APOORV NAGACHARI

BUSINESS ANALYST

E-mail Id: adnxuc@r.postjobfree.com

Contact No: 347-***-****

PROFESSIONAL SUMMARY:

* ***** ************ ********** ** Business Analyst, Business Process Analyst & Scrum Master with strong knowledge of Banking, Financial industry, AML/KYC, and Risk Compliance.

Experienced in Investment Banking projects specialized in Financial Markets, Capital Markets, Wealth Management, and Risk Management.

Experience in managing and implementing business process modeling and requirement management in large financial systems.

Solid experience in SDLC Methodologies, Agile and Waterfall.

Experience in working with business users and documenting and reviewing business documents such as Software Requirement Specifications (SRS), Business Requirements Document (BRD), Functional Specifications Document (FSD), Use Case Specifications, and Requirement Traceability Matrix (RTM), Product Backlogs.

Solid Experience in Collection, Analyses, Documentation of User Requirements, as well as Organizing interviews, User meetings, Workshops and JAD sessions

Proficient in creating Use Cases, Use Case Diagrams, Sequence Diagrams and Activity Diagrams using Rational Rose and Microsoft Visio.

Consistently performed GAP Analysis, SWOT Analysis, Risk Analysis, Impact Analysis and Cost/Benefit Analysis.

Skilled in identifying the data requirements, preparing Data flow diagrams, Data analysis and Data mapping, Process mapping.

Applied the "As Is" and "To Be" process designs to identify any potential process gaps and as well as improvement opportunities.

Knowledge of Mortgage Loan Origination, Servicing, Closing, Loss Mitigation, Loan Modification, Appraisal, Credit, Income

Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modeling and Design.

Strong organizational and planning skills, ability to work well under pressure, result-oriented, self-motivating and versatile in problem solving.

Skillfully used techniques like interviews, surveys, workshops and JAD sessions by using design modeling tools like Microsoft Visio.

Consulting of upgrading/additional technologies including Google Cloud, Tableau, and AWS.

Proficient with Business Analysis tools such as designing wireframes (Balsamiq), JIRA, and GitHub

Insurance experience includes Personal Property & Casualty and Commercial Automobile Product knowledge, Reinsurance for Auto, Billing, Claims and Home Insurance Systems.

Experience in the Informatica/ ETL (Extract, Transform and Load) of data into a data warehouse/data mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).

Providing field level mapping of elements between front end and Duck Creek needed in the service/API.

Setup the Salesforce org, customize the app, create users, profiles, roles, and permission sets, perform data loads. Work closely with average of 8 clients to extract business requirements and apply Salesforce best practices.

Assisted development team in ETL technical tasks such as Development and Testing ETL tools like Informatica and SSIS.

Prepared the Requirement Traceability Matrix for Tracking, Documenting, Capturing, Managing and Communicating the Requirements.

Expertise in developing Test Plan, Test Conditions, and Test Cases; ensuring adequate testing on software both before and after completion; conducting and documenting UAT.

Experience in writing queries for Data analysis using SQL.

Excellent Written & Verbal communication skills.

TECHNICAL SKILLS:

Business Modeling Tools: MS Visio, MS Word, MS Excel, MS PowerPoint, Outlook express, MS Project.

Software Dev Methodologies: Agile, Waterfall & Hybrid.

Testing tools: Quality Center/ALM, Quick Testing Professionals, Clear Quest

Requirement Managerial Tools: Requisite Pro, Doors.

Database: MS SQL Server, MS Access.

Language: SQL, .Net, Java, HTML

EDUCATION:

Pace University, Seidenberg School of Computer Science, and Information Systems

New York, NY

Master of Science (MS) in Information Systems Concentration: Business Analysis December 2019

Maharashtra Institute of Technology, Savitribai Phule Pune University Maharashtra, India

Bachelor of Engineering (BE) in Computer Science 2015

PROFESSIONAL EXPERIENCE:

Client Name: BNY Mellon, New York, NY Oct 2020 - Till date

Role: Senior Business Analyst/Scrum Master

Project Scope: The scope of this project was to provide real-time access to the bank’s corporate institutional account information, including deposits, interests, account activity and investments/ Fixed Income/Brokerage Analysis, turning off the existing components and functionalities and replacing them with new additions. The project was undertaken to enhance the existing functionality of convenient access to real-time account information, ability to download account information, option to enroll staff or service providers (e.g., corporate accountant, auditor, or financial advisor) along with addition of new reports.

Roles & Responsibilities:

Gathering requirements from stakeholders to customize solutions, such as new page layouts and or buttons.

Involved in designing business requirement collection approach based on the project scope and SDLC Methodology.

Facilitated with product owner for prioritizing the user stories and creating repositories of the user stories in the product backlog.

Facilitated requirements gathering by having meeting with SMEs and other work streams.

Actively took responsibilities of business requirements by providing functional support to Dev & QA teams.

Worked as primary contact person for managing changes to project requirements by administering the change management processes.

Perform data analysis, systems requirements gathering, and data migration between Salesforce, AWS, and other business systems.

Extensively contributed to Development, Design, Testing, Deploying and Maintaining Data Warehouse and Data Marts using tools like Informatica Power Center and various third-party tools.

Working with the backend data retrieval team, data stewards, data mart team to guide the proper structuring of data for Power BI reporting.

Create User Stories from stakeholders' requirements and translate those into a technical design document for the ServiceNow team to develop.

Mentor and empower business SME's in PRPC. Customized SharePoint site templates and menus

Tracking this test case execution on day-to-day basis. Logging and tracking the bugs found during this execution phase using ALM defect management tool and JIRA.

Drafted and documented business requirements and initiate kick off meeting with the team after business sign off.

Managed the successful planning, execution, monitoring and delivery of multiple projects and depending on teams.

Used brainstorming sessions and questionnaires to guide the team of business analysts to gather business requirements and translate them to technical requirements to be used by Developers, QA, and external testing teams.

Conducted Joint Application Development (JAD) sessions with stakeholders.

Interfaced with Various staff to ensure that requirements will be complaint with existing and foreseeable standards for future development and movement to a new platform. Developed process flows for current state and future state processing.

Knowledge of functional concepts of Risk Management focusing on Credit Risk, Operations Risk and Market Risk.

Align operational procedures and processes with AML Program objectives to mitigate the exposure to money laundering risk.

Using information gathered from the stakeholders; produced various artifacts such as use-case specifications, software requirements specifications, screen mock-ups, workflow, Functional Specification Documents, use case/diagrams and activity diagrams.

Maintained ongoing communication with back-end developers ensuring that modifications and requirements were addressed in a time manner and monitored all revisions.

Environment: Agile-Scrum, Rational Enterprise Suite (Rose, ClearCase, ClearQuest), GitHub, Visual Basic, MS Project, MS Visio, SQL, SQL Server, SailPoint, Salesforce, ServiceNow, Tableau, AWS, MS Visio, Services, Power BI.

Client Name: Lincoln Financials, Radnor, PA Feb 2020 – Oct 2020

Role: Business System Analyst

Project Scope: The project involved developing a platform for aggregation of financial data, we receive the daily transactional data (withdraw, deposit, loan, payment) from all branches at the end of the day and cleansed, transformed and aggregated in the Enterprise DW. We had to validate the transactions and implement the business logic based on the transactions type or transaction code. Generated various reports based on cash flow and transactions.

Roles & Responsibilities:

Gathered requirements by conducting brainstorming, interviews, JAD Sessions with Bank heads and SME are to understand the needs of the application. Performed feasibility study, SWOT analysis and cost benefit analysis.

Documented requirements and created Project artifacts such as FSD (functional specification document), SRS (software requirement specification) and RTM (Requirement Traceability Matrix).

