SUMMARY

• Business Systems Analyst with 9+ years of experience in Business Development Process and System and Data analysis with extensive work experience in the domain of Finance, Banking and Trading and a registered CFA Level lll and FRM Part ll candidate.
• A Certified Scrum Master with hands on experience in various Software Development Life Cycle (SDLC) methodologies.
• Experience on Waterfall, Agile Scrum and Hybrid of Waterfall and Agile methodologies with the ability to work with self - managing, self-organizing, and cross-functional teams along with coaching of agile framework across the verticals of the organization.
• Sound knowledge of Extreme programming, Rational Unified Process (RUP), Spiral Model, SAFE and Kanban.
• Designed and documented Business process modeling using Swim Lane based Business process flows accompanied by conducting and facilitating elicitation sessions such as survey/questionnaires, Interviews sessions, Brainstorming sessions, Focus group sessions, Requirement workshops, Observation, Prototyping, Interface analysis, Root Cause analysis, Document analysis, and Joint Application Development (JAD) sessions with internal as well as external stakeholders.
• Experience in conducting GAP analysis, Impact analysis, SWOT analysis, Cost benefit analysis, Root cause analysis, Feasibility study, Impact analysis, Risk Analysis, and As-Is and To-Be business analysis and drafting reports.
• Successfully gathered requirements based on SMART (Specific, Measurable, Attainable, Realistic and Timely) technique.
• Facilitated Change Request Management, testing and created and validated Business Requirements documents (BRD), Use-Case Specifications, and System Requirements Specifications (SRS), and verified Requirement Traceability Matrix (RTM) along with Request for Information, Request for Offer (RFO) and Statement of Work (SOW) documents.
• Experience in building Unified Modeling Language (UML) diagrams including Use Cases, Activity diagrams, Sequence Diagrams, Class diagrams, Data Flow Diagrams, and transforming the requirements gathered into functional specifications focusing on workflow analysis and design, user interface design, data flow, process flow and (Entity Relationship) Diagram.
• Good understanding in building and maintaining Responsible, Accountable, Consulted, and Informed (RACI) Matrix.
• Experienced in writing User stories using INVEST technique and handling the Requirement Churn. Efficient in facilitating Product Owner to prioritize using techniques such as MoSCoW Technique, KANO Model Based and Business Value Based.
• Hands on experience in facilitating Sprint Ceremonies (Product Backlog grooming, Sprint Planning meeting, Daily Scrum/Stand-up meeting, Sprint Review meeting and Sprint Retrospective meeting) for Agile Scrum as Scrum Master.
• Hands on experience in using estimation techniques such as Planning Poker, T-shirt sizing, Relative Mass Evaluation.
• Experience in converting Business functionalities into Service Oriented Architecture (SOA) models across IT environment. Created Data Mapping Documents using Hypertext Markup Language HTML, and Extreme Markup Language XML.
• Experience working in Three-Tier architecture, Ajax, Simple API for XML, Web Services (SOAP, WSDL), Client-Side Validation, and Server-Side Validation. Possess knowledge of validation scripting like JavaScript, JQuery and Angular JS.
• Experience in Testing Life Cycle and supervising Black-box Testing, Functionality Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT), Load/Stress Testing, and Performance Testing.
• Worked with QA team to design Test plans and Test Cases for User Acceptance Testing (UAT) using HP QC/ HP ALM.
• Experience in Data Integration using Data center with Hub and Spoke. Extensive implementation knowledge of Databases, Data Table structures, Schemas, Data Marts and OLAP operations such as Roll-up, Drill-down, slice and dice and pivot.
• Experience working in Mainframe environment and deep understanding of database concepts like Data Warehousing, Data Structures, Schemas, Data Marts, Data-Entity Relationships and User Administration. Worked extensively with Data warehouses by migrating data from various OLTP’s to OLAP cube using ETL tools such as Informatica and SSDT-BI.
• Extensive knowledge of Data Cleaning to understand current applications relevant to International Rating Based Risk Weighted Assets calculations (IRB RWA), Pre-Provision Net Revenue forecast, and Comprehensive Capital Analysis Review test.
• Sound understanding of Value at Risk (VaR), Mortgage Valuation, and portfolio management and experience in validating, maintaining, and manipulating customer datasets for predictive modeling of Basel Parameters (PD, LGD, and EAD).
• Strong knowledge of Credit Risk, Market risk and Liquidity risk for various Capital market instruments.
• Excellent understanding of treatment of Goodwill, Impairment, Capitalization and Expensing.
• Excellent Interpersonal skills to interact with end-users, Subject Matter Experts SME’s and Project Stakeholders.
• Excellent Analytical, Problem solving, Communication and Documentation skills. Dedicated & Self- motivated, proven leadership capabilities and Time management skills with sound HPSM knowledge.
• Strong understanding of leasing life cycle and Loan Syndication as well as Loan IQ and their alignment with regulatory norms.
• Strong knowledge of System Infrastructure for functional as well as for non-functional requirements for Crystal Reporting.
• Acted as a strategic partner between the business community and IT development teams to resolve functional and technical issues related to business applications with strong understanding of client on board process.
• Strong experience with workflow based systems as well as comfortable with analyzing large volumes of data.
• Analyzed dexterously large volumes of data as well as facilitated workflow, checks as per the business rule for commercial loan.
• Knowledge of Project Management activities, proficient with Project Management Tools, testing tools and defect reporting tools.
• Worked under tight deadlines and multi-tasking to meet business goals. Experience in scheduling meetings, negotiating and co-ordination with Developers, Application Architects, and Subject Matter Experts.

