Built with datascienceportfol.io

Rashmi Krishnamohan

Sr. Data Analyst at United Way

Based in Windsor, Ontario

About

Certified Power BI Data Analyst with over 6 years of professional experience, specializing in ETL processes. Proficient in SQL, Power BI, Python, and Excel. I transform raw data into actionable insights, making complex information feel like a breeze. Let's turn your data into strategic advantages!

Skills

Projects

Experience

Nov 2021-Present

Sr. Data Analyst at United Way

• Developed a data warehouse that centralized all company’s datasets, improving the speed of reporting by 82% • Automated data acquisition and cleaning processes utilizing Python libraries such Pandas. • Created and implemented ETL pipelines for reporting purposes within Data Warehouse. • Wrote DAX Queries and Developed Power BI dashboards for analyzing important KPI’s for Business users. • Collaborated with Data and evaluation team to update and build out 30+ dashboard reports • Develop and deploy quality SQL codes, stored procedures, and triggers to cut database populating time from 2 minutes to 56 seconds. • Created streamlined data pipelines to guarantee the seamless and precise transfer of data to designated destinations, all the while upholding data integrity.

Sept 2020 - Nov 2021

Data Analyst at Arzosoft Link Inc

• Gathered client requirements and delivered optimal solutions in collaboration with stakeholders and cross-functional teams. • Leveraged Power Query to automate data cleaning processes, reducing data preparation time by 30% • Integrated custom visuals and applied advanced DAX calculations to create KPIs and dynamic reports, enhancing insights for decision-making. • Automated data refresh schedules within Power BI Service, ensuring up-to-date data availability for reports. • Delivered real-time insights by building robust data models and custom calculated measures, driving improvements in business performance tracking. • Developed multiple dashboards, analytical reports, KPIs, and interactive reports based on business requirements. • Optimized Power BI reports by using advanced filtering

Sept 2017 - April 2020

System Analyst - Data Developer at Tata Consultancy Services

• Developed complex SQL scripts, views, and stored procedures across multiple databases, enhancing data retrieval by 30% • Designed and deployed Microsoft SSIS pipelines to streamline ETL processes, resulting in a 30% improvement in reporting turnaround time. • Automated the processing of 1,000+ reports using SSIS and SSRS, decreasing processing time by 77%. • Translated business requirements into SQL stored procedures for database-specific projects, ensuring alignment with client needs. • Resolved user queries that exceeded the scope of L1 support, mitigating potential impacts on business operations. • Implemented access and security controls for comprehensive database administration, including secondary authorizations for enhanced data protection. • Delivered actionable insights through

Education

2020 - 2021

Master of Engineering at University of Windsor

Master's Degree in Electrical and Computer Engineering

2013 - 2017

Bachelor of Engineering at Anna University

Bachelor's Degree in Electronics and Instrumentation Engineering