John Nguyen

Experience

• 

  Teledyne Technologies Incorporated (Storm Products)

  Jan 1998 - Jan 2002

  Design Drafter
• 

  TCF Bank

  Jan 2000 - Jan 2004

  Supervisor
• 

  Kendall College

  May 2004 - Aug 2007

  IT Support

  *Building, maintaining and deploying Windows images*Maintain hardware and software assets*Assist users with hardware and software issues

• 

  Anixter

  Aug 2007 - Nov 2019

  • A results driven software professional with 10+ years of progressively responsible experience in Data Analysis, Design, Implementation, Administration and Support of Business Intelligence, OLTP (Batch Processing, Online Processing), ETL, Data warehousing, DBMS and Data Modeling using SQL Server 2016/2012/2008/2005, SSIS, SSRS, SSAS and Power BI• Implemented SQL Server security features - Row-Level Security (RLS), Always Encrypted, and Dynamic Data Masking (DDM)• Used SQL stored procedures to extract data from multiple systems, transforms and load data into a data warehousing environment, testing performance and troubleshooting before goes live• Experience in creating Views, Constraints, Triggers, Joins, Temp Table, Table Variable, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation• Experience in configuration and maintain Gateway, Report Manager and Report Server for SSRS, Auto Deployed and Scheduled the Reports in Report Manager • Created system for capturing, reporting, and correcting error data optimizing queries and implements proper indexing for the data retrieval process more efficient• Experience in Ad-hoc reports, data driven subscription reports by using Report Builder• Experience in developing Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week• Conducted code walkthroughs and reviewed peer code and documentation• Gathered requirements and designed data warehouse and data mart entities• Analyzed data and provided on-call support to production system to resolve issues• Converted and created web queries report on internal webpages from ASP to ASP.NETAccounts Payable System Programmer (2007-2009)• Programmed window forms using VBA• Created automated reports using MS Access• Provided IT support, added and removed users from ODOC system, and implemented user permissions Show less

  • Enterprise Data Warehousing and Reporting

    Aug 2007 - Nov 2019

  • Enterprise Data Warehousing and Reporting

    Aug 2007 - May 2019
• 

  International Fellowship of Christians and Jews

  Apr 2020 - Aug 2020

  Technical Business/Data Analyst Administration

  • Analyzed the organization's database needs and developed a long-term strategy for data storage• Established and maintained policies and procedures related to data security and integrity and monitors and limited database access as needed• Oversaw the design, maintenance and implementation of systems that manage an internal database• Managed subordinate staff in the day-to-day performance of their jobs and ensured project/department milestones/goals are met• Segmented data into groups using SSIS Show less

• 

  UScellular

  Mar 2021 - Aug 2022

  Data Integration Developer

  • Designing and maintaining the interfaces and data extracts for business processes based on business requirements• Defines, documents, develops, improves, and maintains Software application modules in Informatica/Talend, ksh, Perl, SQL • Performs design validation, reconciliation, and error handling for all code• Understands and executes release management and change management processes for changes to applications• Identifies fixes and resolves application issues and code defects• Production support activities involve the identification, troubleshooting, and resolution of application issues and code defects• Works with source system developers and business owners to define data extraction methodologies• Works with Data Modelers to develop data warehouse models, designs specifications, metadata processes, and documentation• Handles individual workload and delivers to the agreed-upon project landmarks• Experience in any DevSecOps Toolchain products (Jira, Jenkins, Confluence, GitHub, JFrog Artifactory, Automic CDA (Continuous Delivery Automation))• Participate in 24/7 on-call support rotation Show less

• 

  MAU Workforce Solutions

  Aug 2022 - Jan 2024

  Senior Business Intelligence Developer

  • Built and implemented an ETL process to efficiently move data from Microsoft databases and Bullhorn into the Domo platform for analysis and reporting.• Developed and delivered data-driven solutions including reports, ad-hoc queries, visualizations, and interactive dashboards within the Domo environment.• Collaborated with stakeholders to understand and document their data needs, translating them into detailed Business Requirements Documents (BRDs) for accounting and HR systems.• Utilized Smartsheet to track project progress, providing real-time status updates to stakeholders and leadership.• Documented detailed processes for all project implementations to ensure consistency and maintainability. Show less

• 

  AT-PAC

  Jan 2024 - now

  Technical Business Analyst & Power BI Developer

  • Designed and implemented an Azure Data Factory pipeline to automate daily ETL processes, resulting in a 40% reduction in data latency and improved data quality• Developed and deployed a robust ETL solution using Azure Data Factory to integrate data from multiple sources, enabling real-time business intelligence and improved decision-making• Designed and implemented an ETL process to move data from an Azure database to a data warehouse for Power BI consumption, leveraging Logic Apps for efficient data movement and staging• Developed and deployed interactive reports, dashboards, and visualizations using Power BI within a multi-workspace environment to support business decision-making• Gathered, analyzed, and documented detailed business requirements for the Hi-Vis Application in the form of BRDs, ensuring alignment between business needs and technical solutions• Managed project tasks and provided real-time status updates to stakeholders using the Zendesk ticketing system. Documented detailed processes for all implementations to ensure reproducibility and knowledge transfer Show less