Mallika Nagineni
Hamilton
Summary
Data analyst with 5 plus years of experience interpreting and analyzing data to drive successful business solutions. Proficient knowledge of statistics, mathematics, and analytics. Skilled in SQL, experienced in Data modelling, reporting, gathering, and analyzing requirements, data comparison, evaluating & improving existing BI systems. Working experience in Azure, Data Migration and knowledge of Business Analysis.
Experienced with data manipulation, statistical analysis, and data visualization. Utilizes advanced analytical techniques to uncover trends and inform business strategies. Track record of employing critical thinking skills to solve complex problems and deliver meaningful insights.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Data Analyst
Dairy Technology Services
02.2021 - Current
- Gathered requirements from the clients and created PBI reports based on the requirements
- Built Power BI reports and verified against ERP data
- Collaborated with azure data engineers and operation team to implement the ETL process wrote and optimized SQL Queries to perform data extraction to fit the analytical requirements and to perform the data migration
- Created SQL views for comparing data between unified and individual tables using dynamic SQL
- Developed SQL queries/scripts to validate the data such as checking duplicates, and null and ensuring correct data aggregations
- Developed an accounting model and provided a financial forecast compared to the past fiscal year
- Developed Sales model, monitored and evaluated sales performance, and forecasted demand, revenue, and expenses
- Developed Asset, supply and sales model, and monitored the stock cost to set the sales value
- Monitored the sales, and identify key performance indicators to set the targets
- Identified patterns/trends in Data sets, compared the data with ERP, and client websites, and analyzed the results
- Produced monthly reports using advanced Excel spreadsheet functions.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
- Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
- Implemented robust control measures to improve analytical output reliability.
- Conducted ad-hoc analysis to address urgent business questions, facilitating rapid response to market changes.
- Tech Stack: Power BI, Excel, SQL, DAX, M, SSMS, Python, Power Automate
Data Analyst
DATA INSIGHTS AND ANALYSIS OF PORTFOLIO PROJECTS
02.2021 - Current
- Data Visualization using Power BI
- Created an interactive visualization dashboard for the company using Power BI
- The metrics such as monthly revenue, monthly orders, and monthly returns are calculated and visualized reactively based on the product categories selected from the chart
- Tech Stack: Power BI, DAX, M
Analyst
Brelext IT Solutions
05.2020 - 01.2021
- Designed and implemented reports, faceted Analytical displays, and Dashboards according to business needs using the appropriate toolset - mainly SQL Server, Power BI, and Excel
- Performed Data comparison between Power BI and raw data
- Performed Data Checks in the Power BI tool to find out if there are any data outages and passed it on to the developers to fix them
- Successfully interpreted data to identify key metrics and draw conclusions
- Tech Stack: Power BI, Excel, SQL, DAX, M
Analyst
DATA INSIGHTS AND ANALYSIS OF PORTFOLIO PROJECTS
05.2020 - 12.2020
- Statistical Analysis using Excel
- Used Excel for all the statistical analysis and visualization
- Performed Lookups from other sources and cleansed it per requirement
- Tech Stack: Excel, Statistics, Exploratory Data Analysis, Hypothesis Testing
Analyst
Abhyudaya HR Buisness Solutions Pvt Ltd
09.2017 - 10.2018
- Generated reports that are required by the performance management team and client on regular basis
- Analyzed and investigated Sales data to identify patterns and bring valuable insights from it
- Created Dashboards to get the insights on key Performance indicators
- Monitoring the complex data and helping stakeholders with recommendations and forecastings
- Tech Stack: SQL, Excel
Education
Post Graduate Diploma - Applied Informatics
Waikato Institute of Technology
11.2019
Bachelors - Electronics and Communication Engineer
Jawaharlal Nehru Technological University
05.2015
Skills
- Microsoft Power BI
- Microsoft Excel
- Data Modelling
- Data Visualization
- SQL Server
- SSAS
- SSMS
- Jira
- SQL
- Python
- Communication
- Attention to Detail
- Problem-solving
- Adaptability
Certification
- Microsoft, 03/06/20, Exam 778: Analyzing and Visualizing Data with Power BI
- Microsoft, 04/25/24, Power BI Data Analyst Associate
Timeline
Data Analyst
Dairy Technology Services
02.2021 - Current
Data Analyst
DATA INSIGHTS AND ANALYSIS OF PORTFOLIO PROJECTS
02.2021 - Current
Analyst
Brelext IT Solutions
05.2020 - 01.2021
Analyst
DATA INSIGHTS AND ANALYSIS OF PORTFOLIO PROJECTS
05.2020 - 12.2020
Analyst
Abhyudaya HR Buisness Solutions Pvt Ltd
09.2017 - 10.2018
Post Graduate Diploma - Applied Informatics
Waikato Institute of Technology
Bachelors - Electronics and Communication Engineer
Jawaharlal Nehru Technological University
Similar Profiles
John CutajarJohn Cutajar
Product Handler at Bulla Dairy ServicesProduct Handler at Bulla Dairy Services
Krystal WelchKrystal Welch
Office Manager at Dairy Veterinary Services, Inc.Office Manager at Dairy Veterinary Services, Inc.
KOKETSO RAPHOTOKOKETSO RAPHOTO
Process Controller at Veolia Water Services South Africa for Woodlands DairyProcess Controller at Veolia Water Services South Africa for Woodlands Dairy