Summary
Overview
Work History
Education
Skills
Websites
Certification
Accomplishments
Timeline
Generic

SUSMITHA VANKAYALAPATI

Redmond,WA

Summary

Highly skilled Senior BI Engineer with 8+ years of experience in a robust background in managing business intelligence platforms, data warehousing, and data analysis. Possess strong technical acumen in SQL scripting, ETL processes, and BI tools like Power BI to deliver insightful reports for strategic decision-making. Demonstrated leadership in building cross-functional teams and driving initiatives that improve efficiency. Made significant contributions in previous roles by optimizing systems and implementing innovative solutions to enhance data integrity.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Senior BI Developer

Microsoft
Redmond, WA
04.2023 - Current
  • Built and executed end-to-end BI solutions, encompassing data extraction, data preparation, data cleaning, data processing, and data modeling
  • Utilized cloud computing technologies to enhance system performance and leverage Microsoft products for improved deployment processes
  • Analyzed data to identify and resolve conflicts between systems
  • I extracted datasets from ADLS and moved them to Azure SQL Database using Azure Data Bricks and Azure Data Factory
  • Implemented cutting edge technology to increase data retrieval speed by 40% and cut report execution time by 1 hour utilizing predictive analytics techniques and statistical modeling
  • Created SQL queries using stored procedures, views, tables, etc
  • For analysis and implementing new requirements, while adhering to privacy policies
  • Conducted statistical analyses to validate data integrity and reliability
  • Tracked and completed sprint tasks using Azure DevOps, deploying code changes to production
  • Led fabric migration by moving all objects from Paas SQL, ADF Pipelines and Azure notebooks to a unified fabric environment
  • I unified objects within the fabric environment to improve data management efficiency, utilizing technology transfer best practices
  • Provided ongoing support and training to business users on BI tools and reports

Senior BI Developer

Walmart
Bentonville, AR
10.2022 - 04.2023
  • Developed and enhanced BI solutions for Walmart's online application
  • I introduced BI Solutions to meet business objectives by utilizing data collection techniques to gather user insights
  • Used interviewing methods to understand user needs, influencing design and functionality
  • I wrote and maintained complex SQL queries and stored procedures to extract and transform data from various sources by utilizing analysis tools
  • Applied research and expertise in computer engineering to enhance functionality and ensure robust system design
  • Collaborated across multiple teams to address and resolve production issues while orchestrating ethics around data handling
  • Engaged in detailed statistical analysis using various statistical analysis tools to provide insights and strategic recommendations for operational improvements
  • Developed and implemented Power BI visualizations to improve data visibility and support data-driven decisions
  • Employed algorithm design principles and statistical analysis techniques for optimization of processes
  • Utilized DAX functions for data modeling and produced dynamic charts and graphs in Power BI with an emphasis on literature and presentation aesthetics, ensuring publication quality outputs
  • I examined data with Power pivot and visualized reports with Power View and Power Map
  • I designed a new Data Warehouse solution that increased report speed by 30% while maintaining a predictable workflow

Senior BI Developer

Microsoft
Hyderabad, India
11.2020 - 09.2022
  • I engaged with business analysts and end users to gather requirements and ensure that BI solutions met their needs focusing on capability management
  • Established interactive dashboards and reports in Power BI to help stakeholders monitor key performance indicators and track business metrics
  • I wrote complex SQL queries to retrieve detailed data from tables, enhancing the data pipeline efficiency
  • Testing the effectiveness of dashboards through user feedback enhanced my adaptability to changing requirements
  • I worked with tables, views, stored procedures, functions, triggers, and CTES
  • Object recognition capabilities were implemented to identify trends and patterns in data
  • Organized and debugged the Power BI gateway, ensuring optimal functionality
  • Implemented guidance for users to navigate the BI reports effectively
  • I set up role-based row level security (RLS) to protect data
  • I used DAX functions for Aggregation, Logical operations, Filtering, String manipulation, and date handling
  • I deployed SSIS packages and scheduled SQL Server Agent jobs to automate SSIS package execution.
  • Onboarding junior team members into the project and enabling them with essential tools and practices, fostering an atmosphere of coaching and approachability

