Harshad - Développeur VBA

Ref : 191125H001

Domicile

411046 PUNE (Inde)
Profil

Développeur (37 ans)
Statut

Freelance
Tarif Journalier Moyen
Voir le tarif

Compétences

VBA

Expériences professionnelles

Software Engineer

Collabera Technologies Pvt. Ltd., Pune
Jan 2016 - Jan 2017
Onsite: Citi

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
Jan 2016 - Jan 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
Jan 2014 - Jan 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
Jan 2013 - Jan 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
Jan 2013 - Jan 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
Jan 2012 - Jan 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
Jan 2008 - Jan 2008
Designed Brochure, Banner, Visiting Cards
Operated Flex Machine

Skills : Corel Draw, Adobe Photoshop
VBA Developer

Accenture, Pune
Jan - 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

IDOC Monitoring Tool
Solman Template
Margin Calculator
DevOps Dashboard
Weekly PPT Report
Daily Status Report

Études et formations

Master Of Computer Application

Mumbai University
2012
Bachelor In Computer Science

Shivaji University
2009
HSC Maharashtra Board Pune

2004
SSC Maharashtra Board Pune

2002

Autres compétences

Summary

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

Typing 40 wpm

Education & Qualification

Languages:C, C++,C#, Core JAVA, Advance JAVA, SQL, Linux, HTML
Aggregate:57.11 %

Languages:C, C++, VB.Net, JAVA
Aggregate:54.96 %

Aggregate:37.17 %

Aggregate:53.60 %

Skill

VBA, Excel, Macro, MIS, Vlookup, Pivot Table, Data Entry, Java, Hardware, Corel Draw, Photoshop, FRP Moulding

Interest

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