Untitled Document

Professional Summary:
Ï About 8 years of experience in Information Technology including Data Warehouse/Data Mart development using ETL/Informatica Power Center.
Ï Worked on various domains including Insurance, Finance, Banking, Pharmaceutical and Retail.
Ï Good exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation and production support.
Ï Worked in various Heterogeneous Source Systems like Oracle, DB2 UDB, Teradata, MS SQL Server, Flat files and Legacy systems. 
Ï Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
Ï Good understanding of views, Synonyms, Indexes, Joins and Sub-Queries. Extensively used Cursors and Ref Cursors.
Ï Expertise in creating very detailed design documents and performing Proof of Concepts (POC).
Ï Extensively created mapplets, common functions, reusable transformations, look-ups for better usability.
Ï Experience in Performance tuning of ETL process. Reduced the execution time for huge volumes of data for a company merger projects.
Ï Providing the right level of data quality management for the appropriate business user.
Ï Experience in Dataflux and informatica Data explorer (IDE)/Informatica Data Quality (IDQ) tools for data Analysis / Data Profiling and Data governance and Data Quality using First Logic.
Ï Worked withInformaticaServer and Client tools, experienceintheDataAnalysis, Design, Development, Implementation, Testing, Production Support of Database/Datawarehousing /Legacy applications for various industries usingDataModeling,DataExtraction,DataTransformation andDataLoading. 
Ï Extensive experience in Tuning and scaling the procedures for better performance by running explain plan and using different approaches like hint and bulk load.
Ï Used Power Exchange to integrate the sources like Mainframe MVS, VSAM, GDG, DB2 and XML files. 
Ï Experienced with Teradata utilities FastLoad, MultiLoad, BTEQ scripting, FastExport, SQL Assitant.
Ï Extensively used SQL, PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.
Ï Experience in using Exception Handling strategies to capture errors and referential integrity constraints of records during loading processes to notify the exception records to the source team.
Ï Experience in UNIX shell scripting, job scheduling and communicating with server using pmcmd.
Ï Delivered all the projects/assignments within specified timelines. 
Ï Worked on SAP Business Objects enterprise information management (EIM) solutions providing comprehensive information management functionality that can help you deliver integrated, accurate, and timely data – both structured and unstructured – across the enterprise. 
Ï Participating in problem solving and troubleshooting for the applications implemented with ODI. 
Ï Worked on managing Transaction Data and Reference Data.
Ï Knowledge of prebuild OBIEE Dashboard, RPD Metadata Process.
Ï Effectively communicate with business, project manager and team members.
Ï Responsible for Team Delivery and Participated in Design Reviews.
Ï Guided team members to deliver their task.
Ï Assisted Project Manager in estimation and planning.
Ï Strong ability to work within a demanding and aggressive project schedules and environments.
Ï Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills.

Technical Summary:

ETL Tools:

Informatica (Power Center/Power Mart) 9.0/8.6.1/8.1/7.1.2/6.2/5.1, Power Exchange, Power Connect, SQL Server SSIS/ DTS, Datastage 8.x/7.x

Databases:

Oracle10g/9i/8i, IBM UD2 DB2, Sybase, MS SQL Server 2008/2005/2000, Teradata v2r12/v2r6/v2r5

Programming Languages:

C, C++, SQL, PL/SQL, UNIX, XML, Java, .Net, c#

BI Tools:

Business Objects XI r3.1/r2/6.5.1/6.1a/5.1, Cognos,

Web Technologies:

JavaScript 1.2, HTML 4.0

Others:

Erwin 4.1.2/3.5.2, TOAD, SQL Loader, MS Office, Winscp (FTP), Autosys, Rational Clear Case/Clear Quest/ Req.pro, Control-M, Tivoli (IBM), MS.Visio, Harvest, Mercury Quality center (defects), TIBCO Active Exchange. Tidal Schedular.

Operating Systems:

Windows 2003/2000/NT, Unix - Sun Solaris, Linux, HP