BI Developer

Microsoft
Hyderabad, India
11.2019 - 10.2020
  • Improved the performance of BI reports and dashboards for faster insights and a better user experience, incorporating art research techniques to refine outputs
  • Participated in knowledge-sharing sessions to inspire and guide team members
  • I shared findings with management to support data-driven decisions across the firm through detailed data/information analysis and wrote white papers on best practices in BI development
  • I set up data integration pipelines, ETL Processes, and data warehousing systems to ensure accurate data flow while safeguarding intellectual property rights
  • I setup, arranged, and upheld the Power BI Report Server
  • Prepared builds and deployed them to the Pre-Production environment at the end of the sprint, taking responsibility for the team's deployment practices
  • Obtained Go/No-Go decisions from stakeholders before deploying releases to the Live environment
  • Initiated and preserved user accounts, roles, and privileges
  • Configured admin settings in Power BI admin Portal including user management and gateway administration

BI Developer

Efftronics
Vijayawada, India
06.2016 - 08.2019
  • I handled railway signaling systems and managed railway architecture zones, divisions, and networks
  • Gathered requirements from domain experts and site managers and investigated the data for cohesive data pipelines
  • Utilized formulation of approaches to ensure system designs met operational needs
  • Generated database models based on business needs after analyzing the data covering various electrical engineering principles
  • I was involved in migrating the SSRS reports to Power BI enhancing the reporting capabilities across the board by incorporating Microsoft product features
  • I have fixed data gateway issues by reconfiguring settings, adding new data sources, and managing credentials
  • Led team sessions for assisting onboarding processes
  • Tracked industry trends and recommended best practices to improve business intelligence methods while maintaining compliance with ethics in data processing, ensuring consistent quality outputs
  • Participated in cross-functional meetings to understand business needs and deliver insights with a focus on continuous improvement
  • Led a successful fabric migration project, consolidating all objects into a single environment and increasing operational efficiency
  • Applied technology and innovation to ensure streamlined data flows while improving onboarding practices for new talent
  • Emphasized the responsibility of guiding new team members through complex BI solutions

Education

Bachelor's degree - Computer Science Engineering

Vignan Lara Institute of Technology And Science
India
04-2016

Skills

  • Power BI desktop
  • Power BI Service
  • Power BI Gateway
  • Power BI Premium
  • Power BI admin
  • DAX Functions
  • Power BI Report Server
  • SQL Server
  • Advanced Excel
  • Power Apps
  • Microsoft Fabric
  • Azure Data Factory
  • Azure Databricks
  • Azure Logic Apps
  • Business Intelligence
  • Data Integration
  • Data Visualization
  • Azure DevOps
  • Python
  • SSIS
  • Azure SQL
  • Data Extraction
  • Data Modeling
  • Data Warehousing
  • Agile
  • Oracle
  • Git
  • Data Explorer
  • SSRS Reports

Certification

  • Microsoft Azure Fundamentals (AZ900)
  • Microsoft Power BI Data Analyst Associate (PL300)
  • Microsoft Azure Data Engineer Associate (DP-203)

Accomplishments

  • Optimized Reporting Processes: Reduced report execution time by 30% through optimized ETL workflows and database performance tuning, demonstrating initiative and leadership in process improvements.
  • Data-Driven Decision Making: Enabled data-driven decision-making across multiple departments by developing and deploying over 50+ Power BI reports and dashboards, consistently providing guidance to ensure user effectiveness.
  • Successful Migration: Led a successful fabric migration project, consolidating all objects into a single environment and increasing operational efficiency.

Timeline

Senior BI Developer

Microsoft
04.2023 - Current

Senior BI Developer

Walmart
10.2022 - 04.2023

Senior BI Developer

Microsoft
11.2020 - 09.2022

BI Developer

Microsoft
11.2019 - 10.2020

BI Developer

Efftronics
06.2016 - 08.2019

Bachelor's degree - Computer Science Engineering

Vignan Lara Institute of Technology And Science

Similar Profiles

CREATE PROFILE
SUSMITHA VANKAYALAPATI