Siddharth Singh

Hi, As a Senior Consultant in the Analytics team, I have been and currently am part of several team based and sole responsibility projects aimed at providing data and BI related solutions to the Pricing and Reserving teams in the organisation.

I have over 7 years of experience of working on Microsoft Excel & VBA. I have developed several dashboards and tools using different excel functionalities and VBA, these have been built from scratch, starting from understanding the requirements/problem statement, deciding on tools and required functionalities like Data validation, conditional formatting, Pivot tables etc. to write the required sub routines and functions on VBA, establishing the required connection and testing the tool.

I have good experience of creating tools using VBA user forms, my current organisation has an inbuilt tool called Employee Management System which is used to input and retrieve employee and organisation details. It uses Excel VBA user forms to take input from the users and stores all the data in an SQL database. I have been managing the entire tool from past 5 years.

Building a dashboard to show important KPIs of Motor Fleet line of business. The team not only has to build a dashboard from scratch but also look into different data sources, understand the data and finalise on the best way to pull out the required data from different data sources, combine the data and setup a process which would require minimum user intervention.

Familiar of working on Power BI as well, connecting to different data sources, transforming the data using Power query, using DAX functions as per requirement and building graphs, tables and other visualisations as per requirement.

I will bring in diverse experience of working on several analytics tools in past 7 years depending on requirement and problem statement. I can also help in training the other resources on Excel-VBA, SQL, Power BI, Qlik Sense and other tools as I have been doing in my current organisation.

Proficient in advanced MS Excel functions and complex nested formulas.
Created automated dashboards and reports, reducing manual efforts and processing time significantly.
Conducted data cleansing and validation procedures, ensuring data accuracy and integrity.
Designed and implemented pivot tables and charts on Excel to visualize data trends and insights.
Applied data visualization techniques, including conditional formatting and spark-lines.
Customized Excel macros and VBA scripts for automating repetitive tasks, increasing productivity.
Proficient in data importing/exporting, data connections, and external data sources.
Created interactive Excel forms and VBA User forms templates for data collection and reporting purposes.
Implemented error handling and debugging techniques to ensure the reliability and robustness of VBA code, minimizing downtime and errors.
Created and successfully executed numerous sub routines and procedures depending upon requirement to avoid duplication of efforts.
Enhanced data validation and quality control procedures through VBA scripts, ensuring data accuracy and integrity.
Integrated VBA automation with other Microsoft Office applications such as Word and Outlook to optimize workflow efficiency.
Provided details of portfolios against various key risk identifiers evaluated for underwriting effectiveness.
Used MS Excel, VBA, and SharePoint as primary tools for template development, process implementation, SharePoint site management, and building and maintaining reporting tools.
Led the in-house tool (Employee Management System) based on MS Excel, VBA, and SQL.
Used User Forms to fetch, enter, and update information regarding employees, clients, vendors, and projects stored in an SQL database.
Managed the entire process, developed new forms, and solved queries from end users.
Demonstrated expertise in writing advanced SQL queries, including JOINs, subqueries, and window functions, to extract meaningful insights from large datasets.
Proficient in performance tuning and query optimization, resulting in significant reductions in query execution times.
Worked on Microsoft Server Report Builder and Visual Studio.
Maintained separate Reinsurance QN systems for Treaty and Facultative reinsurance.
Created new reports, updated existing reports, deployed reports on Test/Production servers, and made ad hoc changes as per request.
Worked on Power BI for more than 3 years, designing, developing, and delivering data-driven insights and visualizations.
Efficient in connecting Power BI to diverse data sources, including databases, APIs, and cloud platforms, to create comprehensive reports and dashboards.
Developed data models using Power BI's DAX (Data Analysis Expressions), enabling robust calculations and data transformations.
Proficient in creating calculated columns, measures, and calculated tables in Power BI to facilitate advanced analytics and reporting.
Integrated Power BI with other Microsoft tools, such as Excel and SharePoint, for seamless data sharing and collaboration.
Expertise in using Power Query to transform, clean, and manipulate data from various sources such as Excel, SQL databases, CSVs, SharePoint files, and web services.
Created interactive and insightful Qlik Sense dashboards and reports that enable stakeholders to make informed decisions.
Designed and implemented data load scripts using Qlik's scripting language, ensuring data accuracy and consistency.
Conducted performance tuning and optimization of Qlik Sense applications for improved query response times.
Coordinated with Qlik support team ensuring timely creation of QVXs and timely update of underlying data, and getting timely solution for issues/queries.
Explored different ways of fetching data into BI tools focusing on Qlik web connectors.
Performed comparative analysis of both the tools focusing on deployment of final dashboards.
Developed dashboards, scorecards, and reports from scratch using DAX functions, conditional formatting, and indexing.
Worked with Street pricing team on an initiative to build data and requested JPNs for commercial lines portfolios like Motor Fleet and Packages.
Coordinated with the data building team working on SAS to understand and validate the data, and made dashboards based on various KPIs.
Developed and executed SAS programs for data cleaning, transformation, and manipulation, ensuring data accuracy and consistency.
Created customized SAS macros and programs to automate repetitive tasks, improving workflow efficiency and reducing errors.
Proficient in data merging and joining techniques in SAS, combining data from various sources for comprehensive analysis.
Used various SAS statements and procedures to perform data analysis as per requirement.
Worked on Power Automate to schedule tasks and send mails to different stakeholders.
Developed and maintained SharePoint site templates, ensuring consistency and adherence to branding guidelines.
Proficient in creating and maintaining SharePoint lists and libraries for document management, data tracking, and collaboration.
Managed other resources in the team ensuring alignment of their growth and development with the overall objectives of the organization.
Helped the wider team by conducting regular training sessions on Advance Excel, VBA, SQL, Power BI, and Qlik Sense.

Built dashboards and generated extensive QNS reports for various clients.
Wrote code for protection and conversion of Excel worksheets and transferring data from MS-Excel to MS-Access.
Prepared data entry, extraction, and analysis tools using VBA user forms.
Developed complex SQL queries for data analysis and performed various operations on data using SQL functions.