About Me

I am always excited about new technological advancements and believe that it will play a major role in shaping our future. I have diverse experience of working in different sectors like Financial, Healthcare and Technology with different hats. I worked on projects ranging from building ETL pipelines, testing web-based products to migrating data to cloud. Apart from work, I am a foodie and like being amidst nature either by travelling to new places, camping or hiking.



Skills

  • Problem Solver
  • SQL
  • Python
  • Automation
  • Data Visualization
  • Communication

Education

Robert H. Smith School of Business

University of Maryland, College Park

Master in Information Systems • December 2018• Grade: 3.93

The MSIS program at UMD covers data science, IT and analytical skills to become an effective liaison between data analysts and company leadership.

1st prize winner of Smith MBA Data Analytics Case Competition'17 with Praneesh Khanna and Namwoo Park.
● Build a data model to predict the winner of FIFA 2018 world cup using predictive modeling.
● Designed the visualizations of FIFA teams using Tableau.
● Representing Smith School of Business at MIT Solan Sports Analytics Conference

Vice-President (Finance) of Information System Association.
● Plan and compose the club’s budgets

Manipal Institute of Technology

Manipal University

Bachelors in Engineering • May 2015• Grade: 7.8/10

- Presented two technical papers on “corrosion in Reinforced Concrete” and “Ground improvement technique” at MIT Manipal during department level technical fest NIRMAAN 2014.
- Secured 1st position in “Swades” event of TechTatva 2013 (National level technical fest of MIT Manipal) and “Photoquest” annual event of I.E. Civil Manipal community.
- Active member of VSO Manipal. Organised and participated in various social activities such as cleanliness drive, blood donation camps etc.

Work

Phreesia, Wilmington, Delaware

Nov 2022 - Present

Data Engineer, Data Science

● Database Administrator: Worked on writing and optimizing MS SQL queries, SSIS, stored procedures, functions, and triggers for ranging data science requirements of efficient data retrieval, manipulation, and storage.
● Enterprise Data Solution: Worked on developing enterprise data pipelines utilizing DBT, Airflow, and Snowflake, serving as a single source of truth for various enterprise requirements resulting in 25% operational cost reduction.
● Cloud Migration: Migrated Enterprise analytics apps and developed Spark SQL processes in cloud to achieve resilient scalability of 50% YoY growth and accomplished AWS Developer certification along the journey.
● Cloud Automation: Collaborated with Data Scientists and Analysts to develop Infrastructure as code scripts using Terraform for business-critical cloud infrastructure to ensure consistency, fault tolerance and cost optimization.

MicroStrategy, Tysons Corner, Virginia

Feb 2019 - Nov 2022

Senior Software Test Engineer, Web & Security

● Data Visualization: Created enterprise-wide dashboard from Workday and MicroStrategy data, highlighting KPIs like active users, sessions, clients, error rate, team participation which improved blitz user engagement by 30%.
● Data Management: Transform data by developing mapping in Informatica and using SQL for loading the data into multiple IMDB cubes for data warehousing-OLAP.
● Product Testing: Analyze incoming web and security defects & new features, plan the testing scope, code review, create, and execute end-to-end test cases for BI products under Agile Scrum methodology.
● Automation: Developed Python scripts to automate regression test cases to CI pipeline helping the team to reach target automated test cases from 35% to 55% thereby reducing the regression period by 1 week.
● Customer Success: Supported 60+ worldwide customers in swiftly resolving MicroStrategy web, security hardening and identity access management issues resulting in securing 10 million dollars plus deals.

Northwestern Mutual, Milwaukee, Wisconsin

May 2018 - Aug 2018

Data Analyst Intern, Client Experience

● Operational Efficiency: Developed SQL queries to merge 65k+ duplicate data in Microsoft Dynamics CRM database to improve the system efficiency by 35% and enhancing the sales team experience.
● Hackathon: Worked on setting up a Zendesk live chat support process which reduced the resolution time by 25%.
● Certification: Actively involved in on-premises data migration to cloud and completed Azure Cloud certification.

Tata Consultancy Services, Bangalore, India

Jul 2015 - Jul 2017

Data Engineer (Client – Deutsche Bank)

● Team Management: Led a team of eight members in developing ETL (Extract, Transform & Load) jobs for data related to real-time transactions, employee salary and trades to business applications warehouse.
● Process Improvement: Developed efficient SQL codes to avoid Informatica Look-ups that minimized time by 30%.
● Process Innovation: Slashed project costs 20% by automating the job failure alerts and developing KPIs for easy monitoring, while ensuring the continuation and enhancements of services.
● Platform Administrator: Handled multiple outages on the Unix server environment along with providing root cause analysis as specified in SLA.

Download Resume

Client Testimonials

  • Sumit has always been an insightful person, filled with out of the box ideas to implement. I had the pleasure of working alongside him on one of the more challenging projects in TCS that involved designing and developing complex ETL jobs and exploring ways to achieve the highest efficiency. I consider Sumit as an individual who is able to dig in, mobilize resources and drive the results you need. He is the guy to go to for immediate results. His analyzing and presentation skills make him an excellent individual contributor to the team, but he is also an equally capable leader.

    Souradeep Bhowmik

  • "Ridiculously efficient" is the phrase that comes to my mind when I think about Sumit.I had the pleasure of working with Sumit for two years at the Tata Consultancy Services, collaborating on a critical project. Sumit's ability to juggle multiple issues at a time, was unlike any I’ve seen before and made a dramatic difference in the productivity level of our team.Even though his looks were serious, he made sure our Monday morning meetings were never without smile and of course coffee,a great motivator. As a team member Summit earns my highest recommendation.

    Karthick KS