SUMMARY

• 8 Years of overall IT experience as ETL Developer using Data stage 11.5,9.1,8. x.
• Working as Onsite Technical Lead for the project Confidential - Claim Data Warehouse. In this tenure, multiple scheduled maintenance releases were go-live to production without any UAT and post production issues. Also, successfully deployed multiple enhancements. Client always appreciated the work done for the project.
• High performance in System Analysis, design, development and implementation of Relational Database and Data Warehousing Systems using IBM Data Stage 11.5/9.1/8.x
• Experience in Designing, Developing, Testing of ETL Jobs and mapping in server and parallel jobs Using data stage to populate the tables.
• Proficient Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, remove duplicates, Filter, CDC, Dataset, Lookup file set, Funnel, Database connector, Modify, Aggregator, XML.
• Expert in working with Data Stage Designer, Administrator, and Director.
• Excellent knowledge of studying the data dependencies using metadata stored in the repository and prepared batches for the existing sessions to facilitate scheduling of multiple sessions.
• Involved in Data Stage Migration Work
• Expertise in UNIX shell scripts using K-shell for the automation of processes and scheduling the Data Stage jobs using Autosys.
• Worked with Different Databases like DB2, Oracle 10g, SQL Server 2000, DB2, Sybase.
• Experience in all facets of software development life cycle (SDLC) and skilled in writing, testing and reviewing code.
• Experience in Design, Development, and Implementation of Reporting (Cognos) development projects.
• IBM Certified Cognos BI Author- Cognos 10 BI Author
• IBM Certified Solution Developer - Info Sphere Data Stage v8.5 Certification
• Performed SDLC cycle of Data Integration, Unit testing, System Integration testing, Implementation and Maintenance.
• Active participation is Business Check out calls after Production Installation.
• Effective Team Player and an individual contributor with deep quest for learning.
• Perseverance to achieve the set goals with self-motivation
• Good analytical and logical reasoning skills for understanding and implementing any requirement.
• Experience in grooming the junior team members technically and functionally to meet the client requirements.
• Experience in fine tuning the Data stage jobs for performance efficiency.

TECHNICAL SKILLS

Languages Technologies: Data Stage, Cognos 10 Report Studio, Cognos10 Framework Manager.

Database Applications: SQL Server, DB2, Oracle, Sybase, MySQL Application servers UNIX Frameworks / Middleware Autosys, ETL job control.

Tools: Data stage 11.5, Data stage 9.1, Data stage 8.7, IBM Cognos Transformer, IBM Cognos Power Play, Putty. Toad, Query tool, Cognos 10 Report Studio, Cognos 10 Framework Manager, CA Work Station.

Methodology: Waterfall, Agile.

Version Control: PVCS Version Manager 8.4, SVN.

Other Tool: Quilk view, I WAY Software, Web focus, File Zilla, SSH Client, MS Visio, VB6.

Operating System: Window XP Protocols TCP

PROFESSIONAL EXPERIENCE

Confidential

Senior Software Systems Engineer / Technical Lead

Responsibilities:

• Requirement Analysis, Impact Analysis, Estimation.
• Preparation of design strategy for the new applications to the warehouse.
• Prepare the Gap Analysis documents for new applications to Data warehouse.
• Ensuring the overall quality and timeliness of the deliverables.
• Communicate with the client for collecting the requirements and document the same
• Coordinating for solving production data quality problems
• Coordinating project activities
• Coordinate with architects for the design reviews, framework standards and reference materials
• Creating the Application Design Specification Document(ADS)
• Reporting the project status
• Creating Technical Specifications from the ADS
• Coding (Development, support and enhancement)
• Resolving issues and defects
• Understanding and defining content of releases
• Coordinating release documentation
• Reporting the progress to Confidential and Confidential Consultancy Services management.
• Communicate with offshore/ onshore and clarify the queries
• Confirm/ clarify queries with business team to facilitate the requirement gathering
• Co-ordinate with Offshore/onshore counterpart for timely delivery of the work items with the highest Quality
• Improve performance and maintenance and quality of the processes.

Environment: Data stage 9.1, 8.7, TOAD, Putty, CA work station, ETL job control, SQL, PL/SQL, Unix Shell Scripting, Oracle.

Confidential

Senior Software Systems Engineer / Technical Lead

Responsibilities:

• Assess the new requirements provided with the business user and the business analyst.
• Preparation of LOW level Design document
• Review of Functional Specification Document.
• Design ETL jobs Using Data Stage designers as per Specifications mentioned in Low-Level, High-level and Functional design documents
• Involved in Migration work from Data stage 8.7 to 9.1 and DS 9.1 to 11.5
• Create and schedule Cognos reports to meet the business needs.
• Run Monthly cubes using Power Play Transformer.
• Onsite-Offshore Coordination.
• Coordinating with functional team related to Design part & Keep Track of all changes.
• Design of indicators in the table structure of the application to handle the complex requirements of the project and thus writing SQL queries as part of extract jobs.
• Doing a peer review of the deliverables and documenting the defects
• Doing a causal analysis for all the defects and providing the resolution for the same.
• Coordinate with team members and administer all onsite and offshore work packages.
• Analyse performance and monitor work with capacity planning.
• Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
• Documented test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Participated in weekly status meetings.
• Developed Test Plan that included the scope of the release, entrance and exit criteria and overall test strategy. Created detailed Test Cases and Test sets and executed them manually.
• Analyse the issue raised in Service Now and provide a prompt resolution as per requirements.
• Handle all Production and Non-Production deployment process
• Providing Onsite support to make the system available 24/7

