Financial Business Analyst Resume Profile
PROFESSIONAL SUMMARY
- Business Process Analysis:8 years of experience in conducting and documenting the As-Is/To-Be processes and Business Process Re-engineering BPR exercises according to various methodologies - Rational Unified Process RUP and UML development methodology, Rapid Application Development RAD , agile, E2E requirements management and water-fall environment
- Domain Analysis, Data Analysis, Business Rules, Gap Analysis, Prototyping, developing/creating business process related documents with stronger affinity to financial services, investment banking, fixed income, equities, commodities, trade cycle, ETF, securities trade processing/clearing, asset management and mortgage. Diversified profile with client base ranging from investment banking to insurance to energy sector to digital imaging to retail banking to government services
- SDLC: In depth and strong working knowledge of the Software Development Life Cycle SDLC phases such as planning, analysis/design, development, and testing
- Prominently strong in gathering business/ functional user requirements, use cases per requirements, defining project plans, sequence diagrams, delivering project/status reports in addition to creating Business Requirements Document BRD
- Quality Assurance: Experience in conducting Joint Application Development JAD sessions with end users, expert team, QA team, and stakeholders for project related meetings
- Reviewed test scenarios and test cases for UAT and regression testing to support pre and post implementation of applications and production issues along with QA and other business groups, in addition to maintaining Test Matrix and Requirements Traceability Matrix RTM
- Possess reasonable understanding of different relational databases, writing SQL queries, creating tables, and generating reports
- Exceptional in building strong relationships with clientele engaging as a specialist between clients and staff
- Organized, goal-oriented, self-starter, and ability to master new technologies, manage multiple tasks independently Strong team player with excellent communication, verbal, written and analytical skills
TECHNICAL SKILLS
Business Analysis | Requirement Analysis, Business Rules, Data Flow Diagrams, Business Process Modeling Re-engineering, Gap Analysis, Prototyping, Cause Effect Analysis, BRD, SRS, UAT, Test Scripts, UML |
Rational Tools | RUP, UML with Rational Rose, Rational Requisite Pro, Clear Quest, Clear Case, Together Soft UML , MS Office Suite, Optimal Trace |
Operating Systems | MS Windows, Linux, Unix, Sun Solaris |
Methodologies | Spiral/Waterfall, RAD, RUP, Agile, E2E |
Version Control Tools | Rational Clear Case, Clear Quest, SharePoint |
Testing tools | Mercury Test Director, Win Runner, Quality Center |
Packages, Databases etc. | MS Office Suite PowerPoint, Word, Excel, Access, Project and Outlook , Lotus Notes, Optimal Trace, MS Visio, Rational Rose Rational Requisite Pro, Sybase Power Designer, Team Foundation Server, ER Studio, Oracle |
PROFESSIONAL EXPERIENCE
Confidential
Title: Technical Writer Lead Business Analyst
Project Description:
The Division of Juvenile Justice and Opportunities for Youth DJJOY Juvenile Justice Information System JJIS is a web-based application using .Net technology. It tracks juvenile justice youth through detention facilities into OCFS placement.
Responsibilities:
- Prepare and publish user guides to provide users with step-by-step guidance on the new features in the corresponding release
- Publish Release Announcement in the production environment prior to the deployment listing out the new features, enhancements and fixes made to the application
- Gather business requirements through working meetings with business users facility case managers, facility in charges, supervisors and staff
- Work with DBA to ensemble the data nodes and the field names for the creation of database tables, code tables, assigning data types and attributes conduct data mapping between the tables using ER Studio
- Responsible for writing use cases, mockups, and report specifications document and conduct review meetings with project team and business users to collect sign-offs
- Make updates, changes as necessary to existing documentation when migrating modules to .Net 4.5 and verify usability standards after deployment
- Perform functional and regression testing after devising test plans based on business rules to correct errors and emphasize on maximum usability and stability of the application
- Record macros for new features to automate processes in creating dummy test cases and running regression testing in case of any code fixes and eliminate the possibility of broken links
- Design process flow charts in the form of swim lane diagrams to define the flow of information and usage of data across different channels
- Handle change requests through workload management screen and analyze the resources and budget estimates for the new feature indictment
- Work with Cognos report developers to verify the criteria of the reports and the conditions for database snapshots for the elements to be included in reports
- Maintain data dictionary to describe the data elements for business users' understanding
- Maintain repository of reports to include all the reports currently in the
Environment:
Net, SQL, Team Foundation Server, ER Studio, Cognos reporting , Microsoft Office Suite, iMacro
Confidential
Title: Lead Business Analyst
Project Description:
FAS Business Analysis is a process to understand and document Fleet Administrative Services' processes account initiation, FEA, meter collection and billing, FBI, reporting, enquiry and invoicing and propose solutions to enhance the applications in overcoming manual tasks.
Responsibilities:
- Documented work flow of legacy systems of FAS by capturing working procedure, issues, day-to-day functioning, exception and business rules of each process
- Designed workflow of as-is business scenario by identifying and establishing different systems, applications and databases involved using MS Visio
- Conducted sessions with SME to gather requirements of As-is and to capture the proposed to-be scenarios
- Prepared and managed project timeline using MS-Project Allocate resources to meet deadlines and to offer process document and work flow diagram to business for review
- Produced professional quality project artifacts including but not limited to business requirement documents, requirement plans, models e.g. data, event, context and process , traceability matrix, use cases, issue logs and other documents as needed
- Responsible for content management using SharePoint to alleviate project's features used SQL Editor to query databases to extract records per customer request
- Run queries on AmPro billing system to refine tables for customer data, serial numbers of equipment and to add price plans to the customer account Use IMP1 to update fleet data, serial numbers, address and model numbers of equipment
- Enhanced FasTrax application to approve or reject billing packages and to perform end of month reconciliation on successful completion of which will lead to invoices being sent to the client
Environment:
MS Access FasTrax, AmPro , Mainframe IMP1 , SharePoint, Citrix virtual connect , MS Visio, MS Project, MS Word
Confidential
Title: Project Co-ordinator
Responsibilities:
- Responsible for knowledge capture and business requirements gathering for technology initiatives that are both focused on business needs Conduct quality review of reports, reconcile information, and provide informed analysis to support changes to the technology portfolio
- Conducted workshops and focus group sessions with SME of operational teams namely Program Management, Testing, Sample Handling, Shipping Receiving, Warehouse Department, Reporting and Publishing groups
- Managed Microsoft Project Server to store project information in a central SQL Server database, protect from unauthorized access and corruption
Environment:
SQL, SharePoint, Microsoft Office Suite, OmniGraffle Pro for screen flows , Axure RP Pro for prototypes
Confidential
Title: Project Coordinator Senior Business Analyst
Project Description:
- IPREO: To give RBC US-Wealth Management users single sign-on SSO access to iPREO's website to allow them direct access to enter orders against new Muni Underwriting deals for fixed income business.
- CAS Enhancements: Create a new technical support page that's a one-stop solution for all wealth management users for certificate related and Automated Order Management AOM related issues when broker dealers engage in commodities transactions
Responsibilities:
- Conducted comprehensive review of client portfolios, including meeting with clients, lawyers and advisors to assess strategies based on objectives and risk profile, identify opportunities, and prepare customized asset allocation suggestions
- Facilitated meetings between prospective clients and internal products and services groups to develop complete solutions for clients, and maximize the relationship return
- Assist in performing ETL Extract Transaction Load process using SSIS package, and Data Import/Export wizard. Perform data loads analyze and initiate data extracts and clean up data by removing duplicates using all source data
- Key source to identify, build and refine business rules in alignment with the company's procedures, retaining quality characteristics, and categorizing the rules
- Created business process maps BPM to align system functional requirements to business process and to ensure full scope coverage of the to-be automated business functionality
- Integrated SWIFT code into transactions conducted by Financial Advisors and establish security standards for utilizing the code
- Suggested techniques to automate futures contracts in the website in order to derive quantity, price and delivery time from the party
- Manage Microsoft Project Server to store project information in a central SQL Server database, protect from unauthorized access and corruption
- Assist in performing ETL Extract Transaction Load process using SSIS package, and Data Import/Export wizard. Perform data loads analyze and initiate data extracts and clean up data by removing duplicates on all cases and with all source data.
- Deliverables include creating, updating and maintaining Project Timeline, Business Context Diagram, High Level Requirements, Business Process Model swim-lane diagrams , User Interface Map, Storyboard, SRS and UAT
- Consulting with Information Security team for the creation of active directories and sourcing data from various sources into the active directory to facilitate access to the application defining user groups and setting access rights to those groups
- Handled 4 projects, at various phases of SDLC, simultaneously with 7 iterative UAT sessions and rolled off into production successfully Also documented 'Post Implementation Verification' changes
- Administer SharePoint to manage and control project artifacts responsible for safeguarding living requirements to the business
- Trained and experienced to work in E2E requirements management process a use case driven project environment Prior to the shift to E2E, projects were agile driven and scrum based
Environment:
Mainframe, HPQC, Citrix remote desktop , Mainframe, SQL, MS-Word, MS-Excel, MS-Visio, MS-Project, PeopleSoft, SharePoint, OmniGraffle Pro for screen flows , Axure RP Pro for prototypes
Confidential
Role: Financial Business Analyst
Project Description:
Brokerage Processing Services BPS screen was reengineered to provide broker/dealers and banks with comprehensive clearing and settlement services for Equities and Fixed income securities, options and futures.
Responsibilities:
- Work across front, middle and back office teams to analyze problems, define requirements, broker solutions and drive the implementation
- Developed thorough understanding of the working of the prime brokerage, margin, clearing and settlement divisions and conducted knowledge transfer sessions KT for different project users
- Participated in the identification, understanding and documentation of business requirements in the securities market to develop the new processing environment using RUP
- Created user guide for Fixed income processing done through Broadridge's Impact system to be used in real time to calculate or extract actual position and balance information
- Extensive working with data modeling diagrams and creating ER diagrams with the understanding of data flow at back end interfaces
- Gathered requirements for creation of live feed of commodities performance in international market
- Attended workshops on Dodd Frank Act and created presentations for company wide use
- Responsible for identifying and documenting business rules, created detailed Use Cases and conducted User Acceptance Testing Developed test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge
Environment:
BPS, DTC, MS-Office Suite, Mercury Test Director, SQL, Rational Requisite Pro, Toad, Bloomberg
Confidential
Role: Senior Business Analyst
Project Description:
Reengineering of Customer Service web portal using Web2.0 to radically enhance the performance and scalability of e-commerce B2B and B2C web applications the other part of the project was to write off the outstanding balance due 90 plus days for reporting the numbers correctly to the management.
Responsibilities:
- Assisted the Project Manager in creating Project Charter and allocate resources to set up an efficient team that could reform the bad debt process
- Contributed to software process-reengineering efforts aimed at evolving previous software development practices to adopt Lean/Agile and Scrum practices
- Conveyed the information to the business team and the technical team in the form of detailed Use Case Diagrams, Work flow diagrams, Data Flow diagrams using MS Visio to define the business process.
- Conducted JAD sessions using MS PowerPoint with CRM SMEs, system architects, technical teams and other stakeholders for understanding the customer requirements
- Responsible for conducting scrum meetings and reporting the meeting minutes to the Management
- Created and executed Test cases/ Test Scripts according to the Business and Functional requirements
- Performed User Acceptance Testing and system integration testing
Environment:
MS-Office Suite, Web2.0, Webtrends, HTML, Win Runner
Confidential
Role: Business Analyst
Project Description:
To enhance online banking facility for investment related data by building an online access system that facilitates viewing of account balances along with investment portfolio with varied options.
Responsibilities:
- Defined the business process and the approach to gathering/documenting requirements Interacted with the stakeholders by preparing questionnaire and documenting feedback
- Responsible for defining the scope of the project, gathering business requirements by conducting JAD sessions, doing gap analysis and documenting them textually or within models
- Supported the project manager with creating detailed project plans and assisting in developing, scheduling and tracking project timelines while analyzing the requirements
- Created ready-to-use delivery processes to provide the project manager with a quick starting point for planning and initiating a project
- Used MS Visio for flow-charting, process model and architectural design of the application
- Documented business workflows textually as well as in UML diagrams captured in RUP for project review
Environment:
Rational Requisite Pro, Primavera, MS Office tools, NuPoint, Quality Centre, Oracle PeopleSoft
Confidential
Role: Project Intern
Project Description:
Develop Loan Origination System LOS to automate every task involved in attracting new mortgage business beginning from pre-approving an applicant to the formal closing of the loan application.
Responsibilities:
- Acted as a liaison between the developers and management staff for extracting clarity in requirements and instrumental in resolving conflicts between the management and technical teams
- Conducted meetings/interviews and JAD sessions with stakeholders to collect business requirements. This information along with the vision document was used to transform business requirements into System Requirement Specifications
- Prepared business workflow models to capture the as-is business processes are accomplished
- Conducted milestones planning of the project through walkthroughs and meetings involving various leads from development, QA and technical support teams
- Created and managed project templates, use case project templates, requirement types and traceability relationships in Rational Requisite Pro
- Created Analysis Model and Data Model and used these artifacts to develop the Design Model: Class Diagrams, Collaboration, and Sequence Diagrams
Environment:
UML, Rational Requisite pro, Enterprise Architect, MS Office, Mercury Test Director
Confidential
Role: Financial Investment Analyst
Project Description:
To develop web-based portfolio management system for customers to access their accounts, update market information, trade online and evaluate their investments market value as on date.
Responsibilities:
- Created and managed project timeline to deliver project artifacts and reports progress towards delivery goals
- Conducted key stakeholder meetings to gather and analyze requirements through elicitation techniques to improve system efficiency
- Interacted with project stakeholders to document project requirements by translating business needs into testable, developer-ready requirements
- Performed financial data sourcing gap analysis, data analysis and solution identification
- Serve as a critical resource and liaison between subject matter experts and technologists throughout the project lifecycle Work with the business to recommend appropriate training, communication and scheduling as systems are deployed
Environment: MS Visio, MS Word, MS Excel MS Power Point, Bloomberg and Mercury Test Director
Confidential
Role: Junior Analyst
Project Description:
The bank initiated personal banking application to enable its customers to apply for loans using the online portal and negotiate on the rate of interest depending on various factors
Responsibilities:
- Created Use Cases to define the functional requirements of the application with the help of business users
- Participated in JAD sessions to analyze and document business requirements with utmost clarity
- Created detailed workflow diagrams of the proposed system with reference to the existing proposition
- Involved in user acceptance testing and tested various object states using extensive verification points
Environment:
Unified Modeling Language UML , MS Office
Confidential
Role: Business Intern
Project Description:
GE Customer Net is a state-of-the-art, secure online marketing and ordering B2B e-commerce system, used by more than 3,000 customers worldwide to place/edit/track orders for appliances, parts, and Extended Service Plans on the net.
Responsibilities:
- Assisted in gathering/validating high level requirements from the users, and converting them into technical design document
- Conducted gap analysis between the future workflow and the As-Is process
- Designed the To-Be process/ Use Cases and getting the sign-off/buy-in of various stakeholders
- Assisted in creating System Test Plans and Unit Test plans and conduct Unit Testing and System Testing
Environment:
MS-Project, Excel, PowerPoint, Win Runner, Quick Test pro.