Senior Business Analyst Resume Profile
NyC
SUMMARY
- Senior Business Analyst and with over 20 years experience managing complex projects for the financial services industry. Business process improvement / reengineering expertise combined with information technology experience and strong management consulting discipline. Proficient in several structured methodologies including PMBOK, Client on boarding, CRM and CMM.
- Proven ability to create, structure, manage and lead multiple projects, programs, and PMOs in the Financial Services industry, including insurance, institutional and private banking and credit card processing. Expertise in process reengineering, systems implementation, infrastructure, software, business systems, customer service, technical service, project/program organizational management, and continuous improvement through CMM methodology. Experienced in Sarbanes Oxley 404 controls review, ERP package implementations for Best Practices Reengineering, Data Warehousing, Decision Support, Business Intelligence, and Process Redesign / Outsourcing. Strong business analytics to assist clients with business case development, package evaluation/selection, ROI and other cost / benefit analysis.
EXPERIENCE
Confidential
Senior Business Analyst
- Senior Business Analyst managing the outsourcing of Private Wealth Client On-Boarding processes and procedures to external vendor. Project objectives are to configure vendor system to accommodate all Client On-Boarding functionality and workflow so that these and all other back-office functions can be outsourced. Ensured Quality Control and compliance with AML, KYC, BSA, OFAC and FinCen requirements.
- Assessed process and data gaps between current state and target state model
- Performed data mapping, data modeling, data aggregation, and validation logic between current and target model
- Gathered requirements and developed business requirements documents for target state COB functionality in NetX360
- Wrote all Business Requirement Documents and Use Case testing documents for transition to vendor
- Assessed business risks between current state and target state model
- Established KPI's, KRI's, data governance and MIS reporting
- Developed project, testing and implementation strategies and operational risk/process controls in accordance with COSO, COBIT and ITIL standards
- Wrote Perl scripts and SQL Queries against Client Master DB for data validation
- Liaised with Legal/Compliance on all process changes to ensure that they are consistent with regulatory requirements
Confidential
Senior Business Analyst
- Senior Business Analyst managing the redesign and global deployment of an institutional client on-boarding process KYC, AML, Sanctions Screening with the objective of ensuring a more efficient on-boarding of new clients and accounts. Project objectives are to streamline the client and account set up process, increase set-up efficiency, document management and expedite on-boarding time for client to trade.
- Senior Business Analyst for Dodd-Frank client remediation initiative. Developed requirements for Dodd-Frank strategy for institutional fixed-income clients. Developed User Interface and Database for tracking remediation of clients based upon remediation strategy. Developed management reports on remediation progress.
- Developed Perl scripts and SQL Queries to create Management Reporting on status of client remediation
- Developed management dashboards in Access and ASP for tracking on-boarding activity and efficacy
- Gathered requirements and developed business requirements documents for development of On-Boarding dashboard for senior management, data integration with various vendors and performed all data mapping between MS and its vendors
- Developed metrics for reporting On-Boarding statistics and designed dashboard and reports
- Assessed gaps and gap remediation between old process and renovated process
- Liaised with Legal/Compliance on all process changes to ensure that they are consistent with regulatory requirements
Confidential
Senior Business Analyst
- Senior Business Analyst for the development and rollout of a global and centralized document repository for all TR Master Service Agreements and other contractual client documents
- Developed and managing to the project plan for this initiative
- Manage a team of analysts 4 to gather business requirements
- Manage a team of developers 5 for specific functionality within the centralized repository
- Specified and oversaw development of a repository reporting engine/dashboard for senior management
- Developed Web Application in ASP.NET with Oracle DB backend to pull real-time product and pricing data in support of Sales Team coding in C and Java script
Confidential
Senior Project Manager
- Senior Project Manager for a convergence and integration initiative between RBS and Greenwich Capital. Phase one of the project is the global rollout of an entitlements engine to manage all application's permissions throughout the company. Managed project budget of 1.85MM in spend and duration of at least of 18 months. Reported into a London based PMO
- Managed a team of analysts to capture business requirements for system build
- Manage a team of developers 4 to achieve milestone deliverables on time
- Conducted interviews with application owners to regularly extract permissions data
- Liaised among senior management, application business owners and application IT owners on a regular basis for information, status and updates
- Developed Perl scripts set up on scheduled batch jobs to query User Entitlements data and upload to Management System
Confidential
Senior Business Analyst
- Senior Business Analyst for an initiative to replace Internal Audit's fieldwork and issues management suite used by internal auditors, external auditors and senior management. Developing and managing business requirements and functional specifications for Internal Audit's replacement of its firm-wide audit and issues tracking suite
- Analyzed legacy audit applications for baseline user and system requirements
- Migrated legacy database from MS Access to SQL Server
- Conducted extensive interviews with legacy system users and system maintenance resources
- Conducted extensive interviews with software vendors on package functionality for internal audit
- Organized and managed vendor demonstrations highlighting required functionality
- Performed package evaluation and fit analysis against the Bank's requirements and performance needs
- Made a quantitative evaluation of third party packages and a final recommendation to the Bank
Confidential
Senior Business Analyst
- Senior Business Analyst for the development of a java based software suite to support the Basel II initiative to evaluate and manage the firm's Operational Risk
- Developed business requirements and functional specifications for Management Control's Division's MCD next generation, firm-wide integrated control assessment platform
- Led team of business analysts and developers to build an integrated software suite for IT and Financial auditors to manage documented issues and track resolutions
- Implemented Issues Management System - provides workflow for managing issues to closure
- Implemented Data Warehouse for Risks, Controls, Issues and Resolutions
- Developed requirements, specifications and managed the development of the reporting system for Operational Risk issues and resolutions
- Liaised with both internal and external software development groups to provide use cases, process flows, functional specifications and prototypes
- Developed requirements, specifications and managed the data conversion effort from legacy audit system to its replacement
Confidential
Senior Business Analyst
- Senior Business Analyst for supply chain management software implementation for a company-wide Order to Cash implementation using Infor's GEAC ERP. Expected savings exceed 4 million in annual spend. This project required business partner cooperation, substantially reorganized internal business processes, software installation and customizing. Leveraged functionality from existing GEAC legacy system, which currently serves as the books and records for the business. Developed thin client front end system for requisitioning with multi-tier approval workflow and vendor punch-out functionality. Developed three way matching process for invoice processing with integrated exceptions reporting:
- Led team of business analysts to develop the business requirements for the to-be state Purchase to Pay supply chain
- System integration and software development following SDLC best practices
- Thin client requisitioning system with integrated vendor punch-out and approval workflow
- Established PMO to enforce strict controls around the Order to Cash process
- Gathered business requirements and translated them into specifications for technical development
- Developed an automated approval workflow for requisitioning and invoice processing
- Implementing Docushare to achieve paperless office environment
Confidential
Senior Business Analyst
- Senior Business Analyst for Convergence, an extensive conversion/integration project of their Private Wealth Management PWM Group. Convergence refers to the mapping and converting all aspects of client's accounts, brokers, offices and all other related entities across business units MS Co Dean Whitter . Project objective: Converge high net worth clients from MS institutional platform to a retail platform providing clients full range of MS retail products and services with minimal or no disruption to statement reporting, brokerage access, etc.:
- Managed conversion of statements and statement plating i.e. name and address scrubbing and consistency as well as ACAT funds transfer
- Liaised between department heads and technology staff for all systems development
- Facilitated meetings with product and technology team managers to develop time and cost estimates for the delivery of functionality required to satisfy project requirements Managed the testing, role out and communication of functionality and technology deployed in support of project goals
Confidential
Project Manager JH Cohn
- Performed a SOX controls review of financial reporting capabilities for AIG. Developed a BPR and Change Management plan for migrating from a spreadsheet-driven system to an integrated, financial reporting and consolidation system.
- Managed Vendor and Package Selection for replacement consolidation system Hyperion Financials
Confidential
Director of Technology - QSP
- Technology director responsible for technology operations as they support the business, including eCommerce, infrastructure, vendor data feeds, security, Websites and Webservices.
- Project manager for redesign and redeployment of eCommerce via RD.com
- Project manager for redesign and redeployment of QSP.com
- Implemented Data Warehouse and Microsoft's Analysis Services for all magazine subscription feeds from EDS
- Implemented Crystal Reports for all management reporting of magazine sales and revenues
Confidential
Management Consultant
Management Consultant, well organized and steeped in a structured methodology approach to project management, systems development, and client management specializing in best practices reengineering for full life cycle SAP and other ERP package implementations focused on the financial services, media, and communications industries. Position required skill set and expertise in reengineering, project management, process mapping, process redesign and ERP package implementation. Utilized extensive experience and background in financial services sector banking, brokerage and insurance strong communications skills both verbally and in presentation style strong and insightful analytical skills.
TECHNICAL SKILLS
SQL, ASP.NET/C , MS Access/VBA, Perl, Visual Basic / VB Script, Java Script, COGNOS, Business Objects, Hyperion, Visio, MS Project, Sybase, MS Office Suite, SharePoint
