Uday Jain

Operations Associate

Gurgaon, Haryana, India7 yrs 8 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Expert in building automated systems for data analysis.
Proven track record in developing interactive dashboards.
Strong leadership in managing cross-functional teams.

Stackforce AI infers this person is a Business Intelligence and Automation Specialist in the SaaS industry.

Contact

Skills

Core Skills

Business IntelligenceData AnalysisAutomation

Other Skills

Power BIGitHub CopilotMicrosoft DynamicsPower AutomateVbaMicrosoft Power AutomateMicrosoft Power AppsMicrosoft ExcelMicrosoft SQL ServerVisual Basic for Applications (VBA)SQL Server Integration Services (SSIS)Report BuildingInventory ManagementC++Java

About

Business analyst with specialization in building automated systems for data analysis,report generation and interactive dashboards.

Experience

7 yrs 8 mos

Total Experience

1 yr 6 mos

Average Tenure

4 yrs 1 mo

Current Experience

Invest india

2 roles

Manager

Promoted

May 2023 – Present · 3 yrs 1 mo

Led the management and optimization of Microsoft Dynamics CRM, QMS, and
reporting systems, driving efficiency and supporting digital transformation.
Oversaw the management and optimization of Microsoft Dynamics CRM, QMS and Analytics systems.
Managed an 8-member cross-functional development team, overseeing custom feature development, process enhancements, and system maintenance.
Designed and developed Power BI dashboards to deliver real-time reporting on project performance, investment tracking, employee productivity, and strategic data insights.
Responsible for monthly/yearly reports/audits/data analysis to DPIIT and Commerce and Industry Minister’s office.
Conducted company-wide trainings for new joiners on the Microsoft CRM/QMS and BI dashboards.
In charge of Make in India Query management system ensured timely resolution of queries by different Country, Sector, State Teams in adherence to SLA.
Performed in-depth data analysis across business verticals including lead generation, investment pipelines, stakeholder queries, project tracking.
Oversaw Microsoft license and costing renewals, handled RFPs, and troubleshooted system issues with Microsoft Tech Team.
Built automation tools for outreach and web scraping, daily mailers, alerts, approval processes and data collection using Power Automate.
Implemented approval-based Timesheet system for Invest India.
Core member of implementation team for Investment Tracking system

Power BIGitHub CopilotMicrosoft DynamicsData AnalysisAutomationBusiness Intelligence

Consultant

May 2022 – May 2023 · 1 yr

VbaMicrosoft DynamicsBusiness Intelligence

Peoplestrong

2 roles

Lead Analyst

Promoted

Jun 2021 – Jan 2022 · 7 mos

Responsible for full MIS of internal HR team, releasing of all offer letters.
Built automation tools in VBA for all Offer letters, Appointment letter generation, document generation, payroll automation.
Automated bulk assigning of assessments and mass hiring of campus students.
Developed centralized BI dashboards on Power BI.
Automated team performance reports, per recruiter joining/open positions.
Released company contracts and offer letters.
Gave Advanced Excel training to mass campus hire Joiners.

VBAPower BIData AnalysisBusiness Intelligence

Consultant

Jan 2021 – Jun 2021 · 5 mos

Ey

Associate

Aug 2018 – Nov 2018 · 3 mos · Gurugram, Haryana, India

Responsible for creating reports, doing secondary research, managing BI dashboards, supporting a business development team overseas.
Created multiple reports, presentations, and BI dashboards for business development team.
Did regular secondary research on multiple companies overseas.
Managed interaction CRM system for leads and opportunities.
Coordinated with business heads for closed opportunities.

Mynd solutions pvt. ltd.

Senior Executive-MIS

Aug 2016 – Nov 2017 · 1 yr 3 mos

Responsible for building automated systems for multiple clients and projects using VBA, SQL server, .net, Power Bi. Leading a team of compliance executives for facility management project.
Developed and implemented systems for payroll, data analysis, compliance, site allowance, leave calculation, attendance calculation, and report generation.
Oversaw a team providing backend support, generating CLRA registers, and muster rolls for diverse clients through VBA, SQL and .NET.
Crafted business intelligence HR analytics dashboards for clients using Microsoft Power BI.
Built an automated employee settlement system for clients.
Analysed GPS data from vehicles to generate comprehensive reports on breakdowns, mileage calculation, and costing.
Designed a batch utility for investment rejection.
Implemented an automated mass email utility, integrating with Outlook, to efficiently send multiple
payslips.

Built by blank

Inventory Manager

Jul 2015 – Aug 2016 · 1 yr 1 mo

Managed the centralized inventory and analytics system through Stitch Labs, integrating Magento and 12 Square POS systems. Responsibilities included updating product listings, adjusting pricing on multiple POS systems, creating purchase orders/transfer orders, conducting sales and inventory audits.
Built Sales reports for sales every channel, low stock reports, top 10 selling reports, daily inventory reports, monthly closing stock reports.
Developed automated report generation tools for analytics and business intelligence using power query, power pivot, Microsoft Access and VBA coding.
Built business intelligence ETL dashboards on cloud using Microsoft Power BI.