PROFESSIONAL SUMMARY:

• 9+ years of experience in the field of Data warehousing with expertise in the ETL
• Strong expertise in the design and development of ETL processes using Informatica PowerCenter
• Strong experience in creating the Workflows, Worklets, Mappings, Mapplets, Reusable transformations and scheduling the Workflows and sessions using Informatica Power Center
• Worked extensively in the testing and performance monitoring and tuning of ETL jobs
• Strong analytical and conceptual skills in database design and development
• Familiar with reporting tools such as Cognos
• Worked on very large Teradata, Oracle and UDB DB2 databases. Thorough knowledge in RDBMS Concepts and Extensive experience in database programming and performance tuning.
• Experience in writing UNIX Shell scripts
• Experience in Scheduling Jobs using Redwood Cronacle
• Involved in testing cycle and worked on writing test cases for unit testing
• Worked in Technology,HR Workforce management, Re - Insurance and Online Travel business industries
• Experience on building a claims datamart coming out of an TIBCO system
• Outstanding communication and interpersonal skills
• Good management skills

TECHNICAL SKILLS:

Operating System: Win NT 4.0/5.0, Win XP/2000/98/95, UNIX

RDBMS: Oracle 8i/9i/10g, Teradata, UDB DB2

Data Modeling: ERwin 3.5.2/r7

ETL: Informatica PowerCenter 7.x/8.1.1/8.6

Business Intelligence: Cognos 8, ReportNet 1.1, Cognos Power Play 7.3

Methodologies: Star Schema, Snowflake Schema

Programming Languages: SQL, PL/SQL, C, C++, JAVA, HTML, XML, DB2 SQL PL

Other Tools: TOAD, HP Quality center, PVCS, Test Director, SAS, Cronacle

WORK EXPERIENCE:

Confidential, IL

ETL Developer/ Analyst

• Worked closely with the business users to understand the requirements and convert them into project level technical capabilities.
• Worked with business analysts to identify the appropriate data elements for required capabilities.
• Worked with System Analysts to identify the proper sources for required data elements and to determine the accuracy of the data.
• Participated in the data modeling sessions to understand the data model and providing them inputs based on the existing data to make sure designed model is technically feasible.
• Designed a template in Talend for ETL jobs.
• Designed tables in AS400 database and was involved in setting up database libraries, data marts, user groups and access permissions.
• Used AS400 native commands and SQL Server BCP utility to bulk load data from ERP system into Staging area.
• Extensively worked on developing Talend jobs to extract, transform and load data into Operational Data Store and Enterprise Data warehouse.
• Worked with various Talend components including Java Custom Code components; configuration files, context parameters and global parameters.
• Exported Talend jobs and deployed Java .jar files on the server.
• Performed Unit Testing, fixed various bugs including Help Desk tickets and Production issues.
• Involved in scheduling Talend jobs and setting up dependencies using Robot scheduler and worked with Java commands.
• Managed Change Control implementation and coordinating daily, monthly releases and reruns.
• Set up email alerts at the occurrence of runtime events such as project or job start, complete, or error.
• Worked with the QA team and Tech Services team to validate the data and promote the jobs to QA and Production environment.
• Responsible for resolving user queries and setting up DSN and giving access to Data warehouse using Top Dog reporting tool.

Environment: Talend Open Studio 4.1, AS400, Oracle 10g, SQL Server 2005, Robot Scheduler, Aldon Lifecycle Manager, SQL Server Management Studio, SQL Developer, Top Dog Reporting Tool, iSeries Navigator, IBM Power Systems

Confidential, Chicago, IL

ETL Developer/ Analyst

• Designed and developed ETL processes to capture orders and customer related information from PeopleSoft Financials.
• Developed UNIX shell scripts to automate order related file transfers from our third party order fulfillment vendor, ModusLink, Inc. and developed ETL code to load into data mart.
• Wrote UNIX shell scripts and Perl scripts to collect and parse XML feeds from Google Analytics and developed ETL code to load into data mart.
• Developed and coded a process to extract tree hierarchy information from PeopleSoft Financials.

Environment: Informatica 9.1 (Designer, Workflow Manager, Workflow Monitor and Repository Manager), Oracle 10g, UNIX, TOAD, HP Quality center, SharePoint.

Confidential, Cupertino, CA

