$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
CEO and Senior Excel/VBA Developer @ExcelXLS
Mihir Hindocha
,
Hatch End, United Kingdom
Experience
Other titles
Skills
I'm offering
Do you find yourself spending hours to complete tasks in Excel on a regular basis? We can help! We use VBA in Excel to fully automate such problems.
Turn hours into seconds with a click of a button.
We create tools and solutions to solve any Excel based problem.
Examples of projects completed for clients thus far include:
- Unlocking password protected workbooks
- Creating a tool for employees to enter data with the their then being outputs hidden, only for the employer to see. Taking this further by creating automated reports for the client.
- Manipulating and coding a tool to output a random cell based on various criteria.
- Developing a currency calculator based on data from a dynamic number of worksheets.
- Developing automated booking systems, tracking systems and order books.
- Extracting data from a source and creating drop downs based on different variables. Using those drop downs to output data to multiple worksheets, and printing each to in a specific pdf format.
Get in touch for an initial discussion
Turn hours into seconds with a click of a button.
We create tools and solutions to solve any Excel based problem.
Examples of projects completed for clients thus far include:
- Unlocking password protected workbooks
- Creating a tool for employees to enter data with the their then being outputs hidden, only for the employer to see. Taking this further by creating automated reports for the client.
- Manipulating and coding a tool to output a random cell based on various criteria.
- Developing a currency calculator based on data from a dynamic number of worksheets.
- Developing automated booking systems, tracking systems and order books.
- Extracting data from a source and creating drop downs based on different variables. Using those drop downs to output data to multiple worksheets, and printing each to in a specific pdf format.
Get in touch for an initial discussion
Markets
United Kingdom
Links for more
Once you have created a company account and a job, you can access the profiles links.
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2018 - ?
job
CEO and Senior Developer
ExcelXLS.
• After experience with various consultancies, have started my own business to automate and improve excel based processes using VBA.
• Gather requirements from clients, design prospective design of tool - once final requirements agreed with clients, develop bespoke tools using Excel/VBA.
• Create insights for clients from their data when required - present in PPT format.
• Create and provide user guides to complete projects.
• In the process of learning SQL and PowerBI to enhance my skillset.
• Gather requirements from clients, design prospective design of tool - once final requirements agreed with clients, develop bespoke tools using Excel/VBA.
• Create insights for clients from their data when required - present in PPT format.
• Create and provide user guides to complete projects.
• In the process of learning SQL and PowerBI to enhance my skillset.
Design, Sql, Excel, VBA, Developer, Ceo, Senior Developer, PPT, Processes
2017 - ?
freelance
Consultant
Bespoke Excel, Your Excel Experts.
• Communicate with clients locally and abroad to gather Excel based requirements for 3 different consultancies
• Create solutions using VBA/Excel Formulae and provide full documentation
• Create solutions using VBA/Excel Formulae and provide full documentation
Excel, VBA
2019 - 2020
job
Digital Platform Analyst
Discovery Channel.
• Monitoring Discovery's digital platforms and video streams in real-time. (Predominantly Eurosport and GolfTV.
• Acting as primary point of contact for all reported digital playout issues.
• Outage vetting - initiating of critical outage situations.
• Perform & coordinate escalation resolution of incidents to Discovery's vendors.
• Providing oversight to the Release Management process in monitoring and updating the status of releases.
• Identify, adjust, and help establish new monitors and metrics needs.
• Gathering of requirements from stakeholders, creation and automation (VBA) of MS Excel based reports and on VOD fixes. Providing insights to senior stakeholders in order for key decisions to be made about VODs going forward.
• Providing support to the Duty Operations Manager in the management of outages as needed, providing communications to small and large-scale user groups.
• Tools used: Service Now, AWS, MUX, Confluence, Conviva, Kibana, JIRA, BOX, Insomnia, Postman, Sonic VMS, Pager Duty, VBA
• Acting as primary point of contact for all reported digital playout issues.
• Outage vetting - initiating of critical outage situations.
• Perform & coordinate escalation resolution of incidents to Discovery's vendors.
• Providing oversight to the Release Management process in monitoring and updating the status of releases.
• Identify, adjust, and help establish new monitors and metrics needs.
• Gathering of requirements from stakeholders, creation and automation (VBA) of MS Excel based reports and on VOD fixes. Providing insights to senior stakeholders in order for key decisions to be made about VODs going forward.
• Providing support to the Duty Operations Manager in the management of outages as needed, providing communications to small and large-scale user groups.
• Tools used: Service Now, AWS, MUX, Confluence, Conviva, Kibana, JIRA, BOX, Insomnia, Postman, Sonic VMS, Pager Duty, VBA
Excel, AWS, Video, Jira, Operations, Automation, VBA, Operations manager, Management, Service, Confluence, Support, Analyst, Monitoring, Kibana, Manager
2018 - 2019
job
Technical Analyst
Virgin Media.
• Testing of new code releases into Staging (ORT/UAT) and Production servers before going live to Google Playstore and Appstore.
• Functional, Negative, Device Variance, Destructive, System Down and Regression testing.
• Raising and tracking defects using defect management tools (Primarily HP ALM, JIRA).
• Working on multiple streaming projects (Virgin TV Go, Virgin Media Kids, Virgin Media store, Sky cinema etc.)
• Monitoring systems and Application logs, ensuring testing environments are operational for BAU. Diagnosing issues using software tools (Dynatrace, Unix, CDFE, EVO, SVC)
• Create, automate and distribute crash reports with isights (using MS Excel, VBA, Powerpoint)
• Functional, Negative, Device Variance, Destructive, System Down and Regression testing.
• Raising and tracking defects using defect management tools (Primarily HP ALM, JIRA).
• Working on multiple streaming projects (Virgin TV Go, Virgin Media Kids, Virgin Media store, Sky cinema etc.)
• Monitoring systems and Application logs, ensuring testing environments are operational for BAU. Diagnosing issues using software tools (Dynatrace, Unix, CDFE, EVO, SVC)
• Create, automate and distribute crash reports with isights (using MS Excel, VBA, Powerpoint)
Excel, Powerpoint, Jira, Unix, VBA, Management, Regression testing, TV, Analyst, Monitoring, Testing, Software, Streaming, Google, Production, Go
2017 - 2017
freelance
Contractor
Sky NOW TV.
1 month contract working with the Sky triage team to co-ordinate incident management between different teams
• Use incident management tools (Remedy and Spark) to receive/log/liaise with different teams and distribute tickets according to the Sky Now TV web/mobile (iOS & Android)/Roku architecture.
• Take ownership and improve service management reports.
• Use incident management tools (Remedy and Spark) to receive/log/liaise with different teams and distribute tickets according to the Sky Now TV web/mobile (iOS & Android)/Roku architecture.
• Take ownership and improve service management reports.
Android, IOS, Management, Service Management, Service, Architecture, Spark, TV, Remedy, Incident Management, Web
2017 - 2017
freelance
Consultant
Capco.
Consultant for a Capco working on their client projects in investment banks.
• Liaised with stakeholders to collate documentation for audit co-ordination team for external auditors to review. Supported teams abroad to analyze and review documentation.
• Automated many internal audit trackers using VBA and produced user guides. Managed user access to audit trackers and other internal tools.
• Liaised with stakeholders to collate documentation for audit co-ordination team for external auditors to review. Supported teams abroad to analyze and review documentation.
• Automated many internal audit trackers using VBA and produced user guides. Managed user access to audit trackers and other internal tools.
Audit, VBA, Audit
2017 - 2017
job
HR Data Analyst
Arriva.
• Cleansed and validated HR data to migrate from one HR system to another.
• Co-ordinated with site managers to collate accurate data. Upload large sets of data into OrgVue. Automated many processes and tools using VBA.
• Co-ordinated with site managers to collate accurate data. Upload large sets of data into OrgVue. Automated many processes and tools using VBA.
VBA, Analyst, Processes
2013 - 2017
job
Mobility and Reporting Analyst
Shell Oil Company.
Part of the Technical Landscape Services Team (TLS) to support the apps that Shell provide to their internal and external customers.
• Use analytical skills and incident/problem management to diagnose mobile app issues raised by customers and high business stakeholders. Liaise with developers who work and project managers to come to a final solution and if required, to facilitate change management.
• Working in an agile environment with business analysts, product owners and develops to support over 20 apps.
• Assisted to manage the UK team, and train new starters when necessary.
• Liaise with project managers for each app on KPI requirements for the creation of various reports/dashboards and analytics. These reports would then be used by stakeholders to make business decisions such as whether to invest in certain functions of the app. Tools used include Distimo, Google Analytics, App Annie, AirWatch, Advanced Excel Skills.
• Data profiling transactional data to provide accurate KPI analysis. Present KPI reports/dashboards to stakeholders in a PowerPoint format.
• Manipulate data in different formats (such as CSVs) from external sources using Excel functions. To minimize time spent on the creation of reports and to maximize reliability, VBA was implemented.
• Use analytical skills and incident/problem management to diagnose mobile app issues raised by customers and high business stakeholders. Liaise with developers who work and project managers to come to a final solution and if required, to facilitate change management.
• Working in an agile environment with business analysts, product owners and develops to support over 20 apps.
• Assisted to manage the UK team, and train new starters when necessary.
• Liaise with project managers for each app on KPI requirements for the creation of various reports/dashboards and analytics. These reports would then be used by stakeholders to make business decisions such as whether to invest in certain functions of the app. Tools used include Distimo, Google Analytics, App Annie, AirWatch, Advanced Excel Skills.
• Data profiling transactional data to provide accurate KPI analysis. Present KPI reports/dashboards to stakeholders in a PowerPoint format.
• Manipulate data in different formats (such as CSVs) from external sources using Excel functions. To minimize time spent on the creation of reports and to maximize reliability, VBA was implemented.
Change management, Excel, Google analytics, Powerpoint, Agile, VBA, Management, Analytics, Support, Apps, Analyst, KPI, Google, App
2013 - 2013
job
Business Management Analyst
unknown.
Lived and worked in New York City with responsibilities including:
• Audit of internal processes. Completing self tests on a quarterly and annual basis.
• Automated Anti Money Laundering name searches & a random appraiser tool using VBA.
• Audit of internal processes. Completing self tests on a quarterly and annual basis.
• Automated Anti Money Laundering name searches & a random appraiser tool using VBA.
Audit, Business Management, VBA, Management, Analyst, Audit, Processes
2012 - 2013
job
Junior Business Analyst
InMobi.
• Liaison with Sales Team, Campaign Management Team and Business Development team to understand reporting requirements.
• Manipulated data from external sources using Excel functions like Pivot Tables.
• Produced accurate and timely Management Information Reports for internal stakeholders.
• Assisted to identify Mobile Advertising Market potential (market size) in different European countries through secondary research.
• Assisted in identifying the Key Performance Index's (KPI's) to track Business Performance.
• Automated various excel based reports/dashboards within excel using VBA
• Manipulated data from external sources using Excel functions like Pivot Tables.
• Produced accurate and timely Management Information Reports for internal stakeholders.
• Assisted to identify Mobile Advertising Market potential (market size) in different European countries through secondary research.
• Assisted in identifying the Key Performance Index's (KPI's) to track Business Performance.
• Automated various excel based reports/dashboards within excel using VBA
Business development, Excel, Advertising, Research, VBA, Management, Sales, Analyst, KPI, Development, Campaign
2011 - 2012
job
Business Support Analyst
OLM Group.
• Supported the production of effective technical supplier relationships and maintain information to inform systems on current and future spend.
• Put in place adequate mechanisms for the tracking and monitoring of processes and associated data. Created MIS to undertake data collation and data analysis.
• Defined and mapped business processes for the department ensuring that they are documented to the required standard.
• Undertook regular reviews with people and managers for data and process capture for management information. Automated many processes using VBA.
• Put in place adequate mechanisms for the tracking and monitoring of processes and associated data. Created MIS to undertake data collation and data analysis.
• Defined and mapped business processes for the department ensuring that they are documented to the required standard.
• Undertook regular reviews with people and managers for data and process capture for management information. Automated many processes using VBA.
Data Analysis, VBA, Management, Support, Analyst, Monitoring, Production, Processes
2009 - 2010
job
Support Analyst
GlaxoSmithKline.
Using problem and change management supported services such as Groove and Sametime. Blackberrys, Servers.
Change management, Management, Support, Analyst
My education
?
-
2011
Brunel University
BSc, Financial Computing
BSc, Financial Computing
Mihir's reviews
Mihir has not received any reviews on Worksome.
Contact Mihir Hindocha
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Mihir directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark