PROFESSIONAL SUMMARY:

• Software professional wif 8+ years of experience, Proficient in prioritizing and completing tasks in a timely manner, yet flexible to multi task when necessary. Customer focused wif diverse industry experience including Health Care, Telecom and Banking. Keen to learn new programs and processes. A team player who is attentive to detail and able to work in a fast paced environment. Excellent oral and written communication skills.
• Experience in software systems Development client/server Business systems wif 5 years of strong Data Warehousing experience on Extraction, Transformation and Loading (ETL) processes using IBM Information server 8.1/Data Stage 7.5 and Information Analyzer (Profile stage) and Quality Stage.
• 3+ years of experience in IBM mainframes development and testing.
• Strong Knowledge of Data Warehousing, ETL, Business Intelligence (BI) and OLAP.
• Efficient in all phases of teh software development lifecycle (SDLC), coherent wif Data Cleansing, Data Conversion, Performance Tuning, Unit Testing, System Testing, User Acceptance Testing (UAT).
• Experience in analyzing Star Schema/Snowflake Schema, Dimensional Data Modeling
• RDBMS experience wif Oracle 10g/9i, DB2 including database development, developed Stored Procedures, Triggers, Functions, Packages, Views, Materialized Views and Partitioning tables, Nested Tables.
• Extensively worked wif Parallel Extender for splitting bulk data into subsets to distribute teh data to all available processors to achieve best job performance.
• Extensively worked on DataStage client Components Designer/Manager, Director and Administrator.
• Strong in process creation for both Server and Parallel Extender in Ascential Datastage.
• Experience in Data integration wif Mainframe systems
• Strong in IBM DataStage ETL, SQL, Unix, FTP, SDLC (System Development Life Cycle), DB2, UAT Testing, and mainframe utilities.
• Worked wif Metadata Definitions, Import and Export of Datastage jobs using Data stage Manager.
• Strong background in ETL tools, such as Data stage parallel Extender.
• Implemented quality stage for data cleansing, data standardization and matching process.

TECHNICAL SKILLS:

ETL: IB IBM DataStage & QualityStage 8.1, Ascential DataStage 7.5 EE (Designer, Director, Manager, Administrator), FastTrack, Information Analyzer

Data Modeling: Star Join Schema, Snow - Flake Schema, Dimensions & Fact Tables, Physical and Logical Data Modeling, Erwin (Forward & Reverse) engineering

BI Tools: C Cognos 8.3

Databases: Oracle 10g/9i, DB2 9.x, MS SQL Server 2005

Environment: Windows 2003/2000NT 4.0, UNIX

Languages: S C, Java, XML, SQL, COBOL, JCL

PROFESSIONAL EXPERIENCE:

Confidential, TX

DataStage Analyst

Responsabilités:

• Work closely wif Business analysts and Business users to understand teh requirements and to build teh technical specifications.
• Responsible to design, develop and build DataStage parallel jobs using DataStage designer.
• Developed SHELL scripting to validate teh incoming data.
• Handled different structures of source data
• Developed and supported teh Extraction, Transformation and Load process (ETL) for a data warehouse from various data sources using DataStage Designer.
• Designed and developed Parallel jobs to extract data, clean, transform, and to load teh target tables using teh DataStage Designer
• Designed, developed job sequences to run multiple jobs
• Used DataStage Designer for importing teh source and target database schemas, importing and exporting jobs/projects, creating new job categories and table definitions.
• Designed and developed teh Routines and Job Sequence for teh ETL jobs
• Prepared Technical Specification Documents for DataStage Jobs.
• Involved in Unit testing and integration testing.
• Responsible for running jobs using Job Sequencers, Job Batches.
• Developed Parallel jobs using various stages like Join, Merge, Funnel, Lookup, Sort, Transformer, Copy, Remove Duplicate, Filter, Column Generator, Pivot and Aggregator stages for grouping and summarizing on key performance indicators used in decision support systems
• Understanding of source code control concepts.
• Extensively used Reject Link, Job Parameters, and Stage Variables in developing jobs
• Used teh DataStage Director to run, schedule, monitor, and test teh application on development, and to obtain teh performance statistics.

