Sign in

Treasury, Finance, Accounting, Business analyst

Charlotte, North Carolina, 28214, United States
75,000.00 +
January 23, 2017

Contact this candidate

Edward McElwain

***** ***** **** ****, *********, NC 28214



Highly organized, versatile Accounting & Financial Management professional skilled in Financial Analysis and Treasury Management including analytical aspects with expertise in overseeing daily Cash Management, 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. I have Six Sigma projects experience, Information Technology experience, Accounting principles and skilled in a multitude of online banking platforms.

Professional Experience:

April-2016 to August-2016

BB&T Bank, NC

Treasury Managed Implementation Coordinator

(temporary contract)

Treasury operations, Reporting, Portfolio managed clients

Managed a portfolio of seventy seven Corporations with client wealth status over one million

Managed on boarding of clients from National Penn to BB&T bank

Portfolio management, Excel Skills, Pivot Tables, Multitasking, Product knowledge

Online banking expert and treasury knowledge specialist

Client managed treasury point of contact between Sales, Commercial loans and small business online

Deposit and operations implementation management, helping clients with banking platform

Representative for Wires, ACH, Banking Statements, Token login, Loan information, Online Training etc

July-2015 to August-2015

Affinia Group Gastonia, NC

Sr. Treasury Analyst- Officer: Corporate Treasury Operations & Accounts Payable.

(temporary contract completed, acquisitioned by Mann & Hummel- August 2015)

Cash Management, Reporting, Forecasting & Administration

Assist implementation of new Treasury and HR system Oracle Fusion

Monitor prior day and week-ending cash balances for US and international locations

Complete various month-end book close procedures and functions

Administrator of Deutsche bank banking platform

Administrator of JPM Access banking platform

Coordinate cash forecasting data-gathering, consolidation and analysis

Experience with straight through processing and integrated payables

Experience working with domestic and international banking requirements

Senior in Foreign Exchange areas of business

Working in aspects of Bank Account administration (signature updates, service modifications, opening or closing of foreign and domestic bank accounts)

Daily Cash management (bank statement prior day reconciliation) and current day balance forecasting

Wire payment administration (entry of payments, knowledge of various payment types, value date modifications, template setups, SWIFT/ABA/ SEPA/ACH/GACH checks-wires etc.)

Cash and payment transaction research and issue resolution

Liaising and project management for projects between Cash management banks and internal departments for small projects, system upgrades, etc

Domestic and international Europe cash flows for consolidated cash flow forecast reporting

June-2011 to February 2015

Bank of America Charlotte, NC

Financial Analyst–Project Lead Six Sigma-Officer: Global Finance Operations, Finance Systems Management Matrix (laid off organization restructure)

Project management and Accepted Accounting Principles

E-Ledger (SAP) System experience – financial reconciliation analysis

Insight system experience- financial reconciliation analysis

SAP, In$ight, Oracle, extracting, manipulation and restatements data testing

Data Cleansing or extract, transform and load data (ETL)

Master Data Management (MDM)

Data Ware housing

Recomposition of historical balances during system evolution (balance sheet and ledger accounts)

Worked with below the line memo accounts and above the line financial accounts

Multi-currency and multi-GAAP solutions

Implemented SAP across bank to replace legacy systems, standardize ledgers and financial reporting

Migrating existing accounting processes and functions to the target state

Project lead using DMAIC 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

Molded a team to be able to focus and move forward and build on prior milestones

Creation of 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

Practiced Project Management as Lead and Assistant Lead over various projects

Writing functional work specs, Business Requirement Specs, Executive Summaries, System integration.

Functional user testing (FUT), User acceptance testing (UAT), System Integration testing (SIT)

Use Generally Accepted Accounting Principles (GAAP) in reconciliations and analysis

Creating functional user requirements & specifications along with Aris process flows

Leasion between tax and IT department

Review financials, balances, reconcile after information Technology moves data.

Independently research complex accounting transactions from legacy systems to E-Ledger (SAP) general

ledger systems

October-2007 to March 2010

CommScope Inc, Hickory, NC

International Assistant Treasury Manager (laid off acquisitioned by Carlyle Group March 2010)

Cash Accounting

Perform cash accounting journal entries in SAP or postings in treasury management system

Perform daily bank account reconciliations 343 accts

Monitor auto-postings for accuracy and performing re-class entries

Resolve transactional issues

Complete various month-end book close procedures and functions

Adhere to SOX controls, treasury policies and procedures

Performed Cash pooling (Euro Pools)

Cash Management, Reporting & Forecasting

Administration of the global bank account network

Responsible for executing and managing daily and weekly cash management activities

Determine US intraday cash position and request funding

Upload and monitor prior day and week-ending cash balances for US and international locations

Review cash transactions and movements

Report 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

Ensure internal control over cash management activities, and documentation (asset & liabilities balance


Coordinate 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)

Banking Account Governance & Administration

Interface with banking personnel regarding products, services, technology and fees. Act as liaison between banks and the Company

Provide treasury service expertise to internal business partners

Coordinate 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

Maintain bank and internal user database tracking and record retention systems for bank accounts, including signatories, users and user profiles, bank resolutions and signature cards

Administer banking systems, connectivity and security. Perform periodic user audits and support regulatory reporting requirements

Establish and monitor bank service standards, including tracking and analyzing bank fees

Perform compliance and regulatory reporting requirements, such as FBAR and FATCA

Transactional Support & Other Treasury Services

Issue LC’s, track and accrue for LC fees and periodically report on outstanding LC’s

Support transactional matters and inquiries, such as ACH transfers, positive pay exceptions, stop-payment requests and returned items

Post and record miscellaneous deposits

Provided training to business units regarding wires, four banking platforms, and problem solving as needed

Execute funds transfers

Balanced daily cash positioning of international bank account wire activity with accuracy and resolved all discrepancies

Analyzed banking fees and transfer rates

Mentored of shared service teams located in Ireland and Singapore and approve ACH wires

Conducted meetings as a project manager to conclude rollout plans of establishment of international business entities and foreign bank accounts including Saudi Arabia

Liaison with the legal and compliance departments to ensure compliance is achieved and risk is reduced

Maintained, monitored, updated the international treasury SharePoint database

May 2007 to August 2007

US Bank, Temporary Contract, Charlotte, NC

CDO Specialist: Trust Department (contract completed)

Research 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

Research data in a timely manor using time management, analytical skills

Reconcile and investigate accounts as needed

May 2004 to November 2006

Wachovia Bank Charlotte, NC

Accountant -Securities Back & Middle office: Equity Capital Market Team (laid off housing depression)

Cash Management Broker dealer

Work 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 syndications

Perform functions of middle office and back office for Settlement of all Equity Common Stock and Fixed income Convertible Bond Deals (derivatives)

Monitor common stock Equity portfolio and underwrite deal closing in a timely manner

Work close with front office trader to track, confirm and journal all funds and distribution

of funds to Syndicate Co-Managers (Broker/Dealer relationship)

Follow all guidelines of sec regulatory rules and regulations and underwriter guidelines to ensure proper settlement of equity (Common Stock and Convertibles)

Update deal folder and online tracking system data base with all details of deal

Settle all deal reimbursements and professional fees along with tracking dialogic fees and trailer fees

Communicate effectively and Direct all traffic between Central Billing, Settlement and Clearance and front office EC Ops Fail Control and Depository Trust Company (DTC) and Equity/Equity Linked/Sales/Trading along with Equities Product Controller.

Submit all applications as underwriter to DTC and Trustee agent

Balance accounts associated with deals, Journal funds to proper P&L accounts using Eagle or Phase II systems & Initiate Swift, Fed wire or Day loans to Bony Clearing desk

Setup and request Cusip’s

Follow Sec Guidelines and be Sarbanes & Oxley Compliant

Collect out of pockets from Broker dealer relationship and track deal for 90 days

Check all shares short and long

Communicate and report all subject matter and exceptions to Traders

Maintain documentation for new issue IPO and secondary deals

Resolve all settlement exceptions for each equity deal from trade date to settlement date to closing

Request Black and Red Prospectuses

Communicate effectively with Trustee’s and all Units to insure secure settlement and closings

Arrange 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

Track and balance Sales credits in Desi Work Flow system scot interface

Reconcile internal accounts for each deal until 90 day closing to ensure a zero balance, research discrepancies as needed

Communicate with underwriting counsel for deal information not disclosed in Bloomberg

Balance 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

Mentor co-workers on desk functions and daily operations to help further working knowledge to the department

December 2002 to September 2003

Bank of America Charlotte, NC - Business Analyst Team Leader: Corporate Information Security

(temporary service contract completed)

Monitor internal processes and leverages using six sigma methodology

Training 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; searching through financial data and creating electronic files for use

on CD-ROM applications, using intuitive analytical and problem solving skills.

Obtain extracted and sorted data to search fraudulent activities such as money laundering, terrorist

financing and inappropriate materials research

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

August 2001 to April 2002

Manufacturers and Traders Trust (M&T Bank) Buffalo, New York

Financial Analyst II: Corporate Finance Department (laid off 911 market depression)

Collateral Management, FX, Swaps, Derivatives

Calculate 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

Print and distribute Ad Hoc reports to correct business units

Perform hierarchy and translation table maintenance of cost-centers and legal entities (General Ledger chart of accounts)

Create monthly product reports from numerous data bases and research areas of concern

Calculate and monitor bad debt accounts

March 1999 to August 2001

Manufacturers and traders trust (M&T Bank) Buffalo, New York

Financial Analyst I: Foreign Exchange/ Treasury Department

Collateral Management, FX, Swaps, Derivatives

Analyzed proper daily settlement of trades (swift codes, dates, rates, banks, amounts)

Review Rates and manually input into system

Review swaps, spot and forward derivatives and confirm the settlement of foreign currency trades

Monitor 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


Bachelors Degree, Major in Finance -Minor in Information Technology

Hilbert College, Buffalo NY.

Contact this candidate