Description

Adam Aaron | 571-309-9070 | adamaaron.it@gmail.com

 

 

 

EXPERIENCE SUMMARY:

 

Business Analyst/System Analyst with 8 + years of experience working across industries in a client facing role, planning and successfully implementing technical/functional systems
Strong experience in Financial Services Industry, working knowledge of Accounting, Banking, Mortgage and Treasury systems.
Over 6 years of experience in identifying the user requirements; Functional and Non-Functional, capturing AS IS and TO BE business processes.
Proficient in creating BRD (Business Requirement Document), FRD (Functional Requirement Document), PDD (Project/ Product Definition Document), SRS (System Requirement Specification), Requirement Traceability Matrix (RTM), and Change Management Documents.
Experience in constructing Application Architecture Work Objects; System Application Flow, User Interface Validations, and System Interface Validations.
Created Business Processes, Reports, Screen Layouts, Wireframes, and Prototypes.
Strong knowledge of the Software Development Life Cycle (SDLC) and software methodologies like Waterfall, Agile, Scrum, and Rational Unified Process (RUP).
Proficient in analyzing and creating Use Cases and Use Case Diagrams, Activity diagrams, Class diagrams and Sequence diagrams, Business Processes, Business workflow Diagrams, and Data Flow Diagrams.
Extensive experience on project management tools, processes & methodologies.
Expertise in conducting Joint Requirement Planning (JRP) sessions, Joint Application Development (JAD) sessions with a committee of Subject Matter Experts (SME’s) senior management and IT groups
Expertise in Data Migration and Conversion and analyze data from multiple source systems.
Adept in creating and reviewing the Test Procedures, Test cases, and Test scripts.
Identified defects and coordinated with team members to fix the errors.
Conversant in Manual testing (Graphical User Interface (GUI) Testing, Field Validation Testing, and Functionality Testing) of User Interface (UI) and Web Applications, Functional testing, Navigational testing, web services testing (XML and WSDL files), back-end testing and User Acceptance Testing (UAT).
Supported the end user by documenting the user guides and training materials.
Experience in conducting GAP analysis, ROI analysis, SWOT analysis and, Cost benefit analysis.
TECHNICAL SKILLS

 

MS Office Suite:                       MS-Word, MS-Excel, MS-PowerPoint, MS-Project, Visio, Access;

Methodologies:                        SDLC–Waterfall Model, Object Oriented Analysis and Design (OOAD), Agile/Scrum, Rational Unified Process (RUP), BPMN, V-Model, Rapid Application Development (RAD), Joint Application Development (JAD);

UML Diagrams:                      Structure Diagram-Class & Object Diagram, Behavior Diagram, Use Case, Activity, Sequence & Swim Lane Diagrams;

Modeling Tools:                       MS-Visio, Rational Rose, Erwin, Snag-It, and Snipping Tool;

Requirement Tools:                 Rational Requisite Pro, Rational Software Architect (RSA), Rational Requirement Composer (RRC), DOORS;

Data Analytics                          Advanced Excel modelling; SQL queries and stored procedures

Content Management Tools:  SharePoint, Knowledge Link;

 

PROFESSIONAL EXPERIENCE

 

State Street Bank – Princeton, NJ                                                                                                                     Nov 2016 – Present

Sr. Business Analyst

 

State Street is the world’s leading provider of financial services to institutional investors. Performed various tasks as a member of the business team including, but not limited to: task lead, requirements gathering and implementation, writing functional specifications, knowledge transfer and process improvement, internal team building, client communication and relationship, and quality assurance. In addition, possess expertise in the areas of data verification; report analysis and recommendations.

 

Responsibilities:

·         Gathered business requirements through interviews, surveys, and observing from account managers and UI (User Interface)

·         Involved with the following product Types: Fixed Income, Bonds and Bond Trading Cycle, Bond Pricing, Equities, Trade Cycle, Derivatives (Options and Futures).

·         Interviewed SMEs & Stakeholders to capture Client Data parameters for KYC Review & Remediation process in scope.

