Prathamesh Harishchandra Hankare

Sr. Business Systems Analyst

add06m@r.postjobfree.com

Professional Summary:

•Business Analyst with around 7 years of experience in analyzing and gathering requirements for business processes in techno-functional role across Finance and Telecommunications.

•Dexterous in financial terms Fixed Income, Target Date Funds, Capital Markets and Derivatives.

•Knowledge of treasury services such as accounts receivables services, account payable services, liquid management services, reporting services and trade finance services.

•Well-versed in telecommunications terms such as MVNO, MNO, Subscriber, Sales Order, Change Order, 3PL, BYOD, Port-In, NDEL, Provisioning, Activation, Billing, Bundle, MSC, SMSC, Gateways, VoLTE, LTE, Routers.

•Experience with SDLC methodologies like Waterfall, Agile (Scrum), and Scrum-Waterfall Hybrid.

•Successfully gathered SMART (Specific, Measurable, Attainable, Realistic and Timely) requirements at various levels and facilitating elicitation sessions such as survey/questionnaires, interviews, brainstorming, focus group, requirement workshops, document analysis. Proficient in networking with multiple teams.

•Experience in negotiating and coordinating with Developers, Solution Architects, PO’s, testing teams.

•Experience in supporting the Product Owner to define the Minimum Viable Experience (MVE).

•Breaking-down of Epics into User Stories (INVEST format) and then helped in prioritizing user stories using various prioritization techniques like MoSCoW and 100-point method. Estimated the user stories using estimation techniques such as Planning Poker, T-shirt sizing, and Dot Voting System.

•Well-versed in facilitating Sprint Ceremonies (Sprint Planning, Daily Stand-ups, Sprint Review, Sprint

•Retrospective) and parallel execution of Backlog Grooming for each sprint in Agile Scrum Methodology.

•Proven expertise in conceptual and logical data modeling, data integration, and data conversion.

•Knowledge of Source data identification, data profiling, and data mapping.

•Assisted the QA in preparing test plans and test cases, actively involved in defining User acceptance criteria and conducting User Acceptance Tests (UAT) using JIRA. Responsible for updating and maintaining RTM.

•Executed SQL Queries, Functions and Stored Procedures using database platforms such as Oracle 11g.

•Working knowledge of visualization and reporting tools like Tableau, MS Excel and Power BI to drive operational intelligence.

•Experience in performing functional and visual testing of the back-end systems and features.

•Strong understanding of XML, JSON, loosely coupled Web Services (REST, SOAP, WSDL) and system architecture like SOA, Microservice architecture. Documented REST requests and response.

•Creative and self-starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environment.

•Participated in knowledge transfer session with the lead BA’s to understand the AS-IS system.

Technical Skills:

SDLC Methodologies

Agile (Scrum), Kanban, Waterfall, Waterfall-Scrum Hybrid.

Modelling tools

Web sequence, Balsamiq, Lucid Chart, Camunda, Eclipse IDE

Management tools

JIRA, Confluence, SharePoint, Swagger

Testing tool

Postman, JIRA, HP QLM, SoapUI

Reporting tools

Excel, Tableau, Power BI

Languages

HTML5, CSS3, XML, JSON, SQL, YAML, REST

Database tools

MySQL 8.0 EE, Oracle 11g, MSSQL Server, DB2

Communication & Collaboration

Slack, MS outlook, MS teams, WebEx.

Monitoring Tool

AppDynamics

Professional Experience:

Comcast/Xfinity Mobile, Philadelphia, PA Jun’ 2019 – present

Technical Business Analyst

Xfinity Mobile is a Comcast division which seeks to expand its mobile services portfolio to their 27.6 million HSD customers by providing a variety of features which aim at expanding its market grip in the telecommunications domain. Xfinity Mobile had undertaken the effort of providing improved mobile services by increasing backend resiliency of the OMS (Order Management System). This effort consisted of developing and implementing in-house BPaaS (Business Process as a Service) microservices. The aim of this undertaking was to increase their customer base and alleviate limitations of third-party systems which resulted in increased development time and reduced flexibility between XM and AMDOCS (third-party vendor). These systems required design of workflow activities and development of new API’s and domains that were populated by REST API endpoints.

Conducted JAD sessions between front-end and back office team to discuss potential changes to the API contract to enhance existing features while future proofing it at the same time.

As a BA for solution design team, created multiple front-end, back-end, and design stories in JIRA using the INVEST format with clear Acceptance Criteria, API endpoint details, and proposed JSON payload.

Conducted planning, grooming sessions and end-of-sprint retrospective between cross-functional teams.

