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 in ETL 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 of HR, 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 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) -- April 2010 – Feb 2011
ETL Developer and Migration Consultant
Ericson 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
Johnson-n-Johnson 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