Data Analyst Business Intelligence

SUMALATHA PANJA

* San Bernardino, CA 909-***-**** # *****************@*****.***

PROFESSIONAL SUMMARY DATA ANALYST

Insightful and results-driven Data Analyst with hands-on experience in data wrangling, analysis, and business intelligence reporting. Adept at Python, SQL, Power BI, Tableau, MySQL, and Excel for developing scalable data pipelines and delivering actionable insights. Experienced in creating dynamic dashboards, performing statistical analysis, and supporting decision-making in finance, operations, and business strategy. Committed to data quality, automation, and real-time analytics. WORK EXPERIENCE

Data Analyst Intern Nivsee Technology Pvt. Ltd., Hyderabad, India Oct 2022 – July 2023

• Collaborated with business stakeholders to evaluate data needs and translate objectives into actionable data solutions supporting the finance department.

• Conducted complex data analysis using Python and SQL to extract actionable trends and summarize key financial data for executive decision-making.

• Built and optimized ETL pipelines to collect, clean, and integrate raw data from MySQL databases and APIs, improving reporting accuracy and enabling reliable financial dashboards.

• Created Power BI dashboards and visualizations to summarize financial performance and present economic insights to executives.

• Implemented data validation routines to enhance data quality and reliability, reducing reporting errors and improving trust in analytics. Analyst and A4 Capgemini, Hyderabad, India July 2021 – Nov 2021

• Collected and prepared large datasets from internal systems to support business performance monitoring and financial reporting.

• Developed SQL queries to combine and transform data from disparate sources, ensuring data consistency across reporting systems.

• Maintained Excel-based dashboards and automated routine financial summaries used by decision-makers.

• Collaborated with cross-functional teams to analyze cost drivers and support budget optimization efforts.

• Ensured data integrity by applying validation checks and performed exploratory data analysis to uncover trends and variances.

• Supported internal audit teams with data extracts and business documentation for compliance and performance analysis. PROJECT EXPERIENCE

Usage and Engagement Patterns of Students in Online Learning Platforms April 2025

• Analyzed student engagement trends across 10,000 online courses to identify the most effective platforms using Tableau-based visual analytics.

• Investigated correlations between course price, duration, and engagement to uncover patterns driving student platform preferences and completion behavior.

DripWear Urban Threads May 2025

• Designed and developed an Interactive e-commerce website prototype for DripWear Urban Threads using Figma, incorporating user- friendly navigation, customizable t-shirt options, and a seamless cart checkout experience.

• Implemented Digital marketing strategies including SEO optimization, email marketing, and social media advertising to target youth and young adult demographics for online apparel sales. West Coast Electronics Research Document Dec 2024

• Designed a strategic enterprise architecture using the CSVLOD Model to enhance customer satisfaction, streamline operations, and support long-term business scalability.

• Integrated cloud-based systems (POS, CRM, ERP) to enable real-time analytics, personalized marketing, and a seamless omnichannel retail experience.

Healthcare Management System May 2024

• Designed and implemented a secure, centralized database system to streamline patient data, appointment scheduling, and billing operations for a healthcare facility.

• Enhanced Data accessibility, system integration, and scalability by developing optimized schemas, APIs, and encryption-based security protocols.

Smart Gym Management May 2024

• Developed a Smart Gym Management web application using Budi Base’s codeless platform to streamline user registration and data management, enhancing operational efficiency and user engagement.

• Implemented Responsive and secure design features, ensuring seamless access across devices and safeguarding user data through encryption and authentication mechanisms.

SKILLSET

Technical Skills: Python, SQL, Power BI, Tableau, MySQL, Excel, HTML, CSS, C, VBA, MATLAB, Pandas, NumPy, Matplotlib, Seaborn, ETL pipelines,DB2, Data Cleaning, Data Integration, A/B Testing, Data Modeling, ETL, KPI Analysis, Data Warehousing, AWS and Snowflake, API Integration, Microsoft Office Suite, Google Sheets, Schema Design, Big Data concepts. Relevant Courses: Datastage,Project management, Cloud Management, Database design, Software System Design, Information Systems and Technology Management, Systems Analysis, Design and Implementation, Database Management and Policies, Information Networking Systems and Security, Enterprise Architecture Planning, Strategy, Security and Policy,Web Analytics Tools, Business Analytics and Decision Making, Data Warehousing BigQuery, Redshift, Snowflake and Business Intelligence, Business Applications Using Web Technologies. EDUCATION

California State University, San Bernardino May 2025 Master of Science - Information Systems and Technology - Business Intelligence and Analytics San Bernardino, California, USA Institute of Aeronautical Engineering September 2022 Bachelor of Technology - Electrical and Electronics Engineering Hyderabad, India PUBLICATIONS

• Usage and Engagement Patterns of Students in Online Learning Platforms: Thesis – CSUSB Schloarworks 2025

Contact this candidate