SUMMARY:

• 6+ years of experience in IT industry especially in building data warehouses and Decision Support Systems (DSS) analysis, design, development, Testing, Production and implementation.
• Have worked in Agile and Waterfall project methodologies.
• Extensive exposure to Star, Snowflake Schema and Multidimensional Data Models.
• Experience in Extraction, cleansing, integration, loading of data from/to disparate data sources.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using Ascential DataStage, UNIX shell scripting and SQL Loader.
• Expertise in working with various operational sources like DB2, UDBDB2, Oracle, Teradata, Flat Files into a staging area.
• Strong experience in loading and maintaining Data Warehouses and Data Marts using DataStage ETL processes.
• Experience in Using XML in Data stage Integration
• Hands on experience in writing, testing and implementation of the triggers, Procedures, functions at Database level using PL/SQL.
• Involved in Requirements gathering, Logical design model & physical design model meetings to understand the data flow, frequency of data loads into EDW and create S2T Mapping documents and visio diagrams.
• Excellent experience in extracting data from Teradata, DB2, and Oracle and loading into an EDW.
• Extensive experience in loading high volume data, and performance tuning.
• Involved in various phases of project life cycle, such as requirements definition, functional & technical design, testing, Production Support and implementation.
• Excellent team member with problem - solving and trouble-shooting capabilities, Quick Learner, highly motivated, result oriented and an enthusiastic team player.

TECHNICAL SKILLS:

ETL Tools: DataStage9.1,8.5,8.0.1,7.5.2PX (Administrator, Manager, Designer, Director, Parallel Extender/Orchestrate, Information Server)

Operating Systems: Windows, UNIX, IBM AIX

Languages: Shell, Perl, PL/SQL.

Database: Teradata 14, Oracle 11g, DB2 and MQ Series

Web Server: IIS

Other tools/applications: SVN, Tivoli Workload Scheduler, CLM, ITG

PROFESSIONAL EXPERIENCE:

Confidential, Frederick, MD

Sr. DataStage Developer

Responsibilities:

• End-to-end implementation, maintenance, optimizations and enhancement of the application.
• This involves various phases in the project, starting from project estimation, Requirement Gathering and Analysis, Designing, Coding, User Acceptance Testing to deployment in production, including post implementation support.
• Communication with clients/onshore manager on day to day basis which includes conference calls and written communications.
• Assisting the Project Management team in providing the estimation of projects. This is an important step where we analyze the requirements and estimate the effort and time by when we could deliver the best solution.
• Leading the team and ensuring the delivery happens on time with the best quality and least defects. This is important in living up to the Quality standards of UHG.
• Assisting the Management and Quality team (QMS) by providing various Metrics and data for the project. This is really important as View360 projects are very process oriented and emphasize on Quality standards.
• Handling Change requests - Understanding the application work flow in the existing jobs on DataStage and applying new changes to them, testing & Review activities.
• Adhering to the Process and creating and posting all the required documents and deliverables like the UTC document, Review Checklist, etc.
• Worked with Subject matter experts for Data Requirement Documents(DRD)
• Created a data dictionary to map the business requirements to attributes to design logical data model implementing star schema.
• Developed a very complex Data validation and error handling jobs.
• Created Jobs to classify the data into subject areas as source jobs.
• Extensively worked with DataStage Shared Containers for Re-using the Business functionality.
• Worked on performance tuning to address very critical and challenging issues.
• Co-ordinate with SIT and UAT team to fix the Test Problem Reports.

Environment: IBM Information server (Data Stage and Quality Stage 8.5), Teradata 14, Oracle 11g, DB2, SQL, Perl Scripting, Basic Unix Shell, TWS, ITG, CLM, Subversion.

Confidential, Stevens Point, WI

Sr. DataStage Consultant

Responsibilities:

• New development, enhancement and optimization of the application.
• This involves various phases in the project, starting from Requirement Analysis, Designing, Coding, Unit Testing, SIT & UAT support, to deployment in production, including post implementation support.
• Worked on CDC (change Data Capture) project within MDM which is an enhancement to existing code where the transactional data is scanned for updates/inserts/deletes and accordingly transformed and applied on MDM DB.
• Communication with business analyst and project manager on day to day basis which includes meetings and written communications.
• Assisting the PM/lead in providing the estimation of projects. This is an important step where we analyze the requirements and estimate the effort and time by when we could deliver the best solution.
• Work on given timelines to ensure the delivery happens on time with the best quality and least defects. This is important in living up to the Quality standards at Prime.
• Handling Change requests - Understanding the application work flow in the existing jobs on DataStage and applying new changes to them, testing & Review activities.
• Adhering to the Process and creating and posting all the required documents and deliverables like the UTC document, Production Implementation documents, etc.
• Created Prime Wiki Pages for the projects/jobs I worked on over the few months at Prime.
• Worked on performance tuning to address critical and challenging issues.
• Co-ordinate with SIT and UAT team to fix the Test Problem Reports.

Environment: IBM Information server (Data Stage and Quality Stage 8.7), Oracle11g, DB2, SQL, Basic UNIX Shell scripting, Robot Scheduler.

Confidential, Detroit, MI

Software Engineer

Responsibilities:

• Used the DataStage Designer to develop processes for Extracting, Cleansing, Transforming, Integrating, and Loading data into Data warehouse.
• Primarily involved in Job Design, coding and Troubleshooting of jobs.
• Developed various Server and Parallel DataStage jobs.
• Defect Tracking, unit testing, defect reporting, analyzing results and documentation.
• Extensively used Processing Stage like Lookup Stage to perform lookup operations based on the various target tables, Modify stage to alter the record schema of the input data set, Funnel Stage to combine various datasets into a single large dataset and Switch stage to trigger the required output based on a specific condition.
• Performed ETL Performance tuning to increase the ETL process speed.
• Developed Operational Manual Documentation.
• Associated with other team workers for implementation of data stage best practices for better performance.
• Production and test support of the application for 33 Countries in EMEA region (Includes defect handling).
• Handling Change requests - Understanding the business requirements and designing the ETL flow in Datastage, Testing & Review activities.

Environment:Data stage 7.5.1, Mainframes, Windows, DB2 V8, Toad for Oracle

Confidential, Plano, TX

Associate Systems Engineer

Responsibilities:

• Used the DataStage Designer to develop processes for Extracting, Cleansing, Transforming, Integrating, and Loading data into Data warehouse.
• Requirement analysis and gathering to provide technical and architectural support to the team.
• Documented the Purpose of Mapping so as to facilitate the personnel to understand the process and incorporate the changes as and when necessary.
• Primarily involved in Job Design, Technical Reviews and Troubleshooting of jobs. Extensively involved in different Team review meetings and conferences with remote team.
• Developed various Server and Parallel jobs using Oracle, ODBC, FTP, Peek, Aggregator, Filter, Funnel, Copy, Hash File, Change Capture, Merge, look up, Join, Sort, Merge, Lookup stages.
• Developed PL/SQL Procedures, Functions, Packages, Triggers, Normal and Materialized Views.
• Defect Tracking, unit testing, defect reporting, analyzing results and documentation.
• Designed Data Stage parallel jobs using designer to extract data from various source systems, Transformation and conversion of data, Load data to data ware house and Send data from warehouse to third party systems like Mainframe.
• Extensively used Processing Stage like Lookup Stage to perform lookup operations based on the various target tables, modify stage to alter the record schema of the input data set, Funnel Stage to combine various datasets into a single large dataset and Switch stage to trigger the required output based on a specific condition.
• Designed jobs Using complex stages like Transformer, Change Capture, Change Apply, Remove Duplicates, Join, Lookup, Merge, Funnel and Aggregator
• Performed ETL Performance tuning to increase the ETL process speed.
• Have addressed production, UAT issues, proper action was taken accordingly based on priority and requirement
• Developed Operational Manual Documentation.
• Associated with other team workers for implementation of data stage best practices for better performance.

Environment: Data stage 8.0, Oracle 9i, XML, UNIX, and Toad for Oracle.