SUMMARY:

• Meticulous bilingual professional, self - starter with over seventeen years of experience in large multimillion dollar financial institution.
• Technically proficient in MS Office Suite including excel, and macro development.
• Proactively streamlines processes to increase productivity and maximize resources with a clear understanding of financial reporting processes and controls.
• Strong analytic skills, critical thinker, ability to analyze data, determine trends, and identify risks.
• Managed multiple projects from planning stages to successful implementation, regression testing.

TECHNICAL SKILLS:

• Windows
• Microsoft Office
• FDR
• BofA Direct
• People Soft
• Infinity
• In$ight
• IGL
• Image view
• Document Direct
• Vision
• FDES
• Hyperion
• Oracle
• ICM and EZRec
• Essbase
• BofA Support Center racle
• AS400
• Essbase Administration Services
• FDM
• EPM
• Icoms
• ReconWeb
• CEO
• Eagle
• I-reports
• MSP mortgage platform and SAP.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Analyst Consolidation Accounting

Responsibilities:

• Prepared quarterly fund to fund eliminations, posting and reconciliation to TPA source data.
• Responsible for quarterly preparation, analysis, reporting of crossholdings investment and non-consolidating VIE’s.
• Responsible for quarterly preparation, analysis, reporting, posting, reconciliation of funds activities including researching working papers, holdings reports, NAV and general ledger.
• Prepared audit adjustments based on comparison from trial balance to GL.
• Created a database using power pivot for the quarterly reporting of issuance and paydowns for all consolidated funds.
• Prepared roll forwards for level III, FAS 157 securities and Funds.
• Responsible for maintaining, and making VB code changes to the financial footnote workbook androll forward master workbook.
• Mapped statistical accounts to financial footnote workbook.
• Created processes to increase efficiencies and productivity via automation of workbooks.
• Documented and maintained 12 processes and procedures.
• Used excel to create complex formulas match index, Vlookup’s, if statements, sum if, and nested statements.
• Prepared the financial footnotes data for use in the financial statements.
• Prepared the accounting for CLO, CDO, partnerships funds.
• Prepared the accounting in compliance with FAB rules for funds which contained derivatives.

Senior Accountant

Responsibilities:

• Reported and analyzed a 2 billion dollar plus trouble debt restructuring home mortgage portfolio of first and second lien mortgages of multiple entities, financial structures and systems.
• Responsible for the preparation of the 2.45s and 2.45t SEC impaired financial receivables with commentary and explanations of changing trends.
• Used excel to analyzed large data sets, extraction and manipulation of financial data via pivot tables, vlookups, if statements and auto create journal entries.
• Monthly data analysis, reporting and accounting of bankruptcies, principal forgiveness, exceptions and redemption loans, preparing and posting journals via eagle web.
• Used MSP mortgage platform to research exception loans and determine their status as a TDR.
• Used Essbase for monthly trend and variance analysis of GL balances for TDR accounts.
• Monthly reconciliation between GL and home equity TDR Data Base assuring compliance to acceptable variances.
• Reported monthly unfunded commitments for Home Equity TDR.
• Performed monthly SOX control certifications for data integrity, and segregation of duties assuring proper signoff on work product.
• Performed monthly rollforward, analysis and reporting of TDR Data Base.
• Prepared monthly TDR loan delinquency report for the RC-N and RC-C regulatory reports.
• Updated monthly analytics reports for management reporting.
• Managed, planned and successfully integrated A/R daily and monthly reporting for capital finance.
• Reconciled daily cash bank accounts and reported daily cash position.
• Maintained accounts within corporate compliance by researching via IrisWeb, analyzing and resolving outstanding issues on a timely manner.
• Reported weekly Sub-ledger reconciliation variances using I-reports and posted adjusting entries.
• Aged receivable accounts via custom build excel spreadsheet and reported violations to senior management during month end close meeting.
• Participated in Recon Web system enhancements SIT, UAT testing and in the implementation of systems batches.
• Implemented the accounting requirements of FAS 91

Accountant

Responsibilities:

• Used PeopleSoft to reconcile daily cash, bank accounts, credit cards and reported daily cash position.
• Maintained receivable accountants within corporate compliance policy.
• Used PeopleSoft, Icoms to researched, analyzed and resolved outstanding issues.
• Posted daily journal entries, adjusting entries and charge off via PeopleSoft.

Accountant

Responsibilities:

• Reconciled the consolidated balance sheet, income statement, monthly volume report by production plant from various source systems and reported result to senior management during month end close.
• Migrated legacy Essbase cubes to Oracle ERP databases.
• Reconciled the GL from several databases such as PRMS to Essbase.
• Managed the month end daily closing process check list, prepared and analyzed financial statements.
• Used Essbase administration tools to maintained financial reporting systems by querying database according to schedule, created new GL accounts, customers, departments and alternative report views in Essbase outline.
• Uploaded data to Essbase tables via Essbase adding.
• Maintained security access tools and granted access to Essbase cubes.
• Monthly audit of security database and privileges, maintaining access request for audit compliance.
• Made month and quarter end adjusting entries, prepared ad hoc financial reports for senior management.
• Executed the demand forecast process, analyzed and explained variances from actuals to forecast, researched root cause and prepared commentary for management meetings.
• Analyzed P&L, identified trends, researched and resolved variances to paint an accurate financial position.
• Analyzed and developed methodologies, such as redesigning financial and accounting work processes to improve efficiencies.
• Maintained Sarbanes-Oxley compliance documentation in accordance with established policies.
• Used AS400 system to validate new customer’s information, cross reference against Essbase outline and validate monthly financial information.

Manager Financial Systems Support-Management Accounting

Responsibilities:

• Managed a staff of four senior and intermediate financial associates, providing accounting support to internal Confidential associates, setting unit goals, individual goals and evaluated team members’ performance.
• Coordinated unit activities, assigned resources to meet daily SLA of 1hour and unit projects.
• Provided daily morning summary updates to senior management for technical and financial issues arising during off hours and from offshore resources.
• Provided technical and analytical support for Confidential ’s financial reporting databases supporting over 15 applications of customer relationships for management and legal reporting.
• First line of defense for internal financial and accounting associates providing access to proprietary data sources, financial analysis, reporting analysis, accounting functions and training resources.
• Created and delivered training modules to support unit mission of delivering top quality services, knowledge sharing and support the ongoing development of internal associates.
• Managed numerous unit projects including the Merrill Lynch transition, US Trust, MBNA, Governance, Risk and Compliance for E-Ledger and CFC-PeopleSoft creating end to end process maps using Microsoft Visio, report mapping matrix and supporting documentation.
• Prepared, reported and analyzed weekly retained earnings, researched and resolved variances using In$ight, IGL, and document direct.
• Clear understanding of Confidential financial reporting and hierarchy structure providing daily ad hoc reporting, research, variance analyst and audit support to maintain SOX compliance.
• Developed test plans to conduct SIT, and UAT testing for proprietary systems. Tracked break fixes using clarity project management system and reported status to senior management during project meetings.
• Experienced with Microsoft office suite including creating several excel macros to increase unit operational efficiencies.
• Worked on enterprise wide cross functional team, developing strategies to support the global accounting operations in support of transitions, acquisitions, and systems implementations.
• Strong interpersonal skills with the ability to multi task, manage time effectively, and develop business partner relationships.
• Documented and maintained processes, policies, procedures and made quarterly updates in according with corporate policy.
• Responsible for maintaining daily data integrity and assuring the accuracy of the financial system by reconciling sources data and verifying balances from nightly feeds.
• Supported the enterprise wide GL conversion from legacy systems to SAP, by creating informational power points presentations and updating user population.
• Processed, executed and published the alternative chart of accountants.
• Performed financial systems stress testing on the books of records.
• Used SQL to query database tables and extract needed information.
• Participated and supported internal security audits receiving high marks.
• Used oracle financial system to pull financial information, research journals, balances and user information.
• Maintained and updated the Financial Systems Support internal website.
• Identified and cleared suspense items from the corporate suspense accounts.

Staff Accountant

Responsibilities:

• Performed monthly financial close activities including updating and maintenance of the General Ledger, account variances analysis, posting journals, account reconciliation, charge offs, aging A/R, reporting, analysis and process review.
• Responsible the daily reconciliation of 40 plus GL accounts, researched and resolved outstanding A/R aging issues, prepared management reports with variance analysis and recommended follow-up solutions.
• Automated various accounting reconciliation process through the development and deployment of visual basic excel macros.
• Participated in various general ledger conversion projects, prepared internal audit working papers and ad-hoc reporting development.
• Served as technical and business support analysis for the entire settlement department while maintaining dual responsibilities for daily work activity and unit business support.
• Audited and merged the disaster recovery plans from two different legal entities.
• Used FDR and Pega systems to research payment adjustments to customers account.
• Automated and performed escheat reporting for multiple legal entities.
• Participated in a project to mapped alpha code adjustments to general ledge accountants.
• Extracted data from access data base for used in daily recon process.
• Reconciled and streamlined high volume GL suspense accounts such as: Direct Sell (Chargeback), Q1 (NSF), WIP, PIP, DLA, SS/SQ (Fraud).
• Trained associates in the proper research and reconcilement techniques.
• Maintained backup documentation files.