SUMMARY:

• Over 8 years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial, Telecom and Manufacturing Sectors.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Teradata, Client/Server applications.
• Strong Data Warehousing ETL experience of using Informatica 9.5/9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Strong knowledge in Cognos Series 7 and Cognos 8.4 /8.3/10/10.1/10.2 and experience with ETL tools like Informatica.
• Good knowledge of robust data integration with Talend.
• Strong in Talend Studio features like connect databases, flat files, cloud-based applications and more data. Graphical drag-and-drop tools and wizards speed design, testing,
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Centre (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Experience using SAS ETL tool, Talend ETL tool and SAS Enterprise Data Integration Server highly preferred.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Expertise on Business Intelligence tools such as: Cognos 8/10 BI Cognos Web Reports, OLAP cube development using Cognos Power Play and Transformer, and implementing security using Cognos Access Manager.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, .NET, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like Autosys and Control-M.
• Worked extensively with slowly changing dimensions.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Extensive work experience in Manual, Functional, Regression, System and User Acceptance Testing in Client/Server & Web-based application environments
• Created ETL test data for all ETL mapping rules to test the functionality of theInformatica Mapping.
• Expertise in ETL/DWH testing concepts, Informatica power center 8.6.0.
• Tested the ETLInformaticamappings and other ETL Processes (Data Warehouse Testing)
• Experience in creatingTest Readiness Review(TRR).
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema.
• Analyzed Source Systems, Staging area, Fact and Dimension table in Target D/W.
• Well-versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Professional experience inIntegration, Regression, validation Testing, UAT Testing,Black Boxtesting.
• Proficient in all cycles of test life cycle from test planning to defect tracking and managing defect lifecycle.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS:

ETL Tools Informatica: PowerCenter 9.0/9.5/8.6.1/7.1 (Designer, Manager, Workflow Manager), Power Exchange, Informatica Data Quality 9.1 (IDQ). Database Oracle 11g/10g/9i, Teradata, DB2, SQL Server 2000, MS Access, MySQL, Neteeza

Operating Systems: UNIX, Windows 2000/NT 4.0 Server

BI & Reporting Tools: Business Objects 6.5/5.x (Designer, Supervisor) GUI Forms 4.5/5.0, Reports 2.5/3.0, Visual basic 5.0/6.0, Developer 2000, IBM Cognos

Web Technologies: SQL, PL/SQL, .NET, COBOL, JAVA, PHP, HTML, JavaScript and C#.

Testing Tools: Win Runner, Load Runner, QTP 8.2, and QC.

Web/App servers: Internet Information Server, JWS, Apache Web server, Web Logic

Additional Tools: Erwin, Toad, SQL Navigator, Control M, Autosys, Forms 4.5/5.0, Reports 2.5/3.0, Visual basic 5.0/6.0, Developer 2000.

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

Sr Informatica Developer

Responsibilities:

• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Converted business requirements into technical documents - BRD, explained business requirements in terms of technology to the developers.
• Developed Data Flow diagrams to create Mappings and Test plans.
• The Data flow diagrams ranged from OLTP systems to staging to Data warehouse.
• Developed Test plan to verify the logic of every Mapping in a Session. The test plans included counts verification, look up hits, transformation of each element of data, filters, and aggregation and target counts.
• Developed complex Informatica mappings using various transformations- Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation.
• Extensively used SCD’s (Slowly Changing Dimension) to handle the Incremental Loading for Dimension tables, Fact tables.
• Designed various mappings for extracting data from various sources involving Flat files, Oracle, Sybase and SQL Server, IBM DB2.
• Created Informatica Power Exchange Registration and Data map.
• Designed and developed real-time data warehouse.
• Worked on Informatica cloud and extracted data from Sales Force source.
• Worked on Debugging and Troubleshooting of the Informatica application. For debugging utilized Informatica debugger.
• Worked on Performance Tuning to optimize the Session performance by utilizing, Partitioning, Push down optimization, pre and post stored procedures to drop and build constraints.
• Experience in building of the Repository (RPD) using the OBIEE toolset.
• Developed OBIEE technology such as Answers, Dashboards, and BI Publisher.
• Identify users and see what level of familiarity they have with this data. Segment these users based on criteria like influence, authority and participation levels.
• Identifying automated decision-making possibilities.
• Worked on Teradata utilities BTEQ, MLOAD, FLAOD and TPUMP to load staging area.
• Worked on Audit login, Error login and Reference check while loading data to Data warehouse.
• Created Unix Script for ETL jobs, session log cleanup and dynamic parameter.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings.
• Wrote UNIX scripts, Perl scripts for the business needs.
• Coded Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process.

Environment: Informatica PowerCenter 9.5/9.1, Informatica Power Exchange 9.1, Oracle Exadata, Teradata 13, MSSQL Server 2008 R2, T-SQL, Erwin 8, SQL Server 2008, TOAD, PL/SQL Developer, .NET, Linux, Tidal, Shell Scripting, Perl Scripting, Windows XP, DB2 Mainframe, OBIEE 11g, Informatica Cloud, Salesforce.

Confidential, Schaumburg IL

Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Setup and maintenance of database on Oracle.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development. Attended Business meetings and did Business Analysis and gathered the requirements. Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads
• Converted data stored in Oracle, XML, Flat files, Oracle Financials, SQL server using Informatica.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Interact with functional analysts to understand requirements and write high level design documents
• Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts.
• Designed Sources to Targets mapping from primarily Flat files to Oracle using Informatica PowerCenter.
• Data Quality Analysis to determine cleansing requirements.
• Worked extensively with Oracle stored procedures to truncate, move and update data
• Developed ETL methodology to custom fit the ETL needs of Claims Data Mart.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translated business rules and functionality requirements into ETL procedures.
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• • Various kinds of the transformations were used to implement simple and complex business logic. Transformations used are: Aggregator, Joiner, Union, Custom, Router, Expression, Update Strategy, Filter, Sorter transformations, stored Procedure, connected & unconnected lookups, Expressions, source qualifier, sequence Generator, etc.
• Did profiling and Data Quality Analysis of the data to find out anomalies in the data and highlighting the effectiveness of the tool (IDQ) to do that.
• Used IDQ (Informatica Data Quality 9), Address Doctor and Identity Matching to validate the data.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Check and Tune the performance of application for optimum system performance.
• Worked with QA Team to resolve QA issues.

Environment: Informatica Power Center 9.5, Informatica Power Exchange 9.1, Neteeza, PL/SQL, SQL Server 2000/2005, .NET, XML, Erwin, MS Office tools, Clear Case, UNIX, Windows, Control-M Scheduler.

Confidential, Boston MA

Informatica Developer

Responsibilities:

• Modeled the schema for Landing, Staging and Base objects.
• Worked as a key project resource taking day-to-day work direction and accepting accountability for technical aspects of development.
• Configured the match and merge logic in Siperian Informatica.
• Defined System Trust and Validation rules for the base object columns.
• Implemented Pl/SQL stored procedures to perform the match and merge process to load and cleanse data.
• Ensure secure Oracle environment utilizing NETIQ as monitor and testing and applying Oracle patches as they are available
• Customized and configured the Business data director and Informatica data director (IDD).
• Implemented Informatica PowerCenter and golden gate to get the real time data load process.
• Worked with golden gate to replicate data on the real time basis.
• Created and deployed reusable components in the Informatica environment.
• Created parameter driven adhoc stored procedure and packages to handle the temporary need for the data extracts.
• Created reusable Informatica Worklets and Mapplets for implementing the cleansing logic for enterprise wide source system.
• Rated the accuracy of the source system based on the truth level of the source system.
• Worked with data stewards to resolve ambiguities in the data from different source system.
• Intensively worked with business owners and data owners to come up with policy around data governance and data control.
• Resolved and created business flow around the process.
• Analyzed and profiled the data from different source system and determined the confidence level on column level as well as on source entity level.
• Worked with analyst and data owners to come up single organizational level definition of customers
• Implemented near real time golden gate replication process
• Designed the reusable framework in Unix to load the dimension and to schedule the jobs
• Trained and mentored the junior developers about the best practices and coding standards
• Developed the UNIX shell scripts for auditing and for any data quality issues during data load process.
• Intensively involved in performance tuning of the existing SQL queries, PL/SQL stored procedures
• Tuned the existing stored procedures and SQL
• Tuned the SQL loader scripts to reduce the load time
• Designed the tables in order to enhance the loading process and to tune the SQL Query
• Tuned the SQL by giving hints and by modifying joins

Environment: Informatica Power Center 8.6.1, Oracle 10g/ 9i, MS-SQL Server, Windows XP, .NET, UNIX and MS Office Suite

Confidential, PA

Informatica Developer

Responsibilities:

• Studied Involved in entire data warehousing life cycle designing.
• Closely involved with the data Architect to design the star schema and snowflake schema.
• Used Informatica Power Mart 6.2 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Used Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Repository Server Administration Console.
• Developed and documented date Mappings/Transformations and Informatica sessions.
• Designed several mappings to extract the data from Flat files and Relational Sources.
• Designed optimal workflow, monitored performance on UNIX and Mainframe.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, Transform and cleanse data, and Load it into data warehouse.
• Created mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, look-up, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• Called stored procedures & Unix Scripts to perform database operations on post-session and pre session commands
• Tested the Application like Unit Testing and Integrated Testing.
• Designed the test cases and tested the sessions and workflows to meet the Unit Test Requirements.
• Developed design documents and Unit Testing Process for the modules developed.
• Tuned the performance of the mapping to load the data quicker.

Environment: Informatica Power Center 6.2, Oracle 8i, SQL, PL/SQL, Windows NT, UNIX, Toad 9.1, Perl scripts

Confidential, Arizona

ETL/Database Developer.

Responsibilities:

• Developed Procedures, functions, packages and Triggers for enforcing the business rules using PL/SQL.
• Involved in creation of Schema Objects like indexes, views, and stored procedures.
• Involved in a team in designing the Database Schema, for the metadata for storing the informative queries that are generated dynamically.
• Identifying integrity constraints for tables.
• Created mappings, sessions, worklets and workflows.
• Involved in writing the Triggers which internally calls procedures and functions.
• Tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse Impact on integrated system environment.
• Involved in documenting the entire process.
• Involved in Implementation and Testing phases of the system.
• Partnered with a project manager for a project; Employee Management.
• Developed the application without queries.
• Noted every day’s work in a daily tasks book.

Environment: Informatica 7.1, UNIX, Oracle 10g, PL/SQL, SQL *Plus, SQL developer, LINUX, VB Script.