Portfolio - K NEERAJA

About Me

I'm a data analyst passionate about transforming raw data into clear, actionable insights that drive smarter decisions. My background spans data cleaning, statistical analysis, and building intuitive dashboards that simplify complex information. I’ve worked extensively with tools like Excel, Power BI, SQL, and Python, applying them in hands-on projects to solve real-world business challenges. My portfolio reflects real-world projects that highlight trends, solve business problems, and support strategic goals.

Currently working as SCM Analyst at Scimplify, where I specialize in supply chain analytics and process automation. I’m a data analyst passionate about transforming raw data into clear, actionable insights that drive smarter decisions.

I'm always looking to grow—both technically and professionally—by embracing new tools, collaborating with cross-functional teams, and contributing to a data-informed culture.

Key Skills

Excel

PowerBI

Python

Analytical Skills

Problem Solving Skills

Logical Reasoning

SQL

My Projects

Sales & Finance Analytics

Domain/Function: Sales & Finance

AtliQ Hardware-Ad-Insights

Domain/Function: Consumer Goods

AtliQ Hardware - Supply Chain Analysis

Domain/Function: FMCG

My Experience

Scimplify | Jr. Executive – SCM Analyst
Bengaluru, India | Nov 2024 – Present

Automated SCM Dashboards: Built real-time dashboards for EXIM operations, logistics tracking, open orders, and daily warehouse inward/outward movements using Power BI and Google Sheets, streamlining data-driven decision-making.
Enhanced Warehouse Management: Created ageing, expiration, and WH-Inventory dashboards, enabling proactive stock control and improving warehousing efficiency.
Built Warehouse-to-Customer Route Optimizer: Developed a dynamic route optimization tool using Python, HTML, CSS, and JSON to map the most efficient delivery path from warehouses to multiple customer locations.
Automated Business Trackers: Built Google Sheets-based Procurement and R&D Trackers using Apps Script, automating product entry, data transfer across sheets, and sending notifications when new products are raised.
Delivered Executive Reporting: Created custom MIS reports and visual presentations in Power BI, Google Sheets, and PowerPoint, supporting high-level strategic planning.
Scimplify | Market Research Analyst Intern
Bengaluru, India | July 2024 – Oct 2024
Market Research: Conducted in-depth market research for specialty chemical products, including pharmaceuticals, agrochemicals, flavors & fragrances, and industrial chemicals, analyzing industry trends, competitor activities, and customer needs.
Data Cleaning & Processing: Cleaned and processed large datasets using Advanced Excel, ensuring data accuracy, integrity, and readiness for analysis.
Insight Generation: Identified and extracted valuable insights from market data, presenting findings to senior management to support business growth strategies.

Database Development & Maintenance: Developed and maintained databases to track market developments, competitor activities, and emerging industry trends.