Business Analyst - Data, BI, and ETL Expert

Swati Sree Chirumamilla

Business Analyst

+1-934-***-**** ********@*****.*** https://www.linkedin.com/in/swati-sree-c-a49880325/ Professional Experience

Business Analyst skilled in Excel (VBA/pivots), SQL, Python, and BI (Tableau, Power BI, QuickSight); builds ETL pipelines, KPI frameworks, and automated self-serve reporting. Aggregates and cleans large datasets; designs at-a-glance dashboards and standardized metrics; writes complex queries and forecasting/regression models to drive decisions across ops, logistics, and supply chain.

Skills & Tools

Tools: Microsoft Excel (lookups, pivot tables, Power Pivot, array formulas, VBA/macros), SQL query/editors (general RDBMS tools), Tableau, Power BI, Amazon QuickSight, Data management/reporting systems, Dashboard & KPI monitoring suites

Technologies: SQL, Python, R, Java, HTML (for front-end/tooling maintenance), Unix/Linux (optional), Visual Basic

(optional), Perl (optional), Oracle BI ecosystem (optional), Automated ETL/data pipelines, Analytical/statistical modeling

(regression, forecasting), Supply chain concepts (forecasting, planning, optimization, logistics) Key Skills: Data mining & modeling, Requirements gathering & converting to reporting solutions, Complex query writing & deep-dive analysis, KPI definition/tracking/benchmarking, Dashboard/report design & data visualization, Data retrieval/cleansing/aggregation from multiple sources, Forecasting & standardized metrics for planning, Building scalable/automated reporting systems, Process improvement & business case development Soft Skills: Clear communication (verbal & written) and data storytelling, Stakeholder management & influence across functions, Ownership, accuracy, and attention to detail, Problem solving under ambiguity & sound judgment, Customer focus & bias for action, Ability to work independently and in dynamic/high-pressure environments, Fast learning, adaptability, cross-functional collaboration & leadership Responsibilities: Access, organize, and integrate raw data; build queries/macros and pipelines, Retrieve/analyze large datasets and resolve discrepancies, Design and implement reporting/visualization solutions (dashboards, status-at-aglance reports), Define/build/manage KPIs; monitor metrics and create new ones, Generate complex analyses for deepdives and process improvement, Communicate insights to stakeholders; lead cross-functional discussions, Maintain/write light code for analytics toolsets (Python/SQL/HTML/Java/R), Run recurring/ad-hoc BI projects; standardize metrics for forecasting, Own scalable automated reporting systems/artifacts, Prepare/deliver senior-level business reviews and planning inputs Domain/Business Knowledge: Business Intelligence & Analytics fundamentals, Data quality & governance, Supply chain

& logistics (forecasting, planning, optimization), Program implementation & operational efficiency, Customer experience improvement, Cross-functional alignment (Operations, Finance, Recruiting, HR, Tech) Certifications

• Microsoft Certified: Data Analyst Associate (Power BI)

• Tableau Desktop Specialist

• SQL for Data Analytics (Professional Certificate)

• AWS Certified Data Analytics – Specialty

• Certified Business Analysis Professional (CBAP)

• Lean Six Sigma Green Belt

Work Experience

Business Analyst Comerica Bank Mar 2024 – Present

• Automated ETL pipelines and self-serve dashboards using SQL, Python, and Tableau/Power BI/Quick Sight, reducing reporting turnaround by 30% and enabling faster decision-making. Improved data accessibility by standardizing inputs across multiple sources, ensuring reliability for daily and strategic reporting.

• Conducted deep-dive SQL analyses and forecasting/regression modeling, uncovering cost-saving opportunities worth

$2M and improving supply chain planning accuracy. Delivered actionable insights that directly influenced long-term logistics strategies and reduced variance in demand planning.

• Designed KPI frameworks and “status-at-a-glance” dashboards in Excel (VBA/pivots) and BI tools, boosting reporting accuracy to 99% and cutting manual effort by 40%.Enabled senior leadership to track operational performance in real time and prioritize resources more effectively.

• Partnered with Operations, Finance, and HR to translate requirements into scalable analytics, deploying self-serve solutions for 200+ users and driving cross-functional process improvements.Acted as a trusted advisor to stakeholders, bridging technical data solutions with business needs to elevate customer experience. Business Analyst Philips Healthcare Jul 2023 – Mar 2024

• Developed ETL pipelines and automated reporting in SQL and SSIS/SSRS to consolidate patient, trial, and operational data, improving data accuracy by 25%.Enabled healthcare teams to make faster, evidence-based decisions by reducing manual processing time.

• Built KPI dashboards in Excel and Power BI to monitor treatment outcomes, resource utilization, and compliance metrics across clinical programs.Provided leadership with real-time visibility into healthcare performance, enhancing operational efficiency.

• Partnered with cross-functional teams to gather requirements and design scalable analytics solutions tailored to regulatory and healthcare compliance needs.Ensured adherence to HIPAA and healthcare data governance standards, improving trust and audit readiness.

• Conducted deep-dive analyses on patient flow, trial data, and medical equipment performance using SQL and Python.Delivered actionable insights that optimized resource allocation and improved patient care delivery efficiency. Software Engineer IBM Jun 2019 – Jan

2022

• Streamlined recurring business intelligence projects by integrating SQL automation with Excel VBA, cutting manual workload by 25% and improving report delivery speed.Enhanced data reliability by creating audit checkpoints that flagged discrepancies before they reached stakeholders.

• Implemented forecasting models to evaluate transportation and logistics performance, identifying bottlenecks and reducing cost overruns by 15%.Standardized metric definitions across regions, ensuring consistent performance benchmarking globally.

• Developed cross-functional dashboards that unified Finance, Ops, and HR data into a single view, improving stakeholder visibility and alignment.Increased adoption of self-service analytics tools by 40% through targeted training and documentation.

• Led ad-hoc analysis during high-pressure program launches, using QuickSight and Python to provide rapid insights that informed tactical decisions.Delivered recommendations that improved customer delivery accuracy and elevated overall experience scores.

Project Experience

Logistics KPI Dashboard Automation

• Automated dashboards using Excel, SQL, and Tableau to track delivery efficiency, route performance, and cost- perpackage. Integrated multiple raw data feeds into a single pipeline and applied business rules to ensure consistency.

• Reduced manual reporting time by 70% and improved delivery efficiency by 12% through standardized KPIs. Enabled leadership to make quicker operational decisions and reduced errors caused by manual data handling. Forecasting & Capacity Planning Model

• Built a forecasting model in SQL and Python to predict weekly transportation demand and compare forecast vs. actuals. Applied regression techniques and seasonal adjustments to improve accuracy across different routes.

• Improved truck utilization by 15%, generating $1.2M in annual cost savings through better planning. Provided visibility to finance and operations teams for scenario modeling and budget alignment. Recruitment Funnel Analytics

• Analysed applicant tracking data using SQL and Excel VBA, creating Power BI dashboards for time-to-hire and recruiter performance. Automated weekly updates to reduce dependency on manual data pulls and improve accuracy.

• Reduced time-to-hire by 18% and boosted recruiter productivity by 25% through data-driven process improvements. Partnered with HR leadership to redesign candidate screening workflows and improve recruiter load distribution. Education

Master of Science in Computer Science

Stony Brook University, New York, USA Jan 2022 – May 2023 Bachelor of Technology in Computer Science

B.V. Raju Institute of Technology (JNTUH), Hyderabad, India Aug 2015 – May 2019

Contact this candidate