SUMMARY

• More than 7 Years of ETL Experience (Informatica, SSIS)
• 4 Years of experience on Teradata, Oracle, DB2, SQL Server 2000/2005/2008.
• 3 Years of Experience on Data Modeling
• 1Years of Experience on Reporting tools (Business Objects, Micro Strategy, Cognos)
• Over 7 years of experience in Full life cycle of Software Development (SDLC) including Business Requirement Gathering & Analysis, System study, Application Design, Development, testing, Implementation, System Maintenance, Support and Documentation.
• Extensive work experience in the areas of Financial, Healthcare, Insurance, Telecom, Sales and Manufacturing domains.
• Enterprise Data Warehousing: Experience and Expertise with Data Warehousing Architecture on the Design, Development, and loading of Data into a Data warehouse using Informatica Power Center 9.6.1/ 9.5.1/9.1.0/8. x/7.x, Informatica Developer 9.6.1, Informatica Data Quality 9.1, Informatica Data Transformation Studio 9.6.1 and Informatica Power Exchange 9.5.1/9.1.0/8. x
• Well versed with Performance Tuning of ETL process including Power Center mappings and work flows.
• Experience and Expertise in Operational Data Store (ODS) design, Data warehouse and Data mart design methodologies such as Star and Snowflake schemas, designing slowly changing dimension and fact tables.
• Worked with mainframe Copybooks to define Mainframe source definitions in Power Center.
• Expertise in extracting data from various source systems like Oracle, Mainframe, DB2, Teradata, SQL Server, Flat files and XML files and loading into Data warehouse ODS systems and downstream systems.
• Expertise in creating ETL mappings using XML Source Qualifier, XML Parser and XML Generator to load data from XML Applications to downstream systems.
• Expertise on working with WebServices Consumer transformation to fetch values from WebServices applications also experienced in using SoapUI for unit testing.
• Expertise in creation of reference ports in XML and WebServices transformations and trouble shooting them as well.
• Expertise in using Teradata Fast Export, MLoad, Fload, Tpump, TPT and B - TEQ utilities.
• Expertise in using Informatica B2B transformation available in Informatica Developer client with XMAP option.
• Experience in developing suitable Error Handling methods and simplification of data flow processes to the best of requirements.
• Knowledge on FadePlus- a mainframe based policy admin software.
• Experience on Informatica Administration tasks like Informatica installation, upgrade, set up new users and collects informatica stats, logs.
• Expertise in documentation and maintenance of versioning, deployment instructions and production install plans.
• Extensive knowledge on Analyzing the Software Requirement Specifications and Software Development Life Cycle (SDLC) like water fall and agile methodologies.
• Extensive experience in Production support management involving Informatica, Oracle, Unix and Mainframes.
• Good understanding and knowledge of BI tools like Cognos, Microstrategy
• Thorough knowledge in Data Modeling Concepts (Kimball and Inmon), Star and Snowflake Schema addressing Slowly Changing Dimensions(SCDs)
• Comprehensive analytical, interpersonal and communicational skills
• Experienced in developing Test Plans, Test Strategies and Test Cases for Data Warehousing projects ensuring the data meets the business requirements.
• Extensive experience in managing teams Onsite/Offshore coordination, Requirement Analysis, Code reviews, implementing standards, Production release management.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6/9.5/9.1/8. x/7.x/6.x, Informatica Developer 9.6/9.5, Power Exchange 9.1/8.x/7.x, Informatica Data transformation Studio 9.5.1, Informatica Data Quality, Informatica Meta Data Manager, SSIS and DTS Packages.

Data Modeling Tools: Dimensional Data Modeling using Star & Snow Flake schema, Erwin 4.5/4.0/3.5/3.0 and Oracle Designer

Databases: Oracle 11g/10g/9i/8i, DB2, SQL Server 2000/2003/2005/2008 , Teradataa 12,11,V2R6/V2R4

RDMS Load Tools: SQL*Loader, MS SQL Server 2005/2000/7.0 , MS Access 07/03.

OLAP: Business Objects, Cognos 7/8

Languages: JAVA, C, Cobol, XML, HTML, Visual Basic, SQL, PL/SQL, Perl, Shell Scripting.

Operating System: Windows 2007/2003/XP, Red Hat Linux, UNIX (Solaris, HP-UX, AIX).

Office Applications: MS-Office 2010/2007/2003

