Sruthika Gadhari Email & Phone Number

Middlesbrough, Gb

United Kingdom

• Created and maintained DB objects, stored procedures, and ETL processes.• Created Azure Analysis Cubes for evolving report requirements.• Migrated SSAS cubes from 1200 to 1400 compatibility level.• Designed Power BI reports with SSAS Tabular model and DAX measures.• Implemented diverse Power BI dashboards and reports.• Developed SSIS packages for efficient cube partition processing.• Created, configured, and deployed SSIS packages, scheduling through SQL Server Agent.• Continued Power BI dashboard development based on specific needs.• Enhanced SSRS and Power BI reports for improved functionality.• Developed tuned SQL queries, incorporating indexes, views, and stored procedures.• Automated SQL jobs and adept at analyzing and troubleshooting SQL server processes.

India

• Imported SQL data to Power BI, crafted DAX Queries for reports, improving decision-making by 60%. • Enhanced database performance through object creation and Power BI tools.• Published reports and dashboards across web and mobile platforms and Documented reports and facilitated knowledge transfer sessions.• Developed 15+ data models, optimized stored procedures, and created 30+ SQL/SSIS reports.• Led Performance Tuning, Query Optimization, and hands-on Data Flow transformations.• Expert in Star Schema, Snowflakes Schema, and Agile-Scrum processes.

Hyderabad, Telangana, India

• Collaborated in planning sessions to analyze business requirements and propose solutions.• Implemented 3 data schemes and optimized 10+ data flows for reporting performance.• Collaborated together to collect business needs for Colour Pop's sales analysis from its stakeholders.• Designed Power BI dynamic dashboards with performance metrics and actionable insights.• Pulled data from diverse sources like SQL Server, SharePoint, Excel, and CSV into Power BI.• Created intuitive dashboards illustrating yearly sales trends, revenue growth, and profit margins by state.• Designed impactful sales dashboards with essential performance indicators.• Utilized Power Query for data transformations and cleansing to ensure data accuracy and consistency.• Refined dashboards iteratively based on stakeholder feedback and evolving business requirements.• Crafted user training materials and led effective sessions to empower stakeholders in dashboard utilization.• Ensured seamless navigation and interactivity within the dashboards to facilitate easy exploration of sales metrics and trends.• Achieved a 65% increase in customer satisfaction by delivering quality reports after QA checks.• Integrated diverse data sources including transactional databases, CRM systems, and external APIs to consolidate sales data for comprehensive analysis.• Prepared meticulous documentation including user guides, technical specifications, and troubleshooting manuals to facilitatesmooth adoption and usage of the analytics platform.

India

• Implemented ETL processes for data extraction, transformation, and loading.• Monitored environments using Nimbus, OEM, Savvies, and NEWS tools.• Deployed and managed applications on Tomcat, ACS, and Apache.• Analyzed logs and monitored transactions for issue identification.• Developed Shell and Ansible scripts for task automation and troubleshooting.• Managed DES & DUT Jobs utilized Splunk & Elk for log analysis.• Handled first-level troubleshooting, applied patch upgrades, and communicated with IT managers.• Addressed incident cases and participated in maintenance activities.• Developed and reported on Key Performance Indicator (KPI) metrics.• Investigated root causes for major incidents and prepared Incident Reports.

Msc Computer Science, Computer Software Engineering, Distinction

Postgraduate Degree, Msc Computer Science With Advance Practice

Bachelor'S Degree, Computer Science, A

Bachelor'S Degree, Computer Science, Distinction