Professional Experience:

Confidential, WI June ’12–Present 
Role: Sr. ETL/Informatica Developer

Northwestern Mutualis amutual companythat offers financial services, includinglife insurance,long-term care insurance,insurance annuities,mutual funds andemployee benefitservices. Northwestern Mutual also provides consultation on asset and income protection, personal needs,investments, financial planning,estate planning, trusts, business needs,retirement, and employee benefits.

Responsibilities:

• Created detailed Technical specifications for the ETL processes.
• Performed ILIT (Irrevocable Life Insurance Trust) implementation and replacement activities.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Used Informatica as ETL tool, and stored procedures to pull data from source systems/ files, cleanse, transform and load data into databases.
• Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• Developed the Informatica mappings using various transformations, Sessions and Workflows. SQL Server was the target database, Source database is a combination of Flat files, Oracle tables, People Soft, Excel files, CSV files etc.
• Worked with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
• Involved with the DBA in performance tuning of the Informatica sessions and workflows. Created the reusable transformations for better performance.
• Optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and mapplets.
• Involved in writing UNIX shell scripts for Informatics ETL tool to run the Sessions.
• Fixing and tracking mapping defects and implementing with enhancements.
• Worked on Deployment eRetriever GUI.
• Managing post production issues and delivering task/projects within specific timeline.
• Involved in the mirroring of the staging environment to production.
• Worked on Modification of Actuate report to upload and run reports on servers.
• Worked on Autosys to schedule jobs, define dependencies and etc.
• Collaborated with teams for migration and Production Deployment activities.
• Worked on all phases of multiple projects from initial concept through research and development, implementation, QA, to live production, by strict adherence to project timelines.
• Played a Vital role in requirement gathering, preparation of engineering gathering requirement specification.

Environment: Informatica Power Center 9.0.1, Oracle 10g, IBM UDB DB2, SQL server 2008, SSIS, docLoader, Embarcadero Rapid SQL 7.7.1, Autosys, Text Exceed 14, UNIX.

Confidential,MA Sep’11 – April’12 
Role: Sr. ETL/Informatica Developer

Staples are the world\'s largest office products company and a trusted source for office solutions. Implemented the enterprise data warehouse (EDW) to have a detailed view of the customer and products. As an ETL developer I was involved in creating various logical mappings for the data marts based on the business requirements that carry the data related to the customer having information about Daily Sales, Budgeting, and Product Details etc. 
Responsibilities:
Ï Evaluating business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow. 
Ï Created detailed Technical specifications for Data Warehouse and ETL processes.
Ï Used Informatica as ETL tool, and stored procedures to pull data from source systems/ files, cleanse, transform and load data into databases.
Ï Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
Ï Applying most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.
Ï Extensively practiced Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement. 
Ï Involved in Initial loads, Incremental loads; Daily loads to ensure that the data is loaded in the tables in a timely and appropriate manner. Involved in doing error handling, debugging and troubleshootingSessions using the Session logs, Debugger and Workflow Monitor. 
Ï Extensively worked in the performance tuning of SQL, ETL and other processes to optimize session performance.
Ï Involved with the DBA in performance tuning of the Informatica sessions and workflows. Created the reusable transformations for better performance. 
Ï Integrated the data into centralized location. Used migration, redesign and Evaluation approaches. 
Ï Worked extensively with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings. 
Ï Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
Ï Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
Ï Extensively used Power Exchange to integrate the sources like Mainframe MVS, DB2 and XML files.
Ï Performance Tuning of SQL queries, SQL and PL/SQL coding.
Ï Developed stored procedures using PL/SQL and driving scripts using Unix Shell Scripts.
Ï Expertise in Debugging and Performance tuning of targets, sources, mappings and sessions. Managed Scheduling of Tasks to run any time without any operator intervention. 
Ï Leveraged workflow manager for session management, database connection management and scheduling of jobs. 
Ï Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and mapplets. . 
Ï Scheduling Informatica jobs and implementing dependencies if necessary using Tidal Scheduler. 
Ï Responsible for performing SQL query optimization using Hints, Indexes and Explain plan.
Ï Played a Vital role in requirement gathering, preparation of engineering gathering requirement specification.
Ï Managed production issues and delivered all assignments/projects within specified time lines.

