Omkar K

Data Analyst

Ajara, Maharashtra 1+ yrs exp 88 · Excellent

About

Result-oriented Data Analyst with 1.5+ years of experience delivering Data Analysis and Business Intelligence solutions for enterprise retail analytics at Cognizant. Experienced in SQL, Power BI, Advance Excel, DAX for data cleaning, analysis, visualization, and reporting. Skilled in translating business requirements into analytical solutions, Developing Dashboards, track key business metrics, and collaborating with cross-functional stakeholders to deliver reliable, data-driven insights in Agile environments. Strong analytical mindset and ability to manage multiple priorities in fast-paced environments.

Skills & Expertise (50)

Power BI Intermediate

8.1/10

1.5

Years Exp

SQL Intermediate

7.5/10

1.5

Years Exp

Data Analysis Intermediate

7.0/10

1.5

Years Exp

Data Visualization Intermediate

7.0/10

1.5

Years Exp

Tableau Intermediate

6.5/10

1.5

Years Exp

stakeholder communication Intermediate

6.5/10

1.5

Years Exp

Data Cleaning Intermediate

6.5/10

1.5

Years Exp

Business Analysis Intermediate

6.0/10

1.5

Years Exp

DAX Intermediate

6.0/10

1.5

Years Exp

Data Management Intermediate

6.0/10

1.5

Years Exp

Agile Exploratory data analysis KPI Analysis Trend Analysis Root Cause Analysis Gap Analysis Business Process Analysis Requirement gathering RDBMS Business Reporting BRD Frd Process Improvement Ad Hoc Reporting Executive Reporting Risk Assessment Decision Making Project documentation Communication Skills Data Extraction Pivot Table VLOOKUP XLOOKUP HLOOKUP SUMIFS Power Pivot Data collection KPI Reporting Data Transformation Data Validation SQL Server Data Modelling Data Analytics MIS Reporting ETL Validation Dashboards Power Query MySql Query Optimization Advance Excel

Work Experience

Data Analyst

Cognizant Technology Solutions

Jan 2025 - Present

Analyzed large datasets using SQL to identify trends, business opportunities resulting in 15% increase in operational efficiency. Developed and enhanced 15+ Power BI dashboards for sales, inventory, customer, and operational reporting, enabling business stakeholders to monitor KPIs through centralized dashboards. Developed complex MySQL queries to extract, transform, and validate data from multiple retail databases. Maintained production dashboards by resolving refresh failures, dashboard loading issues, and reporting inconsistencies while automating scheduled Power BI dataset refreshes. Performed ad-hoc analysis to investigate KPI fluctuations, identifying increased operating expenses as the primary reason for reduced net profit margin despite stable revenue. Collaborated with business managers, project managers, and clients to gather reporting requirements, explain KPIs, deliver sprint-based enhancements, and present analytical findings.