Scripted VBA Code for Automation
Create Excel Template as per requirement
Debug existing Macro
Automated Email With Chart
Validated Sheet as per Mapping
Projects:
1) Candidate Engagement
Overview : Automated Tool named as Taleo which will get latest file from SharePoint. Consolidate data extracted from SharePoint List & New File from SharePoint location into Taleo with proper validations.
Developed procedure to get latest file from SharePoint location
Consolidated data from existing & new files with updated details
Designed & developed user validations
Developed procedure to extract data from SharePoint List
2) Demand Validation
Overview : Automated Tool, which will extract data from source file as per mapping with proper validations.
Developed tool to extract data of Mapped columns from Mapping Sheet
Designed procedure to Validate data
3) BSC
Developed tool to split Business Unit & Sub Group as per Mapping Sheet
Forecasted Graph
4) Email Chart Automation
Developed tool to Automate Email with Chart
Reporting Analyst
Infosys BPO Ltd, Pune
mars 2016 - septembre 2016
Project: BT - Openreach
Delivered Daily, Weekly and Monthly Reports
Scripted VBA Code for Report Automation
Create, modify, maintain Reports within required timeframe
Create Excel Template as per requirement
Support existing Report
Extract data from database to generate Report
Review Report for accuracy, completeness to delivered error free
Debug existing Macro
Performed Data Manipulation, Transformation, and Cleansing
MIS Executive
Agathos, Pune
mai 2014 - mars 2016
Designed Company Logo, Letter Head & ID Card
Published property details into Agathos Portal
Performed Data Entry for sourced data
Reviewed data spreadsheets for accuracy, completeness & correct errors if any
Handled petty cash
Back Office Assistant
REMAX Panorama Realty, Pune
octobre 2013 - avril 2014
Designed Company Logo, Letter Head
Reviewed data spreadsheets for accuracy, completeness & correct errors if any
Maintained confidentiality of records and information
Monitored progress and prioritised tasks accordingly
Maintained and operated office equipment such as printer, scanner, PC
Lead Data Entry Operator
Probus IT Solution India Pvt. Ltd., Pune
janvier 2013 - septembre 2013
Performed Data Entry of sourced information
Assigned data entry task to team.
Reviewed data for accuracy, completeness & correct errors if any
Maintained complete activity log and prepare report.
Monitored call records for QC
Reviewed data spreadsheets for accuracy, completeness & correct errors if any
Jr. JAVA Developer
Add Weprecon Softwares Pvt. Ltd., Pune
mars 2012 - mai 2012
Project
1) Restaurant Management System
2) Housing Society Management System
Designed & Development of various modules, Coding, Testing, Documentation
Developed code for applications
Maintained and debugged applications
Front End : JAVA (Swing) IDE Net Beans 6.9.1
Back End : MySQL
Graphics Designer
Dipesh Copy Center, Mumbai
février 2008 - mai 2008
Designed Brochure, Banner, Visiting Cards
Operated Flex Machine
Skills : Corel Draw, Adobe Photoshop
VBA Developer
Accenture, Pune
juillet - aujourd'hui
Scripted VBA Code for Reports Automation
Developed program to Export Table into Outlook Email
Developed Web Automated Tool using VBA
Created Excel Application to search relevant Files where Macro File is Located
Debug existing VBA code
Developed program to refresh all Pivots & change Data Source
Created Application to export Chart into PowerPoint
Tools Developed for Below
Hard Worker
A competent professional 5 years of experience in Excel VBA and MIS
Well versed with Microsoft Office Excel, VBA, Macro, Report Automation, MIS, Typing, Data Entry
Other Competencies Hardware, Corel Draw, Photoshop, FRP Moulding
Internship Project
Restaurant Management System
Designed & Development of Modules
Coding, Testing & Documentation
Designed UML diagrams
Professional Training
Advance Diploma in Computer Hardware
A+ Grade, December 2005
Silicon Technologies Computer Education, Sangli - 416416
Microsoft Certified Professional XP(70-270)
May 2007
Silicon Technologies Computer Education, Sangli - 416416
Fiber Reinforced Plastic Molding (FRP)
January 2008
KVIC (Govt. of India), Borivali (W), Mumbai - 400092
State Level Champion in Kho Kho, Runner November 2003
Participated in All India Kho Kho Tournaments December 2006
Personal Details
Name : Harshad Ramesh Shete
Marital Status : Single
Mobile Number : +91 9420053009
Passport Number : K1785522
Email ID : ********
LinkedIn : ********-shete-a75a2559
Permanent Address : 40/A,Shete Building, Opposite Saraswat Bank, Vakharbhag, Sangli - 416416