PROFESSIONAL SUMMARY:

Diverse skill sets with adaptable Accounting principles & Financial Management. Skilled in Treasury Management including analytical aspects with expertise in overseeing daily Cash Management (receivables, payables), Forecasting, Risk Management and liquidity as both leadership and individual contributor. Well versed in developing and implementing daily and long term strategies aimed at business efficiency and growth. Highly organized, Ability to analyze and interpret data. Technology experience, Eight plus years experience.

TECHNICAL SKILLS:

• MS Office (Advanced Excel, Access, PowerPoint, Word) SharePoint hierarchy rollup business user, Lotus Notes, Aris and Visio, Pivot tables
• Structured Query Language SQL (novice level)
• Oracle Client, Oracle Toad
• Oracle General Ledger Concepts and Org Dimensions reporting
• RDR database migration in projects (reporting)
• Basic writing of SQL Quary (Select, From, Where,Order By)
• HP Quality Center life cycle management
• SAP BI/BW, E - ledger (Functional, Group, Index currency)
• Oracle; Oracle Fusion database used to help streamline treasury functionality (entry level startup)
• Master Data Management (MDM)
• Manufacturing AS400 PO system terminal lookup (business office side)
• Cert Master Data Base
• Bony, Logos, Tess, Iris, Eagle Investment Systems, Phase III, Snapshot, Intellimatch, Syndesk, logos
• Super user of numerous online banking systems
• Third party Ach legal services, contract resolutions
• Depository Trust & Clearing Corporation (DTCC)
• Visio flow charting
• GL Sub ledger (Cass -GLcompany,GLaccount,GLcostcenter,GLsubaccounts)
• Project related to Agile, Water Fall, Scrum roles
• In a project environement mapping data stream flows for data bases Oracle BI Hyperion EPM

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Business Analyst Project Consultant

Responsibilities:

• General accounting principles
• Created new Excel spreadsheets and enhance older versions increasing efficiency of department
• Coordinated Extraction of General Ledger (GL) Company/cost center/Balances and created Excel balance sheets between legacy and production databases and analyzed results
• Researched and reported accurate up - to-date financial variances over 10k
• Intuitively analyzed and reported balances using pivot tables and VLOOKUP
• Investigated, report and resolved unusual trends and variances; during retesting of User Acceptance Testing (UAT) items
• Assisted migration and updated RDR (Eone) and GL account databases including adjustment sub ledgers (CASSI, CASS)
• Executed waterfall requirements (design, implementation, verification, maintenance)
• Contributed to Agile Framework Methodology and Scrum roles helping to improve work flows
• Coordinated Timely Extraction of data using Oracle Toad (Essbase) Basic SQL Quary (select, from, where)
• Coordinated Timely Extraction of data using Oracle Toad (Essbase Oracle Hyperion reporting tools)
• Ability to organize, analyze and interpret data to explain complex irregularities or trends

Confidential, Charlotte, NC

Treasury Manager Implementation Coordinator

Responsibilities:

• General accounting principles
• Managed a portfolio of seventy seven Corporations with client wealth status over one million
• Managed Coached, Consulted, Educated on boarding of clients from Confidential & Confidential
• Portfolio management, Excel Skills, Pivot Tables, Multitasking, Product knowledge
• Client managed treasury point of contact between Sales, Commercial loans and small business online
• Consulted business to help enhance future on boarding of clients
• Provided onboarding support to business clients and internal associates with problem resolution, analysis, research, technical assistance, training, and general inquiries on all treasury - related products and services
• Arbitrated legal banking documents with Businesses
• Critical thinker with ability to analyze information and evaluate the implications of a course of action or strategy.
• Created intuitive spreadsheets to help micro filter, monitor clients, based on senior leadership's criteria and project timeline
• Self-motivated and creative problem-solver using all centralized and cross platform bank resources

Confidential, GASTONIA, NC

Sr. Treasury Analyst Officer

Responsibilities:

• General accounting principles
• Daily monitoring prior day and week ending cash balances for US and international locations
• Performed daily P&L and Financial Forecasting of accounts
• Completed various month end book close procedures and functions
• Coordinated cash daily forecasting data gathering, consolidation and analysis to completion
• Daily Cash management (bank statement prior day reconciliation) and current day balance forecasting
• Initiated wire payment administration (entry of payments, using knowledge of various payment types to complete funds movement, value date modifications, template setups, SWIFT/ABA,SEPA/ACH/GACH,NACHA,checks wires etc.)
• Cash and payment transaction research and issue resolutions and suggested enhancements
• Improved and report Domestic and international Europe cash flows for consolidated cash flow forecast
• Administrator of Deutsche bank banking platform, bank account setup and maintenance
• Administrator of JPM Access banking platform, bank account setup and maintenance
• Partnered with banks to complete signature updates, service modifications, opening or closing of foreign and domestic bank accounts
• Assisted implementation of new Treasury and HR system Oracle Fusion

Confidential, CHARLOTTE, NC

Sr Financial Analyst, Project Lead Six Sigma Officer

Responsibilities:

• General accounting principles
• E Ledger (SAP) System experience financial reconciliation analysis
• ln$ight system experience financial reconciliation analysis
• SAP, ln$ight, Oracle, extracting, manipulation and restatements data testing,
• Recompilation of historical balances during system evolution (balance sheet and ledger accounts)
• Worked with below the line memo accounts and above the line financial accounts
• Developed, improve and implement Multi currency and multi GAAP solutions
• Implemented SAP across bank to replace legacy systems, standardize ledgers and financial reporting
• Migrated existing accounting processes and functions to the target state
• Project lead using DMAIC (define, measure, analyze, improve, control) process to support Tax Teams desire for automated tax system
• Followed Deloitte hybrid enterprise value delivery (EVD) Process modeling
• Convened weekly business requirements gathering sessions with business partners
• Project Management overview as lead and assistant lead over various projects.
• Created, Delivered testing user scripts, functional scrip's and end to end user testing including BRD's
• Aris Modeling, Visio Modeling and working with Excel, Vlookup, Sumifs, pivot Tables to completion
• Basic writing of SQL Quary (Select, From, Where,Order By)
• Subject matter expert for creating functional User tsting (FUT). User acceptance testing (UAT), System Integration testing (SIT).
• Business Requirement Specs, Executive Summaries
• Followed generally Accepted Accounting Principles (GAAP) in reconciliations, analysis to help gain insight and promote new ideas
• Reviewed financials, balances, reconcile after Information Technology moved data
• Independently research complex accounting transactions from legacy systems to E Ledger (SAP) general ledger systems
• Work closely with other senior project managers to discuss current milestones and future improvements

Confidential, HICKORY, NC

SR International Treasury Analyst, Ireland Treasury Manager

Responsibilities:

• Performed cash accounting, cash reporting, journal entries in SAP and postings in treasury management system
• Modified and Performed daily bank account reconciliations and management with 343 accts
• Reviewed and Monitored auto postings for accuracy and performing re class entries
• Organized, Analyzed and Interpret data to explain complex irregularities or trends, Resolve transactional issues
• Completed various month end book close procedures and functions Adhere to SOX controls, treasury policies and procedures
• Refined, Calculated, Analyzed to fund Cash pooling, hedging analysis (Euro Pools)
• Administration over the global bank account network
• Subject matter expert responsible for executing and managing daily and weekly cash management activities
• Initiatied and analyzed, updated US intraday cash position and requested funding
• Uploaded, monitored prior day and week ending cash balances for US and international locations
• Customized the review of cash transactions, movements and growth
• Refined the Reporting of cash balances and analyze trends, profit and loss (P&L), booking general ledger acct balances
• Generate, compile and post cash management metrics and treasury reports
• Ensured internal control over cash management activities, and documentation (asset & liabilities balance sheet)
• Coordinated cash forecasting data gathering, consolidation and analysis (ERM) Enterprise risk Management
• Performed profitability analysis, forecasting and financial reporting being aware of value at risk, regulatory capital fundamentals, Basil II, Fas133, Funds Transfer Pricing (FTP)
• Performed International Money Management in order to fund bank accounts in a timely manner as required by master service agreements (MSA) (set funding cash position, meet with banks regarding borrowing and fees)
• Interfaced with banking personnel regarding products, services, technology and fees. Act as liaison between banks and the Company
• Coordinated global bank account openings and closings, including document execution and compliance with process controls
• Worked with the banking community to trace, recover and monitor misdirected wires and delayed wires
• Maintained bank and internal user database tracking and record retention systems for bank accounts, including signatories, users and user profiles, bank resolutions and signature cards
• Managed banking systems, connectivity and security. Perform periodic user audits and support regulatory reporting requirements
• Established and monitor bank service standards, including tracking and analyzing bank fees
• Issue LC's, track and accrue for LC fees and periodically report on outstanding LC's
• Supported transactional matters and inquiries, such as ACH transfers, positive pay exceptions, stop payment requests and returned items
• Provided training to business units regarding wires, four banking platforms, and problem solving as needed
• Balanced daily cash positioning of international bank account wire activity with accuracy and resolved all discrepancies
• Analyzed banking fees and transfer rates
• Managed, trained, mentored and year end reviews of shared service teams located in Ireland and Singapore
• Managed, Organized, Oversaw meetings as subject matter expert to conclude rollout plans of establishment of international business entities and foreign bank accounts including Saudi Arabia
• Deregistered and Registered international bank accounts for multiple corporate manufacturing plants
• Liaison with the legal and compliance departments to ensure compliance is achieved and risk is reduced
• Maintained, monitored, updated, improved the international treasury SharePoint rates database
• Assisted with accounting questions (deloitte audits)

Confidential, CHARLOTTE, NC

CDO Specialist

Responsibilities:

• Researched Collateralized Debt Obligations using Indentures, Databases and Bloomberg
• Setup new accounts and monitor, Maintain old accounts and addresses in SEI System Data Base
• Setup and maintain old and new accounts in Cert Master Data Base
• Add Modify and maintain Tickler information in the ACS Data Base
• Researched data in a timely manor using time management, analytical skills
• Reconciled and investigate accounts as needed

Confidential, CHARLOTTE, NC

Sr Treasury Securities Analyst

Responsibilities:

• Partnered with Underwriting Counsel and Director based on roles cited in Red Prospectus under guidelines of Lead, Sol Lead, Co Lead, Co Managed, Joint Lead, Joint Book, to process equity deals and to Close out P&L and reconcile General Ledger Systems for equity syndication's
• Performed functions of middle office and back office for Settlement of all Equity Common Stock and Fixed income Convertible Bond Deals (derivatives)
• Monitored common stock Equity portfolio and underwrite deal closing in a timely manner
• Worked close with front office trader to track, confirm and journal all funds and distribution of funds to Syndicate Co -
• Managers (Broker/Dealer relationship)
• Followed all guidelines of sec regulatory rules and regulations and underwriter guidelines to ensure proper
• settlement of equity (Common Stock and Convertibles)
• Settled all deal reimbursements and professional fees along with tracking dealogic fees and trailer fees
• Communicated effectively and Direct all traffic between Central Billing, Settlement, Clearance, OTC, front office and Depository Trust Company (DTC) and Equity/Equity Linked/Sales/Trading along with Equities Product Controller
• Submitted all applications as underwriter to DTC and Trustee agent
• Balanced accounts associated with deals, Journal funds to proper P&L accounts using Eagle or Phase II systems &
• Initiated Swift, Fed wire or Day loans to Bony Clearing desk Setup and request Cusip's
• Followed Sec Guidelines and review for Sarbanes & Oxley Compliance
• Collected out of pockets from Broker dealer relationship and track deal for 90 days
• Checked all shares short and long
• Communicated and report all subject matter and exceptions to Traders
• Maintained documentation for new issue IPO and secondary deals
• Resolved all settlement exceptions for each equity deal from trade date to settlement date to closing
• Requested Black and Red Prospectuses
• Communicated effectively with Trustee's and all Units to insure secure settlement and closings
• Arranged dayloan's over 50 Million Dollars
• Trouble shoot and analyze all discrepancies including the Deal tracking data base and account adjustments
• Use Cool Reports and Syndesk front office trading system to identify any discrepancies
• Tracked and balance Sales credits in Desi Work Flow system scot interface
• Reconciled internal accounts for each deal until 90 day closing to ensure a zero balance, research discrepancies as needed
• Communicated with underwriting counsel for deal information not disclosed in Bloomberg
• Balanced Equity accounts using Iris and General Ledger files
• Special projects include testing automation of Desi Work Flow system, updating Eagle database with new cells and the distribution of access rights to the deal tracking data base

