Resume

Sign in

Oracle Management

Location:
San Jose, California, United States
Salary:
125000
Posted:
January 11, 2018

Contact this candidate

Resume:

ARVIND SOLANKI

**** *** ****** **, ******** Heights OH, 44124 M: +1-269-***-**** ac3z2y@r.postjobfree.com

LinkedIn : https://www.linkedin.com/in/arvind-solanki-77745b33

PROFESSIONAL SUMMARY

IT Professional having around 7 years of experience in consulting Oracle applications EBS. Highly skilled in various Oracle modules like Order Management, Release Management, EDI, E-Commerce, Advance Pricing, Purchasing and Inventory with technical expertise. Skilled in specification gathering, design, development, quality assurance testing and troubleshooting. Fluent in English and Hindi.

SKILL SUMMARY

Extensive Oracle Technical experience in development and testing of Oracle application RICE components.

Extensive experience Technical Development skills with working experience on (Reports, Interfaces, Conversions and Enhancements) RICE Components.

Experience in the domain of Oracle Applications E-Business Suite using SQL, PL/SQL Developer, Reports Builder, workflow, unix, BI publisher Reports and Programming/debugging experience in oracle 10g/11g, SQL.

Very good technical experience in Order-to-Cash [O2C].

Experience in data conversion and data mapping from legacy system to Oracle EBS using Oracle interface programs and APIs. Worked on various oracle APIs.

Oracle Technical expert in Oracle EDI integration and extensive experience on EDIFACT, X12 and also worked on other standards like VDA, ODDTTE.

Extensive technical experience in Oracle Application Modules which includes Release management, Order Management (OM), E-Commerce gateway, Inventory [INV] and Purchasing [PO].

Strong Technical as well as functional experience in Oracle release management using EDI and manual functions with extensive experience in setting up processing rules, CUM, sourcing rule and planning forecast set setups. E-commerce and XML gateway Trading partner, code conversions.

Complete mapping logic (MRS development) for gentran and SI, complete testing of I/O and O/B business transactions like 850,860,855,856,810,824,997,820 in ANSI X12 format. Worked on the Oracle interfaces for integration.

Extensive experience on working with various Oracle APIs and experience in Oracle WebADI.

Expert in Oracle Release management with EDI transactions 830, 862 866 as well as DELFOR and DELJIT with complete Oracle setups and customizations for 11i/R12.

Experience in creating Business Requirements Definition [BRD] Document, Technical Design Document [TDD], Solution design documents[BR30, BR10],Test Plan[MD50, MD70] for Custom Applications designed and developed in integration with Oracle R12/11i.

Highly experienced in Loftware label design and development, testing using third party software tool Loftware and its integration with Oracle. Also have exposure to Oracle WMS and shipping process.

Extensive experience working on Incident management, Change management and Problem management. Involvement in developing the best practices for application support and maintenance. Provided on-call and day-to-day support and worked as a part of team in 24x7 production environment.

Experienced in working with Oracle support for functional / technical support area to aid in resolving application problems and solutions.

TECHNOLOGY

Oracle Applications: Oracle Applications 11.5.x/R12

Oracle Technical: Application Object Library (AOL), SQL, PLSQL, Oracle Reports, Forms, Oracle Workflow, OAF, XML Reports, BI publisher, Data Conversions, Oracle Interfaces, EDI.

Oracle Tools: JDeveloper, Oracle Reports Builder 6i/10g, Oracle Workflow Builder 2.6, Pl/SQL developer, Clearcase, Kintana, Data Loader, XML Publisher, Oracle WebADI

Database Tools and Utilities: SQL*Plus, SQL* Loader, WinSCP, Putty

Operating Systems: UNIX, LINUX, Windows

WORK HISTORY

Sr. Technical Consultant, 01/03/2017 to Current at Fujitsu America – Solon Ohio

Client: TTI Floor Care (Solon OH)

Environment: UNIX Application: Oracle Applications R12.2.3

Roles and 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. 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).

Created Oracle WebADI integrator for uploading the AP invoices in Oracle.

IT Business Analyst, 01/01/2016 to 02/28/2017 at Tata Consultancy Services – Galesburg MI

Client: Eaton Corporation (IT Business Analyst): Eaton Mexico Oracle Implementation

Environment: EXADATA server Application: Oracle Applications 11.5.10.2 & R12

Roles and Responsibilities:

Primary owner for delivering end-to-end B2B solutions.

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.

IT Analyst, 02/15/2015 to 12/31/2015 at Tata Consultancy Services – Galesburg, MI

Client: Eaton Corporation (Oracle Techno Functional Analyst): Eaton OMS Project

Environment: EXADATA Server Application: Oracle Applications 11.5.10.2

Roles and Responsibilities:

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.

IT Analyst, 01/01/2014 to 02/14/2015 at Tata Consultancy Services – Galesburg, MI

Client: Eaton Corporation (Oracle Techno Functional Analyst): Eaton Southfield Implementation

Environment: UNIX Server Application: Oracle Applications 11.5.10.2

Roles and Responsibilities:

Prepared Business Requirements Definitions Documents and Proposed Solutions

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.

System Engineer, 01/01/2012 to 12/31/2013 at Tata Consultancy Services – Gurgaon, India

Client: Eaton Corporation (Oracle Technical Analyst): Eaton OMS Project

Environment: UNIX Server Application: Oracle Applications 11.5.10.2

Roles and Responsibilities:

Provided on-call and day-to-day technical support and worked as a part of team in 24x7 production environment.

Acknowledged and acted on the incidents and issues faced by business users.

Provided apt/in time solutions for the incidents from reporting side.

Handling problem tickets for recurring complex issues and doing problem management.

Resolved diverse functional/technical issues/incidents related to RLM, EDI, OM, INV, Shipping, Manufacturing and Purchasing modules.

Worked on enhancement requests for modifying/extending existing functionality of components as per business needs.

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

Assistant System Engineer, 03/07/2011 to 12/31/2011 at Tata Consultancy Services – Gurgaon, India

Client: Eaton Corporation (Oracle Technical Analyst): Eaton OMS Project

Environment: UNIX Server Application: Oracle Applications 11.5.10.2

Roles and Responsibilities

Was responsible for analyzing data received from legacy system and report issues which can prevent its load into Oracle ERP

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.

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.

Created data loader scripts for mass load of legacy data into the ERP.

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

Developing testing scripts and supporting QA and User Acceptance testing

Completed the go-live including movement of code to production and provided warranty support for 15 days.

Handled go live issues and post production issues and tracked incidents using Remedy Incident Management Tool.

EDUCATION

Bachelor of Engineering: Electronics & Communication Engineering, 2010

Rajeev Gandhi Technical University – Bhopal, MP India

ACCOMPLISHMENTS

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

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.

REFERENCES

Name/Contact

Years known

Relation

Chandan Kumar

Email : ac3z2y@r.postjobfree.com

Cell : +1-269-***-****

8 Years

Friend/Colleague

Anil Chamoli

Email : ac3z2y@r.postjobfree.com

Cell : +1-724-***-****

6 Years

Friend/Colleague

Surendra Beniwal

Email : ac3z2y@r.postjobfree.com

Cell : +1-269-***-****

7 Years

Friend/Colleague



Contact this candidate