AeroLeads people directory · profile
Ron Lu Email & Phone Number
Self Employed
at
RL Data Management
LinkedIn matched
✓ Verified May 2026
3 data sources
Profile completeness 100%
Who is Ron Lu? Overview
A concise factual answer block for searchers comparing this professional profile.
Quick answer
Ron Lu is listed as Self Employed at RL Data Management, based in Mason, Ohio, United States. AeroLeads shows a matched LinkedIn profile for Ron Lu.
Ron Lu previously worked as Sr. Database Developer/Data Architect at Veritas Automata/Apex Supply Chain and Sr. Database Developer/DBA/Data Architect at Apex Supply Chain Technologies, Llc. Ron Lu holds Master Of Science (Ms), Computer Science from University Of Cincinnati.
Company email context
Email format at RL Data Management
This section adds company-level context without repeating Ron Lu's masked contact details.
RL Data Management
Review company-level records connected to Ron Lu before choosing the right outreach path.
Profile bio
About Ron Lu
Created many operational databases (SQL Server, MySQL, Postgres, Oracle) as well as a handful of data warehouses(star schema/dimensional model)Many performance tuning success stories. A go-to guy when it comes to performance tuning of ad-hoc query or a stored procedure or an ETL process.If your database (OLTP/OLAP) performance is not optimal, or ETL/Stored Procedure is too slow, or report on website or any data visualization tool times out, then you may need my help in one or more of below things. 1. Make sure the Schema design is correct with necessary Indexes/Partitions/... 2. Make sure if your ETL can do incremental loading3. Make sure your query used the correct algorithm it entails, this is especially in aggregation4. Find the most expensive query; Sometime CTE is better while other times Temp table needed.5. Check Query statistics and/or Index by reviewing the histogram and Execution plan;6. Check to see if you have Joins that you do not need or Indexes that never kicks in7. Out of Date Plan Cache or Transactional Deadlock8. ...With correct OLAP, every report should render in seconds instead of timeout.Strong communication/presentation skills, business analysis skills and project management skillsOutstanding Team Member Award at Cincinnati Children's Hospital on 6/15/20Skills: GitLab CICD, Database and Data Warehouse Architect, Performance Tuning, Kafka streaming, ETL, Microsoft BI Stack (SSIS/PolyBase, SSRS, SSAS Cubes), C# .Net, Cloud computing, PaaS, SaaS, Data Lakes, Node.js, HDFS, Business Objects, Databases Design, Data Warehousing, Star Schema/Dimensional Data Modeling, Stored Procedures and Query Tunning. Particularly interested in Microsoft BI stack and WCF Web Service and Web API, Predictive Analysis/Data Mining in SSAS, R in SQL
Listed skills include .Net, Sql Server, Software Design, Data Warehousing, and 32 others.
Current workplace
Ron Lu's current company
Company context helps verify the profile and gives searchers a useful next step.
10 roles · 27 years
Ron Lu work experience
A career timeline built from the work history available for this profile.
Sr. Database Developer/Data Architect
- Moved bitbucket repository to Gitlab and used Gitlab CICD Pipeline calling flyway to migrate Postgres changes to the database instance residing on the AWS cloud
- Redesigned Mobile UI (MUI/CnC) database schema to combine more than 55 schemas (MySQL and Postgres) into one and developed SSIS packages to incrementally load data from all of the existing production servers into this.
Jun 2021 - Sep 2023
Sr. Database Developer/Dba/Data Architect
Created a Datamart with order/dispense data from events with Json format emitted from Blockchain application. PostgreSQL Triggers and functions are used to parse the events and the individual data fields from the event are inserted into the corresponding table columns. Created Stored procedures for Order/Pickup dashboard.Performance Tuning, Script.
Aug 2018 - Jun 2021
Data Architect (Business Intelligence Solutions)
1. Successfully created data warehouse(dimensional model) and loaded existing schema data from Grady database to the new schema. The new schema can be easily adapted to any of the databases such as Grady, LCMC, Chicago, and St Lukes and so on;2. Created some SSAS cubes against St Lukes database;3. Successfully redesigned and re-implemented some stored.
Aug 2017 - Jul 2018
Business Intelligence & Data Warehousing
Re-designed and implemented an existing complicated HealthCare Insurance Member Stratification and Population Stream project. Member Stratification used to take 6 hours to finish, now it finished in about 6 minutes; Population Stream used to take 3 hours to finish, now it finished in about 14 minutes. CAMS Minimum Datasets project design and implementation.
Jan 2016 - Aug 2017
Business Intelligence Consultant
Created data marts in Star Schema/Dimensional Model and used SSIS as ETL tool to feed the data marts.Developed SSAS cubes against the data marts (expecting to expand this project)Developed Health Provider Incentive Reports and Incentive Program Management reports hosted in MVC.
Jun 2015 - Dec 2015
Senior Software Developer
Developed new features and maintain clinical tracking study management and Medpace intranet. Developed ETL project in SSIS to integrate data files from different sources involving metadata tables detailing the file type and load methods. Developed outlook addin with form regions to connect to SQL Server database
Jun 2014 - Jun 2015
Director
Leap American, Llc
Led a team to have successfully created the Music Recommendation System using Web Services, Silverlight and SQL Server;Implemented the music recommendation algorithm in C# in a much efficient way using Math functions instead of old way of using classes and objects, which is very problematic in both development and performance.
May 2012 - Sep 2014
Application Development, Anderson Center
Developed some data models using Dimensional Data Modeling (Star schema) and used ETL of SSIS for data warehouses. Developed Anesthesia and Radiology Data Warehouse with Business Objects Universes and (WEBI) Reports. It replaced third party software and saved hospital a lot of annual license fee. Developed FluVaccine datamart and Family Experience datamart.
Jun 2008 - Jun 2014
Senior Software Engineer
Computer Associates, Inc
Unicenter TNG and TND development. Responsible for database (Ingres, Sybase, DB2 and Informix) Agents and System agent on various platforms like Windows, Solaris Unix, Linux, AIX, DGUX, and NCR Lead IPV6 mibbrowser development and implementations on Windows for system agent.
1999 - 2008
~9 yrs
4 education records
Ron Lu education
Master Of Science (Ms), Computer Science
University Of Cincinnati
Master'S Degree, Mathematics
University Of Cincinnati
Dimensional Modeling-Data Warehouse
Kimball University
Mathematics
East China Normal University
FAQ
Frequently asked questions about Ron Lu
Quick answers generated from the profile data available on this page.
What company does Ron Lu work for?
Ron Lu works for RL Data Management.
What is Ron Lu's role at RL Data Management?
Ron Lu is listed as Self Employed at RL Data Management.
Where is Ron Lu based?
Ron Lu is based in Mason, Ohio, United States while working with RL Data Management.
What companies has Ron Lu worked for?
Ron Lu has worked for Rl Data Management, Veritas Automata/Apex Supply Chain, Apex Supply Chain Technologies, Llc, Germane Solutions, and Caresource Management.
How can I contact Ron Lu?
You can use AeroLeads to view verified contact signals for Ron Lu at RL Data Management, including work email, phone, and LinkedIn data when available.
What schools did Ron Lu attend?
Ron Lu holds Master Of Science (Ms), Computer Science from University Of Cincinnati.
What skills is Ron Lu known for?
Ron Lu is listed with skills including .Net, Sql Server, Software Design, Data Warehousing, Sdlc, Linux, Ssis, and Html 5.
Find 750M verified contacts
Search by job title, company, industry, location, and seniority. Export verified B2B contact data when you need it.
Start free trial