SKILLS:

Microsoft Office applications (Word, Excel, Power Point, Outlook, Access), Peoplesoft Ledger, NVision, Hyperion Financial Management, Hyperion Essbase, SAP, Business Objects, Sharepoint, PowerPlay, ORACLE, COGNOS, SQL.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, Il

Allowance and Purchase Accounting/Business Analyst/Technical Writer

Responsibilities:

• Audit and test multiple schedules and reconciliations concerning Provision for Credit Losses for various portfolios of acquired assets.
• Purpose of testing was to:
• Ensure efficiency and accuracy of schedule/reconciliation.
• Ensure accuracy, comprehensiveness, and completeness of written procedures for schedule/reconciliation.
• Remediate any gaps within the schedule/reconciliation itself or within the respective procedure.
• Streamline the reporting process for the Provision of Credit Loss segment of Loan accounting.
• Audit, update, or create procedures (via technical writing) regarding various schedules/reconciliations concerning Provision for Credit Losses.
• Items in scope of audit of actual schedule/reconciliation included:
• Ensuring calculation of Provision for Credit Losses accurately captured Incurred Amortization, Net Reservations, Net Charge Offs (NCOs), and General Reserves for Vacant Land by both month and quarter.
• Ensure calculation of Credit Mark accurately captured Amortization, Pay offs and Prepayments, Charge offs, Re - Estimations, and Releases of Incurred Mark by both month and quarter.
• Items in scope of audit of procedures included:
• Ensuring proper referencing of data sources.
• Ensuring proper referencing of data elements used from data sources.
• Ensuring accuracy of documentation of process flow.
• Portfolio scope included Retail/Consumer, Commercial, Purchased Performing Consumer, Purchased Performing Commercial, and Purchased Credit Impaired.
• Performed analysis of Credit Mark types (Incurred Loss and Future Loss) and Rate Mark under FAS91, SOP03 and 141R accounting treatments.

Confidential, Chicago, Il

Senior Business Analyst III/Project Manager-Second Vice President

Responsibilities:

• Provided project management for Confidential ’s Financial Systems Roadmap effort, an enterprise wide, large-scale, top-priority and complex technology change initiative involving the conversion of multiple legacy ledger systems to one book of record, with impact to multiple business units, product lines and business processes
• Drove the high-quality completion of the enterprise wide implementation project by ensuring remediation and migration of various applications’ legacy ledger dependency to the new authorized data source
• Led teams across broad technical, financial and business disciplines, keeping teams focused on business objectives while tracking progress to ensure project milestones were completed on time, within budget, and with the desired results.
• Mitigated risk factors through careful analysis of financial data, anticipating and managing change effectively by maintaining constant communication between the various business, finance and technology partners involved.
• Aside from developing project plans, scheduling/running weekly meetings, and ensuring deployment within strict deadlines, responsibilities include various ad hoc projects such as:
• Performing reconciliations by application between legacy ledger and the proposed ledger using an in-house reporting tool for the purpose of providing data validation/acceptance in support of the change initiative
• Act as subject matter expert for the various lines of business and Finance business partners through an understanding of account rollup logic and data flow between source system, data warehouse, and book of record (for three different ledger systems) in support of initiative for the purpose of explaining technical reason for defects and providing possible courses of action for remediation of issues.
• Performing mapping analysis for applications in order to provide an understanding of how account code blocks of the decommissioned legacy ledger translate into the account code blocks of the new authorized data source/ledger, as well as for the purpose of resolving reconciliation breaks through either mapping changes or the creation of a new account code block.
• Contribute to design, development, and functionality of new applications and systems through end user acceptance testing and live environment business operations, identifying possible areas of improvement and providing feedback for completion and presentation of project deliverables during all phases of initiative.
• Providing senior management with an Executive Summary on a weekly basis detailing which applications have been remediated and successfully deployed, which applications are still outstanding and why, the status of various projects, and the status of escalated issues which require resolution as soon as possible.

Confidential, Mettawa, Il

Regulatory Reporting-Senior Financial Analyst

Responsibilities:

• Assisted in the Regulatory Reporting process of Confidential North American Holdings ( Confidential ) and its subsidiaries BASEL II function, reporting actuals on a quarterly basis and estimates on a monthly basis, focusing on Credit Risk in support of Capital Planning and Forecasting.
• Responsibilities include confirming that balance sheet assets for the respective legal entities fall into proper BASEL II asset classes to ensure accurate approach in determining exposure classes. Analysis performed was for all LOBs (PFS, CMB, GIBM, PB, and Other). Approaches included STD, Retail IRB, AIRB, and OIRB.
• Scope of reporting on a quarterly basis includes Pillar 1 reporting, FSA045 reporting, Customer Group reporting, and Pillar 3 reporting with the purpose of presenting analysis and commentary in support of presentation to both internal and external business partners.
• Responsibilities involved the collaboration and interaction with the Finance, Accounting, Plan and Analysis, and Credit Risk groups across all LOBs and legal entities.
• Monthly responsibilities include but are not limited to the following:
• Perform monthly reconciliation and analysis of GL and Reporting GL mapping upload to Risk Engine to ensure the Retail Credit Management team (RCM) has captured and extracted the necessary retail accounts feeding the Risk Engine.
• Perform the monthly and quarterly analysis of Risk Weighted Assets by Customer Group, including Market and Operational risk, communicating results to Plan and Analysis in support of its Tier 1 and Tier 1 Core Capital ratio calculations. Also provided results to the Retail Banking and Wealth Management team in support of its strategy development regarding captial allocation for business growth while falling under Confidential ’s capital requirements.
• Perform analysis of RWAs in Confidential ’s Non Core Product portfolios in order to calculate Corporate Notional RWAs, communicating results to various Finance/Accounting teams within the business units, as well as senior management.
• Perform monthly analysis on Loss Reserves by business unit (Consumer Lending, Mortgage Services, and Credit Card Retail Services, both Private Label and Cobrand) and then by product, on both an IFRS and US GAAP basis for the purpose of presentation to the Confidential .
• Perform the IFRS Loss Reserve Estimate Schedule for the purpose of aggregating the ALLL by Group Reporting Chart of Accounts for determination of Monthly Estimate and Quarterly Actual Expected Loss for the Consumer Lending, Mortgage Services and Credit Card Retail Services Business units.

Confidential, Chicago, Il

Controllers /Financial Reporting-Senior Staff Accountant-Second Vice President

Responsibilities:

• Assisted in the implementation of BASEL II Regulatory Reporting process within Confidential for the purpose of identifying adequate levels of capital requirements in order to ensure sustainability in the event of economic crisis due to Credit, Market, or Operational risk. Responsibilities included performing fundamental counterparty risk/credit research to enusre proper risk weighting, as well as preparing and maintaining documentation efforts to ensure data integrity, internal controls, and systems/applications validation.
• Assisted in the comprehensive review/assessment of the scope/effectiveness of Northern’s SOX 404 process in order to identify significant deficiencies or material weaknesses in Northern’s Financial Reporting process.
• Responsible for the preparation of the Fair Value of Financial Instruments (FAS 157) table (including footnotes), with results being published within both the 10Q and the Confidential Annual Report.