PROFESSIONAL SUMMARY:

• Qualified IT Business Systems Analyst professional with 8+ years of experience in Banking Domain.
• Knowledge of core banking systems such as Loans, ACH, Checking, Savings, Online and Mobile Banking.
• Knowledge of Anti Money Laundering efforts and Know Your Customer & Enhanced Due Diligence.
• Exposure to regulations & compliance such as Dodd - Frank, FACTA, FDCPA, CFPB, US PATRIOT Act, Bank Secrecy Act & Know Your Customer and Enhanced Due Diligence, Sarbanes-Oxley (SOX) Act .
• Proficient in planning, designing, capturing, consolidating and maintaining key metrics with Agile and Scrum.
• Knowledge of SDLC (Software Development Life Cycle) phases, including concept proposal, analysis, planning, requirement gathering, design, development, integration, testing, deployment, support and maintenance.
• Worked and exposed to enormously various Agile-lean and traditional software development environments including Agile-scrum, Scrumban, RUP and Waterfall methodologies.
• Conducted detailed project analyses such as GAP analysis (AS-IS & TO-BE), risk review & assessment, Impact assessment, Cause and effect analysis (root cause analysis), effort estimation, mitigation plan, maintenance of risk register, Cost-Benefit analysis, SWOT analysis & Feasibility study.
• Used MS Project & MS Excel in Scheduling, Allocation of Resources, Gantt-Chart View Creation, WBS (Work Breakdown Structure), Critical Path Analysis, Budgeting, and End-To -End task & Milestone Tracking.
• Strong project management skills in Planning, Scheduling, Monitoring and Budgeting with experience in requirement elicitation such as Brainstorming, JAD sessions, Job shadowing, Survey/Questionnaire, One-To-One Interviews, Prototyping, Requirements Workshop, Document / Interface analysis and Focused Group Sessions.
• Proficiency in documenting artifacts such as Business Requirements Document (BRD), Functional Requirement Document (FRD), Software Requirement Specification (SRS) & Requirement Traceability Matrix (RTM).
• Efficient in handling change requests and assessing change through impact assessment on triple constraints.
• Created User stories adapting INVEST criteria and acceptance criteria Given-When-Then method) for an iterative and developmental model of application with the help of Scrum Master & Product Owners.
• Created, maintained and assisted the Scrum Product Backlog items, Definition Of Done, Definition Of Ready, breaking down, sizing of stories, tasking the requirements to the scrum team to achieve goals.
• Participated in Sprint Planning (WHAT & HOW meeting), Daily Stand Up, Sprint Execution, Sprint Review & Sprint Retrospective Meetings, and followed disciplined SCRUM framework, guidelines and rules for successful releases.
• Assisted product owner in prioritizing User stories using MoSCoW, KANO model, 100 Point method, Value Stream Mapping, Business Value Based, Ranking method and Walking Skeleton.
• Documented in sprint execution: user roles, workflow descriptions, user interface, storyboards, and prototypes.
• Created Use Case specification document comprising actions, pre-conditions, post-conditions, triggers, happy, unhappy paths, assumptions, constraints and business rules for different positive & negative scenarios.
• Proficient in developing Behavior UML (Unified Modelling Language) Diagrams like Sequence Diagrams, Activity Diagrams and Use case diagrams using Lucid Chart, Rational Rose and MS Visio.
• Designed UI/UX by Mockup and Wireframe diagrams for requirements to show the visual modelling of business processes and getting an understanding of Application Under Development (AUD) through prototyping methods.
• Created Conceptual and Logical data models and proficient in developing Entity-Relationship diagrams for defining dependences and identifying relationships between key entities within the system.
• Proficient in artifacts creation of Data Dictionary, Data Glossary and Data Mapping Specification document.
• Experience in SQL queries for Data Analysis, retrieval, validation, modification. Data Manipulation Language (DML), Data Definition Language (DDL) & Data Control Language (DCL), Views, Stored Procedure and Functions.
• Sound knowledge of Relational Database Management System (RDBMS), Object-oriented programming, Business Process Re-Engineering, & Business Intelligence tools such as Tableau, SSRS for reporting needs.
• Experienced in creation of Data Warehousing, Data marts, OLAP (MOLAP & ROLAP), (Slicing & Dicing), and OLTP.
• In-depth knowledge in implementation of dimensional data modeling (Star & Snowflake schema), Dimensions, Facts data modelling, Data aggregation, Data mapping, Data integration & Application migration.
• Performed ETL process for transformation of data sources into one integrated system (Transformation performed include Sorter, Filter, Source Analyzer, Aggregator, Joiner, Lookup, Stored Procedures, Expression and Router).
• Understanding HTTP request to web service, to specify REST API CRUD operations having HTTP verbs-GET, POST, DELETE and PUT -on application layer that utilized POSTMAN as the powerful HTTP client to test web services.
• Facilitated end-to-end Web Service testing on SOAP & REST API through Swagger Tools & POSTMAN.
• Assisted in performing Black Box, Manual, Unit, System, Performance, Load, Stress, Regression, Automated, Functional, Non-Functional, UAT, Smoke and Sanity Testing of applications with knowledge on STLC (Software Testing Lifecycle) by creating Test plan, Test Scripts, Test cases, Test Scenarios, Test reports and RTM.
• Dealt with stakeholders, change, conflict, vendor & risk management and problem-solving techniques.
• Documented Standard Operating Procedures, Manual, Checklists (Ask questions), Quality Assurance Plan.
• Experienced in bug tracking and following up for successful maintenance & delivery of service tickets using JIRA.
• Engaged actively in creating reports such as feature progress reports, performance reports and ad-hoc reports.