Environment: Informatica Power Center 8.6.1, Power Exchange, Oracle 10g,DB2 8.0, SQL server 2008, Staples Loader, Toad 7.0, Tidal EDW scheduler, UNIX.

Confidential,Temple Terrace, FL Feb’10 – Aug’11 
Role: Sr. ETL/Informatica Developer

Verizon Telecom is nation’s most reliable wireless network. Implemented the enterprise data warehouse (EDW) to have a detailed view of the customer. As an ETL developer I was involved in creating various logical mappings for the data marts based on the business requirements that carry the data related to the customer having information about Bill Payment, Dues, and Plan Details etc. 
Responsibilities:

• Analyze business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Responsible for Impact Analysis, upstream/downstream impacts.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Used Informatica as ETL tool, and stored procedures to pull data from source systems/ files, cleanse, transform and load data into databases.
• Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Successfully upgraded Informatica 7.1.2 to Informatica 8.6.1 and responsible for validating objects in new version of Informatica.
• Involved in Initial loads, Incremental loads; Daily loads to ensure that the data is loaded in the tables in a timely and appropriate manner.
• Extensively worked in the performance tuning of SQL, ETL and other processes to optimize session performance.
• Loaded data in to Teradata Target tables using Teradata Utilities (Fast Load, Multi Load, Fast Export). Queried the Target database using Teradata SQL and BTEQ for validation.
• Worked extensively with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
• Extensively used Power Exchange to integrate the sources like Mainframe MVS, VSAM, GDG, DB2 and XML files.
• Performance Tuning of SQL queries, SQL and PL/SQL coding.
• Developed stored procedures using PL/SQL and driving scripts using Unix Shell Scripts.
• Expertise in Debugging and Performance tuning of targets, sources, mappings and sessions.
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and mapplets.
• Scheduling Informatica jobs and implementing dependencies if necessary using Autosys.
• Responsible for performing SQL query optimization using Hints, Indexes and Explain plan.
• Managed postproduction issues and delivered all assignments/projects within specified time lines.

Environment: Informatica Power Center 9.0/8.6/7.1.2, Power Exchange, Oracle 10g, IBM UDB DB2, SQL server 2008, SSIS, Teradata, Business Objects Xi r3.1, Erwin 4.1.2, Toad, Winscp, Autosys, Rational Clear Case, Rational Req.pro, Rational Clear Quest, UNIX.

Confidential,NJ Jun ’08 – Feb ’10 
Role: Sr. ETL/Informatica Developer

Citi provides mobile banking services supporting 90% of banking activities that can be performed using the Internet banking portal. The mobile banking applications include Citi’s credit card services as well. The Citi mobile app is supported on smart phones like the Iphone, Android, Blackberry and Ipod Touch. The various features available on the mobile app are balances & activity, transfers, bill payment, services and locations. The mobile application, which is downloaded on to the phone, is called the thick client. The user can also type citi.com or citibankonline.com in their mobile browser to be redirected to the device recognized application called thin client where all the features of the mobile thick client are available. The thin client application was developed keeping in mind the mobile phones, which do not support mobile application, downloads.

