Professional Summary

• Around 7 years of total IT experience in design, development, testing, deployment and maintenance of data warehousing systems.
• Excellent experience in ETL tool Data Stage server and parallel extender in analyzing, designing and developing ETL processes for Data Warehousing projects using IBM Websphere-AscentialDataStage 8.x/7.x .
• End-End SDLC experience in data warehousing projects including prototyping, requirements gathering, data profiling, cleansing, design, development, testing, deployment and post-production support. Highly experienced in onsite-offshore delivery model.
• Strong testing lead experience in understanding test requirements,test strategy development,test scenarios, test cases for unit, integration and UAT testing.
• Strong client facing and communication skills including understanding business requirements and status reporting.
• Strong SQL skills for creating and maintaining database objects, storage structures and performance tuning SQL queries.
• Extensive datastage development skills using core components datastage designer, datastage director,datastage manager,datastage administrator, quality stage, information server and parallel extender in InfosphereDatastage 8.5/8.1/7.5/7.1
• Expertise in Datastage issue resolution, debugging and application performance tuning.
• Expertise in extracting data from various versions of Oracle and DB2 database using Datastage. Worked with various databases like DB2 UDB, and Flat Files into a staging area. Strong database skills with Oracle, and DB2.
• Expertise in UNIX shell programming. Used UNIX Shell Scripts for ETL process automation.
• Utilized core datastage stages like transformer, joins, merge, lookup, oracle, ODBC, surrogate key stage, filters, modify, aggregation, peek, complex flat file, funnel etc.
• Experience in developing complex, critical shell scripts for file validation, job scheduling and job automation.
• Good experience in production support and handling high severity incidents.
• Experience in working with scheduling tools like Mainframe ESP and CAWA.
• Prepared key technical documents like detailed design document,mapping sheets,data migration strategy,system design document, cutover plan and deployment plan.
• Strong logical, team oriented, listening and communication skills. Research oriented, motivated, proactive, self-starter with strong technical, analytical and interpersonal skills.

Technical Skills

PROFESSIONAL EXPERIENCE

Confidential

Application Lead- Support

SII Production Support

SII Strategic Inventory Initiative which develop and deploy integrated, demand-driven inventory management processes and systems. Used for combining financial/assortment planning and demand forecasting and allocation into one end to end process

Responsibilities

• Analysed and resolved critical functionality issues in data flow in various systems.
• Resolved data quality issues raised by end users in each of the applications.
• Monitoring batch scheduleswith SLA Service Level Agreement compliance
• Sending status and incident reports to the business leadership
• Worked with clients to improve the business by reducing batch runtime and performance tuning methodologies
• Incident Management to handle incidents in batch and data related issues.
• Change Management for minor enhancements, code fix, new requirements and performance tuning for batch improvement
• Defect identification and fixing
• Provided IT support and resolution for production related issues.
• Provided ad-hoc data extracts to help business partners for effective planning and forecasting
• Created schedules for the batch jobs and done extensive testing in CAWA scheduler before implementing the code in production

Tools/Environment

InfosphereDatastage 8.5,Datastage 7.5, SQL, UNIX, DB2, Winscp, Putty, CAWA, IBM Data Studio, Service Manager

Confidential

Application Lead-Upgrade

Confidential

This was a large technology transformation program for ESP batch jobs from Mainframe to Clerity-linux environment and up-gradation of DB2 database to LUW. The Batch scheduler was also migrated from Mainframe based ESP to open source system CAWA.

Responsibilities

• Interacted with the business users to understand functional requirements, document their expectations and translated to design models and solutions to transform the batch jobs, Database and Scheduler.
• Worked on conversion of impacted programs from Mainframe based system to Clerity environment
• Prepared the estimates and detailed plan for migration
• Analysed the existing configuration of ETL and Mainframe jobs and approach for moving the systems to the new environment
• Collected impacted ETL and any Mainframe interactions and prepared component list
• Created test plans for Unit, System, Integration and End to End testing. Reviewed test plans and implementation plans.
• Done Unit, System, Integration and End to End testing for the impacted components in the new environment, Database and Scheduler.
• Identified defects and raised defects/issues in Quality Center for effective defect management and resolved defects with the help of infrastructure teams.
• Done extensive multiple iterations of Mock testing and Performance testing for each component.
• Created deployment plan for various applications and worked with the application support to ensure smooth migration with minimum business impact
• Implementation coordination of the jobs in the new server, Database and Scheduler environment. Validated of the configuration changes and identified post implementation issues.
• Provided warranty support after the migration to ensure changes are working fine

