Senior Business Analyst Resume
Harrison, NY
SUMMARY:
- Senior Business Analyst and with over 20 years experience managing complex projects for the financial services industry. Business process improvement / re - engineering expertise combined with information technology experience and strong management consulting discipline. Well versed in several structured methodologies including PMBOK, ITIL and CMM. Solid analytical skills to assist clients with business case development, package evaluation/selection, ROI and other cost / benefit analysis.
- Proven ability to organize structure and lead multiple projects, programs, and PMOs in the Financial Services industry. Industry experience includes insurance, institutional and private banking and credit card processing. Successfully managed compliance and regulatory engagements in Sarbanes - Oxley, Dodd Frank and FATCA.
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
PROFESSIONAL EXPERIENCE:
Confidential, Harrison, NY
Senior Business Analyst
Responsibilities:
- Analyze network fault logs to better understand bottlenecks, volume and vulnerabilities within the network
- Developed Perl scripts to parse log file data for heat-map Visio Flows and spreadsheet analysis
- Utilized pivot tables and MS Access database tables to isolate device failures and volume overload points
- Develop metrics and service levels to be used by third party vendors who manage and maintain infrastructure
- Liaise between management and third party vendors to ensure adherence to new service levels
- Managed project plan, risks, issues, quality assurance/UAT testing and management reporting
Confidential, NYC
Senior Business Analyst
Responsibilities:
- Gathered and documented requirements with internal and external clients for design and function of utility
- Developed and administered an RFI and RFP to evaluate twelve vendors
- Facilitated scoring and short-listing of participating vendors
- Developed business case and key indicators around proposed utility
- Managed project plan, risks, issues and reporting
Confidential, NYC
Senior Business Analyst
Responsibilities:
- Assessed process and data gaps between current state and target state model
- Performed data mapping, process modeling (KYC, AML, Enhanced Due Diligence, Sanctions Screening, etc.) data modeling, data aggregation, and validation logic between current and target model
- Gathered requirements and developed business requirements (internal and external clients) 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 KPIs, KRIs, 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 and client reference data for quality assurance testing and data validation
- Liaised with Legal/Compliance and Business units on all process changes to ensure that they are accurate and consistent with regulatory requirements
Confidential, NYC
Senior Business Analyst
Responsibilities:
- Developed Perl scripts and SQL Queries to create Management Reporting on status of client remediation
- Wrote SQL queries to validate client reference data and manage quality assurance/UAT
- Developed management dashboards in Access and ASP for tracking on-boarding activity and efficacy
- 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.
- 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 and Ops Risk on all process changes to ensure that they are consistent with regulatory requirements
Confidential, NYC
Senior Business Analyst
Responsibilities:
- Developed and managing to the project plan and QA testing plan for this initiative
- Manage a team of developers and analysts (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 via SQL in support of Sales Team - coding in C# and Java script
- Documented all processes and flows in Visio
Confidential, Stamford, CT
Senior Business Analyst
Responsibilities:
- Managed a team of analysts to capture business requirements for system build
- Managed a team of developers (4) to achieve milestone deliverables on time
- Performed data mapping and data processing to facilitate system entitlement profiles
- 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 (SQL) and upload to Management System
Confidential, New York, NY
Senior Business Analyst
Responsibilities:
- 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, New York, NY
Senior Business Analyst
Responsibilities:
- 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
- Managed data conversion from legacy db to target system and validated via SQL queries
- 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, New York, NY
Senior Business Analyst
Responsibilities:
- 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, New York, NY
Senior Business Analyst
Responsibilities:
- Managed conversion of statements and statement plating (i.e. name and address scrubbing and consistency) as well as ACAT funds transfer
- Documented all applicable business processes in Visio
- 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, New York, NY
Management Consultant
Responsibilities:
- 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.