Sneha Arora Email & Phone Number

Waltham, Ma, Us

Boston, Ma, Us

• Led a team responsible for solving data & analytics problems and automating processes using Tableau, Power BI, Sigma, DBT, Snowflake, and AWS• Served as product owner for the scrum team, overseeing the end-to-end development of a data lake for reporting purposes• Designed, implemented, and supported data analytics initiatives across Private Equity, Real Estate, and Private Markets Business Units saving 100% of business stakeholders time • Collaborated with partners and business users to design and build business intelligence dashboards, managing project initiation, delivery, and end-to-end management with prompt support to business stakeholders• Improved ETL process performance, reducing job execution time from 1 hour to 15 minutes by materializing dbt models as incremental and creating exposures• Created Real Estate and Private Equity data lake from scratch, setting up the DBT project and generating multiple reports through optimized data models leveraging star schema• Implemented technology solutions to define and track key performance indicators for data quality and governance, automating reporting processes• Conceptualized and owned data architecture for multiple large-scale projects, evaluating design and operational cost-benefit tradeoffs• Enhanced data governance using Atlan for better lineage and data cataloging, aiding business stakeholders with terminology definitions on dashboards• Presented reports to business users, providing training sessions and documentation for using BI platforms like Sigma, Tableau, and Power BI• Solved complex data integration problems, utilizing optimal ETL patterns, frameworks, and query techniques for both structured and unstructured data sources

Denver, Co, Us

• Led the migration of the production data pipelines from Databricks to Snowflake and Postgres and used Airflow for orchestration• Established project management protocols in centralized repository and data validation standards to maintain quality agile working environment• Migrated all the client reports from Databricks platform to Snowflake using SnowSQL• Instituted GIT branching workflow to establish standardized process for version control• Collaborated with multiple cross functional teams (product management, data engineering, and customer success teams) for product and process improvement

Denver, Co, Us

• Worked on the ETL process which comprised of collecting, cleaning, wrangling, validating, and tranforming large client healthcare population data using Python, SAS, Scala, and Excel and loading into Welltok's Cafewell product• Automated the SAS ETL processes by programatically checking new raw data on SFTP and dynamically trigger the pipelines• Migrated existing client ETL processes from SAS to Spark (Scala, PySpark, and Spark SQL) on Databricks• Designed and created medical data warehouse from scratch to facilitate end to end statistical and predictive modelling for client recommendations• Used PySpark to develop and deploy Logistic regression models utilizing historical medical data for personalization and client recommendations for Cafewell product• Conducted trainings and prepared process improvement documentation for discussions with internal and external data customer teams about health pharmacy claims data and healthcare analytics (ICD Codes)• Implemented various QA checks as a part of SLA process improvement in SAS and Databricks platform to ensure client reports are delivered on SFTP successfully • Automated report generation, using Scala & Spark SQL, for business users by templatizing all the reports which reduced the turn around time and increased the efficiency by 90%• Performed data investigation by Scala and SQL codes on data stored in Cassandra/ S3• Familiar with healthcare enrollment, medical/ pharmacy claims, and activity/ biometrics screening data and Implemented both Medicare and commercial clients• Implement clients in metadata driven system – a universal code to intake metadata stored in excels

Waltham, Ma, Us

• Part of Data Lab to carry out Machine Learning and Data Science/ Data Analysis related projects using relevant packages in R and Python.• Assisting faculty members from the Mathematical Science department on external well-fundedresearch projects.• Preparing Machine Learning lectures and tutorials on the Databricks platform.• Mentoring and helping students in programming (R, Python) and/or Databricks platform questions.

Mumbai, Mumbai, In

• Secured new business of 200% in first 6 months by analyzing banking bidder’s conferences and established partnerships• Shaped the new learning system by providing client’s opinion of the product to provide industry feedback.• Text Mining to read the sentiments collected through social media, interviews and surveys.

Mumbai , Maharashtra, In

• Carried out in-depth research to identify existing & new target markets for cross selling of products generating $1M in sales• Built models between revenues and features influencing sales, leading to 100% retention of clients

Master Of Science - Ms, Analytics - Data Science

Master Of Business Administration (M.B.A.), Finance, General

Bachelor Of Technology (Btech), Telecommunications Engineering