Vigneshwaran Giri Velumani

Data Analyst | Data Scientist | Business Intelligence | Business Analyst

Portfolio


About Me


“Twenty years from now you will be more disappointed by the things that you didn't do than by the ones you did do. So, Explore. Dream. Discover.” - H. Jackson Brown Jr.

Throughout my life both academically and professionally, I have been constantly developing my interest in data analytics. From a Software Developer to Data Analyst, my dream to explore further in Technology and Business led me to pursue a Masters in Management Information Systems, which exposed me to Data analytics, Business Intelligence, and Strategy Consulting.

I always believe in constant learning, wherein my exploration steered my passion for Data Science where we “Explore. Hypothesize. Discover” with Data, to pursue an additional Master’s Degree in Business Analytics, where I received in-depth exposure to Machine Learning Algorithms & various Data Analytics tools like SQL, R, Python, Tableau, SAS, etc.

So far, as a Data Analyst at Infosys Limited, Data Analytics and BI Developer at UIC as well as a Pricing Analytics Intern at Zoro, I was able to prove that data-driven decision-making is always the key to any business.

Looking forward to Explore. Dream. Discover…

Currently, I am in the job market looking for opportunities in data analytics, business intelligence and data science.

Kindly contact me to know more about how I can contribute and add value to your organization.






