SUMMARY:

• Sr. Business Analyst with over 8 years of IT experience in Banking and E - commerce domains.
• Experienced in banking sectors such as Payment Processing (Automated Clearing House, credit networks, wire transfers), General Ledger master accounts, Fixed Asset invoices, Cash Balance management, Cash Flow Analysis, Intraday Liquidity.
• Experience working in Salesforce.com Sandbox, Integration and Production environments.
• Hands on experience with solutions implementation, complex customizations and configuration of Sales Cloud, Financial Services Cloud and Marketing Cloud. Develop SOQL queries for data manipulation from cloud.
• Experienced in SAP FIORI App configuration for IOS and Android devices.
• Extensive experience in GL, AP - Procure to Pay (P2P) and AR - Order to Cash (OTC) processes.
• Excellent understanding of Business Processes relating to SAP FI (Finance), CO (Controlling) and Integration with SD (Sales and Distribution), PP (Production Planning), MM (Materials Management) modules.
• Proficient in all stages of SDLC and experienced in Waterfall, Agile Scrum framework and SAFe.
• Strong knowledge SAFe concepts like Solution, Program Team levels, PI objectives, WSJF prioritization, PI planning meeting, team and system demo, and continuous delivery pipeline through DevOps, collaborating with Solution and System architect to develop enablers for Architectural Runway.
• Strong knowledge of creating artifacts in the planning like Project Charter and Project Management Plan.
• Expertise in conducting various types of analyses such as AS-IS and TO-BE analysis, cost benefit, risk and impact, and feasibility analysis for better understanding of the business scenario on a project.
• Skilled in conducting/facilitating various types of requirement elicitation techniques such as Interviews, Brainstorming, JAD Session, Focus groups, Document analysis.
• Solid understanding of documentation through BRD, FRD and SRS, business process model, Use Cases, Requirements Traceability Matrix (RTM), Implementation logs, Review reports during maintenance.
• Experienced assisting and creating mockups, prototypes and wireframes with UI/UX experts for systems.
• Adept in all the different ceremonies in Scrum such as Release planning, Backlog Grooming, Sprint planning, Daily Scrum, Scrum Review and Scrum Retrospective.
• Proficient in creating user stories with well-defined acceptance criteria; helped defining clear Definition of done for each sprint.
• Knowledge of various prioritization techniques such as Kano model, Moscow method and Card sorting; and estimation techniques for user stories like Playing Poker, T-shirt sizing and Relative mass valuation.
• Adept in defining MVP (Minimum Viable Product) & MRF (Minimum releasable features).
• Expert in driving Agile best practices such as time-boxing, continuous integration, refactoring, Test Driven Development (TDD), Behavioral Driven Development, technical debt reduction, code/design reviews.
• Hands-on experience creating conceptual and logical data models and ER models for the Data warehouse.
• Expertise in Extraction, Transformation and Loading (ETL) concepts, along with experience in implementing Data marts, OLAP cubes, Data mapping, Data transformation and OLAP operations.
• Expertise in creating complex SQL queries in SSMS, MySQL, PL/SQL with advanced functions such as joins, group by, create views, sub-queries, having clause, over clause, partition by, stored procedures.
• Well-versed in reporting tools for developing different types of business intelligence (BI) reports spreadsheets, charts, dynamic visualizations, self-service dashboards based on end-user or stakeholder specifications.
• Expertise in 3-tier system architecture and Web Service standards (REST, SOAP).
• Experienced in documenting REST API request and response files; strong understanding of XML and JSON.
• Involved in meetings with the QA team for Test Planning, Test Preparation, Test Execution.
• Reviewed Test plans to make sure all the requirements have been covered. Created test cases based on the test scenarios recognized during QA meetings. Analyzed test results for sanity and conformability.
• Experienced with Functional and User Acceptance testing involving Business users, Development and QA teams.

TECHNICAL SKILLS:

Domain: Payment processing, General Ledger master accounts, Fixed Asset invoices, Cash balance management, Cash Flow, Intraday Liquidity, Automated Clearing House payments, credit networks, wire transfers

SDLC Methodologies: Waterfall, Scrum, SAFe

Design and UI: Microsoft Visio, InVision, Adobe XD

Project Management: JIRA

Collaboration: Confluence

Data Warehousing: Informatica, Microsoft SQL Server, SSIS, SSMS, MySQL

Languages: JSON, XML, SQL

Reporting: Tableau, Excel

Testing: HP ALM, HP QC, Zephyr (JIRA)

Technology: SAP S/4 HANA, FI/CO, SD, MM, PP Modules, SAP FIORY Apps, Salesforce Financial Cloud, Salesforce Lightning, SOQL, Apex

Big Data: Hadoop HDFS, Mahout, Apache Spark, Hive, Apache Pig

PROFESSIONAL EXPERIENCE:

Sr. Business Analyst

Confidential