Responsibilities:
Ï Responsible for design, development and maintenance of Data Marts including Sales, Policy, Customer Reporting and Claims leveraging Informatica Power Center ETL tool, Oracle, DB2 andPL/SQL.
Ï Worked with Business Analyst and application users to finalize Data Model, functional and detailed technical requirements.
Ï Responsible for the Corporate Data Model, the Enterprise Client/Server Case Tool, CASE methods and procedures, development of data models and reverse engineering of production systems. 
Ï Responsible for Data Warehouse Architecture, ETL and coding standards.
Ï Developed Capacity Planning/Architecture/ Strategic Roadmaps/Implementing standards.
Ï Used Informatica as ETL tool, and stored procedures to pull data from source systems/ files, cleanse, transform and load data into databases.
Ï Created detailed Technical specifications for Data Warehouse and ETL processes.
Ï Conducted a series of discussions with team members to convert Business rules into Informatica mappings.
Ï Extracted data from SAP R/3 and loaded into Oracle Data Warehouse.
Ï Used Transformations like Look up, Router, Filter, Joiner, Stored Procedure, Source Qualifier, Aggregator and Update Strategy extensively.
Ï Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
Ï Created Mapplets and used them in different Mappings.
Ï Developed stored procedure to check source data with warehouse data and if not present, write the records to spool table and used spool table as lookup in transformation.
Ï Done extensive bulk loading into the target using Oracle SQL Loader.
Ï Did Application tunning, Memory tunning and Disk I/O tunning to enhance the performance of the system.
Ï Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor. 
Ï Created dictionaries using Informatica Data Quality (IDQ) that was used to cleanse and standardized Data. Worked with Informatica and other consultants to develop IDQ plans to identify possible data issues. 
Ï Documented Cleansing Rules discovered from data cleansing and profiling.
Ï Managed Scheduling of Tasks to run any time without nay operator intervention. 
Ï Leveraged workflow manager for session management, database connection management and scheduling of jobs.
Ï Created Unix Shell Scripts for Informatica ETL tool to automate sessions and cleansing the source data.
Ï Experienced in Debugging and Performance tuning of targets, sources, mappings and sessions
Ï Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and mapplets. 
Ï Delivered all the projects/assignments within specified timelines.

Environment: Informatica Power Center 8.1, Oracle 9i, Power Exchange, SAP R/3, Flat files, MS SQL server 2005, DB2 8.0, Erwin 4.1.2, Winscp, Control-M, MS. Visio, Harvest, Mercury Quality Center, Shell Script, UNIX. 

Confidential,IN Oct ’06 – June ’08 Role: ETL/Informatica Developer

Eli Lilly is now the 10th largest pharmaceutical company in the world. Lilly\'s global employees number approximately 40,000, and its medicines are marketed in 143 countries. Lilly has major research and development facilities in eight countries and conducts clinical trials in more than 50 countries

Responsibilities:
Ï Analyzed existing system prepared and presented an Impact Analysis Document.
Ï Actively participated in the design, development and implementations of the Enterprise Data Warehouse (EDW) process and Data mart.
Ï Created Several Informatica Mappings to populate the data into dimensions and fact tables.
Ï Worked as a Informatica Administrator. 
Ï As per Change requests (CR) migration of objects in all phases (DEV, QA and PRD) of project.
Ï Ability to perform root cause analysis, performance monitoring and application related issues 
Ï Configured the Repositories.
Ï Developed various mappings by using reusable transformations.
Ï Executed the workflow using pmcmd command in UNIX.
Ï Improved the mapping performance using SQL overrides.
Ï Created Mapplets and used them in different mappings.
Ï Used Debugger to test the data flow and fix the mappings.
Ï Implemented Error data validations using Error handling strategy techniques.
Ï Tuning Informatica Mappings and Sessions for optimum performance.
Ï Implemented all the ETL Architecture standards for the new technology Teradata 
Ï Post-Production support to monitor jobs in new environment.
Ï Developed mappings, sessions and workflows for the new ETL process followed with Quality
standards.
Ï Responsible for QA migration and Production Deployment.
Ï Used various transformations for data Manipulation.
Ï Most of the transformations were used like Source Qualifier, Aggregator, Filter, Expression, and Unconnected and connected Lookups, Update Strategy and Normalizer.
Ï Developed and implemented the long term IT goals and strategies.
Ï Participate in the rotation of 24/7 supports.

