Professional Summary:

Motivated, personable software professional with successful 12+ years of extensive IT experience with 9+ years in quality assurance and 3+ years in client focused project development.

6+ years of experience in Data Centric (ETL)testing that includes end to end testing, Interface, Integration, Migration, System and User Acceptance testing, upgrade testing, unit testing and regression testing. 5 years of experience in ERP (Oracle Applications) oracle apps testing.

1+ years in NICHE skilled test lead on Hadoop platform in more rapid Agile Environment.

Strong experience on multiple domains of Healthcare, Finance, Retail and Investment Banking.

Self-starter, result-oriented individual focused on meeting client’s requirements, design, budget, and schedule requirements.

Extensive knowledge in complex System Integration Testing on Hadoop platform, SAS scripting for QA automation testing. BI / Data Warehousing facts and dimensions, bobj reports, crystal reports and Data Migration.

Strong experience in writing & executing SQL queries and performing the back-end testing, package testing in Oracle and ERP applications.

Experience in working with defect management tools like PVCS Merant Tracker, Quality Center 9.2, and RALLY, ALM and automation tool like Win Runner.

Performed key role in Integration track and in Conversion, Interfaces, Process enhancements and Performance Tuning

Expertise in planning, building & managing different test environments throughout the STLC. Worked on Agile environment, with daily standup meetings.

Proficient in preparing Master Test Plan, Test scenario, Test case, Traceability matrix, defect report, test status report and Test metrics.

Expertise in leading a team and mentor them on best practices both technically and functionally.

Possess sound functional and technical knowledge in Oracle Financials modules (AP, GL & AR, HRMS), Oracle Purchasing and Self Service Application modules such as iProcurement

Good functional knowledge in Oracle Project Accounting (PA) & and Localization of Italy & Germany.

Responsible for bug maintenance and enhancements using PL/SQL packages.

Possess good Exposure to go live activities and post production support.

Skills Summary

Teradata, TOAD, AQT

SAS EG

PUTTY

Subversion(SVN)

Oracle 9i,10g (SQL, PL/SQL)

UNIX Shell Scripting

