Available for opportunities

Niranjan Patra

Senior Data Analyst

Senior Data Analyst with 5+ years of experience in SQL-driven analytics, reporting automation, KPI dashboards, compensation analytics, and operational insights for global enterprise clients. Proven track record in building automated reporting systems, reducing manual effort by up to 80%, improving TAT by 40%, and enabling data-driven decision-making.

0+
Years Experience
0%
Manual Work Reduced
0%
TAT Improvement
0+
Users Served
0K$
Quarterly Savings
0/5
Client CSAT
Scroll to explore
Career Journey

Work Experience

A track record of delivering impactful data solutions and driving business value through analytics

Senior Associate - Data Analytics

Axtria India Pvt. Ltd.

Mar 2022 - Present Bengaluru, India
Delivered business performance insights, KPI reporting, and compensation analytics for U.S. clients
Designed SQL-driven reports, Excel KPI models & dashboards improving leadership visibility
Led a 6-member automation team, implementing SQL/VBA-based workflows reducing manual work by 80%
Improved analytics TAT by 40% through automation and optimized reporting pipelines
Applied statistical techniques—segmentation, correlation analysis, accuracy analysis—to evaluate performance trends
Built automation for distributing personalized IC reports to 10,000+ users

Assistant System Engineer - Data Analytics

Tata Consultancy Services

Aug 2020 - Mar 2022 Bhubaneswar, India
Built data validation & reporting automation using SQL, scripting & backend logic
Developed a PHP/MySQL web application cutting manual effort by ~90% and saving $500 per cycle
Created Excel dashboards & checklist systems improving KPI visibility & audit readiness
Validated financial reports ensuring accuracy, compliance, and audit readiness
Collaborated with U.S. client teams on requirement gathering and insights delivery

Automation Impact Over Time

Before
Phase 1
Phase 2
Current
Automated
Manual

Skills & Expertise

A comprehensive toolkit for transforming raw data into actionable insights

Core Technical Proficiency

Analytics & Tools

SQLPythonVBAPower BIPower QueryMS ExcelJupyter

Automation

SQL AutomationVBA AutomationWorkflow AutomationBackend Scripts

Collaboration

JiraAzure DevOpsGitVS Code

AI Tools

ChatGPTCopilotAI Analytics

Professional Skills

Stakeholder Engagement
Problem-Solving
Client Communication
Leadership & Mentoring
Analytical Thinking
Documentation
Cross-Team Collaboration
Agile (Scrum/Kanban)
Technical Stack

Tools I Master

A comprehensive toolkit powering data-driven solutions

SQL

Advanced queries, optimization, stored procedures

Data extraction Complex joins Performance tuning

Python

Data analysis, automation scripts, pandas

Data manipulation Automation Statistical analysis

Excel VBA

Macro development, report automation

Report generation Data validation Workflow automation

Power BI

Interactive dashboards, data storytelling

KPI dashboards Executive reports Data exploration

Power Query

ETL processes, data transformation

Data cleaning Transformation Data modeling

Git

Version control, collaboration

Code versioning Team collaboration CI/CD

Jupyter

Interactive notebooks, data exploration

Prototyping Analysis Documentation

Azure DevOps

Project management, pipelines

Sprint planning Work tracking Deployments

MS Access

Database design, rapid prototyping

Small databases Forms Quick apps

Jira

Agile project tracking, sprint management

Task management Agile workflows Reporting

ChatGPT

AI-assisted analysis, code generation

Code assistance Documentation Analysis help

Copilot

AI pair programming, productivity boost

Code completion Refactoring Learning

Data Engineering

Building robust data pipelines and ETL processes

SQL optimization Data modeling Pipeline automation

Business Intelligence

Transforming data into actionable business insights

Dashboard design KPI tracking Executive reporting

Process Automation

Eliminating manual work through smart automation

VBA macros Script automation Workflow optimization
12+ Tools & Technologies Mastered
Data Insights

Analytics Dashboard

Visual representation of impact metrics and performance indicators

