Harshad - Développeur VBA

Ref : 191125H001
Photo de Harshad, Développeur VBA
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

D'autres freelances
Développeur VBA

Ces profils pourraient vous intéresser !
CV Développeur Python
Oussama

Développeur Python

  • PARIS
VBA PYTHON JAVASCRIPT
Disponible
CV Chef de projet GOOGLE APPS SCRIPT & DATA
Nicolas

Chef de projet GOOGLE APPS SCRIPT & DATA

  • LANNION
Looker GOOGLE APPS SCRIPT GOOGLE APPS SQL Google Cloud Platform VBA ACCESS
Disponible
CV Développeur SIG
Aude

Développeur SIG

  • VITRY-SUR-SEINE
SIG FTTH EXCEL PYTHON POSTGRESQL PostGIS SQL VBA
Disponible
CV Développeur SAS
Katia

Développeur SAS

  • VILLEJUIF
SAS VBA
Disponible
CV Analyste programmeur VBA
Victor

Analyste programmeur VBA

  • LANESTER
VBA EXCEL QLIKVIEW
Disponible
CV Chef de projet VBA
Florian

Chef de projet VBA

  • CARIGNAN
VBA EXCEL
Disponible
CV Développeur DATA
Steve Landry

Développeur DATA

  • CARRIÈRES-SOUS-POISSY
VBA SHAREPOINT Microsoft PowerApps MICROSOFT POWER AUTOMATE TIBCO SPOTFIRE Microsoft Power BI MICROSOFT POWER QUERY PYTHON
Disponible
CV Informatique & Finance de marché (C#/Python/VBA) - Conseil & Formation
Laurent

Informatique & Finance de marché (C#/Python/VBA) - Conseil & Formation

  • ISSY-LES-MOULINEAUX
PYTHON VBA EXCEL C# SQL SQL SERVER .NET ASP.NET PHP Vue.js
Disponible
CV Développeur VBA
Chloé

Développeur VBA

  • LA CHAPELLE-SAINT-MESMIN
VBA SQL EXCEL HTML CSS JAVA PYTHON
Disponible
CV Ingénieur de développement C++ Qt Python
Youssef

Ingénieur de développement C++ Qt Python

  • OLLIOULES
C++ VBA JAVA C# SQL ENTERPRISE ARCHITECT
Disponible