TECHNICAL SKILLS:

SDLC Methods: Waterfall, Agile-Scrum, Scrumban, RUP

Project Management & Business tools: MS Project (v 2010,2013,2016), MS Office v 2010,2013, 2016 Office 365 (MS Word, MS Excel, MS PowerPoint, MS Access, MS OneNote, MS Publisher, MS Visio), SharePoint, Atlassian JIRA (v 6.4,7.3), Confluence (v 6.1,5.9).

Testing: HP Quality Center, HP UFT/QTP (v 14.02), HP LoadRunner 12.60, Cucumber v 2.2.0, QA Touch

Statistical tools: Minitab (v 18.0), MS Excel (2013, 2016, Office 365).

Web services: SOAP API, REST API, XML, JSON, Swagger Tools, SoapUI, POSTMAN.

Database Tools: Microsoft SQL SMS (Server Management Studio), MySQL.

Reporting Tools: Tableau 9.1, QlikView v 11.20, SSRS, IBM Cognos, SnagIT, Swipr, Visual Paradigm ERD.

ETL Tools: Informatica Cloud, Informatica PowerCenter, SSIS &SSAS.

UI Development: MS Visio, Mockup Screen, Balsamiq mockups

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, Ohio

Sr. Business Systems Analyst

Responsibilities:

• Worked in Agile- Scrum Framework environment facilitating documentation, validation, requirement elicitation and elaboration, stakeholder analysis and other business processes related optimization activities.
• Acted as a liaison between business stakeholders, clients, managers and Technology Teams.
• Conducted Gap analysis and Cost benefit analysis to determine the effects & performance of new features.
• Requirements elicitation regarding functionalities including check loan balances, withdraw money, make a onetime extra payment, change periodic payment amount, transaction history.
• Worked on JIRA for running scrum-boards, maintaining backlogs, grooming user stories and organizing sprints .
• Assisted in estimating requirements and Product backlog items and supported in creation of User stories & Acceptance Criteria along with Product owner for Sprint releases, prioritized PBI and involved in Sprint Planning, Daily Stand Ups, Execution, Reviews and Retrospective meetings.
• Assisted Development/Scrum team in creating Minimum Viable Product (MVP) as an early adopter.
• Designed UI/UX by Mockup and Wireframe diagrams for requirements to show the visual modelling of business processes and getting an understanding of Application Under Development (AUD) through prototyping methods.
• Performed SQL Queries to extract data from different sources, verify, validate & modify using various commands.
• Collaborated with the Development/Scrum team in preparing test data for positive and negative test scenarios as per application specifications; writing test plans and performing functional, smoke and end-to-end testing.
• Facilitated meetings and conducted Regression Tests, UAT testing and support functions.
• Work extensively with AWS technologies that support automation using Cloud formation to create EC2 instances, ELBs, Macie, Kinesis, Simple Queue Services (SQS), Cloud-Security (IAM) .
• Created data mapping document after considering data sources and considering business requirements.
• Facilitated in the creation of the Conceptual and logical diagrams behind multidimensional OLAP of the database
• Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries .
• Performed ETL testing, data validation, data partitioning, data quality checks, data transformation testing, data cleansing, data profiling and other data cleaning activities.
• Coordinated in creation of ER Diagram defining entities, attributes, relationships, according to BI requirements.
• Created and maintained dashboards for reporting the behavior of consumers using the application system to determine using Tableau for business analytics (factors chosen: age, gender, date, occupation, marital status, region, annual income, credit score worthiness, occupation and spending power).
• Ensured Definition of Done has been met along with other criteria for each User story of the Sprints.

