Summary:

Over 7 years of IT experience in full life cycle development, Data Warehouse Development, Data Modeling, Design, Mapping, Extraction, Migration, Data Cleansing and Design/Development of ETL. Experience converting business requirements into a feasible technical solution applying client-server based technologies in mixed OS environments. Development experience includes applications in Financial, Banking and Health.

• Extensive experience with Extraction, Transformation, Loading (ETL) process using Ascential Data Stage EE/8.0/7.5/ 7.1/6.0/5.2
• Strong understanding of business processes and interface with IT.
• Experienced in writing system specification, translating user requirements & creating design specifications.
• Experienced in Full Life Cycle and Methodology for implementing Data warehouse and Business Intelligence Reporting Systems.
• Experienced in design and implementation of ER, Star Schema and Snowflake Schema.
• Experience in developing different ETL DataStage jobs using stages (Lookup, Join, Change Capture, Aggregator, Datasets, XML Input, XML Output, Sequential files, ODBC, OraOCI,Transformer, Oracle and DB2 Enterprise, Merge, Modify and Copy).
• Designed Parallel jobs, Job Sequencers, Batch jobs and Server jobs.
• Expertise in developing strategies for Extraction, Transformation and Loading (ETL) processes using DataStage, expertise in LLD (low level design) and requirement analysis gathering.
• Skilled in integration of various data sources such as SQL Server, Oracle, DB2 and MS Access into staging area.
• Involved in Performance Tuning of the DataStage Parallel jobs using Performance Statistics, Dump Score.
• Experience in handling xml files using Datastage.
• Experianced in scheduling and running jobs using DS Director & Unix scripting.
• Creating Dashboard Style operational/adhoc reports for various departments using cognos 8.x/CRN1.1 tools (Frame work Manager, Report Studio, Query Studio).
• Used Quality Stage with in DataStage parallel extender Version 8 to investigate, standardize and cleans names, address, phone numbers etc..
• Experience in integration of various data source, testing and user documentation.
• Installation, Configuration, Upgradation, and Maintaience of IBM Websphere Datastage on UNIX and windows.
• Worked with complex flat files using logic to transform data for mapping.
• Worked extensively with Business Analyst during requirement gathering.
• Multilingual, highly organized, detail-oriented professional with strong technical skills.

Certification:

• IBM Certified Solution Developer -- WebSphere IIS DataStage Enterprise Edition V8.0

Technical skills:

ETL Tools

Data stage 8.0/7.5/7.1/6.0, Quality stage7.x/8.x

Databases & Tools

Oracle (8i/10g/11g), UDB/DB2, Sybase, MS SQL Server, Erwin, Microsoft VISIO.

Languages

SQL, C/C++

Operating Systems

SunSolaris,Unix, Linux, IBM AIX (4.0/5.x), Windows XP/NT/2000/9x.

Web/App Servers

WebSphereApplicationServer3.5/4.0/5.0/5.1/6.0,IBM HTTP Server, Apache Web Server.

Scripting

WSADMIN, Korn Shell Script, Perl, JavaScript, VBScript.

Reporting Tools

Cognos 8.3 Suite, Report studio ,Query studio Crystal Reports, SQR, D2K

Professional Experience:

Confidential , Malvern , PA Aug ‘07 – Nov ‘09 
Data Stage Administrator /Developer

Responsibilities:

• Performed Installation and migration of IBM Websphere Datastage Enterprise Edition/PX on UNIX platforms.
• Extracted data transformed and loaded into Oracle database according to the required provision using Data Stage 8.0.1/7.5.
• Experienced with full life Cycle and Methodology for implementing logical and physical models of Datawarehouse.
• Created DataStage parallel jobs to load data from Sequential files, Flat files, Data sets to Oracle.
• Involved in dimensional modeling of the Data warehouse to design the business process, data representation, dimensions and fact tables using Erwin.
• Enhanced the Job Performance by using proper partitioning methods and analyzing the resources utilized using Job Monitor.
• Generated Surrogate Key for the dimensions in the fact table for indexed and faster access of data
• Used QualityStage to investigate, standardize, and cleanse names, address, phone numbers and emails.
• Implemented Datastage Application using Change Data Capture (CDC).
• Implemented the Slowly Changing Dimension (SCD) strategy in Datastage, for Dimension tables for storing history data.
• Experianced in running jobs using Job sequencers & Unix scripts.
• Experience in UNIX shell scripting, for various functions such as maintenance, backup, and configuration.
• Worked extensively in Data Analysis, Design, Development, Testing and Implementation of various Applications in Ascential Datastage using multiple sources and targets like Oracle, DB2 and Flat files on UNIX environment.
• Created job sequences and job schedules to automate the ETL process. Enhanced the job properties for performance tuning.
• Implemented Crontab for automating job execution.
• Strong administration skills on Data stage and websphere.
• Documented the purpose of the jobs so as to facilitate the personal to understand the process and incorporate the changes as and when necessary.

