Utkarsh Sathe
Pune
Summary
Experienced VBA Developer with a focus on automating business processes and developing custom solutions using Microsoft Access. Proficient in SQL for data extraction, manipulation, and optimization of complex queries to support business intelligence and reporting needs. Skilled in writing SQL queries within Microsoft Access to perform data extraction, manipulation, and reporting, ensuring efficient data management and analysis. Capable of troubleshooting and debugging VBA scripts and SQL queries to resolve issues and improve the functionality of MS Access applications. Expertise in combining SQL queries and VBA to automate repetitive tasks, generate reports, and integrate Access with other data systems or tools. Proficient in automating Outlook tasks using VBA, streamlining email management, calendar scheduling, and task tracking within Microsoft Outlook. Expertise in Power BI for creating interactive, data-driven dashboards and reports that drive informed decision-making.
Overview
2
2
years of professional experience
2019
2019
years of post-secondary education
Work History
Business Analyst
Gunn Solutions
05.2024 - 07.2024
- Gathered, analyzed and documented business requirements by collaborating with stakeholders
- Mapped and optimized business processes to improve efficiency and effectiveness
- Conducted data analysis and provided insights to support decision-making and strategic planning
- Worked with cross-functional teams to design solutions that aligned with business goals
- Acted as a liaison between stakeholders and technical teams to ensure clear communication and accurate requirement implementation
- Coordinated and participated in testing to ensure business requirements were met and solutions were delivered as expected
- Created comprehensive documentation, including business and functional requirements, use cases, and system specifications
- Supported project management efforts by tracking progress, managing risks, and ensuring on-time delivery
- Assisted with change management initiatives to ensure smooth adoption of new processes and technologies
- Identified areas for continuous improvement and recommended solutions to enhance business operations
Software Engineer
Clover Infotech
12.2022 - 04.2024
- Generating quarterly compliance reports for various MSME Schemes
- Created pivot tables and charts to visualize data to find trends and make data-driven decisions
- Designed and Implemented macros and VBA scripts to automate process resulting in reduction of manual labor and increase in data accuracy
- Proficient in utilizing XLOOKUP/VLOOKUP functions for efficient data retrieval and cross-referencing, enhancing accuracy in various reports
- Proficient in comprehensive data analysis, interpreting complex datasets to extract meaningful insights and drive business strategy along with sorting and filtering Excel features for efficient data organization and extracting relevant information
- Led the development and implementation of robotic process automation using VBA, significantly increasing process efficiency and accuracy
- Performed web-scraping on various bank sites in order to fetch data
- Performed Outlook Automation to send bulk mails to clients and customers
- Managed and manipulated large datasets using SQL, demonstrating database handling and data analysis proficiency
- Create charts and data documentation with explanations of algorithms, parameters, models, and relationships
- Understanding of the data, use filters and visualizations Analyze current ETL procedures to define and create new systems
- Experience in Power BI Reports using different DAX queries, visuals, filters, and configuring Dashboards with drill-down Capabilities
- Skilled in Power BI Data Modeling and Data Warehousing: Star Schema, Snowflake Schema, Dimensions, Fact Tables
- Created dynamic, data-driven Power BI dashboards, enabling real-time data visualization and insights for informed decision-making across departments
IT Recruiter
Decision NXT
05.2022 - 09.2022
- Sourced candidates through job boards, social media, and networking
- Conducted phone and in-person interviews to assess candidate qualifications and cultural fit
- Managed candidate selection process, including scheduling interviews and providing feedback
- Negotiated job offers and coordinated onboarding for new hires
- Maintaining candidate’s database and tracked recruitment metrics (e.g., time-to-fill, cost-per-hire)
Tech Recruiter
The Parent Inc
03.2022 - 04.2022
- Proactively sourced and recruited top-tier tech talent for roles across software development, data science, and IT infrastructure
- Conducted candidate screenings, interviews, and assessments to evaluate technical skills and cultural fit
- Collaborated closely with hiring managers to understand job requirements and define clear recruitment strategies
- Managed full-cycle recruitment, including job offer negotiation, salary discussions, and onboarding coordination
- Utilized various sourcing tools (LinkedIn, job boards, social media) and applicant tracking systems (ATS) to streamline recruitment processes
- Enhanced candidate experience by ensuring clear communication and timely feedback
- Maintained recruitment metrics and data to assess hiring effectiveness and optimize future recruitment strategies
Education
Bachelor of Science -
Kishinchand Chellaram College
Skills
- VBA
- Advanced Excel
- MySQL
- Power Point
- Power BI Pro/Services
- ETL
- DAX
- Data Visualization
- Power BI Report Builder
- Paginated Report Development
- Azure
- Python
Project Summary
Compliance Generation for MSME Sector, ICICI Bank, is an Indian Multinational bank and financial services company headquartered in Mumbai with a registered office in Vadodara. It offers a wide range of banking and financial services for corporate and retail customers through various delivery channels and specialized subsidiaries in the areas of investment banking, life, non-life insurance, venture capital and asset management., Employed web scraping techniques to gather relevant data from various banking websites, ensuring timely and accurate information retrieval., Utilized SQL for data manipulation and analysis, enabling efficient handling of large datasets to support compliance reporting., Developed VBA scripts to automate data processing and compliance report generation, significantly reducing manual effort and enhancing operational efficiency., Created interactive dashboards using Power BI and Excel, providing stakeholders with real-time insights into compliance metrics and trends., Developed simple and complex Stored Procedures, Packages, Triggers, Indexes and Views as per business requirement., Analyzing, Debugging & Functionality testing on the existing codes and providing defect free deliveries., Analyzing the challenges (DB side) which team finds at the time of development., Developed and optimized complex SQL queries resulting in a 50% increase in performance., Implemented a row-level security algorithm on confidential data consolidating information security by 80%.
Timeline
Business Analyst
Gunn Solutions
05.2024 - 07.2024
Software Engineer
Clover Infotech
12.2022 - 04.2024
IT Recruiter
Decision NXT
05.2022 - 09.2022
Tech Recruiter
The Parent Inc
03.2022 - 04.2022
Bachelor of Science -
Kishinchand Chellaram College
Similar Profiles
Zoe ChenoudaZoe Chenouda
Assistant Manager at Rodd and GunnAssistant Manager at Rodd and Gunn
Paige ZembowerPaige Zembower
Employee Benefits Account Executive at Gunn-Mowery, LLCEmployee Benefits Account Executive at Gunn-Mowery, LLC
Julia ChengJulia Cheng
Math Teacher at Henry M. Gunn High SchoolMath Teacher at Henry M. Gunn High School