SUMMARY:

• Over 11 years of working experience (Informatica Certified Developer) in various stages of software development, with 8 years senior level experience in full life cycle (SDLC) Data Warehousing, Data Integration, Business Intelligence as ETL Architect /Informatica Lead and Senior System Analyst using Informatica PowerCenter9.x/8.x,7.x, Oracle10g/9i/8i (Oracle level 1 Certified),Microsoft DTS, MS Analysis Services, MS SQL, PLSQL, Shell Scripts, Unix, Linux, Windows,DB2,Netezza,Sybase Power Designer
• Experience in Managing onsite - offshore teams and Mitigating risk by identifying, escalating and resolving issues across multiple delivery groups and/or projects.
• Good experience in working multiple projects including fixed price projects.
• Proficiency in defining ETL design and integrating data from disparate source systems and disparate data formats including Requirements gathering, Source system analysis, Data Quality, Slowly changing dimensions mappings, ETL-QA, Performance Tuning, Maintenance and Production Support using Informatica PowerCenter8.6.1, 8.1.1, 7.1.x, PLSQL,MS Sql 2005/2000/7.0 Unix Shell
• Experience in Data Modeling and deployment of multi-dimensional schema (Star and Snowflake Schemas) using Ralph Kimball Methodology, Conceptual/Logical/Physical design, Preparing HLD and Data flow diagram using Visio.
• Strong programming and debugging skills in SQL, PL/SQL and UNIX shell scripting. Experience in developing Stored Procedures, Functions, Packages, Database triggers, Materialized views, SQL*Loader and extensive experience in Query optimization, Performance tuning.
• Have good domain knowledge on Telecom, Banking and Finance
• Well-versed in SDLC all phases, good understanding of CMM and ISO 9001:2000 guidelines, team leadership, Onsite/Offshore activities 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.
• 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 with 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 with expert knowledge on all production processes. Documented all production applications and resolved all application issues and answered all requests.
• Assist the team technically in case of any technical challenges faced by the team. Ensure the deliverables are delivered as per schedule and the project plan. Responsible for offshore team deliverables. Tracking and Reporting the progress of different requirements in project on a daily/weekly/monthly basis using internal Project Management Tool.
• Good troubleshooting/debugging and technical problem solving skills.
• Good team player committed to client satisfaction and quality.
• Good Knowledge with hands on experience on Big data technologies like PIG, HIVE,

TECHNICAL SKILLS:

ETL: Informatica PowerCenter 9.5 8.6/8.5.1, x/7.1.x/, Ms DTS,BODS 14.2

OLAP: Brio6.0, MS Analysis Services,SSRS,BO,QlickView 9

Data Modeling: Visio, UML

Database tools: TOAD, SQL*Navigator, AQT, Rapid Sql,PL/SQL Developer

RDBMS: Oracle 8i/9i/10g, SQL Server 2000/7, MS-Access, DB2, Sybase, Netezza.

Languages: PL/SQL, Shell Script, Java, C, C++,Vb 6.0,Asp.

O.S: UNIX (HP-UX, Solaris, AIX), Windows XP/2000/ NT/9x

Web Technologies: HTML, .NET, XML

Hardware: HP 9000, Pentium PCs

Tools: /Utilities: MS Project, Clear Quest, ClearCase, Putty, VSS, Autosys, Tortoise SVN, Control - M, Change management tool ITSM,ITPAM.

Scheduling Tools: Autosys, Control M 8.0/9.0,Redoowd

Big Data Technologies: Hadoop, PIG, HIVE, Impala, HBASE

PROFESSIONAL EXPERIENCE:

Confidential, Tempe, AZ

DW Integrator II

• Gathered requirements by conducting meetings and brainstorming sessions with SA and Procut owners and documented them.
• Preparing Design docs, HLD, LLD and working closely with Data modelling team to make any changes to the existing DW structure or creating new objects in database.
• Doing impact analysis and coordinating with the upstream/downstream applications
• Working with offshore team for developing ETL code using BODS tool and scheduling jobs in Redwood tool
• Worked closely with QA team in order to fix the defects on time and to get UAT sign off on the deliverables
• Responsible for offshore coordination, code review and conduct High level design session with offshore team in every phase of requirements.
• Working with Project Manager on efforts estimation for both the projects FRDS and ALLL and hiring offshore resources.

Confidential, Jersey City, NJ

Senior System Analyst\ETL Architect

• Gathered requirements by conducting meetings and brainstorming sessions with end users (Funds Surveillance users) and documented them.
• Worked directly with J.P. Morgan Worldwide Securities Services (WSS) to consume multimanager funds positions, transactions, currency forwards, collateral, derivatives underlying securities details & illiquid securities.
• 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 with staging area to perform data cleansing, data scrubbing, data filtering and data standardization process.
• Created Control M jobs and scheduled the 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.
• Worked on Informatica migration from 8.6 to 9.5 including migration from Unix Solaris server to Linux server as part of Informatica migration

