Siva Guru

Data Analyst / Data Operation Analyst with 2+ years of core analytics experience transforming complex datasets into actionable business insights for Fortune 500 clients. Advanced spreadsheet proficiency in Excel (complex formulas, pivot tables, data modeling) combined with strong working knowledge of Power BI dashboard creation. Proven ability in data cleaning, trend identification, and root cause analysis for troubleshooting data discrepancies.

Excellent communication skills, translating technical insights into clear recommendations for non-technical business teams. Added advantage in SQL query writing, Python data visualization, VBA automation, and familiarity with AI tools and concepts.

Data Operation Analyst - NIQ (NielsenIQ) - Chennai, India

(2024-06 - 2026-04)

Supported analytics and reporting for Fortune 500 clients including Walmart and Amazon, transforming large, multi-source datasets into dashboards and reports used for business decision-making.

• Analyzed complex, multi-format datasets (CSV, PDF, relational databases) to identify business trends, usage patterns, and performance metrics for stakeholder reporting.
• Built interactive Power BI dashboards for stakeholders, consolidating data from multiple sources to give real-time visibility into key business metrics.
• Cleaned and validated data integrity across reporting pipelines - handling missing data, outliers, and inconsistent formats.
• Generated actionable reports for management by consolidating operational data into clear, decision-ready summaries.
• Performed root cause analysis to troubleshoot recurring data discrepancies, working with cross-functional teams to resolve issues at the source and reduce reporting errors.
• Applied advanced Excel skills (complex formulas, pivot tables, data modeling) to consolidate operational data and generate management-ready reports.
• Wrote SQL queries to extract, join, and aggregate data from relational databases, supporting ad-hoc analysis and recurring reporting needs.
• Used Python data visualization libraries to support analysis and automate repetitive data preparation tasks, speeding up reporting turnaround.
• Automated recurring reports and document workflows using VBA (Visual Basic) for MS Word and Excel, reducing manual effort for the team.
• Collaborated with teams to optimize processes and clearly communicated technical insights to non-technical business teams.
• Applied familiarity with artificial intelligence tools and concepts to support automation of data processing and reporting tasks.

Relationship Manager - City Union Bank - Chennai, India

(2023-05 - 2024-06)

• Promoted and sold the bank's products and services to existing and potential customers, consistently meeting sales targets.
• Built and maintained strong relationships with clients to ensure satisfaction and long-term loyalty.
• Handled day-to-day banking operations, including account management and transaction processing with accuracy and compliance.
• Identified opportunities to offer additional banking products tailored to individual customer needs, driving cross-sell revenue.

B.E.

• Mechanical Engineering - Anjalai Ammal Mahalingam Engineering College, Thanjavur, Tamil Nadu (2018 - 2021)

Diploma in Engineering - Vandyar Polytechnic College, Thanjavur, Tamil Nadu (2015 - 2017)

HSC (12th) - Higher Secondary Certificate - Gnanam Matric Hr Sec School, Thanjavur, Tamil Nadu (2013 - 2015)

SSLC (10th) - Secondary School Leaving Certificate - Rajah's Hr Sec School, Thanjavur, Tamil Nadu (2012 - 2013)