Wajahatullah Khan

- Assist in designing and implementation of data marts and data warehousing applications by extracting data from OLTP system to Staging Area using ELT and load the data to the target database by ETL process as per business needs, using postgres and ingres databases. - Creating and testing interactive dashboards, ad-hoc reports, and analytical documents to demonstrate client business. - Create OLAP cubes and XML schemas for data-marts to facilitate top managers with QBE and What-If analysis.

• Managing and development of Data Ware-House. • Analyzing data from multiple sources, simultaneously optimizing statistical efficiency and quality by developing data collection systems and filtering data to remove outliers. • Reporting on Tableau and Power BI. • Migration of data from AWS S3 to Redshift warehouse using AWS Glue. • Created Data Warehouse in Redshift cluster for reporting. • Scheduled and executed SSIS Packages using SQL Server Agent.

• Created Stored Procedures, Triggers, Functions, Indexes, Views, Joins and T-SQL code for applications. • Managed indexes, statistics and optimized queries by using execution plan for tuning the database. • Experience in using multiple data flow transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all.