Business Data Analyst - Python SQL Dashboards

Sai Hritvik B

Phone: 959-***-**** Email Linkedin Hartford, CT

TECHNICAL SKILLS

Programming & Databases: Python, SQL, MySQL, Big Query, NoSQL, R Data Engineering & Processing: ETL Frameworks

Cloud Platforms: AWS (S3, EC2, RDS, VPC)

Visualization & Analytics: Tableau, Power BI, SAS

Automation & OS: Git, Shell scripting, UNIX utilities, Methodologies: Agile, Scrum, Kanban, Requirements Gathering, Needs Assessment, Cost/Benefit Analysis, Process Mapping, Functional Specifications, UAT Support.

EXPERIENCE

Usdotnetworks INC Sept 2024 - Present

Business Data Analyst

• Act as a liaison between technical staff and business owners, coordinating with users to gather and document business and user requirements for new systems and enhancements to existing ones.

• Write shell scripts on UNIX/Linux environments to automate routine patch deployment checks and log collection, reducing manual effort during vulnerability management cycles.

• Document process flow definitions and functional specifications for current-state and future-state processes, supporting change management initiatives with clear visual artifacts for stakeholder sign-off.

• Build automated reporting pipelines in Python (pandas) and SQL to consolidate data from multiple client systems, cutting manual report preparation time for weekly stakeholder updates.

• Write complex SQL queries with joins, CTEs, and window functions against MySQL databases to extract and validate data for KPI reporting and ad-hoc business analysis.

• Develop interactive dashboards in Power BI and Tableau to track project health metrics, giving business and technical teams a shared view of delivery status and performance trends.

• Develop recurring reports to monitor KPIs of implemented solutions, using SQL and Python to pull and shape data, and presenting findings that inform business strategy.

• Assist with project management activities including sprint planning, status tracking, and upkeep of the project documentation library so requirements and specifications stay current across in-house and client-site projects.

• Apply upgrades, patches, and configuration changes in support of patch and vulnerability management processes, maintaining system stability for both internal and client environments.

• Analyze existing business processes and conduct needs assessments to identify inefficiencies, then propose improvements backed by preliminary cost/benefit analysis to align technology solutions with business initiatives. Capstone Project: Reality Interactive Jan 2024 – May 2024 Business Data Analyst

• Worked closely with development and testing teams to ensure BRD compliance during the testing phase, and assisted the project team in gaining business user acceptance ahead of release.

• Assisted in the preparation of weekly sprint reports, reviewing progress and evaluating results for accuracy and efficiency before communicating updates to stakeholders.

• Processed and analyzed 17K+ digital signage log files using data analytics and log analysis techniques to identify anomalies, recurring patterns, and operational inefficiencies impacting service uptime and customer satisfaction.

• Engineered Python-based ETL pipelines for automated data ingestion, transformation, and loading, converting raw logs into structured Parquet datasets and integrating with SQL for centralized data storage and SQL querying.

• Performed Exploratory Data Analysis (EDA), segmentation analysis, and anomaly detection to uncover recurring thumbnail creation errors, missing media assets pre- and post-API migration, and incomplete log files caused by device reboots.

• Designed and implemented a multi-source lookup framework by merging data from disparate sources (device IDs, asset tags, OS/App versions, content schedules) to improve data integration, data quality, and root cause identification.

• Developed interactive Power BI dashboards for real-time monitoring of device health, content delivery performance, and asset playback frequency, supporting business intelligence and data-driven decision-making.

• Recommended and outlined deployment of a predictive maintenance and early warning notification system, enabling proactive fault detection, reducing incident response time, and improving overall operational efficiency.

• Established strategic partnerships with industry-related firms for joint ventures and co-marketing initiatives, enhancing market presence.

• Delivered interactive dashboards and automated alert framework for real-time monitoring of content delivery gaps.

PROJECT EXPERIENCE

Financial Engineering Dashboard (Equity Portfolio Analytics Platform) - Built a full-stack equity portfolio analytics platform in Python, SQL, PySpark, and Streamlit delivering 10-KPI fundamental and technical analysis on any publicly traded stock in under a minute, with Monte Carlo scenario modeling, XGBoost confidence scoring, and a LangChain RAG chatbot for contextual querying of live financial data. Pharmacy Application Prototype - Designed and developed a pharmacy application prototype with medication ordering, delivery, OTC alternatives, and multilingual support, integrating requirements gathering, process mapping, and performance testing.

Tableau Dashboard - Created an interactive Tableau dashboard analyzing migration patterns of Indian expatriates to the US and UK, uncovering key relocation drivers and enhancing insights into global mobility trends. Bank Customer Churn Prediction - Built predictive models (logistic regression, decision trees, random forest) in R to identify high-risk banking customers, enabling targeted retention strategies through data-driven insights. EDUCATION

MS, Business Analytics and Project Management, University of Connecticut, Hartford Aug 2022- May 2024 CERTIFICATIONS

• Jira Fundamental Badge, Atlassian certified for Jira Certification

• Tableau Desktop Specialist

Contact this candidate