RICHARD AMPONSAH
SUMMARY
Proficiency: Matlab, ML, Python, R, SPSS, JS
●Business/systems Analyst with solid understanding of Business Requirements Gathering, Business Process Flow, Business Process Modeling and Business Analysis.
●Specialization in Value-stream mapping, Business Analysis and Design, Business Support Systems.
●Extensive experience in creating Requirements, Use Cases, User Stories, Functional Specs, High Level Design, Data Flows, Business Process Modeling and Entity Relationship Diagrams
●Developed effective working relationship with business users to understand support requirements.
●Proficient in capturing business requirements through a variety of techniques, adept in gathering, developing and documenting Business Requirements Documents (BRD’s) using Rational Unified Process (RUP)
●Expertise in identifying, developing and documenting business and Functional Requirements Specifications (FRS), System Design Specification (SDS), System Requirement Specification (SRS), organizing one-on-one discussions, workshops, JAD, Project planning, presentation skills, resolving issues and conflicts.
●Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME’s), Development and QA teams.
●Have exposure in educating internal customers on business systems and procedures and working with other analysts and QA team to set priorities and schedules.
●Good Experience in Customer Migrations/Data Integrations.
●Experience in writing and reviewing Test Cases and Test Plans; and performing User Acceptance Testing
TECHNICAL & COMPETENCIES SKILLS:
Management & Business Tools: MS Project, MS Visio, MS Office
Business Analysis & Modeling Tools: MS Visio, Rational Rose
Platform: Windows XP, Windows 10, Windows NT, Windows server 2003/2008
Database: SQL server 2005/2008/Oracle, MS Access
Testing and Support Tools: Quality Center
System Development Life Cycle (SDLC) Process: Inception, Elaboration, Construction and Transition.
Documenting Requirements: Document analysis, Interface analysis, conducting interviews, surveys focus groups and Joint Application Development (JAD) sessions
Requirement Documentation: Business Requirement Document (BRD), Functional Requirement Document (FRD), test requirement gathering.
Testing Process: Test strategy, test planning, test execution, analyzing whole test result and process Regression/Monkey/Integration/White-black box/Performance testing
Diagrams: UML Diagrams (use case, activity, sequence, state, class)
Methodologies: Scrum, Waterfall, Agile Methodology, RUP (Rational Unified Process)
Database: MS Access and MS SQL- Server.
UML/RML Tools: MS Visio, Rational Requisite Pro
Reporting Tools: Microsoft reporting services
EDUCATION & TRAINING:
UCONN SCH OF BUSINESS, 2022-
MS Business Analytics & Project Management
WILMINGTON UNIVERSITY, 2019
MS Management Information Systems
Delaware Workforce Development education
Oracle Certified Associate, 2018. 11g, 12c
UNIVERSITY OF CAPE COAST, GH, 1996
Bachelor of Commerce in accounting and Finance; Dip. Ed.
Association of Certified Fraud Examiners – Student Member #749495
Fundamentals of Cyber Security certification and Business Continuity
03/2019 to DOW-DuPont CHEMICAL CO., Newark DE,
12/2021 Business Analyst (Consultant)
This Project entailed the development of a full-fledged front-end system to manage the various kinds of risks associated in maintaining a portfolio of assets. Applied RUP methodology and conducted brainstorming sessions to understand the client specifications and requirements
●Identified and analyzed issues and risks, and recommended solutions to minimize impacts by risk tracking
●Documented the business process through Business Requirement Document and Functional Requirement Specification document
●Conducted weekly meetings with the clients to review functional specifications and resolve open issues
●Involved in Gap analysis requiring the identification of business rules, business and system process flows, user administration, requirements and assumptions
●Modeled the risks in Excel spreadsheet and performed sensitivity analysis and shared this document with the Traders and the technical team to facilitate more efficient communication
●Managed requirements & defects through quality center
Supported in QA testing and implementation of business solutions throughout the Software Development Life cycle
Environment: Spreadsheets, MS Visio, MS office, Quality center, SQL 2005/2008, Oracle Database 11g, 12c,, SAP FICO, CRM, EPPM, BO, Tableau Report, SRSS
11/2017 to Deloitte. Philadelphia
01/2019 Deloitte Staff, Audit Practice
Received hands-on training in performing Vouching, Reconciliation and Analytical Reviews
Created reports with Excel: pivot tables for analytical reviews using formulas, arguments and functions
Assisted Audit team to assess Risk of Material Misstatements (RMM) with overall account balances
Assisted Audit and Assurance team to perform perpetual inventory re-evaluation and confirmation
Assisted Audit and Assurance team with 10-K, 10-Q reporting, review, analysis and Compliance with Dodd-Frank
Assisted Audit and Assurance team to review, evaluate and report on amounts due to lenders, using pivot tables
Received training on Reconciliation and the preparation of consolidated management accounts
Performed thorough review of Accounting cycle (Transaction analysis through Post-closing trial balance & Reverse)
11/2010 to JPMC, Jersey City, NJ
10/2017 Business Analyst (Employee)
Working as Business Analyst for financial reference data solution asset management and trading division with an objective to provide qualitative, accurate and timely data to various user groups such as risk analytics, trading, fixed income and equities and asset management. The initiatives involved data mapping of feeds from several reference data systems, including Bloomberg, Reuters, Capital IQ etc. to number of in-house applications; Used Visio to document current work flows, high level design, business process modeling, manual processes and End-to-End processing of system interaction.
●Responsible for gathering requirements, from users (Traders & Risk Professionals), writing functional & technical specifications, for: (1) an in-house front office, trading application who's main products are related to asset management of ABS (Asset Backed Securities), CDO (Collateralized debt obligations) and Whole Loan Mortgages; (2) Risk Management Systems, which supplies users with intra-day and end-of-day speeds, status of modeled bonds, as well as market and credit risk information.
●Responsible for gathering business/data requirements, business rules identification and documenting them as requirement specifications (BRD).
●Prepared process flows, high level design and data flow diagrams using MS Visio.
●Worked with lead & project manager to prepare and maintain the project plans & project status reports. Analyzed data requirements from the users and assisted data analysts, data modelers and developers for interpreting the data definitions, fields & attributes.
●Effectively liaised between business users & developers to resolve requirement issues.
●Assisted QA testers to review the test scenarios, test cases & defect analysis and worked closely for functional, integration and regression testing.
●Wrote basic SQL queries for validating the data and the business rules.
●Frequently worked with SQL to create basic statements: select, updated, delete, insert, and create.
●Applied Database concepts, DDL, DML.
●Used SQL server2008.
●Interacted with vendor support team to resolve data feed issues.
●Participated at deployment, PROD testing and provided user support.
12/2009 to AT&T CORPORATION, Middletown, NJ
10/2010 Business Analyst (Consultant)
DSS
The DSS is a new set of web services that utilize a business rule engine to determine a recommendation/ decision based on aggregated data applied to enterprise level business rules. Business rules can be used to define a channel specific behavior. The DSS has access to all web data services to execute rules services. This system is mainly used by asset and portfolio management, equities and fixed income trading platforms.
●Actively participated in HLBR sessions for gathering requirements
●Organized review meetings with various LOBs (stakeholders) and finalized the Business Requirement Document
●Used MS Visio for high level design and business process modeling with Use cases
●Prepared the Approach document or Functional Requirement Document (Use Cases) by coordinating with IT team
●Hands on experience with Business Rule Management System (BRMS)
●Knowledge of BOM, XOM, Decision Tree, Decision Table, RTS as a BA perspective
●Experience in creating presentations for senior executives
●Hands on experience with Agile, Scrum & waterfall methodology, SAP BO, Tableau Report, SRSS
●Prepared Process Flow Diagram using Microsoft Visio
●Conducted the project meetings successfully by coordinating all users, technical staff and support personnel Supported in QA testing and implementation of business solutions throughout the Software Development Life cycle
Environment: MS Office, MS Visio, Quality Centre
12/2007 to UBS INVESTMENT BANK, Stamford, CT
11/2009 Business Analyst (Consultant)
HITS is a database framework for efficient storage and retrieval of very high-volume time-series data. This system is capable of storing equities tick-by-tick data from multiple sources. It stores more than two billion records per day and growing. Fusion is Equity IT's strategic historical data system containing end-of-day time-series data on financial instruments from multiple sources. It contains Market data and analytic data on various attributes for many asset classes.
●Performed Business Analysis functions with focus on SDLC methodology for Market Data Group
●Created Current State Study, Project Briefs and Functional Specifications documents for system enhancements/product data enrichment and obtained sign-offs
●Interfaced with users through face-to-face and telephonic meetings/conferences and managed their expectations
●Served as a liaison with business representatives and developers
●Interacted with IT personnel in Front Office and Back Office
●Maintained data quality and integrity for mission critical securities (Equities and Fixed Income) master databases accessed by over 100 downstream applications
●Developed process flowcharts and User Manuals for Data Support function
●Performed complete database field mapping for sourcing data from alternate systems in case of decommissioning of a legacy system
●Communicated with data vendors like Reuters, Bloomberg, Telekurs, Markit etc
●Participated in UAT and developed test cases for unit testing based on functional specifications
Environment: Spreadsheets, MS Visio, MS office, Quality center, SQL 2008, SAP FICO, CRM, EPPM
Reference: Available upon request