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 with Informatica Server and Client tools, experiencein the Data Analysis, Design, Development, Implementation, Testing, Production Support of Database/Datawarehousing /Legacy applications for various industries using Data Modeling,Data Extraction,Data Transformation and Data Loading.
• 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.
• Worked on ADDM and Enterprise manager TKprof and Statspak for performance tunning.
• 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.
• 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.
• 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 SKILLS

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: Oracle 10g/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.

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

PROFESSIONAL EXPERIENCE

Confidential, Temple Terrace, FL

Sr. ETL/Informatica Developer

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 later to 9.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.
• 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, 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

Sr. ETL/Informatica Developer

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 and PL/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

ETL/Informatica Developer

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.
• 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

Data Warehousing Developer

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 production environment.
• 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

Data Warehousing Consultant

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