SUMMARY:

• A Competent IT Professional with more than 7 years of diverse experience in domains like Investment Banking, Mortgage and Regulatory Reporting as a Business System Analyst, Scrum Master, Business Analyst and Data Analyst with strong knowledge and experience working with different SDLC methodologies such as Agile Scrum, Waterfall, RUP and Kanban etc.
• Solid understanding of Software Development Life Cycle (SDLC) processes including requirements gathering, analysis and design, development tools and technologies, release and version control, testing.
• Expert in gathering and documenting business BRD and functional requirements FRD from business users, SMEs, stakeholders using various requirement gathering techniques such as JAD Sessions, Interviews, focus group etc.
• Expertise intranslating business requirementsanduser expectationsinto detailed specifications employing Business Process Modelling (BPM) techniques such as UML (class, use case, activity and sequence diagrams) and BPMN 2.0 as a business analysis methodology for application functionality designs using visio, balsamic and rational rose.
• Agile Practitioner and Certified Scrum Master, proficiency in Scrum framework and facilitated ceremonies like Sprint Planning, Daily Scrum, Sprint Review, Requirement Grooming, and Sprint Retrospective.
• Assisted Project Managers in preparing Project Management Plans, Status Reports and Project Charter in MS Project and managing deliverables using Critical Path Analysis and Gantt Charts.
• Deep understanding of regulatory and compliance issues complements, leading technology and innovative solutions to help our clients achieve their business goals.
• Extensive knowledge of financials including amortization, debt securities, equities and derivatives such as options, futures and currency swaps.
• Involved in Business Process Reengineering (BPR) by conducting Impact Analysis, Cost Benefit Analysis, Root Cause Analysis, SWOT analysis, GAP analysis to understand As - Is and To-Be business process.
• Expertise on identifying various data sources, performing data mapping, data cleansing, data aggregation, data modelling techniques like Entity Relationship modelling using Erwin.
• Data validation in data integration, migration, warehousing projects using Informatica.
• Experience and good understanding of using DDL and DML languages using SQL Server 2012 to perform CRUD operations on database including joins, order by, group by, procedures and functions.
• Created User Stories, Epics, maintained Sprint Burn-down Chart, Sprint Burn-up Chart, Product Release Chart, White Board in JIRA to keep track of the team’s progress and the team’s velocity for better estimation of the sprints.
• Expertise in preparing Test Plan, Test Scenarios, Test Documents, Test Scripts, RTM and defect logs using HP QC/ALM; facilitating User Acceptance Testing (UAT), regression testing and system integration testing (SIT).
• Excellent communication, analytical, problem solving, and management skills with an eagerness to learn new technologies and team building capability.

TECHNICAL SKILLS

Documentation Tool: Microsoft Word, Microsoft Excel, MS Project

Collaboration Tool: Microsoft SharePoint, Confluence

ETL Tools: Informatica

Designing Tool: MS Visio, Balsamic, Mock- up screens, Rational Rose, Erwin, BPMN 2.0

Requirement Management: JIRA, Rally, HP ALM (QC)

Databases: MySQL, Oracle, MS Access, MS SQL Server 2012/2014/2016

Reporting Tools: Tableau

Languages: C/C++, JavaScript, HTML5/CSS3, AngularJS, JQuery, XML, PL/SQL, TSQL

Operating Systems: Windows, Mac OS, Linux

PROFESSIONAL EXPERIENCE

Confidential, Auburn Hills, MI

Business System Analyst/Scrum Master

Responsibilities:

• Defined and developed business functional requirements and participate in technical walk-through meetings to develop the functional design for the implementation.
• Facilitated requirement gathering sessions with the business team to collect the business reporting standards, security and service level requirements, and documented them using RequisitePro.
• Documented Requirement Traceability Matrix in RequisitePro for traceability of requirements through test cases.
• Prepared Business Requirement Document (BRD), Functional Requirement Specification (FRS) document and Data Dictionary containing functional definitions and process details.
• Conducted sessions with business users and technical units and (JAD) sessions with IT Group.
• Enforced Kanban principles as a scrum master that resulted in reduction of Cycle time by 20% thus increasing team's throughput in less than 8 weeks.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created pivot tables and charts using worksheet data and external resources, Imported and exported data from text files, saved queries, or databases; used automatic outlining, inserted subtotals, created advanced filters, and used database functions.
• Performed Data Modeling including Physical & Logical data modeling using Erwin 3.5 and 4.1.
• Created Requirement Traceability matrix (RTM) using HP QC tool.
• Collaborated in various types of testing like Functional (Black-Box) testing, End to End Testing, Regression Testing, and User Acceptance Testing (UAT) smoke testing, functionality testing, Sandbox testing accompanied with expertise in developing Test cases, Test plans and Test procedures in manual and automated test environments.
• Analyzed, interpreted, updated & maintained various asset class i.e. Equity, fixed income, Funds, Derivatives, Money markets, Corporate Action events, etc. and effectively communicating with internal and external clients to deliver functional requirements like GUI, screens and interface designs.
• Worked extensively through Agile development methodology by dividing the application into iterations
• Facilitating Scrum Daily Standup, Product Backlog, Backlog Grooming, Sprint Planning, Retrospectiveagileceremonies
• Deployed solution forCCAR, Dodd-Frank Regulatory Reporting FR Y-14A/Q/M Monthly, Quarterly, Annual, and others required for banks for compliance reporting to various regulatory agencies.
• Conducted GAP analysis byunderstanding the AS-IS system and the TO-BE system requirements by having discussions with the SME's.
• Established process and business process workflows, flow diagram, process flows using BPMN 2.0 technique.
• Assisted the Project manager to construct a Project plan that included Project schedules, Milestone tracking, and meeting minutes using MS Project.
• Collaborated in the implementation of a risk management framework to ensure corporate functions are following the Federal Reserve's Comprehensive Capital Analysis Review (CCAR) regulatory requirements.
• Good knowledge of traditional and alternative asset class investment data, including but not limited to equity, fixed income, private equity, real estate, derivatives, mutual funds, ETFs, global assets, foreign exchange, etc.
• Developed Test Plan and Test cases based on the Use cases and Functional specifications and also performed manual testing of the functionality of the application by inserting varying data.
• Create complex JIRA workflows including project workflows, field configurations, screen schemes, permission schemes and notification schemes.
• Deep understanding and experience in trade life cycle.

Environment: UML, UAT, Agile/Scrum, SQL, Microsoft Office (Project, Publisher, Excel, Word, PowerPoint and Visio), MS SQL Server 2008.

Confidential, Cincinnati OH.

Business Analyst/Scrum Master

Responsibility:

• Analyzed requirements, developed workflow charts and diagrams, assessed legacy system capabilities to develop system specifications documents
• Implemented business rules, logic and processes in Software development life cycle (SDLC)
• Served as a liaison between mortgage specialists and the project team.
• Responsible for gathering user requirements and specifications for designing a mortgage based loan system using and documenting the same.
• Experience in using Jira to create epics, user stories, to track production issues, to handle change request.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x / 8.x) reports.
• Created Requirement Traceability Matrix (RTM), for tracing the requirement versus its respective test cases.
• Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop.
• Created responsive web pages for mobile application using HTML5/CSS3.
• Supported Mortgage Servicing by ensuring requirements is delivered in a timely manner.
• Managed all development and support efforts for the Data Integration/Data Warehouse team.
• Used requisite pro to document requirements, associated change requests with requirements and connected requirements with use cases. Used BPMN 2.0 to represent the business processes.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration using Informatica.
• Created physical and logical data model using data modelling tool like ER Studio.
• Worked extensively through Agile development methodology by dividing the application into iterations
• Facilitating Scrum Daily Standup, Product Backlog, Backlog Grooming, Sprint Planning, Retrospectiveagileceremonies.
• Conducted GAP analysis byunderstanding the AS-IS system and the TO-BE system requirements by having discussions with the SME's.
• Validated the various business processes with a committee of Subject Matter Experts (SME's) like Mortgage Servicers, Underwriters, Credit Analyst etc, to ensure the rules and guidelines have been met.
• Responsible for Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2008 environment.
• Worked on agile scrum based methods forBDD.
• Wrote Application Functional Design Document (AFD) for various applications across different platforms to be used by developers for coding
• Provided analytical support and performed User Acceptance Testing related to the Dodd-Frank project.
• DocumentedRequirement Traceability Matrix inRequisite Profor traceability of requirements through test cases.
• Documented allregulatoryrequired documentation and gates to ensure project meets the financial industry standards.
• Reviews and analyzes all relevant KYC documentation received from applicants and members, and performs required background checks andregulatorysearches to complete a KYC file for Onboarding applicants and existing participants.
• Developed Test Plan and Test cases based on the Use cases and Functional specifications and also performed manual testing of the functionality of the application by inserting varying data.
• In depth knowledge of RUP's Iterative Software Development Life Cycle, Waterfall andAgile Methodology.

Environment: UML, UAT, Agile/Scrum, SQL, Microsoft Office (Project, Publisher, Excel, Word, PowerPoint and Visio), MS SQL Server 2008

Confidential, Mount Laurel, NJ

Business Analyst

Responsibilities:

• DerivedFunctional Requirement Specifications(FRS) based on User Requirement Specification URS. Understand and articulate business requirements from user interviews and then convert requirements into technical specification.
• Documented the use cases and prepared the use case, activity, logical, component and deployment diagrams usingMS VisioandRational Rosefor a clear understanding of the requirements by the development team.
• Expertise in creatingBDDdriven test frame work.
• ConductedRisk Analysisto identify the risks associated with developing the new system, and formulated aMitigation Planto eliminate or reduce risks of high severity and major financial effects.
• Use business process modeling and analysis (BPMA) tools, as well as methods and standards, such as Business Process Modeling Notation (BPMN 2.0), to fully obtain information about what capabilities the business needs and leverage more graphical techniques for facilitating communications
• Performed data integration using various tools like SSIS and Informatica.
• Created bi-monthlyStatus Reportsusing MS Excel to keep the Business Lead informed about developments.
• Used JIRA for maintaining and tracking issues, bugs, user story management, work flow management and creating Requirement Traceability Matrix (RTM) for transparent requirements traceability.
• ConductedDefect Validationusing Quality Center to screen the illegitimate defects raised by the QA and UAT teams before hitting Development.

Environment:Oracle, UML, SQL, MS-Office, MS Excel, MS Project, MS Visio, Quality Center, BPMN 2.0

Confidential

Responsibilities:

• Developed process maps using Visio and subsequently streamlined the month end process which reduced the month end processing time by 20%.
• Updated project plan using Microsoft Project based on the new enhancements to the reports.
• Designed and implemented dashboards using Tableau the authored the same to web.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart..
• Converted the gathered requirements into analysis models and prototypes using HP ALM.
• Obtained, developed and analyzed financial reports for profit gains/losses and rate calculations. Used the forecasting capability to estimate future value of key performance indicators.
• Inserted dynamic values into custom SQL queries for flexible control of data for analysis.
• Followed the change management procedures and negotiated with stakeholders to prioritize the changes of developed reports.
• Created Requirement Traceability Matrix (RTM) to make sure the requirements are being met.
• Supported the creation of the deployment plan, implementation plan and test and go-live phases to ensure that all projects were implemented on time and within budget.
• Conducted UAT and Coordinated with the QA Team for the sign-off process before deployment.
• Involved in creating logical and physical models using Erwin.
• Migrated data from heterogeneous data sources and legacy system to centralized SQL Server databases, which involved cleansing, data mapping and data conversion.
• Responsible for the end-to-end design and testing of assigned reports.
• Mapping Operational Repository to Business Repository elements and incorporating the build rules.
• Based on the user selection and finally storing the output as a flat file for further processing for the next module.
• Extensively used SQL & PL/SQL in reports.
• Identifying and automating repetitive tasks or processes to save time.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.

Environment: Waterfall, Erwin, UML, Payment Processing, SQL Server, Rational Requisite Pro, Rational Rose, MS Office, MS Project, SharePoint 2007, HTML, CSS.