SUMMARY

• 7 plus years of experience in Information Technology with a strong background in Database development, Data warehousing and Data Extraction using Informatica PowerCenter 9.x/8.x/7.x/6.x as ETL Tool, Data Analysis Using IDQ Tool..
• Solid experience in Data Warehousing Concepts like Ralph Kimball Methodology, OLAP, OLTP, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling, Dimension Data Modeling using Erwin, Microsoft VisioExtensively used Informatica Client tools like Designer, Workflow Manager, Workflow Monitor, Repository Manager and Server tools.
• Experience in Oracle, MS SQL Server, Teradata V2R5/V2R4, MS Access 7.0/2000, SQL, PL/SQL, SQL*Plus, Sun Solaris 2.x.
• Well acquainted with Informatica Designer Components - Source Analyzer, Transformation Developer, Mapplet and Mapping Designer.
• Experience in designing/developing complex mapping using transformations Unconnected and Connected lookups, Router, Aggregator, Sorter, Ranker, Joiner, Stored Procedure, Update Strategy and Re-usable transformations
• Extensive experience in developing Workflows, Worklets, sessions and tasks to effectively manage the Load and pmcmd (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Experience in designing XML Schema as XML document allowing to validate the content and the structure of XML data.
• Experience in working withInformatica Data Quality (IDQ) for data and quality analysis.
• Experience in generating Score Cards for each stage of data analysed.
• Experience in creating dictionaries and rules for data standardization and using Consolidation transformations.
• Experience in writing VBA Scripts to enhance the report functionality and automated the Printing capabilities.
• Proficient in the integration of various data sources involving multiple relational databases like Oracle, MS SQL Server, DB2 and Flat Files ( fixed width , delimited )
• Experience in identifying performance bottlenecks and tuning of Informatica Sources, Targets, Mappings, Transformations and Sessions for better performance and efficiency.
• Involved in tuning the Oracle SQL queries by using Indexing techniques, Hints and Parallel execution process.
• Worked with Stored Procedures, Triggers, Cursors, Indexes and Functions.
• Experience in Scheduling Informatica sessions for automation of loads in Autosys.
• Experience in UNIX shell scripting, FTP and file management in various UNIX environments.
• Worked with Pre-Session and Post-Session UNIX scripts for automation of ETL jobs using Auto Sys scheduler and Involved in migration/conversion of ETL processes from development to production environment.
• Experience in Domains like Banking, Hospitality ,Insurance and Telecommunications.
• Identified and debugged the errors before deploying and worked on migration of the mappings and workflows from development to testing, testing to QA and from QA to production.
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and presentation skills.

EDUCATION:

• Bachelor of Technology

TECHNICAL SKILLS

• ETL Tools : Informatica PowerCenter9.x/8.6.1/8.5/8.1/7.x, 6.x, IDQ.
• BI Tools : OBIEE 10.1.3.1, Business Objects, Cognos, Micro strategy
• Data modeling tools : Erwin 8.x/7.x/ 4.2/3.x, Microsoft Visio
• RDBMS : Oracle 11g/10g/9i/8i, SQL Server 2005/2008, DB2,Solaris 10, Teradata V2R5/V2R4.
• Web Tools : HTML, DHTML, XML, Java Script
• Other tools & Utilities : SQL* Plus, TOAD 8.x, Auto Sys
• Languages : SQL, PL/SQL, TSQL, C, C++,SAP-ABAP, Siebel CRM
• Scripting languages : UNIX Shell Scripting,VBA
• Operating systems : Windows 2000/2003/NT/XP, UNIX, LINUX

PROFESSIONAL EXPERIENCE

Confidential, is one of the leading health insurance organization. The information systems for business was customized and utilizing the healthcare enterprise data warehouse to collect, organize and store data from all the sources to integrate the historic data for end user reporting.
Responsibilities:

• Implemented business plan based on required technical and business needs.
• Extensively used Informatica PowerCenter to create mappings, mapplets, transformations, re-usable transformations, etc.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Implemented partitioning and bulk loads for loading large volume of data.
• Developed and designed jobs using Informatica Designer based on mapping specifications using appropriate stages.
• Star schemas and Snow flake schemas were used in developing Informatica jobs.
• Created source to target mapping and job design documents from staging area to Data Warehouse.
• Experience in migrating data from Oracle to Teradata database using Informatica as ETL.
• Experience in using sql loader to load data from the given data-file into table or tables created in the database.
• Worked on Infomatica Data Quality to resolve customers address related issues.
• Experience using IDQ-Informatica Data Quality for Data Quality Analysis perspective providing subset of data, attributes details.
• Experience Combining data quality rules with sophisticated data transformation logic and conduct midstream and comparative profiling to validate and debug logic as it's developed.
• Have generated few complex business reports/graphs using IDQ, which was being used for understanding, acting and reporting.
• Analysis of data and report to stakeholders if data noncompliant with the standards or data quality issues.
• By using Autosys, created the job which runs a UNIX script. The script in turn runs the "pmcmd" command to run a workflow.
• Experience in designing XML Schema as XML document allowing to validate the content and the structure of XML data.
• Developed job sequences to execute a set of jobs with restart ability, check points and implemented proper failure actions.
• Used workflow tasks like reusable Email, Event wait, Timer, Command, Decision for defining the behavior of whole ETL process.
• Created Excel spreadsheet using VBA to do all data cleansing prior to loading into Express.
• Created Stored Procedures, Packages in PL/SQL with Oracle in order to create, update several tables like Order processing Information table and Audit Log tables.
• Used pmcmd command to start, stop and ping server from UNIX and created UNIX SHELL Scripts to automate the process.
• Involved in performance tuning of mappings, transformations and sessions to optimize session performance.
• Creating Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.
• Provided production support and performed enhancements on existing projects.

Environment: Informatica PowerCenter9.0/ 8.6.1,IDQ,Teradata, Oracle 9i, SQL*Plus, Toad, SQL Server 2008, ERWIN 8 Data Modeling tool, XML Schema,UNIX,VBA, AutoSys Scheduler, Sun Solaris, Siebel CRM.

Confidential, Des Plaines, IL Jul'09 - Dec'10
IDQ/Informatica Developer

Confidential, has implemented SAP to better streamline their process and went live. SAP BW is also being used to have a better Data warehouse infrastructure to support in managerial decision making. Oracle is used as the RDBMS. Prior to the SAP implementation IBM DB2 was Lawson's legacy database where all information was stored. This project main purpose is to migrate from DB2 to Oracle and maintain only past seven years of data as per the requirement.
Responsibilities:

• Interacted with the Business Users to analyze the Business Requirements and transform the business requirements into the technical requirements.
• Worked on PowerCenter client applications like Designer, Workflow Manager, Workflow Monitor and repository Manager.
• Experience in working withInformatica Data Quality (IDQ) for data and quality analysis.
• Experience in generating Score Cards for each stage of data analysed.
• Experience in creating dictionaries and rules for data standardization and using Consolidation transformations.
• Worked on Designer Tools like Source Analyzer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Extensively used various Transformations like Filter Transformation, Router Transformation, Joiner Transformation and Aggregator Transformation, Expression Transformation and Lookup Transformation.
• Experienced using Informatica integrated with web services.
• Responsible for Data Cleansing and Data Validation using Expression Transformation and Lookup Transformation.
• Analyzed business process and developed ETL procedures to move data from various source systems to target systems.
• Developed Schemas like Star schema and Snowflake schema which are used in relational, dimensional and multidimensional data modeling using ERWIN.
• Involved in writing PL/SQL procedures to transform data from staging to Data Warehouse Fact and summary tables.
• Extensively used Stored Procedures, Functions and Packages using PL/SQL for creating Stored Procedure Transformations.
• Created UNIX Shell Scripts and necessary Test Plans to ensure the successful execution of the data loading process.
• Developed scripts using pmcmd command to run the Workflows, Sessions from UNIX environment which are called in Autosys jobs.
• Involved in Testing, Debugging, Data Validation and Performance Tuning of ETL process which helped to develop optimum solutions for data warehouse deliverables.
• Performance tuning of Informatica mappings for large data files by managing the block sizes, data cache sizes, sequence buffer lengths and commit interval.
• Worked on Unit Testing, Integration testing and Regression testing to verify load order, time window and lookup with full load.

Environment: Informatica PowerCenter 8.6, Erwin, DB2, Web Services, Oracle 10g, Teradata V2R5/V2R4, Flat Files, SQL, PL/SQL, UNIX, TOAD, AutoSys, SAP BW.

Confidential, Philadelphia, PA Mar'08 - Jul'09
Informatica Developer

Confidential, is in the process of de-commissioning many legacy systems by replacing them with an Enterprise wide data warehouse (EDW), a comprehensive sales and marketing data warehouse environment that delivers timely sales information to assist the end users. The other sources that were integrated are DDD and Exponent Plantrak data from IMS into ODS (Operational Data store). This Central location of data makes J & J to create and manage common reports so that each group can benefit from or leverage work done by other groups.

Responsibilities:

• Analyzed existing transactional database schemas and designed star schema models to support the users reporting needs and requirements.
• Involved in gathering information from HL7 clinical documents for the purpose maintaining data exchange between patients and healthcare providers.
• Used Informatica Repository Manager, maintained all the repositories of various applications, created users, user groups, security access control.
• Strong knowledge of Master data management concepts.
• Experience using facets to meet the transaction needs of the largest health organizations.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, Connected and Unconnected lookups, Filters, Sequence, Router and Update Strategy.
• Worked on the customer care master inbound files which consists data provided by the 3rd party sources and internal systems like IMS (DDD) and Quest, (DEA, drug enforcement agency which regulates and monitors the distribution of ethical drug products)
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• Involved in the development of Informatica mappings and also performed tuning for better performance, co-ordinating jobs on a daily basis for daily load in the data warehouse.
• Extensively involved in performance tuning of Informatica mappings and sessions.
• Using Autosys to schedule UNIX shell scripts and Informatica jobs.
• Written Unix Shell Scripts for getting the data from all systems to the data warehousing system.
• The data was standardized to store various business units in tables.

Environment: Informatica PowerCenter8.1.1/ 7.2, Autosys, HP UNIX, Windows NT, Sybase, Oracle 9i/10g, SQL, DB Artisan,HL7,EMR,ICD9, Facets.

Confidential, New York, NY
Informatica Developer Sep'06-Feb'08

Confidential, is a global financial service company. The bank offers financial products and services for corporate and institutional clients along with private and business clients. Services include sales, trading, research and origination of debt and equity. It provides its clients with expert advice, innovative solutions, outstanding execution and comprehensive access to the world\'s capital markets. Sales Revenue system is a transactional data warehouse of sales revenue information for Equity, Fixed Income and Private Wealth Management divisions. Centralized repository of sales revenue data for the Firm.

Responsibilities:

• Analyzed the pros and cons of the existing model. Clearly understood the Business requirements.
• Studied the nature and huge contention of the feed files - Fixed Income (FID), Equity, Private Wealth Management divisions from OLTP system.
• Created ETL Informatica mappings to extract data from staging area which in turn are the extracts from Mainframe files and ETS extracts.
• Created Parameter files for imparting flexible runs of workflows based on the changes in variable values.
• Created sessions, reusable worklets in Workflow Manager and scheduled the sessions to run at a specified frequency.
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level
• Solid Expertise in using both Connected and Un connected Lookup transformations
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache, and Persistent Cache
• Developed Re usable Transformations, and Re Usable Mapplets
• Worked with Shortcuts across Shared and Non Shared Folders
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Improved the performance of Mappings to increase the efficiency of loading the data from various metrics to the target database.
• Used session logs to debug sessions.
• Scheduled Informatica sessions for automation of loads in Autosys.
• Gathered functional requirements and data specifications for Business Objects Reports.

Environment: Informatica 6.2, DB2, ERwin, Shell scripts, Business Objects XI, Windows 2000, Linux.

Confidential, Hyderabad, India
Client: Confidential, USA
Informatica Developer Dec'04-May'06

Confidential, is a telecommunications company and networks service platforms, that is a global provider of business communications systems. The project is to develop a system for monitoring mobile network elements and sales data for the Cingular service and implementing performance reports and maintaining the Network Data warehouse (NDW). Performance reports are used to find the problematic objects or areas in the network.

Responsibilities:

• Analyze and understand the requirement documents, and prepared design documents
• Preparation of Unit Test Plans and verification of functional specifications and review of deliverables.
• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database.
• Developed ETL mappings, Transformations and Loading using Informatica PowerCenter 6.1.
• Developed mappings and workflows as per business logic, quality and coding standards prescribed for the module using Informatica PowerCenter 6.1.
• Developed, implemented and enforced ETL best practices standards.
• Created mappings using transformations like Source Qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, Union, and Stored procedure, and XML transformations.
• Worked on Informatica PowerCenter tools - Source Analyzer, Warehouse Designer, Mapping & Mapplet Designer and Transformation Developer.
• Implemented Type I, II changes in slowly changing dimension tables.
• Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
• Performance tuning and bottleneck resolution.
• Created Unix Shell scripts to automate workflows.
• Used Workflow Manager for creating workflows, work lets, email and command tasks.
• Development of mappings in Informatica and reporting in Micro strategy and Business Objects.
• Performed regression Testing and Validation of data

Environment: Informatica PowerCenter 6.1, Oracle 9i, SQL*Plus, Toad, Windows 2000, Micro strategy, Mercury Quality Center