Mark D. Weicherding CPA, MAS, Six Sigma Specialist
Plano, Texas 75024
******@*******.***
Significant Work Experience
Raytheon, Garland, TX
IT Audit Manager
11/08-Present
. Perform audit on Strategic Planning, IT Organization Relationships,
Production Controls, Physical Security, Data Backup, Disaster Recover,
Capacity & Performance, Problem Management, Change Management, Operating
System Security, Network Security, Application Security, Database
Administration, Data Security, Application Controls, and Third Party
Vendor Management. This included writing narratives, preparing
flowcharts, testing key controls, and remediation.
. Performed audits on access controls surrounding SAP.
. Performed general application controls audit (i.e. user ID and Password
account suspended after failed login attempts). Audit to evaluate
programmers' test and production environment to ensure all programming is
done in the test environment and that no programmers have access to the
production environment
. Reviewed Unix access rights and not using super user account, ID
suspension after unsuccessful attempts, procedures for requesting
establishing and maintaining user access to system exist, review formal
backup procedures and disaster recovery.
. Reviewed library and version control over programs as well as change
control request form and log. Reviewed physical access controls to
ensure only those needing access to that area of the building have it.
. Performed Annual Risk Assessment with staff so as to develop our annual
audit plan.
. Present annual audit plan, audit findings, issues, new initiatives, etc.
to senior management, the Audit Committee, and to the outside auditors. I
ensure that the Audit Committee is informed of any significant deviations
from the approved Audit Plan during the year. I ensure that all audit
work contained in the Audit Plan is completed by year-end.
. Ensure effective examination and evaluation of the adequacy and
effectiveness of the organization's internal control system. Identify
potential control weaknesses and recommend appropriate solutions
. Report all audit activity to the Audit Committee and Senior Leadership
through both effective verbal and written communication as appropriate. I
ensure they are informed of emerging trends and successful practices in
internal auditing, risk management, and the workings of audit committees
as well as significant legislative and regulatory issues.
. Provide leadership to the Internal Audit Department. I ensure that
internal audits are properly staffed and polices and procedures are
followed. I hire, supervise, develop, coach, and ensure the appropriate
review of the work of the Internal Audit staff.
. Interact with management throughout the audit process by conducting
preliminary interviews, discussing audit findings, and conducting audit
exit interviews.
. Review workpapers prepared by Audit staff and ensure that there is
appropriate disposition of review comments.
. Also, perform yearly performance appraisals of staff, address training
needs, counsel employees, hire potential employees, review staff
workpapers, write and revise audit reports, issue audit reports, and give
awards for good performance.
. Ensure that Sarbanes-Oxley Section 404 requirements are adequately met
and properly reported to Senior Management, the Audit Committee, external
auditors, and proper regulatory agencies.
. Review and approve the overall purpose, scope, and approach for Audits,
ensuring appropriate coverage is achieved considering risk and regulatory
requirements.
Parkland Hospital, Dallas, TX.
Audit Manager
4/07-10/08
. Perform Material Services Audit (i.e. receiving of goods into the system,
billing & charge capture with PYXIS System, Non-PYXIS, Emergency, and
orders needed by the end of the day).
. Performed North Texas Poison Center (i.e. compliance to DSHS and HRSA
Grant Agreements and Parkland Policies), Out of County (i.e. sending
notification letters to another county and following up with billing that
county for seeing that patient), Balance Write Offs (i.e. balances
written off are automatically in the system based on the commercial
insurance carrier or Medicaid/Medicare Contracts that are loaded into
EPIC), Transcription Audit (i.e. billing for the correct characters for
transcription services), and Ryan White (Fraud Audit).
. Performed a majority of the external auditors year-end work (i.e.
performed year-end inventory, A/P Testing, Accounts Receivable Testing,
Fixed Assets, Treasury, Bad Debts, and other HR testing). Performed
account reconciliation for the above accounts. Also, discussed budget
variance with key personnel as to fluctuations in account balances.
. Used ACL on A/P audit.
. Performed Annual Risk Assessment with staff so as to develop our annual
audit plan.
. Present annual audit plan, audit findings, issues, new initiatives, etc.
to senior management, the Audit Committee, and to the outside auditors. I
ensure that the Audit Committee is informed of any significant deviations
from the approved Audit Plan during the year. I ensure that all audit
work contained in the Audit Plan is completed by year-end.
. Ensure effective examination and evaluation of the adequacy and
effectiveness of the organization's internal control system. Identify
potential control weaknesses and recommend appropriate solutions
. Report all audit activity to the Audit Committee and Senior Leadership
through both effective verbal and written communication as appropriate. I
ensure they are informed of emerging trends and successful practices in
internal auditing, risk management, and the workings of audit committees
as well as significant legislative and regulatory issues.
. Provide leadership to the Internal Audit Department. I ensure that
internal audits are properly staffed and polices and procedures are
followed. I Hire, supervise, develop, coach, and ensure the appropriate
review of the work of the Internal Audit staff.
. Interact with management throughout the audit process by conducting
preliminary interviews, discussing audit findings, and conducting audit
exit interviews.
. Review workpapers prepared by Audit staff and ensure that there is
appropriate disposition of review comments.
. Perform yearly performance appraisals of staff, address training needs,
counsel employees, hire potential employees, review staff workpapers,
write and revise audit reports, issue audit reports, and give awards for
good performance.
. Review and approve the overall purpose, scope, and approach for Audits,
ensuring appropriate coverage is achieved considering risk and regulatory
requirements.
BFI Canada, Ft. Worth, TX.
Audit Manager, 4/06-3/07
. Perform Sarbanes-Oxley work on Accounts Receivable, Fixed Assets,
Inventory, Payroll, Revenue/Billing, Cash, Accruals, Prepaid Assets,
Accounts Payable, Production Control, Change Management, Network
Security, Data Backup and Disaster Recovery. This included writing
narratives, preparing flowcharts, testing key controls, and remediation.
Performed annual risk assessment.
. Present annual audit plan, audit findings, issues, new initiatives, etc.
to senior management, the Audit Committee, and to the outside auditors. I
ensure that the Audit Committee is informed of any significant deviations
from the approved Audit Plan during the year. I ensure that all audit
work contained in the Audit Plan is completed by year-end.
. Ensure effective examination and evaluation of the adequacy and
effectiveness of the organization's internal control system. Identify
potential control weaknesses and recommend appropriate solutions
. Report all audit activity to the Audit Committee and Senior Leadership
through both effective verbal and written communication as appropriate. I
ensure they are informed of emerging trends and successful practices in
internal auditing, risk management, and the workings of audit committees
as well as significant legislative and regulatory issues.
. Provide leadership to the Internal Audit Department. I ensure that
internal audits are properly staffed and polices and procedures are
followed. I hire, supervise, develop, coach, and ensure the appropriate
review of the work of the Internal Audit staff.
. Interact with management throughout the audit process by conducting
preliminary interviews, discussing audit findings, and conducting audit
exit interviews.
. Review workpapers prepared by Audit staff and ensure that there is
appropriate disposition of review comments.
. Perform yearly performance appraisals of staff, address training needs,
counsel employees, hire potential employees, review staff workpapers,
write and revise audit reports, issue audit reports, and give awards for
good performance.
. Ensure that Sarbanes-Oxley Section 404 requirements are adequately met
and properly reported to Senior Management, the Audit Committee, external
auditors, and proper regulatory agencies.
. Review and approve the overall purpose, scope, and approach for Audits,
ensuring appropriate coverage is achieved considering risk and regulatory
requirements.
Raytheon, Richardson, TX.
Audit Manager 8/05-3/06
. Performed audits on Timekeeping for unallowable cost activity. Other
operational audits included audits on EAC and Earned Value Management.
Also, used SAP to pull financial statements for the various profit
centers and then test significant financial account balances for proper
support. Drafted audit reports accordingly.
. Performed Annual Risk Assessment with staff so as to develop our annual
audit plan.
. Present annual audit plan, audit findings, issues, new initiatives, etc.
to senior management, the Audit Committee, and to the outside auditors. I
ensure that the Audit Committee is informed of any significant deviations
from the approved Audit Plan during the year. I ensure that all audit
work contained in the Audit Plan is completed by year-end.
. Ensure effective examination and evaluation of the adequacy and
effectiveness of the organization's internal control system. Identify
potential control weaknesses and recommend appropriate solutions
. Provide leadership to the Internal Audit Department. I ensure that
internal audits are properly staffed and polices and procedures are
followed. I hire, supervise, develop, coach, and ensure the appropriate
review of the work of the Internal Audit staff.
. Interact with management throughout the audit process by conducting
preliminary interviews, discussing audit findings, and conducting audit
exit interviews.
. Review workpapers prepared by Audit staff and ensure that there is
appropriate disposition of review comments.
. Perform yearly performance appraisals of staff, address training needs,
counsel employees, hire potential employees, review staff workpapers,
write and revise audit reports, issue audit reports, and give awards for
good performance.
. Review and approve the overall purpose, scope, and approach for Audits,
ensuring appropriate coverage is achieved considering risk and regulatory
requirements.
Robert Half (Contractor), Dallas, TX.
Contractor 2/04-8/05
. Sarbanes-Oxley preparation and testing at all clients to which I was
assigned. This includes documenting the internal controls environment
for all financial as well as IT controls. Also, use COSO and COBIT
framework.
. Reviewed access controls to computer including logon & password controls,
policies & procedures relating to hardware & software acquisition (i.e.
weaknesses in the set-up, installation, and maintenance of system
software which have jeopardized the security of the data and programs
being stored on the system).
. Reviewed policies & procedures relating to system development life cycle
planning & IT policies & procedures relating to security policies and
committees; system development life cycle & planning, system development
testing procedures for program, unit, system test plans, training of
users; migration of systems from test to production, quality assurance &
training.
. Reviewed change control log to ensure formal procedures for both user and
development groups, help desk procedures. Used SQL to query database
when performing audits.
. Prepared risk matrix and performed flowcharts, narratives, and
substantive tests of all key financial controls surrounding,
revenue/billing, A/R, A/P, Fixed Assets, and Inventory. Documented audit
findings accordingly and submitted to management for concurrence.
. Performed mapping, tests of controls and tests of effectiveness for end
user computing.
IT Professional Training
1/03-12/03
. Java certified training, C/C++ programming, UNIX (SED, AWK, and Shell
Scripting), Access Database design, SQL, PL/SQL, Visual Basic
Applications (VBA), and ACL. Also, performed some contract work at
JC Penney using Java to build intranet web page.
Blue Cross, Dallas, Texas
Audit Supervisor, 3/02-12/02
. Prepared risk analysis with staff input for the upcoming
audit plan for the year.
. Performed financial and operational audits, which includes
underwriting, claims processing, treasury, government
programs, pension, compensation, legal, cash, accounts
receivable, accounts payable, inventory, and fixed assets.
Also, performed account reconciliation for the above
accounts.
. Coordinate all audits for any external agency that comes
into audit.
. Prepared audit reports and assisted the chief executive,
financial, and operational officers in decision-
making processes.
. Designing new audit programs for financial and operational
audits.
. Trained and supervised staff. Also, reviewed their workpapers and audit
reports.
. Reason for leaving was to take care of my newborn son and I
have been back in school at SMU and Collin County Community
College taking various programming classes.
DART, Dallas, Texas
Audit Senior 8/00-2/02
. Performed risk analysis and quantified results to determine
high-risk areas of DART to audit. Subsequently presented
results to the audit committee for concurrence.
. Performed risk analysis on the financial and operational
areas of DART. Risk analysis and matrix were developed for
process improvements surrounding cash, accounts receivable,
accounts payable, fixed assets, inventory, expense reports,
compensation, treasury function, transit agents, outside
contractors contracts, and transit police. The results of
these audits are presented to the audit committee.
. Prepare audit reports and assist the chief executive,
financial, and operational officers in their decision-
making process.
. Design financial and operational audit programs and review
the staffs work
. Assist in training and recruiting new employees.
. Contracted till 9/01.
PricewaterhouseCoopers, Dallas, Texas
International Assignment Solutions Senior, 9/99 - 6/00
Cummins Engine, Nashville, TN.
Compensation Analyst, 1/99 - 8/99
United Samaritans Medical Center, Danville, Illinois
Accounting Manager, 8/95 - 8/96
Anacomp (Fortune 500), Indianapolis, Indiana
Audit Senior, 2/85 - 12/92
Education
Northern Illinois University, DeKalb, Illinois
M.A.S., Tax, 1996 - 1998. GPA 3.5/4.0
Eastern Illinois University, Charleston, Illinois
B.S., Accounting, 1993 - 1994. GPA 4.0/4.0
Purdue University, West Lafayette, Indiana
B.S., Management, 1981 - 1984. GPA 4.5/6.0
Personal
Professional License: CPA, Also Six-Sigma Specialist.
Computer: ACL, Access(built my own database), SQL, PL/SQL, Word, VBA,
Excel (Pivot Tables, V-Lookups, Macros), Visio, Audit Leverage Software
(i.e. workpaper repository), Oracle, SAP, AS 400, and Peoplesoft.
Activities: Swam at 1984 Olympic Trials 200-meter butterfly (placed 7th),
biking, reading, and speak Mandarin.