SUMMARY

• 8+ years of work experience in various phases of IT projects such as system analysis, design, coding and testing.
• 7+ years of strong experience in Data Warehousing and ETL using Informatica PowerCenter 9.1/9.0.1/8. x/7.x/6.1, Power Exchange 9.1/8.6/8.1, Oracle 11g/10g/9i, Taradata 13/12/V2R6 and Erwin.
• 3 years of experience on real - time data Warehouse development using CDC tool Informatica PowerExchange 9.1/8.6/8.1.
• Experience in Data Warehouse/Data Mart Development Life Cycle using Dimensional modeling of STAR, SNOWFLAKE schema, OLAP, ROLAP, MOLAP, Fact and Dimension tables, and Logical & Physical data modeling using ERWIN 7.5/4.2 and MS Visio.
• Having Business Intelligence experience using OBIEE 11g/10g, Business Objects XI R2, MS Access Reports.
• Extensive experience in using Oracle 11g/10g/9i, DB2 8/7, MS SQL Server 2008/2000, Teradata 13/12/V2R6, MS Access 7.0/2000, Erwin, XML, SQL, PL/SQL, SQL*Plus, SQL*Loader and MS SQL Developer 2000, Win 7/XP and Sun Solaris.
• Worked with Teradata loading utilities like Multi Load, Fast Load, TPump and BTEQ.
• Extensively worked on Oracle Function, Cursor, Store Procedure, and Package & Trigger.
• Experience on data modeling and create LDP and PDM for Star schema and Snowflake schema using MS Visio and ERWIN 7.1/4.5.
• Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation and production support.
• Excellent working knowledge of UNIX shell scripting, job scheduling on multiple platforms, experience with UNIX command line and LINUX.
• Experience in preparing ETL design documentations, user test case documentation and standard operating procedures (SOP) documentation.
• Experience of working on onsite - offshore module.
• Worked as Agile Scrum call facilitator and track status and discussion using BaseCamp and Rally.
• Extensive experience on effort estimation, distribution of work, track & update status report, team coordination and update client.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.
• Providing on Production Support, Resolution & Closure of Trouble issues tickets.

TECHNICAL SKILLS

ETL Technology: Informatica PowerCenter 9.5/9.1/8.x/7.1/6.1, PowerExchange 9.1/8.6/8.1

Data Modeling: Star Schema Modelling, Snow Flake Modelling, MS Visio, Erwin

Databases: Oracle 11g/10g/9i, MS SQL Server 2008/2000, MS Access, DB2, Teradata 14/13/12/V2R6, Sybase

Reporting Tools: Business Objects XIR2, OBIEE 11g/10g

Languages: C, C++, SQL, PL/SQL, HTML, UNIX Scripting

Other Tools: Toad, Harvest, SCM, Putty, Tidal, Autosys, ESP

Operating Systems: LINUX, SUN Solaris, AIX, Windows7/XP/2000/98

PROFESSIONAL EXPERIENCE

Confidential, Marlborough, MA

Sr. Informatica Developer

Responsibilities:

• Interacting with client on a regular basis to discuss day-to-day Issues and matters.
• Provide support for Informatica workflow/mapping (developed used Informatica 9.1.0) which are running into Production environment at client location.
• Conduct training and Knowledge Transfer (KT) session onsite and offshore developers and testers on domain and functional areas.
• Ensuring top-quality deliverables from HCL to the client.
• Provide support for code developed using Data Warehouse Administration Console (DAC) in order to achieve scheduling for ETL jobs.
• Involved in data analysis and handling the ad-hoc request by interacting with business analyst, client and customers and resolve the issues as part of production support.
• Reviewing project/task, status/issues with the HCL offshore team and ensuring completion of project on time.
• Developing UNIX shell script for automation and enhancing/streamlining existing manual procedure used at client location.
• Involved in the development of Informatica mappings and preparation of design document (DD), technical design document (TDD) and unit acceptation testing (UAT) documents.
• Actively participating in proving technical proposal for upgraded existing ETL and OBIEE code at client locations (In order to make use of advanced features of Informatica newer version).
• Making use of various HCL proprietary frameworks and techniques for requirements gathering and business process maps for understating the current process.

Environment: Informatica Power Center 9.5/9.1, Informatica Power Exchange 9.1/8.6, Oracle 11g, UNIX Shell Scripting, SQL, PL/SQL, TOAD, MS Access, MS Visio, Tidal, Utilities BTEQ, FLOAD and TPUMP, Putty, WinScp, WinCvs, Linux, BaseCamp, SCM, Rally, SmartCapa, UltraEdit.

Confidential, Watertown, MA

Sr. Informatica Developer

Responsibilities:

• Developed technical specifications of the ETL process flow.
• Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in SQLServer and Oracle.
• Worked on various issues on existing Informatica Mappings to Produce correct output.
• Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system.
• Analyzed existing system and developed business documentation TRD on changes required.
• Analyzed existing mapping and Reverse Engineering created DLD.
• Analyzed existing Health Plan issues and Re Design on change required.
• Involved in the Unit Testing, Event & Thread Testing and System testing.
• Involved in gathering of business scope and technical requirements and created technical specifications.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Performed unit and integration testing in User Acceptance Test (UAT), Operational Acceptance Test (OAT), Production Support Environment (PSE) and Production environments.
• Created HLD, LLD, UTC doc and Migration documents.
• Designed and developed Workflows as per ETL Specification for Stage load and Warehouse load.
• Worked with production support systems that required immediate support.
• Monitor and tune ETL processes for performance improvements; identify, research, and resolve data warehouse load issues.
• Created synonyms for copies of time dimensions, used the sequence generator transformation type to create sequences for generalized dimension keys, stored procedure transformation type for encoding and decoding functions and Lookup transformation to identify slowly changing dimensions.

Environment: Informatica Power Center 9.5/9.1, Informatica Power Exchange 9.1/8.6, Oracle 11g, UNIX Shell Scripting, SQL, PL/SQL, TOAD, MS Access, MS Visio, Tidal, Utilities BTEQ, FLOAD and TPUMP, Putty, WinScp, WinCvs, Linux, BaseCamp, SCM, Rally.

Confidential, New York

Sr. Informatica Developer

Responsibilities:

• As a lead member of ETL Team, responsible for analyzing, designing and developing ETL strategies and processes, writing ETL specifications for developer, ETL and Informatica development, administration and mentoring.
• Participated in business analysis, ETL requirements gathering, physical and logical data modeling and documentation.
• As Scrum Master I manage: Stand-ups, Backlogs, sprint Planning Meetings.
• Delivery of quality solutions on time, within budget using approved scheduling tools, techniques and methodologies has been critical to success. Accustomed to working well with internal and external stakeholders at multiple levels, navigating the organization, successfully completing complex projects under tight deadlines.
• Doing self and peer review for Informatica and oracle objects.
• Designing the data transformation mappings and data quality verification programs using Informatica and PL/SQL.
• Designed the ETL processes using Informatica to load data from Mainframe DB2, Oracle, SQL Server, Flat Files, XML Files and Excel files to target Teradata warehouse database.
• Designed Reusable Transformations, Mapplets, and reusable Tasks and designed Worklets as per the dependencies of various sessions and parent-child tables.
• Worked on performance tuning of Informatica code. Extensively work on customization of cache, partitioning, push down optimization and transformation tuning.
• Created PowerExchange registration and configured in PowerCenter to load data in real-time mode.
• Worked on Teradata utilities BTEQ, MLOAD and TPUMP and tuned SQL.
• Created Oracle stored procedure, package and triggers. Worked on analytical query to format report. Created materialized view to store summarized data.
• Investigate, debug and fix problems with Informatica Mappings and Workflows.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Performing ETL, Unix script and database code migrations across environments.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables. Partitioned sessions and used incremental aggregation for fact load.
• Participated in Decision support team to analyze the user requirements and to translate them to technical team for new and change requests.
• Performed unit and integration testing in User Acceptance Test (UAT), Operational Acceptance Test (OAT), Production Support Environment (PSE) and Production environments.
• Created HLD, LLD, UTC doc and Migration documents.

Environment: Informatica Power Center 9.1/8.6, Informatica Power Exchange 9.1/8.6, Oracle 11g, UNIX Shell Scripting, SQL, PL/SQL, TOAD, MS Access, MS Visio, Autosys, Teradata 13, Utilities BTEQ, FLOAD and TPUMP, Putty, WinScp, DB2 Mainframe, Linux, BaseCamp, SCM, Rally.

Confidential, Minnetonka, MN

Sr. Informatica Developer

Responsibilities:

• Designed and developed Logical/physical Data Model, Forward/Reverse engineering Using Erwin 7.2.
• Designed and developed Workflows as per ETL Specification for Stage load and Warehouse load.
• Providing on call production support and efficiently tracked heat-tickets, timely resolving prod issues and proactively escalation (if appropriate), resolution and closure of trouble issues and tickets.
• Designed ETL functional specifications and converting them into technical specifications.
• Interacted with management to identify dimensions and measures.
• Review source systems and propose data acquisition strategy.
• Developed ETL methodology to custom fit the ETL needs of sales.
• Data collection and transformation mappings and design of the data warehouse data model.
• Responsible for developing the mappings for the pre-existed procedure in the CDW as we were removing the procedures from the cloned CDW.
• Responsible for the data analysis of the target systems as there are target systems, which are dependent on CDW data.
• Delivered the test plan, test specification and test report document as per the Guidant system document management system.
• Coordinated with team members for collecting information about system testing of the clone CDW.
• Created Web services source and targets. Customized web services mappings and workflows. Extensively worked on XML source, targets and transformations.
• Actively involved in coordinating all the testing related issues with the end users and the testing team.
• Executed Test Cases to ensure the product meets the specifications and the Life Cycle Services.
• Worked on Data Analysis reports Business Objects.
• Developed shell scripts for job automation, which will generate the log file for every job.
• Prepared Run books, migration documents and production monitoring and support handbook for daily, weekly and monthly processing.

