Sr. Business Analyst Resume
NY
PROFESSIONAL SUMMARY:
- Domain experience in Financial Markets, Capital Markets, Trading Cycle Systems, Credit - Card Transaction Processing and Portfolio Management
- Diligent in performing day to day management of investments, including the monitoring of endowment portfolio, execution of approved buy/ sell transactions, and regular cash and investment account maintenance
- Experienced with the procedures of Banking & Regulatory Compliances - Anti-Money Laundering (AML), Bank Secrecy Act (BSA), USA Patriot Act, Office of Foreign Assets Control (OFAC) Guidance, Customer Identification Program (KYC/CIP), Basel II & III Accords, Dodd-Frank Act
- Expertise in US Generally Accepted Accounting Principles (GAAP) to be in agreement with Financial Accounting Standards Board (FASB) and in accordance of International Financial Reporting Standards (IFRS) as well as provisions of Sarbanes-Oxley (SOX) Act
- Broad experience in Corporate accounting systems, P&L, Balance Sheet consolidation, General Ledger (GL) mergers, securities accounting, Bank & Account Reconciliations
- Expert in various Software Development Life Cycle (SDLC) methodologies including Rational Unified Process (RUP), Agile (SCRUM), Waterfall
- Strong experience in documenting the Business Requirements Document (BRD), Functional and Non-Functional requirements
- Extensive experience in conducting GAP Analysis between the “As-Is” and the “To-Be” system and performing SWOT Analysis, ROI and Cost-Benefit Analysis during project inception phase.
- Proficient in Acting as liaison between management and development team and QA team for Requirements and Conducted JAD sessions in pleasant and expeditious manners to understand and document requirements such as functional, interface and GUI designs
- Experienced in using UMLforBusinessProcess Modeling, Use Cases, Activity Diagrams, Sequence Diagrams, State transition diagrams, Data Flow Diagrams, Collaboration Diagrams, Class Diagrams and Wireframe prototypes
- Outstanding knowledge of using SQL to access databases like MS SQL Server, strong experience in database modeling and development ofEntity Relationship Diagrams (ERD), Data migration,Data mapping,ETL, and reportingprocess.
- Well trained in creating Functional work plans and User Acceptance Test (UAT) Plans, Test Strategies, Test Cases, and Test Scenarios to measure requirements and provide a Head Start for the QA Team.
- Involved in maintaining the Test & Traceability Matrix, change control process and assisting in Post implementation activities.
- Proven ability to work in team-environment as well as independently and managing workload within time sensitive deadlines in addition to handling multiple projects or tasks under minimal supervision.
TECHNICAL SKILLS:
- Agile (SCRUM), RUP, Waterfall, Rational Requisite Pro, Rational Rose, Rational SODA, Rational ClearQuest, Rational
- Modeler, Rational Clear Case, MS Project, MS Visio, MS Office, MS Access, Cognos, HP Quality Center, UML, Entity
- Relationship Diagram (ERD), ERWIN, TOAD Oracle, iRise, Prototype, MS SQL Server, MySQL, SQL Query Analyzer, XML, UML, TQM, ISO Concepts, SOX & CMM
- Compliance, Windows NT/2000/2005/XP/2007/Vista/7/8, MAC OS, UNIX, lean operations and six sigma methodologies
PROFESSIONAL EXPERIENCE:
Confidential, NY
Sr. Business Analyst
Responsibilities:
- Managed business requirements for the project to move the credit reporting batches to publish counter party exposure limits earlier as a part of FSA compliance requirements for Basel 2 on a daily basis which was used by senior management to make capital funding decisions.
- The credit batch components included components for trade valuations, deal generation, netting id mappings, collateral recognition, Monte-Carlo simulations and counterparty aggregation.
- The batches reported various counterparty exposures and capital limits for all clients across the firm. This was an extremely high visibility project which reported to the steering committee.
- Conducted JAD sessions & surveys to elicit the requirements and performed Gap analysis between the present system and the target system (to be implemented)
- As SCRUM Master proactively involved in Scrum Sprint Planning Sessions, Backlog Grooming, Sizing, Sprint Retrospectives & Reviews, Daily Stand ups, User Stories and Acceptance Criteria, created and prioritized the Back Log in Rally
- Developed and enhanced process flows for static data resolution, counterparty limits calculations and reporting.
- Created enterprise level flows, demonstrated system architecture, connectivity, trade flows and timelines to identify gaps and develop requirements.
- Managed over 300 feeds from various systems of records. Meticulously addressed every detail to ensure a successful end-to-end business process.
- Products covered included Fixed Income, Equities, Commodities and Derivatives, FX, Rates, Swaps
- Created SQL queries for reporting details on derivative trades as a part of Dodd-Frank framework
- Worked extensively with off-shore development teams and tracked their progress through various tollgates over the life of the project. Managed overnight releases working alongside release managers
- Worked on all aspects of the project from interacting with directors and senior business partners for requirements, interacting with upstream/downstream data consumers, dev leads and PMs, creating test plans and test cases, post-implementation checks and future enhancements.
- Coordinated UAT with business partners, helped identify relevant test data and reporting metrics. Tracked post-deployment progress, identified improvements and proposed resolutions to existing issues.
Tools: & Technologies: Agile Scrum, Rally, MS Project, MS Visio, MS Word, MS Excel, Cognos, XAML, HTML, J2EE, SQL, Quality center
Confidential, Charlotte, NC
Business Analyst
Responsibilities:
- Formulated and documented business requirements to support new product initiatives that support strategic plans and customer initiatives.
- Interacted with SME Experts in the laws/act and compliance department to understand the AML/BSA trade surveillance compliance requirements.
- As a SCRUM Master Drafted the project scope document to include the necessary requirements like interfacing with ARU (Audio Response Unit) module for status check and phone notification
- Drafted Project Charter for trade surveillance/AML/BSA compliance program implementation which included project goals, business cases, opportunity statement and high level timeline and team assignments for the project
- Established guidelines and parameters for the system based on currency and foreign transaction regulations like Bank Secrecy Act (BSA), USA PATRIOT act, OFAC, SDN etc.
- Cross trained and supported related groups and areas of AML like Transaction (MIL) Filtration; Analytical Views & Reporting (SAR, CTR).
- Studied the existing CIP/KYC system and performed gap analysis as well as prepared the business requirements document which was transformed for functional specifications as well as preparing test data for the CDD and EDD based on the inputs.
- Modeled business use-cases to validate business process flow to be incorporated in the new system.
- Translated business requirements into functional specifications for communication to technology team & performed GAP Analysis to identify requirements.
- As Scrum Master created and prioritized the Back Log in Rally, coordinated Planning Sessions and maintained User Stories and Acceptance Criteria.
- Performed system analysis to integrate a 3rd party processor for EDT (Electronic Data Transfer) via bank networks. CRAPS (Credit Appraisal System) used file outputs to electronically feed to the internal bank systems.
- Researched vendors to provide real-time FICO score, which would enable the CRAPS rules engine to preprocess the application.
- Created activity diagrams to show dataflow between CRAPS and other system interfaces.
- Interacted with the database group to integrate the new CRAPS MS SQL database in the corporate data warehouse for OLAP Reporting via ETL (Extract, Transform & Load).
- Actively participated in the formal control gate review session to establish requirements baselines and assisted the project manager to update the schedule and scope of the project.
- Assisted in development of materials for new technology and process improvements.
- Identified and documented best practices for the product offering
- Created test cases for system use-cases to validate functionality & contributed User Acceptance Testing with business users. Performed risk mitigation via goal modeling at all stages of the project life cycle.
Tools: & Technologies: Project 1: Agile Scrum, Actimize / Mantas AML, MS SharePoint, MS Office (Excel, Word, PowerPoint), MS Visio, UML, LexisNexis, Factiva, World-Check, Subversion (SVN), Rally, SQL, JIRA, Erwin, iRise, HP Quality Center
Confidential, NY
Business Analyst
Responsibilities:
- Gathered and analyzed business requirements and developed artifacts included business requirement documents, functional specification documents, use case, test plans and requirement traceability matrices
- Developedfunctional specificationsbased on high level requirements provided by the end users.
- Interacted withbusinesspartners, management and design teams for identification ofbusinessand system requirements.
- ConductedBusinessGapAnalysis, feasibility study andimpact analysisof the current functionality with respect to proposed enhancements and new requirements.
- ConductedFeasibility analysisthrough mapping of As-IsBusinessprocesses versus To-BeBusinessprocesses.
- Identified and documentedbusinessneeds and created detailedUse CasesusingUML, and collaborated with production team to identify and map detailed existing processes, identify system gaps and developedfunctional requirements documentation (FRD)that supported overall strategy, goals and objectives.
- Created Business specifications,data flow, activity diagramsandstate transition diagrams using Rational Rose
- Interacted with various cross-functional teams to buildbusinessuse cases and understand banking regulations and Cash-Management functionality
- Assisted Project Managerin maintaining and monitoring project progress and status usingRational Requisite Pro,providing high level estimates of efforts for analysis, implementation and support of application, estimating delivery schedule and resource allocation.
- Interfacedbetweenbusinessusers and offshore development / QA team to ensure thebusinessspecifications are met and solicitbusinesssign-offs.
- Establishedtraceability matrixusingRational Requisite Proto trace completeness of requirements in different SDLC stages, and managed changes requests; controlled, tracked and monitoredchange requestsusingRational ClearQuestto enable successful interactive development
- Conducted data analysis and data validation by coordinating with technology team to run SQL queries using TOAD for ORACLE database.
- Developedtest planswith QA team and helped to developtest scenariosforsystem testing,integration testingandperformance testing
- ConductedUAT,documented and reported user feedbacks to management team, and developed materialsfor different end users and assisted inUser for the new system.
- DraftedUser Manualsoutlining the features of the application and step-by-step process for using the functionality provided by the application.
Tools: & Technologies: RUP, Rational Requisite Pro, Rational Rose, Rational ClearCase, Rational ClearQuest, UML, Windows 7, Java, TOAD Oracle, SQL
Confidential, Boston, MA
Business Analyst
Responsibilities:
- Responsible for gathering requirements from users and functioned as the primary liaison between the operations and the technical team and resolved process issues throughout the project cycle.
- Collaborated with the marketing team in identifying the needs of the customers
- Performed Valuation models to determine firm specific “Free Cash flow to equity & Free Cash flow to Firm”.
- Established a Business Analysis methodology around RUP (Rational Unified Process).
- Facilitated numerous Joint Application Development (JAD) sessions utilized for the creation of design documents and system specifications for applications.
- Worked on a Portfolio Management System, which supplies users with intra-day and end-of-day speeds, status of modeled bonds, as well as market and credit risk (delta) information.
- Responsible fordatamapping of feeds from several datasystems, to a number of in-house applications.
- Used MS-Visio to document current work flows, manual processes and end-to-end processing of system interactions
- Modeled trading activities and designed comprehensive Test plan and Test case accordingly. Coordinated Unit Testing, Integration Testing, and User Acceptance Testing (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
- Played a key role in the planning,testing, and implementation of system enhancements and conversions.
- Used Test Director for Storing Requirements, Bug Tracking and Reporting activities.
- Analyzed research on operational procedures and identified opportunities for improvement with an emphasis on automation and efficiency.
Tools: & Technologies: MS Project 2007, MS Visio 2007, MS Word 2007, MS Excel 2007, Mainframe, Java, PL/SQL, Load Runner, HP Quality Center, Citrix
Confidential
Financial Analyst
Responsibilities:
- Budgeted/forecasted - data collection and provided variance analysis, updated staffing plans
- Preparing financial, ad hoc analysis, month end actuals versus Budget Forecast analysis and explanations and responding to BU/IT questions
- Facilitated allocation management team by updating metrics, reviewing data loads for accuracy, observing trends and identifying changes, allocation modeling and troubleshoot issues
- Worked closely with Requirements Analysts and Subject Matter Experts to identify, understand and document business needs for the data flow to create market risk and credit risk module
- Constantly partnered with project leads to ensure the team is producing solutions that meet established standards, procedures and practices, address issues, risks and mitigation plans.
- Assisted Project Manager in executing data analytics with emphasis on credit scoring, credit risk, behavioral models, loan loss and general purposerisk/profitability models
- Proactively identified and removed blockers, facilitate frequent retrospectives, sharing metrics to identify and implement improvements.
- Actively participated in employing various statistical analysis methodologies including regression analysis and Developed prototypes for multi-currency Portfolio market value reconciliations - LMV and BMV calculations
- Aided in designing Trade-Break, Aggregate report formats and evaluating COGNOS as an strategic reporting tool
Tools: & Technologies: MS Project, MS Word, MS Excel, MS Visio, Cognos, MS Access, MS PowerPoint
Confidential
Analyst
Responsibilities:
- Performed financial research, analysis, and reporting of Fixed Assets data. Strong knowledge and experience with fixed assets including leases, tax-related fixed assets issues and business combinations
- Monitored and analyzed Key Performance Indicators (KPI) and financial ratios and implemented improvements for Fixed Asset processes
- Maintained Fixed Asset register using internal bank system module with experience in writing queries and reports
- Conducted complex financial analyses to provide information and recommendations to management. Provided written analyses and interpretation of results
- Reconciliation of all Fixed Asset related General Ledger accounts. Prepared journal entries related to assigned functional responsibilities
- Processed and validated invoices, provided coding to finance, obtained line management approvals and reconciling billing discrepancies
- Reviewing monthly accruals for accuracy and helped identifying automations and process improvements
- Supported audits by various agencies by providing information as requested
- Communicated accurately with fellow associates and management at all levels
Tools: & Technologies:Tally, MS Word, MS Excel, MS PowerPoint