Oracle Financials modules (AP, GL, AR, CM, PA(Projects)

Quality Centre 9.2 and 11

PVCS

RALLY

Win Runner

Load Runner 9.5

Secure Shell (SSH)-UNIX

Beyond Compare

MS Office Suite

SharePoint

HTML/ XML

CVS

WINSCP

ITSM

Optum (United Health Group), MN Jul’2014 – May’2017

Senior IT Quality Consultant/Lead (ETL/BI Testing)

Description: Project involves claims & member data from various sources into ETL dataware house. Data loaded into tables, are used for analytical purposes.

Environment: SAS EG, Advanced Query Tool(AQT), Teradata, UNIX, PUTTY, RALLY, HP ALM, TWS, Ultra edit, Subversion(SVN), CODEHUB, SharePoint, Beyond Compare, Hadoop, SSH

Responsibilities:

Prepared SAS automation scripting (via SAS EG) for QA validation to validate complex source to target transformations. Validated files to tables, files to files, validated lookup files.

Validated COGNOS Reports. Analyzed production issues and prepared root cause analysis.

Prepared test plan, Test Strategy, effort estimations for new projects.

Attended PI panning and prepared features, User Stories, Estimates, Story points & Risks for each release on AGILE environment.

Table structure/view validation. Production Checkout (financial & Clinical)

Worked on Bigdata platform Hadoop environment in testing pharmacy, lab, member data. Validated Dimensional, Fact tables & MART tables load using sql queries. Performed different data loads of History, GAP & Delta. Profiled data for reconciliation.

Lead the team for Hadoop cluster migration testing project.

Create Test scripts, Test Metrics, Pig scripts, shell scripts and Hive Queries for testing

Prepared risk analysis and mitigation plans. Managed defects and review test results with project team. Execute and Validate the data loaded

Created production monitors with hive scripts to monitor the daily load status.

Validated Slowly Changing Dimensions. Tested huge volume of data.

Best Buy Corporation, Richfield, MN Sep’2010 – Jul’2014

QA Lead

Description: A U.S transnational consumer electronics corporation.

Environment: Netezza, Teradata ETL, ORACLE 9i, Informatica, PVCS, ITSM, SSH, SQL Developer, CVS, WinSCP, RALLY & Business Objects

Responsibilities:

Used Netezza & Teradata for validation. Performed data integrity test & data mapping tests and Statistical Data Analysis of cross functional subject areas. Worked on Agile environment, with daily standup meetings.

Jobs scheduled through Maestro tool(TWS) and data flow in Netezza, validated through Aginity BASE tables. Validated Dimensional, Fact tables & MART tables load using sql queries. Performed different loads of History, GAP & Delta data loads.

Validated Slowly Changing Dimensions. Tested huge volume of data upto 2.3 Trillion.

Worked on testing the integration and migration of various subject areas like ENTERPRISE CUSTOMER, EDW Sales, Offering, Fiscal BestBuy Calendars, Location, Market Analysis, OPT OUT and Customer Identification & Communication preferences.

Validated PII columns and accesses. Validated business objects (bobj) reports & crystal reports.

Co-ordinate with program team for IPT tests and provided timely results to IPT team.

Highlight risk to Business system teams on any critical defects that impacts the project completion

Dun & Bradstreet (D&B), Pennsylvania, USA Jun’2010 – Aug’2010

Module Lead

Description: D&B licenses information on businesses and corporations for use in credit decisions, business-to-business marketing and supply chain management.

Environment: Oracle 9i, 10g Database, TOAD, PVCS, ITSM, Oracle Workflow builder

Responsibilities:

Enhance the ORACLE iProcurement Requisition (PO) workflow to include various levels of approvers by setting AME rules.

Prepared technical design documents for the enhancements on PO requisition workflow linking with AME rules. Review the developed components.

Developed AME rules to meet various criteria and tested the PO Requisition workflow.

Modified setups to suppress the “Repeated approvers “getting notification more than once.

Developed POC for creation of customers, parties, party sites, profiles and contacts using TCA API.

Prepared patch list, SR List. Worked with oracle support team on SR’s and with DBA‘s for applying the patches.

Created RFC’s (Request for Change) in ITSM tool to deploy code into UAT instance and prepared the instance for UAT testing.

Prepared Deployment Playbook & installation docs for deploying into prod instance.

CISCO Corporation, USA May’2009 – May’2010

Senior Software Engineer, Bangalore, India

Description: Bug Maintenance & Enhancements.

Environment: Oracle 9i, 10g Database, TOAD, PVCS, Kintana, SQL*Plus, HP Quality Centre, UNIX

Responsibilities:

Developed a custom wrapper program to submit the standard OP concurrent program in batches.

Developed PL\SQL Package in Oracle projects that triggers email notification to the project managers who haven’t performed the project forecast in the past 15days (notification on bi-monthly basis).

Developed pl/sql package using standard oracle HRMS API’s to update the employment_category and normal_hours in oracle HRMS from HR database (via dblink).

Developed pl/sql script using oracle standard HR API to end job titles in oracle HRMS which are no more is use in oracle.

Developed plsql package to delete/create/update UDA’s (User Defined Attributes) in Oracle Projects (OP) using Oracle standard API. Raised P1 service requests for ORACLE product bugs and closely worked with ORACLE support team. Developed POC’s & generated TKPROF’s to explain oracle about this issue.

Developed a program to update the schedule dates for the template tasks in standard tables using oracle standard API.

Prepared technical design, Analysis & Design doc for the fixes and enhancements.

Support production go-live activities for all monthly releases and prepared IT verification checklists, to confirm the successful deployment of packages to production.

BAE Systems, Adelaide, Australia Jan’2009 – Apr’2009

Senior Software Engineer

Description: British Aerospace’s Migration project. Migrate ORACLE projects and tasks from three various external source systems into oracle through migration/interface.

Environment: Oracle 9i, SQL Developer, Data Loader, Oracle Application Server

Responsibilities:

Gathered requirements for the components directly from users

Prepared technical documents (MD70), installation scripts (MD120) & unit test scripts

Developed pl/sql package to extract oracle projects.

Created mapping to map the external systems with oracle projects

Loaded oracle supplier and supplier sites using data loader

Prepared detailed end-user training documents

State Street Corporation, USA DEC’2007 – DEC2008

Senior Software Engineer, Chennai

Description: State Street Corporation has its financials setup in USA and it was rolled out to Europe. Modules included FA, GL & PO. Oracle P2P cycle was automated from invoice creation till payments.

Projects Executed: P2P Implementation & Europe Track2

Environment: Oracle Database, TOAD 8.0.047, Oracle Apps, Oracle Financials, SQL * Plus, PL/SQL, Windows 2000 & XP

Responsibilities:

Performed SIT for FA Conversion both manually & using ADI. Created assets, gl code combinations and employee updates using Data Loader

Reconciliation of the converted assets & GL code combinations between source system and ORACLE and found the reasons for non-converted assets.

Performance tuned the GL & PO Conversion. Worked on troubleshooting and resolving production issues.

Prepared instance for SIT Testing and tested custom components & Audit Report.

Created Technical, Installation docs & detailed test scripts and performed system testing & application functionality testing for Purchasing and iProcurement.

STATESTREET Corporation, USA OCT’2006 –NOV’2007

Senior Tester, Chennai

Description: STATESTREET financials upgraded from oracle database 9i to 10g and application to 11i.

Projects Executed: Oracle Upgrade Project & E2E Testing

Environment: Oracle 9i, Oracle Applications, TOAD, UNIX, Windows 2000, Windows-XP

Responsibilities:

Analyzed environment issues, set up issues, invalid objects due to the environment upgrade and suitable fix for it.

Tested standard and custom functionalities of State Street Interfaces, Eliminations process and oracle standard functionalities like AP, CM, FA, GL, PO and localization involving Austria and Italy.

Tested various functionalities of GL via ADI and custom functionalities & Interfaces.

Created interface files in XML format to load journals into GL base tables.

Tested interfaces, FSG Reports, Elimination transactions and back dated journals in Oracle GL.

INTUIT Corporation, USA Jan’2006 to Sep’2006

Developer, Chennai

Description: INTUIT is a software company that develops financial and tax preparation software and related services for small businesses, accountants and individuals. Project involved migrating of receipts and Credit Card settlements from legacy system into oracle.

Environment: Oracle 11.5.9, Oracle 9i, Developer 2000, Oracle Financials

Responsibilities:

Developed PL\SQL package & performed unit testing.

Performed peer reviews. Code walk-through, Test plan walk through to the client team.

Prepared Unit Test Cases, technical design, Testing Approach Documents.

Performed Unit Testing and Regression Testing for the customized reports.

Analyzed bug according to the business requirements in oracle order management(OM) module.

Thomson Scientific & Healthcare Market Group, USA Aug-2005 to Dec-2005

Developer, Chennai

Description: Thomson Healthcare & Science provides information solutions to the research and development communities, and scholars worldwide. Project involves migration of all oracle financial modules from legacy system. Financial modules included GL, AP, AR, FA, HR EMP, FND USER and PA.

Environment: Oracle Reports, PL/SQL, TOAD, Oracle Apps &Financials

Responsibilities:

Developed PL/SQL stored procedures in oracle projects (PA) to migrate data from legacy into ORACLE with appropriate validations using API. Migrated existing reports and SQL scripts.

Prepared case study about Thomson project which included the project details, functional flow, conversion scope, conversion process, the sequence of conversion elements, reports customizations and the same document has got uploaded in Knet.

Prepared reusable components for GL Balance Conversion with required validations, PA Budgets Conversion with required validations, Concurrent programs, Driver files and PA Transactions Conversion with required validations.

Prepared review checklists for the review codes done in modules GL, AP, AR, FA, HR EMP, FND USER and PA.

STATE STREET Corporation, USA Sep-2004 to Jul-2005

GL Acceleration Rollout Project, Chennai

Tester

Description: State Street is a global financial system that provides financial infrastructure and services to world's largest investors by their investment strategy. Implementation project involved Oracle GL rollout to many countries.

Environment: Oracle Database, UNIX (Sun Solaris 5), Win Runner 7.6, Windows XP, TOAD 8.0.047, Oracle Apps, Oracle Financials, Oracle Reports 6i, SQL Plus, PL/SQL

Responsibilities:

Performed “AP Testing” using win runner scripts and modified the scripts.

Effectively regression tested and certified the Accounts Payable module in Test, UAT and Production environments. Street sits at the very center of the global financial system. Our role is to s to make the most efficient use of the world’s capital.

Educational Summary

2001-2004 - B.Sc. Mathematics from Holy Cross College, Tiruchirappalli, Tamil Nadu

2004 -2008 - M.S. Software Engineering from BITS PILANI, Rajasthan

Contact this candidate