S

SHRESHTHA JHA

About

Detail

Texas, United States

Contact SHRESHTHA regarding: 
work
Full-time jobs

Timeline


work
Job
school
Education

Résumé


Jobs verified_user 0% verified
  • Evolent
    Business Intelligence Engineer
    Evolent
    Jul 2021 - Current (5 years 1 month)
    • Owned and managed delivery of key BI products by spearheading requirements gathering, product roadmap, design & development, UAT, and Go- Live phases in Agile environment • Responsible for developing and maintaining data warehousing and dataflow (ETL) solutions using SSMS, SSIS, Azure Synapse,T-SQL and Power BI • Led QA initiatives for root cause analysis to mitigate data gaps and inconsistencies, thereby reducing data governance and reconciliation errors by 25% • Collaborated cross-functionally with financial, product, and clinical teams to automate over 30 BI reports, resulting in accelerated revenue (5M), savings (10M), and a 40% reduction in manual intervention. • Facilitated scrum ceremonies and product meetings to ensure seamle
  • H
    BI Intern
    Henry Company,
    Jan 2021 - May 2021 (5 months)
    • Developed and maintained database objects/models to support analytical and reporting solutions using SSMS, SSIS, SQL and Python • Spearheaded RMF analysis to identify potential customer churn, aiding in devising retention strategies that reduced churn by 15%. • Engineered a clustering algorithm to analyze purchasing patterns and spending behaviors, enabling targeted marketing strategies that increased rev by 20% • Performed in depth product-level analysis on 30M+ records to devise executive dashboards to present findings to C-level executives • Automated inventory tracking and operational reporting which identified trends/outliers leading to 1.5M$ saving/quarter
  • Verizon
    Data Eng Intern
    Verizon
    Jan 2020 - Apr 2020 (4 months)
    • Prototyped a Network Maintenance Scheduling Model to study the impact of weather on 4G KPI' metrics by analyzing 45M+ records of KPI & Weather data (JSON) • Developed a robust SparkML workflow with Random Forest regression leveraging HDFS, Hive, PySpark and SparkSQL • The model predictions significantly minimize the unnecessary technician dispatch instances by 2X times leading to savings of ~20M+USD/annually
  • Infosys
    BI Analyst
    Infosys
    Jul 2018 - Mar 2019 (9 months)
    • Conceptualizing and implementing scalable data warehousing and business intelligence solutions using Microsoft BI Stack • Automated BI reporting frameworks by devising 20+ self-service data intensive dashboards which reduced manual work by 50%
Education verified_user 0% verified
  • The University of Texas
    M.S.
    The University of Texas
    Aug 2019 - May 2021 (1 year 10 months)
  • V
    B.Tech.
    VIT University
    Aug 2014 - May 2018 (3 years 10 months)
  • T
    Tableau Desktop Specialist, Microsoft Power BI Specialist, Certified Scrum Product Owner
Projects (professional or personal) verified_user 0% verified
  • D
    Database Modelling for the Spatial US Wildlife Fire
  • S
    Stock Market Analysis
  • P
    Personal Expense Tracker
  • C
    Campaign Marketing Analysis
    • Led a team of 4 members to accomplish in-depth Digital and Web analysis using Google AdWords, Adv Excel, SQL and Tableau • Devised 10+ dashboards to track key Campaign level KPI's which boosted web traffic by 25% and reduced marketing cost by 4.5% ◦ Automated data ingestion from multiple Stock API data sources using AWS Lambda and exported it to S3 bucket with boto3 ◦ Formulated database modelling and end to end ETL pipelines from AWS to SSMS for conducting in-depth financial analytics • Created a visually insightful report which tracks earnings, expenses, savings using SSIS, SSMS, SQL and Power BI • The report identified key spending behavior and patterns which reducing monthly expense by 20% and boosted savings by 40% • Migrate
  • A
    Amazon Reviews Analysis
    • Implemented in-depth big data analytics on 200M+ CX records leveraging AWS Suite (S3, Glue,Lambda,Athena), PySpark, Spark SQL and built 10+ visually impactful reports using Tableau
This is a community-created genome.