Vaibhav Bijola
College Station, Texas 979-***-**** adb3pa@r.postjobfree.com www.linkedin.com/in/vaibhavbijola
EDUCATION
Texas A&M University, Mays Business School College Station, TX
Master of Science in Management Information Systems GPA: 3.6/4.0 May 2021
G. B. Pant University of Agriculture and Technology Uttrakhand, India
Bachelor of Technology in Information Technology June 2017
TECHNICAL SKILLS, CERTIFICATIONS & ORGANIZATIONS
Tools: Tableau, PowerBI, Informatica, Adobe Experience Manager, Microsoft Office Suite, Adobe Creative Suite, Lucidchart, MS Project Management, Office 365, Hadoop
Programming Language: Python, JAVA, HTML, CSS, PHP, JavaScript
Database Language/Frameworks: SQL, MariaDB, PL/SQL, MongoDB
Certifications: Tableau 10 Advanced, Scrum Advanced, Python, Excel Masterclass
Organizations: Toastmasters International, SPIC MACAY, National Service Scheme, Data Analytics Club
EXPERIENCE
Texas A&M University College Station, TX
Graduate Teaching Assistant - Statistical Methods for Business January 2020 – Present
Topics include probability, sampling, uniform, and normal distribution, t-distribution, Hypothesis testing, confidence intervals, decision analysis, statistical inferences, linear regression and correlation
Tata Consultancy Services Gurugram, India
System Engineer August 2017 – June 2019
Developed ETL pipeline to process real time data from 100 databases and built a consolidated layer to provision data for more than 1 mn users using Informatica enhancing data processing by 15%
Designed dashboards in Tableau on regular basis to help business users, like visualizing shortage of pharmaceutical drugs in 28 major countries in Asia Pacific region aiding in supply chain management
Boosted the Customer Satisfaction Index from 92% to 100% in 6 months by collaborating with senior officials to define Key Performance Indicators for 3 projects to provide deliverables to business users
Encyclopaedia Britannica Delhi, India
Intern April 2016 – April 2017
Frequently implemented usage of charts, pivot tables and lookup formulas in Microsoft Excel to organize and derive meaningful information from data
Developed a recommendation system for the company by assessing old data to advise them on the content of the learning videos based on different age groups
Oil and Natural Gas Corporation Limited Dehradun, India
Summer Intern June 2016 – July 2016
Performed Data Cleaning, Data Processing and Data Analysis in Relational Databases to create Schemas and Views from a raw data of the products from ONGC oil wells
Used PowerBI and python to visualize the amount of byproducts and view logistical requirements to contain them from 300+ oil wells on Indian Coastline
ACADEMIC PROJECTS
Online Poling System
Created fully functional system using J2EE, MySQL, HTML and CSS
Integrated JDBC with MySQL, created all tables in the database and mitigated all data issues in the system
Detection of Malarial Parasite in Blood using Image Processing
Orchestrated a project to Detect Malarial Parasites in Blood Using Image Processing in Matlab
Best value plan for SIM card users of a particular region
Developed dashboards to visualize and assess data of SIM card users of an area using SQL, Informatica, and Tableau, which were used to suggest best value plans for more than 1000 users
Cryptocurrency Investing Recommendation System
Built a 3 layered ETL pipeline using Informatica to transform, normalize and publish source data (cleaned using python) from MariaDB galera cluster and MongoDB for creating Tableau Dashboards as part of a cryptocurrency recommendation system
SPIC MACAY, Pantnagar Chapter Website
Used HTML, CSS, PHP, Angular JS and Twitter Bootstrap to build society website from scratch