Accommodated change management at a feature level to make sure the effort of the team is aligned.

Documented solution design artifacts in Confluence, listed out the use cases, impact matrix for the system TO-BE implemented, data points using in-built macros like Chalk, Index, table list etc. for reporting requirements and conducted meetings between solution design team and back-end developers to validate the technical aspects of the designs and REST API contracts.

Designed Activiti model for Order Service and Fraud Review on the new BPM platform and its interaction with PROVISIONING and BILLING. Possess workflow knowledge of ACTIVATION post FULFILLMENT.

Assisted the architect in designing the process flow and JSON payload for Phone ACTIVATION on BPM platform (OSS/BSS).

Participated in a cross-function working session to define Minimal Viable Experience for the user.

Designed API for integrating UI elements of XM360 web app to back-end logic in the MSP systems.

Conducting grooming sessions with the DIGITAL team and MyAccount team from front-end which encapsulated the enhancement of commercial website and mobile app.

Assisted in designing the domain for maintaining customer data within the new OSS system built in-house.

Maintained a repository of all the API endpoints deployed in production environment as per Open API 3.0.

Organized meeting with front-end teams to discuss the UX/UI designs and propose changes to the display elements to accommodate for the proposed customer facing features and back-office functionalities.

Assisted the principal architect in designing BPM solutions for OMS and Fraud Review process.

Created sequence diagrams for technical analysis of AS-IS call flows and proposed system.

Conducted analysis of the AMDOCS IDD (Interface Design Document) and existing Xfinity Mobile modules and constructed a BPaaS Activiti model using Camunda Modeler v3.6.0 and Eclipse IDE.

Designed a BPM model for addons feature based on the architectural platform implemented to reduce AMDOCS dependency. Understanding of credit portal and fraud review BPM.

Used MDSL tool for strategy development and expense management to support the marketing team.

Executed performance testing of the API’s using SoapUI to check for bulk responses within SLA.

Documented cart validation rules and MEC (Master Enterprise Catalog) in ELASTIC PATH platform.

Developing and analyzing relative matrix pertaining to the web pages operation and database calls.

Performed root cause analysis of the system to address the issues with the Gateway API calls.

Incorporated the design principle of including topics in the Kafka queue to reduce bottleneck of the incoming asynchronous requests that needs to be processed by the system without going into fallout.

Acquired sign-off from the solution architects, dev leads and the in-take team for the feature stories.

Created the workflow for Kanban board for Agile framework adoption within the team using JIRA.

Tested FE and BE API request and response with third party API’s using Postman.

Environment: SDLC (Waterfall and Scrum), BPM, Web Sequence diagrams, Eclipse IDE, XM Tasks, XM 360, MS office suite, REST API’s, Open API 3.0, Swagger, JIRA, Confluence, SharePoint, Zeplin 3.0, InVision, MDSL, AppDynamics, SoapUI.

Vanguard, Malvern, PA Apr’ 2018 – Apr’ 2019

Sr. Business Systems Analyst

Vanguard proposed to make enhancements to their existing Wealth Management System focusing specifically on “Target Date Analyzer” to provide a solution where the system was able to re-balance various investment vehicles, display the appropriate corresponding information about the portfolio such as NAV, Glide Path, and Expense Ratio. The aim of the project was to enhance the GUI on the commercial website so that the investors were able to see the ROI for “TO” and “THROUGH” target date funds. Also, the system went under enhancement related to tax to accommodate better Real Property Tax calculations such as valuation, exemptions, and assessments.

• Dealt with regulations such as SOX, BASEL III, IFRS, REIT, GDPR confirmed that the system is compliant.

Possess knowledge of QRM (Quantitative Risk Management) and LRM (Liquidity Risk Management).

• Possess a good understanding of Capital Markets, Bonds, Derivatives, Equities, Fixed-income, Asset

Allocation, Wealth Management, Liquidity.

Familiarity with SWIFT payment method and payment portal validations.

Familiarity with TIC reports and CCAR reports.

• Created user stories by eliciting information from SME’s, business owners, and referred to previous project

artifacts to analyze the As-is system and To-be system. Drafted process workflow using Lucid Chart.

• Assisted PO and PM in ROI Analysis, and GAP Analysis to be prepared for potential business and technical risks. Created Risk Traceability Matrix (RTM) to validate all requirements to their test cases.

• Drafted Business Requirement Document (BRD), Functional Requirement Document (FRD) and Systems

Requirements Specification (SRS) by multiple teams involved in the enhancement of the system.

