Varun Sharma

Data Analyst

Gurugram, Haryana, India5 yrs 1 mo experience

Most Likely To Switch

Key Highlights

Proficient in SQL, Excel, and Power BI for data analysis.
Improved CSP engagement by 20% through data analysis.
Created dashboards that enhanced decision-making for stakeholders.

Stackforce AI infers this person is a Data Analyst with expertise in Telecommunications and Financial Services.

Contact

Skills

Core Skills

Data AnalysisReporting

Other Skills

SQLPower BIAdvanced ExcelMicrosoft OfficeExcelPythonSQL Server Management StudioMicrosoft SQL ServerGoogle SheetsFrenchManagement Information Systems (MIS)Technical Support

About

Data Analyst with 2 years of experience, adept in leveraging SQL, Excel, Python, and Power BI for data preparation, analysis and reporting.

Experience

5 yrs 1 mo

Total Experience

1 yr 3 mos

Average Tenure

1 yr 8 mos

Current Experience

Indus towers limited

Data Analyst

Oct 2024 – Present · 1 yr 8 mos · Gurugram, Haryana, India · On-site

Indus Towers is a Pan-India telecom infrastructure company which provides tower infrastructure to telecom operators like Airtel, Jio, Vi, and others.
My role focuses on optimizing rental processes, increasing rental percentage, and improving Indus Towers’ profitability by effective data analysis, timely reporting, and coordination with stakeholders.
Prepare Rental Percentage Dashboard using Power BI and Advanced Excel to analyze rental performance and identify areas for improvement.
Generate Monthly Rental Payout Reports, detailing rental payments made to Landlords (LLs) by state, ensuring accurate tracking of disbursements across India.
Create and maintain Daily Rental Request Reports using Advanced Excel, send them to the Finance Team, track payment status, and provide consolidated weekly reports to the Manager every Monday.
Utilize ERP Oracle System to track rental payments at various tower sites, provide detailed site-wise rental information, and ensure ETMs (Engineer Technical Managers) have complete visibility of site rental status.
Clear Service Requests (SR) / Service Payments (SP) records on ISQ Platform using Trantula tool to ensure smooth operations and proper record-keeping.
Support Indus Towers’ Center of Excellence (COE) by providing analytical insights and reports that help improve rental percentage, optimize rental payout processes, and contribute to maximizing company profitability.

SQLPower BIAdvanced ExcelReportingMicrosoft OfficeData Analysis

Oriel financial solutions private limited

Data Analyst

Apr 2024 – Oct 2024 · 6 mos · Gurugram, Haryana, India · On-site

Prepare data on CSP (Customer Service Point) utilizing SQL to query active-inactive status to identify CSPs that have not worked for several days.
Used Excel to analyze and visualize CSP work patterns, identifying inactivity trends. This approach improved CSP engagement by 20% and reduced service gaps.
Utilized Excel and Power BI to generate and send the Bank Balance Sheet, leveraging data visualization and analytical skills for accurate financial consolidation and reporting.
Employed data validation techniques to ensure transaction accuracy, using Python and excel to apply SQL queries for filtering and analyzing transaction data for reporting.
Managed agreements for CSPs, renewing contracts when they are about to expire.
Utilized Power BI to daily send SSS data, including PMJBY, PMSBY, APY, and PMJDY records, generating dashboards and analyzing total SSS activity for comprehensive reporting.

SQLExcelPower BIData Analysis

Dhoot group

MIS Data Analyst

Apr 2023 – Feb 2024 · 10 mos · Gurugram, Haryana, India · On-site

Preprocessed real estate data from various sources (sales, marketing, customer feedback) and internal systems to generate comprehensive reports on financial gains, pending costs, and customer satisfaction.
Created and maintained interactive dashboards in Power BI to provide real-time insights on sales trends, customer segmentation, and project profitability for stakeholders and senior management.
Leveraged Python and SQL for competitor and internal project analysis, identifying opportunities to enhance project value and stay competitive in the Gurugram real estate market. By analyzing market data, strategically recommended the placement of shops and markets within the society, leading to a 10% increase in retail footfall. Additionally, through customer requirement analysis, helped set up high demand facilities, improving customer satisfaction by 20% and boosting overall community engagement within the development.
Analyzed customer feedback and sales data to recommend strategies that enhance customer satisfaction and drive sales conversion rates.
Worked closely with cross-functional teams (marketing, sales, and project management) to deliver actionable insights that align with project goals.

Power BISQLPythonData Analysis

Bluejay delivery

Data Analyst Intern

Feb 2021 – Mar 2023 · 2 yrs 1 mo · San Francisco, California, United States · Remote

Conducted detailed analysis of logistics data using Excel, employing advanced functions (VLOOKUP, PivotTables, INDEX/MATCH) to generate insightful reports and forecasts.
Developed dynamic and interactive dashboards in Power BI to track key logistics metrics such as shipment delays, and warehouse efficiency, reducing shipment delays by 15% and enhancing warehouse efficiency by 20%
Utilized Excel for data cleaning, transformation, and validation, ensuring accuracy and consistency of logistics data across multiple sources.
Use Excel and Power BI to design and maintain KPIs, visualizing trends related to inventory turnover, fleet utilization, and on-time delivery rates.

ExcelPower BIData Analysis