Environment: Agile / SCRUM, JIRA 7.3.1, Confluence 6.1.0, Tableau 9.1, Balsamiq Mockups, MS Office Suite (Word, Excel, PowerPoint, Visio), Informatica 9.6, QA Touch, MySQL Server, SnagIT (Snapshot tool)

Confidential, New York City

Sr. Business Systems Analyst

Responsibilities:

• Interacted with users and stakeholders to Identify business needs, evaluated solutions for business problems .
• Gathered business requirements by participating in JAD sessions, interviewing business users and stakeholders , conducting one to one session and consulting existing systems documents.
• Analyzed problem details through one to one meeting with Data architect, Enterprise architect & Solution advisors .
• The methodology used for the project was Waterfall and had a deep understanding about the requirement gathering . Provided clear and consistent information about project status both internally, IT team and stakeholders .
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams . Understood the AS-IS system, developed the TO- BE system concepts and prepared the System Process Maps .
• Prepared Business Requirement Document (BRD/HLD) and Drafted Systems Requirement Specification (SRS). Analyzed, modified and validated these documents.
• Developed Conceptual and Logical ER diagrams for the database. Created Data Dictionary for the data models .
• Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing .
• Identified Source systems for financial data profiling of the legacy system and integrated various OLTP to the OLAP by using SSDT-BI as an ETL and reporting tool. Also maintained the Bill Inmon and Ralph Kimball Paradigms .
• Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity to maintain accuracy and effectiveness of data.
• Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries .
• Played a key role in the planning, testing, and implementation of system enhancements and conversions .
• Used ETL to map data and assemble data repository and created data marts .
• Used Data Center for Integrating Legacy systems and supporting in decision making .
• Assisted in creating Data Marts with Bus Architecture and implementation of Integrated Data Warehouse with individual data marts to address areas of business interest .
• Assisted with snow-flake schemas in the Dimensional model architects to providing business rules .
• Understand the Software Development Life Cycle and experience in system architecture mapping .
• Designed and developed all Use Cases and UML models using MS Visio .
• Proficient in creating Use Cases, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams & Class Diagrams .
• Assisted the Project Manager in setting realistic project expectations , in evaluating the impact of changes .
• Establish Incident Reporting and Change Control procedures .
• Developed timelines for project delivery , and managed projects and resources to successful completion .

Environment: SDLC, Waterfall, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), Swipr, MS Project, MS SQL 2008, SSDT-BI, SSIS, SSRS, Visual Paradigm ERD, HP LoadRunner.

Confidential, Phoenix, Arizona

Business Systems Analyst

Responsibilities:

