KD

K. Deepika

Business Analytics / Operations MIS Analyst

Chengalpattu, Tamil Nadu, India

@deepika_krishnaswamy

0 followers

About

Data analytics professional with hands-on experience in SQL-based analysis, dashboard development, MIS reporting, and financial data analytics. Experienced in customer service operations, complaint handling, manpower allocation, documentation, team coordination, and stakeholder communication.

Experience

  • Data Analyst Intern
    Novitech
    Mar 2026 – Present

    Perform data analysis and dashboard development using SQL, Excel, Python, and Power BI. Extract, clean, transform, and analyze data to support business and financial reporting requirements. Develop interactive dashboards and performance reports to monitor key business metrics and identify trends. Apply data validation and analytical techniques to improve the reliability and usability of reporting datasets. Analyze data patterns and results to support data-driven business insights and decision making. Work with structured datasets to prepare information for visualization and reporting.

  • Customer Service Executive
    Starnet Digital Pvt Ltd · Chennai
    Dec 2016 – Mar 2017

    Managed customer service operations and resolved technical issues through effective problem identification, analysis, and communication. Handled and coordinated customer complaints, ensuring issues were tracked and addressed efficiently. Prepared installation schedules and operational documentation for management approval, maintaining accurate records. Allocated manpower resources based on customer requirements to improve service response and operational efficiency. Monitored service activities and coordinated with team members to support performance objectives. Led and coached technicians toward operational and customer service goals. Trained technicians on service procedures, time management, and workplace safety standards. Communicated effectively with customers and internal teams to resolve operational issues and maintain service quality.

  • Admin cum Branch Coordination Executive
    Spiro Solutions Pvt Ltd · Chennai
    Oct 2015 – Apr 2016

    Coordinated day-to-day sales and service operations and monitored activities supporting business targets. Managed manpower coordination and customer issue resolution across branch operations. Supported supply chain activities and maintained operational coordination. Prepared and maintained business-related documentation and records. Supported recruitment and onboarding activities while coordinating with internal teams. Communicated with customers and operational teams to resolve issues and maintain smooth service activities.

Education

  • B.E.
    Sri Nandhanam College of Engineering
    Electronics and Communication Engineering (ECE) · 2015

Skills

Tools / apps / platforms

6 to 12 months 6 to 12 months Most of a year behind them.
Microsoft Excel Microsoft Power BI
<3 months <3 months Just getting started - under three months. This is also what shows when a level has not been set.
Tableau

Languages

Native / Bilingual Native / Bilingual Their first language, or as strong as one.
Tamil Speak
Fluent Fluent Comfortable using it for work.
English Speak

Projects

  • Region-Wise Profit & Sales Analysis
    Tableau

    Developed an interactive Tableau dashboard analyzing sales and operating profit across regions, states, and cities. Analyzed performance trends over time to identify regional sales and profitability patterns. Implemented filters, highlight actions, and drill-down analysis for interactive reporting. Presented business performance through clear and concise visualizations.

  • Grocery Inventory Dashboard
    MS Excel

    Developed an interactive Excel dashboard analyzing 200+ SKUs and classifying products based on sales velocity. Monitored stock quantity against reorder levels and analyzed inventory turnover and overstock conditions. Used PivotTables, KPI cards, and slicers to enable dynamic analysis of inventory performance. Identified fast-moving, slow-moving, and non-moving products to support inventory-related decisions.

  • Detecting Outliers in Financial Transactions
    Python, SQL

    Used SQL to extract and prepare financial transaction data for analysis. Applied Python-based analytical techniques to identify anomalous transaction patterns and outliers. Analyzed unusual transaction behavior to identify potential fraud, errors, and policy violations. Focused on improving data quality and risk visibility while minimizing false-positive identification. Applied data preparation and analytical techniques to support investigation of inconsistencies in financial data.

  • Financial Performance Dashboard
    Power BI

    Built an interactive Power BI dashboard consolidating financial data from multiple sources into a single reporting view. Developed KPI visualizations and analyzed revenue, expenses, and profitability trends. Created drill-down analysis across department, region, and time period to identify performance patterns. Designed dashboard views to communicate financial performance clearly and support data-driven decision making.

Courses & certifications

  • In-plant Training · Integral Coach Factory, Chennai

Explore the Broxer community

Online · instant AI help
Broxer