We provide IT Staff Augmentation Services!

Oracle Technical Consultant Resume

OBJECTIVE:

To secure a challenging position in a well established organization where my knowledge and experience as an Oracle Techno Functional is shared and encouraged. And more importantly to understand the business, so as to pursue a challenging career such as a Business Analyst, which will provide me an excellent working environment & growth opportunities and better business to the organization.

SUMMARY:

  • Currently working as a Technical Lead in Support/Enhancement project
  • Completed end to end implementation as a Technical Lead for Canada,Korea and ROW (Australia and China) Rollout
  • Trained On SQL, Pl - SQL, D2K Forms & Reports
  • Worked in OLM production support project
  • Worked in an Oracle apps R12 upgrade project
  • Worked in an Application Support project as Oracle Apps Technical Consultant.
  • Worked as an onsite coordinator/Onsite technical lead
  • Having good knowledge in SQL, PL/SQL, Oracle Forms & Reports, XML reports, Discoverer reports, UNIX, Shell Scripting & Oracle Apps.
  • Have a good understanding of business processes in Supply Chain Management - Purchasing, Invoicing, Shipping, Inventory, Order Management (OM) and Oracle Lease Management (OLM).
  • Having Basic knowledge of OAF
  • Have worked on performance tuning
  • Worked in Reports, Interfaces in RICE components
  • Having positive attitude with problem solving ability.
  • Excellent communication and interpersonal skills.
  • Flexible to work with environment and tools.

TECHNICAL/FUNCTIONAL EXPERTISE:

  • Oracle E-Business Suite (EBS)
  • Oracle Apps
  • O2C
  • AR
  • AP
  • GL
  • OLM
  • Programming: SQL/PLSQL
  • Basics of UNIX
  • Oracle 9i, Oracle 11G
  • Unix, Windows7
  • Sql*Plus
  • Toad
  • Oracle Reports Builder
  • Oracle Form Builder
  • SQL Navigator
  • SQL developer
  • BMC Remedy,HP ALM, Marval
  • Star Teams
  • STAT,PVCS

Employer 3: Mindtree

Confidential

Oracle Technical Consultant

Responsibilities:

  • Completed Canada, Korea and ROW (Australia and China) Rollout as a Technical Lead successfully.
  • Canada, Korea and ROW Rollout is 1.5 years implementation for EBS and I am the single point of contact from onsite to gather the requirements and delegate to offshore team (6 members). I have also worked on development for Canada Rollout
  • Working on Enhancements for US and UK
  • Working on support related activities like fixing complex technical issues
  • Participating in daily status call with offshore.
  • Worked on US CFD reports. It is a new report created for Ship confirmation.
  • Working in Interfaces, PLSQL and BI publisher reports
  • Had done the setups for OTTT phase 1 for Regions and zones, In-transit times setup and understood the functional flow for OTTP project
  • Have worked in Simulation and Reservation program major enhancements. Know the complete functional knowledge of Reservation program
  • Currently more into techno functional stream and understanding the complete business concepts and trying to move as a pure functional consultant in O2C track.
  • Preparing the test cases and test case scenarios by myself and performing the testing for enhancements which i am doing.
  • Worked on DSG automation process enhancement
  • Worked in Performance tuning of PLSQL programs and SQL queries
  • I am the only resource in this project since it starts. Joined the project when the team size was 3 and now the team size is expanded to 25.
  • Prepared Application handbook for the project which is a technical reference guide for all the custom objects
  • Was part of the transition phase when the project is transited from other client to Mindtree.
  • Has given the KT for all the new resources who joined after me.
  • Have worked on customizations of Modifiers and Qualifiers
  • Have worked on O2C, P2P and FIN tracks.
  • Involved in the process of preparing Migration documents and migration scripts from QA to UAT instance and then to production
  • Involved in preparing MD70 for the development and the unit test cases
  • Worked on UNIX shell scripting for the process of sending Emails, submitting the customer facing reports and for the preparation of migration scripts etc.
  • Worked on the enhancement of Reports for Check printing, AR Invoice Layouts and Remittance reports

