Shirley (Qing) Gu DATA ANALYST
adns9i@r.postjobfree.com 908-***-**** Remote work or Minneapolis, MN Shirley (Qing) Gu LinkedIn
SUMMARY
Highly organized and talented data specialist with 10+ years of experience with a passion for managing, analyzing, and visualizing data in a team environment. Proven experience leading businesses in maintaining their data integrity, utilizing small and large datasets to create value and provide insights through data analysis, effective communication, and presentation. Strong attention to detail and problem-solving skills with extensive background in supporting IT operations.
SKILLS
LANGUAGES: SQL, Python (Pandas, NumPy)
DATA COLLECTION: CSV, Excel, Access, SQL or Oracle Database, XML, JSON
DATA VISUALIZATION: MatplotLib, Tableau, Power BI, Advanced Excel
OTHERS: System Administration, Database Design and Management, Problem-solving & troubleshooting, Teamwork & collaboration, Project management
PROJECTS
Sales/Marketing and Health Insurance Datasets analysis Dec. 2020 – Mar. 2021
Gathered and cleaned the data from Kaggle site; Analyzed and visualized dataset using Advanced Excel function, Power BI and Python.
Conducted the descriptive and inferential statistical analysis using Python, created slide decks to present and communicate the insights.
Medicare dataset analysis Apr. 2021 - Current
Gathered and extract the data from Google Cloud by using the big SQL query technology, combined the yearly datasets into one master dataset for analysis.
Utilize Excel Pivot, Tableau, Power BI and Python to analyze and visualized the data.
Present the insights and action items for technical and non-technical audiences by using the slide decks with different focus.
EMPLOYMENT
New Jersey Manufacturers Insurance (NJM), Data Analyst/ Sr. System Admin, Trenton, NJ Jan. 2013 - Sep. 2020
Provided expertise in data storage structures for multiple systems. Gathered data from the Financials and planning systems using SQL. Validated, formatted, and cleansed data using Advanced Excel functions.
Translated numbers and facts of data using visualization tools to provide insights and influence strategic business decisions. The company was able to reduce the labor cost near 20% in year 2019 by adjusting the employee/contract ratio based on project demand.
An expert in systems administration, maintained 99.8% of uptime of critical Financial system. And effectively engaged with business, IT, and vendors to troubleshoot issues related to the database, application, and data.
Led and participated multiple PeopleSoft Financial application/PeopleTools and database/server upgrade projects.
Supported yearly audits by using SQL to gather relevant data and performed adjustments based on input from the internal auditing team.
Reviewed weekly data visualization reports to share department insights with leadership.
Guest Supply – A Sysco Company, Sr. Database & PeopleSoft Administrator, Princeton, NJ Jan. 2007 - Jan. 2013
Managed various corporate-wide production application databases. Planned, installed, configured, patched, and tuned Oracle server.
Participated and led PeopleSoft Financial application and Oracle Database upgrade projects.
Gathered and queried data from the financial system by utilizing SQL to create reports and analyze the data to provide insights for business.
Supported IT acquisition and knowledge transfer to ensure smooth transition to overseas team.
Engelhard (BASF), Oracle DBA, Iselin, NJ Aug. 2001 - Jan. 2007
Maintained and Supported PeopleSoft HRMS database. Participated and planned PeopleSoft database and application upgrade.
Generated reports by utilizing SQL and PL/SQL based on business requirement.
Created and executed backup and recovery SOP.
EDUCATION & CERTIFICATION
Springboard
6 month intensive course in data analytics, Structured Thinking, Financial analysis, Python, SQL, Advanced Excel functions. Capstone Projects.
Oracle Certified Professional (OCP)
6 month intensive courses in Oracle database administration, SQL& PL/SQL, Backup & recovery and database security.
FuDan University (Medical school)
M.D. in Basic Medicine