PROFESSIONAL SUMMARY:

• Sr. Business Systems Analyst with 8+ years of experience in the Banking, Finance and Mortgage domains with a strong focus on planning, design, development and implementation of different business processes
• Experienced working in different System Development Life Cycle (SDLC) methodologies such as Waterfall, Scrum, Waterfall - Scrum hybrid, Scaled Agile Framework (SAFe) and Kanban
• Well versed with Commercial Banking, Wealth Management, ACH Systems, Payment Networks, Loan Origination Systems (LOS), Portfolio Management systems, and Securities (Stocks, Bonds, Derivatives, Mutual Funds, ETFs)
• Knowledge of Finance, Banking and Mortgage regulations & compliances such as Bank Secrecy Act (BSA) , US Patriot Act, Know your Customer (KYC) , Anti-money Laundering (AML ), CDD , SAR, PCI DSS, Sarbanes-Oxley Act (SOX), Equal Credit Opportunity Act (ECOA), Homeowners Protection Act (HPA), HOEPA, Fair Credit Reporting Act (FCRA) , BASEL Accords (I II III), Comprehensive Capital Analysis and Review, Dodd-Frank Act, and Gramm-Leach Bliley Act (GLBA)
• Highly Proficient in capturing requirements from business stakeholders using Elicitation Techniques such as JAD Sessions, Interviews, Document Analysis, Brainstorming, Interface Analysis, Focus Groups, and Prototyping
• Collaborated with Stakeholders, End Users, Business Owners, Product Owners, Project Managers, Scrum Masters, Tech Leads, DAs/DBAs, UI/UX experts, developers, QA/Testers, Product Managers and SMEs at various levels
• Familiar with Requirement, Change, Defect & Risk Management, Release Management and Project Management
• Expert in understanding the present state, future state and finding gaps using AS-IS, TO-BE and GAP analysis
• Assisted in drafting artifacts like Project Vision, Project Scope, Project Management Plan, Project Charter, Business Requirements Document (BRD), Functional Specification Document (FSD), System Requirements Specification (SRS), Risk Register, and Use Case Documents by communicating with various stakeholders
• Experienced in writing INVEST User Stories with detailed Acceptance Criteria and handling Requirement Churn
• Familiar with best practices like Behavior Driven (BDD), Test-Driven (TDD), Acceptance test driven development (ATDD)
• Participated in Scrum Ceremonies and meetings such as Backlog Grooming sessions, Sprint Planning, Daily Stand-Ups, Sprint Review and Retrospective meetings and efficient in using prioritizing techniques like MoSCoW, KANO analysis, Criteria Based Forced Ranking (Risk, Value, Effort, Dependency), User Story Mapping, and Walking Skeleton
• Experienced in analyzing business processes and modeling them using UML diagrams like Use Case Diagrams, Sequence Diagrams, Context Diagrams and Activity Diagram as well as BPMN models in Visio, Lucidcharts and StarUML
• Assisted in creating low and high-fidelity mockups and wireframes with UI experts using Balsamiq and Axure RP
• Knowledge on Salesforce Financial Services Cloud, Community Cloud, Services Cloud, Marketing Cloud and Analytics Cloud with a good grasp on SFDC concepts like Sandbox Orgs, APEX, Visualforce Pages and SOQL Queries
• Worked with Salesforce tools like Journey Builder, Process Builder, Email Studio, Schema Builder, and Content Builder
• Experienced in logical data modeling, conceptual data modeling and creating Entity-Relationship Diagrams (ERD)
• Highly proficient in Data Modeling, Data Mapping, Data Migration, Data Integration, Data Analysis, Data warehousing (EDW), Data Marts, Operational Data Stores (ODS), Visualization, Reporting, and Business Intelligence (BI)
• Experienced in Source System Exploration, Data Profiling, Data Validation, Master Data Management (MDM), Data Governance and developing Transformations for the extract, transform and load processes of the ETL pipeline
• Experienced in writing SQL queries to manipulate and validate data using Data Manipulation (DML) and Data Definition (DDL) commands as well as creating Stored Procedures, Functions, Triggers, Cursors and Views
• Wrote complex SELECT Queries with Clauses, Aggregate Functions, Subqueries and Joins for relational databases
• Extensive implementation knowledge of Databases (RDBMS, NoSQL), OLTP (Online Transaction Processing) systems and OLAP (Online Analytical processing) Operations such as Roll-up, Drill-down, slicing, dicing and pivoting
• Exhaustive understanding of Dimensional Modeling and Analysis concepts such as Facts, Dimensions, Grain, Star and Snowflake Schemas, OLAP cubes, MOLAP, ROLAP, HOLAP and Slicing, Dicing, Roll-Up, Drill-Down and Pivoting
• Worked on Reporting tools to generate Standard Static Reports, Ad-hoc Reports, Visualizations, KPIs, Write-Back Reports, Dashboards, Interactive MOLAP reports using Tableau, Power BI and Analytics Studio
• Knowledge of Client-Server model, Service-Oriented Architecture (SOA), Microservices, Serverless, Application Programming Interface (APIs), ESB, SOAP, RESTful, JSON, XML, XSDL, UDDI, WSDL, and OAuth
• Fair understanding of Cloud Architecture and Web Services with Amazon Web Services such as S3, Data Pipeline, DynamoDB, ECS, EC2, WAF, EMR, Direct Connect and Kinesis for computational and storage purposes
• Performed API endpoint testing using Postman and API-documentation using Swagger to capture the Headers, Query Parameters, Resources, GET/ POST response body and different error codes received
• Collaborated with QA Team in devising Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Data, issuing the Test Reports, and tracking requirements with the Requirements Traceability Matrix (RTM)
• Facilitated testing using Software Testing Lifecycle, Defect Lifecycle, Bug Tracking tools like HP QC/ALM and Selenium
• Experience in assisting and supervising Integration Testing, Regression Testing, User Acceptance Testing (UAT), Load/Performance Testing, Smoke Testing, Stress Testing and Sanity Testing

