Mzhar Ali

Skills: Snowflake · Apache Airflow · PostgreSQL · Python (Programming Language) . Data Warehousing . Data Quality . Data Analytics . Data Integration . AWS

->Hadoop administration and T-sql Scripts automation in ETL and BI & DWH solution development and deployment of new releases whilst managing workloads and ensure dependencies of jobs. ->Perform daily/weekly/monthly reconciliations to reduce any gaps Monthly reporting. ->Shell Scripting and monitoring Fixing and ensuring resumption of batch jobs.

I was responsible for Designing BI Reports Solution and maintaining ETL scripts and packages and writing test cases algorithm with the ability to perform automated testing to get a deeper understanding of the software. Fraud detection in Health Insurance system SQL business logic development (Visio based algorithm structure to stored procedure conversion).

Production Support/Database Query Optimization and Production Support/Adhoc Reporting/ and Day-to-day Database Administration/Tuning/Performance maintenance/ Database Releases Testing Pre-Production and Production Support. ETL and Advance T-SQL Programming and Script writing, Complex DB SP Writing Function Writing, Database migration. DWH development and Business intelligence Dashboard maintenance/Reports Designing/Analyzing/Deploying

Database Production Support/Adhoc Reporting/ and Day-to-day Database Administration/Tuning/Performance maintenance/ Database Releases Testing Pre-Production Reporting Manager maintenance/administration and Advance Complex T-Sql Programming Script writing/Troubleshooting BI Dashboard maintenance/Reports Designing/Analyzing Database administration and database partitioning and Maintenance/Troubleshooting

Planning/Analyzing, design and development of Data Warehouse/BI Solution Worked independently to provide for data transformation, testing, solving problems, and end-to-end customer support needs and Database Business Reports Designing/Developments/Maintenance/ Implementation and daily request executing Business intelligence Dashboard maintenance/Reports Designing/Analyzing ETL and Complex T-Sql Script writing/Troubleshooting

Planning, Designing and development of HRMIS (Human Resource Information Management System), Business intelligence Dashboard maintenance/Reports Designing/Analyzing

Data warehouse project documentation Teradata ETL Script writing/Troubleshooting Data warehouse Testing

Database Management/DWH Development and Data Analytics Object Oriented Programming Software Engineering