• Decomposed the elicited information into user stories by conducting a story writing session with the Product owner and define the acceptance criteria for the PSPI (Potentially Shippable Product Increment).

• Estimated Product Backlog Items (PBI’s) using Planning Poker and prioritized them using MoSCoW.

• Actively participated in Sprint planning, Daily Stand-ups, Review and Retrospective meetings.

• Strategically handled requirement churn by making sure the current sprint is not affected by the change.

• Proficient in creating UML diagrams like Use-case, Activity and Sequence using Lucid chart.

• Created Mock-ups and Wireframes for the dashboard using Balsamiq to test the aesthetics of the system.

• Implemented changes to the GUI using KendoUI framework for rich and fluid user experience.

• Conducted UAT and maintained a feature-file that listed all the activities of the tests.

• Executed SQL queries to using joins to fetch data from consumer database system pertaining to clients.

Collaborated with the Digital Marketing team to create e-mail Campaigns and Social Media campaigns.

• Created burnup and burn-down charts for the team performance and project timeline suing JIRA.

• Extensively used JIRA to record and maintain the artifacts along with tasks, impediments, and defects.

• Created ad-hoc reports based on the investment venues and target date range using Tableau.

• Involved in creating Kanban board, Issue Tracking and generated reports for multiple sprints using JIRA.

• Involved in API testing to test the accuracy and performance of the data fetched from Bloomberg servers.

• Involved in JSON technical documentation using Postman, debug, and API monitoring for performance.

• Acted as a primary liaison between the business line, operations, and the technical team throughout the project life cycle. Planned and organized team engagement activities to encourage self-organization.

Environment: SDLC, Agile (Scrum), KendoUI, JIRA, MSSQL Server, Balsamiq, Postman, Swagger, XML, JSON, Java, C++, .NET, JavaScript, SQL, REST API, MS Office Suite (Word, Excel, Outlook), Lucid Chart.

Ameriprise Financial, Minneapolis, MN Sept’ 2017 – Mar’ 2018

Sr. Business Systems Analyst

The project was to build and deploy Robo-Advisor (RA). The system was designed for leveraging data science and statistical modelling to automatically allocate client wealth across different asset classes to automatically rebalance portfolio positions based on changing market conditions or client preferences. The system used a mixture of complex computer algorithms such as Modern Portfolio Theory (MPT), and Capital Asset Pricing Model (CAPM)

that are used to allocate assets and adjust positions based on market movements and conditions. RA also provides a 24 7 tracking of the market movements to track rebalancing decisions from a portfolio and taxation standpoint.

• Elicited business requirements by conducting Interviews with stakeholders, Interface Analysis by collaborating with Subject Matter Experts (SMEs).

• Captained GAP Analysis by understanding the AS-IS business process and TO-BE business process.

• Decomposed the scope from the information gathered during the elicitation sessions into user stories in

SMART and INVEST format and defined the acceptance criteria for the PSPI’s. Assisted the project manager in drafting the BRD, FRD and SRS documents in detail.

• Created UML diagrams to show the Activity and Sequence flow of the system using Lucid Chart.

• Designed GUI as per requirements for the web portal and created wireframes using Axure RP.

• Engineered front-end UI using HTML5, CSS3, Bootstrap and AJAX to simplify client-side scripting of HTML.

• Designed Mock-ups and wireframes for the RA platform using Balsamiq.

• Prepared Requirement Traceability Matrix (RTM) to track test cases to their requirements.

• Used JIRA for writing test cases, test plans and test suites. Performed all the tests manually.

• Organized project documents using Confluence, created permission at a space and individual level.

• Worked with Tableau to create dashboards, identify the Key Performance Indicators KPI’s to better analyze the data and measure the service level compliance of all automated & human controlled processes.

Enhancement of the RA so that the website is more appealing to clients and user-friendly to use.

Created awareness digital campaigns to target niche audience specifically millennial investors.

• Assisted in defining the Data Dictionary to maintain demographic info, investor relationships, investor’s current activity, and investor journey graph in the system database.

Executed SQL queries in Oracle 10g environment to fetch results for creating visual reports.

• Defines Data Mapping Document (DMD) that maps the customers and investment fields to the storage.

• Performed UAT using JIRA and performance test of the system using Postman.

• Using Postman, conducted API ingestion tests to see if the data is accurately fetched from external sources.

• Used Informatica Power Center for performing ETL process (Extract, Transform and Load) and performed feature-based extraction. Executed ad-hoc SQL Queries such as joins and aggregate functions.

Environment: Agile (Scrum), JIRA 6.3, JIRA, JavaScript, SOA, RESTful, JSON, Informatica 9.1, MS office suite

