SUMMARY:

• Qualified Business Systems Analyst with 8+ years of experience in successful delivery of high - quality IT solutions in Banking Domain . Used analytical and critical thinking to solve a wide variety of critical business problems.
• Contributed to all phases of Software Development Life Cycle (SDLC) in multiple projects by working with the Business Users, Key Business Stakeholders, Subject Matter Experts (SMEs), Project Managers (PMs), Scrum Master, Product Owner, Architects, Testers, Developers, analysts and delivered end-to-end business solutions by facilitating important meetings. Worked in traditional Waterfall and Agile Methodologies such as Scrum , Scrum-Waterfall.
• Knowledge of various regulatory acts such as Financial Intelligence Centre (FIC) Act, Bank Secrecy Act, Dodd Frank Act, Sarbanes Oxley Act, Basel I, II, III, FinCEN, Office of Foreign Assets Control (OFAC) and compliances such as Anti Money Laundering(AML), Know your Customer(KYC), CIP, Customer Due Diligence(CDD), Financial Action Task Force (FATF), The Federal National Mortgage Association (Fannie Mae) and The Federal Home Loan Mortgage Corporation
• Strong experience in requirement elicitation techniques like Brainstorming, JAD Sessions, Document Analysis, Interviews, Focus Groups, Job shadowing, Interface analysis, Requirements Workshops & Marketing Analysis.
• Extensive experience in creating Screen Mock-ups & Prototypes , conducting Gap Analysis , Impact Analysis , SWOT Analysis , Cost-Benefit Analysis , Risk Analysis , Root Cause Analysis , Feasibility Study and Return on Investment.
• Created several artifacts such as BRD (Business Requirements Document), FRD (Functional Requirements Document), SRS (Software Requirements Specification) and RTM (Requirements Traceability Matrix).
• Comprehensive knowledge in Risk Identification , Risk Assessment , Risk Mitigation , Quantitative Risk Analysis and Qualitative Risk Analysis and Acquisition Plan. Assisted PM in developing Project charter and Project Plan .
• Competent in creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams , Activity Diagrams, Collaboration Diagrams, Data Flow Diagrams and Sequence Diagrams in MS Visio.
• Strong understanding on Big data concepts and tools such as Hadoop consisting of two components HDFS (Hadoop Distributed File Systems), MapReduce and libraries such as Apache Hive , Impala, Flume , Sqoop for analysis and Apache Mahout for Machine Learning algorithms. Have knowledge of using Hue browser to monitor jobs frequently.
• Extensive knowledge about Salesforce CRM platform and earned several badges on Salesforce’s Trailhead .
• Participated in Scrum ceremonies including Backlog Refinement , Sprint Planning , stand up meeting , Sprint Review and Sprint Retrospective and experience in Prioritizing Techniques like MOSCOW, KANO and Estimating Techniques like Planning Poker, Relative Mass Valuation, T-shirt Sizing and Bucket Sizing.
• Assisted product owner with the Definition of Done (DoD) and Definition of Ready (DoR) for backlog items.
• Helped with the story mapping process in Agile after elicitation and documentation of requirements (user stories).
• Facilitated Release Planning sessions for the product, assisted all the teams in writing business epics. Helped in the sizing and estimation and prioritization of epics by helping SMEs performing SWAG Analysis.
• Experienced with issue creation and resolution using Atlassian JIRA. Facilitated the team and created Scrum artifacts like Product Backlog and helped define the User Acceptance Criteria, MVP (Minimum Viable Product) and MRF (Minimum releasable features) to assist with an overall release and feature plan for the products.
• In-Depth Knowledge of the processes involved in creating data warehouse and data-marts and data lakes.
• Hands on experience in writing and executing SQL queries using Data Definition Language (DDL), Data Manipulation Language (DML), DQL & DCL statements to perform CRUD operations on database and experience in executing queries like Joins, Subqueries and Aggregate functions. Good understanding of Procedures, Functions and Triggers.
• Created Source to Target Data Mapping documents indicating the source tables, data types, transformations required and business rules to be applied using Informatica. Knowledge of Data Mapping, Integration and Migration.
• Knowledge of the implementation of dimensional data modelling including the star and snowflake schema, dimension and fact tables and the various OLAP operations like slice, dice, roll-up and drill down.
• Experienced in creating Entity Relationship diagrams, Conceptual and Logical data models.
• Proficient in using tools like Informatica PowerCenter, Tableau, SSRS (SQL Server Reporting Services) and QlikView
• Managed ETL (Extract, Transform and Load) testing, data cleansing, transformation testing, data profiling in databases
• Assisted in performing automated test scripts to test APIs to check if data returned is in JSON, XML format as defined in the API documentation using Swagger Tool to execute the scripts during deployment or during manual testing.
• Experienced in 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 and Test Analysis reports .
• Knowledge in Test Driven (TDD), Behavioral Driven (BDD) and Acceptance Test Driven Development (ATDD).
• Experience in creating analytical Business Intelligence (BI) dashboards using Tableau, IBM Cognos.

TECHNICAL SKILLS:

SDLC Methodologies: Waterfall, Agile-Scrum, Waterfall-Scrum hybrid, XP, Spiral.

Business Modelling and Designing Tool: MS VISIO, Balsamiq, Lucid Chart, Adobe XD.

Project Management & Business Tool: MS Project (2010, 2013, 2016), MS Office, Office 365, JIRA, SharePoint, HP ALM, Confluence.

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

Database & Data Analysis tools: MySQL, MS SQL server, HDFS, Tableau, Oracle 8/9/10, DB2, MS Access, Informatica Power Center 9.6.1, Apache Sqoop, Apache HBase, Hive QL, Apache Mahout, R, Python.

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

Language: Core Java, Java Script, C#, HTML, XML, SQL

Defect Tracking/ Testing Tools: HP QC, Load Runner, POSTMAN, Soap UI, Cucumber, Selenium, HP ALM, Swagger.

Salesforce Clouds: Sales Cloud, Service Cloud, Financial Services Cloud, Marketing Cloud.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Senior Business Systems Analyst

Roles / Responsibilities:

• Assisted the Product owner in interviewing Subject Matter Experts in Credit score and bureau reporting along with employees to get a thorough understanding of business processes & analyzed the data structure, hierarchy and re-mapping and Verified compliance documents for customer KYC and customer due diligence and baselined them.
• Supported the Product owner by assisting in creating project plans, developing the project workflows, creating scope documents along with the process of scheduling and tracking project timelines.
• Created Wireframes , Graphical user interface (GUI) Mockups using Balsamiq and Adobe XD . Created Evolutionary and Throwaway prototypes to explain the end to end system using Invision Studio.
• Extensively used Jira for converting requirements to User stories , assisted the Product Owner in writing acceptance criteria and framing Definition of Done (DOD) for the PSPI that was presented to the users.
• Assisted Data analyst in identifying data sources and identifying exclusion or fraud accounts which will not be used for development purposes. Aided Data analyst to identify compliance with data governance rules.
• Performed CRUD operations in SQL & stored procedures using SELECT & JOIN for drill downs to pull data while being actively involved in reading data from varied file types, created standard and ad-hoc reports using SQL.
• Used Cloudera distribution for Hadoop eco-system and its various libraries like Apache Hive, Pig, Mahout, Spark etc.
• Assisted the Sqoop architect to create batch integration through the API Calls by using Plug-ins and aided the Hadoop Data Engineers in monitoring and documenting the health of the Hadoop clusters at regular intervals.
• Analyzed and logged the Metadata of Hadoop using Mphasis platform. Monitored jobs on Oozie dashboard in Hue.
• Assisted Data engineers in Data querying from Hadoop clusters for MapReduce jobs using querying in Hive QL.
• Used Apache Sqoop, Flume for data extraction from Oracle & NoSQL databases. Used Apache Mahout for analytics.
• Responsible for documenting RESTful API calls from external and internal data sources using Swagger for data ingestion into Hadoop clusters through Apache Sqoop . Tested the functionality of API endpoints using Postman .
• Created Use Case diagrams , Use Case Templates, Process flow diagrams and Data Flow diagrams using MS Visio .
• Assisted in creation of Test Cases , Test Plans , Test Scenarios , and updated Requirements Traceability Matrix . Assisted testing team in UI testing and documented the defects in the ALM , conducted API testing using POSTMAN and used ALM to Manage Defects/Bugs and Test Cases that can be rectified later.
• Conducted User Acceptance Testing (UAT) and actively participated and facilitated end to end testing of the system using Runtime Manager with the help of QA and the entire testing team and delivered the product.
• Used Cloudera Hadoop to connect data to Tableau with the Hive server and created Ad-hoc or analysis reports minimizing the time required for data visualization and reporting dashboards .

Environment: Agile-Scrum, MS Visio, MS SQL server, MS Project, Office 365, JIRA 7.9.2, Confluence 6.4, Tableau 10.5.2, Postman, Swagger 3.5, Cloudera manager, Apache Hadoop, Apache Sqoop, HP ALM, KYC, CDD, FICO.

