Sr. Datastage Developer Resume

Title
Sr. Datastage Developer

Primary Skills
7+ years of experience in IT industry especially in client/server business systems and Decision Support Systems (DSS)

Location
US-VA-Herndon

Posted
Jan-05-09

SUMMARY
* More than 7 years of experience in IT industry especially in client/server business systems and Decision support Systems (DSS) analysis, design, development, Testing and implementation.
* 5 years of experience with a strong knowledge base in Extraction Transformation Loading (ETL) applications for Data Warehouses and Datamarts using DataStage (Server & Parallel Extender), MetaStage, ProfileStage 7.5/6.0/5.2, UNIX Shell Scripting, Autosys and Control M Scheduling tools.
* Good knowledge and understanding of Enterprise Database Integration and Management, with various databases like Oracle, MS-SQL Server, DB2, and Teradata.
* Created Functional and Technical Mapping specifications and documentation.
* Familiarity in incorporation of various data sources like Oracle, MS SQL Server, DB2, XML and Flat Files into the staging area.
* Designed and developed efficient Error handling methods and implemented throughout the mappings.
* Hands on experience in writing, testing and implementation of the triggers, Procedures, functions at Database level using PL/SQL.
* Played significant role 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 tool: ASCENTIAL DATASTAGE 4.x/5.X/6.0XE/7.1/7.5
Programming Languages: SQL, PL/SQL
Internet Technologies: HTML 4.0, JAVASCRIPT
Databases: ORACLE 8i/9i/10g, Sybase 11, SQL SERVER 6.5/7.0, DB2
UDB.
Data Modeling Tools: ERWIN, ORACLE DESIGNER.
GUI: ORACLE D2K with FORMS4.x/5.x/6.x, REPORTS 4.x/5.x/6.x, VISUAL BASIC 5.0, Visual C++, CRYSTAL REPORTS.
Hardware: SUN SPARC, IBM COMPATIBLE PC.
Operating Systems: Windows NT/2000, UNIX, AIX.

EDUCATION
BS in Electrical and Communication Engineering

PROFESSIONAL EXPERIENCE
Sr Data Stage Developer - 2007 to Present
United Health Group, Trumbull, CT
United Health Group is a family of businesses dedicated to making health care work better and serves approximately 70 million individuals nationwide. I worked as developer in multiple projects mostly on moving Claims data into ODS and Data Warehouse.

Responsibilities:
* Helped in preparing the mapping document source to target.
* Created DataStage Parallel Jobs to Fact and Dim Tables.
* Written Configuration files for Performance and production environment.
* Involved in unit, performance, Regression and integration testing of data stage jobs and prepared Documentation.
* Modified the DS jobs to improve performance.
* Excessive usage of DS Director for monitoring Job logs to resolve issues.
* Performed DQ Analysis and documented the issues.
* Wrote Shell Scripts to run data stage jobs, PL/SQL blocks.
* Developing Korn Shell scripts to automate file manipulation and data loading procedures.
* Participated in weekly status meetings.
* Used PVCS to control different Versions of the jobs.
* Written Technical Specifications for the project.
* Designed Job Documentation and Installation and Back out Documentation.
* Resolved issues occurred during regular testing and BLT Testing.
* Finally had knowledge transfer meetings to make DBA's familiar with the project for future production support.

Environment: DATASTAGE 7.5.1(PX&Server), Oracle10g/9i, AIX UNIX, SQL, PL/SQL, PVCS Version Manager, TOAD, Flat Files.

Datastage Developer - 2006 to 2007
Limited Brands, Columbus,OH
Limited Brands considered one of the "Worlds Most Admired Companies" in the retail industry. The Insight project integrates data from multiple operational platforms (i.e. Mainframe, SAP, JDA, Manugistics and PeopleSoft) into a single Enterprise Warehouse.

Responsibilities:
* Analyzed the existing informational sources and methods to identify problem areas and make recommendations for improvement. This required a detailed understanding of the data sources and researching possible solutions.
* Used DataStage as an ETL tool to extract data from sources systems, aggregate the data and load into the Teradata database.
* Implemented multi and fast load methods for loading of data.
* Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
* Developed numerous JCL's, COBOL programs, PROCS.
* Implemented table partitions for parallel load processing.
* Involved in defining technical and functional specifications for ETL process.
* Used both Pipeline and Partition Parallelism for improving performance.
* Extensive use of Control M for job scheduling
* Used lookup stage with reference to Oracle tables for insert/update strategy and updating of slowly changing dimensions
* Involved in performance tuning of the ETL process and performed the data warehouse testing.

