PROFESSIONAL SUMMARY:

• Highly motivated, solutions - driven software professional with over 7+ years of strong experience in Business Analysis, Programming & Functional knowledge in Data warehouse concepts, ETL Development, Reporting and Testing.
• 6+ years expertise in using Data stage 8.x through 11.x versions, knowledgeable in SAP Data Services and Informatica 9.x ETL tool.
• 12+ months in Report Generation. Worked extensively on Sap BI BEx Analyzer in building Queries using Filters, Variables, Structures, Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions and created aggregates for frequently used queries.
• Experience in writing SQL queries for Extracting data from various source systems and mapping for reporting and Data warehouse purposes.
• Strong experience in analysis, high and low-level < -- Inserted: - -->design, development, Testing and Implementation of critical jobs.
• Can efficiently handle Production Support, Bug fixing, and Bug Finding & Fine-tuning< -- Inserted: - --> processes for improving performance. On-Call support for System Maintenance.
• 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.
• Experience 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.
• Expertise in using defect management tools like Test Director, Quality Center, JIRA and Rational Clear Quest.
• Experience in Production support, fixing environmental issues, for various applications using Data stage as part of data Ingestions/Migrations on DB platforms such as Teradata’s server, Greenplum, Hadoop, Oracle, DB2, SQL Server< -- Inserted: QL -->,Sql Server,Excel.
• Proficient in the entire phases and different kinds of SDLC Methodologies.
• Extensive experience in Agile/Scrum methodology.
• Experience in Designing Business Object Universe, Complex BO reports with SAP Webi Client and HTML.
• Expertise in Job design and execution of ETL process in Datastage 8.5 through 11.x.
• Expertise in developing generic jobs in data stage between similar data platforms and debugging issues during data quality.
• Experience in other ETL tools like SAP Data services, SQL Server < -- Deleted:ql -->< -- Inserted: QL -->SSIS and Informatica 9.x.
• Experience in writing SQL queries< -- Deleted:ql -->< -- Inserted: QL --> and transformation for source extraction and loading to the staging area. < -- Inserted: the -->
• 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< -- Inserted: - --> job set up in Mainframes.
• Provide technical expertise and perform code reviews on offshore deliverables.
• Knowledge in working with automated test cases using Mercury automation tool QTP (Quick Test Professional).
• Using various queries to query SQL, Hive, Distcp, Sql Server MS for sql server, Sql Developer for Oracle, Sql Assistant for Teradata, Pgadmin for Greenplum, SAP Hana, Hadoop, DB2 database systems
• Used Quality Center (QC), FireBug and Test Director for tracking and reporting defect.
• Good experience on BMC Remedy Change management, Incident Management, Problem Management &, Release Management.

TECHNICAL 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, Sap Data services, cobol, Informatica 9.x, SSIS 2012,SSRS,SSAS,SAP BI,PowerBI,Erwin Datamodelling

Requirement Management Tools: Rational RequisitePro, S< -- Deleted:ql -->QL Assistant, < -- Inserted: QL -->Putty, HP ALM, Remedy, pg admin, Crystal, < -- Deleted:, -->< -- Inserted:, -->Sql Developer, Sap Hana Client studio, DB visualizer< -- Deleted:db -->< -- Inserted: DB -->, JIRA, TOAD. leankit, firebug, SQL server management studio, BCP < -- Deleted:,sql -->< -- Inserted:, SQL -->

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

Onsite ETL Developer/SQL Report Writer

Responsibilities:

• Requirement gathering, analysis, design, development, and testing activities for every user story assigned.
• Involved in ETL design and development of objects in SAP Data services.
• Involved in redesigning of procs and objects that were developed using SSIS to SAP Data Services.
• Develop, Test and stage components developed in SAP Data services using SQL, Query, and Target stages.< -- Inserted:, -->
• Design interfaces on data loads. Scope process improvements in case of any issues with data loads.
• Develop ETL migration Jobs from SAP Data Services to datastage11.x version.
• Develop Tables in Dimension and Fact models for EOBI reporting needs.
• Write Complex SQL for reporting needs in SAP BI.
• Call stored procs developed in SQL server in Data< -- Deleted:ql -->< -- Inserted: QL --> services for loading miss call information due to tower issues.
• Improve GUI grand central reports for reporting < -- Deleted:msisdn -->MSDN call information to site engineers.< -- Inserted: MSDN -->
• Define data movement process between the legacy systems to the integration layer implementing data integrity automation, error notification, and automated data< -- Inserted:, --> correction.
• Create Mops for SQL ops to promote objects from Stage and to Production.
• Develop and Execute Test Cases, verify actual results with expected results.
• Actively involved in the daily stand up meetings to discuss changes going to production.

