Pranavika Reddy

Actively participated in team meetings to share knowledge, exchange ideas, address challenges, and collaborate on potential solutions.

Improved business processes by analyzing current practices and recommending optimization strategies.

Optimized workflow processes to enhance overall productivity and achieve operational excellence.Led remote development and maintenance of BI applications tailored to Canadian Tire's needs, leveraging SQL Server, SSRS (Reporting Services), SSAS (Analysis Services), SSIS, ETL, and dimensional modeling.

Generated comprehensive reports via SSRS and orchestrated ETL processes using SSIS packages, ensuring seamless

data flow and transformation.

Designed and implemented ETL workflows, integrating slowly changing dimensions, aggregation, and cube

processing to optimize data warehousing and analytics.

Documented ETL mappings and crafted data flow diagrams to visually represent data transformations and enhance

understanding.

Remotely addressed data-related issues, conducted rigorous data validation, and performed ETL and Slowly Changing

Dimension validations for database system.

Analyzed financial, operational, and technical data to generate actionable reports that supported strategic decision-making across departments.

Identified and resolved process inefficiencies by recommending automation and cost-saving solutions, improving operational workflows.

Supported company-wide project implementations, including system testing, user acceptance testing (UAT), and rollout of new customs applications.

Created and maintained dashboards and KPIs for performance tracking and compliance reporting using tools like Power BI and Excel.

Collaborated with cross-functional teams to gather requirements, document business processes, and ensure adherence to internal quality standards.

Enhanced stakeholder communication by creating easy-to-understand visualizations of complex data sets.

Collaborated with cross-functional teams to optimize workflows and drive process improvements.

Designed and built a dimensional modelling data warehouse, a tabular cube, and Power BI dashboard of online sales

using Azure Data Warehouse, Azure Analysis Services cube, and Power BI.

Spearheaded a major pricing restructure by redirecting focus on consumer willingness to pay instead of product cost;

implemented a three-tiered pricing model which increased average sales by 35% and margin 12%

Mainly engaged in Data Migration utilizing SQL, SQL Azure, Azure Data Factory, and SSIS.

Developed Pipelines within ADF using Linked Services, Datasets, and Pipelines to Extract, Transform, and Load data

from diverse sources including SQL Database and Blob storage.

Implemented incremental loading on a daily basis. Proficiently operated SSRS to generate intricate reports sourced

from various data repositories like SQL Database.

Generated dashboard reports using Power BI Desktop tailored to meet stakeholders' business requirements. Produced

Power BI reports, established workspaces, dashboards, Row-Level Security (RLS), gateways, and scheduled refreshes.

Led training sessions on advanced BI tools and implemented a peer-review process for reports. Resulted in 50% faster

turnaround time and improved data quality, also fostering a collaborative team-based environment and hands-on

approach to deliver optimal data solutions.

Conducted deep-dive investigations into suspicious seller behaviours using SQL-based data analysis and surfaced patterns used to implement new prevention mechanisms.

Devised a scalable data architecture that facilitated seamless data aggregation, enabling real-time analytics; utilized by over 15 analysts to drive strategic initiatives and enhance reporting capabilities across the organization.

Extensive experience with Microsoft SQL Server for database development, management, and optimization.

Performed data analysis using Python (Pandas, Numpy).

Developed and maintained robust information systems to support data analysis and decision-making processes.

Created dynamic and interactive dashboards with Power BI and Tableau, facilitating real-time of visualizing data and enhanced data interpretation for cross-functional teams.

Leveraged intermediate to advanced Excel functions(Lookup Function, date & time functions, pivot tables, Macros &VBA) and SQL queries to analyze large datasets, optimize reporting processes, and generate actionable insights.

Applied Excel’s data cleaning features such as text-to-columns, data validation, and conditional formatting to ensure data integrity and consistency.

Provided top-tier customer service with a focus on integrity, ensuring client satisfaction and fostering long-term relationships.

Expertly crafted complex data visualizations and dashboards using Power BI and Tableau, enabling clear and impactful data storytelling for business stakeholders.

Implemented rigorous quality assurance processes to ensure data accuracy and reliability

Utilized Excel to perform advanced data analysis, including the creation of pivot tables, VLOOKUP, and complex formulas to generate detailed insights from large datasets.

Developed automated processes using Visual Basic programming and VBA, enhancing efficiency and reducing manual errors.

Strong decision-making abilities which exhibited a real passion for solving complex problems through robust data analysis, leading to well-informed business decisions.

Collaborated with product management teams to align data engineering efforts with business goals and product strategies, effectively translating business requirements into technical specifications and deliverables.

Collaborated with cross-functional teams by sharing and managing Excel spreadsheets on cloud-based platforms like SharePoint, ensuring real-time data updates and accessibility.

Gained knowledge of Benefits Administration Systems, contributing to improved data handling and system efficiency.

Retrieved and aggregated data from multiple sources (Amazon Redshift, S3, Athena) to create actionable insights for the Selling Partner Risk team, influencing critical business decisions.

Designed and developed SQL-based dashboards to track seller success metrics and policy adherence, reducing manual investigation efforts by 30%.

Built automated reports using Amazon QuickSight to monitor marketplace abuse trends and policy enforcement effectiveness, enabling timely escalations and interventions.

Worked with large datasets (100M+ rows) to analyze seller lifecycle, detect anomalies, and improve the overall health of the selling partner ecosystem.

Delivered self-service BI dashboards and visualizations for cross-functional stakeholders using Power BI and Tableau, enhancing visibility into seller performance metrics.

Partnered with scientists and engineers to evaluate and refine machine learning models aimed at preventing bad actors, contributing to a 25% improvement in detection accuracy.

Led requirements gathering sessions and documented business logic for key safety initiatives, ensuring alignment between technical solutions and business needs.

Collaborated in the development of SQL server database systems, optimizing performance to meet client needs effectively.

Assisted senior data scientists in designing ETL processes, contributing to the creation of SSIS packages.

Utilized MongoDB to establish and manage NoSQL databases, aggregating data from diverse sources for enhanced accessibility and usability.

Maintained data integrity across relational and non-relational databases, ensuring consistency and reliability.

Collaborated with product management teams to align data engineering efforts with strategic business goals, enhancing the decision-making process.

Implemented complex stored procedures to support application logic, ensuring seamless integration with business applications and services.

Expert in crafting complex SQL queries to retrieve and manipulate data efficiently, supporting various business operations and data analysis tasks.

Optimized SQL queries for performance improvements, ensuring quick and accurate data retrieval from relational databases.

Delivered impactful presentations on data findings and project outcomes to senior management..