Environment: Data stage 9.1, 8.7, Cognos Report Studio, COGNOS Frame Work Manager, Query Tool, TOAD, Quilk view, Putty, SSH client, PVCS Version Manager, SQL, Unix Shell Scripting, Java script, DB2, SQL SERVER, SYBASE

Confidential

Senior Software Systems Engineer / Developer Lead

Responsibilities:

• Involved as primary on-site ETL Developer during the analysis, planning, Design, development, and implementation stages of projects using IBM Web Sphere Software.
• Prepared Data Mapping Documents and Design the ETL jobs with required Tables in the Dev Environment.
• Active participation in decision making and QA meetings and regularly interacted withthe Business Analysts &development team to gain a better understanding of the Business Process, Requirements & Design.
• Used Data Stage as an ETL tool to extract data from sources systems, loaded the data into the ORACLE database.
• Designed and Developed Data Stage Jobs to Extract data from heterogeneous sources, applied transform logics to extracted data and Loaded into Data Warehouse Databases.
• Created Datastage jobs using different stages like Transformer, Aggregator, Sort,
• Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter,
• Change Data Capture, Surrogate Key, Column Generator, Row Generator, Etc.
• Extensively worked with Join, Look up (Normal and Sparse) and Merge stages.
• Extensively worked with sequential file, dataset, file set and look up file set stages.
• Extensively used Parallel Stages like Row Generator, Column Generator, Head, and Peek for development and de-bugging purposes.
• Used the Data Stage Director and its run-time engine to schedule running the solution, Testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis.
• Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.
• Creation of jobs sequences.
• Created shell script to run data stage jobs from UNIX and then schedule this script to
• Run data stage jobs through scheduling tool.
• Performed internal/external Quality inspection for the entire project deliverables.
• Giving support in job scheduling to Autosys team

Environment: Data stage 9.1, 8.7, Cognos Report Studio, COGNOS Frame work Manager, Query Tool, TOAD, Quilk view, PL/SQL DEVELOPER, Putty, SSH client, PVCS Version Manager, SQL, Unix Shell Scripting, Java script, DB2, SQL SERVER, SYBASE.

Confidential

Technical Module Lead / Systems Engineer

Responsibilities:

• Involved in analysis of functional requirements and business specifications for development team and in the development of Cognos Reports.
• Involved with Solution Architects to provide feasible Technical Solution to meet the Business requirement
• Create List, Crosstab, Drill through reports to meet the business needs using report studio.
• Design of indicators in the table structure of the application to handle the complex requirements of the project and thus writing SQL queries.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters.
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Contributed to the creation and review of client deliverable code and design documents like Functional and Technical Documents.
• Performed housekeeping activities for SQL Server tables.
• Coordinated Internal Quality Audit and External Quality Audit activities.
• Involved in impact analysis work during decommissioning of the existing systems.

Environment: Cognos Report Studio, COGNOS Frame work Manager, Query Tool, TOAD, Quilk view, Data stage 9.1, 8.7, Putty, SSH client, PVCS Version Manager, SQL, Unix Shell Scripting, Java script, DB2, SQL SERVER, SYBASE.

Confidential

Developer / Systems Engineer

Responsibilities:

• UK Responsibilities involved
• Analyse the existing complex data loading procedure of the Application and identify the jobs need to be modified
• Develop new jobs.
• Prepare the technical specification documents
• Populate data from different source.
• Coding for jobs and create reports for the end user.
• Transform the field as user requirement.
• Unit testing
• UAT Support
• Creating and maintaining traceability matrix for the Test Plan/Test Specification vs. Requirements
• Implement project in production.
• After going live, did also some change request and ISJR for some of the Intermediate Requirements to fulfil some more requirements and preparing technical and test document.

Environment: IWAY Soft Ware, Datastage, Webfocus, VB6, Oracle

Confidential

Developer / Team Member

Responsibilities:

• Designed Technical Design Documents for the requirement provided.
• Built DataStage jobs to read files from multiple tables using Oracle Connector stage Created Sequencers with Exception Handling and Restarting logics.
• Cleansed and transformed the data as per business logic.
• Design Unit Test Cases and SIT test scripts.
• Support developed code through various testing environments.
• Perform housekeeping activities.
• Monitor the job during production runs.
• Provide production support for the warranty period.
• Investigate testing environment and fix bugs if any.

Environment: IWAY Soft Ware, Datastage, Webfocus, VB6, Pl/SQL Developer, Oracle