Data Analyst Sql Server

Srujan Reddy Thandra

ad5cuc@r.postjobfree.com +1-331-***-**** https://www.linkedin.com/in/srujan-reddy-thandra/

EDUCATION

Florida International University — Miami, FL Dec 2022

School of Business - Master of Science in Information Systems - Business Analytics

National Institute of Technology — Warangal, India May 2021

Bachelor Of Technology

SKILLS

•Data Bases: MySQL, SQL SERVER, Oracle.

•Programming language: Python, C, Core JAVA.

•Reporting tools: Tableau, R, PowerBi.

•Tools: MS Excel, Excel Macro programming, PowerPoint, Smartsheet, Acrobat Pro.

PROFESSIONAL EXPERIENCE

New Century Health— Remote, USA (Contract) Jan 2023 – Feb 2024

Financial Data Analyst PowerBI, Tableau, MySQL, SQL SERVER, Python, JAVA, MS Suite, Smartsheet

•Created Power BI visualizations of Dashboards & Scorecards (KPI) for the Finance Department, which reduced overdue accounts receivable by 20% and increased profile margins by 15%.

•Conducted thorough testing cycles, including functional, regression, integration, and user acceptance testing resulting in a 40% reduction in critical defects and a 25% decrease in overall defect density.

•Leveraged Confluence's integration with data visualization tools (e.g., Tableau, Power BI) to embed interactive charts, graphs, and visualizations within the documentation, enhancing the clarity and impact of data-driven narratives.

Florida International University, Miami, Florida. Feb 2022 – Nov 2022

Business Process Analysis – College of Business Tableau, R, MySQL, Acrobat Pro, MS Excel, PowerPoint

•Using Tableau & Tableau Prep, organized the provided data into a data warehouse and created a star schema (dimensional model) using SQL Server. Explanatory analysis was then performed by creating advanced interactive dashboards to analyze the KPIs for an online food ordering and delivery platform.

•Finally, predictive analysis was used to forecast future trends and produce graphs that provided insights into how to improve the business.

•Developed a database for an online hotel booking platform, where users can compare and book hotels online.

Primarily developed on MySQL then moved to Oracle Cloud for better collaboration and easy access.

•Designed a tableau interactive dashboard using a feature of heat map view to display Client Reporting Groups (CRG).

Bachpan EduSys— Hyderabad, India May 2020 – June 2021

Data Analyst Tableau, R, MySQL, Oracle, C, MS Excel, PowerPoint

•Designed and generated 150+ reports that handle multiple schools/universities data of size ~300GB using Tableau and SQL SERVER.

•Planned and created a data pipeline including data gathering, data cleanup, and data feed to generate reports which improved the turnaround time in accounting and auditing by 20%.

•Actively involved in the client’s interfacing with more than 70 schools to gather and streamline requirements. These reports helped customers decrease CapEx (-20%) and OpEx (-15%), saving Rs. 25M.

CERTIFICATIONS and AWARDS

•Tableau Essential Training Certification and Tableau Desktop Qualified Associate Certification.

•Lean Six Sigma Yellow Belt.

•Winner in technical seminar presentation conducted by TEDx and runner up for best business idea at NIT.

•Rookie of the Year Award – Bachpan EduSys Regional Branch. (2021)

Contact this candidate