·         Understand and articulate business requirements from user interviews and then translate requirements into functional and technical specifications.

·         Interacted with fixed income business heads to finalize the Business Requirements for the Risk Management process.

·         Interacted with SMEs of different divisions (Information Technology, Risk and Operations) and established a business analysis and design methodology around the RUP (Rational Unified Process).

·         Prepared High Level Logical Data Models and BRD supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.

·         Conducted JRP sessions with management, SMEs (Subject Matter Expertise), vendors, users and other stakeholders for open and pending issues to develop specifications.

·         Designed Use Cases, Use Case diagrams, Class diagrams, Activity diagrams and Sequence diagrams in UML methodology using Rational Rose.

·         Conducted Joint Application Development (JAD) sessions with the IT Team.

·         Worked closely with the Users to model the screens, which met user defined requirements, organizational and regulatory standards.

·         Held group meetings, walkthroughs and supervised/trained other analysts.

·         Developed and maintained relationships with clients on all on-going projects.

·         Responsible for the completion of projects within specified time and budget dealing with financials, project workflow, change management and dealing with vendor relationships.

·         Performed System and Integration Testing along with testers. Conducted UAT with the business

 

 

Axalta Coating Systems, Glen Mills, PA                                                                                                                    Sep 2015 – Oct 2016

Sr. Business Analyst

 

Axalta Coating Systems was a result of a strategic demerger of the performance coatings business of DuPont Chemicals. The company went public within its first year recently and has more than 150 entities worldwide.

The project was to design and implement an Internal Management and Reporting System for the Intercompany Finance department, as a replacement for the existing legacy DuPont systems.

The system had to can calculate Receivables/Payables invoicing, Transfer pricing and provide customized financial reporting metrics. As BA, my role ranged from scoping and planning the project, to execution and overseeing a successful implementation

 

Responsibilities:

·                 Prepared business scoping and project planning documents, including resource allocation and time-effort estimation.

·                 Designed business models that served to identify requirements and communicate information between teams.

·                 Defined Business use cases and activity diagrams to represent different workflows and associations

·                 Lead requirements gathering by using interviews, requirement workshops and brainstorming sessions.

·                 Used Waterfall/Agile methodologies to design, document, and manage requirements throughout the full lifecycle of the project

·                 Performed Gap analysis for new functionality requirements, as well as prioritized them based on actual business needs to align them with the product release roadmap.

·                 Documented intercompany invoicing, GTP/UTP calculation, reconciliation and reporting metrics for functional design.

·                 Engaged with development efforts, preparing scripts and queries using SQL/Stored Procedures and designing ETL Processes.

·                 Effectively working with clients’ senior management team to provide feedback and recommendations and solutions.

·                 Coordinated and lead User Testing, along with documentation (Test Scripts, Run Reports)

·                 Lead and delivered User Training Sessions

·                 Oversee deployment and provide post production support and troubleshooting.

·                 Created tables and ran queries in SQL (Management Studio) by importing data from different sources.

 

Environment: Window 7, MS Office Suite, MS SharePoint, SAP, .NET Framework, SQL Server Management Studio

 

 

Mellon Financial Corporation, Pittsburgh, PA

Sr. Business Analyst

Aug 2013- Aug 2015

 

Mellon Financial Corporation today is a global financial services company. Some of its services were Investment management, Foreign Exchange and stock transfer, banking services, mutual funds, fixed income and wealth management.

The project was to design a system base application for the investment management system. The system was primarily written to provide reports for our portfolio managers who could use these reports (mainly on cost basis) to provide our clients with the highest total rate of return consistent with their performance goal, corporate actions, cash flow requirements, need for liquidity, and preservation of capital

 

Responsibilities:

·         Designed the business requirement collection approach based on the project scope and SDLC Methodology.

·         Met with users to generate and review business test cases.

·         Gathered requirements by using interviews, requirement workshops and brainstorming sessions.

·         Performed Gap analysis for new functionality requirements, as well as prioritized them based on actual business needs to align them with the product release roadmap.

·         Documented cash flow requirements and trading life cycle including wash sales, lot disposal, valuation method for stock and prepare gap analysis

·         Used RUP, UML methodologies and Requisite Pro tool to design, document, and manage requirements throughout the full lifecycle of the project

·         Designed business models that served to identify requirements and communicate information between teams.

·         Effectively work with third party vendor and senior management team to automate corporate actions and analyzed the subsequent effect stock valuation (cost basis and residual balance method).

·         Used use case diagrams during analysis to capture the requirements on trading life cycle, stock valuation and IRS laid laws like wash sales and short selling stock rules.

·         Defined Business use cases and activity diagrams to represent different workflows and associations

·         Based on the use cases assisted in the preparation of very high level test cases

·         Created tables and ran queries in MS Access by importing data from different spreadsheets.

 

 

Environment: Window XP, Rational Requisite Pro, Rational Rose, UML, SQL, MS Office, MS Access, Win Runner, Oracle, and PL/ SQL.

 

Prudential Financial Services – Newark, NJ

Sr. Business Analyst

Jan 2012– July 2013

 

Prudential Financial Inc. is a financial service leader deals in investment, real estate, commercial property and life insurance. Modernized New Business System (MNBS) is a legacy application catering to the New Business of Prudential Individual Life Insurance (ILI). The New Business System caters to many crucial functions like policy data entry, underwriting, commissions, issuing contracts and placing with Admin systems.

