Sandhya Bondalakunta

• 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) .

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.

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.

• 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

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.

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