PROFESSIONAL SUMMARY:

• Highly motivated and result oriented professional with 8+ years of experience as a Business Analyst/ Senior Business Systems Analyst and Scrum Master in various organizations related to Investment Banking, Mortgage Services, Equity and Debt Capital Markets. Got an opportunity to work with and learn from different people in my career.
• Experience in implementation of project life cycle in various phases and stages of Software Development Life Cycle(SDLC) in Waterfall, Agile (Scrum) and Hybrid(Waterfall - Scrum) methodologies. Good knowledge about other methodologies like Kanban, Rational Unified Process (RUP), Rapid Application Development (RAD) and Spiral methodology.
• Proficient in communicating with the business users, product owners and communicating the requirements to the technical team to bridge the gap between them. Acted as skilled liaison between the technical team, management and the business users. Successful in conflict resolution and delivering high business value.
• Experience in gathering requirements and documenting them such as Business Requirement Document (BRD), Functional Specification Document (FSD), Software Requirement Specification (SRS) and Requirement Traceability Matrix (RTM). Good Experience in using various elicitation techniques such as JAD sessions, Brainstorming, Focus Groups, Prototypes, Survey/Questionnaire and One-One Interviews with different stake holders and product owner.
• Experience in conducting Cost-Benefit Analysis, Risk Analysis, Impact Analysis, SWOT analysis and GAP analysis.
• Proficient in creating prototypes, mockups and wireframes using tools like Balsamiq mockups, MS Visio.
• Good knowledge about the Web Services, SOA, XML, HTML, SOAP, WSDL, REST, JSON while working with front end.
• Experience in creating UML diagrams such as Activity diagrams, Sequence diagrams, use case diagrams in MS Visio.
• Understanding of Test First Development (TFD), Test Driven Development (TDD) and Acceptance Test Driven Development (ATDD) which are used in test-centric development.
• Participated in UAT testing, Smoke testing, Sanity Testing, Unit Testing, Regression Testing and Integration Testing. Collaborated with QA team in using tools like HP Quality Control (HP QC) and HP Application Lifecycle Management (HP ALM) for creating test cases, test plans and test scenarios.
• Experience in assisting back-end teams in Data Mapping, Data Profiling, Data Analysis and Data Modeling. Created Data Mapping Documents, supported in designing Conceptual and Logical Data Models.
• Good knowledge about Data Marts, Operational Data Stores (ODS), On-Line Transactional Processing (OLTP), On-Line Analytical Processing (OLAP), Slicing, Dicing, Roll-up, Drill-down, ROLAP and MOLAP. Experience in using ER Modeling for OLTP processing and Dimensional Modeling using Star Schema and Snowflake Schema for OLAP processing.
• Experience in using SQL queries, performing ETL process in Data Migration from databases to Data Warehouse.
• Experience in building custom reports for analysis purposes using Business Intelligence(BI) tools like Tableau, MS Power BI, IBM Cognos. Proficient in MS Power Point, MS Excel and MS Word. Experience in ETL Informatica tool.
• Used tools such as Atlassian JIRA and Rally for Project Management, Bug Tracking, creating other issues in JIRA Agile like user stories and epics, JIRA Kanban and managing workflow of various issues. Good understanding of other project management tools like IBM RTC (Rational Team Concert) and HPALM.
• Assisted the Product Owner in creating Product Backlog and Spring Backlog using prioritization techniques such as MoSCoW, Kano and Business value methods. Helped the team in writing User Stories, estimating User Stories using various estimation techniques such as Agile Poker and T-Shirt sizing by conducting Scrum Workshops for new teams.
• Experience in facilitating Scrum ceremonies like Backlog Grooming Sessions, Sprint Planning Meeting, Sprint Review Meeting, Sprint Retrospective Meeting, Daily Scrum Meeting and time-boxing the ceremonies.
• Experience in managing changes throughout the SDLC process like Requirement Churn/Change Management.
• Got an opportunity to work with and learn from different people and different teams. Successful in handling cross-functional teams, conflict resolution and acted as servant leader to the Scrum team.
• Good understanding of Equities, Bonds, OTC Derivatives, Mortgages, Mortgage-backed securities, Mutual Funds, Credit Risk Management, Portfolio Management, Capital Adequacy, Stress Testing, Market Liquidity.
• Good knowledge about BCBS, DFAST, CCAR, FINRA, TILA, RESPA, SEC, ECOA and other regulations.
• Experience and knowledge about different Loan Origination Systems like Encompass, Empower and in-house LOS.
• Knowledge about possible risks in the banking system such as Credit risk, Market risk, Liquidity risk, Systemic risk and Operational risk and how to manage these different types of risks.
• Experience in Automated Trading System that uses rule based Algorithms in executing the trade orders.

