SUMMARY:

• Eight plus years of experience in Software Development including ETL processing in OLTP and OLAP systems and enhancement of business operations through various technologies.
• Seven plus years Extensive Experience in ETL and data integration experience in developing ETL mappings and scripts using Informatica Power Center with client tools like Designer (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer), Repository Manager, Workflow Manager and Workflow Monitor.
• Experience in all the phases of Data warehouse life cycle involving Requirement gathering, Implementation & Design, Development, Testing and Deployment.
• Hands on expertise in Data Research, Profiling, Analysis, Automated Integrations, designed and developed end to end solutions using various data tools.
• Strong knowledge of Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Schema Modeling, FACT and Dimensions Tables.
• Knowledge base inETL process handling with end to end integrations, Migrations and Conversions from various sources to target applications including Oracle, MySQL and SQL server.
• Expertise in Business Processes and Entities in the areas ofHR,Financial, Banking, Telecommunications, Insurance, Pharmaceutical, Supply Chain Consumer Products, Mobile Devices and Services.
• Hands on experience in understanding Legacy Systems like CRM, SAP Systems, JD Edwards, PeopleSoft, Oracle applications, Salesforce.com and XML files.
• Excellent understanding of Business Entities involving Account, Contact, Quotes, Order, Product, Asset, Pricing, Sales, Service Request, Opportunity, Activity, Agreements, Entitlements, Campaign Management.
• RDBMS Data coding with Oracle, MS-SQL Server and MYSQL Programming in SQL, PLSQL and UNIX Shell Scripts.
• Exposure to Large Scale Data Integration and Performance Tuning.
• Versatile team player with excellent communication, inter personal skills and highly self-motivated.

EDUCATION

• Post Graduate Diploma in Computer Science
• Master in Commerce

Skill Set

• ETL: Informatica 9.1/8.6/8.2/8.1/7.X, (Source Analyzer, Informatica Power Mart 6.2/5.1/4.7,Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, and Informatica server, Power Analyzer), Informatica Power Exchange, Metadata, Datamart, OLAP, OLTP
• Data Analysis: Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis.
• RDBMS: Oracle 9/10g/11g, MS SQL Server 2000/7/6.5, DB2 and MY SQL, TOAD
• Reporting/Testing: SAP Business Objects XI3, Crystal reports, Actuate, Win Runner, Load Runner
• Legacy Systems: SAP SD, HR, MM, JD Edwards, PeopleSoft, Oracle applications, MIDAS and Salesforce.com
• Scripts: eScript, Siebel VB, JavaScript, VB Script & PERL script
• Languages/Web: C, Java, Visual basic, ASP, PL/SQL, XML
• Environment: Linux, IBM AIX 4.2/4.3, OS/390, MS-DOS 6.22, Win 3.x/95/98, Win NT 4.0, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX - Mobile Solutions March 2011 - Till Date
ETL Developer
Nokia Mobile and Solutions implementing third party vendor integration into SAP MM and SD systems as part of the OASAS 2.0 and OASAS 3.0 release. Major part of the development is to automate the process and transform the source data into Oracle Data warehousing BI systems and SAP requirements.

• Requirement Gathering, Data analysis and Gap analysis of Vendor, Device and Content information
• Worked on the ETL mappings, analysis and documentation of OLAP Business Objects reports requirements
• Developed mappings, sessions and workflows in Informatica Power Center.
• Worked with heterogeneous source system to Extracted data fromOracle database, XMLand flat files and loaded to a relational Oracle warehouse.
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
• Trouble shooting of long running sessions and fixing the issues.
• Worked withVariables and Parametersin the mappings to pass the values between sessions.
• Involved in the development of PL/SQL stored procedures and functions to process business data.
• Worked with the testing team to resolve bugs related to ETL mappings that our team created.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Creating the weekly project status reports, tracking the progress of tasks according to schedule and reporting any risks and contingency plan to management and business users.
• Involved in meetings with production team for issues related to Deployment, maintenance, future enhancements, backup and crisis management of DW.
• Used IBM Tivoli to track and create Tasks and change requests as part of the production support.
• Technical Documentation and Knowledge transfer.

