SUMMARY:

• Driven Business Analyst with more than 8 years of experience in cross - functional projectsacross various domains. Adept at navigating complex issues utilizingproblem-solving skills and negotiating skills. Talented communicator, with ability to strengthen relationships with peers and senior leadership, build consensus, and elicit clear decisions from clients and all levels of stakeholders.
• Extensive knowledge in full SDLC Governance and Collaboration from Inception to Deployment phases. Worked in traditional Waterfall, Spiral and Agile frameworks Scrum, Scrum-Waterfall, Scrum-ban, and Safe.
• Knowledge of various regulatory acts such as PCIDSS, PCISSC, PA-DSS, Bank Secrecy Act, Dodd Frank wall Street Reform and Consumer Act, Sarbanes Oxley Act, Basel I, II, III Fincen, OFAC.
• Proficient in Requirement Management, road mapping, Issue Tracking, Impediment Management, and Work Allocation using tools like JIRA, CA Agile (RALLY) and HP ALM.
• Adept at coordinating with Stakeholders, Subject Matter Experts (SMEs) and End Users to understand, analyze and gain consensus of requirements through a techniques such Prototyping, Brainstorming, Interviews, FocusGroups, Joint Application Design (JAD), Joint Application Review (JAR) sessions,prerequisite walkthroughs
• Experience in conducting SWOT Analysis, Root Cause Analysis, Cost Benefit, Feasibility Study and ROI.
• Extensive experience in Project Collaboration tools such as SharePoint, JIRA, Version One and Salesforce CRM
• Comprehensive knowledge of and highly applicable skills in Risk Identification, Risk Assessment, Risk Mitigation, Quantitative Risk Analysis, Qualitative Risk Analysis, Prepared Risk Register
• Excellent business writing skills in writing Business Requirements Document (BRD), USE Case Specifications, Functional Specifications, Systems Design Specification (SDS), Requirements Traceability Matrix (RTM), Systems Requirements Specification (SRS), Data Dictionary, Business Continuity Plan (BCP), and UML diagrams.
• Facilitated backlog refinement sessions, sprint planning, daily scrum, sprint review, and retrospective meetings.
• Assisted maintaining product backlog, sprint backlog, writing PBI’s, sizing user stories, estimating the user stories. Managed open issues, removed impediments, improved software quality & test coverage on JIRA.
• Designed and developed Use Case, Activity, Sequence, and Data Flow diagramsto define the Business Process.
• Extensive experience in conducting Market Research, Feasibility Studies, Logical and Conceptual designs for Database, Data Warehousing, Business Architecture, andmany Distributed IT systems.
• Experience in SQL queries like Joins, Subqueries, and Aggregate functions to ensure DB, UI Alignment
• Good working knowledge of Three-Tier architecture, Service Oriented Architecture (SOA), Web Services (SOAP, REST, WSDL), Version control, Client-Side and Server-Side Validation.
• Documented requirements and Web APIs (JSON documentation&XML documentation) usingSwagger,IO docsforJSONto assist developers in their development.
• Extensive execution learning of Business Intelligence, Data warehousing, Data Structures, Schemas, Physical Models, Data Marts, OLAP and OLTP Operations, Master Data Management (MDM)
• Interacted with data architect for Data Mapping, Data Modeling, Entity Relationship Diagrams.
• Used DDL, DML, DRL in SQL to perform CRUD operations on databases such as joins and stored procedures.
• Experience in Continuous Integration, Continuous Deployment, Release Management, Master Data Management, Data Profiling, Data Analysis, Data Discovery, Source to Target (S2T) data mapping documents.
• Strong knowledge of SQL, extraction/ transformation/ loading (ETL) process, and data migration using DTS.
• Involved in projects related to implementation of Data warehousing, Data Structures, Schemas, Data Marts and OLAP Operations such as Roll-Up, Drill-Down, Slice, Dice and Pivot. Knowledge of Data-Migration, Data Lineage, Data Migration to Cloud, Systems Mapping and Data-Governance Processes.
• Participated extensively in User Acceptance Testing, Black-Box testing, Smoke testing, Sanity testing, Load/Stress testing, Regression testing, End-to-End testing, and Integration testing.
• UsedTableau, Quick viewto create executive dashboards and reports for the key business measurements by providing users with interactive and responsive reports.
• Expertise in the management of User Request Change, Change Management, and handle User/Team Conflicts.

