SUMMARY

• 9+ years of comprehensive experience as a Business Analyst distributed across Business Development processes and Information Technology with extensive work experience in diverse sectors such as e - commerce, retail and supply chain.
• Expertise in Supply Chain domain with a focus on Procurement, Resource Allocation, Merchandise Planning, Pricing and Invoicing, Demand Planning & Forecasting, Reverse Logistics, Warehouse Management System (WMS), Transport Management System, Accounting and baseline change requirements per contractual terms & earned value methods.
• Specialization in developing and executing IT and business strategies for Lean manufacturing, Value chain streamlining, SKU Rationalization, Demand Forecasting and supply chain optimization processes like warehouse-slotting, route planning and vendor analysis.
• Well versed in analyzing CRM business processes that include Forecasting , Campaign management , Lead Management, Role Hierarchy, Territory Management, Order Management, Inventory Management, Account Management, Case Management and merging managemen t in a multi-tier business environment.
• Designed & deployed custom dynamic workflows, validation rules, Approval Processes & Auto-Response Rules for automating business logic with Sales & marketing cloud on salesforce.net.
• Experienced in SAP ERP and Salesforce integration using MuleSoft, migration from SAP HANA to AWS using Informatica.
• In-depth knowledge of Software Development Life Cycle (SDLC) involving both the traditional methodology such as Waterfall and Agile methodologies such as Scrum, SAFe, Kanban, Scrumban, Waterfall-Scrum hybrid and XP.
• Experienced at utilizing various Elicitation techniques such as document analysis, interviews, focus groups, JAD sessions and brainstorming to derive the functional, non-functional, business and technical requirements from the stakeholders.
• Efficiently collaborated in multiple projects with Business Users, Key Stakeholders, Product Owners, Project Managers, Product Managers, Data Analysts, Scrum Masters, Architects, UX designers, Developers and Testers.
• Experience in analyzing the AS-IS and TO-BE systems, change requests and feasibility reports using techniques like GAP Analysis, SWOT Analysis, Impact Analysis, Root Cause Analysis, Cost Benefit Analysis, Feasibility Study and Risk Analysis.
• Collaborated with Project Manager in creating Project Management Plan, Project Charter, Work Breakdown Structure (WBS), Gantt Chart, Critical Path Analysis, Project Schedule and Budgeting using MS Project and MS Excel together.
• Experienced in creating Business Requirement Document (BRD), Functional Specification Document (FSD), System Requirement Specification (SRS) and Requirement Traceability Matrix (RTM) for multiple paths of the project.
• Used JIRA for managing User stories, defect lifecycle management and contributed in Scrum Ceremonies like Release Planning, Daily standup, Backlog grooming, Sprint Planning, Sprint Review and Retrospective while assisting Product owner in choosing prioritization techniques like Moscow, Kano and estimating techniques like Agile Poker, T-shirt Sizing.
• Sound familiarity with development techniques in Agile such as TDD (Test Driven Development), BDD (Behavior Driven Development) and ATDD (Acceptance Test Driven Development) based on the specific business needs.
• Knowledge and understanding of Continuous Integration and Continuous Deployment (CI &CD) using Jenkins and GitHub
• Expertise in creating Unified Modeling Language (UML) diagrams like Use Cases, Activity and Sequence diagrams using MS Visio and worked on both High Fidelity and Low Fidelity Mockup Screens and wireframes using Lucid Chart and Balsamiq.
• Proficiency in implementing various schemas like star, snowflake, galaxy schema & conducted Proof of Concept (POC) demos and project reviews
• Knowledge in Conceptual, Logical and Physical data models and experienced in creating Entity-Relationship diagrams.
• Deep understanding of database concepts like Data Warehousing, Dimensional Modeling, Relational Database Management System (RDBMS), Data Marts and OLAP operations such as Drill-Down, Roll-Up, Slicing and Dicing.
• Widespread knowledge of extraction of data from source systems, transformation and load process (ETL) for a Data Warehouse using tools like Informatica, MuleSoft and gave technical support in the use of Informatica for testing.
• Proficient in several AWS services EC2, VPC, S3, Cloud Watch , Kinesis, Auto scaling configurations
• Experienced in using different protocols like SSL, HTTP, HTTPS, Force.com IDE, Validation rules, SOQL SOSL
• Proficient in Business Intelligence (BI) tools like SAP BI, Einstein analytics, MS Power BI and Tableau .
• Extensive experience in creating interactive dashboards and data visualization reports using Tableau and Power BI.
• Hands on experience in retrieving data and data validation using SQL queries like Joins, Views, Sub queries and Aggregate functions like max, min, sum and average with good understanding of Stored Procedures, Functions and Triggers.
• Strong understanding of web service concepts like HTML, WSDL, WADL, SOAP, UDDI, REST, JSON, Parsers - SAX, DOM
• Assisted in API testing using Postman to check if the API's are returning the data in JSON and XML format and assisted in documenting the tested API’s using Swagger Tool as required by the workflow.
• Experience in Testing Life Cycle and supervising Black-box Testing, Functionality Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT), Load/Stress Testing, and Performance Testing.
• Experienced in bug tracking and following up for successful maintenance and delivery of service tickets using JIRA

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Scrum, Kanban, Water-Scrum-Fall (Hybrid Waterfall & Scrum), SAFe, RUP.

Process Modeling Tools: MS Visio, Lucid Chart, Balsamiq

Testing Tools: HP ALM, HP QC, Selenium

Statistical Tools: Minitab, MS Excel (2013, 2016, office 365)

Project Management Tools: MS Project, MS Office 365 (MS Word, MS Excel, MS-PowerPoint, MS-SharePoint. MS Access, MS OneNote), Atlassian JIRA, Confluence

ETL Tools: Informatica, MuleSoft

BI and Reporting Tools: Einstein Analytics, MS Power BI, SAP BI, Tableau and MS Excel

Databases: Microsoft SQL Server, PostgreSQL

Data Modeling: Logical/Physical/Dimensional, Star/snowflake schema

Data Warehousing: Data marts, OLTP, OLAP, Multidimensional Analysis, Slicing/Dicing, Drill Down/Roll Up

Web Services: SOAP, REST, XML, JSON, Swagger tool, POSTMAN

Technologies: AWS Redshift, Amazon S3, Amazon EC2, Kinesis, Salesforce and SAP

PROFESSIONAL EXPERIENCE

Confidential, Ada, MI

Sr. Business Systems Analyst

Responsibilities:

• Interviewed Subject Matter Experts (SMEs) and performed an extensive document review to develop a thorough understanding of the business processes and analyzed the supply chain to aid Business Process Improvements.
• Performed GAP analysis to identify the deficiencies of the current business systems and to identify the requirements for the change in the system to analyze the AS-IS and TO-BE to generate the business requirements.
• Created formal Business Requirement Documentation in appropriate format for the Salesforce Administrator to implement and h elped in writing various business analysis documents based on the requirements gathered.
• Participated in Scrum ceremonies, extensively used Jira for converting the requirements to user stories, assisted the Product Owner in writing the Acceptance criteria and framing the Definition of Done (DOD) for the PSPI.
• Worked closely with the technical team in converting the functional requirements into technical specifications like Prototypes, Graphical User Interface (GUI) and User Interface (UI) mock-ups using Balsamiq tool.
• Created Use Case diagrams, Use Case Templates and process flow diagrams using MS Visio for both the systems.
• Integrated social studio and service cloud to enable tracking consumer feedback on social media to understand their opinion about products on the CRM system.
• Used Data Management Platform (DMP) to collect, manage and analyze pseudo consumer data from digital platforms.
• Performed SELECT, JOIN and CRUD operations to pull data from ERP databases and producing delimited files to create sample dataset framework to be used for testing batch processing of Salesforce Bulk API V1
• Assisted MuleSoft integration for B2B/EDI through API’s and validated the transaction sets by onboarding a new vendor.
• Assisted in the API documentation using Swagger and communicated it with the developers to serve as a POC.
• Assisted creation of Test Cases, Test Plans, Test Scenarios, and updated the Requirements Traceability Matrix.
• Conducted User Acceptance Testing (UAT) and actively participated and facilitated the testing of the system during Smoke Testing, Integration Testing, Black Box Testing and Regression Testing with the help of QA.
• Assisted the testing team in UI testing using HP ALM and documented the defects in Jira.

Environment: Agile-Scrum, SAP ERP, Salesforce (sales, service, marketing clouds and Einstein Analytics), JIRA (v7.10.2), Confluence (v6.10), Balsamiq, MySQL, Bulk API, REST API, MS Office Suite, MS Visio (v16.0), HP ALM, MuleSoft, Postman, Swagger.

Confidential, Framingham - MA

Sr. Business Systems Analyst

Responsibilities:

• Assisted Project Manager in creating Project Charter, Work Breakdown Structure (WBS) and Scope statements .
• Aided Product Owner to identify Scope Creep & created mitigation plans for requirements churn with stakeholders.
• Extensively used Jira and Confluence for converting requirements to User stories by assisting the Product Manager.
• Assisted in writing acceptance criteria and framing Definition of Done (DOD) on SCRUM/KANBAN board for Potentially Shippable Product Increment (PSPI) and help enforce WIP limits for optimized process flow.
• Coordinating with ECC team for customizations in ERP to handle Ariba orders, receipts, contracts, PO and invoice
• Worked towards preparation of Requirements Management Plan, Business & Functional Requirement Documents.
• Assisted with Automation of Business Rules with Record Types, Validation Rules, Work Flows and Process Builder.
• Using journey builder created movable data extension, Lead generation in Marketing Cloud of Salesforce platform.
• Aided in using Mule Connectors like FTP , Salesforce, HTTP connector, Database , as part of Integration usage and executed RAML files for different entity creations and respective associations.
• Worked on various Salesforce.com standard objects like Accounts, Leads, Campaigns, Reports and Dashboards.
• Involved in creating inbound & outbound flows for MULE ESB in HTTP and orchestration using XPath .
• Supported & Administrated CRM application, Configure Price Quote (CPQ) tools enhancement and Google analytics
• Used different data tools - Apex Data Loader , Excel Connector , Import Wizard , SFDC Data Export .
• Maintained user roles, security, profiles and workflow rules wherever necessary.
• Performed and documented Data Mapping, converting legacy data element values for inclusion in the Functional Detail Design Specification (FDDS) documents and map it to the related module.
• Aided in Batch Integration process by making REST’s Bulk API calls to upload the data and Lightning Bolt to fetch the data from Salesforce.
• Created custom handler to insert customer data in Salesforce Marketing Cloud using Soap API.
• Designed and prepared the Use Case diagrams, Class diagrams, Sequence diagrams for current activity, shipment association, lookups and web service using MS Visio.
• Functioned on defining the Test Cases to cover the Sourcing , P2P processes that includes Master Data and Transactional data for P2P process and Purchase Order to Invoice automation.
• Conducted User Acceptance Testing (UAT) and actively participated and facilitated testing of the system during Smoke Testing, Integration Testing, Black Box Testing and Regression Testing with the help of QA.

Environment: Agile, SAFe4.0, Confluence (6.4), JIRA (7.0), Tableau (9.0), MS Office suite 2016, MS-Visio (1.5), Apache Tomcat, MySQL Java, REST, Swagger, MuleSoft (3.7), MS Visio, SFDC.

Confidential, Louisville, KY

Sr. Business Analyst

Responsibilities:

• Worked in water- scrum fall environment and participated in sprints with focus on small enhancements.
• Assisted Project Manager in creating Project Charter, WBS and Scope statements and maintained them on MS Project.
• Facilitated JAD sessions, conducted focus groups and document analysis to elicit requirements with stakeholders, business users and SME’s for understanding requirements.
• Drafted BRD for the specific business requirements and FRD to capture functional and non-functional requirements.
• Assisted Project Manager in Risk Analysis and Cost Benefit Analysis and conducted feasibility analysis for requirements
• Performed Gap Analysis by identifying AS-IS and TO-BE process models and process flows and documented them
• Coordinated with the Sr. Product Manager in managing product backlog to assess and prioritize business needs and feature enhancements.
• Worked with the product owner in coordinating with the cross functional development team for clarification on requirements and involved in developing acceptance criteria and prioritizing user stories.
• Created UML diagrams like use cases, activity diagrams and sequence diagrams.
• Created wireframes and mock-up screens using Balsamiq to get a visual understanding of the requirements for the UI/UX of coupons/reward portal and POS.
• Analyzed the system using data flow diagrams, functional hierarchy and process development diagram.
• Used Jira extensively for issue tracking, user story management (writing user stories, owning user stories, acceptance criteria and definition of done) and requirements traceability.
• Used Lucid Charts to create use case diagrams and process flow diagrams.
• Tested REST APIs and SOAP web services with the XML format and other formats using Postman and documented the tested API’s using Swagger.
• Assisted the testing team in developing the test plan, test conditions, and test cases based on business requirements and technical specifications in UAT using Zephyr, a test management tool in JIRA.
• Used JIRA for tracking tasks, defects, and bugs for maintenance and deployment of system being developed

Environment: Waterfall-scrum (hybrid), MySQL (v5.7.10), SAP Ariba, JIRA (v7.0.9), Confluence (v5.9), Zephyr, MS Office Suite, MS Visio (v15.0), Balsamiq, Postman, Swagger.

Confidential, Las Vegas, NV

Business Systems Analyst

Responsibilities:

• Facilitated JAD sessions with SMEs and business analysts from other systems for a detailed analysis and a better understanding of the impact of various aspects on each other.
• Worked closely with business users to prioritize & scope out the Product Backlog Items (PBI) based on priority
• Lead and participated in multiple ongoing project meetings using iterative and Agile project methodologies.
• Collected business requirements to set rules for proper data transfer from Data Source (SAP) to Data Target (Redshift Server) in Data Mapping along with supporting Data Architecture and SQL Code.
• Created GAP analysis documents of AS-IS, TO-BE systems to identify deficiencies and required enhancements.
• Facilitated meetings with Salesforce Admins, Developers and Architects to determine the data that should be integrated into Salesforce platform.
• Collected and assembled data from data sources as input to run research spikes to identify visualization solutions
• Responsible for mapping and modeling the Conceptual, Logical and Physical models (using Informatica), specific to AWS Redshift and capture data from database Streams via Kinesis with aggregations in EC2 instance & Redshift .
• Assisted in creation of Hash tables referencing the Surrogate Key tables for efficient lookup to Dimensions.
• Participated in server deployment on Cloud, ( EC2 ) Optimization / cost reduction of Amazon AWS services ( EC2, S3, EBS, ROUTE53, and VPC ) and defining the conceptual and logical model of the data warehouse.
• Performed Data Investigation , Profiling and Cleansing as part of UAT and Standardized Data Quality Processes.
• Established the ETL Informatica Mappings, Maplets for importing data from ODS into subsequent data marts.
• Performed Salesforce ETL processes using Informatica, Salesforce Web Services, Java API & Scheduled Sessions based on demand, run on time and run only once using Informatica Server Manager.
• Worked with several SFDC objects like Accounts, leads, opportunities, reports and created custom objects .
• Assisted on Jenkins and GitHub on many internal build systems for the core development team on an enterprise-level Java-based cloud orchestration/automation tool to streamline Continuous Integration.
• Experience in Functional, Data Driven Testing, Load, Performance Testing & Validating WSDL using POSTMAN.
• Verified security testing to make sure which authentication is required & if sensitive data is encrypted over HTTP.

Environment: Amazon Redshift, Informatica power center 9.6, Confluence (6.2), JIRA 7.0, GIT, Jenkins, VPC, EC2, S3, Salesforce, Tableau 8.2, Postman (5.0), MS Office Suite, Agile SCRUM.

Confidential

Business Systems Analyst

Responsibilities:

• Authored progress and completion report which were then submitted to the project manager on a weekly basis.
• Facilitated product development of a proprietary system enabling the integration of electronic invoicing with traffic, billing systems, order fulfillment and customer reviews using Salesforce CRM
• Captured requirements in the form of User Stories and defined user Acceptance Criteria for each of them.
• Identified and documented Salesforce APIs like REST, SOAP, Bulk and Analytical APIs.
• Furnished the migration strategy from SAP CRM to Salesforce CRM platform in phase wise model
• Formed workflow diagrams, sequence diagrams, use cases, Analysis & Design Document, Interface Control Document, and Data Mapping Document for incorporating design changes.
• Used Informatica to extract and transform data from various relational databases to the data warehouse.
• Used Tableau to derive business insights from OLAP cube and used Salesforce-Tableau connector (Canvas Adapter) to embed those insights to employee dashboards to generate better reports for the end client and project managers
• Utilized Sales performance management software Optymyze to improve operations and execute sales strategy
• Acted as a resource in assisting team members in the development and executing test/use cases/negative tests.
• Assisted in API testing using Postman to check if the API's are returning the data in JSON, XML format as defined in the API documentation (Using Swagger Tool) along with automating the workflows.

Environment: Salesforce, Java, Swagger (2.0), HPALM (12), Tableau, Selenium3.4.x, XML, JASON, Optymyze, Salesforce Classic UI, REST service, Jira 6.0, Confluence (6.0), Postman (4.0), MS project 2013.