SUMMARY

• Excellent Analytical, Problem solving, Communication and Documentation skills. Dedicated & Self - motivated, proven leadership capabilities and Time management skills.
• Strong experience and understanding of Industry standard methodologies like Waterfall, Scrum, Waterfall-Scrum Hybrid, Rational Unified Process (RUP), Kanban and Scrumban.
• Extensive hands on Experience wif Banking services like Payment processing systems, Enhancement projects, AML, Mortgage, Salesforce, EDMS Extensive years of experience in Business process re-engineering, business process improvements, Data Reports Analysis by active participation in brainstorming, interviews, focus groups, prototyping, document-reviews, and JAD sessions
• Extensive working knowledge of various Banking compliance and Guidelines such as NACHA, Teh Bank Secrecy Act, USA Patriot Act, Teh USA Securities and Exchange Commission and other related laws and regulations.
• 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).
• Well acquainted wif workflows and Unified Modeling Language (UML) diagrams including Use Cases, Activity Charts, Sequence Diagrams, Data Flow Diagrams, Class Diagrams and ER Diagrams.
• Excellent understanding and experience wif Scaled Agile framework (SAFe) and Scrum Framework including but limited to Ceremonies (Backlog grooming, Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective), Artifacts, Prioritization techniques (MoSCoW, Kano, Analytic hierarchy Process) and Estimation techniques (Planning Poker, T-shirt Size, Relative mass Estimation, Bucket sizing).
• Experience in conducting GAP (AS-IS & TO-BE Analysis), Impact Analysis (Business & Technical), SWOT, Cost benefit analysis, Root Cause Analysis, Interface Analysis, Feasibility Study, Risk Analysis.
• Performed SQL queries using different functions like joins, unions, group by and aggregate functions to extract data from different databases (Oracle, SQL Server) for timely reporting and validation.
• Extensive knowledge working wif ETL tools like Informatica Power center, IBM Infosphere Datastage, Microsoft SQL Server Integration Services and reporting tools like Tableau, MS SSRS and MS PowerBI.
• Extensive implementation knowledge of Data Warehouse concept including not limited to Data Migration, Data Integration, Data Conversion, 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.
• Extensive understanding of Web-Services and their documentation like REST and SOAP (and involved in their testing using SOAP UI) using XML, WSDL and UDDI, using internet protocol suite like HTTP under Three-Tier Architecture and Service Oriented Architecture (SOA).
• Worked on service-oriented architecture (SOA), performed API documentation for teh business logic implemented into Web services, also worked on Swagger and postman API documentation and auto-generated documentation for all REST calls.
• Exposure to Client, Server and Database validations and scripted XML for request and responses of web methods to web services using XML Spy to assist teh development team.
• Experience in Testing Life Cycle and supervising Black-box Testing, Functionality Testing, System Testing, Integration Testing, User Acceptance Testing (UAT), Load/Stress Testing, and Performance Testing.
• Extensive working Understanding of automation tools such as Selenium Automation and Rational software
• Experience Working wif QA team to design Test plans and Test Cases for User Acceptance Testing (UAT) using HP QC/ HP ALM.
• Extensive Hands on experience wif Business Intelligence (BI) and experience in creating interactive, analytical dashboards using Tableau, IBM Cognos and Splunk for decision making.

TECHNICAL SKILLS

SDLC: Waterfall, Agile, Scrum, Hybrid, Waterfall - Scrum, RUP

Business Skills: Change Management, Problem & Incident Management, Impact Analysis, JAD Sessions, SWOT Analysis, Project Planning, Project Scheduling, Project Budgeting, Risk Management, Conflict Management, Excellent Communication, Competent leadership & managerial skills, Goal & Time oriented, Great Business Acumen

Business Intelligence tools: MS Visio, Balsamiq, Tableau, Toad Data Modeler, IBM Congo’s, MS Excel

Languages: VB, C# & JAVA, SQL, PL SQL, MS SQL, .Net

Web Technologies: XML, HTML, SOAP, Web Services

Testing Tools: JIRA 6.3, HP-QC 9.2, HP ALM 11.5, Rational Clear Quest, Load Runner 12.02

BPM: Red Hat JBOSS, IBM-BPM, PEGA

Lifecycle management: HP-ALM, HP Quality Center

Architecture/Framework: Service Oriented Architecture (SOA), 3 Tier Architecture, N Tier Architecture, Cloud Platform (SaaS & IaaS), Apache Web Server

Data warehousing: Data Marts, Data Modeling, OLAP, OLTP, Data Mining, ETL, Slicing/Dicing, Drill Down/ Roll up, Pivot, Star and Snowflake Schema, Altova Map Force

