Financial Business A NALYST

Self - starter with MBA, extensive financial licensure, 20 years working with accounting systems (GL, AP, AR, FA, FSG, Discoverer, Report Manager, CE, TCA, SLA and Financial Analyzer). Full upgrade experience implementing Confidential Financials 10 thru 12i. Four years in Investment Banking with Smith Barney and Confidential . Proven ability to develop / customize / implement Financial modules to solve complex business, accounting, and reporting needs. Extensive experience as intermediary between IT and accounting departments involving translating requirements and constraints and mediating divergent needs and approaches.

P ROFESSIONAL E XPERIENCE

Accountant

Confidential - Jackson, MI

Monitored daily bank deposits. Reconciled deposits to monthly bank statements. Recorded transactions in Quick Books (cash, credit card transactions and accounts payable). Ran weekly and monthly financial reports for management. Responsible for month and year end close. Worked closely with auditors to provide requested and required data by preparing ad hoc queries and reports. Updated payroll and earning reports for management. Issued checks for patient refunds. Trained new employees on required tasks.

Global Data Business Analyst

Confidential - Battle Creek, MI

Responsible for building and refreshing a promotion event library for multiple categories/accounts to help improve trade spend efficiency and effectiveness. Data cleansing and harmonization. Communicate to account managers and sales planning team cost and performance data regarding promotional event statistics and analysis. Extensive use of Excel (high level macro design), Nielsen Rating System, SAS (Statistical Analysis System) and ECRM (promotional data and analytics).

Confidential

Confidential Financials Business Analyst

Provide business analysis, development, and customization of Confidential Financials; also provide systems implementation of other Confidential Modules (Discoverer and BI) and integration with existing systems. Served as liaison among IT, accounting, and Confidential, providing discovery / requirements definition, translation to functional specifications, and troubleshooting. Utilize Confidential AIM approach to identify scope of project, document business process and provide documentation for testing. Participate in interviews with end users to document entire business process of accounting functions to identify inefficiencies and present improvements utilizing Confidential AIM and Visio charts. Using Confidential FSG and ADI tools, develop custom queries, reports, and forms such as: Balance Sheets, Income Statements, Operational Variance Reports, Cash Flow Statements, and other ad hoc reporting requests. Responsible for design and reconciliation of financial statements for SEC reporting, GAAP requirements, auditor, tax reporting, management reporting, and analytical reporting. Responsible for and knowledge transfer to end users.

Confidential, Fairfield, California.

QA Test Specialist

Analyzed accounting department workflow to map business processes.

Worked closely with CODA Consulting in defining / writing business requirements and documentation for full CODA accounting implementation (GL, AP, AR, Fixed Assets).

Active in majority of essential setups for CODA Financials as well as mapping feeds from internal insurance database (INSpire).

Setups included chart of account structure design, validation rules, upload and testing. Designed all preliminary financial reporting in CODA. Conducted pre-production application testing and created procedural documentation and user programs.

Confidential, Berkeley, California.

Consultant - Confidential Business Analysis

Played SME role in migration of Confidential GL Data Base (10.7sc) to Confidential Global Database (11i), including all multi-company and multi-currency organization setups.

Tasked with developing all internal and client senior management reporting.

Conducted monthly translations and consolidations for multi-level structure.

Utilized Confidential ADI and FSG for reporting, drill-down, and loading budgets / actual data.

Designed pivot tables, v-lookups, macros, and ad-hoc reports to automate formerly accounting procedures. Aided in defining user requirements, design, creation and testing of reports utilizing Confidential Financial Analyzer extracted from Confidential Database.

Trained end users following successful migration from Confidential FSG to OFA Reporting.

Worked with Confidential to resolve accounting interruptions and implement upgrades.

Confidential, Various Locations.

Clients included: Mindscape (Novato, CA), SPL World Group (San Francisco, CA),

Phoenix Resources, Hambrecht & Quist, (San Francisco, CA) and ING Securities.

Consultant - Confidential Financials

Worked with accounting management to define reporting requirements for design and testing of FSG reports; reconciled monthly accounting financial data; uploaded annual budgets.

Resolved end user technical and functional requests and issues.

Setup demo Confidential database for Confidential Financials sales presentation to investment bank prospects, including General Ledger and Accounts Payable

Confidential, Chicago, Illinois.

Consultant

Promoted within one year of hire to work with major clients in numerous industries / sectors.

Made presentations explaining benefits and advantages of Confidential products; developed and sustained highly positive customer relations from inception through follow up on installation.

Met with clients to determine needs and implemented Confidential Financial Applications. Met with clients; provided and problem resolutions for end users, particularly Confidential GL team setups, report design, and data integrity testing.

Confidential, Chicago, Illinois.

Financial Advisor

Handled sales / business development, portfolio management and investment consulting for stocks, municipal bonds, corporate bonds, mutual funds and insurance product.

Advised companies on administration of 401(k), SEPs, profit sharing and money market purchasing plans; used Bloomberg for research and analysis of equities and cash flow models.

Built investment strategies for client investment goals, liquidity and risk tolerance.

T ECHNICAL E XPERIENCE

Software

Confidential Financials 10.7 thru 12i, Confidential ADI v 7BI Publisher, Confidential Report Manager, Confidential Discoverer, AIM 2.0, System Administrator; Excel, Word, Access, Power Point, SQL Data Load, VISIO,TOAD 10.5, Quick Books.