SUMMARY

• Sr. Business System Analyst with 9 years of experience in E - commerce and Digital Marketing domain with a focus on designing, development & implementation of the business processes.
• Experience working on tools like Subscription Model for Segments, Email Studio, Mobile Studio, Web Studio, Advertising Studio, Social Studio, Journey Builder, Content Builder, and Segment Builder using Sales Force CRM & Marketing Hub Spot, worked on Google cloud, Analytics and Artificial Intelligence (AI)
• Extensive knowledge about E-commerce platform which includes B2B, B2C, B2G & O2O. worked on creating SEM campaign (Pay Per Click) Marketing Automation (E-mail Marketing, Landing Pages, Creating videos for social Networking Platform (Facebook, Instagram, Twitter).
• In depth knowledge of System Development Life Cycle (SDLC) methodologies like Waterfall, Scrum, Waterfall-Scrum hybrid, Scale Agile Framework (SAFe), Scrum Ban, and Kanban.
• In depth knowledge of Requirement Management, Change Management, Defect Management, Release Management, Project Management and Risk Management using JIRA, HP ALM and MS Project.
• Expert in understanding of the AS-IS and TO-BE, business processes by conducting GAP analysis and experience in converting the requirement into technical specification for better execution of the business decision.
• Experienced in gathering requirements from end-clients and stakeholders by using various elicitation techniques like Joint Application Development (JAD), Brainstorming, Interview, Questionnaire/Surveys, Prototyping, Document Analysis, Focus Group, Reversed Engineering, and Interface Analysis.
• Assisted in drafting artifacts like Project Vision and Scope, Project Management Plan, Project Charter, Business Requirement Document (BRD), Functional Specification Document (FSD) and System Requirement Specification (SRS) by communicating with business owners and subject matter experts (SMEs).
• Experienced in writing the user stories and acceptance criteria with handling the requirement churn.
• Participated in Scrum Ceremonies like Backlog Grooming, Sprint Planning, Daily Stand-Up, Sprint Review and Retrospective and efficient in using prioritizing techniques like Moscow, KANO, Technology Risk Based, Value Stream Mapping, 100 Point method and Business Value Based.
• Worked with PO to review PSPI (Potentially Shippable Product Increment) during review meeting and helped to decide which features are done and satisfies the acceptance criteria.
• Experienced in analyzing workflow and developing and reviewing business solution model using Use Case Diagram, Sequence Diagram and Activity Diagram with Lucid Charts and MS Visio.
• Assisted in creating low-fidelity and high-fidelity mockups and wireframes with UI designer using Balsamiq.
• Entity-Relationship (E-R) diagram using conceptual data model and logical data model with Lucid Charts.
• Assisted in developing data marts (DM), data mapping, data migration, data integration and data warehouse (DW) implementing Extract, Transformation and Load (ETL) with Informatica PowerCenter.
• Extensive implementation knowledge of Databases, Data Table structures, Schemas, Online Processing Systems like OLTP and OLAP Operations such as Roll-up, Drill-down, slicing, dicing and pivot.
• Worked on Reporting tools to generate Standard Static Reports, Ad-hoc Reports, Write-Back Reports, Dashboards, Interactive MOLAP reports using Tableau, and Power BI.
• Experienced in SQL queries using MS SQL creation of the Data Manipulation language and Data Definition Language (SELECT, INSERT, UPDATE & DELETE).
• Understanding of the Microservices Architecture (MSA) and JSON, XML, HTML format for communicating between the front end and back end server’ for designing REST, and SOAP APIs.
• Knowledge of the HTTP request to the web service to specify REST API CRUD operations having HTTP verbs- GET, POST, DELETE and PUT on the application layer that utilized POSTMAN as a powerful HTTP client to test the web services and documented them using Swagger hub, and Swagger UI tool.
• Reviewed the test plan, test cases, test scenarios and maintained the test data with Confluence and HP ALM QC.
• Experienced in Black Box, Manual, System, Performance, Regression, Automated, Functional, Non-Functional, UAT, Smoke and Sanity Testing of applications with knowledge on Software Testing Lifecycle by creating Test plan, Test Scripts, Test cases, Test Scenarios, Test reports and Requirements Traceability Matrices (RTM).

TECHNICAL SKILLS

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

Cloud Platform: Salesforce Marketing Cloud, Sales Cloud, Message Cloud, Google Cloud.

SDLC Methodologies: Agile-Scrum, Waterfall, Waterfall-Scrum hybrid, SaFE

Requirement Management: MS Office, Jira, HP ALM, HP-QC

Modeling Tools: MS Visio, Lucid Chart, Balsamiq

ETL Tools: Informatica Power Center

Data Warehousing: Data Marts, OLTP, OLAP, Multidimensional Analysis, OLAP Operations

Databases: MYSQL, Microsoft SQL T-SQL, PL/SQL

Defect Tracking/ Testing Tools: HP ALM QC, Selenium, Jira.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Digital Marketing Business Analyst

Responsibilities:

• Requirements gathering from the client and SME’s such as marketing cloud expert, Marketing analytics expert by conducting elicitation techniques like interviewing, Questionnaires and observation (Job shadowing), document analysis, Joint Application Development (JAD).
• Created the templates for emails and the content to be added in the email along with the segmented lists of email user using Email builder, Content Management on HubSpot.
• Ensured that licenses for Google clouds were properly obtained and maintained by following all the rules, policies and guidelines of the client company.
• Built campaigns for the customer onboarding in Journey Builder that mapped out the complete customer journeys which included email marketing, digital advertising, promotional offers and creating Pay per click campaigns with HubSpot Marketing cloud.
• Drafted and designed the ETL using Hydrograph for data mapping and transforming to process the data flow from unstructured data to Google Cloud dataflow for machine learning.
• Gather data by mining data from social marketing sources (e.g. Facebook, Twitter) and web sources (e.g. Blogs, and Google Analytics) using Firebase SDK.
• Created prototype using “Adobe XD”, implemented visual changes with the help of high- and low-level mockups and wireframes.
• Implemented the KYC compliance regulations in the customer onboarding campaign.
• Assisted in the data migration process from oracle DB to Google cloud using Oracle Server Cloud.
• Helped in writing & documenting the transformation logics in the Data Mapping Document.
• Worked on Standard and Custom objects, Approval Process, Workflow Rules, Email notifications, Process Builder, Profiles, Field level security, Standard and Custom Report types & Page layouts.
• Implemented chatbot as a feature with the help of Dialog Flow. Created and maintained responses that captured and upload the same on cloud platform which supports Continues Integration. Created progress report and guided the team members to use it in the most efficient way and delivered creative briefs and other necessary requirements documentation to support the development of digital strategy.
• Involved in Core, CRUD and REST API documentation, along with the development team.
• Actively participated in all the scrum meetings like spring planning, daily standup meeting, sprint review, sprint retrospective, backlog grooming and release planning.
• Actively participated in Grooming Meeting for Prioritizing the backlog using MASOW technique. Decomposed epics by vertical slicing and created user stories using INVEST criteria and task through SMART criteria.
• Worked with PO to review PSPI (Potentially Shippable Product Increment) during review meeting and helped to decide which features are done and satisfies the acceptance criteria.
• Monitored progress of the overall project, tracked individual issues such as user stories, defects and technical debt using Atlassian JIRA, allowing for improved visibility of project status and accurate forecasts for project completion.
• Jointly responsible for creating test plans, test scenarios and test cases with the testers from the team.
• Created and maintained Confluence spaces to add any impediments the team is facing and tagged the point of contact for the notification of required work from their part.-+
• Created interactive Dashboard using HubSpot and Tableau to give Business heads complete visibility of the business so that necessary action could be taken for its’s growth.

Environment: Agile-Scrum, Google Cloud, Dialog Flow, HubSpot marketing, Oracle Server Cloud, Email studio, Web studio, Adobe XD Journey Builder, Data studio, Confluence, Jira, Tableau.

Confidential

Sr. Salesforce Business System Analyst

Responsibilities:

• Gathered requirements from the SMEs (Subject Matter Experts) which included marketing cloud expert and Einstein analytics expert by performing elicitation techniques like interviewing, document analysis, introspection, benchmarking and market analysis.
• Lead on the relationship with client to define project vision, timelines, deliverables, engagement planning, defined deliverable structure and content. Worked with the PO and development team in deciding and negotiating the DOD (definition of done), definition of ready and acceptance criteria for user stories.
• Assisted the PO (Product Owner) in scope creation, requirements analysis, creating MVP, during backlog grooming meeting by decomposing the Epics into user stories, assisted team in writing user stories.
• Designed the personalized and customized campaigns for customer onboarding, for new customers and customer retention for existing customers using Journey builder that mapped out the complete customer journeys which included email marketing, digital advertising and promotional offers.
• Facilitated meetings with Salesforce Admin, Developers and Architects to determine data that should be integrated.
• Implemented Salesforce Inbox into existing email system to keep track of contacts and opportunities.
• Assisted the admin in creating Users, Roles, Public Groups and implemented Role Hierarchies. Record level permissions to manage sharing access among different users on the Marketing Cloud of Salesforce.
• Worked with SQL queries for Data Analysis, retrieval, validation, modification, and used Data Manipulation Language (DML), Data Definition Language (DDL) & Data Control Language (DCL) syntax for queries.
• Assisted in Salesforce Quip integration to create a document sharing and impediment tracking process. Tracking real time analytics of customer journey by using Journey Builder. Creating interactive dashboard using Analytical studio to give business heads complete visibility about business and its insights so that corrective actions can be taken for its growth.

Environment: Agile-Scrum, Salesforce CRM, Marketing cloud, Community cloud, MySQL, Oracle, Force.com, Email studio, Mobile Studio, Advertising studio, Web studio, Apex, Visualforce, Journey Builder, Data studio, Audience Builder, Segment Builder, SharePoint, Jira.

Confidential

Sr. Business System Analyst

Responsibilities:

• Prepared vision statement and initial documents that contain Business Requirement Documents (BRD) and supported documents that contain the essential business elements and detailed definitions.
• Performed the Gap Analysis to define the current and future business requirements for the new functionalities by analyzing As-Is/To-Be states.
• Conducted Joint Application Development sessions and interviewed SME's, asking detailed functionality aspects of business process and updated the information to the requirements in an understandable format.
• Created Mock-up Screens and Wireframes for an overview of GUI and UML Diagrams such as Sequence, Activity and Use Case Diagrams using MS Visio for proper visualization.
• Documented User Stories and Acceptance Criteria for the PSPI (Potentially Shippable Product Increment).
• Extensively used JIRA to capture & manage User stories and actively participated in all the Scrum Ceremonies.
• Created Data Mapping Document to capture Source to Target Mappings and ensured required datasets were present in new system.
• Used SQL queries (select, insert, update, sub-queries, joins, etc.) to manipulate the data in the Datawarehouse.
• Created mock up screens using Balsamiq as per requirements and implemented the feedback from end customers.
• Created high and low fidelity Mockups, Wireframes to prototype the User Interface using Balsamiq.
• Worked with pricing team and market team to decide products that goes into 'clearance' catalog and default sort.
• Used Magento to manage shopping cart, update checkout process, and gift cards redeem.
• Involved in scrum ceremonies (Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective.)
• Mapped new system with Informatica PowerCenter to ensure data from data warehouse was designed to smoothly operate as per the business logic while incorporating information ported from current database.
• Documented all ETL transformations and mappings performed while establishing the data warehouse.
• Used Tableau to create customized dashboards, showing reports of the on-line store activity
• Developed Test Plans, Test Cases and Test Scripts to assist testing team in System Integration, Performance Tests, Functional and Non-functional tests.

Environment: Waterfall-Scrum hybrid, UML, MS-Visio, MS-Project, JIRA, Swagger, Power Designer, Tableau, MS SQL server, Postman, LoadRunner, Informatica PowerCenter, Balsamiq, Magento Web commerce.

Confidential

Business Analyst

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.
• Created conceptual and logical models of the data warehouse and mapped entities with ER diagrams and documented keys to allow for easy reference while development.
• Documented source & target systems and profiled extracted data to comply with target system architecture.
• Aided developers with design of migration plans and migration execution to not affect business actions and processes.
• Mapped new system with Informatica PowerCenter to ensure data from data warehouse was designed to smoothly operate as per the business logic while incorporating information ported from current database.
• Documented all ETL transformations and mappings performed while establishing data warehouse.
• Involved in scrum ceremonies (Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective.)
• Developed the 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 the backend as per the requirements of the mapping document.
• Used Tableau to create customized dashboards, showing reports that satisfied business need.

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

Confidential

Business Analyst

Responsibilities:

• Gathered requirements from key stakeholders, and SME’s to define the scope and requirements of 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 with Project manager in creating and assigned task through Work Break-down Structure (WBS). Worked in Waterfall System Development Life Cycle (SDLC).
• Developed UML Diagrams for modeling static and dynamic aspects of Mobile Application.
• Worked closely with Project Manager for any Change Request and helped to do Impact Analysis.
• Documented source & target systems and profiled extracted data to comply with target system architecture.
• Aided developers with design of migration plans and migration execution to not affect business actions and processes.
• Mapped new system with Informatica PowerCenter to ensure data from data warehouse was designed to smoothly operate as per the business logic while incorporating information ported from current database.
• Documented all ETL transformations and mappings performed while establishing data warehouse.
• Developed plans for verification and validation of requirements at all levels so that developed software successfully fulfilled user expectations and business needs.
• Used SQL scripts/queries extensively for data verification at the backend as per the requirements of the mapping document.
• Developed the 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 the calculations and creating reports accordingly.
• Worked on Advent Net ZOHO as a reporting tool to give the complete business Insights which could help management to take corrective actions to streamline the business Process.

Environment: Waterfall, MS Office, MS Visio, SQL, UAT Testing, HP QC, COTS. Advent Net ZOHO.

Confidential

Jr. Developer

Responsibilities:

• Involved in complete Software Development Lifecycle (SDLC).
• Wrote complex SQL Queries, Stored Procedures, Triggers, Views & Indexes using DML, DDL commands and user defined functions to implement the business logic.
• Advised optimization of queries by looking at execution plan for better tuning of Database.
• Performed Normalization & De-normalization on existing tables for faster query results.
• Created SSIS package to import and export data from various CSV files, Flat files, Excel spread sheets.
• Designed and developed different types of reports like matrix, tabular, chart reports using SSRS.
• Involved in migration on SQL Server databases
• Coordinating with onshore/offshore & stake holder’s team for task clarification, fixes and review.

Environment: Waterfall, MS Word, MS Excel, MS Project, MS Visio, Oracle, MySQL Workbench, Microsoft SSIS, SSRS.