LORENS MISHRA
LORENS MISHRA
WELCOME TO MY PORTFOLIO
I specialize in transforming raw data into
actionable business insights using
SQL, Power BI, Excel, and Python.
Passionate about KPI tracking,
dashboard development, and
data-driven decision making.
A quick introduction — who I am, what I do, and what drives me.
I am an MCA graduate (8.90 CGPA) with professional experience as a Software Engineer.
I am currently working at Knack Global Pvt. Ltd. as a Junior Software Engineer.
My primary interest lies in Data Analytics and Business Intelligence.
I work with SQL, Power BI (DAX & Power Query), Excel Dashboards, Python, and Jira to clean data, perform analysis, and create performance reports.
I focus on converting raw datasets into structured insights that help organizations track KPI performance, identify trends, and support data-driven decisions.
I have built 6+ data analytics projects including Power BI dashboards, exploratory data analysis (EDA), SQL reporting systems, and machine learning models.
Tools and technologies I use daily to clean, model, and visualize data.
Python
Java
C
Jira
Dashboard
Power BI
Pipelining
SQL
Excel
GitHub
Git
Jira
MS Office
Python
Java
C
Jira
Dashboard
Power BI
Pipelining
SQL
Excel
GitHub
Git
Domo
MS Office
Where I learn, build, and showcase my work — from analytics communities to competitive coding platforms.
A curated selection of analytics dashboards, EDA notebooks, and ML projects — turning raw data into clear, actionable stories.
Built an interactive Power BI dashboard to analyze regional sales performance, revenue trends, and KPIs. The dashboard helps track sales growth and improves business decision-making through visual insights.
Repository containing structured DBMS concepts, SQL practice queries, joins, subqueries, and business case projects used for data analysis and reporting.
Built a machine learning model to predict house prices using historical housing data. Applied data preprocessing, feature engineering, and regression techniques for accurate predictions.
Repository containing structured Excel learning notes including formulas, functions, pivot tables, charts, and dashboard concepts used for data analysis and reporting.
Repository containing structured learning notes on Jira including backlog management, sprint planning, issue tracking, workflows, and agile project management concepts.
Building strong foundations in mathematics, computer science, and applied analytics.
University of Allahabad
CGPA: 8.9
University of Allahabad
Score: 69.2%
Building practical experience in data analytics, dashboard development, business intelligence, ETL workflows, and reporting solutions.
Knack RCM – Hyderabad, Telangana
Migrated User Performance and Quality reports from Excel to DOMO using ETL pipelines and Analyzer.
Performed data cleansing, transformation, and validation for accurate business reporting.
Contributed to migration of PPM-related dashboards from CyberQuery to DOMO.
Worked with JIRA for issue tracking, workflow management, and team collaboration.
Performed OCR testing, report validation, and data quality checks for reliable datasets.
Worked on Prompt Engineering and OCR data testing to support LLM-based validation and intelligent reporting workflows.
Owl AI (Overload Ware Labs AI)
Developed interactive Power BI dashboards to visualize sales KPIs, trends, and business performance.
Created calculated columns and measures using DAX for dynamic reporting and analytics.
Used SQL queries for data extraction, filtering, and transformation from structured datasets.
Built visual reports to support business insights and data-driven decision making.
Continuous learning across analytics, BI tools, and programming — earned milestones along the way.
PW Skills
Feb 2025
Udemy
Aug 2025
Scaler
Jul 2025
Udemy
2025
Simplilearn
2025
HackerRank
Mar 2026
HackerRank
Apr 2026
HackerRank
Apr 2026
LeetCode
Apr 2026
LeetCode
2026
LeetCode
2026
LeetCode
2026Open to data analyst & BI roles, freelance dashboards, and collaborations — say hi!
I am open to Data Analyst & BI opportunities. Feel free to contact me for:
Download Resume PDF · Updated May 2026