• Assisted the Scrum team in creating user stories from the requirements gathered from SME and clients.
• Conducted interviews and focus groups to elicit client-based UI interface configurations and requirements.
• Managed all the different types of issues like tasks, epics, defects and tests cases through JIRA.
• Assisted the Product owner in creating and prioritizing user stories from epics recognized from stakeholders and establishing concrete Acceptance Criteria and discussed Definition of done for each sprint.
• Created mockup designs and frames for the new portal using InVision, to test the aesthetics of the system.
• Designed landing page, menu items, transitions between pages, style font and color scheme of the portal based on signature styling of the company with the help of UI/UX designers.
• Used Lucid chart to create business process models, UML diagrams such as Sequence and activity diagrams of the workflow between the backend server in HDFS and Cloudera Enterprise Data Warehouse.
• Assisted in REST API designing and documentation for transaction request and ACK response files.
• Assisted in the integration of Apache Spark with EC2 instances over HDFS for in-memory computations to achieve real-time or near real-time analytics and reporting on cash flow and liquidity.
• Developed the conceptual and logical models for the cash flow metrics and liquidity computations in the data warehouse by understanding the underlying payment network logic.
• Developed data mapping document and helped create the scripts for the exploration and scrubbing algorithms in Mahout for the EC2 instance to analyze the syntax files.
• Created dynamic data visualization dashboards using Tableau for analyzing daily liquidity and capital efficiencies; also created reports in Excel to provide insights on operations and compliances.
• Designed and executed complex SQL queries in Microsoft SSMS for testing automated ETL process used for data integration into the Cloudera EDW, using analytical functions like stored procedures, sub-queries, case when statements, group by, partition by and over clause.
• Created test cases based on test scenarios identified through the project and tracked them through JIRA.
• Worked with the QA team in analyzing the test results from Zephyr plugin in JIRA.

Environment: Agile Scrum Framework, Hive 2.3.3, Mahout 0.14.1, Spark 2.3.0, JIRA 7.5.4, Confluence 6.7, Lucid Chart, RESTful, JSON, Amazon EC2 instance, XML, JSON, Zephyr, SSMS 17, Tableau 2018.1, MS Office.

Sr. Business Analyst

Confidential - Wilmington, Delaware

• SFDC requirement elicitation and coached junior business analyst in converting business requirements to technical specifications, designing the solution and work closely with Stakeholders, Architects, Developers.
• Managing users, Public Groups, Profiles, and Roles within the Salesforce CRM.
• Contributed and gathered requirement to design and development of campaigns for mobile application. Worked with the Product owner in creating feature stories and slicing them into user stories for development.
• Involved in creating Formula Fields, Validation Rules, Workflows and approvals, Process builders for the flexibility and functionality of force platform application and to help automate the different types of actions.
• Integrated Salesforce with 3rd party systems using web services and App exchange for greater usability.
• Assisted with REST API design and integration with other systems for extracting the data from the on-premise applications by using the on-premise web services. Also conducted API documentation for the same.
• Assisted with development and deployment of outbound change sets from Sandbox to Production system.
• Used SOQL & SOSL Queries with consideration to govern limits for data manipulation needs of the application using Force.com explorer and to support various item-level analytics on database objects.
• Used Data Loader for insert, update and bulk import or export of data from Salesforce S-Objects. Used it to read, extract, and load data from a comma-separated value (CSV) file.
• Involved in the development of custom transactional logic, web services and email automation through Apex.
• Used Cucumber for Behavior Driven Development and connected it to Jenkins CI Tool.
• Designed the Test Cases from Test Plans for all the processes using Confluence and tracked defects on JIRA, hence was part of Black Box Testing, and System Testing.
• Hands on experience on Salesforce Lightning for customizing reports and dashboards for business use.
• Designed and created reports and dynamic visualization dashboards such global payment revenues, liquidity revenues, volume rate of electronic transactions, cross border payment flow analysis on B2B, B2C and C2B, etc.

Environment: s: Agile-Scrum, Force.com IDE, Jenkins 2.53, JIRA 7.3.5, Confluence 6.1, Amazon DynamoDB (AWS), Salesforce integration tools, Cucumber 3.0, SOQL and SOSL queries through Force.com explorer, SOAP, REST.

Business Systems Analyst

Confidential - O’Fallon, Missouri

• Assisted Product owner for multiple scrum teams working on payments space via multiple payment processors.
• Collaborated with the Scrum Team and served as the customer proxy for solutions. Reviewed and prioritized the backlog for Agile Release Train (ART) ceremony readiness.
• Acted functional domain expert for ACH, Wire and Check Payment processing.
• Acted as a functional expert for the scrum teams for the payments and order initiation.
• Defined user stories and acceptance criteria with the Scrum teams.
• Coordinated content dependencies and milestones for the PI with different Product Owners.
• Acted as the supporting source for user story details and prioritization. Worked with the team to break down backlog items into user stories for implementation.
• Assisted the Business owners, Product management, System/Solution Architects, Agile teams and stakeholders to facilitate preparation and readiness for each PI planning.
• Worked with the Scrum Team during the ART ceremonies by providing story definition and providing clarification as necessary to assist the teams with story estimates, sprint loading, story sequencing and drafting team-level objectives for upcoming Potentially Shippable Product Increment (PSPI)
• Worked with the Solution and System Architect to identify and resolve areas for architectural runway.
• Executed and coordinated the Sprint/PSPI artifacts such as Release Notes, User Guides, Rally updates, etc.
• Worked with QA team in developing test strategy. Facilitated User Acceptance and Performance Testing.
• Assisted in producing an aggregated system/product demo for key program stakeholders.
• Created BI reports to help the team identify client account, payment networks, position and trade data using complex SQL queries.

