EXPERIENCE SUMMARY:

• Seasoned IT professional with over 8 years of experience with specialization in implementing Data Warehousing,
• Business intelligenceand Costing applications using various ETL and BI tools.
• Created over 10 differentdata marts using dimension models(Kimball methodology) across various business domains.
• Experience in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating aggregate tables for the data warehouse development, translate business requirements/functional design into High level and low - level design documents.
• Delivered numerous projects using Agile methodology.
• Delivered one of the complex projects which involves creationof assignments using ETL’s for Activity Base Costing model that had 9 different drivers and numerous data marts as a source.
• Extensive experience in working in Onsite-Offshore model, involving immense amount on Communication and transfer of work on regular basis.
• Experienced as Level 1, 2, 3Application Support for Data warehousing applications. Maintenance of production application, Production issues support,PerformanceImprovement of applications process and cost savings.
• Extensive experience in integration of various complex data sources of various types (DB2-UDB, SQL Server, Oracle, Teradata, XML and MS-Access) and having multiple down streams.
• Received numerous spot awards from customers for delivering projects and providing excellent service.

TECHNICAL SKILLS:

ETL Skills: IBM Info sphereDataStage 8.7/9.x, Data warehouse Concepts

SAS: SAS DI studio, SAS CPM, SAS EG, SAS OLAP Cube

Languages & S/W: SQL, JCL, COBOL, Shell Scripting, Core Java, Java script

Databases: DB2, Oracle,Vertica

ReportingTools: Cognos Report studio.

Domain: Banking/Credit Cards, and Card Payment, and Financial

Schedulers: Autosys, Maestro, CA7

Incident management: BMC Remedy, MAXIMO

Tools: SQL Developer, Putty, SQL Workbench, TOAD, CA ERWIN

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

Sr. ETL Data stage Developer/Tech lead

Technology: Data stage, Oracle SQL/PLSQL, Shell scripting (UNIX and LINUX), Java Script, Basic Cognos, SAS DI studio, SAS EG, SAS CPM

Responsibilities:

• Work with a Functional Team and Data Modelers/Architects to identify and understand the data from different source systems.
• Data base design and base model - Logical & Physical design with hands on experience in DDL and DML SQL operations.
• CreateDataStagejobs (ETL Process) for populating the data into the Data Warehouse constantly from different source systems.
• Expertise in IBMDataStageand Quality Stage with data cleansing and transform the data.
• Write the SQL Queries & PL/SQL Code Tables and Data Mart Staging Tables to validate the data results by counting the number of rows in both the tables.
• Used Star Schema and Normalization data modeling techniques for warehousing of data.
• Worked towards optimal performance when using ETL Stages like LOOKUP, JOIN and MERGE.
• Coordinate with offshore team and manage the incidents, Problems and enhancements
• Identify improvements in applications to reduce maintenance efforts and automate the manually driven processes.
• Involve in the creation of Analysis, Design documents, Create Data stage jobs and SQL queries
• Designed and tested theDataStagejobs for extract, transform and load.
• Coordinate with offshore team and manage incidents, problems, enhancements.
• Provide project deliverables status to the customer in the status meetings.

Confidential, Newark, DE

DataStage Developer/Tech Lead

Technology: Data stage, DB2,Vertica, Shell scripting (UNIX and LINUX), Java Scripts

Roles and Responsibilities:

• Involved in translating business requirements/functional design into High level design documents.
• Extensive use ofDataStagefor extracting, transforming and loading databases from sources including Oracle, DB2 and Flat files and transform the business requirements into ETLS, Unix, Vertica, DB2 components.
• Utilized Parallelism through different partition methods to optimize performance in a large database environment using DataStage.
• Developed UNIX Shell Scripts to automate file manipulation and data loading procedures.
• Extensively worked on Job Sequences to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Wait for file, Email Notification, Sequencer, Exception handler activity and Execute Command.
• Driving design discussions, code walkthrough, test results validations, prod-parallel data comparison discussions and providing status in weekly meetings.
• Coordinate with supporting teams like Infrastructure, DBAs, Architects, Lower environment team, Enterprise Data Management, Program Management, and Production Support etc.
• System analysis of the legacy applications to understand and document the functionalities and data flow etc. and comparative study to bring same specifications in new platform

Confidential

Programmer

Technology: Data stage, DB2,Vertica, Shell scripting (UNIX and LINUX), Java Scripts, Mainframe

Roles and Responsibilities:

• Understand the business requirements and developDataStagejobs for extracting, transforming and loading databases from sources including Oracle, DB2 and Flat files.
• Extracted data from flat files and then transformed according to the requirement and Loaded into target tables using various stages like Sequential file, Look up, Aggregator, Transformer, Join, Remove Duplicates, Change Capture Data, Sort, Column generators, Funnel and Oracle Enterprise.
• Develop the VERTICA SQL scripts and implement the business logic.
• Extensively usedDataStageChange Data Capture for DB2 and Oracle files and employed Change Capture Stage in parallel jobs
• Developed DS jobs to populate the data into staging and Data Mart
• Developed UNIX Shell Scripts to automate file manipulation and data loading procedures.
• Scheduled the jobs using AutoSys, Tivoli.