Business Analyst Information Systems

Abhijit Dhoat

San Jose, CA

*************@*****.***

Contact number :-469-***-****

Summary:

11+ years of experience in the field of Information Systems with emphasis on Business Analysis. Focused on banking Domain. Experienced the height of achievement and recognition by stepping into the world of Technology and Management.

Strong knowledge of SDLC methodology and project life cycle, including Analysis, Design and Re-view of Business and Software Requirement Specifications.

Utilized AWS tools (like Amazon Redshift, Athena, or QuickSight) to analyze and visualize data, providing insights to drive business decisions

Experienced in MS Dynamics 365 CRM Customer Engagement with knowledge in Banking and Financial Services domain

Extensive experience in managing project requirements, which includes requirement gathering, requirement rating/analysis and requirement priority assignment.

Extensive experience in gathering User and Business Requirements and creating Business Requirement documents (BRD), Functional Requirements (FRD), Technical Requirement (TRD), Logical De-sign, Change Request Process, Use Cases, Scope document, Contingency Plan.

Collaborated with stakeholders to gather and document business requirements related to AWS projects, ensuring alignment with organizational goals.

Manage projects related to payment solutions, utilizing Agile or Waterfall methodologies for successful delivery

Managed the implementation and customization of Microsoft Dynamics 365 to align with business processes and enhance user experience

Proficient in Microsoft Windows, Word, Excel, PowerPoint, MS Visio, Enterprise Architect, Requisite Pro

Extensive experience with Unified Modelling Language (UML) and proficient in creating Use Case diagrams, Sequence Diagrams, Activity Diagrams

Developed and conducted training sessions for end-users, ensuring successful adoption of Dynamics 365 features.

Analyzed payment processes and recommend improvements to enhance efficiency and compliance with FED, CHIPS, and SWIFT standards.

3+ years of experience within the E&S and/or Admitted P&C insurance market serving in a Business Analyst capacity

Experience working with CMS's/editorial workflow processes, Atlassian software (JIRA, Confluence) or delivering solutions across mobile/website/tablet is very desirable

Strong Background in Capital Markets, Wealth Management, Residential/Commercial Real Estate, Credit/Market Risk, Whole Loans, Trading Systems, ETFs, Fixed Income, Equities, FX Options & Prime Brokerage, IHC/CCAR Regulatory Reporting, Risk, Compliance, Fraud detection, AML processes.

Mapped and optimized business processes, identifying areas for improvement through Dynamics 365 functionalities

·Experience in Conducting Joint Application Development (JAD) sessions, Elicitation sessions, workshops, and interviews sessions with Subject Matter Experts (SMEs)/End Users/Development Groups/Clients, asking detailed functionality aspects of business process and carefully updating the information to the requirements in an easily understandable format.

Skills:

Agile/Scrum, Requirement Scoping, MS Project, MS PowerPoint, MS Visio, Load Runner, Quality Center, Wireframes, SQL, Microsoft SharePoint, Oracle, Activity Diagram, BRD’S, FRD’S, Gap Analysis, Pivot Tables, RUP, Context Diagrams, JAD, MS Excel, MS Access, UML

Education:

Bachelors of Software Engineering, McMaster University

Professional Experience

Mphasis/ PenFed - Dallas, Texas (Remote) Nov 2017 – Feb 2024

Business Analyst

This project is aimed to re-engineer the Payment services Framework for Pentagon Federal Credit Union (PenFed). The new system is designed to perform various Fedwire and FedACH transactions with the core objective to support multi-tenancy by developing individual but interdependent payment engines and payment hub which effectively handle majority of administrative and compliance requirements for payment processing with limited manual intervention.

Gathered Business, Functional and Use Case Requirements for Automated Clearing House (ACH) outgoing transactions.

Analyzed user requirements, procedures, and problems to identify reuse opportunities of existing application components and data elements, system interdependencies, possible gaps, and risks.

Created and managed dashboards and reports to track key performance indicators, facilitating data-driven business strategies.

Collaborated with IT teams on integration projects, ensuring seamless data flow between Dynamics 365 and other systems.

