Mayank Tripathi Email & Phone Number

Bellevue, Washington, United States

Seattle, Washington, United States

Working on integrating and loading customers’ order data along with other datasets.Producing various FinTech reports which is used by accounting and audit teams toeffectively track the various revenue and cost KPIs which then used to take actions tomaximize profits.

Greater Seattle Area

• Executed migration of data pipeline for Microsoft azure incident data from SQL Server to azure data explorer to increase the availability of data up to 99% for partner teams.
• Built and maintained an incident data warehouse by integrating the data from multiple data sources using SSIS and Azure data factory. This helped teams to mitigate the incidents within 15 minutes.
• Created a COSMOS based data pipeline using SCOPE script to pull terabytes of data to enable communication teams meet their SLA more than 90% times in case of service outages.
• Created business dashboards using Power BI for partner teams which help them enhance the azure customer's overall experience.
• Created proactive support data dashboard in Power BI with a set of business KPIs using DAX for azure operations team that helped them reduce the daily ticket volume by up to 40%.
• Gather and analyze business and functional requirements from customer stakeholders. Assign monitor and support team for timely deliveries.

Bengaluru Area, India

• Data Analysis, Requirements Analysis, Designing ETL & Reporting Solutions, Peer Review, providing support to the Business Users on the BI Application, performing maintenance & support activities post Go-Live.
• Data Warehouse design, ETL, Reporting framework
• OLAP design, partitioning and performance tuning
• SQL stored procedure, functions, views and performance tuning
• Identifying Business KPIs and SSRS/Power BI dashboard design
• Worked on delivering end to end BI solution to CPG, Banking customer