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 Concepteur Développeur VBA
Djamel

Concepteur Développeur VBA

  • MALAKOFF
VBA ACCESS EXCEL MERISE UML
Disponible
CV Développeur VBA
Jacques

Développeur VBA

  • PERPIGNAN
VBA EXCEL
Disponible
CV Spécialiste automatisation de flux
Morgane

Spécialiste automatisation de flux

  • ARTONNE
EXCEL ACCESS SQL VBA VB.NET MICROSOFT POWER AUTOMATE Microsoft PowerApps SHAREPOINT JAVA
Disponible
CV Développeur Electronique numérique FPGA
Tom

Développeur Electronique numérique FPGA

  • POINTE-À-PITRE
FPGA VHDL PACK OFFICE PYTHON HTML REACT.JS CSS VBA
Bientôt disponible
CV Analyste programmeur WINDEV
François

Analyste programmeur WINDEV

  • JARDRES
WINDEV VBA PL SQL
Disponible
CV Business Analyst SQL / Data Analyst
Abla

Business Analyst SQL / Data Analyst

  • COURBEVOIE
UiPath SQL C++ PYTHON JAVA Microsoft Power BI Microsoft PowerApps HTML VBA Finance
CV Développeur EXCEL
Eladio

Développeur EXCEL

  • GORCY
EXCEL VBA WORD
CV Business analyst & formatrice Excel
Léa

Business analyst & formatrice Excel

  • PARIS
EXCEL SAP BW VBA SAP WORDPRESS
Disponible
CV Développeur VBA POWER BI SQL
Enzo

Développeur VBA POWER BI SQL

  • FORT-DE-FRANCE
VBA MICROSOFT POWER QUERY DAX SQL
CV Consultant ERP, BI
Youssef

Consultant ERP, BI

  • MONTIGNY-LE-BRETONNEUX
CEGID Microsoft Power BI VBA SQL SERVER WINDEV
Disponible