SUMMARY:

• 16+ years of total experience in IT, Retail and Accountancy.
• 7 years of experience in Retail Industry.
• 7+ Years of experience as Oracle Financials Functional Consultant.
• Experience in Implementation, customization and testing of Oracle Applications for Financials modules in Food, Finance and Service Sectors.
• Expertise in SQL, PL/SQL and Knowledge of converting legacy data into Oracle Applications using SQL Loader.
• Experience in Implementing, Customizing, and Configuring and post production support of Oracle Applications versions R12.1.3, R12.2.4 and 11i.
• Extensive Functional expertise in Purchasing (PO), Accounts Payables (AP), General Ledger (GL) and iProcurement, iSupplier Portal, FAH, FA modules.
• Experienced in documenting Functional Design Documents (MD - 50, BR-100) and test scripts (TE-40s) following Oracle Application Implementation Methodology (AIM).
• Efficient work experience in leading on-site and offshore teams in implementation and support projects. Extensively worked with business users.
• Experienced in developing test cases to meet the system objectives and involved in System and Integration Test Plans (SITP) and User Acceptance Testing (UAT).
• Responsible for functional support and ad-hoc in respective oracle modules and act as a liaison between technical team and users.
• Proven track record of demonstrating strong analytical and problem-solving skills, proficiency, and ability to follow through with projects from inception to completion.
• Proficient in Microsoft Office (Word, Excel, Outlook, PowerPoint, Visio) and preparing End-User documentation using UPK-Universal Productivity Kit Oracle tool.
• Superior communication, organizational, and interpersonal skills.

TECHNICAL SKILLS:

ERP: Oracle E-Business Suite R12 and 11i, Fusion R11

ERP Functional Modules: PO, AP, GL and iProcurement

Programming Languages: SQL and PLSQL

Operating Systems: Windows and UNIX

Test Management Defect Tracking Tools: Quality Center, QC ALM

Databases: Oracle 8i/9i/10g and 11g

PROFESSIONAL EXPERIENCE:

Confidential, Winston-Salem, NC

Senior Consultant

Responsibilities:

• Requirement Gatherings, Solution and Implementation Design.
• Analyzing Legacy Chart of Accounts structure, identifying the consolidation reporting needs and elimination processes.
• Designing new Primary, Reporting Ledgers for UK, Australia and a consolidation Ledger.
• Designing Mapping, Account Rules and cross validation rules to be configured in Oracle EBS.
• Designing custom FSG reports for Balance sheet - detail & Summary, Income Statement by Business Unit PTD and YTD.
• Designing custom WebADI template to load YTD and PTD Legacy balances.
• Preparing BR100, Test case document, Solution Design Document and User Manual.
• Handling and coordinating change requests from development and moving through SIT and UAT phases preparing weekly status and dash board reports.
• Coordinating with offshore team and allocating tasks.

Confidential, Charlotte, NC

Functional Consultant

Responsibilities:

• Understanding the Current Business Process and re-implementing them As-Is in the newer Oracle Version.
• Identifying redundant processes and/or suggesting improvements to the existing process effectively utilizing features of R12.2.4.
• Weekly meeting with Business Stake Holders regarding Project Status and setting up of expectations.
• Documenting BR100 and TE40’s and liaising with Technical team for custom Code development.
• Designing custom ADF pages with additional features to do away with Oracle Forms for Custom Unpostable Transactions.
• Identifying requirements for custom reports or modify existing reports.
• Handling and coordinating Change Requests from development till moving to production through SIT and UAT phases.
• Coordinating with and allocating daily tasks to offshore team members.
• Responsible for the below components:
• Custom Reversals
• Custom Revaluation
• Custom Allocations
• Mainframe Files to Oracle
• Oracle Extracts back to feeder Systems
• Custom rule based Accounting engine to generate accounting entries integrating third party systems with Oracle GL (FAH).

Confidential

Senior Consultant

Responsibilities:

• Responsible for configuring Fusion Accounts Payables module.
• Configuring Common Options for Payables and Procurement.
• Uploading of Supplier Terms, Payment Terms using ADFdi.
• Setting up of Default Distributions, Distribution Sets, Invoice Tolerances and Third-Party Payments, Invoice Approvals.
• Responsible for preparing Configuration documents, Test scenarios and testing standard functionality.
• Worked very closely with the Business Users and Finance team for on-demand requirements and User Acceptance Testing.
• Conducted Demo session to Management.

Confidential, Atlanta, GA

Lead Consultant

Responsibilities:

• Responsible for identifying the business requirements, creating Functional Design Document, Configuration change requirements, test scenarios and functional testing.
• Solution Design includes populating custom batch name, GL Date, creating CCID’s for new code combinations via API, rolling of entries, netting them further.
• Designing custom Journal Import log sheet for identifying import errors with custom error codes.
• Extended the functionality to also interface Payroll transactions from Workday.
• Client Appreciation for effective design and rolling out to North America and APAC territories
• Successfully on boarded the business users to the new program and prepared guide. Oracle Project Accounting Implementation
• Worked extensively on Oracle Projects Billing Sub module of Oracle Projects. This module implements External Customer invoicing for Contract Projects. It deals with Entering Agreements, Funding, Accruing Revenue and Generating Customer Invoices. This module is highly integrated with Oracle Receivables and Oracle General Ledger Modules
• Participated in business requirements review meetings that the Oracle Projects Customers need to take in areas of Project Costing and Project Billing.

Confidential, Atlanta, GA

Senior Consultant

Responsibilities:

• Responsible for identifying the business requirements, creating Functional Design Document, Configuration change requirements, test scenarios and functional testing.
• Solution Design involved defining new segment-based rules for Project and Natural Account segment for some Asset Related Event classes to generate different accounting values.
• Implementation of General Ledgers for Australia, New Zealand project involves designing new Primary ledgers for Global Payment’s business acquisitions in Australia and New Zealand.
• Responsible for identifying the business requirements, creating Functional Design Documents, Configuration change requirements, test scenarios and functional testing.
• Identifying Intercompany Transactions for eliminations
• Project Scope involves designing primary ledgers, reporting currency ledgers and a consolidation ledger.
• Applying various translation methods for merging results in multiple operating currencies, Accounting for Investment in subsidiaries.
• Designed a new RTF template for automated Payment batch processing for ACH Payments.
• Designed batch processing options and configured payment profile as per business requirements.
• Responsible for identifying the business requirements, creating Functional Design Documents, Configuration change requirements, test scenarios and functional testing.

Confidential, Atlanta, GA

Senior Consultant

Responsibilities:

• Designed a delimited file format based to be on the existing GPSE EFT Bank File Report - PSV.
• Designed custom Concurrent Job which is scheduled to send the extracts bi-weekly to Frontier Systems via DataTrans.
• Responsible for drafting Functional design document, Configuration change requirements document and test scenarios and performed functional testing.
• Solution design involved identifying Premier Merchants who are flagged as ‘NACHA Compliance’ as per business requirements.
• Designed custom solution to include transactions of Premier Merchants to be part of EFTs and ACHs sent to Financial Institutions.
• Designed the solution to add a new field ‘Compliance NACHA’ on the existing ‘Premier Auto Resolve Form’ which enables the end user the facility to flag Premier merchants from NACHA Compliance.
• Responsible for drafting Functional design document, Configuration change requirements document and test scenarios and performed functional testing.
• Responsible for identifying the business requirements, creating Functional Design Document, Configuration change requirements, test scenarios and functional testing.

Confidential, Atlanta, GA

Functional Consultant

Responsibilities:

• Designed csv file layout for extracting Source GL Accounting Flexfield and Supplier Payment terms Data from Oracle to Ariba.
• Design involves incremental extraction for the data that have modified, end-dated along with new additions with separate codes to identify such records.
• Designed csv file layout to extract transactional data like supplier invoices from Ariba to Oracle.
• Configured a custom concurrent request which is scheduled to run daily using using Ariba Integration ToolKit (ITK).
• Sufficient error handling methodology is part of the extraction in case the program delivers unexpected results.
• Preparing Test Scripts scenarios, Configurations and QTP Testing
• Post Production support for two weeks.

Confidential

Functional Consultant

Responsibilities:

• Responsible for enhancing Shopping Cart. There are 3 buttons available which would define the process flow in three different ways.
• Edit Lines
• Edit Lines section is for the user to view all the information of header and lines, edit if needed and submit for approvals. A 2-step process for verifying the correctness of the information and followed by submission for approval
• View & Checkout
• View & Checkout Button functionality is to follow the complete standard iProcurement requisition process of search, select, add, review and submit
• Review & Submit

Confidential

Assistant Manager

Responsibilities:

• Responsible for meeting weekly, monthly and yearly sales targets
• Market Basket Analysis and Customer Data Analysis
• Stock planning, Merchandising, Tracking Deliveries and matching invoices to receipts
• Cycle Counts, Auditing
• Bank and Cash Reconciliation

Confidential

Data Analyst

Responsibilities:

• Spreadsheet Analysis and Perform data collection, data summary reports.
• Preparing the Sourcing Taxonomy
• Perform activities like Data Categorization for Description, Account/ERP Commodity Name, Supplier to meet required SLA as per Customer Requirements
• Perform Quality Check on the Categorized Data using different customized aggregation views and templates for consistency and accuracy.