Ram Tyagi

Business Development Executive

Noida, Uttar Pradesh, India4 yrs experience

Most Likely To Switch

Key Highlights

Reduced reporting cycle time by 60% through model redesign.
Built sales dashboard used by over 50 users.
Achieved 12% increase in forecast accuracy.

Stackforce AI infers this person is a Business Intelligence Developer specializing in Retail and E-commerce analytics.

Contact

Skills

Core Skills

Business IntelligenceData VisualizationReport Automation

Other Skills

Analytical SkillsAnalytical ThinkingBig Data AnalyticsBusiness ReportingCommunicationDAXDashboard DevelopmentData AnalysisData AnalyticsData CleaningData EngineeringData MiningData ModelingData ScienceData Storytelling

About

Power BI Developer & Data Analyst with 4+ years turning messy data into clear decisions for sales, operations, and finance. I design dimensional models (Star/Snowflake), build executive dashboards, and automate reporting for retail & e-commerce (Shopify, GA4)—driving forecast accuracy, inventory health, and revenue growth. I build interactive dashboards, automate reporting, and tune SQL so teams get trusted insights—fast. Core stack: Power BI (DAX, Power Query M, Service), Fabric/Lakehouse, T-SQL (window functions), Python (pandas), Excel/Power Pivot, Tabular Editor, Power Automate Data modeling: Star/Snowflake, Kimball, SCD; ETL/ELT, semantic models, KPI design, data quality Cloud/DB: SQL Server, MySQL, PostgreSQL; Azure Data Factory/Synapse; Databricks/Snowflake exposure Results: Cut reporting cycle time 60% via Power BI model redesign (RLS, incremental refresh) Built sales dashboard used by 50+ users; forecast accuracy up 12% Optimized SQL views (CTEs + indexing): 15 min → 90 sec Domains: Retail & ecommerce (Shopify), sales analytics, inventory/OTIF, financial reporting, churn/retention. Currently deepening Python for advanced analytics to deliver end-to-end BI solutions. Open to roles where technical rigor meets business impact.

Experience

Maxima apparel

Senior Associate Analyst

Aug 2023 – Present · 2 yrs 7 mos · Gurugram, Haryana, India · On-site

Designed and deployed 30+ interactive Power BI dashboards to monitor sales, inventory, and financial performance, enhancing decision-making speed and reducing manual reporting efforts by 50%.
Automated reporting workflows using Power BI, VBA, and Selenium, saving 25+ hours per month in report generation and status tracking.
Optimized DAX and Power Query scripts to improve dashboard performance, achieving a 60% faster report refresh time.
Processed and analyzed 50M+ rows of data monthly, delivering actionable insights to business stakeholders, resulting in a 10% increase in operational efficiency.
Led cross-functional teams to implement end-to-end BI solutions, improving decision-making by integrating sales, inventory, and financial data.

Power BIDAXPower QueryVBASeleniumSQL+3

Byju's

Bussiness Associate || Power BI Developer

Jul 2021 – Dec 2022 · 1 yr 5 mos · Noida, Uttar Pradesh, India · On-site

Created and maintained interactive dashboards for operational tracking, improving real-time visibility into key business metrics, which reduced decision-making time by 20%.
Performed data analysis and cleaning to prepare datasets for reporting, improving report accuracy by 15%.
Developed custom Excel-based reports to track performance metrics, reducing manual labor by 10 hours/week.
Conducted in-depth analysis to uncover cost-saving opportunities.
Key Projects:
▪ Sales Reports
▪ Booking Tracking Report

Power BIData AnalysisExcelReportingData CleaningBusiness Intelligence+1