Environment: Informatica PowerCenter 8.6, Informatica PowerConnect, Informatica PowerExchange 8.6, Oracle 11g, SQL * Loader, Data Pump, TOAD, Business Objects XI/R2, MS SQL Server 2005, Sun Solaris, UNIX, Windows NT 4.0, MQ series.

Confidential, Santa Clara, CA

ETL Developer

Responsibilities:

• Involved in Requirement gathering and studying of Source-Target mapping document
• Involved in Data transfer from OLTP systems forming the extracted sources.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Analyzed the sources, transformed the data, mapped the data and loading the data into targets using Power Center Designer.
• Designed and developed Oracle PL/SQL Procedures.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Participated in the design of Star & Snowflake schema data model.
• Tested Informatica workflows using various transformations for extracting data from flat files, oracle and loading aggregated data into staging and target data mart.
• Involved in creation of Test Cases, Test Scripts and logging of defects using Test Director.
• Developed the materialized views, organized indexes to improve the performance of SQL queries.
• Tested Informatica mappings and also tuned them for better performance and implemented various Performance and tuning techniques.
• Responsible to tune ETL procedures and Star Schemas to optimize load and query performance.
• Written stored procedures and triggers.
• Performed System testing, Regression testing, functional testing manually.
• Created Test plans that describe each test in minute detail.
• Developed defect tracking report using Test Director.
• Created MQ series Source and Target and used XML parser and XML generator.

Environment: Informatica Power Center 8.6, Informatica PowerExchange 8.6, Oracle 11g, XML Files, SQL*PLUS, SQL*Loader, TOAD, Windows 2000, UNIX, Import/Export Utilities, MQ Series, Shell Scripts.

Confidential, St. Louise, MO

Informatica Developer

Responsibilities:

• Involved in creation of Logical Data Model for ETL mapping and the process flow diagrams.
• Worked with SQL developer to write the SQL code for data manipulation.
• Worked on Informatica versioned repository with check in and checkout objects feature.
• Used Debugger extensively to validate the mappings and gain troubleshooting information about data and error conditions.
• Provided guidance to less experienced personnel. Conducted quality assurance activities such as peer reviews.
• Participate in the business analysis process and the development of ETL requirements specifications.
• Worked with production support systems that required immediate support.
• Develop, execute and maintain appropriate ETL development best practices and procedures.
• Assisted in the development of test plans for assigned projects.
• Monitor and tune ETL processes for performance improvements; identify, research, and resolve data warehouse load issues.
• Involved in unit testing of the mapping and SQL code.
• Developed mappings to load data in slowly changing dimensions.
• Involved in performance tuning of source & target, mappings, sessions and workflows.
• Worked on Teradata various utilities like BTEQ, FLOAD and created procedures.
• Worked with connected, unconnected lookups and reusable transformations and mapplets.
• Utilized Unix Shell Scripts for adding the header to the flat file targets.
• Involved in designing the star schema and populating the fact table and associated dimension tables.

Environment: Oracle 11g, SQL Developer, SQL, Informatica Power Center 8.1, Sybase, Windows XP, Visio 2000, Business objects XIR2, ESP, SCM, Putty, WinScm, Teradata V2R5.

Confidential, Minneapolis, MN

ETL Developer

Responsibilities:

• Developed complex mappings to extract source data from heterogeneous databases SQL Server Oracle and flat files, applied proper transformation rules and loaded in to Data Warehouse.
• Involved in identifying bugs in existing mappings by analyzing data flow, evaluating transformations using Debugger.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Worked closely with Production Control team to schedule shell scripts, Informatica workflows and PL/SQL code in Autosys.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures etc.
• Defects were tracked, reviewed and analyzed.
• Conducted UAT (User Acceptance Testing) with user community.
• Developed K-shell scripts to run from Informatica pre-session, post session commands.
• Extracted data from VSAM file and XML files.
• Involved in Data transfer from OLTP systems forming the extracted sources.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Analyzed the sources, transformed the data, mapped the data and loading the data into targets using Power Center Designer.
• Designed and developed Oracle PL/SQL Procedures.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Participated in the design of Star & Snowflake schema data model.

Environment: Informatica PowerCenter 7.1/6.1, Oracle 10g, SQL Server 2000, Erwin 3.5, XML, TOAD, HP - Unix 11.11, Harvest, Sun Solaris, DB2 Mainframe.