Other Tools: TOAD, Control M, SQL Plus, Autosys, ClearCase, SQL Developer

Other Applications: Web Services, MQSeries, WebSphere. Data Flux, IDQ.

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

Sr. ETL Developer

Responsibilities:

• Worked with business analysts for requirement gathering (BRD), business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Interacted with both Technical, functional and business audiences across different phases of the project life cycle.
• Extensively used all the regular Transformations available in Power Center designer.
• Created mappings using XML transformations XML Source Qualifier, XML Parser and XML Generator to process data from XML Sources.
• Used WebServices Consumer transformation to look up values in WebServices applications. Created reference ports in WebServices Consumer transformation and assigned keys to correlate the output data from Web Services inquiries.
• Extensively used Informatica B2B Data transformation to process complex XML files to target interface specific schemas, and processed them in Power Center by using UDT transformation.
• Created variables and list variables, used router and look up options in XMap and proficient in using xpath in XMap.
• Imported Source/Target Tables from various databases and created reusable transformations in a mapplet and created new mappings using Designer module of Informatica
• Extensively used incremental aggregation for CDC (Changed Data Capture).
• Designed and developed complex ETL mappings by making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Working directly with System Analysts, Application Analysts and Database administrators to ensure data efficiency and integrity.
• Worked on PowerExchange bulk data movement processes by using PowerExchange Change Data Capture (CDC) method.
• Extract and Load data using different tools available in Teradata like Multiload, FastExport, Fastload and BTEQ.
• Written and used UNIX shell scripts extensively for scheduling and pre/post session management.
• Created Workflows using various tasks like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment and worked on scheduling of the workflows.
• Used mapping parameters and variables.
• Prepared mapping specification document, which gives the data flow and transformation logic for populating each column in the data warehouse table.
• Used debugger to analyze the data flow between source and target to fix the data issues.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Used SQL Loader to load huge flat files into Oracle database.
• Worked with PowerCenter parameter file which is a list of parameters and variables and their associated values, includes information for multiple services, service processes, workflows, worklets, and sessions in a single parameter file.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Created the release requests for QA Builds to include all the release requirements and involved in the implementation of QA, UAT and Production releases.
• Extensive knowledge on Analyzing the Software Requirement Specifications and Software Development Life Cycle (SDLC) like water fall and agile methodologies.
• Developed a UNIX Shell scripts which will send the reports to client over the network by using file transfer protocol (FTP & SFTP) and generating the log file, which will keep the history for the FTP reports.
• Executed Informatica workflows using PMCMD utility through UNIX scripts.
• Provided data loading, monitoring, System support and worked on data issues raised by end user during its production support phase.

Environment: Informatica Power Center9.5, Informatica Developer 9.5, Power Exchange 9.1, Business Objects, Oracle 11g, Teradata v12, DB2, SQL, PL/SQL, SQL Server, Erwin 4.0, UNIX-AIX, XML, Web Services, UNIX shell programming, Perl, Control M, TOAD.

Confidential, Florida

Sr. ETL Developer

Responsibilities:

• Involved in CompleteSoftware Development Lifecycle(SDLC) like water fall and Agile methodologies from Business Analysis to Development, Testing, Deployment and Documentation.
• Conducted meetings with DBAs for preparing the database table layouts.
• Analyzed the DW project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analyzed.
• Experience with high volume datasets from various sources like Oracle, Text Files.
• Created logical schema using ERWIN 3.x and also created the Dimension Modeling for building the Cubes. Involved in creating the physical databases. Wrote stored procedures to automate the process involved.
• Working with business units to identify mapping specifications.
• Created the ETL test plans and implemented the Code Review, Formal Testing, and Specification Testing using the Test Director.
• Implementing the standardized process to archive flat files and for loading indicator files.
• Utilizing the MS Access database for the conversions that are (one time data conversions) for translations that are in Excel or CSV format.
• Creating mapplets and reusable transformations.
• Implementing the error handling strategy process for all interfaces to avoid errors during the live environment and migrated the objects from the Dev, QA to Production Environment.
• Performing code review, formal testing, optional testing, and specification review using Test Director.
• Involved in migration projects tomigrate datafrom data warehouses on Oracle/DB2 and migrated those toTeradata.
• Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager and Informatica Power Exchange.
• Performance tuned and optimized various complex SQL queries.
• Worked on data warehouses with sizes from 30-50 Terabytes

