PROFESSIONAL SUMMARY:

• Possess a master’s degree, 14 years of experience in the IT Industry, with an emphasis on Oracle ERP implementing and upgrading Oracle Financials.
• Unique functional skill set with deep exposure in Oracle Financials AR (Revenue Recognition, Fund Capture), AP, GL, AGIS, CE, FA, Project Accounting (costing and Billing), MFG costing, PO, OM, INV, EBTax, SLA, FAH, AME, Advance Collections, Credit Management, iProcurement and Quality on several multinational and complex ERP projects in Health Care, Medical, Retail and Energy industries.
• Extensive knowledge and experience in Design and Implementation of customized Interfaces, Data Migration/Conversion & Integration with external / legacy systems on cloud based system

AREAS OF SPECIALIZATION ARE:

• Oracle Financials Implementation, Upgrades, Customization, Configuration and Support
• Leveraging onsite - offshore model based delivery
• Managing and coordinating medium size teams
• Project Management activities
• Providing Solutions and Design to standard product gaps
• Experience in Building the complex SQL queries when troubleshooting issues
• Sound experience in using Oracle AIM of project implementation methodologies particularly Business Requirement Gathering (RD020), Future Business Process (BP080), GAP Analysis (BR010), Functional Design (MD50), Application Setup Documents (BR100) deliverables and Test Cases (TE040) for financial modules.
• Strong Business Acumen. Experience in understanding Business requirements.
• Proven ability to plan and lead seamless implementations, collaborate with Customers and delivery teams to build and deliver high end solutions.
• Functional domain experience in various Financial and supply chain projects viz.. Oracle Apps 11i/R12 Financials cloud(Account Payables/Receivables, General Ledger, SLA, FAH, Fixed Asset, Cash Management and eBTax), SCM (Order Management Inventory, Purchasing), CRM,ERES and Quality modules.
• CIP Assets, Project Costing and Billing, GL Reconciliation, Order to cash, Procure to pay, Record to report (RTR),Accounting concepts, costing (Average and standard) and customization of accounting through SLA (subledger accounting), Netting, Invoice Processing, Credit Card Collection System, EFT, Lockbox Oracle AP, AR, GL, eSignature and eRecord.
• Managed multiple projects from conceptualization to final execution of projects. Managing and leading team members; allocating resources within teams; recruiting & guiding team members during the project till final delivery.
• Working experience in onsite-offshore model along with onsite requirement gathering and client engagement skills
• Driving operational metrics like SLA metrics, availability metrics and Responsible for defining organization, wide operational metrics and liaising with business units for creating their respective metrics
• Working as RTR track lead on P2P side

TECHNICAL SKILLS:

SQL, Oracle Workflows, Conversions, Discoverer, Oracle Alerts, WEB ADI, HPQC and Jira

PROFESSIONAL EXPERIENCE:

Confidential, Grand Rapids, MI

Financial Functional Consultant

Platform: Oracle E-Biz R12.2.5 Account Receivables, Collections and RTR modules

Technology: Oracle Applications R12, Jira and confluence

Responsibilities:

• Working as a key person for RTR and DE areas including AR and collections
• Implementing new POS solution for fund capture and refund
• Working on inactive and active outstanding customer balances
• Working on Mass writeoff functionality for Annual and Monthly flush
• Design customer balance service call engine to place payment hold in legacy systems
• Participating in UAT and SIT for ANA countries and involved in cutover plan preparation
• Working on Netting program to net off open AR transactions
• Worked on identifying process improvement and implemented solutions.
• Worked in onsite-offshore model to reduce operational cost and help team to build knowledge repository

Confidential, Grand Rapids, MI

Financial Functional Consultant

Platform: Oracle E-Biz R12.2.5 Cash Management, Taxes( Vertex & Confidential ), Costing

Technology: Vertex 7 o series, Oracle Applications R12, Jira, HP Quality

Responsibilities:

• Part of RTR COE and deployment team, managing regional solution aside with global solution using Agile methodology
• Define new cash management solution including 3rd party bank reconciliation, cash, bank account transfer and bank Sweep using cash pool.
• Design interface between Confidential and Confidential to report unclaimed property and make payments to state authorities.
• Design GL- Subledgers drilldown reports to achieve audit requirements.
• Design interface between Tank/RMS and Confidential system for weekly and monthly bonus payments to IBOs.
• Implemented chargeback/dispute creation process for credit card payment using advance collection
• Implemented Sales tax solution using ebTax and taxeware for ANA countries
• Implemented Vertex solution for sales and use tax reporting for Confidential and design support process for patch applications in collaboration with consultants
• Implemented eBtax solution for CA and DO markets using expert rules
• Design B&O tax solution for WA and HI states to deduct payments from volume IBO’s
• Involved in Global and ANA Performance testing
• Conducted brain storming sessions during CRP and solution validation workshops
• Design cutover plan for RTR modules and between connected systems
• Conducted and Participated in SIT and UAT cycles
• Assist business during MEC and year end closing and reconciliation issues during hyper care
• Led the solution design and business process mapping efforts to minimize and simplify customizations and extensions
• Worked in onsite-offshore model to reduce operational cost and help team to build knowledge repository

Confidential, WI

Financial Functional Consultant

Platform: Oracle E-Biz R12 Costing, AP, AR, GL and eBTax

Technology: Data Loader, Oracle Applications R12, Jira

Responsibilities:

• Involved in scoping session of Mexico sites to cover costing solution
• Conducted Dry Run and working with business on costing conversion
• Customized eBtax to calculate tax based on the dynamic value of shipping address
• Involved in cleaning activity of items, cost IR/ISO process
• Design Intercompany drop ship process for Regal
• Define and design solution for cost conversion based on transfer souring rules
• Assisting business on year end closing and reconciliation
• Worked on other process improvement requirements and production support issues to assist business effectively and efficiently utilize Oracle Applications.

Confidential, California

Business Analyst

Platform: Oracle E-Biz R12 cloud- AR, AP, GL,AGIS, FA, Cash Management, Project Costing, EBTax, FAH and iExpense

Technology: Data Loader, Oracle Applications R12, Quality Center, Servicenow

Responsibilities:

• Design Report for analyzing foreign PO’s Reval Journals and changing the Matching approval level to Receipt.
• Design CIP process in Projects and Fixed Assets
• Worked with Development team on Asset Transfer process for Assets
• Design process for Confidential system to extract installation charges from Revenue and to report separately for GL reclassification
• Supporting Order to cash and Procure to Pay modules
• Having experience on Revenue Recognition in accrual accounting together with matching principle
• Requirement analysis and Solution approach for iExpense reporting for various expense needs
• Managed and assisted business on yearend closing includes cost rollup, revaluation of sales order and impact analysis on open jobs.
• Enable Auto Reconciliation functionality in cash management
• Working on other process improvement requirements and production support issues to assist business effectively and efficiently utilize Oracle Applications.
• Led the solution design and business process mapping efforts to minimize and simplify customizations and extensions

Confidential, California

Business Analyst

Platform: Oracle E-Biz R12.2.3 - Advance Collections and Credit Management

Technology: Data Loader, Oracle Applications R12, Quality Center, Servicenow

Responsibilities:

• Architecting Solutions by leveraging Oracle standard functionality and best practices, designing extensions / customizations
• Implemented collections using Strategy method and customized correspondence letter through XML Publisher in advance collections.
• Automate collection task assignment through custom process
• Design customer Collection effectiveness report
• Setup AME rules for Credit Memo and Credit Limit process
• Setup custom customer account review process
• Setup custom additional data point and score card in credit management
• Define check list for each combination of credit review type and classification
• Integrated credit management with Order Management to automate process for Credit hold release
• Setup Automation rules for new Credit limit and credit limit increase

Confidential, California

Lead Solution Analyst

Platform: Oracle E-Biz R12 - AR, AP, GL, FA, CE, EBTax, FAH and iExpense

Technology: Data Loader, Oracle Applications R12, Quality Center, Servicenow

Responsibilities:

• Architecting Solutions by leveraging Oracle standard functionality and best practices, designing extensions / customizations
• Supporting Order to cash and Procure to Pay modules
• Participate SUMA project to streamline the supplier management processes, project scope is limited to automation of suppliers and ASL maintenance, Data extraction and transformation from SUMA to Oracle.
• Implementing process for employee automation through Global HRMS system.
• Implementing automated SRA functionality to cover consigned invoices detail
• Implementing process for Ledger Consolidation and Revaluation/Translation activities
• Prepared FSG reports for Trial Balance and management reporting.
• Implementing ATLAS project to load AP Invoice transactions of non-oracle (mainframe) system in oracle GL through Financial accounting hub. This includes loading of Accrual Invoice/CM/DM/Payment transactional data.
• Implementing Stringer project which change the ownership of intellectual property from respective countries to single European R HQ, the project scope is limited to changes in EDI interface, COGS account generation and Intercompany invoice processing.
• Coordinates meetings with the product committee, project manager to discuss project impediments, needed resources or issues/delays in completing the task.
• Working on other process improvement requirements and production support issues to assist business effectively and efficiently utilize Oracle Applications.
• Led the solution design and business process mapping efforts to minimize and simplify customizations and extensions

