SUMMARY

Oracle EBS functional consultant with over 10 years of experience; Excellent reputation for resolving problems, improving customer satisfaction, and driving overall cost saving operational improvements.

TECHNICAL SKILLS

Oracle Applications: Financials Modules, HTML, ADI, SQL Developer, Remedy, ITSM

RDBMS: MS - Access

Other Software Packages: MS-Word, MS-PowerPoint, Ms Excel, IP addressing, Sub netting, Subnet mask, VLSM and CIDR, Cisco 2950 Switches, 2500, 2600 Routers

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Oracle Financial Functional Consultant

Responsibilities:

• EMEA Lead for country setups - brought several countries on board with Oracle R12.
• MD050, BR.100, TC.200, TC.300 and TC.400.
• Helped finance in reconciliation of reports.
• Instrumental in standardizing accounts and expense codes for various 'CITI' countries.
• Participated in designing the chart of accounts to meet the client's business requirements.
• Conducted weekly Production support calls with cross functional teams to check status of outstanding tickets.
• Conducted meeting with controllers of different countries on a regular basis to meet their specific requirements.
• Worked with development team in designing specific internal client requirements for building Interfaces such as Flexcube, DBS, EBS.
• SQL performance tuning and writing complex SQL queries
• Built and maintained SQL scripts and complex queries for data analysis and extraction for various projects.
• Imported, exported and manipulated large data sets in multi-row databases under tight deadlines.
• Wrote and automated tools and scripts to increase departmental efficiency and automate repeatable tasks.
• Designed stored procedures, reports
• Interacted and communicated with colleagues as needed as both a technical and functional expert.
• Configured Implementation Options and Project related Organization Hierarchies.
• Defined the Classification Categories and Classification Codes to configure the Auto Accounting.
• Defined Project Types and Project Templates to meet the Business Requirement.
• Configured the Auto Accounting setup.
• Team Lead - system administration.
• Built Cost saving custom applications like 'CATCH'.
• Admin for Oracle Financials, Discoverer, XML and People Soft.
• Played pivotal role in outsourcing the team from Tampa to India.
• Knowledge Transfer to Key Users/Process Owners and End users, User Acceptance, Production Go-Live.
• Ensured smooth transition of duties and responsibilities.

Confidential, Baltimore, MD

Oracle Financial Functional Consultant

Responsibilities:

• Carried out module configuration, solution design, process analysis, and implementation of Oracle Financials General Ledger, Accounts Receivable, Project accounting and Accounts Payable.
• Responsible for the documentation (BR.030 -Business Requirements Mapping, BR.100 -Application Setup and TE.040 -System Test Script) and setups of the General Ledger, Accounts Receivable, and Cash Management Modules.
• Business communications for the system updates and meeting the deadlines for the implementation.
• Supervised the period close and quarter close processes by ensuring that all financial transactions have been accounted for accurately and on a timely basis in Oracle GL.
• Developed Custom reports, Standard Interfaces, Custom Interfaces linked to different modules of Oracle Applications from third party.
• Defined Resource Lists, Budget entry methods and Budget Types.
• Coordinated with the Technical Team to develop the Customizations.
• Provided support during User Acceptance Testing (UAT)
• Involved in the Post Production support and Coordinated with Oracle Support in issue resolution.
• Involved in the Projects Period end process.
• Functioning as an Upgrade Lead for R12 Project for Procure to Pay Track.
• Worked closely with technical team to retrofit CEMLI's to R12.
• Led cross functional discussion with business users to address critical upgrade issues.
• Performed Pre Upgrade setups and Post Upgrade Setups for OM, Advanced Pricing, WMS WIP
• End to End integration testing of Order to Cash Demand to Build WIP business flow processes touching integration points and customizations.
• Worked with Procure to Pay teams to test cross module customizations/interfaces.
• Review Order Management, Advanced Pricing and Shipping WMS Customizations and performed Map/Gap Analysis to bring down Customizations.
• Worked with business users to test customizations during CRP test cycles including UAT and SIT. Drafted Integration Test scripts and Unit Test scripts for CEMLI's in Order to Cash functional area.
• Facilitated issue resolution meeting with the users to successfully resolve and close issues.
• Worked with tech team to migrate customizations including personalization, workflow, lookups, concurrent programs and OA framework java pages etc.
• Worked with business users to train them with new functionality in R12.
• Conducted training sessions for users to review R12 changes. Worked on performance issues related to Order Import, EDI, print Pickslip processes.
• Worked on defining functional design on data conversion scripts and custom interfaces in shipping around trip stop design changes in R12 as opposed to 11i.
• Production Support post Go-live on closing issues.