Developed workflow diagrams, flow charts and Data Flow diagrams for structuring / modelling the ACH business flow using MS Visio.

Worked with technical teams to design solutions that utilize AWS services, ensuring they meet business needs and adhere to best practices

Configured and customized Dynamics 365 applications to align with organizational processes and enhance user experience.

Analyzed data within Dynamics 365 to deliver actionable insights and support strategic decision-making

Ability to collaborate with management, product strategy and product development teams on vision, strategy and program design.

Documented functional and business requirements in collaboration with the product development team.

Ensured adherence to ISO 20022 messaging standards across all payment formats, including FED, CHIPS, and SWIFT

Worked with capital markets, MBS Securities, investment risk and return, portfolio management and retail banking industry.

Maintained comprehensive documentation of AWS architectures, processes, and changes to support ongoing operations and knowledge sharing.

Developed and maintained CRM strategies to improve customer engagement and drive sales performance

Created and refreshed all long-lived documentation on Confluence wiki.

Extensive knowledge using Confluence – To manage the requirements.

Currently working as a SME on Capital Markets Domain.

Led the implementation of FGPP, ensuring seamless integration with existing systems and workflows.

Participated in data analysis process, designed and created data mapping documents.

Reviewing and updating functional requirement documents use cases, scope change documents and mapping specifications.

Quantitative analysis for business operation and financial performance of commercial/investment bank.

Researched investment-grade debt securities and asset management tools, created strategies for sales and trade

Familiar with file formats and NACHA rules related to ACH, IAT, Prenotes and Microdeposits.

Involved in maintaining Requirements Traceability Matrix.

Analyzed customer data and CRM metrics to generate insights and inform decision-making, contributing to targeted marketing and sales strategies

Managed large scale technical and non-technical projects in the areas of Branch Operations, consumer Lending for a credit union.

Exceptional operational knowledge of Loan IQ in the commercial lending domain and the syndicated/bilateral/agented deals.

Possess thorough knowledge and navigation of Loan IQ application. Worked in close relation with other applications of the corporate & commercial lending division such as LTS Lite, Livelink and APMS.

Defined and track key performance indicators (KPIs) to measure the success of AWS initiatives and make data-driven recommendations.

Created test cases and led user acceptance testing (UAT) to ensure system configurations met business needs

Project managed and supported all applicable Regional Credit Cards/ Deposits/Loans.

Defined and delivered the pricing strategy for Deposits/Retail Lending in the ECR by working closely with the segment pricing, formulates pricing logic, rules and controls that support the delivery of the strategy.

Served as Branch Operations and Consumer Lending department representative on Navy Federal's Business Analysis Community of Practice.

Wrote Stored Procedures and T-SQL queries and functions for all the database operations.

California Bank and Trust, San Diego CA Jan 2016 – Oct 2017

Business Analyst

Gathered Business, Functional and Use Case Requirements.

Worked with SME for drafting standard operating procedures for various LOBs.

Conducted JAD sessions and continuously worked under time-intensive project deadlines and targets.

Conducted change request meeting and documented issues and performed impact analysis.

Analyzed user requirements, attended change request meetings to document changes as per user’s request.

Experience in Capital Market pertains to Market Data with in depth knowledge in Stocks, Bonds, Options, Futures, Forwards, Swaps, Etfs, Mortgage-Backed Securities, CDS and CDO's & pricing of all financial instrument.

Used Requisite Pro to document requirements, associated change requests with requirements and linked requirements with Use cases.

Collaborated with stakeholders to gather and document business requirements for Dynamics 365 implementations.

Provide training and support to end-users on FGPP functionalities and payment processing systems

Assisted in development and implementation of JDE functional modules according to project plans.

Implemented procedures for configuration of JDE systems as per recommended set up.

Performed UAT testing of vendor test and client support reports generated by MicroStrategy tool and validating them using SQL queries against the IRRS database.

Worked with capital markets, MBS Securities, investment risk and return, portfolio management and retail banking industry.

Acted as a liaison between technical teams and business stakeholders, ensuring clear communication and understanding of project goals and progress.

Collaborated with cross-functional teams to integrate Dynamics 365 with other systems, streamlining workflows and improving operational efficiency.

