Gurbaj Singh's resume
GURBAJ SINGH
------------
SUMMARY:
• Experienced with various parametric solid modelers such as AutoCAD, SolidWorks & Creo.
• Experience with MS Excel in maintaining and organizing data; creating pivot tables and modifying spreadsheets to achieve analytical goals.
• Proficient in formatting and page setup in MS Word such as custom repeating headers, multiple columns, page numbering, and fontcolor choices.
• Experience with gathering and translating Business Requirement into business artifacts.
• Ability to explain complicated or technical information in a simple way to non-technical audiences.
• Experienced with MS Visio to create use case diagrams.
• Hands-on experience with SQL
• Experience with Programming & Scripting - R, Python, HTML, JavaScript
• Experience with dashboard, storytelling and visualize data in form of various charts, plots & maps using Tableau
• Hands-on experience with Data Analysis (Statistical) using R programming.
• Experience with Predictive modeling such as Classification, Decision Trees and Clustering.
• Proficient in all phases of Software Development Life Cycle (SDLC) and workflow process.
• Excellent organization and time management skills.
EXPERIENCE:
SJSU Spartan Racing club: 2015-2017
Member and Project Management.
Spartan racing club competes in SAE (Society of Automotive Engineer) league where other racing clubs of schools/universities around the globe participate with their engineered vehicles every year in various competitions.
Project Management responsibilities:
• Recognized the minimum essential elements of robust design of various components needed for the development of competition vehicle.
• Managed the projects related to fundraising, promotions and marketing.
• Evaluated the essential requirements to align with competition rules.
• Utilized the different types of meeting and conflict resolution strategies, formulate an effective meeting summary and action list, and simulate an actual design review.
Engineer responsibilities:
• Designed and tested various components of the competition vehicle in CAD for performance, feasibility and competition’s specifications.
• Completed project mechanical design while providing technical solution feedback.
• Supported engineer design through analysis and simulation.
• Provided technical direction to other engineers, designers and technicians.
• Performed thermal, electromagnetic, dynamic and structural engineering analysis.
• Project:
o Used SolidWorks to redesign the oil pan of competition vehicle’s engine, a major engine cooling system part mounted on the bottom of an engine serves as an engine oil reservoir, and simulated tests in STAR CCM to reduce sloshing and prevent oil starvation and low oil-pressure.
o Resulting in new design of 0.5-quart capacity oil pan from 0.9-quart and flange thickness of 0.125 in from 0.1 in. Analyzed data showed 11 % efficiency achieved in preventing sloshing and low oil-pressure. Overall, results showed 7.5% increase in engine’s efficiency of cooling system
Parade AI: July 17 – Present
Analyst
Parade AI is a start-up company that provides automate-solutions to transporting industry of trucking around the world.
• Compile and generate spreadsheets to capture key data related to company’s active contracts.
• Analyze and validate all data and present reports to clients which include importing, cleaning, transforming, validating or modeling data with the purpose of understanding or making conclusions from the data for decision making purposes.
• Responsible for creating R script for migrating Excel data to database.
• Write SQL queries to analyze data in database tables to triage and resolve defects in various levels of testing efforts.
• Coordinate with the stakeholders and project key personnel to gather functional and non-functional requirements.
• Assist business analyst team in creating use case diagrams and narratives, completing BRD and FSD documents.
• Work closely with team members and the director to define the analysis tasks.
• Primary point of contact working with stakeholders to understand their systems, processes, and business needs.
• Created system to assign tasks optimally to increase productivity.
EDUCATION QUALIFICATION:
• San Jose State University, CA, USA. May 2017
Mechanical Engineering
• Stanford Lagunita November 2017
Database Archived course(SQL and Relational databases)
• MIT Open Course Ware January 2018
Introduction to Algorithms
Statistics and Probability
• The Analytics Edge on EDx May 2018 Linear and logistic regression, classification/linear regression trees, clustering and optimization
TECHNICAL SKILLS:
• Programming: R, SQL, HTML, Python
• Databases: Oracle, SQL Server, and MySQL.
• BI Applications: Tableau
• Operating System: Linux, UNIX, Windows.
• Miscellaneous: MS Excel, MS Word, MS PowerPoint, MS Visio
• Modeling: AutoCAD, SolidWorks, Creo
GURBAJ SINGH
------------
SUMMARY:
• Experienced with various parametric solid modelers such as AutoCAD, SolidWorks & Creo.
• Experience with MS Excel in maintaining and organizing data; creating pivot tables and modifying spreadsheets to achieve analytical goals.
• Proficient in formatting and page setup in MS Word such as custom repeating headers, multiple columns, page numbering, and fontcolor choices.
• Experience with gathering and translating Business Requirement into business artifacts.
• Ability to explain complicated or technical information in a simple way to non-technical audiences.
• Experienced with MS Visio to create use case diagrams.
• Hands-on experience with SQL
• Experience with Programming & Scripting - R, Python, HTML, JavaScript
• Experience with dashboard, storytelling and visualize data in form of various charts, plots & maps using Tableau
• Hands-on experience with Data Analysis (Statistical) using R programming.
• Experience with Predictive modeling such as Classification, Decision Trees and Clustering.
• Proficient in all phases of Software Development Life Cycle (SDLC) and workflow process.
• Excellent organization and time management skills.
EXPERIENCE:
SJSU Spartan Racing club: 2015-2017
Member and Project Management.
Spartan racing club competes in SAE (Society of Automotive Engineer) league where other racing clubs of schools/universities around the globe participate with their engineered vehicles every year in various competitions.
Project Management responsibilities:
• Recognized the minimum essential elements of robust design of various components needed for the development of competition vehicle.
• Managed the projects related to fundraising, promotions and marketing.
• Evaluated the essential requirements to align with competition rules.
• Utilized the different types of meeting and conflict resolution strategies, formulate an effective meeting summary and action list, and simulate an actual design review.
Engineer responsibilities:
• Designed and tested various components of the competition vehicle in CAD for performance, feasibility and competition’s specifications.
• Completed project mechanical design while providing technical solution feedback.
• Supported engineer design through analysis and simulation.
• Provided technical direction to other engineers, designers and technicians.
• Performed thermal, electromagnetic, dynamic and structural engineering analysis.
• Project:
o Used SolidWorks to redesign the oil pan of competition vehicle’s engine, a major engine cooling system part mounted on the bottom of an engine serves as an engine oil reservoir, and simulated tests in STAR CCM to reduce sloshing and prevent oil starvation and low oil-pressure.
o Resulting in new design of 0.5-quart capacity oil pan from 0.9-quart and flange thickness of 0.125 in from 0.1 in. Analyzed data showed 11 % efficiency achieved in preventing sloshing and low oil-pressure. Overall, results showed 7.5% increase in engine’s efficiency of cooling system
Parade AI: July 17 – Present
Analyst
Parade AI is a start-up company that provides automate-solutions to transporting industry of trucking around the world.
• Compile and generate spreadsheets to capture key data related to company’s active contracts.
• Analyze and validate all data and present reports to clients which include importing, cleaning, transforming, validating or modeling data with the purpose of understanding or making conclusions from the data for decision making purposes.
• Responsible for creating R script for migrating Excel data to database.
• Write SQL queries to analyze data in database tables to triage and resolve defects in various levels of testing efforts.
• Coordinate with the stakeholders and project key personnel to gather functional and non-functional requirements.
• Assist business analyst team in creating use case diagrams and narratives, completing BRD and FSD documents.
• Work closely with team members and the director to define the analysis tasks.
• Primary point of contact working with stakeholders to understand their systems, processes, and business needs.
• Created system to assign tasks optimally to increase productivity.
EDUCATION QUALIFICATION:
• San Jose State University, CA, USA. May 2017
Mechanical Engineering
• Stanford Lagunita November 2017
Database Archived course(SQL and Relational databases)
• MIT Open Course Ware January 2018
Introduction to Algorithms
Statistics and Probability
• The Analytics Edge on EDx May 2018 Linear and logistic regression, classification/linear regression trees, clustering and optimization
TECHNICAL SKILLS:
• Programming: R, SQL, HTML, Python
• Databases: Oracle, SQL Server, and MySQL.
• BI Applications: Tableau
• Operating System: Linux, UNIX, Windows.
• Miscellaneous: MS Excel, MS Word, MS PowerPoint, MS Visio
• Modeling: AutoCAD, SolidWorks, Creo