PROFESSIONAL SUMMARY:

• Have 8 years of experience as Business analyst and Business System Analyst in IT industry with strong domain knowledge of Banking, Payment Processing System, Trading.
• Extensive working knowledge of various Banking compliance and Guidelines such as NACHA, Bank Secrecy Act, USA Patriot Act, AML, KYC, SAR, BASEL, CCAR/DFAST, SOX, FCRA, PCI - DSS and other related laws and regulations
• Experience working in cross-functional and distributed teams on projects in various SDLC phases and end-to-end implementations using methodologies such as Waterfall, Scrum, Scrum-Waterfall hybrid, SAFe, and Kanban.
• A Certified Scrum Master with 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)and knowledge of understanding Velocity, Burn-Up, Burn-down charts.
• Experience in facilitating various elicitation techniques such as JAD sessions, Requirement Workshops, Brainstorming, Focus group, Document Analysis, Interviews, Reverse Engineering, and Surveys.
• Skilled in the 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).
• Performed Change Management through understanding the change and conducted Impact analysis (Technical analysis and Business), Risk analysis of the change on the project and experience in conducting GAP analysis (AS-IS and To-BE), SWOT analysis, Root cause analysis, Cost-Benefit analysis, Feasibility study.
• Sound knowledge of Erwin, MS VISIOforcreating data models and Unified Modeling Language (UML) diagrams including Use Cases, Activity Charts, Sequence Diagrams, Data Flow Diagrams and ER Diagrams.
• Experienced in writing User stories using INVEST technique and requirement management in JIRA, Confluence.
• Hands on experience in Slicing, Estimating, Prioritizing requirements using various techniques.
• Proficient in SQL querieslike the JOINS, Store procedures, Triggers, Functions to fetch data from different databases for timely reporting and validation.
• Experience in writing Data definition language (DDL), Data Manipulation Language (DML), Data Query Language (DQL) for CRUD operations.
• Extensive knowledge of Data warehouse including data integrity, Data transformation, Data migration, Data schemas, Data Quality, Data Profiling, Data marts, OLAP, used ETL tools such as Informatica,Talend, SSIS.
• Experience in converting Business functionalities into Service Oriented Architecture (SOA) models across IT environment with drafting knowledge of Web service level Agreement (WSLA).
• Comprehensive understanding of Web-Services (and their documentation using Swagger) like REST and SOAP (and involved in their testing using POSTMAN and SOAP UI) using XML, WSDL, UDDI, using internet protocol suite like HTTP under Three-Tier Architecture and Service Oriented Architecture (SOA).
• Exposure to Client- Server validations and Database validations and scripted XML for request and responses of web methods to web services using XMLSpy to assist the development team.
• Possess knowledge of the usage of different scripting languages like HTML, CSS, JavaScript, AngularJS, Ajax.
• Experience in developing Test plan, Test scenario, Test cases, in manual and automated test environments using Selenium, HQ QC, HP ALM, HP quick test Pro.
• Knowledge of Testing Life Cycle. Assisted in Black Box testing, Functional and Non-Functional Testing, Integration Testing, Regression Testing,Load/Stress Testing (LoadRunner), Performance and User Acceptance Testing.
• Detailed Understanding of building applications using .NET framework,ASP.NET, C#, MVC, WCF, WPF, Web API.
• Extensive Hands-on experience with Business Intelligence (BI) and experience in creating interactive, analytical dashboards using Tableau, MicroStrategy, SSRS, QlikView for decision making.
• Self-starter with ability to work under tight deadlines and multi-task to meet business objectives, schedules, communicating and coordinating with SME’s, Software Developers, Solution Architects and QA Team.

SKILLS:

Methodology: Waterfall, Agile-Scrum, Waterfall-Scrum, Kanban.

Modeling Tools: ER/Studio, Balsamiq, SmartDraw, MS Visio.

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

Reporting Tools/ETL: Tableau,SSRS, MicroStrategy, SSIS, Informatica, Talend.

Database: MySQL 2008, Oracle 10g, SQL Server Management Studio.

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Project, MS Visio.

Repositorytools/CI tools: GitHub, TFS, Jenkins, Bitbucket,Bamboo.

