Shilpi Roy

Data Analyst

Pune, Maharashtra 2+ yrs exp 91 · Outstanding

About

Data Analyst specializing in SQL, Power BI, Excel, and data visualization. Proven ability to analyze large enterprise telecom datasets, develop KPI-driven dashboards, and transform complex operational data into actionable business insights. Experienced in the telecom domain (Order Management Systems) with specific expertise in data validation, log analytics, database testing, and cross-functional collaboration to eliminate pipeline friction, resolve data anomalies, automate reporting frameworks, and deliver predictive operational and trend insights.

Skills & Expertise (28)

Power BI Advanced

8.0/10

Years Exp

Data Visualization Advanced

7.5/10

Years Exp

SQL Advanced

7.5/10

Years Exp

Python Advanced

7.5/10

Years Exp

ETL Advanced

7.0/10

Years Exp

Data Aggregation Advanced

7.0/10

Years Exp

Data Transformation Advanced

7.0/10

Years Exp

Data Validation Advanced

7.0/10

Years Exp

Data Cleansing Advanced

7.0/10

Years Exp

trend forecasting Advanced

7.0/10

Years Exp

Root Cause Analysis Advanced

7.0/10

Years Exp

Pandas Advanced

7.0/10

Years Exp

Excel Advanced

7.0/10

Years Exp

NumPy Intermediate

6.5/10

Years Exp

Databricks Intermediate

6.5/10

Years Exp

Data Warehousing Intermediate

6.5/10

Years Exp

Power Query Intermediate

6.0/10

Years Exp

DAX Intermediate

6.0/10

Years Exp

MySql Intermediate

6.0/10

Years Exp

Matplotlib Intermediate

6.0/10

Years Exp

Git Intermediate

6.0/10

Years Exp

GitHub Intermediate

6.0/10

Years Exp

Jira Intermediate

6.0/10

Years Exp

Tableau Intermediate

5.5/10

Years Exp

Oracle Intermediate

5.0/10

Years Exp

ChatGPT Intermediate

5.0/10

Years Exp

Microsoft Copilot Intermediate

5.0/10

Years Exp

Cursor Intermediate

5.0/10

Years Exp

Work Experience

Software Developer (Data & Business Intelligence)

Amdocs

Dec 2023 - Aug 2026

Optimized complex SQL queries, advanced joins, and aggregations to drive partner portal reporting and ensure data quality across enterprise systems. Directed structured root-cause analysis on customer transaction drop-offs and data anomalies, identifying fulfillment bottlenecks to mitigate operational costs and eliminate systemic data gaps. Designed and supported data engineering workflows using Python and SQL to ingest, clean, and map transactional datasets within cloud environments (AWS/Databricks), ensuring high data quality and schema compliance. Built, optimized, and maintained comprehensive Power BI dashboards, tuning DAX query speeds and semantic model efficiency to handle large datasets. Automated data pipeline testing, validation workflows, and data cleaning routines using Python and LLM-enabled generative AI tools (Cursor) during routine sprint cycles. Collaborated closely with cross-functional teams to translate raw business requirements into robust, compliant analytical solutions; prepared ad-hoc reports and predictive trend forecasting models to track data volumes and support strategic, data-backed roadmap decisions.

Business Associate Intern (Qliksense)

VOIS-Vodafone

Jan 2023 - Apr 2023

Built QlikSense dashboards to monitor daily operational KPIs and user experience metrics, developing automated reports to track business performance across indicators. Performed end-to-end data cleaning, variance reconciliation, and validation on source datasets using SQL, Python, and Excel Pivot Tables/lookup functions. Communicated analytical findings, operational risks, and process optimization strategies directly to senior management and strategy teams, translating complex data into clear PowerPoint presentations and performance insights.