M.Bhattacharya

Email: ad3duk@r.postjobfree.com

Contact: +1-614-***-****

Location: Ashland, Virginia 23005

Sr. Business Analyst

PROFESSIONAL SUMMARY:

●Over 8+ years of professional experience as Sr.Business Analyst in Banking/Finance, E-Commerce & Retail with strong understanding of Business Requirements Gathering, Business Process Flow, Business Process Modelling and Business Analysis.

●Experienced in performing Gap Analysis, Impact Analysis, Risk Analysis, Traceability Matrices, SWOT Analysis, Document analysis and Cost Benefit Analysis.

●Experienced in Online Banking, Fund Transfer, deposits, withdrawals, loan payments and Cash management process.

●Experience with Business-to-consumer (B2C) sales of tangible goods/online services and Business-to-business (B2B) scenarios, such as e-procurement and e-commerce.

●Expertise in Retail Supply Chain Management (Order Management, Inventory management) across Consumer Travel, Supply Chain Management (SCM), Demand Management (DM)

●Experienced with reviewing and writing BRD and FRD.

●Excellent in analyzing and creating Use-cases, various UML diagrams like Use case diagram, Activity diagram, ER diagrams, Data Flow diagram using MS-Visio, Balsamic, and mock-ups.

●Extensive knowledge of SDLC with different methodologies, such as SDLC, Waterfall, Scrum, Agile, Kanban, RUP, Extreme Programming and Scrum-Waterfall Hybrid.

●Strong project management skills from requirement analysis, process mapping and documentation. Hands-on experience on tools like Rally, JIRA, Azure DevOps, cloud, MS-Project, Confluence for collaboration and tracking.

●Excellent facilitation skills in conducting walk through, surveys, questionnaires, one-on-one interview sessions, groups’ sessions, and prototyping brainstorming, JAD and JAR sessions.

●Experienced in ETL tools like SQL Loader and Datastage, Informatica to transfer the data between different databases.

●Experienced with Microsoft Cloud-based solutions including Office 365, One Drive, OneNote, and Skype for Business.

●Experience in utilizing tools like MS (office suite, Excel, Power Point, projects, Visio) and requirement management tools.

●Experience in internal and external stakeholder UI/UX design and processes approval meetings.

●Experience in SAS includes detailed knowledge of statistical analysis of financial.

●Good understanding of building model driven and canvas app in Dynamic 365 using Common data model.

●Experience in User acceptance Testing (UAT) and familiar with software testing and Regression testing.

●Experience designing and developing SQL statements and queries for Oracle and SQL Server database.

●Extensively used SQL queries for business analytics and analysis of data using data manipulation language.

●Excellent analytical and problem-solving skills; listening, oral, and written communication/presentation skills with strong ability to influence people at all levels and in various functions.

Education: MBA, Punjab Technical University, 2012

PROFESSIONAL EXPERIENCE:

Jefferies Investment Bank, New York, NY July 2021 to Present

Sr. Business Analyst

Project Description: I am working in the Online Banking Application which allowed tracking, managing and optimizing with customers or members. It provided centralized access to perform frequently used "banking" functions such as deposits, withdrawals, Funds transfer, wire Transfers, loan payments, etc. Enabling efficient Management of Cash Inflow &outflow processes, Automated Payment, Reconciliation & Accounting.

Responsibilities:

Involve in an Online Banking accessing personal accounts, checking balances, payment of recurring bills, such as mortgages and loan payments, transfer of funds between accounts of its customers.

Work in consumer and commercial loan analysis, credit analysis, profit and loss, balance sheet analysis, loan origination, repayment track.

Working with a Grant Management Database integration project.

Gather requirements for improving cash flow management by enabling the ability to send payments electronically, collect payments and move money across accounts.

Work closely with program manager to develop and manage Product backlog, User Stories, Sprint Plan, Iteration plan and Sprint Backlog.

Work with the scrum development to understand building Java micro services in Microsoft Azure cloud.

Handling equipment finance accounts with high risk assets.

Gathered Requirements through different elicitation techniques such as Document Analysis, Brainstorming, Interviewing, and conducting JAD sessions with technical teams, and SMEs.

Involve with Client Service and Customer Relationship team (CRM) to get end users feedback about the application.

Create Scrum board & Kanban board product backlog items/ tasks and PBI estimates using Atlassian Jira and track progress.

The business process review, validation and testing of the current SAP system in accordance with the business structure.

Coach and adapted seven SAFe competencies team and Technical agility, agile product delivery lean portfolio management.

Working as an Agile Transformation Coach where scrum and Kanban Techniques are applied.