Testing Toolsand Web Services: HP QC / HP ALM, HP Load Runner, Selenium, Cucumber, Postman, SOAP UI, SOAP, REST, AJAX, XML, JSON, WSDL, XSD.

Languages: HTML, Java, .NET, C, C#, ASP.NET, MVC, WCF, Entity Framework, Bootstrap.

CRM: Salesforce CRM.

PROFESSIONAL EXPERIENCE:

Sr. Business Systems Analyst

Confidential, New York

Responsibilities:

• Conducted meeting with stakeholders to define product vision and get aligned with the project phases.
• Elicited requirements usingJAD session, Document Analysis, Focus Groups, Interview sessions to identify the business problems then analyze and documented them.
• Acted as liaison between the Business and Technical team to clarify and update requirements and status of project.
• Created high level and detailed documents as Business Requirement Document (BRD), Functional Requirement Document (FRD) and System Requirement Specification (SRS).
• Performed GAP Analysis and Cost-benefit analysis to gain significant knowledge about the enhancement.
• Identified dependencies by interacting with Subject Matter Experts, Technical Leads and recorded requirements that can be understood and reviewed by both business users and technical team.
• Conducted due diligence reviews of high-risk businesses and customers utilizing a risk-based approach in accordance with federal regulation including The USA PATRIOT ACT and OFAC.
• Researched and obtained KYC information to align the customer with Know Your Customer (KYC) and Anti Money Laundering (AML) standards.
• Producedbusinessrequirement artifacts including UML diagrams, Use Cases,BusinessRules, Supplemental (Non-Functional) Specifications, and User Interface Design Specificationsusing SmartDraw.
• Participated in various scrum ceremonies as Grooming Session, Sprint Planning, daily stand up, Sprint review, SprintRetrospective meetings for the system development.
• Assisted PO to prioritize Product backlog items and in slicing user stories for maximum business value delivery.
• Used JIRA to create user story based on INVEST criteria and determined theirAcceptance Criteria.
• Developed client-side and server-side validationsof data by writing business rules in the business engine.
• Executed SQL queriessuch as Sub-query, Joins, Triggers, Stored procedures, viewsand various Transformation rules to fetch the data from SQL Server database systems for validation and reporting purpose.
• Used Informatica forData Profiling and Data Mappingfor the basic source to target mapping for report generation for the management and created Data Mapping Documentfor the ETL team.
• Scripted business rules for the web service and assisted in drafting agreements for various web methods in XML format.Negotiated and updated SLA for the internal web services.
• Prepared the documentation for the RESTful APIs and SOAP web service i.e. the methods/endpoints its exposing, URIs and description through Swagger and tested API’s using POSTMAN and SOAPUI.
• Worked with Salesforce Admin to transfer the data and to create data dictionary with the source to target mapping.
• Developed Requirement Traceability Matrix and prepared test data for UAT testing.
• Designed Test plans and test casesto perform Blackbox testing, Regression testingusing HP ALM.
• Facilitated automated User Acceptance testingto ensure the functionality of the system was in alignment to the users and incorporated their feedback.
• Created dynamic and interactive visualizations and dashboards using Tableau for reporting to the management.

Environment: Scrum - waterfall Hybrid, SmartDraw 2017, Asp.net 4.5, C#, MS SQL Server 2016, Visual Studio 2015, JIRA 7.2, Tableau 8.2, Swagger, Postman 5.0.2, SOAPUI 4.6, HP ALM11.2, Salesforce CRM.

Sr. Business Systems Analyst

Confidential, Pennington, NJ

Responsibilities:

• Participated in the kickoff meeting to understand product vision and strategy with Business owners
• Framed a detailed agenda and conducted JAD sessions with different stakeholders and development team.
• Understood and articulated business requirements through user interviews,Surveys, Document Analysis.
• Performed GapAnalysis to identify the enhancements and differences between the current system and futuresystem.
• Prepared Business rules document based on user requirements and Network protocols.
• Gained knowledge about PCI-DSS compliance and ACH for the transparent system processing.
• Created Use case and used MS VISIO for UML diagrams such as Use case diagrams, Activity diagram andSequence diagram for client authentication and business process improvements.
• Used Balsamiqfor design and development of Wireframes and Mockup screensto assist development team.
• Worked on JIRA for requirement management, writing User stories and assisted PO in the grooming of Product backlog items using vertical slicing, estimation and Prioritizing the Product Backlog.
• Participated in various Scrum ceremonies, helped PO to review the working demo of Potentially Shippable Product Increment (PSPI) in review meeting based on the Definition of Done and Acceptance Criteria.
• Wrote SQL queriesto perform data analysis as needed to gather business requirements around reportdelivery.
• Reviewed existing Stored Procedures, Triggers, and other SQL joinsfor improving the speed and performance.
• Assisted in Designing Conceptual and Logical Models to capture the entities existing in the system and the relationship between them using E-R Diagrams, keeping in mind the business requirements.
• UsedTalend for ETL Process to Data profiling using built-in connectors and Data mapping of data from different sources to the target data-martthereby reporting and analyzing events and metrics.
• Assisted in Creating Data Mappingdocument for the application after finalizing the attributes and tables withbusiness users, SME’s and Data Architects.
• Reviewed all the Data points included for data contribution according to the SLA to the Third party.
• Documented REST API via JSON using documentation tools (Swagger), used Swagger Specification and converted its API documentation and used Plugins for integrating with JAVA.
• Tested API using to validate API in accordance with the business and vendor network rules.
• Assisted the QA team to develop the test plan and test cases to perform the testing and involved in Automated User Acceptance Testing (UAT) using Cucumber automation tool.
• Used MicroStrategy to generate Business Intelligence report for senior management.

Environment: Agile/Scrum, MS Office 2013, MS Visio 2013, Talend 6.1, JIRA 7.0, UML, JAVA, Web Services, SOA, REST, SOAP, Postman 4.3.2, XML, MS SQL Server 2014,Bitbucket, Selenium, MicroStrategy 10.2, Cucumber 2.4.

Business Systems Analyst

Confidential, Trenton, NJ

Responsibilities:

• Assisted and created the Project Plan, Roadmap, designed requirements planning, and management document.
• Analyzed existing system documents and conducted JAD session, interviews, brainstorming to elicit design requirement from business users and stakeholders.
• Interacted with Subject Matter Experts across the business, operations and IT to define requirements and documented the requirement in BRD, FRD, and SRS.
• Created Work Breakdown structure and performed Risk analysis along with the Project Manager.
• Involved in the process of creating the data flow,E-R, Conceptual and Logical Model diagramsusing Erwin.
• Conducted data profiling for identification of source data using Informatica IDQ.
• Assisted database developers in data normalization anddata transformation of data and data types, by creating Snowflake Schema dimension modeling, enabling the source to target column name and data mapping.
• Used Informatica Power Center in identifying business rules, and defining passive and active transformations like constant, look-up, data type conversion, and data transformation.
• Worked along with ETL developers using Informatica Workflow Manager, by assisting them in Extraction, Transformation, and Loading operations while documenting and monitoring ETL logs.
• Wrote SQL queries to pull data from the warehouse to create specialized reports for management.
• Performed Rollup, drill down, Slice and Dice operations and assisted in OLAP cubes development.
• Worked with QA team to create and monitor the Requirements Traceability matrix, Test Plan, and Test Cases to perform testingand facilitated Automated User Acceptance Testing (UAT).
• Prepared Functional Test Summary, Change Control & Validation Specification forreporting to Sr. Architect.
• Responsible for creating dashboards and customized visualizations to present the reports as per business requirements that helped in strategic decisions and validated reports using Tableau.

Environment: Waterfall, MS Project 2013, MS Office 2013 (Word, Excel, PowerPoint, and Visio), Erwin 9.5, MS SQL Server 2014,Tableau 8.0, Informatica, HP quick test Pro.

Business Systems Analyst

Confidential, San Francisco, CA

Responsibilities:

• Conducted JAD Session, Interviews, Document Analysis, brainstorming to elicit Business Requirements with Subject Matter Expert to gain knowledge of CCAR reporting and the Dodd-Frank Act.
• Validated and reconciled data from the various system by supporting CCAR and BASEL data acquisition teams.
• Performed GAP Analysis by analyzing AS-IS and TO-BE business process models.
• Assisted Project Manager in creatingProject Planning,Work breakdown structure,Project charter.
• Analyzed and gathered business and functional requirements for preparation of Business Requirement Document (BRD), and System Requirement Specification (SRS).
• Created Functional Requirement Specification (FRS), Functional Test SummaryandValidation Specification.
• Handled change management through technical impact analysis and business Impact analysis on the project.
• Created UML diagrams like Use Cases diagram, Activity Diagram, Sequence diagramsin order to capture the dynamic behavior of different applications and for the clear understanding of vision document using MS VISIO.
• Created Data Mapping&Data Modelling, a process in reference to Datacenter for regulatory reporting.
• UsedSSIS for Extraction, Transformation, and Loading; SSRS for report generation of the data to be analyzed from the data warehouses and data marts.
• Implemented SQL queries such as CRUD and Stored Procedure for central data repository and data profiling.
• Worked on service-oriented architecture (SOA)and documented and validated WSDL and its exposing methods.
• Assisted the QA team for creatingTest Plans and Test Cases and helped in User Acceptance Testing.
• Developed and Maintainedquality proceduresand ensured that appropriate documentation is in place.
• Prepared Requirement Traceability Matrix and interacted with QA team to ensure the quality of software.

Environment: SDLC Waterfall, MS Project 2013, MS Office 2013 (Word, Excel, PowerPoint and Visio), HTML, CSS, JavaScript, XML, Asp.net, C# .net, SSIS, MS SQL 2008, SQL, SSRS.

Business Analyst

Confidential

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.
• Tracked and reported timely performance against plans and forecast analyzed gaps (AS-IS and TO-BE process) and recommended corrective measures to improve productivity.
• Assessed business prioritiesand advised business units by performing RiskAnalysis.
• Handled change management by analyzing Technical and Business Impact analysis on the system using CR forms.
• 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.
• Created SQL Queries for BI reports forPortfolio Drill Downs to pull necessary data from data sources.
• Created an environment for self-organization and organized team engagement activities.
• Maintained and shared documents using MS SharePoint.
• Documented Requirement Traceability Matrix and 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, HP QC 10.0, MS Project 2010, MS Visio, Oracle 10g, SharePoint 2010, MS Office (MS Excel, MS Word, MS PowerPoint), QlikView,

.NET Developer/Business System Analyst

Confidential

Responsibilities:

• Involved in all levels of application lifecycle development, provided value-added services with development teams and clients, facilitated product development through functional consulting and managing complex tasks.
• Participated in workshops like JAD with SME’s and Networked with Project Managers to understand the business process gather Business Requirements.
• Collaborated and negotiated with stakeholders in defining project scope boundaries
• Created use cases, use case diagrams, activity diagrams to get the Business user’s perspective of the application.
• Designed wireframes and mockup screens for the developers to build multiple Windows Presentation Foundation (WPF) forms, custom controls, user controls and suggested master page,themes.
• Used Team Foundation Server effectively for team build, version control, data collection, and reporting.
• Assisted to author functional and business requirement documents and provided guidance to the QA team.
• 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.

Environment: Waterfall, TFS, MS Visio 2010, MS Access, MySQL server 2008, MS Excel, Outlook, MS Office, MS Powerpoint.

.NET developer

Confidential

Responsibilities:

• Involved in end-to-end implementation including analysis, design, development, and testing of application
• Developed various Models, Views, and Controllers for different modules like Accounts, Transfers, Bill Pay, Offers, Alerts, Statements.
• Worked on ASP.NET state management using sessions, query string parameters and ASP.NET caching features.
• Designed UI using web forms, HTML, XML, JavaScript, jQuery, CSS, ASP.NET, Server Controls and experience with various controls. Implemented client-side and server-side validations.
• Implemented Web services using WCF to update the information displayed in the browser and to authenticate the current users to ensure security and information sharing.
• Involved in development of web forms, classes, and interfaces using C#.NET that incorporates both N-tier architecture and database connectivity.
• Wrote SQLqueries including normal and complex, such as joins, stored procedures, triggers, and functions.

Environment: Waterfall,TFS,ASP.NET 3.5, C#.NET, Ajax, WCF, LINQ, Visual Studio .net 2008,ADO.Net, SQL Server 2008, XML, HTML, CSS, JavaScript, jQuery, IIS