Anna Chang Email & Phone Number

Dallas, TX, US

Lewisville TX, TX, US

Lewisville TX, TX, US

• Led the development of the EEHORIZON platform, integrating data science, GIS applications, and machine learning techniques for power system analysis and energy markets.
• Built and managed databases to support data storage, retrieval, and analysis, ensuring optimal performance and security.
• Worked closely with cross-functional teams to support process automation, fostering effective teamwork and communication to achieve project goals.

Lewisville TX, TX, US

• Assist in the application of advanced data science and machine learning techniques to various aspects of power system analysis and energy markets.
• Development of predictive analytic tools associated with market nodal pricing trends across various centrally dispatched SCED-based ISO/RTO energy markets in the US.
• Development of data visualization tools associated with nodal LMPs, power system generation, load, transmission system outages and other relevant system data identified as key parameters.
• Development of GIS applications, dashboards for the Energy applied areas, including mapping GIS points for the Electrical Substations and Transmission lines in US.

Richardson, Texas, US

• Working on site at Oncor Electric Delivery Inc. to create Common Data Model database based on different databases and write data definition language (DDL) for the required equipment to create tables in database Schema.
• Analyzing 2 different databases’ about 100 thousands data by comparing the difference information, and identify the attributes need to be worked on.
• Generating Target Table Mapping by Excel and Pivot table to quickly summarize datasets.
• Populating daily data, and architecting, designing, and developing ETL process.
• Working in multi-disciplinary and cross-functional team to translate business objectives into CDM design.

• Used Python and github to develop a linear regression model by using sklearn, Numpy by using last 6 years records and produced dashboards by using Matplotlib, tried to figure out the correlations between features and.
• Analyzed and managed company's database on SQL server 2014, programmed SQL codes to execute ETL process efficiently, which automatically extracted and blended daily data from each of 4 branch offices (300 users) to the.
• Optimized performance of KVM resulting in 15% improvement of CPU performance, 10% in desk IO performance and 20% in network optimization.
• Assisted IT manager in managing the company's working system. Produced marketing presentations in PowerPoint.

• Assembled 3 databases with 10,000+ data to meet business requirements
• Optimized data delivery process by using Python and accomplished automating manual processes with VS and python.
• Used SQL Server Studio to help with optimal extraction, transformation, and loading of data from various data sources like Excel, PDF, etc.
• Developed analytical tools and programs like predictive modeling by Python and conduct complex data analysis and report on results by Tableau and Python.

Master Of Engineering - Meng, Engineering/Industrial Management

B.Sc, Software Engineering