SUMMARY

• Senior Functional Analyst with 18 years of experience helping companies design and build technical systems customized for unique needs.
• Two Full lifecycle Implementations of Oracle EBS R12 P2P and O2C cycles.
• Experience in EBS Upgrades, Data migrations, Conversions and Integrations, system Support and Project Delivery.
• Solid understanding of Oracle Application modules, Multi Org setups, Reporting, Ledgers, SLA, Accounting Flows, Technical Architecture, integration points.
• Expertise in identifying areas for process improvements and implement solutions to increase operational efficiency and achieve cost savings.
• Extensive work experience in the functional flows of Oracle applications R12 and 11i modules GL, AR, AP, PO, FA, PA, iprocurement, Inventory, BOM, Budget Execution, isupplier, and Sys Admin.
• Expertise in analyzing current business processes, conduct GAP analysis, determining system requirements, Data analysis, design and implement solutions for client specific needs.
• Vast experience in P2P cycle, vendor and payment management, Cash reconciliation, Requisition and Purchase order processes, Tax reporting, Order to Cash cycle, TCA.
• Expertise in R12 SLA and accounting flows from sub ledger to GL and in designing reconciliation processes/reporting to help companies improve financial reporting and visibility across organization.
• Experience in period closing for Month end, Quarter and Year end cycles and W2/1099 processes.
• Conduct root cause analysis to identify common pattern of repetitive issues and implementing methodologies to resolve the root cause and train users on improved processes.
• Experience working in production support environment and resolving critical issues.
• Expertise in various reporting tools and designed reports in XML Publisher, RXI financial Administration, OBIEE Business intelligence suite, APEX.
• Expertise in integrating different systems, inbound and outbound processes, Cash reconciliation.
• Post implementation support, preparing training manuals and training end users.
• Expertise in resolving critical production issues, tracking development, Coordinating Release management and SDLC.
• Well experienced with Application Tools TOAD, SQL Developer, Data loader, ADI & Web ADI, SOA.
• Good Technical Knowledge on SQL, PL*SQL, SOA, APEX, OBIEE, Busines Intelligence.

TECHNICAL SKILLS

• Oracle E - Business Suite, ERP, R12
• Systems Analysis, Data Analysis
• Requirement analysis, Solution Design
• Technical analysis, Development
• CRP, Project planning and Documentation
• OBIEE, Business Intelligence
• Production Support and user training
• RICE, Workflow, Web ADI, API
• SDLC, Agile, Hypercare Support
• Change Management and Release coordination
• Product development and integrations
• Business Process improvement, Value Addition
• Oracle ERP P2P, O2C, Oracle Projects, HR
• Oracle Financial Accounting, GL, FA, SLA
• R12 Implementation, Upgrades, Data migration
• ERP, Oracle, SQL, PL/SQL, APEX, SOA, JAVA
• Data analysis, Reconciliation, FAH
• Month end Year end Period closing, Support.

PROFESSIONAL EXPERIENCE

Principal Business Systems Analyst

Confidential

Responsibilities:

• Worked as Principal analyst in integrating various systems in a big, shared service environment and designed the inbound/outbound processes between different business units across the organization to a shared hub for achieving process efficiency and reduced cost associated to maintaining the feeder systems.
• Designed a central shared repository to accept vendor, Customer, Invoice and Journal data from different feeder systems to a common data standard to achieve data quality and reduce redundancy.
• Conducted Project Reviews at different stages and setup regular meetings with Business stake holders.
• Contributed to project discoveries, kickoff, prepare proposals for an end-to-end solution and worked with management to schedule, coordinate and implement projects.
• Designed reconciliation processes between subledger to General Ledger to identify Purchasing, Invoicing and Collection activity is accurately accounted and designed solutions to Finance team.
• Setup new payment templates, Configured Payment batch setups for timely process the payments and improved the working capital per the client specific requirements.
• Designed mapping of legal entities, reporting currencies, ledgers and balancing segments and resolved inter company accounting issues and journal import issues that saved cost associated to the journal corrections.
• Lead the initiative to integrate coupa software as single procurement system to EBS, designed inbound, outbound integrations and transition from old multi feeder systems that improved efficiency and cost.
• Designed solution using SOA and Oracle Apex for various users across the organization to drop and pickup various files from a frontend UI, Data upload, Error corrections and Automated extract to user emails that saved lot of manual effort and cost and time associated to the daily activities across organization.
• Created setups for automated payment batch kickoff for various payment schedules and designed processes to identify potential payment issues proactively to facilitate timely payment process for customers.
• Detailed the processes causing delays in period closing during Month end, Quarter End and Year end and designed processes for timely closing of books and reduced system downtime to the customers.
• Led the master data team and worked with business systems to come up with data guidelines and Data quality measures for Incoming Data and to maintain master data system.
• Worked with Business intelligence teams and designed outbound data feed to the BI systems for generating Dash boards for Higher management on the payment, cash and Receivable activity across organization.
• Worked with management to review, prioritize and schedule projects and implement the solutions.
• Reviewed the business practices across the organization in the shared service and identified gaps and designed solutions to improve processes, implement measures to prevent repetitive failures.
• Engaged in meetings with customers to in corporate new projects and train the users on new implementations for a successful transition from existing systems to new processes.