TECHNICAL SKILLS:

Business Skills: Change Management, Impact Analysis, Risk Management, Cost-Benefit Analysis, ROI Analysis, JAD Sessions, SWOT Analysis and Financial Reporting

Requirement/Project Management: Jira, Confluence, MS Excel, MS SharePoint, HP ALM, Rally, MS Project

CRM (Salesforce): Marketing Cloud, Service Cloud, Financial Service Cloud, Analytics Cloud, Lightning Connect, Schema Builder, Journey Builder, Apex, Visualforce

Waterfall, Waterfallscrum Hybrid, Agile: scrum, SAFe, XP

Modeling Tools: MS Visio, Balsamiq, StarUML, Axure RP, Lucidcharts

ETL Tools: Informatica Power Center, Informatica Cloud, AWS Data Pipeline

Data Marts, OLTP, OLAP, Multi: dimensional Analysis, ODS, OLAP Operations

Analysis, Reporting and BI: Tableau, Microsoft Excel, Analytics Studio, Power BI

Databases/DBMS: MySQL, PL/SQL, Oracle, AWS, MS SQL, Teradata

Defect Tracking/ Testing Tools: HP ALM/QC, Selenium, Jira, Load Runner, JMeter

Web Services and API Tools: SOAP, RESTful, XML, JSON, Swagger, Postman, SOAP UI, MuleSoft

WORK EXPERIENCE:

Confidential, San Ramon, CA

Sr. Business Systems Analyst

Responsibilities:

• Requirements gathering from the end-users and SMEs such as Salesforce Cloud experts, DBAs, Salesforce Admins, Personal Bankers, Advisors and Loan officers using elicitation techniques like JAD sessions, Interviews, Document Analysis, Brainstorming, Interface analysis and paper whiteboard prototyping
• Actively participated in scrum meetings and ceremonies like sprint planning meeting, daily standups, sprint review meeting, sprint retrospective meeting, backlog grooming sessions and release planning
• Assisted the Product Owner (PO) in identifying the MVP, writing and slicing User Stories and Epics, fleshing out Acceptance Criteria and defining the Definition of Ready (DOR) and Definition of Done (DOD)
• Participated in User Story Mapping and MoSCoW analysis of Product Backlog with PO to prioritize user stories
• Created Process flow diagrams to understand AS-IS processes and collaborated with team members to conduct Gap analysis based on the TO-BE process to map the future state based on end-user requirements
• Worked on Standard and Custom Objects, Formula Fields, Validation Rules, Workflow Rules, Approval Process, Process Builders, Permission Sets, Profiles and Field level security to help automate business processes
• Ensured that licenses for Salesforce CRM clouds were properly obtained and maintained by following all the rules, policies and guidelines of the client company as well as the Salesforce CRM
• Assisted in campaign development for customer onboarding in Journey Builder that mapped out the complete customer journeys which included Emails, Digital advertising and Promotional offers using Marketing Cloud
• Created mockup and wireframes for email templates, custom pages, reports, and cards using Balsamiq
• Integrated in-house and third-party web-services with Salesforce for KYC approvals, Credit Risk Checks and Customer Data Enrichment for cross-selling, up-selling, client onboarding and credit/loan origination processes
• Assisted in the Data Migration process to SFDC cloud from on-premise sources using Informatica Clouds real-time and batch streaming capabilities for initial data loads as well as Change Data Capture (CDC)
• Assisted in writing and documenting the transformation logic in the Data Mapping Specification Document
• Collaborated with team members in Customer Master Data Management (MDM) activities such as De-duplication, Matching, Merging, Cleansing and Reporting using Informatica Cloud platform to maintain a golden record
• Involved in testing APIs for streaming real-time transactional data into salesforce applications
• Conducted User Acceptance Testing (UAT) and actively participated and facilitated testing of the system during Smoke Testing, Sanity Testing, Integration Testing and Regression Testing
• Monitored progress of the overall project, tracked individual issues such as user stories, defects and technical debt using Atlassian JIRA, allowing for improved visibility of project status and accurate forecasts for project completion
• Created interactive Dashboards and reports using Analytics Studio to give branch managers, retail bankers, advisors and other end-users a full visibility into their book of business, activities, referrals and more
• Created and maintained Confluence spaces to add any impediments the team is facing and tagged the point of contact for the notification of required work from their part

Environment: Agile-Scrum, Salesforce CRM, Financial Services Cloud, Marketing Cloud, Community Cloud, Analytics Cloud, Oracle SOA suite, Informatica Cloud (Power Center & MDM), Journey Builder, Schema Builder, Salesforce Shield, Analytics Studio, Einstein Analytics, Apex, Visualforce, Email Studio, JIRA, Confluence, SOQL, Balsamiq

Confidential, Wilmington, DE

Sr. Business Systems Analyst

Responsibilities:

• Organized JAD sessions and Brainstorming sessions, prepared agenda and facilitated meetings with the SMEs, product owner & stakeholders to Elicit Requirements and Document outcomes
• Bridged the gap between functional and technical stakeholders through walkthrough sessions and requirements clarifications resulting in a significant reduction of risks associated due to communication gaps
• Worked with the Product Owner and development team in defining and negotiating a robust DOD (definition of done), definition of ready (DOR) and Acceptance criteria for user stories as well as Slicing user stories
• Developed understanding of Payments (ACH, RTP, P2P, Wire Transfers, and Credit), Data (Account Validation, Account Aggregation) and Foreign Exchange services using Process Models and Document Analysis
• Exposure to Banking Regulations and guidelines such as EU’s Payment services directive (PSD2), KYC, FinCEN, AML, PCI DSS, CFPB (12 CFR), Automated clearing house (ACH), OAuth 2.0, and TLS 1.2 for compliance and security
• Participated in Scrum ceremonies such as Sprint Planning, Sprint Review, Daily Scrum meeting and Sprint Retrospective as well as Backlog Refinement meetings and Release Planning Meetings
• Designed Data Flow Diagrams (DFD) and Context diagrams to visualize data flow between APIs, services and their consumers to glean Data Conversion, Encryption, and Data Aggregation requirements
• Designed wireframes and medium-to-high fidelity mockups using Axure RP for the API Development Portal
• Tested API Endpoints to validate the request/response for SOAP and RESTful services in XML/JSON format using HTTP methods like GET/POST to capture errors and validate data
• Developed API Documentation for newly developed APIs for internal and 3rd Party consumption
• Created Dashboards for API Monitoring using metrics such as Uptime, Number of calls, Latency, Response Time, and Response Types and API Usage/Growth tracking based on User Traffic and User Profiling
• Assisted in deploying builds to dev, test and prod environment while managing Bugs and Change Requests
• Conducted Functional demos for internal clients and 3rd Party users before going live to validate expectations and mitigate production risk

Environment: Agile Scrum, JIRA, Confluence, DevOps, BDD, Axure RP, MuleSoft, GitHub, Jenkins, JMeter, Selenium, Angular JS, Spring Framework, Java J2EE, XML, JSON, SOAP, REST

Confidential, Smithfield, RI

Business Systems Analyst

Responsibilities:

• Gathered requirements from Fund Manager, Portfolio Managers, End-users, DBAs, SMEs and Cloud Architects using interviews, JAD sessions, surveys and requirement workshops in User Story format
• Participated in Source system exploration, analyzing existing Front-end applications, middleware, Hadoop distributed file system and Mainframe Databases to come up with Migration Plans and Strategy
• Discussed and documented Technical User Stories from Cloud Architects, Data Stewards and SME’s through JAD Sessions and interviews identifying Data Mappings, Security, Data Quality/Governance requirements
• Acquainted with regulations and domain terminologies such as Asset Management, Securities, Securities and Exchange Commission (SEC), FINRA, 401(k), 403(b), IRAs, Dodd-Frank Act and Investors Protection Act
• Documented Business Process Workflows using UML diagrams such as Use Case and Activity diagrams
• Identified Source Data, Target data needs, performed Data Mapping, Data Profiling, Developed Governance Processes, Transformation rules and Business Rules to engineer AWS Data pipeline for ETL processes
• Assisted in setting up ECS on Fargate and used AWS Management Console for creating jobs and ordering Snowballs for migrating our on-premise data to the Amazon Web Services Cloud (S3, DynamoDB)
• Extensively used JIRA to capture & manage User stories and actively participated in all the Scrum Ceremonies
• Created high and low fidelity Mockups, Wireframes to prototype the enhanced User Interface using Balsamiq
• Created interactive Tableau dashboards and reports for analyzing and measuring Portfolio Performance using NAV, NPV, Asset Allocation, P&L, Market Benchmarks, P/E ratios, Risk Metrics and ESG Scores
• Assisted in System Integration tests (SIT), Non-functional Tests, Performance tests using JMeter, User acceptance tests and Alpha/Beta tests in testing and staging environments
• Exposure to AWS services such as Route 53, KMS, Macie, Shield, CloudFront, WAF, Direct Connect, S3, EMR, Secrets Manager, Aurora, DynamoDB, Kinesis, and ECS on Fargate, and API Gateway
• Assisted in the integration and testing of Bloomberg B-Pipe and MSCI integrations with the cloud implementation
• Kept track of bugs and defects using JIRA, maintained issue logs and handled the change requests efficiently

Environment: Agile-Scrum, MS Visio, JIRA, Swagger, Postman, Selenium, Hadoop HDFS, Amazon Web Services, DB2 Mainframe, JMeter, Angular JS, Java J2EE, Tableau, MS SharePoint, Balsamiq

Confidential

Business Systems Analyst

Responsibilities:

• Analyzed tuning rules on initial threshold values by reviewing existing alert quality and relevant data analysis of cash management, compliance division and anti-money laundering AML requirements
• Assisted in transaction monitoring scenario design, identifying initial threshold values based on customer segment and customer risk profile and maintained the list of high-risk customers base within Actimize
• Worked on UI by creating UML diagrams - Activity, Sequence diagrams and assisting the UI experts, Developers in designing user-friendly features (Component Selection, Data-entry Fields, Check Boxes, Drop-down lists)
• Gathered requirements for check balances and transaction history, search for transactions within the application, transfer funds, view your balances using Quick Balance, deposit checks electronically, pay bills, and find ATMs
• Directly involved in creating and baselining Business Requirement Document, assisted in drafting System Requirement Specification, and other artifacts while converting them into user stories during scrum sprints
• Developed Conceptual and Logical Data Models in collaboration and wrote SQL queries to validate data
• Tracked user stories, tasks and defects using Rally for development, deployment and maintenance of application
• Worked with testing team creating test cases, test data, test scenarios and conducting User Acceptance tests
• Worked closely with Project Manager and PO managing Change Requests doing change assessment and Impact analysis

Environment: Waterfall-Scrum Hybrid, Microsoft SQL Server 2012, SharePoint, LoadRunner, HP ALM/QC, Lucidchart, Rally, MS Project, Java J2EE, XML, HTML5

Confidential

Business Analyst

Responsibilities:

• Responsible for gathering and documenting requirements by understanding the reporting and analytical needs of functional users such as Sr. Business Analyst, Sales Manager and Market experts using BRD and SRS
• Assisted the Project Manager in identifying tasks and creating the Work Breakdown Structure (WBS)
• Tracked stakeholder requested enhancements and changes using the Requirement Traceability Matrix (RTM)
• Used Conceptual Data Models and Logical data models, identified entities, attributes, and relationships by referring to the Data Dictionary, Data Glossary and E-R Models for source exploration
• Involved in Data Profiling for source systems to comply with target system architecture and data quality needs
• Identified Facts, Dimensions and Grain to enable complex drill-down, roll-up, slicing and dicing OLAP queries for ad-hoc analysis and reporting
• Created Data Mapping Specification artifact to document Source to Target mappings including transformation rules, default values, and other business logic using MS Excel
• Developed Dimensional Models by Normalizing data for facts and dimensions tables in the Hybrid Schema using Star and Snowflake schemas for optimal query performance and storage utilization
• Aided developers in migration plan, design, build testing and conducted User Acceptance tests to validate the analytics and reporting requirements throughout different stages
• Used PL/ SQL scripts and queries for data validation as per the requirements of the mapping document
• Developed Reports and Dashboards using Power BI to serve as a DSS for BI/BA activities

Environment: Waterfall Methodology, Teradata, Power BI, Informatica PowerCenter, Oracle, StarUML, MS Project, MS Word, CVS, MS Excel

Confidential

Jr. SQL Developer

Responsibilities:

• Co-ordinated with team members in Data Assessment, Integration, Modelling, Visualization and Reporting activities to enable insightful analyses leading to improved forward-thinking strategies
• Generated KPIs and Visualizations packaged in interactive Dashboards to the management on a weekly basis
• Queried data with SELECT Statements using complex joins, where, group by, order by, having clauses, subqueries and aggregate functions to meet the reporting and validation needs of Business and Technical teams
• Wrote complex SQL Queries, Views, Triggers, Stored Procedures, Functions and Indexes using DDL, DML and DQL commands to implement business logic
• Involved in data migration from different sources such as CSV files, Flat Files, Excel Spread Sheets and relational databases to build a central cloud repository (Data Mart) for reporting
• Designed periodic reports, static dashboards as well as ad-hoc reports using Tableau

Environment: Waterfall Methodology, MS Excel, MS Word, MS Project, Oracle, Oracle Data Integrator 11g, MySQL 5.6.5, Clear Case, Tableau 7.0