SUMMARY

• 9+ Years of IT industry Expertise in Data Warehouse/Data Mart, ODS, OLTP and OLAP implementations teamed wif project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Participate in Agile team activities including daily standups, sprint planning, PSI planning, product demos, etc.
• Highly proficient in ETL using Informatica Power Center 7.x, 8.x, 9.5, 9.6 and reporting using SAP Business Objects XI R2, 3.1 & 4.0, Xcelsius, Cognos reporting.
• Experience in performance tuning of Informatica mappings, and SQL query tuning.
• Experience in scheduling teh Informatica workflows using Cntrl - M, Informatica Scheduler and ESP.
• Working wif databases like IBM UDB DB2, Oracle, MS SQL Server, Teradata, Netezza, Greenplum and JDE.
• Experience in working wif UNIX, LINUX and other environments.
• SAP Business Objects and Xcelsius: 3+ years of SAP Business Objects 4.0/XIR3/XIR2 experience in Central Management Console, Central Configuration Manager, Designer, Web Intelligence, Desktop 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 Oracle, DB2, SQL Server etc.
• 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.
• Domain Experience: Diversified experience in multiple domains like Oil & Gas, Manufacturing, Insurance, Federal, Finance, and Pharmaceutical.

TECHNICAL SKILLS

Operating System: Windows 2000, XP/NT, HP-UX, UNIX and DOS.

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

RDBMS & other Tools: Oracle 11g/10g/9i, SQL Server, Teradata, DB2, TOAD, IBM Data Studio, SQL Developer. etc

ETL, BI Tools: Informatica PowerCenter 7.1/8.5/9.1, 9.5, 9.6 Power Exchange, Business Objects XI R2, 3.1, BI 4.0, Xcelsius, OBIEE and Cognos Reporting.

Packages/Validation Tools: DVO, DataFlux, Pentaho Data Integration, Pentaho Spoon, IDQ, Erwin 4.2, MS Office, RUMBA and Crystal Reports 6.

PROFESSIONAL EXPERIENCE

Confidential, TX

Sr. Informatica Lead Developer

Responsibilities:

• Working wif customer and technical resources to address business information and application needs.
• Interact wif teh Application users to get a brief noledge of business logics.
• Giving estimates to customer and application users.
• Involve in Data validation, Bug Fix, determining teh bottlenecks and fixing teh bottlenecks.
• Conduct code walkthroughs and review peer code and documentation.
• Extract data from flat files, XML files, JDE, Oracle and other heterogeneous sources and load teh data into respective tables and files.
• Developed medium to complex level informatica mapping and tuning teh mappings and workflows for optimum performance.
• 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.
• Developed Informatica workflows/worklets/sessions associated wif teh mappings using Workflow Manager.
• Distribution of work to offshore team and follow-ups.
• Participating in daily, weekly & monthly standups wif offshore & onsite.
• Worked on Informatica MDM - Populated data into different data feeds (Landing, Staging and Base tables) from different sources JDE, SFDC, Oracle, flat files & SQL Server using Informatica 9.6.
• Involved in implementing teh Land Process of loading teh customer/product Data Set into Informatica MDM from various source systems.
• Validate teh ongoing data synchronization process using DVO to ensure teh data in source and target system are synchronized.
• Extensively used Informatica IDQ for matching/removing duplicate data.
• Extensively used IDQ Keygen Transformation, Standardizing & Labeler Transformation, Consolidation Transformation, Address Doctor and other transformation.
• Extensively working on code migration from DEV, QA and PROD.
• Used Informatica scheduler for scheduling jobs in production and provided onsite Level-3 ETL production support.

Confidential, IL

Sr. Informatica Developer/ On-Site Coordinator

Responsibilities:

• Interact wif teh Product Owners to get a brief noledge of business logics.
• Participate in Agile team activities including daily standups, sprint planning and product demos, etc. Worked wif teh Product Owner to understand requirements and translate them into teh design, development and implementation of ETL process using Informatica.
• Working wif business and technical resources to address business information and application needs.
• Developed SQL and DB2 procedures, packages and functions to process teh 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, SAP and to load teh 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 teh capturing delta loads.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in teh Joiner Transformation.
• Used cvs files and tables as sources and loaded teh data into relational tables.
• Created and Configured Workflows, Worklets, and Sessions to load teh data to Netezza tables using Informatica PowerCenter.
• Working wif teh business analyst team to analyze teh final data and fixed teh issues if any.
• Used pushdown optimization to achieve good performance in loading data into Netezza.
• Responsible for determining teh bottlenecks and fixing teh bottlenecks wif performance tuning.
• Extensively work on Informatica Metadata tables and created reusable transformations for error handling and exception reprocessing.
• Worked wif Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Identified and eliminated duplicates in datasets thorough IDQ 8.6.1 components of Edit Distance, Jaro Distance and Mixed Field matcher, It enables teh creation of a single view of customers, halp control costs associated wif mailing lists by preventing multiple pieces of mail.
• Conduct code walkthroughs and review peer code and documentation.
• Writing Unix scrip for handling teh source data and mapping.
• Validate teh ongoing data synchronization process using validation tools to ensure teh data in source and target system are synchronized.
• Extensively used ESP tool for scheduling Informatica batch jobs and provided level-3 production support on rotation.