Automation Rate
Data Accuracy
TAT Improvement
Process Efficiency

Quarterly Performance

Savings & Efficiency trends

+23%
100 75 50 25 0
65%
8K
Q1
72%
9K
Q2
78%
10K
Q3
85%
12K
Q4
Efficiency (%)
Savings ($K)

Skill Distribution

Technical expertise overview

Automation Python Excel Power BI VBA SQL

Core Competencies

95% Data Analytics
90% KPI Analysis
88% Dashboard Dev
92% Automation
94% Reporting
85% Statistical Analysis
88% Process Optimization
86% Stakeholder Mgmt

Hover over bubbles to see details

Analytics Expertise

What I Analyze

End-to-end analytics capabilities from data collection to actionable insights

My Analytics Process

1

Data Collection

Gathering data from multiple sources including databases, APIs, and spreadsheets

2

Data Processing

Cleaning, transforming, and preparing data for analysis using SQL & Python

3

Analysis & Modeling

Applying statistical methods, segmentation, and correlation analysis

4

Visualization

Creating interactive dashboards and reports for stakeholder insights

5

Actionable Insights

Delivering data-driven recommendations for business decisions

Analytics Capabilities

Reporting & Dashboards

KPI Dashboards
Executive Reports
Performance Scorecards
Real-time Metrics

Statistical Analysis

Trend Analysis
Correlation Analysis
Segmentation
Accuracy Analysis

Process Automation

Report Automation
Workflow Optimization
Data Pipelines
Scheduled Jobs

Business Intelligence

Compensation Analytics
Sales Performance
Operational Insights
Forecasting

Key Impact Areas

Workflow Automation

Streamlined reporting processes

Team Enablement

Empowered 10,000+ users

System Optimization

Enhanced data pipelines

Decision Support

Leadership visibility improved

Portfolio

Featured Projects

High-impact data solutions that delivered measurable business value

$10K+ savings/quarter

Automated Reporting System

Built SQL-driven pipelines reducing manual work by 80%, improving TAT by 40%, and saving $10K per quarter

SQLVBAExcel
90% effort reduction

PHP/MySQL Web Application

Developed validation application reducing manual effort by ~90% at TCS, saving $500 per cycle

PHPMySQLBackend Logic
Government Project

Govt. of Odisha Chilika App

Co-developed application for Govt. of Odisha for research data collection in Chilika region

Mobile AppDatabaseResearch
10,000+ users served

IC Reports Distribution System

Built automation for distributing personalized IC reports to 10,000+ users

SQLAutomationVBA
$40K+
Annual Cost Savings
10,000+
Users Impacted
80%
Efficiency Gain
Recognition

Awards & Education

Celebrating achievements and continuous learning journey

Awards & Recognition

RIGHT Brigade Awards

Axtria

Bravo Awards

Axtria

National Award - Opendatahack 2018

National

Finals

Cognizance Robotics Competition

IIT Roorkee

Runner-up

SmartBitHack 2018

Hackathon

Runner-up

Achiever of the Year 2018

Academic

Winner
5/5 CSAT Score
Consistent client satisfaction

Education

2020

B.Tech: Computer Science Engineering

Gandhi Institute For Technology

Bhubaneswar

2016

Intermediate

DR. ANK DAV Public School

Rourkela, India

Languages

English Hindi Odia

What People Say

"Niranjan's automation solutions transformed our reporting workflow. His SQL expertise and attention to detail consistently deliver exceptional results."

S
Nisha Jain
Program Manager, Axtria

"An exceptional data analyst who combines technical skills with strong business acumen. His dashboards have become essential for our decision-making."

R
Bhavana Deshmukh
Team Lead, Axtria

"Niranjan's ability to identify optimization opportunities and implement automated solutions has saved our team countless hours of manual work."

P
Jishnu Nambiar
Manager, TCS
Get in Touch

Let's Connect

Have a data challenge or opportunity? I'd love to hear from you.

Contact Information

Ready to transform data into insights? Let's discuss how we can work together.

Send a Message