Annpurna Provision Stores A-77,
Sudama Nagar Indore-9.
Phone -09824730109
Email -
SUNIL GHARIYA
Objective To achieve successful position in the field of Information Technology by utilizing my knowledge and skills for the achievements of the desired objectives.
Education Qualification:
- S.S.C. (10th) form C.B.S.C. Board, 1992 with first division- 73.6%
- H.S.C. (12th) from C.B.S.C. Board, 1994 with 70.3%
- B.Sc. (Physics Honors) from HolkarScienceCollege, Indore in 1997 with 64%.
Personal Skills
Comprehensive problem solving abilities, ability to deal with people diplomatically, willingness to learn, excellent communication skills, presentation skills, adaptability to changing job situations and ability to work cohesively in a team.
Certification and Training
- Completed 6-week training for Development Consultant Certification – SAP Net Weaver ABAP Workbench at SapientCollege - Siemens, Hyderabad.
- SAP ECC 5.0 Implementation Core Team Member
- Brainbench Certification in Visual Basic 6.0
Result: Scored higher than 73% of all previous test takers
Technical Skills
More than 8+ years of working experience in following areas of IT as a Developer, Project Leader in a very reputed Telecom Company of India, since June 1997 .
Operating System: MS DOS, WINDOWS 98, Unix
Packages: Spreadsheet Development using Visual Basic For Application
Languages: Visual Basic, C, C++, Assembly
Back End: MS Access, Oracle Database, Sql server
Mail Client/Server: Lotus Notes Administration
Database Administration: Oracle 8i
Networking: Basic Knowledge of Win NT Networking, User Maintenance
ASP: Working Knowledge of Active Server Pages
Process Automation: Automation of Instruments using Visual Basic, Excel and C++
SAP R/3: Working knowledge of PP & MM Functional Module , ABAP/4 Programming
Statistical Tools: Development of Statistical Process Control tools using Visual Basic, VBA and Oracle Database, Minitab Application.
SAP Experience
SAP Technical Experience
1+ years of ABAP Programming with MM and PP Module Experience with following skills.
- ABAP Objects in SAP R/3 4.7.
- GUI development using Workbench tools.
- Reports Design and Development (Classical, Interactive & with ALV grid).
- RFC and BAPI
- Creation and maintenance of ABAP Data Dictionary and Logical Database.
- Enhancement & Modification (User Exit, Customer Exit and Business Add-Ins).
- SAP Script
- Run Time Analysis, SQL Trace
- Batch Data Communication (BDC)
SAP Functional Experience
- One Full Cycle Implementation Experience of SAP PP and SAP PP PI Module
- Core Team Member for SAP Implementation and responsible for PP PI Module
Non SAP Experience
Projects: (In reverse chronological order)
Project #1
Integration of Minitab Application with VB Application for Statistical Process Control
Tools Used: Visual Basic, Oracle Database, Minitab and Excel as reporting tool.
Project Description
This project is developed basically to enhance the capability of Minitab Software, which is a statistical tool. The Interface has been designed so that the Minitab Software becomes an automation and DDE server.This project employs most of the Visual Basic Capabilities including Activex, Windows API, SMTP, Class Modules, and Object Oriented approach, Messaging Over TCP/IP. This is a good tool for Process and Data analysis in a Process Industry.
Project # 2
Reverse Auction System for Corporate Purchases
Tools Used: Visual Basic, Oracle Database, Excel and Word as reporting
Project Description
The Project is for Reverse Auction for the Supply of Corporate Purchases and Rate Contract This project is employs most of the Visual Basic Capabilities including Activex, Windows API, SMTP, Class Modules, Object Oriented approach, Messaging Over TCP/IP.
Project # 3
Sales and Distribution System (SD)
Tools Used: Visual Basic, Oracle Database, Excel and Word as reporting
Project Description
The system takes care of the Finished Goods Stock, Barcode Printing for Batches, Automatic Product Allocation to desire consignee based on the Specs. The project eliminates the manually making of regulatory documents including Customs, Excise etc. Thereby minimizing errors. This project employs most of the Visual Basic Capabilities including Activex, Windows API, SMTP, Class Modules, Object Oriented Approach and Messaging Over TCP/IP.
Project # 4
Production Inventory Control
Tools Used: Visual Basic, Lab View, Oracle Database, Crystal Report Control, Excel as reporting tool
Project Description
The program is developed using Visual Basic as Front End and Oracle as back end. The system keeps track of the complete inventory, stock, movement and online reports. The output of the reports is generated in Excel Spreadsheets and Microsoft Graphs. The System is also capable of doing automatic process corrections in real time and send any deviation related to Failure on mail. This is achieved using SMTP, MAPI, Windows API, Microsoft Winsock etc.
Project #5
Rolling Display of Critical Manufacturing related Parameters for decision-making.
Project Description
This program is an online rolling display of production and output figures. The program resides in System Tray and Timer Based. It polls the data after a fixed interval of time from Oracle Database and displays on the screen. The Program makes use of different Windows APIs to draw text on screen and the program resides in the system tray.
Project # 6
Statistical Process Control Software
Tools Used: Visual Basic, VBA, Oracle Database
Project Description
This is a Microsoft Excel Spreadsheet program developed using Visual Basic for Application and Oracle and is a statistical tool developed for specific process control and trend of different control parameters in the process. This tool calculates Process Capability Index of the Manufacturing Process and generates exception.
Project # 7
Online Tension Control Program
Tools Used: Visual Basic, Labview, Oracle Database
This project is developed in Visual Basic and Oracle .The program is timer based and keeps track of some of the real time changing parameters. Based on these parameters, the program controls the behavior of the process and automatically gives the feedback. This has brought the Standard Deviation of the process to a very low and manual intervention is eliminated.
Project # 8
Paperless and Office Automation
Project Description
Many small programs were developed to make industry paperless and achieve office automation using some of the Windows GUI techniques like File System Objects, System Tray, API, MAPI Control, Winsock, Messages, Callback, Class Modules etc.
Project # 9
SMTP mail system:
Project Description
This is designed to give the immediate feedback to Production and Process people if any exception is recorded in the process. The program flashes on the user screen and also sends the details through mail. The mail system is developed using MAPI, Windows API controls
Personal Details
Name:SUNIL GHARIYA
D.O.B.:01-07-1976
Sex: Male.
Martial Status: Married
Nationality:Indian.
Permanent Address: Annpurna Provision Stores A-77,
Sudama Nagar Indore-9
Contact No: 09824730109
Languages Known: English, Hindi, Gujarati, Marathi
Current CTC:5.0 LPA
Expected CTC:Negotiable
I hereby declare that the above written particulars are true and best of my knowledge and belief.
SUNIL GHARIYA