SUMMARY

• Certified Scrum Master with 8+ years of experience working as a Business Systems Analyst in the finance and investment/ retail banking domains using the Agile and Waterfall methodology.
• Adept at creating various project artifacts like Business Requirements Document (BRD), Functional Specifications Document (FSD) and Systems Requirements Specifications (SRS) and other forms of documentation.
• Conducted JRD sessions to in corporate cross - functional requirements to ensure that ambiguous and articulately defined requirements are understood by all the stakeholders involved.
• Expertise in Business Requirement gathering, Functional Specifications Documenting, Business Process Modeling Notation (BPMN) and Business Analysis and understanding the Business Process Flow.
• Strong understanding of the different phases of Software Development Life Cycle (SDLC) using Waterfall and the Agile family of methodologies such as Scrum and Rational Unified Process (RUP).
• Detailed understanding of all the phases of the SDLC phases from Ideation to Planning, Design, Development, Testing, Maintenance and Disposition for the software/system development process.
• Highly skilled as a Scrum Master in conducting and facilitating the Scrum process using JIRA Agile. This includes ensuring the adherence of all Scrum practices, enforcing time boxes and maximizing the productivity of the team by remedying impediments.
• Thorough understanding of the various processes of the Scrum process including the compilation of Scrum artifacts such as the Product & Sprint Backlog, Velocity Charts and the Burndown/Burnup charts
• Proficiency in conducting GAP analysis, SWOT analysis, Impact analysis, Feasibility analysis, Cost-benefit analysis and Risk analysis.
• Created User Stories and specified their acceptance criteria using Blueprint Systems
• Experience in Business Intelligence (BI) tools such as Microsoft tools such as SSAS, SSRS and PowerPivot for data mining and to generate and depict actionable insights.
• Experienced in facilitating Joint Application Development (JAD) sessions as well as conducting interviews (structured and unstructured), questionnaires, brainstorming sessions and focus group sessions as techniques for requirement elicitation.
• Proficiency in creating UML diagrams like Use-Case diagrams, Activity diagrams, Statechart diagram Deployment diagrams and Sequence diagrams using MS Visio and creating Use Cases for functional requirements using Blueprint.
• Proficiency at database handling and data manipulation for RDBMS and Object Databases in Oracle Data warehouse and MS SQL Server.
• Worked in all phases of Data Warehousing project like Data Cleansing, Data modeling for Operational Data Stores & Data Mart, ETL, designing schemas (star and snowflake) for business users.
• Experience in issue/bug tracking in JIRA using cloud computing and understanding the various reporting charts used such as the Cumulative Flow Diagram, Control Charts, Sprint Report, Epic Report and Version Reports
• Proficiency in creating visual graphs and interactive dashboards using Tableau to generate useful business insights by querying, analyzing and visualizing sets of data.
• A good understanding of the HP-ALM from Release & Requirements Planning, Test Execution and Defect Tracking
• Experimenting sets of Test Cases in a Test Lab Module in HP-ALM
• Understanding the Data Cleansing/Data Manipulation and Master Data Management process and the various ETL Services in Informatica including the Repository, Integration and Reporting Service, creating mappings and executing process threads to execute workflows.
• Proficiency in understanding of Web-Services using the HTTP methods to implement the concept of REST and SOAP architecture using SOAP UI as an API tool. Used programming languages like XML and JSON for Three-Tier Architecture and Service Oriented Architecture (SOA)
• A good understanding of SQL programming including the use of all the Operators, data manipulation commands, SQL joins and the usage of sub-queries and stored procedures

TECHNICAL SKILLS

Methodologies: Waterfall-Scrum Hybrid, Agile-Scrum, Waterfall

Project Management Tools: JIRA Agile, HP Application Lifecycle Management (ALM)s, MS Project Professional 2013

Requirement Tools: IBM Rational DOORS, Blueprint Systems

Languages: SQL, HTML 5, XML, JAVA

Business Intelligence: Tableau, SSRS, SSAS, PowerPivot, Excel Vlookup, Hlookup

Databases/ Query Tools: MS SQL Server, Oracle SQL Developer

DW/ MDM Tools: Informatica, SSIS

Reporting Tools: Tableau, Qlikview

Modelling Tools: MS Visio, BPMN, UML Process Flows, Blueprint Systems, Balsimiq

Testing Tools: SOAP UI, UAT, Unit testing, Integration testing, System testing, HP QC, LoadRunner

Miscellaneous Tools: MS Office, MS SharePoint, Change Management, Conflict Management, WebEx, Skype, Beam Managment

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Sr. Business Analyst/Scrum Master

Responsibilities:

• Have a thorough understanding of the different resolution asset classes ranging from equity (stock) trading to surety bonds, government bonds, mutual funds and other marketable securities which can help in the diversification of a portfolio and asset management for investment banking
• Designed the business requirement collection approach based on the project scope and the SDLC using Agile methodology
• As part of the CFTC’s (Commodities Futures Trading Commission) rules for credit and trade regulations, ensured that the trading of marketable securities were handled with minimal counter-party risk and credit risk for the obligee.
• Collect and document the business requirement documents, functional specification documents, project schedules, design artifacts and the test plans.
• Using JIRA Agile and Blueprint Systems, created user stories and their relevant acceptance criteria for specifying functional requirements for a broad range of features including the login, dashboard and database functionality.
• Facilitated the Scrum process including the time-boxed Daily Sprints, Sprint planning meeting, Sprint review meeting and the Sprint retrospective meeting.
• Proficient with the use of JIRA Agile for Scrum including tracking the different types of issues (epics, user stories, tasks etc) and categorizing them into swimlanes for daily sprints.
• Using JIRA AGILE compiled the Scrum artifacts such as the control chart, burndown chart, velocity chart, sprint report, cumulative flow diagram and gadgets such as agile sprint health and agile sprint burndown
• Worked as an Operations Analyst by collecting and analyzing business requirements and business process information from clients by conducting user interviews and questionnaires and then translating the requirements into technical specifications.
• Have an understanding of the Basel Accords (Basel 1, 2 & 3) and CCAR (Comprehensive Capital Analysis And Review) for regulations and supervisions in the banking sector.
• Understand the business logic that underlies the mapping of the workflow of the component data and the control variables from disparate vendor sources to the financial APMS database using Informatica.
• Using Excel’s VBA Macros, wrote and executed automated processes such as computing best portfolio for n returns and generating list of personnel who work for the company
• Designed and analyzed use case diagrams and sequence diagrams using Microsoft Visio to depict process flows and PowerPoint presentations.
• Worked on Business Intelligence (BI) tools such as Tableau for reporting/analysis and data visualization to create drafts of dashboards consisting of charts, graphs and other relevant information.
• Used Blueprint and IBM Rational DOORS for requirements gathering and crafting the requirements traceability and for visualizing user stories.
• Write SQL queries for retrieval of data from the APMS database for querying and analysis using Microsoft SQL Server 2012
• Regularly interacted with the financial analysts, portfolio managers, data warehousing team, data services and client reporting team to assess business work flows and inadequacies and to aid in Corporate Actions.
• Conducted Gap analysis to assess the effectiveness and inadequacies of the current work environment and to help with adequate Corporate Actions.
• Conducted JAD sessions as an elicitation technique to ensure that it paralleled with the technical specifications of the developing application.
• Worked with Change Management teams for business process optimization.
• Used SOAP UI for A/B testing
• Created test cases and scenarios for the test suites.
• Oversee report generation and aggregate reporting from the modeling/analysis system modules using Tableau and ensure its proper distribution to the system users.
• Gather and document requirements for new and existing web development using interviews with the business users and conduct document analysis, process and workflow analysis.
• Conduct regular meetings with stakeholders to analyze and document project requirements.

Environment: Agile, Waterfall & Scrum methodology, MS Visio, MS Word, XML, Microsoft SQL Server, Microsoft Management Studio 2012, JIRA Agile, HP-ALM, Balsimiq, Blueprint, Change Management. SOAP Web Services, API, Soap UI, Informatica Powercenter 9.6, JRD, JAD, Tableau, Traceability Matrix, UML designs, GAP analysis and MS Powerpoint

Confidential, Philadelphia, PA

Sr Business Analyst/Scrum Master

Responsibilities:

• Created and reviewed business requirements, functional specifications, project schedules, documentations and test plans using IBM Rational Doors
• Performed extensive requirement analysis including data analysis and GAP analysis.
• Ensure that various user behavior metrics such as the delivery rate of messages, the click-through rate & digital media dissemination are translated into KPIs and are documented and available to the business owners’ and their business partners’ server for study and analysis.
• For the Scrum process, compiled and documented scrum artifacts such as Sprint Backlog, Velocity Chart and Burnup/Burndown charts using JIRA Agile
• Used JIRA Agile for Scrum by prioritizing the different types of issues (epics, bugs, user stories) and used the Agile simplified workflow to track them in a timely manner.
• Using Blueprint Systems, created user stories and their relevant acceptance criteria so that they could be translated to the relevant Product Backlog Items (PBIs) for Scrum
• Understand the business logic that underlies the batch data integration for the purpose of building mining models for data analysis using Informatica Powercenter 9.6 as an ETL tool
• Facilitated the Scrum process by ensuring time boxed meetings, resolving impediments and ensuring that the development team were able to work in concert in a congenial environment by shielding them from stakeholders’ interference.
• Assisted the Product Owner in prioritizing the Product Backlog Items (PBIs) using Moscow for Scrum.
• Understand the SOAP architecture and the HTTP methods used for optimal data exchange between the Traffic Analysis service provider and the Business Owner’s server.
• Have an understanding of the “tag builder” process using HTML 5 scripting.
• Used SOAP UI as a web services and API tool to conduct A/B testing, functional testing, mocking & simulation, load & security testing and integrated analytics.
• Used Balsamiq to create mockups and wire-framing by creating two-dimensional illustration of a page’s interface and the layout of the information architecture
• Worked on the Omnichannel business model to work on User Experience (UX) to improve the quality and perceptions of user interactions with our software
• Used Oracle’s PeopleSoft Workforce Scorecard to create dashboards of performance scorecards which is then sent to the departmental managers to monitor workforce performance.
• Used SQL to access the data housed at the database from the third party traffic server using Microsoft SQL server
• Oversee the release cycles, test execution, test planning and defect tracking of the software products using HP-ALM.
• Ensure that data mining parameters and other aggregation reports are translated into graphical format to the appropriate server partners using Tableau.
• Used Microsoft’s SSAS, SSRS and PowerPivot as a Business Intelligence (BI) tool for the generation of visually interactive dashboards for data visualization.
• Document requirements using JRD sessions from the software developers and other technical staff to determine the level of effort required for development.
• Collect and analyze data from usability tests and translate the research findings into actionable design.
• Participate in the implementation phase to ensure that the proper business scope has been met and create test plans and conduct UAT (User Acceptance Testing) with the end users.
• Relay upgrades, software rollouts and new functionalities with internal and external technology teams.

Environment: Waterfall - Scrum Hybrid, 3 - tier architecture, JIRA Agile, HP-ALM, MS Visio, HTML 5, MS Word, Project Lab, Balsimiq, Microsoft SQL, Microsoft Management Studio 2012, Moscow, XML, PeopleSoft Workforce Scorecard, Blueprint, SOAP Web Services, Omnichannel, SOAP UI, API, Informatica Powercenter, MS SharePoint 2013

Confidential, New Brunswick, NJ

Business Analyst

Responsibilities:

• Create and review business requirements, functional specifications, project schedules, documentation and test plans.
• Conducted Feasibility Study and undertook Scope Analysis to institute proposed changes which then served as proposed recommendations to the business users.
• Partake in requirements and Gap Analysis study with the clients. This aided in analyzing business needs and developing use case scenarios to facilitate JAD sessions.
• Collaborate and co-ordinate with stakeholders to formulate the project scope boundaries.
• Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams using Blueprint
• Developed timelines for project delivery, and managed projects and resources to successful completion.
• Acted as a mediator between the financial analysts and the clients both in a business and technical capacity.
• Assess the pricing methodology, collateral management and vendor treatment for new option types and OTC derivatives.
• Ensure proper aggregation and visualization of the Options Values using Tableau.
• Oversee and manage the testing for each of the release cycles using HP-ALM.
• Oversee the development and building of unit test programs and their execution, support integration testing and facilitate user acceptance testing (UAT) to ensure conformance to design and accuracy of implementation of the financial engine.
• Worked on Microsoft’s SSAS, SSRS and PowerPivot as a Business Intelligence (BI) Tool to analyze and generate the real time characteristics of Options in the Financial Engine.
• Using Informatica understand the business logic that underlies the mapping of the workflows containing financial inputs such as the market price of the underlying asset, its volatility, interest rate, maturity, dividend yield etc into the financial engine.
• Ensure that the repository of historical and current data was maintained for transaction management for the financial analysts and the system users at the middle office.
• Work with the technical team, business users and the support team on JRD sessions to document the requirements for the implementation phase of the projects.
• Used SQL to assess and manipulate the data from the financial engine for the forward pricing model.
• Monitor and study significant market events to narrow down the gap between the observed and computed pricing of the underlying asset of an option.
• Ensure compliance with state, federal and other regulatory law standards by ensuring adequate record keeping.
• Accountable for risk assessment management and client engagement management.