Education


  • University of Illinois at Chicago – Liautaud Graduate School of Business
  • Master of Science in Business Analytics
  • Duration: Aug 2018 – Dec 2019
  • Location: Chicago, IL
  • GPA: 3.71

    • University of Illinois at Chicago – Liautaud Graduate School of Business
    • Master of Science Management Information Systems
    • Duration: Aug 2017 – Dec 2019
    • Location: Chicago, IL
    • GPA: 3.71

      • Anna University
      • Sri Sivasubramaniya Nadar College of Engineering
      • Bachelor of Engineering in Electrical & Electronics Engineering
      • Duration: Aug 2009 – May 2013
      • Location: Chennai, India
      • GPA: 3.16



      • Work Experience


        • Company: Presbyterian Healthcare Services
        • Position: Analytics Associate III
        • Duration: Sep 2020 – Present
        • Location: Chicago, IL (Remote)

        • Key Technologies: SQL, Business Objects, Tableau, PowerBI, Advance Excel
        • • Design, develop & deliver reporting/analytics solutions & statistical expertise for Delivery team to enable better decision making.
        • • Gather customer's requirements from Delivery System including supply chain & finance for developing dashboards & reports.
        • • Act as an analytics consultant & provide ad-hoc reports to business leaders & stakeholders for actionable insights. Perform business analysis and develop metrics, design data flows to ensure integrity & reliability of BI, analytics & database infrastructure.
        • • Serve as a liaison with internal & external stakeholders to conduct strategic analysis, deliver the findings & implement solutions.
        • • Spearheaded completion of 15 Analytics reports for Delivery System customers after swiftly getting up-to-speed with tech stack.


        • Company: University of Illinois at Chicago
        • Position: Data Analyst
        • Duration: Feb 2020 – Sep 2020
        • Location: Chicago, IL

        • Key Technologies: Excel, R, Google Scholar, Publish or Perish
        • • Extracted effect size metrics, methods, & adverse events of primary targets in multifaceted trial outcomes of medical studies.
        • • Performed data cleaning, created visualizations & identified value-added features to assist physicians in comprehensive reviews.


        • Company: DuPage Medical Group
        • Position: Data Science Academic Intern
        • Duration: Aug 2019 – Dec 2019
        • Location: Chicago, IL

        • Key Technologies: Python, Tableau and SQL
        • • Analyzed claims data having ICD-10, CPT codes, service provider & diagnostic codes of patients who churned from DuPage.
        • • Explored geographic, demographic, seasonality & modality features, created dashboards showing prime churn factors .
        • • Collected & merged 3rd party data with extracted features & built a Neural Network model with prediction accuracy of 90%.
        • • Assessed risk of customer churn & developed strategies by defining KPIs & metrics for decreasing the rate of patient churn.


        • Company:Zoro, a W.W. Grainger Company
        • Position: Pricing Analyst Intern
        • Duration: June 2019 – August 2019
        • Location: Chicago, IL

        • Key Technologies: R, PostgreSQL and Advance Excel
        • • Analyzed price changes of Amazon to estimate their periodic price volatility and their impact on Zoro’s sales over time.
        • • Performed competitive data QA checks by applying a set of pricing rules to filter SKUs to determine volatility of 26.4K SKUs.
        • • Built an automated detective system which identifies opportunities of revising prices within 2.7 million SKUs of Zoro.
        • • Identified 6200 products of Zoro cross-referenced with 500K SKUs of Amazon requiring price revision during volatility.


        • Company: University of Illinois at Chicago
        • Position: Data Analytics & Business Intelligence Developer
        • Duration: July 2018 – Dec 2019
        • Location: Chicago, IL

        • Key Technologies: SLATE CRM, Advance Excel, Tableau and PowerBI
        • • Utilized UIC’s prospective & current students’ enrollment data using CRM system to perform trend analysis & monitoring.
        • • Consulted with stakeholders & identified KPIs in application review process & developed metrics to measure yearly progress
        • • Built reports & developed PowerBI dashboards that provide a clear picture of admissions trends.
        • • Informed stakeholders with key insights which helped improve the recruitment processes resulting in expedited admissions decisions by 8% per year.


        • Company: VisTracks
        • Position: Analytics Project Intern
        • Duration: March 2018 – May 2018
        • Location: Chicago, IL

        • Key Technologies: R and Tableau
        • • Designed a marketing plan for an ELD software provider. Performed Industry, Competitor, KPI and web & app store assessment to increase its brand awareness, bring Value Added Services & proposed ideas to revamp their reseller model.
        • • Analyzed customer age, Customer Happiness Index, service and usage patterns of the website & created Tableau dashboard.
        • • Identified the list of 100 customers with highest churn probabilities and the top three drivers of churn for each customer .


        • Company: Infosys Limited
        • Position: Data Analyst / Senior Systems Engineer
        • Duration: Jan 2015 – July 2017
        • Location: Chennai, India

        • • Improved the target marketing by collaborating with the customer acquisition & marketing team for designing new campaigns.
        • • Converted client’s liability customers to personal loan customers using k-NN model & increased the conversion rate by 5%.
        • • Supported AMEX to meet Regulatory Compliance Requirement, using Risk Management platform - LexisNexis Bridger Insight XG.
        • • Developed a workflow management system to monitor screening progress of the batch files of customer data and reported KPIs.
        • • Updated and tuned rules in SQL to analyze fraudulent accounts/transactions & trends in customer data & developed reports.
        • • Led a team of 4 in the Training Applications Portfolio Management project for an aircraft manufacturing customer across broad technical disciplines involving 4 web applications - An application request management System, a Sensitive Information Management System, a Change Request tool and a Points Portal Management System, accomplishing an overall cost savings of $200K annually for the customer.
        • • Focused the team on business objectives and tracked progress to ensure project milestones were completed on time, on budget, and with the desired results.
        • • Utilized reporting tools like Tableau and Excel for generating ad hoc reports of various industry-specific KPIs and presented the insights to a wide range of audiences for actionable insights and involved in documentation of analysis.
        • • Gathered business and technical requirements from stakeholders/business and technology partners for project planning, project estimates, and risks in the application and collaborated in the development and grooming of Project Backlog Stories (Requirements) using Rally.
        • • Translated and simplified business & functional requirements document, created business use cases, test plans, planning and monitored the project for timely completion.
        • • Collaborated in Sprint Planning, Daily Scrum Stand Up, and Sprint Retrospective meetings.


        • Company: Infosys Limited
        • Position: Systems Engineer
        • Duration: Sep 2013 – Jan 2015
        • Location: Chennai, India

        • • Involved in all stages of the Software Development Life Cycle (SDLC) including requirement gathering, analyzing, designing, implementation, testing, deployment, and documentation.
        • • Migrated Client’s application and data from legacy VB6 to VB.NET in Agile environment by analyzing data and revamped the UI which improved data processing, improved visual presentation of data, and ease of use. Developed an Excel to XML conversion tool, reducing the effort from 4 hours to 30 seconds.
        • • Effectively managed version control through TFS. Updated issues, bugs, and efforts in JIRA.
        • • Mined financial datasets, wrote complex SQL queries, aggregated data using SQL aggregate functions, extracted and analyzed data using pivot tables, v-lookup in Microsoft Excel and provided actionable recommendations to a Banking customer to Meet Global Regulatory Compliance Requirement, using a Financial Crime Risk Management platform called LexisNexis Bridger Insight XG.
        • • The platform is used to check customer profiles quickly, to carry out an “Identity Screening” in real-time against a comprehensive set of watch lists.
        • • Developed a feature to show the workflow status of batch screening in the internal web portal to drive compliance costs down and increase operational capacity.
        • • Implemented database objects such as stored procedures, functions, triggers, views for SQL database.
        • • Resolved JIRA support tickets (bugs in the applications) within the Service Level Agreement and achieved Customer Satisfaction Index (CSI) of above 98%.



