Rudrama Devi Goli

ac4peo@r.postjobfree.com

+1-585-***-****

Professional Summary

Over 12+ years of extensive experience as Onshore Lead, Oracle Applications Techno Functional Consultant,Technical Lead,Module Lead, Business Analyst and Developer with TATA Consultancy Services Ltd in Implementation, Upgrade, Production support and Customization of Oracle e-Business Suite Applications (R12, 11i)

Rich Expertise in System study, Requirements gathering, Gap analysis, Design, To-Be solution Proposal, Development, Testing, Conversion, Customization, Interfacing, Implementation of business applications using ERP .

Defined technology solutions to solve complex, multidisciplinary business problems with long-term implications

Managed small teams successfully at offshore and at onshore. Worked in client facing roles at Singapore, Webster-US(Xerox).Worked with multiple teams like Testing,Engineering,Release Management and operations.

Worked as a Techno-functional consultant and onsite technical lead for various customers mission critical ERP Platforms

Having excellent domain knowledge of Healthcare and Manufacturing.

Extensive experience in System Study, Requirements gathering, Gap Analysis, Design and Development in various modules of Oracle Applications with major focus General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Cash Management (CM), Collections, Assets,Bill Presentment Architecture(BPA),FSG reporting, Channel Revenue Management,Trading Community Architecture (TCA),Human Resource Management(HRMS) and Service Contracts (OKS) .

Strong knowledge on various modules of Oracle E-Business R12 suite Lease and Finance, HRMS, CRM and SCM.

Technically proficient in RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows), Data Migration, XML Publisher Reports, ADI (Application development Integration),SQL, PL/SQL, SQL*Loader, Forms (10g), Reports (10g), workflows, workflow business events, Shell Scripting. Well versed with performance tuning using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, HINTS and STATSPACK.

Expertise in forms personalization, standard Forms/Reports/workflow customization with ZOOM, designing and implementing AOL and Oracle Alerts,

Fair Knowledge in customizing (personalization. VO extension, CO extension) existing OAF Screens as per business needs.

Experience in integrations with MFT, invoking SOAP/REST services and EBS Integrated SOA Gateway.

Strong Knowledge of Application Implementation Methodology (AIM), Application object Library (AOL) implementation standards, Trading Community Architecture (TCA) and software Development Life Cycle (SDLC).

Well versed with client server environment and tools like SQL*Plus, PL/SQL, SQL*Loader, Toad, Oracle*Forms, Oracle*Reports, Workflow, Discoverer and fair knowledge of JDev.

Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews using Word, Excel, Power Point and other MS office tools.

Expert in developing Solution Design Document (MD050), Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120).Having fair knowledge of Oracle Cloud Platform.

Excellent in writing technical design documents for conversions, extensions, interfaces, and reports. Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).

Proficient in team collaboration, team motivation and leadership. Excel in Quick adaptation and problem solving with good communication skills. Eager to learn new technologies,take new roles & responsibilities and accept new technical challenges .Absolutely capable of working in a fast paced, dynamic, team-oriented environment

Pro-actively identify areas of opportunity and work to finding solutions that meet the business needs of the customer.

Good understanding of latest technologies including Cloud, DevOps, AWS, Azure, Mobile Apps.

Certifications

HL72.3 (health Care standard).

Oracle E-Business Suite 12: Oracle Receivables Essentials.

Oracle E-Business Suite 12: Oracle Payables Essential.

Oracle Financials Cloud General Ledger-2017-Implementation Essentials.

Project management Professional .

Professional Experience

1)Customer & Project : Xerox Corporation – Contract to Cash, Managed printer Services

Location: Webster (US) 2015-Jan till date

Role: Techno – Functional Consultant and Onshore Technical Lead

Responsibilities

Key resource of Service Contracts, Install base, Account Receivables, EB-Tax, Collections, Channel Revenue Management, Assets modules.

Requirement analysis, Solution Design Document (SDD) preparation, design review, planning deliverables, assigning work to team members, Technical Design Document (TDD) preparation