Confidential

Oracle Technical Consultant

Responsibilities:

  • Worked as a senior techno functional consultant in production support (R11 and R12) and offshore lead for Italy interface activities
  • Worked in Interfaces, PL/SQL, XML Publisher, Discoveror reports
  • Participated in Weekly status call with clients all over the globe.
  • Taken care of all minor enhancements in project
  • Had automated the Italy Maxiwin process in AR interface
  • Had worked in performance tuning of Discoveror reports

Confidential

Oracle Techno Functional Consultant

Responsibilities:

  • Worked as a senior techno functional consultant in R12 upgrade
  • Retrofitted all the components like views, packages, OAF pages etc

Confidential

SCM Techno Functional Consultant

Responsibilities:

  • Worked as a senior technical consultant and recently as a offshore lead in MLS team. Involved in production support for MLS, MR & MSS.
  • Worked as a Master Register team lead and performing all the tasks related to MR.
  • Worked as an onsite coordinator/Onsite technical lead in Finland from Jan 2011 to July 2011 (6 months)
  • I am the only resource in this project since it starts. Joined the project when the team size was 4 and now the team size is expanded to 14. Prepared System Maintenance Technical Design (SMTD) for the project
  • Was part of KAP (Knowledge Acquisition Phase) and the transition phase when the project is transited from Accenture to Confidential .
  • Has given the KT for all the new resources who joined after me.
  • I was single handedly driven the MLS 11 G upgrade activity and successfully completed from onsite (Finland) which was a 1 year activity which involves the upgrade of all the 14 MLS databases to 11 G. It was a challenging task to coordinate all the key users of 14 countries, third party teams, HP team who is responsible for doing the 11 G upgrade and the team to do the 11 G testing.
  • Got appreciation from Service Managers (SM) and Operation managers (OM) for successful completion of 11 G upgrade activity.
  • Completed database migration activity successfully from onsite.
  • Presented the weekly meeting to the client (SM/OM) and updating the weekly status of the application.
  • Involved in Application Maintenance activities for MLS/MR application.
  • Have worked on BO reports, have run & fixed bugs in BO report queries on customer demand.
  • Have worked on Infoview reports to fetch and run sales and inventory reports which is a monthly activity for this project.
  • Was involved with colleagues in translating the functional sketch to System Maintenance Technical Design (SMTD) and in the process gained very good functional & technical knowledge of the order management module.
  • Got well acquainted with critical areas of the Enterprise Resource Planning via: Sales Order Processing, Contracts, Purchase Order Processing, Registers, Hardware Repair Service, Inventory Management, Delivery Database Management, Invoicing, and Delivery & Forwarding as MLS covers all of them.
  • Helped new comers with the trainings and the customizations in the project.

Confidential

Developer & ERP Techno-functional Consultant

Responsibilities:

  • Have worked on O2C, P2P and GL tracks.
  • Worked on the development of Reports for AR Invoice Layouts, Dunning Letters, Separate Remittance Reports, VAT Report Direct Debit, BAFI Report and Customer statements etc. for Euro next UK, Euro next Netherland, Euro next Portugal, Euro next Belgium and Euro next France Go-Lives.
  • Have worked on AR Interface.
  • Worked on RAAMS (Reports Administration and Account Management System) - a mini project in O2C track
  • Have worked on the development and enhancement of Reports and XML Publisher.
  • Involved in the process of preparing Instruction documents and migration scripts from QA to UAT instance and then to production.
  • Worked on UNIX shell scripting for the process of sending Emails, submitting the customer facing reports and for the preparation of migration scripts etc.
  • Understanding the existing Confidential system and its legacy systems.
  • Preparation and review of design documents to describe the analysis done and the changes required for the integration.
  • Preparation of MD120, MD70, CV60, CV70 and TE20 documents.

Hire Now