Leadership


  • Position: Executive Committee Member
  • Organization: University of Illinois at Chicago
  • Duration: Aug 2019 – Dec 2019
  • As an Executive Committee Member at UIC, I organize major events, and participate in all Graduate Student Council activities. I involve in executive committee meetings and attend monthly meetings with the representatives. I also serving as a formal representative of IDS-MSMIS at monthly GSC meetings.
  • Team: Lead a team of 5 Masters Students to coordinate with all activities.


  • Position: Business Ambassador
  • Organization: University of Illinois at Chicago
  • Duration: Aug 2017 – Dec 2019
  • Ambassadors are an essential part of UIC's Admissions and Recruitment team. This leadership program offers me an opportunity to become directly involved with students, faculty, and staff through campus activities and events. Ambassadors like me share our perspectives regarding the admissions process, courses, faculty, and life as a graduate business student to Liautaud candidates, donors, alumni, and other entities interacting with the school of business.
  • Team: Lead a team of 10 Ambassador Volumneers to assign tasks & responsibilities & work with Event Coordinator to allocate resources to all tasks for all UIC Business Events like Onboardings, Open houses, etc.


  • Position: Logistics Manager
  • Organization: INFORMS - UIC Chapter
  • Duration: Jan 2018 – Dec 2018
  • As a Logistics Manager, I was responsible for logistics handling for all INFORMS events. I reach out to alumni of IDS programs & invite them to share their experiences in finding jobs, conducting Info sessions, mock interviews, grad social for networking and inviting keynote speakers and job shadowing.
  • Team: Coordinate with President and Informs Team to plan and organize all the events.


  • Position: Coordinator
  • Organization: Indian Graduate Students Association (UIC)
  • Duration: May 2018 – Dec 2018
  • As a Coordinator at IGSA, my responsibility was to collect data of the students in the upcoming semesters and provide them with information and surveys. Validate and manage the data collected and report any problems. Ensure timely pick-up of students from the airport and drop them at their respective locations.
  • Team: Worked with 4 other Coordinators to plan & organize all the activities.


  • Position: Student Member
  • Organization: LeaderShape, Inc.
  • Duration: May 2018
  • As a student who attended leadershape is a good program that universities and businesses can send people to for structured leadership development. They work best in small numbers so it can be competitive if there are a lot of people interested. During the week-long course students learn various aspects of leadership and then put into positions to see and reflect on their own leadership characteristics and how those could be beneficial or harmful in a group setting.

Awards


     
  • Insta Award Recipient, Infosys (2016)
  •  
  • SPOT Award Recipient, Infosys (2015)

Certifications


     
  • Tableau Data Scientist | Tableau Software | Issued June 2020 View Credential
  •  
  • Tableau Desktop Specialist | Tableau Software | Issued May 2020 View Credential
  •  
  • Tableau Analyst | Tableau Software | Issued May 2020 View Credential
  •  
  • Introduction to Data Science in Python | University of Michigan on Coursera | Issued December 2019 View Credential
  •  
  • Using Python to Access Web Data | University of Michigan on Coursera | Issued November 2019 View Credential
  •  
  • Digital Product Management: Modern Fundamentals | Coursera | Issued October 2019 View Credential
  •  
  • Introduction to Data Studio | Google | Issued October 2019 ● Expires October 2022 View Credential
  •  
  • Google Analytics for Beginners | Google | Issued May 2019 ● Expires May 2022 View Credential
  •  
  • Advanced Google Analytics | Google | Issued May 2019 ● Expires May 2022 View Credential





