SUMMARY

• 10+ years of experience in Information Technology projects and helping clients in converting complex business problems into efficient solutions.
• As a Revenue Recognition consultant helping clients in adapting the new Revenue Recognition standard ASC 606 for the Software Companies like Confidential and Confidential .
• Implementing and Customizing the Industry Leading Revenue Recognition tool called REVPRO.
• With a strong back - ground in Oracle ERP (E-Business Suite)development methodologies coupled with R12/R11i Implementation, Upgrade, Customization and Production support with multiple full life cycle implementations experience.
• As an ERP consultantactivelyinvolved in all the phases of the SDLC.Specialized in Oracle E-Business Suite/ Applications 9i, 10g and 11i deployment Requirements, Coding/Development, Customizations, Testing, and Functional User Training.
• Expertise in working directly with the business end-users to understand the business complexities and proficient in designing and building the custom solutions.
• Performing Gap Analysis between goals and existing procedures / skill sets, and designing process and system improvements to increase productivity and reduce costs.
• Highly resourceful with strong problem-solving skills; detail oriented; enjoy challenges and diversity of work tasks.
• Experience in systems and business process analysis, including process workflows, identifying and orchestrating productivity and continuous improvements, and the application of IT best practice standards and change management procedures.
• Expertise in providing custom solutions with Oracle Public API’s.
• Conducted business meetings and brainstorming sessions with the end-users to perform fit gap analysis and improve business solutions efficiency.
• Experience is customizing the standard workflows in Oracle to suite business needs.
• Created User training manuals, videos and conducted online training sessions.
• Performing manual testing, actively participating with User Acceptance Testing teams and proficient in performing pre-production validation.
• EBS-APEX integration & Solutions expert. Implemented the Oracle EBS Application extensions, provided solutions beyond RICEW, and added another element A (APEX) to the listing at various clients.
• Experience in Application System Administration activities like application user setup, defining responsibilities, value sets, registering menus, forms, reports and concurrent programs and assigning them to request groups and responsibilities.
• Good knowledge on oracle AIM Methodology. Written Technical, Functional and conversion mapping documents MD070, MD050 and conversion mapping CV060 respectively.
• Self-Starter with good written and oral communication skills.

TECHNICAL SKILLS

• Oracle APEX (4.1/4.2)
• Oracle 11gR2/10g/9i
• SQL & PL/SQL
• BI/XML Publisher Forms
• Reports
• Oracle Workflows
• UNIX
• Shell Script
• SQL*Loader
• SQL Developer
• Java
• J2EE
• XML
• TOAD
• Discoverer
• Jdeveloper
• JDBC
• Java Concurrent Programs
• LINUX
• UNIX
• Windows

PROFESSIONAL EXPERIENCE

Confidential, San Jose

RevPro Techno-Functional Consultant

Responsibilities:

• As a RevPro Consultant, supporting the revenue team to adapt the new Revenue Recognition Compliance, Accounting Standards Codification 606.
• Data conversion or Data loading of existing Net-Suite data into the production environment of REVPRO for FY17 and FY18.
• Customizing the reports as per the business needs and running them for various users on demand.
• Mass deferral/release of performance obligations on demand per business.
• Accounting Details report reconciliation for every quarter and helping fix the differences.
• Working with REVPRO support team to resolve the tickets raised by the team and get quick closures.
• Analyzing & fixing the technical challenges in the production / Non-Production environments.

Confidential, Fort Lauderdale

RevPro Techno-Functional Consultant

Responsibilities:

• As a Lead Consultant, implementing the industry leading revenue recognition tool REVPRO at Citrix HQ.
• Understanding the Order to Cash process of the Citrix environment and aligning the product to comply with the new accounting standard ASC 606, which is mandatory for every public company starting Jan 1 2018.
• Configuring the Revpro to help CITRIX to perform the revenue recognition complying with the ASC 606.
• Fit-Gap analysis and provided custom code to fill the gap between the tool and the business requirement.
• Actively involved in resolving unit test case and user acceptance test case defects/issues.
• Conducted Mock data load of 1.2 million records to test the efficiency of RevPro.
• Written functional specifications, configuration documents as well as training documents.
• Constant interaction with the business teams to gather requirements and understanding the complex business problems. Frequent interaction with the Top & Middle management to improve the business processes and productivity helped me to expand my functional & interpersonal skills.
• Part of the technical team to build custom solutions.
• Coordinating with the off-shore team to provide efficient and on time solutions.

Confidential

Techno-Functional Consultant

Responsibilities:

• As a Techno-Functional consultant, provided complete end-end solutions to the complex business problems.
• Revenue and Cost Recognition Tools: Provided a custom solution to the finance team to comprehend the revenue and the cost recognized in the current month. With the waterfall report consisting of a broad range of 72 months now, the finance team knows how much revenue is recognized every month how much is remaining for the next coming months. It is a good forecasting tool for the finance team.
• Billing Statements and Aging Tool: Provided the Independent Affiliates (OR) sub-contractors of Confidential a solution to view the billing statements online outside the firewall. Monthly statements, Pending Payments, Aging info, and Checks with Transaction details.
• Invoice Reconciliation Automation: Provided custom solution to reconcile the $1.2M worth invoices from Dish, Direct TV and other 3rd party vendors against Contracts billing. Automated a manual process by designing and implementing a solution which compares the bill amount from third party against $ amount from the Contract Billing for that month. Multiple people and weeks of transformed into few minutes and few clicks.
• AP/AR Netting: Actively involved in implementing the AP/AR netting and provided a solution to the third party vendors to view the netting info on the Billing statements.
• EB-TAX Rate Analysis: Provided a solution to the Tax team to understand and comprehend the tax rates provided by VERTEX and uploaded every month. This solution helps the team to understand the increased, decreased tax rates along with any Jurisdiction and name changes.
• Asset Management Tool: Provided a solution for the IT team to manage the Assets and assign them to the respective employees who own the assets.
• Oracle Customer Data Management: Built an easy to use custom solution to manage the Customer data, which is dynamic. Updating Sales Mangers, Account Managers, Collectors, and other fields updates made easy via this tool.
• Public API implementation Tool: Designed and developed a custom tool to Mass Create and Update of Oracle Service Requests and Tasks via a user-friendly front end with batch logging.
• Dashboards: Provided a Solution to help the TOP management to understand the overall picture of Orders & Service Requests in multi-dimensional view.
• Report Request Tool: Built a custom Interactive-tool to log report requests by the company wide users at Confidential . For example, if the Sales team wants a report, instead of sending an email they log a request in this tool and an email will be sent out to the Data Warehouse team. DW team works on the report and updates the tasks on this tool.
• Purchase Order Cycle enhancement: Provided a custom solution to send out an email to close the PO passed 10 days after shipment date.
• Data Conversion and Validation: Actively involved in converting the invoices and orders from a third party database to Oracle during the merger project.
• APEX Administration: Responsible for the APEX Application with hierarchy management and accessing grants to the new developers or business users. Migrating reports from OBIEE to APEX to reduce licensing costs.

Confidential, Charlotte

Oracle EBS Consultant

Responsibilities:

• Actively involved in the complete life cycle of Oracle EBS upgrade project (11i to R12).
• Working with business partners to understand their processes and needs to design and build extensions accordingly.
• Developed/Migrated around 20+ RDF reports, BI/XML publisher reports as part of the Upgrade.
• Developed/Migrated around 30+ PL/SQL packages and created the underlying database objects like custom tables, view and indexes as required.
• Developed multiple interfaces and worked with business partners to transfer the files via NDM a method used in Confidential to transfer files between servers.
• Created the concurrent programs, value sets and profile options according to the new business requirements.
• Replaced the third-party software “IRIS” with Oracle Apex reports, cost effective.
• Hands on experience in Linux/Unix shell scripting to support the business process.
• Always inclined toward Performance: Involved in tuning SQL and suggesting/ implementing the latest Oracle database techniques like bulk collect and for all to improve the performance in numerous PL/SQL packages.
• Expert in Analysis, design, develop, document, test and implement the Oracle APEX (4.1+) application as required, developed upon decommissioning a java based application and built 50+ forms/reports. Played a significant/crucial/major development resource role in the success of this application.
• Developed SOAP xml request to implement UPS & FedEx Web service to track the live shipping packages via Oracle Apex application and written the parsing code to show the xml response results as per the business need.
• Thorough understanding of the documentation methodology involved in the project and created the SDLC documents to comply with the business requirements.
• Actively involved in the project meetings to discuss the timelines, which streamlines the process and enhances the project progress.
• To increase the productivity, Leveraged and made the best use of UAT in enhancing the requirements in this phase requested by the users as per the business needs.
• Expertise in Ticketing/QC tool: HP Application Life Cycle Management software, Code Repository tool: Harvest and Deployment tool: CAMS used in Confidential .
• Received appreciation letters for smoothly and efficiently pipelining the business processes and efficiently implementing the user needs (please refer to my LinkedIn).

Confidential

Oracle EBS Consultant

Responsibilities:

• Actively participated in the full life cycle of the upgrade project from 11i to R12.
• Studied the existing system, reviewed it and implemented/enhanced the changes as per the new business process upon approval.
• Migrated/Developed and tested the custom PL/SQL packages to develop interfaces.
• Migrated/Developed new reports RDF as well as XML publisher as per the client requirement.
• Created SQL*Loader control programs and PL/SQL validation scripts.
• Designed & developed the custom interface program to create and update an item with database validations.
• Developed SQL queries to obtain specific information as per requirements.
• Developed reports like Pick Slip, Packing Slip, and Mailing Label for Shipping and Credit Order Detail, Orders by Item, Order Detail & Summary Reports for Order Management.
• Customization and Extension of Forms using personalization.
• Application System Administration activities like application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs.
• Registering reports, custom packages as concurrent programs to run from SRS form.
• Prepared Technical specifications for the functional specifications received from the functional team following AIM methodology: MD070 and CV060.