Khalil Achach

Over the last 15 years, I have developed various Excel programs using Visual Basic for Applications (VBA) and leveraging my expertise in Microsoft Excel reports.

One of my latest projects involved creating a capacity dashboard report to collect approximately 3,000 daily CSV files, each with a size of around 2KB, and extract relevant data from them. The collected data was then combined in a monthly Microsoft Excel file and pushed to the SQL Server for visualization using Tableau. This process led to significant savings in time and human resources, with the time to go from the dashboard to upper management being reduced from over 2 weeks to 2 hours.

The pandemic prompted significant changes in user behavior, and a comprehensive analysis of the new scenario was needed. I played a crucial role in supporting COVID-19 capacity management by conducting an in-depth analysis of peak traffic shifts from night to day and vice versa across various sites and regions.

By analyzing and interpreting this data, I provided valuable insights that informed the senior leadership team and contributed to crucial decision-making processes. The daily reports I generated became an essential tool, saving the company valuable time and resources.

A cloud migration project in which I was the liaison between customers and the senior leadership team, providing all the reports in SQL Server views, Microsoft Excel files, and Tableau.

Because of my role in the project, I spearheaded the whole process comprising two steps. The first step involved using an API to collect raw data and then store it in an Amazon S3 bucket or a cloud database. The second step targeted the conversion of the SQL Server store procedure, and SQL Server Integration Services (SSIS) packages to Databricks using Scala, SQL, and PySpark. This new technology led to significant savings in time and money, with the monthly report that used to take 3 days to be ready then taking only around 4 hours.

The objective was to contribute to PointClickCare's mission of transforming healthcare through technology and collaboration by ensuring the successful migration of databases in accordance with company standards.

MY RESPONSIBILITIES
• Database migration: Executed the migration of databases, adhering strictly to PointClickCare's criteria to ensure data integrity and system compatibility.
• Automation: Developed and implemented automated jobs to streamline the migration process, enhancing efficiency and reducing manual intervention.
• Error debugging: Identified and resolved database errors, including primary key and foreign key constraints, to maintain relational database integrity and prevent data anomalies.
• Collaboration: Worked closely with cross-functional teams to ensure seamless integration of new systems and databases, supporting the company's collaborative approach to technological transformation.