Working with Product Manager to streamline the current adobe analytics engagement process.

MS Excel spreadsheet development VBA, Forms, Vlookups, Hookup, Pivot Tables and Report Development

Work as a SAFe Scrum Master for three agile teams. Facilitated Sprint Planning.

Full understanding of Unified Modeling Language (UML) and SDLC models like Rational Unified Process (RUP), Waterfall.

Document requirements in Business Requirements Documents (BRD) and Functional Requirements Document (FRD).

Continuous communication with the team to track requirements on Rally and discuss to fix defects with JIRA tools.

Use Visio to develop Use Case diagrams, Activity Diagrams and Sequence Diagrams.

Involve in scrum methodology and agile framework to team members and stakeholders.

Manage projects schedules via MS Project; all documentation and status for projects were kept in SharePoint.

Analyze business requirements and document them appropriately in the form of user stories in Jira and/or Azure DevOps.

Designed landing page, menu items, transitions between pages, and style font and color scheme of the portal based on signature styling of the company with the help of UI/UX designers.

Data migration from in house sales systems into Dynamic 365 sales entities.

Interact with several Investment banks to support UAT testing for them.

Involve in ETL mappings about business rules and solving the cases.

Excellent command in writing complex routines for Data Validations, Data Extraction, transformation and loading to target decision support systems using MS Excel, Pivot tables and SAS on various environments

Work in a BABOK methodology environment to execute Business Analysis best practices.

Work in Oracle SQL, MY SQL, PL/SQL, SQL Plus, SQL Loader, SQL queries and SQL server.

Coordinating with Database team to perform Data mapping, Data warehouse and Data migration.

Citizen Financial group, Providence, RI Dec 2019 to Jun 2021

Business Analyst

Project Description: The project objective was To create the Citizens Financial Group entered into an agreement to perform comprehensive due diligence on customers at on-boarding allowing for enhanced AML risk rating and profile development. Worked, helped and assisted the team of 4 BAs towards the completion of multiple functional specification documents.

Responsibilities:

Worked in Anti - Money Laundering (AML)/KYC and Operation Risk Management in the large Investment Banks and Finance Companies.

Assisted the Product Owner to find techniques for effective goal definition and product backlog management and writing user stories.

Responsible for guiding the planning, tracking and day-to-day activities of cross functional teams during its transition from Waterfall to Agile methodologies.

Worked with business stakeholders to establish goals and objectives of the business initiative.

Helped development team build logic for applying factor for pay down fixed income securities such as Mortgage Based Securities (MBS), and ABS (Asset Based Securities).

Performed an active coaching role for a scaled agile implementation utilizing the SAFe.

Gathered requirements through interviews, meetings, and existing documentation and conducted UAT.

Worked with a diverse team of Business users to gather requirements and prepared BRD and FRD.

Oversee creation and approval of critical process flow documents and project plans for new projects using SAFe.

Worked in Software Development Life Cycle (SDLC), iterative Software Development Life Cycle Process. (Agile, Kanban, Waterfall and RUP).

Trained the team on JIRA tool for Agile/ Scrum Methodologies.

Managed clients contact management including monitoring and recording interactions and communications through CRM.

Designed Use Cases using UML and managed the entire Functional requirements life cycle using RUP.

Utilized corporation developed Agile SDLC methodology.

Worked in JIRA and TFS / Azure DevOps for story tracking and documentation.

Worked with SMEs to determine new requirements for Vendors providing grant management services.

Set up meetings, conducted Walkthroughs, JAD sessions with Management, SMEs (Subject Matter Experts), vendors, users, and other stakeholders to resolve open and pending issues and to develop specifications.

Involved in creating UML Activity, Sequence, Dataflow, and Use Cases diagrams using Microsoft Visio.

Using ETL failures to create job aids for training purposes and facilitating in daily scrums and brainstorming sessions.

Effectively monitored sprint progress using data visualization to express performances and to support data driven decision making.

Worked in SQL statements for product specific ETL specifications.

Involved in Data profiling, Data analysis, data mapping and Data architecture artifacts design.

EBay, Austin, TX May 2017 to Nov 2019

Business Analyst

Project Description: I worked in the complete redesign of the main ecommerce web site and introduction of new features like Browse Catalog, Shopping Cart, Checkout, Order Processing, Digital Marketing, Manage Account, International Shipping and Digital Wallet. Features delivered included major enhancements to all platforms and concepts on desktop, tablet and smartphone.

Responsibilities:

Worked in Ecommerce testing Product Search, Payment System, Online transaction processing and Inventory management.