Gained extensive working knowledge in Data analysis, profiling, governance, and conversion.

Analyzed business processes, requirements, and data necessary to provide detailed logic for ETL development.

Instrumental in developing Use Cases, Use Case Diagrams, Activity Diagrams using MS Visio.

Worked on Transaction Monitoring of Data Quality and Data Lineage of Key Data Elements, from each data source.

Assisted project manager in developing a plan, assigning resources to tasks, tracking progress, and analyzing workloads using MS Project tool.

Worked closely with Data Architects in development of High-level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems.

Helped Reporting analysts in developing drill-through, parameterized reports, Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports in SQL Server Reporting Services (SSRS).

Created Validation queries (SQL) for testing of ETL workflows using ETL mapping document.

Gathered requirements for Client-Side Validation, and Server-Side. Created Test Plans, Test Cases, Test Scenarios and conducted Functional/Non-Functional Testing.

Assisted QA team in Testing calls and responses to various REST API’s and documented them using Swagger.

Prepared UAT test document and Test Scenarios for validating the Business requirements and uploaded Test scenarios mapped Business requirements to Test scenarios and updated defects and defect tracking in HP ALM.

Environment: Agile, MS Project, MS SQL Server 2012, SQL Server Integration Services (SSIS) ETL tool, SSRS, SQL Server, T-SQL, Flat files, MS Word, MS Excel, MS Visio, MS Access, MS Project, SQL, HP ALM, Wireframes, Pencil, Gap Analysis, Swagger, UAT Testing.

Client: Barclays, Wilmington, DE Oct 2018 – Nov 2019

Role: Business Analyst

Project Scope: The project principally concentrated on incorporating payment processing services platform with the current framework and integrating the information from various departments into a consolidated stage with the assistance of Informatica ETL tool. This provides point-to-point encryption benefits on all POS contraptions such as Card swipe, E-check terminals, and exchange points of interest. The new highlights decreased complexities to manage various records, allowed remote check deposit through online applications, and less demanding invoicing and payroll workflows.

Roles & Responsibilities:

Directed high-level requirements gathering sessions with Business Owners, Users, Departmental Heads, SME’s, and end customers for elicitations by means of JAD sessions, Interviews, Surveys, Focused Groups, and Brainstorming Sessions.

Produced business cases, functional specifications, data validation mapping, SRS, BRD, FSD, non-functional specifications, use cases, RTM, mockup Screens and user stories for web and mobile application changes and enhancements.

Experienced in Enterprise Business Analysis, Process Workflows, Change Management, Requirements Management, Software Usability, Information Architecture, Risk Management and maintaining SLAs.

Created technical debt backlog, collated, and tracked defects, and communicated defects to development team.

Conducted PCI-DSS Business and IT Security Gap Analysis, by suggesting PCI credit card processing gap remediation.

Prepared GAP analysis and Risk analysis via Document Analysis and Interface Analysis to understand the new business model and additional functionalities to be incorporated in agreement with the online processing compliances.

Created Use-Case diagrams, Activity, Sequence diagrams, Data Flow Diagrams, ER Diagrams using Bizagi Modeler.

Led ETL workshops to comprehend requirements for Data Warehouse Design (Extraction, Transform and Load) activities on the databases and worked closely with the Product Owner for master data management.

Worked with integration services for exchanging and assessing data from disparate sources like Excel, CSV, flat files, and Text Format Data and integrating them into data marts. Implemented SQL queries to perform basic CRUD operations.

Integrated the various OLTP to the OLAP by using Informatica as an ETL tool.

Conducted manual testing, automation testing, Smoke testing, Black Box testing, Regression testing and User Acceptance Testing (UAT) in conveying testing standards and created test cases, test scenarios and test plans using HP QC ALM.

Developed Dashboards that provided reports related to transaction details, customers details, patterns recognized, social media details, customer account details with the use of various matrices utilizing Tableau.

