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.
8125 48th Ave APT#321
College Park, MD 20470 US
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.
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.
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.
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.
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.
Donco LTD wants to setup a merchandise acquisition in Nepal. Identify both current and projected near term (within 3 years) communications infrastructure and services, and in-country geographic areas of service. Also, determine geographic areas within each country in which appropriate communications services can be obtained to support their communications requirements with potential outsourcers, including access technologies and services available.Newtorks, Business Setup
Ranking system of US graduate programs – Salesforce and MS SQL
-Defined business processes and translated them into system requirements for business operations.
-Deployed a CRM model to improvise storytelling and business intelligence for the management.
Avizia – Emerging telehealth firm analysis
-Detailed research on firm’s standing in the industry, its competitive advantage and value proposition.
-Application of frameworks (SWOT & VRIN model) to evaluate the overall valuation of the firm.
Problem: Predict the winner of FIFA World Cup 2018 based on the latest FIFA dataset.
Approach: Established a linear regression model to find the top 5 attributes for each position. Based on these attributes and player's preferred position, assigned a player for each position.
> Won the 1st prize and got a chance to compete in MIT Solan Case Competition 2018.
Proin gravida nibh vel velit auctor aliquet. Aenean sollicitudin, lorem quis bibendum auctor, nisi elit consequat ipsum, nec sagittis sem nibh id elit.Branding, Webdesign
Proin gravida nibh vel velit auctor aliquet. Aenean sollicitudin, lorem quis bibendum auctor, nisi elit consequat ipsum, nec sagittis sem nibh id elit.Photography
Proin gravida nibh vel velit auctor aliquet. Aenean sollicitudin, lorem quis bibendum auctor, nisi elit consequat ipsum, nec sagittis sem nibh id elit.Branding, Illustration
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.
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
If you want to get in touch with me, please feel free to drop a mail.