Tools: Informatica 9.1/8.6 | Oracle 10g/11G | Pl/SQL | Toad | UNIX | Visio | IBM Tivoli | WINSCP | SAP SD and MM Modules

Confidential, (Irving, TX) -- Enterprise Solutions April 2010 - Feb 2011
ETL Developer and Migration Consultant
Confidential, converted its existing PeopleSoft CRM platform to Siebel CRM. I Was part of the ETL team involved in understanding the legacy system and Target system to create Informatica Mappings and Migrate data into Siebel proprietary Enterprise Integration Tables.

• Data Analysis of PeopleSoft and Conversion Design for more than 13 major entities.
• Successful Migration of Legacy data to Siebel within given time frame using Informatica Mappings
• ETL Design for batch and real time updates to Siebel EIM tables
• Informatica transformations to integrate various legacy daily updates to Assets, Orders and RMA.
• Developed 15+ Batch integrations (both inbound and outbound) to support eService application.
• Worked withVariables and Parametersin the mappings to pass the values between sessions.
• Used Workflow Managerto create connections,sessions, tasks, workflows and createdEmail,Event wait, Event Raise, Timer and Control Eventsin a single master workflow according to the business requirements.
• Used Toad to debug the SQL queries to identify duplicate rows in the warehouse tables, and to debug SQL queries issued during report execution.
• Closely interacted with the testing team to resolve bugs.
• Created Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Performance tuning of targets, sources, mappings, and sessions.
• Implementation of slowly changing dimensions to accommodate OLTP, OLAP and BW environments
• Creating/building and running/scheduling workflows using the Workflow Manager.
• Created Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Event Wait, Event Raise, Timer etc).
• End to end data testing comparing both metadata conversion transformations and data transformations.
• Documentation and Knowledge transfer to Offsite team.

Tools: Informatica 7.x/8.2 | Oracle 9/10g | Pl/SQL | Toad | UNIX | Visio | IBM Tivoli | WINSCP | PeopleSoft | Siebel CRM

Confidential,(Jersey City, NJ) June 2009 - March 2010
Informatica Developer
Confidential, implemented enterprise data warehouse project with consolidation of data from North America, EMEA and APAC data centers, worked on various ETL requirements from heterogeneous sources and target systems.

• Involved in all the phases of project (gathering requirements, preparation of detail design, development, testing and production support).
• Partnered with the Information Architect to translate the Dimensional Data Model to the ETL Code (mapping, mapplets, workflows) using the Informatica Power Center and optimize ETL data load jobs to improve performance.
• Identified ETL specifications based on Business Requirements/Mapping Document.
• Extracted source data fromOracle database, XMLand flat files and loaded to a relational Oracle warehouse.
• Worked withVariables and Parametersin the mappings to pass the values between sessions.
• Used Workflow Managerto create connections,sessions, tasks, workflows and createdEvent wait, Event Raise, Timer and Control Eventsin a single master workflow according to the business requirements.
• Involved in performance tuning of targets, sources, mappings, and sessions.
• Implemented slowly changing dimensions both (Type 1 and Type 2).
• Creating/building and running/scheduling workflows and worklets using the Workflow Manager.
• Interacted with Business Users for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Worked with BI team to Develop Reports / Dashboards with different Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBIEE Web.
• Performed tuning of SQL queries for speedy extraction of data to resolve and troubleshoot production Issues.
• Involved in the development of PL/SQL stored procedures and functions to process business data.
• Used Toad to debug the SQL queries to identify duplicate rows in the warehouse tables, and to debug SQL queries issued during report execution.
• Closely interacted with the testing team to resolve bugs.
• Co-ordinate with onshore and offshore development team to implement the project.
• Involved in meetings with production team for issues related to maintenance, future enhancements, backup and crisis management of DW.
• Used UNIX shell scripts to automate repetitive database processes, file transfers and job scheduling.

Tools: Informatica 7.x/8.1 | Oracle 9/10g | MS SQL Server | XML | Pl/SQL | Toad | UNIX | Visio | IBM Tivoli | WINSCP

Confidential - Data Conversion and Interfaces August 2008 - May 2009
Informatica Developer
Confidential, Data Conversion is one of the largest implementation in North America to convert their MIDAS system into Data warehousing and ERP/CRM systems. Was part of the data team from the initial stages of the project till the end of the final production release

• Involved in all the phases of project (gathering requirements, preparation of detail design, development, testing and production support).
• Partnered with the Information Architect to translate the Dimensional Data Model to the ETL Code (mapping, mapplets, workflows)
• Identified ETL specifications based on Business Requirements/Mapping Document.
• Extracted source data fromOracle database, XMLand flat files and loaded to a relational Oracle warehouse.
• Worked withVariables and Parametersin the mappings to pass the values between sessions.
• Informatica Power Center and optimize ETL data load jobs to improve performance.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, Union, Rank, Normalizer, Update strategy and Router transformations for populating target table in efficient manner.
• Implemented slowly changing dimension Type 1 and Type 2 forChange data captureusing Version control.
• Involved in Creation of SQL, Packages, Functions, Procedures, Views, and Database Triggers.
• Expertise in configuration, performance tuning, installation of Informatica, & in integration of various data sources like Oracle, MS SQL Server, XML, Flat files into the staging area and Design ETL processes that span multiple projects
• Involved in writing the SQL procedures used SQL Server DTS to improve the warehouse loading.
• Designed and Developed ODS to Data Mart Mappings/Sessions/Workflows.

Tools: Informatica 7.x/8.1 | Oracle 9/10g | MS SQL Server | XML | Pl/SQL | Toad | UNIX | Visio | IBM Tivoli | WINSCP | Siebel CRM

Confidential, (Los Angeles, CA) Feb 2007 - June 2008
Informatica Developer
Farmers Insurance Group of Companies is the country\'s third-largest writer of both private passenger automobile and homeowners insurance. Farmers Insurance Group of Companies operates in 41 states across the country and is responsible for servicing more than 15 million customers. Farmers Group, Inc., is a provider of insurance management services and its key products are Auto, Homeowners, Life, Business, Specialty, and Financial Insurance.

Responsibilities:

• Developed mappings to populate Reference data tables or VVT's (Valid Value Tables) which provide codes and descriptions for dimension tables in the database. The VVT's are used to match codes with descriptions and provide a set of valid values for other attributes in the database.
• Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations.
• Implemented efficient and effective performance tuning procedures
• Fixed invalid Mapping's, tested Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Workflows and Target Data.
• Used Debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Created Sessions, reusable Worklets in Workflow Manager and scheduled the sessions to run at a specified frequency.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
• Worked on UNIX shell scripts. Developed UNIX shell scripts to run the pmcmd functionality to start and stop sessions.

Tools: Informatica 7.x | Oracle 9| DB2 | Pl/SQL | Toad | UNIX | Flat Files

Confidential, (NYC,NY) April 2005 - Dec 2006
ETL Developer
Confidential, Companies in NY implemented ICS project (International Central System) to accommodate all their customer information into one centralized system. Major contributions include requirement and metadata gathering and ETL integration using Informatica tool.

• Business Analysis and user requirements collection.
• Analyzing the data model and identification of heterogeneous data sources.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and databases.
• Configured Informatica Repository Manager to create user groups and user profiles.
• Granted administrator rights and assigned security & privileges to user groups.
• Designed & executed SQL, PL/SQL, stored procedures, triggers according to need of database environment.
• Involved in DAC - creating, configuring, executing and monitoring modular data warehouse applications in a parallel, high - performing environment.
• Deployed Informatica tools - Power Center, Workflow Manager and Workflow Monitor.
• Utilized the Mapping Designer tools - Source Analyzer and Warehouse Designer to create and/or import the source and target database schemas.
• Used the Mapping Designer to map the sources to the target and to create the various transformations.

Tools: Informatica 7.x | SQL Server | SQL | UNIX | Flat Files

Confidential, (India) March 2003 - Dec 2004
ASP/.Net/Reports
Confidential, implement projects related to Content Management and Data Reports projects. Worked with Onsite clients in USA to understand their requirement and generate reports in MS Access and Excel. Technologies used were custom ad-hoc scripts. ASP and .Net were also used as part of the client server projects implemented.

• Ad-hoc reports using custom scripts and MS-Access database
• Client server programming using ASP and ,Net technologies
• Support for onsite and offsite clients
• Software training and e-learning projects for new clients and exiting partners