Environment: IBM DataStage 8.0/7.5 (Parallel extender), oracle 11g/ 8i, IBM AIX, DB2,SQL Query Analyzer, Flat files.

Confidential , Jersey City, NJ July ‘05 – Jun ‘07
DataStage Developer

Responsibilities:

• Was responsible for Requirement Analysis, Design and Development of the project.
• Performed extensive source Data analysis for effective design.
• Extracted data transformed and loaded into Oracle databases according to the required provision using DataStage 7.5.
• Designed Star schema model for Target system.
• Responsible for mapping and workflow techniques.
• Enhanced the Job Performance by using proper partitioning methods and analyzing resources utilized using Job the Monitor.
• Extensively used most of the stages available in DataStage (Transformer, Aggregator, Join, Lookup, Merge, Sort, Link Collector, Link Partitioner, Hash file, Sequential file).
• Used Datastage Manager for Importing, exporting projects, Individual components, Metadata definitions, from and to Repository
• Involved in all the stages of Software Development Life Cycle (SDLC).
• Extensive experience working with complex mainframe EBCDIC files using complex file stage
• Experience in UNIX shell scripting, for various functions such as maintenance, backup, and configuration.
• Automated Job Control using Batch logic to execute and Schedule various Datastage jobs.
• Designed Datastage jobs for loading history data into WareHouse table.
• Ensured Data Quality by validating the data and maintaining proper data structure
• Used Environment Variables and Stage Variables for developing Parameter Driven Jobs and debugging them.
• Enhanced the Job Performance by using proper Partitioning methods and analyzing the resources utilized using Job Monitor.

Environment: Ascential DataStage 7.5, (Designer, Director, Manager) Enterprise Edition, Quality Stage 7.x/8.X, SQL Server, Query Analyzer, Enterprise Manager, PL/SQL, Oracle 9i/10g, AIX, Unix.

Confidential, NY Jan ‘03 - June ‘05 
DataStage Developer

Responsibilities:

• Gathered user requirements from Business Analysts.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms.
• Created DataStage server jobs to load data from sequential files, flat files and MS Access.
• Used DataStage to transform the data to multiple stages, and documented the details.
• Analyzed the performance of the jobs and project and enhance the performance using the standard techniques.
• Created job sequences and scheduled for automation.
• Designed and Developed jobs using Parallel Extender for splitting Bulk Data into subsets and to dynamically distribute to all available Nodes to achieve best job performance.
• Used the Data stage Designer to develop jobs for extracting, cleaning the Data.
• Transforming, integrating, and loading data into data warehouse database.
• Used the Data Stage Director for scheduling, validating, running and monitoring the jobs.
• Used Administrator for creating projects and managing the users.
• Used almost all stages like Sequential file, hash file, odbc stage etc and also
• Extensively involved in creating custom routines and transforms.
• Created reusable transformations and jobs using Designer Tool set of DataStage.
• Developed various stages such as merge stage, look up stage, funnel stage, filter stage, copy stage.
• Extensively involved in Unit & system to verify expected results..
• Used DataStage Director to schedule and monitor the jobs.
• Used DataStage Administrator for setting the variables and parameters.
• Prepared Data volume estimates and troubleshot using the debugging tool.

Environment: 
Ascential DataStage 7.1/6.0 ( Designer, Director, Manager ) Windows NT 4.0, UNIX,Oracle 8i, PL/SQL, Sequential Files, MS Access,DB2,ERwin 4.0.

Confidential Sep ‘01 - Dec ‘02
Websphere Administrator

Responsibilities:

• Installed, configured and maintained IBM WebSphere Application Server 5.x(Network Deployment) on diverse UNIX platforms and Windows 2003
• Involved in migration of the applications from WAS 4.x to 5.x
• Supported WebSphere Application Server clustering, load balance, failover/recovery and performance tuning
• Involved with the customer care and deployment teams in trouble shooting and fixing day-to-day problems of the applications in production
• Involved in configuring the WebSphere load balancing utilizing WebSphere Workload Management (WLM) including horizontal scaling and vertical scaling.
• Configured horizontal scalability of WebSphere through a mechanism called as “Cloning of multiple JVMs” with independent Java Virtual Machines-JVMs, for each clone.
• Involved in trouble shooting and Performance tuning using Tivoli Performance Viewer and log analyzer.
• Installing SSL certificates, configuring Single Sign On (thru TAI module of Siteminder), configuring Siteminder WebAgent to implement Security, and enabling Global Security for the Application Server
• Configured volume groups and logical volumes, extended logical volumes for file system growth need using Logical Volume Manager (LVM) commands
• Proficient in working with WebSphere Log Analyzer tool for trouble shooting and handling of Application/Web server errors and logs

Environment: 
Aix 5.2, Sun OS 5.6/2.7/8, Apache, WebSphere 4.0.x/5.0/5.1, IBM HTTP Server, Websphere Portal Server 5.0.2.6, BIG IP, Windows NT/2000, Tivoli, Oracle 8i, Java, EJB, Java Servlets, JSP 1.0

Education:

• Bachelor of Engineering in Computer Science