Post Job Free

Resume

Sign in

Oracle Functional Business Analyst/Quality Assurance

Location:
Wyomissing, PA, 19610
Salary:
negotiable
Posted:
February 16, 2011

Contact this candidate

Resume:

RAKESH TEKKAM

*** ******** *****, **********, ** 19610

717-***-****

qpvbti@r.postjobfree.com

ORACLE FUNCTIONAL BUSINESS ANALYST | PERFORMANCE TEST ENGINEER (QUALITY ASSURANCE)

PROFILE

Analytical, enthusiastic and successful professional with over 7 years extensive and progressive background in ERP business solutions and Quality Assurance using HP Quality Center and LoadRunner. Exhibit over 5 years significant skills and expertise implementing Oracle E-Business Suite applications. Demonstrate results-driven performance in environments where functional responsibilities are aligned to business strategies. Proven ability to configure and empower high-performance IT organizations around the needs of the business. Thrive in operating and maintaining technology systems, with reliable management information tools specific to company’s business and its markets. Exemplify unparalleled ability in the implementation and management of diverse programs concurrently.

CORE COMPETENCIES

- Quality Assurance

- Continuous Process Improvement

- Strategic Planning and Goal Setting

- Outstanding Customer Relations

- Oracle EBS Business Management

- Project Implementation and Administration

- Problem Resolution and Change Management

- Business Development

- Business Process Administration

- Strategic Operational Technology Planning

CAREER HIGHLIGHTS

- Interviewed key business users and stakeholders to document and analyze business requirements and data/workflows, using Oracle AIM methodology as well as defined the scope and timeline

- Effectively designed and deployed a custom inventory conversion process that integrated an electronic publishing content management solution with Oracle Inventory

- Expertly designed and implemented freeware database tools for an International Project Management Software Company that helped generate a Q4 revenue of $22 million in Service Contracts

- Played an integral role in leading the efforts of performance testing an architectural transition from 2-tier to 3-tier to facilitate a capacity of 5000 business users for a leading global professional services organization

- Successfully authored training material for Oracle modules specific to clients business as well as led various training sessions for business users at client locations

TECHNICAL SKILLS

- Oracle Inventory

- Oracle iStore

- Oracle Order Management

- Oracle Bills of Material

- Oracle Service Contracts

- Oracle Purchasing

- Oracle Configurator

- Oracle Discoverer

- Oracle Install Base

- Oracle Accounts Receivables

- Oracle Accounts Payables

- Oracle General Ledger

- User Productivity Kit

- HP - Quality Center, LoadRunner

- PL/SQL

- Data Conversion Tools – Dataload Pro

- Salesforce.com

- SAP R/3

PROFESSIONAL EXPERIENCE

SUNGARD AVAILABILITY SERVICES

BUSINESS ANALYST ~ WAYNE, PA MAR 2009–JAN 2011

Served effectively as the primary contact for Oracle Order Management and Oracle Install Base modules during the upgrade of Oracle ERP from Release 11.5.9 to Release 12. Conducted gathering of requirements for functionality development and new requirements from users, organized activities between development and QA to ensure compliance with project timelines.

- Expertly granted production support across Sales Online, Oracle Order Management, Oracle Install Base, Oracle Discoverer and Custom Billing application.

- Conducted root cause analysis of issues and worked with track lead and development to provide fixes

- Documented requirements and functional enhancement using RD-50 and MD-50 respectively

- Accurately created test cases and conduct unit, integration and user acceptance testing

- Efficiently used Quality Center for bug reporting and defect tracking

- Effectively designed and deployed business reports using Oracle Discoverer

- Actively participated in requirement gathering from business users to integrate Salesforce and Oracle EBS

- Effectively conducted user acceptance, unit, integration, usability, and regression testing between the Oracle application and Salesforce as well generate and grant support to SRs all the way through issue resolution

- Ensured identification of software problems, accurately wrote easy-to-follow bug reports and log them into bug tracking database; monitored the development and verified fixes

Environment: Oracle E-Business Suite R12, Oracle Install Base, Order Management, Oracle Sales Online, Oracle Discoverer, Sales Store, Oracle Incentive Compensation, Salesforce

BIZTECH (ORACLE CERTIFIED PARTNER CONSULTING FIRM)

LEAD SUPPLY CHAIN BUSINESS ANALYST ~ CONSHOHOCKEN, PA JUN 2008–MAR 2009

Client: ASTM International

Effectively implemented 2 Operating Units with respective Inventory Organizations which automated child record assignments, attribute population, and item category assignments.

- Directed discovery sessions with client in the areas of operations and requirements

- Documented requirements (RD-50) and prepared application setup document (BR100) for Inventory, Bill of Materials Order Management and Service Contracts modules

- Designed and deployed a custom Inventory conversion process that integrates an electronic publishing content management solution with Oracle Inventory

- Defined and implemented Item Status, Item Attribute Control, Item DFF, Item templates, Subinventory, Item Categories, Shipping Network, UOM Conversion, Freight and Shipping

- Maintained system wide Profile Options, custom Responsibilities and User Menus

- Creatively developed Dataload templates to load data during set up activities

- Set up Order Management to reflect the inventory organization, Price Lists, Bills of Material, Advanced Pricing, Telesales and Service Contracts, Accounts Receivable, Accounts Payable and General Ledger

- Ensured validation of set ups through executing end-to-end unit testing by using dynamic data

- Efficiently conducted CRP sessions to ensure validation of required business processes and expected output. Organized and prepared training documentation for each CRP scenario and trained business users.

Environment: Oracle Applications 11.5.10.2, Oracle Inventory, Bills of Material, Order Management, Advanced Pricing, Service Contracts, Accounts Receivables, Accounts Payable, General Ledger, SQL

SUPPLY CHAIN BUSINESS ANALYST ~ BALA CYNWYD, PA JAN 2008–DEC 2008

Client: Primavera Systems

Implementation of Oracle E-Business suite modules: Oracle Inventory, Order Management, Install Base, Inventory, Advanced Pricing, BOM, Service Contracts, Shipping Execution, Service Fulfillment Manager, System Administration, i-Store, CRM foundation and HRMS

- Implemented and identified improvements to the existing interfaces and processes

- Reworked Inventory and BOM to ensure they are effectively tracked in Oracle Install Base

- Efficiently organized test plan and scenarios for functionality testing and conducted business end-to-end manual testing

- Granted exceptional assistance to the OM Team in conducting daily activities utilizing Service Contracts

- Proactively facilitated the IT team in renewal and consolidation of Service Contracts data on a monthly basis to generate renewal letters

- Functioned effectively in improving the client’s order processing ability by 70% through implementing database tools, which successfully led to a Q4 revenue realization of over $22 million in Service Contracts

- Accurately documented defects and communicated issues during daily Scrum meetings

- Effectively resolved end-user issues and questions for Service Contracts, OM, and IB

- Professionally conducted end-user training for Service Contracts, Order Management, and Install Base

Environment: Oracle Applications 11.5.10.2, Order Management, Shipping, Inventory, Install Base, Service Contracts, Bills of Material, SQL, Configurator

ORACLE BUSINESS INTELLIGENCE ANALYST ~ PAOLI, PA JUN 2007–DEC 2007

Client: Ametek

Demonstrated expertise in designing and developing custom reports using Oracle Business Intelligence. Effectively worked on Answers to develop and establish interactive dashboards with drill-down capabilities

- Ensured management of the web catalog along with the configuration of analytic requests, dashboard prompts, and various KPIs. Validated the entire data displayed on reports against the database tables.

- Instrumental in the walkthroughs of the data models, ETL specifications, identification of dimensional attributes and Star Schema to complete requirements

- Organized and prepared row-level security on specific reports of the dashboard along with the security access to all users and groups within the BI repository and at the UI level

- Successfully directed CRP sessions in training end users on utilizing the design of personalized reports

Environment: Oracle BIEE 10.1.3.3.1, Oracle BI Apps 7.9.3, Informatica 7.1.4, Oracle Database 10g

LEAD FUNCTIONAL TEST ENGINEER ~ COLLEGEVILLE, PA FEB 2007–SEP 2007

Client: Accellent

Functionality Testing for Oracle HR, FA, AP, AR and GL modules

- Conducted development of the test plan strategy, test cases, and scenarios. Ensured validation of the entire functionality through implementing black-box testing along with the communication of functionality issues with the project team for fixes.

- Validated all fixes through conducting regression tests

- Updated Oracle scripts to reflect any changes during the pre-test process and accurately authored training documentation for end-user training

- Efficiently developed Oracle scripts for the implemented modules in an Oracle standard format

Environment: Oracle 11.5.10.2, Oracle Human Resources, Enterprise Asset Management, Fixed Assets, GL

SUPPLY CHAIN BUSINESS ANALYST ~ WESTPORT, CT JAN 2007–JUL 2007

Client: HJ Baker

Provided exceptional assistance in implementing a Custom Freight Solution

- Accurately documented requirements through utilizing Oracles AIM standard methodology

- Executed examinations through the use of dynamic test data to ensure validity of the desired functionality

- Functioned effectively in directing teams to investigate and fix system bugs

- Efficiently created system test scripts for diverse test scenarios that covered all facets of project functionality

Environment: Oracle 11.5.10.2, Oracle Inventory, OM, AR, AP, Purchasing, SQL

SUPPLY CHAIN BUSINESS ANALYST ~ HORSHAM, PA NOV 2006–MAR 2007

Client: Optium

Implementation of Oracle E-Business Suite to manage inter-company orders processed across multiple sets of books and currencies

- Actively attended discovery sessions and accurately documented requirements using Oracle AIM documentation

- Conducted conception of inventory items, BOM, price lists, and OM related to the new organization

- Set up the Inventory Organization: Item Status, Item Attribute Control, Item DFF, Item templates, Subinventory, Item Categories, Shipping Network, UOM Conversion, Freight and Shipping

- Implemented Oracle Purchasing along with the setting up of the system to distinguish the new Operating Unit

- Performed testing which included creation of a requisition, POs, and 3-way matching as well as examined the period end closing of purchasing to reflect accruals and reconciling the same within GL

- Created CRP test scripts and conducted CRP sessions to business stake holders

Environment: Oracle Applications 11.5.10.2, Purchasing, OM, Inventory, BOM, GL, AP, AR

LEAD QUALITY ASSURANCE | PERFORMANCE TEST ENGINEER ~ PHILADELPHIA, PA MAR 2006–OCT 2006

Client: Towers Perrin

Phase 1: Oracle - Financials Reporting Management (FRM) Upgrade

Customized and validated Legacy Applications Regression Testing of FA, AP, GL, and System Administration Oracle modules.

- Accurately documented defects and issues faced within the test instance.

- Conducted recording of business processes using QTP for purposes of Regression Testing

- Effectively generated test plan and regression flows within Quality Center

- Ensured tracking and maintaining of QTP scripts using Quality Center

- Granted training to client personnel in using QTP to run recorded scripts

- Efficiently used Quality Center for bug reporting and defect tracking

- Demonstrated exceptional skills in directing weekly meetings with key business users and executives

Phase 2: Performance Testing

Performance Testing of AR, FA, PA, AP, GL & OTL modules in Oracle for a 3-tier architecture to incorporate 5000 users

- Arranged schedules and led status meetings to ensure clear communication with stakeholders

- Performed black-box testing on the entire business scenarios and concentrate on any detected issues

- Set up the QA test lab, configured LoadRunner software, load injectors, Network delay monitors, Oracle database monitors for measurement

- Developed and enhanced Vuser scripts to simulate the critical business transactions. Enhancements included parameterization, correlation, coding, pacing and iterations

- Developed scenarios, monitored errors, failed scripts, documented and addressed these bugs with the team

- Analyzed stress test results, monitored Server and Database response times, CPU utilization, Network Delay and correlated the results with base line standards

- Ensured maintenance on all test scripts through utilizing Quality Center

- Conducted accurate consolidation and documentation of the performance test along with preparing the final report after test cycles, addressed various bottlenecks, and suggested implementation changes for performance improvements