Functional Lead

Confidential

Responsibilities:

• Worked as Functional lead in a large team in Full life cycle implementation of oracle ERP upgrade from11i to R12. Conducted meetings with Client in detailing the requirements, conducting GAP analysis, identifying Business scenarios, preparing Functional and Technical Specifications for conversions, Interfaces.
• Analyzed the procure to Pay cycle and the Feeder system interfaces to AP, PO modules and modified the interfaces to accommodate R12 changes.
• Conducted Project Reviews at different stages and setup regular meetings with Business stake holders.
• Led the data cleanup project to identify duplicate and invalid data of Suppliers, Customers. Worked with Client and prepared methodologies for data cleanup for a smoother migration.
• Setup new payment templates, Configured Payment batch setups for creating payment batches from single concurrent program which reduced man hours spend every day by payment team.
• Designed new Cash reconciliation process to reconcile cash balances with Treasury/Bank and designed reports to identify discrepancies in remittance.
• Reviewed the SLA setups and verified accounting entry generation for sub ledger modules.
• Reviewed the data and worked with client for interface table cleanup, unused data cleanup and improved performance of interface programs.
• Reviewed the existing responsibilities and analyzed security and audit compliances and designed new responsibilities for specific menu, form, and reports accessible for specific set of users.
• Designed new processes and reports to reconcile the account balances between subledger modules AR, AP, PO and General Ledger which helped client in the account balance reconciliations.
• Conducted MOCK test cycles during different phases of project and resolved the defects during testing.
• Worked closely with OBIEE implementation and designed new reports for identifying payment exceptions, Total Income and collections, Open receivable balances, aging reports, Dash board counts to provide Metrics.
• Prepared the training materials for standard business process and conducted training to end users.
• Worked with QA team and designed the test scripts for standard functionalities in AP, PO, AR, GL, iProcurement modules and coordinated the testing cycles with customer during IT, UAT cycles.
• Provided post upgrade support and interacting with Business users on Issue resolutions and stabilization.

Senior Functional Analyst

Confidential

Responsibilities:

• Involved in full life cycle implementation of Travel payment system “Concur” and integrating it with Oracle P2P modules. Designed interfaces from Concur Travel payment system to oracle EBS.
• Designed interfaces from Concur Travel payment system to PO modules and designed processes to provide real time funds availability for recording obligations.
• Setup the CTX payment formats to process payments and reconcile payments, fees, and commission from Bank issuing Employee credit cards.
• Led a project that replaced the manual processes with the automation of payment and collection processes and integration of Oracle Order to Cash and Procure to Pay cycles with third Party Travel payment system MACCS that replaced the resource intensive manual process of processing payments and collections.
• Designed the vendor setup and default charge accounts for Travel card payments, approval processes to facilitate the travel payments to Oracle procure to pay modules.
• Developed ADI templates to load Journal Data to GL module. Setup new Cross Validation rules.
• Setup up Job positions, Approval hierarchies for Requisition creation and Approval in iProcurement.
• Developed interfaces to process Payroll payments and prepared reconciliation programs with Feeder Pay roll system and processes and designed processes to identify issues in Budget document Approvals.
• Resolved issues in Draft revenue in Projects and resolved reconciliation issues of Projects with AR and AP.
• Assisted client in Migration of Business intelligence reports from Oracle Discoverer to OBIEE suite and involved in the design of new reports and Dash boards.
• Worked closely with Client in identifying key reports from P2P and O2C cycles, GL, HR, Projects modules and designed functional and technical specification documents.
• Designed interactive Dashboards with drill down capabilities for Daily metrics to display Transactional volume, amounts in key areas of AR, AP, PO, GL modules.
• Coordinated the Unit testing, IT, UAT test cycles with users, designed project plans in communicating to client for test readiness.