SUMMARY:

• Result driven Information Technology professional with over 10 years of experience as a Business Analyst, Business Systems Analyst and Scrum Master in the Financial and Banking industries
• Experience working in Waterfall Methodology and Agile Methodologies like Scrum, Kanban, Agile - Waterfall-Scrum (Hybrid) and RUP environment. Sound understanding of SAFe Framework
• Good understanding of Financial concepts like Financial Budgeting, Portfolio Management, Wealth Management, Capital Markets, Reconciliation, Settlements, Trade Flow Management
• Sound expertise and first-hand experience in Comprehensive Capital Analysis and Review - CCAR framework and Payment Security Industry (PCI) / Data Security Standards (DSS) Compliance
• Thorough understanding and extensive experience in SDLC governance and the related documentation
• Experience in networking with individuals at various levels and facilitating elicitation sessions for Surveys, Interviews, Interface Analysis including JAD, Focus Groups and Brainstorming. Successfully gathered SMART pre-requisites from various stakeholders and users and converted the needs of business users and stakeholders into Functional Requirements Specifications
• Experience in conducting As-Is and To-Be Analysis and possess strong knowledge in carrying out processes for Risk Analysis, SWOT analysis, Change Management and perform Feasibility Study
• Assisted Project Managers in preparing Project Plans, Project Schedules, establishing Milestones, Work Breakdown Structure (WBS) and Conflict Management with Team Members
• Proficient in creating Request for Proposal (RFP), Business Requirement Document (BRD), Functional Requirement Document (FRD), System Requirement Specification (SRS), Requirement Traceability Matrix (RTM)
• Proficient in creating UML diagrams like Class Diagrams, Activity Diagrams, Use case Diagrams and Sequence Diagrams in addition to creating MockUps and Wireframes using tools such as MS Visio, MockUp Screens, Lucid Charts and Balsamiq MockUp to communicate requirements to Development and UI teams
• Extensive exposure in using various Prioritization techniques (100-dollar Test, Priority Poker and MoSCoW) Estimation techniques (Planning Poker, T-Shirt Sizing and Relative Mass Valuation) and Retrospective techniques (1-2-4 ALL, Silent Writing, ORID and Star Fish)
• Maintained Sprint Burn-down 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 deliverables. Proficient in writing User Stories and Acceptance Criteria and handling Requirement Churn. Assisted Product Owner in slicing Features/Epics into User Stories by performing Horizontal and Vertical slicing
• Good understanding of Test Driven Development (TDD), Acceptance Test Driven Development (ATDD), Behavior Driven Development (BDD), Continuous Integration, Pair Programming development practices
• Experienced in performing Data Mapping using Informatica PowerCenter from source to target storage system, validating connection objects and target writing path of the warehouse with the help of proper naming conventions
• Extensively used SQL queries using joins, unions, outer joins, group by, order by and aggregate functions to extract data from different data sources and to perform DDL (Data defining language) operations to create, read, update and delete (CRUD) the data in the database for data manipulation and data analysis
• Experience in creating SQL reports, graphical interactive UI and dashboards using QlikSense, Power BI and Tableau from multiple data sources like SQL, Oracle and flat files like CSV, excel etc.
• Strong knowledge on SOA, N-tier Architecture, SOAP, RESTful Web Services, API Web Services testing using SoapUI, API testing using Postman and API documentation using JSON and XML
• Strong understanding on concepts like AJAX, Single Page Application (SPA), JSON documentation, XML schema definition (XSD), Extensible Stylesheet Language Transformations (XSLT), Web Service Description Language (WSDL), Universal Description, Discovery and Integration (UDDI)
• First-hand working experience in data warehouse related concepts like identifying Dimensions and Attributes creating Dimensional schemas like Star schema, Snowflake schema, Fact tables and Lookup tables. Strong understanding of OLTP/OLAP, Data Marts, Data Mapping, Data Profiling and ETL. Developed Conceptual Data Model and Logical Data Model, Data Normalization and identified key elements, key attributes, their relationships, table structures and aided in database design
• Experience in System Testing, Manual Regression Testing and Pre-Alpha and Beta Testing. Proficient in developing and writing Test Plans, Test Cases, Test Strategies and Test Scripts
• Worked with tools like HPQC, Cucumber, LoadRunner for identifying, analyzing and documenting defects

TECHNICAL SKILLS:

Operating Systems: Windows XP / Vista / 7 Macintosh / iOS

Methodologies: Waterfall, Scrum, Waterfall-Scrum Hybrid, Scrumban, Kanban, SAFe

Modelling Tools: MS Visio, Mockup Screens, Lucid chart, Balsamiq Mockup

