EXPERIENCE SUMMARY:

• Expert Informaticaand SAP Business Objects Developer with hands - on experience with DB2,Oracle,JDE, SQL Server, MDM, Netezza& Mainframe
• 9 Years of IT industry experience including analysis, design, development, testing, and defect tracking of Data Warehouse, ODS, OLTP.
• Highly proficient in ETL using Informatica Power Center 7.1,7.5,8.5, 9.1, 9.5 and reporting using SAP Business Objects XI R2, 3.1 & 4.0,Xcelsius, Cognos Impromptu 5.0.
• Domain Experience: Diversified experience in multiple domains likeOil & Gas, Manufacturing, Insurance,Federal, Finance, and Pharmaceutical.
• SAP Business Objectsand Xcelsius: 3+ years of SAP Business Objects 4.0/XIR3/XIR2 experience in Central Management Console, Central Configuration Manager, Designer, Web Intelligence, Desktop Intelligence, OLAP Intelligence, Import Wizard, Infoview, Dashboard Manager, and Scorecards.
• Xcelsius 2008/4.5 and Xcelsius Data Visualization Live Office, QAAWS, Import Wizard, and Report Conversion Tool and Services. Building dashboards against various data sources including Live Office, Oracle, DB2, SQL Server etc.
• Hands-on knowledge of Data warehousing and OLAP, reporting tools, methodologies, 3NF & Dimensional modeling, MDM, Data cleansing technologies (IDQ), testing strategies.
• Expertise in Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, and Dimension Data Modeling using Erwin, Microsoft Visio.
• Participate in Agile team activities including daily standups, sprint planning, PSI planning, product demos, etc.
• Involved in all aspects of ETL from requirement gathering, analysis, designing, documentation, development, testing, defect analysis and deployment.
• Experience in performance tuning of Informatica mappings, and sql query tuning.
• Implemented Code generators that generate the code for PL-SQL procedures and functions in the DW load process.
• Developed and Implemented many generic ETL routines using PL/SQL that are widely used in the entire Data Warehouse processes (loading, balancing and Data Quality).
• Experience in UNIX environment as working with (korn) Shell Scripts to automate file manipulation and data loading procedures.
• Experience in scheduling the Informatica workflows using Cntrl-M, Informatica Scheduler and ESP.
• Working with databases like IBM UDB DB2, Oracle, MS SQL Server, Netezza and JDE.
• Experienced in estimation, planning, Risk Management, finalization of technical / functional specifications, communication management and quality management of the product.
• Experienced in dealing with outsourced technical resources and coordinating global development efforts.
• Very strong Academic and Professional experience in the related area, Demonstrated accomplishments in analyzing problems, involved in developing and implementing standards and best practices.

TECHNICAL SKILLS:

Operating System: Windows 2000, Windows XP/NT 4.0/98/95, Novell NetWare 3/4, SUN Solaris 2.6/8, HP-UX 10.x/11, SCO UNIX and DOS

Languages: C, SQL, SQL*PLUS, PL/SQL, Shell Programming, COBOL.

