Business Analyst Resume
Boston, MA
PROFESSIONAL SUMMARY:
- Experienced IT Professional with over 9+years of experience in Business/Process and Systems Analysis in Financial Institutions Retail Banking and various application developments
- Well versed in performingGap analysis and Data Mapping/ Process Mappingto document system and process inconsistencies and implemented solutions
- Extensive and diversified experience leading the implementations ofSoftware Development Life Cycle (SDLC) Waterfall, RUP, RAD, Agile
- Strong knowledge in using theSix Sigmatechnique (DMAIC) for eliminating defect and reducing variations inbusinessprocess as well as designed various usefulbusinessmaps such as Flow charts.
- Analyzed SIPOC and RACI matrix to clarify the cross team members about their roles and responsibility to complete thebusinessprocess
- Sound knowledge of concepts likeGap Analysis, Risk Analysis, and Impact Analysis
- Expertise in developing Functional Requirement Specifications (FRS), Systems Requirements Specification (SRS), Systems Design Specification (SDS), Design Documents, Use Cases and Object Oriented Design using UML
- Strong knowledge ofDatawarehousingconcepts Experience in database modeling and development of Entity Relationship Diagrams (ERD)
- Expertise in coordinatingFunctional Testing, System Testing and UAT test effort and writing System Test Plans and formulating Test Strategies
- Excellent Business writing skills in writing Business Requirements Document (BRD), USE Case Specifications, as well as thorough exposure of conducting JAD sessions and interviews with Subject Matter Experts (SME) and data stewards to understand the business process, business rules, and data requirements
- Designed and implementedData Mappingand Mining Documents for various projects under ISO - 9001 requirements to meet strict Quality Assurance standards.
- Proficient in using UML for Business Process Modeling, Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Collaboration Diagrams, Class Diagrams and document them using Microsoft Visio.
- Experience in designingProcess Flow and Data Flow diagramsto documentBusinessprocesses
- A team playercomplimented on working effectively with all levels of management
- Designed and created data reports using various reporting tools.
- Able to effectively converse, relate and liaise with multi-functional teams, includingbusinessowner, stake holders, managers, architects, developers and testers at all levels.
- Excellent interpersonal skills in listening, mentoring, coaching, negotiation, mediation, influencing, conflict resolution and strong communication, written and presentation skills.
TECHNICAL SKILLS:
BusinessModeling Tools: MS Project, MS Visio, Power Point, UML, Rational Requisite Pro, Rational Rose
Databases/Query Tools/Web: MS SQL Server 2005/2000, MS Access, DB2, Oracle 11i/10g/9i.
Defect Tracking / Testing Tools: Quality Center Test Director,Quick Test Pro, WinRunner, Load Runner, Rational Clear Quest
Software: MS Office Suite(Word, Excel, Access, PowerPoint & Outlook), MS Visio, Rational Requisite Pro, Congos, Adobe Acrobat, MS Office, Mockingbird, Lotus Notes, Industry Print.
Reporting Tools: Visual Studio 2008/2005, SharePoint 2010, iRise, Telelogic, Jira, DOORS, RequisitePro, ClearQuest, ClearCase, Rational Rose, Star UML, Blueprint, JIRA, CaliberRM, Enterprise
ArchitectImaging Tools: FileNet and Xerox BlitzDocs
Methodologies: Rational Unified Process(RUP), Rapid Action Development(RAD), Waterfall, AGILE/SCRUM
Operating Systems: Windows 95/98/XP/NT/2000, Windows 7, Windows 8, Windows 8.1, UNIX
PROFESSIONAL EXPERIENCE:
Confidential, Boston, MA
Business Analyst
Responsibilities:
- Consistently documented functional and business requirements using use cases and Unified Modeling Language.
- Provided End-user support by supplying effective product, efficient process and functional solutions to resolve and enhance current user application functionality.
- Enhanced end-user access to a wide variety of data using Data warehouse modeling techniques.
- Assisted the Executives and the Department Heads in Disaster Recovery Operation during production process of applications.
- Interacted with prospects, clients and industry representatives for gathering, analyzing, writing and translating business and functional requirements into Functional specification documents.
- Maintained, communicated and tracked requirements using Rational Requisite Pro.
- Created and maintained artifacts by evaluating needs, clarifying requirements, and analyzing use cases and dependencies to recommend a course of action.
- Used MS Visio to create product maps and sequence diagrams.
- Worked closely with project manager and gave inputs in the strategic development of detailed project plans, work assignments, target dates in MS Project.
Confidential, Dallas, TX
BusinessAnalyst
Responsibilities:
- Engage business and Risk Management stakeholders in priority discussions for feed integration projects for given asset class/set
- Complete, maintain and review project plans for each one of the project implementations
- Complete Test / Business Requirements Documents (BRD), obtaining approval from key stakeholders
- Experienced with risk metrics including capital and stress testing
- Hands on experience in credit risk in both consumer and institutional banking business lines
- Ability to present data with clarity from an insightful and actionable perspective
- Compare liquidity, profitability, and credit histories of individual or company being evaluated with similar establishments to determine risk supports the Global Credit Trading team which is a leading market maker in public debt across the credit spectrum, including high grade, high yield and distressed debt
- Engage business and Risk Management stakeholders in priority discussions for feed integration projects for given asset class/set
- Determines cost of operations by establishing standard costs; collecting operational data
- Identifies financial status by comparing and analyzing actual results with plans and forecasts
- Create the current state and the future state BRD document for the GPS project and related to the new Oscar GUI, Position Management, P&L calculation, Risk reporting, etc.
- Meet with decision makers, systems owners, and end users to definebusiness, financial, and operations requirements and systems goals, and identify and resolve systems issues.
- Identify and establish scope and parameters ofbusinessanalysisof multiple projects in relations to Credit Cards, Debit Cards, EFT and Retails banking systems.
- Collaborate in the planning, design, development, and deployment of new applications, and enhancements to existing applications.
- Prepare and deliver reports, recommendations, or alternatives that address existing and potential trouble areas in operating systems across the organization.
- Create system design proposals.
- Review and analyze the effectiveness and efficiency of existing systems and develop strategies for improving or further leveraging these systems.
- Lead design sessions in prototyping new systems for the purpose of enhancing business processes, operations, and information process flow.
- Plan and schedule project timelines and milestones using appropriate tools.
- Track project milestones and deliverables.
- Perform cost-benefit and return on investment analyses for proposed systems to aid management in making implementation decisions.
- Write business requirements and has strong traded products knowledge - specifically equities and equity related products
- Ensure compatibility and interoperability of in-house computing systems.
- Create systems models, specifications, diagrams, and charts to provide direction to system programmers.
- Coordinate and perform in-depth tests, including end-user reviews, for modified and new systems, and other post-implementation support.
- Provide guidance and/or instruction to junior staff members.
- Functioned as a vital liaison between the business line, operations and the technical areas throughout the project cycle.
- Worked with development project teams with regards to functional specifications, quality assurance scripting, and product rollout.
Environment: Visual Basic, Oracle 10g, SQL Server 2005, HP Quality Center 9.0, XML and HTML, Rational Rose, MS Visio, MS PowerPoint
Confidential
Business Analyst
Responsibilities:
- Used the Agile(Scrum) methodology for Software Development Life Cycle (SDLC) guidelines to carry out every step of the business modeling process.
- Followed reforms related to changes in the Mortgage Laws for the Real Estate portfolio.
- Organized workshops with Subject Matter Experts (SME) to obtain domain level information.
- Added Functionality to existing Santander Bank website to allow its customers to prequalify for a mortgage in regards to credit card history utilizing Dodd Frank Wall Street Reform.
- Organized workshops with Subject Matter Experts (SME) to obtain domain level information in regards to credit score, Annual Percentage Rate (APR), variable interest rate and credit limit.
- Lead discussions and JAD Sessions to gather business requirements and discuss possible solutions documenting them Software Requirement Specifications (SRS).
- Elicited demands from the stakeholders and analyzed them for consistency, flexibility and completeness.
- Gathered Functional and Data Requirements, analyzed workflows and created Use Cases, Requirement Specifications, Report Specifications, Data Requirements, Data Mappings and Data Flow Diagrams.
- Documented use cases, created use case diagrams that described the behavior of the system and modeled them in Rational Rose.
- Identified, organized, and documented the changing requirements of the project using Rational Requisite Pro.
- Assisted in creating wireframes for web interface with the GUI design team.
- Logged defects to Rational Clear Quest and interacted with developers to resolve the defects then verify fixes and close bugs
- Dedicated a good portion of time with the QA team in front-end, back-end and Regression testing.
- Coordinated with the business partners in conducting the UAT (User Acceptance) Testing.
Environment: Agile methodology, Rational Suite (Rational Requisite Pro, Rational Clear Quest, Rational Rose), Oracle, MS office suite 2007, SQL Server 2008
Confidential, Boston, MA
BusinessAnalyst
Responsibilities:
- Provides ongoing day-to-day support of a Private Wealth Advisor’s book of business. Provide account information to clients and Private Wealth Advisors. Learn the business and products in order to assist Private Wealth Advisors
- Working with clients to ensure proper accounting opening procedures and documentation
- Providing account information to clients and Private Wealth Advisors and maintaining key client relationships work with the Wealth Management Digital channel managers to support a multi-year strategic roadmap to implementation responsible for the creation of business requirements documents and subsequent user acceptance testing of these requirements so that the roadmap can become reality
- Responsible for developing a charter, high level and detailed functional and non-functional business requirements and business rules for business and technology projects.
- Facilitates working sessions to drive to specific understanding of business line needs and ideas and participates in both strategic and tactical support of initiatives to address those needs and issue resolution
- Acted as a liaison between thebusiness units and the technology teams.
- Organizedmeetings with the SMEs of the dependent systems. Conduct weekly issue meetings with customers.
- Created the dimension models and the created the physicaldatamodels.
- Written the specifications for theDatamapping and complex ETL transformation specs.
- Supported ETL developers with end-to-end ETL development of the newsystemto integrate thedatain the existingDataWarehouse using SSIS.
- Lead JAD sessions and act as the lead facilitator for variousprojectsfrom start to finish through the SDLC.
- Prepared BRD to ensure high-level design, updated BRD and FRD through working with the Desk heads andtheir different business units (Investment Grade, High Yield, and Distressed Debt).
- Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.
- Automated Batch Jobs to Load the ConsolidatedDatawarehouse at scheduled times to run on a daily, weekly and monthly basis in Job Scheduling Console.
- Designed and developedSSISMappings to loaddatafromexistingtrading system.
- Developed test cases and test scripts for system and UAT testing.
- Participate in Code Reviews, System Testing and UAT followed by production verification, postproduction testing and support.
- 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
- Designing ETL flow, batch job creation, responsible for identifying and monitoring data ware house usage across several applications.
- Extensively used Quality Center for Test Management needs.
- Involved in end user and support for new system.
Environment: SQL Server 2008/2008R2, SSIS, SSRS, T-SQL, XML, XSD, Perl Script, TFS, Agile methodology
Confidential, Austin, TX
BusinessAnalyst
Responsibilities:
- Extensively involved in Risk analysis, Securities and their valuation, Asset Management (risks and returns), Asset Allocations, Bond pricing, Financial Derivatives, Cash flows, financing structure, Portfolio Analysis, etc.
- Responsible for creating and reviewingbusinessrequirements, functional specifications, project schedules, documentation and test plans.
- Worked with production staff to identify and map detailed current processes, identify gaps and failure points, perform root cause analysis and develop functional requirements that supported overall strategy, goals and objectives, and develop and document the functional requirement documents.
- Developed and implemented highly complex statistical reports ranging from delinquency analysis to portfolio stratification of Sub-Prime Mortgage portfolio.
- Reconciled, collected and monitored the $10 million daily cash flow of loan portfolio acquisitions.
- Ensured SOX and internal control and process compliance
- Experience withbusinessprocess and Information technology process and procedures re-engineering
- Involved with the following financial products: Fixed Income (Bonds, Money Market Instruments, Mortgage Backed Securities and Asset backed securities),over the counter derivatives(credit default swaps, interest rate swaps, Total Return Swaps), Structured Products (MBS, CMBS, CMO, ABS, CDO, CBO & CLO), trade capture application and risk management
- Performed IT Risk Assessment and IT scoping based on COSO and COBIT frameworks for SOX
- Recommend and coordinated IT SOX requirements and supported Implementation
- Plan and scope the internal audit process pertaining to Sarbanes-Oxley act of 2002
- Played a key role in the company SOX compliance efforts including process documentation
- Prepared month-end results ofbusinessunit's financial performance.
- Gathered requirements, analyzed credit card processing life cycle workflow and documented Statement of Work, Functional specifications and user requirements specifications
- Traced Requirements to High Level Design, Test Cases and Product Requirements
- Implemented a custom build solution to Baseline Requirements on basis of software releases
- Created infrastructure for proactive systems analysis using Requisite Pro and other rational tools
- Facilitated Joint Application Development (JAD) sessions to gather requirements from SME’sfrom different groups
Environment: RUP, UML, Rational Requisite Pro, Enterprise Architect, MS Project, MS Visio, MS Office, DOORS, SQL Oracle 8i
Confidential, San Antonio, TX
BusinessAnalyst
Responsibilities:
- Gathered the reporting requirements of the Trade Position Reporting for various Secured and Unsecured Financial Products including Derivatives like Equity Swaps, FX Forwards, Currency Swaps, Interest Rate Options and Forward Rate Agreements (FRA) and formulated theBusinessRules for the same in the Oracle Data Warehouse with Crystal Reports as the front end reporting tool
- Ensured IT security and SOX Compliance requirements are implemented in New Systems, Enhancements and Upgrades
- Analyzed consumer surveys and gave technical inputs inBusinessmeetings.
- Actively participated in the resolution of Production Report issues and also the gathering and analysis of ever changing Reporting Requirements of users
- Involved in the meeting withbusinessand marketing team for requirements gathering in definition stage.
- Asset classes covered include Interest Rate Swaps, Credit Default Swaps,Foreign exchange swaps and Equity options.
- Ability toorganize,documentandtrackchanges anddefectsusing theRational Clear Questand archive change request inClear Case.
- Worked as a Liaison between Trading and Debt Capital markets to execute Syndicated loans
- Created narrative Risk Manuals and flow charts identifying internal risks to Investors Bank and Trust for Global Treasury/Global Treasury Operations.
- Monitored compliance of Global Treasury/Global Treasury Operations desks (Asset Liability Management, Broker/Dealer, Foreign Exchange, Investment Portfolio, Money Desk, Securities Lending and Wire Room Operations) with regulatory and internal requirements.
- Performed compliance projects as requested by Global Treasury/Global Treasury Operations Management.
- Monitored daily compliance reporting for all Global Treasury desks.
- Assisted with integration of former Investors Bank and Trust Institutional Custody Department into Wealth Management Services.
- Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
- Assisted with preparation for internal audits, and Federal Reserve Board audits.
- Provided Anti-Money Laundering review of State Street/Investors Bank and Trust clients.
Completed other compliance projects.
- Implemented complex views, procedures, functions, packages and triggers inPL/SQL
- Performed Data Validation of the data flow from the front-end to the back-end usingSQLto perform the Back-end testing on the database
- Facilitated negotiations with clients (other arrangers) for the finalization of syndicated facilities (conditions, term sheet, covenants)
- Ensured that relevant UML diagrams and Tools (Rose,RequisitePro) were used in all requirement documents e.g.BusinessRequirements, Functional Specifications.
- Facilitated the Customer in defining the high-level Functional Requirements and needs.
- Gathered the Requirements, Develop Process Model and detailedBusinessPolicies and modified thebusinessrequirement document
- Documented approved change controls to add them intobusinessdesign.
Environment: MS Visio, PowerPoint, Quality Center, Rational Requisite Professional, Rational ClearQuest, Rational Test Manager, Rational Clearquest,, Microsoft Visio, Rational Requisite Pro