Analyzed the business requirements, proposed To-BE solutions, acquired required approvals from decision team & prepared the System Requirements Document (SRD), Solution Design Document (SDD). Assisted the technical team for timely completion of deliverables

Done POC for Partial and Tax only Credit Memo with Vertex integration, which resulted in highly business satisfaction and reduced efforts in System Requirements gathering, Solution Design, Development and Testing.

Supported performance testing for Contract price escalation, Contracts Extension and proposed process changes, which resulted in better performance and reduced manual intervention.

Built and Customized Service contracts creation,meter read capture, activation, termination, extension,billing and price escalation using AOL, forms, XML publisher reports, Application Development Integration (ADI), PLSQL, integrations with MFT, invoking SOAP/REST and calls to SOA services.

Customized AR Credit Memo Approval Request workflow,roles assignment to the customer contacts and customized creation and application of on account credit memo, full credit memo, partial credit memo, tax only credit memo using AOL, Oracle APIs, workflow, PLSQL and ADI .Personalized Transaction, Receipts forms using OAF Personalization through functional administrator.

Customized coupon creation as part of channel revenue management using AOL and PLSQL

Supported Functional/User/System Integration testing

Prepared and communicated project status, metrics on Defects &Value -adds on weekly basis to the Customer and Higher Management.

2)Customer & Project : Xerox Corporation – ePrintice

Location: Webster (US) 2013-Jan to 2015-Dec

Role: Techno – Functional Consultant and Onshore Technical Lead

Responsibilities

Key resource of Account Receivables, Payables, General Ledger, Cash management and AOL modules.

Designed solution and prepared scripts using PLSQL, UNIX to analyze all custom objects across the platform (Forms, Reports, DB objects, AOL Objects, Shell scripts, Control Files etc) to identify the objects, which are impacted due to COA segments update from 6 to 9, and merging of two different Operating Units in to one.

Analyzed the Impacted objects, proposed To-BE solutions, acquired required approvals from decision/business team & prepared the System Requirements Document (SRD), Solution Design Document (SDD). Assisted the technical team for timely completion of deliverables

Supported Functional/User/System Integration testing

Prepared and communicated project status to the Customer and Higher Management on weekly basis.

3)Customer & Project : Xerox Corporation – DMO R12 Upgrade

Location: Hyderabad (India) 2012-May to 2012-Dec

Role: Techno – Functional Consultant and Offshore Technical Lead

Responsibilities

Key resource of Service Contracts,Install base, Account Receivables, Payables, Payments, General Ledger, Collections, Cash Management, Sub Ledger Accounting (SLA), Assets, TCA and AOL modules.

Analyzed and co–ordinated team to analyze all the custom objects across the platform (Forms, Reports, DB objects, AOL Objects, Shell scripts, Control Files, workflows other application tire objects and DB objects to identify the objects which are impacted due to oracle Apps upgrade from 11i to R12 using built in tool ASSAY.

Analyzed the Impacted objects for existing customizations, proposed To-BE solutions, acquired required approvals from decision/business team & prepared the System Requirements Document (SRD), Solution Design Document (SDD). Assisted the offshore team in understanding the business requirements and proposed solutions.

Coordinated and worked on remediation of all impacted custom components and customized standard objects of R12 finance suite using PLSQL, forms (10g), Reports (10g), XML Publisher, Workflow, OAF and AOL.

Coordinated with onsite team in understanding the requirements and assigned the work to the Team at Offshore related to the new customizations.

Coordinated with offshore development team in developing and configuring custom solutions.

Developed new check formats in English and Spanish as per customer requirements using, XML Publisher, PLSQL and customized Payment Batch processing using Business events,PLSQL and Alerts

Personalized Customer, Supplier OAF screens to validate the address and to display extra fields on the screen, Bank Accounts Screen to display Created User, Last Updated details through Functional Administrator Responsibility.

Developed new FSG reports and customized existing FSG reports.

Analyzed standard oracle issues encountered during System integration testing and proposed patch applications based on metalink notes. Coordinated with oracle team through Oracle SRs to find solutions to the production issues upgrade issues during upgradation and after R12 upgrade.

Supported Functional/User/System Integration testing and postproduction issues.

Proactively proposed Value adds to the existing system that leaded to a new project to the current employer.

Prepared metrics on weekly basis and shared with customer /Supervisor.

4)Customer &Project: Motorola- CAT

