Siddarth Parekh

INFOSPHERE INFORMATION SERVER PRODUCTION SUPPORT ENGINEER

E-mail: abhm3x@r.postjobfree.com Ph:

985-***-****

SUMMARY

. Seven (7+) years of work experience in Data Warehousing and Data

integration and conversion processes, including Software Architecture,

Design and Development.

. Six (6+) years of hands-on experience in leading and administering

Data Integration and migration for Data Warehouses including Data

Profiling and Data analysis using IBM Websphere DataStage EE

8.0/8.5/8.1/7.5.3/7.5.2/7.5.1 (DataStage Manager, DataStage Designer,

DataStage Director, DataStage Administrator, Parallel Extender).

. Experienced and involved with all the stages of software development

life cycle.

. Extensive ETL experience in Installation, Configuration, Upgradation,

Migration, Administration, Development and Production Support of

IBM/Ascential DataStage, Information Analyzer, Metadata Workbench,

Business Glossary etc of InfoSphere Information Server 8.0/8.1/8.5

[Server and Enterprise Editions].

. Experienced in design, debug & tracing of Server, Parallel and

Multiple-instances of Complex Sequence Jobs.

. Experienced in troubleshooting DataStage jobs, fixing bugs and

addressing production issues like performance tuning and enhancements.

. Experienced in configuring operational sources like SQL Server,

Teradata, Oracle, DB2, Flat files.

. Extensive knowledge on various stages like ODBC, Transformer,

Sequential file,

Hashed file, Join, Lookup, Lookup file set, Sort, Aggregator, Copy,

Dataset,

Merge, Oracle, Remove duplicates and DB2 stages.

. Diverse knowledge of data dependencies using Metadata of DataStage and

running job sequences for existing jobs to facilitate scheduling of

multiple jobs.

. Experienced writing Unix/Linux Shell Scripts.

. Excellent knowledge about the principles of DW using Fact Tables,

Dimension Tables and star-schema modeling and snowflake-schema

modeling.

. Excellent knowledge of RDBMS principles.

. Experienced working with DataStage Version control and PVCS version

control software.

. Migration of DataStage Projects & Jobs from previous versions of

DataStage 7.5.x into InfoSphere DataStage 8.0, 8.1 and 8.5.

. Work with IBM Technical Support on resolution of complex issues,

patches, software upgrades etc.

. Promotion of Projects and Jobs between DEV, UAT and PROD servers using

elevation request forms with business approvals.

. Excellent knowledge of High Availability and Clustering of Grid

Environment and Connectors, Adapters & PACKs of IIS suite.

. Familiar with Erwin Data Modeling tool.

. Good aptitude for problem solving and logical analysis.

. Excellent interpersonal communication skills.

. Possesses the ability to work effectively in a team environment or

individually.

. Self-motivated, quick learner and adaptable to any situation.

. Multilingual, highly organized, detail-oriented professional with

strong technical skills.

Education

MS in Computer Science & Engineering

Technical Skills

ETL Tools Ascential DataStage 7.5.x, InfoSphere DataStage, Information

Analyzer, QualityStage, Metadata Workbench, Business

Glossary 8.0/8.1/8.5 & Metadata Server

Operating Systems Windows 98/2000/XP, NT 4.0, Unix (HP 11, Sun Solaris

10, AIX 6.1), Linux (Red Hat, SUSE)

Databases Oracle 7.x/8.0/8i/9i/10g, DB2, Teradata, MS-Access, SQL

SERVER 7.0/2000/2005

Languages PL/SQL, SQL, UNIX shell programming, HTML and Java

Database Tools SQL Plus, SQL Loader, Import, Export, Quest SQL

Navigator 4.3, SQL Programmer, PL/SQL Developer

Other Tools Microsoft Office 2000/NT/XP/7, MS Visio, Unigraphics, and

Minitab

Connectivity Tools Putty, Cygwin X, Reflection, Exceed

CITIBANK, OH MAR 2010 -

MAR 2011

