Diego Li
Principal Solutions Architect at Aimpoint Digital- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Full professional proficiency
-
Chinese Native or bilingual proficiency
-
Cantonese Native or bilingual proficiency
-
Spanish Elementary proficiency
Topline Score
Bio
Thom Jareczek
As a mentor, I provide ideas, insight and moral support as Diego pursues his career objectives. His resume speaks for itself. As a person, Diego is equally as impressive. He is both goal-oriented and coachable. During conversations, he is engaged and asks relevant questions. Action plans Diego develops are specific, realistic and methodical. His ability to handle adversity appears to be a result of his strong work ethic and positive attitude. With Diego's respectful disposition, it is easy to talk with him. Whether you are a recruiter, employer or just want to network, I suggest you invite Diego for coffee or to your office to see if he's everything I describe. The combination of Diego's abilities and attitude truly makes it a pleasure to work with him on his professional journey.
Thom Jareczek
As a mentor, I provide ideas, insight and moral support as Diego pursues his career objectives. His resume speaks for itself. As a person, Diego is equally as impressive. He is both goal-oriented and coachable. During conversations, he is engaged and asks relevant questions. Action plans Diego develops are specific, realistic and methodical. His ability to handle adversity appears to be a result of his strong work ethic and positive attitude. With Diego's respectful disposition, it is easy to talk with him. Whether you are a recruiter, employer or just want to network, I suggest you invite Diego for coffee or to your office to see if he's everything I describe. The combination of Diego's abilities and attitude truly makes it a pleasure to work with him on his professional journey.
Thom Jareczek
As a mentor, I provide ideas, insight and moral support as Diego pursues his career objectives. His resume speaks for itself. As a person, Diego is equally as impressive. He is both goal-oriented and coachable. During conversations, he is engaged and asks relevant questions. Action plans Diego develops are specific, realistic and methodical. His ability to handle adversity appears to be a result of his strong work ethic and positive attitude. With Diego's respectful disposition, it is easy to talk with him. Whether you are a recruiter, employer or just want to network, I suggest you invite Diego for coffee or to your office to see if he's everything I describe. The combination of Diego's abilities and attitude truly makes it a pleasure to work with him on his professional journey.
Thom Jareczek
As a mentor, I provide ideas, insight and moral support as Diego pursues his career objectives. His resume speaks for itself. As a person, Diego is equally as impressive. He is both goal-oriented and coachable. During conversations, he is engaged and asks relevant questions. Action plans Diego develops are specific, realistic and methodical. His ability to handle adversity appears to be a result of his strong work ethic and positive attitude. With Diego's respectful disposition, it is easy to talk with him. Whether you are a recruiter, employer or just want to network, I suggest you invite Diego for coffee or to your office to see if he's everything I describe. The combination of Diego's abilities and attitude truly makes it a pleasure to work with him on his professional journey.
Credentials
-
Databricks Certified Associate Developer for Apache Spark 3.0
DatabricksNov, 2021- Nov, 2024 -
PCAP – Certified Associate in Python Programming
Python InstituteOct, 2021- Nov, 2024 -
SAS-UTD Graduate Certificate in Data Mining and Business Intelligence
Naveen Jindal School of Management, UT DallasJan, 2016- Nov, 2024 -
edX Honor Code Certificate for Introduction to Computer Science and Programming Using Python
edXJan, 2016- Nov, 2024 -
Senior Data Scientist (SDS™)
Data Science Council of America (DASCA)Jan, 2022- Nov, 2024 -
AWS Certified Machine Learning – Specialty
Amazon Web Services (AWS)Dec, 2021- Nov, 2024 -
dbt Certified Developer
dbt LabsAug, 2022- Nov, 2024 -
dbt Fundamentals
dbt LabsJul, 2022- Nov, 2024 -
SnowPro Core Certification
SnowflakeNov, 2021- Nov, 2024 -
Alteryx Designer Advanced Certification
AlteryxAug, 2021- Nov, 2024 -
Alteryx Designer Core Certification
AlteryxAug, 2021- Nov, 2024 -
Tableau Desktop Certified Associate
TableauAug, 2021- Nov, 2024 -
Microsoft Certified: Data Analyst Associate
MicrosoftJul, 2021- Nov, 2024 -
Microsoft Certified: Azure Data Engineer Associate
MicrosoftJun, 2021- Nov, 2024 -
Microsoft Certified: Azure Data Scientist Associate
MicrosoftApr, 2021- Nov, 2024
Experience
-
Aimpoint Digital
-
United States
-
Data Infrastructure and Analytics
-
1 - 100 Employee
-
Principal Solutions Architect
-
May 2022 - Present
Aimpoint Digital is a premier data and analytics consulting and solutions development firm that is made up of the very best data scientist, data engineers, management consultants and industry experts, and aims at accelerating clients’ strategic vision and initiatives. Aimpoint Digital is a premier data and analytics consulting and solutions development firm that is made up of the very best data scientist, data engineers, management consultants and industry experts, and aims at accelerating clients’ strategic vision and initiatives.
-
-
-
ClubCorp
-
United States
-
Hospitality
-
700 & Above Employee
-
Data Analysis Manager
-
Oct 2020 - May 2022
Played a primary role in transitioning the company to a data-driven environment, transforming existing data architecture to a cloud-based modern data analytics platform that can facilitate better measurement of KPIs and support the operations of the business.• Led a 4-member team to migrate existing member sales, lead scoring, and member at-risk scoring predictive models from AWS to Azure and rebuild the pipelines by utilizing Azure ML, Databricks, and other Azure services, improving the overall model accuracy by 17%, simplifying the data ingestion and model training processes, and reducing the ongoing monthly maintenance cost by 25%• Integrated prediction results into various BI platforms including Salesforce and Tableau, delivering actionable insights to the frontline 1,700+ employees across 200+ clubs• Collaborated with membership team to execute at-risk member intervention programs and target members with high at-risk scores from predictive model, reducing churn rate by 30% and improving overall member experience• Created member segmentations over 160K active members using K-means clustering based on member demographic information and spending behaviors in the past 10 years, uncovering insights about member preferences and usage patterns and helping to personalize marketing campaigns and identify new members with similar profiles• Supervised a 3-member team in migrating from Tableau to Power BI, recreating existing KPI, Member Rosters, and other dashboards by leveraging better features and following the best practices • Supported development team to continuously expand the existing traditional data warehouse to a data lakehouse encompassing greater scale of data and various data formats by leveraging Azure Blob, Data Factory, Synapse, Databricks, etc.• Reviewed data architecture and model, ensuring that data in data lakehouse can fulfill business requirements and be easily retrieved by business users without complex query and transformation
-
-
Senior Data Analyst
-
Sep 2018 - Oct 2020
Responsible for implementing and managing BI solutions that include data warehouse, data visualization, data governance, and predictive analytics. • Directed a 5-member data management team and followed CI/CD and DevOps practices to implement data warehouse solution using Azure SQL Server for the company, creating a central repository of integrated data for ad-hoc reporting needs and advanced data analytics • Defined business requirements and data logic based on information gathered from the senior management team, and documented data flows, ERDs, and data mappings for the development team• Completed automated pipelines to incorporate 300M+ records of data from various source systems: POS, Membership, Private Events, Inventory, Payroll, etc. • Wrote and executed UAT test scripts in SQL and Python to test and validate final data in the data warehouse• Implemented Tableau across 200+ clubs and managed 1,700+ users, working with IT as Tableau Admin to maintain Tableau Server deployed on AWS and apply company security policies and procedures• Collected, cleaned, and transformed data from disparate sources utilizing SQL, Python, and Alteryx, supporting full Data Analytics team to generate various financial and operational reports and dashboards• Designed, built, and tested dashboards in Tableau for multiple areas of the organization including Finance, Sales & Operations, enabling leadership and individual club operators to make data-based decisions• Functioned as a company data scientist, enhancing and maintaining predictive models on AWS Sagemaker which use ML algorithms including XGBoost, Logistic Regression, Neural Network, etc. to predict monthly member sales and member at-risk score, and delivering prediction outputs via dashboards with actionable strategies to other teams
-
-
-
New Life CFO Services, LLC
-
United States
-
Business Consulting and Services
-
1 - 100 Employee
-
Senior Business Intelligence Developer
-
Oct 2016 - Jan 2020
Main responsibilities included creating and maintaining a self-service reporting solution that employees can use to securely store clients’ financial information, deliver standardized financial reports, and monitor clients’ performance. • Coordinated with clients to accomplish real-time data connection to systems (QuickBooks, Salesforce, etc.) • Built and managed analytical SQL database, automating monthly analysis of trends, ratios, and KPI for clients • Designed dashboards to highlight strengths and weaknesses within the operational functions of the company • Developed reporting portal (website), allowing analysts to download standardized financial report package • Created time tracking system (website) to capture time and work by all staff and contractors • Maintained and updated systems, dashboards, database, file server, etc.
-
-
-
Essilor Group
-
France
-
Medical Equipment Manufacturing
-
700 & Above Employee
-
Marketing/MBA Intern
-
May 2016 - Aug 2016
• Identified trends and opportunities by evaluating the business performance of 246 customers • Proposed strategies and developed tactics to engage customers and drive sales growth by $2.5M per year • Produced final presentation and delivered project results to +100 managers and colleagues • Identified trends and opportunities by evaluating the business performance of 246 customers • Proposed strategies and developed tactics to engage customers and drive sales growth by $2.5M per year • Produced final presentation and delivered project results to +100 managers and colleagues
-
-
-
Bank of China
-
Banking
-
700 & Above Employee
-
Client Relationship Manager
-
Jun 2014 - Jul 2015
• Surveyed 20 clients daily, collecting their information and identifying top 30% potential customers • Proposed financial investment plans for clients, selling over $150,000 of financial products monthly • Planned events with 58 corporate partners to develop personal banking business among their employees • Surveyed 20 clients daily, collecting their information and identifying top 30% potential customers • Proposed financial investment plans for clients, selling over $150,000 of financial products monthly • Planned events with 58 corporate partners to develop personal banking business among their employees
-
-
-
Qujiang Baochang Building Materials Co., Ltd
-
Shaoguan, Guangdong, China
-
Market Research Intern
-
Jan 2014 - Apr 2014
• Conducted market research among four cities to launch marketing plans based on recent sales trends • Created a sales database using data from 2008 – 2013; evaluated and analyzed output to determine potential clients and review seasonal trends to optimize sales efforts and outcomes • Conducted market research among four cities to launch marketing plans based on recent sales trends • Created a sales database using data from 2008 – 2013; evaluated and analyzed output to determine potential clients and review seasonal trends to optimize sales efforts and outcomes
-
-
-
Qujiang Baochang Building Materials Co., Ltd
-
Shaoguan, Guangdong, China
-
Supply Chain Intern
-
Jul 2013 - Oct 2013
• Constructed network model for logistics system and accomplished the most feasible optimization plan • Optimized methods of product distribution, reducing logistics cost by $85,000 per month • Constructed network model for logistics system and accomplished the most feasible optimization plan • Optimized methods of product distribution, reducing logistics cost by $85,000 per month
-
-
Education
-
University of Texas at Dallas - Naveen Jindal School of Management
Master’s Degree, , MBA & Information Technology and Management