Azure Data Architect
Resume:
ASADULLAH MUZAFFAR
Data Architect
US Citizen
********@*****.***
EXECUTIVE SUMMARY
** ***** ** ****** **** Integration experience in development, leadership, and management
Data Warehousing experience in data analysis, architect, development and implementing software solutions in various business applications using ETL tools Informatica PowerCenter, Informatica Intelligent Cloud Services
(IICS), and Azure Data Factory
Strong experience of Informatica cloud IICS services like Cloud Application Integration, Cloud Data Integration, Cloud Data Quality, Mass ingestion, API Manager, API Portal, Administrator, Monitor, Application Integration Console, Data Synchronization, Data Replication
Ability to define and design the best architecture to install Informatica Intelligent Cloud Services (IICS) Secure Agent components and subsystems for a multi-server platform capable of scaling with growing number of components and applications.
Proven ability to architect and build high volume, mission critical cloud native applications.
Demonstrated success in building RESTful API Integration using IICS
Certified Azure Data Engineer, good hands-on experience on Azure Data Factory and Synapse Analytics
Experience with Azure architecture decision making Architect and implement ETL and data movement solutions using Azure Data Factory
Hands on experience on ADF Author, Monitor and Manage windows, developed pipelines by using activities
(Iterations & Conditions) like copy data, If Conditions, For Each, Lookup, Store Procedures etc.
Using ADF, extracted data from sources system using https, JSON files, Relational Databases and loaded on Azure Data Lake blob storage in the form of Parquet or csv files. Using In line dataset type ‘DELTA’ loaded data into Data Lake which maintains history of data and provides analysis on time travel of
Using ADF, extracted data from sources system using https, JSON files, Parquet files and loaded on Azure Data Lake and then using Azure Databricks Frame processed data and loaded in Azure SQL
Good Understanding of Structured and Unstructured data
Experience in Database Design, Entity-Relationship modeling, Dimensional modeling like Star-schema, Snowflake- schema, Fact and Dimension tables
Very good experience in various types of Data Analysis like HR, Health Care, Pharma, Procurement, Sales and Financial
Implemented and contributed to Data Governance activities as a Data Architect
Strong Analytical skills, a positive attitude, and the ability to thrive in a fast-paced environment
Ability to think intuitively and creatively about how data is managed and how it applies to solve business problems
Good understanding of Data Lineage
Informatica Power Exchange real-time Change Data Capture expert from the development and admin both perspectives
Closely worked with business and BI teams to provide best Business Intelligence reporting solutions
Very good knowledge on Analytical/Business Intelligence tools
Extensively worked on Data Integration with various components of the Informatica PowerCenter – Power Center Designer (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer), Repository Manager, Workflow Manager, and Workflow Monitor to create mappings for the extraction of data from various source systems
Experience in implementing complex business rules by creating Informatica re-usable transformations, and robust mappings/mapplets using different transformations like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure, Normalizer etc.
Experienced in Informatica PowerCenter admin activities, Admin Console management, applying EBFs and Hot fixes, and Informatica version upgrades
Proficient in full life cycle development of Data Warehousing, ETL strategies, reporting and hands on experience in Performance Tuning of sources, targets, transformations, mappings, and sessions using Database Tuning, Partitioning, Index Usage, Aggregate Tables, Session partitioning, Load strategies, commit intervals and transformation tuning
Extensive experience in integrating data from various Heterogeneous sources like Relational database (Oracle, SQL Server, Teradata, DB2), Flat Files (Fixed Width and Delimited), COBOL files, XML Files and Excel files into Data Warehouse and Data Mart
Worked with Slowly Changing Dimensions type 1 and type 2
Experience in Oracle PL/SQL Programming (Stored procedures, Triggers, Functions, Packages) and UNIX shell scripting to perform job scheduling
Experience in various RDBMS systems Microsoft SQL Server (TSQL), including DDL creation, views, complex SQL constructs, stored procedures, indexing, Partitioning techniques.
Good experience in documenting process flows for better maintenance and analyzing the data flow
Demonstrated ability to take initiatives, grasp and expand on ideas, tackle and follow through difficult assignments in the fast-pace and changing environment
Independent yet team oriented with excellent analytical, problem solving, multi-tasking, oral and written communication skills
EDUCATION AND MAJOR TRAININGS
MBA Finance from University of Central Punjab in May 2011
Bachelor’s in commerce from University of Punjab in April 2006
Certified Azure Data Engineer
SKILLS
ETL TECHNOLOGY Informatica Power Center 10.5/10.2.2/10.1.0/9.6/9.1/8.6/8.1/7.1/6.1 IICS (Informatica Intelligent Cloud Services)
DATA GOVERNANCE Tool Informatica Axon, EDC, Erwin
CDC TEHNOLOGY Informatica Power Exchange 10.2.0/10.1.0/9.0/8.6 DATA WAREHOUSE Multidimensional Model Design, Star Schema Development CLOUD Microsoft Azure
DATA MODELLING Star-Schema Modeling, Snowflake Modeling DATABASES Oracle 19C/12.2/12.1/11g/10g/9i, Microsoft SQL Server7.0/2000, DB2(iSeries/AS400), MS Access
PROGRAMMING SQL, PL/SQL, UNIX Scripting, Python
OPERATING SYSTEMS Windows, MAC, UNIX, MS-DOS
OTHER TOOLS Autosys, Atomic/UC4, Start, Ticket Plus, Service Now/Dash, Toad, SQL Developer, iNavigator, Putty, SQL Server 2014 Management Studio, FileZilla, Azure Portal, ServiceNow, Jira
PROFESSIONAL EXPERIENCE
Client: MGM Resorts Sep’2022 – Feb’2023
Employer: Cognizant
Las Vegas, NV
Data Architect
Worked as ETL team lead to provide expertise in Data Validation Framework process
Worked closely with businesspeople to gather requirements of Business Rules to add in Data Validation framework
Worked with Development team to provided them required functional and technical information for the development of Framework
Analyzed Business and Technical requirements and designed enhanced ETL Processes to meet the business requirements
Drove decision making, risk management and issue resolution
On-boarded many businesses applications, ERP system and HCM system to add in Data Validation Framework
Created and managed Jira tickets and collected status from team during daily standup meetings and reported same to leadership
Using Azure data Factory created pipelines and Data flows for Data Validation framework
Created Databricks Notebooks to apply data validation rules and processing the source data. Used Python and SQL languages in Databricks notebooks
Developed Informatica Power Center mappings for loading SAP data into Oracle multiple layers: Staging, Central Rep and Datamart
Environment: Azure Data Lake, Azure Data Factory, Databricks, Azure Synapse, Microsoft SQL Server, Jira, Informatica PowerCenter 10.5
Client: Travel and Leisure Jan’2022 – Aug’2022
Employer: Cognizant
Orlando, FL
Data Engineer/Data Architect
Worked as ETL team lead to provide expertise in Data Conversion and ETL development Project Genesis
Using Informatica PowerCenter worked on Data migration from legacy systems to OFSLL (Oracle Financial Service Lending and Leasing)
Developed Informatica mappings to build DataMart Loan and DataMart Dues to load OFSLL data into Data warehouse
Analyzed and communicated ETL development issues, including problems with data integrity, data design, and functional and technical issues
Extracting and transforming data from various relational databases and flat files to OFSLL and developed Informatica mappings to loads source OFSLL data into Datawarehouse layers (LZ, CDR and FDM)
Analyzed Business and Technical requirements and designed enhanced ETL Processes to meet that requirements
Hands-on Experience in working with Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets to extract, transform and load data
Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables
Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions, or system which led to better session performance
Created stored procedures for generating the data warehouse cycle dates and to drop, re-create the indexes
Worked with various Active and Passive transformations like Source Qualifier, Sorter, Aggregator, Filter, Union, and Router Transformations, Sequence Generator and Update Strategy Transformations
Handled versioning and dependencies in Informatica
Developed Test Cases according to Business and Technical Requirements and prepared SQL scripts to test data for both Unit testing and UAT testing
Environment: Informatica Power Center 10.5, SQL Server 2005/2000 Oracle 19C, Microsoft SQL Server, Jira KBR Inc. Sep’18 – Jan’2022
Houston, TX
Role: Data Architect/Data Engineer
Managed and provided technical leadership to Data Integration and ODS (Operational Data Store) developers
Designed architecture of critical interfaces to maintain the data accuracy
Provided technical lead and designed architecture of many interfaces which includes many major projects but not limited to:
Costpoint Implementation:
SAP to Costpoint data conversion
Supply Chain Interfaces between Costpoint and Maximo Hire to Retire Interfaces
Workday Implementation:
SAP to Workday data conversion
Workday interfaces to pull data down to ODS and send to downstream application/systems Sending Active Directory and Other ids data to Workday Dash On-boarding automation
SAP Financial Data Integration
Implemented and led Data Governance activities across the organization
Worked on Data Governance of KBR different data domains as Data Architect. Wrote Data Governance White Paper, Introduced Data Governance Framework and Data Governance Office. Built Data Catalog and Business Glossary, Data Dictionary, worked very closely with Data Owners and Data Stewards to clarify roles and responsibilities and define Data Standards and procedures. Established Data Journey and Data Lineage for better understanding of Data Flow across the systems and applications. Worked very closely with Data Quality Analysts. Published Data Quality scorecard on Data Governance tool “Informatica Axon” and gave access to businesspeople for Data Democratization. Helped Business users to provide ease of Data Provisioning process. Worked very closely with security team to govern data by implementing data security policy to protect employees PII and customers data, intellectual property and other sensitive. In Business Glossary created GDPR and other policies to associate with business terms. Using Data Governance tool, applied Azure Data Protection policy to business documents
Mentor and manage team members, including career development and performance management
Facilitate the Agile development process and help team members remove roadblocks
Worked with different data owners, Businesspeople, and Business Intelligence teams to understand their requirements and provided them best Datawarehouse solutions for Analytical and send data out to various applications and external vendors
Using Azure Data Factory extracted data from SAAS applications and loaded in to Data Lake and then processed using Azure Databricks. Very good knowledger of using Python and SQL in Databricks.
Drove decision making, risk management and issue resolution
Maintained awareness of new applications, technical methods, trends, and advances in the profession
Track details, prioritize tasks, and meet deadlines of multiple projects with varying completion dates
Managed resource planning and distribution of workload
Ability to work with raw data from many different formats and transform it to be useful for end users
Responsible for Informatica Codes Review, unit testing and process Documentation Review
Data Cleansing, Masking, Validation in the Landing/Staging Area
Analyzed and communicated ETL development issues, including problems with data integrity, data design, and functional and technical issues
Developed ETL Batch and Realtime integration data pipelines using IICS
Built IICS components like mappings, mapplets, mapping tasks, taskflows, Business services, Data Replication, Data synchronization tasks, file listener, Business Services, Hierarchical schema etc.
Using IICS data was ingested from Clous based applications like Workday and Salesforce
Created IICS Data replication tasks to replicate Salesforce objects into Oracle tables
Developed and Tested IICS/Informatica PowerCenter mappings to load data into various dimensions and fact tables from various source systems.
Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems.
Implemented slowly changing dimensions (SCD) - type I & II in different mappings as per the requirements and performed target load order in multiple target instances.
Responsible for testing different versions of Informatica and resolving the issues identified in the new version with the Informatica Support Team.
Responsible for deploying the code from Dev to Prod. Responsible for creating folders and giving privileges to the new users.
Formatted the data in a specific format and loaded it to the target flat files.
Performed ETL (extract, transform, and load) duties to include requirements validation, code development, source control, unit testing, and version deployment scripting.
Developed program specifications/detail design documents.
Coded, tested, and debug application programs. Participated in the application design of systems, including use of analytical techniques.
Created Informatica mappings with PL/SQL Procedures/Functions to build business rules to load data.
Performance turning was done on various Informatica mappings to reduce the execution time.
Production support was done on a weekly routine basis.
Analyzed and tested operational problems to determine presence and scope of potential code defects.
After the loading was complete balance scripts were developed to make sure that the number of rows read from the source agreed with the number of rows loaded in the target. This validation was done to check for the total counts and for the data in all the fields.
Worked extensively on various reusable transformations, mapplets and transformations such as lookup, joiner, expression, sorter, router, update strategy, aggregate, union etc.
Extensively used FTP Pro to transfer files to and from FTP sites.
Analyzed Business and Technical requirements and designed enhanced ETL Processes to meet that requirement
Hands-on Experience in working with Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets to extract, transform and load data
Developed and supported PLSQL Stored procedures, Triggers, Functions and Packages for processing the data in EDW
Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables
Developed Test Cases according to Business and Technical Requirements and prepared SQL scripts to test data for both Unit testing and UAT testing
Resolved technical and design issues
Managed databases, application like Informatica and PGP upgrades Environment: Informatica Power Center 10.2.2, SQL Server 2005/2000 Oracle 12g, Atomic/UC4 schedule, Start, Ticket Plus, ServiceNow/Dash, PGP version 10.5, Informatica Axon, EDC Client: Healthfirst, NYC, NY June’18 – Sep’18
Employer: Knowledgent Inc., Part of Accenture
Role: Data Integration Lead/CDC Architect and Admin Responsibilities:
Worked with Informatica Engineers and Informatica Professional Support for implementation of Informatica Power Exchange CDC for sources DB2, Oracle and SQL Server
Worked on Informatica Power Exchange configurations of dbmover.cfg, pwxccl.cfg, pwxorad.cfg and CDCT report
Trained the team to work on Power Exchange CDC and transition of knowledge of restart tokens
Designed the architect for CDC in AWS and Big Data Hadoop environment
Worked on designing the technical documents
Worked closely to resolve the development issues related to CDC
Created Power Exchange registrations and extractions maps for SQL Server, Oracle and DB2 sources
Created Data Maps registrations
Developed Informatica Power Center mappings using Power Exchange Application as source and AWS S3 as target
Worked on Informatica Power Center mappings and sessions to tune them to get best performance in CDC environment
Enabled Informatica recovery to restart the session from last checkpoint to avoid duplications in the target
Used Informatica Power Center Transformation Flexible Target Key Transformation to manage the scenario where PK itself updated in source system
Created scripts to generate the registrations and extraction maps using Power Exchange utility DTLUCBRG
Very good knowledge on Power Exchange components listener and logger restart (cold start, warm start, special restart)
Created registration and extraction maps migration scripts using Power Exchange utility DTLURDMO
Created Power Exchange CDC troubleshooting documents for DBA of SQL Server, Oracle and DB2
Created troubleshooting documents for Informatica team Client: KBR Inc., Houston TX Sep’15 – June’18
Employer: HCL
Role: Lead Application Developer
Responsibilities:
Contributed as a member of the Operational Data Store (ODS) responsible for design, development and implementation of interfaces and conversions for different kind of data (HR, Accounting, Procurement)
Provided technical leadership to the Data Integration team
Worked on various projects that included but not limited to: 1. Architecture of DataMart for various subject areas – HR, Procurement 2. KBR-Wyle Integration
Worked with Business Intelligence team for data conversions and building the DataMart as per the requirements
Worked on designing the technical documents
Responsible for Codes Review, unit testing and process Documentation Review
Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements
Data Cleansing, Masking, Validation in the Landing/Staging Area
Part of Production Support Team and Monitored systems and processes to ensure seamless loading of data in time
Analyzed and communicated ETL development issues, including problems with data integrity, data design, and functional and technical issues
Extracting and transforming data from various relational databases, ERP systems and flat files to the data warehouse
Analyzed Business and Technical requirements and designed enhanced ETL Processes to meet that requirement
Hands-on Experience in working with Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets to extract, transform and load data
Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables
Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions, or system which led to better session performance
Used Informatica Power Center 9.6 for migrating data from various OLTP servers/databases to the data mart
Created stored procedures for generating the data warehouse cycle dates and to drop, re-create the indexes
Worked with various Active and Passive transformations like Source Qualifier, Sorter, Aggregator, Filter, Union, and Router Transformations, Sequence Generator and Update Strategy Transformations
Handled versioning and dependencies in Informatica
Developed Test Cases according to Business and Technical Requirements and prepared SQL scripts to test data for both Unit testing and UAT testing
Developed schedules to automate the update processes and Informatica sessions and batches
Resolving technical and design issues
Discussed with customers and technical support on Data Migration and Data warehousing
Developed standards and procedures to support quality development and testing of data warehouse processes
Deployment of ETL and databases codes across environments
Led the team of engineers that developed, maintained, and supported the Operational Data Store and the Enterprise Data warehouse that included over 3000 nightly jobs and supported over 60 Business Applications
Trained the engineers for the team and mentored them in areas of expertise, such as solution and information architecture and data modeling
In Automic/UC4 scheduler created informatica jobs using pmcmd command, FTP jobs, job plans, variables, events, call objects and scheduled the jobs, created loop jobs to loop the Informatica workflows and process the flat files in loop
Environment: Informatica Power Center 9.6, SQL Server 2005/2000 Oracle 11g, Atomic/UC4 schedule, Start, Ticket Plus, ServiceNow/Dash
Premier Inc. June’14 – Aug’15
Charlotte, NC
Role: Sr. ETL Developer
Responsibilities:
Contributed as a member of the Data Management Group (DMG) responsible for design, development, and implementation of interfaces and conversions (Member, Member Eligibility, Claims, Pharmacy, Providers, and Prior Authorization) for Medicaid Management Information System clients
Developed and Tested Informatica mappings to load data into various dimensions and fact tables from various source systems
Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems
Implemented slowly changing dimensions (SCD) - type I & II in different mappings as per the requirements and performed target load order in multiple target instances
Responsible for testing different versions of Informatica and resolving the issues identified in the new version with the Informatica Support Team.
Responsible for deploying the code from Dev to Prod. Responsible for creating folders and giving privileges to the new users
Formatted the data in a specific format and loaded it to the target flat files
Wrote Windows batch scripts to automate the batches
Performed ETL (extract, transform, and load) duties to include requirements validation, code development, source control, unit testing, and version deployment scripting
Developed program specifications/detail design documents
Coded, tested, and debug application programs. Participated in the application design of systems, including use of analytical techniques
Created Informatica mappings with PL/SQL Procedures/Functions to build business rules to load data
Performance turning was done on various Informatica mappings to reduce the execution time
Production support was done on a weekly routine basis
Analyzed and tested operational problems to determine presence and scope of potential code defects
After the loading was complete balancing scripts were developed to make sure that the number of rows read from the source agreed with the number of rows loaded in the target. This validation was done to check for the total counts and for the data in all the fields
Worked extensively on various reusable transformations, mapplets and transformations such as lookup, joiner, expression, sorter, router, update strategy, aggregate, union etc.
Extensively used FTP Pro to transfer files to and from FTP sites Environment: Informatica Power Center 9.1, Server Grid/HA, Informatica Power Exchange 9.1, SQL Server 2005/2000, Oracle 11g, DB2, PL/SQL, Unix Shell Scripting, Windows 2007, DB2 Anonymous Resolution, FTP Pro 8.7, Team Foundation Server, TIDAL, Teradata 13.
Actavis, Inc.
Jersey City/Parsippany, NJ Jan’13- May’14
Role: Sr. ETL Developer
Responsibilities:
Worked with business analyst for requirement gathering, business analysis, and testing and project- coordination
Created Detail Design Documents which have the ETL technical specifications for the given functionality, overall process flow for each particular process, Flow diagrams, Mapping spreadsheets, issues, assumptions, configurations, Informatica code details, shell scripts etc. Conducted meetings with the business to review the documents and get approval of the process
Analyzed the mapping logic to determine the reusability of the codes
Handled versioning and dependencies in Informatica
Developed complex Informatica mappings using various transformations- Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation
Extensively used SCD’s (Slowly Changing Dimension) to handle the Incremental Loading for Dimension tables, Fact tables
Configured Informatica Power Exchange connection and navigator
Created Registration, Data Map, configured Real-Time mapping and workflows for real-time data processing using CDC option of Informatica Power Exchange
Wrote Script to load multiple tables and used MLOAD utility
Used Debugger utility of the Designer tool to check the errors in the mapping and made appropriate changes in the mappings to generate the required results
Performing ETL & database code migrations across environments
Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions, or system. This led to better session performance.
Created and maintained the Shell Scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments
Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test, Regression test & supported the UAT for the client Environment: Informatica Power Center 9.0, Informatica Power Exchange 9.0, Toad, UNIX Shell Scripting, SQL Server 2008, Teradata 13, Mercury Quality Center, Autosys, Linux. Client: Abbott Laboratories Jan’07-Dec’12
Karachi, Pakistan
Role: ETL Developer
Responsibilities:
Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems
Designed, Developed and Tested Informatica mappings for populating the data into the dimension, facts, and history tables constantly from different source systems
Recommended, designed, and implemented strategies for managing the data in data warehouse.
Acted as a liaison with internal and external customers to research, analyze and propose solutions to technical, operational and use cases
Analyzed requirements and specifications for complex processing to verify that current and future business requirements are met and obtained relevant test data. Designed, coded, and reviewed accurate and thorough test material (Test Plan and Test Cases) with pre-determined results within specified scheduled dates
Created copies for the non-production environments by masking the data to make sure test and development processes are not exposing sensitive information
Performance tuning was done for various facts and dimension mappings to reduce the ETL load time
Involved in developing ETL mappings to load data from Flat files into the target Oracle / SQL Server database by applying business logic on transformation mapping for inserting and updating records when loaded
Worked closely with executive sponsors and decision makers to develop the transformation logic to be used in Informatica
Designed the source to target mappings that contain the business rules for the server during the extract, transform and load process using Informatica ETL Tool
Created reusable transformations and used them in different mappings
Formatted the data in a specific format and loaded it to the target flat files
Wrote Windows batch scripts to automate the batches
Developed ETL Scripts for processing and transferring of raw data from the legacy systems into the warehouse every week
Created post-session and pre-session scripts and mail-notifications
Creating/Maintaining/Modifying Informatica ETL mappings that transfers data from sources to the data warehouse
Performed tuning of SQL queries for faster extraction of data
Upgraded various DTS packages into SSIS.
Worked on Teradata utilities BTEQ, MLOAD and TPUMP and tuned SQL
Created various SSIS packages and responsible for integrating child package into the framework and creating configurations to move data from Dev to Test and then to Prod Environment: Informatica Power Center 9.1,8.6, Informatica Power Exchange 9.1,8.6, PL/SQL, Oracle 11g, SQL Server 2005, DB2 Mainframe, Unix Shell Scripting, Teradata 13, Windows 2003.
Contact this candidate