Ankita Sunil Oulkar

Data Analyst | Power BI Specialist | Automation & Insight Expert
Leeds, UK.

About

Highly accomplished Data Analyst with 8+ years of experience in business intelligence and data analytics, specializing in Power BI, SQL, Python, and Power Automate. Proven expertise in data modeling, ETL processes, and developing interactive dashboards that significantly improve KPI visibility and reporting accuracy. Adept at automating workflows, integrating diverse data sources, and leveraging data-driven insights to boost operational efficiency and stakeholder decision-making, with a track record of delivering over 40% improvement in KPI visibility and substantial reductions in manual effort.

Work

Aberystwyth University
|

Data Analyst & Power BI Developer

Aberystwyth, Wales, UK

Summary

Led data analysis and Power BI development initiatives, enhancing environmental data capture accuracy, automating workflows, and transforming raw data into actionable insights.

Highlights

Developed communication scripts for data loggers, achieving 99% accuracy in environmental data capture and satellite transmission efficiency.

Automated data workflows using Power Automate, triggered by emails and form inputs, reducing manual effort by 70% and minimizing response times by 60%.

Designed and built Power BI dashboards to transform raw hexadecimal data into actionable insights, increasing reporting efficiency by 50%.

Created custom Python visuals within Power BI to enhance data storytelling and support advanced analytics capabilities.

Integrated Microsoft Forms and Power Apps to streamline user input collection and automate dataset delivery processes.

Tech Mahindra
|

Data Analyst

Pune, Maharashtra, India

Summary

Drove data analysis and reporting for a global IT services and consulting company, leveraging Power BI, SQL, and Azure Insights to enhance decision-making and operational efficiency.

Highlights

Built Power BI reports with SQL Server and Azure Insights, leveraging advanced DAX functions to deliver real-time dashboards and elevate decision-making efficiency by 40%.

Managed Power BI reports on Power BI Service, achieving timely data delivery with a 98% success rate through robust dataset refresh, workspace management, and security controls.

Established and maintained data governance frameworks, including Row Level Security (RLS), to ensure secure role-based access and data integrity across departments.

Automated data flows using Power Automate and embedded PowerApps to extract Azure telemetry, enabling seamless updates and cutting manual intervention by 80%.

Led User Acceptance Testing (UAT) and troubleshooting sessions, ensuring robust production deployment and zero post-launch issues.

Indian Institute of Technology Goa
|

Data Specialist

Goa, Goa, India

Summary

Specialized in data management and analytics within an academic setting, automating performance evaluation, optimizing resource allocation, and enhancing data consistency.

Highlights

Developed Power BI models to automate academic performance evaluation, cutting reporting time by 80% and increasing accuracy by 95%.

Created interactive dashboards for academic and administrative decision-making, providing real-time insights and optimizing resource allocation efficiency by 30%.

Expanded data consistency and reporting accuracy by 90% through standardized data pipelines and validation techniques, significantly reducing errors in academic reports.

Digitized and managed employee and student records, and advanced technical support systems, improving overall data management and operational efficiency by 25-30%.

Provided hands-on training sessions and support to internal teams on Power BI and Excel solutions, fostering a data-positive culture within the institution.

Education

Karnataka State Open University
Mysuru, Karnataka, India

Master of Science

Computer Science

Goa College of Engineering
Goa, Goa, India

Bachelor of Engineering

Computer Engineering

Awards

Bravo Award

Awarded By

Tech Mahindra

Awarded for excellence in data analytics innovation and automation-driven process improvements, recognizing significant contributions to efficiency and insight generation.

Languages

English

Certificates

Python for Data Analysis & Visualization
Power Automate - Complete Guide to Microsoft Power Automate
Microsoft Power BI

Issued By

Microsoft

Data Analysts Toolbox: Excel, Python, Power BI, PivotTables
SQL Masterclass: SQL for Data Analytics

Skills

Business Intelligence & Reporting

Power BI, DAX, MQuery, Excel, Interactive Dashboards, KPI Visibility, Reporting Accuracy, Data Storytelling.

Automation & Integration

Power Automate, Power Apps, Workflow Automation, Data Workflow Automation, System Integration.

Data Handling & Analysis

SQL, Python, Pandas, NumPy, KQL, Data Modelling, ETL Processes, Data Governance, Data Validation, Hexadecimal Data Transformation.

Database Management

SQL Developer, SQL Server, Azure Insights.

Project & Quality Management

User Acceptance Testing (UAT), Troubleshooting, Technical Documentation, Stakeholder Training, Process Improvement.