Sowmiya

Business Analyst | Data Analyst

Chennai, India 1+ yrs exp 83 · Excellent

About

Detail-oriented Data Analyst and Business Analyst experienced in querying database systems to extract and clean data for analysis, and in analyzing large datasets to identify trends, patterns, and anomalies using statistical methods. Skilled in SQL (writing, editing, and optimizing queries), advanced Excel (VLOOKUP/XLOOKUP, Pivot Tables, Power Query), and Python (Pandas, NumPy) for data manipulation and ad-hoc analysis. Proven ability to create clear reports and interactive dashboards for stakeholders, and to collaborate closely with cross-functional teams to understand their data needs and provide analytical support.

Skills & Expertise (35)

SQL Advanced

9.0/10

Years Exp

Data Extraction Advanced

8.5/10

Years Exp

Power BI Advanced

8.5/10

Years Exp

Stakeholder Management Advanced

8.0/10

Years Exp

Excel Advanced

8.0/10

Years Exp

Python Advanced

8.0/10

Years Exp

Tableau Intermediate

7.5/10

Years Exp

Anomaly Detection Statistical Methods Descriptive analysis EDA Variance Analysis Interactive Dashboards DAX KPI Reporting Stakeholder Reports Cross-Functional Collaboration BRD FSD Documentation Pattern Detection Trend Detection Matplotlib NumPy Pandas Ad-hoc Analysis Charts VBA Macros Power Query Pivot Tables XLOOKUP VLOOKUP ETL relational databases Writing

Work Experience

Research Specialist

ZoomInfo

Mar 2025 - Present

Queried database systems using SQL and Snowflake to extract and clean 17M+ business records for analysis, eliminating 17 million bad/corrupt records and reducing the data error rate by 92%. Analyzed large datasets from multiple sources to identify trends, patterns, and anomalies using statistical methods and root cause analysis, resolving data quality issues across 1,000+ datasets. Wrote, edited, and optimized complex SQL queries to extract, filter, and analyze data from relational databases, supporting BI reporting and analytical needs for stakeholders. Created clear reports and interactive dashboards in Power BI and Excel (pivot tables, Power Query, charts, VBA macros) tracking KPIs, with business insights and recommendations for management. Used Python (Pandas, NumPy) and SQL to automate 15+ recurring reports, cutting manual effort by 60% and reducing reporting errors by 30%. Collaborated closely with cross-functional teams to understand their data needs, provide analytical support, and ensure 100% on-time delivery against agreed timelines.