Oracle Quality Assurance
Resume:
Satish Goli Kumar
Houston, TX *****
Phone #: 917-***-**** (Central Time Zone)
E-mail: ***************@*****.***
Blog: http://oracleR12financials.blogspot.com/
ORACLE FINANCIALS FUNCTIONAL ANALYST
___________________________________________________________________________
EXPERIENCE SUMMARY
* 8+ years experience as an IT Consultant in US
* 7+ years experience with Oracle in Procure to Pay (P2P) modules.
* 6+ years experience with Oracle E-Business Suite/Applications -
Performing functional and technical work mainly with the modules of
Oracle Financials for Enterprise Resource Planning (ERP)
* 3 Full Life Cycle implementations completed - completed three (3) full
lifecycle Implementations of Financial Modules (out of which one (1)
was Release 12(R12) and two (2) were 11i implementation projects.
* 1 (one) upgrade project completed - Completed one (1) upgrade project
from 11.5.5. to 11.5.9.
* Experience in using Oracle AIM (Application Implementation
Methodology) of project implementation methodologies particularly
Gather Requirements (RD.50), Application Setup Documents (BR.100),
deliverables and Test Cases (TE.40) or AP, AR, iExpenses.
* Started working with Oracle as a developer; finally transitioned to
working a functional consultant
* Functional responsibilities: requirement gathering, functional gap
analysis, application design, configuration, module setup, test script
generation, writing training guides, training end users, and
production support
* Technical Attributes: requirement gathering, development and testing
of the extensions to the Oracle Applications product based on customer
specifications and trouble shoot production issues.
* Easy adaptability to new technologies and new system environments.
* Excellent communications, good performance and experience working
under pressure.
SKILLS SUMMARY
* Oracle Application Modules: AP, AR, iExpenses, CE, GL, PO, FA,
Projects, iProcurement and HR
* Oracle Application Releases: R12, 11.5.10 and 11.5.9
* Tools: Oracle Workflow, Oracle Approval
Management, Oracle Reports, Oracle
Discoverer, Microsoft Office Applications, i.e., Word, Excel,
Powerpoint, Visio, Microsoft Project
* Languages: SQL, PL/SQL, Java C/C++, UNIX, HTML and Java
Script
* Third Party Tools: Captiva, Telware, Compeat, Extensity and
Ceridian
* Methodologies & Documents: Oracle's Applications Implementation
Methodology (AIM), Oracle documents include
RD.050, BR.030, BR.100, MD.050, TE.040 and UAT
ORACLE APPS SKILLS AND TOOLS
* Study of Current Business Processes, Future Business Flow and
identification of GAP/Workaround
* Business Requirements Mapping for AP, AR, CE and GL
* Setup of AP, AR, CE, FA and iExpenses
* Data Extraction from Legacy systems and Open Interfaces
* Testing modules', Test Scripts (TE040), Conference Room Pilots (CRPs),
User Acceptance Test (UAT)
* Log, view, access, monitor, follow up and close Service Requests (SR)
* Customizations and client extension
ORACLE APPS PROJECT EXPERIENCE
Cardinal Health April 11 - Present
Houston, TX
Project: R12 Oracle Financials Functional Support
Role: R12 Oracle Financial Functional Production Support Analyst
o Perform system troubleshooting of the production support environment
for Oracle Financials Modules, AP, AR, iExpenses, FA and GL
o Track, document and solve day-to-day support issues in an effectively
and a timely manner
o Assist users in solving both functional and system issues with agreed-
to service level agreements (SLAs)
o Act as an interface between the Oracle development team and the end
users.
o Develop recommendations for business streamlining and efficiencies
o Provide end-user instruction, training and support to resolve
application issues
o Manage Oracle Service Requests (SR's) to resolve issues effectively
o Debug business processes that conform to current environment
o Plan, design, develop and deploy new applications in collaboration
with key stakeholders
o Perform integrated quality assurance testing on system changes
o Use TOAD to analyze the underlying data in the tables
o Coordinate with production control and operational counterparts
including DBAs, Operations and Tech Support
o Ensure that Oracle Applications meets business requirements and
goals, fulfills user requirements, and identifies and resolves
systems issues.
o Ensure that any Oracle integration into other systems meets
functional requirements, system compliance, interface
specifications and is in direct correlation with overall IT
strategy.
o Liaise with network administrators and software engineers to
assist with design specifications, program logic, and data
conversions.
o Interacted with external and internal auditors on Oracle system-
level controls.
Broadway Across America (BAA) July 08 - March 11
Houston, TX
Project: R12 E-Business Suite Implementation
Role: EBS Implementation and Post-go live support Analyst
Responsibilities:
o Team member of full life-cycle implementation of Release 12 E-
Business Suite involving Financials modules AP, AR, iExpenses, CM,
Fixed Assets, and GL.
o Post go-live support in AP, AR and iExpenses.
o Worked on core setups, interface configurations, workflow
documentation, requirement definition, and fit/gap analysis.
o Developed, modified and Executed Application Setup Documents
(BR.100s) for AP, AR, FA and iExpenses.
o Fully responsible Developing, modifying and Executing Test Scripts
(TE.040) for AP, AR, FA, iExpenses, and GL
o Fully responsible for delivery for data extraction.
o Fully responsible for Third-Party tool integration..
o Collaborated with analysts, designers, and system owners in the
testing of Oracle software programs and applications.
o Extensive use of TOAD to test code, write queries and trouble shoot
issues.
o Providing end-user support and training of AP, AR, GL, FA, CE and
iExpenses.
o Provide on-going training and post-production support for all
deployed modules/locations.
o Responsible for troubleshooting and resolving issues, liaising with
end user, technical resources, and DBAs.
o Ensure that any Oracle integration into other systems meets
functional requirements, system compliance, interface
specifications and is in direct correlation with overall IT
strategy.
o Provide direction for the application team in support of Oracle
operations.
o Evaluate proposals in order to identify potential problem areas,
and make the appropriate recommendation.
o Modify/recreate already existing Discoverer Reports based on the
user requirements.
o Logged, viewed, accessed, monitored, followed up, and closed
Service Requests (SR) online - Oracle Meta Link.
American Tire Distributors (ATD) January 08 - June 08
Charlotte, NC
Project: R11i Financials Support
Role: Financials Support Analyst
Responsibilities:
o Production support in core financials, i.e., AP, AR, CE, PO, Oracle
Ecommerce Gateway (EDI),Pricing and GL
o Troubleshoot/Analyzed reported system issues to provide quality
production support for the Live Oracle Application System.
o Responded to critical production issues that need immediate
turnaround.
o Monitored, measured, and reported on application support group
performance and customer satisfaction.
o Worked with business users to understand reported issues and
provide relevant solution through technical changes or workarounds.
o Extensively used TOAD to test code, write queries and trouble shoot
production support issues.
o Modified/recreated already existing Discoverer Reports based on the
user requirements.
o Liaised with DBAs, as and when required
o Managed concurrent processes and reports
o Created/modified functional designs to address production support
issues.
o Performed comprehensive testing to test the technical and
configuration changes needed to address Oracle production support
issues.
o Logged, viewed, accessed, monitored, followed up, and closed
Service Requests (SR) online - Oracle Meta Link.
o Researched and communicated to team lead newest functionality
available within Oracle Applications.
o Managed users/roles and responsibilities using Oracle SYSADMIN
utilities.
o Identified and test application patches prior to promotion to
production.
o Extensively used TOAD to test code, write queries and trouble shoot
production support issues.
o Ensured that Oracle Applications meets business requirements and
goals, fulfills user requirements, and identifies and resolves
systems issues.
o Ensured that any Oracle integration into other systems meets
functional requirements, system compliance, interface
specifications and is in direct correlation with overall IT
strategy.
o Liaised with network administrators and software engineers to
assist with design specifications, program logic, and data
conversions.
o Interacted with external and internal auditors on Oracle system-
level controls.
o Provided documentation tailored to company needs.
Sirius Satellite Radio March 06 - January 08
New York, New York
Project: R11i EBS Implementation - Financial Applications
Role: Oracle Financials Functional Analyst
Responsibilities
o Team member of implementation of Release 11.5.9 involving
Financials modules AP, iExpenses, iProcurement, PO, HR, FA and GL
o Developed, modified and Executed Test Scripts for AP, iExpenses,
iProcurement, PO, HR, FA and GL.
o Developed, modified and Executed Application Setup Documents
(BR.100s) for AP, iExpenses, iProcurement, PO, HR, FA, and GL..
o Developed System Test Scripts TE.040 for AP, iExpenses,
iProcurement, PO, FA and GL
o Conducted User Acceptance Testing (UAT) sessions with Business
users, Financial Users and Purchasing Users.
o Conducted extensive testing of AP, iExpenses, iProcurement, PO, HR,
CE, FA and GL.
o Extensively used TOAD to test code, write queries and trouble shoot
production support issues.
o Modified/recreated already existing Discoverer Reports based on the
user requirements.
o Core setup, interface configuration, workflow documentation,
requirement definition and fit/gap analysis
o Assigned user responsibilities, menu structures and security
profiles using SYSADMIN.
o Collaborated with analysts, designers, and system owners in the
testing of Oracle software programs and applications.
o Researched and communicated to team functionality availability
within oracle
o Provided post-go-live support in AP, iExpenses, iProcurement,
Purchasing, Human Resource, FA and GL: User/responsibility
maintenance, managing concurrent processes and reports, and day-to-
day trouble shooting. Researching and communicating to team newest
functionality available within Oracle Applications.
o Managed users/roles and responsibilities using Oracle SYSADMIN
utilities.
o Was responsible for troubleshooting and resolving technical Oracle
applications issues, liaising with end user functional resources
and Oracle ERP DBAs, as and when required
o Monitored, measured, and reported on application support group
performance and customer satisfaction.
o Logged, viewed, accessed, monitored, followed up, and closed
Service Requests (SR) online - Oracle Meta Link.
o Data migration from legacy systems - ADI and Open Interfaces.
o Acted as a Primary support for Financial modules and Self service
applications.
o Identified and tested application patches prior to promotion to
production.
o Ensured that Oracle Applications meets business requirements and
goals, fulfills user requirements, and identifies and resolves
systems issues.
o Ensured that any Oracle integration into other systems meets
functional requirements, system compliance, interface
specifications and is in direct correlation with overall IT
strategy.
o Liaised with network administrators and software engineers to
assist with design specifications, program logic, and data
conversions.
o Interacted with external and internal auditors on Oracle system-
level controls. Provided documentation tailored to company needs.
Oracle Business Analyst January 05 - February 06
NYC School Construction Authority
Log Island City, NY
Project: Upgrade from 11.5.3 to 11.5.9 Oracle Apps Project
Role: Oracle Business Analyst
Responsibilities:
o Involved in Oracle Application upgrade process from 11.5.3 to
11.5.9. Mainly dealt with business areas, Financials modules (AP,
FA, CE, GL and PO).
o Wrote specs for these departments, made recommendations on business
process and working with technical group on upgrading/
reconfiguring within all aspects of Oracle Financials.
o Involved in Unit Testing, Testing Customization and Integration
testing.
o Conducted User Acceptance Testing (UAT) sessions with Business
users, Financial Users and Purchasing Users.
o Created setup documents (BR.100).
o Developed System Test Scripts TE.040 for AP, AR, Cash Management
and PO
o Work with DBA, Assisted with tar resolution, patching and testing.
Participated in evaluating, documenting, implementing or applying
of system upgrades, patches and implementations
o Develop, coordinate, and implement plans to test business and
functional processes and quality assurance testing.
o Documented standards and procedures, Developed product
documentation and training materials.
o Organized and worked with the business /user team through the
testing process and provide reports on testing progress.
o Analyzed and documented test results, track issues and communicate
to
IT and the business /user team.
o Troubleshoot questions/problems from the user community with Oracle
Application issues.
o Extensively used TOAD to test code, write queries and resolve
production support issues
o Modified/recreated already existing Discoverer Reports based on the
user requirements.
o Other responsibilities included supporting users, diagnosing and
resolving problems, implementing solutions and documenting business
processes.
OSI PHARMACEUTICALS November 03 - December 04
Melville, NY
Project: 11.5.9 Oracle Applications Implementation
Role: Business Analyst
Responsibilities:
o Team member of implementation team for Release 11.5.9 involving AP,
AR, iExpenses, iProcurement, FA, CE, Projects, Time & Labor and GL.
o Developed, modified and Executed Test Scripts (TE.040) for AP, AR,
iExpenses, iProcurement, FA, CE, Projects, Time & Labor and GL.
o Developed, modified and Executed Application Setup Documents
(BR.100s) AP, AR, iExpenses, iProcurement, FA, CE, Projects, Time &
Labor and GL
o Conducted User Acceptance Testing (UAT) sessions with Business
users, Financial Users and Purchasing Users.
o Provided documentation tailored to company needs.
o Core setup, interface configuration, workflow documentation,
requirement definition and fit/gap analysis
o Assigned user responsibilities, menu structures and security
profiles using SYSADMIN.
o Collaborated with analysts, designers, and system owners in the
testing of Oracle software programs and applications.
o Researched and communicated to team functionality availability
within oracle
o Provided post-go-live support in AP, AR, iExpenses, iProcurement,
FA, CE, Projects, Time & Labor and GL: User/responsibility
maintenance, managing concurrent processes and reports, and day-to-
day troubleshooting.Researching and communicating to team newest
functionality available within Oracle Applications.
o Managed users/roles and responsibilities using Oracle SYSADMIN
utilities.
o Was responsible for troubleshooting and resolving technical Oracle
applications issues, liaising with end user functional resources
and Oracle ERP DBAs, as and when required..
o Monitored, measured, and reported on application support group
performance and customer satisfaction.
o Worked with Oracle resources to escalate and resolve company-
initiated Service Request (SRs)).
o Acted as a Primary support for Financial modules and Self service
applications.
o Identified and tested application patches prior to promotion to
production.
o Ensured that Oracle Applications meets business requirements and
goals, fulfills user requirements, and identifies and resolves
systems issues.
o Ensured that any Oracle integration into other systems meets
functional requirements, system compliance, interface
specifications and is in direct correlation with overall IT
strategy.
o Liaised with network administrators and software engineers to
assist with design specifications, program logic, and data
conversions. Interaction with external and internal auditors on
Oracle system-level controls.
MOTOROLA April 03 - October 03
Ft. Lauderdale, FL
Project: 11i Oracle Applications Technical Support Analyst
Role: Developer
Responsibilities:
o Translated functional specs and business requirements for technical
groups.
o Understood and communicated complex concepts to functional users.
o Assisted the Business users with refining functional requirements so
that they are clear and concise.
o Ability to translate functional requirements into a functional design
with pseudo code where appropriate.
o Worked with end-users and internal development team to understand
objectives and develop requirements for reports, interfaces and
extensions. Strong understanding of Functional flow of various
processes.
o Responsible for troubleshooting and resolving Oracle applications
issues, liaising with end user and Oracle DBA, as and when needed.
Developed and maintained effective relationships with clients and
cross-functional teams.
o Conducted analysis, design, development, testing, implementation,
training, configuration, security & day to day support of the assigned
business applications aligned to functional area. Managed the
relationship between client base (owners of process) and IT (owners of
tool).
o Design, plan and conduct functional testing. Develop and maintain test
scenarios for end users. Test Plans for all the modules.
o Defined the suppliers, payment terms and relationships between parent
companies and their subsidiaries and merged the duplicate suppliers.
o Assisted in developing, implementing, maintaining policies,
procedures, and training plans for Oracle implementation..
o Designed, planned and conducted functional testing. Developed and
maintained test scenarios for end users. Test Plans for all the
modules.
o Worked on Oracle Applications System Administration responsibility.
o Provided technical assistance by responding to inquiries from end
users and others regarding errors, problems, or questions about
programs.
EDUCATION
o Bachelors Degree - India
o Oracle EBS Certification Training - London, England
o Oracle R12 EBS Financials Training - New York, New York
REFERENCES AVAILABLE UPON REQUEST
Contact this candidate