Data Analyst Financial
Resume:
•
Joy Ching
Denver, Colorado 80220- 6220
United States of America
*********@*****.***
Experiences
Department of Justice - Bureau of Alcohol, Tobacco, Firearms and Explosives (ATF)- Asset Forfeiture contractor with FSA (Forfeiture Support Associates, LLC) – March, 2016 – April, 2020. Record Examiner Analyst (Investigative Analyst) and Data Analyst - FSA, a professional services company delivering highly qualified personnel in support of the government's mission. The Data Analyst and the Record Examiner Analyst supports the Asset Forfeiture Program at the Bureau of Alcohol, Tobacco, Firearms and Explosives (ATF). The Data Analyst and Record Examiner Analyst provides administrative and case management support to Special Agents and the US Attorney’s Offices.
ATF enforces the federal laws and regulations relating to alcohol, tobacco, firearms, explosives and arson by working directly and in cooperation with other federal, state and local law enforcement agencies. ATF has the authority to seize and forfeit firearms, ammunition, explosives, alcohol, tobacco, currency, conveyances and certain real property involved in violation of law. Record Examiner Analyst (Investigative Analyst) provides the Data Analyst tasks (listed below) and, also, executed the following: review data and information from multiple sources; establish case/project files; enter & retrieve data from data bases; prepare and format management reports; manipulate, transfer, compute and print information; create and manipulate spreadsheets; prepare and correct reports and correspondence with other agencies for the government; conduct validation and verification of law enforcement case files and case data systems and documentation retrieval from other federal, state and local agencies. Apply laws, rules and regulations to research of cases were applicable. NFORCE, CATS, ACCURINT applications and other law enforcement databases and applications used for work performance.
Data Analyst executes the following duties:
• Provide organization and management of case files
• Review data (completeness of information, proper execution)
• Extract data from data base
• Obtain additional information from other investigative agencies/data base
• Establish/maintain physical file
• Prepare notices/advertisements
• Receive, suspense pennons, claims, process sharing requests
• Reconcile inconsistencies
• Prepare declarations
• Gather information and organize investigative package
• Verify case files and case tracking system
• Maintain internal status information on the disposition of all forfeited assets
• Assure information is accurate and perform analytical computations necessary to process data
• Conduct and reconcile inventories
• Distribute and receive documents
• Assist lead analyst or officials in obtaining/collecting all documents/information to complete case file
• Provide administrative information and assistance concerning case to other investigative agencies, local law enforcement agencies, US Attorney, and other DOJ processing USAO, and higher headquarters
• Extract data from agency data base for management and program reports
• Perform process(s) relevant to case documentation
• Perform data relevant to case
• Procurement of supplies using federal government process system when needed
• Apply laws, rules and regulations to research on cases were applicable
• Both Record Examiner Analyst and Data Analyst include telework. Great-West Financia1/Empower Retirement - Greenwood Village, CO - November 2015 - February 2016. Financial Analyst.
This highly visible position required responsibility for the accuracy of Great-West Finance (GWF) product reporting via complex Documents and ad hoc requests from Implementation, Fulfillment, Institutional Partners, Plan Management, Relationship Managers, and Client Service. Emphasis was on one or more of the following areas: Returns, Investment Options at a Glance (IOAGs), Fund Fact Sheets.
• Audit for the accuracy of GWF product reporting via Statements, IOAGs, Fund Fact Sheets, Fee Disclosures and various Correspondence.
• Processes, researches, quality controls, holds, cleared rejections, completed, and published documents within strict time frames.
• Obtains information from various internal and external sources communicating via file feeds, e-mail and phone for any of the company's lines of business and products.
• Handled any manual exceptions and processes. Maintained, updated or added EASY (SalesForce) and Thunderhead (internal GWF proprietary) information
• Provided customer service for any escalated questions and/or issues to internal and external departments via GW Connect.
• Ran ad hoc SQL scripts in advance of production to validate data and enable pursuit of missing or Incomplete data, and other monthly reporting.
• Interacted with high level contacts both Internally and externally to respond to inquiries and identified Issues.
• Maintained and updated GWF departmental SharePoint Sites
• Shared knowledge via training for those with less experience in the position,
• Provided assistance to Team Members and the Manager and/or Assistant Manager with special projects and workload.
• Microsoft Office was required, with a strong emphasis on Excel.
• Strong organizational skills exhibited
Great-West Financial / Empower - Greenwood Village, CO - (CoreStaff Consulting Services - contract) -
February 2015 -November 2015. Consulting Analyst.
• File Management Organize and maintain version-controls of datasets.
• Extract (filter and clean), and review and audit data from client databases on spreadsheets; locate performance indicators and correct any raw data code problems.
• Interpret data and analysis results using MS Excel to provide ongoing reporting to management i.e. interpret information to assist with integration project decision making.
• Provide MS PowerPoint slide decks and MS Word documents for management weekly status reporting
• Investigate and communicate with all necessary project teams as necessary to complete task(s)
• Locate and define new process Improvement opportunities
• Strong client relationships Strong upper management communications. Effective email writing ACOSTA Sales & Marketing - Aurora, Colorado - October 2011 to February 2015. Client Resolution Analyst - Contract/Data Analyst
2
•
• Audit and analyze contracts and payment terms against vendor and contractor invoices
• Analyze and resolve claims' discrepancies with contracts and any Issues from clients, internal and external
customers, and sales teams III a professional manner. problem resolution tracking statistics.
• Periodically quality check existing contracts to ensure the contract rights and obligations are properly
administered.
• Handle and resolve discrepancies and issues with field knowledge, experiences research, SOP
(Standard Operation Procedures) and communications with vendors, internal and external customers and sales teams
• Escalate unresolved Issues to appropriate parties, including Business Managers, Regional Managers, etc.
• Understand types of escalations, using problem solving techniques and analytical skills to resolve as not to
repeat problem, recommend solutions, and/or address root causes
• Update and maintain current information on pricing Ensure Sales Teams are notified on a timely basis
• Maintain excellent working relationships with vendors, internal and external customers, clients, sales
teams, and co-workers in the Food Distribution and Food Services industry
• Communications on the phone, emails, and other media ranked 'highest' on PMR Colorado Technical University - Denver, Colorado - Summer, 2008 to 2013. Graduated - Master of Business Administration (MBA) - Business Management - emphasizing Project and Accounting Management, GPA 4 0 - June 2013 -Masters of Science Management- June 2014
Graduated - Bachelor of Science - Business Administration - Business Management, GP A 4 0 - March. 2012
Student Senate President - elected by student body from October 2009 to March 2013 Assisting students-in the student advocacy 1OIe--m growth and development by discussing meaningful educational plan compatible to their life goals Assisted Chair of Business Management - recommend to students on concentration sequence substitution
Understanding of a student life and workload to consult with student challenges Two-campus co-ordination for student and community activities & involvement Volunteer tutor, assist students with study tools, technology, and aids Self-directed, motivated, responsible, and a decision-maker Encouraged students to the successful completion of a degree and to graduate Demonstrated leadership, organizational, and presentation skills-involved in every quarter student orientation (s)
Demonstrated critical thinking skills to solve problems m team environments Adapt successfully to continuous change and multi-tasking. Wells Fargo Bank N. A. – Denver, Colorado – June, 2008 to August, 2013 Credit Analyst II- Wholesale Loan Services - Accounting
• Job functions included gathering and auditing routine credit mfoimation for wholesale loans; preparing credit reports for presentation and contract adjustment; tune value of money/analysis applications
3
• Spreading financial/credit information (extensive Microsoft Spreadsheet/excel usage)
• quality check and followed up on credit covenants.
• monitored documentation expectations
• responded to customer inquiries, internal financial analyst inquiries and bankers
• ensured credit files are current and compiling and analyzing loan data
• generated status reports for management/bankers.
- Advised Relationship Managers and Regional Community Banking Offices of potential situations,
assess the risk, and results of analysis of audits Wells Fargo Bank, N.A. - Personal Retail Banker & Loan Officer
• Manage a full book of financial & service banking needs for customers, business(s); including investment and wealth management clients to include sales.
• Consultative sales techniques; delivery of complex solutions to customers.
• Loan origination to closing process to homeowner/clients’ home purchases or refinancing.
• Review and loan approval decisions - always customer-centric.
• Licensed Annuities/Insurance 2004-2006; Notary Public Other Accomplishments
CTU Student Senate President 2009-2013
Denver Mayor's Asian Advisory Board
Martial Artist - 2 Black Belts - 2nd Dan - Tae Kwon Do, Avid Skier; Tennis Player Community volunteerism and involvement m Denver community for numerous years Asian Connection - Team Member Resource Group for community - Wells Fargo Bank, N.A Daughter of a Military Veteran of the US Army
Education
Colorado Tech University - Denver, CO - GPA 4 0, M.B A - Bus Management, June 2013. Colorado Tech University - Denver, CO - GPA 4 0, Master of Science - Management, June 2014 Colorado Tech University - Denver, CO - GPA 4 0, B.S.- Business Administration, December 2011 Certified Contact Tracer -Covid-19- John Hopkins University – School of Public Health, May, 2020 Other Skill Sets
- Microsoft Excel, Access, PowerPoint, Word & other Microsoft products
- Prior years to Wells Fargo Bank; worked Protocol Call Center on 2 campaigns
- Strong interpersonal skills, organization skills, analytical skills, presentation skills, problem solving, research skills, and leading effective teams.
- Security Clearance and Criminal background clearance per adjudicators: Public Trust Position. 4
Contact this candidate