SUMMARY:

• Business System Analyst with over 8+ years of experience and strong understanding of Business Requirement Gathering, Business Process Modelling, Case Tools, and Business Analysis in the domain of Finance, Banking, Mortgage and Insurance.
• Strong Knowledge of RUP, Waterfall, Agile (Scrum, Kanban, SAFe) and Hybrid SDLC methodologies.
• Conducted many JAD sessions, Interviews, workshops, sessions with client/stake holders and the development group.
• Extensive experience in gathering Business and Functional Requirements and converting the requirement to System requirements to a testable level.
• Support with the Use Case, Requirements Elicitation, GAP analysis, SWOT Analysis and functional design documents Swim Lane Diagrams, SIPOC Diagrams, Work Flow Diagrams, Process Flow Diagrams.
• Expertise in creating Unified Modelling Language (UML) diagrams, Use Case diagrams, Activity diagrams, Sequence diagrams, Context diagrams, Component diagrams, State diagrams
• Hands full experience in MS Office Suite, MS Project, Gantter for project planning, MS Visio, Rational Suite, Rational Rose, Rational Requisite Pro, Rational Clear Case, and rational Clear Quest.
• Experience in conducting daily Scrum meeting, sprint planning sessions, Backlog updates, user stories updates.
• Expertise using MS Excel pivot tables, graphs, v - lookups, etc.
• Coordinate with QA/UAT teams to in corporate new functional items into regression suite. Update team documentation such as regression and production check-out scripts.
• Proficient in developing and automating reports, iteratively build and prototype BI dashboards using Tableau to provide insights at scale, solving for analytical needs of business team.
• Support testing of requirements from beginning to end and identify issues as early as possible.
• Involved in GUI Testing, Functionality Testing, Regression Testing, System Testing Unit attesting, Integration Testing, Performance Testing and Stress Testing
• Comprehensive knowledge of and highly applicable skills in Risk Identification, Risk Assessment, and Risk Management.
• Worked on UAT, Selenium testing, performance testing to test the test cases and test scenarios.
• Generated Traceability Matrix to ensure that all the requirements are covered by the test cases.
• Broad Knowledge in reviewing Test Procedures, creating Test plans and detailed test plans for UAT, Test scenario, defining Test cases, both System & Integration and executed many test cases Test Data reviewing and maintaining and executing detailed Test scripts for UAT
• Skilled in SQL queries, Data mapping and Data modeling.
• Solid Experience inSalesforceCRM,SalesforceSales,SalesforceService Clouds.
• Strong Experience in managing requirements for MS SharePoint Migration Projects with Updates in third party tools like Ave Point, K2 Workflow.
• Broad knowledge of banking industry (Retail banking, Investment banking, Private banking, Asset management) and financial services.
• Expertise in Commercial Property and causality Claims and Deposit Operations Representative; with focus in risk mitigation. Knowledgeable in Bank Secrecy Act (BSA) Anti Money Laundering (AML), Comprehensive capital Analysis and review (CCAR) and DODD frank Act, Large Currency Transactions and Court Orders. Analytical, detail oriented with ability to meet deadlines.
• Conducted successful projects with the help of development and testing teams to achieve deadlines timely and proficiently. Sincere, well-organized, quick learner, self-motivated, team player and achiever.
• Strong work ethics, taking ownership of all duties and responsibilities and efficient time management skills. Group and individual based problem solving and decision making.

TECHNICAL SKILLS:

Modelling & Designing Tools: Microsoft VISIO, CSS, HTML, Flash, Action Script, Office365.

Testing Tools: Win Runner, Load Runner 9.1, Quick Test Pro (QTP)

Defect Tracking: JIRA, IBM Rational Clear Quest, IBM DOORS, Bugzilla.

SDLC Methods: Agile/Scrum, Waterfall.

Languages: HTML, CSS, C++, SQL.

Application Servers: Apache Tomcat, JBoss, WebSphere.

Databases: Oracle, IBM DB2, SQL Server, OBIEE/OBIA

Other Tools: Microsoft Project, JIRA, Rally, Microsoft Azure, MS Office, TIBCO, Selenium, IBM DOORS, VISIO, SIX SIGMA, EXCEL, TABLEAU.

PROFESSIONAL EXPERIENCE:

Confidential, West Warwick, RI

Sr Business analyst/BI Developer

Responsibilities:

• Extensively developed Business Requirements Documents, Functional Design Documents and Technical Design Documents.
• Documented Technical Design, Requirements Traceability matrix, document and build user stories for the Confidential integration project.
• Develop functional and non-functional high-level design documents as needed for the TM1 implementation.
• Actively participated and conducted in JAD sessions with business users, technical leads and with development personnel in all aspects of the SDLC.
• Participated in technical walk-through meetings to develop the functional design for the implementation of dashboards.
• Performed detailed requirement analysis and created data mapping documents. Utilized Agile by working with the technical team and product owner to break down user story complexity, prioritize, get level of effort estimates, create the project plan, baseline and update the plan through life cycle. Handled the multi projects resources, tasks, risks and baselines using Gant chart sheets using Gantter.
• Involved in developing Informatica Mappings and writing complex T-SQL programs for the Data Warehouse.
• Efficient in identifying and analyzing Business requirements from documents and end-user discussions and deliver the data requirements necessary to support DW subject areas.
• Extensive experience on designing database using ER modeling and Normalization. Developed source to target mappings
• Experienced in designing rich Interactive reports and dashboards integrating various reporting components from multiple sources.
• Experience in aggregating data and configuring reports from different data sources using data blending.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, maps, funnel charts, lollypop charts, donuts, bubbles, etc. and other making use of actions, other local and global filters.
• Extensive knowledge in various reporting objects like Dimensions, Measures, Hierarchies, Filters, Actions, Calculated Fields, Sets, Groups, Parameters etc.
• Good experience on LOD expressions Comparative Sales Analysis, Customer Acquisitions, etc.
• Hands on experience in embedding Tableau reports and dashboards on external websites using Java API scripting.
• Good knowledge on Embedded views of Tableau with web applications to integrate reports.
• Expertise in Agile Scrum Methodology to implement project life cycles of reports design and development
• Extensively involved in Reverse-Engineering and Business Rules Extraction Expert in project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.
• ImplementedTableauBI Dashboard reporting solution for different groups in the organization and published Dashboards ontoTableauServer for users to view in different mediums (laptop, Desktop, Tablet.).
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for developed ETL Mappings.
• Experience in guiding onshore/offshore development teams to build dashboard applications, developing templates and development framework, design standards and implementation plans.
• Excellent analytical, problem solving, communication and time management skills.
• Participated in technical walk-through meetings to develop the functional design for the implementation of dashboards.
• Performed detailed requirement analysis and created data mapping documents.
• Provide data analysis support for the company's initiatives and projects and oversee the performance of these project designs are as per the requirement.
• Monitoring MS SQL Server performance using Performance Monitor, Profiler, Tuning Advisor and Execution Plan. Experience working with data processing in AWS (S3, Redshift)
• Closely watch the SQL Server error logs, System error log for regular maintenance of SQL Server.
• Rebuilding indexes on various tables, Responsible for creating databases, tables, view and Store procedure as per the business need.
• Associated with Performance Monitoring and Tuning of the database system using System Stored Procedures, DBCC Commands, Dynamic Management Views and SQL Server Profiler.
• DevelopedTableauscorecards, dashboards using stack bars, dual axis charts, geographical maps and Gantt charts. Built complex formulas inTableaufor various business calculations.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes.
• Created organized, customized analysis and visualized projects and dashboards for presenting to Senior Level Executives.
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics.
• PerformedTableauServer administration activities like Site and Project creations and adding users and providing permissions to workbooks.
• Conducted JAD sessions, design discussions and SOS meetings to develop the appropriate data mart.
• Conducted sessions for users onTableauto use it as a Self-service BI tool for ad-hoc reporting.

Environment: Tableau(Desktop/Server) 9.5.6,2018.1, Microsoft SQLServer, JIRA, MS Visio, MS Office.

Confidential, Cherry Hill, NJ

Sr. Business System Analyst

Responsibilities:

