We provide IT Staff Augmentation Services!

Principal Consultant Resume

PROFESSIONAL SUMMARY:

  • Certified Scrum Master with 11 years of experience in Data Management and Business Intelligence in HealthCare, Mortgage, Finance and Retail verticals
  • 11 years of experience in designing and developing data integration applications, primarily using Informatica Power Center Suite, Oracle and Teradata applications
  • 3 years of experience in building BI applications using Oracle, SSRS, OBIEE Suite, Cognos, Microstrategy and Power BI.
  • Hands - on expertise in SDLC involving Business Analysis, Design, Development, QA, Documentation, Knowledge Transfer and Production Support.
  • Strong knowledge in ER Modeling, Dimensional Modeling (Star Schema, Snowflake Schema) and Data Warehousing methodologies (Kimball and Inmon).
  • Experience in integration of various data sources - Oracle, Teradata, SalesForce, SQL Server, Sybase, DB2, MS Access, Flat files, XML and COBOL files.
  • Experience in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
  • An efficient team leader and team player with multi-tasking and mentoring other team members.

TECHNICAL SKILLS:

Operating Systems: LINUX, IBM Mainframe, Windows

Data Management and BI Tools: Informatica PowerCenter Suite 10.1.1/9.6/9.5 , Informatica Power Exchange, Informatica Analyst, SalesForce, OBIEE, SQL Server Integration Services, SQL Server Reporting Services, Power BI, Microstrategy, Talend, Informatica Data Quality, Informatica Test Data Manager, Master Data Management, T-SQL, PL/SQL, FastExport, FastLoad, TPump, BTEQ.

Databases: Oracle 12c/11g, Teradata 15.10.13, SQL Server, Sybase, DB2, MYSQL, MS Access, WRDB

Modeling tools: Erwin r7.2, SQL Developer, ER Studio

Scheduling Tools: AUTOSYS, TIDAL, CONTROL-M, TWS

Testing Management Tools: HP ALM, Quality Center, Clear Case, JIRA, Confluence

Migration Tools: SERENA, DIMENSIONS, SVN, MKS, ENDEVOR

Cloud: AWS(EC2, S3, Direct Connect, VPC, Redshift, SNS)

PROFESSIONAL EXPERIENCE:

Confidential

Principal Consultant

Responsibilities:

  • Coordinated with business analysts to discuss the requirements and built technical specifications.
  • Designed and developed Informatica ETL Interfaces for the COO dashboard.
  • Coordinated with source system analysts over resolution of source data issues and better understanding of source data systems.
  • Coordinated with Testing Team to develop unit, system and integration test cases to detect and resolve development defects.
  • Involved in integration of AWS S3 to on premise data systems.
  • Involved in testing of Informatica upgrade to 10.1.

Environment: Informatica Power Center10.1/ 9.6.1, Oracle,SQL Developer, Rally, SharePoint, Secure CRT, WinSCP,JIRA,Confluence,Python,AWS(S3),SQL Server.

Confidential

Principal Programmer

Responsibilities:

  • Coordinated with business analysts to discuss the requirements and built technical specifications.
  • Developed Requirement Traceability Matrix, Implementation Plans, Version Description documents, Source-Target Map documents and participated in peer reviews.
  • Designed and developed Informatica ETL Interfaces, Mainframe components and Teradata BTEQ scripts to load data into Integrated Data Repository.
  • Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema
  • Developed slowly changed dimensions (SCD) Type 2 for loading data into Dimensions and Facts.
  • Coordinated with Testing Team to develop unit, system and integration test cases to detect and resolve development defects.
  • Involved in migration of legacy mainframe system to AWS Redshift.
  • Involved in upgrade testing of Informatica Power Center software 10.1.1 HF2.
  • Worked closely with the management, Project Managers, technical staff and end users to ensure successful project implementation and deliverables.

Environment: Informatica Power Center 10.1.1, Teradata, Teradata SQL Assistant, Microstrategy, Power BI, ALM, MKS, WRDB, SharePoint, Secure CRT, WinSCP, JIRA, Confluence, Python, AWS(DirectConnect,VPC,Galcier,S3, Redshift, EC2, ELB, Lambda, and SNS).

Senior Informatica Developer

Confidential

Responsibilities:

  • Developed System Design documents, Operations/Maintenance Manual and DPlan documents and participated in Peer Code and Unit Test Reviews.
  • Developed Data Models using Oracle SQL Developer.
  • Designed and developed Informatica ETL Interfaces to load data from Integrated Data Repository (Teradata) to ASC Reporting system (Oracle)
  • Performed the data validations and control checks to ensure the data integrity and consistency.
  • Coordinated with Testing Team to develop unit, system and integration test cases to detect and resolve development defects.
  • Involved in upgrade testing of Informatica Power Center software from 9.1 to 9.5
  • Involved in performance tuning of Informatica objects and database objects using standard Optimization techniques
  • Supported migration of ETL code from development through production environments.

