Suryateja Ravuri

Rational, critical-thinking MSBI Consultant & Power BI Developer with 6 years of experience enhancing operations for organizations through information systems solutions. Proven track record of transforming specific business goals related to growth and efficiency improvements into new system designs. Knowledgeable innovator known for recommending new technologies to enhance existing systems and introduce new systems.

• Awarded with multiple Spot awards in Sonata (“Play to Win”, "Run for It",“Everyone Counts” and “Emotions @ Work”) for the contribution in multiple projects.
• Part of the team which received the “Team of the Quarter” award in the Quarter of July-Sep 2014.
• Part of the team which received the “Team of the Year” award for the year 2018-19.

MSCE: 70-778: Analysing and visualizing data with Power BI

Senior Business Intelligence Analyst (Feb 2020- Till Date)

Microsoft WE HQ

As part of Western Europe Marketing and Sales Operations team (WE BSO BI Team), responsible for building Western Europe specific reports to bridge the business gaps and provide detailed insights on the business performance across segments.

Responsibilities:

• Working intensively with Power BI and Excel Power Pivot.
• Building dashboards to support different business aspects at Microsoft.
• Providing ad-hoc analytics.
• Building databases to store and stage data.
• Developing power automated flow to follow Data owners to get monthly or weekly data files/sets.

Senior Business Intelligence & Power Platform Developer (May 2019-Feb 2020)

Microsoft Corp HQ

As part of M&O App support team, responsible for automating the follow up process with business stakeholders on the issues/concerns from field users and automating the process of requesting proxy access and approvals for the same, to avoid to and from mail conversations between requester, support team and approver.

Responsibilities:

• Built some Power BI reports on the Incidents worked by support team and provided insights by monthly and by business to estimate/forecast workload expected for current month and future months.
• Developed couple of Power Automate flows to send reminders/automated emails to Business stakeholders on the active/scheduled asks from field users where stakeholders response required.
• Proposed and worked on PowerApps solution to automate/reduce manual effort and speed up the process of Proxy access approvals.
• Developed two power apps, one to log the request and another for approvers to exercise on the access request.

Business Intelligence & Power BI Developer (Jan 2017-May 2019)

Microsoft Corp HQ

The ROB process is key for supporting the SMSG Management system. By using the ROB process, the field can request support while also providing insight on their business and opportunities for assessing field performance. Expected outcomes of ROB Process were increased business predictability, increased business consistency and simplified process.Modern ROB process aims at One Engine across Finance/BGs/Segments/M&O, Automation to eliminate manual and redundant work in field and Corp, Optimization of platforms to reduce costs & speed delivery and Modern Experience to provide insights not just data.

Responsibilities:

• Understanding the business requirements and converting them into BI solutions
• Identified the gaps between the requirements and the available data at the source.
• Modified already existing/creating new reports based on the requirements.
• Analyzed the feasibility of replicating the Excel charts with Power BI reports and identifying the gaps.
• Configured the Enterprise/Personal Gateways to publish model-based Power BI reports to Power BI workspaces, through which we can automate and schedule the report refresh.

Business Intelligence Developer(Aug 2014-Dec 2016)

Microsoft Corp HQ

Core BMX team develops elegant reports and dashboards, using Microsoft Excel, Power Pivot and Power view and provides detail data. Which will be handier to end users to track their business with KPIs. But it is very hard to fulfil end users never ending data thirst.So, this process of the developing Ad-hoc reports to the field users, where the standard reports do not fulfill their requirements. In such scenarios, field users reach out to business owners with the requirement. Developing the Ad Hoc Reports according to the customer requirements. Gathering and analyze business end user data and identifying gap analysis strategies of customer requirements with respective to source systems and technology feasibility. Each Report has its own significance of data and data must be sourced from various types of systems. These reports help the end users to analyze their revenue forecasting, pipeline management and the budget attainment.

Responsibilities:

• Understanding requirements and identifying gap analysis of customer requirements with respective to source systems and technology feasibility
• Collaborated with corporate executives to identify needed business intelligence systems and implementation strategies.
• Developed new stored procedures to pull the data from different sources.
• Developed the load stored procedure for implementing end user’s esteemed business logic.
• Creation of new SQL database fetching the data from multiple data sources using SSIS packages to a central location .
• Scheduling the SSIS packages to extract and load the data into reporting databases using SQL Server Agent.
• Creation of Excel reports and dashboards as per the client requirements.
• Automated some reports refresh whenever the user want to pull latest information into report using excel VBA.
• Taking care of refreshable reports of recurring releases of the reports on defined frequency(weekly, monthly, Quarterly).
• Addressing end user’s ad hoc (On demand) request’s instantly.
• Maintained data privacy and followed rules regarding data security.

I solemnly do here by declare that all statements made here are true to the best of my knowledge and belief.