Jyoti Agarwal Email & Phone Number

Redmond, Washington, United States

United States

• Automated CO2 emission Inventory report for the City of Seattle using Power BI, which reduced the manual effort by ~200 hours every year. • Set up Azure SQL Managed instance and replicated databases from a on-premises server to Azure server. Created custom visual in Power BI using Node.js.• Created a dashboard in Dynamics 365 to provide sales insights to leadership.• Automated the sales process in Dynamics 365, which reduced the manual effort by ~10 hours per week.

United States

• Drove migration from the Corpnet domain to the Azure management environment (AME) domain for Azure services.• Collaborated with various teams such as Cloud & Enterprise (C+E) Security, Azure Active Directory (AAD), Azure Resource Manager (ARM), Azure Internal Billing system (AIRS), Just in time (JIT), and Payment and Operations (PayOps) to drive feature development for migration, and resolve migration blockers• Conducted workshops, office hours, and email campaigns for AME migration and AME Secure Admin Workstation (SAW) adoption.• Created Power BI dashboards by querying data from various data sources such as SQL, Kusto, and Cosmos stream to simplify the migration process, and provide the status to the leadership.

Greater Seattle Area

• Managed revenue recognition and online services modules for MS Sales. MS Sales is Microsoft's worldwide revenue reporting tool and provides 21 years of revenue details for all businesses and channels across Microsoft. • Managed product backlog, and led bug triage, sprint review and sprint retrospective meetings.• Worked with Microsoft Finance BI team to gather business requirements, converted them into user stories, reviewed technical specifications, performed testing, and sent release communication.

Redmond, Washington

• Defined the business rules of assigning the revenue to sales accounts by working with Finance Manager and automated it by myself using SQL scripts. Achieved a savings of ~2000 manual hours per year and 100% revenue accuracy. • Collaborated with various business partners (Incentive Plan Design, Finance, Quota Management) to gather and prioritize requirements for Deal Based Compensation system which was part of Worldwide Incentive Compensation (WWIC).• Led the quarterly payout process for Deal Based Compensation program including communication to the senior leadership of payout health, milestones tracking and identifying risks & issues. • Developed daily, weekly, and quarterly reporting frameworks in Power BI for providing programs performance insights to leadership

Hyderabad Area, India

• Received consistent high-performance review ratings, resulting in promotion to a Project Manager role in the fast-track program. Supervised a team of 9 developers and 3 Team leads – work allocation, mentoring, and performance reviews.• Led development of complex web application for Infosys deal's cost and margin analysis. Won an award for displaying keen business acumen and excellent partnering with the client team.• Improved customer satisfaction index from 70% to 95% by developing user-friendly features and fulfilling training needs. Became the first project in the department to attain the highest process maturity level, CMMI level 5.• Led “Infosys Science Foundation” project as additional responsibility when existing project manager left the team. Quickly learned, gained the trust of business stakeholders and released the changes on time with high quality.

United Kingdom

• Onshore coordinator for play.com which was an online shop for electronics and other consumer products. It was ranked UK's second favorite music and video retailer.• Developed and performance tuned slow running data warehouse reports.• Developed a web service for discount vouchers using C#.NET

Bengaluru Area, India

• Performed feasibility analysis, proof of concept, design, development, and deployment of ProjectBudgeting system (PBS). Won outstanding performance award for ensuring the re-engineered PBS application is best-in-breed.• Led a group of 8 engineers in the design, and development of ASP.Net based multi-layered webApplication with SQL as backend.• Automated Percentage of completion calculation using Excel macros which saved 100 hours effort every quarter.