Soham Moralwar

About Soham Moralwar

Data has always been at the core of my professional journey, driving my passion for uncovering insights, optimizing processes, and enabling impactful business decisions. With a Master’s in Business Analytics from The University of Texas at Dallas and hands-on experience across data engineering and analytics roles, I bring both technical expertise and strategic insight to the table.At my current role at Integrity Marketing Group, I engineered ETL workflows using Nexla and Python, seamlessly migrating over 1 billion insurance records to Snowflake. By optimizing data pipelines for 26 million policies, I improved accuracy and reduced processing time by 45%. Collaborating across teams, I established SDLC frameworks, trained 12+ team members, and engineered frameworks to ensure accurate ingestion of data. I worked in enhancing Snowflake schema designs to boost data retrieval efficiency. Beyond technical work, I established SDLC frameworks, trained 12+ team members, and streamlined monthly data load and reconciliation processes for audits.At my previous role at Wish, I used Tableau and Apache Superset to create dynamic dashboards and analyze critical KPIs, which resulted in a 25% boost in click-through rates. I oversaw a client database with 15 million entries, optimizing advertising strategies and using cutting-edge visualization tools to deliver actionable insights. I was able to become an expert in end-to-end BI procedures because to my early experience at Opine Group. I created a business data warehouse for SMEs, used SSIS to automate ETL processes, and used SSRS to generate drill-down dashboards. These programs provided data-driven insights and practical suggestions to empower stakeholders.In addition to my professional roles, my academic projects, including the analysis of Instacart and Airbnb datasets, showcase my ability to generate insights from complex datasets using SQL, Tableau, and MongoDB. With a skill set spanning SQL, Python, Snowflake, Tableau, and Nexla, I excel at bridging the gap between raw data and strategic business outcomes. Whether it\'s resolving intricate data issues, identifying trends across 120+ business units, or mentoring teams to adopt best practices, I am committed to driving success through data.Let’s connect to explore how I can help your organization turn data into a competitive advantage!

Experience

1. Data Engineer

   Integrity

   Oct 2023 — Present · Dallas, TX, US

   Developed ETL workflows in Nexla for migrating insurance data of more than 1 billion records from legacy systems to Snowflake Managed acquisition, ingestion, and reconciliation of revenue and deposit statements from 100+ healthcare carriers Built data migration pipelines for over 26 million policies enhancing overall system efficiency Established SDLC for data migration (Development, Staging, Refine), and provided training to more than 12 new team members Automated migration processes by improving accuracy and reducing data processing time by 45% using python scripts Resolved 100+ Jira tickets by analyzing root causes and implementing SQL solutions achieving a 100% resolution rate Created and optimized large-scale SQL stored procedures for data transportation across defined SDLC stages Engineered data framework and logic for ingesting manual adjustments and deposits into the system Identified trends and insights across data from 120+ business units for providing valuable recommendations Improved Snowflake schema design and query performance for boosting data retrieval efficiency Streamlined monthly data load and reconciliation processes to improve production operations for audit purposes

Education

• Vishwakarma Institute Of Technology

  Bachelor's degree, Computer Science

  2017 — 2021

• The University of Texas at Dallas

  Master of Science - MS, Business Analytics