Environment: IBM Websphere DataStage & QualityStage 8.5 (Designer, Director and Administrator), UNIX, Shell Scripting, Oracle 10g, SQL Loader, PUTTY, DB2, VSAM, Flat files, Mainframe utilities, Balance Optimizer, SQL Server, SQL Assistant, Windows XP, Visio, Erwin, Business Objects

Confidential, PA

DataStage Analyst

Responsabilités:

• Involved in requirement gathering, analysis and study of existing systems.
• Extensively used DataStage Designer for developing Server jobs, Parallel jobs and performed complex mappings based on user specifications.
• Used DataStage Designer for Extracting Data, Performing Data Transformations and Aggregate Data.
• Performed lookups using Hashed files.
• Used DataStage Manager to store and manage reusable Metadata, and created custom routines and transforms for teh jobs.
• Experience in using DataStage Director to Validate, Run, Schedule and Monitor DataStage jobs.
• Worked extensively on all teh stages such as OCI, Sequential, Aggregator, Hashed Files, Sort, Link Partitioner, Link Collector and ODBC.
• Developed jobs in Parallel Extender using different stages like Transformer, Aggregator, Lookup, Source dataset, External Filter, Row generator, Column Generator and Peek stages.
• Distributed load among different processors by implementing teh Partitioning of data in Parallel Extender.
• Used Partition methods and Collecting methods for implementing parallel processing.
• Extracted data from Oracle and DB2 databases, transformed data and loaded into Oracle data warehouse.
• Also extracted data from Flat files, Sequential files and access files, applied transformations and loaded teh data into Oracle data warehouse.
• Created DataStage jobs and Job sequences and tuned them for better performance.
• Developed Unix shell scripts to automate teh Data Load processes to teh target Data warehouse.

Environment: Data Stage 8.1, Ascential Datastage Version Control, Erwin4.0, Oracle (9i), FileZilla, DB2 UDB 7.2, TOAD 7.4, PL/SQL, Windows NT server, Unix 5.2.

Confidential, PA

DataStage Developer

Responsabilités:

• Involved in requirement gathering, analysis and study of existing systems.
• Extensively used DataStage Designer for developing Server jobs, Parallel jobs and performed complex mappings based on user specifications.
• Used DataStage Designer for Extracting Data, Performing Data Transformations and Aggregate Data.
• Performed lookups using Hashed files.
• Used DataStage Manager to store and manage reusable Metadata, and created custom routines and transforms for teh jobs.
• Experience in using DataStage Director to Validate, Run, Schedule and Monitor DataStage jobs.
• Worked extensively on all teh stages such as OCI, Sequential, Aggregator, Hashed Files, Sort, Link Partitioner, Link Collector and ODBC.
• Developed jobs in Parallel Extender using different stages like Transformer, Aggregator, Lookup, Source dataset, External Filter, Row generator, Column Generator and Peek stages.
• Distributed load among different processors by implementing teh Partitioning of data in Parallel Extender.
• Used Ascential MetaStage for data integration and standardization for loading in Oracle data warehouse.
• Used Partition methods and Collecting methods for implementing parallel processing.
• Extracted data from Oracle and DB2 databases, transformed data and loaded into Oracle data warehouse.
• Also extracted data from Flat files, Sequential files and access files, applied transformations and loaded teh data into Oracle data warehouse.
• Created DataStage jobs and Job sequences and tuned them for better performance.
• Developed Unix shell scripts to automate teh Data Load processes to teh target Data warehouse.

Environment: Data Stage 7.5(Parallel Extender), Ascential Datastage Version Control, Erwin4.0, Oracle 9i, VSAM, Flat files, Mainframe Utilities, DB2 UDB 7.2, TOAD 7.4, PL/SQL, Windows NT server, AIX Unix 5.2.

Confidential, CT

DataStage Developer

Responsibilities:

• As a Data Warehousing team member, Involved in designing, developing and testing of teh ETL (Extract, Transformation and Load) strategy to populate teh finance, HR, client, vendor, manufacturing Data from various source systems into Enterprise Data Warehouse using DataStage ETL Programs.
• Involved in Data Profiling to understand teh patterns, completeness, and quality of source data.
• Involved in data modeling.
• Worked on design and developing data extraction programs using DataStage client component Designer.
• Experience using DataStage Directory component to run, monitor jobs and to clean up teh logs and manage teh parallel datasets.
• Used DataStage as an ETL tool to extract data from sources systems and aggregate teh data and load into teh Oracle database.
• Worked on Extracting data from Mainframe legacy VSAM data sets to Data Mart Application.
• Extensively used stages like Transformer, Join, Funnel, Join, Merge, and Lookup stages etc. to process and merge teh data.
• Involved in performance tuning of teh ETL process and performed teh end-to-end testing.
• Designed server jobs for migrating data from staging area to warehouse to data marts
• Performing Unit Testing and integration testing
• Extensively used SQL Loader to load Oracle database
• Defined test scripts, test specs & testing methodologies.

Environment: IBM DataStage 7.5, Oracle 9i, DB2, VSAM, XML Plug-Ins, Version control, SQL Server, Windows NT, Toad for Oracle, Micro strategy.

Confidential, TX

Mainframe Developer

Responsibilities:

• Involved in Production support on a rotation basis
• Endeavor TEMPhas been used for promoting teh codes
• Tools developed using CLIST and REXX
• Critical jobs statistics tool, ACS tracker tool, GDG Tool, DD Name Vs File name and developed back end JCL’s and COBOL programs.
• All teh back end modules involve Database interaction like creating teh table, Inserting teh data and retrieving teh data.
• Supported multiple testing environments concurrently IBS, FDR/BASE, FDR/SEARS, both minor and major releases
• Key point of contact to end users and developers
• Responsible for configuration management, involves Verification of jobs, procs, cards, modules, copy books in development libraries for teh correctness. Verification of Tag’s, Change man package, parent and implementation details.
• Involved in teh stage, promote and recompiles of teh components.
• Acted as a Defect preventive prime
• Developed and implemented teh Compare Process, regression SCRUB process
• Involved in teh preparation of regression design document, analysis of miss compares and responsible to circulate teh same to developers to fix teh issues.

Environment: TSO/ISPF, SDSF, COBOL, JCL, DB2, EasyTrieve, PPM, Remedy, CICS, SQL, SPUFI, VSAM, Z/OS, MS Office, File-Aid, REXX, DB2 TMS, Expeditor and Endevor.

Confidential, NJ

Mainframe Developer

Responsibilities:

• Understanding of teh present system
• Prepared test plan and presenting teh same to team
• Setting up teh Jobs in TSO Environment and Fixing teh errors
• Comfortable in fixing JCL Errors, VSAM File errors and DB2 issues
• Endeavor TEMPhas been used for teh change control management
• Comfortable wif all Endevor Activities like moving teh code across different stages, creating teh packages, resetting teh packages and casting.
• Spufi TEMPhas been used for executing teh SQL Queries and for identifying teh test data
• File-Aid TEMPhas been used to analyze teh File Data to by mapping teh files to copy books, and also used many other features of file Aid like comparing teh files, creating teh files
• Follow up wif teh team members for all project related issues and defects
• Provided support to UAT team during UAT window
• Involved in teh Post Implementation support
• Preparing weekly status reports to track teh status of testing
• Participated in meetings wif project manager
• Prepared Knowledge transition documents on teh projects worked
• Involved in all phases of SDLC and Acted as a Developer, Testing Coordinator, (Offshore Coordination)
• Involved in Production support on a rotation basis

Environment: TSO/ISPF, SDSF, COBOL, JCL, DB2, CICS, EasyTrieve, HP Quality center, SQL, SPUFI, VSAM, Z/OS, MS Office, File-Aid, REXX, Expeditor and Endeavor.