Confidential, California

Senior Business Analyst

Platform: Oracle E-Biz R12 - AR, AP, GL, AGIS, FA, Project Costing, CST and EBTax

Technology: Oracle Applications R12, Quality Center, Servicenow

Responsibilities:

• Various aspects and stages in implementation of GL, AP, PA Costing, FA and CST modules for multiple business units spread across US and Ireland
• Worked as a functional consultant for the implementation of Oracle Project Accounting (Costing).
• Configured standard Project related setup Implementation options, burdening details related setup, and Project related workflow and profiles.
• Performed the standard configuration and setups for project accounting.
• Developed Asset Register Report
• Setup AGIS system for multiple LE’s
• Define Inter/Intra account on Ledger to process intercompany invoices
• Configured WEB ADI for Asset additions during data conversion phase
• Enable Asset book security controls and Retirement process in Fixed Assets
• Worked on Billing events, Project costing, Budgeting and Project Management.
• Added Accounting Rules for Auto accounting and creating Lookup sets.
• Worked on customizing the application for revenue recognition.
• Mapping the Client Requirements with oracle standard functionality and Preparation of Functionality design document
• Successfully conducted CRP1, CRP2 and UAT and client acceptance at all the stages for all the responsible modules.
• Conducting review of some of their current business processes and streamlining them to align to industry preferred practices.
• Involved in setting up eBtax module for location and VAT taxes for US and Ireland division
• Implemented process for accounting rules to create invoice revenue recognition schedules
• Defined AGIS flow for managing Intercompany invoices for management Fee/Rent processes.
• Designed solutions to enhance standard oracle flows for Order to Cash(O2C), Procure to Pay(P2P) and GL Accounting processes.
• Implementing Platinum process for Consigned Inventory
• Implementing SEPA, EFT and Positive pay processes through custom format
• Implementing Lockbox process and custom invoice printing
• Implementing AME for AP Invoice approval process and design interface for scanning invoices image to legacy system
• Designed Reconciliation (WIP, MADD, and RADD) reports based on custom SLA accounting.
• Design interface for importing payroll journals and exporting trial balance details to Blackline system for consolidation.
• Ensuring compliance with changing US Sales and Ireland VAT Tax rules
• Experience implementing indirect tax solutions for ERP and specializes in integration of ERP systems, especially Oracle eBusiness Suite with Vertex.
• Experience in implementing Oracle E-Business Tax (eBTax) module at various configuration levels such as Global Configuration Level and at Operating unit level based on business requirement.
• Designed outbound interface for US sales Tax return data to Vertex.
• Implementing Vertex O Series 7.x integration with Oracle eBusiness Suite R12
• Implementing AME with E-Signatures for Part 11 compliance (standard for a medical devices company).This is required to automate - ve and +ve inventory adjustments for scraping material.

Confidential, Duluth, Atlanta

Platform: Oracle E-Biz R12.1.2 - AR, AP, GL, SLA, OM and EBTax

Financial Functional Consultant and Team Lead

Technology: Oracle Applications R12, Workflow, XML Administrator and Web ADI

Responsibilities:

• Involved in End-end project implementation from requirement gathering till post production support
• Successfully conducted in AS-IS and TO-BE process design and mapping
• Performing Setups, Configurations and preparing BR.100 document
• Implementing global Billing process for various countries
• Participated in decisions finalization Chart of Accounts Structure
• Configure Financial modules includes GL, AP, AR, eBTax and SLA based on the country legal needs
• Implementing and supporting Procure to Pay modules for rollout countries.
• Implementing the strategy to migrate financial module setup between instances through iSetup module
• Design interfaces between EDW (Data Warehouse)/Legacy systems and oracle for financial reporting
• Implementing LOB (Line of business) change process
• Implementing Autoaccouting to use custom accounting flow per LOB.
• Managed a team of SMEs to implement Financials solution for customers. No of Direct Reports- 08 including 2 Onsite Developer and 1 Business analyst. This includes implementation of EFT 810/820/824/827/997 , SLA customization, AP/AR Netting and T&M flow.
• Supported Order to cash involving T&M flow.
• Maintain Financial Operations team and monitor performance of Team members and provide feedback for rewards and recognition
• Data & Solution Architect: - Controller of all Data setup elements in Oracle Application Financials (AP, AR and GL), assess process, system impacts, provides scalable data solutions to Financial processes
• Manage & run medium size projects to migrate new countries, Mergers & Acquisitions (Trident), improve process/ data quality in Oracle Application Financials
• Worked with strategic partners to ensure deliverables are prepared to satisfy the project requirements, cost and schedule
• Coordinating with PMO, Development, Testing and Business teams across various locations / geographies
• Provide directions to Financial Key users in monthly/quarterly/yearly period closings and also help them during PWC audit
• Lead a team of 5 developers to convert important operations text report to XML reports with the ability to send email to the users
• Worked with US Confidential team and PMO for resource alignment and status reporting and also communicate team status, task, and direction
• Involved in SLS Logistics R12 upgradation project
• Coordinates meetings with the product committee, project manager and functional management to discuss project impediments, needed resources or issues/delays in completing the task

Confidential, Louisville

Platform: Oracle E-Biz 11i.- AR, AP and GL

Finance Functional Consultant and Project Lead

Technology: Workflow, PLSQL developer, Oracle 11i Application Server, Oracle 10g Database, D2k Forms, Discoverer Reports

Responsibilities:

• Captured requirements from Finance Business through workshop, brainstorming sessions
• Perform Design and share detailed software architecture including Proof of Concept, Functional Design and Technical Design.
• Working on other process improvement requirements and production support issues to assist business effectively and efficiently utilize Oracle Applications.
• Providing incident/ticket resolution - Impact Analysis, Provide Solution
• Design Audit Trail requirement for Confidential on Sys Admin Access.
• Integrating Oracle E-Business with 3rd party applications such as TTT and custom built applications such as accounting applications
• Conducted Knowledge Transition from the Confidential contractors.
• Design Invoice upload WEADI to import Standard, projects and PO match invoices
• Working in close coordination with client PMO, Business leaders and Application Development teams
• Implementing Lockbox functionality
• Coordinates meetings with the product committee, project manager and functional management to discuss project impediments, needed resources or issues/delays in completing the task
• Work with functional managers and the team sponsor to obtain necessary resources to support the team's requirements
• Communicating team status, task, and direction

Confidential

Financial Consultant

Platform: Oracle E-Biz 11i.- AR, AP, Project Billing, OM and GL

Technology: Data Loader, PLSQL developer, Oracle 11i Application Server, Oracle 10g Database, D2k Forms, Discoverer Reports

Responsibilities:

• Responsible for Implementation of Project Billing, Accounts Payable, Accounts Receivable, iPayment, modules
• Arranged workshop, checklist for requirement gathering
• Implemented silent features of Project Accounting such as rate schedule, transaction control and auto-accounting rules, Implementation of labor cost rate.
• Setup of project templates and projects. Creating agreements and project Funding.
• Involved in setting up non-labor resource, billing cycle, event type etc.
• Setup of expenditure categories and expenditure types.
• Validated the Integration with Accounts Receivable: Project related Purchase Order and Integration with Payables, Import and Review Project Expense.
• Implementing Customized Revenue Recognition process for COGS
• Mapping the Client Requirements with oracle standard functionality and finding the gaps and proposing the solution in terms of Customizations, workarounds and re-engineering.
• Successfully conducted CRP1, CRP2 and UAT and client acceptance at all the stages for all the responsible modules.
• Helped testers to conduct testing properly as per the design and made sure not to impact the project delivery due to testing delays.
• Responsible for atomization of financial transactions required for WOM in accounts receivable & accounts payable.
• Responsible for providing support for all financial modules, along with OM, inventory and purchasing during GO Live and managed O2C and P2P business
• Involved in testing and delivery of content
• Worked on EOD Reporting Interface.
• Assisted developers in technical design and development of complex interfaces and issue resolution
• Coordinated the design and development of RICE components, super-user and knowledge transition.
• Captured requirements by working closely with Business Team for custom Shipping Application.
• Perform Design and present detailed software architecture including Proof of Concept, Functional Design.
• Automation of AR Invoice, receipt, remittance and reconciliation