Manasa G.
Senior Data Analyst
Open to offersNew to PlatformAbout
Manasa G., a Senior Data Analyst based in Saint Louis, MO, offers over five years of robust industry experience. She specializes in building enterprise reporting solutions and is proficient in designing advanced SQL queries, automating workflows with Python, and creating high-impact dashboards with Power BI. Her expertise spans sectors such as finance, operations, procurement, and insurance. She has been successful in reducing reporting turnaround times and ensuring precise KPI insights, facilitating data-driven decision-making. At Zurich North America, Manasa refactored SQL workflows, optimizing data refresh processes, and saved over 200 analyst hours monthly by automating data tasks. At Treeni Inc., she managed SQL-based and Power BI/Tableau reporting for over 50 clients, enhancing compliance and operational metrics. Her previous role at Capgemini honed her skills in developing SQL scripts for high-volume insurance datasets. With degrees in Business Analytics and Electronics and Communication Engineering, she holds significant certifications, including a Google Data Analytics Professional Certificate and Six Sigma Black Belt.
Experience
Data Analyst
Zurich North America · 2024 — PresentDesigned and optimized advanced SQL queries utilizing complex joins, CTEs, window functions, subqueries, and stored procedures for extracting and transforming procurement, logistics, and financial data for enterprise reporting. Developed and maintained over 15 executive Power BI dashboards that illustrated KPI visibility into supplier performance, spend analytics, budget variance, and inventory movement across five business departments. Refactored SQL workflows in Snowflake and Azure Databricks by evaluating execution plans and fine-tuning transformations, which contributed to a reduction in query runtime and data refresh latency by 35%. Automated the cleansing, reconciliation, and validation workflows using Python and SQL scripts, resulting in over 200 analyst hours saved monthly while achieving 99% reporting accuracy. Constructed reusable SQL views, reporting tables, and semantic models to facilitate ad hoc analytics and self-service reporting requests from finance and operations leadership.Data Analyst
Treeni Inc. · 2023 — 2023Developed SQL-driven reporting solutions alongside Power BI and Tableau dashboards that tracked compliance KPIs, operational trends, and business performance metrics for over 50 enterprise clients. Designed transformation models in Snowflake and DBT aimed at standardizing data extraction, cleansing, aggregation, and business rule application from multiple source systems. Streamlined reporting workflows through the automation of Python scripts, scheduled SQL procedures, and validation checks, which significantly decreased report generation turnaround time by 60%. Constructed intricate SQL views using nested subqueries, conditional aggregations, and analytic functions to assist with executive trend reporting and variance analysis.Guidewire Business Analyst (Data & Analytics Focus)
Capgemini · 2020 — 2022Engineered SQL-based data validation scripts, reconciliation queries, and operational reports to support claims, billing, and policy analytics across high-volume insurance datasets. Developed KPI scorecards that monitored claim cycle time, reserve adequacy, settlement performance, and loss ratios for actuarial and finance reporting teams. Partnered with data warehouse and QA teams to establish extraction logic, test SQL queries, and guarantee reporting consistency within downstream analytical systems. Converted business reporting requirements into technical user stories while supporting Agile sprint delivery for analytics enhancements.
Skills & Expertise
Education
- Master of Science, Business AnalyticsUniversity of Texas at Arlington · 2022 — 2023
- Bachelor of Technology, Electronics and Communication EngineeringCMR Institute of Technology · 2016 — 2020