shekhargtm045

SHASHI SHEKHAR GAUTAM
Oracle Application Consultant
971554344696, shekhargtm045@gmail.com
Burdubai, UAE- 122002

Overview
Oracle Application consultant with experience of 13 plus years of in Oracle database and 7 years of Oracle ERP suite. I am highly flexible, optimistic and looking to grow my skills and knowledge. I have worked in a highly pressurized environment and made sure quality is delivered in time.
Experience

Infogain Systems   from Apr 2009 – Nov 2009
Role: Oracle Technical consultant
Designation : Project Trainee

⦁ Worked as technical consultant while implementation of Oracle Application R12 for the client ZipZoomFly.com (USA) Offshore Development of various logical implementations in the PLSQL package, PLSQL procedures to ease the conversion process and data cleansing. Developed Order management API for conversion of data into oracle application ERP suite.

Clover Infotech from (Nov 2009 – Jul 2012)
Role : Oracle Application Technical Consultant
Designation : Consultant
⦁ In a short period of time managed to understand requirements, analyzed, and provided solutions to   AFL, Birla Sun Life, HSBC Bank, ICICI Bank, Integrion –clients of Clover Infotech Private Limited for Oracle Application R12.
⦁ Teaming up with KPMG India, completed implementation as a technical consultant, and achieved complete conversion (supplier,employee,Gl,invoice, interface, and reports (discoverer, Developer 2000, XML report) in the given timeline.
⦁ I worked as a support consultant after implementation was completed. Provided full fledge solutions to the stakeholders keeping in their mind about the timeline and quality.
⦁ HSBC bank in collaboration with Taj Hotel, Mumbai wanted to develop a payment gateway, where accounts payable (TAJ Hotel), Oracle application gets processed. The requirement was to develop IAT, NEFT, RTGS, ICO, IDD, and ACC. Completed the project as per the requirement of HSCB Bank.
⦁ Developing onsite and providing client Oracle Application ERP support using SQL queries, PLSQL Packages, Forms, Reports, Interfaces, and Conversions. I make sure the object I develop is well optimized while in the phase of development itself.

Professional Computer Systems from (Sep 2012 – Dec 2014)
Role: Oracle Technical Consultant,Trainier
Designation : Sr Analyst Programmer
⦁ Parallelly worked as support consultant for Inland Revenue department Nepal along with Development of Banking software using Oracle Forms, Oracle Reports, PlSQL , Package, Procedures. Always made sure the delivery was done on a timely basis.
⦁ Technical Training on oracle Application Ebusiness suite to the user of Nepal Telecome.

Nepa soft Solutions Pvt Ltd        From (Dec 2014 – Nov 2015)
Role: Oracle Application Technical Consultant
Designation :Sr Software Engineer

⦁ Achieved full fledge development for Oracle application AP, HR, GL reports as per the client requirements. Always got appreciation and recommendations from Nepal Telecom PVT limited .
⦁ Developed and customized SQL queries, PLSQL Packages, Forms, Reports, Interfaces (RICE Components) and prepared various documents and made sure of timely delivery.

LIS Nepal       From (Nov 2015 – Apr 2017)
Role :              Oracle Technical Consultant, Project Management, Delivery, Hiring
Designation : Associate project manager

⦁ Initiated and completed data conversion from Matahari, Indonesia, RMS to Retail analytics for further development of OBIEE reports. The data ingestion project script creation was fulfilled ahead of its timeline.
⦁ Initiated the document management system at LIS for knowledge sharing. The company was using many tools while lacking a proper document management system. The document management system holds all of the tutorials, technical documents, and functional documents enabling the developer to access it when required.
⦁ Worked on Oracle Data integrator project for data conversion

Cotiviti Nepal    From (May 2017 – May 2023)
Role :              Development, Project Management, Delivery, Hiring, Team sizing, Training
Designation : Senior Software Engineer

⦁ Accomplished GDIT data conversion project using PLSQL packages, functions, procedures, and DDL with in-depth business requirement analysis, architecture, design, and team collaboration which helped Cotiviti acquire existing clients of Global Dynamic Information Technology USA and grow its business extensively.
⦁ Accomplished full fledge QA with Automation for HEDIS ERP software being developed and upgraded by Cotiviti for its internal business. Always made sure product is tested, given demo, collected feedback, communicated with all stakeholders, automated, and submitted in each sprint within the timeline resulting in the project being always ahead of its competitors.
⦁ Involved in DevOps tasks for different business clients of Cotiviti systems private limited, facilitating teams to complete the entire process within the timeline and with accuracy. The team size in Nepal for Dev Ops grew from 3 to 15 within two years duration.

Freelancing Project in Oracle Application
June 2023 (One month)
⦁ Client wanted to reverse their account receivable invoices in Oracle Application Ebusiness Suite, by applying credit memo for late fees when payment has been made in given criteria. I developed the oracle package using oracle supplied API to un-apply  payment and apply credit memo when the criteria have been met.
⦁ Client wanted to develop AR invoice interface which I achieved using oracle supplied API and plsql package.

Skills
Oracle 11i, SQL, XML report, Form Customization, Form Personalization, Oracle Report, Oracle AP, Oracle GL, Oracle HR,PLSQL package, functions, procedures, triggers, DDL, DML, DCL, Data Ware Housing, ETL, ELT, QA, Data Migration, Data Conversion, Interface, Oracle API, AGILE, Oracle Application E-business Suite, Test Complete, Database Analysis, and Design, DevOps, Support, HIPAA, Client Communication, Mentoring, Training, Documentation, Report development and customization.

Education
⦁ Bachelors  Of Computer Application (2003-2007) Software Engineering, Purbanchal University, Nepal
⦁ Pursuing IMBA (May 2023), from Capital University College, Sharjah.

Certifications & Courses
11i e-Business Suite Essentials for Implementers Ed4 from Oracle University

Personal
Date of Birth: 7 November 1985

LinkedIn
Shashi Shekhar (Shashi Shekhar Gautam) Gautam | LinkedIn

Blog
Oracle application ERP (shashierp.blogspot.com)

GitHub
shashishekhar-gautam (shashi shekhar gautam) (github.com)