Pru Life Universal System (PLUS) system replaced MNBS a legacy system that handled the New Business process for Prudential`s individual Life Insurance (ILI) needs. The application also involved enhancing the online life insurance quoting system, claim processing.  It provides a wide range of options relating to choose of policy.

 

 

Responsibilities:

·         Interacted with Subject Matter Experts such as Prudential’s Investment Managers, Life Insurance Managers, and Process Analysts to gather requirements and goals through interviews, surveys to understand the business process. Conducted a controlled brain-storming session with project focus groups.

·         Involved in gathering and synthesizing business requirements and translated into functional and non-functional requirements to be used as input to the functional design specifications.

·         Designed Use cases, use case diagrams to present a better view of the system to the technical team for them to identify the key processes.

·         Interacted with technical Architects to identify and analyze the given information, procedures and decision flows and evaluated existing procedures.

·         Acted as liaison between the SME’s and the technical teams, handled all scheduling, resource planning and allocation matters, ran all status meetings and compiled reports.

·         Extensively worked on Creating User Requirement Specifications (URS), Functional Requirement Specifications (FRS), and Business Process Documents and also developed System Requirements.

·         Prepared Use Cases, Use Case Scenarios and elaborated those using UML diagrams like Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, Business Process and Data Process Model.

·         Facilitated Joint Application Development (JAD) sessions for communicating and managing expectations with SME’s and to understand thoroughly the business process and the interface requirements, which need to be incorporated in the application.

·         Performed lot of Customizations, Enhancements, Updates and changing functionalities of web page.

·         Worked as a team with Developers and Process Analysts in preparing the requirements, writing workflows, process flows, and Interacted with system developers to resolve questions and discrepancies in BRD.

 

Environment: Enterprise Architect, Windows 2000, SQL, PL/SQL, Oracle, SharePoint, Requisite Pro, MS-Project, MS-Office Suite

 

 

Rhodium Strategies, New York, NY

Business Analyst

September 2010- Dec 2011

 

Rhodium Strategies is a boutique strategy advisory and consulting company working with emerging growth technology companies and the investors who support those companies and include strategy and growth consulting, strategic/M&A advice, fundraising strategy advisory services, independent valuations, and outsourced diligence.

Projects included M&A post-merger system integration of a company in the cloud space Vertical and helped Auditing and reconciling its financials for mapping to various income sources.

 

Responsibilities:

 

·            Evaluated the financial reports such as income statements, cash flow statements, and balance sheet of the project and performed an analysis on how the finances will impact the project operations as per GAAP.

·            Prepared consolidated financial models, valuation analysis (Public and transaction comparable, Discounted Cash Flow (DCF), Net Present Value (NPV) & Total Cost of Ownership (TCO) models.)

·            Presented the financial data analysis in clear and compelling ways and made recommendations for action by synthesizing the financial information and the trends and helped in designing the business process management design for the integrated company.

·            Supporter client accounting team in auditing back file conversions.

·            Wrote business requirements documents (BRD’s) after accessing the status and scope of the project and understanding the business processes.

·            Facilitated Joint Application Development (JAD) Sessions for communicating and managing expectations and applied core management skills such as organizing and planning

·            Identified processes for developing and documenting detailed business requirements. Data was collected from end-users, and analysts.

·            Created Use-Cases and Requirements documents to document business needs.

·            Requirements were gathered through interactions and meetings and periodic walkthroughs with potential users of the application.

·            Ensured Use-Cases were consistent and covered all aspects of the Requirements document.

·            Followed UML based methods using Rational Rose to develop use cases and activity diagrams, sequence diagrams and collaboration diagrams.

·            Maintained documents using SharePoint and the effect of proposed changes on the project schedule and costs.

·            Designed and developed scenarios based on business requirements.

·            Leveraged advanced skills and expertise to succeed as a financial business analyst.

·            Participated in Bug-Review meetings with software developers, QA engineers, managers and suggested enhancements to the existed application from business perspectives, provided solutions to existing bugs.

·            Conducted UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application.

 

Environment: Rational Rose, Requisite Pro, Windows XP, MS Office 2003 (Word, Power Point, MS Excel, MS Access) MS Visio 2003,

 

 

Ameriprise Financial, Minneapolis, MN

Business Analyst

March 2009 – Aug 2010

 

The main Scope of this project was to enhance the existing system and add new features to support financial services information. In this project, there were some new business requirements, which were added to upgrade the existing manual reporting process into automated reports. In addition, provided support to in house projects with requirements document, and provided my contribution whenever needed.

 

Responsibilities:

 

·         Worked with the Business sponsor and Project Manager to create Project Charter, which covered Project need, Business scope, Resources and constraints of the project.

·         Performed workflow analysis to help identify Business needs and corresponding solutions.

·         Created Business Requirement Documents, Functional Requirement Specifications and used Requisite Pro to maintain the requirements.

·         Worked on the Point of Sale of Insurances & UI system to automate the buying process of consumers

·         Acted as Single Point of Contact for integrating the PeopleSoft application with downstream applications.

·         Documented all the discussions, stored the requirements and tracked the changes maintaining the versions of document.

·         Created requirements in Iteration development and waterfall method.

·         Documented and maintained Requirements Traceability Matrix (RTM) to validate that all requirements have been tested.

·         Modified COBOL/IMS batch programs to generate reports for Treasury systems.

·         Generated Inventory/Exception reports prototype to accelerate the requirements gathering for SVP/Director/Manager centric reports.

·         Chaired meeting with 25+ senior business users to explore the enhancements needed in the underwriting process model.

·         Responded to escalated inquires that affect Ameriprise Financial

·         Provided regular and timely feedback to management regarding new trends or sensitive issues that arise from handling interactions and provide relevant data/statistics/analysis that adds value.

·         Performed data analysis on loan attributes in excel concluding the key findings in a report which are presented to management to make critical loan quality decisions

·         Worked in mainframe environment and used SQL to query various reporting databases

·         Responded to internal and external environmental changes

·         Created Test plans, After Action Reviews and Questionnaires to execute and support various BCP related exercises, activities and tests.

·         Coordinated with onshore and offshore team to ensure the test plan is concurrent with the development initiatives.

·         Created Process documentation to facilitate seamless performance of various BCP related activities.

·         Provided support for User Acceptance Testing with UAT cases and resolving any issues with the users and performed UAT and participated in writing test plans, and developed different testing strategies like Black Box testing.

·         Analyzed Requirements and created Use Case Documents, Use Case Diagrams, Activity Diagrams using UML

 

Environment: MS Word, MS PowerPoint, MS Excel, MS Visio, Agile.

 

 

 

Education

Bachelors in Business Administration