• Lead thebusinessflow in creation of Accounts and Asset transfer during external receive transaction mainly from Investment Brokerage firms and Banks.
• Lead the Capital Market process flow in terms of investment banking and share trading.
• Evaluated the pricing model on charges based on the services offered to client as part of transactions which includes charges on tax, brokerage and other fees.
• Designed businessprocess models, Use Cases, workflows, and Activity Diagrams using TIBCO.
• Processing the invitation of the Applications to - Achieving Customer's satisfactions.
• Maintain daily reports and keeping the daily record of New Open Accounts.
• Handled the multi projects resources, tasks, risks and baselines using Gant chart sheets using Gantter.
• Set-up the company profile, users, accounts, defined role hierarchy, and created user environment.
• Led the pricing methodology by converting the pricing elements from the federal government forms to technical attributes and encrypted the acceptance criteria and test cases for UAT testing.
• Extracted data from different data sources; aggregated and implemented various calculation measures to create financial data analysis.
• Expert in knowledge in various capital market instruments and securities including Equities, Fixed Income, Risk Management (Credit and Market Risk), Mutual Funds, Derivatives (OTC market, F&O), Hedge Funds, ETF's, securitization, Mortgage backed securities, Asset backed securities.
• Understanding of Corporate Finance, Quantitative analysis, P&L, Balance sheet analysis, accounting, financial market, derivatives, fixed income, equity, personal lending, financial modeling, data forecast & sensitivity analysis.
• Optimized Risk Management Information Systems (RMIS) for asset valuation to reduce processing times of loan application by 57% (from 3 min to 1 min).
• Supported and coordinated the implementation of the risk framework for new trading activities such as credit pulling.
• Integrated applications into the enterprise wide SailPoint solution. Worked under the Identity Access Management.
• Experience in .NET Framework (C#, ASP.NET, ADO.NET).
• Implemented SOA as a service layer for all possible services that are coupled with product-based business logic functions in Lakewood.
• Decoupled all the available services in Lakewood and create a service layer to provide external service to all the associated mortgage business partners.
• Implemented REST API calls in Spring Rest Controller handle client requests for CRUD operations on the database.
• Implementing Web Services (REST API) between higher level and downstream organizations to send and retrieve information based on criteria.
• Implemented the integration with the back-end system with web services using REST API.
• Developed, tested and documented APIs by allowing to quickly put together both simple and complex HTTP requests in staging.
• Created JIRA projects, templates, workflows, screens, fields and other administrative activities
• Provided ongoing support and configuration for JIRA project, workflows, Screens, fields, permissions, and other Admin tasks
• Created custom templates for use within Confluence.
• Managed portfolio for the all the projects in the JIRA instance.
• Managed and upgraded Jira and confluence 7.x-7.5.2
• Setup Jira "Timesheet Report" plugin, to help users for time-tracking on their dashboards using a JQL or by configuring manually.
• Managed build results in Jenkins and deployed using workflow.
• Worked on JIRA customization - Issue Schemes, Workflow Schemes, Field Configuration Schemes, Screen Schemes, Permission Schemes, Notification Schemes.
• Worked with various teams on Setting new JIRA & Confluence instances for new teams
• Worked on Integrating(migrating) JIRA with Confluence, Fisheye, Crucible.
• Gathered business requirements and converted it into SQL stored procedures for database specific projects.
• Liaised with production team to analyze bugs and resolve issues for the WCF application web services.
• Experience in writing complex SQL queries involving multiple tables inner and outer joins, stored procedures.
• Defined relationship between tables and enforced referential integrity.
• Involved in the analysis, design, development, testing, deployment and user of analytical and transactional reporting system.
• Developed test cases for Web-based ASP.NET Internet applications linked to firm-wide SQL databases.

Environment: AGILEC# 4.5, MVC 4.0 Entity Framework 6.0, JIRA 6.x-7.5.2, POSTMAN, Jenkins UAT Telerik Kendo, CSS, HTML5, Visual Studio 2017, Office 365, VISIO, Excel, Microsoft Visio Telerik JustTrace and JustMock, Version One, SharePoint, MS Office Suite.

Confidential, Marlton, NJ

Sr. Business System Analyst

Responsibilities:

• Worked on Client Onboarding Platform, business processes and functions including Risk/Regulatory, Credit functions, Tax functions, legal functions of Client Lifecycle management.
• Managed Portfolio Officers in managing the existing $300 million commercial loan portfolio and recommended loan structure, covenants and conditions.
• Responsible for the oversight and management of all aspects of commercial lending client needs. Established and maintained ongoing client relationships. Portfolio consisted of commercial lines of credit, term loans, letters of credit, commercial real estate, construction financing and SBA 7(a) and 504 loans.
• Utilized knowledge of credit analysis, market analysis and lending procedures to successfully address business needs and resolve issues.
• Initiated JAD sessions and open-ended discussions to identify, clarify and simplify requirements with client and team.Performed Gap Analysis with As Is -To Be Process flow diagrams using Visio.
• Reviewed data movement deliverables and participated in thebusinessprocess modelling.
• Devised BRD after collecting Functional Requirements for Salesforce implementation from System Users which provided appropriate scope for the technical team to develop prototype and overall system.
• Verified user requirements, managed Change Control Process and updated existing documentation by productively interacting with users.
• Implement requirements and execute testing strategies using theAgile methodology.
• Leading change in team culture for grooming, planning, and estimating, keeping processes aligned with Agile best practices.
• Identifying and remove impediments and blockers for team to work as efficiently as possible through constant communication with Product Owners and operations team.
• Reviewing and documenting systems, products, and processes to better implement Agile best practices.
• Organized and facilitated Agile and Scrum meetings, which included Sprint Planning, Daily Scrums or Stand-ups, Sprint Check-In, Sprint Review & Retrospective.
• Working knowledge and understanding odd Suspicious Activity Reporting(SAR)and OFAC reports.
• Devised graphical depictions of Use Cases, BusinessProcess Diagrams, Use Case Diagrams, State Diagrams, Activity Diagrams, and Sequence Diagrams using Microsoft Visio.
• Delivered functional walkthroughs and UAT sessions and assisted the development of User Manuals for customers.
• Worked as a Branch Development Resource in Credit Cards division. Develop and implemented a standard process for branch risk review including credit approval.
• Developed and implemented programs to sell and secure advancement payments and prepayments on new projects.
• Reviewed existing business process and made improvement recommendations.
• Perform other accounting duties, including bank and credit card reconciliations and cleared all transactions in bank. Prepared credit memos and adjustments for approval by managers by gathering all information.
• Reviewed case notes investigated on-line banking, identity theft, kiting, and seizures.
• Created Custom objects to build new application functionality in theSalesforce.
• Created workflow rules and defined related tasks, time triggered tasks, email alerts, field updates to implementbusinesslogic. Created email templates, approval processes, approval page layouts and defined approval actions on them to automate the processes.
• Created Custom Profiles, Public Groups and Roles to distribute user rights and functionality.
• Used DQC Data cleansing and unification of customer data for client identification purpose and Customer prole validation and correction of incomplete data records.
• Strong experience on Content Management System by capturing, search, networking and storing the data in digital assessments. By using CMS can retrieve the checks in time by digital technologies.
• Customer input data validation in Data proofing as a part of data integration project analysis.
• Perform overall on-site maintenance of Atlassian tools (JIRA and Confluence)
• Administered HP ALM / QC instance for 2K users and Atlassian Jira for Financial Crimes department.
• Integrated Jira with bitbucket
• Integrating and Upgrading JIRA with other Atlassian Applications.
• Analyzing the Different Plugin in Atlassian marketplace and Configuration on JIRA instance.
• Create projects on Jira and assigned Jira Agile boards such as Kanban and Scrum using Swim lane columns with software simplified workflow.
• Created User manual on using Atlassian Products (JIRA / Confluence) and trained end users project wise.
• Taken initiative to clean up the JIRA cleanup for a better performance of JIRA.
• Installed Plugins in JIRA and integrated them with Confluence.
• Created and managed product backlog of clearly defined and prioritized Features, Epics and user stories. Authored user stories along with acceptance criteria.
• Conducted product backlog grooming sessions with the product owner and the implementation team.
• Installed and tested new versions of the tools and plug-ins to ensure compatibility research and utilize industry standard methods and techniques.
• Used Groovy scripts on Script Runner plugin to write custom scripts for Jira.
• Created events, (JEMH) email notification schemes and assigned project roles on Jira.
• Developed SOQL and SOSL queries to get data from different related objects.
• Used Apex Data Loader and workbench mapped data sources and loaded data from legacy systems toSalesforce.
• Involved in data mapping and migration of data from legacy systems toSalesforce Objects and fields.
• Performed the role of support engineer for the internal users and helped them in getting used to the application, generating reports and saved them for further access to the users.
• Provided custom reports and dashboards to support the needs of the users and executives.Administrated and monitored variousSalesforceapplication, hence provided application support.

Environment: Salesforce, Apex, Visualforce, Rally, SOQL, POSTMAN, Office 365, Microsoft Visio HTML, XML, Siebel CRM.

Confidential, Dallas, TX

Business System Analyst

Responsibilities:

• Responsible for Gathering Requirements based on the user requirements and specifications using IBM DOORS.
• Assisted PM with project schedule, timelines, scope, and milestones.
• Performed Gap Analysis to identify the deficiencies of the current system and identify the requirements for the proposed system.
• Conducted Joint Application Development (JAD) and Rapid Application Development (RAD) sessions for communicating and managing expectations, reviewing requirements, and requirements approval.
• In depth knowledge of Software Development Life Cycle process which includes Waterfall, Agile-SCRUMFramework, and Waterfall-SCRUMhybrid methodology.
• Created and managed all thescrumartifacts for the sprint and release (Product Backlog, Sprint Backlog, Burndown Chart, and Burnup Chart)
• Created wireframes and mockups during design phase to in corporate in Use Case documents.
• Gathered requirements for LoanServ(TM) process flows and integration with in house system for better effectiveness, real-time servicing, and robust processing.
• Captured requirements and provided recommendations for real-time reporting in LoanServ(TM) and LoanLink.
• Responsible for UI design, business process modeling,business requirement documents, development interaction, user acceptance testing, and implementation
• Created relationships in Requirement Traceability Matrix linkingBusinessRequirements to Functional requirements and Functional Requirements to Systems Requirements.
• Created UAT Test Plan to assist UAT testers during UAT. Participated actively in UAT and worked as SME along with testing during UAT.
• Initiated Walkthrough & interviews with Subject Matter Experts (SME) & stakeholders to keep track of user requirements.
• Created detailed process flows to aided design documents and assist technical teams.
• Facilitated the change management process. Kept change request log to prioritize change requests along with requirements during each build.

Environment: SQL Server, IBM DOORS, Oracle, Crystal Reports, Office 365, JIRA, MS Office Suite, HP Quality Center (ALM).

Confidential, Stamford, CT.

Business Analyst

Responsibilities:

• Gathered Business Requirements, created Functional Requirements Document (FRD) and analyzed data/workflows; defined the scope, financial projections and cost/benefit analysis; progressed from Problem Statement to well-documented designs.
• Used RUP-iterative process to Conduct Data Analysis on the Group Disability Data to find missing data fields in the application and customize them.
• Used MS Word & Visio to document data flow of the AS-IS process and TO-BE process.
• Conducted JAD sessions to get SME’s input on how to implement the application for Group Disability Claims.
• Responsibilities included underwriting policies for auto, fire, life, health and commercial insurance, providing common bank and notary services, providing customer service on existing insurance policies, marketing to new and existing clients, resolving billing issues, providing insurance and financial services to policyholders, working with internal programs and MS Office Suite to complete office tasks.
• Excellent communication and teamwork skills utilized through written communication, phone and sales meetings. Licensed through the State of CT to write Property and Casualty, Life and Health and Commercial Insurance as well as provide bank and notary services.
• Working with all aspects of financial systems and processes to maintain and service insurance products.
• Strong use of security and customer data across domains to ensure transactional efficiency, regulatory compliance, and profit maximization.
• SQL analysis utilized to design, implement, and maintain commercial insurance products and marketing programs. Also, identifying, communication, and course correcting project risks when needed.

Environment: MS Office, Java, Oracle, Microsoft Visio, JIRA, Office365, Rational Rose, Clear Quest.

Confidential

Business Analyst

Responsibilities:

• Generated comprehensive documentation including version control templates - Enhancement Change Requests, Defect Change Requests.
• Created processes and analytical tools to determine performance and effectiveness ofe-commerce businessstrategies, also created the e-commerce online portal
• Responsible for writing High Level Design (HLD) documents and Detail Design Specifications (DDS) documents. Developed the class mode, database implementation, detailed design (screen layouts, etc.) decided on what design patterns to enforce leading most walkthroughs.
• Conducted RAD sessions with extensive involvement from Business, Development, Testing teams, Architects, SME’s (Subject Matter Experts) and Managers from various platforms.
• Recommended development techniques, specified development tools, mentored other developers. Used the Rational Unified Process (RUP) for the software lifecycle, Rational Rose for modeling, ClearCase and PVCS for source code management, and RequisitePro for document management.

Environment: Rational Analyst Suite (Requisite Pro, Rose, ClearCase), PVCS, RUP, UML, Office 365, MS-Microsoft Visio, MS-Word, MS-Excel, MS-Outlook, MS-Power Point

Confidential

Programmer/Business Analyst

Responsibilities:

• Extensively involved in code generation of the program and testing the efficiency of the chip during flight trials of missiles.
• Documented a report on the functionality of the program and its efficiency during the trials.

Environment: Qnx 4.25, JIRA, Watcom C/C++, Office 365.