Business Analyst Contractor Resume Profile
NJ
Technical Business Analysis / Project Management
Technical Business Analysis / Project Management Business Analyst and PMP Certified Project Manager who excels in customer relationship management, requirements definition, testing, data modeling, and reporting and project management. Exceptional analytical skills with successful history of integrating project management and business analysis skills resulting in significant operational efficiency gains and cost savings.
Core Business Skills
- Stony Brook Business Analysis Certification
- PMP Certification
- Business, Functional Requirements, Use Cases Process Swimlanes
- Testing Approaches Management Development
- SDLC, SOX and PMP Standards
- Strong written, verbal and communication skills.
- Reference Data Subject Matter Expert SME
- Use of Agile Scrum Methodology
- Experience with Financial, reference data, GL, regulatory data, credit position, loan systems
- Relationship Management
- Cross-Group Multiple Project Management
- Customer Relationship Communication Focus
- Overseas and Domestic Co-location Management
- Merger Management Analytical Experience
- Audit SEC Compliance reporting
Core Technical Skills
- BI Business Intelligence Reporting Systems
- Business Objects WEBI
- Data warehouse experience Oracle, MS SQL
- Strong SQL Query skills Toad, Access, DbArtisan
- Rapid comprehension of new technologies
- MS Office/ Project, Mercury Quality Center,Visio
- 98 Data Warehouse Brain Bench Assessed
- Data Modeling participation
- Functional Management of multiple applications including Business Objects, MS SQL, Client Server, Lotus Notes and Mainframe
Professional Experience
Confidential
Business Analyst Contractor
- Performing the function of business analyst for the Asset Management replacement project for the Confidential. The project utilizes the Confidential product produced by Confidential to replace legacy applications. Worked in an Agile environment using Scrum.
- Performed analysis of the announcement capture function for Investment Bank. The announcement capture sources addressed were Confidential
- Performed analysis of SWIFT format generated internal announcements
- Performed analysis of Position Request Response function for security notifications.
- Designed utilization of ISO20022 format messages for receiving internal dividend announcement information
- Created FRD's for SWIFT and GCA announcement processing functionality, internally generated announcements, and GCA format feed to legacy systems and position request response.
- Created process flow documents utilizing Visio demonstrating the flow of announcements, the generation of internal announcements and the creation of the GCA format feed.
- Designed methodology to extract heritage information stored in BaNCS engine and transmit the data in GCA format to legacy systems, replacing the legacy system feed. Utilized DB Artisan tool to analyze data required for the feed.
Confidential
Business Analyst Contractor
- Performed the function of business analyst for a series of projects in the for the Q RM Quality Risk Management group at Confidential.
- Updated the annual process for Partner Rotation Control. This included creating BRD FRDs for interfaces, Daily Process, Initialization and On-line Form Specification requirements. Changes were due to the replacement of existing source with SQL Database.
- Created BRD FRD's for two Lotus Notes systems Subpoena tracking and Lobbying and Political Compliance . These requirements were in support of a series of work order changes which comprised a release.
- Performed Business Analysis and built BRD, FRD's, traceability index for Fashion Designer voting web site to include email notification to external voters containing logon information.
Confidential
Project Manager
- Managed Business Analysts in support of various projects related to Overseas reporting of Insurance information. Interacted with customers and IT to ensure projects were delivered in an accurate and timely basis.
- Supported Business Analysts in testing of methodology for converting foreign currency to US Dollars in order to improve consistency of reporting.
- Supported conversion of marine data to amortize insurance payments consistent with other products as opposed to immediately realizing payments
- Testing Conversion of reports from mainframe platform to Cognos generated reports and ensuring consistency between the mainframe and new Cognos reports.
Confidential
Business/Systems Analyst
- In support of Audit and Confidential compliance requirements, managed and executed project, following SDLC and SOX guidelines, activating FAS-91 Financial Accounting Standards Board rule for amortization of loan fees on mortgages in Jack Henry SilverLake Product.
- Eliminated intensive month end effort and improved validation of FAS-91 process.
- Created excel spreadsheet to limit impact of functionality for loan operations.
- Developed Specifications for Data warehouse reports to Support FAS-91 mortgage verification.
- Developed and implemented customer training for new FAS-91 process.
- Relationship management with Business Users to develop business requirements for the FAS-91 process
- Created BRD, FRD, traceability index, process flow work flow diagrams to document process.
Confidential
Reference Data Functional/Project Manager/System Analyst
- Led analysis effort while managing numerous projects related to processing of Corporate Reference Data. Subject Matter Expert SME for IT Reference Data on steering committee.
Confidential
Business Intelligence Reporting Application- Project Manager Key Analyst
- In partnership with Business Organization, managed creation of single source reference inquiry system. Worked with DBA, modelers, and Business Analysts to create the structure for Reference Data Warehouse utilizing Oracle 9i. Worked with the Business Intelligence team to design model, develop specifications, coordinate infrastructure, testing and disaster recovery requirements for Business Objects WEBI Reporting.
- Positioned for elimination of 3 legacy systems with annual savings of over 1 million.
- Completed three major implementations for reference dimensions over two years.
- Interaction with business community to ensure requirements were properly defined and met
- Lead in data model design of STAR structure views for reporting.
- Merger Conversion for Reference Data - Project Manager Key Analyst
- Lead analyst and Project manager in collaborating with internal business and technical customers across merger organizations to analyze requirements develop functional specifications to synchronize entity reference data between Heritage JPMC and Bank One applications.
- Working closely with the business community, helped uncover and advocated for pain point operational issues resulting in significantly improved reporting accuracy and reduced operational time to finalize hierarchy by 20 .
- Utilized MS/SQL data mart to reduce development time for distribution between applications.
- Migrated organization maintenance from Heritage MDM/Hyperion application to JPMC application.
- Provided mapping data corporate wide for account, hierarchy and legal entity. Created process model for information flow.
- Acted as consultant for data model design of data warehouse of reference data.
Confidential
Project Manager Key Analyst
Key participant in Analytical Task Force addressing organization expansion, identifying over 100 affected systems for expansion of attribute size needed for merger integrations. Managed project working with business team, which identified over 500 interfaces, reports and processes for strategic Reference warehouse, reporting, maintenance and ETL delivery. Reduced time to approve accounts by 35 by working with clients to implement replacement Account Request System and providing true validation data feed from MS SQL data mart.
Confidential
Budgeting Forecasting: Project Manager
- Managed development of multiple applications utilizing Oracle Financial Analyzer OFA Package, continued support of Impaired Loan System Loan Fees and Foreign Withholding Tax , Overseas General Ledger Feeder system, and Off ledger transactions for Fed and Annual Reporting. Worked with business partners across lines of business to define, review and update requirements.
- Retired Budgeting application with new annual Planning Budgeting system using OFA.
- Allowed for planning and budgeting at a more granular level detail vs. corporate summary .
- Increased accuracy and frequency quarterly to monthly of Forecast data firm wide.
- Automated process of allocating corporate expenses across corporation replaced Excel .
- Managed relationship with Business users in developing budgeting and forecasting requirements
Confidential
Project Manager/Application Lead/System Analyst
- Manager and Analytical contributor to application supporting: Impaired Loan Instrument Reporting FAS-114 , Amortization of Fees/and Costs FAS-91 , and Foreign Withholding Tax. Applications were in compliance with Generally Accepted Account Rules GAAP and Regulatory Accounting Rules RAP .
- Worked closely with Business Users to build and refine BRD's and FRD's resulting in improved accuracy and timeliness of data to SEC and Lines of Business by successfully implemented Impaired Loan Instrument System for calculating data in accordance with FAS-114 rules. Retired excel spreadsheet system.
- Actively participated in analysis, technical direction, data modeling for database design.
- Reduced development time by 30 by incorporated the FAS-91, Foreign Withholding Tax and Past Due mortgage, loan, security Instruments into the Impaired Loan System.
- Reduced annual support cost by retiring applications for FAS-91 and Foreign Withholding Tax.
- Designed MS SQL Data mart and Powerbuilder application with open architecture allowing easy incorporation of additional functions and specialized security.
Confidential
Application Lead, Key Analyst
- Provided 90 reduction in production of Daily Fed Reports
- Eliminated 10 individual applications at Line of Business Level with new corporate-wide Subledger Accounting System. Project Lead and key person for design and data mart model.
- Lead Analyst in Credit Position Reporting CICS/VSAM system for Factoring Group.