SUMMARY

• Dedicated and goal - oriented skilled professional with proven strengths in data warehousing concepts and ETL technologies across diversified industries, who excels in a fast-paced environment and works well independently and as part of a team.
• Consistently meets business objectives and exceeds standards in projects.
• Excellent organizational and time management skills.
• 11+ Years of overall experience in Data Warehousing, ETL development using various ETL tools such as SSIS, Informatica and IBM Information Server/DataStage, and report creation.
• 11+ years of IT experience in Data warehousing and Business intelligence with emphasis on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of Data Warehouse and Data Mart systems in the Manufacturing, Food Service, Financial, Pharmaceutical, Telecom and Insurance industries.
• 11+ years of development and design of ETL methodology for supporting data transformations and processing, in a corporate wide ETL Solution using DataStage, Informatica Power Center and Microsoft SSIS.
• 11+ Years of database experience using IBM Netezza 7.2, Oracle 11g,10g,9i/8i, MS SQL Server 2012,2008,2005/2000, SQL, PL/SQL in creating database structures, tables, views, triggers and performance tuning of SQL procedures.
• Cognos report creation experience
• Working knowledge of Linux to create scripts to automate data transfers.
• 1+ year of experience in Siebel Analytics Repository objects creation and report development.

TECHNICAL SKILLS

