Deepak Singh Rana

Data Analyst with 5 years of experience in Advanced Excel-based reporting, MIS operations, reconciliation, and data validation. Skilled in handling large datasets, automating recurring reports, and ensuring audit-ready reporting accuracy using Pivot Tables, XLOOKUP, Power Query, VBA/macros, and SQL. Experienced in working with Salesforce reports, operational KPI tracking, data integrity checks, and cross-functional reporting support.

Strong attention to detail with experience supporting leadership reporting, business operations, and recurring reporting cadences. Passionate about applying analytical expertise to improve AI systems through high-quality data analysis, validation, and structured reasoning.

Lead Data Analyst - Espresa - Dehradun, India

(2024-10)

• Developed and maintained recurring MIS reports and operational dashboards for leadership teams using Advanced Excel, SQL, and Power BI.
• Performed data validation, reconciliation, and quality checks across multiple systems to ensure reporting accuracy and consistency.
• Documented reporting methodologies, business logic, and data validation processes to ensure reporting consistency and knowledge sharing.
• Managed payroll-related datasets for multiple clients using internal SAS tools and Advanced Excel, ensuring accurate data validation, reconciliation, and timely processing.
• Conducted detailed data integrity and quality checks to support error-free payroll operations and reporting.
• Utilized Excel functions such as Pivot Tables, XLOOKUP, conditional formulas, and data validation techniques to streamline payroll reporting and reduce manual errors.
• Supported performance analysis for LSA adjudication operations by conducting periodic data analysis and developing dashboards in Advanced Excel to track operational efficiency, monitor KPIs, identify trends, and highlight improvement areas for leadership and operations teams.
• Built automated Excel trackers for monitoring Payroll Due Dates.
• Collaborated with cross-functional teams including Product, Operations, and Customer Success to resolve data discrepancies and improve reporting processes.
• Extracted and transformed data from databases using SQL for recurring business reporting and executive summaries.
• Supported leadership with ad-hoc analysis, trend reporting, and operational insights for decision-making.

Data Analyst - Brillica Services Pvt. Limited - Dehradun, India

(2023-09 - 2024-09)

• Worked with Salesforce-generated datasets, student enrollment data, and operational reports to support KPI tracking, business reporting, and management decision-making within the EdTech domain.
• Created and maintained Salesforce reports, Excel-based dashboards, and MIS reports to monitor student engagement, sales performance, lead conversions, and operational metrics.
• Performed data cleaning, validation, reconciliation, and reporting support activities to improve reporting accuracy, consistency, and data integrity across multiple reporting sources.
• Analyzed sales, marketing, and student performance datasets to identify trends, optimize campaign effectiveness, and support operational planning.
• Automated recurring reporting activities using Advanced Excel functions including Pivot Tables, XLOOKUP, conditional formulas, and data validation techniques.
• Collaborated with sales, operations, and student support teams to resolve reporting discrepancies and improve reporting processes.

Data Analysis - Freelancing - Dehradun, India

(2021-08 - 2023-06)

• Delivered reporting and data analysis solutions using Advanced Excel, SQL, and Power BI for clients across multiple domains. Worked on data cleaning, reporting automation, KPI tracking, and operational dashboard creation to support business decision-making.
• Developed interactive Excel dashboards using Pivot Charts, Slicers, Conditional Formatting, and Power Query.

Software Developer - Sudo Technologies, Dubai LLC - Dehradun, India

(2020-09 - 2021-04)

• Developed various websites, including an e-commerce store for beauty products and online forum websites, and successfully provided ongoing support.

Associate Software Engineer - Rubico IT Pvt. Limited - Dehradun, India

(2017-01 - 2020-08)

• Built various Websites and products including - "School Digital E- Pass System". Collaborated with the client successfully. Involved in working with Agile Methodology implementations such as Daily scrum meetings, sprint planning.

Master's In Computer Application - Computer Application - College of Engineering Roorkee (2015 - 2017)

Bachelor's In Computer Application - Computer Application - Dev Sanskriti Vishwavidyalaya (2012 - 2015)