SUMMARY

• Around 8 years of experience as a Business Systems Analyst in Banking and Financial service industry in application enhancement and development projects.
• Strong experience and understanding of Industry standard methodologies like Waterfall, Scrum, Waterfall - Scrum Hybrid, Extreme programming, Rational Unified Process (RUP), Spiral Model, Kanban and Scrum Ban.
• Knowledge and exposure working with various Banking regulations and compliance such as; FINRA, FINCEN, PATRIOTIC ACT, BSA, AML and KYC.
• Knowledgeable and well acquainted with financial instruments such as Portfolio Management and Investment Management. Knowledge on Regulations like SEC, Dodd Frank and Basel III.
• Experience in eliciting detailed Business Requirements from customer/project stakeholders. such as survey/questionnaires, Structured Interviews, Brainstorming, Focus group, Requirement workshops, Interface analysis, Document analysis, and JAD sessions.
• Experience in conducting GAP (AS-IS & TO-BE), Impact Analysis (Business & Technical), SWOT, Cost benefit analysis, Root Cause Analysis, Interface Analysis, Feasibility Study and Risk Analysis
• Skilled in creation of Project Charter, Work Breakdown Structures, Project Plan, Screen Mockups and Wireframes, Business Requirements documents (BRD), Functional Requirement Document (FRD), System Requirements Specification (SRS), Requirement Traceability Matrix (RTM)
• Proficient in using MS Visio, Rational Rose and UML for generating Use Cases, Class Diagrams, Entity relationship (ER), Sequence Diagrams, Activity Diagrams, Data Flow and Business Flow Diagrams
• Performed SQL queries using different functions like Select, Joins, Views, Unions, Group by And Aggregate functions to extract data from different databases (SQL Server, Oracle) for timely reporting
• Extensive knowledge working with ETL tools like Informatica Power center, Microsoft SQL Server Integration Services and reporting tools like Tableau.
• Extensive implementation knowledge of Data Warehouse concept such as Data Migration, Data Integration, Data Cleansing, Data Quality, Databases, Data Table structures, OLAP Cubes, Conceptual Modeling, Logical modeling, Physical Modeling, Star Schema, Snowflake Schema, Galaxy Schema, Facts, Dimensions, Measures, Top-down and Bottom up approaches.
• Experience working in Three-Tier architecture, Web Services (SOAP (XML, WSDL), REST (XML, JSON)), Client-Side/Server-Side Validation
• Involved in identifying API requirements and end points of API, technical writing (API Documentation), Swagger API, Used SOAP UI tool to check the request and response of REST API
• Extensively interacted with the designers, developers to ensure functional implementation of business requirements and the QA team in executing Test Plans, Test Case scenarios, Test Logs, Test Objectives. Employed HP Quality center/ALM for designing Test plans and Test Cases for User Acceptance Testing (UAT). Used HP ALM for managing the full test cycle and Automation Tool, QTP for testing and Quality center for test management
• Experience supervising Black-box Testing, White-Box Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT), Load/Stress Testing, and Performance Testing
• Successful in translating business requirements and user expectations into detailed specifications employing MS excel and tools like JIRA and HPALM; content management using TFS
• Created Dashboards, Visualizations and Reporting using MS EXCEL and TABLEAU.
• Excellent Analytical, Problem solving, Communication and Documentation skills. Dedicated & Self- motivated, Proven leadership capabilities and Time management skills.

TECHNICAL SKILLS

Banking & Finance Domain knowledge: AML/KYC, BASEL lll, National Automated Clearing House Association (NACHA), Portfolio management, Investment Management, Risk & Fraud Management, Loan Origination, Credit Processing.Project Management Tools/Methodology Unified Modeling Language (UML), MS Project, MS Share Point, Rally, JIRA, Agile-Scrum, Waterfall-Scrum, Waterfall, Extreme Programming, Kanban.

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

Reporting Tools: IBM Cognos, Confluence, Tableau, MS Power BI

Databases: Oracle, SQL Server, Apache HBase, MS-Access, MySQL

Office Tools: MS Word, MS Excel, MS PowerPoint, MS SharePoint 2013, MS Project, MS Visio

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

Languages: JAVA, SQL, JavaScript, HTML, XML, C, C++, Python

Issue Tracking tools: JIRA, Rally (CA Agile), HP ALM, HP QC

ITIL Framework: ServiceNow

Hadoop/Big Data domain: Apache Hadoop, Apache Spark, Apache Hive, Apache Hive

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr. Business System Analyst

Responsibilities:

• Ensured Customer Identification Program(CIP), Customer Due Diligence (CDD) and Enhanced Due Diligence (EDD) policies are followed based on KYC norms and reviewed its monthly report for accounts with suspicious activity and maintained track of all reports
• Responsible for ensuring all required AML regulatory requirements for existing clients are still in place
• Conducted Gap Analysis by identifying AS-IS and TO-BE process models and process flows
• Worked with AML Team, performed Document Analysis by analyzing previous documentation, tools and business processes, conducted One-to-One Open-Ended Interviews with Front & Middle Office experts for current & proposed business flow for comprehensive understanding of the project. Also involved in JAD sessions, Observations, Interface Analysis for the requirements elicitation.
• Converted the BRD into user stories by conducting a story writing workshop with the Product owner and defined their acceptance criteria for the PSPI (Potentially Shippable Product Increment).
• Handled Requirement churn via Impact Analysis by checking the feasibility of the Triple Constraints and discussing them in Daily Scrum. Developed quality plan for the development team and resolved team impediments.
• Used SQL for querying & analysis purpose on various source tables and wrote SQL Joins, GROUP-BY queries to check duplicate data, AGGREGATE functions to perform calculations on set of values
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to Target systems using Informatica Power Center 9.1
• Involved in analyzing Source system and identify the domains and various kinds of data and availability of data. Involved in identifying Data Elements, Data Types, Key Attributes of Data and the data that should be passed to the target system.
• Worked on Service-Oriented Architecture (SOA), Performed API Documentation for the business logic implemented into webservices, also worked on Swagger API Documentation and Auto-generated documentation for all REST calls. Documented and Tested Rest API using SOAP UI tool
• Used HP ALM for managing the full test cycle and Automation Tool, Selenium for testing and QC for test management throughout the project from creation to execution and JIRA for defect management and Confluence for Repository Management and collaboration.
• Conducted User Acceptance Testing (UAT) and developed the test plan, test condition and test cases to be used in testing based on Business Requirement/Use Case.
• Generated KPI reports on data project and identify enhancement opportunities across products by creating Dashboards, Visualizations and Reporting using MS Excel and Tableau

Environment: Waterfall-Scrum Hybrid, HP ALM, TFS, JIRA, HTML5, CSS3, JavaScript, jQuery, MS office (Project, Visio, Excel, PowerPoint) UML, Java EE 6, Red Hat JBoss BPM, Tableau, REST, Swagger, Apache Hadoop, Apache Presto, Apache Spark, Apache Hive2.

Confidential, Baltimore, Maryland

Sr. Business System Analyst

Responsibilities:

• Assisted Project Manager in documenting project scope, Gantt chart and Cost/benefit analysis
• Created Project Management Plan, involved and facilitated JAD sessions,Focus Group, Interviews,conducting surveys/questionnaires, Document Analysis along withBusiness Owner and Project stakeholders to elicit requirements.
• Coordinated withBusiness owner, System Architect, Data Scientists/Analysts, Development, and Data operationsteams to examine, collate and document data requests and impending risks in Risk Matrix.
• Documented AS-IS/TO BE scenario by performing Gap Analysis, created Use Case Diagrams, Activity diagrams, Sequence diagrams in MS Visio, prepared BRD & FRD, decomposed BRD into PBIs by participated in Story Writing Working workshop.
• Developed Mockup Screens for the proposed Web Application Portal, created Conceptual and Logical Data Model by coordinating with the System Architect and Development Team
• Used SQL queries such as DDL commands (Alter, Drop, Truncate, Rename) to define database schema & DML commands such as (Insert, Update & Delete) for data manipulation in database.
• Documented REST API via JSON using documentation tools (Swagger), used Swagger Specification and converted it API documentation and used Plugins for integrating with JAVA.
• Proficient in Manual testing, with different testing types like Black Box, Gray Box, smoke, functional, Integration, System, End to End Regression, User Acceptance Testing and Database Testing.
• Defined Acceptance Criteria for user stories for User Acceptance Testing. Designed Test Cases, Test Plans, Test Scripts, and Test Scenarios to perform Functional and Regression Testing & logged down defects and systematically managed them in Jira
• Created interactive dashboards using Tableau andMS Excel for reporting to the Management.

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

Confidential, Boston, MA

Business Systems Analyst

Responsibilities:

• Elicited business requirements using JAD session, interviews, document analysis, and Brainstorming
• Performed GAP analysis (AS-IS & TO-BE) process models/process flows and created, documented Business Requirement Document (BRD), Functional Requirement Document (FRD), and System Requirement Specification(SRS)
• Created Requirement Traceability Matrix, prepared Business process models; used MS Visio to create process flow diagrams for management and mapping the logical aspects of the process.
• Developed Use Cases, Activity Diagrams & Sequence Diagrams for understanding of the document.
• Used ETL to map data and assemble data repository and created data marts.
• Strong experience in Data Migration, Data Cleansing, Transformation, Integration and Data Export using ETL tools such as Informatica PowerCenter.
• Created Data Mapping template and assisted in creating Data modeling. Developed Conceptual and Logical ER diagrams for the database. Created Data Dictionary for the data models.
• Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity to maintain accuracy and effectiveness of data,
• Assisted with SNOW-flake schemas in the Dimensional model architects to providing business rules.
• Created Data Mapping specs, Source to Target mapping documents including the transformation rules.
• Worked with QA team to help create Manual test cases and develop Test Plan, Test Cases, to perform User Acceptance Testing (UAT), System integration Testing (SIT), and Regression Testing

Environment: SDLC, Waterfall, MS office (Word, Excel, PowerPoint and Visio, Project), HTML5, CSS3, Visual studio, MS PowerBI, MS BI (SSIS, SSRS, SSAS), HP QC.

Confidential, Cincinnati, Ohio

Sr. Business System Analyst

Responsibilities:

• Conducted Business workflow analysis, process analysis, SWOT analysis, cost-benefit analysis and Gap analysis to know the condition of the current process in use
• Involved in Project Management activities like defining / managing project scope, schedule management
• Creating project plans, tracking and communicating project status, and milestones using Gantt chart
• Handled risks proactively and worked with the Senior Management Teams to deliver the project
• Participated in Scrum meeting with technical/non-technical team, SME’s to clarify business rules & solve impediments and translated Functional requirements into User stories using TFS
• Used Unified Modeling Language (UML) to prepare Use Cases diagrams, process flow diagrams, sequence diagrams from the gathered requirements
• Collaborate with cross functional teams and build schedules and plans, Identify and manage dependencies with other internal or external teams to align deliverables
• Created XML data mapping documents to map the XML request and response from the tables in database
• Worked on Web Orchestration and Java API’s to integrate it with different Applications
• Experienced in developing and maintaining overall Testing Methodology and Strategy, documenting Test plans, creating Test cases and executing Test Scripts based on baseline requirements.

Environment: Agile, Restful web services, Team Foundation Server, UNIX, REST, Microsoft Test Manager, HP QC, MS Office, MS Visio

Confidential

Business System Analyst

Responsibilities:

• Prepared BRD, FRD and updated the artifacts during Change Request. Developed Requirement Traceability Matrix (RTM) to ensure no requirement is left without being tested
• Created static and dynamic prototypes and screen mock-ups, interacted with stakeholders in eliciting requirements and to showcase the new screen changes
• Created UML diagrams such as Sequence diagram, use case diagram, and activity flow diagram
• Gathered data from Bloomberg in flat files on various securities and used these data to for uploading it to calculator engine to Calculate Margin Requirement and worked on reference data
• Defined and suggested SOAP, XML based web services, web methods, (API’s). Good Experience in testing and defect logging tools like HP-ALM, and SOAP UI
• Performed various kinds of testing - Integration testing, Functional testing, Smoke testing
• Used HP QC for defect logging and defect tracking, and worked on various defects related to the application

Environment: AutoSys, MS-Visio, HP-ALM, Bloomberg, SOAPUI, SharePoint, XML, HTML, UML, HP-Quality Center, MS PowerPoint, TFS.

Confidential

Business Analyst

Responsibilities:

• Interacted with the internal stakeholders to elicit user requirements and their expectations from the system.
• Involved in analyzing Business Requirements and developing System Specifications. Conducted JAD sessions with key business users to make them understand the project scope
• Interacted with cross-functional teams on Business Use Cases and understanding expenses and revenue
• Created Use case diagrams, activity diagrams and class diagrams using UML for designing and developing to describe whole scenario using MS-Visio.
• Created Stub Data in XML and provided to UI developers to progress the web page development
• Used Group-By & Having-Clauses with Aggregate Functions Such as Sum & Count to summarize data.
• Participated in the development and preparation of the Test Plan with the testing team as well as ensuring testability, reliability, usability, maintainability and performance of the application.

Environment: AGILE, MS Office Suite, MS Visio, UML, SharePoint, HTML5, Bloomberg, Informatica, HP Load Runner, JIRA.

Confidential

Jr. Business Analyst

Responsibilities:

• Interacted with the customers and internal stakeholders to elicit requirements and their expectations from the system. 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 Business Requirement Document (BRD), Software Requirement Specifications (SRS) and Functional Requirement Specifications (FRS). Generated initial use-case diagrams using UML in MS Visio.

Environment: Waterfall, MS Office, MS EXCEL, MS ACCESS, Load runner, windows 2000, clear case, MS Visio and Bugzilla.