Shashidhar 19

Data Analyst

Bangalore, India 80 · Excellent

About

Data Analyst with 3+ years of experience in data analysis, reporting, and business intelligence, turning raw data into actionable insights using SQL, Excel, and Power BI. Skilled in querying and analyzing data with SQL, building pivot tables and formula-driven models in Excel, and designing dashboards and KPI frameworks in Power BI. Experienced in maintaining and supporting Power BI, IBM Cognos, and Tableau applications across Development (DEV), User Acceptance Testing (UAT), and Production (Prod) environments, ensuring system reliability, and seamless reporting operations.

Skills & Expertise (40)

SQL Server Advanced

8.0/10

Years Exp

Data Cleaning Intermediate

7.5/10

Years Exp

Python Intermediate

7.0/10

Years Exp

Tableau Intermediate

7.0/10

Years Exp

Row-Level Security Dimension Tables Pandas NumPy Java OOPs Power Query Microsoft Azure AWS Snowflake Schema Role-based access control Access Control ServiceNow Hpsm MS Office Excel Word PowerPoint Power BI Desktop Pivot Tables Lookups Data Manipulation MS-SQL Joins Subqueries Window Functions Query Optimization Fact Tables Power BI Service IBM Cognos Dashboard Design Data Validation Root-cause analysis Descriptive Statistics Star Schema Advanced Formulas

Work Experience

Data Analyst

DXC Technology

Present - Present

Analyzed and validated business data using SQL and Excel, building pivot tables and formula-based checks to catch inconsistencies before reporting. Designed and implemented Star Schema data models with optimized fact and dimension tables, improving report performance. Enhanced and developed interactive Power BI dashboards and reports that transformed complex data into actionable insights. Developed advanced DAX measures (YTD, MTD, QTD, variance %, rolling averages) for executive-level performance tracking, applying core statistical concepts to reporting. Wrote SQL queries using Joins, Subqueries, and Window Functions to support risk and finance reporting requirements. Enforced Role-Based Access Control (RBAC) and Dynamic Row-Level Security (RLS) to ensure secure data access for regional managers. Created drill-through reports, tooltips, and bookmarks to improve user navigation and data exploration. Resolved data refresh failures and performed data quality checks to ensure seamless data integration and reporting accuracy.

Cognos Reporting & Administration

IBM Cognos

Present - Present

Provided L2 production support, resolving report failures and coordinating fixes with development teams. Supported package deployment, performance tuning, and environment migrations (DEV → QA → PROD). Monitored system metrics and admin consoles to maintain operational integrity. Engaged with development teams to coordinate defect remediation and confirm successful release outcomes.

Tableau Administration

Present - Present

Conducted comprehensive monitoring and maintenance of Tableau Server, enhancing system reliability and user accessibility. Validated and updated data source credentials to ensure secure, accurate data access. Supported teams in troubleshooting issues to stabilize system reliability. Delivered environment feedback and health reports to simplify client understanding. Managed creation and modification of Tableau sites to optimize data visualization capabilities.