Finaial Analyst Resume Profile
3.00/5 (Submit Your Rating)
NC
Professional Experience
Confidential
Financial Analyst
- E-Ledger SAP System experience financial reconciliation analysis
- Insight system experience- financial reconciliation analysis
- SAP , In ight Journal entry testing
- Project lead using DMAIC process to support Tax Teams desire for automated tax system
- Writing functional work specs, Business Requirement Specs, Executive Summaries, System integration
- Followed Deloitte 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
- Assisted Change Managers in deliverables
- Learned data flow and communication of bank systems using SAP, Insight, ML Oracle
- Implemented SAP across bank to replace legacy systems, standardize ledgers and financial reporting
- Practiced Project Management overview as lead and assistant lead over various projects.
- Extracting, manipulation of line item data and reports from In ight, Eledger SAP , Oracle.
- Creation of testing user scripts, functional scrip's and end to end user testing.
- Aris Modeling, Visio Moldeling and working with Excel, Vlookup, Sumifs, pivot Tables
- Practiced Project Management as Lead and Assistant Lead over various projects.
- Confidential
- Financial Analyst Cash Management: Corporate International Treasury
- Managed daily and monthly international cash flow forecasts in excel and obtained and monitored daily cash positions.
- Provided financial analysis of inter-company, financial reporting, and documentation asset liabilities balance sheet
- Balanced daily cash positioning of international bank account wire activity with accuracy and resolved all discrepancies
- Performed profitability analysis, forecasting and financial reporting being aware of value at risk, regulatory capital fundamentals, Basil II, Fas133, Funds Transfer Pricing FTP
- Performed P L income statement analysis using Excel Software
- Determine daily financial international funding requirements for all international entities
- Assisted in quarter end close duties and audit activities
- Extracted global financial data from various bank accounting systems and lockboxes.
- Provided weekly financial reporting on all 343 plus bank account balances and reported discrepancies
- Analyzed banking fees and transfer rates
- Determined banking product services, gathered business requirements by interviewing domestic, foreign banks along with business units and translated data into technical specifications
- Managed the opening and closure of bank accounts associated with subsidiaries that have been registered or deregistered under the parent of CommScope Inc.
- Conducted meetings as a project manager to conclude rollout plans of establishment of international business entities and foreign bank accounts Saudi Arabia
- Reconciled and entered SAP quarter end journal entries belonging to business units
- Mentored of shared service teams located in Ireland and Singapore
- Performed International Money Management in-order to fund bank accounts in a timely manner as required by master service agreements MSA
- Performed Cash pooling Euro Pools
- Worked with the banking community to trace, recover and monitor misdirected wires and delayed wires
- Administrator of 4 banking platforms including the Citibank banking platform responsible for all security and account setups and access
- Maintained signatories, created board resolutions, maintained users and profiles of online banking systems
- Coordinated execution of bank documents, checklists, signatories for bank account openings and closings
- Responsible for understanding problems, bringing issues to resolution, and escalating as necessary to meet timelines
- Responsible, directly and through subordinates for managing all activities and people associated with highly complex account projects of foreign exchange
- Multitasked between daily Project work, Bank platform supervision, administration of shared services teams and financial accounts which requires strong organizational skills
- Provided training to business units regarding wires, four banking platforms, and problem solving as needed
- Proficient in learning new operational systems and can do management style
- Communicated effectively with legal groups, bank representatives and internal business units pertaining to specific projects
- Liaison with the legal and compliance departments to ensure compliance is achieved and risk is reduced
- Utilize extensive prior banking industry experience to develop banking plans to help manage and reduce Global Foreign exchange risk to the customer or the company
- Developed, coordinated, planed, executed and implemented economic and cash management strategies and solutions consistent with Treasury guidelines
- Maintained, monitored, updated the international treasury SharePoint database
- Provided flow chart modeling of various transactional functions
Confidential
CDO Specialist
- 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
- Confidential
- Accountant Securities Back Middle office: Equity Capital Market Team
- 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 system, Send out fed wire payments
- 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
Confidential
Business Analyst Team Leader
- 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
Confidential
Financial Analyst II
- 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
- 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
Confidential
Financial Analyst I
- 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