Business Objects:
* Interacting with Report Users and Business Analysts to understand and document the Requirements and translate these to Technical Specifications for Designing Universes and Business Object Reports.
* Designing new Universes and Modifying the existing Universes, using features like Check Integrity, Aliases, Loops, Contexts, Joins and finally creating the Objects (Dimensions, Measures and Details), which are grouped into Classes.
* Created Universe, Classes and Objects for management system.
* Created Aliases and Contexts for resolving Loops and checked the Integrity of the Universe.
* Worked extensively with @functions (@aggregate aware, @select, @prompt, @where) to overcome the problems with database when integrating with BO.
* Created User defined objects (measures, dimensions).
* Secured the data by using Report Bursting (BCA Publisher).
* Analyzed the reports using the Drill Through, Slice and Dice.
* Created reports on web using Info View Portal and ZABO, distributed the reports to different users.
* Used Broadcast Agent for scheduling and distributing the documents.

Environment: Ascential Datastage (PX& Server) 7.5.1, Business Objects 6.1b, Web Intelligence 2.7, Cobol, JCL, MVS, Oracle 9i, Teradata V2R5, HP UNIX, SQL, TOAD, Control M 6.2, OS/390, AIX 5.2

Data Stage Developer - 2005 to 2006
Merrill Lynch, Hopewell, NJ
Merrill Lynch is one of the world's leading financial management and advisory companies, with offices in 36 countries and private client assets of approximately $1.1 trillion. As an investment bank, it is a leading global underwriter of debt and equity securities and strategic advisor to corporations, governments, institutions and individuals worldwide. Through Merrill Lynch Investment Managers, the company is one of the world's largest managers of financial assets.

Responsibilities:
* Involved in creating entity relational and dimensional relational data models using Data modeling tool Erwin.
* Designing the Target Schema definition and Extraction, Transformation and Loading (ETL) using Data stage.
* Mapping Data Items from Source Systems to the Target System.
* Used the Data stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
* Worked on programs for scheduling Data loading and transformations using Data Stage.
* Designing and Developing PL/SQL Procedures, functions, and packages to create Summary tables.
* Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
* Worked with Datastage Manager for importing metadata from repository, new job Categories and creating new data elements.
* Developing Shell Scripts to automate file manipulation and data loading procedures.

Environment: Data Stage 7.1(PX & Server), ERWIN, Autosys, Oracle 8i, Sybase, SQL, PL/SQL, SQL* Loader, Oracle 9i, AIX UNIX, Windows 2000.

Data Warehouse Developer - 2004 to 2005
Taro Pharmaceuticals, NY
Description:
The Pharma Expense Data System is an enterprise wide analytical data warehouse support system and interfaced with Decision Support system.

Responsibilities:
* Designed a Data Warehouse to replace the legacy databases to provide decision support in a distributed environment.
* Worked with the Business analysts for requirements gathering, business analysis, testing, and project coordination.
* Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
* End-to-end development on Datastage - Hash files, OCI stages, Transformer, Sort stages
* Involved in performance tuning of Datastage jobs to optimize performance using Director.
* Used Data Warehouse techniques like Star-Schema, snowflake schema based on the environment.
* Performed Unit Testing and also Regression testing when needed along with Documentation.
* Developed many stored procedures, triggers, functions and packages used for the system.

Environment:
Ascential DataStage 6.1 (Server), Business Objects 5.1.2, Oracle 8i, SQL Server, Sybase, IBM DB2, Mainframe COBOL Files, Toad, Erwin, Windows, UNIX.

2002 to 2003
Arvind Mills, INDIA
Description:
Arvind Mills is a Manufacturer of range of premium cotton Shirting, world-class Knits, Bottom weights and over 150 varieties of Denim. Worked as a Programmer on Sales Order Processing System. This package with different modules like Receiving Orders, Executing Orders, and Dispatching etc. maintains various tables like Orders, Stock Register, Customer Details, etc. Wrote various reports like Daily Orders, Packaging Slip, Pending Orders, etc. using Reports and used forms 4.5 to create some basic forms like Order Entry, Pending Orders, Customer Details, etc. Also Worked on Human Resources Management System. This package keeps a detailed track record of employees in an organization regarding their recruitment, attendance, leave, salary structure, etc., developed various forms and reports using Forms 4.5 & Reports.

Responsibilities:
* Analysis, Design, and Development of the Data Entry Subsystem.
* Maintaining all the data needed for supporting the Sales Results and Compensation processing rules.
* Developed the screens using Developer2000 for Windows NT/95 (Oracle Forms 4.5).
* Extensively used Database Procedures and Triggers.
* Participated well in design of database schema and wrote some stored procedures for database.
* Coded, tested and implemented components for querying and updating the database.
* Developed screen to enter, update and delete records using D2K.
* Generate weekly, monthly and yearly reports of the employees.
* Developed test data and conducted performance testing on the developed modules.
* Involved in system integration and implemented the system in various outlets.

Environment: Oracle 8i Forms 4.5, Reports, SQL, PL/SQL, and Windows 95.

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Herndon, VA | Resumes in Virginia

View other Sr. Datastage Developer resumes, Programmer / Developer resumes