Ratnesh Sinha

Ratnesh Sinha Email :- Mobile : - EXPERIENCE SUMMARY: • Oracle Apps techno-functional consultant having 13 years of experience in manufacturing and automation Industry. • Certified in Six Sigma Green Belt. SKILL SUMMARY: IT and Project Management Industry: Automation/ Manufacturing ➢ Custom Application Development. Value-Added Leadership ➢ Requirement Analysis, estimation and project schedule. ✓ Cross functional with HANA, SAP-Informatica, Snowflake ➢ Database design (RDBMS)/ upgrade/ Migration. ✓ Team building, review of work and assignments. ➢ Enterprise wide implementation. ✓ Client relations. ➢ Testing/ QA/ Rollout/ Support. ✓ Onsite-Offshore model (US, Mexico, Malaysia and China). Programming Language: Oracle ERP: Oracle EBS 11i ❖ SQL, PL/SQL, Unix, HTML ❖ Form Personalization, Interface, Conversion, Data Migration. ❖ Oracle attachment download through program. ❖ Oracle Modules - Tools / Applications: SQL Developer Toad SQL Plus INV PO BOM Routing OM AP Oracle Forms6i JIRA Putty AR SR/SRA ASL Vendor Bank Quality MS Office365 Edit Plus WinSCP Bit wise SSH Tunnelier Notepad++ Windows2010 Analytical Dashboard and Reporting Tool: ❖ Reports 6i/ 10g Database ❖ SAP Business Objects 3.1/4.1 ❖ Oracle 11g, 9i ❖ XML Publisher ❖ Snowflake ACADEMIC QUALIFICATION: ✓ Post Graduate Diploma in Business Administration (PGDBA) from Symbiosis Centre for Distance Learning, Pune. ✓ Post Graduate Diploma in Advanced Computing (PGDAC) from Vidya Nidhi Infotech Academy, Mumbai, C-DAC, ACTS-Pune. ✓ Master’s in Computer Application (MCA) from Indira Gandhi National Open University. ✓ Advanced Diploma in Computer Application (ADCA) from Indira Gandhi National Open University. ✓ Bachelor’s in Computer Application (BCA) from Indira Gandhi National Open University. ✓ BISSS-9E, Bokaro, Higher Secondary Certificate Examination from Central Board of Secondary Education. ✓ High School-9A, Bokaro, Secondary School Certificate Examination from Bihar Secondary Examination Board. JOB TITLE HISTORY: ➢ Currently working as Sr. Data Analyst with Honeywell International India Private Limited, Pune from Nov2010. ➢ Worked as Asst. Executive-Oracle Apps developer with D.P. Jindal Group-Maharashtra Seamless Ltd from Dec07 to Nov10. WORK SYNOPSIS: ➢ Onsite-Offshore Projects Summary:  Malaysia – Shah Alam – 2019 WMS-Flux Integration.  Mexico – Mexico City – 2018 Oracle-SAP migration mapping and integration.  US – Elpaso – 2018 Oracle Apps custom support.  US – Northford – 2018 Custom Oracle-EIS-SAP Integration Phase2.  China – Shanghai – 2017 Data Migration and Implementation of new site.  US – Minneapolis – 2017 Custom Oracle-EIS-SAP Integration Phase1.  China-Xian – 2017 Data Migration, Implementation and Support for new site. ➢ Data Load from Legacy System to Oracle: • Item interface (For Creation of New Items/Modification of existing items/ Inactive the Items) and Item Categories. • Routing and Bill of Material. • Quotation. • Sourcing Rule (SR). • Sourcing Rule Assignment (SRA). • Approved Supplier List (ASL). • OM Price List of Items. • Vendor, Vendor Sites, Vendor Contacts and Banks. ➢ Oracle to SAP-Informatica/ HANA/ Snowflake:  Material Master.  Vendor Masters.  Customer Master/ Sales representative and Customer Contacts.  Purchase Order.  PO Receipts, Quality and Reject.  AR Invoices and payments.  AP Invoices and payments.  Sales Order and Sales Order History.  Inventory Transaction and On-hand balance. ➢ Proficient Skills and Action:  Analyze, design and deployment of Customized Oracle Apps ERP business Solutions.  Procure to Pay and Order to Cash cycle.  Implementation and modification in Forms.  Implementation and modification of reports (PL/SQL, Report builder, XML report, OBIEE).  SAP Business Object (SAPBO) reports.  Bank and Payment setups.  Collection Plan (Quality Module).  Email notification through PL/SQL. CERTIFICATES, AWARDS AND TRAININGS Certification and Training Bravo Awards Recognition and Appreciation ✓ Six Sigma Green belt.  Aug17- Bravo Star Award for Oracle to HANA data integration.  Oct19- Recognition extraction. ✓ Firmware XTM Basics from Watch-guard.  Jul16- Bravo Bronze Award for helping to achieve 100% business target in Jul-16.  Sep19- Recognition for act with urgency in WMS-FLUX-Oracle Integration project. ✓ 1-month training in Central Mines Planning & Design Institute (CMPDI), Ranchi on E&E department.  Mar15- Bravo Star Award for successfully completing data migration activity for Indonesia.  Aug-19- Recognition for Elster Australia Deployment project.  May13- Bravo Bronze Award for effective performance.  July12- Bravo Bronze Award for delivery of assignments within a given time frame. data Metering  Oct14- Appreciation Award (Honeywell Partner Award) from business for effective performance of tasks. Name : Ratnesh Sinha Father’s Name : Vidya Bhushan Prasad Sinha Date of Birth : 01-Jul-1982 Gender : Male Nationality : Indian Marital Status : Married Current City : Pune – Maharashtra Origin City : Bokaro Steel City– Jharkhand Passport : Available Notice Period : 2 Months Total Exp : 13 Years Relevant Exp : 13 Years Job Type : Permanent Employee Language Known : Hindi, English US Visa : B1 Mobile : - Email : - Reason for change : For the growth of my career and advance my skills. Ratnesh Sinha Techno-functional Consultant, Pune Vocollect  Jan18- Recognition for Wildcat data migration project. PERSONAL PROFILE X for