Shivaji R. Upase
Near Muktai Mata Mandir Chakreshwar Mandir Road
Chakan Tal- Khed Dist.-Pune
Email ID - ***********@*****.***
Contact No-989*******
Objective
To seeking a position as “MIS Associate” where my professional skills would be used to their fullest.
Summary of Education
Bachelor of Arts From SRTMU University Nanded with II class in 2006
H.S.C. From Pune Board in 2002
S.S.C From Pune Board In 2000
MS-CIT From M.K.C.L. Mumbai in 2008
Communication Marathi Hindi & English
Operating System Windows 98, XP, Widows 7 /10
Applications MS-Office, ADP, and Ticketing Tool (Siebel, Matrix)
Advanced Excel VLOOKUP Pivot H-Lookup, Pivot Table etc.
VBA Programming VBA Coding for Port count projects
Current Experience
(Worked as – Business Planning Analyst Avaya India Pvt Ltd 21-10-2016 To 16-10-2020
Company Profile- Avaya is a leading global provider of next-generation business collaboration, and Communications solutions, Providing unified communications, real-time video collaboration, contact center, networking and related services to companies of all sizes around the world.
Roles & Responsibilities:
• Preparation of Daily, Monthly, Quarterly reports in MS-excel
Fetching out the data from various servers and slice and dice it as per requirement.
• Working on Port count project for automated template using VBA.
• Works on system like Siebel, Matrix, BMC Remedy
• Handling Billing Activities in Is3e Invoicing Software
• Hands on Experience in Advanced excel functions like V-lookup-Lookup, Pivot etc.
• Preparation of reports related with port count
• Activities related with all other reporting
• Data analysis from input files
• Adding sites into system
• Adhoc Port/license Pull for Billing
• Timely delivery of reports to customers
• Works in Linux based systems to taking port counts of different servers
Scheduling reports from analytics .
Sound knowledge of using macros to automate things
Previous Experiences
1.(Worked As – MIS Associate ) 11-06-2013 To 21-10-2016
Company Name-Magna Infotech, Hyderabad Company profile- Avaya is a leading global provider of next-generation business collaboration, and Communications solutions, Providing unified communications, real-time video collaboration, contact center, networking and related services to companies of all sizes around the world.
Roles & Responsibilities:
• Preparation of Daily, Monthly, Quarterly reports in MS-excel
• How to run macro Creation of simplest macros in excel etc.
• Works on system like Siebel, Matrix, BMC Remedy
• Handling Billing Activities in Is3e Invoicing Software
• Hands on Experience in Advanced excel functions like V-lookup,H-Lookup, Pivot etc.
• Handling client queries from mail
• Port count process handling
• Preparation of reports related with port count
• Activities related with all other reporting
• Data analysis from input files
• Adding sites into system
• Adhoc Port/license Pull for Billing
• Email Management from outlook
• Timely delivery of reports to customers
• Connecting to different systems and pull out reports for Port Licenses
2.(Worked-As Associate) 26-12-11 To 12-5-2013
Company Name - Yors Corp HR Services Pvt ltd
Company Profile-It’s a World Class supply chain solution providing company including, Oil & GAS Filteration.Powerplants.Mining, Construction & Tires
Roles & Responsibilities:
Preparation of GRN reports in excel regarding shipment received
Raises enquires for quotations
Creation of Purchase orders & Tax invoices in ADP
Receive GRN in system and submit to finance department
Follow up for supplier payment with finance dept.
Updating Bin location in ADP for Non-stock items & Non-Bin location Items
Creation of Break up invoices for customer
Making of Internal invoices for internal company transfer
Issuing job cards and internal invoices from ADP
Completing shipping instructions data in ADP
Handling of mail queries related with problems
Update Drill production & Equipment statistics report online
3.(Worked As-Data Entry Operator)
Company Name -SKF Bearing LTD Chinchwad 1 -6- 2011 to 8-12-2011
Company Profile-World class Ball Bearing Manufacturer and also includes in Cloth Manufacturing.
Roles & Responsibilities:
Punch Bearing coupons in MAPIX system
Raise credit note to Distributors respectively
Solving Queries related payments
Punch 1000 coupons in MAPIX system with target daily
Maintain locations for incoming coupons from distributor
Making monthly reports for distributors incoming coupons for raising credit notes
To build up various types of daily reports in MS-Excel
Personal Details
Date Of Birth 13/12/1983
Marital Status Married
Hobbies Reading,Surfing,
Nationality Indian
Permanent Address C/O,Nivrutti Todkar,Bolhai mata temple,Bhujbal Ali chakan tal-khed Dist-pune
Declaration : I hereby declare that All above given information is true as per my best knowledge
Thank you