Sr. Business Systems Analyst Resume
SUMMARY:
- Over around 8 Plus years of extensive experience as a Business Analyst in Software Development Life Cycle (SDLC) using Waterfall, Agile/Scrum, RUP (Rational Unified Process), business and functional requirement gathering, analyzing requirements, business process design and software validation. Collaborated in the implementation of a risk management framework to ensure corporate functions are in compliance with the Federal Reserve's Comprehensive Capital Analysis Review (CCAR) regulatory requirements.
- Highly experienced in broad range of technologies including business process tools such as MS Project, MS Office Suite, MS Visio, Data Warehousing concepts.
- Strong experience in client interaction, understanding business applications and business data flow.
- Facilitates meetings and discussions with internal and external stakeholders throughout the project lifecycle.
- Knowledge of Basel II/III, CCAR, DFAST, PPNR, ALLL, AML, KYC, Credit Risk/Market Risk/Liquidity Risk Modeling and Management, PD/LGD/EAD modeling, Quantitative Approaches including General Linear Regression (GLM), Time Series Analysis (ARIMA/ARCH/GARCH), Decision Tress, Classification and Cluster Analysis, Principal Component Analysis(PCA), Monte Carol Simulation, and Vector Auto Regression (VAR).
- Extensive experience in documenting Business Requirements (BRS), Use Case, Functional and Nonfunctional requirements, Systems Design Specifications, Systems Requirements Specifications (SRS).
- Excellent in performing Gap Analysis to check the compatibility of the existing system infrastructure with new Business Requirements, SWOT analysis, forecasting and traceability matrix.
- Able to effectively influence/motivate self and others, Identifies opportunities for improvement and make constructive suggestions for change following accepted change management procedures
- Facilitates all aspects of UX Research and Usability Testing: recruiting, scheduling, test materials, scripts, findings, reports and presentations
- Proficient in developing Use Cases, Behavior & Structural diagrams, Business Process Flow based on UML using MS Visio.
- Adept in translating business requirements, reporting requirements and user expectations into detailed system specifications employing Unified Modeling Language (UML).
- Strong supporting CCAR related operational risk activities, identifying and monitoring risks to assess the adequacy of capital planning and liquidity stress testing controls. Excellent understanding of Business Requirements Gathering or Elicitation, Translating Requirements into Specifications and Application Design.
- Proficient in using Agile Scrum methodologies, performed roles of Scrum Master following sprint/standup sessions and used Excel extensively to write user stories, analyzed the Iteration Burn down charts and reviewed defects.
- Good knowledge in developing and designing reports through SSRS and Excel.
- Experienced in conducting User Acceptance Testing and coordinating with the UAT participants to get the change requirements.
- Adept in deploying the projects by involving in go - live processes and getting client feedback timely.
- Interact with Business Owner/Sr. Technical managers at the client site to gather more information or validate processes.
TECHNICAL SKILLS
Skill Set: Requirement Elicitation, UML (Unified Modeling Language), RUP,Microsoft Office 2010/2007/2003 , Business Process Analysis & Research, Use Case Modeling, JAD/ RAD Sessions, Requirements Gathering, Gap Analysis and Impact analysis, Finance, Banking, Mortgage, Healthcare. Methodologies like Agile, Waterfall, RUP and UML.
Tools: (Excel, Word, PowerPoint, Access, Outlook, Project, Visio), MS SharePoint Business Definition Requirements, Cognos - BI tool- transform raw data to meaningful things, SAP BI - to enhance and improve business, CCAR, Basel III
PROFESSIONAL EXPERIENCE
ConfidentialSr. Business Systems Analyst
Responsibilities:
- Worked closely with the business owners; conducted formal interviews, live Meetings and JAD sessions to identify requirements and functional specifications.
- Analyzed market tendency and customer purchasing preference of Financial products and derivatives
- Assisted in modeling to set up sales target, premium rates, payment method and product package to fit in different customer base
- Transaction Cost & Algorithms Effectiveness Analysis for the Buy Side Equities trading desk
- Documented High Level Design (HLD) and Low Level Design (LLD) Documents to define the system rules by creating Use cases, interface designs etc. Created Use Case diagram, activity diagrams, sequence diagram in MS Visio.
- Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
- Prepared and processed documents to disbursed funds, made deposits and prepared reports
- Contribute to the development of improved strategic sourcing strategies.
- Responsible for business requirement analysis, data accuracy and quality check, process/approach/model verification and validation, defect management, and System Integration Test (SIT).
- Created gap analysis and specified all required business data for XML messages to place facultative reinsurance submissions, quotations and binder information
- Equities, Fixed income, Foreign Exchange, Derivatives (Equity, Interest Rate and Credit) and Funds businesses in US and Asian markets
- Capital Markets, Investment Banking and Brokerage, Corporate Treasury, Asset / Wealth Management, Exchange operations.
- Trade life-cycle, trading operations, Securities Lending and Repo Transactions, Collateral Management, Both Buy Side and Sell Side trading.
- Interfaced in all aspects of user consulting, business analysis, general systems design, vendor contracts and detail business specification development; learns user functions, organization and role in the enterprise to the extent required.
- Designed and worked on successfully developing web applications that allow independent sales agents and underwriters for quoting, rating, processing and tracking applications.
- Focused on the validation process, reviewing the claims submitted by the servicers to the client.
- Involved in creating the Project templates, Use case specifications, Change request form.
- Worked with cross-functional teams for building use cases, demonstrating the business requirements, developing business models; Designed and developed business flow diagrams, Object Oriented models using MS Visio.
- Worked with the database design team to assist them in designing the database and also created data dictionary.
- Worked with testing team in developing the test plan, test conditions, test cases based on business requirements and technical specifications.
- Involved in UAT process and coordinated with the UAT team to get the feedback to make change requirements document.
- Interpreted business requirements, translating them into business specifications.
Environment: Microsoft Office Suite 2007, MS Visio, MS Excel (Macro), HP Quality Center, SQL Server Management Studio 2005/2008, Reporting Services (SSRS) MS SharePoint. Basel III
Confidential, OH
Sr. Business System Analyst
Responsibilities:
- Gather detailed business and technical requirements and participate in the definitions of business rules and data standards.
- Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
- Conducted current state study, which included data collection methodologies, data quality and data integration problems, and data storage issues.
- Experienced in data mapping, metadata management, gap analysis ETL.
- Elicit, document and Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, and process flows.
- Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Teradata, Data Warehousing, and Cognos.
- Wrote detailed specifications for various reports generated using Cognos.
- In charge of the client liaison required for documenting and recommendations for the change due to the Dodd Frank Act that will be required in the systems.
- Identify all required sub-deliverables, identified client SME’s and deliverables reviewers and created a joint agreed work plan.
- Capturing current state trading workflows, major gaps and opportunities for improvement and mapping out future state derivatives trading workflows including digital signatures and other best practices.
- Single handedly responsible for conducting of surveys of market participants in the derivatives industry to provide input and guidance into the final recommendations and technology platform solutions including workflow automation engines
- Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
- Build and maintain CCAR (Comprehensive Capital Analysis & Review) operating rhythm and governance framework. Liaise with FR Y-14 template owners to ensure compliance with instructions and report timing.
- Project management duties coordinating external consulting team of 15+ members; provide critical input and key decision maker of technical solution design.
- U.S. Basel III Liquidity Coverage Ratio - Requirements Analysis
- Provided oversight over the development of an operational risk model and framework based on the BASEL III pillars (Enhanced Minimum Capital & Liquidity Requirements, Enhanced Supervisory Process, and Enhanced Disclosure-Discipline of Market).
- Provide finance/risk management consulting services on Basel III implementation
- Establish cross-functional reconciliation framework for tie points between FR-Y9C and FR-Y14 reporting templates.
- Supported and maintained alignment of the Enterprise technology architecture to Agency business strategy, goals and objectives, and the defined architectures of other key Enterprise architecture domains (e.g. Application, Data, Security, etc.).
- Involved in the FRY9C and CCAR Q/M/A data analysis and reporting.
- Analyzed and documented the current and the future state of reports related to Credit Risk and different types of securities. Documentation of the processes for all Manual Data feeds and in future to create a Strategic process around the manually sourced data.
Environment:RUP, UML, UAT, SDLC, Rational Rose, SAP, Rational Test Manager, Informatica, Rational Requisite Pro, Rational Clear Case, Rational Rose, UNIX, Oracle 8i, PL/SQL, Mercury Test Director Agile, Waterfall, MS Access, CSV Files, XML File, Basel III
ConfidentialLong Island City, NY
Business Systems Analyst
Responsibilities:
- Worked extensively with the business owners; conducted formal interviews, live Meetings and JAD sessions to identify requirements and functional specifications.
- Conducted and controlled brainstorming sessions with project focus groups which included folks from leadership and management.
- Responsible for researching companies for targeted marketing campaigns, which included in-depth research about the companies, as well as top level management.
- Interacted with the QA team and involved in End to End testing of the interfaces with various scenarios to make sure that the Interface Integration is complete and accurate for different kind of data and protocols (xml data and DB tables via HTTP protocols).
- Created Use Case diagram, activity diagrams, sequence diagram in MS Visio for scenarios including Parole and sentence term scenarios.
- Participate in Daily Agile Scrum "Stand-up", Bi Weekly Sprint Planning and Retrospective Sessions and update the team on status of upcoming User Stories.
- Established and managed the maintenance of the internal portal database of flight management system
- Highlighted technical requirements to assist managers for RFP documentation for outsourcing potential projects and assist hiring
- Presented and trained recruiting personnel on how to best make use of an online tracking database, and the information/metrics that can be synthesized from it.
- Tracked daily issues and analyzed a solution documentation where required.
- Involved in creating the Project templates, Use case specifications, Change request form.
- Actively participated in CAB meetings and overnight deployments
- Worked with cross-functional teams for building use cases, demonstrating the business requirements, developing business models; Designed and developed business flow diagrams, Object Oriented models using MS Visio.
- Develop reports using complex formulas and to query the database to generate different types of ad-hoc reportsusing Tableau.
- Worked with the database design team to assist them in designing the database and also created data dictionary.
- Conducted Model reviews with project team members; Publish and communicate models to various IT and business-based teams.
- Worked with testing team in developing the test plan, test conditions, test cases based on business requirements and technical specifications.
- Involved in UAT process and coordinated with the UAT team to get the feedback to make change requirements document.
Environment: MS Visio, MS Office Suite, Agile/Scrum, Rational Requisite Pro, UML, Windows XP, SOAP, XML, MS Project, Quality center, .NET, Tableau, SQL Server.
ConfidentialNew York
Sr. Business System Analyst
Responsibilities:
- Analyzed complex financial products and system architectures, including accounting business processes including financial and management reporting (e.g. IFRS and US GAAP), month-end closing process, regulatory reporting, entity consolidations and multi-currency accounting.
- Created and revised reporting templates based on industry standards and project requirements.
- Worked through the complete SDLC, Elicit, Analyze and Define requirements.
- Conducted JAD sessions between the end users and the development team. Worked with the software architects / developers to ensure that the applications conform to customer requirements.
- Used Rational Unified Process (RUP) for streamlining the team’s development activities.
- Created project documentation such as BRD and FRD.
- Analyzed current formats for reporting Accounts Payable,Accounts Receivable and Reconciliation towards using some of the necessary fields in the new format too.
- Utilized Process Narratives, Flow charting Techniques using UML, and Good Documentation Practices.
- Reverse-engineer several databases, such as research, business, and clinical to extract metadata to leverage it for ETL design and reporting.
- Created Physical Inventory process for retail stores, consisted of data integration and inventory processes with third party vendor
- Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
- Experienced in developing Object Oriented Analysis and Design Models; Use Case Model and UML.
- Well versed in project management tools like MS Project for project planning, Project scheduling.
- Prepared documents to conduct user acceptance testing.
- Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
- Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
- Followed the UML based methods using Rational Rose to create: Use Cases, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
- Participated Testing and Evaluation of projects at established integration points to assess progress and identify key functionality issues.
- Documented the dimensional models of ETL system.
- Used SQL to test various reports and ETL load jobs in development, QA and production environment
- Tracked UAT issues/bugs and prepared reports.
- Performed job of contact point for all stakeholders (business, legal, compliance, development)
- Took approvals from business owners for business requirements
- Documented monthly status reports for enhancement and modification requests for the development team to assist them in efficient tracking and monitoring of open issues of the project
Environment: UNIX, DB2 UDB, MS PowerPoint, MS Excel, Cognos, RUP, UML, Rational Rose, System Analysis, Testing Strategies.
Confidential
Richmond, VA
Business Analyst
Environment: Windows, MS Project, MS Visio, UML, SOAP, XML.
