Abdul Ahmed

Experience

1. Sr Msbi Ssis Developer

   PNC

   Sep 2018 — Present · Pittsburgh, PA, US

   Met with business users, gathered business requirements and prepared the documentation for requirement analysis. Created centralized data warehouse (ODS) and developed de-normalized structures based on the requirements and to improve the query performance for end users. Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database. Worked with SSAS tabular model (BISM) and created dashboards and reports using power view, power pivot and SSRS. Created database and database objects like tables, stored procedures, views, triggers, rules, defaults user defined data types and functions with T-SQL to facilitate data consistency. Used data quality services (DQS) to cleanse the data, remove duplicates and improve the quality. Created domains in DQS and exported the activity results into SQL tables. Created highly complex SSIS packages using various data transformations like Conditional Splitting, Fuzzy Lookup, Multi-Cast, Column Conversion, Fuzzy Grouping, Script Components and Error Handling. Created and managed Stored Procedures, Indexed Views, User-Defined Functions, Triggers and Database Constraints to meet business requirements and policies. Created custom logging and package configurations to change connection strings and variables dynamically. Used all types of containers in SSIS. Created package deployment utility and deployed packages into various environments. Involved in Unit Testing, SIT, UAT and Data Validations. Created complex queries for database auditing purposes. Involved in migration and conversion of reports from SSRS. Involved in developing Store Procedures, views and other SQL joins and statements as per the requirement.