We provide IT Staff Augmentation Services!

Consultant Resume

New Jersey, NJ

Summary

  • Over 7 years experience as an Oracle Financial Consultant and Business Analyst.
  • Experienced in full life cycle implementation through Project Development and Deployment incorporating Business Requirements definition, Modeling, Mapping, Gap Analysis, Data Conversion, Validating, Testing, Transition, Migration, Production, Assessments, Refinements, Documentation and Training.
  • Experience and exposure to Oracle Financial R11i & R12 Applications like Fixed Asset, Account Payables, General Ledger, Purchasing and Account Receivables.
  • Certified Oracle E-Business Suite Consultant.
  • Project Management Certification (PMP).

TECHNICAL SKILLS

  • Methodology: Oracle AIM 3.0, Oracle Tutor and PMI Method.
  • Languages: PL/SQL, SQL*Plus, SQL Loader.
  • Relational Database: Oracle RDBMS v 8x, 9x. MS-Access
  • Operating Systems: Unix, Windows 95/98, Windows NT.
  • Hardware: IBM Compatibles, Sun Solaris, HP.
  • Conversion Tools: Application Desktop Integrator (ADI), Web ADI and Data loader.
  • Microsoft Office : Words, Excel, Power-point, Projects, outlook and Visio.

PROFESSIONAL EXPERIENCE

November 2006 – Present Confidential,Senior Consultant

Oracle R12 Fixed Assets Consultant
Understood clients Fixed Asset business process before defining both current and future business requirements
Mapped the Future Process Requirement into Oracle Fixed Asset module and identified the Gaps. Analyzed the gaps and proffered solutions.
Performed set up of the Fixed Asset Application by determining value sets for Categories, Asset Key and Location and set up the asset codes
Synchronized the Asset categories with Chart of Account descriptions and classifications and defined the segments and their values
Carried out set-ups including depreciation default rules for different asset categories.
Defined the prorate calendars, depreciation rate and calendars, fiscal calendars, book controls and system controls. Defined Depreciation methods, rates and ceilings
Guided the users through data cleansing prior to conversion as well as involved in data conversion process for assets including data mapping to open interface tables and processing of the mass additions
Authored the Fixed Assets Test Scripts and participated in Conference Room Pilot(CRP) testing.
Trained users of the application at each stage of the setup and at the completion and full integration with other Oracle Application and wrote Manuals to guide users on day-to-day operation of the application
Observed the production migration and live production to supervised and support users for the first few weeks of going life.
Implementation of Oracle Financial Application
Understood current & future business requirements and developed the Future Business Requirement (FBD) document.
Designed a new Chart of Account structure (with a local statutory segment)
Mapped the Future Process Requirement into Oracle GL/FA module and identified the gaps. Analyzed identified gaps and proffered solutions.
Configured CRP Environment for Conference Room Pilot (CRP) test and wrote test scripts for this testing.
Configured Oracle Environment using Oracle set up steps and clients configuration requirements.
Reviewed test plans and strategies and assured they are executed according to defined plan.
Carry out unit, integrated and user Acceptance (UAT) testing of FA and GL module.
Guided users through data cleansing activities
Converted Legacy Data into Oracle Environment using ADI for FA and SQL scripts for GL
Participate in all quality management reviews as outlined in the validation task overview to ensure adherence to all quality management plans and standards.
Trained Users on the use of Oracle Financial Application and developed training manual for them.
Met deadlines on the delivering of all deliverables (FBD, Set-up Document, Test Scripts, Training Manual etc) required by client.
Managed analysts and consultants by providing daily leadership/directions in addition delivered performance reviews and coordinated trainings of each team members.
Identify and delegate tasks to subordinates.
Reviewed test plans and strategies and assured they are executed according to defined plan.
Ensured adequate sign-off project deliverables completed.
Observed the production migration and live production to supervised and support users for the first few weeks of going life.
Reviewed test plans and strategies and assured they are executed according to defined plan.

