SUMMARY

• 8+ years of experience in Software Development Life cycle, gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse, Data Marts.
• Extensive experience of Data warehousing using Informatica PowerCenter 9.5/9.1/8.6/8.5/8.1/7.1 Client and Server tools and OBIEE 11g/10g.
• Very strong noledge in relational databases (RDBMS), data modeling and in building Data Warehouse, Data Marts using Star Schema and Snowflake Schema, physical data modeling using Erwin 7.2.
• Application Support, Performance Tuning, Optimization, Data warehousing, User & Security Administration, Data Administration and setting up the Test, Supporting and Development environments.
• Extensive experience in designing developing Informatica Mappings & Mapplets using various transformations for Extraction, Transformation and Loading from Multiple Sources (SQL Server, Oracle, Flat files, DB2 Mainframes) to Data Warehouse and creating Sessions and Workflows/Worklets and executing the Workflows.
• Responsible for Unit, System and Integration Testing and Performed Data Validation for all the ETL’s and reports those are generated from Informatica.
• Knowledge in design and development of Business Intelligence reports using BI tools Business Objects, OBIEE 11g/10g an Excel spreadsheet.
• Worked on Informatica PowerExchange to capture real time CDC.
• Worked on Autosys scheduling tool for scheduling jobs
• Involved in analysis, design and quality assurance of Client/server and Web applications for Healthcare, Health Insurance, Banking, Retail.
• Developed Test Plans, Test Scenarios, and Test cases, Test Scripts, Test reports and Test Metrics for Manual as well as Automated testing for various applications to ensure proper business compliance and testing Multi - Tier application architecture.
• Excellent communication, interpersonal, analytical skills and strong ability to perform in a team and to interact with the Business users and ability to manage (Multiple) project tasks with changing priorities and tight deadlines.
• Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.
• Demonstrated ability to work well with a wide variety of people at various levels, coordinated with Offshore and Onsite team, halp team resolve conflicts constructively. A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.

TECHNICAL SKILLS

ETL, DW & BI Tools: Informatica Power Center 9.x, 8.x, 7.x,6.x,OBIEE 11g/10g,Business Objects XIR2/6.0, Power Exchange 9.1 CDC, Erwin 7.2, Cognos

Databases: Oracle 11g/10g/9.x, DB2, SQL server 2005/2000, My SQL, MS-Access, TeraData 13, V2R5, SQL Developer 2008

Operating Systems: Windows, Linux, UNIX, WINSCP, WinCVS, Tidal Enterprise Scheduler, AIX, SunSolaris

Programming Languages & Scripting: SQL, PL/SQL,VB, C/ C++, Perl, HTML, XML, UNIX

Version Control: Harvest, HCM, control X

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Sr. Informatica Developer

Responsibilities:

• Responsible for ETL design & implementation to source CRM data from Siebel to Business Warehouse.
• Involved in requirement analysis, ETL design and development for extracting data from the source systems like Oracle, flat files, XML files and loading into data mart using VSE Connector.
• Worked with analysts and data source systems experts to map requirements to ETL code.
• Worked on developing UNIX and Perl Scripts for file parsing and job automations.
• Developed complex mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Router, Update strategy and Sequence generator.
• Converted functional specifications into technical specifications (design of mapping documents).
• Used Autosys, CRON to schedule jobs.
• Worked on administering Informatica 8.6 and 9.5 on windows environment before UNIX migration.
• Created deployment groups to deploy objects.
• Responsible for design and implementation needed for loading and updating the warehouse.
• Worked with Session logs and Work flow logs for Error handling and troubleshooting in Dev environment.
• Created scripts for better handling of incoming source files such as moving files from one directory to another directory and extracting information from file names, such as date, for continuously incoming sources.
• Wrote scripts to ensure e-mails sent to respective people on Failure/Success, error handling, control auditing of different processes.
• Designing, document and configure the Informatica MDM Hub to support loading, cleansing, matching of MDM data.
• Efficiently worked on MDM data modelling, data mappings and data integration.
• Involved in Performance Tuning of existing mappings as well as new ones.
• Wrote complex SQL scripts to avoid Informatica joiners and Look-ups
• Coordinated with DBA’s in resolving the database issues that lead to production job failures.
• Migrated code/objects from the development environment to the QA/testing environment to facilitate the testing of all objects developed and check their consistency end to end on the new environment.
• Involved extensively in Unit testing, integration testing, system testing and UAT.

Environment: Informatica Power Center 9.1, MDM, Informatica Power Connect SAP R/3,OBIEE 11g, Oracle 11g, SQL server 2010, PL/SQL Procedures, TOAD, Perl scripts, Rational Clear case, Autosys, MKS Integrity Client, MS Visio, ALM, Mainframes, UNIX, PUTTY, VSE Connector.

Confidential, Watertown, MA

ETL/ Informatica Developer

Responsibilities:

• Used Mapping Designer, Workflow Manager, Workflow Monitor extensively to create, execute informatics complex mappings.
• Designed and developed end-to-end ETL process from various source system to staging area, from staging to Data Marts.
• Migrated data from one environment to another.
• Extensively worked with various transformations like expression, filter, joiner, aggregator, lookup etc..,,
• Expertise in creating Mappings for Initial Loads and Incremental Loads using Mapping/ Mapplet Parameters and Variables.
• Extensively worked on performance tuning and monitoring of programs, ETL procedures.
• Collected performance data for sessions and performance tuned by adjusting Informatica.
• Created pre-session and post-session shell scripts and mail-notifications.
• Generated SQL queries and validated the data loads using TOAD and SQL Developer and monitored mapping’s run process.
• Used for mapping the following processes Lookup, rank, sequence generator, sorter, etc.
• Used UNIX to create session parameter files.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and Router
• Involved in ETL design for the new requirements
• Used INFORMATICA (Power Center) tool as ETL tool for constantly moving the data from sources into staging area
• Prepared Test cases for the Project
• Development of the Informatica Mappings, lookups, reusable components, Sessions, Work Flows etc. (on ETL side) as per the design documents/communication
• Fixed the Issues that come out of Integration Testing.
• Implemented sending of Post-Session Email once data is loaded.
• Used Debugger to test the mappings and fixed the bugs.
• Worked with DBA for partitioning and creating indexes on tables used in source qualifier queries.
• Scheduled and executed batch and session jobs on Tidal.

Environment: Informatica Power Center 9.5, Oracle 9i/10g, Tidal, UNIX and Windows 7.

Confidential, Parsippany, NJ

Informatica Developer

Responsibilities:

• Formalization of requirements and creation the formal subject area description based on functional sets and binary adjacency matrixes, functional specs and technical specs, metadata for the data warehouse, database naming convention and Informatica coding convention using Microsoft Word, Excel.
• Involved in Logical & Physical Database Layout Design and Data Modeling using the Star schema.
• Prepared gap analysis document for reporting and ETL Strategy using Informatica.
• Worked with various Informatica transformations such as Source Qualifier, Joiner, Filter, Router, Aggregator, Lookup (Connected/ Unconnected), Rank and Sorter Transformations.
• Involved in performance tuning of Informatica mappings, identified the bottlenecks and resolved performance issue
• Used Stored Procedures to implement complex business logic in that basically writing PL/SQL stored Procedures and SQL queries using TOAD.
• Involved in Tuning Informatica Mappings to identify and remove processing bottlenecks.
• Designed Audit Strategy to audit the data between Source System, Target System and Other Parallel Reporting Systems.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Developed Customized reporting with OBIEE Answers and integrated them into the Dashboards by using BI Publisher.
• Involved in on-site Production Support and change management team and was responsible for smooth onshore-offshore co-ordination, change/release management, user interaction and production support.

Environment: Informatica Power Center 9.1/8.6, Oracle 11g, OBIEE 11.1.1.5, TeraData V2R5, SQL Server 2005, Oracle SQL Developer, Supply Chain Management, DB2 version 9.1, TeraData 13, DAC 7.95, Cognos

Confidential, West Point, PA

Informatica Developer

Responsibilities:

• Participated in full life cycle development of Data Warehouse systems and analytics such as analysis, design, development, testing and technical documentation.
• Involved in on-site Production Support and change management team and was responsible for smooth onshore-offshore co-ordination, change/release management, user interaction and production support.
• Developed complex mappings to extract source data from heterogeneous databases SQL Server, Oracle and flat files, applied proper transformation rules and loaded into Data Warehouse.
• Extensively used transformations such as Source Qualifier, Filter, Router, Aggregator, Union, Lookup, Update Strategy, Sequence Generator, and Stored Procedure and configured according to business requirements.
• Created mappings for Initial/Incremental loads.
• Involved in identifying bugs in existing mappings by analysing data flow, evaluating transformations using Debugger.
• Worked extensively on Data Mapping from various source systems on to target systems involving TeraData as EDW.
• Involved in Tuning Informatica Mappings to identify and remove processing bottlenecks.
• Developed PL/SQL Scripts to write data into flat files and tan loaded data from flat files to custom tables through SQL Loader scripts.
• Created Stored Procedures, Triggers, Functions, Views and Packages using PL/SQL.
• Developed different reports using Oracle Application Express and PL/SQL.
• Involved with support team in Deployment and Administration of the release to various environments (Dev/UAT/PROD Support).

Environment: Informatica 8.6.1, Informatica PowerExchange 8.6, DB2 Mainframe, SQL Server 2008, Windows XP, Linux, MQ Series, Web Services, Putty, Oracle Exadata, SCM, OBIEE 10g.

Confidential, San Francisco CA

Informatica Developer

Responsibilities:

• Worked closely with the Business Analyst for preparing and reviewing the business specifications of the project.
• Involved in creating scripts for various database objects related to the data model, which involve in creation of schema, tables, sequences, views, materialized views, constraints, and indexes.
• Involved in designing of star schema based data model with dimensions and facts.
• Used Informatica as ETL tool for building the data warehouse and data marts where majorly focused on the transformations namely Expression, Lookup, Unconnected and Connected Lookup, Router, Filter, Expression, Aggregator.
• Involved in creation of various UNIX scripts, which halp the ETL scheduling jobs and halp in initial validation of various tasks.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Extensively used transformations such as Source Qualifier, Filter, Router, Aggregator, Union, Lookup, Update Strategy, Sequence Generator, and Stored Procedure and configured according to business requirements.
• Involved in Production Support and various product release activities.

Environment: Linux, Sun Solaris, Informatica PowerCenter 8.5/8.6.1, Power exchange 8.6, Oracle 9i/10G,XML Files, Flat Files, DB2, Teradata V2R5.