Databases: SQL Server Management Studio, Oracle 8i-9i, Oracle 11g, MS SQL Server 2012, Team Foundation Server (TFS) 2012

PROFESSIONAL EXPERIENCE

Confidential - Pennington, NJ

Sr. Business System Analyst

Responsibilities:

• Gathered teh requirements via JAD sessions, One-to-One interviews wif Business stakeholders, Enterprise architect, analyzed teh requirements and prepared Business Requirement Document (BRD) & System Requirement Specification.
• Worked wif Subject Matter Experts(SME) to capture and understand thebusinessrequirements. Reviewed high - level requirements wifbusinessto prioritize and define scope of teh project.
• Performed Gap and Cost-Benefit analysis to establish teh significance of teh enhancement for teh project.
• Analyzed requirements by prioritizing and tracking toBusinesscase.Took insights wif active participation in document-reviews, plan setup, plan configuration and incorporated them in Business process re-engineering, Business process improvements, Business process modeling using activity diagrams and swim-lane diagrams.
• Worked wif Product Owner to review teh working demo of Potentially Shippable Product Increment (PSPI) in review meeting and halped deciding which features are done and satisfies teh acceptance criteria
• Hands on Experience wif JIRA for drafting teh User Stories and managing teh requirements.
• Experience in Creating Use-case scenarios and Sequence Diagrams using MS Visio for Client autantication.
• Created Mock-up Screens and Wireframes using UI Components such as Drop-down list, Check boxes for retrieving data from teh user wif client-side verification.
• Wrote SQL queries to document and integrate data from various sources for real time collateral monitoring.
• Assisted in Designing Conceptual and Logical Models to capture teh entities existing in teh system and teh relationship between them using E-R Diagrams, keeping in mind teh business requirements.
• Created Dimensional Model and halped teh architect to select from different types of dimensions i.e. Conformed and Slowly Changing Dimensions, thereby converting user stories into dimensions.
• Reviewed Business Rules written for middle tier and validated XML schema for system data documentation including teh requirement data document.
• Used ETL Process to map data from different sources to teh target data-mart in IBM Cognos Data Manager, thereby reporting and analyzing events and metrics.
• Assisted in Creating Data Mapping document for teh application after finalizing teh attributes and tables wifbusinessusers.
• Documented REST API via JSON using documentation tools(Swagger), used Swagger Specification and converted it API documentation and used Plugins for integrating wif JAVA.
• Reviewed existing stored procedures, supported application developers by tuning SQL queries for better performance.
• Worked wif QA team to design and develop Test Plan, Test Cases, to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.
• Assisted teh QA team to develop teh test plan and test cases to perform teh testing and involved in Automated User Acceptance Testing (UAT) using Cucumber automation tool.
• Generated Business intelligence report for senior management using teh Tableau reporting tool

ENVIRONMENT: SDLC, Waterfall-Scrum Hybrid, Wireframes, MS Office (MS Word, MS Excel, and MS PowerPoint), MS Visio, UML, JIRA, Data Manager v10.2, Web Services, SOA, SOAP, XML, HTML, Tableau, Cucumber

Confidential - Livingston, NJ

Sr. Business System Analyst

Responsibilities:

• Acted as a liaison betweenbusinessclients and technical teams by planning, conducting and directing teh analysis ofbusinessrequirements to support online transactions.
• Led Requirements elicitation sessions to understandbusinessproblems and how proposed system enhancements will address them for escalating teh issues.
• Conducted onboarding due diligence of high risk new to bank consumer andbusinessclients in accordance wif federal regulation including Teh USA PATRIOT ACT and OFAC.
• Producedbusinessrequirement artifacts including UML, Use Cases,BusinessRules, Supplemental (Non-Functional) Specifications, and User Interface Design Specifications.
• Created workflow mockups to Depict navigation flow for teh websites.Created Wireframes to present it to teh development team to better understandbusinessprocess architecture for customer facing online portal and issue escalation for change management.
• Conducted due diligence reviews of high risk businesses and consumer customers utilizing a risk-based approach.
• Researched and obtained KYC information to align teh customer wif Know Your Customer (KYC) and Anti Money Laundering (AML) standards.
• Conducted in-depth transaction analysis to assess potential risks and possible mitigation based on teh research of customer records and verification of counterparties to determinebusiness purpose and legitimacy.
• Documented detailed risk assessment of customer and escalated any activity outside of risk tolerance such as dat which posed potential Suspicious Activity Reporting (SAR) filing or required additional action(s) whenAMLrisks identified.
• Created User Stories for maintaining FTPs and navigation flow for teh online transactions for downstream, upstream and midstream interfaces (SOAP, HTTP, and REST).
• Formatted teh report layout for teh requirement of teh end users and deploy teh developed reports on to teh server for teh end users.
• Retrieved data from Enterprise Database using various SQL queries using joins, database connections and transformation rules to fetch data from teh SQL Serverdatabase systems.
• CreatedBusinessChange Request Management (BCRM) Documents for building integrated platforms to accommodate new technologies & development methods, improve teh processing of sensitive information, and reduce operational risks, User Acceptance Testing (UAT) and Test Plans (Quality Center).
• Assisted in teh development of quality assurance activities including Quality Assurance Plan, Product Acceptance Plan, Test Plan, and Test Cases.
• Used HP ALM Manual testing tool to link test cases wif teh requirement.
• Responsible for teh maintaining activities related to teh projects after integration wif teh current system and fixing teh defects suggested by teh end users and TEMPeffectively implementation.
• Created dynamic and interactive visualizations and dashboards using Tableau andMS Excel for reporting to teh Management