Scoping & Phasing of Global Implementation of Oracle Applications

Actively participate in proposal development, at the direction of management, and take a lead role responding to requests for proposal.
Conducted High Level Business Requirement Overview of WHO GSM application and identified the RICE (Reports, Interface, Conversion and Interface) components.
Used Identified WHO GSM High level Business Requirements to drive out PAHO RICE components.
Conducted review meetings with PAHO Subject Matter Experts (SME\'s) in order to have a high level understanding of PAHO business Requirement.
Mapped PAHO\'s business requirements to Oracle Application in order to identify the gaps and drive out new RICE elements.
Identified PAHO RICE components required to determine the variable cost required for PAHO\'s GSM Implementation.
In charge of the cost model required to estimate PAHO RICE components.
Serve as the Engagement Lead on specific client accounts, taking responsibility for pre-engagement planning, execution, and final deliverable.
Provide regular performance feedback as well as deliver timely performance evaluations.
Lead a team of consultants and ensured adequate skill developments.

April 2002 - November 2006 Confidential,
Senior Consultant

GL, FA and AR Data conversions
Developed Functional Specification document for data conversions prior to production deployment
Ensure adequate cleansing of legacy Data prior to conversion into client Oracle system.
Reviewed extract files and ensure that the correlate with the staging table format.
Provided functional assistance to technical personnel writing SQL Scripts for loading into the staging table and interface tables.
Ensured necessary set-ups are in place prior to conversion into the base table.
Ensure adequate validation of data and review of error log.
Provided assistance in error handling; possible reasons and solution strategy
Actively participated in Test Fires to check readiness for Production Conversion.
Assets conversion into Oracle Application using Application Desktop Integrator (ADI)
GL Balances and Journal conversion into Oracle application
Open AR invoices conversion from the client’s legacy system into Oracle application.
Deferred Revenue conversion from the Legacy system into Oracle application
Provided post production support.

Implementation of Oracle Financial Application
Developed Future Business Requirement Document and Test Scripts for FA, AP, and GL.
Reviewed 11.5.10 Oracle Release Documents to assess changes in functionalities between Oracle 11.5.9 and 11.5.10 instance
Managed analysts and consultants by providing daily leadership/directions in addition delivered performance reviews and coordinated trainings of each team members.
Enabled Multi - Org for Client and configured AP, FA, CE, AP , GL and PO on client\'s 11.5.10 instances based on approved Application Set-up Document (BF160).
Defined Business Group, Legal Entity and Operating Unit
Defined Inventory Organization and Parameters
Set System Profiles and security where required
Configured Flex fields to meet client requirements
Ran the Multi-Org Validation Report.
Capture client’s legacy (Lawson) asset number using descriptive Flexfield.
Defined Asset Category,Book Control and System Control.
Asset Conversion using Application Desktop Integrator (ADI).
Used Dataload to Upload data into Oracle Key Flexfield Value Sets.
Trouble Shoot for Oracle Financial Applications problems.
Unit, Integrated and User Acceptance testing
Delivered BR 100 and Test Script Document.
Developed training manual and trained users
Provided post production support.

Oracle Financial Wireline Team Lead
Co-ordinate and facilitate Wireline regression test activities between SBC clients, SBC IT, and Offshore regression testers.
Obtain functional requirement for new/modified system functionality and handoff to offshore counterpart.
Ensure adequate knowledge Transfer(KT) between SBC Subject Matter Experts and Offshore Testers.
Manage test data development between SBC IT, SBC clients and offshore regression testers.
Ensure test scenarios, scripts, and results are passed to SBC IT and SBC clients for regression test sign-off.
Coordinate defects/issue tracking and resolution process.
Coordinate test environment maintenance activities with SBC IT and SCM (refresh, downtime).
Support SBC application inquiries and investigations.
Ensure Wireline team compliance with existing SBC process controls, tools, and methodologies.
Involved in the setup and use of test director for storage of test scripts/cases and defect tracking
Understood current SBC business and system needs and apply where appropriate.
Set System Profiles and security where required.
Issue resolution and determination of all testing environment requirements and tools
Organize conference calls and web conferencing as required.
Participate in all quality management reviews as outlined in the validation task overview to ensure adherence to all quality management plans and standards.

Oracle 11i Fixed Assets Consultant
Understood clients Fixed Asset business process before defining both current and future business requirements
Mapped the Future Process Requirement into Oracle Fixed Asset module and identified the Gaps. Analyzed the gaps and proffered solutions.
Performed set up of the Fixed Asset Application by determining value sets for Categories, Asset Key and Location and set up these asset codes
Synchronized the Asset categories with Chart of Account descriptions and classifications and defined the segments and their values
Carried out set-ups including depreciation default rules for different asset categories.
Defined the prorate calendars, depreciation rate and calendars, fiscal calendars, book controls and system controls. Defined Depreciation methods, rates and ceilings
Guided the users through data cleansing prior to conversion as well as involved in data conversion process for assets including data mapping to open interface tables and processing of the mass additions
Authored the Fixed Assets Test Scripts and participated in Conference Room Pilot(CRP) testing.
Trained users of the application at each stage of the setup and at the completion and full integration with other Oracle Application and wrote Manuals to guide users on day-to-day operation of the application
Observed the production migration and live production to supervised and support users for the first few weeks of going life.


Oracle 11i Account Payable Consultant
Worked with the client team in understanding the Business Process to prepare the Business Requirement definition document
Mapped the Future Process Requirement into Oracle AP module and identified the gaps. Analyzed the identified gaps and customized clients expense authorization form.
Carried out all the required set up steps of the Accounts Payable Module
Carried out migration from Legacy to Oracle by working with the developers to identity various tables in oracle database that the legacy data are to be transferred
Checked and ensure data integrity before and after migration to Oracle application.
Defined payment terms and hold/release names
Set up employee expense templates and distribution sets.
Set up the Approval and Authorization limits in this module.
Set Vendors quick Codes and defined the payables options
Set up various types of Suppliers and Banks for AP use.
Participate in the migration of the legacy data like suppliers and open invoices into oracle AP module for production.
Performed unit and integration tests.
Participated in the Conference Room Pilot Test for all the modules implemented by the client
Led client Team to carry out Accounts Payable period end closing
Trained Users during and after the implementation on data entry, processing and close of month end activities.


MAY 1993 – December 2001 Confidential,

Forcados Terminal
Environmental/laboratory Management Supervisor

Analysis of pollutant indicators in effluent and produced water
Analysis of crude oil samples for BS&W sludge content, Total Hydrocarbon Content.
Ensuring compliance with environmental laws and regulations
Development of compliance chart on a monthly, quarterly and annual basis
Liaison with Directorate of Petroleum Resources on environmental regulations affairs
Regular HSE audit of Terminal facilities and contractors
Conduct of hazard and effect management exercise and certify that risks are managed to ALARP.
Emergency responses to oil spill incidences and remediation of oil impacted sites.
Writing and submission of monthly environmental and HSE performance report.
Co-ordination of Waste Management affairs for the Terminal
Setting and ensuring compliance with Waste Management targets.
Processing and handling of invoices submitted by contractors for jobs done
Logging of Monthly Manpower Statistics and coordinated Oracle Training classes

Corporate Training/Human Resources Department
Training Administrator.
Nomination of staff for training according to stated regulations.
Arrangement and coordination of nominated staff logistics at training venues
Liaison with Training company/firms on training matters.
Coordinated Oracle financial trainings and HSE trainings.
Ensuring optimum recovery of training cost from Industrial Training Funds
Handling of other administrative matters and submission of Monthly updated reports to Industrial Training Funds
Logging of Monthly Manpower Statistics and coordinated Oracle Training classes

Education

B.SC Biochemistry
M.SC Chemistry

Hire Now