Internet ASP, HTML/DHTML, Javascript, Windows NT script
Tools Developer 2000(Forms 6i/4.5, Reports 6i/2.5, Graphics)
RDBMS Oracle 9.0/8.0/7.3, MS SQL Server 7.0/6.5, Oracle Web Application Server 3.0
ERP Oracle Apps 11.5.9 (Service Contracts /OKC |
Oracle Apps Senior Developer/Consultant
24-Hour Fitness Inc
24 Hour Fitness®, the world's largest privately owned and operated fitness center chain with more than 3 million members and 350 clubs in 16 states. The Accounts Receivables, Service Contracts and parts of General Ledger modules have been implemented in Oracle 11.5.9 Applications. Involved in Analysis, Design, Development, Testing of Enhancements and Maintenance of AR and OKC Modules.
24HRFIT
• Created several Corporate Roll Forward Reports for deferred revenue for the management to analyze and derive financial forecasting per club. Also created queries for Audit trials per contract per club.
• Fixed over 20 tickets/issues as part of enhancement and maintenance of the Oracle Application System both in Contracts and Accounts Receivables module.
• Created and converted complex queries into views to be run as EUL Custom Folders objects Discoverer reports for Business Analysts.
• Worked on Customers & Contracts Open Interfaces, Auto-invoice Process and Service Requests associated with Workflows.
• Created new Responsibilities, Request Groups, Concurrent Programs, Request Sets and performed AOL and System Admin operation in the DEV environment.
• Document processes for migration to Test and Production environments and wrote User Docs and Test Docs as part of Deliverables.
Jun 2004 – Nov 2004
Oracle Apps Developer/Consultant
Cisco Systems
Cisco Systems, Inc. is the worldwide leader in networking for the Internet. Cisco hardware, software, and service offerings are used to create Internet solutions that allow individuals, companies, and countries to increase productivity, improve customer satisfaction and strengthen competitive advantage.
Involved in Analysis, Design, Development, Testing and Implementation of two enhancement projects in Accounts Receivables Application in Oracle 10.7 Modified existing table structures and PL/SQL procedures and packages for the 2-Tier Unit Deferral Project and 2-Tier Packaged Service Revenue Recognition Projects.
2Tier Unit Deferral Project
• Met with Business users and cross-functional teams in understanding the requirements for the enhancement. Conducted meetings and presented design proposals to the business and technical users for the same.
• Studied the current production system for impact analysis and documented the design specs and analysis of the same.
• Incorporated the changes in the schema (tables, views), Form and PL/SQL packages for the 2-Tier Deferral and Amortization for Cisco products and tested the same by creating test cases and documents.
2Tier Packaged Service Revenue Recognition Project
• Successfully implemented the 2 Tier Packaged Service Revenue Recognition project by creating a new profile and eliminated hard coding of value in the “Receivables Interface to Support Maintenance” concurrent program, as was the case in production under challenging deadlines.
• Interacted with downstream
|