SUMMARY:

• Senior Business Analyst with over 9 years of experience in the IT industry implementing a variety of projects in the E - commerce, Retail and Digital Marketing arena using Traditional and Agile SDLC methodologies like Waterfall and Scrum.
• Techno-Functional experience in Salesforce Sales, Service & Marketing Cloud and guiding clients on CRM solution for sales, marketing and services teams in the Ecommerce-Digital Marketing domain
• Experience in standard Salesforce configuration that includes creating profiles, roles, users, workflow rules, page layouts, Record Types, Approval Processes, Assignment rules, Validation rules, Dashboards
• Experience in Customization, Security Access, Workflow Approvals, Data Validation, Data Utilities, Analytics, Sales, Marketing, Customer Service and Support Administration in Salesforce . com CRM and Force.com Platform .
• Expert in generating and analyzing custom reports and dashboard for management and various business unit personnel to provide detail information on key performance indicators
• Familiar with Business Process Modeling, Data Modeling, Change Management methodologies
• Proficient in assessing Project feasibility through Cost-benefit analysis, SWOT analysis, Break-even analysis, What-if analysis, Gap analysis, ABC analysis, Risk analysis, ROI Analysis, and Value chain analysis
• Knowledge of several AWS services including EC2, VPC, S3, RDS , Kinesis, Auto scaling configurations
• Understanding of different protocols like SSL, HTTP, HTTPS, Force.com IDE, Validation rules, SOQL
• Knowledge of implementing Databases, Data Table Structures, Data marts, Data Analysis, Data Integration, Data Modeling, Schemas and OLAP operations viz. Slice, Dice, Pivot, Roll-up , and Drill-down and various schemas like star, snowflake, galaxy schema & conducted Proof of Concept (POC) demos and project reviews
• Elicited requirements using various techniques such as Joint Application Development ( JAD ) sessions , Interview sessions , Document analysis, Focus Groups, Requirement workshops, Surveys and Questionnaire over the years
• Using standard company proprietary guidelines, developed BRD's ( business requirements), SRS's (system requirements) and FSD's, Requirement Traceability Matrix for multiple paths of the project
• Used JIRA for managing User stories, defect lifecycle management and contributed in Scrum Ceremonies like Release Planning, Backlog grooming, Sprint Planning, Sprint Review and Retrospective while assisting Product owner in choosing prioritizing techniques like Moscow, Kano and estimating techniques like Agile Poker, T-shirt Sizing.
• Documented solutions using Share point, Confluence and used Reporting tools like Tableau, Excel
• Functional experience with concentration on Use Case modeling using Unified Modeling Language (UML)
• Hands on Experience in creating High Fidelity Interactive Graphic User Interface Design (GUI) , UI mock-ups, Wireframes using Lucid Chart , Invision , Moqup , Balsamiq and Proto to enhance the UI/UX experience .
• Knowledge in the ETL (Extract, Transform and Load) of data using INFORMATICA and other ETL tools into a data ware house/date mart and Business Intelligence (BI) tools like Einstein analytics, Business Objects Modules
• Knowledge in retrieving data using SQL queries like Joins, views, Aggregate functions like max, min, sum & average
• Good understanding of Service Oriented Architecture (SOA) , 3-tier and n-tier architecture systems , Extensible Mark-up Language (XML), and JavaScript Object Notation (JSON), web service concepts like HTML, CSS, SOAP, REST, JSON
• Proficient in test data management , API , Web Services Testing and documenting in Open API Specification (OAS 3.0) using Postman , Soap UI and documenting it using Swagger tool along with automating test workflows
• Experienced in QA testing, & Systems Testing of client server and web-based systems using tools like HPALM and HP QC
• Extensive knowledge of Continuous Integration and Continuous Deployment (CICD) using GIT, Jenkins
• Dynamically participated in Post Production Validation (PPV) making sure the entry and exit criteria are met
• Designing online survey & Managing CRM data for ad & marketing campaigns with proficiency in A/B multivariate testing
• Worked in maintaining the Functional areas of Forecasting, Accounts, Contacts, Leads, Campaigns, Opportunities, Quotes, Activities, Dashboards and Reports
• Encouraged best practices including continuous integration, Test-Driven Development (TDD), Behavioral driven development (BDD), Acceptance Test Driven Development ( ATDD ), Pair Programming .

TECHNICAL SKILLS:

Digital Marketing: Google Analytics, Google AdWords, E-mail Marketing

Database, Data Analysis tools & ETL tools: Tableau, MS SQL server, Oracle 8/9/10, DB2, MS Access, Informatica Power Centre, MuleSoft, Google Analytics

Programming Languages: SQL, HTML

Requirements, Test & Defect Management: JIRA (v.6.3,7.0), HP Quality Centre (v.11, 12), Confluence, Postman (v.3,4,5,6), IBM, Rational Requisite Pro, Swagger (v.2.0,3.0)

Modelling Designing: MS Visio, Smart Draw, Process Model, Balsamiq

Productivity tools: MS Office, MS Project, MS SharePoint, MS Word, MS PowerPoint, MS Excel

