PROFESSIONAL SUMMARY:

• Highly motivated, solutions - driven software professional with over 5 years of strong experience in Business Analysis, Programming & Functional knowledge in ETL, expertise in using Datastage 8.x through 11.x versions.
• Expertise in using defect management tools like Test Director, Quality Center, JIRA and Rational Clear Quest.
• Strong experience in analysis, high and low level design, development, Testing and implementation of critical jobs.
• Can efficiently handle Production Support, Bug fixing, and Bug Finding & Fine tuning processes for improving performance. On-Call support for System Maintenance.
• Designed the Testing Methodology for Product Testing and Embellishment File Testing for QA team.
• Onsite/Onshore coordination activities, working in a 24/7-delivery module.
• Follow Parallel coordination/agile approach between different teams to help achieve smooth deployment of projects.
• Experienced with documentation from initiation through closure, end user support and knowledge transfer.
• Excellent Interpersonal and communication skills with the ability to remain highly focused and self-assured in fast-paced and high-pressure environments.
• Also knowledgeable in using mercury test automation tool (QTP). Exceptional ability in System Testing, Database Testing, Regression Testing, Smoke Testing, compatibility Testing, Black Box testing and creation of test cases for User Acceptance Testing (UAT). Expertise in developing Test Plans, Test Scenarios and Test Scripts for various applications to ensure proper business compliance.
• Proficient in the entire phases and different kinds of SDLC Methodologies.
• Extensive experience in Agile/Scrum methodology.
• Expertise in Job design and execution of ETL process in Datastage 8.5 through 11.x.
• Expertise in developing generic jobs in datastage between similar data platforms and debugging issues during data quality.
• Expertise in all stages of Testing in the SDLC including, Unit, Integration, System and User Acceptance (UAT)
• Exceptional ability in handling of various roles such as Onsite Coordinator, Quality Assurance Analyst, Test Coordinator and Test Lead
• Strong experience and skill in creation and documentation of Test Plans, Test Cases, Test Scripts, Test Procedures and Test Data from requirement document for various applications.
• Ability to execution positive and negative Test Case scenarios using testing tools, documented tests performed, and updated detailed Test Case reports. Revised Test Scripts as needed to meet new and changing specifications.
• CA7 cross platform job set up in Mainframes.
• Knowledge in working with automated test cases using Mercury automation tool QTP (Quick Test Professional)
• Using various queries to query SQL, Hive, distcp Sqoop, Oracle, Teradata, Greenplum, Hadoop, DB2 database systems
• Used Quality Center (QC), and Test Director for tracking and reporting defect

SOFTWARE SKILLS:

Project Methodologies: Rational Unified Process (RUP), UML, Agile, Waterfall

Business Modeling Tools: MS Visio, MS Project, IBM Data stage 8.x,9.x,11.x, PeopleSoft,Ca7 scheduler, Excel, MS word, blueprint director,sharepoint

Requirement Management Tools: Rational RequisitePro, Sql Assistant, Putty, HP ALM,Remedy,pgadmin,Sql Developer, Sap Hana Client studio,dbvisualizer, JIRA,TOAD.leankit

Operating Systems: Windows 7/NT/XP/2000, MS Dos, UNIX, Mainframes

Databases: SQL Server, MS Access, Oracle 11g,Teradata 13.0,Greenplum, Hadoop, SAPHANA, DB2 Mainframe’s, Informix, Cassandra

Languages: SQL, UML,PL/SQL,C,XML,HTML

PROFESSIONAL EXPERIENCE:

Confidential, Bentonville, Arkansas

Sr ETL Developer/Onsite Lead

Responsibilities:

• Involving in requirements gathering, analysis, design, development, and testing and deployment activities for each project being migrated to 9.1 and also 11.x
• Work closely with Business stake holder to understand the reporting needs.
• Design interfaces on data loads. Scope process improvements in case of any issues with data loads.
• Transition functional knowledge to offshore to help deliver the development on schedule. Conduct Onsite/offshore stand up meetings to get daily updates on development progress.
• Provide detailed estimates on the design received and getting resources allocated to fulfill the delivery request.
• Developing jobs for migration of data from Datastage 8.1 &8.5 to using 9.1 and also migrating to 11.x using migration tool in data stage.
• Schedule for running the jobs, testing and debugging its components and monitoring the resulting executable versions.
• New SSH key setup between Datastage servers and external source servers.
• Develop Diagnostic jobs to test environmental setup and connectivity between different databases.
• Assist in Writing Sqoop utility and HIVE SQLs for data movement to Big data platforms. Invoke distcp to copy data between servers on same clusters.
• Mentor less experience resources in tools like JIRA and BSM remedy for change control process and Incident Management
• Perform Code reviews on offshore development activities and involve in implementation activities once testing is complete.

Environment: IBM Info sphere Datastage 8.x,9.x,11.x, Oracle 11g, Mainframe, DB2, Teradata, Hadoop, HIVE,MS Visio, ASCII, Flat files, UNIX, NFS shared services, Pgadmin, Plsql, SAPHANA, Sql Assistant, Sql Developer, MS Word/Excel, sql server, Informix, filezilla, Hp ALM, JIRA,OBIEE

Confidential, Bentonville, Arkansas

Sr ETL Developer/Onsite Lead

Responsibilities:

• Data Warehouse related Customer Service Requests (CSR) within a production life cycle support environment, including release planning, status reporting, risk and issue tracking, and solution and deliverable quality assurance.
• Involving in requirements gathering, analysis, design, development, and testing and deployment activities for each Data Warehouse or ETL enhancement.
• Collaborates with the EDW team and stakeholders to ensure expectations are managed and ensure requirements are met.
• Work closely with the EDW project team members and stakeholders to assist in defining interface requirements as well as analytical reporting requirements.
• Transition functional knowledge to offshore to help deliver the development on schedule. Conduct Onsite/offshore stand up meetings to get daily updates on development progress.
• Provide detailed estimates on the design received and getting resources allocated to fulfill the delivery request.
• Developing jobs for migration of data from ETL online tool to IBM datastage 8.5 and 9.1.
• Schedule for running the jobs, testing and debugging its components and monitoring the resulting executable versions.
• Testing the code developed, running test cases in HP ALM and tracking bug fixes and code version in Team forge
• Created UNIX Shell scripts for running data through secure pipes in case of sensitive data transfer from one platform to another without landing the data on disk.
• Created Plsql procedures for greenplum loads and bteq, tpt scripts for Teradata loads.
• Perform Code reviews on offshore development activities and involve in implementation activities once testing is complete.
• Working knowledge in CA7 scheduler for deploying and setting up batch jobs in development region.
• Providing support in DEV, QA and PROD environments.

Environment: IBM Info sphere Datastage 8.x,9.x, Oracle 11g, Mainframe, DB2, Teradata, MS Visio, ASCII, Flat files, UNIX, NFS shared services, Pgadmin, Plsql, SAPHANA, Sql Assistant, Sql Developer, MS Word/Excel

Confidential, Bentonville, Arkansas

Sr ETL Developer/Onsite Lead

Responsibilities:

• Data Warehouse related Customer Service Requests (CSR) within a production life cycle support environment, including release planning, status reporting, risk and issue tracking, and solution and deliverable quality assurance.
• Involving in requirements gathering, analysis, design, development, and testing and deployment activities for each Data Warehouse or ETL enhancement.
• Collaborates with the EDW team and stakeholders to ensure expectations are managed and ensure requirements are met.
• Work closely with the EDW project team members and stakeholders to assist in defining interface requirements as well as analytical reporting requirements.
• Transition functional knowledge to offshore to help deliver the development on schedule. Conduct Onsite/offshore stand up meetings to get daily updates on development progress.
• Provide detailed estimates on the design received and getting resources allocated to fulfill the delivery request.
• Developing jobs for migration of data from ETL online tool to IBM Datastage 8.5 and 9.1.
• Schedule for running the jobs, testing and debugging its components and monitoring the resulting executable versions.
• Testing the code developed, running test cases in HP ALM and tracking bug fixes and code version in Team forge
• Created UNIX Shell scripts for running data through secure pipes in case of sensitive data transfer from one platform to another without landing the data on disk.
• Created Psql procedures for greenplum loads and bteq, tpt scripts for Teradata loads.
• Perform Code reviews on offshore development activities and involve in implementation activities once testing is complete.
• Working knowledge in CA7 scheduler for deploying and setting up batch jobs in development region.
• Providing support in DEV, QA and PROD environments.

