prasanth kancharana

Data Analyst & Business Intelligence (BI) Developer

Hyderabad 10+ yrs exp 90 · Outstanding

About

Spearheaded the development of 50+ interactive Power BI dashboards, visualizing key performance indicators (KPIs) across sales, marketing, and operations to directly inform strategic decisions. Engineered 5+ ETL pipelines using SQL Server Integration Services (SSIS), migrating 200 GB of legacy data to a modern data lake and enabling real-time analytics dashboards. Designed and deployed five fully automated data pipelines using SQL Server and Python, ensuring data quality and accuracy and resulting in 99.9% uptime while eliminating data discrepancies.

Skills & Expertise (18)

Power BI Advanced

8.5/10

6.5

Years Exp

Snowflake Advanced

8.5/10

Years Exp

SQL Advanced

8.0/10

6.5

Years Exp

DAX Advanced

8.0/10

6.5

Years Exp

SSIS Advanced

8.0/10

6.5

Years Exp

Data Transformation Advanced

7.5/10

6.5

Years Exp

T-SQL Advanced

7.5/10

6.5

Years Exp

SQL Server Advanced

7.5/10

6.5

Years Exp

Data Modeling Advanced

7.5/10

6.5

Years Exp

Data Warehousing Advanced

7.5/10

6.5

Years Exp

SSRS Advanced

7.5/10

6.5

Years Exp

Power Query Advanced

7.0/10

Years Exp

Data Storytelling Advanced

7.0/10

Years Exp

SSAS Intermediate

6.5/10

Years Exp

MySql Intermediate

6.0/10

Years Exp

Power Pivot Intermediate

6.0/10

Years Exp

MSBI Intermediate

6.0/10

Years Exp

MDX Intermediate

6.0/10

Years Exp

Work Experience

Software Engineer

Sutherland Global Services (on payroll of Motech Software)

Feb 2019 - Present

Spearheaded the design and development of data-driven dashboards and reports using Power BI, leading to a 20% improvement in client data accessibility and decision-making. Architected ETL processes in SSIS to load complex data from OLTP systems into a data warehouse, reducing processing time by 30%. Integrated Snowflake with S3, automating data ingestion and cutting manual data handling by 50%. Created and optimized data models for seamless reporting, resulting in faster report generation and deeper insights into policy renewals and claims. Led a team of 6, collaborating with onshore and offshore stakeholders to ensure project alignment with business goals and client satisfaction.

Software Engineer

PepsiCo

Feb 2019 - Sep 2021

Engineered Power BI dashboards for retail performance analysis across 100+ outlets, empowering the client with actionable insights that drove a 10% increase in sales. Created complex reports (drill-down, sub-reports, grouped reports) using SSRS, tailored to specific business requirements and enhancing operational reporting efficiency. Reduced report load times by 30% through advanced troubleshooting and optimization of Power BI performance. Collaborated with cross-functional teams to document the architecture of BI projects, ensuring scalability and future-proofing of solutions.