Skip to content

Chakali Yougandar

Data Analyst • Bangalore • Y*********************@gmail.com • 701****122 • drivetube.ai/•••••

Career Objective

Data Analyst with 2 years of experience transforming raw data into actionable business insights using SQL, MSBI, Power BI, Alteryx, and Excel. Skilled in ETL design, data modeling, OLAP, dashboard development, report automation, data validation, and incident support for production data pipelines. Proven collaborator with business stakeholders to deliver timely, high-quality analytical solutions that support decision-making and operational efficiency.

Education

SVR Engineering and Technology (JNTUA)
Bachelor of Technology

Technical Skills

Databases: SQL,SQL Server,Replicon,Azure Datahub
Data and Analytics: Power BI,DAX,Power Query,Interactive Dashboards,Report Automation,Data Modeling,Data Cleaning,Data Validation,Root Cause Analysis,Performance Optimization,Excel
Tools and Methodologies: ITSM ServiceNow,Incident Management,Requirement Gathering,Stakeholder Collaboration
Skills: T-SQL,Stored Procedures
Business Intelligence & ETL: SSIS,SSAS,SSRS,Alteryx Designer,ETL workflows,OLAP cubes

Projects

Analysis and Reporting System for IT Industries
Tools Used: SQL Server, SSIS, SSAS, Power BI, T-SQL, OLAP cubes
  • Built an end-to-end analysis and reporting solution for IT/ITES industry and employee datasets using SQL Server, SSIS, SSAS, and Power BI to enable cross-functional decision-making.
  • Designed and implemented ETL workflows in SSIS to extract, transform and load data from multiple operational sources, improving ingestion reliability and consistency.
  • Developed SSAS multidimensional models and OLAP cubes to support advanced analytics and fast ad-hoc querying for business users.
  • Authored T-SQL queries and stored procedures for data extraction, validation, and aggregation, enabling repeatable and auditable data pipelines.
  • Created interactive Power BI dashboards presenting industry metrics and employee performance insights, reducing time-to-insight for stakeholders.
Banking and ESG Analysis
Tools Used: Power BI, Excel, Data Modeling, ESG KPIs, Stakeholder Collaboration
  • Collected, cleaned and integrated ESG-related banking data from multiple internal sources to create a consolidated dataset for KPI reporting.
  • Defined and structured key ESG metrics in partnership with stakeholders to address inconsistent industry breakdowns and ensure comparability.
  • Designed and delivered interactive Power BI dashboards for real-time ESG KPI monitoring tailored to banking domain requirements.
  • Performed deep-dive analyses to identify performance gaps and provided actionable recommendations to improve sustainability outcomes.
  • Validated ESG data with domain teams to ensure alignment with organizational goals and regulatory expectations.
GTM Replicon Incident Management (Azure Datahub L2)
Tools Used: SQL, Excel, ServiceNow, Incident Management, Root Cause Analysis, Data Synchronization
  • Provided L2 support for Azure Datahub pipelines and GTM–Replicon data flows, monitoring production jobs and responding to incidents to maintain business continuity.
  • Managed incident tickets and service requests in ServiceNow, ensuring timely resolution and adherence to SLA timelines.
  • Collaborated with L3 engineering and data engineering teams to troubleshoot complex production issues and minimize business impact.
  • Conducted thorough root-cause analyses for recurring and high-priority incidents and implemented preventive measures to reduce recurrence.
  • Validated GTM to Replicon data synchronization processes to ensure accuracy of timesheets and workforce productivity metrics used for reporting.

Powered by Drivetube · Create your own profile at drivetube.ai