Environment: Informatica Power Center 7.1.2, Oracle 8i, Flat files, SQL server 2005, Analytics Server 3.1.2, Business Objects 6.0, Shell / Perl Script, Sun Solaris OS, PL/SQL, Toad 7.0, Erwin 3.5.2.

Confidential,New York, NY Nov ’05 – Sep ’06 Role: Data Warehousing Developer

Barclays was established more than 300 years ago. It has grown to offer a range of products and services tailored to meet the specific needs of its customers all over the world. As a responsible global citizen, Barclays is committed to ensuring the sustainability of the communities in which the business operates, and strives for sustainable relationships with customers and clients worldwide.

Responsibilities:
Ï Developing Informatica mappings and shell scripts for loading trading and clearing data from various clients.
Ï Actively participated in a team in the logical and physical design of the data warehouse.
Ï Closely associated with data architect in resolving the data issues. 
Ï Developed the Informatica mappings using various transformations, Sessions and Workflows. SQL Server was the target database, Source database is a combination of Flat files, Oracle tables, People Soft, Excel files, CSV files etc.
Ï Involved in creating stored procedure to support recovery. 
Ï Responsible for working closely with the Informatica administrator to migrate Source and Target definitions, Mappings, Workflows, and Flat Files from development environment to the productionenvironment.
Ï Extensively used the Lookup and Update Strategy Transformations for implementing the Slowly Changing Dimensions.
Ï Used different tasks like Email, Command task. 
Ï Worked with the Informatica Administrator in migrating the mappings, sessions, source/target definitions from the development repository to the production environment.
Ï Involved with the DBA in performance tuning of the Informatica sessions and workflows. Created the reusable transformations for better performance.
Ï Involved in the mirroring of the staging environment to production.
Ï Created and reviewed the Design and Code review Templates.
Ï As a part of the testing team, Involved in conducting the Unit tests and System tests.
Ï Scheduling jobs using Autosys to automate the Informatica Sessions.
Ï Optimizing the Autosys batch flow.
Ï Developing control files, Stored Procedures to manipulate and load the data into Oracle database 
Ï Optimizing queries using SQL Navigator

Environment: Informatica Power Center 7.1.3, Sun Solaris, Shell Scripts, Oracle 8i, PL/SQL, Pro*C, SQL Loader, Discoverer 2000, SQL Server, Autosys, DB2, Erwin 3.5.2.

Confidential,India Apr’04 – Sep ’05 Data Warehousing Consultant
Client: CHEMIDEX, Kansas

Successfully developed and maintained ETL maps to Extract, Transform and Load data from 
various data sources to the Enterprise Data warehouse called PMS (Product Management System).The data warehouse contained information regarding sales data, purchase data, valued customer information, employee information. The projects aim to help make decisions for new product improvements, analysis of existing products.

Responsibilities:
Ï Imported various Sources, Targets, and Transformations using Informatica Power Center Server Manager, Repository Manager and Designer.
Ï Created and managed the global and local repositories and permissions using Repository Manager in Oracle Database.
Ï Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
Ï Used heterogeneous files from Oracle, Flat files and SQL server as source and imported stored procedures from oracle for transformations.
Ï Designed and coded maps, which extracted data from existing, source systems into the data warehouse. 
Ï Used Dimensional Modeling Techniques to create Dimensions, Cubes and Fact tables. 
Ï Written PL/SQL procedures for processing business logic in the database. Tuned SQL queries for better performance.
Ï Scheduled Sessions and Batch Process based on demand, run on time, run only once using Informatica Server Manager.
Ï Generated completion messages and status reports using Informatica Server manager.
Ï Tuned ETL procedures and STAR schemas to optimize load and query Performance.
Ï Starting Sessions and Batches and make Event based scheduling
Ï Managed migration in a multi-vendor supported Server and Database environments.

Environment: Informatica Power Center 6.2, SQL/PLSQL, UNIX Shell Scripts, Oracle 8i, Business Objects 5.1.6