• Strong understanding of the Dodd-Frank Act, Bank Secrecy Act, Know Your Customer (KYC), Financial Crimes Enforcement Network (FinCEN), Office of Foreign Asset Controls (OFAC) regulations, and Sarbanes-Oxley Act.
• Captured the high-level requirements in Confluence and JIRA to trace epics and user stories .
• Performed 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 .
• Coordinated with Banking Team to collect, organize KYC information for new and existing accounts, review supporting documentation . Involved in walkthroughs and meetings with development team to discuss issues.
• Analyzed a company's financial statements , business model , and industry to develop business strategies .
• 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 testing defects and resolution in the project review meetings . Analyzed workflows , and documented the UML diagrams like Activity, Sequence, Data Flow using ER Win Data Modeler and Created page mockups using Balsamiq .
• 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.
• Created Data Mapping documents for tables and columns stored in the database after coordinating with the development team, business users, subject matter experts, project manager and stakeholders.
• Involved in API documentation for REST/SOAP using Swagger tools and documented XML request and responses .
• Analyzing and reviewing name screening alerts to determine if the client is an SPF match to such alerts.
• Wrote and executed SQL queries to perform various types of analysis like data analysis, data validation and data manipulation using different types of Joins, Subqueries and Aggregate functions .
• Used SQL minus queries to make sure that the extraction process did not provide duplicate data or redundant data in the source and all unnecessary columns are removed as per the business requirements .
• Examined, analyzed, modeled Use Case & Test procedures . Assisted the QA team to conduct functional testing, compliance testing, performance testing and develop test plan, test conditions, test cases .
• Managed Deliverables such as Software release planning, status reports, issue resolutions for implementation, and minutes of various meetings.
• 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 and generated KPI reports using Excel.

Environment: Scrum, Word 2013, Excel 2013, PowerPoint 2013, Outlook, Swagger tools for API, JIRA 6.4.13, Confluence 5.9.3, Tableau 8.2, ER Win, Selenium IDE and Selenium Web driver, Cucumber v 2.2.0, SQL Server.

Confidential

Business Analyst

Responsibilities:

• Determined User, Business and Functional Requirements .
• Preparation of HLD, LLD and their reviews.
• Created and assisted in vision, scope, and use case documents, Use Case Diagrams, and Activity Diagrams .
• Utilized RUP to configure and develop process , standards , and procedures .
• Performed GAP and Risk Analysis of existing system and evaluated benefits of new system.
• Conducted Joint Application Development (JAD) sessions with stakeholders throughout SDLC to resolve open issues.
• Experienced in Analyzing Feasibility and risk analysis to identify the business-critical area from the user perspective
• Worked with gathering requirement from stake holders and Subject Matter Expert (SME) by interviewing them, also prepared questionnaires and received their feedback.
• Performed SQL queries operation such as DML and DDL commands for data extraction and manipulation .
• Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT) .
• Coordinated work plans between project manager and client using MS Project .
• Created documentation for and Help Desk teams.
• Production release Coordination & Implementation support.
• Documentation of production support related procedures, tips and best practices .

Environment: Waterfall, MS Word, MS Excel, MS Visio, SQL, Oracle, Rational Unified Process (RUP), Rational Doors, Rational Clear quest, Rational Rose, SharePoint, HP QC.

Confidential

Business Analyst Associate

Responsibilities:

• Networked with Subject Matter Experts, Project Managers and Process Analysts to understand the business process gather Business Requirements and identified enhancements.
• Facilitated various sessions like JAD and JRD with various Subject Matter Experts.
• Assisted to author functional requirements and business requirement documents & provided them to QA team.
• Used HP QC for allotting task and issue tracking, user story management and requirement traceability.
• 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.
• Produced visual models for the application using UML MS Visio to create Use Cases, Sequence Diagrams.
• Collaborated and negotiated with stakeholders in defining project scope boundaries.

Environment: Waterfall, MS Visio, MS Office Suite, MS Access, SQL version, Informatica, IBM Cognos, Outlook, HP Quality Center.

Confidential

Junior Support Engineer (Internship)

Responsibilities:

• Supported the network and systems engineer with activities, solutions and other responses to request for service.
• Performed basic testing, firewall configurations, resolving network issues and configuring operating systems.
• Used remote desktop connections to provide configuration and administrative support.
• Used email and chat applications to give clients quick answers to simple IT issues.
• Responded to user requests for service, troubleshooted problems and helped develop solutions.
• Supported PC hardware components, desktop operating system software, and application software.
• Performed minor repairs to equipment and arrange for other servicing needs; identified and reported system issues to vendors, monitored and tested resolution of those issues sent to vendors.