Location: Hyderabad (India) 2011-Dec to 2012-Apr

Role: offshore Lead

Responsibilities

Key resource of Account Receivables, Payables, Project Accounting, Collections, Order Management, Purchasing, Inventory and Costing.

Coordinated with onsite team in understanding the requirements, use cases and assigned the work to the Team at Offshore

Analysed requirements, use cases, developed test cases for Account Receivables, Payables, Project Accounting, Collections, Project Management, Project Accounting, Order management, Purchasing, Inventory, and Costing and acquired approvals from Business users.

Planned deliverables and delivered test cases to Onsite Coordinator.

5)Customer &Project: Fintech -Fintech OLFM Implementation

Location: Hyderabad (India) 2009-May to 2011-Nov

Role: Techno – Functional Consultant and Module Lead

Responsibilities

Key resource of Collections, Payables, Payments, Receivables, General Ledger, Leasing and Finance, Sub Ledger Accounting (SLA), XML Gateway, TCA and AOL modules.

Coordinated with onsite team in understanding the requirements and completed Proof of Concepts (POC)s on scoring engine, check formats, bank statement Upload reconciliation that resulted early completion of SRD and reduced efforts for design and development.

Analysed requirements, proposed To-BE solutions, prepared solution design documents (SDD), acquired approvals from required business/decision team, assigned the work to the Team at Offshore and coordinated with offshore development team in developing and configuring custom solutions.

Developed of custom components to customize collector assignment, Bank account validation, queries to set up scoring engines, scoring components, promise to pay reconciliation,Customer Open Balance report,Customer Address Validation and generic workflow process to send alerts from any process with predefined configurable message as an attachment to any list of users using PLSQL, workflow, Jdev(OAF),BI Publisher.

Developed OAF screen to capture customer specific rates for items.

Migrated of closed invoices, Customers, Suppliers, Banks, Bank Branches, Bank Accounts from legacy system using Dynamic Tables, Oracle standard APIs, PLSQL, Reports (reports 10g) and AOL.

Customized Bank statement upload, Lockbox, Receipt Creation and Cash application using PLSQL, AOL and XML publisher reports.

Customized Payment Batch Creation,Payment Batch Approval, and Check Formats(English And Mexico) using XML Publisher,OAF, Workflow,Shell Script, Workflow Business Events and PLSQL

Co-ordinated and developed interfaces for Contract Creation, AR invoice creation, AP invoices creation and developed VPDs to restrict LOVs in General Ledger.

Prepared Technical design documents (TDD), Unit test cases, executed Unit test cases, and functional test cases.

Developed scripts to migrate the code from one environment to other environments and migrated code to Testing, Production environments successfully.

Supported Functional/User/System Integration testing and postproduction issues.

Traced project status from offshore team weekly and communicated to the Onsite team lead.

6)Customer &Project :Chamber of Commerce (Saudi Arabia) -Dammam Finance Implementation

Location: Hyderabad (India) 2008-May to 2009-Apr

Role: Techno Functional Consultant and Developer.

Responsibilities

Key resource of Account Collections, Payables, Payments, Receivables, Cash Management, Human Resources, Payroll, XML Gateway TCA and AOL modules.

Coordinated with onsite team in understanding the requirements and development of Solution Design Documents (SDDs) and acquiring approvals from required business/decision team.

Developed custom components for AR invoice interface using PLSQL and AOL

Migrated closed Invoices, Receipts, Customers, Suppliers, Banks, Bank Branches, Bank Accounts from legacy system using Oracle standard APIs, PLSQL, Reports (reports 10g) and AOL.

Developed interfaces for Contract Creation, AR invoice creation, AP invoices creation using PLSQL, Dynamic Table creation, Shell script.

