Hello!

I'm Ramprakash Ganesh

A Power BI and SQL-focused Data Analyst with 2+ years of experience in data cleaning, dashboard creation, and automation. Proven expertise in streamlining reporting processes and improving data quality for large-scale enterprise systems.

Year of Experience
0 +
Successful Project
0 +

Data Analyst

Find Me :

About Me

Get in touch with me

I am a passionate Data Analyst with a strong foundation in SQL, Power BI, and Excel-based automation. With over 2 years of industry experience, I specialize in transforming large datasets into meaningful business insights and simplifying complex reporting workflows.

My goal is to drive better decision-making by building clear dashboards, automating data pipelines, and ensuring end-to-end data quality. I stay continuously up-to-date with analytics trends and bring an agile mindset to every project I lead. My work has helped reduce reporting errors by 22% and cut manual processes by 40%.

Vision

To empower organizations by transforming raw data into interactive dashboards and actionable KPIs that boost productivity and clarity.

Mission

To leverage SQL, Power BI, and automation to solve reporting bottlenecks, ensure reliable data operations, and deliver meaningful insights.

Years of Experience
0 +
Major Projects Completed
0 +
Dashboards Built
0 +
Data Processed
0 k+
What I Do?

Data Analysis and Reporting Automation

Creating SQL-powered reports and Power BI dashboards to automate manual reporting and reduce effort by up to 40%, ensuring timely and accurate insights.

Database Migration and Cloud Integration

Led successful migration of 500K+ rows from legacy systems to Snowflake using Excel VBA and Informatica, optimizing access and long-term scalability.

Business Intelligence & KPI Monitoring

Developed real-time dashboards in Power BI and Excel to track KPIs, sales forecasts, and data quality metrics across multiple departments.

My Skills

How can I assist with the upcoming project?

Skilled in data analysis, statistical modeling, SQL, Python, and data visualization with a strong focus on turning raw data into actionable insights.

FrameWorks
Agile, Scrum, SDLC, ensuring streamlined delivery processes and effective data-driven solutions. 100%
Languages & Database
SQL, Python, MySQL, DAX, Amazon Redshift for querying, transformation, and analysis 100%
ETL & Storage
ETL development, data cleaning, AWS S3, IICS integration, data modeling, relational DB. 100%
Data Tools
Power BI, Advanced Excel (VLOOKUP, Pivots), Pandas, NumPy, Matplotlib - visual analytics. 100%
Platforms
JIRA for project tracking, Power BI and Excel for reporting and visualization, Agile development. 100%

Cognizant Technology Solutions

Data Analyst

March 2021 – June 2023

Led database migration and reporting automation at Cognizant by engineering 70+ SQL scripts and automating record profiling, improving schema accuracy by 25%. Created Excel-based reports to track ingestion quality, reducing manual effort by 40%. Drafted 100+ L3 incident summaries, enhancing triage accuracy by 15%. Resolved anomalies across 12+ pipelines and reduced rollback by 20%. Validated schema integrity and executed audits that cut downstream errors by 22%. Coordinated cross-functional requirements across teams, improving traceability and reducing rework during testing by 35%.

My Experiences

Let's Work Together

Experienced in data analysis, machine learning, and problem-solving with a proven ability to deliver actionable insights that drive informed business decisions.

My Education

Learning Journey

Dedicated to continuous growth through academic excellence in data analytics, business analysis, and computer applications.

Durham College, Ontario

Graduate Certificate in Data Analytics

September 2024 - April 2025

Sheridan College, Ontario

Graduate Certificate in Business Analysis and Process Management

January 2024 - August 2024

Sri Krishna Arts and Science College, India

Bachelor of Computer Applications

June 2017 - September 2020

Microsoft Certified Power BI Data Analyst Associate

Microsoft Certified Azure Data Fundamentals (DP-900)

My Certificates

CERTIFICATIONS

My certificates

CERTIFICATIONS

Microsoft Certified Power BI Data Analyst Associate

Microsoft Certified Azure Data Fundamentals (DP-900)

Recent Projects

Developed scalable analytics pipelines and automation frameworks to deliver trusted insights and streamline operations across domains.

Data Analytics Projects

Project 1: Data Quality Assurance & Automation
Location: Remote
July 2022 – Present
  • Automated profiling of records to validate constraints and schema integrity across systems.
  • Reduced manual validation hours by 40% through Excel reporting and SQL scripting.
  • Enabled real-time reporting by preparing ingestion-ready pipelines with verified lineage.
Project 2: INCIDENT TRACKING & ROOT CAUSE ANALYSIS
Location: Remote
January 2022 – June 2022
  • Drafted 100+ L3 incident summaries and optimized issue triage using a structured status tracker.
  • Enhanced incident resolution accuracy by 15% via clear blocker classification and ownership mapping.
  • Reduced system rollback events by 20% through anomaly detection and remediation.
Scroll to Top