SUMMARY:

• 7+ Years of IT experience in Data Warehousing & RDBMS with in-depth knowledge on operational and reporting environments in all phases including design, development and implementation of enterprise data warehouse.
• 6 Years of experience in ETL using Informatica Power Center & Power Mart including installation and configuration in Client/Server environment.
• Extensively worked on creating Mappings, Transformations, Sessions, Workflows and, worklets to extract data from various sources and load into targets using Informatica Power Center 8.1.1/7.1/6.2.1/5.1
• Experienced in performance tuning of mappings, sessions and workflows including partitioning using Informatica Power Center 8.1.1/7.1/6.2.1/5.1
• Well versed with Dimensional modeling to Design and develop Star/Snowflake schemas using Erwin data modeling tool.
• Worked on various databases like Teradata V2R6, Oracle Versions 10g/9i/8i/7.x, MS SQL SERVER 2000 on various operating systems like UNIX and Windows XP/NT.
• Involved in designing Universe, generating ad hoc and canned reports using different data providers like Universe, Stored Procedures and Free Hand SQL using Business Objects Reporter.
• Experience with data cleansing issues and Meta Data Management in the implementation of ETL methodology in Data Extraction, Transformation and Loading using Informatica Power Center 8.1.1/7.1/6.2.1/5.1.
• Proficient in all phases of the Systems Development Lifecycle - Analysis, Design and Modeling, System Implementation, System Testing, Acceptance and Maintenance.
• Involved in functional and technical Systems Analysis & Design, Systems architectural design, Presentation, process data flow design system impact analysis, star schema, snowflake, changing dimension, Gap analysis and documentation.
• Expertise in the QA process of ETL mappings like unit, Functional and Integration testing.
• Experience in interacting with Business Users to analyze the business process and requirements, writing Business Requirement Documents, Technical Specifications, Data Modeling and drawing up the Process Flow Charts, DFDs, and ERDs
• Proficient in coding UNIX shell scripts using AWK / SED on UNIX, Red Hat Enterprise Linux Environment. (Versions RHEL 3.1 and 4.1)
• An excellent team player with an ability to perform individually, good interpersonal relations, strong communicational skills, hardworking and high level of motivation. A quick learner with an aptitude for taking responsibilities.

TECHNICAL SKILLS:

OLAP Tools: Siebel Analytics 7.8.2/7.7.1/7.5.2, OBIEE 10.1.3.4, Hyperion Essbase 9.3.1
ETL Tools: Informatica Power Center 8.2/7.1/5.1, Informatica PowerMart 5.0/4.7
Databases: Oracle 10g/9i/8i/7.3, MS SQL Server 2000/2005, MS Access, Teradata
Data Modeling: MS Visio, Erwin.
Languages: C, C++, Java, VB, SQL, PL/SQL, Java Script, VB Script
CRM Siebel 7.7/7.5.2/7.0.3, Siebel Tools
Operating Systems: Windows XP/00/NT/98/95, Linux, UNIX (Solaris)
Packages: SQL* PLUS, Query Analyzer
Utilities: Toad, SQL * Loader

PROFESSIONAL EXPERIENCE:

Client: Confidential, GA Sep'08 to Present
Role: Sr Informatica Developer

Project Description:
Confidential, is the third largest cable television provider in United States. It offers region of the country digital cable television and telecommunication services. Data warehouse was built to support Business Executives to take quick decisions regarding, market study for the existing policies, release of new policies and to analyze cash flows, treasury and customer data. The data is obtained from various sources like flat files, relational databases and loaded into target database using Informatica.

Responsibilities:

• Interacted actively with Business Analysts, Data Modelers and report developers on Mapping documents and Design process for various Sources and Targets.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Extracted data from wide variety of data Sources like Flat files, Relational Databases (Oracle, SQL Server).
• Designed Data transformation from Transient to Staging, Fact and Dimension Tables in the Warehouse.
• Used version mapping to update a slowly changing dimension table to keep full history.
• Used transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure and update strategy to meet business logic in the mappings.
• Worked extensively on schema (Star schema) creations in data warehouse.
• Created sessions and batches for incremental load into staging tables and schedule them to run daily.
• Implemented SCD Type1 and SCD Type2 methodologies in ODS tables loading, to keep historical data in data warehouse.
• Extensively worked on creating the new set of composite primary keys on ODS tables to handle Type2 changes efficiently.
• Developed various Mappings with the collection of Sources, Transformations, and Targets, using Designer.
• Created mappings to load data mart tables like Dimensions and Fact tables.
• Implemented unconnected lookups in ETL mappings to create foreign key relationship between Dimensions and Fact tables.
• Extensively worked on Performance tuning to increase the throughput of the data load (like read the data from flat file & write the data into target flat files to identify the bottlenecks).
• Extensively worked on SQL tuning process to increase the source qualifier throughput by analyzing the queries with explain plan, creating new indexes, partitions and Materialized views.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger.
• Involved in database testing, writing complex SQL queries to verify the transactions and business logic like identifying the duplicate rows.
• Created and tested AppWorx scripts to automate Job scheduling.
• Created Workflow, Work let, Assignment, Decision, Event Wait and Raise and Email Task, scheduled Task and Workflow based on Client requirement.
• Used Update Strategy to effectively migrate data from source system to target Database.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Create, monitor and troubleshoot batches and sessions for daily extracts.
• Developed, executed Test Plans and Test Cases to validate and check Referential integrity of data extracts before loading it to Data Warehouse.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g, OBIEE 10.1.3.4, PL/SQL, SQL*Plus, XML, PL/SQL Developer, Erwin 4.2, Windows 2003

