Open to opportunities

vidya kolati

@vidyakolati

Message

Data Analyst at ShowTime Consulting who analyzed survey data from 4 million residents and builds Power BI dashboards.

India

Message

At ShowTime Consulting, I write and optimize SQL queries and Python scripts to clean and transform datasets, improving dataset accuracy by 20%. I also build Power BI dashboards that communicate KPIs and regional trends.

I analyzed survey data from 4 million state residents, including data validation and statistical trend analysis for strategic planning. I also examined IVR call-duration patterns to evaluate stakeholder engagement and outreach.

At APPSeCONNECT Automation Pvt Ltd, I translated enterprise clients’ reporting and data-flow requirements into integration configurations. I developed SQL stored procedures and automated Salesforce CRM–SAP Business One synchronization workflows, improving synchronization efficiency by 30%.

I tested and quality-checked integrations across CRM, ERP, and e-commerce platforms, and investigated data issues with clients and Product Engineering. I also authored technical documentation, solution notes, and end-user training materials.

Experience

Work history, roles, and key accomplishments

Current

Data Analyst

Current

ShowTime Consulting

Apr 2024 - Present (2 years 7 months)

Write, optimize, and integrate complex SQL queries and Python scripts to extract, clean, and transform large-scale relational datasets, improving dataset accuracy by 20%. Design and maintain interactive Power BI dashboards and custom visual reports to communicate KPIs and operational insights.

SQL Python Power BI Data Cleaning Data Validation Statistical Analysis Sentiment Analysis Opinion Mining IVR Analysis Data Visualization

Techno-Functional Consultant (Customer Success Team)

APPSeCONNECT Automation Pvt Ltd

Dec 2021 - Jun 2024 (2 years 6 months)

Partnered with enterprise clients and Customer Success Managers to gather requirements and translate them into technical specifications. Developed and optimized SQL stored procedures and automated data synchronization workflows between Salesforce CRM and SAP Business One, improving efficiency by 30%.