SUMMARY:

• Over 9 years of IT Experience in Data Warehouse using Informatica Power Center.
• Experienced in Requirement Analysis, Requirement Gathering, Functional Analysis, System Design, Process Flow, Workflow, Use and Test Case Development, Software Development Life Cycle, System Testing, Agile Development, Bug Fixing, Documentation, Implementation, Production Support.
• Maintenance and Integration of various data sources such as Oracle, DB2, MS SQL Server, Fixed Width/Delimited Flat Files, XML and COBOL Sources using Informatica Power Center 9.5/9.1/8.5 on Windows and UNIX.
• Experienced in development of ETL (Extract, Transform and Load) processes with a very good understanding of source to target data mapping, ability to define, capture Metadata and business rules.
• Experienced in Star - Schema and Snow-Flake Data Modeling, Normalization, Data Cleansing, Logical and Physical Data Model, Fact and Dimensional Data modeling using ERwin.
• Extensively worked on Slowly Changing Dimensions TYPE1 and TYPE2.
• Designed Mappings using B2B Data Transformation Studio.
• Sound knowledge of RDBMS concepts, with hands on experience in the development of relational database environment using SQL, PL/SQL, DB2, Stored Procedures, Packages and UNIX Shell Scripting.
• Involved in analyzing different modules offacetssystem and EDI interfaces to understand the source system and source data.
• Worked exclusively on Informatica Data Quality(IDQ) for data quality and data profiling, applying rules and develop mapping to move data from target system
• Created dictionaries using Informatica Data Quality (IDQ) that was used to cleanse and standardized Data. Worked with Informatica and other consultants to develop IDQ plans to identify possible data issues.
• Experienced in Master data Management (MDM), MDM Hub configurations, data modeling, Data mapping, creating source tables and target tables and data profiling
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions
• Experience in installation and configuration of core informatica MDM Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match server and Cleanse adapter in Windows.
• Experienced with Teradata utilities Fastload, Multiload, BTEQ scripting, fastexport SQL assistant
• Experienced in developing complex business rules through Informatica transformations, Workflows/Worklets, Mappings/Mapplets, Test Plans, Test Strategies and Test Cases for Data Warehousing Projects.
• Experienced in Data validation / Data Quality analysts,
• Experienced in job scheduling using Control-M and IBM Tivoli Workload Scheduler(TWS) on Windows environments.
• Experienced in Online and Batch Mainframe environments and production supports for both.
• Team player, self-motivated and dynamic with excellent oral and written communication skills.
• Quick learner and adaptive to new environments.

TECHNICAL SKILLS:

Languages: COBOL, JCL, SQL, PL/SQL, C, C++

Scripting: UNIX Shell Scripting

Databases: Oracle 11g/10g/9i, SQL Server, DB2, IMSDB

ETL Tools: Informatica PowerCenter v 9.5/9.1/8.x, Developer 9.0.1 and SSIS

Data Modeling Tools: ERwin Data Modeler 9.2

Other Tools: SQL developer, Universal SQL Editor, TWS, Toad, WinSCP, QC, IBM MQ Series, Control-M and IBM Maestro Tivoli

Operating Systems: UNIX-AIX, Windows 95/98/2000/NT/XP/07/08, MS DOS, MVS, OS/390

Methodologies: Waterfall, Star Schema, Snow Flake Schema, Fact and Dimensional Tables, Physical and Logical Data Modeling

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

Sr. DWH Consultant

Environment: Informatica PowerCenter 9.5.1, Oracle 12g/11i, DB2, Flat Files, SQL, Shell Scripting, TWS Maestro, WinSCP Universal SQL Developer and SCM.

Responsibilities:

• Analyzed CIM(Customer Information Management) application/system.
• Involved in meetings with business teams to discuss requirements.
• Involved in functional and technical design documents prep meetings.
• Prepared BSTMs(Business Source to Target Mapping definition) as per requirements.
• Developed and unit tested mappings, sessions and workflows with sources like relational tables and flat files.
• Developed relational table definitions, views and written complex override SQLs.
• Implemented CDC, SCD1, SCD2, incremental load, Snapshot and transactional fact tables, headers and footers to flat file and file list.
• Used major components like Serializers, Parsers, Mappers and Streamers in Data Transformation Studio for conversion of XML files to other formats (B2B).
• Developed complex mappings using multiple sources and targets in different databases Oracle, DB2, flat and XML files.
• Worked on data cleansing and standardization using the cleanse functions in Informatica(MDM).
• Involved with Informatica team members in Designing, document and configure the Informatica MDM Hub to support loading, cleaning, matching, merging and publication of MDM data.
• Worked on Mapplet/rules using Informatica data quality (IDQ)
• Experience with utilitiesInformatica Data Quality(IDQ) andInformatica Data Explorer(IDE).
• Used Match and Consolidator transformation in IDQ which helped in reducing the duplicates.
• Created dictionaries using Informatica Data Quality (IDQ) that was used to cleanse and standardized Data. Worked with Informatica and other consultants to develop IDQ plans to identify possible data issues.
• Extensively used IDQ which helped in debugging and also reducing development time. involved in code promotion to SIT and Production using SCM code management tool.
• Worked on Informatica Power Exchange 9.1 for reading VSAM/COBOL sources.
• Worked on Agile Methodology for this project with multiple sprints.
• Developed complex Unix scripts to Copy, Move and process different files.
• Developed Maestro Schedules and Jobs for running Unix, Informatica and Db2 load jobs in different environments like DEV, SIT and Production.
• Exclusively worked on code debugging using Informatica debugger for complex mappings.
• Prepared code promotion documentation and ICEM packages for production deployment.
• Involved in monitoring and supporting production jobs.
• Conducted and involved in defect triage meetings on daily and weekly basis.
• Resolved priority one(P1), priority two(P2) and priority three(P3) defects.
• Worked on HP ALM to update the status of ongoing defects and comments.
• Prepared project documents like Recovery specifications, Project Change Request Form(PCRF) and Promotion Worksheet.

Confidential, Farmington Hills, MI

Sr. DWH Consultant

Environment: Informatica PowerCenter 9.5.1, Oracle 11g, Flat Files, XML Files, TOAD, SQL, PL/SQL, Shell Scripting, BMC Control-M, Teradata, Oracle Golden Gate, WinSCP and SQL Developer

Responsibilities:

• Analyzed existing Legacy ODS for migration into new environment.
• Evaluated client’s new design changes and suggested few corrections for better quality and performance.
• Ledand coordinated offshore team and provided clarifications.
• Identified and extracted data from varied sources, applied business rules and loaded them to target Data Marts using Informatica Power Center 9.1 ETL solution environment.
• Used Informatica to extract data from DB2, HL7, XML and Flat files to load the data into the Teradata
• Used the Teradata fast load/Multiload utilitiesto load data into tables
• Developed Complex Mappings in Informatica using Power Center transformations (Source Qualifier, Joiner, Lookups, Filter, Router, Aggregator, Expression, XML and Sequence Generator Transformations), Mapping Parameters/Variables, Parameter Files, SQL Overrides and Transformation Language.
• Designed and developed Technical and Business Data Quality rules in IDQ (Informatica Developer) and created the Score Card to present it to the Business users for a trending analysis (Informatica Analyst)
• Worked on IDQ/IDE tools for data profiling, data enrichment and standardization.
• Tuned performance of Outbound ETL. Performed CDC based on MDM last update date, which is indexed and maintained by MDM. Used the parameterization template mapping/session for each base object, and had that as first task in the Workflow.
• Developed Shell Scripts for file copy and database table purge etc.
• Data Quality checks for source files using Control Frame Work (CFW) and Mapplets.
• Designed and developed stored procedures for table truncation before loading.
• Implemented CDC, SCD1, SCD2, SCD4 dimension tables, incremental load, Snapshot and transactional fact tables, headers and footers to Flat File and File List.
• Scheduled the workflows to run on a daily, weekly and monthly basis using Control-M Scheduling Tool.
• Prepared QA and production implementation documents for multiple releases.
• Involved in Design Pattern discussions for new environment and client meetings.
• Performed unit testing for developed ETL mappings before deploying to QA.
• Interacted with database DBAs and Informatica Admin’s and conducted business meetings for implementation.
• Documented mapping specifications, STM, unit test cases, procedure and results.