Environment: SAP BODS, Datastage SAP BO, Crystal Reports, Oracle 11g, SQL SERVER 2014, MS Visio, ASCII, Flat files, UNIX, NFS shared services, SQL Developer, MS Word/Exc< -- Inserted: QL -->el, FileZilla, Wiscp, FTP JIRA, POWER BI

Confidential, Bentonville, Arkansas

Sr ETL Developer/Onsite Lead

Responsibilities:

• Data analysis, design, development, testing and deployment activities for each project being migrated to 9.1 and also 11.x
• Work closely with Business stakeholder to understand the reporting needs.
• Design interfaces on data loads. Scope process improvements in case of any issues with data loads.
• Develop facts and dimensions logical models to relate supplier and Walmart divisions to improve sales.
• 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 Data stage 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 Data stage 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.
• As part of the Tester involved in writing Test Cases, Test Scenarios Creation, Test Cases Review.
• Responsible for Test Cases Review and Application Testing.
• Have performed System Testing, Static Testing, Regression Testing and Integration.
• Mentor fewer experience resources in tools like JIRA < -- Deleted:ss -->< -- Inserted: r -->< -- Deleted:l -->< -- Inserted: few -->and BSM remedy for change control process and Incident Management
• Perform Code reviews on offshore development activities and involves in < -- Inserted: s -->implementation activities once testing is complete.

Environment: SAP Webi 4.x, Informatics 9.x, SQL SEVER, MS Visio, ASCII, Flat files, UNIX, NFS shared services, SQL SSMS, SQL Assistant, SQL Developer, MS Word/Exc< -- Inserted: QL -->< -- Inserted: QL -->el, SAP Scheduling, FileZilla, Hp ALM, JIRA

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.
• Write SQL procs for getting item information to different < -- Deleted:sql -->< -- Inserted: SQL -->platforms.
• Developing jobs for migration of data from ETL online tool to IBM data stage 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 SQL procedures< -- Deleted:Plsql -->< -- Inserted: SQL --> for Greenplum loads< -- Deleted:g -->< -- Inserted: G --> and bteq, tpt scripts for Teradata loads.
• Perform Code reviews on offshore development activities and involves in < -- Inserted: s -->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 Infosphere Datastage 8.x,9.x,11.x Oracle 11g, Mainframes, DB2, Teradata, MS Visio, ASCII, Flat files, UNIX, NFS shared services, Pgadmin, Plsql, SAPHANA, S< -- Deleted:ql -->QL Assistant< -- Inserted: QL -->, SQL Developer< -- Deleted:ql -->< -- Inserted: QL -->, MS Word/Excel, SQL server, Hadoop< -- Deleted:ql -->< -- Inserted: QL -->

Confidential, Bentonville, Arkansas

Sr ETL Developer/Onsite Lead

Responsibilities:

• Involved in requirements gathering, analysis, design, development, and testing and deployment activities for each Data Warehouse or ETL enhancement.
• 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< -- Deleted:sql -->< -- Inserted: SQL --> for greenplum loads and Bteq, TPT scripts for Teradata loads.
• Perform Code reviews on offshore development activities and involves in < -- Inserted: s -->implementation activities once testing is complete.
• Working knowledge in CA7 scheduler for deploying and setting up batch jobs in development region.

Environment: IBM Infosphere Data stage 8.x,9.x, Oracle 11g, Mainframe, DB2, Teradata, MS Visio, ASCII, Flat files, UNIX, NFS shared services, S< -- Deleted:ql -->QL Assistant, SQL Developer, MS Word/Exc< -- Deleted:ql -->< -- Inserted: QL -->< -- Inserted: QL -->el

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 Data stage Designer, Director, Manager, and Administrator to develop < -- Inserted:, -->Parallel, Server, and Sequence Jobs< -- Inserted:, --> 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.
• The tuned performance of < -- Inserted: he t -->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 Infosphere Data stage 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

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 Data Stage 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 Data Stage 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 Data Stage 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 Info sphere Data stage 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.