Mohana Venkata Sai Krishna Devabhaktuni
Olmsted Falls,OH
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Data analysis professional prepared to deliver impactful insights and drive business decisions. Adept in data visualization, statistical analysis, and database management, with strong focus on teamwork and adaptability. Known for reliability, analytical thinking, and results-driven approach. Skilled in Python, SQL, and Excel, ensuring robust data solutions and strategic recommendations.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Data Analyst
TATA Consultancy Services
02.2022 - Current
- Worked on deploying and monitoring ETL packages in SQL server and scheduling the flow of packages from development to test and Production servers
- Worked on ETL mapping documents in data warehouse projects that accelerated data warehousing and management processes to increase the data retrieval speed
- Proficient in optimizing SQL queries and knowledge on SSAS tabular model, and Power BI data flows
- Worked on Microsoft Power BI dashboards, creating datasets, reports, and complex layers
- Created data reports and monitored all the data
- Analyzed large datasets, identified issues, and created operational data reports
- Developed database schema and created stored procedure to generate reports using SQL Server
- Utilized MS SQL, Data Warehousing programs, and Tableau for data analysis
- Produce ad hoc SQL scripts essential for reporting requirements and establish data pipelines in the cloud using Azure Data Factory
- Develop complex SQL statements, including stored procedures and Common Table Expressions (CTEs), to extract data from data warehouse servers to support report generation
- Extract data for reporting from databases, including SQL Server, SQL Server Analysis Services, Azure SQL Database, and Azure SQL Data Warehouse
- Design and implement automation test scripts using Python, enhancing the efficiency and reliability of testing processes
Data Analyst
Andhra Hospitals
01.2019 - 12.2019
- Used complex SQL and PL/SQL to create UMT, Aggregate, Trend, Pivot, and List reports
- Proficient in advanced Tableau features, including calculated fields, parameters, table calculations, LOD, and R integration
- Designed and optimized Tableau dashboards with best practices in layout, performance, and interactivity
- Built data-driven Tableau stories for clear insights and effective end-user communication
- Developed and maintained clinical databases, including Utilization Management and Drug List Management systems
- Communicate actionable insights using data, to a non-technical audience and to stakeholders using Business Intelligence and visualization tools like Tableau, Power Bi, Excel, HubSpot, etc
- And automate reporting processes to create daily, weekly and monthly reports
Education
Master of Science - Information Science
University of North Texas
Denton, Texas12.2021
Bachelor of Pharmaceutical Science and Technology -
Krishna University
Machilipatnam, India05.2019
Skills
- Python
- R
- PL/SQL
- PySpark
- SQL Server
- Oracle
- SQL developer
- PostgreSQL
- MySQL
- Microsoft Access
- Azure Databricks
- R studio
- Jupyter
- MS SQL Server
- Jira
- GitHub
- Confluence
- Visual studio
- Advanced Excel
- Azure
- Sklearn
- Matplotlib
- Pandas
- Numpy
- Windows
- Linux
- Mac OS
- SDLC
- Agile
- Waterfall Programming
- SSIS
- SSAS
- SSRS
- Tableau
- Power BI
Certification
- AZ-900 Certification
- SQL Certification
- Agile certification
- Fundamentals of AI Foundation certification
Timeline
Data Analyst
TATA Consultancy Services
02.2022 - Current
Data Analyst
Andhra Hospitals
01.2019 - 12.2019
Bachelor of Pharmaceutical Science and Technology -
Krishna University
Master of Science - Information Science
University of North Texas
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Anaisa ComerfordAnaisa Comerford
Patient Service Specialist at Cleveland ClinicPatient Service Specialist at Cleveland Clinic