Data Analytics Manager
Resume:
JOCELYN Y. ANG, CFE
Chicago, IL 60607
**********@***.***
Summary
A Reporting & Data Analysis expert with over eight years of experience working in a Data Quality & Integrity (DQI) practice for a Big 4, I have provided consulting and analytical services to many Fortune 500 clients in various industries including healthcare/pharmaceutical, consumer business, retail, manufacturing, and financial services. My effective project management skills and positive attitude have helped me successfully deliver quality results to my clients for a variety of projects including revenue recognition, ERP implementations, spend analysis, contract compliance reviews, financial re-statements, and forensic reviews.
Core Competencies
• Analytical Thinker
• Presentation and Communication Skills
• Team Player
• Mentor
• Project Management
• Achievement/Results Orientated
Experience
DELOITTE & TOUCHE LLP, Enterprise Risk Services December 2000 – February, 2009
A SERVICE LINE SPECIALIZING IN IDENTIFYING, MEASURING, AND MANAGING CONTROL RISKS FOR ALL INDUSTRIES
Manager
Simultaneously managed multiple engagements varying in team size of 2 to 10. Helped clients convert data into business intelligence. Built and facilitated relationships between senior leadership and staff both internal and external. Often assigned relationships that were in need of repair or were sensitive. Responsibilities included:
• Developing data analysis metrics to assist clients in understanding the trends and anomalies of their business by understanding the key performance indicators
• Researching and benchmarking key statistics to aid clients in the comprehension of their data profiles
• Creating executive summaries and reports to present to senior management and partnerships
• Designing databases/program code to gather information and develop standard reports
• Expanding audit plans and fraud procedures in the key business areas of Accounts Payable, Accounts Receivable, Financial Reporting, Payroll, etc.
• Managing the scheduling of projects and team of 12 data specialists to ensure timely execution of projects and deliverables as well as matching the appropriate resources to the level of expertise required for the projects. Revenue from staff totaled over $1 Million.
• Counseled and guided over eight staff members throughout the Midwest and Southeast region from new hire training through several promotions. Mentored and advised several star performers through their career development.
Engagements included:
Developed several key exception reports using Crystal Reports for a Sarbanes Oxley Report. Project consisted of building a reporting tool on the security access of all major systems. Gathered initial business requirements from both the system and for the reports. Reports were parameter driven sub-reports.
Assisting an internal audit client in the decision making process to re-engineer their inventory stocking process versus adding additional headcount. Accomplished by analyzing and reviewing several types of inventory and receipt files for movement versus quantity and timing
Providing client with spend analysis recommendations based on accounts payable vendor and disbursement information
Using SAS and ACL, analyzed complete journal entry populations for fraudulent characteristics (i.e. transactions to unrelated accounts, transactions with missing descriptions, etc.) based on SAS 99 guidelines for various industries for both internal and external audit clients. Procedures included using statistical concepts such as calculating standard deviations and population proportion to size sampling
Validated the Performance Evaluation Model on sub prime accounts for a large west coast bank
Building foundational course materials for a four-day campus hire class as well as facilitating the training for this course for Deloitte’s National Learning team
Determining the feasibility of implementing an estimation-sampling program for a distribution center by review of the physical and systematical flow of merchandise within a large pharmaceutical warehouse
Preparing and presenting overall results of a three month global compliance review to client senior management, two lead client partners and a panel of international legal counsel
SPECIALWARE CORPORATION April 1998 – December 2000
A CONSULTING AND TRAINING COMPANY SPECIALIZING IN BUSINESS INTELLIGENCE SOFTWARE
Certified Consultant / Trainer
Analyzed clients’ reporting needs to streamline business processes. Managed projects from initial client contact through the planning process to the final deliverable. Responsibilities included:
• Understanding the current reporting process as well as the desired process
• Designing Financial and HR reports using Seagate Crystal Reports
• Teaching Introductory and Advanced Crystal Reports classes both publicly and onsite as a Certified Seagate Software Crystal Trainer
• Developing course material for new classes including agendas, outlines, curriculums
• Extracting and analyzing data from different databases including, but not limited to MSSQL, Oracle, and Access
DELOITTE & TOUCHE LLP, Enterprise Risk Services December 1996 – February 1998
Regional Recruiting Coordinator/Campus Recruiter
Formulated a new hire recruiting process for eight Midwest regional cities by forming successful working relationships with the lead Partners and their offices. Responsibilities include:
• Understanding recruiting needs for each city
• Reviewing and screening initial candidates for foundational qualifications
• Scheduling and coordinating experienced hire interviews around the region
• Giving class presentations to establish and further develop relationships with key universities
• Recruiting 36 campus level hires for the Midwest Region (increased number by 100% from the previous year)
U.S. ROBOTICS October 1995 – December 1996
A TECHNOLOGY COMPANY FOCUSING ON PROVIDING INNOVATIVE PRODUCTS THAT ACCESS THE INTERNET
Human Resources Assistant
Supported three Human Resource Generalists by organizing the voluminous files in a rapidly growing department and company. Responsibilities included:
• Establishing and maintaining employee records using PeopleSoft
• Reviewing and correcting PeopleSoft data as part of PeopleSoft implementation project
• Participating in college recruiting strategy development and planning
• Analyzing compensation data to determine average mid-range salary trends
AEON CORPORATION (Kasugai, Japan) July 1993 – June 1995
ONE OF THE LARGEST JAPANESE PRIVATE SCHOOLS IN JAPAN SPECIALIZING ON PROVIDING LANGUAGE SERVICES
English Teacher
Taught conversational English to both children and adults using innovative methods. Responsibilities included:
• Developing activities to follow curriculum using technology and different approaches
Technical Skills
• SQL • SAS • ACL • Microsoft Visio
• Crystal Reports • Monarch • Microsoft Excel • Microsoft Word
Education
UNIVERSITY OF ILLINOIS at Urbana-Champaign May, 1993
Bachelors of Science – Education, with a concentration in Mathematics
Contact this candidate