FINANCIAL, ACCOUNTING, INVESTMANENT, TRANSACTIONAL AND HISTORICAL [FAITH]

SYSTEM

Citigroup is an American multinational financial services company with

operations in consumer, corporate, and investment banking and insurance by

combining banking giant Citicorp and financial conglomerate Travelers

Group. DataStage projects have been developed for data marts belonging to

FAITH application.

Responsibilities:

> Installed, Configured and Administered DataStage, QualityStage,

ProfileStage, IS Manager and Metadata Server of InfoSphere Information

Server 8.1 suite in Dev, UAT and Prod Phases.

> Installed, Configured and Administered Oracle 10gR4 Metadata

Repository Database and WebSphere Application Server

6.0.2.27/7.0.0.11.

> Unlocked jobs. Set up Configuration Files, Job Parameters, Environment

Variables and Data Connections across jobs in a project.

> Prepared disk, file, network resources and packages. Modified kernel

parameters and user limits. Resolved incompatible JRE errors during

upgradation.

> Involved in DataStage security - assigned IIS suite and suite component

roles in IIS Web Console.

> DataStage disk usage - projects, system files, datasets & scratch.

> Installed and Configured Fix Pack 1, Rollup Patch1 and Fix Pack2 on

IIS 8.1 and resolved errors.

> Used Designer Client to develop server, parallel and sequence jobs

with different invocation ids as per source-target mapping

specifications.

> Involved in migration of DataStage and QualityStage projects and jobs

from earlier versions to 8.5 version.

> Worked with Administrator Client to manage projects and set their

properties.

> Worked with Director Client to schedule, run and view the logs of jobs.

> Used Information Analyzer for Profiling tasks and QualityStage for

Cleansing Tasks.

> Used Business Glossary to build a vocabulary system between business

metadata and technical metadata.

> Created data lineage and impact analysis reports in Metadata

Workbench.

> Categorized and created new data elements.

> Involved in Optimizing Parallel Extender Jobs.

> Developed Shell scripts to backup and restore DataStage projects

automatically.

Environment:

InfoSphere DataStage 8.5/8.1 (Designer, Director, Administrator),

Information Analyzer, QualityStage, Metadata Workbench, Business Glossary,

Metadata Server, ERwin, Oracle 9i/10g, SQL Server 2005, SQL, PL/SQL, Unix,

Linux, Windows XP

TJMAXX, MA

DEC 2008 - FEB 2010

RETAIL ANALYSIS & MONITORING PERFORMANCE [RAMP] SYSTEM

TJMAXX has more than 900 stores nationwide offering products in the

departments of ladies accessories, jewelry, ladies' footwear, beauty,

active wear, women's plus baby, juniors' men's, kids' home etc.

Responsibilities:

> Developed cluster and grid architecture to enable the integration of

metadata between InfoSphere tools and non-InfoSphere tools.

> Upgraded and configured all the tools from IIS Information Server 8.0.1

base version to Fix Pack 1->Fix Pack 1a->Fix Pack 2 and then to 8.1 on

different tiers.

> Installed, Configured and Administered DB2 9.5 Metadata Repository

Database and WebSphere Application Server 6.0.2.27.

> Configured .odbc.ini, dsenv, uvconfig, DSParams, uvodbc.config files at

both engine and project levels.

> Configured parallel engine, database connectivity in parallel environment

and access to ODBC sources.

> Started and stopped DataStage Engine, WebSphere Application Server and

Information Server and managed logs.

> Raised PMRs with IBM on upgradation problems, patches and fix packs.

> Managed Users, Groups, active sessions, logs, schedules and licenses in

IIS Web Console.

> Worked on administration command tool AppServerAdmin to update WAS and

XMETA user credentials.

> Worked with Designer Client to design, debug and optimize server,

parallel and sequence jobs using stages.

> Used Information Analyzer and QualityStage for Data profiling and

Quality.

> Used Business Glossary Anywhere to build a vocabulary system between

business metadata and technical metadata.

