Vinit Ramteke

NAME Mobile No Skype id Email Id Present Address Permanent Address Date Of Birth Marital Status Language Know :VINIT RAMTEKE :- : vinit.ramteke :-: Gokul villa, Plot no. 14, Sec 18, Kamote, Navi Mumbai-INDIA : Ward No 30, Sarekha, Balaghat, M.P -INDIA : 17 Oct 1985 : Married : English, Hindi, Marathi Education Summary: Completed Bachelor of Engineer in Computer Science from SATI VIDISHA (M.P.) in the year 2009. Having 7+ years of experience in Oracle ,PL/SQL, UNIX Production/Application Development and support. Software Skill: Operating System Language Oracle Tools Database Ticketing Tools Application Tools : UNIX, Windows : SQL, PL/SQL ,UNIX , PUTTY , WinSCP, Procure to Pay : SQL*PLUS, SQL*Loader, Report Builder 6i, XML Publisher, Jasper Report : Oracle 10g/9i : BMC Remedy : Toad, Single View Billing, Oracle applications 11i Professional Summary: Reliance Communication (Senior software engineer) –Mumbai,India JAN 2015-TILL DATE Responsible for Wireline Billing, Global Billing and Wireless Billing (Monthly). Responsible for Accurate Billing – approx 40 million customers worth of an amount 45 Billion INR approx per month for all India circle. Worked on tool like Single-View billing , SQL and PL/SQL command of Unix and Toad . Responsible for Analysis (Resolving Tickets) of billing Modules related to rating/billing/customer/service/Payment reconciliation as per the request. Involved in Terminal Bill cycle for Wireless customer and Enterprise. Identify billing exception such as Double Billings/Wrong billing, error customer, late billing to detect revenue leakage and possible customer dissatisfaction causes. Pre – Bill Observation analysis and Post -Bill validation , reservation of charging issues & checks. Ensure indexing, partitioning & sorting on database server & rating is done before bill cycle . New Process implemented in Billing and achieved two Day Billing Project. Moving high volume customer to high volume cycle for ensuring SLA and Migrating cancelled customer to back up server from production server using SQL and PL/SQL. Preparing to business Weekly/Monthly Presentations- Billed & Unbilled summary. CYLSYS SOFTWARE SOLUTION (Senior software engineer)–Mumbai,India April 2014 – Nov2014 Developed PL/SQL packages and function,stored procedures using PL/SQL cursors for the back end processing of the proposed data base design. Writing scripts to create tables , views and Implemented PL/SQL scripts in accordance with the Necessary Business rules and procedures and extract data from flat files using SQL*Loader. Performed code reviews and Monitoring the query performance using explain plans,indexs. Analysis and design of data flow between the various components. Developed graphical Reports through Oracle Data query and pl/sql stored procedures. Creating User Documentation for the applications developed as required. June 2012 – June 2013 BASWARE CORPORATION (Technical consultant)- Chandigarh,India Client: Swiss Re, Zurich Modules: Barware Invoice Processing, Barware Purchase Management, AnyERP adapter, Basware EPP suite, Procure to Pay (P2P) business flows , Oracle SQL Developer. Involved in development and debugging of PL/SQL packages that integrate Basware's EPP product line with Oracle ERP. Understanding the ever changing business environment and so eliciting both functional and technical requirements of the client and implementing the same on Basware products. Define requisition, purchase order, creation of suppliers and supplier site and setup of purchasing options and define and maintain invoices and matching. Netwin infosolutions (Senior Programmer)-Pune,India May 2011 – Dec 2011 Client: Kardex System Ltd, Germany Modules: Oracle Inventory module for Kardex System Ltd. in Oracle Apps 11i. Reviewing Functional Specifications sent by Client. worked with team size of 8 Members Code review, Do optimization on coding. Reviewing the Issues and escalate if required. Participated in Performing Unit Testing, Query Performance tuning on coding part Integration Testing with Business. Developed & Supported database objects like Views , Indexes , Sequences , PL/SQL packages , Procedures , Function and database triggers. Used Hints , Indexes ,records, tables , collections , bulk collection and other tuning techniques in Pl/sql for increase the performance. MNEMON IT Consulting PVT Ltd (Technical consultant)-Hyderabad, India Client: CCHS,US June 2009 – Apr 2011 Modules: Purchasing, Oracle Payables and Fixed Assets - Release 11i Developed RDF and XML Reports from Scratch and Customized Oracle Standard Reports using report builder 6i and XML Publisher respectively and Registered reports in Oracle Applications for various modules PO, AP like Invoice status report. Worked on Import Standard Purchase Order conversion from legacy system to Oracle . The conversions writing stored PL/SQL procedures to load the data into the Oracle Interface tables. Worked on Purchase order print report , Vendor po shipment details report, XML publisher reports. Client: Aleris International, US Modules: General Ledger, Inventory, Accounts Payables, Purchasing. -- Release 11i Prepared all the CV60 and MD70 Document and Defining Concurrent programs, Executables. Involved in design and coding of GL daily rates conversion and PO conversion. Developed various Interfaces to transfer data from legacy system to Oracle Base Tables using SQL*Loader and checked data validation by creating SQL and PL/SQL package. Worked with AOL for setups like registering Concurrent Programs, Request Sets and Value sets. Involved in developing and register G L account analysis report, Purchase order details Report in XML format.