TECHNICAL SKILLS:

SDLC Methodologies: Traditional Waterfall, Agile Scrum, Hybrid (Waterfall-Agile)

Management Tools: Rally, JIRA, MS project

Languages: SQL, HTML, XML

Business Modelling Tools: M.S Visio, Mockup Screens, Wireframes, Balsamiq

Data Warehousing: Data Marts, OLTP, OLAP, Multidimensional Analysis, ETL, Slicing/Dicing, Drilldown/ Roll Up, ROLAP, MOLAP, Data Mapping, Data Profiling, ER Diagram, Dimensional Model

Databases: MYSQL, Oracle, Microsoft SQL server

Data Warehouse Tools: Tableau, IBM Cognos, SSRS, Informatica ETL, Power BI

Testing Tools: HPQC, HP ALM

Business Skills: Business Rules Management System, Change Management, Impact Analysis, JAD sessions, SWOT analysis, Project Planning, Business Process Modelling, Cost-Benefit Analysis, Business Process Reengineering

Operating Systems: Windows XP, Vista, 7,8,10, Mac OS, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Danbury, CT

Business Systems Analyst/Scrum Master

Responsibilities:

• Analyzed the business case for the project to understand the consumer requirements
• Conducted face-to-face and conference meetings with the team and the business stakeholders to review business requirements. Gathered requirements using elicitation techniques such as personal interviews and Brainstorming.
• Conducted thorough analysis of the Business Requirements and created design specification to accomplish and achieve business needs. Documented requirements in Business Requirements Document (BRD).
• Created the user stories on the JIRA board and wrote the Acceptance Criteria for the stories based on the wireframes and mockups.
• Clarified the requirements for the development team and conducted meetings with other teams if there are external dependencies and made sure the work is completed.
• Assisted in designing the new User Interface that supports new mobiles in the market with different Operating Systems and of different sizes.
• Helped the UI architect in designing the mockups and wireframes for the new application based on the inputs from the Sales and Support teams.
• Participated in API integration and testing using the Postman tool.
• Facilitated all the Scrum meetings and ensure all the artifacts are visible to the scrum development team and the stake holders. Ensured time-boxing of the events and solved the impediments that the team is facing.
• Used JIRA for project management including iteration planning and release planning.
• Assisted the Product Owner in reprioritizing the Product Backlog Items (PBIs) and maximize ROI.
• Conducted Scrum Workshops to get better idea about user story writing, story estimation and other scrum principles.
• Worked with QA on UAT testing, test plans, test cases and worked with the Product Owner for UAT test execution.
• Ensured that the modifications suggested by the users were incorporated into the application successfully.

Environment: Scrum, Wireframes, Mockups, Axure, MS Office, MS Visio, Tableau, Rally, JIRA, Web Services, REST, XML, JSON, JavaScript.

Confidential, Pittsburgh, Pennsylvania

Sr. Business Systems Analyst/Scrum Master

Responsibilities:

• Helped the team in defining the business rules and the algorithms in the Business Rules Engine to price the loan application and perform automated underwriting by verifying all the information about the consumer.
• Helped in deploying GalssFish 4.1 application server on JEE 7platform and technical integration of Imixs Workflow engine with the application server which acts as Business Process Management System.
• Participated in defining the REST architecture to communicate with third party applications such as Credit API, FHA Electronic Appraisal Delivery and other APIs using HTTP methods and CRUD methods. The system includes Collateral Management, Compliance Requirements and Credit Checking.
• Used tools like Altova XML Spy as XML editors during designing the web services.
• Documented the Regulatory requirements such as TILA, RESPA, BCBS, ECOA and many other regulations and are converted in the form of business rules to meet these standards for processing the Loan Applications.
• Assisted in Business Process Reengineering for the mortgages LoB and helped in automating certain processes where required and reducing the cost of production and increasing the Return on Investment for the organization.
• Closely worked with Project Manager to identify core business processes and workflows for Business Process Improvement. Also assisted in Project Management decisions and new approaches towards the processes.
• Facilitated elicitation techniques to gather requirements such as JAD sessions and Personal Interviews.
• Assisted in analyzing the existing system (as-is) and problems with them and designed a plan to overcome the existing problems with the new systems by performing Gap Analysis.
• Conducted Risk analysis, Cost-Benefit analysis in implementing the new Loan Origination System.
• Documented functional and technical requirements in the form of Business Requirements Document (BRD) and System Requirements Specifications (SRS) in coordination with all the business stakeholders, Product Owner and Project Development team.
• Participated at different stages of the Software Development Life Cycle (SDLC).
• As a Scrum Master, implemented Scrum Practices while handling teams and facilitated Scrum Ceremonies like Daily Scrum, Sprint Planning Meeting, Sprint Review Meeting and Sprint Retrospective meeting.
• Helped the Product Owner in prioritizing Product Backlog Items (PBIs), helped the team in breaking PBIs into user stories using INVEST criteria and selecting the user stories for the current Sprint and further breaking them into tasks.
• Helped the team in solving impediments that are discussed in Daily Standup Meeting and deliver PSPIs every sprint.
• Used JIRA to track team’s performance and tracked team velocity using Sprint Burn Down charts and help them achieve optimum velocity.
• Created the Definition of Done for the entire Scrum process and Acceptance Criteria for specific user stories.
• Facilitated and communicated meetings with the Product Owner, whenever there is any requirement churn and whenever the team feels re-prioritizing or changing the user stories for the current sprint.
• Prepared UML diagrams like Activity diagrams, Sequence diagrams using MS Visio to analyze the structure of the architectural design, behavior and the interaction within the system design.
• Designed the Test Cases, Test Scenarios, Test Strategies and Test Plans for all processing using HPQC, hence developed the test scripts considering different testing such as Black Box Testing, Regression Testing, Smoke Testing and User Acceptance Testing.

Environment: Waterfall-Scrum Hybrid Methodology, MS Visio, Bootstrap Framework v3.3.4 for UI, XML, JSON, AJAX, MS Office, GlassFish 4.1 application server on JEE7 platform, Imixs Workflow Engine, DROOLS Business Rules Engine, JIRA, Kanban boards, HTML5, CSS3, Java Script, Oracle 11gR2, JDBC.

Confidential, Baltimore, Maryland

Business Systems Analyst/Scrum Master

Responsibilities:

• Studied the objective and scope of the project and reviewed existing documents as well as worked closely with SME’s of different divisions to gain strong understanding of existing system and to analyze to-be model that is to be implemented along with business rules, functional requirements and process design.
• Conducted extensive GAP analysis and process flows. This helped the team to plan and bridge the gap.
• Developed a new Business Requirement Document (BRD) and System Requirement Specification (SRS) and made changes to the old documents where the requirements where documented incorrectly.
• Used business analysis tools like Tableau on the organization Data Warehouse, to get the pattern of the consumers’ investments in multiple products before designing the new User Interface.
• Participated in designing the new system architecture including the Risk Management System at the client-end as well as at the middle layer in the Trade Order Management System. There is a FIX engine integrated into the middleware, that uses FIX protocol for communicating the trade information.
• Participated in designing new trading algorithms and custom algorithms adding to the existing algorithms.
• Knowledge about Post Trading functionalities, Trade Order Management System and Trade Lifecycle.
• Developed risk check parameters in the Risk Management System such as limiting the value of the order or the quantity of the order that leads to erroneous trade orders at the client side and also developed risk check parameters for trading algorithms at the server side.
• Integrated the new regulations related to SEC and FINRA into the system to meet the regulatory standards.
• Conducted Scrum Workshops for the team to be familiar with Scrum Methodology to ensure that development teams are practicing Agile Principles in becoming self-organized to optimize productivity.
• Created User Stories and conducted Planning Poker to estimate them in Sprint Planning and Backlog Grooming meetings. Also, helped PO to prioritize user stories based on business value.
• With good problem solving skills, successfully handled the internal team conflicts and enhanced team collaboration.
• Assured the development team has all the resources at any given time and solve their impediments. Also, helped the development team members to insert spikes where they feel necessary to understand the existing system problems.
• Used JIRA for allotting tasks, user story writing, backlog management, issue tracking and bug tracking.
• Define 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.
• Handled requirement churn during the project by performing Impact Analysis.
• Tracked team’s velocity and progress during a Sprint using Sprint burn down chart and Release burn down chart.

Environment: Hybrid Methodology, MS Visio, Mockup-Screens, MS Office, JEE platform, JIRA5.2, Kanban boards, HTML5, CSS3, Java Script, FIX Engine, FIX protocol, Risk Management System, Order Management System, Tableau, Automated Trading Systems, Trading Algorithms.

Confidential, Fort Worth, Texas

Business Systems Analyst

Responsibilities:

• Analyzed the business case for the project to understand the organizational needs. Captured and defined the vision and scope of the project in the project planning.
• Responsible for conducting JAD sessions and interviews for eliciting, analyzing requirements for various ad-hoc reports and creating documents for analyzing and visualization of data collected from disparate source systems.
• Prepared documents like Business Requirement Document (BRD) and System Requirement Specification (SRS).
• Created sample of data prototypes for approval from sponsors and business owners on how the data can be migrated.
• Created Data Flow Diagrams, Sequence Diagrams using UML methodologies for easy understanding.
• Worked with Data Analyst in Data Governance, Data Profiling, Data Mapping, Data Cleansing and Data Analysis before loading the data into the new database using tools like Informatica Data Quality. Participated in deciding the methods for extracting, transforming and loading the data into target database using Informatica PowerCenter.
• Created the conceptual and the logical entity relationship diagrams and the data dictionary.
• Reviewed the data mapping and the transformation business logic being applied to the data to check if the requirements are being met by preparing the Data Mapping Document.
• Used Dimension Modeling in designing the data warehouse like Star Schema to define the relation between the fact tables and dimension tables.
• Used Tableau for data reporting, studying the trends, data patterns and for data forecasting
• Tableau dashboards are used to view different types of reports to analyze the business by geographic locations. It is because of the Fast Data Engine of Tableau that made us extract the data from the data warehouse easily.
• Involved in and supported team with analytical skills in all phases of Software Development Life Cycle (SDLC).
• Used HP QC to keep track of the issues that are logged and in progress along with the person responsible. It helps to generate reports to see the status of the issues.
• Led the User Acceptance Testing (UAT) efforts, and opened/closed defects on HP QC.
• Drafted test strategy, test cases and exit strategy by working closely with the quality analyst team. Used SQL queries to perform data analysis, data validation and data manipulation.

Environment: Waterfall Methodology, MS Visio, Prototypes, MS Office, Data Migration, MySQL database, Oracle 10g Database, Informatica Power Center, Informatica Data Quality, HP QC, Tableau.

Confidential

Business Analyst

Responsibilities:

• Involved in reviewing and evaluating teams Service Level Agreement (SLA) on weekly and monthly basis.
• Interacted with stakeholders and elicited requirements by conducting user interviews and JAD Sessions.
• Analyzed and documented requirements gathered and authored Business Requirement Document (BRD), System Requirement Specification (SRS) for application development.
• Worked with development environment and testing environment for better understanding of the functionalities
• Created and use case documents and uploaded the documents in Knowledge Link.
• Analyzed business requirements and segregated them into high level and low level Use Cases, activity diagrams using MS Visio according to UML.
• Involved designing the new UI interface where the KYC details are mandated by the consumer.
• Used AML and KYC regulations described by the Reserve Bank of India(RBI) for safety banking and fraud management.
• Involved in UAT, test plans, documentation of test reports, etc.
• Involved in developing SQL Queries and Procedures that are used to track consumer history and transaction.
• Provided updates to the Project Manager regularly on the status and progress of the tasks.
• Interacted with the upper level management on status reporting, schedule control, client/project team coordination.
• Ensured requirements compliance and testing using Requirement Traceability Matrix (RTM).

Environment: MS Visio, MS Office, MS Excel, MS Power Point, SQL Server, SOAP, WSDL, REST, XML, HTML, Java Script, CSS, Waterfall method.

Confidential

Business Analyst

Responsibilities:

• Involved in all phases of SDLC, including requirement gathering, analysis, design, development, and implementation.
• Assisted the project manager/ lead in defining the vision, project plan, charter, scope and timelines.
• Facilitated JAD sessions to embrace a problem’s dimensions, possible causes, to propose alternative solutions.
• Performed requirement analysis by gathering both functional and non-functional requirements based on interaction with the process owners & SME's.
• Prepared requirement documents like Business Requirement Document(BRD).
• Managed test cases and logged defects using HP QC tool.
• Formed a bridge between the Project Manager and different teams with effective presentations.
• Planned and organized team engagement activities to encourage self-organization among the team.
• Handle customer complaints and questions regarding problems with order
• Created mock-ups with the help of MS-Visio to understand the UI and UX requirements
• Participated in developing test cases, test plans and conducted User Acceptance Tests.

Environment: MS Visio, HP QC, MS Office, MS Excel, Waterfall methodology, Mockups, CSS, Java script

Confidential

Jr. SQL Developer

Responsibilities:

• Participated in creating Database Objects such as tables, views, stored procedures, indexes and triggers.
• Designed database tables to store the data coming from different applications and determining what data is returned or received from the applications.
• Performed Data Modeling and created Entity-Relationship diagrams for the new databases.
• Defined primary keys and foreign keys for tables while designing and used constraints to maintain referential integrity, domain integrity and column integrity. Also, normalization of tables in the database.
• Writing extensive SQL queries and determining what data must be sent to various applications.
• Optimizing existing queries to enhance the performance of the database.
• Worked closely with the Database Administrator in creating the database and maintaining the database components and participated in designing how the data should be organized and how data should be displayed.
• Generated reports like drill down reports, tabular reports using SQL Server Reporting Services (SSRS).

Environment: Waterfall, SQL Server Database, MS Office, MS Excel, MS Power Point, SQL Server Reporting Services