TECHNICAL SKILLS:

Methodologies: Waterfall, Agile-Scrum, Kanban,Scrumban, Waterfall-Scrum, XP, Spiral.

Business Modelling Tool: MS VISIO, Balsamiq, Lucid Chart, Bizagi

Project Management: Rally, JIRA, Version One, SharePoint, HP ALM, Confluence

Operating Systems: Windows XP, Vista, 7,8,10, Mac OS, Linux

Dara Warehousing: Data Modelling, Data Mapping, Data Marts, OLTP, OLAP, Data Mining, Slicing/Dicing, Roll Up/Drill Down, Pivot

Database/ETL: MS Access, Oracle DB, SQL Server, Informatica- Power Center, Data Quality,MDM

Reporting/BI: Tableau, MicroStrategy, SSRS, Microsoft Power BI, IBM Cognos,Quick view

Language: Java, C++, HTML, XML, SQL, COBOL,Xpath

Defect Tracking/ Testing Tools: HP QC, Load Runner, JIRA, Soap UI, Cucumber, Gherkin, Selenium, HPALM, TFS

Miscellaneous: Microsoft Office, Microsoft Access, Skype Business, Adobe Photoshop, RedHat JBoss BPMsuite,Oracle BPM, Oracle IAM Proofpoint,Oracle SOA/AIA,Salesforce, MuleESB, Swagger, Proofpoint, SAS Visualization

PROFESSIONAL EXPERIENCE:

Confidential

Sr.Business system Analyst/Scrum Master

Responsibilities:

• Involved in PI planning, Big room Planning and Scrum of scrums, Backlog Refinement meeting, Sprint planning, Daily Standup Meeting, sprint Review and Sprint Retrospective meetings.
• Conducted WAR sessions for brainstorming on the migration of the databases to AWS
• Conducted meetings to gather requirements as to which fields, tables need to be migrated
• Interacted with the stakeholders to get the reporting requirements based
• Assisted Product Owner and tech lead in RAPID roles and responsibilities
• Assisted with internal and external communication, improved transparency, and radiated information
• Helped creating the unified Remedy flow of tickets for the team across different modules
• Built relationship with Product owner and other stake holders to facilitate team's interaction with them
• Coached team members on Agile principles and providing general guidance on the methodology
• Continuously learned Agile/Scrum techniques and shared findings with the team
• Engaged with other Scrum Masters to increase the effectiveness of the application of Scrum in the organization
• Responsible for assisting different business users and QA team to create test cases and test plans.
• Ensured proper prioritization, sizing and scope of the backlog and help prepare stories to the right
• Strong relationship-building skills, creativity, organizational skills, exceptional communication capabilities, excellent verbal skills, strong multi-tasking ability
• Worked very closely with the product owner and business analysts to help team understand scope and vision.
• Used different Performance metrics to track the performance of the teams on JIRA.
• Tracked, measured, and reviewed project progress. This included adjusting plans and communicating changes.
• Assisted and trained teams in estimating the User stories, by using Planning Poker, T-shirt sizing, Relative Mass Valuation and bucket sizing.
• Worked with senior management to identify the resources required to successfully deliver on the project requirements.
• Continuously updated leadership team with weekly status of the progress by creating a new template to update the progress

Environment: Scrum, JIRA 7.13, MS Office (Word, Excel, PowerPoint, Outlook), Jedox, PBI, Looker,AWS

