profile-images

Stefan P.

AI and Data Science , Information Technology , Marketing , Operations

call   (214) GO-RELAY / (214) 467-3529

email   Careers@RelayHumanCloud.com

home   Ahmedabad, India


SKILLS

  • AI Proficient
  • AWS
  • PostgreSQL
  • Power BI
  • SQL
  • Python
  • Advanced Excel
  • ETL Pipeline Development
  • Data Visualization & Dashboard Development
  • Data Automation & API Integration
  • Snowflake
  • Power Automate & SharePoint Integration
  • Data Modeling (Star Schema)
  • Data Quality Assurance
  • Query Optimization & Stored Procedures

EDUCATION

M.Sc in Data Science

Symbiosis International University (2025)

Bachelor of Commerce

Ran Vijay Smarak Mahavidyalaya, BBMKU (2019)


ASSESSMENTS

CORE SKILL English Aptitude DataAnalysis 0 100

PERSONALITY

ENTJ-A

Extraverted Introverted Intuitive Observant Thinking Feeling Judging Prospecting

People with ENTJ as a personality type are natural leaders. They are charismatic and confident, driving teams toward common goals with strategic thinking and discipline.

PROFESSIONAL SUMMARY

Results-driven Data Analyst and Power BI Developer with 3+ years of experience in data engineering, ETL pipeline development, and business intelligence solutions. Proven ability to improve data quality, operational efficiency, and reporting automation through scalable data architectures and advanced analytics. Strong expertise in Python, SQL, Power BI, ETL pipelines, and data visualization, with experience translating complex business requirements into actionable insights that support strategic decision-making. Experienced in designing automated reporting frameworks and real-time data pipelines to support enterprise-level analytics and performance tracking. Demonstrated ability to build interactive dashboards and KPI monitoring systems that enable stakeholders to make faster and more informed business decisions. Adept at data modeling, trend analysis, and forecasting to identify performance gaps and drive continuous improvement.

PROFESSIONAL EXPERIENCE

Data Analyst | Power BI Developer

Dhwani Rural Information System | India | Aug 2023 – Mar 2026

  • Architected and deployed end-to-end ETL pipelines integrating SharePoint Excel data with PostgreSQL using Power Automate, processing 500+ records daily with 99.5% accuracy.
  • Automated scheduled data extraction workflows, reducing manual intervention by 80% and ensuring consistent real-time data availability.
  • Implemented database triggers, validation rules, and data quality checks in PostgreSQL, improving overall data integrity by 35%.
  • Developed 20+ interactive Power BI dashboards with dynamic filtering, drill-down capabilities, and Row Level Security (RLS) to monitor KPIs across multiple initiatives.
  • Configured automated report refresh schedules using Power BI Service Gateways to ensure timely data availability.
  • Collaborated with cross-functional program teams to gather reporting requirements and convert business needs into effective BI solutions.
  • Streamlined data workflows, reducing manual reporting effort by 70% and improving organizational data hygiene standards.
  • Integrated SharePoint, Power Automate, PostgreSQL, and Power BI ecosystem to enable seamless data flow across reporting systems.
  • Designed and delivered weekly performance dashboards to senior stakeholders highlighting measurable program outcomes and ROI.
  • Developed complex SQL queries, stored procedures, triggers, and materialized views to support efficient database operations and reporting.
  • Supported project delivery and performance tracking by contributing to data-driven operational insights.
  • Partnered with project owners to identify automation opportunities, reducing manual reporting effort by 65% using Python and API integrations.
  • Improved reporting accuracy by 95% through automated calculations and data validation processes.
  • Provided strategic insights to stakeholders by identifying performance gaps and optimization opportunities, contributing to a 20% improvement in project outcomes.
  • Conducted trend analysis and forecasting using historical data patterns to support planning and resource allocation decisions.
  • Participated in requirements gathering and data mapping sessions to ensure alignment between business expectations and technical implementation.

PROJECTS

Real-Time Cryptocurrency Data Tracker

  • Designed and implemented a real-time cryptocurrency monitoring system using Python and CoinGecko API to track 100+ cryptocurrencies and process 250+ daily data points.
  • Built a complete ETL pipeline for data extraction, transformation, and analysis ensuring reliable and consistent data processing.
  • Automated daily email alerts delivering top buy/sell recommendations based on market indicators and technical analysis.
  • Developed automation workflows using Python scheduling libraries and email notification systems to deliver timely market insights.

Web Scraping using Python – ETL

  • Developed a data analysis solution using BigBasket sales dataset (50,000+ transactions) to generate actionable business insights.
  • Built an automated ETL pipeline integrating API data extraction, Python preprocessing, and PostgreSQL data storage.
  • Performed advanced SQL analysis to answer 15+ business questions including revenue trends, product performance, and customer segmentation.
  • Applied data cleaning and transformation techniques to handle missing values, outliers, and inconsistencies to ensure analytical accuracy.
  • Strengthened expertise in complex SQL queries including CTEs, window functions, and subqueries for large dataset analysis.