Lead modeling efforts within group of process-oriented Web Developers and Business Analysts in defining business and operational requirements for electronic file /Enterprise Content Management ECM system modernization initiative.

Expertise in financial systems and the ability to work with system vendors to execute on process improvements. Experience with Insurance Industry investment accounting packages such as CAM-RA or PAM (Pledged Account Mortgage) preferred

Treasury finance and risk management duties with exposure to the business of FX trading, investments.

Drafted Requirements and Data mapping to deliver clean and confirmed trade transactions, cash flow and collateral data and capability to produce Federal reserve report 2052A.

Lead optimizations and management of regulatory data requirements for secured funding transactions (FR 2052a).

Exceptional operational knowledge of Loan IQ in the commercial lending domain and the syndicated/bilateral/agented deals.

Managed change initiatives related to Dynamics 365, supporting smooth transitions and user adoption.

Responsible for preparing the existing SQL platform for upgrades that were installed as soon as they were released.

Documented Test Scenarios and Test Case after reviewing the business & system requirements.

Designed and developed Use Cases, Sequence Diagrams, and Collaboration Diagrams using MS Visio and Enterprise Architect in order to clarify the online data access management.

Support the Enterprise Architect in creation of technical specifications for integrations between the different systems deployed in the overall end solution.

Vancity Bank, BC, CAN Jun 2014 – Dec 2015

Business Analyst

Provide project planning, milestone management, scope management, resource forecasting; financial management; change management across the project portfolio

Planning, Reporting, Document Management, Financial Management, Stakeholder Management, RAID management, Change Request Management

Work with the PMO Manager to develop the frameworks and standards for Programme and Project Management

Develop and maintain the TA PMO project management toolsets and assist users to overcome challenges within work requests or projects

Ensure a consistent set of Portfolio Management standards are developed and applied to all work streams of work

Experience transforming large, complex, unstructured data into denormalized star or snowflake schemas

Practical knowledge of modelling methodologies for analytical data repositories (including Snow-flake, Star-Schema)

Providing effective management support to project teams on small to medium sized projects, or assisting Project Managers on streams of other large projects.

Providing guidance and working with project and program managers with outcome-based performance reporting for program boards

Worked with AML SME’s provided direction and guidance to employees on appropriate remediation action for high-risk accounts.

Acted as a liaison between technical teams and business stakeholders to facilitate effective communication and project alignment.

Works in collaboration with Business Teams and other internal partners to manage the credit insurance portfolio

Assesses and evaluates requests for new credit in support of the business teams on marginal risk accounts, large dollar exposures and unusual credit scenarios

Engaged project sponsors and facilitated discussions; worked with stakeholders to facilitate user acceptance testing, change management and project implementation.

Formulating and managing project plans by defining deliverables, identifying key milestones, re-viewing project progress, and engaging in ongoing risk management.

Perform Dynamics 365 configuration and customization based on the functional requirements.

Developed training materials and provide support to users on AWS tools and applications, facilitating smooth adoption.

Worked with Data Integration developers to develop Data Integration Workflows and load ETL processes. Mapped existing and target state architecture, data events and data flows.

Coordinated the activities across different teams such as product management team, development team, QA team. Conduct weekly status meetings, tracked project tasks, issues regularly, conducted Gap Analysis.

Extensive Experience with Continuous integration tools (e.g. GitHub, TFS, Jenkins), Cloud (e.g. Amazon Web Services, Azure ), Monitoring/alerting tools.

Provided training and support to end-users, ensuring effective utilization of Dynamics 365 features and functionalities.

Monitored and ensured compliance with data security and privacy regulations within the CRM system.

Managed multiple key IT initiatives by establishing testing processes, framework, testing tools and testing procedures.

Utilized internal Microsoft Access database for verification and populating purposes concerning inventory and different asset management needs.

Communicated with business users to prepare and update Business Requirements Document (BRD) and Functional Required Document (FRD) and Specifications

Involved in Requirement Gathering and analysis by interviewing users, application owner and SME's.

Expertise in Business Process Modelling and Use Case Modelling using Unified Modelling Language (UML).