> Used Metadata Workbench to understand, analyze and explore the assets of

business, technical and operational metadata.

> Worked on administration command tool DirectoryAdmin to perform tasks and

services of IIS and WAS.

> Worked on Oracle 10gR2 and DataStage Server performance tuning

approaches.

> Backed up and restored InfoSphere Information Server suite.

> Configured NLS to support character maps and locales.

> Managed ASBAgent, Logging Agent, DSRPC, Telnet and Engine Resource

services.

> Involved in migration of DataStage and QualityStage projects and jobs

from earlier versions to 8.1 version.

Environment:

InfoSphere DataStage 8.1/8.0, Information Analyzer, QualityStage, Metadata

Workbench, Business Glossary, Metadata Server, SQL Server 2000, flat files,

Oracle 9i, Linux, DB2, Shell Scripts and Windows XP.

ASTELLAS PHARMA INC, IL OCT 2007- NOV 2008

PHARMACEUTICAL ACCOUNTING CUSTOMIZED & KNOWLEDGE [PACK] SYSTEM

Astellas promotes activities that contribute to the good of society and

that help create a dialogue with local communities in various fields,

including Science, Healthcare, Welfare, Education, Environment, Culture and

Research. DataStage projects have been developed for data marts belonging

to PACS application.

Responsibilities:

> Involved in analysis based on requirements and developed Cluster & Grid

Architecture for data integration.

> Selected Installation Topology with layers for the products of

Information Server.

> Prepared disk, file and network resources. Modified kernel parameters and

user limits.

> Installed, Configured and Administered IBM IS 8.0 suite.

> Worked with IBM to troubleshoot data integration suite issues. Resolved

incompatible JRE errors during installation.

> Added, deleted and moved projects and jobs. Purged job log files and

traced server activity.

> Issued DataStage engine commands from Administrator. Started and stopped

DataStage engine and managed logs.

> Managed DataStage services like DSRPC, Telnet and Engine Resource

Services.

> Configured NLS for WebSphere DataStage and QualityStage in dsenv file.

> Supported failures of production server jobs - parallel, server and

sequence jobs with development team.

> Worked on performance tuning of ETL jobs using SQL queries, data

connections, configuration files, parameter sets and environment

variables.

> Used Information Analyzer and QualityStage for Data profiling and

Quality.

> Imported the contents of DataStage and FastTrack into Business Glossary.

Created data lineage and impact analysis reports in Metadata Workbench.

> Used IBM Business Glossary [MetaStage] to organize metadata into

categories, terms and objects.

> Migrated DataStage and QualityStage jobs from earlier versions to

DataStage 8.0 version.

> Worked on setting up users for IIS suite and suite components for

different products.

> Used IIS Web Console for administration areas: security, licensing,

logging, and scheduling.

> Created different type of reports like Administrative reports, IA Column

Analysis reports, Metadata reports and Fast Track Mapping specification

reports from IIS console.

> Installed WAS 6.0.2.11 and DB2 9.1 metadata repository automatically and

configured LDAP user registry with Microsoft Active Directory in both WAS

& IIS.

> Used Control-M to schedule jobs and e-mailed the status of jobs to

operations team daily.

Environment:

WebSphere DataStage 8.0/7.5.3, Information Analyzer, QualityStage, Metadata

Workbench, Business Glossary, Metadata Server, Windows XP, SQL 2000/2005

server, Version Control, Oracle 9i, SQL Server 2000, Shell Scripts and

Unix.

BAXTER INTERNATIONAL INC, IL SEP 2006 - SEP

2007

HEALTHCARE, INSURANCE, TRACKING AND SYNOPSIS [HITS] SYSTEM

Baxter International Inc, through its subsidiaries, develops, manufactures

and markets products that save and sustain the lives of people with

hemophilia, immune disorders, infectious diseases, kidney disease, trauma,

and other chronic and acute medical conditions.

Responsibilities:

> Involved in requirements gathering and source data analysis and

identified business rules for data migration and for developing data