Developed oracle alerts to send notifications to the respective manager in case of new employee record/role change /employee termination.

Developed custom generic workflow to send FYI messages for any process using workflow, AOL, PLSQL and OAF.

Migrated Courses, Classes, Resources and employees using PLSQL, Dynamic Table creation, Shell script from legacy system

Prepared Technical design documents (TDD), Unit test cases, executed Unit test cases and functional test cases.

Developed scripts to migrate the code from one environment to other environments and migrated code to Testing, Production environments successfully.

Supporting Functional/User/System Integration testing and postproduction issues.

Traced project status from offshore team weekly and communicated to the Project Manager.

7)Customer &Project :Parkway Hospitals –Parkway health care System

Location: Singapore 2007-May to 2006-Apr and India 2008 Apr- 2007 June

Role: Business Analyst, Module Lead, Solution Architect and Developer.

Key resource of patient Management, Patient Accounting, Billing, Patient Revenue Management, Patient Receivables and Payments.

Coordinated with Users and Business Analysts in understanding business scenarios, use cases, requirements for patient Management, Patient Accounting, Revenue Management, Mediclaim and developed Functional Design Documents (FDDs).

Liaised with customer and acquired approvals on SRD from required decision/business team.

Proposed To-BE solutions, leaded and prepared High level Design Documents, Low Level Design Documents, Technical Design documents, System Integration test cases, ER diagrams, Use case Diagrams, Traceability matrices and obtained approvals from required Business team. Liaised with customer on requirement gaps.

Prototyped high-level design, Database design for Patient Management, Billing, Patient Revenue, AP, AR modules.

Coordinated with respective offshore team to understand the requirements and prepare Solution Design Documents (SDDs).

Developed POC/ prototypes, assigned work to the team at offshore and supported development activities.

Leaded design and developed interfaces to oracle apps related to AR, AP,GL and cash management from .net applications using Word, Excel,PLSQL, Forms and Reports(6i).

Leaded, designed and developed Mediclaim( This is applicable only for Singapore and is process of submitting Bill data to CPF board electronically through Xml Message )interfaces to oracle apps related to AR,AP,GL and Cash Management from .net applications using PLSQL, VB.net, Forms and Reports.

Reviewed SDDs, FDDs and TDDS from standards perspective, content perspective and technical perspective.

Supported Functional/User/System Integration testing and postproduction issues.

8)Customer &Project: TCS Internal- HMS(Health management system)

Location: India 2004 Sep – Apr 2006-Mar

Role: Module Lead and Developer.

Responsibilities

Key resource of Patient Management, Patient Accounting, Billing, General Ledger, Mediclaim and key resource at customer site.

Coordinated with Users and Business Analysts in understanding business scenarios, requirements for patient Management, Patient Accounting, Revenue Management, Mediclaim and development of Functional Design Documents (FDDs).

Leaded and prepared High level Design Documents, Low Level Design Documents, Technical Design documents, System Integration test cases, ER diagrams, Use case Diagrams for HL7 Intigra(It’s a generic tool to send HL7 messages from one application to Other application)using Oracle 8i/9i.

Co-ordinated designed and developed converting HL7 Integra from SQL Server to Oracle 9i.

Developed new forms and reports, enhanced existing forms and reports, tuned SQL queries for performance improvement, developed new packages, procedures, functions to support day to day health care activities using forms6i,reports 6i,PLSQL

Performed gap analysis, Proposed Change Requests and handled Change Requests, Minor enhancements, Major Enhancements, unit testing related to Patient Trial Balance report and Balance Sheet.

Supported Mediciti Hospitals-Hyderabad for Billing and Financial Accounting Modules

Implemented Billing and Financial Accounting Modules in Hiranandanani Hospitals –Bombay

Supported Mahatma Gandhi Hospital-Pondicherry for Billing and Financial Accounting

Supported Functional/User/System Integration testing and postproduction issues.

Education:

B.Tech (Bachelor of Technology) in Computer Science and Engineering (CSE), 75%

US Green card holder

Contact this candidate