Operating Systems: Windows XP, Windows 8, Windows 10, LINUX, UNIX, Ubuntu

SDLC Methodologies: Agile/Scrum, Waterfall, XP, Kanban, Scrumban, WaterScrumFall

Web Services API: SOAP, REST, XML, JSON

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

PROFESSIONAL EXPERIENCE:

Sr. Business Systems Analyst

Confidential, Jersey City, NJ

Responsibilities:

• Interacted with various user groups for gathering the Requirements for Salesforce CRM implementation
• Involved in gap analysis, data analysis to identify any data gaps and eradicate any bottlenecks and minimize risks in the business processes
• Participated in business process analysis, data modeling and identified the data and did modifications if needed
• Assisted testing team in creating test plan and test cases
• Initiated and drove the adoption of Agile practices to improve productivity within solution delivery space
• Designed and prepared the Use Case Diagrams, Class Diagrams, Sequence Diagrams for process flow using MS Visio
• Assisted Product owner in writing well defined User Stories and Gherkin format Acceptance Criteria
• Worked closely with business users in defining the scope, analyzing business requirements and segregating them into high level and low-level requirements in Salesforce CRM solutions
• Worked on Sales & Commerce Cloud to give agents the tools to deliver an outstanding customer experience, enabling them to work faster and more productively, which improves customer satisfaction and reduces costs
• Involved in creating inbound and outbound flows for Mule ESB in HTTP
• Assisted in creating Process Builde r to automate complex business process
• Created and captured screenshots in Sandbox for stakeholder presentation
• Assisted in the process of data migration from Excel to Salesforce using Data Loader & Import WIzard
• Created Record types to offer different business processes, picklist values, and page layouts for different users thereby helping in tailoring business processes
• Uploaded the lead into CRM system and assisted in managing all aspects related to lead and customer in the related to lead life cycle i.e. when lead is cold, hot, acquired to finally delivered
• Extensively used Jira and Confluence for converting requirements to User Stories by Product Owner
• Conducted JAD sessions with users across the Industry to identify the requirements, use case analysis and outlining business rules
• Created Definition of Ready and Definition of Done for the teams
• Assisted in the process of data migration from Excel to Salesforce using Data Loader & Import Wizard

Environment: Magento, Agile Scrum Methodology, salesforce.com, MuleSoft, HP ALM (12), Confluence, MySQL, JIRA 6.0, SharePoint, R EST, Balsamiq, Postman 4.0, MS Visio

Business Systems Analyst

Confidential, Bentonville, AR

Responsibilities:

• Gathered requirements around customization of Salesforce.com pertaining to dashboards, reports, custom fields & custom-built applications such as Quotes/RFPs
• Assisted the Scrum Master in the producing the Burn-Up & Burn-Down Charts and updating them
• Participated in Agile Scrum ceremonies and in planning poker sessions for consensus
• Performed review sessions with various stakeholders to gather sign-offs
• Documented Definition of Ready (DoR) and Definition of Done (DoD ) for the teams
• Worked on Salesforce.com Chatter for Internal Stakeholders communication
• Documented Definition of Ready (DoR) and Definition of Done (DoD ) for the teams
• Conducted Gap Analysis between the As-Is and the To-Be system to identify key areas of concern and addressed them with the team and documented the processes
• Facilitated User Acceptance Testing to check if all the requirements were met according to the specification and carried out Defect management using JIRA
• Created Users, Roles, Public Groups and implemented role hierarchies and record level permissions to manage sharing access among different users on marketing cloud of SFDC
• Worked with various salesforce.com objects like Accounts, Contacts, Leads, Campaigns, Reports, and Dashboards .
• Worked with architect to create & develop wireframes & mock-up screens using Visio .
• Created Test Plans, Test Cases for Unit, System, Regression & Load testing .
• Performed configuration task using Apttus CPQ and Opportunity Management
• Implemented Apttus CPQ (Configure, Price, Quote) for Sales Cloud platform
• 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
• Modify Page Layouts, Lookup Fields, Standard Related Lists, Tabs & defined Dependent Pick Lists
• Assisted in writing Acceptance Criteria and framing Definition of Done (DoD) on Scrum board for Potentially Shippable Product Increment (PSPI) and assisted in enforcing WIP limits for optimized process flow
• Assisted in creating and managing User Roles, Profiles, Permissions, and Role Hierarchies, Public Groups, Security Controls, and Shared Settings
• Created and captured screenshots in Sandbox for stakeholder presentation

Environment: Salesforce, Apttus, Data Loader, Workflow & Approvals, Sandboxes, Confluence, My SQL, JIRA, MS SQL Server, J2EE, Java, XML, SharePoint, MS Visio

Business Systems Analyst

Confidential

Responsibilities:

• Authored progress and completion reports which were then submitted to project manager on a weekly basis
• Facilitated JAD sessions with SMEs and business analysts from other systems for a detailed analysis and a better understanding the impact of various aspects on each other
• Captured requirements in the form of User Stories and defined user Acceptance Criteria for each of them
• Prepared GAP Analysis, Risk Analysis and Cost Benefit Analysis to understand the As-Is and To-Be process
• Worked closely with business users to prioritize and scope out the Product Backlog Items (PBIs) based on priority
• Formed workflow diagrams, sequence diagrams, use cases, Analysis & Design Document, Interface Control Document, and Data Mapping Document for incorporating design changes
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL to filter data and assisted in Creation of Hash tables referencing the Surrogate Key tables for efficient lookup to Dimensions
• 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
• Acted as a resource in assisting team members in the development and executing test/use cases/negative tests.
• Participated in server deployment on Cloud, ( EB ) Optimization / cost reduction of Amazon AWS services
• 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
• Proficient in SQL queries such as Joins, Triggers, select to find the pattern and correlation in existing data
• Experience in Functional, Data Driven Testing, Load, Performance Testing & Validating WSDL using POSTMAN
• Prioritizing API function call for testers and documenting the API according to system, Performance & experience

Environment: AWS Elastic Beanstalk, Informatica Power Center, Confluence, JIRA, Jenkins, VPC, EC2, S3, Tableau, Postman, Swagger, MS Office Suite, Waterfall

Jr. Business Analyst

Confidential

Responsibilities:

• Utilized my communication skills to conduct JAD sessions, Interviews, Brain Storming, Surveys, Prototyping and other elicitation techniques to collect requirements for the project simultaneously performed the Cost/Benefit Analysis (CBA), SWOT analysis, GAP analysis, Impact Analysis to check the feasibility of solution provided.
• Created project plans in accordance with project management standards and procedures and Identified ongoing issues and gaps within project plans, to eliminate implementation issues and updated them on SharePoint.
• Worked closely with the product development team during various phases of Product lifecycle management (PLM).
• Consistently tracked the project status and reported it to all the stake holders using SharePoint.
• Assisted in creating the UML diagrams and interactive Hi-Fidelity Mock ups and GUI for development team to better understand the requirements in an orderly manner and updated the Requirements Traceability Matrix
• Used Data Loader for insert, update, and bulk import or export of data from Salesforce.com objects and used it to read, extract and load data from comma separated values (CSV) files, flat files, Html files, CRM data, temp tables.
• Assisted in testing efforts, ensuring that issues are identified, tracked, reported on and resolved in a timely manner and assisted the development team to perform UAT testing and updated status in the SharePoint.
• Assisted in creating dashboards and reports on the Salesforce platform
• Assisted in guiding the customers on Sales & Service Cloud implementation
• Built reports as requested by management, along with standard sales reports

Environment: Salesforce, Java, Windows, Swagger, HPALM, SharePoint, XML, JSON, Optymyze, Salesforce Classic UI, REST service, Jira, Confluence, Postman, Tableau.

Marketing Analyst

Confidential

Responsibilities:

• Scrutinized customer's feedback identifying market trends , locating market segments , profiling potential customers and providing product modification
• Work with both demand and field organizations to share insights for optimizing content for email, landing pages, videos, social and other channels
• Acted as a liaison between the marketing team and technology team for feedback and requirements.
• Managed LinkedIn and other social media, hit 2500 average views per post (105% increased)
• Performed Google Analytics for the website, analyzed the landing page and conversion rate, suggested the managing team to optimize the website and assisted in content creation for the Ad campaigns both online & paper.
• Perform market research , identified the target customers and presented new market insights to the team for Retail Pricing Management and launched a product capturing upwards of 71% market share value
• Assisted in developing E-mail marketing campaigns using Mail-chimp and helped in A/B multivariate testing
• Executed SEO and local SEO for the businesses to help them attain top spot on Google Map
• Worked extensively with Microsoft Excel (Macros, VLOOKUPS, and Pivot Tables), Microsoft Word, Power Point

Environment: : Waterfall, WordPress, Google Ad Words, Google Analytics, Hub Spot CMS, Hub Spot E-mail, Marketing, Microsoft Excel (2007), Microsoft word, Power point, MS Access (2007), Google Online Marketing, Apache, PHP

Digital Marketing Analyst

Confidential

Responsibilities:

• Contributed SEO guidelines and recommendations to clients and developers for the structure of website landing pages
• Assisted the Google AdWords, analytics team, managed PPC campaigns,
• Wrote and edited close to 250 product descriptions and posted them to the SQL database using SQL queries
• Created SQL statements & CRUD operations to validate the data in the backend process.
• Requirements Elicitation, Analysis, Communication support and guidance to Business users and end customers .
• Developing content initiatives to launch blogs and social media profiles in order to generate significant inbound marketing results
• Analyzing and researching keywords related to client's website through keywords research tool.
• Conducting competitor analysis to identify improvements as well as increase visibility and rankings.
• Making strategies for Social Media Marketing
• Review of traffic reports using Google Analytics
• Augmented and approved successful marketing campaign proposals that droves sales and market growth for clients
• Created measurement plans to allow business users to measure site performance against various business objectives and goals
• Created semi-automated excel reports for users who required an excel format
• Conducted deep-dive analysis on various topics to provide insights to business users that could be used to drive changes on the site and in the marketing strategy

Environment: Waterfall, JOOMLA, SQL, Visio, WordPress, Windows XP, Microsoft Office suite, Apache, PH, MS Access