SUMMARY

• Over 8 years of experience in IT industry in Design, Analysis and Development of software applications and Implementation of Data warehousing using ETL tools Informatica, Datastage with Oracle, Teradata databases on Windows & UNIX platforms.
• Expert in understanding of Data Warehousing Methodology and Software Development Life Cycle (SDLC).
• Extensively worked on creating Mappings, Transformations, Sessions, Workflows and worklets to extract data from various sources and load into targets using Informatica Power Center.
• Expertise in implementing complex Business rules by creating Mappings, Mapplets and
• Reusable objects from varied transformations like lookups, Router, Filter, Expression, Aggregator, Sorter and Update Strategy.
• Extensive experience in working with databases (Oracle 8i/9i/10g/11g and Teradata).
• Experience in using parameter files, mapping parameters, mapping variables and session variables.
• Experience in Data Modeling and preparing Star schemas and Snowflake schemas.
• Experience in performance tuning of mappings, sessions and workflows using Informatica Power Center.
• Expertise in design and implementation of SCD - slowly changing dimensions types (1, 2 and 3).
• Strong experience in writing complex queries in SQL and creating stored procedures (PLSQL).
• Experience in using Autosys scheduling tool to organize and schedule jobs.
• Experience using Erwin as a data modeler.
• Knowledge of using Debugger in mapping environment.
• Proficient with Siebel Tools and Client in configuration and customization of Siebel Objects at multiple levels.
• Proficient with Siebel EIM and creating data mapping.
• Self-Starter, Detail Oriented and Quick Learner of new applications and technologies.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Good Understanding of Programming languages(C, C++, JAVA...etc.).

TECHNICAL SKILLS

• Informatica Power Center 9.1/8.6/7.1
• Datastage
• Autosys
• Oracle 9i/8.x
• DB2
• Teradata
• Windows XP/95/98/NT/2000
• Erwin
• Unix
• C C++
• JAVA
• SQL
• PL/SQL
• Siebel Analytics (OBIEE 10g)
• Siebel 7.8/8.1
• Siebel Tools
• Siebel call center

PROFESSIONAL EXPERIENCE

Confidential, Rahway, NJ

ETL Informatica Developer/DW Developer

Responsibilities:

• The Data Mart collects Data from Numerous healthcare facilities in varying formats and thenStandardize the data into a common format.
• Involved in data analyzing building the ETL architecture
• Created and analyzed facts, dimensions and star schema representations for the Sales and Marketing Data Mart.
• Extensively used Erwin to generate logical and physical data models.
• Create and review the source-target mappings, ETL development, tunings and optimization, unit testing and integration testing.
• Write the shell script to format/cleanup/validate the incoming text file.
• Define extract and load scripts and create maplets and reusable transformation.
• Write the meeting minutes.
• Developed mapping specifications on Excel sheets based on the Business Requirement Analysis
• Developed Documentation for all the routines (Mappings, Sessions and Workflows)
• Extensively used Informatica Designer to create and manipulate source definitions, target definitions, mappings, Maplets, transformations, re-usable transformations.
• Created mappings to load data from source to staging, and staging to ODS (Operational Data Sources)
• Implemented complex logic using some transformations such as Joiner, Source Qualifier, Expression, Filter, Router, Union, Look-up.

Environment: Informatica Power Center 7.1/8.6, Workflow Manager, PL/SQL Developer, Oracle 9i, Teradata, Flat Files, Windows 2000, XP.

Confidential, Woodland Hills, CA

ETL Informatica Developer/Lead

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Reviewed and analysed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed one time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.

Environment: Informatica Power Center 9.1, Oracle10g, DB2, UNIX Shell scripts, SQL, PL/SQL.

Confidential, Pleasanton, CA

ETL Informatica Developer

Responsibilities:

• Designed and implemented type II slowly changing dimension.
• Worked with iterative and incremental model of development cycle.
• Extensively worked in data Extraction, Transformation and loading from source to target system.
• Did error handling and performance tuning in Teradata queries and utilities.
• Designed a workflow to load data from multiple flat files using list file load concept.
• Configured sessions, setup workflow and tasks to schedule data loads at desired frequency.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager with changing requirements.
• Provided resolution to issues by correcting and validating specification changes.
• Modified existing mappings for enhancements of new requirements.
• Involved in Creation of RPD.
• Developed dashboards and dashboard pages.
• Designed Created and Tested Report in the Dashboard and created the adhoc report according to the client needs.
• Expertise in Building Metadata Model (.rpd), Building Physical layer, Business Model and Mapping layer, Presentation layer using OBIEE tool along with development of dynamic and interactive Dashboards.
• Experience in configuring Interactive Dashboards with drill-down capabilities using global and local Filters, OBIEE Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Prepared validation scripts for user acceptance testing.

Environment: Informatica Power Center 8.6/7.1, Oracle 10g/9i, SQL Server 2005, Toad 9.1,Teradata, Flat Files, Windows NT, UNIX, OBIEE 10.1.3.4

Confidential

Systems Engineer /ETL Developer

Responsibilities

• Worked on running the existing workflows in Data stage
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards to create a Technical Design Document.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files into staging area and populated onto Data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, and Stored Procedure to develop robust mappings in the Informatica Designer.
• Worked with loading data into Siebel using EIM(Enterprise Integration Manager) processes.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document for admin team to move the mappings from development to testing and then to production repositories.
• Worked on developing integration objects for inbound and outbound web services and also worked on configuration of applets, views, screens and customizing business objects, business components.
• Worked on creating Unit Testing scripts and performed Unit Testing.
• Worked to monitor regular batch jobs and data loads and perform regular support activities.
• Worked with maintenance team to resolve and do major bug fixes in Informatica.
• Used relational SQL wherever possible to minimize the data transfer over the network.
• Worked on writing Stored Procedures PLSQL.

Environment: Informatica Power Center 8.6, PL/SQL, Oracle 10g/9i, Teradata, Erwin, Autosys, SQL Server 2005, Toad 9.0,WINDOWS XP,NT, Windows 7, HP Service Center, Siebel Tools, Siebel Client 7.1/8, OBIEE 10.1