Lead Analyst Data Excellence Resume
2.00/5 (Submit Your Rating)
Washington, DC
SUMMARY:
- Extensive work experience in the financial services field and knowledge of GAAP and GIPS guidelines.
- Business expertise in Performance Measurement, Financial Analysis, Private Wealth Management, SEC Regulatory Reporting, Forecasting, Auditing, Performance Reporting, Process Management, Profit & Loss, Compliance, Management/ Financial Reporting, Relationship Management, Basel II and Accounting. Five plus years of Wall Street experience.
- Aptitude to understand business drivers, detail oriented with follow - up and follow-through skills.
- Ability to partner with the analytics teams and the Line of Business, manage partner relationships and lead projects.
- Provide various weekly, monthly, quarterly and ad-hoc reporting. Experience working from a Unix/Linux command prompt.
- Supports achievement of business goals by working on more complex projects with others within the unit and with business partners.
- Strive for continuous improvement in processes and tools by identifying needs. Capability to own a process from start to finish with autonomy. Identify issues, research root causes and recommend solutions.
- Possess strong business partnering skills, leadership abilities and data analytic skills. Ability to drive results in an integrated, complex and changing environment. Aptitude to analyze and interpret information and data.
- Highly motivated, analytical, possess great interpersonal, communication, quantitative and excellent problem solving skills and can work independently or in team settings. Document and analyze control deficiencies. Completed Project Management Institute training and pursuing PMP Certification.
TECHNICAL SKILLS:
- Microsoft Excel
- Microsoft Word
- WordPerfect
- CMS
- IAS
- Microsoft Works
- Lotus Notes
- AM Trust
- Access
- Bloomberg
- SEI
- Internet
- Invest One
- Sunguard
- Reuters
- INFORMPerformance
- INFORMCompliance
- Lotus 1-2-3 dBase IV
- INFORM AuditTools
- APL
- Zephyr
- Lipper
- Barra
- FactSet
- Crystal Reports
- In$ight iGL
- Pivot tables
- VLookup
- CLPR
- SQL
- Teradata
WORK EXPERIENCE:
Confidential, Washington, DC
Lead Analyst Data Excellence
Responsibilities:
- Oversee nightly automated process to deliver reports to internal stakeholders. Ensure consistencies in applications of our data by cross functional teams and evaluate new sources to pull into the consolidated reporting environment.
- Work closely with a team of Data Excellence Analysts to ensure they are up to date on all changes occurring in the data landscape.
- Establish relationships with key stakeholders to serve as an escalation point for any major reporting projects throughout the company.
- Work cross-functionally with a variety of internal teams to identify areas that data could be better leveraged.
- Prepare specific analytic deliverables, including reports, presentations and models that provide more timely insight into our data.
- Educate operational leads from across the company on how to better consume and manipulate our cross-functional data.
- Identify and evaluate other technologies that could be included in our strategic business processes.
- Standardize and document the consolidated reporting environment and all related output.
Confidential, Charlotte, NC
Senior Financial Analyst, AVP
Responsibilities:
- Conducted UAT Testing by creating SQL scripts to test the functionality of new regulatory requirements and Risk Weight Calculations. Scripts were tested to insure that the rules and regulations being tested within the calculator are being correctly implemented and the function of the new scripts follow the guidelines described.
- Created 101 Schedules for Regulatory Reporting Package. Created schedules for Cash Securities. Reports created for the overall Corporation as well as the 5 Subsidiaries. (108 schedules created on a monthly basis for SEC Regulators)
- Worked with LOBs to insert, delete and adjust data based on Ad-Hoc request. Utilized Excel, SQL and Oracle to accurately adjust data.
- Reconciled 101 Results from Teradata to the General Ledger. Utilized Excel to create General Ledger Matrix by GL accounts. Created SQL to pull reconciled General Ledger balances and compare balances to the Insight General Ledger tool for Confidential . Variances were researched for internal management reports.
- Created reconciliation of Non-Material balances, Synthetic Plug balances and Material balances by product line. Created and conducted trend analysis by product line, including breakout analysis of EAD, RWA and ECL.
- Created Desk Top Procedures used by internal and external auditors to follow the process conducted on a monthly basis in order to reproduce the 101 Reports. As process improvements are made the Desk Top Procedures are updated.
- Built Basel II Calculator in Excel to test data to insure that the calculators were functioning as described per the rules provided by the Federal Regulators.
- GWIM Senior Operations Analyst/ Performance Measurement Team Lead/Performance Analyst, AVP
- Responsible for managing data integrity, workflow, assigning responsibilities to appropriate team members, overseeing deadlines and ensuring that they are met in a timely, accurate and professional manner. Performed the internal audit on the investment accounts.
- Possessed the ability to interact with upper management and to keep track of organizational product changes as they relate to the group’s reporting activities. Conveyed analysis and conclusions in written and verbal communication.
- Supported many lines of business including Senior Executives, Portfolio Management, Marketing, Finance, Client Service, Sales, Compliance, Risk Management and Fund Administration. Examined and tracked investment portfolios worth over $20 billion of Separately Managed Accounts. Provided financial and analytical support to all levels of management.
- Responded to ad hoc requests for information and data. Identified and evaluated opportunities for improvement.
- Sustained product composite data and ensured that performance measurement and reporting remained in CFA Institute guidelines.
- Supervised the calculation of performance returns for a variety of portfolios and investment strategies, over 52,000 accounts.
- Responsible for communicating and resolving issues with internal and external auditors. Prepared detailed variance analyses, wrote explanations for variances and ensured that work standards are met. Participated in production of monthly management oversight reports.
- Analyzed, calculated and tracked performance returns for a variety of portfolios and investment strategies.
Confidential, New York, NY
Financial Analyst
Responsibilities:
- Analyzed and tracked investment portfolios worth over $6 billion of diversified equity, fixed income, hedge funds, real estate, etc. Supplied cumulative and annualized SEC returns and reports. Performed the internal audit function.
- Functioned as the Performance Consultant for assigned client relationships with regard to performance inquiries, investment manager reconciliation, ad-hoc/ custom reporting needs, client service reviews and participate in conference calls.
- Prepared, reviewed and delivered all client reports such as: universe comparison reports, attribution analysis and customized executive summaries. Provided account and segment level information to improve strategic decision-making.
- Participated in the presentation and explanation of performance data to the Board of Directors, Senior Management, Investor Relations and all other levels of management.
- Served as the relationship liaison to the Relationship Management team and business partners to drive understanding and use of methodology, tools and data.
- Researched and resolved performance reporting discrepancies through communication and contact with internal and external financial consultants, management, operations, administration and systems personnel of the firm.
- Provided thought leadership and analysis, while maintaining focus on data quality and voice of the business partner to evaluate opportunities for improvement. Produced custom performance analysis and custom reports on specific accounts.
- Reviewed, researched, understand, and communicated market trends and their impact on various investment products as they relate to client portfolios. Monitor client portfolios by reviewing investment allocations.
- Created Monthly Performance Reports within firm compliance guidelines by gathering client investment data (i.e. securities owned by a client) and provided a customized book that presents their securities benchmarked against comparable indexes.
- Monitored client portfolios by reviewing investment allocations, comparing performance of various mutual funds, hedge funds, and third party money managers against appropriate benchmarks.
- Gathered, compared, analyzed, and communicated investment research data to the clients and their external consultants to facilitate the investment allocation process.
- Investment Accountant
- Provided comprehensive analytical support to the fund group and knowledge of GAAP.
- Managed all aspects of Accounts Receivable and Accounts Payable. Assured compliance with quality control measures and procedures.
- Prepared Excel spreadsheets for General Ledger control, bank reconciliations, cash flow availability, income and expense accruals.
- Created custom financial statements reflecting investment account operations. Priced funds and booked trades.
- Calculated daily dividend factors and NAV’s for equity, offshore and municipal funds. Reconciled holdings, cash, accruals and expenses.
- Prepared daily fund level performance calculation on assigned funds and financial forecasting.
- Prepared daily price variance analysis on funds’ investment portfolios. Prepared accounting entries for a group of mutual funds.
- Performed daily bank reconciliations and general ledger accounts analyses.
- Updated accounting records for corporate actions on funds’ investment portfolios, prepared cash projections and resolved reconciling items.
Confidential, Murray Hill, NJ
Contract Administrator
Responsibilities:
- Assisted contract administrator in a special project to eliminate $100 million of billing backlog in the financial database.
- Utilized and manipulated spreadsheets to input correct data to be inputted for the transference into databases for billing customer files.
- Assisted in successful problem resolution of accounts and maintained tracking report of transfers for auditing purposes.
