Chenlu Jiang Email and Phone Number
Chenlu Jiang phone numbers
Data Engineer
Department For Education, South Australia
View- Website:
- education.sa.gov.au
- Employees:
- 1963
-
Data EngineerDepartment For Education, South Australia Nov 2022 - PresentAdelaide, South Australia, Australia -
Data Analytics InternChina Telecom Corporation Limited Aug 2021 - Nov 2021Hangzhou, Zhejiang, China• Written SQL scripts of launching new tables for the specific customer needs analysis or optimized existed scripts for adding customer portraits labels(columns) into Vertica Database and capsuled SQL scripts into Perl scripts for DBA to test and update on ETL platform• Written prepositional and postpositional dependency for launched scripts, and updated new labels to Big Data Labels Management Platform and finished the data audit• Updated daily/weekly/monthly data to the Vertica database through DbVisualizer client program via SQL• Written SQL scripts and capsuled into Perl scripts to fetch different themes data (ex:5G) for specific analysis• Used Impala component, and written SQL and HiveSQL scripts to fetch data from Hive and Vertica databases to build models for targeting, suspending service and analyzing telecommunication fraud users -
Teaching AssistantBrandeis International Business School Aug 2018 - May 2019Waltham, Massachusetts, The United StatesTeaching Assistant of Marketing Analytics -
Teaching AssistantBrandeis International Business School Aug 2018 - Oct 2018Waltham, Massachusetts, The United StatesTeaching Assistant of Big Data I & II -
Data AnalystHikvision Jun 2018 - Aug 2018Hangzhou, Zhejiang, China• Collected and cleaned the finance income and spending data of 2000 regions and 300 cities in China, analyzed it exploratorily, calculated and prepared the potential variables for modelling • Selected and normalized the variables from the dataset, built and optimized different clustering models in R using algorithms including k-means, DBSCAN and hierarchical clustering• Determined the best algorithm for a score which measures each region and city’s comprehensive economic power, and used the score as the reference to select the best model• Found the best cluster model in which the different regions and cities were assigned into clusters with different financial risk levels, the model helped the company to decide whether to invest projects in certain areas and might help to save millions of Yuan -
Coporate Finance Department InternChina Citic Bank Feb 2017 - Jun 2017Hangzhou, Zhejiang, China• Analyzed operation data, built charts and wrote the operation analysis report monthly, presented the results and conclusions of the operation analysis in the department meeting• Analyzed the data and built the model for new rules of bankers’ performance assessment and salary rating• Collected and analyzed operation data of local branches and competitors, wrote research reports
Chenlu Jiang Skills
Chenlu Jiang Education Details
-
Business Intelligence And Data Analytics -
3.86/4(Graduating With Distinction)
Frequently Asked Questions about Chenlu Jiang
What company does Chenlu Jiang work for?
Chenlu Jiang works for Department For Education, South Australia
What is Chenlu Jiang's role at the current company?
Chenlu Jiang's current role is Data Engineer, Business Intelligence & Data Analytics, Carnegie Mellon University Alumni, Brandeis Alumni.
What is Chenlu Jiang's direct phone number?
Chenlu Jiang's direct phone number is +178135*****
What schools did Chenlu Jiang attend?
Chenlu Jiang attended Carnegie Mellon University, Brandeis University.
What skills is Chenlu Jiang known for?
Chenlu Jiang has skills like R, Stata, Microsoft Excel, Java, Python.
Who are Chenlu Jiang's colleagues?
Chenlu Jiang's colleagues are Carlos Nasese, Lisa Drabsch, Angela Bang, Kathryn Bruggemann, Rachel Scheuboeck, Julie-Anne Byrnes, Lauren Trenerry.
Not the Chenlu Jiang you were looking for?
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial