SUMMARY:

• Around 9+ yearsof Software experience in Client/Server Technologies and Internet applications of which 9.3 years in the Design, Development and Implementation of Data warehouse using Informatica and Oracle.
• Extensively worked on Informatica PowerCener Client versions 7.x, 8.x, 9.x including Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Admin console.
• Data Warehouse development working with Extraction/Transformation/Loading, using Informatica Power Center.
• Extensive experience in Extraction, Transformation, Loading data from various sources into Data Warehouses using Informatica Power Center 7.1.3, 8.6,9.x
• Implementation of ETL Strategy, which optimizes Mapping Performance.
• Experience of supporting existing data - warehousing systems and resolving production issues.
• Created ETL mappings using Informatica Power Center to move Data from multiple sources like XML, SQL server, Flat files, Oracle into a common target area such as Staging, Data Warehouse and Data Marts.
• Thorough understanding of Business Intelligence and Data Warehousing Concepts with emphasis on ETL.
• Good Analytical and Strong interpersonal and excellent communication skills.
• A Committed team player.
• Excellent communication and presentation skills.

AREAS OF EXPOSURE:

• Participate in weekly review meetings with the Business Analyst/Technical Program Manager to discuss project status, reports design and/or requirements in the client
• Understanding the technical & functional specifications.
• Designing, development, testing and troubleshooting of the applications.
• Providing post-implementation, enhancement and maintenance support to client for application.
• Analyzing user requirements in order to understand the problem and to suggest the alternatives available for a solution to them.
• Reviewing the alternatives available to pick the best solution and design a solution for it.

TECHNICAL EXPERIENCE:

ETL Tool: InformaticaPower Center7.1,8.1.6,9.5.1 and Data stage

Database: Oracle 9i,Teradata

BI Tools: BusinessObjects6.5,Cognos Reportnet, Dashboard Manager,OBIEE

Language: SQL, C, C++, HTML, XML.

Tools: SQL Tools, SQL Navigator, Toad, FileZilla.

Scheduling Tools: Tivoli, Control-M, Autosys

Domain Experience: Banking, Financial, Travel and Transport Vertical.

PROFESSIONAL EXPERIENCE:

Confidential, CA

Responsibilities:

• Gathered the requirement/s through MDR tool (Metadata Repository).
• Involved in Estimation of the project.
• 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, testing and mentoring.
• Involved in debugging the UNIX scripts according to the requirement.
• Developed mappings between source and target tables.
• Conducting code review sessions.
• Involved in Unit testing and integration testing.
• Preparing the LLD and carrying out impact analysis.
• Regular Communicating with the onsite team to get the requirements.
• Task Assignment to the team and responsible for updating daily status to the onsite team.

Technology: Informatica 8.6, LINUX, Autosys, Oracle, OBIEE.

Confidential, Los Angeles, CA

Responsibilities:

• Understand the business requirement specifications provided by the client and translate them into ETL design specification, and create mappings, sessions and workflows.
• Involved in Data Extraction from Oracle, Flat files, Mainframe files using Informatica.
• Developed various mappings to load data from various sources (Mainframe files, flat files, oracle) using different transformations like source qualifier, Normalizer, joiner, Aggregator, Lookup, Router, Update Strategy, filter and Expression to store the data in different target tables.
• 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, testing and mentoring.
• Involved in debugging the UNIX scripts according to the requirement.
• Developed mappings between source and target tables.
• Conducting code review sessions.
• Involved in Unit testing and integration testing.
• Preparing the LLD and carrying out impact analysis.
• Regular Communicating with the onsite team to get the requirements.
• Task Assignment to the team and responsible for updating daily status to the onsite team.

Technology: Informatica 8.6, LINUX, Autosys, Oracle.

Confidential, Los Angeles, CA

Responsibilities:

• Properties and names of ETL objects and UNIX scripts modified as per new standardization documents.
• Modified the server names and path names in the Unix script as per Linux standards.
• Removed the short cut definitions in ETL objects and modified the ETL objects without short cut definition.
• Involved in system integration testing and data validation.

Technology: Informatica 7.1.4 and 8.6, LINUX, TWS, Oracle.

Confidential, New York

Responsibilities:

• Worked on the source extracts as required for business on the source system (Omniture)
• Worked on the shell scripts to extract the data from the source system and load them accordingly.
• Worked extensively on the analysis of the data and transforming according to the business logic.
• Involved in developing mappings according to the business requirements received from the Strategic Business analysis team.
• Worked extensively on Teradata to analyze the data.
• 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, testing and mentoring.
• Participates in technical walkthroughs/ code reviews of other team member’s components, test plans and results and help them with gaps.

Technology: Informatica8.1.6/Business Object’s 6.5, Teradata, UNIX.

Confidential, Oaks, PA

Responsibilities:

• Requirement gathering from business owners or users.
• Understand and analyze the data sources, type of data and prepare a list of data elements.
• Generation of Functional Specifications and Technical documents.
• Design for implementation of the database.
• Worked on the Redesign of the TLM project for converting business specifications to technical specification individually.
• Worked on the compatibility of software’s for project set up.

Technology: Informatica8.X/informatica7.X, Business Object’s XI, SQL server and Oracle 10g,UNIX.

Confidential

Responsibilities:

• Extensively worked as a production support to resolve any issues in production
• Monitored the workflows, which are running in production on daily basis.
• Resolved performance issues that were raised in production.
• Assisted in Migrating Repository objects using Repository Manager between various environments.
• Exported universes to the repository to making resources available to the users.
• Daily monitoring the Broadcast Scheduler and performing action against reported issues.
• Scheduling reports on BCA, making changes to Universes through Designer tool of BO and promoting them to LIVE.
• Involved in making changes to Reports through BO reporting tool and Promoting them LIVE.

Technology: Informatica PowerCener 7.1.3, Business Objects 6.5, Oracle 9i, UNIX.

Confidential

ETL Developer

Responsibilities:

• Involved in developing of the ETL (Extract, Transformation and Load) strategy to populate the Data Warehouse from various source systems (Oracle), flat files feeds using Informatica.
• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets and Transformations.
• Used various Transformations like Source Qualifier, Joiner, Aggregator, Update Strategy, Expression, Sequence Generator and Filter for better data messaging and to migrate clean and consistent data.
• Created informatica mappings to build business rules to load the data into data warehouse.
• Created Mapplets and Reusable Transformations.
• Used the Workflow Manager to create Sessions.
• Involved in the unit testing to check the data consistency.
• Used InformaticaWorkflow Manager to create Sessions, Workflows to run with the logic embedded in the mappings

Technology: Informatica Power Center 7.1.3, Business Objects 6.5, Oracle 9i, UNIX.

Confidential

Responsibilities:

• Responsible for Extracting, Transforming and Loading data from Flat files and ORACLE files and placing it into Data warehouse.
• Used various transformations like Source Qualifier, Filter, Aggregator, Expression, Lookup, Sequence Generator, Joiner and update Strategy to create mappings.
• Created Mapplets and Reusable Transformations.
• Created and developed a series of mappings for handling different cases of input data in the same source table.
• Tuned and tested the mappings to perform better using different logics to provide maximum efficiency.
• Used the Workflow Manager to create Sessions.
• Involved in the unit testing to check the data consistency.
• Used InformaticaWorkflow Manager to create Sessions, Workflows to run with the logic embedded in the mappings

Technology: Informatica Power Center 7.1.3, Business Objects 6.5, Oracle 9i, UNIX.