Power Bi Data Analyst

RESUME

Amol Gaikwad

Mail ID: ******@*****.***

Contact No: +91-955*******

LinkedIn: http://www.linkedin.com/in/amol-gaikwad- Professional Summary

Power BI Developer & Data Analyst with 4+ years of experience designing data models, building interactive dashboards, and delivering insights that drive business decisions. Skilled in Power BI, SQL, DAX, and cloud integrations (Azure). Proven success in reducing reporting cycles by 40%, optimizing KPIs, and enabling leadership teams to make faster, data-driven decisions

Core Skills

Business Intelligence Tools: Power BI (Desktop, Service, Dataflows, Datamarts), Power Query (M)

Data Modeling: Star Schema, Snowflake, Composite Modeling

Databases: SQL Server, Oracle, PostgreSQL, MS Access

Languages: SQL, DAX (Advanced), Excel (Advanced)

BI Practices: Report Automation, KPI Tracking, Dashboard Optimization, Data Visualization, RLS Security

Cloud Platforms: Microsoft Azure

Work Experience

Tata Consultancy Services (TCS), Pune

• Power BI Developer Oct 2020 – Present

Designed and deployed 20+ interactive dashboards across Insurance and HR domains, reducing manual reporting by 45% and improving SLA compliance tracking.

Built optimized data models (Star & Snowflake) handling 10M+ rows across SQL Server, Oracle, and SAP data sources, ensuring performance and accuracy.

Developed advanced DAX measures to calculate KPIs (SLA compliance, productivity, attrition), cutting SLA breaches by 15%.

Implemented row-level security (RLS) for 500+ users, safeguarding sensitive business data.

Partnered with cross-functional teams across India & UK, ensuring 95% on-time delivery of BI projects.

• Senior MIS Analyst May 2017 – Oct 2020

Automated VBA, Excel and SQL-based reporting processes, saving 20+ hours weekly and reducing manual errors by 30%.

Designed and maintained weekly/monthly performance dashboards that provided leadership with actionable insights into productivity trends.

Collaborated with the operations team to identify process inefficiencies, creating MIS reports that improved accuracy in SLA tracking by 15%.

Supported business teams with ad-hoc analysis and data validation for decision-making.

• Senior Process Associate Mar 2015 – May 2017

Handled day-to-day transaction processing and operational activities while ensuring 100% compliance with defined SLA timelines.

Resolved customer and client queries within agreed TAT, improving first-contact resolution rate.

Assisted in process documentation and SOP updates, which helped new team members ramp up faster.

ICICI Bank, Pashan Pune Br

• Sales Officer Mar 2014 – Mar 2015

Managed customer acquisition and cross-selling of banking products, consistently meeting monthly sales targets.

Built and maintained strong client relationships, increasing repeat business by 20% within the first year.

Conducted market research and lead generation, which boosted new account openings by 15%.

Delivered personalized financial solutions, improving customer satisfaction scores and contributing to branch revenue growth.

Key Projects

Diligenta SLA Analysis SQL / Power BI Developer Feb 2024 – Aug 2025

• Developed automated Power BI dashboards to monitor SLA performance across insurance operations, reducing SLA breach rate by 12%.

• Integrated multiple data sources (SQL Server, Excel, Oracle) and built a centralized data warehouse for reporting.

• Coordinated with offshore teams and stakeholders, ensuring smooth project delivery. Diligenta Mandatory Training Compliance Report Power BI Developer Sep 2023 – Feb 2024

• Designed and developed a Mandatory Training Compliance dashboard in Power BI to track training completion status for ~6,000 onshore & offshore employees.

• Integrated data from Oracle SQL and Excel using Power Query for cleansing and transformation, ensuring accuracy and completeness.

• Built interactive Power BI reports with drill-down and scheduling in Power BI Service, enabling HR and compliance teams to monitor progress in real-time.

Aviva Employee Performance Analysis SQL / BI Developer Feb 2023 – Sep 2023

• Built Power BI reports analyzing performance of 18M+ employee records, improving workforce allocation decisions.

• Designed enterprise architecture, configured gateways, and automated refresh schedules to ensure data accuracy.

• Created drill-down & drill-through reports that improved HR’s visibility into attrition trends. SunLife Resource Management SQL / BI Developer Oct 2022 – Mar 2023

• Designed data warehouse architecture and mappings from source-to-target tables.

• Built Power BI dashboards for HR data (DOJ, notice period, release dates), reducing report preparation time by 40%.

• Deployed dashboards via Power BI Service with enterprise gateway integration. Certifications

Microsoft Certified: Power BI Data Analyst Associate (PL-300) Education

Bachelor of Commerce (B. Com) – Baking & Finance, Pune University – 2010 Thanks

Amol Gaikwad

Contact this candidate