TECHNICAL SKILLS

Finance and Banking Domain knowledge: CCAR/DFAST, MiFID II, BASEL lll, SOX, National Automated Clearing House Association (NACHA), Asset allocation, Portfolio management, Fixed Income (Bonds, Convertibles, T-Notes, T-Bonds), Derivatives Money Market Instruments and Mutual Funds.

Project Management Tools/Methodology: MS-Project, MS Share Point, Rally, JIRA, and Agile-Scrum, Waterfall-Scrum, Waterfall, Extreme Programming, and Kanban.

Modeling Tools: PowerDesigner, ER/Studio, ORACLE SQL developer Data Modeler

Requirement Management: MS Office, JIRA, Confluence, HP ALM 11.5.

Reporting Tools: IBM Cognos, Tableau, MS office Suite, Spotfire

Database: MS SQL server 2012, MS Access, Oracle 9i, DB2

Transaction Processing (OS): IBM CICS TG V9.0

Mainframes (Hardware): IBM z13 2964 series, IBM z10

Testing Tools: HP QC, Load runner, Bugzillla and SOAP UI

ETL Tools: Informatica, SQL Server Data Tools-Business Intelligence (SSDT-BI)

Languages: HTML, XML, MS SQL, Base SAS 9, SOAP and Java

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, New York

Project Manager

Responsibilities:

• Identify and engage key stakeholders and contributor to both business and technical that must participate in the project and ensure that contributors are motivated to complete assigned tasks with in parameters of the project plan. This is across many different geographic locations.
• Plan, organize and control activities associated with roll out or enhancement of a global technical solution not limited to an individual country. This may involve understanding, navigating and following local country project, compliance, regulatory risk, legal and any other required Confidential processes and guidelines.
• Facilitating necessary project meetings and follow ups with team members as required to focus on driving business, operational and /or technical tasks, risks and issues to completion. Documenting, assigning and monitoring all project activities to completion.
• Coordinated working with the business, business analysts, technical resources and other supporting teams to drive the project and ensure a delivery of requirements with in Confidential standards. Teams will span many geographic locations.
• Create and managing project plans using tools that facilitate task listing, assignment, tracking and approvals to ensure business requirements are completely satisfied and on time.
• Engage and participate with various stakeholders in various testing phases i.e. UAT, DR and heading sign offs. Creating or contributing to project status on assigned projects and keep management apprised of project status, issues, risks, scope changes, and milestone achievements or misses.
• Used JIRA for issue tracking, user story management and requirement traceability.
• Troubleshoot data or transaction issues, and reviewed opportunities to leverage new functionality.
• Worked with the Product Owner during the Sprint Review Meeting for the Potential Shippable Product Increment (PSPI) and help decide which feature are DONE and satisfied using the Acceptance Criteria.
• Assisted with User Acceptance Testing, developing and maintaining quality procedures, and ensure that appropriate documentation is in place. Assisted in Black box testing, Integration testing, DR exercise maintaining consistency in migration data from legacy by testing both systems parallelly.

Environment: Scrum - waterfall Hybrid, MS Visio, MS Project, MS SQL Server, Visual studio 2013, JIRA 5.2, MS Office Suite (MS word, MS Excel, PowerPoint) 2013, IAS 2012.

Confidential, Cincinnati, Ohio

Sr. Business System Analyst/Scrum Master

Responsibilities:

• Gathered requirements as per regulatory article 31 CFR Part 210 and owned the requirements process and oversaw it from the beginning of development as well as performed requirements related progress tracking, and managing Liquidity and Market risk.
• Elicited requirements using JAD sessions, Survey/Questionnaire, Interview sessions, Focus Groups with the UI/UX team and analyzed the feasibility of the requirements and formulated and conducted GAP Analysis to derive requirements for ACH processing as well as assisting PM in creating work breakdown structure and project charter using MS Project
• Conducted a detailed Feasibility check, Impact analysis, Cost analysis, System Functional analysis for system infrastructure.
• Coached the team and Implemented software methodologies including Agile (Scrum) Scrum - waterfall Hybrid.
• Interacted with SME’s, asking detailed questions and carefully recording the requirements in a format that can be understood and reviewed by both technical and business people.
• Created Mock-Up Screens and Wireframes using User Interface GUI components for client verification.
• Adopted Entity-relationship modeling technique and developed Conceptual and Logical data model for DFI tables.
• Logged Data Mapping documents of various HTML field to XML tags and further onto tables stored in database.
• Conducted User Story Writing sessions and determine Acceptance Criteria for Potentially Shippable Product Increment.
• As a SCRUM Master, facilitated and time-boxed the SCRUM ceremonies Sprint Planning Meeting, Daily Standups, Sprint Review Meeting, Sprint Retrospective Meeting and Grooming Sessions.
• Helped the Product Owner to Prioritize the Product Backlog items for developing Sprint tasks by taking suggestions from the cross-functional development team.
• Highly proficient in writing and prioritizing user stories in Product Back Log with Product Owner.
• Analyzed the Iteration Burn Down charts and reviewed defects.
• As experienced Scrum Master anticipated and removed obstacles from project team’s path and pushed them to deliver quality results based on schedule.
• Used JIRA for issue tracking, user story management and requirement traceability.
• Troubleshoot data or transaction issues, and reviewed opportunities to leverage new functionality.
• Worked with the Product Owner during the Sprint Review Meeting for the Potential Shippable Product Increment (PSPI) and help decide which feature are DONE and satisfied using the Acceptance Criteria.
• Generated ad hoc SQL queries using joins, database connections and transformation rules to fetch data from the SQL Server database systems. Drafted reports based on the analysis using SSRS (Power Pivot and Power View).
• Assisted with User Acceptance Testing, developing and maintaining quality procedures, and ensure that appropriate documentation is in place. Assisted in Black box testing, Integration testing, Load testing using LoadRunner and Regression testing using UFT.
• Extensively involved in the User Acceptance Testing phase to ensure the requirements and functionality of the system was in accordance to the users and their feedback was incorporated.
• Conducted Risk analysis as required by NACHA and maintained a Risk Register.
• Communicated effectively across company contacts and clients regarding requirements, schedules and launches.

Environment: Scrum - waterfall Hybrid, MS Visio, MS Project, MS SQL Server, Visual studio 2013, JIRA 5.2, IBM CICS, Tableau 8.3, MS Office Suite (MS word, MS Excel, PowerPoint) 2013, IAS 2012, SAS, LoadRunner 12.02, UFT 12.02, HTML5, CSS3, Bootstrap.

Confidential, Austin, Texas

Sr. Business System Analyst/Scrum Master

Responsibilities:

• Assisted PM in creating work breakdown structure to in corporate inputs from UI/UX team and project charter using MS Project.
• Elicited requirements as per SEC and FINRA regulatory norms and conducted extensive GAP analysis by identifying AS-IS and TO-BE process models as well as process flows and help product owner to plan how to bridge the gap.
• Created Mock-Up Screens and Wireframes for designing GUI.
• Facilitated Fair Value calculation as well as consolidating PnL and Balance Sheet statements for internal reports.
• Elicited requirements involving vast set of interactions with various stakeholders using JAD Sessions, Structured Interviews, Process Analysis and Business Rules Analysis.
• Analyzed feasibility of business requirements and defined scope, found out dependencies by interacting with Management Business Analysts, other Subject Matter Experts, Product Owner, Project Manager and Technical Lead.
• Created a Macro Document incorporating components of Business Requirement Document and System Requirement Specification incorporating business, functional, non-functional, data and GUI requirements which would in turn serve as the centerpiece of the project.
• Created Use Case Diagrams and Use Case Narratives and incorporated them in Macro Document.
• Created User Stories and led the Planning Poker game to estimate them in Sprint Planning and Backlog Grooming meetings. Also, helped PO to prioritize user stories based on business value.
• Helped product owner in prioritization of Product Backlog Items (PBIs) including the process of breaking down EPICS into user stories using INVEST criteria.
• Facilitated and time-boxed Scrum ceremonies. Helped negotiating commitments and assured parallel understanding of requirements and deliverables amongst all stakeholders in Sprint Planning Meetings.
• Timely assured development team has necessary resources to perform up to potential, tracked and removed impediments.
• Performed extensive prototyping using Mock-Up Screens.
• Handled requirement churn during the project by performing Impact Analysis.
• Checking the feasibility of Change in Requirement and maintaining the triple constraint.
• At the end of each sprint conducted Sprint Retrospective meetings creating the environment for each stakeholder to freely express their opinions and suggest improvement measures.
• Used JIRA for allotting tasks, user story writing, backlog management, issue tracking, user story management and forward and backward requirement traceability.
• Troubleshoot data or transaction issues, and reviewed opportunities to leverage new functionality.
• Acceptance Criteria for User Stories to perform User Acceptance Testing. Designed Test Cases, Test Plans and Test Scenarios to perform Functional Testing, Smoke Testing and Regression Testing and logged down defects and systematically managed them in JIRA 5.2.
• Created Spotfire Visualization and dashboards using Spotfire Professional.
• Analyzed using Spotfire Professional and provided recommendations to the product owner over the use of Business Intelligence (BI) tools.
• Created Structured Query Language (SQL) Queries for Portfolio Drill Downs to pull-out necessary data from the data sources.
• Created environment for self-organization and organized team engagement activities.
• Worked on service oriented architecture (SOA), REST, SOAP, XML, API.
• Created training curriculum and wrote training scripts.

ENVIRONMENT: Waterfall-Scrum Hybrid, MS Visio, Mock-Up Screens, MS Office Suite, Actimize, JIRA 5.2, Moody’s, MS SQL Server, MS Project, HP Identity Management, Spotfire Professional, JAVASCRIPT CSS, AJAX, HTML, IAS 2012, BASEL lll.

Confidential, New York

Business System Analyst/Data Analyst

Responsibilities:

• Interacted with users and stakeholders to Identify business needs, evaluated solutions for business problems.
• Gathered business requirements by participating in JAD sessions, interviewing business users and stakeholders, conducting one to one sessions and consulting existing systems documents.
• Understood problem definition through one to one meetings with Data architect, Enterprise architect and Solution advisors.
• The methodology used for the project was Waterfall and had a deep understanding about the requirement gathering. Provided clear and consistent information about project status both internally, IT team and stakeholders.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams. Understood the AS-IS system, developed the TO- BE system concepts and also prepared the System Process Maps.
• Prepared Business Requirement Document (BRD/HLD) and Drafted Systems Requirement Specification (SRS). Analyzed, modified and validated these documents.
• Developed Conceptual and Logical ER diagrams for the database. Created Data Dictionary for the data models.
• Worked with QA team to design and develop Test Plan and Test Cases.
• Performed User Acceptance Testing (UAT), Functional Testing and Regression Testing.
• Identified Source systems for financial data profiling of the legacy system.
• Integrated various OLTP to the OLAP by using SSIS/SSAS as an ETL tool and used SSRS (Power Pivot and Power View) as reporting tool. Also maintained the Bill Inmon and Ralph Kimball Paradigms.
• Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity to maintain accuracy and effectiveness of data.
• Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries.
• As a Scrum Master, I facilitated all the scrum ceremonies, namely: Sprint Planning meeting, Daily Scrum Meeting, Product backlog refinement meeting, Sprint Review meeting and Sprint Review meeting.
• Was also responsible for resolving impediments during the entire project life. Was also responsible to update the burn down charts. Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Used ETL to map data and assemble data repository and created data marts.
• Used Data Center for Integrating Legacy systems and supporting in decision making.
• Assisted in creating Data Marts with Bus Architecture.
• Assisted in the implementation of Integrated Data Warehouse with individual data marts to address areas of business interest.
• Assisted with SNOW-flake schemas in the Dimensional model architects to providing business rules. Understand the Software Development Life Cycle and experience in system architecture mapping. Designed and developed all Use Cases and UML models using MS Visio.
• Proficient in creating Use Cases, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams.
• Assisted the Project Manager in setting realistic project expectations, in evaluating the impact of changes.
• Developed timelines for project delivery, and managed projects and resources to successful completion.

Environment: SDLC Waterfall, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), MS Project, PL/SQL, SSIS, SSRS, SSAS, HP ALM, JIRA 5.2.

Confidential, Charlotte, North Carolina

Business System Analyst

Responsibilities:

• Facilitated strategic partnership between Business users and IT development teams to create holistic technology for managing granular and high-quality data for regulatory as well as internal reporting to manage Liquidity and Credit risk.
• Elicited business requirements for the project using interviews, document analysis, surveys, site visits, use case scenarios and also used standard template of the organization to develop requirements.
• Conducted Joint Application Development (JAD) sessions with Subject Matter Expert (SME) sessions.
• Maintained and build relationships with stakeholders to ensure their performance management and business analysis needs are understood and supported.
• Gathered requirements pertaining to the supplier information to support the Retail chain system.
• Elicited and documented Functional requirements, business requirements AS-IS and TO-BE business process models.
• Understood the Business process flow (Supplier to Retailer).
• Analyzed and gathered requirements for preparation of Business Requirement Document (BRD), Functional Requirement Document (FRD), system Requirement Specification (SRS), Request for Information, and Request for Offer (RFO) and Statement of Work (SOW) documents.
• Developed clear Business flow and Supply chain flow for better reporting and analysis.
• Responsible for creating UML diagrams (Use Cases, Activity Diagram and Class Diagram) in order to capture the dynamic behavior of Mortgages, LOS and various other application.
• Developed Understanding of Billing centers for Data profiling and Data modeling.
• Developed Use Cases, Activity Diagrams and Sequence Diagrams for a clear understanding of the vision document.
• Designed Test Plans and Test Cases with the help of QA teams.
• Prepared Business process models; used Visio to create process flow diagrams for management and mapping the logical aspects of the process.
• Created Mapping and Modelling process in reference to Data center for reporting.
• Utilized Informatica for Extraction, Transformation and Loading; SAS for report generation of the data to be analyzed from the data warehouses and data marts.
• Prepared Requirement Traceability Matrix and interacted with QA team to ensure quality of software.

Environment: SDLC Waterfall, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), MS Project, MS Visio, HTML, JAVASCRIPT CSS, Informatica, MS SQL server 2008, Base SAS, PROC SQL, Java, spring framework 3.1.

Confidential

Sr. Business Analyst/Scrum Master

Responsibilities:

• Involved in analyzing Business Requirements and developing System Specifications.
• Interacted with the customers and internal stakeholders to gather user requirements and their expectations from the system to create Business Requirement Document (BRD), Functional Requirement Document (FRD) and System Requirement Specification (SRS). Created UML Diagrams using MS Visio.
• As a Scrum Master, I facilitated all the scrum ceremonies, namely: Sprint Planning meeting, Daily Scrum Meeting, Product backlog refinement meeting, Sprint Review meeting and Sprint Review meeting.
• Was also responsible for resolving impediments during the entire project life.
• Was also responsible to update the burn down charts.
• Tracked and reported timely performance against plans and forecast analyzed gaps and recommended corrective measures to improve productivity. Involved in incident reporting and change management procedures.
• Maintained and shared documents using MS SharePoint. Managed test cases and logged defects using HP QC tool.
• Formed a bridge between the Project Manager and different teams with effective presentations.

Environment: Waterfall-Scrum Hybrid, HP QC, MS Project, MS Visio, MS SQL Server, SharePoint, MS Office (MS Excel, MS Word, MS PowerPoint).

Confidential

Business System Analyst

Responsibilities:

• Networked with Subject Matter Experts, Project Managers and Process Analysts to understand the business process gather Business Requirements and identified enhancements in LOS.
• Facilitated various sessions like JAD, JRD, JAM and RAD with various Subject Matter Experts.
• Assisted to author functional requirements and business requirement documents and provided guidance to QA team.
• Used HPQC for allotting task and issue tracking, user story management and requirement traceability.
• Responsible for meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure the system meets all the goals of the project.
• Produced visual models for the application using UML MS Visio to create Use Cases, Sequence Diagrams.
• Collaborated and negotiated with stakeholders in defining project scope boundaries.

Environment: Waterfall, MS Visio, MS Office Suite, MS Access, SQL version, Informatica, IBM Cognos, Outlook, MS Office.

Confidential

Business System Analyst/JAVA developer

Responsibilities:

• Facilitated meeting and arranged JAD sessions with business users for requirement gathering.
• Served as a liaison between business team and the project team by assisting the business in identifying, understanding and documenting their business needs.
• Assisted in gathering requirements for the GUI (Graphical User Interface) Screens and designing.
• Created use cases and designed use case diagrams class, sequence diagrams and activity diagrams.
• Responsible for preparing Software Requirement Specifications (SRS) and Functional Requirement Specifications. Conducted Project related Presentations.

Environment: Waterfall, MS Office, MS EXCEL, MS ACCESS, Load runner, windows 2000, UML and Bugzillla.