VISHAKH VIJAYAN
Bentonville,AR
Summary
Business Intelligence Developer with 6 years of experience in business intelligence and data analysis providing data driven insights and solutions across business operations including production, sales, supply chain, product development, and accounting. Extensive knowledge, and experience working with data analysis and visualization tools in multiple platforms to automate, standardize, and govern data analytics solutions across a company and building KPI dashboards and ad-hoc reports.
Overview
9
9
years of professional experience
Work History
Business Intelligence Developer
Outdoor Cap Company
12.2022 - Current
- Developed data warehouse in SQL Server using SSMS increasing data consistency, and reduced data modeling times by 68%
- Created ETL pipelines in SSMS and using SSIS packages reducing load on OLTP and increased refresh times of inventory tables to every 1 hour per day
- Upgraded monthly inventory tracking using Power BI, Power Query Editor, and SQL queries which helped to reduce slow moving and closeout inventory by 26%
- Migrated factory scorecard tool to SharePoint cloud and Power BI, reducing monthly employee hours by 10 hours for report generation
- Reduced IT department midpoint reporting hours by 6 hours, and provide monthly analysis on performance metrics including release quality, ROI, SLA
- Standardized and documented metadata of data warehouse tables increasing data accuracy across company and improved consistency to 88%
- Collaborates and trained stakeholders and cross functional teams to determine business requirements and translate into analytic solutions
Operational Research Analyst
Outdoor Cap Company
01.2020 - 12.2022
- Facilitate reduction of production costs and capacity allocation at vendor factories providing accurate monthly production forecasts using advanced Excel and decreased cost by 15%
- Decreased sample rejection by 10% and design utilization visibility through sample utilization tracking tool in Power BI utilizing DAX, Power Query Editor, SQL (Joins, Sub-queries, CTE, Functions)
- Enhanced expense tracking of compliance testing for corporate responsibility team using Power BI dashboard reducing monthly report generation time by 4 hours
- Analyzed competitor data from shipping data provider website, and automated report update time under 10 minutes and developed data model to determine top competitors and identify potential vendors
Graduate Teaching Assistant
Wichita State University
08.2017 - 05.2019
- Trained undergraduate classes of 35 students on Engineering Graphics course and design software, and class performance tracking was done using blackboard and MS Excel
- Maintained student attendance and marks in Excel, to determine students requiring additional attention, through conditional formatting, v-lookup and data validation increasing pass percentage by 5%
Assistant Professor
VAST
03.2015 - 07.2017
- Lectured undergraduate classes of 60+ students on Mechanical Engineering courses with pass percentage of 90%
- Built Excel tool for tracking attendance and academic marks of students using Excel tables, functions, formulas, and Pivot tables
Education
Master of Science - Industrial Engineering -
Wichita State University
Wichita, KSMaster of Technology - Manufacturing Engineering -
Vellore Institute of Technology
Vellore, IndiaBachelor of Technology - Mechanical Engineering -
VAST
Thrissur, IndiaSkills
- ,Data Analysis Tool Design and Visualization
- Data Warehousing, Relational Database Management
- Data Modeling, ETL Pipelines
- Power BI, Tableau, Excel
- MS SQL Server, Azure SQL Database, Google BigQuery, IBM DB2
- SSMS, SSIS, SSRS, Azure Data Fundamentals
- Python, R
- Statistical Analysis, Business Intelligence, Supply Chain Management
Projects
Lead Time Analysis and Simulation Modeling, 05/2019 - 12/2019
Spirit AeroSystems
Process improvement project for a sub-assembly line of fuselage assembly plant for Boeing and determined bottle necks in the line and identified corrective measures to reduce lead time by 20%. Conducted time study and built database in MS Access to load collected data, defined a simulation model using Simio and calculated the lead time saved using MS Excel and tested the model
Bike Share Case Study, 09/2022 - 10/2022
Google Data Analytics Capstone
Analyzed bike share data from Google BigQuery database using SQL query conducted descriptive analysis of bike user data in Chicago bike share program. Combined multiple datasets, cleaned, and transformed before exploratory analysis using R and analyzed trends in Tableau visualizations showing and determined usage patterns of customers and recommended program changes to increase new customers and decrease customer churn
Certifications
- Microsoft Certified: Power BI Data Analyst Associate
- Microsoft Certified: Azure Data Fundamentals (September 2023)
- Google Data Analytics Certification (October 2022)
Publications
Journal Publication - Simulation-Based Decision Framework for Hybrid Layout Production Systems Under Disruptions. Procedia Manufacturing, 51, 1062-1068 https://doi.org/10.1016/j.promfg.2020.10.149
Timeline
Business Intelligence Developer
Outdoor Cap Company
12.2022 - Current
Operational Research Analyst
Outdoor Cap Company
01.2020 - 12.2022
Graduate Teaching Assistant
Wichita State University
08.2017 - 05.2019
Assistant Professor
VAST
03.2015 - 07.2017
Master of Science - Industrial Engineering -
Wichita State University
Master of Technology - Manufacturing Engineering -
Vellore Institute of Technology
Bachelor of Technology - Mechanical Engineering -
VAST
Similar Profiles
Emilio GonzalezEmilio Gonzalez
IT Technical Support Specialist at Outdoor Cap CompanyIT Technical Support Specialist at Outdoor Cap Company
Elizabeth ReevesElizabeth Reeves
Account Lead 2 at Outdoor Cap CompanyAccount Lead 2 at Outdoor Cap Company
César MagaÑaCésar MagaÑa
Senior Product Designer at Outdoor Cap CompanySenior Product Designer at Outdoor Cap Company