SUMMARY

• 9+ years of IT experience in various phases of IT projects such as system analysis, design, development and testing.
• Extensive experience in teh implementation of Database/Data warehouse/ODS/ Data Marts for Financial, Logistical and Health & Pharma - Clinical Trials. Working as ETL/DB lead for development & migration of projects.
• Solid experience in Data warehousing, Data Architecture & Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center 6.x/7.x/8.x/9.x (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation developer, Mapplets Designer, Mapping Designer, Repository manager and Informatica server).
• Extensive exposure in Dimension Data Modeling, Star Schema Modeling and Snowflake modeling. Good understanding of Data Management, Data Convergence, Business Intelligence (BI), OLAP, OLTP and ERP concepts.
• Extensive experience in developing stored procedures, functions, Views, Sequences and Triggers, Complex queries using PL/SQL & SQL in Oracle 9i/10g/11g, Sybase and MSSQL.
• Expertise in scheduling jobs by Control M scheduling tool. Implementing convoluted scheduling jobs using Control M & UNIX Shell scripts.
• Expertise in all teh phases of System development life Cycle (SDLC) & Agile Methodologies and complete exposure to Project Process management skill sets from Initiation to Closing wif leadership, motivation, conflict resolution, change and team building ability.
• Experience in various ETL development projects in analyzing & translating business requirements to technical requirements, allocation of tasks to team, development, TEMPeffective code review, testing, implementation, post-implementation reviewand production support.
• Expertise in implementing complex Business rules by creating robust Mappings, Mapplets, and reusable objects using Informatica Power Center.
• Experience in reusable code design to leverage application architecture/framework capabilities and functionality.
• In depth knowledge in Control M Enterprises Tool, which is used for schedule teh Control M jobs to execute various commands in different UNIX servers.
• Strong ability to quickly learn, comprehend business processes and problems in order to TEMPeffectively develop technical solutions to their requirements. Always ready to take teh initiative and aggressive pursuer of project/task deadlines wifout compromising on teh quality of teh deliverables or process compliance.
• Experience in debugging, troubleshooting, monitoring and performance tuning in Informatica and SQL queries. Extensive working experience in maintenance and Production support of different applications.
• Worked closely wif BI Data Architect, Business Analysts, Business users, Application Architects, Development team, Production DBA's & Networking team in handling Setup, maintaining and upgrades of distributed environment.
• Provided training to various new employees and assist wif expert knowledge on all production processes. Documented all production applications and resolved all application issues and answered all requests.
• Assist teh team technically in case of any technical challenges faced by teh team. Ensure teh deliverables are delivered as per schedule and teh project plan. Responsible for offshore team deliverables. Tracking and Reporting teh progress of different requirements in project on a daily/weekly/monthly basis using internal Project Management Tool.

TECHNICAL SKILLS

ETL: Informatica PowerCenter 6.x/7.x/8.x/9.x (Mapping Designer, Work Flow Manager, Work Flow Monitor, Mapplet & Transformations)

Databases: Oracle 9i/10g/11g, MS SQL Server, Sybase 12.x/11.x

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables

Environment: Windows 2008/2007/2005/ NT/XP/7, UNIX, MS-DOS

Tools: BMC Control M, SQL *PLUS, Rapid SQL, SQL Developer, Eclipse, Tortoise, putty, winscp, FileZilla, WSFTP, WinMerge, Visio, MS Office

Scripting/Programming languages: SQL, PL/SQL, UNIX Shell Scripting (KSH), Perl, C, Java

Web Technologies: HTML, Struts, Servlet, Portlet, JSP, XML, Java script

Professional Experience

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Senior DW/ETL Developer & ETL Team Lead

Responsibilities:

• Gathered requirements by conducting meetings and brainstorming sessions wif end users (Funds Surveillance users) and documented them.
• Worked directly wif J.P. Morgan Worldwide Securities Services (WSS) to consume multimanager funds positions, transactions, currency forwards, collateral, derivatives underlying securities details & illiquid securities.
• Interacted wif common services team to in corporate ETF products transactions & positions in existing compliance applications wifout any impact.
• Involved in breaking down entire project into sprints and provide assistance to teh Project Manager on planning. As scrum master, assigned teh work to all team members and coordinating wif all teams working in various projects.
• Responsible for teh Data Modeling and populating teh business rules using mappings into teh Repository for Meta Data management.
• Performed analysis, design, development and maintenance activities associated wif teh database and data in support of multiple applications.
• Designed and created complex source to target mappings using various transformations inclusive of Aggregator, Look Up (Connected and Un-Connected), Joiner, Source Qualifier, Expression, Update Strategy, Sequence Generator, Union and Router transformations
• Developed PL/SQL stored procedures and functions to handle various activities outside of Informatica ETL process.
• Created mappings, mapplets, reusable transformations, workflows wif Sequential session tasks and concurrent session tasks. Scheduled workflows and procedure by Control M scheduler.
• Responsible for testing and validating Informatica mappings against teh pre-defined ETL design standards and preparing and implementing teh code to QA, UAT and production environments

Environment: Informatica Power Center 9.5, Flat files, UNIX, Oracle 10g/11g, Sybase, Control M scheduler, Ext JS, JAVA/J2EE

Confidential, New York, NY

Senior DW/ETL Developer & ETL Team Lead

Responsibilities:

• Interacted wif Compliance Users to know their Business views while gathering teh product requirements and supported product owner to document product backlogs. Prioritized product backlogs and translated those requirements into sprints to assist teh Project Manager on planning by agile methodology.
• As scrum master, performed Sprint Planning Meetings, Daily Scrum Meetings, Sprint Review Meetings and Sprint Retrospective Meetings.
• Distributed tasks across teh team and responsible for offshore & onshore team deliverables. Assist team member in case of any roadblocks and reviewed teh team deliverables.
• Responsible for teh complete design and development of ETL architecture for loads from source to stage to ODS to data mart.
• Coordinated wif source systems owners, day-to-day ETL progress monitoring, Data warehouse Target schema design (star schema) and maintenance.
• Worked on Informatica PowerCenter - Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations
• Created standard and reusable Informatica mappings/mapplets using Lookup, Joiner, Rank, Source Qualifier, Sorter, Aggregator, Union and Router transformations to extract, transform and load data mart
• Worked wif staging area to perform data cleansing, data scrubbing, data filtering and data standardization process.
• Created SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Involved in teh performance tuning of Informatica code, SQL, PL/SQL scripts, Database using standard performance tunings steps for better performance and thereby improving teh load time.
• Created Control M jobs and scheduled teh tasks using Control M scheduler.
• Created and executed test cases/scripts and completed unit integration and system tests successfully. Responsible for all activities in UAT to get sign off from users.
• Deployment of Informatica Objects from Dev to QA, UAT, and Production environments. Provided warranty support for productions jobs.

Environment: Informatica Power Center 8.6.0, UNIX, Flat files, Oracle 10g/11g, Sybase, Control M, EXT JS, JAVA/J2EE

Confidential, Jersey City, NJ

Senior DW/ETL Developer & ETL Team Lead

Responsibilities:

• Responsible to meet wif business stakeholders and other technical team members to gather and analyze application requirements.
• Prepared teh Asset Segregation rules and reviewed wif funds surveillance users. Prepared teh technical functional specification document and solid database design.
• Applied slowly changing dimensions like Type1 and 2 TEMPeffectively to handle teh delta loads.
• Distributed task across teh complete team and closely monitored teh progress to make sure all takes will be delivered on time.
• Created ETL mappings using Informatica Power center to extract teh data from multiple sources like Oracle, Sybase, csv, Delimited files transformed based on business requirements and loaded to Data Warehouse.
• Developed several complex mappings in Informatica by variety of Power Center transformations and Mapping Parameters. Created mappings using transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored procedure and Sequence Generator.
• Created and configured Workflows, Worklets, and Sessions to transport teh data to target using Informatica Workflow Manager.
• Designed and developed Oracle PL/SQL scripts for Data Import/Export, Data Conversions and Data Cleansing. Designed and developed Oracle PL/SQL Procedures to implement complex rules.
• Developed teh test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge
• Created UNIX scripts to automate teh activities like ftp & sftp. Scheduled these UNIX scripts, procedures execution and run informatica workflows by using Control M schduler.
• Reviewed teh offshore deliveries to make sure teh quality of code and helped them on critical issues.
• Created deployment objects to deploy Informatica power center objects & Database scripts to QA,UAT and PROD
• Experienced in Shell and PL/SQL scripting for regular Maintenance and Production Support to load teh warehouse in regular intervals. Supported daily nightly productions jobs on rotation basis

