Pallavi Shetkar
TROY
Summary
Analytical and detail-oriented analyst with hands-on experience in data visualization, reporting, dashboarding with Power BI, and SQL. Strong analytical skills, problem-solving abilities, with a learning mindset, and a proactive approach.
Overview
17
17
years of professional experience
1
1
Certification
Work History
IT Business Process
Kautex Textron
09.2023 - Current
- Built and maintained 20+ end-to-end data pipelines, enabling the ingestion, preparation, and transformation of data from heterogeneous sources.
- Developed high-efficiency, reusable data flows that reduced data processing time by 30%–40% and improved pipeline reliability.
- Implemented Azure Synapse solutions that improved big data and warehousing integration, increasing query performance by up to 50%.
- Utilized Synapse SQL Pools, Spark Pools, and Data Lake storage to support analytics and ML workloads, accelerating model-ready data delivery by 25%.
- Translated business requirements into scalable data models and dashboards, improving stakeholder decision-making speed by 35%.
- Partnered with cross-functional teams across engineering, analytics, and product to streamline system integration, reducing data-related issues by 20%.
- Designed and published 15+ interactive Power BI dashboards, increasing data visibility and operational insights for business teams.
BUSINESS ANALYST
Vodafone Ltd.
09.2013 - 11.2015
- Led the elicitation, prioritization, and maintenance of network and downstream system requirements to ensure alignment with business and technical needs.
- Prepared comprehensive Functional Requirement Documents (FRD) and Change Request Documents (CRD) to support clear and traceable solution delivery.
- Reviewed High-Level Designs (HLD) and Low-Level Designs (LLD) with stakeholders, securing approvals across cross-functional teams.
- Collaborated with developers and stakeholders to design, validate, and refine end-to-end technical solutions.
- Analyzed test scenarios, validated requirements, and supervised User Acceptance Testing (UAT) to ensure solution quality and readiness.
- Managed project scheduling, progress tracking, and facilitated regular meetings to drive on-time delivery.
- Oversaw the complete migration of Intelligent Network (IN) systems from Siemens to Ericsson as an Associate Project Manager, from initiation through execution.
BUSINESS ANALYST
Tech Mahindra Ltd
08.2008 - 09.2013
- Gathered and documented requirements for Telecom Billing and Mediation systems, including detailed source-to-target data mapping.
- Developed high-level functional designs, conceptual data-flow pipelines, and comprehensive business requirement documents.
- Performed ad-hoc analyses to identify root causes of issues related to inventory support and operational data flows.
- Analyzed requirements using SQL sample data, UI screenshots, reports, prototypes, and existing data models to ensure accurate solution design.
- Built and enhanced downstream business logic using Perl scripting to support system integrations and data processing.
- Completed training in HTML and web development to support front-end and documentation needs.
- Automated data collection, decoding, and encoding processes using UNIX shell scripting on mainframe environments, improving operational efficiency.
- Evaluated new requirements for feasibility and contributed to end-to-end implementation across multiple project phases.
Education
BS - Computer Science
Visvesvaraya Technological University
India04.2008
Skills
- Power BI Desktop
- SQL
- Data Modeling
- Power BI Service
- Pyspark
- Data Visualization
- Power Query (M-Query)
- Python
- Agile Methodology
- DAX
- MS Office Suite
Certification
- ITIL 4 from PeopleCert
- ECBA from IIBA
- Scrum Master (PSM1)
Personal Information
Title: Business Intelligence Analyst
Timeline
IT Business Process
Kautex Textron
09.2023 - Current
BUSINESS ANALYST
Vodafone Ltd.
09.2013 - 11.2015
BUSINESS ANALYST
Tech Mahindra Ltd
08.2008 - 09.2013
BS - Computer Science
Visvesvaraya Technological University