Junior Project Analyst - Data & Business Insights Specialist

Venkata Sathvik M Business Data Analyst

*************@*****.*** 475-***-****

PROFESSIONAL SUMMARY

Data Analyst with hands-on experience turning complex datasets into actionable insights for financial and healthcare domains. Skilled in data modeling, workflow optimization, creating clear dashboards and reports for cross-functional teams. Experienced in supporting performance tracking, forecasting accuracy, and data driven decision making using various skills and tools mentioned below.

SKILLS

Data & Analytics: Data Visualization, Business Intelligence, Data Analysis, DBMS, Time Series Analysis, Statistical Analysis.

Tools & Languages: Python, R, SQL, Microsoft SQL Server, Microsoft Office, Advanced Excel (Pivot Tables, Macros, Power Query, Conditional Formatting), Spreadsheets, PowerPoint, Tableau, Power BI, Looker, Talend, MATLAB, Google Data Studio, HTML, CSS, JavaScript, Jupyter Notebook. Qlik Sense.

Libraries/Frameworks: Pandas, NumPy, Scikit-learn, SciPy, dply, tidy, ggplot2, VBA, DAX.

Domain Knowledge: Healthcare Data (EHR, Claims), Financial Data (Budgeting and Forecasting), Reporting.

Additional: Supply Chain Management, Stakeholder Communication, Process Mapping, Data Quality Assurance, Data Governance, JIRA, Visio, Agile and Scrum Methodologies, Global Economics and Finance.

EMPLOYMENT

Data Analyst Capital One. LLC(Client) Texas May 2024 – Present

Translated complex financial and operational requirements into user stories and features, accelerating delivery timelines by 20% in Agile Sprints using JIRA.

Supported ETL workflows and data pipelines using SQL and Python, ensuring clean, validated data for reporting (Talend or similar tools).

Designed and executed advanced SQL queries across large-scale financial databases, reducing reconciliation effort by 40% and improving reporting accuracy.

Built executive real-time Tableau and Power BI (Based on requirement) dashboards for revenue, expenses, and budget utilization, enabling executives to monitor 95% of KPIs in real time.

Used Python (Pandas, NumPy, Scikit-learn) for advanced financial data analysis, improving model accuracy and scalability.

Used Excel (VLOOKUP, Pivot Tables, Power Query) for trend identification, exception tracking, and monthly invoice validation.

Partnered with cross-functional teams using SCRUM to implement analysis and models, increasing cash-flow prediction accuracy by 15%.

Streamlined financial process documentation and created process flow diagrams, reducing cross-team handover time by 15%.

Data Analyst Master Compliance.Co (CGI) Hyderabad, India June 2021 – December 2022

Automated healthcare compliance reporting using VBA Macros, cutting manual effort by 40% and reducing claim processing errors.

Designed SQL-based dashboards in Power BI to track patient admissions, insurance claims, and provider KPIs, improving visibility for leadership.

Built Python web scraping pipelines (Scrapy) to collect regulatory updates and payer fee schedules, enhancing compliance monitoring by 30%.

Applied advanced Excel techniques (VLOOKUP, Pivot Tables) to cleanse and organize large EHR and claims datasets, boosting data consistency.

Integrated data from insurance claims, provider rosters, and encounter systems into centralized reports for compliance and audit teams.

Supported compliance teams in preparing regulatory submissions and audit-ready datasets, improving response time to external reviews.

Applied Exploratory Data Analysis (EDA) using Python to detect anomalies in claims data, reducing compliance risks by 20%.

ACADEMIC PROJECTS

Data Analytics Simulation – Analyzed 200K+ transactions to deliver 6+ actionable business insights, improving decision-making efficiency on various issues relating to finance, Healthcare and Banking records.

Olympics 2020 Power BI Dashboard – Built interactive dashboards tracking medal counts, country performance, and event metrics.

National Student Loan Analysis (R) – Used logistic regression and predictive modeling to identify repayment trends and risk factors.

EDUCATION

Master of Science in Data Analytics, University of New Haven, West Haven, Connecticut January 2023 – May 2024

Bachelor of Commerce in Finance, Statistics, Economics and BA, SSSIHL, India June 2019 – May 2022

CERTIFICATIONS

Microsoft Business Analysis TATA Group Data Analysis Project Management – CBRE Power Bi Certification.

Contact this candidate