Client: Confidential, OH Mar'08 to Aug'08
Role: Sr Informatica Developer

Project Description:
Confidential, is one of the largest auto insurers in the United States, it primarily offers its services through the Internet, phone and private Insurance agents. The project involved extracting data from the different sources and loading into data Mart. The data mart has been designed using Erwin adopting Star Schema methodology. Models are created based on the dimensions, levels and measures required for analysis. It enables an insight in to the current and future customer service and helps in making business decisions based on the reports generated from data warehouse.

Responsibilities:

• Extracted data from wide variety of data Sources like Legacy Systems (Mainframe), Flat files, Relational Databases (Teradata and Oracle) and Heterogeneous sources.
• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets.
• Extensively worked on ETL performance tuning for tune the data load, worked with DBAs for SQL query tuning etc.
• Extensively developed various Mappings which perform Extraction, Transformation and Loading of Source data into the OLAP Schema, and used different Transformations like Source Qualifier, Expression, Lookup, Update Strategy, Aggregator, Stored Procedure, Filter, Router, Joiner, Normalizer, etc
• Extensively used Re-usable Objects like Mapplets and Transformations in the Mappings.
• Changed the logic from PERL scripting to Informatica code.
• Data Loaded into different Targets like Flat Files and Relational Databases (ORACLE).
• Tested all Mappings, Sessions and Workflows for Data accuracy.
• Backend testing (Oracle 9i), writing complex SQL queries to verify the transactions and business logic.
• Extensively developed Oracle PL/SQL stored procedures to implement different business logics.
• Created and tested UNIX shell scripts to automate.
• Validated Informatica processes to check the data is populated correctly.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Created Worklets, Workflow and Tasks to schedule the loads at required frequency using Workflow Manager.
• Designed and developed Informatica mappings for data loads and data cleansing. Extensively worked on Informatica Designer.
• Extensively used almost all of the transformations of Informatica including lookups, Stored Procedures, Update Strategy and others.
• Tested data integrity among various sources and targets. Associated with Production support team in various performances related issues.

Environment: Informatica PowerCenter 8.1, Oracle 10g/9i,Teradata, PL/SQL, SQL*Plus, XML, TOAD,PL/SQL Developer, Erwin 4.1, Windows 2003

Client: Confidential, Stamford, CT Apr'07 to Feb'08
Role: Informatica Developer

Project Description:
Confidential, is a wholly owned subsidiary of G.E that is into Funds management and Portfolio management business. GE-Asset Management is in the business of managing assets. At first, it used to manage only their employee pension and other benefits (assets). Today GEAM is a registered investment advisor with offices in the U.S, Canada, Europe and Japan. Usually they invest money in U.S equity, International Equity, Fixed Income, Real estate, Private Equity etc.

Responsibilities:

• Involved in requirements gathering and translation of Business processes into Informatica mappings.
• Extraction and loading of data from various sources like Flat files, Oracle, Mainframe to Oracle database using Informatica mappings.
• Developed various simple to complex mappings using transformations such as Aggregator, Expression, Lookup, Filter, Router, Rank, Sequence Generator, Update Strategy using Informatica.
• Enhanced the performance of SQL statements, Mappings by identifying bottlenecks and used Informatica debugger to eliminate them.
• Involved in writing the PL/SQL Packages, Stored Procedures, Functions to accomplish the business rules and tuning the SQL queries using Explain plan in Toad
• Involved in writing the shell scripts to automate the execution of sessions and scheduled the jobs using Informatica Scheduler.
• Used Toad extensively to debug, test SQL and PL/SQL scripts, procedures, functions, triggers.
• Created automatic scripts to create views for objects in an external Database and validated.
• Involved in maintaining Reporting database by extracting data for report developers.
• Worked on moving mappings from Development to Test and from Test to Production environments.
• Involved in testing at various levels, unit, performance and Integration.

Environment: Informatica 7.1, Oracle 9i, Rapid SQL, TOAD,WSFTP, MVS, Business Objects 6.5, APPWORX TOOL, Autosys and Exceed.