Confidential

ETL Architect

• Understanding business requirements, analysis and designing Data Migration/Integration Process from Business Users.
• Managing project deliverables in line with the project plan.
• Recording and managing project issues and escalating where necessary.
• Working closely with users to ensure the project meets business needs.
• Providing regular status reports to client and feedback to offshore Team.
• Working with Pega Application developers closely to help them in writing complex sql code and in developing ETL strategy.
• Testing the functionality build in Pega - CMS application as per requirement doc.
• Use Informatica PowerCenter to extract, transform and load data from/to Oracle, Sql Server to Flatfile and XML.
• Handling Change Management (Defects, Enhancement) through ITSM reporting tool.
• Managing code deployment to higher env from DEV, code review, preparing test cases and Unit testing.
• Recruiting project staff and consultants.

Confidential

ETL Lead

• Understanding business requirements, analysis and designing Data Migration/Integration Process from Business Users.
• Managing project deliverables in line with the project plan.
• Recording and managing project issues and escalating where necessary.
• Working closely with users to ensure the project meets business needs.
• Providing regular status reports to client and feedback to offshore Team.
• Use Sybase Power Designer 15.3 for Data Modeling
• Testing the functionality build in Pega - CMS application as per requirement doc.
• Use Informatica PowerCenter to extract, transform and load data from/to Oracle, Sql Server to Flatfile and XML.
• Handling Change Management (Defects, Enhancement) through ITSM reporting tool.
• Managing code deployment to higher env from DEV, code review, preparing test cases and Unit testing.
• Recruiting project staff and consultants.

Environment: Informatica PowerCenter 8.6, Rapid SQL, Control M, Ms Visio, Oracle, MS Sql Server 2005,Spot Fire,SVN , Business Objects reporting services,Control - M,Sybase Power Designer 15.3,Pega 6.2.

Confidential

ETL Lead\System Analyst

• Understanding business requirements, analysis and designing Data Migration/Integration Process from Business Users
• Creating HLD/LLD and Release documentation and Involve END-END to release
• Translate business requirements into Data Migration architectural design.
• Work with onsite and offshore project team to devise best practices and continuous improvement of project delivery across the enterprise.
• Coach, mentor and motivate junior Associates
• Escalate issues and concerns appropriately.
• Offer input and feedback on growth and development opportunities for junior Associates
• Create Technical Design document, Source to Target mapping documents based on the client business requirement.
• Use Informatica PowerCenter to extract, transform and load data from/to Oracle,Sql Server to Flatfile and XML.
• Production env setup and Production support

Environment: Informatica PowerCenter 8.6.1, Rapid SQL, Control M, Ms Visio,Oracle,Ms Sql Server 2005,Spot Fire,SVN , Bo reporting services,Control -M

Confidential, Schamburg IL

ETL Lead

• Actively participate in understanding business requirements, analysis and designing Data Migration/Integration Process from Business Analyst
• Translate business requirements into Data Migration architectural design.
• Create Technical Design document, Source to Target mapping documents based on the client business requirement.
• Design and implement Meta data repository and reusable components
• Create ETL best practices and Developers guide
• Create reusable transformations and mapplets to use in multiple mappings
• Develop the strategy Flat file to Relational table, table to table load mappings
• Handle the performance tuning of Informatica mappings
• Responsible to test the Informatica (mappings), DB2 complex queries
• Responsible for code migration, Code review, test plans, test scenarios, test cases as part of Unit/Integrations testing
• Automate the Production jobs using Informatica Workflows, Autosys, Shell script
• Onsite - Offshore communication
• Production env setup and Production support
• Platform conversion from DB2 database to Netezza database.

Environment: Informatica PowerCenter 8.6.1, AQT, Autosys, Ms Visio,DB2,Ms Sql Server 2005,Netezza

Confidential, Schamburg, IL

ETL Lead

• Actively participate in understanding business requirements, analysis and designing Data Migration/Integration Process from Business Analyst
• Translate business requirements into Data Migration architectural design.
• Create Technical Design document, Source to Target mapping documents based on the client business requirement.
• Design and implement Meta data repository and reusable components
• Create ETL best practices and Developers guide
• Create reusable transformations and mapplets to use in multiple mappings
• Develop the strategy Flat file to Relational table, table to table load mappings
• Handle the performance tuning of Informatica mappings
• Responsible to test the Informatica (mappings), DB2 complex queries
• Responsible for code migration, Code review, test plans, test scenarios, test cases as part of Unit/Integrations testing
• Automate the Production jobs using Informatica Workflows, Autosys, Shell script

