Resume of Datastage Developer

Title
Datastage Developer

Primary Skills
IBM-Ascential DataStage 7.5/7.0/6.0 (DataStage Enterprise Edition & Server Edition), SQL, PL/SQL

Location
US-IL-Chicago

Posted
Dec-12-07


EXECUTIVE SUMMARY:

• Over 6 years career reflecting experience and high performance in System Analysis, design, development and implementation of Relational Database and Data Warehousing Systems using DataStage.
• Software Analysis, Design and Development. Experience in Data warehousing, application development and Production Support.
• Strong skills in IBM-Ascential DataStage 7.5/7.0/6.0 (DataStage Enterprise Edition & Server Edition), SQL, PL/SQL, Stored Procedures and Triggers, Performed Debugging, Troubleshooting and performance tuning.
• Experience in Designing, Developing, Documenting and Testing of ETL Jobs and Mappings in Server Jobs in Data Stage to populate tables in Data warehouse and Data marts.
• Experienced and trained in developing Data Warehousing / Business Intelligence applications using IBM (Ascential DataStage) 7.5/7.0/6.0 and Different Databases.
• Experience in Data analysis, Data modeling concepts, Database design and Data migration.
• Worked on various operating systems like UNIX AIX 5.2/5.1, Sun Solaris V8.0 and Windows and Developed Strategies for Extraction Transformation Loading (ETL) mechanism.
• Expert in unit testing, system integration testing, implementation, maintenance and performance tuning.
• Experience in Data Modeling as well as reverse engineering using tools Oracle Designer, Erwin, ER/Studio and MS Visio.
• Experience in Database programming for Data Warehouses (Schemas), proficient in dimensional modeling, Star Schema modeling, and Snowflake modeling. Proficiency in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon, surrogate key assignment and CDC (change data capture).
• Unique ability to understand and long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts with strong analytical, organizational, presentation and problem solving skills.

TECHNICAL SUMMARY:

Tools & Utilities: DataStage 7.5.2/7.0/6.0 (Data stage Enterprise Edition & Server Edition), Oracle Designer, Erwin, ER/Studio, TOAD

Databases: Oracle 9i/8i/7.x, SQL Server 7.x/2000, MS Access.

Operating Systems: IBM AIX 5.2/5.1, Sun Solaris V8.0, HP-UX V11.0, Windows XP/NT/2000/98

Languages: C, C++, Visual Basic, SQL, PL/SQL

Protocols: TCP/IP, SMTP, POP, FTP and HTTP

Version Controls: MS Source Safe and DataStage Version Control


EDUCATION:
Bachelor of Engineering
Rajasthan University, Rajasthan, India



PROFESSIONAL EXPERIENCE:

Accenture, LLP Jan 06 to till date
Data Warehouse Analyst
Client: Aon Corp, Chicago, USA

Aon Corp is the leading global reinsurance intermediary, providing its clients with a full range of services in the design, structure, and implementation of their risk-transfer programs. We offer reinsurance expertise in all lines of business, including niche lines such as aviation, marine and energy.
This Data Warehousing Project is to facilitate the Client integration of information involving multiple, silo operational applications. The objective of this integration of information is to provide a unified picture of the business. This unified picture of the business is intended to facilitate integrated management reporting.
It will promote a single, accurate version of the truth in an efficient manor by providing multi operational business governance over the reporting environment.
Responsibilities:
• Involved in requirements gathering and source data analysis and identified business rules for data migration and for developing data warehouse data marts.
• Involved in identifying the data inputs from various source systems depending upon the business requirement.
• Created source to target mapping documents from staging area to Data Warehouse and from Data Warehouse to various Data Marts.
• Involved in low-level design and developed various jobs and performed data loads and transformations using different stages of DataStage and pre-built routines, functions and macros.
• Involved in creation of logical and physical data model using Oracle Designer.
• Used DataStage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data Warehouse.
• Used DataStage Director to schedule running the server jobs, monitoring scheduling and validating its components.
• Used DataStage Manager for managing datastage repository (view and edit), define custom routines & transforms, Import and export items between different datastage systems or exchange metadata with other data warehousing tools.
• Used Hashed file to extract and write data and also to act as intermediate file in a job. Hashed file is also used as reference table based on single key field.
• Parameterized DataStage jobs to allow portability and flexibility during runtime.
• Used ER/Studio to reverse engineer legacy database from Sybase to Oracle.
• Responsible for Preparation of Design Documents / Test Case Specifications / Performance Review and Coding and getting it signed off from client.
• Plan and conduct the conference calls from off-shore.
• Plan and distribute the work among the off-shore team mates.
• Plan, Co-ordinate and Arrange Knowledge Transfer from our client - Aon to current team members to understand the Application.
• Update the management on issue and resolve

Environment: DataStage 7.5 EE (Designer, Manager, Director, Administrator) Server Edition, Oracle 9i, SQL, PL/SQL, SQL Loader, Windows NT4.0/2000, UNIX Shell Scripting



Accenture Services Pvt Ltd. Jan 01 to Nov 05
DataStage Developer
Client: Royal & SunAlliance, UK

Royal & SunAlliance, one of the world's leading insurance groups. Royal & SunAlliance protects people against the risks they face in their daily lives, both personal and commercial.
This Data Warehousing Project is to facilitate the Client and Network partner details like Policy Distribution -- office wise, Premium Collection, and Claim Distribution. It can also provide advance warning about new clients based on there location / size and business type that depends upon various parameters.
The basic purpose is to provide the Business Intelligence to Royal & Sun Alliance decision-makers on there tips / clicks, interactively.

Responsibilities:
• Involved in understanding Business Process and coordinating with Business-users to get specific user requirements to build the Data Marts.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Modeled the Star Schema Data Marts by identifying the Facts and Dimensions using Erwin Data modeling tool.
• Used DataStage 7.0 to integrate Sales and Marketing data along with Staging Area into Marketing and Sales Data Marts.
• Created jobs in DataStage to extract from heterogeneous data sources like SQL Server 2000, PeopleSoft and Text files to Oracle 9i.
• Used Link Practitioner to Portion Data in order to enhance performance of DataStage jobs. And Link Collector to collect portioned data together.
• Migration of data from Staging Area into Marketing and Sales Data Marts to store reliable data for decision support system using DataStage as ETL tool.
• Used DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouse database.
• Used different types of Stages like FTP, Sequential File, Hashed File, Transformer, Sort Aggregator, and ODBC for developing different Jobs.
• Used DataStage Director to Run and Monitor the Jobs performed.
• Complex queries are written to facilitate the supply of data to other teams.

Environment: DataStage 7.0(Designer, Manager, Director, Administrator) Server Edition, Erwin, IBM AIX 5.1, Oracle 8i, PL/SQL, Business Objects 5.0, SQL Server 2000, UNIX Shell Scripting

Certifications
Bachelor of Engineering
Rajasthan University, Rajasthan, India



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

View all resumes in US-IL-Chicago »
View all resumes in US-IL »

View other Datastage Developer resumes, Programmer / Developer resumes