Participate in our strategic Digital Marketing team meetings to help coordinate initiatives to improve our processes.

Understanding of key E-commerce functions like site browsing and navigation, checkout flow, order fulfillment, payment processing, order shipment, inventory management and order management.

Work cross-functionally with product management, designers, marketing, sales & engineering.

Documented and analyses the business process for receiving and processing customer sales based on "Opportunity to Order" and covers business-to-business (B2B) and business-to-consumer (B2C) sales.

Conducted JAD sessions with management, SME (Subject matter expert), stakeholders and developing team for critical issues.

Participate in ecommerce implementation strategy. SAP hybris platform functionalities of Shopping Cart, Catalogs, UI design, Integration of payment gateways, Data Integrations with CRM, and SAP.

Worked as Business Requirement Document (BRD) and Functional Requirement Document (FRD).

Worked in Electronic merchandizing, Advertisement, order management, Regulatory compliance scope 15c3-5 Controls and regulatory compliance rule for advertisement of shares executed.

Worked as Project Management maintaining project documentation.

Planned and established Software Development Life Cycle (SDLC) from start to finish. Adopted SLDC methodology Waterfall for development of the project.

Created Use case diagrams, activity diagrams using Ms Visio according to UML methodology thus defining the Data Process Models.

Worked with UI/UX designers to modernize UI designs and functional flows for existing products.

Use Jira, CA Rally and project management tools or track and monitor backlog status and delivery.

Used SQL queries to extract the performance metrics and generate the performance reports of trainees and trainers.

Using PL/SQL and Dynamic SQL to extract Data from Oracle databases.

Wal-Mart, Florida, United State Oct 2015 to Apr 2017

Business Analyst

Project Description: The objective of the project was to Re-architect existing BSS systems and also create a Universal UI (replacing CSM online) to streamline customer interactions and reduce the reliance on In-House Applications. Enrich customer experience and address some of the challenges like time to market, limited billing system capabilities and outdated architecture. Universal UI brings functional parity between service channels and allow the frontline Retail and CC&B representatives to focus on the customer rather than the systems.

Responsibilities:

Gather Business Requirements from Retail and CC&B stakeholders for new BSS processes to-be implemented in Amdocs CES 8.5 and EPC.

Create Functional and Technical Requirements to accommodate Postpaid and Prepaid line Activations to be implemented in Amdocs Billing and Enterprise Product Catalog.

Identify, evaluate the impact of new requirements on an existing suite of complex applications and develop billing systems procedures that meet business requirements.

Worked with Data Warehouse for data mining, making consolidated reports and finding relationships correlations.

Serving as a liaise between Supply Chain, Marketing, Sales, Finance and IT teams and providing analysis to Confidential

Evangelized and lead the staffing, architecture and re-development effort of proprietary legacy applications to a commercial e-commerce B2B and B2C web portal solution in Hybris Endeca e-commerce platform.

Conduct JAD sessions to finalize the Billing system design, scoping of functionality to be implemented per release and design changes needed in Middleware services for Billing and Retail systems.

Collaborated with global supply chain team to streamline the overseas suppliers and reduce material shortages up to 20%.

Complete Impact Assessments for all defects in production and creating Change Requests for Development teams to implement fixes.

Helped in creating the data mappings and transformations.

Used JIRA to communicate website bugs and keep track of when they will be resolved.

Data and Product modeling of Wireless Voice and data services in Ensemble and EPC.

Participate in reviews of proposed new UI prototype and map key fields to backend services and data elements of Ensemble and EPC systems

Create Visio diagrams to depict ‘As-Is’ and ‘To-Be’ Architecture and Designs using Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, Context Models, Event Modeling, State Modeling, Process decomposition, and document Use Case Scenarios.

Created test plans, test cases and conducted functional/non-functional testing as needed, defined and traced software defects in JIRA.

Used IMPEX files for import and export of the product Catalog and content pages in the B2B/ B2C site. Utilized IMPEX scripts to create the internal/external and category link components.

Act as liaison between IT and the Business owners; ensuring tasks lined up for releases are properly being handled in Development and QAT phases.

Maintain Requirements Traceability Matrix from planning to deployment phase and tracking emergency fixes that are handled by scrum teams.

Reviewed Test Cases, Test Plans, and performed User Acceptance Testing (UAT), documented defects using the Jira as Defect Tracking Tool.

Work with Retail Partners, Service Assurance and Revenue Assurance teams to gather their requirements and implement Billing systems design and determine impacts on the current workflow. Perform Gap analysis in some cases.

Contact this candidate