Data Warehousing: IBM Information Server DataStage and QualityStage, Information Analyzer Data Profiling 9.1, 8.7, 8.5, 7.1 Informatica PowerCenter 8.1.1/7.1/6.2 (Designer, Repository Manager, Repository Server Administration Console, Workflow Manager, Workflow Monitor, Informatica Server SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services

Database Tools: Aginity, Toad, SQL Developer, SQL Server Management Studio

Others: SQL, PL/SQL, SQL Plus, Unix Shell Scripting, Batch Scripting

Databases: IBM Netezza, Oracle 11g, 10g, 9i, MS SQL Server 2008,2005,2000

Environment: Linux RedHat 6.5/5.7, Windows 7,2003/2000/XP

PROFESSIONAL EXPERIENCE

Confidential, Ohio

Data Warehouse Consultant

Responsibilities:

• Quickly get up-to-speed with project objectives and data warehouse architecture
• Documented existing SQL views and created Visio diagrams for easily identifying source tables and underlying views of major data warehouse targets
• Work with business users to understand requirements and set expectations
• Work with source system analysts to identify source fields and create source to target mapping documents
• Create DataStage jobs and sequences to provide extracts to third party vendors
• Modify and enhance existing views to extract data from the Netezza databases
• Work with DBAs to deploy the views on the database using SCCS check-in/out
• Work with testing team to fix defects and provide solutions

Confidential, Ohio

Data Warehouse Analyst

Responsibilities:

• Successful implementation of a new demand planning and forecasting tool (JDA) to run the company’s manufacturing process. Played the role of team lead to manage several contractors by creating source-to-target mapping documents, creating workflows, architecting job designs and resolving bottlenecks.
• Successfully created and implemented the MTD Enterprise Consumer Database to stage over 10 different data sources from databases, text files and third party vendors via FTP. Created data cleansing, matching, merging jobs and purchase and survey question fact jobs. Worked with Cognos team members to design table layouts for efficient reporting and to create Cognos packages.
• Worked with and led contractors to convert older DataStage sequential jobs to parallel jobs and reduced nightly cycle processing time from 8 hours to 3 hours.
• Responsible for loading the company’s financial budget on an annual basis and the revised financial forecast on a monthly basis.
• Responsible for creating, loading and maintaining product ratings and reviews data every month with data coming in from several different third parties. This data is now being used to design new customer outreach programs and is displayed at the company’s quarterly board meetings for upper management.
• Designed and developed several in-house data solutions for key areas including orders, customers, manufacturing, procuring, shipments, AR, supply chain etc.
• Worked with team to create efficient and scalable data models to in corporate various data elements into a global data warehouse.
• Responsible for being on-call every other week on a rotating basis with one other co-worker to ensure successful completion of nightly processing of data for critical morning reports.
• Worked with team and consultants to upgrade the IBM Information Server DataStage software through several upgrade cycles.
• Created a standards document very early at MTD to standardize development and implemented across the team and with all contractors.
• Cleaned up old DataStage ETL jobs to minimize daily data load failures and increased data reliability and SLA achievability to 99% on a daily basis.
• Worked diligently to quickly and efficiently resolve any production issues by involving the team and working out a reliable and cost-effective solution and continue to monitor afterwards and analyze and implement possible enhancements.
• Worked with team architect and DBAs to design efficient and scalable solutions.
• Recently started implementing Agile methodology to improve project turnaround times and show progress on a regularly scheduled basis to users.

Confidential, Ohio

Informatica/Siebel Analytics Developer

Responsibilities:

• Meet with consultants that are rolling off to get knowledge transferred and taking over responsibilities.
• Working with users to understand the issues they are facing and outlining possible fixes for it.
• Working on the Siebel Analytics repository or on Informatica to create new measures or to modify existing measures based on change in calculation.
• Created new mappings to create a daily recon procedure to compare the OLTP rows to the OLAP rows and ensure no rows are falling out as a part of the daily ETL load.
• Create new measures in the Siebel Analytics repository based on existing tables and joins.
• Modifying calculations in existing measures as per changes in business requirements.
• Running the DAC manually if any problems arise in the OLTP system so as to ensure all rows are captured.
• Monitoring the daily ETL run to ensure completion and to diagnose problems (if any).

Confidential, Ohio

DW Informatica Developer

Responsibilities:

• Worked with the business users and the business analyst in gathering the requirements.
• Created technical requirements documentation.
• Created individual requirements documentations for the different subject areas like Funds, Promotions, and Invoices etc.
• Created mappings using Informatica Power Center 7.1.4 to implement these requirements.
• Used Siebel Transactional System and Oracle Databases as the sources for these mappings.
• Used some Out-of-the-Box mappings for implementing requirements and modified some vanilla mappings and also created custom mappings from scratch.
• Created sessions and workflows for these mappings.
• Assisted in configuring the DataWarehouse Administration Console for running the out-of-the-box and customized mappings.
• Configured the DAC from command-line to work with Autosys.
• Explained and demonstrated the load process to the Production Support Team.
• Created the support documents for the production support team.

Confidential, Ohio

DW Informatica Developer

Responsibilities:

• Worked with the business analysts to identify the business requirements.
• Helped in building the functional and technical requirement documents.
• Created mapping documents to outline data flow from sources to targets.
• Designed various mappings using Informatica Designer to load Dimensions and Facts.
• Used existing ETL standards to develop the mappings.
• Modified existing mappings to implement enhancements for new business requirements.
• Used the reusable sessions for creating partitions on tables and for creating and dropping temporary tables for the partition exchange technique.
• Created test scenarios to test the functionality of the mappings.
• Helped in automating the Informatica loads by working with the Control-M team.
• Created technical support documentation for the production support team.
• Explained and demonstrated the load process to the Production support team.

Confidential, Maryland

DW Informatica Developer

Responsibilities:

• The COMSORTer application was Oracle based and the existing data was stored on SQL Server. One of the tasks was to migrate the data from SQL Server to Oracle.
• Created a mapping document that outlines the sources mapped to the targets.
• Created a document outlining the plan of action to be taken for the entire process.
• Created views to select data from the existing SQL Server databases.
• Created DTS packages to generate flat files from the views created.
• Used existing UNIX scripts and modified them to load the Oracle tables.
• Designed mappings to load the Surveys, Questions, Projects and other tables related to Surveys.
• Created views and designed mappings to load test for the UAT to test the application.
• Worked with Offshore team (Cognizant Solutions) for the backend development process and to synchronize the work process and progress of development.
• Provided production support for Business Users and documented problems and solutions for running the workflow.
• Creating Stored Procedures to delete existing data from the tables before loading. Creating test scenarios to thoroughly test the tool's functionality.
• Creating support documents for the mappings and sessions.
• Explaining the entire process to the production support members.

Confidential, NJ

DW Informatica Developer

Responsibilities:

• Getting information from the users and the Cold Fusion developers about the ETL process.
• Creating a document outlining the development approach with the level of detail down to transformations.
• Transferred the data from a combination of different input files to SQL Server.
• Creating workflows with the Event Wait task to specify when the workflow should load the tables. The Event Wait task would wait for the indicator file which was being dropped onto the Informatica server by the Cold Fusion (Front End), and then transfer the control to the rest of the workflow to load the data.
• After completion of the sessions, created a session that updates the load status into a File Load Status table.

Confidential, Grand Rapids, MI

DW Informatica Developer

Responsibilities:

• Transferred the data from a combination of different input files to Oracle.
• Responsible for creating, tuning and maintaining all test and development databases.
• Transferred the data from CSV files to Oracle using Informatica.
• Responsible for querying data from different database tables as per the requirement.
• Responsible for creation of standard Filters, Calculations, prompts and conditions,
• Creating documents to outline the details and specifications of DTS packages that were to be converted to Informatica.
• Conversion of DTS packages to Informatica mappings based on the documentation and making any necessary changes as per the business requirements.
• Assist in the upgrade process by creating backups of repositories.

Confidential, Kansas

DW Informatica Developer

Responsibilities:

• Requirement gathering and Business Analysis
• Analyzed the Functional Specs provided by the Architect and created Technical Specs documents for all the mappings.
• Played a key role in designing the application that would migrate the existing data into PCMD warehouse effectively by using SQL Server Integration Services (SSIS).
• Worked on SSIS using the built in workflow and Data Flow tasks to create ETL jobs.
• Used the built-in transformations such as conditional split, multicast, lookup and aggregation to perform the transformations on data.
• Configured OLDEB connections to connect to and extract from different sources.
• Helped in creating reports using the built-in Analysis services functionality.
• Loaded the data into the SQL Server database.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database.