Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sandhya Bondalakunta

Sr. Data Analyst
Bothell

Summary

Analyst with experience in business and finance area, with 6 years of experience organizing, modeling and analyzing data to forecast business trends. Efficient, decisive and thorough professional.

Overview

3
3
years of post-secondary education
7
7
years of professional experience

Work History

Sr.Data Analyst

Harman International
2019-03 - Current
  • Meet stakeholders, gather requirements, prototype , document and get sign off.
  • Handled 3 different team under same program working with vast amount of data sets.
  • Analyzed program data to provide input for key decision making and strategic planning.
  • Researched and recommended process improvements designed to mitigate operational and financial risk.
  • Provided reporting for audit insights at quarterly level and ad-hoc reporting in support of decision-making using Power BI
  • Validated results and performed quality assurance to assess accuracy of data.
  • Generated reports detailing findings and recommendations.
  • Designed SSIS Packages to transfer data from flat files to SQL Server.
  • Scheduled run for Power BI refresh and SSIS packages
  • Strong SQL skills with ability to write complex queries, CTEs(Common Table Expressions) and stored procedures and functions.
  • Skills in Microsoft BI stack (SSAS, SSRS, Power Pivot, Power View, PowerBI) .

Data Analyst

Harman International
2017-05 - 2018-10

Worked in Microsoft WDG team. Responsible for handling data about all Windows Devices. Involved in assessing data related to all Microsoft products campaigning and product related information and present inference with managers to better improve their advertising by providing them insights on view by category, subsidiary, Form codes etc.

  • Identified and documented detailed business rules and use cases based on requirements analysis.
  • Transformed project data requirements into project data models.
  • Created various Excel documents to assist with pulling metrics data and presenting them to give concise understanding of best placement for needed resources.
  • Created PBI reports and sore cards to summarize information at high level and provide insights.
  • Complex SQL queries to dig into and understand data.
  • SSIS packages to import data from Source system to SQL.

Data Analyst

Robustware
2015-10 - 2016-09

Worked with O365 Business Planning Team.

● Owned and implemented complete data analysis for Data Science group of O365 Platform.

● Extracted large sets of data, manipulated/transformed data using SCOPE, SQL and C# scripting through COSMOS to derive business interpretation.

● Building structured data pipelines.

● Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

● Writing SQL stored procedures for displaying and updating data in dashboards with Power BI

● Developing Node.js script to access API's.

● Collaborated with senior management, Data scientists to define business requirements.

● User documentation with technical specifications and methods of process.

● Scheduling jobs on ongoing basis to monitor results.

● Project documentation.

Software Developer

RobustWare
2015-02 - 2015-09
  • Performed software testing to uncover bugs and troubleshoot [Type] issues prior to application launch.
  • Created Test scenarios, test cases based on the requirements.
  • Perform User Acceptance Testing and unit testing for REST API's using C#.
  • Wrote complex Oracle SQL scripts to validate and verify back-end data
  • Effectively communicated test progress, results, and other relevant information to all the stakeholders and management.

Environment: Visual Studio 2010, SQL Server 2008, ASP.NET, C#, Quality Center, REST API, Visio PowerPoint

Associate Software Developer

Tata Consultancy Services
2008-04 - 2009-04

Project Description: Monitoring System is intended to deliver a system to support transaction management for the bank. The system is used for accepting loan forms, view history of transactions,

available balances etc.

  • Designed web forms using different HTML Controls.
  • Performed Database Operation-Inserting data, fetching of data and displaying on web controls
  • Designed and developed reports using SQL server reporting services.
  • Conducted module and regression tests.

Software Developer Intern

Indian Space Research Organization
2007-01 - 2008-03

Involved in development of sophisticated intranet system which performs assessment of the manpower required for accomplishing different projects in ISAC. The system should provide

information about applications, projects various divisions, activities, the required manpower and if necessary, their reallocation in different sections of ISAC. Main modules are: Manpower Assessment,

Scheduling and Control of Divisions.

Responsibilities:

● Involved in analyzing requirements and documenting.

● Prepared requirement analysis, design, coding.

● Involved in designing web forms.

● Client-side programming was done using C#

● Designed the queries, stored procedures using SQL server

● Prepared project documentation.

● performed unit testing, usability testing, user acceptance testing

Environment: C#.NET, SQL Server, Windows XP, Quality Center, Java script

Education

Master of Computer Applications - Computer Applications

JNTU
2004-08 - 2007-06

Skills

MS SQL Server 2017 SSRS/SSIS, Power BI, SSRS, Excel, PowerPoint, Tableau, Xflow, MS Visio, MS Excel, MS Power Point, MS Project. C#, DAX, MDX, Cosmos, Knowledge on hive/spark/Python, Excel for Data Analysis, SCOPE script, R, Adobe Analytics omniture, Data analysis, basic Python scripting Excel,

Use Cases

Data profiling

Activity diagrams

Data validation

Microsoft Visio

Data Analysis

Technical Analysis

Software Testing Life Cycle (STLC)

Business needs analysis

Timeline

Sr.Data Analyst

Harman International
2019-03 - Current

Data Analyst

Harman International
2017-05 - 2018-10

Data Analyst

Robustware
2015-10 - 2016-09

Software Developer

RobustWare
2015-02 - 2015-09

Associate Software Developer

Tata Consultancy Services
2008-04 - 2009-04

Software Developer Intern

Indian Space Research Organization
2007-01 - 2008-03

Master of Computer Applications - Computer Applications

JNTU
2004-08 - 2007-06
Sandhya BondalakuntaSr. Data Analyst