Environment: Informatica PowerCenter 8.6.1, AQT, Autosys, Ms Visio,DB2,Ms Sql Server 2005

Confidential, Broomfield CO

ETL Lead

• Participated in all phases of SI - Conversion
• Responsible for Requirements gathering, Technical System Design, Development, Testing, Code Review, Code migration, UAT, Job scheduling, Offshore Coordination.
• Convert functional requirements to design. Interact with Business and formulate the design and approach.
• Interacted with Data Architecture group, PM, Project team to finalize the design strategies. Created various diagrams as part of the Project deliverable and physical database design.
• Wrote new DDL scripts. Prepared the source-to-target mapping document.
• Designed conforming dimension and fact tables in a STAR Schema
• Designed and developed high performance ETL design plans, Staging and Target tables design to load large volumes of data(Flat file to table, Table to Table, table to Flat file) utilizing Informatica PowerCenter, Parameter File, Korn Shell.
• Developed back-end routines using Oracle SQL PLSQL stored procedures Packages Triggers. Created UNIX Shell scripts to automate routine tasks.
• Generating dashboard reports based on Siebel 7.8 data.
• Generating Reports using MS reporting services 2008
• Created reusable transformations & Mapplets, and implement various slowly changing dimensional mappings.
• Created db objects such as Table, Synonym, Materialized view, View, index, Partitioning
• Designed error checking mechanisms to reduce failures and monitor error logs thru Parameter file.
• Performance Tuning on the Targets, Sources, Mappings and Sessions used Techniques like reusable Transformations, reusable Caches and partitioning etc.
• Developed test plans, test scenarios, test cases as part of Unit/Integrations testing
• Responsible for setting up Production Jobs and created Production Operational Document

Environment: Oracle 10g, PL/SQL,Siebel 7.8, Informatica PowerCenter 8.1.1, Unix, TOAD 8.1,ClearCase, Rational Clear Quest, MS Visio, Clear Case,Ms reporting Services 2008, Ms Visio.

Confidential

Sr. Informatica Developer

• Responsible for designing, developing, implementing all aspects of ETL Phase
• Defined star schema and staging database environments
• Developed high performance ETL plans to load large volumes of data
• Design and develop ETL processes to data from PeopleSoft tables
• Developed various Complex Informatica Mappings, slowly changing dimensions
• Designed and implemented slowly changing dimension types for Organizational hierarchy
• Developed various Complex Informatica Mappings implementing SCD type 2 dimensions.
• Designed bulk loading utility for large volume of source data
• Detected bottlenecks, trouble shooting and tuning of mappings, queries, sessions for better performance and efficiency. Handled error handling routine using Process Control table and automated error checking mechanisms to reduce failures & monitor error logs
• Created DDL scripts, developed back-end routines using SQL, PLSQL Stored procedures.
• Created ETL batch jobs, work lets and workflows for data warehouse data loading automation process
• Created UNIX Shell scripts to automate routine tasks
• Deliver project documentations such as Source to target mapping document, ETL design specs, ETL Test strategy, Production Operational documents

Environment: Oracle 10g, PL/SQL, Informatica PowerCenter 7, Unix, TOAD 8.1,ClearCase, Rational ClearQuest, MS Visio, Clear Case,Ms reporting Services 2005,Ms Sql Server 2005, Ms Visio

Confidential

Sr ETL Developer/Onshore lead

• Responsible for Planning, Knowledge Transfer (KT phase), Knowledge Acquisition, Offshore coordination, designing, developing Designing LLD, Analysis and Documentation.
• Automated all the manually generated dashboard report in MS Reporting Services
• Interaction with Business Analysts/Users to get the functional requirements/reporting needs, brainstorming discussions with offshore team to explain the SR requirements.
• Developed complex mappings involved extensive use of transformations.
• Used lookups extensively to load the target table for SCD type 2 processes.
• Developed back-end routines using Oracle SQL PLSQL Stored procedures Packages Triggers and created UNIX Shell scripts to automate routine tasks.
• Detected bottlenecks and improved the performance of the Informatica maps.
• Did Performance Tuning on the Mappings and Sessions used Techniques like reusable Transformations reusable Caches and partitioning etc. Migrated the code/Informatica objects between environments.
• Provided on-call support for the nightly load process & version control system of Informatica.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation. Used Debugger to test the mappings and fix the bugs.
• Delivered ETL checklist, Test Plan& Test cases for developers & ETL QA team

Environment: Oracle 10g, PL/SQL, Informatica PowerCenter 7, Unix, TOAD 8.1,ClearCase, Rational ClearQuest, MS Visio, Clear Case,Ms reporting Services 2005, Ms Visio, Ms Sql Server 2005

Confidential

