Jogesh Kumar Sharma

Business Development Executive

Chandigarh, India5 yrs 4 mos experience

Most Likely To Switch

Key Highlights

Developed automated reporting workflows improving efficiency by 60%.
Created interactive dashboards enhancing KPI visibility by 40%.
Mentored interns to uphold data analysis standards.

Stackforce AI infers this person is a Data Analyst with expertise in SaaS and Healthcare industries.

Contact

Skills

Core Skills

SqlPower BiPower AutomateData Analysis

Other Skills

SQL ServerVBAMicrosoft ExcelAdvanced ExcelGoogle SheetsMicrosoft OfficeDAXData GovernanceMicrosoft Power AutomateDatabasesMicrosoft AccessInformation Management SolutionsBusiness InsightsBusiness Intelligence (BI)Visualization

About

Business Analyst | SQL | Power BI | Python | Advanced Excel I help organizations turn raw data into clear, actionable insights that drive smarter decisions. I collaborate closely with stakeholders to understand business needs and deliver interactive dashboards, automated reports, and data-driven solutions aligned with strategic goals. 🔹 Core Expertise: • SQL Server / Snowflake/ BigQuery – Data extraction & optimization • Power BI/ Tableau – Data modeling, DAX, RLS, dynamic dashboards • Python (Pandas, Matplotlib) – Data cleaning & analysis • Advanced Excel – Power Query, Pivot Tables, Power Pivot • ETL - DOMO, Azure Data Factory, and Alteryx • Power Automate & VBA – Workflow and report automation

Experience

5 yrs 4 mos

Total Experience

1 yr 4 mos

Average Tenure

1 yr 6 mos

Current Experience

Knack rcm

Business Analyst

Nov 2024 – Present · 1 yr 6 mos · Mohali district, India · On-site

● Collaborated with the Senior Director and Managers to understand business requirements, developed SQL Server queries, and built Power BI dashboards, empowering the CEO and vendor-clients with real-time insights that guided strategic decisions.
● Designed, built, and maintained multiple Power BI dashboards, including Sales Trackers, Daily Performance Metrics, and Distributor Query Status, enhancing KPI visibility and reducing manual reporting time by 40%.
● Developed automated workflows using VBA and Power Automate, streamlining 4 recurring reports and improving overall reporting efficiency by 60%.
● Automated distributor-sales data submission reminders using Power Automate, resulting in a 30 % increase in on-time submissions.
● Migrated MS Access reports to SQL Server and worked with data engineers to deploy them in SSRS, improving report reliability and reducing refresh issues by 35%.

SQL ServerPower BIVBAMicrosoft ExcelSQL

Bolster legal

Medical Data Analyst

Dec 2022 – Nov 2024 · 1 yr 11 mos · Banglore · Remote

▪ Conducted high-quality data extraction, collation, and analysis of medical data for Jacoby & Meyers and The Law Offices of Larry H. Parker Inc., delivering 70+ comprehensive reports within stringent deadlines, which enhanced decision-making and case preparation efficiency.
▪ Utilized advanced Excel functions, PivotTables, and Power BI to analyze and visualize accidental injury datasets, improving accuracy by 40% and clarity
in reporting.
▪ Created over high-quality reports and visualizations using Power BI to track the status of accidental cases, mentoring 10+ interns to uphold data analysis standards and ensure accurate reporting.

Power BIAdvanced ExcelData Analysis

Parexel

Drug Safety Associate I

Jan 2022 – Dec 2022 · 11 mos · Sahibzada Ajit Singh Nagar, Punjab, India · Hybrid

● Generated and analyzed over 150 detailed reports for NOVARTIS, identifying key trends that led to improvement in decision-making efficiency and supporting strategic initiatives.
● Developed and maintained databases using SQL, enhancing data tracking for patient outcomes and study metrics.
● Created over 150+ detailed reports and visualizations using Excel and Power BI, effectively communicating findings to clinical teams and stakeholders, leading to a 40% reduction in data-related misunderstandings and improving project outcomes.

SQLPower BIMicrosoft ExcelData Analysis

Transtutors

Junior Associate

Jan 2021 – Jan 2022 · 1 yr · Noida, Uttar Pradesh, India · Hybrid

● Performed detailed data analysis to identify and resolve financial discrepancies, including managing PayPal and Stripe dispute cases using Excel.
● Maintained accurate profiles by sourcing data from websites and filings, and improved accuracy using Google Sheets.
● Trained and supervised over 5 interns, ensuring accuracy and quality in their data management and analysis tasks.
● Maintain accurate records of customer interactions and transactions.
● Collaborate with other departments to ensure customer satisfaction.
● Identify and escalate complex issues to senior management.

Google SheetsMicrosoft Office