Environment: SAFe Agile, Microsoft Office 2016, Rally, JIRA 7.0.11, Confluence 5.10, PL/SQL 11.0.5.

SAP Business Analyst

Confidential

• Elicited requirements for understanding how each SAP module works with the ledger accounts, creating of trial balance for comparing sub-ledger debits and credit, material groups, etc. for mapping existing dimensions.
• Regularly interacted with users to ensure proper understanding of the Business and Functional specifications.
• Identified issues in the backlog and escalating them to the developers using JIRA Tool and reporting existing issues and gaps to Project Manager. Managed project spaces and meetings in Confluence.
• Assisted with chart of accounts, account groups, field status groups, and posting keys, assigned these variants to company codes, created GL Master records, reconciliation accounts for sub-ledgers, document types, number ranges, invoices and payments, tolerance groups, automatic account assignments, GL display (line item layouts, special fields, sort variants, totals variants) and financial statement version.
• Worked on Electronic Bank Statement (EBS), Positive pay, ACH payments and Wire Transfer, liquidity forecast and configuring and customizing multiple payment methods and automatic clearing.
• SAP Fiori App configuration for iOS and Android devices
• Worked with MM processes like Logistics Invoice Verification (LIV), credit debit memos, maintaining Material master data, material and purchasing groups, purchasing info records, MM Pricing procedures, etc.
• Involved in building simple finance solution for client on SAP S/4HANA Finance 1605 on-premise platform.
• Involved in configuring SAP FI- GL, AP (Procurement-to-pay), AR (Order-to-Cash Process), Banking Integration for SAP FI/CO with MM/IM, SD, PP as per business process.
• Designed and documented Test Cases for each SAP module integration on HANA platform in every sprint.
• Facilitated UAT with the business users for evaluating the GL, AP, AR modules on S/4HANA Finance platform.
• Configured the system to deduct a cash discount for payment of fixed asset invoice automatically and in real time.
• Configured setting for revaluation of fixed assets, normal depreciation run and posting of asset acquisition.

Environment: Scrum, SAP ECC 6.0, Modules FI/CO- GL, AP, MM, SD, S/4 HANA platform, Fiori Apps, SharePoint 2013, MS TFS 2013, MS Office Suite 2013.

Business Analyst

Confidential

• Gathered business requirements by driving user-group meetings and working with various global, cross-functional and virtual teams.
• Prepared Business Requirements Document (BRD) and Functional Requirements Document (FRD).
• Experience and skills in creating design models through UML for modeling views using tools like Microsoft Visio.
• Followed traditional Waterfall SDLC (Software Development Life Cycle) to validate EDM system.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Assisted in Requirement Analysis and developing Use Cases, Activity Diagrams using Rational Rose.
• Worked with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing (UAT).
• Involved in documenting the UAT test plan and executing test cases with Users to ensure user acceptance
• Received the Client and Business user’s appreciation for the implementation of Prescriber NPI update and E-prescribing changes.

Environment: Waterfall, Microsoft Office 2010, Microsoft Projects 2010, Rational Rose, Microsoft SSMS 2008.

Data Analyst

Confidential

• Collected databases for different countries from data vendors in specified formats and used Nielsen Advisor and Aztec temple for data extraction.
• Performed data cleaning, data formatting and data consolidation in Excel for all the product categories.
• Created scripts in Microsoft VBA to automate Excel functions, perform data profiling prepare reports.
• Used advanced Excel functions such as VLOOKUP, SUMIFS, pivot tables to do market, product and metric segmentation of the raw data.
• Prepared data mapping documents with transformation logic for data processing in SQL Server.
• Worked on different data formats, Flat files, SQL files, CSV files.
• Designed data transformation workflow in SSIS involving various types of transformations such as join, lookup, sorting, filtering and SQL transaction.
• Prepared SQL queries in SSMS using functions like group by, having, sub-queries, over clause, partition by etc. for quality checks on the transformation performed in order to analyze data accuracy and integrity.
• Used scripts prepared in SSRS to upload data into the on-premise data warehouse with pre-defined dimensions and fact tables mapped from the incoming raw data from the databases.
• Developed automated templates in Excel to create major deliverable International Market Share report.
• Used Tableau for creating dynamic visualizations and dashboards for further study on the client’s data such as international product performance and country-wise comparative analysis dashboard.
• Communicated any issues during the project over weekly meeting with the client and created solutions.
• Documented all the business process flow of the project and QA tasks; also prepared on-boarding study manual for any new hires. Conducted knowledge transfer sessions for the same.

Environment: Microsoft SSIS & SSMS 2008, MS Office suite (2013), Tableau 8.1, Nielsen Advisor, Aztec Temple.