Siddharth Yadav Email & Phone Number

Orange, California, United States

Irvine, California, United States

• Redesigned North American workflows for various mandate types and asset classes, focusing on AUM and net cashflows, utilizing Alteryx to enhance process efficiency and ensure consistency in financial reporting across regions. • Managed BAU reporting for private clients’ AUMs and cashflows, utilizing Alteryx and SAP BW to deliver precise, real-time insights tailored to client needs.

Chicago, Illinois, United States

• Engineered predictive models (XGBoost, Logistic Regression) utilizing Python for analysis on the Chronic Patient explore on demand dataset, achieving 72% accuracy in disease progression predictions.• Implemented an OOP-Python package with Scikit-learn and Statsmodels, incorporating statistical and ML methods to create reusable functions, achieving disease comorbidity 95% prediction accuracy.• Built 10+ disease (ICD-10) cohorts (e.g., cancer, mental disorders) using SQL for querying and data modeling (ETL), turning underutilized data into actionable insights, aiding drug R&D and improving supply chain timelines.• Applied AI techniques to extract insights on disease progression models from 4 research papers, creating a data strategy to develop predictive models from uncleaned patient data, enhancing data-driven decision-making in healthcare.

Remote

• Designed Power BI self-service FP&A dashboards that analyzed budget allocation across business units, empowering stakeholders to understand the division of a $374.7M budget and make informed financial decisions.• Developed what-if analysis capabilities within Power BI dashboards, enabling non-technical stakeholders to explore various budget scenarios and enhancing forecasting efficiency by 30%.• Integrated row-level security (RLS) in Power BI dashboards for manager-level access and above, ensuring data security and compliance and reducing unauthorized access incidents by 42%.• Migrated SSMS data to Azure Synapse for secure, cloud-based storage solutions, boosting Power BI dashboard refresh rates and DAX Studio performance by 25% through optimized data processing.• Collaborated with stakeholders to document a BRD that detailed KPIs, DAX measures, and Power Query techniques, ensuring alignment with business needs and enhancing team efficiency by 20% in an Agile environment.

• Created 5 interactive Power BI dashboards with custom visuals for financial KPIs, incorporating advanced filters, drilldowns, drill-through, and Q&A improving data-driven budget vs. actual analysis by 35%.• Merged data from multiple sources using Power BI query modeling to create integrated datasets, improving visualization accuracy by 30% and supporting comprehensive data analysis for better-informed decision-making.• Cleaned and normalized data in SSMS, building tables into optimized star schemas, procedures, and databases, increasing data quality and consistency by 40% and improving downstream analytics.• Streamlined data pipelines for Power BI across ad hoc, test, and production environments, adhering to data limits, improving semantic models, and reducing redundancy by 20%.• Automated MBR by developing 21 SBU paginated reports using PBI Report Builder, distributed via Power Automate cloud flows, achieving 100% automation and streamlining the SharePoint file storage.

Manesar, Haryana, India

Analyzed 2 bike assembly lines and proposed time-effective assembly alternatives using Lean Six Sigma, leading to a 13% faster vehicle assembly.

Delhi, India

Developed a comprehensive range selling strategy for TATA Tea in the retail market using ERP systems, Excel; achieved a 15% increase in market penetration and sales for Q4 2018.

Master Of Science - Ms, Business Analytics

Bachelor Of Technology - Btech, Production & Industrial Engineering

Pcm