Back to Developers
Pranjal Awasthi

Pranjal Awasthi

Data Analyst

Noida 6+ yrs exp 90 ยท Outstanding

About

Drive impactful data solutions and insightful analytics as a Data Analyst, leveraging experience to enhance decision-making processes in the financial and product sectors.

Skills & Expertise (16)

SQL Advanced
8.5/10
8
Years Exp
Python Advanced
8.0/10
8
Years Exp
Tableau Advanced
8.0/10
8
Years Exp
Power BI Advanced
8.0/10
8
Years Exp
ETL Pipelines Advanced
8.0/10
8
Years Exp
Data Warehousing Advanced
8.0/10
8
Years Exp
Pandas Advanced
7.5/10
5
Years Exp
Informatica Advanced
7.5/10
5
Years Exp
NumPy Advanced
7.0/10
5
Years Exp
Excel Advanced
7.0/10
8
Years Exp
Snowflake Intermediate
6.5/10
3
Years Exp
SAP BO Intermediate
6.0/10
4
Years Exp
Jira Intermediate
5.5/10
4
Years Exp
Confluence Intermediate
5.5/10
4
Years Exp
Databricks Intermediate
5.0/10
2
Years Exp
Oracle

Work Experience

Data Analyst

Spring Financial

Aug 2024 - Jun 2026

Developed and optimized complex SQL queries for financial reporting, validation, and large-scale data analysis, enabling data-driven decision-making across enterprise environments. Designed and maintained ETL workflows for seamless integration of financial data across multiple systems using data warehousing principles, streamlining reporting processes and improving data flow efficiency. Built interactive dashboards and KPI reports using Tableau and Power BI, improving reporting efficiency by 30% while delivering scalable BI solutions for cross-functional stakeholders. Performed data validation and reconciliation using SQL and Python to ensure accuracy and consistency, while collaborating with stakeholders for requirements gathering and supporting automation initiatives that improved reporting timelines and reduced manual effort. Developed an AI-ready semantic layer by enriching enterprise metadata, business glossary, and semantic models, enabling Claude-powered LLM analytics through accurate business context and metadata-driven insights.

Management Trainee

Sekhmet Pharmaventures

Jun 2024 - Aug 2024

Performed detailed data analysis using Python (Pandas, NumPy) alongside process optimization initiatives, reducing operational turnaround time by 35% while improving overall efficiency across critical business workflows. Created Power BI dashboards and automated reports to support business insights and visualization needs, effectively bridging the gap between raw operational data and strategic decision-making requirements. Automated reporting workflows using scripting and scheduling tools, improving reporting accuracy and operational efficiency while reducing manual effort and errors. Assisted in tracking key operational KPIs and preparing analytical reports for management review, enabling data-driven decision-making and enhanced visibility.

Data Analyst

Infosys

Jul 2018 - Aug 2022

Developed dynamic BI dashboards leveraging Tableau, Power BI, and SAP BO for comprehensive reporting and KPI monitoring activities, effectively delivering scalable, high-performance BI solutions tailored for executive stakeholders. Implemented highly robust ETL workflows utilizing Informatica and data warehousing principles, improving data reliability, operational efficiency, and reporting quality by 25%, while delivering actionable insights through Spotfire visualizations and advanced Excel modeling for strategic decision-making. Implemented Informatica workflows to streamline data transformation processes between heterogeneous databases and reporting systems, achieving 95% system uptime through robust ETL operations and proactive error handling. Leveraged expertise in SAP BO, FreeHand SQL, and Oracle to design and deliver complex reporting solutions, ensuring the accuracy and timeliness of insights that supported critical decision-making across departments. Championed Infoburst automation initiatives to optimize report scheduling and distribution, reducing manual effort and turnaround time, while enabling stakeholders to consume reports efficiently and improving accessibility and operational transparency. Collaborated effectively with a diverse cross-functional team of analysts, developers, and business users to align reporting solutions with organizational goals, fostering a culture of knowledge sharing and problem-solving to accelerate project delivery. Developed and maintained TDV Studio integrations to facilitate seamless communication between SAP BO and SQL environments, enhancing data flow efficiency and reducing latency to ensure consistent and reliable reporting pipelines. Utilized Spotfire data visualization tools to create interactive dashboards and insightful visualizations for internal applications, empowering business leaders with actionable intelligence to improve performance monitoring and trend analysis.

Education

B.Tech. (Computer Science Engineering) - Galgotias University

2014 - 2018 ยท Afghanistan

MBA (Business Analytics) - BML Munjal University

- ยท Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 15/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 90/100

Profile Overview

Member sinceJul 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation