SUMMARY

• Highly motivated, detailed oriented and focusedSenior Business Systems Analyst, wif 8+ years of experience in teh general IT sector specializing in Digital Marketing, Retail and E - Commerce. Quick learner wif adaptability skills and a commitment to deliver results and respond to any challenge wif confidence, determination, focus and ability to interact wif anyone.
• Knowledge about E-Commerce, Digital Marketing compliances such as GDPR (General Data Protection Regulation) and COPPA (Children Online Privacy Protection Act)
• Experience on ABM (Account-Based marketing) such as Subscription Model for Segments, Email Studio, Mobile Studio, Web Studio, Advertising Studio, Social Studio, Journey Builder, Content Builder, Augmented Reality using Salesforce CRM, Marketing Cloud, CMS, Sales cloud,Einstein Analytics, Service Cloud and AR Tools.
• Knowledge about E-commerce platform which includes Business 2 Business, Business 2 Customer, Business 2 Government & Offline 2 Online. Worked on creating SEM campaign (Pay Per Click) Marketing Automation (E-mail Marketing, Landing Pages, Creating videos for social Networking Platform Facebook, Instagram, Twitter).
• Knowledge of System Development Life Cycle (SDLC) methodologies like Waterfall, Scrum, Waterfall-Scrum hybrid
• Experienced in gathering requirements from end-clients and stakeholders by using various elicitationtechniques like Joint Application Development (JAD), Brainstorming, Interview, Questionnaire/Surveys, Prototyping, Document Analysis and Focus Group. Experience in analyzing teh As-Is and To-Be systems, performing various business analysis such as GAP Analysis,Risk Analysis, Root Cause Analysis,Change Management, SWOT Analysis
• Responsible for drafting and support in artifacts likeBusiness Requirement Document (BRD), Functional Specification Document (FSD), and System Requirement Specification (SRS) by communicating wif business owners and SMEs
• Experience in using teh JIRA tool for writing and managing User Stories and Tasks in Scrum environment, track issues, Defect Lifecycle Management and used Zephyr in Jira as a test management tool
• Participated in Scrum ceremonies such as Product Backlog Grooming, Sprint Planning, Review, Retrospective, and Daily Stand-ups. Assisted Product Owner in prioritizing PBI s using techniques like Moscow, KANO, and worked wif teh team to estimate teh effort using techniques like Planning Poker, T-shirt sizing. Assisted PO in release planning, backlog grooming by assisting in teh outlining of MVP, MMF, and MRF
• Experienced in analyzing workflow and developing and reviewing business solution model to halp wif processes and development using UseCaseDiagram, SequenceDiagram and ActivityDiagram wif Lucid Charts and MS Visio. Assisted in creating low-fidelity and high-fidelity mockups and wireframes wif UI and UX designer using Balsamiq.Created Workflows using Business Process Modeling Notation (BPMN)and also created Standard Operating Procedure, Data Flow diagrams for better understanding of data and business processes
• Experience in creating a Data Mapping Specification document, Entity-Relationship Data Models by identifying teh key elements, performing Data profiling, Data cleansing and Normalization. Experience wif analyzing and writing Logical and Conceptual Data Models.
• Knowledge of extraction of data from source systems, transformation and load process (ETL) for a Data Warehouse using (Informatica PowerCenter) and gave technical support for using Informatica for testing.
• Knowledge of implementing and assessingDatawarehouse, Databases, Data Table Structures, Data marts, Data Analysis, Data Integration, Data Modeling, Schemas and OLAP operations viz. Slice, Dice, Pivot and Roll-up
• Familiar wif using platforms such as Postman, Swagger, and Soap UI for API development and testing
• Extensive knowledge in assisting testers to perform Regression Testing andUser Acceptance Testing (UAT). Assisted teh testing teams in creating testing artifacts like Test Plans, Test Cases, Test Scenarios, Reports, and Requirements Traceability Matrix(RTM)
• Extensive knowledge about Data Visualization and Business Intelligence tools such as Tableau, PowerBI and Advent ZOHO for creating reports such as Ad-Hoc Reports, Heat Maps, TreeMaps, Bar Graphs, Dashboards, Interactive MOLAPs, and other static reports

TECHNICAL SKILLS

Business Skills: Change Management, Impact Analysis, Risk Analysis, Cost-Benefit Analysis, ROI Analysis, JAD Sessions, SWOT Analysis

Data warehouse: Oracle PRP, IBM sterling DOM, BY WMS, ESP

Cloud Platform: Salesforce cloud (Marketing Cloud, Sales Cloud, Service Cloud, Einstein Analytics)

Project Management Methodologies: Waterfall, Agile Scrum, Scrum Waterfall Hybrid, SDLC, Kimball Methodology

Project Management Tools: Atlassian Jira,MS Project, MS SharePoint, MS Office 365(Word, Excel, PowerPoint, Access), Confluence

Marketing Tools: Google analytics, Google Adwords, Hootsuite

Modeling Tools: MS Visio, Lucid Charts, Balsamiq

Salesforce: Marketing Cloud, Sales Cloud, Service Cloud, Einstein Analytics, Data Loader

API Tools: Swagger, Postman, SOAP UI

ETL Tools: InformaticaPowercenter, Oracle Data Integrator, Tera Data, PayDM

BI and Reporting Tools: Tableau, Power BI, Advent Net ZOHO

PROFESSIONAL EXPERIENCE

Business Systems Analyst

Confidential, NJ

Responsibilities:

• Grooming teh requirements provided by teh Business BA’s and having grooming sessions wif technical team to groom and set up teh expectations from teh business
• Breaking requirements into user stories and having user story grooming sessions wif teh business team.
• Conducted a Jira workshop for teh whole team to give an understanding of how teh jira works and how it is used by teh business for dis project.
• Conducted data mapping sessions for various interfaces, wifin source and Confidential team members to document teh Confidential attributes in teh new systems and teh source attributes in teh legacy systems where teh data is going to be extracted from.
• Documented meeting notes, open issues and action items from meetings and follow back.

Environment: Scrum, Oracle PRP, IBM sterling DOM, BY WMS, ESP, Jira

Business Systems Analyst

Confidential, NJ

Responsibilities:

• Gathering requirements from various stakeholders who were responsible in teh steps of different types of discounting, by using various elicitation techniques interviewing, brainstorming and document analysis
• Requirements were mainly gathered to document teh process in forms of Business Process Modeling Notation (BPMN) diagrams, Standard Operating Procedure (SOP), and data flow diagrams which showcases teh various steps involved in teh various business processes. Used Ms Visio to create teh diagrams and also use during presenting to teh stakeholders during meetings.
• Understanding teh involvement of various systems in teh processes like salesforce, Teradata, PayDM, eVIP portal, etc. where data was stored
• Documenting teh various types of data shared between teh systems during teh process in teh SOP. Documenting teh various documents created during these processes
• Reviewing wif various stakeholder on teh documentation and taking feedback on required changes in teh process and documenting them

Environment: Agile Safe, Ms Visio Professional, Salesforce CRM, Tableau 10.3

Senior Business Systems Analyst

Confidential, MI

Responsibilities:

• Utilized teh Guidelines and Artifacts of teh Agile-Scrum to develop a detailed implementation and development process
• Conducted meetings wif Subject Matter Experts (SME), digital marketing team, marketing leads, marketing analyst, sales lead, retail store managers and executives to discuss program specifications, process models and more
• Ensured teh system was by teh GDPR compliance by coordinating wif teh legal team
• Requirements gathering from teh client by conducting elicitation techniques like interviewing,Questionnaires, and observation (Job shadowing), document analysis, Joint Application Development (JAD). Performed teh Gap Analysis to define teh current and future business requirements for teh new functionalities by analyzing As-Is/To-Be states, along wif other analysis like Root Cause Analysis to understand teh problem and gaps faced teh company’s legacy CRM system, andSWOT Analysis on how teh new system will be beneficial. Helped wif smooth change management after implementing new system in teh organization wif conducting workshops for Salesforce.com.
• Created Mock-up Screens and Wireframes for an overview of teh processes, development, UI/ UX design, GUI and UML Diagrams such as Business Process Modeling Notation(BPMN), Data flow diagrams,Sequence diagram, Activity diagramsand Use Case Diagrams using MS Visio for proper visualization. Used these methods to present teh project and development of teh project to business team. Worked between business team and IT team to express and present teh processes to them
• Involved in scrum ceremonies (Backlog Grooming, SprintPlanning, Daily Scrum, Sprint Review, Sprint Retrospective.) Helped teh Product owner in finalizing teh Minimum viable product (MVP) and maintaining teh Product Backlog and teh Sprint Backlog by assisting teh Product Owner and team wif doubts in prioritization and estimation of PBI’s wif Acceptance Criteria
• Assisted teh Scrum Master to maintain teh Sprint/ Release Burn-up and Burn-Down charts, Velocity Chart in JIRA
• Created Data Mapping Document to capture Source to Confidential Mappings and ensured required datasets were integrated wif salesforce
• Performed As-is To-Be analysis from legacy system to CRM system onData Loader, Marketing Cloud, Sales Cloud, Service Cloud and Einstein Analytics
• Assisted in Implementing and Customizing Salesforce customer relationship management (CRM) for Marketing, Sales, Service and Content Managementfor effective customer retention and service delivery process
• Responsible for all teh activities related to configuring Data Loader, uploading data in CSV files collected from retail stores and e-commerce website into salesforce.com, checking for integrity of teh data
• Assisted Salesforce Administrator wif performing administrative activities on Sales, Service, Marketing cloud by creating User, Roles, Profiles, Workflow rules and Approval process.
• Implemented salescloud and service cloud to improve customer retention and service delivery process improvement in retail stores and e-commerce website
• Implemented objects to be able to keep track of customer journeys, customer behavior, customer categorization using Sales Cloud
• On service cloud gathered Customer Feedback and tracked customer behavior to teh brand using Hashtags, Chatbot, emails and feedback from retail stores
• Created teh templates for emails and teh content to be added in teh email along wif teh segmented lists of email user who are categorized into loyal customers using Email builder, Content Management on Salesforce Marketing Cloud
• Built campaigns for teh loyal customers onboarding in Journey Builder dat mapped out teh complete customer journeys which included email marketing, digital advertising, promotional offers, and creating Pay per click campaigns wif Salesforce Marketing Cloud to be used in retail stores and e-commerce website
• Created business process model, traceability matrix, and quality management techniques which assisted teh team throughout teh development of teh project
• Performed API testing using Postman to check if teh information returned is in JSON/XML format (RESTful API) and Swagger for API documentation
• Collaborated wif teh QA team to write Test Plans, Test Cases and Test scenarios, and prepared Requirements TracebilityMatrix(RTM). Facilitated UAT and actively participated in another functional testing by facilitating and providing assistance to teh Quality Assurance teams.
• Created and maintained JIRA spaces to add any impediments teh team is facing and tagged teh point of contact for teh notification of required work from their part
• Helped visualize teh data by creating Static reports, Interactive MOLAP, Dashboards, Geo Heat Maps, and other dynamic real-time reports using Tableau Data Visualization tool

Environment: Agile Scrum, Salesforce CRM, Marketing Cloud, Sales Cloud, Service Cloud, Einstein Analytics, JSON/XML,Journey Builder, MySQL, Tableau 10.3, MS Visio 7.1.9, Postman, Swagger, JIRA

Senior Business Systems Analyst

Confidential, NJ

Responsibilities:

• Conducted interviews wif clients, SMEs & business users like marketing team, manufacturing team, retail stores and managers, augmented reality experts to understand their Business & Functional Requirements, behind teh idea of Augmented Reality, and analyzed teh benefits dat it provided to users.
• Created an AR Document which included various dimensions like AR Tools Creator (ARTC), AR Experience Creator (AREC), Assets Creator (AC), Assets Aggregator (AA), Media servers and Service servers.
• Lead on teh relationship wif client to define project vision, timelines, deliverables, engagement planning, defined deliverable structure and content. Worked wif teh PO and development team in deciding and negotiating teh DOD (definition of done), definition of ready and acceptance criteria for user stories.
• Assisted teh PO (Product Owner) in scope creation, requirements analysis, creating MVP, during backlog grooming meeting by decomposing teh Epics into user stories, assisted team in writing user stories.
• Discussed wif teh SME’s and Technical leads and identified teh Data Marts, Content Management System, Analytic Engine, Content Distribution Network and teh type of Rendering devices which were required.
• Acted as a liaisonbetween developers and business stakeholders to communicate teh technical requirements.
• Performed “As-Is” and “To-Be” analysis to understand teh current and desired state of teh system.
• Collaborated wif implementing Google Adwords, Google Analytics and hootsuitefor creating campaigns for customers. Used Google Adwords to be able to create ads on google and websites and analyzed teh customer behavior on google analytics. Created content for social media and website using hootsuite.
• Assisted in creating User Interface Document to express UI/ UX component design, navigation & created interactive wireframes&dynamic mock-ups using Balsamiq tool which halped get feedback to enhance teh User experience.
• Created Use Case Diagrams, Business Process Modeling Notation(BPMN)& Process Flow diagrams using MS Visio & Lucid Chartto halp teh team and business understand teh processes and development of teh project
• Participated in story writing workshops and wrote user stories, and also assisted PO during PSPI demonstration.
• Performed SQL queries such as Joins, Aggregators, Triggers using MS SQL Server Management Studio.
• Worked wif QA team to write test cases and halped in UAT by testing teh front end of teh system and documented bugs/errors if any, in teh Test Analysis Reportand created Requirements Traceability Matrix (RTM) for tracking test cases wif requirements
• Identified and documented APIs like REST, SOAP, Bulk and Analytical APIs and used Swagger for Documentation and Unit testing
• Extensively involved in data mapping, logical data modeling, creating class diagrams, E-R diagrams.
• Created Geo-heat maps, Time-series graphs and Dashboards using Tableau to assess density of users segmented on geographical parameters to halp understand customer and market trends.

Environment: Agile Scrum, Office 365, REST, JSON, XML, MS Visio, Lucid Chart, AR, Informatica PowerCenter 9.6.x, Tableau 10.3, JIRA 7.4.0, Swagger, Google Adwords, Google Analytics, Hootsuite

Senior Business Systems Analyst

Confidential, AK

Responsibilities:

• Identified key stakeholders and gathered functional and non-functional requirements associated wifRetail Stores, Store Management, Marketing, Inventory Management, Potential Stores, etc. through interviews, document analysis, and JAD sessions
• Performed AS-IS and TO-BE analysis to identify a gap then existing Retail Store Management System and layout, to how it can be constantly updated into teh application
• Worked closely wif teh Design/UI team in converting teh functional requirements into technical specifications like Prototypes, Graphical User Interface (, GUI) and User Interface (UI) mock-ups using teh Balsamiq tool
• Documented User Stories and Acceptance Criteria for teh PSPI (Potentially Shippable Product Increment)
• Worked wif teh Mobile application team to create a wireframe and Mockup of teh website to appear teh same on teh Mobile platform.
• Created Workflow for mobile application platforms to update teh product catalog and user profiles. Captured customer engagement through Mobile application and desktop application
• Participated in Scrum ceremonies and assisted Product Owner in converting requirements into User stories, writing acceptance criteria, Definition of Done (DoD) and prioritizing them in teh Product Backlog using JIRA.
• Performed retrieval queries in SQL & stored procedures using SELECT & JOIN for drill-downs to pull data while being actively involved in reading data from varied file types, created standard and ad-hoc reports using SQL, generating delimited files and SQL script to load data into SQL tables. Mainly focused on retrieve data to understand teh data
• Identified and documented APIs like REST, SOAP, Bulk and Analytical APIs
• Developed teh test plan, test conditions, and test casesusing Jira, MS Excel, and MS Word, to be used in testing based on business requirements, technical specifications, and/or product knowledge
• Created interactive reports and detailed dashboards using Power BI tool for forecasting and marketing needs

Environment: Agile Scrum, Balsamiq, Power BI, Jira 7.1.9, Office 365, REST

Business Analyst

Confidential

Responsibilities:

• Responsible for creating and reviewing business requirements, functional specifications documentation.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
• Responsible for identifying and documenting business rules, created detailed Use Cases and conducted User Acceptance Testing.
• Kimball drop down methodology was used to develop teh new system. Data extracted from different sources to be able to transform and load into new datawarehouse
• Created conceptual and logical models of teh data warehouse and mapped entities wif ER diagrams and documented keys to allow for easy reference while development.
• Documented source & Confidential systems and profiled extracted data to comply wif Confidential system architecture.
• Aided developers wif design of migration plans and migration execution to not affect business actions and processes.
• Mapped new system wif Informatica PowerCenter to ensure data from data warehouse was designed to smoothly operate as per teh business logic while incorporating information ported from current database.
• Documented all ETL transformations and mappings performed while establishing data warehouse.
• Involved in scrum ceremonies (SprintPlanning, Daily Scrum, Sprint Review, Sprint Retrospective.)
• Developed teh test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.
• Used SQL scripts/queries extensively for data verification at teh backend as per teh requirements of teh mapping document.
• Used Tableau to create customized dashboards, showing reports dat satisfied business need.