Confidential, Charlotte, NC

Sr. Business Systems Analyst

Responsibilities:

• Gained knowledgeof theMSRB, NYSE, SEC,Federal/State/Local Governmentprocedures regarding communications with the public
• Interviewed business users, stakeholders, Subject Matter Experts and performed extensive document analysis to develop a thorough understanding of end to end business processes
• Identified and mapped stakeholders to RACI (Responsible, Accountable, Consulted, and Informed) matrix to ensure smoother change process and to clarify roles and responsibilities in the cross-functional project.
• Conducting searches, gathering data, and recording evidence from internal systems and commercial databases
• Analyzed the required data and services both inbound and outbound and documentedAssumptions, Dependencies, Constraints, and Other Impacted Capabilities
• Worked with management team to map detailed current As-Is processes and To-Be processes for GAP analysis
• Drafted Out of Scope Items, Future State Considerations and Entry, Exit, Suspension, Resumption Criteria
• Identified workflows,Prepared, and documented the UML diagrams- Activity, Sequence, Use Case, Data Flow, and Created page mockups using Balsamiq.
• Created overview document for data conversion, data dictionaries, data mapping documents,detailed instructions, specification documents, pre-requisites, sample files, loader formats and business test cases.
• Implemented SQL queries to perform data validation, CRUD operations, joins, triggers, and stored procedures.
• Involved in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS).
• Assisted the teams in creating clear and concise epics and further breaking them into user stories. Actively participated in backlog grooming sessions throughout the sprint and ensured granularity of user stories.
• Designed and documentedREST/SOAPAPIs, including JSON data formats using Swagger.
• Worked on front-end and back-end Application Programming Interface (API) to define the functionalities of UI.
• Assisted the QA team to conduct functional testing, compliance testing, performance testing and assisted in development of thetest plan, test conditions, test cases.
• Extensively involved in Functional testing covering different formats of XMLs being developed to be sent to Proofpoint which will include the defined Policies, Reviewers and Rules as well as the Monitored Staff
• Expertise in usingTFSto open bugs, create tasks and user stories, initiate change requests.
• Strategized testing so that it is focused on validating that the policies are created for various business units and entities. Validation will be done to ensure that the rules and review teams have been assigned correctly in XML
• Provided a report that identifies when rule trigger volumes go up or down, in an amount outside of a specified tolerance during a period specified by the user
• Created solution driven dashboards using different chart types like Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau
• Actively Involved in defect triage, validated defects, updated status of defects with proper RCA.

Environment: Agile/Scrum, MS Office (Word, Excel, PowerPoint, Outlook), JBOSS,JIRA7.2,HPALM,REST /SOAP,SOA, XML, Java 8, Proofpoint, SSIS packages, MSSQL, TFS,Swagger,Balsamiq,Tableau 8.2,GITHUB

Confidential, Warren, New Jersey

Sr. Business Systems Analyst (AML, KYC)

Responsibilities:

• Acquired Knowledge ofthe Dodd-Frank Act, the Bank Secrecy Act, Financial Crimes Enforcement Network (FinCEN), Office of Foreign Asset Controls (OFAC) regulations, and Sarbanes-Oxley Act
• Captured the high-level requirements in Confluence and the same with JIRA to trace epics and user stories to high level requirements
• Performed the required KYC assessments on customers and documenting the information obtained on the client.
• Ensured compliance with all AML laws and regulations including OFAC, CIP, KYC, transaction monitoring.
• Coordinatedand managed investigations with BSA Compliance team on questionable accounts and transactions.
• Coordinated with Banking Team to collect and organize Know Your Customer (KYC) information for new and existing accounts, and review supportingdocumentation
• Involved in walkthroughs and meetings with development team to discuss related issues.
• Efficiently interacted with designers and software developers to understand application functionality and navigational flow and keep them updated about business user's specifications.
• Managed all the requirements effectively and made them available to all team members and presented the testing defects and resolution in the project review meetings.
• Analyzed workflows, Prepared, and documented the UML diagrams- Activity, Sequence, Data Flowusing ER Win
• Analyzing and reviewing name screening alerts to determine if the client is an SPF match to such alerts
• Developed tables, views, various SQL queries, stored procedures, functions.
• Examined, analyzed, and modeled Test plans Use Case Model cases & Test procedures
• Assisted the QA team to conduct functional testing, compliance tensing, performance testing and develop the test plan, test conditions, test cases.
• Managed Deliverables such as Software release planning, status reports, issue resolutions for implementation, and minutes of various meetings.
• Generated KPI reports on the data project and identified enhancement opportunities across products by creating dashboards, visualizations and reporting using MS Excel and tableau

