Summary
Overview
Work History
Education
Skills
Interests
Timeline
CustomerServiceRepresentative
Harsh Jailia

Harsh Jailia

Assistant Vice President
Noida

Summary

Process oriented Assistant VP with 6+ years of experience in Process Automation and MI Reporting, created efficiency of ~65% by automating various process using Microsoft VBA, Sharepoint Desingner, HTML/CSS and Python. Designed Tableau dashboards to create insights out of company’s google marketing data for better decision making. Practice mindset of self-learn and implement, learnt and implemented Alteryx within the process to create automated workflows

Overview

8
8
years of professional experience
4
4
years of post-secondary education

Work History

Assistant Vice President

Barclays - Strategy & Forecasting
Noida
07.2022 - Current
  • Reviewed, identified, updated and prioritized strategic initiatives to provide comprehensive support to senior leadership.
  • Identified opportunities to improve business process flows and productivity.
  • Hired and managed employees to maximize productivity while training staff on best practices and protocols.
  • Learnt about the Microsoft Power Apps & Power Automate in order to create in-house sharepoint based Query Manager Tool for team to facilitate the query resolution in ongoing planning cycle
  • Led development of Automated processes using "Microsoft Excel VBA"
  • Led down more robust controls around Query Management tool where we could assign the query to specific individual and multiple users can work at the same time in the database.
  • Demonstrated proficient leadership skills to motivate employees and build competent teams.

Assistant Manager

Barclays - Strategy & Forecasting
Noida
02.2020 - 06.2022
  • Learnt Alteryx during barclays training session and implemented it within the team in order to create a workflow to refine consol file template, hence creating efficiency of ~20min per iteration per cycle
  • Liaising with various stakeholders for requirement gathering and facilitating all technical aspects of data transformation and process automation
  • Build a tool using VBA and Sharepoint to better supervise the Hood request from FBP's (Finance Business Partners) at the time of planning cycle and developed a formulated template to consolidate the request and convert them into system loadable format thus, creating an efficiency of ~3hrs/day
  • Developed a BX SharePoint Site on SharePoint Designer Platform in order to facilitate user experience at the time of planning cycle
  • Integrated the SharePoint List with Excel that they could get updated data from SharePoint List from excel itself without actually accessing the SharePoint
  • Developed 10 scalable automated tool using VBA and Python to assist people across Barclays in their day to day reporting and analysis which added on Cost Innovation Hub

Business Analyst

Barclays
Noida
10.2016 - 01.2020
  • Designed MI Dashboard in tableau to present the weekly/Monthly progress of the department in terms of project completion and failure
  • Created a SharePoint Mentor-Mentee site using InfoPath and SharePoint Designer 2010 to engage employees with the higher management and take career guidance from them
  • Implemented robust control environment by decoding logics of all processes/Reports automated in VBA, in order to ensure the execution of processes in case the VBA Macro fails.

Data Analyst

QuickDel Logistics Pvt Ltd
04.2016 - 08.2016
  • Practiced concepts of Statistical Analysis (Like Regressions, Clustering, Decision Tree) in R Tool by incorporating shipping data
  • Designed Dashboard to visualize Daily, Weekly and Monthly loads received v/s Cost incurred using Excel and Tableau
  • Applied time series analysis in R Tool in order to visualize the trends of how the TAT (Turn Around Time) of the product delivery is going during the span of time (Weekly,Monthly, Quarterly, Yearly).

Senior Executive

Home Credit India Finance Ltd
12.2015 - 03.2016
  • Created dashboards and reports on factors leading to Attrition (Churn Analysis) using Tableau and R Programming in order to reduce Attrition Rate of the company
  • Practiced on automating reports using Excel, VBA Macros in order to reduce the time taken to complete the activity manually and increase the efficiency.

Data Analyst

Gyansha Infotech
01.2015 - 11.2015
  • Engaged in writing blogs of my research on Analytical tools and technologies like R, Tableau for Company's website
  • Created tableau dashboard in order to get insights out of company’s google marketing data for better decision making.

Education

Bachelor of Technology - Computer Science And Programming

United College of Engg And Research
Gr. Noida
07.2011 - 08.2015

Skills

    Automation (Microsoft VBA/Python)

undefined

Interests

Binge Watching

Badminton

Guitar

Timeline

Assistant Vice President

Barclays - Strategy & Forecasting
07.2022 - Current

Assistant Manager

Barclays - Strategy & Forecasting
02.2020 - 06.2022

Business Analyst

Barclays
10.2016 - 01.2020

Data Analyst

QuickDel Logistics Pvt Ltd
04.2016 - 08.2016

Senior Executive

Home Credit India Finance Ltd
12.2015 - 03.2016

Data Analyst

Gyansha Infotech
01.2015 - 11.2015

Bachelor of Technology - Computer Science And Programming

United College of Engg And Research
07.2011 - 08.2015

Similar Profiles

CREATE PROFILE
Harsh JailiaAssistant Vice President