Oracle Developer
Resume:
Arvind Solanki (Charlotte NC)
Phone: +1-269-***-**** Email: adcr6c@r.postjobfree.com
LinkedIn: https://www.linkedin.com/in/arvind-solanki-77745b33
Experience Summary
Oracle Applications Techno Functional Consultant with over 8 years of experience in implementation, upgrade and customization of Oracle e-Business Suite Applications. This includes system study, design, development, post implementation maintenance and support of Oracle EBS 11i/R12
Profile Summary:
Extensive experience in Implementation, Migration, Customization, Production Support of various modules in Oracle Applications(EBS) with major focus in Inventory (INV), Order Management (OM), EDI integration (E-Commerce), Release Management (RLM), Advanced Pricing,Purchasing(PO)
Oracle Global Techno-Functional Development and Production Support in Oracle process cycle like Order to Cash (O2C).
Oracle conversions using Oracle APIs and Open interface programs in various modules, Customer masters(TCA), Item masters, categories, Orders, POs, ASL, cost, BOM etc.
Experience in creating Business Requirements Definition Document, Technical Design Document, Test Plan for Custom Applications designed and developed in integration with Oracle R12/11i.
Good Technical Development skills with hands on working experience on (Reports, Interfaces, Conversions, Enhancements, Workflow, Forms) RICEW Components in the domain of Oracle Applications E-Business Suite.
Worked on AOL and System Administrator Tasks like Creating Users, Responsibilities, Menus, Request Set/ Groups, Value sets, Key Flex fields, Descriptive Flex fields, Profile Options and Concurrent Programs.
Exposure to Account Receivables (AR), Account Payables (AP) modules.
Extensive Knowledge of code migration and version control tools like Kintana and Clearcase respectively.
Highly experienced in XML/BI publisher reports having developed more than 15 reports. Created XML Templates (RTF/XSL-FO), XML Data Definitions and Bursting files using Reports 6i/10g.
Hands on experience on Oracle application Testing Suite (OATS).
Highly experienced in Loftware label design and development, testing using third party software tool Loftware and its integration with Oracle.
Exposure to OAF framework and knowledge of AIM methodology.
Experience with Oracle and other Utilities: SQL Developer, PL/SQL Developer and SSH client – Putty and WinScp
Provided on-call and day-to-day support and worked as a part of team in 24x7 production environment
Good knowledge of Incident management, Change management and Problem management.
Ability to work effectively with Oracle Support to resolve Service Request (SR) issues
Knowledge of Oracle Metalink functionality/technical support area to aid in resolving application problems and finding solutions.
Proven ability to quickly learn and apply new technologies with strong technical background
Excellent analytical, problem solving skills and ability to follow through with projects from inception to completion.
Good team leading skills with onsite direct client interaction experience of five+ years in US
Technology:
Oracle Applications: Oracle Applications 11.5.x/R12
Oracle Technical: Application Object Library (AOL), SQL, PLSQL, Oracle Reports, Oracle Forms, OAF, XML Reports, Data Conversions, Oracle Interfaces, EDI
Oracle Tools: JDeveloper, Oracle Reports Builder 6i/10g, Forms Builder 6i/10g, Pl/SQL developer, Clearcase, Kintana, Data Loader, XML Publisher
Database Tools and Utilities: SQL*Plus, SQL* Loader, WinSCP, Putty
Operating Systems: UNIX, LINUX, Windows
Projects
1)
Company: TTI Floor Care
Project: TTI Enhancement project
Duration: Jan 2019 - Till Date (Charlotte NC)
Description: The project consisted Small Projects and Daily firefighting.
Roles: Oracle Applications Techno Functional Consultant (SCM)
Responsibilities:
Designed and developed a custom solution for EDI request for routing (753/754) and integrated Amazon, Walmart and The home depot. Developed inbound and outbound custom processes. Project just went live with really good success.
3PL integration customization for one our Inventory Organization.
Created new customization for integrating the new supplier requirements using EDI 850, 856 and 810.
Enhancement project done on Oracle WMS with automating all the shipping paperwork and label printing which also include great performance tuning.
Training three associates in the team on Oracle technical as well as functional areas including my current supervisor.
Working on WMS implementation project currently.
2)
Company: Fujitsu America (Client – TTI Floorcare)
Project: TTI Enhancement project
Duration: May 2017 – Dec 2018 (Solon OH)
Description: The project consisted of Support and enhancement activities.
Roles: Oracle Applications Techno Functional Consultant
Responsibilities:
Developed PL/SQL scripts and Conversion Programs to Validate and Import data from legacy systems to Oracle applications using interface programs and APIs.
Designed, developed and tested various Oracle/XML/BI publisher reports for users to provide access to their daily activity, errors and to resolve the errors. Worked on Oder detail reports, pack slip report, Oracle order import error report etc.
Converted customer data, items, categories, cost, price list and price etc. using Oracle APIs and open interface programs from existing system, gathering requirements, documentation, design, development and implementation to new system.
Worked on loftware labels for different customers as per their requirements and supported various existing interfaces.
Completed Master data assessment project for Value Chain Planning project independently. Recommended the data cleanup on customer’s masters, item masters data.
Worked on third party logistics solution for client including designed, developed, testing and post go live support on interfacing the to and from data with partner (Ryder), this was the big project includes I/O interfaces using xml. Implemented for all the organizations.
Exposer to Oracle financial modules e.g. Account Receivables.
Created program for Price upload with minimal IT intervention, business users can do the upload on their own without needing any assistance from IT.
Worked on Packing slips design with third party integration (CommerceHub) with team to provide technical assistance.
Tools: Oracle Applications, Oracle 11g, SQL Plus, PL SQL Developer, Oracle Forms Builder, Oracle Reports Builder
3)
Customer: Eaton Vehicle Sector
Project: Eaton Mexico Rollout project
Duration: Jan 2016- Feb 2017 (Galesburg, MI, US)
Description: The project was to rollout the business from JDE to Oracle, it has to be rolled out into existing Oracle application ERP. Project has a team of 20 people with expertise in different areas of Oracle ERP, I was responsible for Oracle EDI integration, Release management and Order management as a Techno functional consultant.
Roles: IT Business analyst
Responsibilities:
Primary owner for delivering end-to-end B2B solutions in Oracle applications integrating EDI.
Responsible for the strategic direction of the Electronic Data Interchange (EDI) processes and for managing the design and development of complete integration solutions for customers and trading partners.
Studying from existing system, gathering requirements, documentation, design, development and implementation to new system.
Responsible for complete functional setups in Oracle for EDI, Release management, customers and Order management.
Oracle release management using EDI and manual functions in setting up processing rules, CUM, sourcing rule and planning forecast set setups. E-commerce and XML gateway Trading partner, code conversions.
Work closely with business users and trading partners to gather & analyze requirements, develop EDI/B2B artifacts (design documents, mapping specifications, test cases, implementation guides etc.)
During the implementation project I have implemented ORDERS, ORDRSP, INVOIC, DESADV, SLSRPT, INVRPT & DELFOR message, and Implemented North American customer transactions 850, 855, 860, 856 and 810 transactions.
Implemented the end to end Release management module in oracle including OM, INV, Supply chain planner and E-commerce Gateway for transaction 830,862,866, DELFOR, DELJIT.
Conducted meetings with plant users and shippers and understood existing plant processes.
Created BRD and proposed solutions for development/customization of the components.
Provided user training including the work instruction to the business users.
Functional support, technical support (post production support) and Business support after go-live. - On-site communication with customers and Business teams.
Travelled to Onsite for every milestone including Blueprinting, CRP1, CRP2, UAT and Go-Live to complete the testing rounds and provide post production support at onshore.
Tools: Oracle Applications, Oracle 11g, SQL Plus, PL SQL Developer, Oracle Forms Builder, Oracle Reports Builder, Kintana, Clearcase, Remedy
4)
Customer: Eaton Vehicle sector
Project: Oracle Applications Managed Service Production Support
Duration: Jun 2014- Dec 2015 (Galesburg, MI)
Description: Eaton Corporation is a global technology leader in manufacturing of auto and truck parts. This project encompassed providing managed service support to the business users handling critical business issues and providing timely and efficient solutions to problems of functional and techno functional nature.
Role: Oracle Applications Techno Functional Consultant
Responsibilities:
Resolved diverse functional/technical issues/incidents related to INV, OM, Shipping, Purchasing modules
Provided on-call and day-to-day functional /technical support and worked as a part of team in 24x7 production environment.
Development of Oracle reports/ ad hoc SQL extracts from system to support business requirements.
Developed quick fix scripts to handle data corruption in system.
Worked on fixing issues with Oracle Reports, PL SQL interfaces Customizations.
Supported Oracle modules like – Release Management, Order Management, Inventory and Purchasing.
Worked on Oracle Interfaces, workflows and xml reports.
Oracle Reports, XML reports, data conversions, interfaces.
Worked on various Oracle APIs to upload the price, customer create/update, Order import, customer site update etc.
Done master data conversion from Legacy system to Oracle i.e. customer, items, item categories, price list, orders etc.
Provided day to day support on Oracle techno Functional – O2C cycle.
Worked on Oracle Forms 6i and 10g.
Designed, developed labels using Loftware, developed 100+ labels including barcode labels.
New trading partner setups for both inbound and outbound EDI transactions.
MRS / Paper Map development.
Worked on EDI outbound Transaction like POO (850), POAO (855), DSNO (856), INO (810), SPSO (830), SSSO (862), PQSO (866).
Testing EDI transactions through order to cash life cycle as well as inbound Planning, Shipping and Sequenced Schedules in Release Management.
Setting up processing rules in Release Management including all OM, Customer, BSA, Forecast sets and every technical and functional setup linked with the RLM module.
Trained core business users including work instruction and documentation.
Incident management, change management and problem management using Remedy application.
Analyzing support tickets for root cause, updating root causes and reporting them in appropriate reports.
Documenting and recording all changes made to any application in the configuration.
Worked on 24*7 support with coordination of offshore team.
Tools: Oracle Applications, Oracle 11g, SQL Plus, PL SQL Developer, Oracle Forms Builder, Oracle Reports Builder, Kintana, Clearcase, Remedy
5)
Customer: Eaton Vehicle Sector
Project: Eaton Southfield Implementation & Support
Duration: Jan 2013- May 2014 (Gurgaon, India)
Description: The project consisted of rolling out the legacy system to Oracle. I have been part of huge team and worked as an Oracle technical associate.
Role: Oracle Applications Technical Consultant
Responsibilities:
Prepared technical design document for development for reports, interfaces, labels and other customizations.
Designed SQL queries to fetch the accurate fields and data from operational instance.
Developed PL SQL logic to call the oracle reports and send the output via email.
Created interactive RTF templates to present data in desired format.
Designed, Developed 25+ labels and assisted core shipping users to perform user testing.
Mapping of the Legacy columns to the Oracle and created Pseudo Code structure of the flow.
Carried out Data Clean-up and processing required in MS-Excel
Developed PL/SQL scripts and Conversion Programs to Validate and Import data from legacy systems.
Converted customer data, items, categories, cost etc. from legacy system to Oracle.
Created data loader scripts for mass load of legacy data into the ERP
Customized XML Publisher Pick Slip and Pack slip reports
Worked with Change Management teams and supported production movement of components.
Attended weekly change review meetings and presented the changes for approval.
Followed Change Management process to ensure smooth migration of changes to live instance.
Used HP Kintana tool for production migration of various components.
Used IBM Clearcase for controlling versions of components to be worked upon in development team
Assisted customers with Post production validation and testing of components.
Provided one month warranty support to business and resolved critical issues.
Handled change requests and enhancement requests to the existing functionality.
Tools: Oracle Applications, Oracle 11g, SQL Plus, PL SQL Developer, Oracle Forms Builder, Oracle Reports Builder, Kintana, Clearcase, Remedy
6)
Customer: Eaton Vehicle Sector
Project: Oracle Applications Managed Service Production Support
Duration: Mar 2011- Dec 2012 (Gurgaon, India)
Description: Eaton Electrical is a global technology leader in manufacturing and distributing automotive and truck parts. The project involved the Oracle managed production support and enhancements of Oracle Applications ERP across various North America and India operating sites.
Role: Oracle Applications Technical Consultant
Responsibilities:
Designed the Technical Design Documents as per the functional doc provided and developed the package procedures for the same.
Developed PL/SQL scripts and Conversion Programs to Validate and Import data from legacy systems.
Implemented the Customer Item Cross Reference Conversion.
Customized XML Publisher Pick Slip and Pack slip reports.
Development of Oracle reports/ ad hoc SQL extracts from system to support business requirements.
Developed quick fix scripts to handle data corruption in system.
Worked on fixing issues with Oracle Reports, PL SQL interfaces, Customizations and labels.
Developed test cases and UAT test plans for ensuring correct functionality.
Tracked and logged solutions in incident reporting tool Remedy.
Worked with Change Management teams and support production movement of components
Followed Change Management process to ensure smooth migration of changes to live instance
Assisted customers with Post production validation and testing of components
Tools: Oracle Applications, Oracle 11g, SQL Plus, PL SQL Developer, Oracle Forms Builder, Oracle Reports Builder, Kintana, Clearcase, Remedy
Education
Degree and Date
College/University
Major and Specialization
Bachelor of Technology (2010)
Rajiv Gandhi Technical University, Bhopal, India
Electronics & Communications Eng
Training & Certifications
SQL certification (1Z0-047).
Certification in Software testing.
Oracle Order Management Certified.
Cincom Training (Configurator) in Cincinnati.
Oracle Fusion Technical Training.
Various trainings on word, PowerPoint, email antiques and technical writing.
Trained on Oracle application framework
Trained in Oracle Application Testing Suite
Awards:
Star of the Month award @ TCS
Star of the Quarter award @ TCS
Services & Commitment award @ TCS
E-STAR award from Customer for outstanding support @ Eaton
Excellence Cheers award @ Fujitsu
Human Language Skills
English, Hindi
Contact this candidate