Professional Summary

• IBM Certified Solution Developer InfoSphere DataStage V8.5
• 7 years of experience in IT, working for Target Corporation (Fortune 500), MN, USA.
• Install and configuration of Information server 8.5 and DataStage 7.5.3.
• Experience in implementing the Dynamic resource management using Grid toolkit.
• Configuration of High availability and clustering for Engine and Service Tier.
• Install and configure SAP BW and R/3 connectivity to DataStage.
• Performed administration tasks like role setup, connectivity, security, configuration of projects, user registries, DSNs, parallel, compiler, reporting, operator and user-defined environment variables, backup DataStage and restart of services etc.
• Worked with IBM Technical Support on the configuration of XMETA repository, Node Agents, DS Engine and Web Sphere Application Server.
• Expertise in Administration IBM InfoSphere Information Server Tools like DataStage, QualityStage, Balanced Optimization and Information Server Manager.
• Experience in integration of various data sources (Oracle 8i/9i/10g/11g, SQL Server, DB2, TeraData, MQ, Flat Files, XML files, and various File systems) into staging area and target Data warehouse.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Participated in discussions with Project Manager, Business Analysts and Team Members for functional and non-functional Requirement issues.
• Created technical documentation for source to target mapping procedures to facilitate better understanding of the process and incorporate changes as and when necessary.
• Experience in design of high level and low-level docs based on the business and functional requirements.
• Experience in converting the Business Logic into Technical Specifications.
• Extensively worked on processing stages like join, merge, lookup, funnel, transformer, change data capture etc.
• Designed Documents for performing unit testing and integration testing of developed code.
• Involved in migration of DataStage projects and jobs from previous versions 7.5.1 to 7.5.3 to 8.5.
• Fixed errors, issues and bottlenecks in design, compilation and execution of server jobs, parallel jobs and complex sequence jobs.
• Extensive experience of handling both Onsite and Offshore teams according to projects

Technical Skills

ETL Tools

DataStage 7.5.1, 7.5.3 [Enterprise Edition & Server Edition], IBM Information Server Suite 8.5

Database

Oracle 8i/9i/10g, SQL Server2000/2005, DB2 9.5/9.1, TeraData

Web servers

IBM Web sphere Application Server,

Configuration Management Tools

Teamprise, Test Director, MSTFS, PVCS, HPSD

Operating Systems

Win XP/7, AIX, Sun Solaris

Educational Qualifications

B.E (Bachelor ofEngineering)

Project Experience Summary

Confidential, Minneapolis, MN, USA Mar 2010 to Present
ETL Admin

To accommodate the Target’s Business growth, Long term stability and high availability; Target determined to upgrade the foremost ETL tool to its latest version. To reduce the environment downtime of business intelligence systems in the enterprise world, Information servers were configured with the latest architecture, supporting high availability in all the environments.

• Project 1: Installation and configuration of IIS 8.5
• Project 2: Installation and configuration of DataStage V7.5.3 EBI environment

Roles and Responsibilities:

• Installation and configuration of Information Server version 8.5 and fixpack1.
• Installation of Information Server Patches for Service, Engine and Client Tiers.
• Installation and configuration of Grid toolkit and LoadLeveler for Dynamic resource management
• Implementation of High Availability for the Information Server 8.5 in Target for the first time.
• Install and configure the TeraData Database client connectivity software.
• LDAP and PAM conversion for service and Engine Tier
• Install and configure the SAP BW and R/3 connectivity to Information server
• Coordinate with Customer and IBM technical Support for Problem Management Requests.
• Defined the standards and security model for the new Information server 8.5.
• Implemented procedures for maintenance, monitoring, backup, and recovery operations for the HA enabled Information server 8.5.
• Integrated MSTFS with ISM for effortless code management process.
• Worked with various teams to plan, coordinate, and implement system patches and minor upgrades to Information Server, to maintain the integrity of the systems.
• Defined and automated the UNIX based code promotion process using istool utility.
• Automation of project creation using Command line for the Information Server DataStage
• Creation and management of DataStage Projects for various teams
• Experience in working with HPSD for incident, issue tracking and change control for patch installations and experience working with Versioning systems MSTFS for managing code base.
• Resolved errors in compilation and execution of different jobs.
• Fine tune the environment to avoid any bottle necks and performance
• Involved in designing the MDHA Architecture for the new 8.5 environment

Environment:
Operating Systems: AIX 6.1, Windows XP, Windows 7
Software’s: IBM Information Server V8.5.1, DataStage V7.5.3, Grid toolkit 4.2.5, LoadLeveler 3.5.1.0, TeraData 13.10, Windows XP, DB2 Connect client 9.5, HPSD, Control-M, MSTFS

Confidential, Spinoff Nov 2008 to Feb 2010
ETL Admin

Target has three different domains for Data warehouse applications. Involved in design, install and maintenance for DataStage for all those three domains. Responsible for applying patches for different environments Analytical Data warehouse, Corporate Shared and Enterprise Business Intelligence. Supported more than 170 DataStage projects on 30 different servers (AIX and Solaris) with more than 300 end users.

• Project 1: Installation and configuration of DataStage V7.5.3 Corp Shared Environment
• Project 2: Migration from Sun Solaris to AIX DataStage V7.5.3 environment.
• Project 3: Security Compliance Remediation for DataStage Environment V7.5.3