Confidential, Oakland, CA Oct '06 - Mar '07
Role: Informatica Developer
Confidential, is a company specializing in financial services, credit cards etc. A third party vendor called Total Access maintains the data of Providian. Efforts are on from the Providian side, to build its own Data warehouse from the Oracle database being maintained by Total Access. Especially the aim is to build two different types of data warehouses, EDW and OIS, while the latter maintains data for 6 months, the former maintains all the history spanning over several years. The ETL process involved extracting the data from DB2 mainframe as source, with the target data warehouse being in Oracle.
Responsibilities:

• Designed ETL processes using Informatica to load data from Flat Files, and Excel files to target Oracle Data Warehouse database.
• Performed data manipulations using various Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, and Sequence Generator, Stored Procedure etc.
• Used SQL overrides in source Qualifier to meet business requirements.
• Written pre session and post session scripts in mappings. Created sessions and workflows for designed mappings. Redesigned some of the existing mappings in the system to meet new functionality.
• Created and used different tasks like command and email tasks for session status.
• Used Workflow Manager to create Sessions and scheduled them to run at specified time with required frequency.
• Monitored and configured the sessions that are running, scheduled, completed and failed.
• Involved in writing UNIX shell scripts for Informatica ETL tool to fire off services and sessions.
• Migrated mappings from Development to Test and from Test to Production environments.

Environment: Informatica Power Center 7.1.1, Oracle 9i, PL/SQL, SQL*Plus, Toad 8.0,UNIX, Windows NT/2000

Client: Confidential, India Jan'05 to Sep'06
Role: Informatica Developer

Project Description:
This data warehouse was developed to aid and assist the management committee in making various decisions regarding a customer. The database is maintained in Oracle. Star schema was used in the design process and Erwin was the data-modeling tool utilized to present the facts. Data Mart was built to do customer-rating analysis, to monitor the various shopping trends of the customer (this data was used to detect a pattern), Track & Record updates.

Responsibilities:

• Understanding source systems and customer requirements.
• Designed and Developed Complex Update Strategy, aggregator, Joiner, lookup Transformations that are used in mapping.
• Creation and Modification of Reusable Transformations, Mapplets.
• Analyzing the Issue if any in flat file and Communicate with concerned person to resolve issue.
• Created Sessions, Database connections and Workflows using Informatica Workflow Manager.
• Knowledge of different Schemas (Star and Snow Flake) to fit reporting, query and business analysis
• Have working knowledge of Web Technologies including Java and HTML.
• Excellent communication, interpersonal and analytical skills
• Quick learner and adaptive to new and challenging technological environments

Environment: Informatica PowerCenter 6.1), Oracle 8i, Flat Files, Erwin, SQL, PL/SQL, Windows 2000/NT

Client: Confidential, India May'03 to Dec'04
Role: Informatica Developer

Project Description:
Confidential, has been in business since 1980. Like every electronics based company, the company is searching for business enhancements and competitive edge. Client wants to have some system, which can give him/her intelligent information and reports regarding his existing business situation and how he/she can analyze specific business areas. According to the client requirement this data warehouse is developed to meet the requirement and help him/her to take appropriate decision to success.

Responsibilities:

• Prepared Transformation Specifications for each and every mapping.
• ETL Implementation for designing.
• Extensively used Informatica to load data from different data sources into the oracle data warehouse.
• Imported Sources and Targets to create Mappings and developed Transformations using Designer.
• Created mappings and transformations using joiner, expression, aggregator, filter, router, sorter, sequence generator, update strategy and lookup.
• Implemented performance tuning in oracle queries by using different techniques like using hints, parallel processing, and optimization rules.
• Good experience with performance tuning in oracle using indexes like bitmap and B tree indexes.
• Possess expertise with relational database concepts, stored procedures, functions, triggers and scalability analysis.
• Created the sessions and workflows.
• Monitoring the workflows using Workflow Monitor.
• Preparing test cases for unit test.
• Performed Unit testing with the UTP.
• Raised the required requests to migrate the code from different environments and providing the required documentation and DB scripts to the concerned teams
• Was always available & accessible to team members in understanding the warehouse and for technical issues.

Environment: Informatica Power Center 6.1.2, Oracle 8i, SQL, PL/SQL, Toad & UNIX.

Client: Confidential, India May'02 to Mar'03
Role: Informatica Developer

Project Description:
The application provides business intelligence analysis services to client sales department on cost margin performance metrics through interactive client to­­­ols. Data from various OLTP sources is selectively extracted, related and transformed and loaded into Oracle Warehouse.

Responsibilities:

• Involved in the team meeting for understanding the business requirements.
• Involved in the creation of DDL and DML scripts for all stage and target tables.
• Developed the mappings for staging tables using Informatica to load data from different sources.
• Created transformations and Performed data cleansing using various features of Informatica.
• Worked with Informatica Designer to develop mappings using Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expression, Aggregator and Sequence Generator transformations.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
• Created reusable transformations and used in different mappings.
• Created sessions and workflows using Workflow Manager.
• Performed Data Validation and Unit testing by preparing Unit test cases.

Environment: Informatica Power Mart 5.1, Cognos 5, Oracle 8i, SQL, PL/SQL, Toad and Unix