SUMMARY:

• Seven + Years of IT experience on Installation, configuration, setup and Administration of DataStage Server.
• Installed and configured of IBM Infosphere Information server 9.1/8.7/8.5
• Configuration of High availability and clustering for Engine and Service Tier.
• Installed and configured SAP BW and R/3 connectivity to Data Stage.
• Performed administration tasks like role setup, connectivity, security, configuration of projects, user registries, create or update users and groups, mapping credentials, configuring DSN and TNS entries, parallel, compiler, reporting, operator and user - defined environment variables.
• Configuration of XMETA repository, Node Agents, DSEngine and Web Sphere Application Server.
• Expert in backing up and restoring of Infosphere/Websphere Information Server manually and also by using isrecovery automated tool.
• Expertise in Administration of IBM InfoSphere/Websphere Information Server Tools like DataStage, QualityStage, Balanced Optimization and Information Server Manager.
• Experience in source systems analysis and data extraction from various sources (Flat files, XML files, Oracle 8i/9i/10g/11g, DB2, SQL Server, Teradata, MQ and SAP) into staging area and target Data warehouse.
• Experience in converting the Business Logic into Technical Specifications.
• Extensive professional expertise in Extraction, Transformation and Loading (ETL).
• Extensively worked on processing stages like join, merge, lookup, transformer, change capture, Remove duplicates, Funnel, Filter and Pivot stages, etc.,
• Designed Documents for performing unit testing and integration testing of developed code.
• Fixed errors, issues and bottlenecks in design, compilation and execution of server jobs, parallel jobs and complex sequence jobs.
• Extensively worked on Server Edition, Enterprise Edition (Parallel Extender) and development of Data Warehouse/Data mart Applications.
• Strong understanding of the principles of Data warehouse using Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Experience in Data modeling, Data warehouse using modeling tools like Visio and ERWIN.
• Designed many Batch Processing jobs within DataStage and created many sequences in DataStage using Job Sequencer.
• Experienced in Scheduling and running Jobs using DataStage Director, External tools like Control-M, Autosys and Unix Crontab.
• Involved in performance tuning for various DataStage jobs by usage of Hash Stage, SQL Tuning, Job Tuning and usage of IPC s.
• Development, Analysis and Design of ETL methodologies in all the phases of the Data warehousing life cycle with knowledge in ETL, Data warehousing & LDAP Technology.
• Designed and Prepared Mapping Documents for Source to Target mapping with ETL transformation rules.
• Experience in DataStage Administrator to create/modify/delete projects andcleanup projects and Implemented security among DataStage users and projects.
• Worked on parallel and server jobs using various stages like Join, Lookup, Change Capture, Filter, Funnel, Copy, Column generator, Peek, Dataset, Sequential file, Oracle Enterprise, DB2/UDB, Merge, Transformer, Aggregator, Remove duplicates stages
• Designed and developed jobs using DataStage Parallel Extender (also known as IBM Enterprise Edition) for splitting bulk data into subsets and to dynamically distribute data to all available nodes to achieve best job performance
• Excellent knowledge in extraction, cleansing and modification of data from/to various data sources, flat files and comma delimited files (.csv)
• Expert in requirement gathering, analysis and Data cleansing using Quality Stage (Investigate, Standardize, Cross Column Analysis).
• Strong knowledge in OLTP/OLAP systems, Normalized (OLTP), De-normalized models, dimensional strategies, surrogate key, star schema, snowflake schema.
• Good knowledge of dimensional modeling (star and snowflake schema) for data warehouses and data marts
• Experience in integration of various data sources like DB2, Oracle into staging area
• Used stage variables, constraints in DataStage jobs
• Strong experience on UNIX Shell Scripting to run DataStage jobs, to validate the audit log, to consolidate different source, to extract and load from multi system and to enhance the performance
• HTML, XML, JavaScript, Photoshop, Visual Basic 6, SQL/ PL SQL, ORACLE 9i, 10g, SQL Server 2005, C++, C, C#, LINUX, UNIX, and Microsoft Office Suite

TECHNICAL SKILLS:

ETL Tools: IBM Info Sphere DataStage 8.x, (Designer, Director, Administrator), Ascential DataStage 7.5.2 Enterprise Edition (Designer, Director, Administrator, Manager)

