SUMMARY

• Over 15 years of progressive experience in Oracle implementation, Upgrade & Support
• All stages of life cycle - Requirement Gathering, Solution Design, GAP analysis, Custom development, System configuration, Test Plan Cycle, CRP, UAT, and Project Coordination activities.
• Extensive experience in all SDLC life cycle stages including requirement gathering, solution design, GAP analysis, custom development, system configuration, test plan cycle, CRP, UAT, cut-over and project coordination activities.
• Involved in implementations, version upgrade, data conversions, production support and customization of reports and forms in Oracle Applications
• Implemented Oracle Applications 11i / R12 Functional Architecture and Design
• Advance Supply Chain Planning (ASCP) / Replenishment Planning
• Field Inventory Optimization (FIO), Demantra
• Equipment Planning & Logistics (EPL) / Oracle Demand Planning (ODP)
• Inventory (INV)
• Order Management (OM)
• Purchasing (PO)
• Appworx Admin (UC4) Implementation
• Experience in Oracle Business Accelerators 11i / R12 Release
• Leveraged Strong Process knowledge and implementation of Order-to-Cash, SCM / ASCP / JDA / Demantra / OFSLL Modules business processes.
• Functional Design
• Customization
• Test Planning/Script Generation
• Integrated System Testing, UAT, SIT
• End Users Training and Preparing User Guides
• Knowledge in BOM / WMS / TCA & AIM Methodology.
• Managed Projects, Enhancements, Patches, upgrades and Production Support.
• Hands-on experience in Upgrades, Conversion/Migration of data from legacy systems to Oracle Systems

TECHNICAL SKILLS

ERP Package: Oracle Applications (R12 / Cloud), OFSLL, Maarsman

Modules: ASCP, EPL, Demantra, SCM, OM, INV, PO, WMS, Shipping, UC4

Databases: Oracle 10g, 11g, Access

Languages: SQL, PLSQL, ANT, Shell, Perl script and Groovy

Application/Web Server: WebLogic 10g, 11g and 12c; WebSphere, Apache Tomcat, Rest / SOAP

Cloud Platform: AWS Amazon Web Services, PCF Pivotal Cloud Foundry .

Tools: PIER, Jenkins, GIT, Docker, PKS, Kubernetes, Bitbucket, Splunk, AppDynamics, Control M

Other Tools: Kintana, Bugzilla, HP Quality Tools, Linux, AOTS Remedy, Appworx (UC4)

PROFESSIONAL EXPERIENCE

Confidential

Oracle Developer

Responsibilities:

• Act as an SME of EIP Interface and coordinate with Other teams in resolving the Critical issues.
• Generating the SQL Script and Deploying PROMO's in the EIP system as and when it comes from Business.
• Implementation of LCA Update based on the Credit Class, Monthly EIP Interest Rates for EIP / OFSLL system.
• Point of Contact for all the EIP Related Server Patching for Every Quarter.
• Defuse hot situations and got quick technical resolution, Identify the issue and either resolve or escalate to the appropriate team responsible for the components affected.
• Timely resolution of Production Support Tickets, including the monitoring, root causes analysis and reporting.
• Developed several reports that help track down the transactions.
• Manage the process of problem response, triage, and remediation as second-tier support for applications issues.
• Take ownership of end user incidents and help requests and be proactive when dealing with user issues
• Manage the Chronic Issue process, driving to resolution, implementing short term fixes and reporting status to proper channels on a defined schedule
• Raising the Bug in case of Show Stoppers issues and co-ordination with Development for getting patches and Updates
• Working the DR drills and experience in bringing up the DR servers live, recording the scenarios of time taking issues in fixing the with all will documented.
• Monitoring and controlling the Alert systems with the help of Grafana, Prometheus and Splunk.
• Experience in writing the scripting and YAML files integrating with the Jenkins pipeline.
• Setting up the Cron jobs in the ControlM tool and engaging the jobs with the alert systems.
• Maintaining the minimal SLA in representing the reliable backend application service.
• Expertise in the routing, holding, and splitting the traffic to multi HA Kubernetes cluster during the time of deployments.
• Designing the layouts in deploying the large number of microservices with zero-down time.

Confidential

Oracle Developer

Responsibilities:

• Working with DBA's in Setting up on non-prod instance for U2L Upgrade.
• Impact analysis in current business process due upgrade changes/enhancements
• Flow Testing for SCM Modules (ASCP, EPL, OM, and INV) to make sure flow is working without any issues
• Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
• Design test scripts of all sub-process identified in assessment phase.
• Working with Perf DBA's in Tuning the Long Running Process.

Confidential

Responsibilities:

• Custom arrival date change notification email
• Custom item reservation notification email
• Custom pending approval notification email for project approvers and market planners
• Custom rejected order notification email
• Custom early warning callout notification email
• Custom Reminder pending approval notification email for project approvers and market planners
• Custom shipped item notification for Engineers, Market planners and Supply planners
• Custom delay pick release notification email.
• Custom On-Hand Discrepancy Between Oracle and TelcoBuy Alert.

Confidential

Solution Specialist - Oracle Business Accelerator

Responsibilities:

• Gathering Business Process requirements from Oracle Partners across industry / country
• Doing the Feasibility study and propose the Internal Customers with Final Foot Print.
• Designing Flow Models (BF020) based on the Business Flows.
• Defining the Project Plan and objectives for the Team members, setting up the Time lines & organizing necessary resources to carry out the tasks.
• Designing of the Data Model and Setup Document (BR100) as per best Industrial Practice
• Co-ordinating with DBA Team for Project Workspace for OBA.
• Identifying required setups in Oracle Accelerators for the Business Flows.
• Identify the Required template in Oracle OBA and Map the questions into corresponding flow families
• Load the setups into Oracle applications from Accelerator (Training Internal / Production Run).
• Flow Testing for SCM Modules (Inv, OM, PO) to make sure flow is working without any issues.
• Raising the Bug in case of Show Stoppers issues and co-ordination with Development for getting patches and Updates.
• Conducting Pre-Project Review & Post Project Review.
• Providing Post Implementation support
• Handling a team of 4 members and responsible for their productivity, efficiency & quality

Confidential

System Executive

Responsibilities:

• Creating Business Scenarios for Conference Room Pilot initiatives to identify the potential gaps in the application.
• Gather Business Requirements and Requirement Analysis.
• Perform process analysis, process design, mapping, and re-engineering, gap analysis and resolution
• Participate in implementation plan meetings to report the status and progress of project
• Analyze and test the patches before being implemented
• Preparation of UAT test scripts & subsequent client sign-off.
• Handling client-side escalations after implementation.
• Presentations to the client side officials about the product and it’s functioning.
• Act as a perfect intermediary between management and the client