Senior Data Analytics & BI Professional

Utsav Rana

*************@*****.*** +1-602-***-**** linkedin.com/in/utsav-rana-326b92231 gitHub.com/utsav-rana25

Profile

Results-driven Data Analytics & Business Intelligence professional with around 3 years of experience transforming complex datasets into actionable insights across consulting, telecom, and technology domains in India and the US. Proficient in building scalable ETL pipelines, designing data models, and developing interactive dashboards using Power BI, SQL, Python, and Azure Databricks, with strong command over DAX, data visualization, and KPI optimization. Experienced in implementing data governance frameworks, metadata management, and data quality controls to ensure analytics accuracy and consistency. Currently advancing enterprise reporting and business transformation initiatives as a Business Analyst at Tetra Tech, United States.

Technical Skills

Data Ingestion & ETL: Azure Data Factory, SSIS (SQL Server Integration Services), Power Query (M language).

Database & Warehousing: Microsoft SQL Server, Azure Synapse Analytics, Azure SQL Data Warehouse.

Data Modelling & Semantic Layers: Star schema design, fact & dimension tables, tabular modelling in Power BI, DAX (Data Analysis Expressions).

Data Transformation & Scripting: Python (pandas, NumPy, scikit-learn), PySpark, Jupyter notebooks.

Business Intelligence & Reporting: Microsoft Power BI (Designer, Service, workspaces), Tableau.

Performance & Optimization: SQL query tuning, indexing, table partitioning, incremental dataset refresh.

Data Governance, Security & Compliance: Row-Level Security (RLS), Azure Active Directory groups, metadata lineage, audit logs, master-data-management (MDM).

Analytics & Insight Extraction: Exploratory data analysis (EDA), time-series forecasting, segmentation/clustering, churn- propensity modeling.

Delivery & Methodology Skills: Agile/Scrum (sprints, backlog grooming, user-stories), Jira, version control (GitHub).

Other Tools & Techniques: Microsoft Excel (advanced pivot tables, macros), Power BI templates & shared data-flows, ETL metadata documentation.

Professional Experience

Data Analyst, Dell Technologies Aug 2025 – Present United States

&Collaborated with US federal and municipal clients to elicit business requirements, define program-KPIs and translate them into BI deliverables, authored BRDs, user-stories and functional-specifications that drove analytics architecture and roadmap.

&Designed and deployed enterprise-scale Power BI dashboards integrating multi-source datasets (CSV, REST APIs, SQL databases, ServiceNow) to reflect real-time program-performance and enable C-level stakeholder decision-making.

&Architected and orchestrated modular data-transformation pipelines in Azure Data Factory and PySpark that processed 1 million+ records daily; delivered reusable ETL components that reduced manual interventions by 50%.

&Applied Agile/Scrum cadence (sprint-planning, backlog prioritization, daily stand-ups, reviews) to deliver minimum-viable- products every sprint, aligning tech delivery with business value and reducing time-to-market by 25%.

&Defined and implemented a data-governance framework for analytics engagements: created metadata-catalogues, defined master-data-management (MDM) practices, applied row-level security and aligned deliverables with US regulatory frameworks.

&Conducted root-cause analysis on program-performance variances by authoring dynamic SQL queries, applying statistical testing in Python and building narratives that delivered cost-saving insights worth up to USD 2 M annually.

&Mentored and on boarded junior analytics engineers and data-analysts; guided upon BI-tool best-practices and training materials—improving team productivity by 20% and reducing ramp-up time.

BI Engineer, HCL Technologies Jun 2023 – Aug 2024 India

&Engineered an enterprise semantic model in Power BI (tabular mode) with advanced DAX measures, hierarchies and perspectives; ensured business users across APAC/EMEA/US could self-serve customer-lifecycle insights, reducing ad-hoc report requests by 35%.

&Implemented incremental-refresh and scheduled gateway refresh for datasets in Power BI Service pulling from Azure SQL Data Warehouse, processed 50+ million rows per run and achieved daily refresh windows under 4 hours.

