Data Analyst with 3+ years in data visualization & SQL
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Data Analyst with 4 years of experience using data to provide business insights. Skilled in Python, Advanced SQL, Microsoft Excel, Tableau, Power BI, and data visualization. Experienced in analyzing large datasets, creating interactive dashboards, and providing automation solutions to support business decisions. I enjoy solving complex problems with data-driven methods.
Utkal University
Master of Business Administration
N/A – June 30, 2024
Gemcokati Exploration Pvt. Ltd
Data Analyst (Operation Analyst)
August 1, 2021 – May 1, 2025
Chandrapur, Maharashtra, India
Enterprise Drilling Operations Performance Analytics
June 23, 2026 – Present
Led end-to-end data analytics implementation for multi-site drilling operations to improve productivity visibility, standardize reporting, and enable data-driven operational decisions. Designed centralized MySQL data architecture integrating multi-site drilling, manpower, and equipment datasets. Developed automated ETL pipelines using Python (Pandas) to clean, validate, and standardize field-level operational data. Conducted exploratory data analysis (EDA) to identify: Equipment downtime patterns, Shift inefficiencies, Productivity deviations, Site-wise performance variance. Built dynamic executive dashboards using Power BI and Tableau covering: Meterage drilled vs targets, Rig utilization rate, Shift productivity KPIs, Downtime root-cause analysis, Site benchmarking models. Automated MIS reporting framework using Advanced Excel (Power Query, Pivot Models) reducing manual reporting dependency by 40%. Partnered with project managers and field engineers to translate analytical insights into operational improvements.
View ProjectCost Intelligence & Resource Optimization Framework
June 23, 2026 – Present
Developed a cost analytics and resource optimization system to improve financial control, operational transparency, and audit readiness across active drilling sites. Consolidated cost datasets (fuel, manpower, consumables, maintenance, vendor payments) into structured MySQL databases. Built SQL-based analytical models to calculate: Cost per meter drilled, Equipment-level cost efficiency, Budget vs actual variance, Vendor performance scorecards. Applied Python-based statistical analysis for: Outlier detection (fuel & consumables variance), Cost trend forecasting, Budget deviation modeling. Designed executive dashboards in Power BI & Tableau for: Monthly cost projections, Site-level cost comparison, Financial KPI tracking, Resource utilization heatmaps. Automated Excel-based forecasting templates for operational budget planning. Supported PSU audit reviews by generating structured analytical documentation and compliance-ready reports.
HackerRank Certified – Python (Basic / Intermediate)
HackerRank
June 1, 2026 – Present
HackerRank Certified – SQL (Basic, Intermediate & Advance)
HackerRank
June 1, 2026 – Present
Cultural Fit Analysis
The candidate's project experience in the mining and steel sector, particularly with PSU clients, indicates adaptability to structured environments and experience with compliance-ready reporting. Their MBA education suggests a business-oriented mindset, which is beneficial for understanding organizational goals and translating data into strategic value. The breadth of tools used (Python, SQL, Power BI, Tableau, Excel) shows a willingness to learn and apply diverse technologies, contributing to a flexible cultural fit.
Soft Skills & Operational Fit
The candidate demonstrates strong problem-solving, analytical thinking, and team collaboration skills through project descriptions. Their experience in partnering with project managers and field engineers to translate insights into operational improvements indicates good communication and stakeholder management. The focus on automating reports and improving efficiency aligns well with operational excellence.