SUMMARY OF QUALIFICATION
** ***** ** **** ********** with varied domain knowledge in Information Technology, Manufacturing, Educational Institution, Building construction, US Federal Agency, Banking, e-Publishing etc.
8 years of experience in Oracle Financials E-business suite as Oracle Financials Functional Consultant.
Assistant manager for 2.8 years with Corporate Finance experience in auto manufacturing company.
I have done Masters Degree in Business Administration, and Bachelors Degree in Engineering.
SKILLS
Certified Oracle financials Functional consultant. SME of Oracle Financial modules GL, AP, AR, FA, CE, I-expenses. Expert knowledge in Federal Financials, Desktop Integration, Web-ADI, Inventory, Purchase, Cost Management, OM, Sys Admin, Projects Costing, Projects Billing, HR and configurations in other modules relevant to Financial modules
Skilled on varied versions of Oracle 11i and R12 of E-business suite
Savvy in complete cycle of project activities starting from Requirement gathering, BR100, Process flows, Configuration of modules, Testing, Issues handling, Implementation, Training manuals
Chart of Accounts- COA creation and management, Multi-Org, Multiple Reporting Currencies, Web-ADI, Financial Statement FSG COA creation and management, Rules definition like CVR and SR, SLA-Sub Ledger Accounting, Payment Processing, Receipts process design and other AR configurations, Period and Year end process, Multi-Org, Multiple Reporting Currencies, AGIS- Advanced Global Intercompany System, GCS – Global Consolidation System, Financial Statement FSG
Data loader and related applications, TOAD for data extraction, tools for ticket management, Issue tracker, Oracle Metalink, Tools required for project management like Share point
Expertise in Corporate Finance Activities and manufacturing company business processes, like reports generation MIS, Analysis, Budget preparation, Monitoring, Invoices Approval, Account payables, Accounts receivables, Internal Audit response and rectification etc.
Skilled in Microsoft office applications like MS Word, Excel, PowerPoint
Proficient in Document preparation, Presentations, Interactive Training materials, Work flows, Inter-related work sheets
WORK EXPERIENCE
There is a break in my career from Dec 2013 for valid unavoidable reason. Now getting back with work authorization and I’m open to any job opportunity. So here is a deal to hire an employee who got paid $80 per hour at much lower rate.
Oracle financials functional consultant Worked as contract employee through Scopus consulting for various clients by taking projects USA From Aug 2010 to Nov 2013
Client- Haemonetics, Braintree, Massachusetts
Role - Oracle financials functional consultant
Responsibilities- Account Receivables, Account Payables, General Ledger, Interactive training materials preparation
Client- Lockheed Martin – CDC, Federal Agency Georgia
Role - Oracle Administrator
Responsibilities- Upgrade Oracle EBS version 11.5.10 to R12.1.3. Identify the scope of improving system in R12, incorporate oracle prescribed upgrade activities, preparation before upgrade, support during upgrade, testing, post upgrade/ post production support.
Modules worked are General Ledger, Federal Financials, Payables, Fixed Assests, Purchasing, Cost Management, project costing, project Billing, Receivables, Inventory, System Administrator.
Certificate of Achievement in
oIntroduction to Incident Command System
oICS for Single Resources and Initial Action Incident
oNational Incident Management System (NIMS) –An Introduction
oNational Response Framework, An Introduction
Certificate of Training in Records Management
Period end process analysis, design, manage the relevant changes in R12 from 11i which impacts Agency business process, configuration, testing, preparation of user training manuals, preparation of test scripts, guidance and support for User Acceptance Testing. The module involved in this process are General Ledger, Payables, Fixed Assets, Purchasing, Cost Management, Project costing, Project Billing, Receivables, Inventory and Federal Financials
Similarly did Year-end process analysis, design, managing the changes, preparation of documents and coordinate with DBA and Finance team. This involves period end plus other once in year executed tasks, reports generation, new codes, accounts, reports like FACTS I and FACTS II. Federal Financials module has many processes like setting up Funds, Appropriation, Distribution, Transaction types, Treasury Account codes, Federal Account Symbol etc.
SubLedger Accounting configuration to replace Account Generator workflows in 11i as prescribed by Oracle after upgrade. SLA was configured for Fixed Assets transactions, Purchase Orders and Requisitions
Execute Pre-upgrade activity to review open invoices in Payables to Confirm or Cancel transactions by running series of reports like Invoice register, Invoices on Hold report, Unaccounted transactions report
Project Cost Variance analysis pertaining to Expenditure and Project status inquiry forms, Set Reporting Period, Interface Project Manufacturing cost, Projects Cost Collection Manager, Transaction Import, Distribute Usage and Miscellaneous Costs, Update Project Summary Amounts
Actitivies for incorporating IPAC process in Requsitions and Purchase orders for suppliers with Funds Control at IAA level and MOD level. This involves Package and Functions to verify Total amount and control Funds.
Support activities for Production and Development issues, used HP Service center client system and iSupport ticket / tracking system
Client- Fujitsu America - Jostens, Minnesota
Role - Business Analyst -Oracle Financials
Responsibilities- Oracle EBS upgrade project from version 11i to R12 for client Jostens, a company providing yearbooks and class rings. Task is AS IS configuration along with few selected features of R12. I was responsible for financial modules General Ledger, Payables, Fixed Assets, Receivables, I-expenses and Cash management. Activities involved were pre and post upgrade tasks, extensive Testing of upgraded instance, Analysis, Requirement gathering, Application setups, Configuration of new features, BR100 documents and Training Manual preparation.
Upgrade 11.5.8 version As Is to R12.1.3 version adding few new features
Analyze changes in R12 from 11i and take required steps based on client processes
Pre-upgrade activities, Snap shots before upgrade for comparison after upgrade, Configuration in upgraded instance, Handling issues after upgrade, BR100, MD50 Documentations, Walk-through in Oracle EBS for Users
Testing includes Validation test, Smoke test, Core test, Sprint test, testing complete processes in all modules of GL, AP, FA, AR, CE and I-exp.
Service Request SR with Oracle Support, Patch identification and coordinate with DBA for Patch application and testing post patch instance
Reports validation across 11i and R12 versions pre-post upgrade
Printer configuration and testing; Managing Share point and intranet R12 Wiki page
Desktop Integration module in R12 to upload varied Journals and Assets
GL - Journal Import, Drilldown, Define Currency Rates, Translation, Consolidation, web ADI, Various Reports
FA – Sub Ledger Accounting, web ADI, Impairment configuration, Retirements, Reports, Asset Addition, Mass addition, Maintenance, Depreciation
AP – Sub Ledger Accounting, Payment Process Request, Standard and Customized Reports, Tax details for supplier, Supplier merge, ACH Payment, User manual for new processes, DFF Descriptive Flexfield for Bank Account form, Credit card records, TCA validation
AR – Transactions, Receipts, Invoices Application, Transfer to GL, Collections configuration and testing, Time Payment Letter, Reports
CE - Cash Generating Unit, Bank, Branches, Account
I-expenses – Expenses Reports, Testing, Report creation, Approval, Rejection, Expenses export, Audit
Client- CISCO systems, California
Role - Oracle Apps Consultant
Responsibilities- Cisco Systems is a multinational American company in consumer electronics and networking business. I was part of Oracle 11i Financials team in development project. Activities involved were application setups and configurations in GL and AP modules, Preparation of functional specifications documents, preparation of Test scripts, Testing and reporting the Test results
Preparation of AS IS documents after analyzing the instance, along with existing BR100 documents for GL and AP modules
Understanding the requirement through meetings, documentation of minutes of meeting, co-ordinate with technical team, guide technical team with business processes
Functional specifications documents prepared for General Ledger Manual journals, Adjustment Journals, Recurring Journals, Mass allocations Journals
Configuration in GL Application for various types of Journals with respect to BR100
Test scripts preparation involving complete cycle of journal preparation in General ledger and Accounts payables modules
Conduct Test in the instance and analyze any issue that arises, fix the issue and document the test result
New requirement analysis that is put forward in scope of Oracle EBS and suggests the configuration options in Oracle Application along with impacts of choices
Preparation of process flow documentation to explain the business users the Oracle e-business suite flow across modules
Preparation of training manuals for process like generation of journal, preparation of invoices, credit memos, debit memos
Oracle financials Senior.Consultant Infosys Full time employee. Worked on various projects for clients in USA, JAPAN from India as offshore resource INDIA From Jan 2008 to Jul 2010
Client- Elsevier, Missouri
Role - Oracle financials Sr. consultant
Responsibilities- Elsevier is a publishing company which publishes medical and scientific literature. It is a part of the Reed Elsevier group. I was Functional Lead. This is a takeover of an existing Oracle 11i support project. This project includes different applications in use, for clients business needs, inter connected with regular financial modules in Oracle EBS
Support project related activities like Tickets handling. Using tools for this including Issue tracker. Use of Oracle Metalink support
Client connectivity, citrix connectivity activities along with network team
Periodic interaction with client about existing application business processes, requirements, challenges, expectations and scope for improvement
Lead the team, conduct meeting regularly with outgoing vendors who were performing support activities previously
Analyze client’s existing system through instance analysis, review of existing BR100 documents, training manuals and presentations
Perform reverse Knowledge Transfer presentation subsequently using MS office tools including presentation, document and Visio diagram
Guide subordinates and peers in Oracle application, Coordinate onsite and offshore team, Resource allocation chart prepared for offshore team for extended support timing
General Ledger, Fixed Assets module instance analysis and preparation of Application Information Document
Hedging process and foreign exchange hedge analyzed and prepared knowledge material and elaborate power-point presentation
Auto invoice process analysis and process flows design and configuration document. Auto Accounting setup done in AR as per requirement
Impact analysis of configuration and setup changes, Profile menu and option submenu analysis in application
E-tax module configuration study, current tax process analysis. Preparation of Business flow document along with Visio diagram to explain the process
Sub-rights SR module review, instance analysis and preparation of Application Information Document
Upload all relevant documents of project in SharePoint and subsequent maintenance including its versions
Client- Bank of America, California
Role - Sr. Consultant - Oracle Financials
Responsibilities- Bank of America, a leading bank in United States had assigned a team to work on Oracle 11i EBS Financials project. I was handling generation of Receipt, varied purpose Receipts, Partial application of Receipt process in that development project. I was Functional Lead for this project.
Understand the business process of receipt generation according to their day to day operation, the types of receipt, purpose of receipt and other documents inter connected to it.
Regular meetings with client then and there during project
Study of hitherto process in system and expected process, required change, purpose of expected output, scope of improvement in future
Documentation of all the analysis undertaken as separate documents in form of MS documents and presentations
Enlighten the technical team about the clients’ current process, the specific requirement, required changes and expected outcome
Reverse power-point presentation to client about the requirement and development that will be done, along with process flow chart in Visio
Configured the functional part in Oracle Accounts Receivables for the partial application of Receipt. Guide technical team during complete development cycle of new process and configuration
Develop test scripts for the Partial application of Receipt and did extensive testing in instance and further corrections required
Demonstrate the new process configured to the client and obtain feedback
Preparation of User training manual explaining the process flow as a Visio diagram along with a word document
Adherence to Quality of process during entire project, perfect documentation of various developments in project and maintenance of all documents along with numbered versions in designated places
Client- Enterprise Business System Solutions, Japan
Role - Sr. Consultant - Oracle Financials
Responsibilities- Oracle R12 upgrade project for Enterprise Business System Solutions Corporation (EBSS), a joint venture company launched by Toshiba, Accenture and Oracle Japan. This is an end-to-end Oracle manufacturing implementation project for a leading manufacturer of electronic goods. As Oracle Financials SME, I took up specific tasks like Testing AP, CE, AR, GL, FA Modules, Configurations of new features in R12 Financial modules.
Pre-upgrade activities verification for Financial modules
Preparation of Test scripts for Modules Accounts Payables AP, Cash Management CE, Accounts Receivables AR and General Ledger GL.
Conduct Testing of processes and process flows for Financial modules like AP, CE, AR and GL
Analysis of issues that arises during testing and solving the issues, retest the same.
Analysis of new features in R12 and configurations in new instance as per business requirement
Review work meant for preparation to upgrade from version 11i to R12
Testing done for Oracle R12 General Ledger and Cash Management modules configurations
Complete cycle of Bank account creation through AP, including setups in User management
Sub Ledger Accounting SLA configuration for FA, AP, AR modules
Oracle Service Request SR management, Patch identification and coordinate with DBA for Patch application and testing post patch instance
Reports validation across 11i and R12 versions pre-post upgrade
Client- International Baccalaureate, Maryland
Role - Sr. Consultant - Oracle Financials
Responsibilities- The International Baccalaureate is an international educational foundation headquartered in Geneva, Switzerland. Development project was undertaken in Oracle 11i EBS predominantly to re-implement Chart of Accounts in Oracle General Ledger and all major GL setups incorporating various units across globe. I was Functional Lead for this project for team including other financial functional resources.
Analyze new requirement under oracle application provisions in scope of client’s business process and suggest configuration options
Development activities like configuration in instance and usage of other tools and applications for this purpose
Chart of Accounts COA segment values designing along with client through meetings, sending out for review, modification, redesigning and finalizing
Segment definition, COA values addition in test instance using Data loader for various segments for all units
Inter-company configuration and Multi-org configuration
Defined Security Rules and Cross Validation Rules, Tested and Implemented successfully
Configuration of Multiple Reporting Currencies involving same primary currency and different reporting currencies in General Ledger, Accounts Payables and Accounts Receivables of various units
Configurations in AR including types of Transactions, Receipts, Dunning Letters, Defining Tax codes and Rates
Configured and prepared training manual for Web-ADI, Web - Applications Desktop Integrator
Global Consolidation System GCS setup is done
Financial Statement Generator, FSG configuration and preparation of FSG reports
BR100 document for configurations and all deliverables related documents, Test scripts preparation, Testing, subsequent rectification, report Test results
Training manuals prepared and presented for all processes
Lead the team, Guide subordinates and peers in Oracle application, Coordinate onsite and offshore team
Assistant Manager - Finance Ucal Fuel Systems Limited (UFSL) Chennai, India From May 2005 to Jan 2008
UFSL is an Auto-motive manufacturing company. I was centrally managing corporate finance activities of all branches from corporate office.
Generate various reports like account analysis, aging report, handle forms like invoices, payments, receipts, debit and credit memos, journals, perform reversal entries and rectification entries in various modules of ERP Oracle Application 11i
Preparation and monitoring of Company Budget. Single handedly prepared Budget 2007-08 encompassing various units across country. I prepared Zero based budget involving every user department unlike erstwhile procedure of deriving from previous year experiences.
Account Payables activities include Approval of payments, Verification of receiving report, Purchase Order compliance and adjustment of advance payments, Monitoring legal obligations and accounting of transactions
Introduced foreign travel request form to enable cost analysis of various existing products and new product investment analysis
Internal Auditing to analyze the non-compliances, initiate action, rectify the issues on monthly basis. Prepare and present Internal Audit Response Report on Quarterly basis to Audit sub-committee and Board of Directors of company
Monthly Information Statement MIS preparation about specific expenses for Management's internal purpose by data mining in ERP Oracle Application
Accounts Receivables activities including preparation of monthly Outstanding statement, generation of Receipt, Invoice adjustments, manual debit memo, credit memo creation for returned supplies, warranty claims, and price revisions
Created Value Stream Mapping for Material Inward process in manufacturing units. Identified the scope of improving process ratio from current state of 1.51% to 18.0%
EDUCATION HONORS
Bharathidasan Institute of Management http://bim.edu/indexnew/ Trichy, India From Jun 2003 to Apr 2005
Area of Study/Major: MBA Master of Business Administration
Passed out with appreciable CGPA of 3.56 out of 4.0
Thiagarajar College of Engineering https://www.tce.edu/ Madurai, India From Jun 1996 to May 2000
Area of Study/Major: BE Bachelor of Engineering
Endowment prize for "Best B.E. project" in the year 2000
Passed out with appreciable 77.3 %
Technical paper presentation on "construction techniques for high rise structures" in IIT Chennai
Medal for 100% marks in Mathematics in 10th grade board examination