Environment: Waterfall, MS Word, MS Visio, MS Excel, MS SQL Server, SQL, JIRA, Web Services, Informatica, Powercenter, Blueprint, HTML, HP-ALM, MS Project Professional, Tableau.

Confidential, Bloomington, IL

Business Analyst

Responsibilities:

• Act as a liaison between business users and the technical team to ensure all engaged parties have complete understanding of issues/requests, requirements and process steps to ensure strategic goal alignment, optimal performance and seamless execution.
• Ensure that adequate credit risk assessment were seamlessly incorporated into the paperless loan processing initiative.
• Works with business owners and stakeholders to document all business requirements, process maps, flow charts and technical documents.
• Collaborate with business owners to analyze, design and execute process improvements, quality reviews and reporting solutions.
• Ensure accountability and consistency of data with respect to the calculations and other metrics.
• Ensure proper testing of system upgrades, update rollouts and the implementation of new systems.
• Partake in meetings with clients, investors and vendors to improve reporting strategies and to ensure accurate reporting.
• Monitor critical investor announcements and work with Business and Change Management teams to implement reporting changes adherent to the company’s business goals.
• Ensure responses to internal and external audit requests comply with the established guidelines and are completed and submitted within the required timeframe.
• Ensure that the Quality Control of reporting and performance dashboard support business functions for the vendors and clients.
• Work with business and developers to identify test case scenarios.
• Ensure compliance with the state and federal legal/regulatory environments.
• Diagnose system problems and work internally or with the vendors to solve them.
• Monitor and support a shared team mailbox.
• Provide on-call support as needed.

Environment: Waterfall, MS Word, 3-tier architecture, JIRA, HP-ALM, MS Visio, MS Excel, SQL, SOAP Web Services, Informatica, Powercenter, HTML/CSS, MS Project Professional, Change Management, Tableau

Confidential

Business Analyst

Responsibilities:

• Performing data-mining and statistical analysis, including predictive modeling to develop database-marketing strategies that improve customer acquisition/ retention, enhance customer experience and maximize customer lifetime contribution.
• Developing clear, concise, and actionable insights into customer characteristics and behavior.
• Understanding diverse product sets that Confidential Bank offers across its Asset, Liability and Card business.
• Ensure proper documentation of business required documents, functional specification documents, test cases and end-to-end process map.
• Designing and implementing meaningful tests and analytical approaches to address business needs.
• Analyzing and measuring the business impact of analytical scorecards and other customer communications.
• Conduct meetings with internal clients and project stakeholders to identify business problems and formulate ways to resolve them.
• Conduct GAP analysis to analyze and improve the existing work processes.
• Essaying a liaison role and provide investment information support in a dynamic investment risk environment.
• Sifting through large volumes of data while being able to document and communicate findings to the business owners and stakeholders at an executive level.
• Troubleshooting production and test issues using JIRA.
• Engaging with business teams in the bank in the development and implementation of data-driven strategies.
• Act as a single point of contact for escalations identify the issue and addressing to the owner.
• Analyze the root cause for delays or incorrect processing and propose sustainable solution.

Environment: Waterfall, MS Word, MS Visio, MS Excel, RUP, SQL, Oracle Data Warehouse, Web Services, Informatica, Powercenter, HTML/CSS, MS Project Professional, Tableau

Confidential

Business Analyst

Responsibilities:

• Expansive knowledge of general insurance, credit risk, loan issuance, underwriting, policy servicing, claims and re-insurance
• Create and review business requirement documents, functional specifications documents, project schedules, documentation and test plans.
• Using the SDLC methodology and the project scope, designed the business requirement collection approach.
• Using interviews/questionnaires analyzed and documented the business users’ requirements to the developmental team.
• Conduct meetings with the project management teams, business users and vendors to identify the business needs.
• Document and analyzes operating data and develop imperative insights and leveraging results to institute proper recommendations for improvement.
• Ensure accuracy of operating data through assessing and investigation of discrepancies and issues.
• Contribute in market share growth and profitability by recommending optimal analyses, product design changes, pricing, and risk management.
• Implement improvements in the visualization of data using Tableau for the divisional and departmental dashboards.
• Co-ordinate with the client’s Business Intelligence team to optimize tools and reporting performances.
• Partake in measuring and improving KPIs and undertake continuous improvement initiatives.
• Ensured a savory environment for effective teamwork by maintaining communication with the business users and the developmental team.
• Ensure written and oral communication of technically intricate terms and data to the non-technical users.

Environment: Waterfall, Agile, SQL, Oracle, SQL Developer, MS Office Suite MS Project, MS Visio, HP-ALM, Java Ajax, JavaScript, Informatica, JIRA