SUMMARY

• 7+ Years of overall IT experience in Analyzing, Designing, Developing, Testing, Implementing and Maintaining client/server business systems over six years of experience wif IBM Information Server (IBM WebSphere DataStage 11.5/9.1/8x DataStage Enterprise Edition (Parallel Extender) to implement ETL solutions and Data Warehousing projects
• Very good knowledge on running Data Stage jobs on Hadoop or big data systems.
• Experience in Data warehousing and Data migration.
• Experience inData Modeling, Star Schema/Snowflake Schema modeling, FACT & Dimensionstables, Physical & logical data modeling.
• Used both Pipeline and Partition Parallelism for improving performance.
• Developed Parallel jobs using various stages like Join, Merge, Lookup, Surrogate key, SCD, Funnel, Sort, Transformer, Copy, Remove Duplicate, Filter, Pivot and Aggregator stages for grouping and summarizing on key performance indicators used in decision support systems.
• Frequently used Peek, Row Generator and Column Generator stages to debug.
• Expertise in Software Development Life Cycle (SDLC) of Projects - System study, Analysis, Physical and Logical design, Resource Planning, Coding and implementing business applications.
• Expertise in performing Data Migration from various legacy systems to target database.
• Expertise in Data Modeling, OLAP/ OLTP Systems, generation of Surrogate Keys, Data Modeling experience using Ralph-Kimball methodology and Bill-Inmon methodology, implementing Star Schema, Snowflake Schema, using Data Modeling tool Erwin.
• Experience inTERADATAUtilities: BTEQ, Fastload, Multiload, Fastexport
• Experience in implementing Netezza, DB2, DB2/UDB, Oracle 10.2/ 9i/ 8i/ 8.0, SQL Server, PL/SQL, and SQL *PLUS database applications.
• Participated Actively in Server Upgrade and Data Stage Version Upgrade.
• 1.5 Year of experience in working wif Data-Services (SAP-BODS), D3.JS
• Migrating jobs from DataStage 7.5.1 to DataStage 8.1 Enterprise Edition, 8.5 to 11.5, Server jobs to parallel jobs migration
• Experience in HP Quality Center and RTC (Rational Team Concert) to manage manual and automated test cases and to track defects.

TECHNICAL SKILLS

Databases: Netezza, Oracle 10g/9i, DB2 Teradata V2R3/V2R4.1

Tools: IBM Info Sphere / WebSphere Data Stage 11.5/9.1 /8.7 Designer, Director, Administrator and Manager)

Languages: SQL, PL/SQL, UNIX Shell Script, XML.

Reporting Tools: D3.JS

PROFESSIONAL EXPERIENCE

Senior IBM Data Stage Developer/ Data Analyst

Confidential - San Antonio, Texas

Responsibilities:

• Involved in data modeling session, developed technical design documents
• Identifying data gaps between old (PeopleSoft) and new (workday) ERP Systems.
• Involved in data discovery in profiling different source data.
• Designed Parallel jobs using various stages like Join, Merge, Remove Duplicates, Filter, Lookup, Modify, Aggregator and Funnel stages.
• Developed Parallel Jobs using various Development / Debug Stages (Peek Stage, Row generator stage, Column generator stage, Sample stage) and Processing Stages (Aggregator, Change Capture, Change Apply, Filter, Sort and Merge, Funnel Remove Duplicate Stage).
• Created a technical proof of concept for implementing teh D3.js using teh feed generated by Data Stage. This is done as an alternate to teh Cognos active reports .
• Creation of unit test case documents
• Developed shell scripts and updated teh log for teh backups.
• Involved in performance tuning of long running jobs.
• Involved in volume testing and quality testing.
• Involved in performance tuning of long running jobs.
• Involved in volume testing and quality testing.
• Creating teh scheduling plan, job execution timings and sharing wif scheduling team (Control-M)
• Modifying teh existing (Re-Usable) Job if required.
• Involved in Retrofitting legacy Informatica jobs to Data Stage 11.5.
• Used Data Stage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data Warehouse.
• Involved in Data Stage upgrade from 9.1 to 11.5.

Environment: Data Stage 9.1/11.5, Netezza, Oracle 10g/9i, DB2, Hadoop 2.2.0, Red Hat 6.8.

Data stage Developer

Confidential, Fort Worth, TX

Responsibilities:

• Development of DataStage design concepts, execution, testing and deployment on teh client server.
• Designed and developed sequence jobs wif stages Nested Condition, Execute Command, Job activity, Sequencer, User variables activity to dynamically loop through 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.
• Worked on business objects that map to actual SQL structures in teh database. All objects are grouped into classes and subclasses.
• Used DB2 EE stage for doing loads into DB2 UDB Database and to load large volumes of data into Teradata V2R4 using Teradata Fast Export, Multi Load, and T-Pump.
• Developed Stream Dashboard using BIWS on SAP BO, dashboard was used to make sure teh Financial process for teh Allocations and Budget was all sync and as planned for teh current Fiscal Year.
• Used DataStage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data Warehouse.
• Created dashboards using Xcelsius based on project requirements, I have developed complication dashboards using BIWS, live Office and QAAWS based on available SAP Environment.
• Running and monitoring of Jobs using DataStage Director and checking logs.
• Monitoring all data loads and fixing teh errors.

Environment: IBM WebSphere DataStage 8.5,Oracle 9i, Teradata V2R4, DB2, SQL Server 2005, Flat Files, UNIX scripting, Windows 2003, Autosys, Quality stage, Profile stage.

Data stage Developer

Confidential

Responsibilities:

• Worked wif users & analysts to understand requirements
• Participated in client meetings to review Integrated Data approaches and to interpret results
• Closely involved in gathering requirement, design, development and implementation of teh project
• Worked wif Development Team to draft teh Development Checklist and Plan for Iteration Releases.
• Developed Parallel jobs using various stages like Join, Merge, Lookup, Surrogate key, SCD, Funnel, Sort, Transformer, Copy, Remove Duplicate, Filter, Pivot and Aggregator stages for grouping and summarizing on key performance indicators used in decision support systems.
• Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing
• Performed database validation according to teh business logic by comparing teh source to teh target in Spreadsheet
• Work wif source system personnel on source data delivery issues. Interacted wif DBA for setting up test environment
• Created teh test environment for Staging area, loading teh Staging area wif data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables
• Mapped Requirements to test cases (Traceability) for SIT and UAT in Requirements module of Quality Center.
• Review test specifications, cases and performed manual testing
• Developed and tested UNIX shell scripts as part of teh ETL process
• Automated teh process of loading, pulling teh data for test data setup.
• Involved in Backend Database testing in Oracle using SQL.
• Followed State Street defined ETL Standards and Best Practices

Environment: QC, QTP, Clear Quest, Clear Case, Ascential DataStage 7.5, Oracle 10g, UNIX, SQL*plus, Windows NT and Autosys