Environment: Informatica Power Center9.1, Power Exchange 9.1, Micro Strategy, Oracle 11g, Teradata v12, DB2, SQL, PL/SQL, SQL Server, SAP ECC, SAP BW 7.1. Erwin 4.0, UNIX-AIX, XML, Web Services, UNIX shell programming, Perl, Control M, TOAD.

Confidential, Atlanta, GA

Sr. ETL Developer

Responsibilities:

• Understanding the Technical Spec and Develop an ETL process to load data from source to target.
• Involved in designing the mappings between sources and targets and also tuned them for better performance.
• Worked with PMREP command to get list of object details, Workflow,Source,Target,Mapplet,
• Transformation, Export Object, find checkouts, connections, Validate, Modify Folder Owner and Permission. Object Import.
• Worked with PMCMD command to Start workflows, Start task, Stop, Abort workflows and Sessions, Schedule the workflows
• Created Migration Documentation and Process Flow for mappings and sessions.
• Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Aggregator Expression, Joiner, lookup, Filters, Router and update strategy.
• Scheduled and executed sessions, sequential and concurrent batches for proper execution of mappings; sent notification e-mails using Server Manager.
• Performed various update strategies using Lookup and Update Strategy transformations
• Created templates for presenting results and Analytics and modified the OBIEE Dashboards
• Implemented security object level to restrict users from accessing unauthorized object.
• Worked extensively on Answers to create the reports as per the Client Requirements.
• Done Unit Testing and prepared the parameter file for creating the connection’s in UNIX.
• Involved in Production deployments, Data purging etc.

Environment: Informatica Power Center 9.1, Oracle 10g, Teradata 11, SQL, PL/SQL, Oracle, DB2, Siebel, SQL Server, XML,AS 400, MS Access, SAP ECC, SAP BW 7.1, Teradata V2R6, Windows 2003, Control M, UNIX-HP, UDB DB2, Business Objects XIR2.

Confidential, CT

Sr. ETL Developer

Responsibilities:

• Worked closely with the Business Analyst for gathering business requirements.
• Created Mappings, Mapplets and Transformations using the Designer and developed Informatica sessions using Workflow Manager as per the business requirement.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Extensive performance tuning by determining bottlenecks Confidential various points like targets, sources, mappings and sessions.
• Worked on Source Analyzer, Warehouse designer, Mapping, Mapplet Designer, Transformations, Informatica Repository Manager, Workflow Manager and Monitor.
• Tested all the Informatica mappings individually as well as with the entire process.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Identified key dimensions and facts for analytical reporting and decisions support reporting to develop custom reports in Business objects.
• Designed the procedures for getting the data from all systems to Data Warehousing system.
• Process design documentation of the Data Warehouse Dimensional Upgrades.
• Assisted in the design of report layouts to maximize usability and business relevance.
• Conducted end user technical training on reporting tools.
• Extensively used the Teradata utilities like BTEQ, Fast load, Multi load, DDL and DML Commands (SQL).
• Involved in Unit & Integration testing of the system.
• Business Objects XI was used for the generation of reports and involved in the trouble shooting of generating reports.

Environment: Informatica Power Center 8.6/8.1, Business Objects XI, Sybase 7.4.0, Flat files, Teradata, Oracle 10g/9i, UNIX (HP-UX), Windows NT, Dot Net Framework, IIS 5.0, C#, ADO.NET, Win Forms, MS-SQL Server.

Confidential

Data Warehouse Developer

Responsibilities:

• Worked on Informatica - Source Analyzer, Data warehousing designer, Mapping Designer and Transformations
• Worked with Transformations like Source Qualifier, Aggregator, Expression, Lookup, update strategy, Filters, Stored procedure, Router are mostly used
• Created mappings and Mapplets and also tuned them for better performance.
• Extensively involved in data Extraction, Transformation and loading (ETL Process) from source to target using Informatica
• Designed data warehouse using Star Schema.
• Importing source, target tables from respective databases and created reusable transformations and mappings using Designer Tool set of Informatica
• Scheduled workflows using workflow manager& workflow monitor
• Extensively Involved in Preparation of Technical Specifications
• Prepared Unit Test cases for unit testing and Specification Requirements.

Environment: Informatica 7.4/7.1, Oracle 9i, SQL* Loader, Windows 2000 / NT, Toad