About Me

Currently, I am a first year MSIS student at Robert H. Smith School of Business. Prior to this, I have worked at Tata Consultancy Services for 2 years. My major responsibilities were to manage the database of Deutsche Bank by operating various business intelligence tools. I really enjoyed my role and wanted to deepen my understanding in data analytics field. So, I joined MSIS program which provides a unique blend of technical and business skills.

Contact Details

Sumit Bansal
8125 48th Ave APT#321
College Park, MD 20470 US

(240)918-8258
sumit.bansal@rhsmith.umd.edu

Education

University of Maryland

Robert H. Smith School of Business

Master in Information Systems Dec 2018

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:
-Develop the club’s budgets
-Arrange logistics for different events organized by ISA.

Manipal University

Manipal Institute of Technology

B.Tech. in Civil Engineering May 2015

- 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

Tata Consultancy Services

ETL Engineer July 2015 - July 2017

Client – Deutsche Bank
Team Management: Lead a team of eight members handling over 1000 jobs, each containing 10,000 rows, to be processed daily; Collaborated with managers on plans to enhance team productivity.
Process Improvement: Developed efficient SQL codes to clean and manipulate 10,000,000 rows on Informatica PowerCenter tool; minimized time by 30% for running loads and completion of tasks.
Process Innovation: Automated job failure alerts using SQL queries on Geneos tool; Received “On the spot award” from client for reducing work force by 50% and reaction time from 2 minutes to 30 seconds.
Business Planning: Conducted several knowledge transfer and training sessions for new employees. Also, prepared documents and presentations on Business Intelligence tools for 45 associates to ensure smooth transition.

TCS Internal Project
Process Setup: Collaborated with cross-functional team of five to set up Pentaho Data Integration and Business Analytics unit for company; promoted use of services via rollouts resulting in 60% adoption in 3 months.
Business Analysis: Generated dynamic reports of 8,000 employees in TCS learning program worldwide highlighting performance of individual employee, class and center for higher management analysis.

Delhi Land & Finance

Analyst Intern June 2014 - August 2014

Business Requirements: Performed requirements gathering; Devised technical designs and architect data models for analytical database to meet the client expectations.
Process Implementation: Implemented database management and reporting system to organize and analyze construction materials; leading to optimization of resources and 20% increase in project revenues.

Skills

There are two ways to extend a business. Take inventory of what you're good at and extend out from your skills or determine what your customers need and work backward, even if it requires learning new skills. Below are my skill sets and I am eager to learn more.

  • Python
  • R
  • Unix
  • SQL
  • Tableau
  • Microsoft Excel

Get Hosting.

Moto

In today’s world, we constantly produce a lot of data by various means such as social media, GPS, purchase transaction records to name a few. There is a need to harness and analyze these large datasets available and provide personalized products to the customer. This profound idea attracted me and urged me to widen my knowledge by pursuing Master of Information Systems Management program, which not only supplements the knowledge that I possess but also provides a strong platform for my career aspirations and goals. On completion of the program, I will be well prepared to extract meaningful data, analyze that data backward and forward for trends, and provide stakeholders with the necessary information from structured as well as unstructured datasets.

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.

    Mr. Souradeep Bhowmik
    Senior System Engineer at Tata Consultancy Services
  • "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.

    Mr. Karthick KS
    Senior Analyst at DBOI GLOBAL SERVICES PRIVATE LIMITED

Get In Touch.

If you want to get in touch with me, please feel free to drop a mail.

Address and Phone

Sumit Bansal
8125 48th Ave APT#321
College Park, MD 20740 US
(240) 918-8258
sumit.bansal@rhsmith.umd.edu