Learn Data Skills
Beta
Henmi Ng

Henmi Ng

Certified

Business Intelligence Analyst

RTI International

Technologies

My Portfolio Highlights

My New Track

Associate Data Analyst in SQL (previously Data Analyst in SQL)

My New Course

PostgreSQL Summary Stats and Window Functions

My New Track

SQL Fundamentals

My New Track

Associate Data Analyst in SQL (previously Data Analyst in SQL)

Analytics ninja, mastering the art of extracting insights from chaos.

My Work

Take a look at my latest work.

course

Case Study: Analyzing Customer Churn in Tableau

course

Sampling in Python

course

Case Study: Analyzing Job Market Data in Tableau

course

Case Study: Analyzing Customer Churn in Tableau

My Certifications

These are the industry credentials that I’ve earned.

Data Analyst Associate

Data Analyst Associate

Other Certificates

Microsoft Analyzing and Visualizing Data in Excel

NC State University Data Communicator

Microsoft Power BI Data Analyst Associate

Microsoft Azure Data Fundamentals

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Intermediate SQL
Intermediate Python

My Work Experience

Where I've interned and worked during my career.

RTI International | Aug 2022 - Present

Enterprise Reporting & Analytics Manager

• Led a team of 4 Power BI Developers/Admin to create an enterprise reporting solution for 3000+ report consumers (C-suite to business analyst) and citizen developers with a core focus on data governance, compliance, and UI/UX centric design. • Consolidate complex business needs from existing legacy reports into Power BI reports with enhanced analytical drill-throughs and cross-filter functions. • Established RLS and OLS for HR-sensitive data and proposal confidential information in complex data models. • Experienced with Azure Synapse, AWS, Salesforce, and Custom API Connectors for report building. • Administered Power BI Pro/Premium environments, gateways, and dataflows for RTI Azure tenant.
Show More

RTI International | Mar 2022 - Aug 2022

Senior Power BI Developer

• Collaborated with RTI Marketing, Compliance, and Business Development to develop dashboards for various data sources including but not limited to: AWS, Google Analytics, Demand base, IBM COGNOS, Bloomberg Government, USASpending.gov, Salesforce and OnBase. • Performed ETL in SSMS and Power Query to load data into consolidated Power BI Reports. • Created security groups and proper governance and access are provided to all levels of audience. • Utilized DAX to create custom measures and calculated columns for analysis. • Conducted training and created training documentation on all reports and metrics.

RTI International | Jan 2019 - Mar 2022

Proposal Intelligence Analyst III

• Increase RTI’s win rate on high-valued opportunities by providing impactful analyses on competitors, external/internal project spending, subcontractors, and agency funding landscapes for high-level stakeholders in months to year- long captures. • Consolidate intricate spending data from external/internal databases into actionable insights to reduce uncertainty for decision-makers. • Assist Strategic Account Executives in locating opportunities and designing PowerBI dashboards for agency spending. • Participate in institute-wide initiatives that impact approval levels, Subcontractors Diversity & Inclusion, and RTI systems.

RTI International | Jun 2018 - Jan 2019

Financial Analyst

and foundation clienteles for a total awarded portfolio value of $59M (55% Win Rate). • Submitted over 155 proposals and add-ons in 1 year while learning the role of a Proposal Intelligence Analyst. • Facilitated Green Team meetings for involved RTI stakeholders on all proposals valued >$5M. • Innovated and created new workflows for processing T&M proposals that RTI is still using today for PLC categories and mapping.

Outdoor Equipped | Dec 2017 - May 2018

Data Analyst

• Assist in the development of key purchasing strategies for meeting growth goals for multiple brands across all four apparel segments through data analysis, financial forecasting and risk assessment algorithms on Microsoft Excel • Increased monthly revenue by 25% for OE’s key supplier through FBA weekly purchases and prebooks of $100,000+ and collaboration with VP of E- commerce and CTO/Founder • Analyze and compile multiple data sources to create accurate projection models for budget optimization in growing key supplier from $5,000,000 in annual revenue to $15,000,000 • Create actionable business intelligence reports with pivot charts and slicers based on sales data for segment managers and senior management

Outdoor Equipped | May 2017 - Nov 2017

Logistics Coordinator/Analyst

• Organized, trained, and led personnel to ensure that all bulk shipments (averaging in weekly value of $150,000) that arrived at the North Carolina warehouse were efficiently cross-docked to Amazon warehouses across the U.S. • Redesigned and improved on existing cross-docking procedures for the purpose of reducing lead time to less than 3 days for increasing overall operational efficiency • Utilized Amazon web portals and software to organize bulk shipments and prebooks for operational efficiency to Amazon • Utilized Google SketchUp to design and maximize warehouse space for storing inventory value of $4,000,000 and future expansion • Compared and compiled software solutions for inventory management to improve overall operational efficiency and reduce annual expenditure • General IT assistance for PC, MAC, and security system

Outdoor Equipped | Jan 2017 - Apr 2017

Purchase Analyst/Brand Manager

• Interpreted data from compiled demand data and various other in-house analytical programs to assess opportunities and risks for making purchase orders to major retailers such as: Nike, Asics, Mizuno, Timberland and many others. • Established and maintained relationships with various sales representatives of major sports and outdoors brands. • Assisted segment managers and VP of E-Commerce with in-depth analysis on brand-specific breakdown for bestselling product trends, rogue selling threats and profitability for specific product makeup and prebooks. • Provided creative solutions and imagery, for supplier acquisition and CEO, for trade show presentation with utilization of Prezi and Pages

J.W. Hunter, Inc. | Jun 2012 - Aug 2012

Assistant Leasing Agent

During my time with J.W. Hunter, I have had the pleasure of working with the V.P. of the company and while working under her guidance, I had successfully leased 10 one-year contracts for the company.

My Education

Take a look at my formal education

Certification in Data Analytics University of Pennsylvania | 2021
Bachelor of Science - BS, Finance, GeneralUniversity of North Carolina at Wilmington | 2016

About Me

Henmi Ng

Henmi is a seasoned data analyst with over 7 years of experience in finance and IT. With a background in finance and data analytics, he is currently looking for data analytics/data scientist roles.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free