warehouse.

> Installed, Configured and Administered all the client and server

components of DataStage, MetaStage and Parallel Extender.

> Set up users and changes license details on both client and server

systems.

> Added, deleted and moved projects and jobs. Purged job log files and

traced server activity.

> Set up job parameters, environment variables, configuration files and

enabled runtime column propagation.

> Issued DataStage engine commands from Administrator. Started and stopped

DataStage engine and managed logs.

> Optimized server, parallel and sequence jobs for extracting,

transforming, integrating, and loading data into data mart using

DataStage Designer.

> Worked with DataStage Director to schedule, monitor, analyze performance

of individual stages and run DataStage jobs.

> Developed Job Sequencer and batches and have edited the job control to

have jobs run in sequence.

> Developed shell scripts to validate, automate and schedule DataStage jobs

using UNIX shell scripting and Crontab Utility.

> Interacted with business analysts and data modelers for better

understanding of data and modified specifications to reflect accurate

user needs.

> Created design documents and proto type jobs based on the business

requirements and high level design (HLD).

> Used Lookup, Join, Funnel, Merge, Lookup, Transformer etc processing

stages to design server, parallel and sequence jobs.

> Defined and documented the required data validation rules on the source

feed files that were used in ETL.

> Ran job sequences with restart ability, check points and implemented

proper failure actions.

Environment:

Ascential DataStage 7.5x2 (Server and Parallel Extender), Windows NT

4.0,UNIX, SQL Server 2000, Oracle 8i, IBM DB2, DOS, Sequential Files and

CSV files.

US CELLULAR, IL MAR 2005 -AUG 2006

CALL PLAN TRACKING SYSTEM [CPTS]

US Cellular is one of the largest cellular phone companies in the United

States. It is a dynamic organization that offers business in voice & data

plans, phones & accessories, repairs & insurance, billing & reporting and

industry specific solutions.

Responsibilities:

> Installed, Configured and Administered all the client, server components

of DataStage, MetaStage and Parallel Extender.

> Configured server daemon environment and accessed remote files via NFS.

> Started and stopped DataStage engine and managed logs.

> Set environment variables, kernel parameters and C++ compilers.

> Configured ODBC connections, maximum no. of processes per node and paging

space.

> Used DataStage Designer to develop processes for extracting, cleansing,

transforming, integrating, and loading data into data warehouse database.

> Responsible for building and loading dimension tables and fact tables for

the target warehouse system.

> Used DataStage Designer/Manager/Director to design and run jobs to

implement the Import and Export Interfaces.

> Extensively used DataStage Designer components to design various Server

and Parallel jobs in accordance with business specs.

> Imported table definitions from ODBC/Plug-in table definitions available.

> Used Partition methods and collecting methods for implementing parallel

processing.

> Monitored the performance of Parallel jobs by turning on various

environment variables.

> Used Job Control routines and Transform functions in the process of

designing the job.

> Developed jobs in Parallel Extender using different stages like

Transformer, aggregator, lookup, source dataset, external filter, row

generator, and column generator.

> Validated and debugged the developed jobs.

Environment:

Ascential DataStage 7.5.1 (Manager, Administrator, Designer, Director,

Parallel Extender), IBM DB2/UDB Universal Database Oracle 8/9i, MSSQL

Server 7.0, XML, UNIX, Windows NT

First Citizen Bank, RI APR

2004 - FEB 2005

First Citizen Bank offers products in the areas of Checking & Savings,

Business Services, Investment & Wealth Management*, Credit & Lending and

Privacy & Security.

Responsibilities:

> Creating Data Structures. i.e. Tables & views and applying the

referential integrity using SQL.

> Design and develop the data entry screens.

> Written Database Triggers, Procedure & Functions using PL/SQL

> Developed forms using forms 6i.

> Tested and debugged the modules along with the other modules to implement

the business logic.

Environment:

Oracle 8i, Oracle Forms 6i, Oracle Reports 6i, PL/SQL and Windows98.

Contact this candidate