Environment: Scrumban, JIRA 7.2,MS Office (Word, Excel, PowerPoint, Outlook), CitiSmart, Mantas, Citi screening, SAR Database,Confluence,Tableau, ER Win,Selenium IDE, HP QC, HP ALM,GITHUB

Confidential

Sr. Business Systems Analyst (Finacle Online Payment Processing System)

Responsibilities:

• Gathered requirements for development of new customized products for all the requirements coming in for various financial majors and banks which includes identification high-level business needs, PreparedDetail Requirement document (DRD), Screen field Design Doc, Preparation of Application Work Flow
• Identified new custom menus and enhanced existing menu options based on the requirements.
• Planed and devisedstrategy to complete the data mapping exercise for multiple legacy products used to create the initial data upload for application.
• Understood theUnderwriting Rules and Rating during Interview sessions with the stakeholders.
• Assisted the team in requirement gathering of modulesPages,Underwriting Rules, Non-Functional Requirements.
• Prepared the function flow of application; prepare the Page Mockups, utilized modeling techniques (business process, data) to discover & clarify the functional and data requirementusing USE case diagram and workflow/sequence diagramMS Visio
• Experience with Salesforce analysis, objects workflow and integrations.
• Experience in working with various data formats such as EDI, EDIFACT, XML, CSV, JSON, XML in Mule ESB.
• Good hands on experience using mule connectors like Database, FTP, FILE, SFTP, Salesforce.
• Created SQL queries like stored procedures, functions, joins and packages based on the client requirement
• Conducted end-to-end data validation of data flow and created theData Mapping Document,for defining data flow between data source and target, along with business rules
• Worked on data profiling& various data quality rules development using Informatica Data Quality.
• Creation of database objects like tables, views, materialized views, procedures and packages using various tools Wrote extensive SQL scripts for validating the data generated by the UAT's.
• Performed web services testing with SOAP UI by validating request and response for XML, JSON files.
• Full life cycle experience in Quality Assurance, including Black Box, system, integration, database, Data Migration, Interface, GUI, Functional, Regression, End to End, User Acceptance, Smoke testing of both client-server and web-based applications
• Involved in creation manual and automatedtestcases to increase regression coverage.
• Created testing data needed to execute manual and automated test cases using Data Driven Frameworks
• Create reports in Salesforce.com to meet operational requirements & maintaining a standard set of reports
• Experience in Customer & Partner portals, SalesForce.com sites in creating and customizing user interfaces to the customers and partners to resolve their enquiries.

Environment: Agile Scrum, Sun Solaris, Linux, IBM MQ, Java, C++, Finacle (Infosys), Salesforce, Tableau, Mule ESB, Oracle DB, selenium, JIRA, cucumber,MS Visio

Confidential

Sr. Business systems Analyst

Responsibilities:

• Knowledge of PCI-DSS Compliance and made sure procedures were adhered to the compliance.
• Conducted sessions, meetings, interviews with internal and global stakeholders and understood requirements from the business perspective and translated them into key deliverables such as SRS, FSD and BRD.
• Created sample files such as count files, store specific demographic files, movement files with continual interactions with SME’s
• Created Gantt Charts, WBS, critical path analysis, and project schedules and alignment using MS Project.
• Assisted in creation of data feeds (inbound and outbound data feeds), data models
• Experience in several facts of MDM implementations including Data Profiling, data migration, validation, reject processing and pre-landing processing.
• Implemented SQL queries to perform data validation, CRUD operations, joints, triggers, and stored procedures.
• Key participant in data services and API and webservice design activities by providing knowledge of the data domains and ensuring design addresses data usage needs across consumers
• Worked with the Quality Assurance team in validating Test Plan, Test Cases, Test Scenarios and Test cases.
• Conducted manual testing, automation testing, Smoke testing, Black Box testing, Regression testing and UAT in conveying testing standards and created test cases, test scenarios and test plans using HP QC,ALM.

Environment: Waterfall -Scrum, MS Visio, Informatica MDM, Red Hat JBoss Application Server, Red Hat JBoss Web Server, Red Hat JBoss BPM Suite, Informatica ETL, HTML5, CSS3, JQuery, Java Script, AJAX,JIRA,Confluence,Altova XML, SVN

Confidential

SOA Jr. Business System Analyst

Responsibilities:

• Created Business Requirements Document (BRD), Functional Specifications Document (FSD) and System Requirement Specifications (SRS) and design and development of use case scenarios.
• GeneratedUse Case Diagrams, Sequence Diagrams, Activity Diagrams, Data Flow Diagrams, Class Diagrams and State Chart Diagrams using Microsoft Visio
• Proficientlyanalyzed, designed and re-engineered system applications using established system analysis, business and system process design, Implementation of methodologies, Responsible for creating and reviewing business requirements, functional specifications, project timelines and planning, documentation, and test plans.
• Analyzed data/workflows; defined the scope. Verified and Validated Detailed Use Cases, Business Rules, Data Rules and Design documents.
• Fine-tuned SQL QuerieslikeEXISTS, HAVING,UNION ALLfor maximum efficiency and performance.
• Analyzed Business Requirements from Black Box testing perspective; reviewed Test Strategy, Traceability Matrices and Test Plans for the functional, performance requirements.
• Conducted functional walkthroughs, User Acceptance Testing (UAT) sessions, created user Manuals.
• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.

Environment: Waterfall,Oracle SOA/BPM Suite 11g/12c, Oracle BAM 11.1.X, OSB 11g/12c, WSDL, Oracle JDeveloper 11.1.1.6.0, WebLogic 10.3, XML, and Oracle 11g,Microsoft Visio,Oracle IAM,Rally,Altova XML,SVN,Sharepoint

Confidential

SOA Middleware developer

Responsibilities:

• Identified business services from business processes, Identified the possible impact of the Business triggers on the Business architecture and communicate same to the Architecture team.
• Decomposition of the Business Components (in different Business layers), into Business functions and further into Business Processes, which would represent the Business Architecture using SOA/AIA technology.
• Build processes around operational requirements and develop and maintain these processes to ensure applications supported meet compliance standards
• Developed technical design specification based on functional requirement from business users
• Developed, deployed asynchronous/synchronous, AIA/SOA Interfaces using adapters (JMS Queue, JMS Topic, File/FTP, and DB), partner links (WSDLs), process activities (Assign, While, Java Embedding) Implemented SOA/AIA Error Handling Framework
• Configuring and using Email Notifications in SOA and AIA to notify users of exceptions, errors, and success of records, Preparation of Unit Test Cases and performed unit testing
• Generated reports using business activity monitoring tool in oracle suite.

Environment: Waterfall,Oracle SOA/AIA Suite 11gR1, Oracle BAM 11.1.X, Oracle B2B,Oracle BAM,WSDL, Oracle JDeveloper 11.1.1.6.0, WebLogic 10.3, XML, and Oracle 11g,Oracle IAM,Rally,Altova XML,SVN,Sharepoint