Awais Hussain

• Designed, developed, implemented, and maintained ETL packages with different data sources (CMEP MV90, Flat Files, JSON, and XML) and loaded the data into the Data Warehouse using SQL Server Integration Services Packages , PowerShell – Bulk Copy Insert. Used different transformations like Surrogate Keys, Lookups, Derived Column, Merge Join, Fuzzy Lookup, Loops, Conditional Split, Union all, Script component, etc. • Successfully upgraded, streamlined, and optimized existing bulk load jobs from on-premises environments like SSIS Packages to Azure Data Factory pipelines and automated Job runs and deployments and Azure DevOps. • Engineered metadata extraction from SQL Server Dynamic management views (DMVs) and dynamic management functions (DMFs) to ensure comprehensive tracking of data usage and access patterns, contributing to a more secure and compliant data environment.

• Worked closely with business stakeholders to gather and analyze requirements, translating them into effective data models and visualization solutions that supported data-driven decision-making and business growth • Successfully streamlined and optimized existing bulk load jobs, significantly increasing performance. Advanced techniques such as query optimization, indexing, and partitioning reduced the time required to process large datasets from 10+ hours to under 2 hours, representing a 10x performance improvement. This was accomplished using close collaboration with the DBA team to ensure maximum efficiency and minimal downtime • Engaged in the development of complex SQL queries using advanced techniques such as Dynamic SQL, Transaction Handling, CTEs, Pivot Tables, Window Functions, Stored Procedures, Functions, Views, SQL Server Agent Jobs, and OPENQUERY. These techniques helped enhance the SQL Server’s performance and provided efficient data management solutions for the business • Created solutions for security related applications. SSIS packages to extract metadata for Web based Access Review Apps using .NET, C# , SQL Server Management Studio, SQL Server Data Tools, and Visual Studio 2019

Worked as SQL Server 2005/2008 and Reports Developer in The Marketing Store. My responsibilities were as follows: • Served as Lead in development , testing and implementation of pdf pricing guides storage system in database before transmitting these to an Electronic Database Management System (EDMS) using SOAP Web Services, C# and ASP .NET • Created solutions for security related applications. SSIS packages to extract metadata for Web based Access Review Apps using .NET, C# , classic ASP, SQL Server Management Studio, SQL Server Data Tools, and Visual Studio 2019

Worked closely with teams monitoring production servers and helped them identify and solve problems related to database, application, and web servers • Assisted in the development and upkeep of data warehouses aimed at consolidating and storing historical banking data.