Environment: Scrum, XML, Web Services, Tomcat 5.5, WebSphere 6.1, Oracle 9i, HP Quality Center, MS Office Suite, Rational Requisite Pro, Outlook, JIRA, SaaS, APIs and FTPs (SOA, SOAP), HTTP, RDBM

Confidential - Estero, FL

Sr. Business System Analyst

Responsibilities:

• Assisted in creating Project Plan, Road Map, Designed Requirements Planning and Management document.
• Identified subject-matter experts and drove teh requirements gathering process through approval of teh documents dat convey their needs to management, developers, and quality assurance team.
• Assisted in creating Gap and Cost-Benefit analysis to establish teh significance of teh enhancement.
• Identified, created and facilitated process design changes by conducting business and system process analysis and design at complex level
• Conducted JRP sessions to assess needs and Conducted JAD sessions to gather teh design requirements for teh solution proposed and documented Requirement.
• Elicited requirements from teh intended users and documented teh requirements in FRD and BRD.
• Managed change requests from stakeholders based on teh criticality of teh request for deciding on making teh change in teh project
• Created UML diagrams like activity diagrams, use case diagrams, sequence diagrams, state diagrams for defining business processes.
• Involved in reporting status, milestones, and project plan tracking to project manager and product owner on a weekly basis.
• Assisted in Creating Data Mapping Document and worked wif team on normalizing, data schema, data cleansing.
• Extensive working knowledge of Informatica power center for Extracting, Transforming and loading teh Data into teh systems
• Performed Data Normalization, Data Verification & Validation to increase Data Integrity by maintaining accuracy and TEMPeffectiveness of data. Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries
• Prepared Functional Test Summary, Change Control Documentation & Validation Specification for reporting to Sr. Architect.
• Developed client side and server-side validations by writing business rules in teh business engine acquired form teh stakeholder.
• Used XML in modelling request and response for teh web methods using XML Spy.
• Documented REST APIs and SOAP web services wif teh URI and description of methods.
• Provided support to teh upgrades and improvements for application successfully and efficiently.
• Developed Requirement Traceability Matrix and prepared test data for UAT testing.
• Assisted teh QA team to develop teh test plan and test cases to perform teh testing and involved in Automated User Acceptance Testing (UAT) using HP Quick Test Pro automation tool.
• Generated Business intelligence report for senior management using teh Tableau 9.3 reporting tool

Environment: Waterfall, Red hat Jboss, BPM, MS Office Tools, MS Project, HP Quick Test Pro, Requisite Pro, MS Visio, Clear Case, Visual Studio, MS-SharePoint, Tableau 9.3, Informatica power center

Confidential - Hopkins, Minnesota

Business Analyst

Responsibilities:

• Developed and introduced new features/capabilities inCRMapplications by analyzing information needs and functional requirements to deliver teh needed artifacts.
• Elicit requirements from teh business and collected overall system requirement through JAD sessions.
• Worked on identity management to provide access levels by establishing role hierarchy.
• Facilitated wif data engineers to conduct data validation and mapping from existing systems into data ETL systems to integrate data to teh CRM object and business models
• Involved in defining teh source to target data mappings, business rules, business and data definitions
• Administered and configured profile and role hierarchy and created workflows to adhere to user requirements resulting in enhanced customization.
• Worked wif teh technical team in integrating teh REST APIs in teh pages as per business requirements.
• Used Postman Api documentation tool for documenting teh API
• Administered and reviewed testing including UAT, criteria-based testing in QA stage.
• Supported teh application wif updates eliminating teh problems and considering new requirements.
• Pioneered teh company’sCRMsoftware program, curriculum and materials production.
• Facilitated for teh junior staff on producing critical management sales performance insights.
• 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.