ETL Developer/ Analyst

• Worked with Data Modelers in the creation of the ETL source to target mapping document with the transformation logic
• Designed and developed ETLs to load the data from various client instance databases into a staging area in the DW
• Designed and developed reusable ETLs to pull data from staging area to the DW by using parameter files
• Created Unix scripts to process several flat file feeds
• Developed the ETLs as reusable by using parameter files so they can be used for different client instances i.e HPSM Coke, HPSM Swiss, EWM Australia, EWM Japan etc.
• Created a shared LIBRARY folder (global) to import and maintain Source/Target/transformation definitions and implemented shortcuts to the objects within each folder so it is easy to maintain and control the changes to the source and targets
• Used transformations like Source qualifier, Joiner, Lookups (connected and unconnected), Update strategy, Sequence generators, Routers, Aggregators, Union in the development
• Worked on creating Mapplets and reusable transformations where necessary
• Developed the sessions and workflows in the workflow Manager
• Created parameter files to re-use ETLs across different source instances
• Worked on the deployment of the jobs to FQA and Production
• Worked closely with the testing team and the user team to resolve bugs in the UAT
• Provided production support of the processes

Environment: Informatica 8.6 (Designer, Workflow Manager, Workflow Monitor and Repository Manager), Oracle 10g, UNIX, TOAD, HP Quality center, Sharepoint

Confidential, Chicago

ETL Developer/ Analyst

• Interacted closely with Business Users in the Requirements gathering phase
• Worked with Data Architect in the logical and physical design of the data model
• Documented the design by creating High-level design document and a Low-level design document
• Designed, developed and tested ETL processes to pull data from the mart and push it to OLTP database
• Used transformations like Source qualifier, Joiner, Lookups (connected and unconnected), Update strategy, Sequence generators, Routers, Aggregators, Union in the development
• Worked on creating Mapplets and reusable transformations where necessary
• Developed the sessions and workflows in the workflow Manager
• Created worklets when a group of sessions need to run multiple times
• Implemented dependencies in Cronacle to wait for the upstream processes to complete before triggering the jobs
• Implemented Load schedule table to control the date the data needs to be run
• Implemented Error Rejection process to load bad/invalid records into a separate reject table
• Worked closely with the website team in the Integration testing of the process
• Worked with the administrator in creating the deployment groups for the deployment of the jobs to FQA and Production

Environment: Informatica 8.1.1 (Designer, Workflow Manager, Workflow Monitor and Repository Manager), Teradata, Oracle 10g, Erwin r7, UNIX, TOAD, SQL Assistant, Redwood Cronacle

Confidential, Chicago

ETL Developer

• Design and develop the ETL processes for Workforce Management Implementation-Base Reporting that are leveraged across multiple clients(Rockwell,Cintas,Omnicom and Pepsi)
• Co-ordinated the work between offshore and on-site and across all the clients
• Heavily involved in the logical and physical data modeling
• Customized and configured the ETLs for various clients using reusable transformations and mapplets
• Worked extensively on the performance tuning of ETLs by tweaking the lookup transformation cache
• Developed stored procedure to determine the effective dates of various person records
• Coordinated with the QA and the Reporting team and provided guidance and knowledge on the ETL process
• Involved in the UAT testing and Integration testing process
• Migrated the ETLs and the Database structure changes between the environments
• Used Control-M scheduler to schedule the ETL processes

Environment: UDB DB2, Informatica Power center 7.1.3, AQT, Quest, UNIX, Control-M Scheduler

Confidential, KS

ETL Developer

• Involved in testing all stages of warehouse development and deployment life cycle
• Extensively involved in source data analysis and data cleansing
• Designed and created logical & physical data models using Erwin to support strategic business decisions
• Created and maintained several ETL mappings using Informatica Designer to extract the data from multiple source systems and load into star schema designed target tables.
• Scheduled Informatica workflows to populate the datamart on a regular basis using Workflow Manager (6.0).
• Interacted with the Business users to identify the process metrics and various keys dimensions and measures
• Used Cognos Architect 7.0 to build a common set of business oriented metadata from the datamart and provided users with the Cognos Queries and Cubes

Environment: Erwin 3.5.2, SQL, PL/SQL, Oracle 8i, Informatica PowerCenter 6.1,TOAD, Cognos 7.0