Confidential, CHARLOTTE, NC

Business Analyst Team Leader

Responsibilities:

• Obtained extracted and sorted data to search fraudulent activities such as money laundering, terrorist financing and inappropriate materials research (Forensic Drill down, Accounts, Emails)
• Training high quality new employees on operational functions and servicing computer hardware and software as needed.
• Performing brokerage litigation research; in support of brokerage litigation clients; Electronic data research;
• using intuitive analytical and problem solving skills.
• Extensive attention to data management, risk management and loss prevention analysis
• Extensive use of Ghost, Attenex, Outlook, Terminal Services, Prep of Hard Drives, Zantaz, Excel
• Setup and networked new computers from Dell in new CIS computer room for department

Confidential, BUFFALO, NEW YORK

Financial Analyst II

Responsibilities:

• Calculated and analyze monthly Euro rates, Tranche Rates, Match funded rates on forty asset backed security portfolios used to fund the bank's Service Providers and Profit centers (SBU)" (This is spreadsheet driven)
• Researched and resolve questions relating to the Strategic Business Units (SBU) Report and Earnings Analysis System
• Printed and distribute Ad Hoc reports to correct business units
• Performed hierarchy and translation table maintenance of cost centers and legal entities (General Ledger chart of accounts)
• Created monthly product reports from numerous data bases and research areas of concern
• Calculated and monitor bad debt accounts

Confidential, BUFFALO, NEW YORK

Financial Analyst I

Responsibilities:

• Lead project to implement an automated control totals gui and also wrote GWBasic trigger file to show example to IT deparment
• Analyzed proper daily settlement of trades (swift codes, dates, rates, banks, amounts)
• Review Rates and manually input into system
• Reviewed swaps, spot and forward derivatives and confirm the settlement of foreign currency trades
• Monitored foreign currency bank accounts and reconcile daily
• Reconciliation of Inter bank FX trades and Capital market trades to be batched and processed
• Reconciliation of daily Profit & Loss (P&L) and Work in Progress (WIP) accounts and forecasting
• Draft Custodian and Controller of Foreign Bank Drafts locked in safety deposit box
• Custodian of the Office of Foreign Assets Control (OFAC) trade compliance Documentation to ensure trade security against unauthorized countries and businesses
• Successfully trained on all three Capital Markets Desks (Inter bank FX, Investigations, Commercial Merchant services FX)
• Keep secure records of current trades and total amount of foreign currency on hand before releasing to the
• Automated Clearing House (total daily trading volume between both desks 40 trades depending on the Market movement.
• Analyzed and input Forex FX exchange rates from Routers
• Effectively worked on special projects concerning Departmental Budget and the movement of department from New York City to Buffalo.
• As a liaison between IT and Treasury used prior programming language of Cobal and Quick basic to help programmers adapt a GUI (Graphical) interface for some treasury applications and for Excel CSV files used for search query's