Environment: Scrum-Waterfall hybrid, HP QC, JIRA, MS Visio, Java, HTML, XML, OLAP, OLTP, Tableau, SQL Server 2013, Informatica MDM, JDBC, ODBC, Apache Tomcat Application Server, Apache Tomcat Web Server, Informatica ETL.

Client: Invesco, Mumbai, India June 2017 – July 2018

Role: Business Analyst

Project Scope: The project was to build an Enterprise Reporting system for the performance analysis of the credit card system in use. This further supported the portfolio management services of the bank.

Roles & Responsibilities:

Facilitated meeting and arranged JAD sessions with business users for requirement gathering.

Performed requirements analysis, formulate, and define systems scope and objectives through user needs and an understanding of business systems and industry requirements.

Developed documentation for various stages of the Software Development Life Cycle (SDLC), including Functional Designs and Test Cases. Provided functional support and guidance to application changes.

Served as a liaison between business team and the project team by assisting the business in identifying, understanding, and documenting their business needs and requirements.

Created AS-IS and TO-BE business process flow diagrams, integrate process flow diagrams to show end-to-end business model including swim lanes for the elicited business requirements.

Responsible for preparing Software Requirement Specifications (SRS) and Functional Requirement Specifications and performing Gap Analysis to check the system compatibility with the new requirements.

Created use cases and designed use case diagrams class, sequence diagrams and activity diagrams.

Used SharePoint for content management and document management. Assisted in gathering requirements for the GUI (Graphical User Interface) Screens and designing mockup screens using Balsamiq.

Added and configured various transformations like lookup, derived column, data conversion, aggregate, conditional split, merge, row count, and union, select and join pertaining to data.

Environment: Hybrid, SQL Server 2008, SQL Server Integration Service (SSIS), SQL Server Reporting Services, Waterfall, MS Office, MS SharePoint, MS Excel, MS Access, UML, Balsamiq

Client: Try catch Tech, Mumbai, India May 2015 – June 2017

Role: Jr. Business Analyst

Roles & Responsibilities:

Involved in documenting the business process by identifying the requirements and involved in finding the system requirements. Map the requirements with the test cases for requirement traceability matrix.

Involved in Full life cycle of the project, and Daily Scrums as part of Agile Methodology.

Capture, track and execute daily system requests from various departments such as stores, warehouse, planning, inventory control, accounts payable, and distribution center to ensure smooth day-to-day functioning of business.

Actively involved in performance tuning of T-SQL queries, ETL transformations, and data validations.

Extensively used MS Excel in defining various Reports, Data elements, Data inputs, data captures using various algorithms for identifying AML activities.

Designed dynamic DTS to transfer data crossing different platforms, validate data during transferring.

Act as a liaison, interact with, and build consensus among diverse group of stakeholders, IT department, external vendors, and business.

Conducted JAD sessions to allow different stakeholders to communicate their perspectives, resolve issues, and reach agreements.

Create summary report outlining activities completed throughout the project.

Experienced creating user stories, tasks, and bugs in Azure DevOps Studio. Developed JIRA and Confluence Dashboards, Blogs & Pages for tracking the project for management purposes.

Defined existing state, and what enhancements/upgrades those were to be built to optimize the accuracy, performance, and reporting of the AML infrastructure and suggested design related inputs.

Created Epics/User Stories based on Business Requirements to complete Product Backlog.

Created small tasks within a User Story with granule level Validation and Acceptance Criteria.

Created workflow diagrams and activity diagrams on MS Visio.

Regular submission of project status reports to the higher management using MS SharePoint.

IBM Web Sphere (Java application), Eclipse IDE Juno 3.8, Load Runner 11.5, Rally ALM, Apex Data Loader, Workflow Approvals.

Environment: Agile methodology, Microsoft Office Suite, Microsoft Project, JIRA, MS-Visio, MicroStrategy, Tableau, python.

Contact this candidate