Consolidated Billing and Loan Statement: Worked as lead BA for consolidated billing and the loan statement for all line of business for BMO corporate & commercial clients. This project-involved gathering of the business requirement for consolidated billing and loan statement and E2E testing. As a part of this project enhancements to pre-existing billing interface were performed this includes NCP/Mail bill and E-mail statements.

Participate as a key team member in the full cycle of requirements gathering, design, configuration and implementation of enhancements to HFM.

Planned & conducted JAD sessions and finalized Business Requirements & prepared Functional Specifications.

Assisted in the test plans for (SIT) System Integration Testing and User Acceptance Testing.

Designed, developed and tested ETL scripts using Oracle PL/SQL, SQL to extract, transform and load data from OLTP database EOIS CAMS which bases on Curam modules to Data warehouse.

Involved in project scope meetings with the Pricing manager to understand the type of requests and issues handled by the pricing team and documented the high-level business requirements to the product backlog using JIRA

Involved in Joint Application Development sessions with SMEs and development teams and documented functional business requirements as product backlogs using JIRA.

ING Direct, Toronto CAN Jan 2013 – May 2014

Business Analyst

Project Description:(Online/Mobile banking) ING Direct Online is a web based secure application allows business user to maintain banking transaction and make real-time account transfers wire transfers and ACH payment processing. This feature allows you to require one user to initiate a payment and a second user, with a second set of credentials to approve the release of a payment.

Gathered and documented the requirements that are critical to the business mission and using those requirements to design application software.

Interacted with the “Users” by interviewing them, by preparing questionnaire and getting feed-back.

Working in Agile environment, documented Test Scenarios, and Test Cases after reviewing the business requirements, design document, use cases, and technical specifications documents.

Accountable for populating the asset management database with accurate configuration, location and lifecycle information.

End to End experience in designing and deploying data visualizations using Tableau

Assist in the design, implementation, testing and training of the Enterprise Resource Planning (ERP) system and other finance related systems for transaction processing or analysis

Oversees the profiling of data from different sources and determines whether and how data can support business and data requirements of its intended use.

Acts as primary business data ex-pert on SBU and select Enterprise data repositories and business system data flows.

Communicates the findings and serves as focal point in understanding the business data and managing business unit expectations.

Continuously updated knowledge of Dynamics 365 features and best practices to drive process optimization.

Analyzed AWS usage and costs, providing recommendations for optimizing spending and resource allocation.

Consults on product implementations and modifications impacting repositories and provides primary support for project request documentation, CAT testing, and daily monitoring of stored data

Wrote, designed, and implemented User Interface (UI) design procedures that assisted with UI Prototyping, Interactivity and Animation, Adaptation to All Device Screen Sizes, and Implementation with the Developer.

Constantly evaluate Ecommerce opportunities and make recommendations to optimize performance

Involved in the development and implementation of various technology projects that not only benefited both internal and external clients but also required extensive project management of both groups

Enhanced the client experience by more closely integrating diverse technical documentations and processes to provide a more consistent, high quality service delivery experience.

Performed requirement analysis, development and implementation for ERP Systems

Responsible for documenting User Guides, Release Notes, Configuration Guides, Deployment Documents and Technical Notes for the entire product suite

Provide estimation, risk assessments, resource planning, and preparing test strategy, following up on the development progress, issue prioritization and resolution, project/testing scheduling, coordinating implementation, defect reporting, managing sign off.

Managed Performance & Operability testing phases across multiple lines of business - Distribution Technology, Capital Markets- FX & Wealth Management, Mobile Applications

Working with consultant during the implementation of Microsoft Dynamics 365 for Finance and Operations & CRM (Road Map, Analysis, Design, Development, Deployment, Operation) Collabo-rated and strategized on the purchasing the most cost effective and productive assets for the company engineers and employees.

Assisted in developing cloud strategies that leverage AWS services to improve efficiency, scalability, and cost-effectiveness.

Supporting Finance, Procurement, Sale, CRM, HR, Payroll and Time Attendance functional area.

Responsible for the accuracy and availability of populated asset information in the asset management database in Microsoft Access, ensuring compliance to client standards.

Contact this candidate