Data Analyst Power Bi

KILARUSRAVAN

Analyst

+1-630-***-**** ******.****@*****.***

SUMMARY

ExperiencedDataAnalystwith3yearsacrossIndustry,skilledinSQL,Python,anddatavisualizationwithPowerBIandTableau. Provenabilitytoextractactionableinsights,buildETLpipelines,anddrivedata-informeddecision-making.Proficientacrossthe 5entireSoftwareDevelopmentLifeCyclespectrum,Design,Development,Testing,andDeploymentphases.

SKILLS

DataAnalysisTools:SQL,Python,R

DataVisualizationTools:Tableau, PowerBI

Documentation:FRD,BRD,SRS,UserStories

DatabaseManagement:Oracle,MSSQLServer,PostgreSQL

DataModeling&Transformation:ETLprocesses,datapipelines

ProjectManagementTools:MSProject,MSOffice,MSSharePoint,MSExcel

Tracking/OtherTools:Jira,MSVisio,HPQualityCenter,JAD,UAT

AnalysisSkills:Cost/BenefitAnalysis,ImpactAnalysis,RiskAnalysis,SWOTAnalysis,GAPAnalysis,CohortAnalysis

EXPERIENCE

Northern Trust,USA Aug2024- Current Data Analyst

Entered, maintained, and validated transactional and client data in enterprise systems, ensuring high data accuracy and integrity.

Designed and automated ETL pipelines using SQL, Python, and BigQuery, integrating financial, client, and transactional datasets from multiple sources.

Developed and maintained Power BI dashboards to deliver real-time insights on key business KPIs, supporting forecasting and financial planning.

Partnered with data engineering teams to enhance data models and optimize reporting queries for large-scale datasets on GCP.

Applied Python scripting to automate recurring reporting tasks, improving data accuracy and reducing manual effort.

Authored data governance documentation (data dictionaries, FRDs, metadata guides) to ensure compliance and consistency across reporting environments.

Collaborated with business stakeholders to address ad hoc data queries and report generation requests, ensuring timely insights for decision-making.

Produced data catalogs and documentation, improving transparency, data stewardship, and cross-team knowledge sharing.

SofturaTechnologies,India May2022–Aug2023 Data Analyst

Performed in-depth retail and sales data analysis, improving data accuracy and reporting efficiency by 30%.

Built interactive dashboards in Power BI and Tableau to track sales, client, and operational performance metrics, enabling business leaders to act on trends.

Performed SQL-based data extraction, validation, and transformation across Salesforce and relational databases, ensuring consistency of reporting datasets.

Designed and implemented ETL workflows with Python and SQL, improving reporting efficiency and reducing manual processing by 30%.

Conducted descriptive and diagnostic analytics to uncover actionable insights, driving strategy for client engagement and business performance.

Supported database management and Salesforce data integration, improving data accuracy and reducing reporting errors.

Supported database management and Salesforce data updates, ensuring accurate tracking of business opportunities.

EDUCATION

Master’s in computer science University of Illinois at Chicago,USA Dec2024

BachelorofComputerScienceandEngineering SRMUniversity,India May 2023

Contact this candidate