Project Manager And Senior Financial Analyst Resume
Charlotte, NC
SUMMARY:
- Fortune 500 Banking, Manufacturing experience and Telecommunications Revitalizes improvement in Finance, Treasury and Cash Management along with good communication partnerships Business analyst project work is present in all my jobs Concept - to-execution strategies solutions that yield 50% revenue growth using Project Management (Agile, Waterfall Agile, DEMAIC, Six Sigma).
- Banking, Manufacturing, Telecommunications industry Experience
- Balance sheet and GL ledger (General Accounting Principles).
- Global Finance, Accounting
- Daily Cash Management (accounts receivables, accounts payables, funding, analysis, billing)
- Foreign Exchange
- Project Management (MS office programs, Financial systems and applications)
TECHNICAL SKILLS:
SKILLS: Business Analyst: 17+ yrs Capital Mkts: 15 yrs Treasury: 15 yrs Finance: 15yrs BRD/FSD: 12+ yrs Risk and Governance: 13+ yrs Regulatory: 12 yrs SQL: 6 months SOX: 10 yrs Testing: 12 yrs. MS Office (Share point, Excel, Visio, P.P, Outlook, Word, etc.): 15 yrs Aris modeling: 3 yrs Project work: 17 yrs
PROFESSIONAL EXPERIENCE:
Confidential, Charlotte. NC
Project manager and Senior Financial Analyst
Responsibilities:
- Performed advanced and confidential support for multiple directors; handling various tasks and prioritizing personal workload to meet objectives and deadlines.
- Duties include financial management, financial reporting, accounting deliverable, financial modeling, calculation and measurements
- Capital Expenditures (Capex), Project Revenue, Invoice analysis, budgeting and spend to date (partial FP&A),
- Invoice, Disputes cost analysis, Research support
- Established key relationships with operational leaders to drive financial and business analysis reporting aimed at influencing business decisions
- Worked across business functions to lead pricing opportunities
- Creative problem solving, innovative thinking, prioritizing, development and budgeting
Confidential, Charlotte, NC
Finance Project Consultant
Responsibilities:
- Corporate Finance Controllers Diviion, Reporting Solutions (Contract, Project ended)
- General accounting principles
- Created new Financial Excel spreadsheets and enhance older versions increasing efficiency of department (analyzed and prepared financial reports)
- 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 resolvedunusualtrendsand 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)
- Ability to organize, analyze and interpret data to explain complex irregularities or trends
Confidential, Charlotte, NC
Finance/ Treasury Manager Implementation Coordinator (Project Manager)
Responsibilities:
- Managed a portfolio of seventy seven Corporations with client wealth status over one million each
- Tracked, Managed Coached, Consulted, Educated on boarding of clients from National Penn to BB&T bank
- Reviewed Clients accounts to keep up to date and active
- Main point of contact for financial topics related to all clients such as accounts including loans
- Provided recommendations to sales staff for possible bank product upgrades to save client money and minimize risk of default.
- Portfolio management, Excel Skills, Pivot Tables (data sets), 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,, 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, CHARLOTTE, NC
Finance/ Sr Financial Analyst, Project Lead Six Sigma Officer
Responsibilities:
- Global Finance Operations (laid off organization restructure & was actively seeking employment)
- General accounting principles
- Big Data experience (Volume, Velocity, Variety, Variability and Complexity)
- E - Ledger (SAP) System experience - PC savey financial reconciliation analysis ln$ight system experience- financial reconciliation analysis
- Business Analytics Tool (BI) (this is internal proprietary customized)
- 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 process to support Tax Teams desire for automated tax system
- Followed Confidential 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 testing (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
- Worked directly internally and externally with Information Technology areas (business analyst)
- Independently research complex accounting transactions from legacy systems to E-Ledger (SAP) general ledger systems
- Worked closely with other senior project managers to discuss current milestones and future improvements
Confidential, HICKORY, NC
Finance/ Sr International Treasury Analyst, Ireland Asst Treasury Manager
Responsibilities:
- Analzed current and future financials and variances of account levels verse trend of expected future funds
- 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 and bank resolutions, signature cards
- Subject matter expert responsible for hands on executing and managing daily and weekly cash management activities including journal entry
- Initiated 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 (debt analysis and reporting)
- Refined the Reporting of cash balances and analyze trends, profit and loss (P&L), booking general ledger acct balances
- Generated, compiled and posted cash management metrics and treasury reports
- Ensured internal control over cash management activities, and documentation (asset & liabilities balance sheet)
- Coordinated hands on cash forecasting data-gathering, consolidation and analysis (ERM) Enterprise risk Management
- Performed hands on 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
- Performed 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
- Supported transactional matters and inquiries, such as ACH transfers, positive pay exceptions, stop-payment requests and returned items
- Provided 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
Confidential, CHARLOTTE, NC
Finance/ CDO Specialist (Collateralized Debt Obligation)
Responsibilities:
- Trust Department (contract & actively seeking employment)
- 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
Finance/ Sr Treasury Securities Analyst Back & Middle office
Responsibilities:
- Equity Capital Market Team, Cash Management Broker dealer (laid off housing depression with bank acquisition & was actively seeking employment)
- 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)
- Support the general accounting functions by preparing/reviewing/inputting accruals, reversals and journal entries to close out deal
- 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 GL journal entries, 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