Location

1427 W Lexington St
Chicago, IL 60607

Contact Number

+1 312-804-5442

Let's Connect!

Network Analysis of GitHub Developers Community


Analyzed Github undirected network data of 37.7K nodes & 289K edges to find the characteristics, the collaboration between ML and Web Developers, find most popular developers in both networks.

Identified several sub-communities & also provided insights on how to improve collaboration.

Close Project

Link Prediction of Nasdaq's top 100 Companies


Some firms may have closely related patterns in the amount of social media chatter about them over time. In this project, I have built and described the undirected networks that link firms based upon the (partial) correlations in their Twitter activity.

I have analyzed what the resulting network reveals about the relationship between the firms as they are described on Twitter. I have also explained whether the edges appear to represent competitive relationships, cooperative relationships, or some other type of connection.

Some of the methods/techniques which I used in this project include: partial correlation, Fisher’s transformation, Benjamini-Hochberg adjustment and finaly creating visualizations of these links between the networks.

Close Project

Network Structure Analysis of SAP Online Knowledge Community Platform


This project analyzes the implications of the Network Structure of the SAP Online Knowledge Community Platform. It has a complex network structure with 6090 Edges & 3415 Vertices.

The project includes analysis and findings of the features of the network, its overall structure, the distributions of network measures among nodes and edges, and all their implications of the SAP knowledge community.

The findings also include trust, reciprocity, authority, and access to information, strong triadic closure is present in this network, and what the data tells us about the role of local bridges and weak ties.

Close Project

Web scraping of Physician reviews to build a Recommender System using NLP & Text Mining


Web scraped 2500+ Physicians and their reviews (50,000 records) from ratemd website using beautifulsoup4

Preprocessed the data & implemented text mining and NLP techniques and built a Recommender System for the patients

Close Project

Statistical Analysis of EMR Health Information National Trends Survey Data


Analyzed the characteristics of the users/nonusers of online system to access EMR health records using the HINTS 5 Cycle 2 dataset containing 449 Features and 3504 samples.

Identified 20 important features which were key indicators of EMR online user activity. Developed models and visualizations to determine the similar characteristics of the portal users across 5 different categories.

Close Project

Social media analytics to combat Digital Opioid Access


Developed a solution to detect and classify Illicit Online Marketing, Sales & consumption of Controlled Substances via Instagram: Using NLP & Machine Learning models. Identified 10 illegal individual & online sellers.

Close Project

Sentiment Analysis of tweets to find Adverse Drug Reactions


Implemented bag of words model and sentiment mining using SVM classification of three allergy medication drug tweets collected for a period of one month from April 1 to April 28 - 2018.

Identified the effectiveness of the drugs, their 9 undisclosed Adverse Drug Reactions from 48 negative tweets, and their frequent common side effects and presented the findings to our client – a leading US pharmaceutical company.

Close Project

Predicting daily Surgery Volume at Vanderbilt University Medical Center


Developed a time series model for predicting daily case volume using 45 weeks of data. Built a model to forecast the demand two weeks ahead of time;achieved an adjusted R-squared value of 85.8% with RMSE value of 8.58 and MAE value of 6.462.

Close Project

Study of Black Friday sales through consumer behaviors


Analyzed Black Friday's consumer and transaction dataset containing 12 features and 537557 observations.

Performed data cleansing, model comparison and discovered that male unmarried in the age group of 40 – 50, certain occupation types, and city category C predominantly influence the purchase amount.

Close Project

Chronic Kidney Disease Prediction using Logistic Regression


Analyzed dataset containing 6000 records of training data and predicted 2819 records of test data containing 33 indicator variables. Built a forward step-wise logistic regression model in SPSS to predict the risk of a patient getting Chronic Kidney Disease.

Close Project

German Credit Loan Default Prediction using Decision Tree Algorithm


Analyzed dataset containing 30 predictor variables and 1000 observations while considering the cost of misclassification using loss function.

Performed EDA and built a Decision Tree model to classify whether a new applicant is a good credit or a bad credit.

Evaluated the model with and without opportunity cost and observed a 10% decrease in the false alarm rate & a 10% increase in specificity in the test data.