(Word, Excel, outlook), Lucid Chart, Tableau 2018.3, Postman, Swagger, Confluence.

Credit Suisse, Morrisville, NC Sept’ 2016 – Aug’ 2017

Business Systems Analyst

The project was about implementing a multi-phase data warehouse for the Trading Platform system. The aim was to apply a uniform format to all the collected data to develop insights into market transactions. The project was to implement faster and more flexible reporting, collect data regarding the intermediaries and their respective trades.

• Understood the processes by interacting with stakeholders and participated in a JAD session.

• Defined user stories based on information gathered from stakeholders and estimated and prioritized them.

• Understood the current Trading system to create data dictionary and defined meta data fields

• Defined logical and conceptual model for the definition of data warehouse and OLAP cubes.

• Assisted Data modeling process by creating conceptual and logical ER diagrams and designing database schema to help development of an accurate Data Warehouse Structure.

• Performed dimensional modelling and assisted System Architect in creating dimensional and fact tables.

• Utilized Informatica PowerCenter to perform ETL process to extract and manipulate the sources data.

• Created different Informatica Workspace (Sources Analyzer, Target Designer, Mapping Designer, Mapplet designer, and transformation Developer) to transform the data from source to target.

• Helped with data normalization for elimination of data redundancy and faster query processing.

• Involved in creating mapping design between source and target and performed various transformations.

• Managed and tracked bugs and defects using JIRA. Posted bugs on the sprint board for a joint effort.

• Worked with QA team to design and develop test cases to perform User Acceptance Testing.

• Assisted in Validation testing, Metadata Testing, Data Completeness Testing.

• Designed test scenarios and test cases for constraints, correctness, cleanliness, and data quality.

• Performed SQL queries like DML and join commands and supervised the source to target mappings (STM).

• Was involved in using Tableau for effective ad hoc reporting to provide Business Intelligence (BI) to facilitate expenditure tracking using various matrices critical to decision making.

• Timely tracked progress and reported it to Stakeholders and Project Manager.

Environment: Waterfall – Scrum Hybrid, MS Office (MS Word, MS Excel, MS PowerPoint), Tableau, JIRA, MSSQL

Server 2012, Tableau, UML, UAT testing, Confluence.

Pinnacle Solutions, Mumbai, IND Jun’ 2014 – Jun’ 2016

Jr. Business Analyst

The undertaking was for an e-commerce website. The project was to make enhancements to the website and create an Order Tracking System for the ordered goods.

• Implemented Waterfall SDLC methodology which included Requirements Analysis, Design, Development, QA & Testing, Deployment, and Maintenance.

• Performed requirements gathering by Document Analysis, Prototyping, and User-cases.

• Created mock-ups using MS Visio to implement a fluid experience by incorporated visually pleasing UI’s.

• Assisted the Project Manager in defining the scope of the project and in creating the FRD, and SRS.

• Defined the business rules according the standards of Order Tracking System.

• Designed UML diagram such as Sequence, Activity, Class, and Use Case diagrams.

• Coordinated creation of Test plans, test cases, User Acceptance Test (UAT) scripts and RTM.

• Actively involved in handling change request by performing Impact Analysis on Triple Constraints.

Environment: Waterfall, Lucid Chart, MSSQL Server, MS Office Suite (Word, Excel, Outlook), JIRA.

Mindspace, Mumbai, IND July’ 2013 – May’ 2014

QA Analyst

The Job Scheduling Management is a system designed to schedule resource and manage all the services provided to the clients. The system helps the Admin to handle the business with efficacy. It allows to allocate the resource, record the time sheet, etc.

• Active participation in Requirements Analysis, Use-case Analysis, and GAP Analysis.

• Developed Test plans, Test cases, Test scenarios and their scripts. The scripts were developed after careful review of the BRD, and SRS. The manual testing was performed on JIRA.

• Tested the application on various browsers to test its cross-browser viability and on different environments.

• Monitored defects and reported the bugs using JIRA via email to different developers working on the bug.

• Analyzed all the bugs in the JIRA, participated with the users during the UAT.

• Investigate software defects and interact with developers to resolve technical issues.

• Performed User Acceptance Test (UAT) and wrote DML SQL Queries to test the target database.

• Interactions with Business Analyst, Developers, UAT team, and QA team members in defect raising situations.

Environment: Waterfall, MSSQL Server, MS Office Suite (Word, Excel, Outlook), JIRA.

Education:

Bachelor’s in computer engineering

University of Mumbai, Maharashtra, INDIA.

Master’s in Computer Science

Florida International University, FL

Contact this candidate