Shyam Krishnan

Shyam Krishnan

$35/hr
Project/ Business Analyst
Reply rate:
-
Availability:
Hourly ($/hour)
Age:
33 years old
Location:
Coimbatore, Tamilnadu, India
Experience:
2 years
Shyam Krishnan Shyam Krishnan - | Chennai, India |-| LinkedIn: shyam-krishnan | Github | Tableau EDUCATION MS, Information Systems University of Maryland, Robert H. Smith School of Business B. Tech (Distinction), Electrical and Electronics Engineering Amrita University, Coimbatore Graduated: December 2019 Maryland, USA Graduated: August 2016 Tamil Nadu, India PROFESSIONAL EXPERIENCE ❖ Amtrak, National Railroad Passenger Corporation – Washington, DC, USA May 2019 – December 2019 • IT Reporting & Financial Analyst Intern, Passenger Information Display Systems ▪ Developed budgets, reconciliations and actuals reports using SAP Concur showing the incurred charges against all ongoing projects funded by Federal Railroad Administration typically ranging from $250K to $25M annually ▪ Created an Invoice Management dashboard in Tableau that helps six project managers efficiently approve invoices received from third party vendors assisting streamlined payment process for Amtrak Finance reducing the unpaid invoice backup 20% month on month ❖ ZoomRx Healthcare Solutions, Chennai, Tamilnadu June 2017 – March 2018 • Associate, Pharmaceutical Market Research ▪ Enabled a fortune-500 pharmaceutical client to make better decisions on their drug value creation and their brand perceptions through an in-house survey based analytical techniques with the help of SQL, advanced Excel functions and visualized the insights on a Tableau Dashboards to drive business insights ▪ Initiated recommendations from responses obtained from surveys; improved client’s physician reach by 25% ▪ Automated physician responses status of surveys using Google Scripts and SQL ❖ Mu Sigma Inc., Bangalore, Karnataka • Trainee Decision Scientist – Marketing Solutions October 2016 – April 2017 ▪ Led a team of five people and coordinated with a $50B pharmaceutical client by helping revamp marketing campaign strategies to increase older drug sales facing a dip in revenue due to market cannibalization ▪ Developed statistical models using predictive and prescriptive analytics; Utilized exponential smoothing time series models to visualize sales forecasts which resulted in revenue growth by 25% ▪ Built a Microsoft Excel dashboard to solve a route optimization problem for a major courier services company • Decision Scientist Intern - Center of Excellence & Innovation January 2016 – May 2016 ▪ Developed a Python script for streamlining an end-to-end business analytical process and automating report generation and updating data quality issues for the world’s largest apparel manufacturer using Python and Tableau ▪ Improved quality of decision making; decreased delays in report generation by 80% ▪ Appreciated by client, team lead and manager for driving this project towards completion and diligence shown towards tasks assigned VOLUNTEER EXPERIENCE ❖ ChangingThePresent.org, New York City, NY, USA April 2020 – February 2021 • Volunteer, Analytics Lead ▪ Responsible for hiring and training 15+ analysts on Google Workspace ▪ Executed data-driven strategies for non-profit organizations signed up on the platform ▪ Built automation tools using Jotforms, Python and GCP for creating influencer pages on our websites BUSINESS & TECHNICAL SKILLS Programming Skills: Databases / Big Data: Tools / Frameworks: Cloud Computing: Data Visualization, Reporting: Team Collaborative Tools: Business Management Skills: Python, R, Web Design & Development (HTML, CSS, JavaScript, BootStrap) MS SQL Server, Hadoop File Systems, MongoDB, SAP, StatTools Git, Pandas, NumPy, Matplotlib, Seaborn, NLtk, Scikit-Learn Amazon Web Services, Google Cloud Platform Microsoft Excel, PowerPoint, Tableau Desktop, RShiny App Microsoft Project & SharePoint, Asana, Google Workspace Client Relations, Strategic Decision Making, Critical thinking, Problem Solving Page 1 Shyam Krishnan ACADEMIC DATA SCIENCE PROJECTS ❖ Yelp Data Challenge: Predicting Star Ratings (Big Data Systems) March 2021 –April 2021 ▪ Leveraged big data technologies such as AWS Sagemaker by implementing Machine Learning models on the Yelp Dataset which comprised of 6.6M reviews across 200K businesses by setting up a Zeppelin instance for analysis ▪ Built functions using Apache Spark for data cleaning with an increased execution speed by 30% ▪ Support Vector Machine Regression was the best model for our analysis which could predict the star-rating with an 85% accuracy ❖ Hiretual Data Challenge: Corporate Attrition Predictor (Data Mining) March 2021 –April 2021 ▪ Spearheaded a team of 4 for analysis and modelling of Hiretual’s recruitment data to predict the attrition rate of employees in various businesses and non-profit organizations based on available and extrapolated features ▪ Developed data processing/ cleaning pipeline in python to efficiently handle ~10GB of data in Jupyter Notebook ▪ Used tests of significance and multicollinearity to streamline feature selection. Developed logistic regression, SVM and Random-Forest classifier, achieved 80% accuracy with Random Forest model ❖ Traffic Violations Predictor: Montgomery County, Maryland (Accessing web-data) March 2021 –April 2021 ▪ Implemented the Data Analysis workflow in RShiny from Descriptive to Prescriptive analytics using the open-source data on traffic violation cases in Montgomery County in the State of Maryland ▪ Built a prediction workflow of traffic violation cases across months in 2019 using ARIMA Time Series technique ❖ Efficiency Analysis of Public Utility Vehicles, Maryland (Decision Analytics) April 2021 –May 2021 ▪ Led a team of 3 for analysis of the fuel efficiency of public utility assets for the city council of College Park, Maryland ▪ Presented our analysis on low, medium, and high duty vehicles across different seasons to the College Park Mayor ▪ Conducted awareness campaigns to essential and emergency services teams on the importance of ‘code-orange’ days to save the environment from pollution by low fuel-efficiency vehicles ❖ Customer Segmentation Analysis: Product Marketing (Decision Analytics) April 2021 –May 2021 ▪ Customers who have made recent purchases from an online retail store were analyzed and segmented into various categories based on their profiling details to enable the online retailer to improve their shopping experience on all customer touch points ▪ The insights generated from the customer segmentation analysis were put up in an interactive storyboard in Tableau Public ❖ Page Rank Analysis: Python Data Visualization (Data Mining) April 2021 –May 2021 ▪ Built a simple web-page crawler in Python that accesses all the links in a webpage stored in an SQLite database for computation of Page-rank ▪ The resulting page-ranks of the links in the website are visualized using d3.js which is a JavaScript library for data visualization COURSES & CERTIFICATIONS ❖ Academic Courses ▪ Data Science ▪ Data Analytics ▪ Accessing Web-Data ▪ Financial Management ▪ Project Management ▪ Big Data Systems ❖ Other Courses & Certifications ▪ Python Specialization (University of Michigan) ▪ Tableau Desktop Specialization (UC – Davis) ▪ Business Foundations (Wharton – UPenn) Page 1
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.