Environment: Waterfall- Scrum, Informatica PowerCenter, MS Project, MS Office Suite, Kimball methodology, MS Power Point, Tableau, Oracle.

Business Analyst

Confidential

Responsibilities:

• Gathered requirements from key stakeholders, and SMEs to define teh scope and requirements of teh mobile application.
• Directly involved in creating and baselining Functional Requirement Document, Business Requirement Documents and Software Requirement Specification, and other key deliverables
• Assisted and worked wif teh Project manager in creating an assigned task through Work Break-down Structure (WBS). Worked in WaterfallSystem Development Life Cycle (SDLC)
• Developed UML Diagrams for modeling static and dynamic aspects of Mobile Application
• Worked closely wif Project Manager for any Change Request and halped to do Impact Analysis
• Assisted PO in writing acceptance criteria, Definition of Done and prioritizing PBI’s based on Business Value, time and risk, and also assisted in Backlog Grooming to determine teh Minimum Viable Product (MVP).
• Documented source & Confidential systems and profiled extracted data to comply wif Confidential system architecture
• Aided developers wif teh design of migration plans and migration execution to not affect business actions and processes
• Teh mapped new system wif Informatica PowerCenter to ensure data from teh data warehouse was designed to smoothly operate as per teh business logic while incorporating information ported from teh current database
• Documented all ETL transformations and mappings performed while establishing a data warehouse
• Developed plans for verification and validation of requirements at all levels so dat developed software successfully fulfilled user expectations and business needs
• Used SQL scripts/queries extensively for data verification at teh backend as per teh requirements of teh mapping document
• Developed teh test plan, test conditions, and test cases to be used in testing based on business requirements, technical specifications, and/or product knowledge
• Created ad-hoc reports using MS-Excel and Pivot tables to do teh calculations and creating reports accordingly
• Worked on Advent Net ZOHO as a reporting tool to give teh complete business Insights which could halp management to take corrective actions to streamline teh business Process

Environment: Water Scrumfall (Hybrid), MS Office, MS Visio, SQL, UAT Testing, HP QC, COTS. Advent Net ZOHO

Business Analyst

Confidential

Responsibilities:

• Elicited requirements using JAD sessions, Surveys/Questionnaire, Interview sessions, Requirement Workshops, Focus Groups, Interface Analysis and conducted GAP Analysis to analyze drawbacks in teh process
• Reviewed requirements and technical design documents to ensure dat requirements fall wifin scope by constantly ensuring triple constraints are met
• Understand teh application business logic wif Business Requirements Specification Documents and functionality of application wif Functional Requirements Specification Documents
• Create and review test plans, test scenarios, test cases
• Created Mock-Up Screens and Wireframes using Balsamiq for User Interface components for client feedback
• Created Workflow, Process flow, Use Case, Activity and Sequence diagrams using Lucid Chart
• Supported ETL developers in creating workflows and scheduling batch processes based on Data Mapping
• Oversaw teh Database teams and DBAs while implementing teh Enterprise Data Warehouse
• Conducted User Acceptance Testing (UAT), functional walkthroughs for teh developed e-commerce website
• Used Tableau for data reporting, studying teh trends, data patterns, data forecasting, and visualization

Environment: Waterfall, MS SQL, MS Office 365, JIRA, Informatica Power Center, Tableau

Junior Data Analyst

Confidential

Responsibilities:

• Collaborated wif multiple stakeholders to gather business requirements
• Created a custom data store to extract and load historical data from various sources such as flat files, Excel files, Oracle etc.
• Converted data into actionable insights by predicting and modeling future outcomes
• Utilized MySQL, data warehousing programs, Tableau for data intelligence and analysis
• Prepared reports dat interpret consumer behavior, market opportunities, and conditions and trends

Environment: Waterfall, MySQL, Tableau, MS Office, Informatica