Environment: Informatica Power Center 9.5/9.1, Oracle 11g/10g, Oracle SQL Developer 1.5.5, PLSQL Developer, Teradata, Teradata SQL Assistant, REST API, Webservices, OBIEE, PuTTY, ALM, Autosys, Serena Dimensions, Altova XML SPY, Tortoise SVN, Share Point, SSH-Tectia.

Senior Informatica Developer

Confidential

Responsibilities:

  • Analyzed the business requirement document and created functional requirement document mapping all the business requirements.
  • Designed and Developed ETL mappings to process XML data.
  • Developed end-to-end lineage to present dynamic visual map of all the data flows using Metadata Manger.
  • Automated the load process using UNIX shell scripts.

Environment: Power Center 8.6, Oracle 9i, XML, PL/SQL, UNIX/AIX, Altova XML SPY, Tortoise SVN, Share Point, SSH-Tectia, Cognos 8.3

Senior Informatica Developer

Confidential

Responsibilities:

  • Designed & developed multiple cleanse function and standardization scenarios using Address Doctor.
  • Analyzed the existing PL/SQL package to extract the business logic and requirements for the load. Derived the mappings from the existing system.
  • Responsible for executing, reviewing, and tracking test case scenarios.

Environment: Informatica Power Center 9.5/9.1,Oracle 11g/10g, Oracle SQL Developer, PLSQL Developer, PuTTY, ALM, Altova XML SPY, Tortoise SVN, Share Point, SSH-Tectia.

Senior Informatica Developer

Confidential, McLean, VA

Responsibilities:

  • Discussed business requirement specifications with business analysts and data modelers, in order to convert them into technical requirement specifications.
  • Performed data analysis of source entities to understand source relationships, source data quality, hidden and potential data issues, etc.
  • Coordinated with source system analysts over resolution of source data issues and better understanding of source data systems.
  • Designed and developed Informatica ETL Interfaces to load borrower, property and deal data incrementally from MPS (Sybase) database to Oracle Staging schema and then into the EDM dimension tables.
  • Included error logging mechanism in all ETL Interfaces for further review of any data errors by source teams.
  • Created and documented unit and integration test cases to detect and resolve development defects.

Environment: Informatica Power Center 8.6, Sybase, Oracle 11g, RapidSQL7.6.1, PL/SQL, PuTTY, Clear Case, Clear Quest, Autosys, Oracle SQL Developer

Senior Consultant - Data Integration

Confidential, New York, NY

Responsibilities:

  • Coordinated with source system and data owners over resolution of source data issues and better understanding of source data systems.
  • Performed data profiling and analysis of various objects in SalesForce.com (SFDC) and MS Access database tables for an in-depth understanding of the source entities, attributes, relationships, domains, source data quality, hidden and potential data issues, etc.
  • Developed ETL Specification Design document containing detailed information on ETL processing, mapping/workflow specifications, exception handling process, staging and data warehouse schemas, etc.
  • Designed and developed Informatica ETL Interfaces to load data incrementally from SFDC, MS Access databases and Flat files into Staging schema
  • Designed and developed SSIS packages to load data from Staging schema to Customer Reporting DW dimension tables.
  • Scheduled ETL jobs for the entire DW load process using Informatica scheduler.

Environment: Informatica Power Center 8.6, Salesforce.com, SQL Server 2008, Power Exchange 8.1, ER Studio 8.0, RapidSQL7.6.1, PL/SQL, Atacama Data Profiler, Apex Loader, Control-M.

Confidential, Winston Salem, NC

Senior Informatica Developer

Responsibilities:

  • Developed Detailed Technical Specification and Logical Data mapping documents for all the Informatica Interfaces developed.
  • Developed ETL interfaces to integrate master data from Oracle, SQL Server, and Flat file source systems into Oracle database.
  • Designed and implemented ETL interfaces to generate Order transaction reports for all RJRT product-selling outlets in USA.
  • Developed UNIX scripts to create file lists, transfer and archive source data files for backup and audit purposes.
  • Used TIDAL to schedule the execution of ETL workflows, Confidential scripts and File transfer and archival scripts.
  • Assisted the Production Support Team to ensure smooth execution of the interfaces.
  • Developed Knowledge Management contracts to help knowledge transition of the development activity and documentation to the client.

Environment: Power Center 8.6/7.1.2, Oracle 10g, Teradata, SQL Server, PL/SQL, AIX, DB2, TIDAL,TIBCO, Rapid SQL, AQT, SERENA, CPWerx6.0, Mercury Test Director, Reflection X

Hire Now