Data Analyst Python
Resume:
Michelle Chow
***********@*****.***
https://www.linkedin.com/in/michelle-chow-a394b9159 Work Authorization: US Citizen
EDUCATION
The University of Texas at Dallas, Texas May 2020
Information Technology Systems (Bachelor of Science) GPA: 3.81 SKILLS
• Languages: T-SQL, Python, JAVA, R.
• DBMS: Oracle, MS SQL Server.
• Tools: Tableau, MS Visual Studio (ETL, SSAS, SSRS), Lucidchart, Power BI, Microsoft SSMS.
• Microsoft Suites.
Academic Projects
• Created SQL queries to pull data for Folly Theater campaigns’ data and conducted A/B tests to compared different campaigns’ effectiveness.
• Helped Christian Community Action (CCA) member acquisition department to design a new database with sophisticated customer-related entities. Created ERD, primary key, foreign key, and then created the CTAS T- SQL statements to implement the tables.
• Sharpened python programming and wrote a whole script for a restaurant food order service. Related EXPERIENCE
Business Analyst internship Community Foundation of Texas Jan 2020 – May 2020 Developing a scorecard and dashboard for a group of 5 local communities so they can describe the characteristics of the community and create a visual measurement stick for change efforts, identify common metrics, the sources for those data, and metrics that are specific to particular communities based on their characteristics and focus areas. The work will include the following key accomplishments:
• Develop a formal set of requirements for the project.
• Provide a recommendation on the software tool to build the dashboards.
• Identify key common metrics and community specific metrics along with their sources.
• Develop a dashboard to display the key metrics that have been identified.
• Provide an implementation plan along with ongoing support requirements. Data Analyst internship Ping An Insurance Company (Guangzhou, China) May 2019 - Sep 2019
• Pulled data from various data sources to generate ad-hoc reports and operational reports. T-SQL scripts were developed in SQL server. Reports included cycle time and inventory monitoring in retail, group, government aid plans and claims.
• Built various operational reports: included data ETL, heavy SQL coding, and advanced tableau visualization techniques.
• Explored impact factors for Group, Retail and Government aided plans’ claim and inquires volumes, and created an inventory prediction model utilizing these findings. AWARDS
• Phi Theta Kappa Scholarship 2017 – 2020
• Dean’s list
• Comet Transfer Scholarship 2018 – 2020
Contact this candidate