Confidential, Kalamazoo, MI

DWH Consultant

Environment: Informatica PowerCenter 9.5/9.1, Oracle 11g, Flat Files, COBOL Files, ERwin, Control-M, SQL, PL/SQL, Shell Scripting

Responsibilities:

• Worked with stakeholders regarding business requirements, functional specifications and enhancements, based on the business needs created technical design and functional specification documents.
• Actively participated in weekly calls with data modeling and analyst teams to understand and work on any new requirements.
• Analyzed data from source systems to design the solution for the business requirement.
• Developed complex mappings in Informatica using Power Center transformations (Source Qualifier, Joiner, Lookups, Filter, Router, Aggregator, Expression, XML Update and Sequence Generator Transformations), Mapping Parameters/Variables, Parameter files, SQL overrides and Transformation Language.Data profiling the source files and developing data model and mappings for smaller requirements.
• Implemented CDC, SCD2, SCD1 Delta load, Snapshot and transactional fact tables, headers and footers to Flat File and File List.
• Established the rules for certifying the quality of data during development in IDQ
• Created several session and workflows in IDQ which we deployed in Power Center
• Developed Unix Scripts for SFTP file transfers and target table truncate operations.
• Implemented partitioning at database level for better performance.
• Scheduled the workflows to run on a daily and weekly basis using Control-M Scheduling Tool.
• Provided support to the QA team for various testing phases of ETL development.
• Involved in unit tests and unit test plan document preparation.
• Documented mapping specifications, STM, Unit Test Cases, procedure and results.
• Implemented Push Down Optimization(PDO) for better performance when source data is huge.

Confidential

DWH Developer

Environment: Informatica PowerCenter 9.1/8.x, Flat files, COBOL files, Oracle 11gR2, PL/SQL, ERwin,TOAD, UNIX, SQL * Loader, PL/SQL, MS SQL Server 2008, Control-M, Crystal Reports

Responsibilities:

• Analyzed data in source systems for solution design document of the business requirement.
• Designed functional documents and Technical design documents according to business needs for ODS.
• Prepared DDLs for creating new tables and adding new metadata columns as per the design specification.
• Implemented database partitioning by HASH and RANGE.
• Extensively worked with Data Analyst and Data Modeler to design and to understand the structures of Fact and Dimension tables.Data profiling and data quality checks using Informatica Data Quality(IDQ).
• Exclusively worked on Unix shell scripting for various operations on files.
• Created data quality transformations using IDQ for data quality checks and data conversions.
• Prepared source to target mapping documents for the new mappings developed and updated existing.
• Developed complex Mappings using Informatica transformations and developed Reusable Transformations and Mapplets to load OLTP data into OLAP system by using multiple mappings.
• Determined bottlenecks at various points like Targets, Sources, Mappings, Sessions and Optimized the Performance which led to better session performance and achieving high response time.
• Created target tables in Oracle and Workflows in Informatica to populate the data according to requirements.
• Scheduled the Workflows to run on a daily and weekly basis using Control-M scheduling tool.
• Performed system integration testing (SIT) and was involved in User Acceptance Testing (UAT) to ensure business and technical requirements are met and documented the results.
• Involved in the documentation of Source to Target mapping, mapping design and implementation steps.