Data Analyst Sql Server

MADHURIKA KATTUNGA

Dallas, Texas • *****************@*****.***.*** • 945-***-**** https://www.linkedin.com/in/madhurikakattunga1176/ SUMMARY:

Goal oriented professional successfully assisting companies by developing and implementing updates to operational standards,team organization and employee engagement strategies. Proactive and personable leader with top notch skills in streamlining information, prioritizing tasks, and approaching issues with analytical mindset. Bringing years of experience and demonstrated track records of success. TECHNICAL SKILLS EXPERIENCE

Programming: R programming, Python, SAP Datawarehouse, SAP Business Objects, C, C++ Cloud Platforms: AWS (S3, EC2, EMR, RedShift, Glue, Snowflake) Analysis tools: MS Office, MS Excel, Tableau, PowerBI, SAP Lumira, Google Studio, Stata, QlikView, Looker, Adobe Analytics Databases: Oracle, MySQL, Microsoft SQL Server Management Studio, MongoDB PROFESSIONAL EXPERIENCE

TRR INSTITUTE OF MEDICAL SCIENCE India

Data Analyst Engineer June

2017- July 2021

● Developed and maintained complex software solutions using Python and R, in leveraging advanced language features and libraries like NumPy, Pandas and Matplotlib

● Developed predictive models using R and Python to forecast patient volumes accurately. Achieved a 40% increase in forecast accuracy, optimizing staffing and resource allocation based on seasonal trends and historical data.

● Employed AWS (S3, EC2, RedShift, Glue) and MongoDB for data management and analysis to streamline logistics processes. Reduced turnaround times and transportation costs by 23% through improved data-driven decision-making.

● Leveraged SQL queries to analyze pharmaceutical usage patterns stored in Oracle and MySQL databases. Conducted comprehensive analysis of procurement data, identifying cost-saving opportunities and optimizing inventory levels. Implemented data-driven strategies that reduced procurement costs by 12% while ensuring continuous supply chain efficiency

● Utilized Tableau, PowerBI, and SAP Lumira to monitor patient volume trends, pharmaceutical inventory levels, logistics efficiency, and student performance metrics. These dashboards facilitated real-time monitoring and data-driven decision-making across departments. Identified key performance indicators and implemented interventions that resulted in overall improvement.

● Exceled in Excel, including manipulating large volumes of data, pivot tables, and lookups, enhancing data-driven decision- making processes from time to time.

● Collaborated with cross-functional teams to integrate applications with other systems and services, ensuring seamless interoperability using Microsoft Office (Word, Excel, PowerPoint, Outlook) and Trello Project Management Tool for patient and student management.

● Managed client data with integrity and confidentiality EDUCATION

UNIVERSITY OF TEXAS AT DALLAS Dallas, Texas 2022-2023 Master of Science in Business Analytics

● Relevant Experience: Business Analytics with R, Advanced Statistics for Data Science, Database Foundations for Business Analytics, Big Data Analytics, Applied Econometrics and Time Series Analysis, Data Visualization, Business Data Warehousing, Predictive and Prescriptive Analytics, Statistical Analysis Software (SAS), Operations Management, Spreadsheet Modeling and Analytics, Programming for Data Science

ACADEMIC PROJECT EXPERIENCE

● Analysis and Prediction of Walmart Sales using R, R programming and Data Analysis January 2022-April 2022 Designed to overcome unforeseen challenges like losses related to unexpected demands by analyzing and predicting the weekly sales of each store accurately through models like Correlation matrix and Scatter plots.

● Airlines Database System, Microsoft SQL Server Management Studio January 2022-April 2023 Delivered to manage operations like scheduling of flights, air ticket reservations, flight cancellations, seats availability.

● Data Mining, Data Visualization and Analysis of Products and Revenue Trends, Microsoft SQL Server Management Studio

Analyzed and derived trends in Products, Product prices and their revenues using Microsoft SQL Server Management Studio, SAP Lumira, and Excel pivot to illustrate Data marts and Data warehousing. ADDITIONAL INFORMATION

Eligibility: VISA, Eligible to work in the US for internships and full time for up to 36 months, Data Science

Contact this candidate