Business Analyst System
Resume:
Maulik P
ad3qz2@r.postjobfree.com
SUMMARY
15+ years of experience as a Business Analyst/Business System Analyst in industry domains including Banking with 7 plus years exp, State & City Agencies with 4 years exp, Insurance, and Retail with 5 years of exp.
Skilled Business Analyst in PMO environment who leads projects to successful completion and acts as liaison between business users and technical development teams to bridge gaps.
Strong understanding of financial valuation concepts and various capital market instruments and processes including Equities, Fixed Income, Foreign Exchange, Derivative (OTC) & Back-Office operations, Basel III, Dodd-Frank Act and Comprehensive Capital Analysis and Review (CCAR).and experienced in Black Rock Alladin, Bloomberg, Reuters.
Proficient in executing Test Plans, providing Test Data, conducting unit test, documenting test cases and in Manual Testing - Functional, Database, Black Box, Positive-Negative, and Regression testing.
Experience in writing User manual, conducting functional walkthroughs, and in performing extensive User Acceptance Testing (UAT), training the users, demo sessions with business.
Seasoned writing user stories in Agile Environment, leading Backlog prioritization and story refinement sessions. Experienced with waterfall model drafting, writing, and acquiring approvals for Functional Requirement Documents, FSDs etc.
Solution delivery on time from end to end implementation perspective.
Ability to manage multiple, concurrent projects, activities and tasks under time constraints.
Pragmatic approach towards any task, excellent communication skills, have handled stakeholder conflicts and delivering as per promised on a strict and disciplined time line.
Bringing whole team on the same platform, having communication channel open both ways in business terms with sponsors and technical with architect, developers, QA teams and implementation teams.
Hands on experience with SQL, Visio, Lucid Chart creating processes.
Experienced with Data mapping excercise for API (RESTful and SOAP) development along with Oauth, and security bearers tokens implemention, with POSTMAN, Swagger etc.
CERTIFICATIONS
Certified Salesforce Administrator
SKILLS
Business Analysis Skills
Scope Initiation, Business Proposals, Requirements Definition, Problem Resolution, Structured Walkthrough, Workflow Analysis, Gap Analysis, Design Review, Business Process Management, Product Management, Business Impact and Risk Analysis, Gate Review, Confirmations, Post-Implementation Review, Defect Management, Data Analysis, Data Reconciliation, Data Governance and Data Management.
Project Management Skills
Change Management, Client Relationship building, Risk Management, Strategic Planning and Reporting, Technical Writing, Budget Planning & Cost control, Vendor Management, Strategic Change Management, Onsite-Offshore Management, Virtual team Management.
Testing Tools (QA)
HP ALM, HP Quality Center/Test Director, HP Performance Center/Load Runner
Business Process Modeling
UML/ Use Case Diagrams, Class Diagrams, Object Diagrams, Package Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Communication Diagrams, Component Diagrams, Deployment Diagrams, Process Flow, ER Diagrams and Data Flow Diagrams (DFD)
Database
Oracle 11g, 10g, Oracle 9i, Oracle 8i and Rainstor file system, NoSQL (Mongo DB)
Oracle Applications
OAM, OIM Suite, Oracle 11i &R12 - GL (SLA ), AP, AR, FA, CE, OM, PO
Languages
SQL, UML
Operating Systems
MS-Windows
MS Office
Word, Excel, Outlook, PowerPoint, Visio, Project
Collaboration Tools
Microsoft Live meeting, WebEx Products, SharePoint
Miscellaneous
Salesforce CRM, Tableau, Amazon Web Services (AWS), Guidewire 6.0, Actimize (AML), iRise, Gliffy, JIRA, Black Rock Alladin, Bloomberg, IBM Rational Rose, Smart Draw 2008
EXPERIENCE
Israel Discount Bank (IDB Bank of New York) September 2021-Present
Sr. Business Analyst
Bank was switching from back-end payment service provider FIServe to Jack Henry Associates.. Hence all types of accounts, USD, Non-USD, every single product, and application was getting replaced with JHA applications & JXhange services. Core Conversion of data, validation of EDW, validation and testing of interfaces, scheduling all cybermation jobs, entire downstream applicatioin architect was getting impacted and thorogh requirement gathering, created SCR and SCR MODS. Captured current business process, enhanced EDW logic. Actively writing test cases, training UAT audience. Single handedly worked on document generation logic for every account type or CIF created on Front Office application Argo Keys. Core Finance projects worked on Front office application implementation – Argo Keys, Data Governance project – KYC, Online/Digital platform implementation – IDB Direct &IDB Access, Interest on DDA Vostro & Intoducing Fixed Rate Non USD Time Deposit (Foreign Currency), Adeppar (BAI2) implementation, Enterprise workflow Management, Integration of Service Now to JIRA, Mulesoft API Services.
Roles & Responsibility
Understoond and documented complex groups, cutomer grouping, and customer hierarchy within the existing eco-system for all customer types that is consumer and commercial, and assisted for the same plan and implementation plan for new payment service provider (JHA).
Closely worked with Front Office, and EDW team. Actively captured requirement for front office application Argo Keys application, from end to that is creation of customer (CIF), relationships, and all the products offered by the bank.
Analyzed the entire data flow, during CIF creation and which fields are required for KYC (Salesforce) Team, engaged actively with KYC team, creating field inventory, mapping of fields from front office application, salesforce to EDW, and other applications that needs to consume data.
Worked on CPS (Combined Period Statement) where objective was to provide one single statement to customer who have multiple products such as, DDA, TD, Non USD DDA, Loans etc. Worked closely with vendor RRD who generates the statements.
Did extensive analysis, using SQL queries joining tables, to validate, identify root cause to EDW team for solution approach.
XML testing and validation for any errors that are noticed for CPS, in UAT region.
Scheduled the logic of monthy DDA and TD file as part of cybermation to be dropped by JHA at the cut off date, and cybermation schedule to move the file to different Central Folder for RRD to pick up for processing, scheduled XML file monthly file to get ingested into EDW tables dedicated to CPS only.
Worked with Spectrum for Non USD Foregin Accounts, Custody Accounts, Wealth Management with Pershing, Insurance product with Sunlife and Loans with LoanIQ. Each service provider sends interface files, scheduled job for files to JHA silverlake backend single source application, and downstream consumption of data to EDW.
Worked single handedly on Forms, the bank have120 plus forms which runs on a logic based on account type, relationship, rate, tiered and non tiered, and state specific criterias.
Mapped each and every signle field for each form on word docs by doing mail merge, connecting with correct Data Source with criteria of required “Yes” ”No”, maintenance functions, customer level, and triggering on a very complex product code logic.
Wrote 120+ test cases for each form creation, for the end users to execute and validate the test cases.
Once the forms are ready coordinated with server team to drop the forms into correct folders in correct region.
Forms included for all product types, DDA, TD, Escrow accouonts, IOLTA accounts, 1031 Master Account, Foreign Accounts, Broker, Cash Management, W8, W9, beneficiary forms, customer level forms, DBUS- Domestic Business, FBUS-Foregin Business, DIND & FIND- Domestic and Foregin individual, MMS (DBUS,FBUS,DIND,FIND-Money Market Savings.
Created Ad-Hoc SCR requirements, as gaps were identified during testing, engaged with international user from Argentina, Brazil, Israel to gather requirements get sign off, after doing thorogh analysis of all down stream and up stream applications and working hand in hand with service provider JHA.
Hands on SQL analysis to identify root-cause, remidation, and UAT testing for every requirement. Good understanding of stored procedures to identify the logic of the file/API data flow and file creation.
Worked on Salesforce CRM community webpages for bank internal users, and integrating with Okta Single Sign on (SSO).
Once SCR customs were developed manually validated each customs and created test cases for the end users to test.
Worked with online digital banking team for launch of IDB NY online banking application for bothe iOS and Android Banno being the core for user management, creating new users CIF, and accounts, NETTeller IDs, assisted with set up, and created various test data for the users to test in relationships, sole ownerships, for all types of accounts along with proper funding of the accounts, activated positive pay and balance transfer functionality.
Enhanced W8 status based of a file received from CTI and creating an automated process to update the status on the core systems.
Orchestrated end-to-end digital banking implementation for entire bank, optimizing customer access and experience.
Segmented customer types and established personalized relationship-based access.
Successfully introduced E-Statement functionality and remote deposit capture for increased efficiency.
Collaborated seamlessly with JHA and MuleSoft teams to integrate external account plugins (FX, Loans, Securities).
Devised and executed comprehensive test scenarios to ensure flawless system functionality.
Worked on BAI2 reporting, end to end from field/data mapping at all headers, group levels, transaction code mapping etc with banks transaction code etc along with STPF file drop automation, to the vendors UI development.
Worked with Vendor on dashboard creation, and data file transfers with complete mapping of DDA, Non-USD DDA, Time Deposits (CD/TD), Loans, and Year End Tax Summary reports for product Adeppar.
Worked captured AS-IS and TO-BE with Treasury Ops as business for introducing new Non USD products DDA Vostro and Fixed Non USD Time Deposit.
Gathered requirement for Cognos report and wrote queries sourcing from dataware house for output files and direct feed to Cognos.
Environment- JIRA, confluence, Visio, SQL (Cyberark), Banno, Argo Keys, Silverlake, Synergy, cybermatioin, excel, Note++, XML studio, Cognos Reports, MS Project, MS Outlook.
State of Florida (Department of Economic Opportunity) February 2020-August 2021
Sr. Salesforce Business Analyst
Worked across the organization to revamp, connect all the programs (Benefits) under one platform. Different hurricanes, and disaster had benefits such as housing, employment etc offered by State of Florida, and the programs were all paper based. The vision to utilize Salesforce and have all business units connects, and working under their own application and have a more streamlined processes, to elimate the gaps and have more efficient and faster way to accomplish the goals. Worked across multiple business units and stakeholders, gathered requirement, did gap analysis, remidieate the gaps, along with processe. Trained stakeholders on salesforce instance.
Roles & Responsibilities
Worked across multiple business units, gathered requirements for 4 releases, and 3 programs.
Analyzed each users daily activities, and created profiles suited best for each person across the org.
80 profles created across multiple applications, and roles.
Created reports and dashboards for each business units.
Assisted developers in migration of data from legacy to salesforce.
Created 1 super user profile for each business units a total of 6.
Worked on lightning web component pages, and community pages.
Performed end to end testing of each application and or pience developed as per requirement.
Worked with multiple stakeholders across several business units on various functions within organization.
Created visio charts for business process of “AS-IS” of entire housing program, which involved 3rd party vendor too (IEM).
Captured process from inception of application registration ITA (Invitation to apply) (Vendor only processes before application transferred to DEO)
Captured requirements and created wireframes for business stake holders. On how salesforce instance can be converted into business process.
Assisted developers in creation of Apex classes, and lightning web components.
Entire workflow, designed, Application Registration ITA Verify Eligibility Verify DOB (Duplication of Benefits) ER (Environmental Review) Award Pre-Construction Construction Completed Denied Appeals Duplicate Multiple Award Due Diligence Compliance Monitoring.
Took ownership of multiple releases across many projects. Release 5,6,7,8,9 and two other damage and benefit related projects.
Created various types of reports and dashboards.
Managed entire project on JIRA and production issues on smartsheet. Created smartsheet reports for real time tracking.
Created daily batch upload of files from community pages to salesforce to Azure environment.
Performed end to end testing of each piece that was developed.
Organized demo sessions to stakeholders, assisted QA lead with test scripts.
Captured Sandbox testing issues and remediated quickly before moving to Production.
Integrated Docusign into Salesforce.
Integrated Conga component (Template only).
Handled 3 sandbox and kept every SB in sync with scheduled sandbox refresh. Used Prodly for data push from production to sandbox.
Integrated DocuSign, filed merges with salesforce pages and created workflow of the entire DocuSign process.
Created multiple front end applications on Qualtrics for infrastructure project. Applications consisted of surveys, capturing end user details and writing workflow on a YES/NO basis whether users are qualified for benefits.
Created reports and dashboard on Qualtrics for data analysis, and forecasting of disbursement of cash flow.
Environment:-JIRA,ServiceNow (Ticketing Module0, Smartsheet, Salesforce, Sandboxes, Eclipse, Jitterbit, Azure, Dataloader, Prodly, MSWord, Excel, Einstein Analytics, Docusign, Conga.
Citizens Bank (Johnston, Rhode Island) June 2019-January 2020
Business Systems Analyst
Engaged with middleware within the bank.Understood the business process, completely new work environment. Worked on the enterprise wide stardard theory and assisted in creating the vision for the bank, on API’s. Worked in a Scaled-Agile environment, 4 PODS running parallel, in two week sprints.One BSA allocated to 4 teams. Built peer relations across all domains within the bank Consumer Banking, Commercial Banking, Main Frame, FIS. Managed 38 projects in the pipeline, from requirements gathering, planning, execution, deployment, and prod support.Rigourous environment and balanced the work load as most projects were in waterfall and Middleware being in Agile. Worked on multiple projects-first ever bank to issue a debit card instantly at the branch location, revamped customer care service channel.
Roles & Responsibilities
As soon the project was identified reached out to stakeholders and gather more information about project on high level.
Organized and hosted API Intake Interview with the projects. Engaged with project team and Middleware team (Solution Architects, Product Owner, Principal Architect and assisted in decision making, of the solution)
Balanced the workload and requirements distribution with the POD’s as majority of the project requirement were Waterfall and Middleware being in Agile.
Worked hand in hand with two Product Owners, briefing them on the requirements gathered, analyzed if bank have any existing API’s or services that bank can leverage or enhance.
Created Epics, use-cases, user-stories, with definition of done& Acceptance Criteria on JIRA board.
Maintained, updated, uploaded Middleware related documents on Confluence.
Provided budget estimates to the project and intial analysis on the list of the services available based on the project requirement.
Worked and created mapping documentation, component design document, and broker services document, uploaded on SVN for middleware on SVN.
Worked on the frist ever project to instantly issue a debit-card to the customer. Backend was vendor. Constantly engaged with vendor and flushed out the design/YAML/Swagger needed for development. Helped solution architects in resolving the complex logic and workflow of the requirement.
Supported end to end development from gathering the requirement, assisting with desing, development and deployment.
Gathered test account data for the testers, for dev and SIT regions.
Helped tester writing the test cases, and handing off the testing to do component testing in SIT region.
Worked on Customer Care project, and dealt with all they types of accounts for both consumer tower and commercial tower, Savings, Checking, Credit Cards, ALS, AFS, Mortgage, Brokerage, Purged Accounts, SBA (Safe Deposit Box), RMS(recovery management system). Project had two work flows an unique requirement to identify MLS (service members on Customer level to the account level).
Helped designing Customers API on swagger, and lone handedly created API User Guides for enterprise wide standard API.
Constantly engaged in with stakeholders and understanding the requirements. Identifying the back-end services, engaged with backend resources for mapping of the middleware API fields to the back end fields.
Worked on Real Time Payments requirement, to have a real time payment interface, from intiating the payment, or requesting the payment, identifying the receiving bank is part of the network, knowing the status of the bank whether online or not, and receiving the payment.
Worked on Composite Deposit account(CD) a product within Savings Account, on how the payment and interest distribution spread should be whether direct deposit, pay to the affiliate, pay by check, or the pay to the joint-account holder.
Engaged with Access Optima, and integration of payments API with backend system of recordLoanIQ, worked on multiple requirements from getting the accoutlist, and transaction history and merging them into one response for the report generation for front end users.
Worked on Loans API, and the error handling and messaging of the transaction status to the customer. Helped developers with the IIB Component development and writing the logic.
Managed all deployments in across all regions SIT, QA and Prod migrations. Sending out email communications to all the consumers on the deployments and the changes on the version of the API.
Worked on salesforce for commercial banking and cosumer banking, on asset finance for lending & Loans portfolios, SSO, requirements.
Helped in development of Year End Tax Reporting services, adding new fields that IRS requires and supported end to end migration till Prod and delivered product on time due to compliance time-bound requirement.
Reviewed SRD & BRD for the projects flushed out Middleware requirements, gathered solution architects on the design and logic of the new services to be built or enhancing the existing one.
Worked with off-shore teams on many requirements, which included developers & testers.
Engaged with project on ACH calims, on reversal payment and stop payments, PEP+ as vendor.
Environment:- JIRA, Swagger, YAML, APIC, SOAPUI, Lucid Chart, MS Word, Excel, IBM-IIB Portal,JSON, JAVA, XML SPY, XSD, WSDL,Jenkis, Github SVN/Tortoise.
AMD (Advanced Micro Devices)-Austin, TX May 2018 to May 2019
Senior Business Analyst
Worked on two projects, a successful implementation of the company’s internal communication (Intranet). Improving the internal communication from end to end across all Business Units, and the effect of the change and implementation was global which included 7 Mega-Regions. Also worked on Business Process Management improving the business process finding GAPS and align all business units on multiple platforms from Opportunities, Sales to Pricing Process.
Roles & Responsibilities
Engaged in migration process strategy of entire data, which included all 7 regions across the globe.
Constantly engaging with business on their needs and assuring them on the data migration and compliance on GDPR (which got into effect while ongoing project).
Validation of SOX compliance.
Been part of the decision making and finalization of vendor and intranet product. (O 365, Bonzai).
Part of the monthly budget meetings, and leveraging the IT teams for approving the upcoming projects by giving presentations to the Executive Branch.
Worked as Finance BA on creating Deal Reviews, and giving executive summary for budget approvals, and creating CAPEX &OPEX requests for final decision making.
Constantly engaged with vendors and briefed them with the requirements, scheduling them for the business team for demo sessions and handled the entire NDA agreement process before engagement of the vendor and client.
Detailed out the migration process, and the elements of the data that needs to be intact.
Created backup data plan with retention period of 5 year, and ran SQL queries to verify the backup data is accessible.
Co-ordinated and organized off-shore teams during GO-LIVE and accessing Akamai for any redirects needed.
Managed entire project on Microsoft Project, scheduled daily sync ups with Product Owner and resolved any issues such as GDPR, migration strategies, approvals needed, financial road blocks.
Was the power user, for the new intranet, and trained KPIs, and other employees of the organization on how to create their pages, where the data resides, how sharepoint works, how to migrate archived data to the new intranet pages.
Supported all the issued tickets and resolved on a timely manner.
Created stake holders list (80), from each business unit for the Business Process Alignment and Management. (BPM)
Assisted a rigorous 39 days’ workshop “Sales Simplification Workshop”.
Understood the pain points of each business units and made extensive notes, gathered requirements.
Did AS-IS and TO-BE analysis, found GAPS and resolved those GAPS in the process.
Mapped business requirements with different units who were working on the same opportunity but had no visibility on other BU.
Captured TO-BE process from white board to MS-Visio and Lucid Chart simultaneously and presented to the stakeholder, had one on one sessions, JAD sessions and brain storming with Executives and other stakeholders on how to enhance & improve the current business process.
Worked with MDM consultant to organize the data.
Engaged with Forecasting team, on how to improve the data quality and have a better and accurate quarterly forecast. (Resolved OPN challenges via data cleansing)
Created RFP for multiple business units, forecasting, pricing, marketing communicating with stake holders and validated it with both IT and business units
Helped CPQ (Pricing team) on MS-CRM dynamics (COMPETE) for the post pricing process. Capturing the DPA (Disti Pricing Agreement).
Redesigned organizations opportunity pipeline.
Maintianed Clarity and Troux on a weekly basis for internal reporting of the status of the project for executives.
Used SQL, for data validation, mapping, and reports by creating joins.
Environment NDA, Sharepoint, Bonzai, O365, MS Project, Lucid Chart, MS Visio, Aure, SQL, Power BI, whiteboard, Excel, Powerpoint, Akamai,EPM, EDW, SAP, Marketplan, SilverPOP, MS-CRM, Clarity, Troux.
City of New York– New York, NY Feb 2017- April 2018
Senior Business Analyst
Main objective of the Gateway Modernization Project is to make doing business with City of Newyork easy and efficient by providing e-Government services that are simple and secure.
Responsibilities
• Experienced in business process mapping and system-based solutions to increase efficiency and reduce costs for clients.
• Successfully improved communication channels and reduced pending cases by connecting city departments.
• Conducted JAD sessions, focus groups, and surveys to gather requirements from various stakeholders.
• Communicated regularly with SMEs to understand city processes and department dependencies.
• Skilled in Salesforce.com application setup and customization, including creating page layouts, workflows, reports, and dashboards.
• Worked with clients to understand their business issues and pain points, and developed solution architectures to address them.
• Proficient in Wave Analytics, including uploading data, creating datasets, and designing dashboards.
• Expertise in JSON editing, data manipulation, and using various transformations.
Environment Saleforce.com platform, Apex, Visual Force, Data Loader, Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Security Controls, Sandbox data loading, Data Loader, SF Explorer and Eclipse IDE Plug-in, AppExchange apps, Flows, SOAP/REST API Wave Analytics, Agile/Scrum Framework.
Santander Bank – Boston, MA Aug 2016 – Feb 2017
Business System Analyst
Santander Bank, N. A. formerly Sovereign Bank is a wholly owned subsidiary of the Spanish Santander Group. It is based in Boston and its principal market is the northeast United States. It has more than $77 billion in assets, operates 723 retail banking offices and over 2,300 ATMs and employs approximately 9,000 people.
Implemented Salesforce to not only understand customers better, but also service their needs in a more efficient manner by implementing the Omni-channel Salesforce feature to describe 360-degree view of each client. Using Sales Cloud managed the entire lifecycle of third-party agents, from prospecting to onboarding and ongoing relationship management. Sales Cloud has led to 40 percent faster agent onboarding overall, which has cut costs and accelerated revenue growth. A newly launched initiative built on Analytics Cloud measures agent productivity, which helps company leaders identify and react to trends in operations effectiveness. Improved User Adoption of Salesforce Chatter within the company to communicate user groups, the social enterprise tool to stay aligned internally and shares the latest financial news and information in service of customers.
Responsibilities
Gathered business and functional requirements, worked with stakeholders and developers to formulate business processes, and prioritized requirements with product owner.
Developed and maintained Salesforce implementation, created reports and dashboards, and configured security and permissions.
Designed workflows, formulas, and validation rules, and performed testing and issue resolution.
Conducted user training and provided support for production and application issues.
Contributed to gap analysis, system integration testing, and revenue generation efforts.
Created dashboards and reports using Tableau Desktop and Server, and performed Tableau administration tasks such as user and project management.
Developed Customer portal to implement Web-to-lead functionality and enable lead capturing in real time and implemented and automation products with marketing automation techniques.
Maintained and improved existing Salesforce implementation. Created Fields, Record types and Page layouts.
Created newreport types, new reports and dashboards to monitor and issue regular key productivity indicator reports and chart.
Created Email Templates and letterheads and used them in workflow Email alerts.
Worked on Process flows, Wireframes and Mockups for the application.
Configured/Created Profiles, Roles, and Permission Sets, Sharing Settings, Custom settings for the organization and setting up Field-level, Object-level security rules for the application.
Developed Validation rules, Workflows and Formulas in different scenarios.
Worked with Apex Classes and Apex Controllers, Apex web services, Apex callouts.
Documented the entire process starting from Requirement document to end user training document.
MDM managed information about products, with a focus on data required to market and sell products.
Provided in-depth analysis to resolve production and application issues.
Provided a concrete explanation of resolutions to issues, inquiries and requests.
Verified the Business Scenarios on new builds to allow extended testing by the QA team.
After deployment of the product giving end user proper training on how to consume the product.
Training other staff member on how the process would work by creating pipeline, and building process builder and process visualizer.
Environment Salesforce.com, Apex (Classes-Controllers-web services), Outbound messaging, Data Loader, Wiki pages, MS Project, MS Visio, UML, JIRA, Agile, Tableau, Windows,SQL,SAS.
State of Indiana– Indianapolis, IN Sep 2015 – Aug 2016
Business Analyst
Computer Science Corp. has supported the Department of Health, IN for Health and Dental Insurance Claims and Eligibility efforts. The core data is in MMIS Legacy system and can handle the processing of different Claims within POS in MVS Site D and AIX Box. The MMIS can handle the HIPAA EDI transactions such as 835, 837 (P, D, I) 276, 277, 278. The Inbound and Outbound is run through JCL in batch mode
Responsibilities
Acted as a business analyst for a company creating business applications and middleware for insurance and healthcare clients like Anthem Blue Cross Blue Shield, Care, Cendant, Progressive and Allstate.
Conducted business process analysis, interviewed SMEs, gathered requirements, created use cases, and documented workflows using MS Visio.
Analyzed and tested Common Eligibility Outbound Interface Process, EDI claims, and trading partner specs.
Responsible for Data
Contact this candidate