Jake Nguyen

Jake Nguyen

Data Analyst
United States of America

About Me

Data Analyst with experience in SQL, Python, Tableau, Power BI, ETL data pipelines, reporting dashboards, and data visualization. Experienced in data mining, data architecture, data schema modeling, automation, product m…

Experience

Data Analyst

Startup Tech
Mar 2023 - Present · 3 years 3 months

Kindly check resume.











































































































































































































































z

Data Analyst

Stealth Startup
Mar 2023 - Present · 3 years 4 months

Architected and designed wireframes in Figma.
Wrote specs for a data intelligence and search product.
Designed and oversaw development of an advanced search product using semantic search and image captioning.
Designed orchestration of data pipelines and APIs for an enterprise-grade scraping network.
Managed a team of 3 developers.
Held agile sprints.
Approved code.
Led versioning and deployment of code and database from test to prod builds.

Product Owner

Personal Portfolio Various MicroSaaS’s
Mar 2023 - Jan 2024 · 10 months

Developed 10+ software applications, mostly business productivity software.
Developed a consumer-grade CRM software for job seekers.
Developed a consumer-grade ticketing app with queuing, multi-users, automations, and reporting.
Developed an any-all scraper tool using ChatGPT and pandas in Python.

Data Analyst

Lockheed Martin
Oct 2019 - Feb 2023 · 3 years 4 months

Cleansed, transformed, and aggregated large manufacturing datasets using SSMS and SQL stored procedures.
Merged data with SAP/ERP master records.
Automated ETL data pipelines with pyautogui.
Led digital transformation for the Blades department by developing a suite of Tableau dashboards.
Migrated 5 legacy Microsoft Access databases and converted them to SQL Data Warehouse and Power BI dashboard visualizations embedded in SharePoint.
Performed business analysis and tracked KPIs such as time spent, throughput, quality, waste, and bottlenecks.
Used Tableau and ad-hoc Excel to create and present PowerPoint presentations to stakeholders.
Helped advise stakeholders on manpower decisions and new initiatives.
Used regression in Python to create a statistical model to predict macro input/output scenarios.
Collaborated with IT to implement digital flows, suggest data governance, and validate data quality.
Researched, mapped, and documented processes using Visio.
Worked with Operations to come up with requirements and nonnegotiables.
Collaborated with manufacturing to finalize project implementation.
Trained non-technical personnel in custom SAP, Tableau, Power BI, and SharePoint Excel modules.

Skills

Analytics Data Analysis Professional Information Systems Management Data Mining Microsoft Access Statistical Analysis System (SAS) Structured Query Language (SQL) Data Representation Data Analysis Skills Power BI R Programming Language (R) Tableau Figma Semantic Search Image Captioning NLP Machine Learning C# .NET Python Agile Version Control Deployment SQL Server Data Pipelines APIs Scraping CRM ChatGPT pandas SSMS SQL Stored Procedures SAP ERP RPA SQL Data Warehouse SharePoint Excel Regression Analysis Visio Data Governance Snowflake Apache Spark Google BigQuery Wireframing UI/UX User Stories SDLC Jira SCRUM Salesforce HubSpot Azure REST APIs HTML JavaScript CSS Caching
Report this Profile?