SUMMARY

• Around 7 years of IT experience in Data Analysis, Design, Development, Implementation and Testing of Database/Data warehousing/Client/Server/Legacy applications using Data Modeling, Data Extraction, Data Transformation, Data Loading and Data Analysis.
• Expertise in translating business requirements into Data Warehouse and Data Mart design and developing ETL Design based on the requirements using Data Stage.
• Worked with dimensional modeling, Star Schema modeling, and Snowflake modeling, and fact and dimension table design, physical and logical Data modeling
• Extensive experience in loading and maintaining Data Warehouses and Data Marts using DataStage Client Components like Manager, Designer, Director, Administrator
• Worked extensively on different types of stages like ODBC, Aggregator, Transformer, Merge, Join, Lookup, Sort, SAP ABAP stage, XML Input/Output, CFF, Pivot, FTP, Shared Containers ( Parallel) for developing jobs.
• Extensively worked on designing, compiling, testing, scheduling DataStage jobs
• Experienced in debugging, validate, schedule, run and monitor jobs using DataStage Director.
• Worked on Control - M, DataStage Director for designing batch jobs for scheduling.
• Experienced in performance tuning and troubleshooting by performing the root cause analysis.
• Highly noledgeable in Database management systems, UNIX shell scripting, Client/Server application development, Software Testing.
• Knowledge on Agile method of SDLC, Sprint and JIRA
• Experience in integration of various data sources like Oracle, SQL Server and Flat Files using Active/Passive Stages available in Data Stage Tool.
• Strong noledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL Loader.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as a team

TECHNICAL SKILLS

ETL Tools: Data Stage 11.5/11.3/9.1/8.7/8.5/7.5

Reporting Tools: Cognos

RDBMS: Oracle 11g/10g/9i, MS SQL Server 2008/2005,Mainframes

Languages: SQL, BASIC, C, C++, XML, shell scripting

Other tools: Oracle Utilities, SQL*Loader, TOAD, SQL Navigator, Control-M, winscp, SFTP

Operating Systems: IBM AIX, WINDOWS NT/2000, Unix, Linux

Scheduling tools: Control-M, Zena

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, KS

ETL Data Stage Developer

Responsibilities:

• Involved in gathering and analyzing various items from different departments
• Understanding the core requirements of the Project.
• Involved in Data Extraction, Staging, Transformation and Loading.
• Develop ETL jobs to generate files & reports transmitted to end customers
• Involved in Analysis, Design, Development, and Documentation of Functional &Technical specifications.
• Participated in four complete cycles of ETL development.
• Created Job Sequences to using Job Activity, Notification Variables Activity
• Used Data Stage Director for monitoring jobs, troubleshooting errors and resetting aborted jobs.
• Created Datastage sequencer to call Datastage parallel and server jobs and used check points.
• Understand the HL7 messages and Created complex DataStage jobs to meet HL7 layout segments.
• Created DataStage shared containers to reuse the same logic in multiple jobs.
• Design DataStage jobs to create HL7 ADT messages.
• Create Zena schedule jobs to send extracts to HealthShare.

Environment: IBM Datastage 11.5, UNIX, Winscp, SQL server, DB2, Zena scheduling tool, workday, ADO, Service now, Sybase.

Confidential, Malvern, PA

Data Stage Developer

Responsibilities:

• Involved in analyzing existing schema to identify suitable dimensions and facts for schema and Implemented logic for Slowly Changing Dimensions.
• Interacted with the Data Modelers while designing data mart and reporting layers.
• Designed and developed mappings between sources systems (external files and databases) to operational staging targets.
• Used the DataStage Designer to develop processes for extracting, transforming, integrating, and loading data into Data mart.
• Developed user defined Routines and Transformations to implement Complex business logic.
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions (on an ad hoc or scheduled basis).
• Involved in Unit Testing and System Testing for various jobs and performed job tuning.
• Involved in creating reports with Multiple Data Sources, Drill Down, Cross Tab, Slice/Dice and Charts.
• Involved in production support and on call support.

Environment: DataStage 8.0 ( Designer, Director),Oracle 10g, Unix, PL/SQL.

Confidential, Charlotte, NC

Data warehouse Developer

Responsibilities:

• Designed and developed jobs for extracting, transforming, integrating, and loading data into Oracle AR Module using DataStage Designer.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development
• Developed Open Interface to import the Invoices using Auto Invoice Master Program.
• Most of the stages used were the Sequential File, Aggregator, ODBC, and Transformer.
• Extensively used pre built-in Transformations and Functions.
• Developed user defined Routines for implementing Complex business logic.
• Used DataStage Manager for importing metadata from repository and creating new job categories and data elements.
• Extensively used DataStage Director to schedule, monitor, analyze performance of individual stages and run multiple instances of a job.
• Performed the Unit and System testing for each job to ensure dat it meets the documented functional requirements.
• Developed Unix Shell Scripts to validate files, schedule DataStage jobs and data loading procedures.

Environment: Ascential DataStage 7.5 (Designer, Manager, Director), IBM DataStage 8.5, Oracle 10G, UNIX.