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 Citrix Systems and Splunk.
• Implementing and Customizing the Industry Leading Revenue Recognition tool called.
• 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 .
• 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 manuals, videos and conducted online 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:

Modules: Order ManagementInventory Purchasing Assets PayablesReceivablesGeneral Ledger EB Tax Incentive Compensation Service Service ContractsInstall Base

Technical: Oracle APEX (4.1/4.2)Oracle 11gR2/10g/9i SQL & PL/SQL BI/XML Publisher Forms & ReportsOracle Workflows UNIX Shell ScriptSQL*Loader

SQL Developer: Java, J2EE, XMLTOAD

Discoverer: JdeveloperJDBC Java Concurrent Programs LINUXUNIXWindows

PROFESSIONAL EXPERIENCE:

Confidential, San Jose

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

Consultant

Responsibilities:

• As a Lead Consultant, implementing the industry leading revenue recognition
• 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 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

Environment: LINUX, Oracle Applications R12.

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 Mood Media 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 MOOD Media. 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

Environment: LINUX, Oracle Applications 11i & R12.

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 Wells Fargo 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 Wells Fargo.
• 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.
• Printed Requisition Report.
• Invoices completely paid Report.
• Vendor wise Pending, Cancelled Purchase Orders Report.
• Purchasing open interface.
• Item transactions with quantity by sub inventory wise for a specific organization.
• Customized invoice form through personalization: If invoice is approved then we cannot update quantity and price.
• Customized invoice form through personalization: If invoice is approved then payments should be disabled.
• Customized PO form through personalization: Not to raise purchase order on weekends.
• Developed normal query find form with dff.

Confidential

Technical Consultant

Responsibilities:

• Understand the requirements or issue and develop or fix respectively with respect to the Oracle E-Business suite application.
• Responsible for all the queries and any other technical work in the testing team.
• Creating queries to assist users in performing User acceptance testing.
• Writing custom PL/SQL packages as per the business requirements.
• Developed SQL*Loader control programs and PL/SQL validation scripts.
• Preparing the Technical Design Documents after completion of component and updating the Tar’s.
• Developed PO Vendor Report, Vendor ledger report using XML Publisher
• Involved in customizing and developing the Reports, Registration of Custom Tables and Concurrent Programs.
• Used custom.pll extensively for example to restrict the user responsibility access and restrict the usage of some of the management units for approval process.
• Involved in System Administration activities of creating the value sets, registering concurrent programs and assigning them to request groups and responsibilities.
• Handling assignments that demand ability to create data extracts, reports and other extensions to standard Oracle Apps functionality.

Confidential

Associate Consultant

Responsibilities:

• Developing PL/SQL validation Scripts.
• Developing Custom Interface Programs, Discoverer Reports and XML Publisher reports.
• Creating value sets for report parameters and registering them in applications.
• Developing conversion programs and reports that are registered as concurrent programs and which are run from SRS form.
• Writing SQL*Loader Scripts to create CTL files to load the data into oracle base tables.
• Extensively worked on UTL FILE Packages in reading data from data files and put them in database tables.
• Developed several programs as part of the change requests submitted by the users and approved by the IT team.
• Development of Reports as required by the client’s IT team from time to time.
• Developed, personalized and customized forms according to business requirements.
• Preparation of Technical Documents like CV060, MD070 from the functional specifications, which are based on the client’s requirement.
• Assisting the users in testing the programs by providing them with the test scripts.
• As a Research Assistant, I have worked in the project “Delineation of Skin Cancer and Lesions by Filters Supported Active Contour” for Dr. N.M.Sirakov
• Implemented typical image processing techniques in JAVA to surpass the noise present in the skin cancer image and detect the boundary of the lesion very accurately.