Business Skills: Process modeling, Change Management, GAP Analysis, Impact Analysis, SWOT Analysis, Project Scheduling

Project Management Tools: JIRA, MS SharePoint Server, HP ALM, Confluence

Testing Tools: HP QC, Load Runner, Cucumber, Soap UI, POSTMAN, Selenium Framework

Language / Web Services: HTML, XML, MySQL, JSON

Database / ETL: SQL server, Informatica, Talend BI, SSIS

Data Warehousing / Reporting: Data Modeling, OLTP, OLAP, Tableau, Qlikview, IBM Cognos

Scrum Tools: JIRA, Version one, Rally, TFS, Hudson, Jenkins

Finance: Capital Market, Portfolio Management, Wealth Management, Trade Flow Management, Trade Lifecycle

Banking: Bill Payment Systems, Credit Risk Management Systems, Mobile Banking, Corporate Banking, Retail Banking

Risk and Compliance: CCAR, PCIDSS, Operations Risk, Credit Risk, Regulation E, FR Y 14 M/Q/A, AML - Anti-Money Laundering

PROFESSIONAL EXPERIENCE:

Confidential, Warren, NJ

Business Analyst / Scrum Master

Responsibilities:

• Knowledge in identifying brokers and dealers registered with SEC and FINRA and the various types of brokerage registration regulations including Foreign Broker-Dealer Exemption (Rule 15a-6)
• Knowledge of requirements on Brokers and Dealers of Government and Municipal Securities
• Prepared GAP analysis and Risk analysis to understand the new business model and process improvement inclusions, with focus on the compliance and Regulations and information security
• Performed Document Analysis to understand the As-Is environment and identified the Functional Decomposition, System boundary and Automation boundary including the Database requirements
• Compiled the information in the form of Business Requirement Document (BRD), Functional Requirement Specifications (FRS) and System Requirement Specification (SRS) and Visual Diagrams like UML Diagrams, ER Diagrams using MS Visio for developers to comprehend and follow
• Used Requirement Traceability Matrix (RTM) for mapping requirements to test cases using JIRA
• Utilized MySQL to probe data dependency issues and inconsistencies to safeguard against SQL Injection. Wrote basic SQL queries including inner join, left join, right join, full join, group by etc. for retrieving data from different database systems using Microsoft SQL Server
• Integrated the various OLTP to the OLAP by using Oracle Warehouse Builder as an ETL tool and created Data Mapping Documents for the source and target systems for integration
• Involved in API documentation and testing, provided guidance and review for Service Oriented Architecture (SOA) implementation, its deployment and management
• Documented APIs, integrated different APIs based on XML / JSON data representation using SOAP / REST Services and also assisted the team in executing API testing using Postman
• Assisted the team in appropriately slicing and writing User Stories and the Acceptance Criteria to represent unambiguous conditions of satisfaction covering different criterion like Functional Criteria, Non-Functional Criteria and Performance Criteria stating the intent of the story
• Worked with the Product Owner to define a detailed Definition of Done at Story and Sprint level with focus on different test dimensions that pose a risk covering performance, reliability, security, documentation, maintainability and compatibility ensuring major risk areas are covered sufficiently well
• Assisted with all aspects of verification including preparation of Test Cases, Test Plans and assisted the team in executing Functional Testing, Black box Testing, Regression Testing and System Testing
• Assisted the team in creating manual test scripts which the automation team used for automation testing using Selenium and for performance testing using LoadRunner
• Developed new Automation test cases and updated existing Automation test cases using Selenium Web Driver and TeamCity to create and run deployment jobs
• Developed the User Acceptance Test (UAT) plan and led the UAT efforts, identified user representative and worked with the development team to resolve defects/bugs identified during UAT
• Worked with the team to prepare the user manual and guide to using the automation system

Environment:: Waterfall - Scrum (Hybrid), SOA - N-Tier, MS Office Suite, UML, HTML5/CSS3, Bootstrap, Java Script, Oracle Warehouse Builder, jQuery, Ajax, Visual Studio 7.0, IIS, Azure, ReSTful API, SQL, SharePoint, Postman, nUnit, TeamCity, LoadRunner, Selenium, JIRA

Confidential, Boston

Business Systems Analyst

Responsibilities:

• Understood state of art processes by interacting with stakeholders and document analysis. Performed GAP analysis to assist Project Manager in planning the transition
• Planning and driving Project kickoff meetings with Business Users, Business Owners, Technology Architects to identify the high-level project objectives and scope. Broke down the business model into smaller bits of tangible information to understand how they should be processed
• Facilitated JAD sessions as Moderator and conducted interviews with various Subject Matter Experts (SMEs) and Stakeholders, Process, Policy & Procedure reviews to elicit requirements
• Prepared Business Requirement Document (BRD) and assisted preparation of System Requirement Specification (SRS). These documents were Analyzed, modified and validated. Created Use Cases and built Use Case Diagram and Activity Diagram using MS Visio
• Gathered requirements, created Document Libraries/Lists, and maintained comprehensive test plans and test specifications through SharePoint
• Assisted Data modeling process by creating Conceptual and Logical ER diagrams and designing Database Schemas to help in development of an accurate Data Warehouse Structure
• Integrated various OLTP to the OLAP by using Informatica for ETL and used Tableau for reporting. Assisted in increasing Data Integrity by inclusion of Constraints and Triggers and performing Data Normalization and adding Data Verification and Validity for data accuracy and effectiveness
• Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries. Performed SQL data validation for the data integrity in the back-end systems
• Was involved in using Tableau for effective reporting of key performance indicators (KPI) to facilitate expenditure tracking using various matrices critical to decision making
• Experience in documenting tags of REST and SOAP UI and involved in API testing using REST API with Postman
• Involved in technical writing, API documentation and end user manuals and documentation using MS Office Suite (MS Word, MS Access, MS Excel, MS Power point)
• Managed and tracked requirements using HP ALM through Application Life-Cycle. Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing, Black Box Testing and Manual Regression Testing
• Developed numerous Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading. Created Training Module and provided live demonstrations and system tutorials to business users Style Sheets, Pivot Table, Column Selector, Tabular with global and local Filters) using Presentation Services

Environment:: Waterfall, MS Office Suite, Tableau, Informatica, Rapid Miner, MS Visio, MS Project, HP ALM, Wireframes, Mock-Up Screens, Postman, MS SQL Server, SharePoint, UAT testing.

Confidential, Santa Clara, CA

Business Analyst

Responsibilities:

• Understood and documented Securities Compliance requirements and maintained a traceability log that was used to verify Compliance adherence throughout the project. Developed good knowledge on Asset Allocation, Commodities, Bond Pricing, Corporate Bonds, Fixed Income, Credit Risk, Market Risk
• Understood Business Requirements, finalized Product Backlog and helped PO with Prioritization using the Priority Poker technique and worked with PO on Release Planning for multiple sprints
• Worked intensely with the business team in the process analysis of cash/stock accounting, cash management and corporate actions to facilitate the build for migration to strategic platform
• Led an onshore and offshore resource pool of 23 cross-functional, Self-managing team members working collaboratively using online collaboration tools like JIRA, planning poker integrated with JIRA
• Worked with the development team that handled the module involved in the interaction between the GUI and the database, to ensure that the business standards are met in the data representations
• Systematically gained knowledge on the business process being followed in the project environment
• Worked on process improvements and implementation of best practices in software development
• Used JIRA to schedule and track the activities in the project and documented the RTM. Also, used the advanced search criteria to search for issues using JIRA Query Language (JQL)
• Conducted story writing sessions with the product owner and formulated User Stories and Acceptance Criteria for the Potentially Shippable Product Increment (PSPI)
• Facilitated with data engineers to conduct data validation and mapping from existing systems into data ETL systems to integrate data to the CRM object and business models
• Developed reports and operational dashboards to monitor product/departments’ performance and to continually analyze growth and engagement drivers through SQL reporting, which resulted in higher operating efficiencies
• Utilized MySQL to query tables in retrieving sample data from customer profiles stored in the system. Generated ad hoc SQL queries using joins, database connections and transformation rules to fetch data from the database
• Performed REST API web services testing using SoapUI and involved in API testing using Postman. Assisted the team with API documentation using JSON and XML
• Helped in testing activities by developing Test plans, Test cases, Use Case Scenarios using JIRA
• Developed, maintained and executed Manual Test Cases for requirement validation, integration testing, regression testing, performance testing and usability testing
• Created documents like the Business Glossary, Actors Catalog, Data Modeling and Data Dictionary to facilitate the team in understanding client business
• Liaised closely with the development team to deliver features/user stories across the project lifecycle

Environment:: Agile - Scrum, My SQL, MVC model architecture, MS Suite, DB2, Oracle 11g, MS Visio, MockUp screens, Postman, Load Runner, HP QC, SOAP UI, Jenkins, Selenium v3, IBM WebSphere Application Server 8.0

Confidential, Pennington, NJ

Sr. Business Systems Analyst

Responsibilities:

• Systematically gained knowledge on the business process being followed in the project environment
• Conducted Document Analysis and one-to-one interviews with the stakeholders and area experts to record requirements and act as a liaison between the business and technical team members
• Documented PCI-DSS compliance requirements and created traceability matrix with given functional requirements. Oversaw design, test and user acceptance of software and ETL to adhere to PCI standard
• Prepared and analyzed As-Is and To-Be in the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level
• Used detailed knowledge of application features and functions assess scope and impact of business needs throughout analysis and completion of all enhancement specifications
• Formulated user stories by conducting a story writing session with the Product owner and the acceptance criteria for the PSPI (Potentially Shippable Product Increment)
• Used SharePoint to manage schedules, deadlines, and resources and collaborate on the project and JIRA for requirements management, allotting tasks, issue tracking and for requirement traceability
• Handled requirement churn during the project by performing Impact Analysis. Conducted detailed and comprehensive Process Analysis, Business Rules Analysis by working with the client IT staff, project managers, supervisors, SME’s, and other stakeholders to identify the system, operational requirements and improvements
• Identified necessary Business Use Cases from requirements, created UML Diagrams including Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Class Diagrams and Mock-Ups using MS Visio and MockUp screens
• Understood the business logic, User Requirements and test-objectives to develop Test plans, Test cases, Use Case Scenarios, Test case execution using HP QC
• Worked with the team in performing Black Box Testing, White Box Testing, Functionality Testing, Integration Testing, System Testing and Modular Testing
• Performed REST API web services testing using SoapUI. Defined XSD schemas for the various restful services/web services after detailed analysis of the customer requirement
• Provide support in developing and maintaining ETL processes that extract data from PDF template that contains the transaction information then transport the data to various delivery points such as data marts or data warehouses in order to maintain the client bill payment information in documentum
• Performed various SQL queries to obtain data from multiple databases for QA testing
• Created documents like the Business Glossary, Actors Catalog, Data Modeling and Data Dictionary to facilitate the other teams in understanding client business
• Participated in Bug-Review meetings with software developers, QA engineers, managers, and suggested enhancements to the existing application from business perspectives
• Used Test Case distribution and trend reports to track the progress of test case planning, implementation and execution results. Performed Smoke Testing to evaluate builds
• Coordinated the development of the UAT test scripts, UAT test scenarios and Master Test Plan and successfully lead the User Acceptance Testing (UAT) effort

Environment:: Agile - Scrum, My SQL, MVC model architecture, IBM WebSphere Application Server 8.0, Postman, HP Load Runner, HP QC 10.0, SOAP UI, Jira, SharePoint 2010, Jenkins, Selenium v3, MS Office, MS Excel, MS Project, DB2, Oracle 11g, MS Visio, MockUp screens.

Confidential, Columbus, OH

Sr. Business Systems Analyst

Responsibilities:

• Analyzed the current systems in place and evaluated their use and scalability in developing this system. Performed Gap Analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements
• Conducted interviews and questionnaire sessions with the stakeholders for gathering requirements and evaluation/analysis of their data to convert the business requirements into functional specifications and prioritized the requirement as a High, medium and low
• Facilitated JAD session follow-up for Project Plan updates, gained consensus for UAT requirements
• Authored Business Requirements Document (BRD) with project teams. Extracted, discussed, and refined business requirements from business users and SMEs
• Created Business Use-Case Model and Business Use-Case specifications after accessing the status and scope of the project and understanding the business processes
• Used MS Visio to design and develop Use Cases Scenarios, Use Cases Models, Activity Diagrams, Sequence Diagrams and State chart diagrams
• Completed logical Data Modeling and Normalized Data Model for RDBMS. Assisted in developing ER models for database design. Created attributes for each requirement like priority, status, cost and difficulty and provided one-to-one, one-to-many parent child relationships between requirements of the same type. Designed mock-up User Interfaces to communicate visual data flow to the end users
• Designed and implemented SQL queries using joins, unions, outer joins, group by and aggregate functions to extract data from different databases (Oracle, SQL Server) for reporting and validation
• Produced Functional Specifications and led weekly meetings with technical teams to discuss outstanding technical issues and deadlines that had to be met
• Used MS Project to schedule and track the activities in the project. Documented Requirement Traceability Matrix (RTM) in Requisite Pro through test cases
• Mapped the designed URLs for the RESTful APIs to the business requirements. Scripted business rules for the web service, and assisted in drafting agreements for various web methods in XML format
• Worked with QA team to prepare master test plan, test strategy, test cases, and test scripts to perform functional testing, black-box testing, GUI testing, system testing, performance testing, stress testing, sanity testing, regression testing, and supported user acceptance testing (UAT)
• Involved in writing Feature Files in the Gherkins language for Cucumber testing and have experience and collaborated in the Cucumber - Selenium integrated automated testing environment for BDD

