Henry L. Franklin, JR., M.B.A.
*** ************ **. ***** ****, TX 75104 Home Phone: 972-***-****
Cell Phone: 708-***-**** ************@*****.***
Ambitious Accounting professional who has worked in many of roles as an
Accounting Manager, Financial Analyst and Sr. Accountant with a strong
track-record of proven ability to lead and improve workplace
productivity able to
deliver timely and top performance work and a dynamic decision making
ability
Technical Skills
Applications: SAP, PeopleSoft, AS400, JD Edwards, Hyperion Essbase,
Hyperion Enterprise, Hyperion Retrieve, Cognos, Microsoft Office 2007,
2003, 1997, 1995
Systems: Microsoft Operating System Windows 7, Vista, XP, 1998, 1995
Professional Experience
Accounting Manager- Contractor
4/2013 to Present
Novartis (Alcon)
. Responds to inquiries from the Director of Finance, Controller, and
other finance managers regarding financial results, special reporting
requests
. Responsible for the functional areas in the Over the counter
(OTC) division to ensure appropriate accounting and financial
reporting is accomplished
. Ensure an accurate and timely monthly, quarterly and year end close
. Complete and review account analysis and account reconciliations
. Compile all financial data for Income Statement, Balance Sheet and
Cash Flow for Director's review
. Coordinates the Month-end financial closing and reporting process
. Prepare monthly flash review for Senior Management
. Review OTC division Account Reconciliations before submitting to
Director for final approval
. Serves as key liaison for OTC and other division to ensure accounting
and financial reporting is complete and accurate
. Review all OTC division journal entries before processing
. Advises staff regarding the handling of non-routine reporting
transactions
Senior Accountant - Contractor
1/2009 to 4/2013
Varel International, McKesson, Bank of America, Edward Jones, Time
Warner Cable
. Supported Compensation closing process through account
reconciliation, complete transaction processing, and perform
certain data maintenance
. Collaborated with Finance and Sales Operations to ensure that
compensation plan changes are aligned with business unit budgets
. Prepared weekly & monthly tracking by region and sales analysis
by SKU's
. Prepared monthly salesmen bonus calculations
. Provided reporting and analytics on sales performance to Sales
V.P. and Directors
. Prepared weekly cash analysis for Accounting Manager
. Created financial forecasts and budgets for division Managers
. Preformed monthly analysis to explain variances
. Ensured all A/P transactions were posted in a timely manner
. Created and maintained SAP Chart of Accounts and updated SAP G/L
Accounts
. Managed the Month End close process for Staff Accountants
reviewed and post all journal entries
. Performmed cost estimation, business case analysis, statement of
work generation
. Supervised a team of three employees within A/P department
Financial Analyst - Contractor
Aetna, Nissan Motor Acceptance Corporation, CVS/Caremark, McAfee, CVS
. Reviewed, evaluate and compress data and information from
multiple sources, resolve conflicts and differentiate between
actual and required user needs
. Evaluated multiple data collected through task analysis, business
process, surveys and workshops
. Coordinated with group managers who will test, validate, evaluate
new application and functions and determine issues in service an
software
. Using strong analytical reasoning to understand end user's
requirements and transforming them into operational application
. Analyzed the business operations to determine profitability as
well as to create a baseline for salesmen payout
. Analyzes and formulates data used for the calculations for
management MBO's
. Prepared weekly cash analysis for Plan CFO's
. Responsible for consolidation and posting of transactional
billing, system to GL reconciliation and detail reporting to BU
and Finance
. Responsible for auditing, developing and maintaining cost
accounting data within SAP
. Assisted in reviewing contracts that related to National
Prescription Drugs Management and Benefits
. Pepared Trend Analysis to explain the aging A/R
. Prepared weekly flash report for revenue that is distributed to
senior and field management
. Prepared monthly and annual financial statements and supporting
schedules
. Reviewed balances from the subsidiary ledger to general ledger
. Audit commission statement within SAP and Insight Financial
systems
. User Acceptance Testing (UAT) Commission Statements from legacy
system to SAP
. Prepared variance analysis and explanations for management team
. Prepared budget and forecasting updates for management
. Created policies and procedures for departmental controls
. Investigate all financial transactions to ensure data flow
correctly through SAP and Insight Financial systems
. Provided financial trend analysis for commission statements
CommScope Systems - Richardson, TX
1/2007 to
12/2008
Financial Analyst
. Acted as a liaison between business units, technology teams and
support teams
. Investigated options to solve business problems and meet the
business needs
. Compared month-end balances to budget and to previous months and
quarters and provide explanations for variances
. Assisted business process management and business requirements of
the customers and translating them to specific software
requirements
. Drive and challenge business units on their assumptions of how
they will successfully execute their plans
. Critically evaluate information gathered from multiple sources,
reconcile conflicts
. Provided technical and analytical guidance to project team
. Prepared Monthly Cost Analysis according to the CAS practices
. Wrote and reviewed budgets for department managers with variance
analysis
. Consult with key business and process owners to audit key
business processes through narratives, walk-through and process
flows
. Facilitated projects for internal and external customer meetings
. Prepared 125 Monthly Cost Center Reports for 75 Cost Center
Managers
. Follow-up with key contacts to validate that action plans have
been implemented timely and mitigated the previously identified
audit issue
. Performed routine testing to evaluate the operating effectiveness
of current risk-mitigating controls
. Reviewed departmental expenditures to ensure compliance with
budget allocations
. Gathered monthly financial statements to identify reasonableness
and irregularities for recommendation to Cost Center Managers
Safety - Kleen - Plano, TX
9/2004 to 12/2006
Government Reporting Analyst
. Responsible for the monthly financial reports for the United
States Census Bureau for all 50 States
. Generated Balance Sheets and Income Statements with monthly
foreign exchange reports for review by the Director of Financial
Reporting
. Coordinated with Internal and External Auditors in preparing GAAP
Compliance, Audit Reports, and Governmental Survey Reports
. Assisted with Sarbanes-Oxley documentation processes and testing
of financial controls
. Developed, submitted, approved, and updated government forward
pricing rates for oil recycling
. Assisted with leading contract/project set-up for government cost
point pricing
Pro-line International - Dallas, TX
3/2002 to 8/2004
Senior Accountant
. Researched, gathering and analyzing data to ensure appropriated
salesmen payout
. Provided promotional analysis for salesmen payout
. Worked with the top 50 customers for sales analysis and product
movement
. Administered Annual Quota Setting process for sales team
. Supported the Comp Supervisor as required for sales team and
region
. Participated in the design and delivery of incentive sales and
services plans using Essbase and advance Excel skills
. Processed 150 journal entries and allocations of business
expenses/revenue monthly, cost of sales calculations
. Prepared and analyzes accounts receivables cycle reports for all
business to segment entities
. Worked closely with internal/external audit to ensure all
documentation
. Generated and reviewed all journal entries to be approved by the
Accounting Manager or Director
. Collected sales data for the Domestic and International Sales
Team monthly sales quota
. Responsible for creating cost analysis for Manufacturing and G&A
overhead run rate
. Worked closely with the Operations Manager to schedule physical
inventory
Education
University of Phoenix - Irving, TX - Master of Business Administration
Tennessee State University - Nashville, TN - Bachelor of Business
Administration - Accounting