Tools/Environment

InfosphereDatastage 8.5,Datastage 7.5, SQL, UNIX, DB2, Winscp, Putty, CAWA, IBM Data Studio, Service Manager, Mainframe ESP batch scheduler

Confidential

Senior Systems Engineer- Datastage

Confidential

SII Strategic Inventory Initiative which develop and deploy integrated, demand-driven inventory management processes and systems. Used for combining financial/assortment planning and demand forecasting and allocation into one end to end process

Responsibilities

• Design, develop and test datastage jobs by utilizing core stages like transformer, joins, merge, lookup, oracle, ODBC, surrogate key stage, filters, modify aggregation, peek, complex flat file, funnel etc. Managed version controls using job compare and impact analysis.
• Performed key transformations using loop processing,dynamic transformer,link variables,system variables,sort stages etc.Fine-tuned jobs to minimize sorts and repartitions.
• Used different parallel extender partitioning techniques like key based partitioning techniques hash and modulus and non-key based partitioning techniques round robin and entire techniques for performance enhancements.
• Worked on efforts estimation, resource estimation, size and volume estimation and infrastructure and database size estimation for the project. Conducted quality assurance activities such as datastage code reviews.
• Worked on performance improvements of Datastage jobs by tuning the SQL queries and job design.
• Prepared test plans and done Unit testing, System testing, Integration testing and End to End testing for minor enhancements
• Prepared Weekly and Monthly status reports to keep track of the code changes, batch issues and major accomplishments
• Mentored and guided the team members for effective management.

Tools/Environment

InfosphereDatastage 8.5,Datastage 7.5, SQL, UNIX, DB2, Winscp, Putty, Service Manager, Mainframe ESP batch scheduler, Quality center

Confidential

Systems Engineer- Datastage

Confidential

This project is to remove the interdependency between two systems RMS Retail Merchandise System which deals with Purchase Order creation, Sales Return, Receipt from Warehouse, units ordered, units at store, and units at warehouse and ODS Operational Data Store a Java based reporting system tightly coupled with RMS, using file data queuing approach. This design helped in eliminating the impact on RMS resulting from delays in ODS jobs.

Responsibilities

• Developedcritical shell scripts for file validation, job scheduling, data transfer and job automation.
• Used different parallel extender partitioning techniques like key based partitioning techniques hash and modulus and non-key based partitioning techniques round robin and entire techniques for performance enhancements.
• Created datasets for intermediate storage of data and for quick retrieval. Designed dataset files transfer from one server to the other.
• Optimized datastage job performance by splitting the Extract, Transformation and load done in single job into separate jobs.
• Implemented Queuing solution to provide the ability to recover by re-processing of data jobs using the archived data files. Better data analysis is also enabled with availability of archived data files.
• Developedexecutor framework for audit and error handling and monitoring scripts for performance tuning of the existing process.
• Critical member in integration testing, system testing anduser acceptance testing anddeployment of the application.Prepared a detailed go-live and backout strategy document.
• Done all the various phases of testing to deliver defect free code.

Tools/Environment

Datastage 7.1, SQL, UNIX, DB2, Winscp, Putty, Mainframe ESP batch scheduler, Quality center

Confidential

Systems Engineer- Datastage

Confidential

This project is a modification in Store Attributes Deviations Upload and Enhancement of the Common Validation service to validate store associations to seasonality groups and Bill of Distribution.

Responsibilities

• Utilized core datastage stages like transformer, joins, merge, lookup, oracle, ODBC, filters, modify, aggregation, peek, funnel etc.
• Developed reusable datastage components using local and shared containers to provide simplified view of complex design and standardize development steps.
• Gathered requirements from the client and prepared High level and Technical Design documents
• Created sub-queries and joins for complex requirements involving multiple tables and exception handlers. Performed query optimization and performance tuning using SQL.
• Created detailed design documents to list ETL extract strategy, initial/incremental data load strategies, insert/update/delete strategies and audit and data reconciliation.
• Managed defect and bug tracking using HP quality center.
• Done various cycles of testing and removed defects before implementing the code in production and created test plans and results.
• Prepared datastage naming convention standard document, datastage coding checklist and implemented datastage best design practices.

Tools/Environment

Datastage 7.5, SQL, UNIX, DB2, Winscp, Putty, Mainframe ESP batch scheduler, Quality center