Oracle Apps Developer with 6+ years of experience in implementation, development, conversions and upgrades
Seeking a software consultancy position in a dynamic Information Technology environment to leverage my skills, abilities and experience in the ERP and Financial systems domains to contribute towards the company's success. To enhance my technical, functional and analytical skills and continually learn the latest technologies, paradigms and processes.
oracle Financials techno-functional consultant with over Six years of IT experience in the ERP domain. Rich experience in oracle e-business suite technologies (oracle Applications 11i ?11.5.10/11.5.9/11.5.5/11.0.3).
Proficient in Development, Implementation, Setup, Configurations, Upgrades, Building interfaces, Process customizations, Data conversions, Enhancements and Support of oracle ERP systems.
OCP-Certified oracle Developer with rich project experience in Forms 6i, Reports 6i, PL/SQL, RICE (Reports, Interfaces, Conversions and Extensions) for oracle Apps, SQL*Loader, SQL performance tuning, database triggers, packages, Workflow customizations, Custom libraries & UNIX shell programming.
Strong oracle Applications technical knowledge in architecture, setups, configuration and implementation of oracle Financials modules (AP, GL, PO, AR, FA, PA, INV, OE, System administration).
Has a good understanding of Retail industry and retail business processes (especially retail finance and accounting business flows), having worked for major US retailers.
Self-starter with good interpersonal, presentation, communication and project coordination skills.
Exceptional ability to quickly grasp new concepts. Enjoy working in a fast-paced work environment both as an independent individual as well as a team player. Always willing to take on new challenges and extra responsibilities.
oracle Applications 11i (11.5.10/11.5.9/11.5.5/11.0.3):
Functional areas -
Accounts Payable (AP), General Ledger (GL), Accounts Receivable (AR), Purchasing (PO), Fixed Assets (FA), Project Accounting (PA), Order Entry / Management (OE / OM), Inventory (INV)
Technical ? oracle Forms 6i, Reports 6i, PL/SQL, Discoverer, Workflow, ADI, AOL, System Administration, Concurrent processing, Alerts, Flexfields, Trading Community Architecture (TCA)
Implementation, Setup, Configuration & Upgrades of oracle Financial systems
oracle Forms 6i, oracle Reports 6i, PL/SQL, Stored procedures & functions, PL/SQL packages, UNIX Shell scripting, oracle Workflow, C, C++, Visual Basic
oracle Discoverer 4i, oracle Workflow Builder, SQL*Loader, oracle ADI, oracle Alerts, Taviz 3.1, PVCS, VSS, CVS, MHC Document Express, Vertex 3.1, Sabrix Tax Solution, Bugzilla defect tracking utility
oracle 9i/8i (188.8.131.52, 184.108.40.206, 9.x, 8.x), Microsoft Access
HP UNIX 10.04, Windows XP/NT/2000
oracle Certified Professional (OCP) in Forms Development from oracle Corporation
Diploma in Network-Centric Computing from NIIT, India
Brainbench certified in oracle Financials Release 11i, Accounts Payable, PL/SQL, RDBMS
Client: ShopNBC, Minneapolis, MN, USA Feb ?06 - present
ShopNBC is America's #3 home shopping network, specializing in jewelry, apparel, collectibles, housewares and electronics through its nationwide TV channel, and website (www.ShopNBC.com).
AR end-to-end Reconciliation: Sep?06 ? present
Designed & implemented a comprehensive end-to-end reporting solution comprising of 7 reports (using oracle reports and PL/SQL reports) to perform reconciliation of the company's A/R subledger to the General ledger at each fiscal period-end, and to determine reasons for discrepancies. Performed functional reviews of accounting business processes to identify reconciliation issues. This helped the business to fix accounting issues to the tune of $60-120K per month.
Worked closely with end users to gather requirements on oracle Apps reports to be developed.
Performed an end-to-end functional analysis of accounting business processes to identify potential root causes for reconciliation issues in AR.
Proposed fiscal month-end cutover processes to be followed by the business groups to eliminate accounting carry-over across periods.
Recommended various setup changes in oracle Apps (AR/GL) to streamline the accounting flow and fix incorrect/double accounting scenarios that were occurring with customer refunds.
Revamped the accounting mechanism for Warranty processing to provide finer detail of visibility and reporting to end users.
oracle ERP Upgrade: Feb?06 ? Aug ?06
The ERP Upgrade project involved upgrading ShopNBC's oracle Apps system to release 11.5.9. The oracle Apps implementation at ShopNBC contains several complex customizations to the core oracle modules, making the upgrade a challenging and mission-critical activity.
Performed Impact analysis and identified application components to be remediated for the upgrade.
Conducted regression testing of application functionalities including customizations (custom forms, reports, interfaces and setups) in AR, AP, GL, OE and INV. Utilized tools such as Bugzilla to track resolution of issues and CVS for version management.
Remediated the impacted Purchase-to-pay and Order-to-cash custom forms and reports (including oracle reports, Discoverer, SQL reports) for the upgrade.
Redesigned the custom Discoverer EUL's to map objects and tables correctly in the upgraded schema.
Tuned custom interface programs, processes, packages and reports for better performance in the post-upgrade environment. Achieved greater than 50% improvement in run time for some cases.
Adhoc Development/Enhancement Initiatives: Ongoing (Sep 06 ? till date)
Developed numerous new functionalities/enhancements to oracle Apps as per the client's business requests during the period, such as:
Inventory aging analysis & reporting: Designed and built a set of oracle reports and PL/SQL reports to provide a drilldown breakup of aging inventory items by buyer and vendor. This aided inventory and merchandising managers to measure buyer performance and track inventory movements.
Warranty processing interface to G/L: Developed a PL/SQL interface to import journal entries into G/L, to record the sale of warranties to customers, and invoicing/billing between ShopNBC and NEW (a 3rd party vendor who manages warranties).
Customer credit scoring: Designed and developed a custom oracle form to be used by ShopNBC's Credit dept to view/update customer credit scores based on credit reports received from reporting agencies, and place customer orders on credit hold/cancel orders according to user review.
Client: Best Buy Co. Inc., Richfield, MN, USA Apr ?01 ? Jan ?06
Best Buy Co., Inc. is North America?s #1 specialty retailer of consumer electronics, personal computers, home entertainment, software and appliances, with more than 1000 stores throughout the USA and Canada.
oracle Financials Application Support/Maintenance: Mar ?03 ? Apr ?04, Jul ?05 ? Jan '06
Was responsible for providing Application support for the oracle Financials suite at Best Buy, an application with a user group of more than 1500 users and one of the largest implementations of oracle Applications in the USA.
Supported and maintained a large-scale multinational enterprise application running on a clustered environment with a total of 8 HP-UX servers and multi-terabyte RAC-clustered databases. Key areas supported were Accounts Payable, General Ledger, Purchasing, Fixed Assets and Project Accounting.
Responsible for troubleshooting & fixing production issues and permanent resolution of recurring issues.
Implemented several performance tuning improvements such as reducing critical fiscal month-end GL batch processing time by 20%. Co-ordinated with Accounting business users to ensure smooth and successful fiscal period-end processing and timely annual 1099 tax filings.
Undertook process automation initiatives such as developing a spreadsheet tool to validate invoice upload data in AP, resulting in productivity gains for invoice processors and substantially reducing manual identification and correction effort.
Worked with oracle Support through Metalink to resolve production issues. For critical issues, co-ordinated with Support (by logging emergency iTARs) and DBA?s to resolve the issues as quickly as possible and minimize downtime.
Undertook responsibility for ensuring that the application suite was kept updated to the latest patch set levels and implementation of bug fixes/critical updates done on a periodic basis.
Electronic funds transfer (EFT) Implementation for oracle AP: Oct?04 ? Jun?05
Implemented a system to deliver B2B payments electronically to the trusted external suppliers of Best Buy through electronic fund transfer (EFT) to the supplier accounts, thereby eliminating the expenses of printing paper checks and remittances. Developed a PL/SQL interface between oracle AP and TranCentrix Inc., a provider of international payment solutions, for this requirement. Designed custom DFF's in oracle vendor and invoice screens to capture EFT-specific information.
Apps 11.5.9 Upgrade: May ?04 ? Sept ?04
Provided technical consultancy in the oracle Apps upgrade from release 11.5.5 to 11.5.9 at Best Buy. Performed impact analysis and patch testing for the upgrade, Regression testing and re-designing of impacted components including custom forms/reports and custom library (Custom.pll). Co-ordinated functional regression tests with business users. Trained the end users on new and changed functionalities in the upgraded application.
Expense Reimbursements through Payroll Implementation: Nov ?02 ? Feb ?03
Implemented an interfacing system (using PL/SQL, oracle API's and SQL*Loader), to deliver BBY employee's expense reimbursements from oracle AP to its third-party Payroll system, for the reimbursements to be added with the employee's paychecks. This project eliminated the printing of 25-35,000 checks per month and hence significantly reduced the company's paper check printing/mailing expense and associated overhead costs.
Best Buy - oracle Financials Implementation: May ?01 ? Oct ?02
Project involved implementation of oracle Financials modules AP, GL, PO, FA and PA at Best Buy.
Designed and developed data conversion programs and complex inbound/outbound interfaces between legacy Finance applications and oracle Financial modules, using PL/SQL, oracle API's, UNIX shell scripts and concurrent programs.
Developed custom interfaces to import AP invoices from external systems, and automate the check batch printing process, using PL/SQL and oracle API's. Worked with business users to gather requirements and wrote functional design and technical design documents for the interfaces.
Used oracle Forms 6i extensively to develop custom forms for BBY's business needs, such as Legacy account mapping form and Employee Expense reimbursement maintenance. Extensively used oracle Reports to build several custom reports in AP, GL, PO and FA/PA, as well as Sarbanes-oxley (SOX) related reports.
Implemented custom library (Custom.PLL) routines to build custom functionality to the standard forms, such as notifying AP processors of potential duplicate invoices in the Invoice Workbench form.
Worked with functional teams to perform and document application setups and configurations, including designing of custom DFFs and value sets to capture legacy app-specific data for the various invoice interfaces.
Conducted system testing and integration testing of interfaces and custom forms/reports. Participated in conference room pilot (CRP) stage of the implementation.
Played key technical role during system cutover. Responsible for developing complex data conversion routines using oracle API's, PL/SQL procedures, SQL*Loader scripts and interface tables to transform and load legacy data into oracle master tables. Successfully loaded several million journal entries from BBY's legacy accounting package into oracle GL within short timeframe.
Bachelor of Engineering (B.E.) from Anna University, Chennai, India
Member of IEEE since 2001.
Provided on request.