Roles and Responsibilities:

• Install/Upgrade DataStage EE server and various DataStage packages.
• Set up the projects, roles, users, privileges in different environments
• Install and configure SAP BW and R/3 connectivity to DataStage
• Create new projects and associated data directories on the DataStage server node.
• Manage space allocation and usage within the DataStage file systems.
• Migrate the DataStage projects from 7.5.1 (Sun system) to 7.5.3 (AIX System) version of DataStage
• Tune the DataStage server settings for optimum performance.
• Ensure that the DataStage server is backed up appropriately, and the recovery of DataStage server data if necessary.
• Subject matter expert for any critical issues related to DataStage.
• Identify, define and establish technical environments requirements.
• Provide consultation on DataStage best practices to the project teams.
• Work with other technical teams like UNIX admin, DB2 DBA, DB2 Connect within the Target Corporation group to set-up and configure the DataStage environments.
• Participate in design and development of common jobs and utilities that will be rolled out to various project teams.
• Interact with the vendor IBM technical support staff to resolve issues regarding the DataStage product suites.
• Converted all the interactive NUID’s to non-interactive NUID’s to comply with Target Security standards
• Implemented RSH to SSH methodology into the DataStage Environment by generating SSH keys and distributing it across servers to the NUID’s for password less communication between Head and compute nodes.

Environment:
Operating Systems: Sun Solaris, AIX 5.3, Windows XP
Software’s: DataStage 7.5.x, Control-M, DB2, Oracle, SQL server, HPSD, Control-M, PVCS, MSTFS

Confidential,Minneapolis, MN, USA Mar 2007 to Oct 2008
Sr.Datastage Developer/ETL Admin

Shared object is the system which loads all the information to the shared database. This system is the heart of Business intelligence application in the Target Data warehouse world. This application extracts data from different source system holding Location, Item, Team Member, Sr.Buyer, Calendar and Vendor information and loads into Business Intelligence system; which is further referenced by other application like Stores, Sales and finance applications.

Vendor Data warehouse is the application which holds the information about the Vendor, Purchase orders and Receipts related to the vendors.

• Project 1: Application Development for Shared objects and Vendor Data Warehouse system.
• Project2 : Planning and Designing the DataStage V7.5.3 Environment

Roles and Responsibilities:

• Meeting business clients for requirements gathering.
• Analyzing the requirements, functional specifications and identifying the source data to be moved to the warehouse.
• Extracted data from various source systems.
• Added, deleted and moved DataStage projects by export and import
• Setting up job parameter defaults and environment variables.
• Designed and Developed jobs using DataStage Designer.
• Validated, Scheduled, Run and monitored developed jobs using DataStage Director.
• Exported and imported jobs between development and production environments using DataStage Manager and maintained different versions of developed jobs using version control PVCS.
• Used all Transformations such as Transformer, Aggregator, Join, Lookup, Funnel, Merge and CDC etc. to load consistent data in to database.
• Scheduling jobs for daily loads.
• Involved in unit testing of the system.
• Involved in planning for building a new DataStage Environment to align with IBM End of support model for UDB Database V9.1.
• Defined strategy for the Installation and configuration of the new environment
• Defined Migration approach for the new version

Environment:
Operating Systems: AIX 5.3, Windows XP
Software’s: DataStage PX 7.5.1, Control-M, DB2, Oracle, SQL server, Remedy, Control-M, PVCS

Confidential,Business Intelligence APR 2005 to FEB 2007
DataStage programmer

This project comprised of development, maintenance, enhancement and end-user support for Target Business Intelligence portfolio applications. This project is for fixing the functional and non-functional issues for all the DataStage applications residing on various domains like Stores, Merchandising, and Distribution DataStage applications.

Roles and Responsibilities

• Involved in development phase meetings for Business Analysis and requirements
• Developed Tier 2 and Tier 3 architectures for data integration.
• Designed and developed Jobs by using IBM DataStage that extract data from the Oracle & SQL Server databases transformed it as per business requirement and populated the data into oracle and UDB DB2.
• Used DataStage Director to Run and Monitor the Jobs.
• Used Shared Container to implement repeated business logic across multiple jobs in the project.
• Developed SQL Queries for implementing Complex business rules and transformations.
• Automated Reports to update the progress of Batch schedule status.
• Responsible for UNIT, System and Integration testing. Developed Test scripts, Test plan and Test Data. Participated in UAT (User Acceptance Testing).
• Scheduled batch jobs in Control-m.
• Extensively involved in Fine-tuning the jobs. Assisted production support team in resolving tickets.
• Wrote UNIX scripts and scheduled those using Control-M to run jobs automatically as per the business SLA.
• Monitoring the DataStage jobs on daily basis by running the Control-M.
• Incorporated restartable logics into the UNIX scripts to restart the jobs for infrastructure errors.
• Maintained the support matrix and updated request and problem tickets in Remedy.

Environment:
Operating Systems: Windows XP, AIX 5.3
Software’s: DataStage 7.5.1, IBM DB2 Control/Command Center, Quality Center, SQL-Plus, Remedy, Control-M, PVCS