Headline

BI & Data Analyst @ Saint-Gobain | Snowflake | SQL | MicroStrategy

About

As a BI & Data Analyst at Saint-Gobain (Fortune Global 500), I specialize in MicroStrategy report development, multi-system data reconciliation, and validating complex backend business logic across Sales, Finance, Logistics, Marketing, Pricing, and Commerce domains. My day-to-day involves owning morning incident management across the reporting pipeline, investigating and resolving failures within the MicroStrategy layer - tracing data mismatches back to source using SQL and Snowflake, performing deep-dive root cause analysis, and eliminating reporting data mismatches through end-to-end data quality triage. Beyond daily monitoring, I've resolved 200+ change and incident tickets raised by business users, maintaining an 85%+ first-level resolution rate. Some of the work I'm most proud of includes migrating 20+ legacy SAP HANA/Sybase IQ reports into a Snowflake-backed MicroStrategy environment with zero data variance, managing the go-live migration of 1,000+ report subscriptions, and delivering a customer churn analysis across 885,000+ client records - covering Churn Rate, Customer Retention Rate (CRR), Customer Lifetime Value (CLV), Customer Acquisition Cost (CAC), and B2C/B2B purchasing trends. I thrive in cross-functional environments, collaborating with multinational teams and bridging the gap between complex cloud architecture and executive-level business strategy. Core stack: MicroStrategy · SQL · Snowflake · SAP HANA · Advanced Excel

Location

Mumbai

Work experience

Software Engineer - BI Reporting & Data Analytics at Saint-Gobain International IT Delivery Centre, Jan 2021 - Present · 5 yrs 6 mos, Mumbai, •Developed MicroStrategy data visualization solutions surfacing business-critical metrics for executive and cross-functional leadership - including a dynamic cockpit tracking multi-regional traffic, YoY revenue variations, and hourly volumes (reducing report layout clutter by 40%); prepared dashboards and reports to support decision-making across commercial and business stakeholders. • Developed various Auto prompts to give end users a choice of different filtering criteria each time they run the report. • Governed morning pipeline incidents across a 5-layer Snowflake pipeline (STG/DTS/DWH/DTM/RPT) tied to Azure Data Lake Storage, maintaining an 85%+ first-level resolution rate. • Resolved 200+ high-priority functional Jira tickets, performing deep-dive lineage and code profiling inside Snowflake and SAP HANA using advanced dbt models and complex SQL. • Successfully migrated 20+ legacy reports from SAP HANA/Sybase IQ into the Snowflake-backed OneData MicroStrategy project, tracking metadata via detailed mapping sheets to eliminate data variance. • Streamlined end-to-end go-live migration of 1,000+ subscriptions across 2 releases, reducing setup effort by 70–80% using Excel-driven bulk Command Manager scripts. • Led comprehensive weekly production MEP releases via Object Manager, executing "before and after" regression testing cycles via Integrity Manager to isolate post-migration anomalies • Collaborating with French-speaking stakeholders, business users and project teams in a multinational environment to support reporting and analytical requirements.

Software Engineer Intern at Saint-Gobain International IT Delivery Centre, Feb 2020 - Aug 2020 · 7 mos, Mumbai, Maharashtra, India, *Worked in Project HR-BOT. Developed a CHATBOT in Botpress integrated with PostgreSQL to automate HR query handling. *Worked in Project Asset Management. Created Forms for Managing & Tracking Assets using Asp.net & c# and html, bootstrap and CSS for Styling UI and MySql for Database.

Education

Bachelor of Computer Applications, Computer Science, Tilak Maharashtra Vidyapeeth, Pune