SUMMARY

• An accomplished professional with over 7 plus years of hands - on experience in Implementation, Upgrade and Support of Oracle 11i/R12 applications, business process analysis, evaluation and integration of internal systems and training the users.
• Experience in implementing, testing, training, live production supporting on various Oracle ERP modules like General Ledger(GL), Accounts Payable(AP), Fixed Assets (FA), Accounts Receivables(AR), Cash Management(CE),, E-Business Tax, Sub Ledger Accounting(SLA), iProcurement, iExpenses, Purchasing(PO), Order Management(OM), Inventory(INV) .
• Two successful ERP implementations including upgrades for large commercial clients.
• Worked on various phases of Software Development Life Cycle (SDLC), such as Project Requirement study, Project Planning, High-level design, Low-level design, Coding, Implementation, Testing and Quality Assurance documentation.
• Strong technical and functional knowledge in business flows like Order-to-Cash (O2C) and Procure-to-Pay (P2P).
• Extensive experience in back end database development using tools such as, SQL*PLUS, iSQL PLUS, TOAD, SQL Navigator.
• Experience in Data Migration from the Legacy System to Oracle Application.
• Experience in integrating and uploading data from the desktop excel spreadsheets using Web ADI.
• Involved in performing Unit Testing, System Testing and Integration Testing using tools in HPQC.
• Experienced in Requirement gathering, Gap analysis, As-Is Process Mapping, Re-Engineering, To-Be Process mapping, Solution design and Application Setup/Configuration.
• Worked extensively on designing functional documents for various customizations, Data Conversions, Interfaces to third party systems, Reports, Workflows etc.
• Strong knowledge of financial accounting including Key Commercial and Federal Financial statements.
• Knowledge on Sub ledger Accounting (SLA) for managing accounting across Sub ledger transactions to generate accounting entries.
• Extensive knowledge in using Oracle AIM of project implementation methodologies.
• Self-motivated, ability to learn and apply new technologies, well committed to responsibilities, ability to work independently as well as in teams for longer hours.
• Good Decision Making ability with Mathematical Decision Modeling and Analysis to make key decisions in the project, both individual and group decision making.
• Several years of experience in project planning using PERT and CPM methods and MS Project tool.
• Excellent communication, problem-solving and Client Management skills.

TECHNICAL SKILLS

Oracle Apps Versions: R12.1, R12.0.6, R12.0.4, 11.5.10.2 and 11.5.7.

Modules: General Ledger(GL), Purchasing(PO), Accounts Payables(AP), Accounts Receivables(AR), Fixed Assets(FA), Inventory(INV), Cash Management(CM), Order Management(OM), E-Business Tax, Sub Ledger Accounting(SLA), Internet Modules(iProcurement, iReceivables, iPayments) and System Administration.

Processes: Procure to pay, Order to cash.

AIM: BR100,TE020,TE040,MD050,CV040

Databases: MS Access 2000, Oracle 9i, 10g, 11g.

Operating Systems: Windows 8/7/Vista/XP/NT/2000/Linux, UNIX, Sun Solaris.

Office Software: MS Word, MS Excel, MS PowerPoint, MS Project, MS Access

Programming Languages: C,C++,SQL,PL/SQL,HTML,XML,JAVA,PERL,PYTHON.

Tools: Data Loader, ADI, Web ADI, SQL Loader, Win SCP, Toad.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Oracle Financials Techno-Functional Consultant

Environment: EBS R12.1 GL, AGIS, AP, iExpenses, iSupplier, iProcurement, FAH, AR, CE, SLA, EB Tax-Implementation, Production Support and Enhancements.

Responsibilities:

• Prepared BR-100 Setup and Implementation documentation for GL, AP, AR, PO, FA, CM, OM and iExpense & iProcurement modules.
• Analyzed design, customize, configure and test implement detailed Oracle applications
• Perform system analysis, requirement studies, specifications generation, implementing R12 (12.1.1) and system integrations; Develop creative solutions to support business needs, and help determine opportunities for exercising additional application capabilities;
• Assist with functional configurations, implementations, and production support activities; Perform system configuration required to satisfy requests from end-users for fixes, changes, and enhancements to financial/accounting management functionality.
• KBD57 Task - Setup AR, AP for 4 agencies (SWE, TPO, SGB, and SGF) to keep them separate as per Govt. regulation also involved in conversion of Customers and Suppliers for the agencies using Data loader. iExpense Setups: Expense Report Templates, Expense Types, Payment Terms, Pay Group, Payment priority
• Validate DFF Setups for iExpense in AP, GL reports and AP reports in prod and other instances
• In Fixed Assets module, the following work was done. Setups for Asset Category, Location Flex fields and Values, Asset Keys, Additional Fiscal Years, Profile Options, Creating Mass Additions, Posting Mass Additions, Full Asset Retirement Setup, Partial Asset Retirement Setup, Depreciation Setup, etc. and successfully created the Journal Entries, and posted Journal Entries in GL.
• Involved in creating Responsibilities with appropriate menus and functions for specific job roles in GL, AP, AR
• Involved in Regression testing for AR, AP, GL, Pay Terms in AP
• Working on production support issues (24x7) for iExpenses, AP, AR, GL and PO.
• Designed and prepared MD50 for customization of interface to load Journals for Reconciliation.
• Define, analyze, document business and systems user requirements; Configure dimension rules, datasets, balance rules, data sources, loading metadata; Perform data extracts to and from Oracle modules such as GL, FA, AP and AR; Write detailed descriptions of project needs, program functions, and steps required to develop or modify computer programs;
• Design of Accounting Flex Field Structure: Helped in arriving to an appropriate Chart of Accounts structure, which was simple to grasp and yet captured all reporting requirements.
• Implemented AGIS: GL Intra-Company setup: Setup Intra-company Balancing rules, Define balancing API to pick the correct balancing rule, Define Journal Mode(One-to-one, One-to-many, Many-to-many), Define Journal Entry Sources and Categories.
• GL Inter-company setup: Define Inter-company accounts at Legal Entity Level (One-to-one, One-to-many, Many-to-many), Define Inter-company accounts at Balancing Segment Level (One-to-one, One-to-many, Many-to-many), Setup Intercompany Balancing rules, Define balancing API to pick the correct balancing rule, Define Journal Mode(One-to-one, One-to-many, Many-to-many), Define Journal Entry Sources and Categories.
• Security and Cross Validation Rules: Created security and cross validation rules for restricting the use of account code combinations by company and department.
• Conducted user sessions to capture and document current RICE custom objects and provided TO-BE suggestions and documents.
• Developed interface program to Upload items into GL interface tables from Legacy System in Oracle General Ledger and Used SQL * Loader to upload data from Flat Files to Pre-interface table and wrote PL/ SQL Procedures for all the business validations.
• Developed Sales Order Conversion to load Historical Orders Data into Oracle Base Tables.
• Made customizations and new forms in Sourcing module using OAF Framework.
• Was Involved in Monitoring (Application Auditing & Database Auditing) and Trouble Shooting according to the compliance of SOX Act.
• Customized Order Discount Detail Report by adding up two more fields (List Price Subtotal & Selling Price Subtotal) for existing List Price & Selling Price

Confidential, Houston, TX

Oracle Financials Techno-Functional Consultant

Environment: Oracle Apps R12 (AP, AR, GL, OM, PO), Reports Builder 10.1.X, Workflow Builder 2.6.X, Forms Builder 10x, PL/SQL, SQL*Loader, UNIX and System Administration.

Responsibilities:

• Analyze design, customize, configure and test implement detailed Oracle applications and modules including AR, AP, GL, iExpense, FA, ebtax etc.
• Participated in the Conference Room Pilot sessions to interact with users to analyze the business process and identify the gaps.
• Participated and documented the requirement gathering sessions and analyzed the impact of the changes.
• Gather, manage and document functional requirements for technical customization including workflows and scripting.
• Defined the Functional specifications for setups and reports and transformed the specifications to the Technical Team.
• General Ledger (GL): Designed Set of Books, built chart of accounts, set up cross-validation rules and flex field segments. Defined journal sources, journal categories, Translation of balances from subsidiary units for reporting purposes and consolidation. Defined system controls and Set the profile options for GL, Creating of Sub ledgers and Globalization.
• Implemented AGIS. GL Intra-Company setup: Setup Intra-company Balancing rules, Define balancing API to pick the correct balancing rule, Define Journal Mode(One-to-one, One-to-many, Many-to-many), Define Journal Entry Sources and Categories.
• GL Inter-company setup: Define Inter-company accounts at Legal Entity Level (One-to-one, One-to-many, Many-to-many), Define Inter-company accounts at Balancing Segment Level (One-to-one, One-to-many, Many-to-many), Setup Intercompany Balancing rules, Define balancing API to pick the correct balancing rule, Define Journal Mode(One-to-one, One-to-many, Many-to-many), Define Journal Entry Sources and Categories.
• FA (Fixed Assets): Setups for Asset Category, Location Flex fields and Values, Asset Keys, Additional Fiscal Years, Profile Options, Creating Mass Additions, Posting Mass Additions, Full Asset Retirement Setup, Partial Asset Retirement Setup, Depreciation Setup, etc. and successfully created the Journal Entries, and posted Journal Entries in GL. iExpense Setups: Expense Report Templates, Expense Types, Payment Terms, Pay Group, Payment priority
• Accounts Payable (AP) Functional analysis and setup of AP. Defined Financial and Payable options, Defined descriptive flex fields for additional information for vendors details and invoice transactions and provided solutions for invoice matching. Defined Vendors Banks, sites, quick codes and Interest invoices. Defined payment terms, distribution sets and scheduled payment lines. Set up and schedule recurring payables for invoices paid on a regular basis and automatically remind staff to process recurring payables. Defined prepayments, Expense detail report formats, Invoice structure with taxes, invoice distributions, invoice validations and holds, Recurring Invoices, invoice aging report formats. Set the profile options for AP.
• Account Receivables(AR): Setups for TCA Architecture, DQM, Customer Profiles, System Options, Transaction Types, Sources, Accounting Rules, Auto Accounting Rules, Auto Invoice Line Ordering Rules, Grouping Rules, Receipt Sources, Receipt Classes, Banks, Bank Charges, Lock Boxes, Transmission Formats, Aging Buckets. Define Parameters for Item Validation Organization & Customer Relationship in OM, System Options, Location Flex field, Auto Accounting, Transaction Sources, Transaction Types, Receivable Activities, Remittance Banks, Receipt Class, Receipt Sources, Customer & Sites, Remit to Address, System profiles etc.
• Ebtax Setups: Define Geography Hierarchy Structure, define Tax and Geography Validation, Defining Tax And TCA profile Options, define TCA geography hierarchy, Setting up TCA classification, define tax content services, define tax determination service and analyzing tax requirements. Define Tax Setups (Tax Regime, Taxes, Tax Statuses, Tax Jurisdictions, Tax Recovery Rates, Tax Rates and default tax rules), Define the party tax profile for Legal Entity and Operating Unit and Make tax available for Transactions in AP, AR, PO etc. Define tax accounts and accounting information. Setup lookup codes and tax classification codes, Implemented Ebtax for US as well as Other countries for tax calculations.
• FA (Fixed Assets): Setups for Asset Category, Location Flex fields and Values, Asset Keys, Additional Fiscal Years, Profile Options, Creating Mass Additions, Posting Mass Additions, Full Asset Retirement Setup, Partial Asset Retirement Setup, Depreciation Setup, etc. and successfully created the Journal Entries, and posted Journal Entries in GL.
• Also took system admin and support roles. Customizing various fields, forms and reports was also done for user’s ease of operation

Confidential, Kansas City, MO

Oracle Financials Techno-Functional Consultant

Environment: EBS R12 GL, AGIS, AP, iExpenses, AR, CE, SLA, EB Tax

Responsibilities:

• Involved in requirement gathering and analysis and design of the existing and future application
• Prepared Functional Specification Documents, AS-IS and TO-BE workflows
• Assist in defining and reviewing the functional requirements for the RICEW objects, for instance, existing interface specifications.
• Full cycle implementation of Oracle ERP E-Business Suite Release 12.1.3 (Finance). Successfully completed implementation rollout at
• My focus areas was finance modules implementation (AP, AR, GL, Cash Management)
• Led the complete implementation lifecycle including, requirements gathering, global design workshops, Conference Room Pilot testing, Vertex - Oracle EBS integration testing, User Acceptance Testing (UAT), User Training and Go-live/Month end close.
• Prepared Gap Analysis for new modules
• Re structured approval hierarchy based on company new policies
• Prepared specification for the account generator (Charge account generation) while requisition creation in iProcurement/Purchasing.
• Prepared Current Business Baseline
• Actively participated in ORG and Char of Account discussion in design phase.
• Prepared Finance module configuration document (BR100), Business process (BPO110), Gap detail document, Project approach (PRF110) docs and reviewed those with client’s finance core team.
• Work with the business architect and other planners to assess current capabilities and identify high-level requirements.

Confidential, Petaluma, CA

Oracle Financials Techno-Functional Consultant

Environment: EBS R12 GL, Cash management, CRM, Accounts receivables, Oracle10g, Forms, Reports, UNIX.

Responsibilities:

• Worked on preparing Technical Specification Documentations (MD70) following the AIM Methodology standards.
• Infoprint US Payroll Accounting Transactions - Designed an interface process which accepts flat files containing accounting transactions in a standardized GL inbound interface file from Ceridian.
• Worked on Citibank Bank Interface. Designed an interface to process Citibank statements into Oracle Cash Management. Completed the full life cycle of loading the BAI2 files, importing the statements and reconciling.
• Imported legacy Transactions (invoices) into Accounts Receivables.
• Defined the Invoice import related setups in Receivables across all instances.
• Converted Supplier Bank Accounts from legacy systems and loaded them into Oracle.
• Designed the upload and download scripts to migrate value sets, lookups and concurrent programs.
• Defined various DFF’s, value sets, functions, forms, Messages and lookup’s using application developer & Sys Admin responsibility.
• Infoprint had the need and requirement of having a common shared concurrent program which can be used across the board to process the data files. So designed a UNIX shell script program to process the data files on the server and load it into the pre-interface tables.
• Represented as point of contact from Oracle Technical Team in data mapping sessions.

Confidential, Richmond, VA

Oracle Financials Techno-Functional Consultant

Environment: Oracle 10g, PL/SQL, Forms, Reports

Responsibilities:

• Was responsible for managing 2 billing applications - Batch customer view (BCV) and Error Management System (EMS). Ensured that the applications ran smoothly.
• Was responsible to prepare, track and report the work plan updates to management.
• Worked with End users and project management teams to support IT projects.
• Attended the Project management team meetings and make appropriate decisions on work based on LOE’s. Also monitored and supported the release implementation of all major and minor releases.
• Monitored production and respond quickly to resolve any issues to prevent the down time to bill cycle execution.
• Effectively managed the development team of 6 members including 2 in offshore. Provided daily status updates to Manager. Assigned and balanced the work based on priority, complexity and best interests of the team members. Also provided the evaluation for team members periodically to the manager and resolved any conflicts/differences within the team as they arise.
• Worked with JAD and Requirement analysis and design (RAD) teams to brainstorm the business requirements/issues and designed the best possible solution. Also worked with interface teams to resolve any issues.
• Prepared the detail designs and discussed with team. Reviewed the code, test results and worked on implementation tasks. Helped the team to resolve critical issues. Worked on the development projects when resources are tight and/or when quick turnaround is required.
• Provided 24x7 production, PLT (Production like Testing) environment and X-application support. Investigated production referrals and worked on the fixes. Generated adhoc reports to manager based on client requests. Also supported Disaster Recovery exercise.
• Worked on several performance opportunities and revenue recovery areas by implementing appropriate fixes constantly.

Confidential 

Oracle Technical Development Consultant

Environment: Oracle 9.2, Developer Suite, PL/SQL and SQL, Business Analysis.

Responsibilities:

• Conducted Business Analysis.
• Met with the customer teams, account executives and end users to develop functional requirements.
• Documented the Requirement gathering to configure Applications.
• Developed Screens using Developer Suite Forms.
• Designed various reports based on requirements gathering and analysis.
• Wrote Server side PL/SQL for business functions.
• Created Year End Reports using Oracle Reports.
• Trained the client core team members & end users in the configured solution.
• Prepared well documented user procedure manuals.