Environment: IBM Info sphere Datastage 8.x,9.x, Oracle 11g, Mainframe, DB2, Teradata, MS Visio, ASCII, Flat files, UNIX, NFS shared services, Pgadmin, Plsql, SAPHANA, Sql Assistant, Sql Developer, MS Word/Excel

Confidential, Troy, MI

ETL Developer/Tester

Responsibilities:

• Interacted with Business Users and Managers in gathering business requirements.
• Prepared documents for every phase of the project meeting the standards of GM and uploaded all the documents in configuration management tool (Clear case) phase wise.
• Calculated the capacity requirements for this project.
• Used Datastage Designer, Director, Manager and Administrator to develop Parallel, Server and Sequence Jobs as per business rules.
• Developing and modifying changes in jobs according to the business logic. Fixing warnings
• Creating Environment variables, Job Parameters.
• Creating Re-Process logic for any Failed jobs.
• Coding & Debugging, Sorting out their time-to-time technical problems.
• Analyze the types of business tools and transformations to be applied.
• Tuned performance of Data Stage Jobs for large data files and Tables by Creating Indexes, increasing scratch space, configuring multi-Nodes.
• Involved in writing the Unit Test Cases using SQL.
• Developed the standard documentation for the Test Plans and Test Summary Sheets.
• Prepared various Test Cases and executed them as per requirements of the application.
• Manual testing of the ECF modules as part of functional testing.
• Developed and executed Test Cases and verified actual results with expected results
• Actively involved in the daily testing status meetings in which defects identified were discussed
• Automated the test scripts as part of string testing, based on the Use-Cases, for GUI, Functional, Data Driven and Regression Testing using Quickest Pro.
• Involved in the creation of various change control forms to promote the code from Dev, QA and to Production.

Environment: IBM Info sphere Datastage 8.5, Oracle 11g, Mainframe, SQL server, Windows, UNIX, MS Visio, ASCII, Flat files, UNIX, Putty, WinSCP, Autosys,MS Word/Excel, HP QC,JIRA,QTP.

Confidential, Beaverton, OR

ETL Developer/Tester

Responsibilities:

• Designed the ETL jobs using IBM Web Sphere Data stage 8.0.1 to Extract, Transform and load the data into Staging and then into Target Database.
• Designed and developed the ETL jobs using Parallel edition, which distributed the incoming data concurrently across all the processors, to achieve the best performance.
• Handled Performance Tuning of Jobs to ensure faster Data Loads
• Created Master controlling sequencer jobs using DataStage Job Sequencer.
• Extensively worked with Shared Containers for Re-using the Business functionality.
• Extensively developed and deployed UNIX Shell scripts as wrappers that provide values to DataStage jobs during runtime.
• Created Job Parameters and Environment variables to run the same job for different sources and targets.
• Used Director to monitor jobs, run and validating its components.
• Involved in the Performance Tuning of the DataStage jobs using different partition methodologies and node configurations of the environment variable file, designing and editing configurations, increasing the reading as well as the writing speed while fetching or loading data to files or databases.
• Provided data models and dataflow (extract, transform and load analysis) of the data marts and feeder/target systems in the aggregation effort.
• Tested the navigational flow of the portal.
• Performed Cross browser testing on different browsers.
• Fully involved in backend integration database testing by writing and executing SQL queries to ensure data integrity and data consistency. Extensive backend testing, on the Database Server and viewing the data in TOAD.
• Developed User Acceptance Test plans and executed Test cases after bug fixes for each build for UAT.
• Interact d with the application developers to fix the bugs that were reported against the application.

Environment: IBM Web sphere DataStage 8.1, Windows, UNIX, IBM AIX 5.2, Teradata, SQL server 2005, Flat files, TOAD, Putty, Win SCP, Autosys HP QC 10, MS Word/Excel, TOAD