Home

Abhi Sagarika Bansidhar - Business Analyst

[email protected]

Location: New York City, New York, USA

Relocation:

Visa:

Abhi Sagarika Bansidhar PROFESSIONAL SUMMARY Business Analyst with 10years of global professional experience having extensive cross-functional domain expertise in technology consulting, product management and B2B SAAS. Extensive cross-functional domain expertise in technology consulting, business intelligence and data analytics software development and product management. Agile leader with extensive experience in Agile Scrum methodology. Facilitated Scrum events including Sprint planning , Backlog Grooming , Sprint Review , Retrospective and Daily stand-ups Extensive experience in creating and documenting Business Requirements, Process Flows, Functional and Non-Functional Requirements, and System Functional Specifications including Use cases. Skilled in Data Management, Data Modelling and Machine learning techniques. Extensive experience in in analyzing analytics report and creating dashboards using data visualization tools such as Tableau, Power BI. The Merchant Accounting Systems team is responsible for building, testing and implementing new Merchants to the TSYS Credit Card Systems Extensive use of UML Diagramming for modeling views in Microsoft Visio. Firsthand experience in SQL queries and SQL procedures functions and packages. Strong understanding of Systems Integrations, Data Integration/Flow and Data Modelling. Experience in conducting Gap analysis using AS-IS and TO-BE business process, Impact analysis, SWOT analysis, Cost-benefit analysis and ROI analysis. Experience in working with QA Testing Team, creating Test Cases and conducting User Acceptance Testing (UAT). Managing requirements traceability information and tracking requirements status throughout the project. Result oriented Joint Application Development (JAD) facilitator and meetings coordinator with excellent communication and interpersonal skills. Effective communication, coordination and interpersonal skills in interactions with subject matter experts (SME s), and business End users. Experience in managing projects with multiple stakeholders (Both external and internal). Strong business insight, strategic thinking, communication, interpersonal and presentation skills, editing, coordinating extensive communication networks, presentation skills Group and individual based problem solving, excellent leadership. TECHNICAL SKILLS SDLC Methodologies: Kanban, Agile, SCRUM, Waterfall Requirement Management Tools: JIRA, HP ALM, Rally, Requisite Pro Databases: Oracle, MS SQL Server, MS Access, Toad. BI &Data Visualization Tools: SAS Enterprise Guide, SAS Enterprise Miner, R Programming, Python MS BI, MS Power BI, Tableau, E-Builder by Trimble PROFESSIONAL EXPERIENCE T Rowe Price-Maryland Business Systems Analyst Oct 2024 to Dec 2024 Worked as a Senior Business Analyst as part of the TRP Marketing team Worked on the Data Transition from On Premise legacy DB to AWS cloud Data Warehouse. Worked on Data Classification for varioius marketing platforms such as ON24, Bizzabo and EAM (Emailed Address Management), as per the organization data governance and compliance. Worked on Source to Target Data Mapping for Marketing platforms to finalize the data lineage for migration into AWS Data Warehouse for Analytics and reporting Delivered assignments in Agile SLDC. Worked with key stakeholders within all business functions to align technology solutions with business strategies and deliver on a use case basis. Used Informatica to understand Data lineage for Marketing Platforms for Source to Target Mapping for data assets into AWS Data Warehouse. TD Bank AMCB (America s Most Convenient Bank-NJ, USA Business Systems Analyst Data Strategy and Cloud Migration Jan 2023 Spt 2024 Business Systems Analyst in Data as a Service (DAAS)-Project Ascend, responsible for migrating all on-premise data assets into Microsoft Azure Cloud Data Warehouse platform. Worked and collaborated with team consisting of product owner, scrum master, solution architect, data modelers, data engineers and ETL developers. The Certification Data Services team is responsible for refreshing the CBT O integrated data for the integrated and independent releases. To meet demands of new data requirements, have synchronized data between Consumer, Card, HL I, GWIM, and TSYS, minimizing the need for data conditioning, and provide up-to-date test data which mirrors production data. Identified and worked on use-case based prioritized data sources to be migrated to Azure Cloud Data Warehouse and made available in the Curated Zone for Reporting and Analytics by different lines of businesses (Fraud, Marketing, and Retail). Gathered business requirements from Technical Subject Matter Experts (SME s) on data sources from different line of businesses for migration into Azure Cloud platform, and prepared technical design documents. Created comprehensive narrative use cases, diagrams, and activity diagrams, improving communication and understanding among stakeholders. Analyzing key aspects of business to evaluate factors driving results and summarized into presentations. Validate API s using SOAP UI and Postman. Worked with Data Modelers, Technical SME s and Data Stewards on Source to Target Data Mapping for data sources to be shifted from the Standardized Raw Zone to the Curated Zone in Azure Cloud Data Warehouse, using Microsoft Excel. Assisted in the integration process by analyzing the data lake and designing functional specifications for both front end and back-end integration. Conducted in-depth data analysis using SQL queries to extract, transform, and manipulate large datasets. Extensively used Informatica to understand and trace the data lineage and relationship for data sources to be migrated to Microsoft Azure Cloud Data Warehouse. The Merchant Accounting Systems team is responsible for building, testing and implementing new Merchants to the TSYS Credit Card Systems. Wrote complex SQL queries to extract and analyze data from relational databases. Used Microsoft SQL server to write queries to access data in on-premise data warehouse to extract technical metadata on prioritized data sources. Collaborating with stakeholders, including Developers, business users, to gather and document business requirements related to Open Banking API integration, data governance Led a team in the implementation of a new credit card processing system using TSYS, resulting in a 25% reduction in transaction processing time. Used Datadog to track the ingestion status for data sources ingested into Azure Cloud Data Warehouse. Created Process Flow Diagrams, Sequence Diagrams and Activity Diagrams using Microsoft Visio. Created user stories within JIRA to track the data migration process for different data source codes. Kept track of epics, user stories, tasks, sub-task and research spikes using JIRA. Defined Acceptance Criteria and Definition of Done for the user stories created. Conducted GAP analysis to derive requirements for existing systems, enhancements, work flows and process flows to highlight the changes. Iterating on data mappings based on feedback from stakeholders, testing, and evolving business needs. Operated in 2-week sprints with flexibility on length based on immediate functionality concerns. Practiced daily standups, sprint planning and retrospective, backlog grooming and impediment removal. Curated Knowledge Transfer documents for various platforms on Confluence, and organized and conducted training sessions for new incoming BSA s. Client: Bank of America Role: Sr. Business Analyst September 2019 January 2023 Description: With unique IT Project Management Process Methodology and Technique, acquired contracts/Contracts acquisitions of various Domain specific IT Project Management projects and sought by the giant company to support their vision of leveraging technologies to increase operational efficiency/customer service levels/revenue spanning more than 50% of market shares in the Finance and Mortgage Industries. The contract award is $600M to cover over Bank of America s marketplace being developed to satisfy the requirements of the high level security and single to multi-channel performance expectations of the customers and stakeholders. The integrated uses of business models system is designed to meet all the loyalty demands of the company in the commercial and residential level covering multi-channel in highly scalable but robust performance. The project was initiated with the intent to improve existing versions of online banking applications currently in use. I was able to lead and manage the project analytical team horizontally and by identifying project scope to manage complex project life cycle by creating project milestones and deliverable. Subsequent releases added new features and functionality. I handled and maintained Merrill Lynch s public funds and mutual funds by mitigating risk, consolidation of market share in regards to any discrepancies or clarifications using performance measurements in Six Sigma estimations. Managed the schedules and timelines of Mortgage industry professional with strong knowledge of commercial and residential lending loan-processing experience and a comprehensive knowledge of conventional and government loan programs. Thorough in gathering borrower information, verifying loan documents and reviewing file documentation to guide each loan from pre-approval to closing. Using MS Visio to create wire frames and mock-up screens to present to stakeholders User-Interface and elicit feedback. Moody s Risk Origin savvy with various systems integration formats of leasing, loan processing, and risk mitigations in MS financial suites and proprietary mortgage-processing software. Ensured comprehensive UAT testing for releases and maintained detailed Confluence documentation for APIs and requirements, supporting project dependencies. IT Loan Processing Expertise gained from previous work experience from Freddie Mac. Conforming & Nonconforming Loans, FRMs, ARMs, GPMs, Jumbo Loans, Fannie Mae & Freddie Mac Guidelines, FHA, VA, USDA Rural Development Loans Tracked project progress, reported defects, and enhanced issue resolution time using Agile tools (JIRA, Kanban, Azure DevOps, ServiceNow), providing regular updates to managers and stakeholders. Conducted in-depth analysis of existing TSYS systems to identify and resolve operational inefficiencies, improving system reliability and performance. Assisted in the migration of legacy credit card processing systems to TSYS, including data validation and system testing. Assessed the adjudication process during data verification and validation ensuring stakeholder requirements are met as they apply for applicants and borrowers with problematic credit histories With exceptional technical and business acumens gained over the years, delivered proven track record of executing team approach in meeting deadlines of complex projects such as going live finance and mortgage application and integration of loan processing, supporting the project with strong Capability Statements model for brokers during procurement projects. Conducted training sessions for business users on SQL querying and reporting tools. Collaborating with business stakeholders to gather and understand business requirements for the .NET web development project. Led strong negotiations and communications intensive meetings while easily adapting to highly stressful situations. Managed new business requirements by extending the functionality of the core WebSphere multi-channel scopes from DOM design phase to go-live phase of systems architecture, requirements gathering and testing. Smoothly and efficiently strategized the structural framework of project management system using extensibility architecture feature of integrating and designing digital third party systems to enable options such as paperless improvements with efficient implementation processes. Conducted system impact assessments and analyses, particularly with APIs and process flows, to mitigate issues and ensure smooth platform operations. Supported the development of user manuals and training materials for new TSYS functionalities, enhancing user adoption and efficiency. Wrote quick turnaround RFP s, RFQ s, RFI s, and administered contracts impacting desired results. Enabled easy access in usability to support commercial the e-commerce capability of the design, project plans schedules, using business models applicable for each module during integration phase. Increased competitive edge in the industry by establishing vendor management systems based on submitted Capability Statements containing WBS, Estimation, Risk Assessment, and LOE in modified plans. Client: Citizens Bank - Providence, RI Role: Business Analyst February 2017 August 2019 Citizens Financial Group, Inc. is one of the oldest and largest financial services firms in the United States. It offers retail and commercial banking products and services to individuals, small businesses, middle-market companies, large corporations and institutions. The project initiatives included iOS Universal Application for iPads and iPhones, Real-Time credit card balance, adding pending transactions to the current user experience, leveraging transfer now for Pay Now Capabilities for Credit Cards, digitally management of Certificate of Deposit upon Maturity and digital access for sweeps checking account. Responsibilities: Gathered Business requirements from subject matter experts and convert them into user stories within JIRA. Maintained a physical user story board, sorting requirement into categories such as Backlog, doing, done and ready for development to visualize the progress on numerous initiatives. Kept track of epics, user stories, tasks, sub-task and research spikes using JIRA. Updated rank for User Stories before grooming sessions. Defined Acceptance Criteria and Definition of Done for the user stories created for current initiative. Operated in 2-week sprints with flexibility on length based on immediate functionality concerns. Practiced backlog grooming, release and sprint planning, daily standups, impediment removal. Meet and Co-ordinate with internal and external stakeholders to establish project scope, system requirements and goals to develop, analyze and prioritize the requirements. Collaborated with the team, architect, product owner and chief product owner to ensure rightness of features and design. Extensively used SnagIt to create mockups, screenshots and wireframes based on the requirements elicited for the mobile and web application. Working closely with business stakeholders to understand the organization's strategic goals and objectives. Developed, managed and tracked project plan to implement requested features. Facilitated grooming and planning sessions with team. Tracked and reported on project progress. Work with team to adjust focus and approach as needed. Creating comprehensive documentation including, API usage guides, process flows and system diagrams. Gathered Business Requirements from customer and prepared Technical Design documents. Created business process workflow and activity diagram. Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes. Assisted in creating Process Flow Diagrams, Sequence Diagrams and Activity Diagrams using Microsoft Visio. Conducted GAP analysis to derive requirements for existing systems, enhancements, work flows and process flows to highlight the changes. Assisted in the integration process by analyzing the data lake and designing functional specifications for both front end and back-end integration Collaborated with the System Administrators on identifying workflow enhancements/improvements. Coordinated meetings related to requirements gathering, workflow design, preliminary testing, and User Acceptance Testing (UAT). Performed Usability testing for My Cards initiative within mobile environment to opt for the best user experience. Research, analysis, prototyping and validating of mobile and web application for seamless user experience. Utilized Agile (Scrum) methodology to monitor, direct and develop project objectives. Used Perfecto Mobile to carry out cloud based user acceptance testing. Created Test Plans and Test Cases for user acceptance testing. Collaborate with stakeholders, including credit risk managers, underwriters, and IT teams, to understand business needs and regulatory requirements. Co-ordinated Unit Testing and Performance Testing during the development process. Assured that all Artifacts follow corporate Agile Policies and guidelines. Environment/Tools: Perfecto, HP ALM, DB2, Rational Clear Quest, API,Agile, Rational Administrator, SQL Basic, UML, MS Visio, JIRA. Client: Bank of America - Charlotte, NC Role: Business Systems Analyst June 2016 January 2017 Bank of America is one of the largest financial services holding companies in the US offering full range of consumer and commercial banking, asset management, security brokerage, mortgage and insurance products and services. The project was a Banking mobile application where customers can access Checking and Saving Account details. The customers can view, update personal information and make the payments directly from the Checking accounts. They can also view details online for Current Balances, Loan history, Taxation and Rate of Interest etc. The Application responds within 60 seconds and gives details of credit card approval or non-approval. Hunan Optical Valley NanoTechnology Co. Changsha, Hunan, China Nanotechnology firm with various nano technology products for Industrial applications - Consulted for Huzheng Nano Technology Co., Located in Changsha, Hunan, China. (GW Global MBA Consulting AbroadProject) Marketing Consultant - GW Global MBA Consulting Abroad Project Jan 2016 May2016 Worked with the product development team to identify products for internationalmarket (USA, UK). Conducted market analysis and forecasting for capturing internationalmarket. Developed strategies for product branding andmarketing. Identified the most feasible foreign market for Industrial grade nano-paints. CodomotiveSoftwareSolutions(IT startup providing solutions for website and apps) Kolkata, India BusinessDevelopmentManager Jan 2014 May2015 LedthemarketingandCRMteam,growingitfromsixto12professionals,expandedtheclientbaseinternationally (theEU,MiddleEastandAustralia). Supervised and managed software development projects from ideation to delivery phase, following agile scrum methodology. Increased revenue potential by expanding the company s product offering through market research analysis and customer needs assessment. Led strategic planning for product expansion of the company in developing apps using android technology, thereby increasing the target customers, and ensuring productdiversification. Createdanewbusinessmodelbyimprovingthecompany sonlineportalandautomatingtheprospectingprocess helping the firm increase its cost savings by 15% in 2014 compared to the last fiscal year. Finalized and delivered Codomotive s first foreign client project from Israel, which was by far the largest project handled by Codomotive, accounting for 12% of the revenue in2014. TataConsultancyServices Mumbai,India Indian multinational information technology service, consulting and business solutions company operating in 46 countries. SystemsEngineer Oct2011-Nov2013 Oversaw a team of three professionals responsible for database management andmaintenance. Worked on the backend interface using Oracle PL-SQLtechnology. Maintained and developed client s software interface as per client srequirement. Successfully trained three assistant system engineers in PL-SQL technology andCRM. Prepared Functional specifications, technical specifications, test plan and end usermanual. EDUCATION Suffolk University Boston, Massachusetts,USA Master of Science inBusinessAnalytics ExpectedDec2021 Master of ScienceinFinance Suffolk Graduate Fellowship in Information systems and operations management. Suffolk Graduate Scholarship. Associate Member, Suffolk University, Finance and Investing Club MIT Sloan School of Management Cambridge, Massachusetts,USA Certificate in Artificial Intelligence: Implications forBusinessStrategy Oct2019 The George Washington University Washington DC,USA Master ofBusinessAdministration April2019 GWU Scholarship. Kalinga Institute of Industrial Technology(KIIT) Bhubaneswar,India Bachelor of Technology,ElectricalEngineering Apr2011 Intern at Larsen & Toubro Ltd(L&T). ADDITIONAL INFORMATION Overall TechnicalSkills: SQL, SAS Enterprise Guide/Miner, SAP, Python, Advance MSExcel, Tableau, Power BI, Predictive modelling, Financial Modelling and Evaluation, Agile Scrum Methodology, R Programming, Financial Statement Analysis, Oracle DBMS, Microsoft SQL Server. Soft Skills: Communication, Teamwork, Adaptability, Problem Solving, Critical Thinking, Project Management, Strategy GlobalView: English (Fluent), Hindi, Worked with Clients from the US, APAC, UK, China and MiddleEast. Community: Closely worked with All India Heart Foundation (WHOrecognized). Member of People for Animals (PFA), a not-for-profit organization for stray animals Interests: Adventure sports, international travel, guitar, film, history of theworld. Keywords: quality analyst user interface business intelligence database rlang information technology golang hewlett packard microsoft procedural language Colorado New Jersey North Carolina Rhode Island Virginia