Close Project

Predicting cardiovascular examination volume at Fargo Health Group using Time Series Analysis


Predicted the incoming cardiovascular examination volume at Abbeville HC using ARIMA model. Validated all the assumptions underlying ARIMA model and forecasted the number of Cardiovascular examination volume by analyzing 8 years of exam records at the Abbeville HC.

Close Project

Insurance purchase prediction using Random Forest with hyperparameter tuning


Analyzed dataset containing 86 predictor variables & 9000 observations while tuning hyperparameters to choose optimal sample size, mtry and n0.

Performed factor level reduction & built the RF model with 94% accuracy & 6.18% OOB error rate and identified 281 insurance holders.

Close Project

Predicting Treatment costs at Mission Hospital using Multiple Regression


Analyzed 248 patient’s health data containing 41 features and identified 8 key factors that affect the treatment cost.

Built a multiple regression model using Mission Hospital data for predicting the package price/treatment costs at the time of patient admission.

Close Project

YouTube Data Analysis using MapReduce


Identified the top 10 categories of videos having the highest number of views, likes, comments, and ratings using 2 mappers and 2 reducers. Used PowerBI to visualize and compare the results to recommend the best video categories on YouTube

Close Project

Prostate Cancer Survival Analysis


Analyzed 8955 patient records and their 34 features and identified the characteristics of prostate cancer survival after 7 years. Built a forward stepwise logistic regression model to identify the prostate cancer patients and predict the odds and risk of prostate cancer survival.

Close Project

KPI Analysis & Dashboard development for JetBlue Airlines


Performed KPI, competitor analysis of JetBlue's on-time performances and delays and Identified 2 key competitors, 6 major airports & 23 major routes for increasing traffic & improving customer engagement. Developed a comprehensive executive storyboard to provide actionable insights and opportunities for growth.

Close Project

IBOT (A Program Recommender System and Q&A Chatbot for Universities powered by IBM Watson)


Improved the user experience of finding the different programs offered by Universities by building a recommender system and integrating it with a WordPress website which leveraged IBM Watson's Conversation & Discovery Services to provide recommendations based on user’s preference and profile.

The chatbot also responds to frequently asked applicant’s admission queries.

Data of different programs has been extracted from UIC Web pages and integrated into the Chatbot using IBM Watson Discovery Services.

Built the startup business canvas model which elaborated the unique value proposition, cost structure, revenue streams, customer segments, channels and key activities

This IBOT could potentially reduce #calls by 30%, email inquiries by 40% and reduce overall response time by 20% and save $140K/year for Universities.

Close Project

Analysis of Bureau of Transportation Statistics data for building Regression Models using SAS


Analyzed BTS monthly flight on-time performance file for June 2015 to estimate an OLS Regression Model and a LOGISTIC regression model for each carrier.
Code:View code

Estimated an Ordinal Logit Model and a Multinomial logistic regression model using March 2015 BTS file. Estimated an OLS regression model using O'Hare 2015 weather file. Finally invoked R from SAS to run the same model to compare results of both.
Code:View code

Estimated a Poisson regression model using may 2015 BTS file. Estimated a penalized regression model using the LASSO method using the same data.
Code:View code

Close Project

MapReduce using Big Data Hadoop - NoSql Database Implementation


Retrieved data from Github wordcount Project into Google Big Table for the purposes of research and business intelligence.

Conducted thorough analysis on Google Big Table as a tool for storing data.

Implemented storing, Map/Reduce, clustering, sharding, and replication of wordcount data.

Close Project

Market Segmentation using Clustering Techniques


Performed EDA of CRISA bath soap data containing 600 observations and 46 attributes. Segmented customers based on their purchase behavior and brand loyalty.

Leveraged insights from the demographics & transaction data & developed a 5-cluster K-means model. Provided recommendations to guide advertisement & promotional campaigns.

Close Project

Statistical Analysis of factors affecting the price of Airbnb listings


Analyzed and performed EDA of 2016’s Airbnb Melbourne data which were merged with 3rd party data containing 25 features and 7280 observations

Conducted hypotheses testing and developed a multiple linear regression model to identify 2 key factors that affect the prices of these listings and determined the pricing pattern for different city zones

Close Project