Dennis Lo
System Developer/ Administrator at Parfait Lingerie- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Professional working proficiency
-
Chinese Native or bilingual proficiency
-
Cantonese Native or bilingual proficiency
Topline Score
Bio
Credentials
-
Fundamental of the databricks lakehouse platform
DatabricksFeb, 2023- Nov, 2024
Experience
-
Parfait Lingerie
-
United States
-
Retail Apparel and Fashion
-
1 - 100 Employee
-
System Developer/ Administrator
-
Jul 2012 - Present
• Led the migration of an outdated system to the Azure application service, providing thorough documentation of data flow. • Developed PHP applications for internal company websites to meet specific business needs, including loading customer sales orders from FTP into an importable format for Netsuite. • Constructed an ETL pipeline using MSSQL on VM, Netsuite ODBC, Azure Data Factory, and Logic App for database, data exchange service, and web applications on Azure. • Designed VBA Excel applications to enhance company efficiency and workflow, such as an inventory scanning system that achieved 99% accuracy in the order process. Show less
-
-
-
California State University Long Beach, College of Engineering
-
United States
-
Higher Education
-
1 - 100 Employee
-
Research Assistant (App Developer)
-
Aug 2022 - Mar 2023
• Lead the development of a Swift-based iPad application utilizing the Scosche heart rate monitor SDK and SpriteKit package to create an innovative horizontal moving heart rate visualization application. • Conducted user studies for a tablet-based heart rate visualization app geared towards promoting sustained physical activity among individuals with disabilities. • Expertly employed Azure DataBrick, Google BigQuery, and Tableau to perform data analysis and generate visual reports. • Lead the development of a Swift-based iPad application utilizing the Scosche heart rate monitor SDK and SpriteKit package to create an innovative horizontal moving heart rate visualization application. • Conducted user studies for a tablet-based heart rate visualization app geared towards promoting sustained physical activity among individuals with disabilities. • Expertly employed Azure DataBrick, Google BigQuery, and Tableau to perform data analysis and generate visual reports.
-
-
-
TechStyleOS
-
United States
-
Apparel & Fashion
-
500 - 600 Employee
-
Financial Accounting Data Analyst
-
Apr 2020 - Oct 2022
• Refactor the month-end reporting code base by migrating and optimizing the logic from MSSQL to Snowflake SQL. • Reduced data-to-report layers by transforming Excel reports into transactional-based Tableau reports with historical data back up support, resulting in a 90% reduction in research time for accounting team requests from auditors. Empowering accounting team to be self-sufficient with data pull, while also decreasing the reporting time from 2 days to 2 hours. • Developed credit balances validation process across multiple systems, improving efficiency by performing ETL between AWS S3 and Snowflake. Reconciliation process improved from a week to an hour. • Managed accounting audit requests for data and explanation. Designed and deployed code to reduce response time from half a day to within an hour. Show less
-
-
-
Molina Healthcare
-
United States
-
Hospitals and Health Care
-
700 & Above Employee
-
Data Analyst (Finance/Accounting)
-
Apr 2018 - Apr 2020
• Managed monthly accounting reporting using MSSQL and Excel. • Developed a Python script to extract information from the state's EDI files for reporting purposes, utilizing Selenium for web scraping, raw data processing in Excel, and data extraction. • Maintained stored procedures, reports, and rates for updates received from the state. • Designed and implemented custom Excel VBA applications to improve business processes. • Managed monthly accounting reporting using MSSQL and Excel. • Developed a Python script to extract information from the state's EDI files for reporting purposes, utilizing Selenium for web scraping, raw data processing in Excel, and data extraction. • Maintained stored procedures, reports, and rates for updates received from the state. • Designed and implemented custom Excel VBA applications to improve business processes.
-
-
-
ICC - A Structured Cabling Solutions Company
-
United States
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Data Analyst
-
Jan 2016 - Apr 2018
• Led data migration and training during the company's migration to a new ERP system, Epicor Prophet 21. • Generated insightful reports using Power BI and SQL, including GIS and sales data, to improve business processes and aid in decision-making. • Developed a B2B portal and ETL using the company's ERP system for inventory and pricing management. • Designed MSSQL tables to connect with Bigcommerce API for efficient data updating using PHP. • Managed company website data, including Google AdWords, Analytics, and Merchant Center. Show less
-
-
-
East Los Angeles College
-
Higher Education
-
400 - 500 Employee
-
Student assistant
-
Jul 2009 - Jul 2012
Used DEC and Access to update applied student information • Provided school service, pick up calls, add and drop class, process applications • Held school orientation Used DEC and Access to update applied student information • Provided school service, pick up calls, add and drop class, process applications • Held school orientation
-
-
Education
-
2019 - 2023
California State University Long Beach, College of Engineering
Master of Engineering - MEng, Computer Science -
2012 - 2015
California State University-Los Angeles
Bachelor of Business Administration (B.B.A.), Computer and Information Sciences, General -
2009 - 2012
East Los Angeles College
Associate of Science (A.S.), Business Administration and Management, General
Community