Environment: Waterfall-Scrum Hybrid, Windows XP, MS Project 2000, Cucumber - Calabash, Pencil Project, MS Office 2003 (Word, Excel, PowerPoint, Access), SQL Server 6.5, Lucid chart.

Confidential

Business Systems Analyst

Responsibilities:

• Involved in identifying the problem definition as part of continuous process improvement using Define, Measure, Analyze and Improve to support the business continuity of the organization Proficient in Data Analysis, Data Validation, Data Lineage, Data Cleansing and Data Verification
• Created sample of data prototypes for approval from sponsors on how the data can be migrated. Involved in the design of Star-Schema methodology and converted data from various sources
• Prepared and maintained ETL specifications, and Dimensional Modeling documentation. Integrated data sources through Extraction, Transformation and Loading (ETL) process using Informatica.
• Participated in deciding the methods for extracting, transforming and loading the data into target database using Informatica PowerCenter. Used Informatica to load data from Flat Files, Oracle.
• Created Data Flow Diagrams, Sequence Diagrams using UML methodologies for easy understanding. Worked with Data Analyst in Data Profiling, Data Mapping, Data Cleansing and Data Analysis before loading the data into the new database using tools like Informatica Data Quality.
• Used Dimensional Modeling in designing the data warehouse like Star Schema to define the relation between the fact tables and dimension tables. Created the conceptual, the logical ER diagrams, and the data dictionary. Reviewed the data mapping and the transformation business logic applied to the data to check if the requirements are met.
• Used Tableau for data reporting, studying the trends, data patterns and for data forecasting.
• Drafted test strategy, test cases and exit strategy by working closely with the QA team. Used SQL queries to perform data analysis, data validation and data manipulation. Led the User Acceptance Testing (UAT) efforts, and opened/closed defects on HP QC.
• Managed and tracked the requirements using HP ALM. Assisted in preparing the training module which was uploaded to the internal online training portal

Environment:: Waterfall, HTLM5/CSS, AngularJS, JavaScript/JQuery, .Net, ASP.Net MVC REST, ADO.Net, Microsoft SQL Server, Cloudera platform, HP ALM

Confidential

Business Analyst

Responsibilities:

• Interviewed key stakeholders to understand needs and translate them into Business Requirement and performed extensive Requirement Analysis including Data Analysis and Gap Analysis and functioned as the primary liaison between the business, operations and the technical teams
• Documented Business Requirements, Functional Specifications, high-level Project plan involving Work Break-down Structures and created business process information flow
• Identified requirements and created use cases for Account Opening, Maintenance and Reporting for new accounts on private banking and trust applications
• Designed and developed Use Cases and UML models - Sequence Diagram and Activity Diagram. Used Rational Rose and Rational Requisite-Pro for Requirement Traceability
• Created the Business Flow diagrams of Investment Banking, and extensively involved in Portfolio Management and analysis of Mutual Funds trading in Reference Data and Security Master
• Performed data analysis to identify the existing data quality issues pertaining to Fixed Income and partnered with the technical teams in the research and resolution of system and process problems
• Worked with the testing team in drafting the Test Plan, gathering Test Data and Test Cases. Involved in creation and execution of Manual Test Cases in Mercury Test Director, automated Test Cases in WinRunner and analyzed the Test Results in Mercury Test Director

Environment:: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), Windows 2000 Server, Oracle, MySQL, PLSQL, SQL Server, WebLogic, Java, J2EE, JSP, Vignette, LoadRunner, WinRunner, Test Director

Confidential

Business Analyst

Responsibilities:

• Interacted with stakeholders and Subject Matter Experts (SME) to understand Business needs and convert them into Business Requirement Document (BRD). Documented Function Requirement Document (FRD) and assisted the team in creating the System Requirement Specification (SRS)
• Used UML to prepare Use Cases from the gathered Function Design Document and created diagrams using Rational Rose
• Developed PowerPoint presentations for monthly reporting and meeting with upper management
• Performed GAP Analysis and Risk Analysis of existing system and evaluated benefits of new system
• Conducted JAD sessions with stakeholders throughout the SDLC to resolve open issues
• Created Requirement Traceability Matrix (RTM), Ad-hoc reports using MS-excel and Pivot tables to do calculations and created reports accordingly
• Worked with QA team to design Test plan, Test Strategy and Test Cases for User Acceptance Testing (UAT) and Regression Testing. Led UAT Testing

Environment:: Waterfall, MS Office, SQL, UAT Testing, HP QC, COTS