Ramya Vaidya

Microsoft, Central Finance Planning and Analytics

• Developed and sent the weekly Flash report to the Microsoft CEO, CFO, and other members of the senior leadership team. Automated the report using VBA code to limit the manual additions which helped in delivering high quality report.
• Provided financial modeling and Commercial Revenue business performance analysis that enable global stakeholders to dynamically manage and change their business strategies.
• Drove rollover, management and maintenance for a variety of financial reports on a monthly, quarterly, annual and ad hoc basis using Advanced excel, VBA and Power BI.
• Lead and delivered high quality 24/5 support in a cross functional setting using Service Now platform for all production incidents. Provided incident management and resolution, including root cause analysis and triage of issues while communicating with the business partners within 24 hours.

Microsoft, Consumer Devices and Services (CDS)

• Worked closely with clients at CDS finance group to develop analytics that track financial performance indicators.
• In coordination with Office financial managers, created analytics that track attach percentages, product ratios and various KPIs.
• Built worldwide forecasting models for Azure consumed revenue, Surface, and Office.
• Prepared finance briefings for monthly close, automating the reporting process in Power BI and Excel, thereby reducing preparation time, and increasing data accuracy.

Microsoft, Customer Service & Support BI team

• Owned the Performance monitoring project. Created Performance monitor counters and SQL Server Profiler trace to monitor SSAS tabular models for system performance and user activity.
• Assisted the developer in writing PowerShell Scripts to automate the starting and stopping of the traces.
• Created ETL process to load the trace data and perfmon data into SQL table.
• Created customized Power BI dashboard that analyzed the Performance of the tabular.
• Decommissioned reports using older platforms like SSRS and rebuilt them using PowerPivot and Power BI.

King County

• Mapped data to newer touchscreen system from the older manually entered data using MSSQL to help King county government make decisions on where and how many STD clinics they need in the King County region.
• Identified data inconsistencies in the ETL process and fixed them within tight timelines.
• Created and maintained stored procedures and scheduled them through a SQL job on a cadence to refresh the data in report.

• Developed business process diagrams by working with customers and other analysts.
• Worked with stakeholders to discover and categorize high-level user stories for the development teams including acceptance criteria via story mapping sessions.
• Engaged with Product Owner to prioritize sized user stories.
• Developed test cases and test scripts (automated and manual), based on acceptance criteria, in support of test-driven development.
• Facilitated communication between Product Owner and the developers on the assigned Scrum Team.
• Led Daily Scrum Meetings, Sprint Planning, Sprint Review, and Sprint Retrospective Meetings.