Sr ETL Developer/Onshore lead

• Have good knowledge on Network engineer and Granite application.
• Responsible for Planning, Knowledge Transfer (KT phase), Knowledge Acquisition, Offshore coordination, designing, developing Designing LLD, Analysis and Documentation.
• Interaction with Business Analysts/Users to get the functional requirements/reporting needs, brainstorming discussions with offshore team to explain the SR requirements.
• Developed complex mappings involved extensive use of transformations.
• Developed back-end routines using Oracle SQL PLSQL Stored procedures Packages Triggers and created UNIX Shell scripts to automate routine tasks.
• Detected bottlenecks and improved the performance of the Informatica maps.
• Did Performance Tuning on the Mappings and Sessions used Techniques like reusable Transformations reusable Caches and partitioning etc. Migrated the code/Informatica objects between environments.
• Provided on-call support for the nightly load process & version control system of Informatica.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation. Used Debugger to test the mappings and fix the bugs.
• Delivered ETL checklist, Test Plan& Test cases for developers & ETL QA team
• Wrote Stored Procedures in Oracle and used them as Target Post SP Transformations and to aggregate data and use those stored procedures as SP Transformations in Informatica.
• Mentored other developers and assisted them with development issues.
• Reviewed peer-to-peer mappings, created various Mappings using Informatica PowerCenter. Involved in the development, Unit Testing / System Testing of various Informatica mappings.
• Documented the number of source / target rows and analyzed the rejected rows and worked on re-loading the rejected rows.

Environment: Oracle 9i, PL/SQL, Informatica PowerCenter 7, Unix, TOAD 8.1,ClearCase, Rational ClearQuest, MS Visio, Clear Case,Ms reporting Services 2005, Ms Visio, Ms Sql Server 2005

Confidential

ETL Developer

• Designed and developed ETL Processes based on business rules using PLSQL Scripts and DTS.
• Conversion of Hyperion Brio reports to MS Sql Server 2005 reporting services.
• Designed the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Developed ETL SQL Server 2000 DTS packages.
• Analyzed business process and assisted in the development of ETL procedures for moving data from source to target systems.
• Involved in extensive performance tuning by determining bottlenecks at various points
• Involved in creating and optimizing cubes and dimensions in Sql Server 2000.
• Involved in writing MDX queries for OLAP
• Efficient in writing custom code in DTS using VB script.
• Wrote complex PL sql scripts and Dynamic Procedures
• Created test cases and test scenarios and documented actual results.
• Involved in system testing of overall Processes provided production support.
• Involved in Production support of existing application
• A motivated player, worked towards achieving results as a team.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Training and Mentoring Junior team members
• Coordinating with source system owners, day-to-day ETL progress monitoring,

Environment: Oracle 9i, SQL, PL/SQL, Unix, TOAD, ClearCase, Rational ClearQuest, MS Visio, Clear Case,Ms reporting Services 2000, Ms Visio, Ms Sql Server 2000

Confidential

Software Engineer

• Involved in design and development of data warehouse environment, liaison to business users and technical teams
• Gathered requirement specification documents and presenting and identifying data sources, targets and report generation.
• Developing Sql 2000 DTS packages based on requirement specifications.
• Worked as OLAP team member for creating cubes, dimensions in Sql Server 2000.
• Worked on MDX queries
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Involved production support and end to end testing.
• Worked on creating report using ProClarity tool and MS Sql Server 2000 reporting services.
• Provided technical assistance and support to IT analysts and business community.
• Developed automated web tool using ASP,VB script for loading data from different source system to Sql Server 2000

Environment: Oracle 9i, SQL, PL/SQL, Unix, TOAD, ClearCase, Rational ClearQuest, MS Visio, Clear Case,Ms reporting Services 2000, Ms Visio, Ms Sql Server 2000

Confidential

Software Engineer

• Involved in designing front end applications.
• Involved in gathering business requirements from different client directly.
• Wrote detail design specifications, attended user requirement sessions.
• Suggested Data Transformation on the Legacy data to suit the Business requirements.
• Prepared Detail design documents for the project as per the ETL standards, procedures and naming conventions.
• Designed and developed ETL Processes based on business rules using Sql Server 2000 DTS.
• Worked extensively on developing banking applications using VB 6.0
• Involved support and enhancing the existing legacy source system.
• Involved in system testing of overall Processes.
• Involved in Performance Tuning of TSQL code.
• Efficiently worked in optimizing the applications based on business needs
• Created test cases and test scenarios and documentation
• Created complex reports using Farpoint Reporting tool
• Involve in Deploying code and Production support

Environment: ClearCase, Rational ClearQuest, MS Visio, Clear Case,MS Sql Sever 2000,Farpoint reporting tool,Vb 6.0, ASP.