Confidential, IL

Sr. Informatica Developer

Responsibilities:

• Involved in requirement gathering wif different DC for business requirements and functional specifications.
• Extensively worked on analysis, design, ETL development, Unit testing, QA/Production deployments and production support.
• Worked wif developers at onsite/offshore and clearly communicated deliverables to offshore team on Informatica development and documentation.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Implement best practices to maintain optimal performance.
• Conduct code walkthroughs and review peer code and documentation.
• Worked wif teh business analyst team to analyze teh final data and fixed teh issues if any.
• Writing medium to complex DB2 queries. Working wif DB admin to resolve teh performance issues.
• Developed medium to complex level informatica mapping and tuning teh mappings and workflows for optimum performance.
• Extensively worked on data validation tools and developed Dataflux/DVO jobs for comparing Source (DB2) and Target (Salseforce) to ensure that data is in sink and teh data is populated as according to business requirements.
• Extensively worked on salesforce API web connections for connecting Informatica & SAS DataFlux.
• Extensively used Informatica debugger to figure out teh problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Implemented teh informatica CDC for capturing teh changes done to teh legacy systems.
• Extensively worked on Pentaho Data Integration and Pentaho Spoon for extracting data from DB2, Salesforce and loaded data into oracle.
• Experience in accessing teh mainframe using RUMBA.
• Developing Teradata Utility scripts like FastLoad, MultiLoad to load data from various source systems to Teradata.
• Worked on Informatica IDQ 8.6 to complete initial data profiling and matching/removing duplicate data.
• Experience in working wif different Insurance domains- Auto, Home & Property, Commercial and Life.
• Developed reusable transformations and reusable mapplets.
• Given 24/7 production support and met SLA’s.

Technology/ Environment: Informatica PowerCenter 9.1, 8.5, DB2, Salesforce, Oracle, SAS DataFlux, IDQ, Pentaho Data Integration, Pentaho Spoon, Teradata, Greenplum, UNIX shell scripting.

Confidential, VA

Sr. SAP Business Objects Developer

Responsibilities:

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

Confidential, MD

Sr. Informatica/SAP Business Objects Developer

Responsibilities:

• Extracted data from various heterogeneous sources DB2 UDB, Oracle and Flat files, XML files.
• Written medium to complex queries and tuned teh queries for optimum performance and related to data model.
• Worked wif 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 wif various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Extensively worked on XML files as Source and Target.
• Used transformations like XML Generator and XML Parser to transform XML files.
• Used Erwin tool for data modeling.
• Worked on Informatica 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 SAP Business Objects reports from 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 teh universe wif Classes, Objects and Condition Objects.
• Involved in creation of SAP Business Objects XI R3.0 Desktop Intelligence and Web Intelligence Reports wif 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 teh data along a combination of Dimensions and Drill-down Hierarchies giving teh ability to teh end-users to view teh data.
• Created graphical representation of reports such as Bar charts, 3D charts and Pie charts etc.
• Created Web Intelligence reports wif multiple data providers and synchronized teh data using merge dimension option in SAP Business Objects XI R3.0.
• Responsible for migrate teh 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.

Technology/ Environment: Informatica Power Center 8.5, SAP Business Objects XI R2, Oracle 10g, PL/SQL, DB2 UDB LUW, Erwin 4.2, Access, Flat files, UNIX shell scripting.

Confidential, FL

Informatica Developer

Responsibilities:

• Analyzed teh logical model of teh databases and normalizing it when necessary.
• Involved in identification of teh fact and dimension tables.
• Extensively used Informatica-Power Center 7.1 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 teh requirement, created mappings and loaded data into respective targets.
• Created Source and Target Definitions in teh 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.
• Replicated operational tables into staging tables, to transform and load data into teh enterprise data warehouse using Informatica.
• Created and scheduled Worklets, configured email notifications. Set up Workflow to schedule teh 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 teh data loaded into teh warehouse.
• Extensively worked on data modeling.
• Documented Data Mappings/ Transformations as per teh business requirement.
• Performed testing, noledge transfer and mentored other team members

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

Confidential

ETL Programmer

Responsibilities:

• Analyzed teh systems, met wif end users and business units in order to define teh requirements.
• Responsible for developing technical specifications from business requirements.
• Extracted high volume of data from DB2 tables, Flat Files and populated into Oracle wif teh halp of SAS Data Integration-ETL.
• Create High level, low level and detail technical design specifications for teh SAS ETL.
• Understanding of teh business requirement of external source systems and perform cleaning, standardization and generate match case and clusters.
• Wrote PL/SQL procedures, functions, triggers and packages for processing business logic in teh database.
• Experience in Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
• Designed coding specification and documentation.
• Involved in ETL coding using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Involved in teh continuous enhancements and fixing of production problems.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios wif Oracle Streams.

Technology/ Environment: Oracle 8i, PL/SQL, DB2, SAS Data Integration studio 3.0, UNIX.