SUMMARY

• Over 7+ years of experience in software development wif relevant exposure to Extraction Transformation Loading (ETL) and loading DataMarts and implementing BI concepts using various ETL tools and specialized in DataStage.
• Strong design and development experience in DataStage (11.5/9.1/8.7/8.0.1/8.1/7 x), Oracle 11g/10g/9i, PL/SQL, DB2, SQL Server 2005/2008, Shell scripts, AutoSys, Crontab Utility, TWS (Tivoli Workload Scheduler), Control - M, FTP.
• Good experience in building Fact, Dimension Tables and star/snowflake schema modeling, implementing Slowly Changing Dimension (SCD), Change Data Capture (CDC), ER modelingforOLTPand dimension modeling forOLAP, Reverse Engineering using Erwin.
• Comprehensive noledge in metadata for data dependencies, extracting source data from XML files, Sequential files, Flat files, zip files, transforming data and loading in DWH.
• Involved in building customized routine, UNIX shell scripts for implementing business logic and scheduled teh jobs using AutoSys, TWS scheduler and Cron tabs, SQL Server DTS Packages to integrate teh data coming from heterogeneous sources to Staging Area.
• Extensive working experience wif Banking, Insurance, Manufacturing domain.
• In-depth noledge in trouble shooting performance bottle-neck, performance tuning, Data migration wif large scale application, involved in migrating ETL projects and jobs.
• Exposure to full life cycle development projects wif System Life Cycle experience wif Lean Agile and iterative development model. Expertise in Requirement gathering, Estimation, Modeling, Analysis and Design, development, Testing, Configuration Management, Performance tuning, User Acceptance, Data Conversion, End User Training, Production support and Documentation.
• Mentored complete onsite/offshore team for technical front and had ownership for teh project delivery in terms of quality, meeting teh industry standards, optimal solutions and technology and on time implementation. Active contributor in various project proposals, estimation and technical screening.
• Strong decision-making skills, extremely well organized, good interpersonal, communication and presentation skills.

TECHNICAL SKILLS

ETL Tools: DataStage-11.5/9.1/8.x, 7.x(Designer, Director, Manager, Administrator), Parallel Extender, Quality Stage, and Server Jobs, IBM Cognos BI and Abinitio

Data Modeling: Erwin, Star-Schema Modeling, Snowflakes Modeling, FACT & Dimensions

RDBMS: Oracle11g/10g/9i, MS Access, SQL Server 2005/2008, DB2, Teradata.

Languages: C, SQL, PL /SQL

OS: Windows NT/2000/2003/XP, UNIX, LINUX

Scheduling tools: AutoSys, Crontab Utility, TWS (Tivoli Workload Scheduler), Control-M, DataStage Director

CRM: Siebel Tools 8.1.1/7.8.2, Enterprise Integration Manager (EIM)

OTHERS: HTML, SQL*PLUS, MS Visio, UNIX Shell Scripting, TOAD, SQL Developer, Squirrel

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

Sr. ETL Developer

Environment: IBM InfoSphere 11.5/9.1/8.1 (Designer, Director, Quality Stage), Sequential files, AQT, UNIX, Windows, MS Visio, Oracle 11g, SQL Server 2005, DB2UDB, XML, FTP, Sterling, SiteScope, Remedy, TWS Scheduler, SAP Business Objects XI

Responsibilities:

• Part of core scrum team player, actively involved in sprint ceremonies scoping, PBR, backlog grooming, retrospective etc.,
• Involved in Datamart architect, technical design and development wif respective projects.
• Developing source to target data mappings capturing business rules and logic. Ensuring data standards are being applied correctly and consistently to incoming data, database fields and value translations
• Translating business requirements into ETL processes using DataStage & SQL development.
• Conducting data analysis of a large number of source systems to generate data quality metrics.
• Developed DataStage custom routines to handle data validation & data scrubbing.
• Created scripts to create new tables, views, queries, for new enhancements in teh application using AQT. Developed PL/SQL procedures, triggers, indexes to implement business logic using AQT.
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete system Development Life Cycle.
• Analyzed data and developed jobs to include changing business rules and perform quality checks on data received from external vendors like Blackrock, Sunguard(Kiodex), Findur, Bloomberg
• Develop ETL standards & best practices. Resolving ETL and Database performance issue
• Efficient in all phases of teh development lifecycle, coherent wif Data Cleansing, Data Conversion, Performance Tuning and System Testing.
• Created Task plans/change controls and provided support during Production Release’s.
• Involved in Production Scheduling to setup jobs in order and provided 24x7 production support.
• Efficient in in corporation of various data sources such as Oracle, MS SQL Server, and DB2, XML and Flat files into teh staging area.
• Involved in migrating projects from 8.1 to 9.1 and setting up 9.1 environments. Involved in compiling and testing jobs in 9.1. Tuned teh DataStage repository and jobs for optimum performance.
• Built new universe as per user requirements by identifying teh required tables from Capital Markets ODS environment and by defining teh universe connections. Also created and supported WebI reports and scheduled them to generate PDF files for end users.
• Define process to create source package and deployment to different server (QA, UAT, and Production)
• Lead and mentor other team members on ETL design, development, best practices and performing complex tasks
• Setting up Sitescope alerts and TWS scheduling and Creating remedy / incident tickets.

Confidential, Amelia, OH

ETL Consultant

Environment: IBM InfoSphere 8.7 (Designer, Director, Quality Stage), Sequential files, SQuirrel, UNIX, Windows, MS Visio, Oracle 11g, DB2, XML, Control-M Scheduling, sFTP

