SUMMARY:

• Eight Plus Years of IT experience in Software Analysis, Development and Implementation of business applications.
• Six Years of ETL and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter 8.x/7.x/6.x using Designer(Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor.
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in Performance tuning of targets, sources, mappings and sessions.
• Knowledge in Informatica Data Explorer and Informatica Data Quality.
• Extensive experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, Teradata ,XML,DB2, Oracle, SQL Server.
• Hands on experience in reporting tools like Business Objects and Cognos Impromptu.
• Data modeling knowledge using Dimensional Data Modeling, Star Schema Modeling, FACT and Dimensions Tables.
• Hands on experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
• Developed UNIX shell scripts to run Informatica Workflows.
• Excellent knowledge and experience in creating source to target mapping, edit rules and validation, transformations, and business rules.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
  

TECHNICAL SKILLS:

ETL Tools: Informatica 6.2,7.1,8.1.1.8.6
RDBMS: Oracle 8i/9i/10g (SQL, PL/SQL, Stored Procedures, Triggers),
Teradata 4.x/5.0, SQL server, DB2
OLAP: Business Objects 5.1,6.1,6.5 Info View, Web intelligence 2.6,6.0,Cognos Suite
Operating Systems:UNIX (HP Unix, LINUX, AIX), Windows NT/98/95, WIN 2000
Data Modeling: Erwin 4.0, MS Visio 2000
Programming: XML, Visual Basic 6.0/5.0, SQL, PL/SQL, Unix Shell Scripting
(Korn, C), Transact-SQL, and COBOL
Environment: IBM AIX 5.x, Sun Solaris 2.6/2.7, HP-UX, Linux,
MS Windows Server 2003 / XP / NT / 2000 / 98
Hardware: HP 9000, Sun SPARC V, Intel Pentiums
Other Software: SQL *Loader, TOAD, SQL Navigator 4.2, VNC Viewer, and MS Visio 2000

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH Mar’09 - Till Date
Sr.Informatica Developer/Architect/Admin

Project: Huntington Data Warehouse (FODW)

Worked on design, development and implementation FODW (Finance and Operations Data Warehouse). This project allows the company to store historical information of its credit card holders, account holders, respective credit scores of all its customers and also for generation of detailed monthly reports based on the company business requirements.

Responsibilities:

• Involved in collecting requirements, analyzing data, design and development of Data warehouse.
• Used Erwin for logical and Physical database modeling of the warehouse, responsible for Database schemas creation based on the logical models.
• Involved in complete Design, Build, Test, QA, and Deploy of the Project
• Coordinated off shore team and provided training in understanding business requirements and performed code reviews.
• Change Data Capture (CDC) using Power Exchange
• Involved in creation of Technical specification document (Source to Target) for the project by conducting technical meetings.
• Administration responsibilities included creating Database connection, Cleaning log Files, Repository backups, Creating folders.
• Manage Repositories using Repository Server Administration Console
• Extensive experience in loading the data from multiple sources like flat files and other RDBMS databases.
• Handled various data sources like Relational, VSAM, DB2, SQL server,XML, Oracle
• Helped in migrating from version 7.1.1 to version 8.6 of informatica Power center on Windows environment
• Involved in Establishing Data Quality Processes by performing Store and correct, unambiguous, consistent, complete and accurate data in the enterprise data warehouse and ensure data Integrity
• Extensively worked on Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer to Extract Sources, Transform Data andLoad into Target.
• Build Workflows and Worklets to schedule, sequence and parameterize data loads into the different Datamarts and the Enterprise Data Warehouse.
• Involved in analyzing and writing complex procedures and queries to extract data from SQL Server.
• Worked on Informatica Power Exchange to pull data from SAP system
• Used Business Objects to check the validity of the data in the Data Warehouse. Created the reports using Business Objects functionality like Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail and Formula.
• Involved in Increasing ETL process performance by identifying performance bottlenecks, eliminating them, and then identifying the next performance bottleneck until the mapping flow performance is the optimum.Configure single-pass reading to reduce the number of times the Integration Service reads sources. Optimized filters. to maximize session performance, only process records that belong in the pipeline
• Worked on various Transformations like Connected and Remote Lookup, Aggregator, Expression, Filter, Router, Update Strategy, Stored Procedure and Sequence Generator, Sorter.
• Interacting with the users and making changes to Informatica mappings according to the Business requirements
• Used FastLoad and MultiLoad Types to load the data into the Teradata Database Tables.
• Created UNIX shell scripts for Informatica jobs automation.
• Created and monitored sessions using Informatica Server and Workflow monitor.
• Used debuggers to detect bugs in mappings with development data.
• Involved in unit testing of the mapping and mapplets.

Environment: Informatica Power Center 8.6, Oracle 10g, SQL Server 2008, UNIX, Teradata,Business Objects XI, SQL Developer, DB2,SQL, PL/SQL, Erwin 4.0,Toad, Windows XP.

Confidential Cincinnati, OH Apr’08 -Feb’09
Sr Informatica Developer

Provident Bank is one of the leading community banks in US. The objective of this project was to create a Consolidate Reporting Project. Build a data mart for the Retail Customer Service department. The data is from the call center coming from different Cisco modules like ICM, IVR and IEX etc. These tools populate data in the database, which is pulled to design the data mart

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, pilot, training and rollout to the field user and support for production environment.
• Extensively Designed, Developed, Tested complex Informatica mappings, mapplets and Reusable Transformations to load data from various sources.
• Design the Informatica ETL architecture that transfers data from different heterogeneous source systems to the Targets according to the business rules.
• Extensively Worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer andMapping Designer.
• Extensively used all the transformations like source qualifier, aggregator, filter, joiner, Sorter, Lookup, Update Strategy, Router, Sequence Generator etc. and used transformation language likes transformation expression, constants, system variables, data format strings etc.
• Created workflow design document, mapping design document, Integration test plan document, Unit test plan document etc.
• Modeled the Data Warehousing Data marts using Star Schema, Built Dimension Tables and Fact Tables.
• Involved in running the loads to the data warehouse and data mart involving different environments.
• Used the update strategy to effectively migrate data from source to target.
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.
• Created, Configured and Scheduled the Sessions and Batches for different mappings using workflow Manager and Unix Scripts.
• Integrated various sources into the Staging area in Data warehouse.
• Used Power Connect to extract data from other systems.
• Created necessary Repositories to handle the Metadata in the ETL process.
• Created the Source and Target Definitions in Informatica Power Center Designer.
• Developed shell scripts to automate the data loading process and to cleanse the flat file inputs
• Created validation routines, unit test cases and test plan.

Environment: Informatica Power Center 8.1.1(Infromatica Server, Infromatica Repository Server, Repository Manager, Designer, Workflow Manager and Workflow Moniter), Power Connect, Cognos Suite(Impromptu 7.2/7.3, PowerPlay 7.2/7.3, Transformer) Oracle 9i, PL/SQL, SQL*PLUS, SQL*LOADER, RDBMS, Teradata, DB2,ERWIN 3.5, Unix Shell Scripting.

Confidential Chicago, IL May’07 - Mar’08 Sr Informatica Developer/Architect/Admin

Exelon Energy is a retail energy marketer specializing in the supply of natural gas and electricity to commercial and industrial customers. Exelon Energy has been serving customers since 1998. Exelon Energy markets electricity to customers in Illinois and Michigan and natural gas to customers in Illinois, Michigan, and Ohio.

Responsibilities:

• Converted the business requirements into technical specifications for ETL process.
• Worked with PeopleSoft team to identify the best means of extraction of source and source data validation directly from PS tables.
• Developed Informatica Mappings/Sessions to populate the Data Warehouse and Data Mart.
• Worked on modifying/ updating PL/SQL codes, views, matviews and stored procedure, triggers and packages.
• Upgraded Informatica Power center from 7.x to 8.x.
• Coordinating with source system owners, day-to-day ETL progress monitoring and maintenance of daily Informatica batch schedule run on a nightly basis.
• Developed complex mappings using Informatica Power Center Designer to transform and load data from various source systems like Flat files, Mainframe DB2 IBM MQ Series, SQL Server.
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet designer and Transformations
• Worked on various Transformations such as Source Qualifier, Expression, Aggregator, Stored procedure, Connected & Unconnected lookups, Filter, Rank, Router, Sequence Generator, Sorter, Joiner and Update Strategy.
• Worked on creating mapplets and reusable transformations to prevent redundancy of transfomation usage and maintainability.
• Used Workflow Manager for Workflow and Session Management, Database Connection Management and Scheduling of jobs.
• Developed SQL overrides in Source Qualifier according to the business requirements.
• Configured mapping parameters and variables and defined in the Parameter file and made the entire Session environment independent.
• Created post-session and pre-session shell scripts and email-notifications.
• Involved in Performance Tuning of Targets, Sources, Mappings and Sessions.
• Created Unix Shell Scripts to control the execution of Workflow.
• Scheduled and monitored automated weekly jobs.
• Assisted in Unit and System Testing of developed mappings.

Environment: Informatica Power Center 8.1.1/7.1, Informatica Powerconnect (Repository Manager, Designer, Server Manager, Workflow Monitor, Workflow Manager), Power Exchange, Business Objects,Windows NT, Mainframes, Autosys, TOAD, Oracle 9i, SQL*Loader, Unix Scripting, PL/SQL, Shell Programming.

Confidential Cleveland, OH Sep’06 - Apr’07
Sr.Informatica Developer

The Progressive group of companies ranks third in the nation for healthcare insurance, with more than 12 million customers in U.S. The Insurance warehouse was built for the users to analyze the detailed transactions related to the insurance policies and also the transactions generated by claims processing. Data residing in SQL Server, flat files are consolidated onto target warehouse database built on Oracle. Reports were generated for the users using Business Objects.

Responsibilities:

• Involved in the Data warehouse data modeling based on the client requirements
• Developed Logical and physical database designs for the transaction system.
• Responsible for migrating the folders or mappings/workflows from development to production environment, Created shortcuts to share the repository objects
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the activities.
• Responsible for configuring the Workflow manager, Repository Server Administration Console, PowerCenter Server, Database Connection
• Performance tuning on sources, targets, mappings and SQL queries in the transformations
• Created reusable transformations and mapplets based on the business rules to ease the development
• Used various Informatica Error handling technique to debug failed session
• Done various optimization techniques in Aggregator, Lookup, Joiner transformation
• Developed mapping to implement Type 2 SCD\'s
• Used various debugging techniques to debug the mappings
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality.
• Created Materialized view for summary data to improve the query performance
• Responsible for loading data into warehouse from different sources using Oracle loader to load millions of records and used Import/Export utility to load small tables.
• Responsible for scheduling the workflow based on the nightly load.
• Supported Oracle 9i databases running mission critical 24*7 systems.

Environment: Informatica Power Center 7.1.2, Oracle 9i, SQL, HP/UX, Erwin Data Modeler, MS Visio, TOAD Tool, Windows XP, Teradata.

Confidential Cary, NC Nov’05 - Aug’06
Informatica Developer

Confidential provides online and mobile search marketing via their DexKnows.com website, print yellow pages directories, voice based search platforms and pay-per-click ad networks in the U.S. The company also maintains a business search engine and online directory through its Business.com subsidiary.

Responsibilities:

• Analyzed and created Fact and Dimension table for Star schema.
• Worked closely with business analysts to understand the business needs for decision support data,Extraction, Transformation and Load was performed using Informatica PowerCenter to build the data Mart.
• Extensively worked on Type 1 and Type 2 SCD\'s.
• Worked on various transformations like Aggerator, Router, Filter, Expression based on the business requirement.
• Worked on creating mapplets and reusable transformations to prevent redundancy of transfomation usage and maintainability.
• Involved in Performance Tuning of Targets, Sources, Mappings and Sessions.
• Created session partitions to increase the performance of Informatica Server Manager.Debugged mappings for failed Sessions.
• Used Autosys for scheduling of jobs.

Environment: Informatica Power Center 7.1, Oracle 9i, TOAD, PL/SQL, Sybase, Flat files, Solaris, Autosys, Windows NT/XP.

Confidential Thousand Oaks, CA Jan’05 - Oct’05
Informatica Developer

Contract and Chargebacks System (Amgen-CCS): Amgen-CCS Data warehouse collect, denormalize and integrate data from its operational database, as well as third-party hospital, pharmacies and physician patient’s reports to provide critical analytical data for decision makers. Informatica Powercenter is used to extract, transform and load the data from staging area built through Oracle 9i snapshot replication of operational database into the data warehouse implemented in Oracle 9i.

• Analyzed the business requirements and framing the business logic for the ETL process.
• Extensively used ETL to load data from fixed width as well as Delimited Flat files, COBOL files.
• Worked extensively on different types of transformations like normalizer, expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator and joiner
• Designed and Developed complex mappings, reusable Transformations.
• Implemented variables and parameters in the mappings
• Scheduling the Workflows using Workflow Manager.
• Created Sessions, workflows and worklets for designed mappings.
• Involved in writing ETL specifications and unit test plans for the mappings.
• Extensively worked in performance tuning of programs, ETL procedures and processes. Also used debugger to troubleshoot logical errors.
• Worked on Stored Procedures, triggers, views and indexes.
• Written SQL overrides in source Qualifier according to business requirements.
• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
• Migrated the mappings to the testing and production environment.

Environment: Informatica Powercenter 6.2, DB2, Oracle 9i,SQL, PL/SQL, UNIX, Teradata, WindowsNT.

Confidential Hyderabad, India Aug’03 - Oct’04
Oracle Developer

ICICI Bank offers a wide range of banking products and financial services to corporate and retail customers through a variety of delivery channels and affiliates in the areas of investment banking, life and non-life insurance, venture capital and asset management. Designed and modified various applications using Oracle and Developer 2000 (Forms, Reports). Developed various forms and reports for departments such as; quality control, warehouse and finance. This includes developing the user requested forms for data entry for the end users and its respective reports for managerial view using Developer 2000.

Responsibilities:

• Developed / modified PL/SQL code like stored procedures, packages etc for interface.
• Involved in Unit testing, Integration testing and Load testing of the interface.
• Involved in documenting the modifications and intended functionalities of the interface.
• Helped in creating technical specifications by mapping the interface tables with the base tables.
• Helped Project Lead to develop various reports as needed by management.

Environment: Oracle 8i,SQL*Plus, PL / SQL, Windows 2000.

Confidential Hyderabad, India Jan’02- Jul’03
PL/SQL Developer

This Project involves of automation of Loading Monthly Electrical Bill of Company employees who are residing in Company quarters into the oracle database. The activity involves loading of Excel file (csv format) into the oracle database in fast and efficient manner by using SQL-Loader utility.

Responsibilities:

• Created database objects including tables, indexes, roles, clusters, sequence and privileges.
• Calculated and monitored size and space for tables, clusters and indexes.
• Created and maintained triggers, packages, functions and procedures.
• Wrote procedures to replicate data from one table to another.
• Involved in generating SQL Reports.
• Debugging system application tuning by identifying long running reports.

Environment: Oracle 8i, SQL*Plus, PL/SQL, Sun Solaris, Windows NT

Education:

Bachelors in Engineering,Confidential, India