SUMMARY

• Around 15+ Years of IT Experience with over 14 years in Designing, Development and Implementation of Data Warehouses & Data marts with ETL & OLAP Tools using Informatica, Ab - Initio and Business Objects.
• Strong experience in Extraction/Transformation/Loading (ETL) design and implementation includes Requirements gathering and business rules analysis, Source to target mapping design, and also implemented various Performance Tuning techniques.
• Well-versed in SDLC all phases, good understanding of Onsite/Offshore activities, team leadership, mentoring and exposed to driving the translation and construction of a client's complex business problems into innovative technology solutions. Ability to learn very quickly and apply new skills to existing problems.
• Strong skills in data mapping for the Slowly Changing Dimensions - SCD1, SCD2 (Flagging, Time Stamping and Version), and SCD3. Implemented the complex business rules by creating reusable transformations and Mappings / Mapplets.
• Extensive experience in design and development of ETL processes from Teradata, Confidential, SQLServer, DB2, Flat files, Mainframe Files, Excel Spreadsheets and MS Access. Excellent understanding of Star Schema modeling, Snowflake modeling, Fact, Lookup and Dimensions Tables.
• Involved in Dimensional Modeling using Star Schema & Snowflake Schema.
• Strong Experience in both Agile and Waterfall methods and project management tools like Jira.
• Expertise in IBM Banking Data Warehouse model.
• Over 5+ Years of Experience in IBM Mainframe Technology (COBOL, IMS DB, JCL & DB2).
• Extensively worked on Business Intelligence (OLAP) Tools such as Business Objects.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6.1/10.1 (Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Informatica Power Exchange 9.5.1, Informatica Push Down Optimization, Informatica ILM, Informatica Data Quality (IDQ), Ab-Initio (GDE 3.2.6.1, Co>Op 3.2.6.0)

Big Data: Hadoop, Hive

OLAP Tools: Business Objects XI r2, WebIntelligence 6.5

Data Modeling Tool: Erwin

Database: Teradata, Confidential 12c, DB2 8.2, UDB, SQL Server 2012, Netezza, Sybase, MS Access

Languages: SQL, UNIX Shell Script, PL - SQL

SQL Tools: Teradata Sql Assistant, TOAD, SQL Developer, Aqua Data Studio, WinSQL, AQT (Advanced Query Tool), SQL Server Management Studio

Scheduling Tools: Control-M, Autosys

Version Control: Subversion (SVN)

Primavera Applications: Project Integration Framework (PIF), P6, Unifier, OPPM

Management Tools: Jira, MS Office

Mainframe Skills: Cobol, JCL, IMS - DB, VSAM

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr Data Integration Lead

Responsibilities:

• Work with business users and functional team to define the requirements scope for integration interfaces.
• Prepare detailed technical design documents for Data Integration Interfaces.
• Develop Integration Interfaces for P6, Unifier and OPPM applications using Primavera Web Services and API.
• Provide technical guidance to data integration team and Perform Unit tests and System Integration testing.
• Responsible for providing maintenance and support of the Integration Interfaces.

Environment: Project Integration Framework (PIF), P6, Unifier, OPPM, Confidential 12c, SQL Developer, SQL, Primavera Web Services Methods, API, Excel, CSV Files.

Confidential, Jacksonville, FL

Sr ETL Developer

Responsibilities:

• Perform gap analysis between Bullhorn Replication Data Mirror to Cosmos Datawarehouse.
• Developed ETL mappings to integrate data for specialty applications from Bullhorn Replication Data Mirror to existing Cosmos Datawarehouse applying SCD Type 1 to update and SCD Type 2 to keep the history changes using Informatica Power Center 9.6.1/10.1
• Analyze existing ETL mappings and make necessary changes to keep the data integrity of Cosmos Datawarehouse.
• Created design documents for ETL mappings.

Environment: Informatica Power Center 9.6.1/10.1, Confidential 12c, SQL, SQL Server 2012, SQL Developer, SQL Server Management Studio.

Confidential, Dallas, TX

Sr ETL Designer/Developer

Responsibilities:

• Designed and Developed Ab-Initio generic graphs to handle file validation for EBCDIC and ASC II files and ingest the data into Hadoop file system.
• Developed generic graphs to read the data from Hadoop file system and load it into Confidential and Teradata db.
• Effectively used various Ab-Inito components like Join, Reformat, Rollup, Sort, Partition by key, Merge, Gather, Lookup, Dedup etc.
• Designed and Developed ETL mappings and transformations for complex requirements using Informatica Power Center 9.5.1
• Designed and Developed generic reusable file validation Mapplet to validate control file with the data file.
• Extensively used Normalizer transformation to read the data from Mainframe Cobol files with EBCDIC format.
• Very good understanding on IBM Banking Data Warehouse model.
• Effectively used Informatica Push Down Optimization and Teradata Parallel Transporter (LOAD and UPDATE operator) throughout the project.
• Very good knowledge in Control-M to load and run the schedules.
• Effectively applied work around for Informatica Push Down Optimization limitations and having very good knowledge in debugging Informatica PDO sqls.
• Effectively applied Change Data Capture to track the changes in the source data and used SCD Type 2 dimension to keep the history changes.
• Extensive experience in transformations like Store Procedure, SQL & Unconnected lookup.
• Vastly used Shortcuts for Sources and Targets and applied standards throughout the mappings.
• Providing technical guidance to ETL team and Perform Unit tests and System Integration testing.
• Responsible for Migrating the code from Dev to QA, UAT & Prod environments.
• Prepared Micro Design and Macro design documents for ETL mappings.

Environment: Ab Initio, Hadoop, Informatica Power Center 9.5.1, Informatica Push Down Optimization, Teradata Parallel Transporter, Teradata, Confidential, SQL, Mainframe Files, Flat files, UNIX Shell Script, Teradata SQL Assistant, Control-M, Toad

Confidential, Phoenix, AZ

Sr ETL Developer

Responsibilities:

• Involved in phases of the project from Analyze, Design, Development, Testing & Implementation.
• Created Use cases and Test cases. Worked with business users to get the sign off on the Use cases.
• Implemented performance tuning logic on mappings, and sessions to provide maximum efficiency and performance. Brought down the run time of a session from 7 hrs to 1.5 hrs.
• Extensive experience in transformations like source qualifier, Expression, Filter, Aggregator, Router, Update strategy, Unconnected & Connected lookup, Normalizer, SQL and Sequence generator.
• Scheduled Informatica Workflows thru Informatica Scheduler & Unix Shell Scripts.
• Perform Unit tests, System Integration testing and User Acceptance testing. Responsible for maintaining the Test cases & Test results on Mercury Quality Center.
• Prepared design report document and work objects as per Amex Method 1 standards.

Environment: Informatica Power Center 8.6, Informatica Power Exchange 8.6, UDB, Netezza, SQL, Flat files, UNIX Shell Script, WinSQL, Cobol, JCL, Windows XP.

Confidential, New York, NY

Sr ETL Developer

Responsibilities:

• Worked with business users to prepare high level design documents.
• Developed ETL mappings and transformations for complex requirements using Informatica Power Center 8.6 & 8.1
• Scheduled Informatica Workflows thru Autosys by creating Autosys scripts.
• Perform Unit tests, Integration testing and validated results with Functional lead and providing technical guidance to ETL team.
• Prepared technical design documents for ETL mappings.

Environment: Informatica Power Center 8.6 & 8.1, Confidential 10g, SQL, Teradata, Flat files, UNIX Shell Script, TOAD, Aqua Data Studio, Teradata Sql Assistant, Autosys, Windows XP.

Confidential, Birmingham, AL

Sr ETL Developer

Responsibilities:

• Developed ETL mappings and transformations for complex requirements using Informatica Power Center 8.6
• Extensively used Informatica Power Exchange to read the data from Mainframe Cobol files.
• Sound knowledge on IBM Banking Data Warehouse model.
• Implemented operational framework, to run the workflows from CA-7 mainframe scheduler. Parameter file is dynamically created through operational framework.
• Developed generic reusable Mapplet to validate control file with the data file for all 26 source systems.
• Effectively applied Change Data Capture to track the changes in the source data and used SCD Type 2 dimension to keep the history changes.
• Extensively used Informatica client tools Source Analyzer, Mapping Designer, Mapplet Designer, Transformation Developer and Informatica Workflow Manager.
• Perform Unit tests, Integration testing and validated results with Functional lead and providing technical guidance to ETL team.
• Migrated the code from Dev to Test & Prod environments.
• Detected bottlenecks, trouble shooting and tuning of mappings, sessions for better performance and efficiency.
• Prepared technical design documents for ETL mappings.

Environment: Informatica Power Center 8.6, Informatica Power Exchange 8.6, Confidential 10g, SQLCobol Files, Flat files, UNIX Shell Script, TOAD, Aqua Data Studio, Cobol, JCL, Windows XP.

Confidential, Tampa, FL

Sr ETL Developer

Responsibilities:

• Interact with business users for requirement gathering.
• Extensively used ETL Tool Informatica to load data from Flat Files, Mainframe Files, SQL Server, Sybase, and DB2 and developed reusable Mapplets and Transformations and designed data Mappings between source systems and warehouse components using Mapping Designer.
• Efficiently applied various transformation logic using source qualifier, Expression, Filter, Aggregator, Router, Update strategy, lookup, Normalizer, Stored procedure, XML, Mapping Variables and Sequence generator transformation to derive new fields and solves rigorous business requirements.
• Developed Mappings to Sync the data for critical tables across the different schemas.
• Analyzed the existing mappings to resolve the business queries raised by different systems and business users.
• Developed Mappings to migrate the data for a critical table from existing UDB to Teradata using Mapping Designer.
• Developed and Implemented Error Handling Strategies.
• Responsible for tuning ETL procedures to optimize load and query Performance
• Involved in Writing Shell scripts to automate the Pre-Session and Post-Sessions Processes.
• Involved in dealing with performance issues at various levels such as target, sessions, mappings and sources.

Environment: Informatica Power Center 8.1.1, UDB, SQL Server 2005, Confidential 10g, Teradata, Sybase, SQL, Flat files, XML file, UNIX Shell Script, AQT (Advanced Query Tool), Teradata Sql Assistant, Windows XP.

Confidential, Phoenix, AZ

Sr ETL Developer

Responsibilities:

• Involved in phases of the project from requirement gathering, Development & Implementation.
• Worked extensively on different transformations like source qualifier, Expression, Filter, Aggregator, Router, Update strategy, Unconnected & Connected lookup, Normalizer, Stored procedure, Mapping Variables and Sequence generator.
• Successfully Implemented Slowly Changing Dimensions. Used Type 2 dimension to keep the history changes.
• Extensively used Partition components to process huge volume of records quickly, thus decreasing the execution time.
• Implemented performance tuning logic on mappings, and sessions to provide maximum efficiency and performance.
• Responsible for creating test cases to test the production ready mapping for integrability, operability, and to make sure the data originating from source is making into target properly in the right format.
• Worked extensively on end to end of the project right from mainframe legacy system to distributed system.
• Effectively managed a team of 12 resources.
• Has very good experience in Onsite/Offshore model.
• Empowered end users to explore business, by generating various reports in Business Object using Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail and Formula's etc.
• Used Business Objects to create reports containing 2D/3D charts to present the end users with a better graphical representation of the data.
• Used Business Objects report level functions like Alerts, Breaks, Customized filters to display relevant data.
• Aggregate awareness Functions of Business Objects were used to route the query objects through most appropriate path while selecting from multiple contexts.

Environment: Informatica Power Center 7.1/8.1, Business Objects XI r2, Cobol, JCL, DB2 8.2, SQL Server, SQL, Siebel, Flat files, UNIX Shell Script, Windows XP.

Confidential, Salt Lake City, UT

Sr ETL Developer

Responsibilities:

• Analyzed the data transmission mechanism for receiving and sending data into/from the repository for strategic business initiatives related to new products and service opportunities.
• Analyzed the third-party system structure that would become the system of record after data migration.
• Did Gap analysis for Source, Staging and warehouse tables.
• Involved in the analysis of Proof of concept (POC) for data migration project.
• Identified the conversion requirements that need to be implemented by the upstream system in order for them to change to the new system of record after cut over.
• Extensively worked on different types of transformations like Source Qualifier, Expression, Filter, Aggregator, Rank, Lookup, Update Strategy, Stored Procedure, Sequence Generator and Joiner.
• Detected bottlenecks, trouble shooting and tuning of mappings, queries, sessions for better performance and efficiency.
• Modified the existing Mappings and created new Mappings as per the requirement.
• Responsible for tuning ETL procedures to optimize load and query Performance.
• Perform Unit tests, Integration testing and validated results with Functional lead and providing technical guidance to ETL team.
• Interacted with the Business Users to analyze the business process requirements made necessary changes to schema objects to fulfill their reporting and business needs.
• Designed the Universes incorporating all the Business requirements.
• Generated various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per the business rules and the requirements of the end users.
• Published existing reports to corporate intranet through Web Intelligence.
• Interacted with the users to analyze the changes for improvement they need in existing reports and developed the reports to satisfy their needs and requirements.

Environment: Informatica Power Center 7.1, Business Objects 6.1, WebIntelligence 6.5, Erwin, DB2 7.1, SQL Server, SQL, Siebel, UNIX Shell Script, Windows2000/NT.

Confidential, Appleton, WI

As ETL Developer

Responsibilities:

• Performed data analysis on the source data coming from point of sales systems (POS) and legacy systems.
• Involved in the design phase of logical and physical data model using Erwin.
• Developed mappings in Informatica Designer tool to extract data from source system, transform and load to the data warehouse.
• Used various transformations like lookup, update strategy, router, filter, sequence generator, source qualifier, joiner on data extracted according to the business rules and technical specifications.
• Used workflow manager to develop and manage tasks, manage connections and scheduling workflows.
• Extensively used Informatica debugger to validate mappings and to gain troubleshooting information about data and error conditions.
• Involved in the preparation of the Unit test cases and executing the same for the Unit testing phase.

Environment: Informatica Power Center 6.2, Confidential 9i, SQL Server, SQL, UNIX Shell Script, MS Access, Flat files, Windows 2000/NT.

Confidential

Programmer Analyst

Responsibilities:

• 24 X 7 Production Support.
• Handling day-to-day maintenance request from onsite/client.
• Root Cause Analysis (RCA) of ABEND/problem by analyzing program and job for providing permanent business solutions and code fixes to the root causes.
• Enhancement of the existing system/programs by writing new programs or by changing existing programs according to the client bill which includes reviewing the System Enhancement Requirement sent by the Client / Onsite Coordinators.
• Impact analysis for assessing the number and severity of impacted components.
• Unit Test Plan preparation, Unit Test Data preparation and Unit Testing.

Environment: COBOL, IMS DB, JCL, VSAM, FILEAID, EZYTRIEVE, CHANGEMAN, INFOMAN, MANAGENOW and JOBTRAC.