Confidential, Wilmington, Delaware

Senior Salesforce Business Analyst

Roles / Responsibilities:

• Performed requirement walkthrough to understand and address the advantages of implementing the new system.
• Analyzed the existing system by implementing the Gap Analysis and created the AS-IS & TO-BE documents to address the areas of improvement and enhancements to address the system capabilities and needs.
• Performed Cost & Benefit Analysis , Feasibility Analysis to understand the net benefit and the feasibility.
• Used JIRA for converting requirements into user stories and Confluence for defects tracking, organizing and collaborating teams for meetings and emails.
• Assisted in the implementation of the Salesforce CRM to facilitate the development of the cloud-based Business Banking Console that would manage customer data and help bankers to recommend solutions to the customer.
• Used Salesforce Lightening Platform for Application Development.
• Participated in various Scrum ceremonies, helped PO to review the the Definition of Done and Acceptance Criteria.
• Actively participated in the transition process to the SFDC including the Design, Development, Planning, testing and integrating the Cloud services in SFDC for customer data management and enhancing the user experience.
• Identified the accounts and contacts of existing customers, leads and opportunities in source databases, source csv files and along with data team mapped them to the corresponding new records/fields on target Salesforce clouds.
• Built ER Diagrams as a part of cloud computing to visualize different entities and their relationships within the banking system and assisted the data team to migrate data from MySQL and Oracle databases onto the Salesforce CRM cloud using Dell Boomi, Data Loader and identified the corresponding records/fields.
• Used Salesforce Einstein Analytics on the customer data that would assist the bankers to identify the highest priority referrals based on the intelligent scoring.
• Assisted the QA team to develop the test plan and test cases to perform the testing and involved in Automated User Acceptance Testing (UAT) to ensure that the business requirements were being addressed in the test.
• Assisted the Quality Assurance team in performing functionality testing, reliability testing, and utility testing on the API web-services using tools Postman and Swagger .

Environment: Agile - Scrum, Salesforce, Einstein Analytics, Community, Salesforce App Exchange, Windows 10, MS Office, Swagger, MS Visio,SOAP UI, JIRA 7.0, MS Project 2016, SharePoint 2013, Web Services, XML, SOAP, JAVA, REST, TABLEAU 8.2, MS SQL Server 2012, HTML, CSS, HP QC 10.0, Confluence 5.9.5.

Confidential, Warren, New Jersey

Business Systems Analyst

Roles / Responsibilities:

• Captured the high-level requirements in Confluence and JIRA to trace epics and user stories.
• Conducted Gap Analysis by highlighting the differences between the AS-IS and TO-BE model and developed the project requirements based on that.
• Coordinated with Banking Team to collect and organize KYC information for new and existing accounts, and review supporting documentation. Involved in walkthroughs with development team to discuss related issues.
• Conducted periodic AML risk-based review on individual and business accounts and highlighted high-risk jurisdictions, cash intensive/high risk businesses and Politically Exposed Persons (PEPs) accounts.
• Created page Mockups using Balsamiq and designed Activity Flow Diagrams , Use Case diagram , Sequence Diagrams using UML Business Process Modeling in MS Visio which aided in the understanding of the business user.
• Created technical requirement, functional and system specifications, project schedules using MS Project .
• Assisted the teams in creating clear and concise epics and further breaking them into 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 managers and stakeholders.
• Involved in API documentation for REST/SOAP and documented XML request and responses. Tested the functionality of API endpoints and Bulk REST API calls using Postman and SOAP UI .
• 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.
• Assisted the QA team to conduct UI Testing, functional testing, compliance tensing, performance testing and develop the test plan, test conditions, test cases using HP ALM.Performed checks against World Check Risk Screen, FinCEN list, and OFAC Specially Designated Nationals List (SDN) and Blocked Persons list to identify any potential discrepancies that can be corrected before going live. Also Executed View SQL queries with different Where Clauses in Views for reports to AML Compliance Office.

Environment: Agile-Scrum, JIRA v6.4, Confluence v5.9, MS Visio, MS Project, REST API, Word, Excel, PowerPoint, Outlook, Oracle Database, SOAP UI, SharePoint 2013, Web Services, XML, JAVA, HTML, CSS, HP QC/ALM.

Confidential

Business Systems Analyst

Roles / Responsibilities:

• Assisted in generating a streamline process to understand the various steps in the Loan Lifecycle and desired functionality of the new system by interacting with users, SMEs, stakeholders, lenders, underwriters.
• Identified and analyzed needs for various functionalities by using various techniques such as Document Analysis, Focus Groups, and Interviews with Subject Matter Experts (SMEs) and project stakeholders.
• Performed GAP Analysis by understanding the AS-IS business process and TO-BE business process and created Business Process Model and Notation (BPMN) document using Microsoft Visio.
• Assisted in elaboration of epics into user stories in Product Backlog Grooming Session so that stories are granular.
• Developed several activity and sequence diagrams with swim lanes and UML components to show entity relationship diagrams (ERD) using Lucid chart and Microsoft Visio for the developers and data architects.
• Prepared the function flow of application; by creating High fidelity Wireframes and MockUps using Balsamiq.
• Conducted end-to-end data validation of data flow and created the Data Mapping Document, for defining data flow between data source and target, along with business rules and assisted ETL developers to prepare ETL routines to conduct the process.
• Written 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 on Oracle 12c DB.
• Used Tableau 9.1 to generate credit check reports and application status reports.
• Designed API technical document and conducted API designs sessions to understand their functional features of REST, HTML, XML using Postman and worked on developing API integration documentation using Swagger.
• Worked with the QA team for validating Test Plan and Test Cases for Integration testing, Regression Testing, Whitebox Testing, black Box Testing, Smoke Testing and assisted in facilitating User Acceptance Testing (UAT).

Environment: Agile-Scrum, MS Office, MS Visio, MS Project, Share Point 365, Balsamiq, Magento 2.0, HP ALM, Web Services, REST, SOA, HTML, XML Web Method WSDL, Tableau, Oracle 12c, SQL, Postman, Swagger, JIRA, Confluence.

Confidential

Business Analyst

Roles /Responsibilities:

• Extensively involved in gathering requirements and writing technical designs document and process flows.
• Conducted focus group session to discuss communication & interaction between MDM & data warehouse followed up by JAD session involving the end user to record the requirements & expectations & came up with a prototype.
• Arranged meetings with architects and SME’s about implementation procedures and documented runbook.
• Kept track of the shared resources such as system architect and created Work Breakdown Structure accordingly.
• Migrated and reviewed data from heterogenous sources like various databases, flat files by working with data management team and developed Master File from multiple sources for sound data governance.
• Created Process Flow Diagram to represent source to target mapping of the data from source to ODS and to EDW.
• Defined Data Profile, data migration, validation, Integration and match rules tuning.
• Generated Conceptual & Logical model document defining entities & attributes with datatypes, cardinalities & relationships.
• Identified all the Dimensions and Facts and designed Snow-flake schema for the Centralized Data Warehouse.
• Defined the Landing Tables, Staging Tables and configured the base objects, foreign-key relationships, custom Cleanse Functions, match and merge settings, lookups & queries according to the business logic and requirements.
• Assisted in data mapping and integration by using the different transformations like joiner, filter, expression, sort, aggregator and look up in the Informatica Power Center along with creating Mapplets.
• Involved in Batch job error debug and handling, Batch jobs design, Batch Group design, schema exports- imports using metadata manager and conducting data team workshops helped in documentation & reporting.
• Worked closely with reporting team to ensure correct data is presented in the generated reports using tableau
• Major tasks included architecting end to end solution for sourcing Customer data from sources using Informatica Power Center and to feed the cleansed, consolidated and integrated Customer data to Data warehouse.

Environment: Waterfall scrum hybrid, Informatica Multidomain MDM 9.7.1, Informatica Power Center 9.6Tableau, Oracle, SQL.

Confidential

Quality Analyst/ Tester

Roles/ Responsibilities:

• Reviewed System Requirement Specifications (SRS), Functional Requirement Specification (FRS) & design documents.
• Designed & documented Test Plans, Test Scenarios, Test Cases based on business requirements & design documents & logged defects in HP ALM.
• Prepared Test Data for positive and negative test scenarios for functional testing using boundary value analysis and exhaustive testing as documented in test plan.
• Validated the database using various SQL queries like Joins, group by & SQL Aggregate queries for data profiling.
• Prepared Requirements Traceability Matrix (RTM) to help the stakeholders trace the requirements.
• Documented Bug Report and Categorized them based on severity and Priority.
• Used Quality Center to store all test results and for defect tracking and reporting.
• Provided weekly management status reports and coordinated meetings between test team and development team to review defects and track them to closure. Created Macros which helped in enhancing the reports.
• Took part in all phases of testing; Smoke testing, Graphical User Interface (GUI), Functional testing, System testing and Regression testing and support User Acceptance Testing (UAT).

Environment: Waterfall, MYSQL Server, HP QC, MS Office (MS Excel, MS Word).