&Built a library of Power BI template files, Power Query functions (M-language) and shared data-flows to standardize reporting across Business Units, accelerating new dashboard builds by 30% while enforcing governance and branding.

&Defined governance protocols for Power BI workspace access: established row-level security roles, dataset-workspace lineage documentation and usage audit logs; aligned with enterprise compliance standards and data-catalog requirements.

&Led Agile delivery (two-week sprints) for BI feature development—initiated sprint-planning, backlog grooming, daily stand- ups and UAT sign-off—delivering 10+ dashboards per quarter that matched business value and sprint metrics.

&Created executive-level dashboards for margin-analysis, product profitability and pipeline health via Power BI; collaborated directly with US leadership to translate analytic findings into board-ready presentations influencing FY 2023 pricing strategy.

&Diagnosed poor dashboard performance by rewriting inefficient DAX expressions, removing redundant relationships, and enabling dataset partitioning in underlying Azure SQL tables; improved average visual load time from 7 s to under 3 s for 70% of reports.

&Mentored junior BI developers and analysts on data-modelling in Power BI, DAX optimization and visual best-practices; improved report-accuracy metric by 20% and reduced production defects.

Data Analyst (Internship), Tech Mahindra Mar 2020 – Aug 2021 India

&Developed and executed SQL queries in Microsoft SQL Server to extract 0.6 million service-desk and CRM records; structured the staging environment for analytics deliverables, laying a scalable foundation for downstream BI.

&Cleaned and transformed raw ticketing and customer-interaction datasets using Python (pandas) and advanced Excel functions, decreasing data-prep cycle by 30% while improving accuracy across key KPI datasets.

&Built a Power BI prototype dashboard for first-response time, ticket-escalation trends and SLA compliance, enabling operations leads to monitor backlog hotspots and drive corrective actions.

&Mapped end-to-end data-flows across ITSM/Service-Desk systems and documented metadata and lineage in collaboration with process owners, supporting internal audit readiness and data governance.

&Assisted in designing SSIS packages to automate monthly ingestion of service-desk logs into the EDW, including validation checks that ensured less than 2% variance against source systems.

&Conducted ad-hoc root-cause analysis using pivot tables, Excel macros and summary statistics to identify a 12% uplift opportunity in ticket-closure rate, which was escalated to the operations steering committee.

&Created training-documentation for non-technical frontline managers on accessing self-service Power BI reports, reducing dependency on IT for basic query requests by 25%.

Projects

TechSupport 360 Analytics Platform Digitech Inc,

Tools : PySpark, Databricks, SQL, Power BI, Tableau

Mar 2025 – Apr 2025

&Architected a three-tier “bronze-silver-gold” data lake framework on Azure Databricks, ingesting 30K+ service-desk records from API and batch sources, and applying schema evolution and data-versioning for traceability.

&Developed PySpark transformation pipelines in Databricks, converting raw event logs into structured silver tables, then into curated gold fact and dimension tables using dimensional modelling to support analytics atop SQL relational store.

&Implemented a data-quality framework with anomaly detection and rule-based validation, flagging issues early and improving downstream dashboard accuracy by 20%.

CX360 – Customer Journey Insights Hub Arizona State University,

Tools : Power BI, SQL, Tableau

Feb 2025 – Mar 2025

&Developed interactive dashboards in Power BI and Tableau visualizing journey funnels, satisfaction-index trends, channel- drop-offs and pricing-impact analytics; provided executives with intuitive drill-throughs into specific cohorts.

&Implemented data-profiling techniques (null-value heat maps, distribution checks, skew detection) on integrated datasets to surface data-quality issues that, once remediated, increased model-trust and reduced ambiguous insights.

&Facilitated cross-functional workshops with marketing, pricing and CX teams to interpret dashboard results, prioritize improvement initiatives and map actionable business outcomes.

Education

Master of Science in Business And Big Data Analytics,

Arizona State University

Bachelor of Technology in Information Technology Engineering,

Mumbai University

Certificates

May 2025 Arizona, US May 2024 Mumbai, India

Contact this candidate