● ac65i5@r.postjobfree.com ● ANKUR (***)***-NAISHADH 9289 SUMMARY ● https:GANDHI //www.linkedin.com/in/ankurngandhi/

• Analytical fast learner with 3years experience in global on-demand service in Oracle Application 11i/R12

• E-Excellent Business hands-Suite, on Pl/experience SQL, Reports with Builder, successfully and BI using implementing RICE (Reports, advanced Integration, modules Conversion in Oracle Applications & Extensions) like

• documentation Strong communication and coordination and documentation of work with skills team gained members through and clients development in a team of of over technical 100 people and functional EDUC ATIO N

California State University, Fullerton Aug 2016 - May 2018 Master of Science, Computer Science GPA - 3.6/4.0

University of Mumbai, India Aug 2009 - May 2013

Bachelor of Engineering, Computer Engineering GPA – 3.8/4.0 WORK EXPERIENC E

Infosys Limited - Systems Engineer Pune, India

Project (Supply Chain Management and Finance) Oct 2014 - June 2016

• • • • • Generated Designed Orchestrated Migrated reducing Improved tables resulting UAT an Oracle the a Oracle customized conversion efficiency time in objects fetching by BI 70% template of (code XML concurrent code up in of report page through PL/30 items SQL allowing programs, publisher Query for details migration user optimizer request querying (columns) to display using set) by multiple for using concepts contents from each cost-one keys Purchase like in based test multi-together Stored instance optimizer Order organization Procedures, consisting Summary to technique another language of Triggers, through more through than Cursor SQL Unix, 20

• Designed Pl/SQL packages to show the price list structure based on the organization selected

• Worked in Oracle 11g/R12c forms with a thorough understanding in P2P and O2C lifecycles.

• Prepared business and technical documentation to help understand the business processes to the clients

• Implemented the conversion code to migrate inventory supply from 3rd party legacy system to Oracle R12

• Established user requirements, procedures, to identify problem automate; improve, or add new functionality Modules: General Ledger, Inventory, Order Management, Purchasing, Warehouse, Bill of Material, Internet Advanced Design Pricing, Zone Advanced – Developer Receivables, Advanced Payables, Cash Management Mumbai, India Project (Web Development) July 2013 - Oct 2014

• • • • Achieved providing Generated Saved Overhauled 30% 20% easy 25% of knowledge data response navigation more entry mobile transfer time time for improvement mobile by user session creating traffic users to shell the by via team performing script website explaining to load customization indexes bulk the data coding and in SQL through ETL functionality, tuning tools java-performance instead script to help of and manual save bootstraps time entry ACADEMIC PROJECTS

Predicting Freeway Vehicular Traffic based on Social Media Tweets Jan 2018 - May 2018

• • • BI/Predicting Fetched Applied DW System analytics data a correlation through Design dataset MongoDB Project between to obtain for using vehicular Trip prediction API’s Advisor traffic in of python, traffic and social while via tweets media generating using tweets scikit plots to library analyze in python the Aug relationship 2017 - Dec 2017

• • Crime sales Diagnosed Collected, Prediction through cleansed, data relative through and marketing BI analyzed analytics KPI Trip showing Advisor percentage air booking difference dataset due using to improper ETL tools marketing to find Aug ways 2016 sales to - Dec improve 2016

• • • Collected Used Constructed time and clustering date data prediction which of algorithm San would Francisco based to help generate for Homeland in these reducing hotspot prime Security crime spots for each SKILLS by to in analyze 30% R crime Studio type each to identify and crime displayed details next estimated through it on google google crime maps based API on place,

• • • • Frameworks: Databases: Tools: Reports, Programming Oracle phpMyAdmin, Oracle Oracle E-Skills: Business 10g, ERP, BI Eclipse, 11g, Publisher, Suite Oracle R12, Microsoft R12.MySQL, EBS Oracle 2.5, MongoDB TOAD, Office, Forms, Informatica, Oracle Oracle • • Libraries: API: SQL Pl/Oracle SQL, Developer, Visio, Tableau, JavaScript API, Excel Twitter Oracle PHP, API HTML, BI Desktop CSS, Python, Publisher, XML Oracle