Environment: Scrum, Windows 7/8, Microsoft Office Suite, Microsoft Visio, SharePoint, GitHub, Salesforce, Rally, Tableau, SQL Server, PostMan API Documentation

Confidential

Business Analyst

Responsibilities:

• Elicited business requirements for teh project using interviews, document analysis, surveys, site visits, use case scenarios and used standard template of teh organization to develop requirements.
• Conducted Joint Application Development (JAD) sessions wif Subject Matter Expert (SME) sessions.
• Reviewed thebusinessrules wif teh developing team and modified based on Technical Specification and software requirements specifications (SRS) usingPegaRules Process Commander
• Maintained and build relationships wif stakeholders to ensure their performance management and business analysis needs are understood and supported.
• Elicited and documented Functional requirements, business requirements AS-IS and TO-BE business process models.
• Prepared Requirement Traceability Matrix and interacted wif QA team to ensure quality of software
• Analyzed and gathered requirements for preparation of Business Requirement Document (BRD), Functional Requirement Document (FRD) and System Requirement Specification (SRS).
• Teh methodology used for teh project was Waterfall. Provided clear and consistent information about project status both internally, IT team and stakeholders.
• Responsible for creating UML diagrams (Use Cases, Activity Diagram and Class Diagram) in order to capture teh dynamic behavior of different applications.
• Documented REST APIs and SOAP web services wif teh URI and description of methods.
• Developed Understanding of SAS for Data profiling and Data modeling.
• Developed Use Cases, Activity Diagrams and Sequence Diagrams for a clear understanding of teh vision document.
• Worked Extensively on SQL Server database to extract data and build Business reports
• Designed Test Plans and Test Cases for User Acceptance testing (UAT) wif teh halp of QA teams.
• Generated Business intelligence report for senior management using teh Tableau reporting tool

Environment: SDLC Waterfall, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), MS Project, MS Visio, PegaRules Process Commander, Tableau

Confidential

Business Analyst

Responsibilities:

• Involved in Requirement Scoping and analyzing high priority requirement for implementation.
• Conducted GAP analysis by identifying AS-IS and TO-BE analysis, created Business Requirement Document (BRD), Functional Requirement Document (FRD) and performed What-if Analysis using Excel as per teh requirements of teh managers.
• Created Use Case Diagrams, Activity Diagrams and Entity Relationship Diagram (E-R) using MS Visio.
• Talked to teh developers and users to collect teh information about data sources, teh data feed, teh format for input data file and built a Traceability matrix(RTM) for teh same.
• Analyzed Requirements and created Use case models, UML/Use Case diagrams, Activity Diagrams.
• Coordinated wif teh development team, database team, data warehousing team and Assisted QA team to develop test plans, test strategies and test cases and used Quality Center for defect logging and defect tracking.
• Experience in writing SQL queries to retrieve data from teh database and perform data validation testing.
• Facilitated User Acceptance Testing by preparing test schedules, teh business users to perform teh testing and addressing open issues.

Environment: Waterfall, SOAP UI, MS SQL Server, Tableau, JIRA, MS Office (Project, Visio, Excel), MS SharePoint, XML, HTML, JavaScript, Tableau, Java 2, Java script, XML, HTML, SQL

Confidential

Jr. Business Analyst

Responsibilities:

• Elicited business requirements for teh project using interviews, document analysis, surveys, site visits, use case scenarios and used standard template of teh organization to develop requirements.
• Facilitated JAD sessions to identify business rules and requirements and tan documented them in a format dat can be reviewed and understood by both business people and technical people.
• Conducted interviews wif clients for gathering product requirements and understanding teh client workflow.
• Elicited requirements and created Use Cases, Use Case Diagrams and Sequence Diagrams using MS Visio.
• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) for application development.
• Analyzing and designed Use Case diagrams, Sequence diagrams, Activity Diagrams, Business Objects, Domain Object Model, and MS Visio to depict process flows and PowerPoint presentations.
• Involved in project analysis and created functional specifications.
• Documented User Requirements wif MS Word as teh editing tool and Rational Rose to develop teh use cases.
• Authored design documentations: requirements traceability matrices (RTM), functional specs and complex process and data flow diagrams.

Environment: Waterfall, Documentum, XML, SOAP, J2EE, Oracle, MS Office (Project, Visio, Word, Excel, PowerPoint), MS Access, Load runner, UML, HP QC, MS SQL, Oracle, Tableau server.