SUMMARY

• Exuberant, pragmatic, and self - directed team player possessing most of the highly demanded organizational behavior such as agility, flexibility, and empathy. Ability to handle tasks that are consistently varying in nature that encompasses ability to pay attention to explicit and implicit details.
• Passionate about facilitating creative ideas that are emergent in nature satisfying ever changing technological and business demands.
• Strict adherence to compliances and formulating coherent problem-solving techniques is one of the core competencies.
• Excellent verbal, communication and interpersonal skills that could suit the internal culture of any organization.
• 9 years of work experience as Business Analyst/ Business Systems Analyst working with multiple domains and state client.
• Delivered numerous solutions under various SDLC environments including Waterfall, Agile Scrum, Kanban, Scrum ban, hybrid methodologies possessing abilities to work with cross functional and self-organizing teams.
• Deeply involved in drafting multiple artifacts such as Business Design Document (BDD), Functional Specification Document (FSD), Use Case Document, Risk Register, RACI matrix and various Technical and Product Documents.
• With Team I achieved various milestones, deliverables, vision, and objectives using Critical Path Analysis (CPA), GAP Analysis, Work Breakdown Structure (WBS), Earned Value Management (EVM) and Financial Analysis Models
• Extensive knowledge on Continuous Integration, development techniques like TDD (Test Driven Development), BDD (Behavior Driven Development) and ATDD (Acceptance Criteria Test Driven Development)
• Collaborated with Stakeholders, End Users, Business Owners, Product Owners, Project Managers, Scrum Masters, Tech Leads, DAs, UI experts, Developers, QA, Product Managers & SME’s at various levels.
• Expertise in Scrum Ceremonies including Backlog Refinement, Sprint Planning, Daily Standups, Sprint Review, Retrospectives.
• Assisted my team in estimating user stories using techniques such as Relative Mass Valuation, Planning Poker, T-Shirt Sizing which helped in delivering critical functionalities for release and maximize business value.
• Extensive practical experience in facilitating my team and creating Scrum Artifacts like Product Backlog and helped product owner defining Definition of Done (DoD), Definition of Ready (DoR), MVP (Minimum Viable Product) and MRF (Minimum releasable features) to assist with releases and assisted him in prioritizing user stories using various techniques
• Experience in analyzing diverse architectures, creating workflows, and developing business solution models utilizing Use Case Diagram, Data Flow Diagrams, Activity Diagram, Entity-Relationship Diagram with tools MS-Visio and Balsamiq.
• Experienced in creating Wireframes, Mockups and helping UI-UX developers to understand Business needs around UI-UX and inspect using tools such as, Signavio, Invison, Figma, Magneto 2.0 and Adobe XD.
• Assessed risks, issues, impediments efficiently and possess in-depth knowledge in Requirement Management, Change Management, Defect Management, Release Management, Project Management and Product Roadmap using JIRA, Confluence, HP ALM, SharePoint, and MS Project.
• Proficient in Data Modeling, Data analysis, Data Mapping, Data Migration, Data Integration & Data Profiling with the understanding of Data Warehouse System, Operational Data Store, Blockchain and Data Marts.
• Assisted Dev-ops, System Team and Development Team in creation and maintenance of Databases, Distributed Ledger Technology, Data Table Structures, Schemas, Online Processing Systems like OLTP and various OLAP Operations.
• Experience in creating Data Mapping Documents indicating transformations with operational knowledge in Extract, Transformation and Load (ETL) process using Informatica PowerCenter and Talend.
• Knowledge of Service-Oriented Architecture (SOA) such as XML & JSON data formats for communicating between the front end and back-end server using RESTful and SOAP APIs.
• Adequate knowledge in performing and creation of API Documentation, API Endpoint Validation using POSTMAN and Swagger to capture the Headers, Query Parameters, Resources, POST/PUT response body and different error codes.
• Knowledge on Salesforce Marketing Cloud, Analytics Cloud and Salesforce Administration which includes creating workflows, validation rules, approval process, field security settings, formula fields, creating and editing permission sets and OWDS (Organization Wide Default Settings), rollup summary, data imports.
• Experience in creating email templates, email content using Amazon Web Service (AWS) Pinpoint for targeted customer segments and ran targeted campaigns to drive user engagement.
• Experienced in Reporting tools such as Tableau, Qlik sense and Power BI to generate Standard Static Reports, Ad-hoc Reports, Visualizations, KPIs, Write-Back Reports and Interactive Dashboards
• Collaborated with QA Team in formulating Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Data, issuing the Test Reports and tracking requirements with the Requirements Traceability Matrix (RTM) using HP QC/ALM.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Waterfall-Scrum Hybrid, Agile-Scrum, SAFe, Scrumban, Kanban, XP.

Collaboration Tools: Confluence, MS SharePoint, GitHub

Requirement Management: Jira, HP ALM, MS Office, MS Excel, Azure DevOps.

ERP & CRM: Salesforce CRM, Oracle Peoplesoft, SAP.

Modeling Tools: MS Visio, Balsamiq, Signavio, Invision, Lucid Charts, Figma.

ETL Tools: Informatica Power Center, Talend.

Analysis and Reporting Tools: Tableau, Qlik Sense, Microsoft Excel, Analytics Studio, Power BI.

Databases: MySQL, PL/SQL, Oracle.

Testing Tools: HP ALM/QC, JIRA.

Web Services and API Tools: SOAP, RESTful, XML, JSON, Swagger, Postman.

PROFESSIONAL EXPERIENCE

Confidential, New York city, NY

Lead Business Analyst

Responsibilities:

• Resolved malfunctions with systems and programs through troubleshooting supporting NYC's 41 agencies.
• Prepare future enhancements and suggestions by learning drawbacks to the current system, proposing new solutions.
• Conduct feasibility study for agencies related to PASSPort system developed by the City of NY.
• Create and help associate directors in conducting office hours or learning workshops for new features, releases, and activities in the system.
• Working with ServiceNow and Remedy systems to create, track and resolve tickets with offshore team.
• Helped my team in moving from BMC’s Remedy system to ServiceNow, Creating interactive dashboards in ServiceNow.
• Track and recognize various pain points and problems coming to agencies daily. Resolve issues with help of an offshore team.
• Assist Management with project management activities for future releases, mapping resources, and developing budget estimates.
• Manage good accounting practices with all the agencies and assist them to encumber funds if any problem is generated.
• Using Business design document help users troubleshooting problems and resolving issues around PASSPort.
• Help generate Purchase order and encumber funds in PASSPort and FMS SAP based system (NYC applications).
• Checked API, System integration logs in XML to identify data authenticity and shortcomings that caused FMS errors.
• Produced accurate and timely collections reports, facilitating measurement, decision-making, and engagement with agencies.
• Improved processes within collections and rigorously tested test and learn strategies throughout collections processes.
• Performed troubleshooting of technical issues within production environment.
• Troubleshot incidents reported by end-users to schedule system changes and identify permanent solutions.
• Created various Guides and Documents to help users navigate through PASSPort which were displayed on public portal.
• Managed ETL processes with Data Team for Catalogs and PQL for PASSPort.
• Owned Weekly report outs to directors and associate directors regarding system issue.
• Performed testing in lower environments to resolve system issues or identify user errors in PASSPort.

Environment: Hybrid Scrum and Waterfall, Remedy, ServiceNow, JIRA, MS-office, SharePoint, PASSPort, XML, FMS, ETL.

Confidential, Wilmington, DE

Senior Business Systems Analyst

Responsibilities:

• Gathered Requirements from end-users such as Business user, stakeholders, and SME’s such as financial analysts, Accountants, Developer by conducting elicitation techniques like Brain Storming, Interviewing, Prototyping, Document Analysis, Interface Analysis and JAD (Joint Application Development) sessions.
• Supported the Product owner by assisting in creation of Project Plans, developing the Project Workflows, Creating Scope Documents, Project Roadmap along with the process of scheduling and tracking project timelines
• Assisted Product Owner with prioritizing User Stories based on MoSCoW model, defining Definition of Ready (DOR) and Definition of Done (DOD) and defined acceptance criteria for different User Stories.
• Analyzed and defined AS-IS condition of existing System and process. While analyzing Business Requirements to determine TO-BE state after the project is successfully implemented or created.
• Created Process flow diagrams to map out strategy and plan to fill the Gap between by performing Gap analysis
• Actively participated in all the scrum meetings like sprint planning, daily standup meeting, sprint review, sprint retrospective and product backlog grooming.
• Assisted in creating system using open-source Kubernetes Platform and API’s and created smart contracts with the help of developers to automate the process and assisted for a better understanding of business contracts.
• Assisted Team in Data Integration from on-premises oracle database to Blockchain and helped in writing and documenting the transformation logics in the Data Mapping Specification Document.
• Assisted in ETL process to define what business logics are being used. Assisted in defining Target Data accordingly.
• Created Data Flow Diagrams to understand the data flow throughout the system and organization to balance load and understand Miner, channel, payment and clearing node configuration for optimal performance of system.
• Jointly responsible for creating Test Plans, Test Scenarios & Test Cases with the testers from the team and oversee testing of the system during Smoke Testing, Regression Testing and User Acceptance Testing
• Created various Reports like bar graphs, interactive live dashboards, heat maps using Tableau for Data Analysis
• Created various Confluence pages and spaces to manage requirements, meeting to enable cross functional communication and document sharing between Team members.
• Worked on SQL queries using unions, joins, aggregation, order by & group by to extract data from different data sources.

Environment: Agile-Scrum, Salesforce CRM, Azure Architecture, Email studio, Swagger, MS-PowerPoint, Kubernetes, Mobile studio, Process Builder, Journey Builder, Informatica PowerCenter, Confluence, JIRA, Balsamiq, Tableau.

Confidential, Charlotte, NC

Sr. Business System Analyst

Responsibilities:

• Designed use-case diagrams, process flow diagrams, activity diagrams and sequence diagrams using Signavio to define the interactions of the customer with the Trading Platform.
• Assisted the Product Owner in the Definition of Done (DOD), Definition of Ready (DOR), Product Roadmap, Requirements Analysis, creating MVP, assisted him to prioritize the Product Backlog Items. Helping the team to Breakdown User Stories
• Worked on JIRA to capture & manage User stories and to define User Story Acceptance Criteria. Kept track of bugs and defects using JIRA, maintained issue logs and handled the change requests efficiently.
• Verified compliance documents for customer KYC, Customer Due Diligence, FCRA (Fair Credit Reporting Act), FACTA (Fair and Accurate Credit Transaction Act) & FCBA (Fair Credit Billing Act) to meet compliance standards.
• Developed System to comply with existing Amazon Web Services Architecture.
• Created API Documentation and API Endpoint Testing using POSTMAN to validate the request for RESTful services in XML/JSON format using functionalities like GET/POST to capture errors and validate data.
• Assisted in the implementation of the Salesforce CRM to facilitate the development of the cloud-based CRM.
• Worked on Salesforce Mobile Studio, Email notifications, Push Notifications to help automate business processes and built campaigns for the customers in Journey Builder that mapped out the complete customer journey.
• Used Conceptual Data Models and Logical data models, identified entities, attributes, relationships by referring to the Data Dictionary, Data Glossary and E-R Models for source exploration.
• Applied Data Transformation rules such as filter, router, aggregator, joiner, sorter. Identified Source Data & Target data needs, performed Data Mapping, Data Profiling, as part of ETL process using Amazon Glue.
• Provided Valuable insights to Team from gathered Stakeholder Feedback and communicated with team during/after User Acceptance Testing (UAT).
• Clarified business requirements and outcomes from system during Smoke Testing, Sanity testing, Integration Testing and Regression Testing.
• Developed SharePoint workflows, applications to improve project management and content management practices.
• Worked closely with the reporting team to ensure correct data is presented in the generated reports using Power BI.
• Worked on SQL queries like joins, aggregation, order by & group by for Data Analysis, validation, and profiling.

Environment: Agile-Scrum, AWS RDS, AWS S3, AWS Athena, Amazon Cloud Web Services, MS-PowerPoint, SharePoint, HP ALM, Figma, POSTMAN, JIRA, JAVA, Power BI, Amazon Glue, Salesforce CRM, Salesforce Marketing cloud.

Confidential, Morrisville, NC

Business System Analyst

Responsibilities:

• Assisted the Product owner in interviewing Subject Matter Experts in Credit Score and Bureau reporting along with few employees to get a thorough understanding of business processes & analyzed the data structure, hierarchy.
• Discussed and gathered the requirements from different stakeholders like Portfolio Managers, End-users using interviews, JAD sessions, surveys & then documented before giving it to the team in the form of product backlog items.
• Supported the Product owner by assisting in creation of Project Plans, Roadmaps developing the Project Workflows, Creating Scope Documents along with the process of scheduling and tracking project timelines
• Participated in Source system exploration, analyzing existing Front-end applications, middleware, and Mainframe Databases to come up with Migration Plans and Strategy.
• Consistently involved in the ETL process using Talend assisting ETL developers in applying designer transformation logics, preparing workflow sessions, and monitoring the process results.
• Assisted in performing Data Normalization process to eliminate data redundancy and faster query processing
• Used SQL queries (select, insert, update, delete, sub-queries, joins) to manipulate the data in the databases.
• Worked on AWS Pinpoint, Email notifications, Push Notifications to help automate business processes and built campaigns for the customers.
• Involved in API documentation and API Endpoint Testing along with the development team.
• Developed Test Plans, Test Cases, Test Scripts to assist in System Integration, Performance & Functional tests.
• Generated various Dashboards and Project Closure Reports using Tableau promoting business insights & trends.

Environment: Agile-Scrum, UML, MS-Visio, MS-Project, JIRA, Tableau, Talend, Amazon Web services, MS-PowerPoint, AWS Pinpoint Salesforce Sales cloud, Oracle, Confluence, MS PowerPoint, Lucid Chart, HP ALM, Invision.

Confidential

Business System Analyst

Responsibilities:

• Assisted in generating a streamline process to understand the various steps in the Loan Lifecycle and desired functionality of the new system by interacting with users, SMEs, stakeholders, lenders, underwriters.
• Identified and analyzed needs for various functionalities by using various techniques such as Document Analysis, Focus Groups, and Interviews with Subject Matter Experts (SMEs) and project stakeholders.
• Prepared the function flow of application; by creating High fidelity Wireframes and Mockups using Invision.
• Performed GAP Analysis by understanding the AS-IS business process and TO-BE business process and created Business Process Model and Notation (BPMN) document using Microsoft Visio.
• Developed several activity and sequence diagrams with swimlanes and UML components to show entity relationship diagrams (ERD) using Lucid chart and Microsoft Visio for the developers and data architects.
• Assisted in elaboration of epics into user stories in Product Backlog Grooming Session so that stories are granular.
• Designed API technical documents and conducted API designs sessions to understand their functional features of REST, HTML, XML using Postman and worked on developing API integration documentation using Swagger.
• Worked with the QA team for validating Test Plan and Test Cases for Integration testing, Regression Testing, Whitebox Testing, black Box Testing, Smoke Testing and assisted in facilitating User Acceptance Testing (UAT).
• Conducted end-to-end data validation of data flow and created the Data Mapping Document, prepared ETL routines.
• Used Tableau to generate credit check reports and application status reports.
• Wrote and executed SQL queries to perform data analysis, data validation and data manipulation on Oracle 12c DB.

Environment: Agile-Scrum, MS Office, MS Visio, MS Project, Invision, Magento 2.0, HP ALM, Web Services, MS-PowerPoint, JAVA, REST, SOA, HTML, XML Web Method WSDL, Tableau, Oracle 12c, SQL, Postman, Swagger, JIRA, Confluence.

Confidential

Business Analyst- SAP FICO

Responsibilities:

• Responsible for SAP Master Data maintenance in accordance with the SAP Master Data best practices, policies, and procedures.
• Assisted project manager in creating business cases and Project related documentation.
• Worked on ServiceNow platform to map all the business process and workflows for enhancement and better understanding.
• Design solutions to meet business requirements for quality team and cross-functional processes for the business
• Resolving tickets on SAP Master Data around customer master, Vendor master, Material master Data
• Performed End to End testing from Order to Cash, Data Migration and Rollout.
• Worked extensively on Team Site SharePoint updated, edit, and created web pages
• Taking care of overall AP activities within SAP, Working on ACH payments, AP Workflow, and Intercompany posting
• Taking care of day-to-day activities on Invoice posting, Parking, validating, and processing for the payment

Environment: SAP, MS-Excel, MS office suite, SAP FI-CO Module, MS-PowerPoint, SharePoint.

Confidential

SAP Master Data Management Analyst

Responsibilities:

• SAP Legacy System Harmonization and Interfacing Master Data Objects, Fields, Data Sets Collection, Consolidation, Cleansing and Uploads. Test and Validate Collected Master Data
• Responsible for all master data maintenance in SAP (FI-CO, MM, SD, ETC.) within the supporting business reorganization, process changes and data updates
• Configuration of SAP FI-CO module and various chart of accounts (operational, group and country specific)
• Created training documentation, MDDDs and process flows
• Utilized MS Access to validate data and extracted custom reports as requested
• Created custom queries and responsible for SAP troubleshoot issues
• Took part in all SAP integrations and functioned as SharePoint site manager
• Created new processes for multiple business units

Environment: SAP, Master Data management, MS Access, MS word, MS Excel, MS-PowerPoint.