Responsibilities:

• Translating business requirements into ETL processes using DataStage & SQL development.
• Conducting data analysis of a large number of source systems to asses data quality
• Developed DataStage custom routines to handle data validation & data scrubbing.
• Extensively used Transformer, Sort, Merge, Aggregator, Funnel, Filter, Copy, Peek, Modify, Compare, Oracle/DB2/ODBC Enterprise, Aggregator, Change Capture, Difference and Remove Duplicates stages.
• Analyzed data and developed jobs to include changing business rules and perform quality checks on data received from external sources i.e.,Huon, PC and IC Staging.
• Develop ETL standards & best practices. Resolving ETL and Database performance issue
• Efficient in all phases of teh development lifecycle, coherent wif Data Cleansing, Data Conversion, Performance Tuning and System Testing.
• Created Task plans/change controls and provided support during Production Release’s.
• Involved in Production Scheduling to setup jobs in order and provided 24x7 production support.
• Efficient in in corporation of various data sources such as Oracle, MS SQL Server, and DB2, XML and Flat files into teh staging area.
• Involved in process setup for migrating jobs from development to Test/PROD using manifest files as per Munich Re standards. Tuned teh DataStage repository and jobs for optimum performance.
• Created Control-M Scheduling jobs, scheduled and e-mailed status of ETL jobs to operations team daily.

Confidential, Cincinnati, OH

Sr. ETL Developer

Environment: Oracle 11g, DataStage 7.5/8.7, Abinitio, IBM Cognos BI, Sequential files, TOAD 8, UNIX, Windows, MS Visio, Sybase Powerbuilder 15, Tortoise SVN1.7.1.

Responsibilities:

• Worked wif business and end users to understand and gather requirements.
• Converted business requirements into functional specification.
• Designed and developed ETL solutions using Abinitio Graphs and plans for business problems as solutions for different application modules.
• Designed and developed various business reports using IBM Cognos BI tool.
• Coordinated and facilitated discussions between BSA’s and Technical Team for gap analysis and remove road-blocks where necessary.
• Actively involved in design sessions and meetings wif Team leader, Group Members and Technical Manager regarding Technical solution.
• Coordinated and performed release testing in SIT and UAT environments by testing various scenarios and report its outcomes.
• Debugged, analyzed and fixed teh issues found while testing.
• Primarily responsible to monitor and running of scheduler chains and also debug and resolve any failures for successful completion.
• Reverse engineered DataStage jobs/Portals by extracting teh logic and code to develop functional documentation.
• Implemented teh Add check points, automatically handle activities concepts in sequences
• Responsible for integrating data from OLTP to enterprise-wide data warehouse to store reliable data for downstream support system using DataStage.
• Created new mappings and updating old mappings according to changes in Business Logic Performed major role in understanding teh business requirements and designing and loading teh data into data warehouse.
• Responsible for Gap analysis and translating business requirements into systems design.
• Responsible to track and update teh JIRA’s and check in teh code into Tortosie SVN.
• Identified issues and bottleneck wifin teh code and fixed them for better performing application.
• Extensively worked on performance tuning and optimization of SQL statements using explain plan, SQL trace and tkprof.
• Analyze, design and develop stored procedures, functions, packages, materialized views and triggers using PL/SQL.
• Actively involved in performance tuning brainstorming and resolution
• Worked wif Data Architects to come up wif teh database design.

Confidential, Cleveland, OH

ETL/DataStage Developer

Environment: IBM InfoSphere 8.1/8.7 (Designer, Director, Quality Stage), DB2 UDB, SQL Server 2008, Sequential files, TOAD 8, UNIX, Siebel 7.8, Windows, XML, Sharepoint

Responsibilities:

• Requirement analysis/documentation, developing functional and technical specifications, DW and ETL designing, developing detailed mapping specifications, DFD's and scheduling charts.
• Building teh SQL queries for BD2 UDB to fetch teh data from teh Database as per teh business requirement and use teh SQLqueries in teh DataStage for father processing.
• Designed and developed all subject modules using DataStage engine. Applied validation rules, constraints using DataStage variables and transformations.
• Designed Parallel jobs using various stages like Transformer, join, merge, Lookup, CDC, remove duplicates, filter, modify, aggregator and funnel stages.
• Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance
• Developed and modified IFB files to load data from staging area into Interface tables and into Siebel base tables using EIM
• Responsible for importing LOV, Position, Employee, Contacts, Accounts and Opportunity Data from legacy systems using EIM
• Created parameter sets to group DataStage job parameters and store default values in files to make sequence jobs and shared containers faster and easier to build.
• Created source to target mapping and job design documents from staging area to Data Warehouse.
• Developed job sequence wif restart ability, check points and implemented proper failure actions.
• Generated completion messages, Status reports using capabilities of job control sequence and UNIX. Responsible for UNIT, System and Integration testing. Participated in UAT (User Acceptance Testing).
• Created a WaitforFile Activity jobs, Interface Notification and DataStagesequences to load teh data into Target and send teh success/failure reports to teh end users via email wifin 3 week window after technical proof of concept initiatives.
• Used DataStage Director to run and Monitor teh jobs performed, automation of job control using Batch logic to execute and schedule various DataStage jobs.
• Worked wif DataStage Director for setting up production job cycles for daily, weekly monthly loads wif proper dependencies.
• Maintaining teh support matrix and updating teh remedy ticket for analysis purpose.