Environment: Oracle Applications 11.5.10.2, Purchasing, AR, AP, GL, FA. OTL, Workflows, Quality Center, LoadRunner, QTP

IN-VENTURE SOFT, INC.

PERFORMANCE TEST ENGINEER ~ CAMDEN, NJ DEC 2005–MAR 2006

Client: Campbell Soup

Performance tested a multi–module high volume SAP implementation (SD, FI, CO, MM) measured by transaction, reporting and printing volumes

- Created testing strategies–Test Scenarios, Test Cases, Test Script and best practices to be followed

- Set up the QA test lab, configuration of Network delay, SAP-CCMS, Oracle and Unix OS monitors for measurement

- Developed Vuser scripts to simulate critical business transactions with eEnhancements including parameterization, correlation, coding, pacing and iterations

- Conducted accurate consolidation and documentation of the performance test along with preparing the final report after test cycles, addressed various bottlenecks, and suggested implementation changes for performance improvements

Environment: LoadRunner 7.6, Test Director 8.0, SAP R3, SQL, AIX 5.3 with R/3 Enterprise 4.7, Oracle 9.2.0.6 and IBM P5, P4 Servers with HACMP Clusters

PERFORMANCE TEST ENGINEER ~ NEW YORK, NY FEB 2005–NOV 2005

Client: InterPublic Group

Performance Test of high-volume implementation for the following SAP R/3 modules: FI, SD, MM, PA, HR and CO

- Tested various business modules: FI, SD, MM, PA, HR and CO of SAP R/3 to verify the functionality of various interfaces

- Manually tested business processes. Conducted negative testing. Validated the test environment

- Created and documented Test Plans, Test Cases, Test Scripts and procedures to be followed as Test Steps

- Installed and configured of performance test environment including LR controller, load injector and stress test master client in SAP R/3

- Recorded, parameterized and enhanced VUser scripts to simulate critical business transactions

- Gathered Stress Test results and authored reports to indicate bottlenecks within the system as well as provide recommendations for improvement

Environment: SAP R/3, Windows Server 2003, LoadRunner 7.5/ 8.0, BW 3.0B/3.5.,TestDirector 7.6, QTP 8.0

SOFTWARE TEST ENGINEER ~ SPRING HILL, TN SEP 2003–OCT 2004

Client: Saturn Manufacturing

Inventory Management System for was tested for Functional, Regression and Integration Testing. The associated modules- Vendor Management, Vendor Evaluation, Purchase Order, Warehouse, Material handling were tested to verify and validate inter-module data consistency and updating of the database

- Setup the environment for testing.Analyzed user requirement document and developed test plans

- Functionality and system testing was initially done manually using TestDirector for compatibility of using multiple browsers. Conducted Functional, Interface and Regression Testing using WinRunner

- Customized WinRunner Scripts that were already developed to make them robust and repeatable

- Generated User defined functions to enhance the maintainability of the test scripts using WinRunner

- Maintained the WinRunner test environment, script version control, GUI maps, UI testing, regression testing, identified bugs and assisted development to resolve issues

- Investigated software bugs and categorized based on severity, interacted with developers to resolve technical issues

Environment: Oracle 8i, Winrunner, TestDirector 6.0

PERFORMANCE TEST ENGINEER ~ PRINCETON, NJ JUN 2002–JUL 2003

Client: Bristol Myers Squibb

Performance Test of high-volume implementation for SAP R/3 modules

- Identified mission critical business operational profiles and transactions. Gathered acceptable benchmark numbers for the environment reflecting the production work load of the system

- Set up the QA test lab, configuration of Network delay, SAP-CCMS, Oracle and Unix OS monitors for measurement

- Executed stress test scenarios, monitored and captured stress test results, analyzed stress test results and suggested implementation changes for performance improvements.

Environment: Mercury- Test Director, WinRunner, MS Office, HTML, SAP R3, MS Office

EDUCATION

Master’s in Industrial Technology, Bowling Green State University, OH ~ 2002

Bachelor of Science in Mechanical Engineering, Bangalore University, India ~ 1998



Contact this candidate