Oracle Application Technical Consultant
Freelance project
05.2023 - 06.2023
Hi, I’m
SHASHI SHEKHAR GAUTAM
Burdubai
Summary
Oracle Application consultant with experience of 13 plus years 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 on time.
Work History
Freelance project
Oracle Application Technical Consultant
05.2023 - 06.2023
Job overview
- The client wanted to reverse their account receivable invoices in Oracle Application Ebusiness Suite, by applying credit memos for late fees when payment has been made in the given criteria. I developed the Oracle package using Oracle-supplied API to un-apply payment and apply credit memos when the criteria have been met.
- The client wanted to develop an AR invoice interface which I achieved using Oracle-supplied API and plsql package
Cotiviti Nepal
Senior Software Engineer
05.2017 - 05.2023
Job overview
- Development, Project Management, Delivery, Hiring, Team sizing, TrainingDesignation :, 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
Nepal
Associate Project Manager
11.2015 - 04.2017
Job overview
- 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
Nepa soft Solutions Pvt Ltd
Sr Software Engineer
12.2014 - 11.2015
Job overview
- 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.
Professional Computer Systems
Sr Analyst Programmer
09.2012 - 12.2014
Job overview
- 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.
Clover Infotech
Consultant
11.2009 - 07.2012
Job overview
- 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.
Infogain
Project Trainee
04.2009 - 11.2009
Job overview
- 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.
Education
Capital University CollegeDubai
MBA from International Business Management
05.2024
Purbanchal UniversityNepal
Bachelors Of Computer Application from Software Engineering
2007
Accomplishments
- Helped client reverse late fee payments for 1 million payments resulting in 100% customer retention.
- Helped acquisition of 6 new Clients with PLSQL data conversion effectively, and timely with 99% clean data.
- Document Management System to ease knowledge sharing within the organization which reduced attrition by 40%
- Developed operational reports in Oracle Application R12 to increase the efficiency of business users by 40%.
- Automated QA tasks which helped the team to find out bugs reducing more than 80% of the effort.
- Created HSBC Payment module in Oracle Application accounts payables for payment task automation, reducing processing time from one week to a few hours.
- Incorporated segment description in custom trial balance reports to reduce audit time upto 50%
Certification
11i e-Business Suite Essentials for Implementers Ed4 from Oracle University
Core Competencies
Core Expertise:
- Mastery: Plsql, SQL, XML for seamless Oracle integration.
- Proficiency: Developing, and enhancing Oracle EBS apps.
- Support: Swift issue resolution for streamlined operations.
- Expertise: SQL, PL/SQL, WRICEF, CEMLI, Oracle TCA.
- Integration: OM, Inventory, Financial modules.
- Collaboration: Effective interdisciplinary teamwork, API integration.
- Communication: Clear technical and non-tech interaction.
- Training: Thorough user guidance and documentation.
- Autonomy: Prioritizing tasks, and meeting deadlines.
- Analysis: Aligning business needs with Oracle apps.
- Contribution: Ensuring Oracle EBS financial data integrity.
Broad Understanding of:
- CRM Modules: Depot Repair, Install Base, Field Service, WIP, CRM.
- Integrations: Oracle Integration Cloud (OIC).
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, Oracle EBS Service, CRM Modules, Development, Customization, Troubleshooting, Support, SQL, PL/SQL, WRICEF, CEMLI, Oracle TCA Architecture, Integration, Oracle Integration Cloud (OIC) Cross-Functional Collaboration, Communication, Training, Documentation, Independent Work, Business Requirements Analysis, Financial Data Integrity
Timeline
Senior Software Engineer
Cotiviti Nepal
05.2017 - 05.2023
Associate Project Manager
Nepal
11.2015 - 04.2017
Sr Software Engineer
Nepa soft Solutions Pvt Ltd
12.2014 - 11.2015
Sr Analyst Programmer
Professional Computer Systems
09.2012 - 12.2014
Consultant
Clover Infotech
11.2009 - 07.2012
Project Trainee
Infogain
04.2009 - 11.2009
Capital University College
MBA from International Business Management
Purbanchal University
Bachelors Of Computer Application from Software Engineering
Similar Profiles
Thanet TetthamThanet Tettham
Freelance Graphic Creator at Freelance ProjectFreelance Graphic Creator at Freelance Project
Adil PatelAdil Patel
Business Analyst Intern at Freelance ProjectBusiness Analyst Intern at Freelance Project
KAUSHIK ADSULKAUSHIK ADSUL
Interior Designer at FREELANCE PROJECTInterior Designer at FREELANCE PROJECT
Chetan KumarChetan Kumar
Web Developer at Freelance ProjectWeb Developer at Freelance Project
KRISHNA SHAHKRISHNA SHAH
Sales Manager at Guru Kripa CreationSales Manager at Guru Kripa Creation