Niharika Danda
Hyderabad,India
Summary
Experienced Data Analyst with over 2+ years of experience in Business Intelligence and Data Analysis. I’m proficient in Tableau, SQL and Python, specializing in Pharmaceutical Sales and Inventory Analytics. Strong expertise in Data Visualization, Database profiling, and predictive modelling to drive business insights. Passionate about leveraging data-driven solutions to improve efficiency, automation and optimize decision-making.
Overview
2
2
years of professional experience
Work History
Jr. Data Analyst
AmpleLogic
10.2019 - 03.2022
- Company Overview: This project is focused on Analyzing Sales and Inventory data to optimize stock levels, enhance demand forecasting and provide Business Intelligence for pharmaceutical Companies
- The Integration of SQL, Tableau and Python helped to extract, transform, visualize and predict the performance of Pharmaceutical products supporting better decision-making across supply chain and sales teams
- Collaborated with Business Analysts to gather requirements and analyze Sales and Inventory data provided in Excel format
- Gathering business requirements to analyze, design and develop Dashboards
- Utilized SQL for data cleansing and transformation with JOIN’s, CTE’s, Sub Queries and Stored procedures for efficient data retrieval
- Created Interactive Tableau dashboards to visualize key metrics such as Sales Trends, Top-selling Drugs and Stock levels enhancing Decision-making
- Designed sales trend reports and inventory insights to provide actionable Business Insights
- Built a Linear Regression Model in Python leveraging Scikit-learn to forecast sales, improving Demand Prediction Accuracy by 15%
- Employed feature engineering to Optimize Model Performance and evaluated the model using MSE, RMSE, and R² score
- Integrated multiple data sources including Databases, files(Excel, CSV) to provide comprehensive insights
- The forecasting model and dashboards enabled better Sales planning, Inventory Management and Strategic Business Decisions
- This project is focused on Analyzing Sales and Inventory data to optimize stock levels, enhance demand forecasting and provide Business Intelligence for pharmaceutical Companies
- The Integration of SQL, Tableau and Python helped to extract, transform, visualize and predict the performance of Pharmaceutical products supporting better decision-making across supply chain and sales teams
- Environment: SQL Server, AWS S3, Redshift, Python, Excel, Tableau, JIRA/Confluence
Education
Bachelor’s - Civil Engineering
Jntu
01.2018
Skills
- SQL: Complex queries
- SQL: JOIN’s
- SQL: Functions
- SQL: Performance Optimization
- Tableau: Dashboards
- Tableau: Data Visualization
- Python Frameworks: Pandas
- Python Frameworks: NumPy
- Python Frameworks: Matplotlib
- Python Frameworks: Scikit-learn
- Python Frameworks: Seaborn
- Data Analysis: Trend Analysis
- Data Analysis: Sales Forecasting
- Data Analysis: Inventory Optimization
- Databases: SQL Server
- ETL & Reporting: Data Cleansing
- ETL & Reporting: Data Extraction
- ETL & Reporting: Automation
- ETL & Reporting: Report Generation
Timeline
Jr. Data Analyst
AmpleLogic
10.2019 - 03.2022
Bachelor’s - Civil Engineering
Jntu
Similar Profiles
Kamballa PradeepKamballa Pradeep
Associate Developer at Venkanna Software Services Pvt Ltd (AmpleLogic)Associate Developer at Venkanna Software Services Pvt Ltd (AmpleLogic)
Sriee Chandrasekar JSriee Chandrasekar J
Senior Manager/ Officer at State Street Corporate ServicesSenior Manager/ Officer at State Street Corporate Services
Anusha MeneniAnusha Meneni
Application Development Analyst at Accenture Services Pvt.LtdApplication Development Analyst at Accenture Services Pvt.Ltd
Chandrashekhar MadathaChandrashekhar Madatha
Goods out administrator at The Real Wrap CoGoods out administrator at The Real Wrap Co
Dhanvi GudipatiDhanvi Gudipati
BIM ARCHITECT / SENIOR ARCHITECT at VEE TECHNOLOGIESBIM ARCHITECT / SENIOR ARCHITECT at VEE TECHNOLOGIES