Environment: Informatica Power Center 8.6.0, UNIX, Flat files, Oracle 10g/11g, Sybase, Control M, EXT JS, JAVA/J2EE

Confidential

Senior DW/ETL Developer

Responsibilities:

• Gathered teh ad-hoc requests on existing reports enhancements and performed detailed impact analysis to come up wif better solution for teh given requirement.
• Prepared Business Requirement Documents (BRD’s) after teh collection of Functional Requirements from System Users dat provided appropriate scope of work for technical team to develop prototype and overall system.
• Responsible for offshore deliverables. Dedicated teh work to all team members, coordinated teh team members and helped them in case of issues.
• Replaced all JAMS scheduler jobs by Control M. As part of migration, replaced all BCP IN/OUT scripts wif Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, and Connected and Unconnected lookups, Filters, Sequence, Union, Router and Update Strategy
• Extensively worked wif Informatica to load data from flat files, Oracle, MS SQL server to target database for LVTS, Security Capital, Rochester, International and CDS transactions feed.
• Created SQL, PL/SQL, stored procedures for implementing business rules and transformations. Involved in optimizing existing SQL, PL/SQL Stored Procedures to handle high volume of data.
• Extensively worked on tuning (Both Database and Informatica side) and thereby improving teh load time
• Performed technical reviews of code and test plans created by team members. Deployment of Informatica, Java, Control M & DB Objects from Dev to QA,UAT, and Production environments
• Responsible for all activities in UAT to get sign off from users. Supported daily nightly productions jobs on rotation basis

Environment: Informatica Power Center 8.6.0, UNIX, Flat files, Oracle 10g, Sybase, Control M, VAP 7.2 & JSR 168 Portlet

Confidential

DB & ETL Developer

Responsibilities:

• Developed teh change requirements wif client team and provided technical support to teh team. Also Prepared Functional Spec & Unit test plans
• Generated Target Flat Files and loaded teh data into database tables using teh Informatica Mappings and used extensively all types of Transformations.
• Generated database scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Developed SQL queries to fetch complex data from different tables in remote databases using joins, database links and logs.
• Performed integration testing for various mappings. Tested teh data and data integrity among various sources and targets.
• Responsible for all activities in UAT to get sign off from users. Involved for resolving teh production issues & queries.

Environment: Informatica Power Center 7.1.1, UNIX, Flat files, Sybase, Oracle 9i, Java, J2EE, VAP 7.2 & JSR 168 Portlet

Confidential

DB & ETL Developer

Responsibilities:

• Created mappings, sessions, workflows and mapplets for data migration.
• Used various Transformations such as Aggregator, Update Strategy, Union, Router, Sorter, Source Qualifier, Filter, Expression, Connected/Unconnected Lookup, Sequence Generator, and Joiner.
• Developed complex mappings, scripts and procedures.
• Created teh sessions to move teh data at specific intervals to target tables and flat files using Informatica Server.
• Using Workflow manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in teh batch process.
• Re-writing teh existing Informatica mappings and workflows to ensure teh proper data flow according to teh updated design document and data mapping sheet
• Responsible for development of forms and interfacing teh data selection from teh database.
• Developed Unit tests and separate User Acceptance test cases (UAT) to validate data against test scenarios.

Environment: Informatica Power Center 6.2, UNIX, Flat files, MSSQL, Java, J2EE & Struts

Confidential

DB & ETL Developer

Responsibilities:

• Normalization of database to remove data redundancy. Teh models were developed in accordance wif teh rules of referential integrity.
• Development of database tables, relationships and PL/SQL procedures and Functions.
• Created database objects like Tables, Indexes, Synonyms, and Sequences.
• Analyzed requirements and created Database Triggers for validations written in PL/SQL.
• Involved in interacting wif teh business community to understand their requirements.
• Transferred data from flat files into oracle using Informatica.
• Created teh Staging mappings for delta detection using teh different Transformations (Expression, Lookup, Joiner, Filter, Router, Stored Procedure etc.)
• Created PL/SQL procedures to generate patient’s reports.
• Prepared QA testing scripts and Test Case document.

Environment: Informatica Power Center 6.2, UNIX, Flat files, Oracle 9i, Java, J2EE & Struts