Rachel Nguyen
**** **** ****, ***** *******, TX. 75052
Email: adt155@r.postjobfree.com Mobile: 817-***-****
Career Objective
To obtain Data Analyst position that utilizes my experience in gathering, designing, building, and providing reporting data for decision support
High Lights
• Ability to extract, model, and front-end solution information from various databases using complex query statements and advanced database tools such as Toad, Rapid SQL, SAS, and MS Access.
• Ability to build visualizations for data analytics using Cognos, Power BI, and Tableau
• Ability to map out conceptual design for backend database and front end access for end users
• Able to work independently and as a member of a cross-functional and cross-geographical team
• Ability to manage time and to work with management to prioritize task when needed
using business intelligence tools and databases, applying analytics, and data reporting techniques in a complex environment required
EXPERIENCE
GM Financial - Data Analyst - Mar 2016 to Dec 2021
• As an audit staff data analyst, I was responsible for building, developing, and executing data analytics and assisting with the development of analytics skills for internal audit team members.
• Developed and supported the internal audit automated systems built in MS Access VBA for keeping tracks of auditor's data mining requests, process and work flow, staff info, and request and incidents ticket system to help prioritize requests and increased works efficiency
• Created and maintained reports and dashboard built in Cognos and PowerBI for historical data and monthly summary for management reviews
• Analyzed complex data, identified anomalies, and provided usable insight to internal and external customers
• Recommended types of analytics and procedures to apply to meet audit objectives
• Prepared documentation and analytical reports that summarize results, assumptions, and conclusions for internal audit and business
• Fulfilled data mining request by monitoring progress, managing risk, and ensuring key stakeholders are kept informed about the progress and the expected outcomes
Nurtur Health - Data Analyst - Feb 2015 to Jun 2015
• Responsible for analytical data needs. Handle complex data requests, reports, and predictive data modeling.
• Analyze health management programs including: data collection, validation and outcome measurement. May include: Financial, pharmacy, claims, provider, and member data, IRS, CMS, HHSC, HEDIS reporting
• Create and generate reports through MS-Excel, MS-Access, and SQL using Business Objects interface and direct links to core databases (ODS/EDW)
• Gather and interpret business requirements and monitor data trends to proactively identify issues
LGM Finance Companies LLC - SQL Database Admin - Jul 2012 to Mar 2014
• Designed and created relational database for the new data warehouse in SQL server.
• Created documents for database creation and data definition for meta data reference
• Created ETL process for importing complex data from large text files and excel files with limited resources
• Created SSIS packages to import data from external vendors and handle batch jobs
• Managed backups and performed routine DB performance tuning. Managed user roles and access rights.
• Troubleshoot and resolved issued related to application software such as NorthRidge and MarkIV
Prospect America, Inc. - System Admin - Jun1999 to May 2010
• Monitor and supporting the server system and user computers. Performed system admin duties including install software, configure windows and applications, upgrade MS patches, and troubleshoot technical issues
• Created and supported the Order/Invoice systems that was built on MS Access front end on Oracle backend database.
• Supported the telemarketing software TouchStar
• Monitor daily batches for data upload and transform from production dataset in Unix to data warehouse in SQL server
• Migrated the production database from Oracle to SQL database
Education
BS – Management Information Systems – University of Texas at Arlington – Arlington, TX
Certifications
MCP, MCSE NT4 MCSE
Technical Skills
MS Office 365, Excel, Visual Studio, VBScript, Perl, Knowledge of Unix commands, STAR methodology, Agile project management, Power BI, Cognos, Tableau, Window Powershell, MS Access 2013 and 365, SQL server, Oracle, MyQL, TeraData, TOAD, Rapid SQL, SAS Enterprise, SharePoint, SailPoint, Arbutus
Professional Reference
Viet Nguyen, Manager of Data Analytics, GM Financial, 214-***-****
Dale English, VP of I, LGM Finance, 817-***-****, adt155@r.postjobfree.com
Ryan Schreck, .Net developer, LGM Finance, 972-***-****, adt155@r.postjobfree.com
Dan Reeves, President, Prospect America Inc, 817-***-****, adt155@r.postjobfree.com