Databases: Oracle 11g/10g/9i, DB2, SQL Server 2003/2005/2008 and Data Modelling OLTP, OLAP, Star & Snow-Flake schema Modeling, Fact and Dimensions, Physical and Logical Data ModelingLanguages C, SQL, UNIX Shell scripting

Operating Systems: IBM AIX 5.3, Red Hat Linux, Windows 95/98/2000/XP /7/8 & Windows Server 2000/2003/2008/2012

PROFESSIONAL EXPERIENCE:

Confidential

Sr. DataStage Administration

Responsibilities:

• IBM Information server installation and configuration on a distributed environment.
• Create Data Architect technical specification documents for extraction, transformation, cleansing, and load (ETL) programs.
• Responsibilities include installation and configuration of Information Server on DEV, QA, PPROD and PROD environments.
• Migrating developed DataStage Jobs from DEV to QA and PPROD to PROD.
• Attend Design Review Board (DRB) meetings to discuss the data model changes in detail and attend to Technical Forum meetings to discuss Design/Implementation details of the project, coordinate development activities with Offshore Development Team.
• Installed Information Server/DataStage Clients on end user desktops/laptops/Citrix and troubleshooting daily issues.
• Extensively worked with SAP stages (IDOC, BW and ABAP) and trouble shoot the connection issue with SAP.
• Prepared Documentation for Information server suite installation and configuration.
• Problem determination and support during testing phases. (Application support and trouble shooting) and Data Stage production support.
• Written Configuration files for Performance tuning in production environment.
• Involved in DR exercise, as part of DR we back up the projects, scripts and various required software and restore them in the designated server make the whole environment available for DR testing purpose.
• Involved in unit, performance, Regression and integration testing of DataStage jobs and prepared Documentation
• Excessive usage of DataStage Director for monitoring Job logs to resolve issues.
• Developed Shell scripts to automate file manipulation and data loading procedures.
• Resolved issues occurred during regular testing.

Software used: IBM InfoSphere DataStage v9.1, iseries DB2, Windows 2000/XP /7/8 & Windows Server 2008/2012, SQL Plus, Quality Stage

Confidential

DataStage Administration

Responsibilities:

• Setting up the environment for Datastage Designer, Director and Manager and Administrator.
• Installation, configuration, setup and Administration of DataStage Server.
• New Datastage projects creations, moving of projects, unlocking of projects through Datastage Administrator.
• Turned on DataStage odbc tracing (DataDirect actually) by specifying in the ODBC section of the $ODBCINI file.
• Fixed existing bugs in the ETL code, SQL code used in extract jobs, other mapping errors.
• Exported and Imported jobs from one environment to other environment.
• Project creation/modification policies.
• Prepared Sequence document essential in sequencing data stage jobs.
• Performed performance tuning of DataStage jobs to improve the extraction, transformation and loading time of data.
• Used DataStage Director and its run-time engine to validate, run and monitor the resulting executable versions.
• Used Information Manager for creating new job categories, Metadata Definitions, Data elements, Import/Export of projects, jobs, and DataStage components, viewing and editing the contents of the Repository as well as writing routines.
• Used DataStage Version Control for change management and elevation of jobs to the higher environments from development.
• Developed unit test cases, and unit-testing of jobs-involved in testing the job before migrating the code to QA and Production boxes.

Software Used: IBM InfoSphere DataStage 7.5.3, Oracle 10g, DB2, Data Stage 8.5 v, SQL Server 2008, Quality Stage, DB2, Windows server 2008

Confidential

DataStage Developer

Responsibilities:

• Creating jobs for cleansing, transforming and loading data into warehouse.
• Understanding the Source System.
• Analyzed the business requirements and functional specifications
• Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database
• Processing files coming from multiple source system
• Designed ETL jobs to identify and remove duplicate rows using remove duplicate stage.
• Extensively worked with surrogate key generator to generate warehouse keys before loading data into warehouse
• Involved in design and development of parallel jobs using DataStage designer
• Design and Development of DataStage ETL jobs using various stages like Aggregator, Join, Transformer, Sort, Merge, Filter and Lookup, Sequence, Modify, Peek etc.
• Used UNIX Shell Scripts for scheduling the jobs
• Frequent communication with the Team members and the business users
• Doing the Analysis & Bug fixing during the development

Software Used: DataStage 7.5, Oracle 10g, DB2, Data Stage 8.1 v, SQL Server 2005/2008, Quality Stage, DB2, Windows XP & Windows Server 2003