RDBMS and Tools: Oracle 11g/10g/9i/8i/7.x, Developer/2000 (Forms6i/4.5/5/3.0, Reports (6i/3.0/2.5), SQL*Loader

ETL, OLAP Tools: InformaticaPowerCenter 6.1/7.1/8.5/9.1 , 9.5 Power Exchange, Business Objects XI R2,3.1,4.0,Xcelsius, Oracle, and Cognos Impromptu5.0, RUMBA, Transformer6.5, Power Play 6.5

Packages/Tool: DVO,DataFlux, Spoon, SAP Information Steward, MDM, IDQ 8.6, Erwin 4.2/4.0/3.5.5/3.5.2 , MS Office and Crystal Reports 6.

WORK EXPERIENCE:

Confidential, TX

ETL Lead

Technology: Informatica Power Center.

Environment: InformaticaPowerCenter 9.5, DVO,JDE, Oracle, SQL server,MDM,UNIX shell scripting.

Responsibilities:

• Working with customer and technical resources to address business information and application needs.
• Interact with the Application users to get a brief knowledge of business logics.
• Giving estimates to customer and application users.
• Involve in Data validating, Bug Fix,determining the bottlenecks and fixing the bottlenecks.
• Conduct code walkthroughs and review peer code anddocumentation.
• Extract data from flat files, JDE, Oracle and other heterogeneous sources and load the data into respective tables and files.
• Implementing various loads like Daily Loads, Weekly Loads and Monthly loads.
• Extensively used Mapping Variables, Mapping Parameters, and Workflow variables for full load and incremental load.
• Extensively used Informatica Transformation like Router, Filter, Lookup, Joiner, Aggregator, Sorter,Rank, Stored Procedure Transformation, Mapplets etc. and all transformation properties.
• Improved performance using Informatica Partitions and other Performance Tuning techniques. Developed re-usable components in Informatica and UNIX.
• Worked on InformaticaMDM- Populated data into different data feeds (Landing, Stagingand Base tables) from different sources JDE, SFDC, Oracle, flat files & SQLServer using Informatica 9.5.
• Worked on Informatica MDM Hub configuration.
• Validate the ongoing data synchronization process using DVO to ensure the data in source and target system are synchronized.
• Extensively working on code migration from DEV, QA and PROD.
• Used Informatica scheduler for scheduling jobs in production.

Confidential, IL

Informatica Analyst

Technology: Informatica Power Center,ESP.

Environment: InformaticaPowerCenter 9.1, DB2 Databases on Z/OS, LUW, UNIX shell scripting andPIPER(ETL Test Driven Development Tool).

Responsibilities:

• Interact with the Product Owners to get a brief knowledge of business logics.
• Participate in Agile team activities including daily standups, sprint planning and product demos, etc. Worked with the Product Owner to understand requirements and translate them into the design, development and implementation of ETL process using Informatica.
• Working with business and technical resources to address business information and application needs.
• Developed SQL and DB2 procedures, packages and functions to process the data for CGR Project (Complete Goods Reporting).
• Involve in Data validating, Data integrity, performances related to DB, Field size validation, check Constraints and Data Manipulation and updates by using SQL.
• Extract data from flat files, DB2 and to load the data into respective tables.
• Implementing various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy for CGR.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD, Type 2 SCD and fact implementation.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Used cvs files and tables as sources and loaded the data into relational tables.
• Working with the business analyst team to analyze the final data and fixed the issues if any.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Conduct code walkthroughs and review peer code and documentation.
• Writing Unix scrip for handling the source data and mapping.
• Used PIPER(TDD Tool) for testing ETL Code and testing DB2 tables.
• Validate the ongoing data synchronization process using validation tools to ensure the data in source and target system are synchronized.

Confidential, IL

Informatica Analyst

Technology: Informatica, MainFrame.

Environment: InformaticaPowerCenter 9.1, 8.5, DB2, DataFlux, Spoon,SAP Information StewardRUMBA,UNIX shell scripting, Salesforce.

Responsibilities:

• Gather requirements, analysis and design and data mart entities.
• Design and develop Informatica components, tables, views.
• Implement best practices to maintain optimal performance.
• Train and manage developers at onsite and offshore, advising other groups in organization on Informatica development, data warehouse development, development best practices.
• Conduct code walkthroughs and review peer code and documentation.
• Worked with the business analyst team to analyze the final data and fixed the issues if any.
• Work with developers, and systems support personnel in elevating and automating successful code to production.
• Writing medium to complex DB2 queries. Working with DB admin to resolve the performance issues.
• Developed medium to complex level informatica mapping and tuning the mappings and workflows for optimum performance.
• Implemented the informatica CDC for capturing the changes done to the legacy systems.
• Experience in accessing the mainframe using RUMBA.
• Used tools DataFlux&SAP Information Steward for data validation&data quality to compare source and target by developing graphs to ensure that data is sink and the data is populated as according to business requirements.
• Developed Reusable Transformations and Reusable Mapplets.

Confidential, VA

SAP Business Objects Developer

Technology: SAP Business Objects, SAP BO Live Office,Informatica

Environment: SAP BO 3.1/ BO BI 4.0, InformaticaPowerCenter 8, DB2, PL/SQL.

Responsibilities:

• This project is a proof of concept (POC) project for the automation of 2013 budget book for the office of Planning and Budget (OPB).
• I have involved in different tasks starting from requirements gathering, defining functional specifications, analysis, and estimation of work for the proto type development, presenting it to the stake holders and documentation etc.
• Designed and developed Universe and web-I reports, used the web-I report parts into the word document using live office.
• Worked on the performance improvement of the different reports.
• Created user groups and provided them access accordingly.
• Helped power users/SME to install the Client version of Business Objects including the SAP BO Live Office 4.0.
• Provided multiple live/web-ex training sessions for different users and provided project demo’s for the stake holders.
• Design universes and reports as per the PTO guide lines.
• Worked with ETL team and other team members while loading the data into “Data warehouse”.
• Responsible for designing and developing Automated reports using live office.
• Ensuring customer satisfaction, I have timely delivered the deliverables for each milestone.
• Enhanced and improved the existing reports as per the customer requirements.
• Designed and developed dashboards and scorecards using SAP BO Dashboard Design 4.0 for higher management.
• Developed new drill-down/up reports and input control enabled reports from the existing universes for the data analysis purposes.
• Performed unit testing, and wrote test scripts for the regression testing and performance testing for the testing team.

Confidential, MD

Informatica Developer/SAP BO Report Developer

Technology: Informatica, SAP Business Objects, Xcelsius.

Environment: Informatica Power Center 8.5(Repository Manger, Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Mapplet Designer, Workflow Designer, Task developer, Worklet Designer), SAP Business Objects XI R2, Toad 9.7, Erwin 4.2,DB2 UDB,DB2 LUW, Oracle 10g, ODI 11g Administration, Access, Flat files, SQL/PLSQL, UNIX shell scripting.

Responsibilities:

• Extracted data from various heterogeneous sources DB2 UDB, Oracle and Flat files.
• Written medium to complex queries and tuned the queries for optimum performance and related to data model.
• Worked with power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Extensively used Informatica Transformation like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties.
• Solid Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Used Debugger wizard to troubleshoot data and error conditions.
• Responsible for Best Practices like naming conventions, and Performance Tuning.
• Developed Reusable Transformations and Reusable Mapplets.
• Extensively used Various Data Cleansing and Data Conversion Functions in various Transformations.
• Involved in Migrating from Business Objects XI R2 to BO XI 3.0.
• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities, responsible for creation of the universe with Classes, Objects and Condition Objects.
• Involved in creation of SAP Business Objects XI R3.0 Desktop Intelligence and Web Intelligence Reports with different functionalities like Dynamic cascading prompts, drill down, linking reports, charts and graphs, ranking and alerts based on user feedback.
• Used multi-dimensional analysis (Slice & Dice and Drill Functions) to organize the data along a combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view the data.
• Created graphical representation of reports such as Bar charts, 3D charts and Pie charts etc.
• Created Web Intelligence reports with multiple data providers and synchronized the data using merge dimension option inSAP Business Objects XI R3.0.
• Developed Error Logging and Auditing strategies for the ETL Scripts.
• Responsible for migrate the code using deployment groups across various Instances.
• Optimized SQL queries for better performance.
• Responsible for Unit Testing of Mappings and Workflows.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD, Type 2 SCD and fact implementation.

Confidential

ETL Developer

Technology: Informatica

Environment: Informatica Power Center 7.1, Oracle 9i, PL/SQL, Toad, SQL plus, Erwin,Tivoli.

Responsibilities:

• Analyzed the logical model of the databases and normalizing it when necessary.
• Involved in identification of the fact and dimension tables.
• Extensively used Informatica-Power Center 7.1.3 for extracting, transforming and loading into different databases.
• Wrote PL/SQL stored procedures and triggers for implementing business rules and transformations
• Developed transformation logic as per the requirement, created mappings and loaded data into respective targets.
• Created Source and Target Definitions in the repository using Informatica Designer - Source Analyzer and Warehouse Designer.
• Worked extensively on different types of transformations like Source qualifier, Expression, Filter, Aggregator, Rank, Lookup, Stored procedure, Sequence generator.
• Used Mapping Designer to create mappings.
• Replicated operational tables into staging tables, to transform and load data into the enterprise data warehouse using Informatica.
• Created and scheduled Worklets, configured email notifications. Set up Workflow to schedule the loads at required frequency using Power Center Workflow Manager, Generated completion messages and status reports using Workflow Manager.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse.
• Documented Data Mappings/ Transformations as per the business requirement.
• Performed testing, knowledge transfer and mentored other team members