PROFESSIONAL SUMMARY:

• Senior Business System Analyst wif 7 years of professional experience in Business Analysis in Supply chain, E - commerce & IT domain, working on custom Point-of-Sale (POS) application, Salesforce CRM & Oracle E-business Suite ERP integration, Inventory optimization, Order management System, Risk pooling, Material requirement planning, Vendor management and Warehouse Management.
• Well versed on Lean Six Sigma, Lean Agile and have hands-on experience in SDLC methodologies like Waterfall, XP, RUP, Scrum, Kanban, Scaled Agile Framework (SAFe 4.0) & in Hybrid Methodology like Water-Scrum-fall.
• Processed Request for Proposal (RFP) for potential business set-up & evaluated Statement of Work (SOW).
• Utilized a fusion of industry noledge & technical programming to provide management wif a development & implementation of interactive business tools & strategic analysis vital for mission-critical decision-making.
• Full Software Development life cycle (SDLC) experience including Analysis, Design, Review & feedback of Business & Software Requirement Specifications.
• Experience in eliciting, analyzing & documenting Business Requirement document (BRD) and Functional Specification Document (FSD) based on teh requirements elicited from Business owners, users and SME’s.
• Experience in facilitating Joint Application Development (JAD), conducting various elicitation techniques like Brainstorming, Interviews, Questionnaire, Prototyping, Document Analysis, Focus Group, Reverse Engineering, Interface analysis & Observation, Surveys.
• Experience in assisting teh SME’s in feasibility study, Impact Analysis, Cost/Benefit analysis, 5-Why analysis, Pareto analysis, ABC analysis, Risk analysis & baselining acceptance criteria.
• In Depth understanding of teh AS-IS & TO-BE by conducting GAP Analysis business processes & experience in converting teh requirements into technical specifications for preparing test plans.
• Set up Requirement Traceability Matrices based on defined business rules to ensure all teh requirements are fulfilled & all teh test cases are executed according to teh proposed plan & used HP ALM to log down teh defects.
• Experienced in developing & reviewing State Chart diagrams, Sequence diagrams, & Activity diagrams using MS Visio, Balsamiq & to define teh business solution model & documented requirements using Use Cases.
• Assisted UI Team to understand interfaces & systems in a better way by creating wireframes & mockups
• Experience in writing good User stories and Acceptance criteria & handling teh Requirements Churn.
• Assisted teh PO in TEMPeffective Product Backlog Management using various tools such as JIRA, RALLY & TFS.
• Expertise in breaking down teh epics and user stories into tasks by using various slicing and dicing techniques.
• Participated in Sprint Ceremonies (Backlog grooming, Sprint Planning, Sprint Review & Retrospective) & efficient in using prioritizing techniques like MoSCoW, KANO, business value, technical risk based & estimation techniques such as Agile/planning poker, T-Shirt Sizing & Relative mass valuation.
• Created Users, Roles, Public Groups, implemented role hierarchies & record level permissions to manage sharing access among different users on marketing cloud of SFDC.
• Designed & deployed custom dynamic workflows, validation rules, Approval Processes & Auto-Response Rules for automating business logic wif Sales & marketing cloud on salesforce.com.
• Experience working wif Salesforce Classic and Lightning UI for custom theming, branding Wave and Einstein Analytics for account & opportunity insights, recommendations, prediction builder & predictive sorting.
• Experienced in SQL queries to validate data in MS SQL SERVER, creating database objects like Views, triggers & custom stored procedures, indexes.
• Used DDL, DML & DQL statements to perform CRUD operations on database queries like Joins, Subqueries & Aggregate functions to ensure Integrity between DB & UI.
• Worked wif data modeling tools to identify key elements & table structures & aid database design.
• Created Entity- Relationship Diagrams, Identified teh attributes, relationship between different tables.
• Proficient wif SQL 2005 Business Intelligence tools, Data Warehousing, Normalization, Data modeling, Dimensional Modeling (star schema, snowflake schema) & Extract Transform Load (ETL) processes.
• Strong noledge of Service Oriented Architecture (SOA), 3-tier and n-tier architecture systems, Extensible Mark-up Language (XML), and JavaScript Object Notation (JSON).
• Experience in identifying & documenting REST, SOAP APIs using Swagger, testing using SOAPUI & Postman.
• Developed Reports / Dashboards wif different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular wif global & local Filters).
• Experience working on Revamping reports, dynamic reports using tools like Business Objects, IBM Cognos.
• Experienced in Unit testing, Functional testing, Regression testing, Integration testing System testing, Black box Testing, Load testing, performance & Stress testing using different tools like QTP & Selenium.
• Experienced in writing test cases to meet teh system objectives & involved in facilitating User Acceptance Testing (UAT) to check if teh software or product can handle required tasks as per teh specification.
• Experienced in defect tracking, defect analysis & ability to organize, document & track changes & defects using tools like Jira & ClearQuest.
• Experienced in change control procedures in Waterfall & Scrum environments, experience in working wif SIPOC diagram for process improvement.
• Experienced in handling BIGDATA wif HADOOP Eco-System using Hive, Sqoop, Flume, HBase, Yarn, etc.

TECHNICAL SKILLS:

Database & Data Analysis tools: Tableau, MS SQL server, Oracle 8/9/10, DB2, MS Access, Informatica Power Center 9.6.1, Data Mining, Slicing, Hadoop, Microsoft SSIS/SSRS/SSAS, Dell Boomi, SAP.

Programming Languages: MY SQL, C, JAVA, JQL HTML, PHP.

Requirements, Test & Defect Management: JIRA, Quality Center, HP ALM, Confluence, Rational Clear Quest, Rational Rose, Selenium, Load Runner, Service Now, IBM Rational Requisite Pro, ProClarity, Selenium, QTP.

Modelling Designing: MS Visio, Smart Draw, Process Model, Just-in-Mind, 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.

SDLC Methodologies: Agile/Scrum, SAFe, Waterfall, XP, Rational Unified Process (RUP), Water Scrum Fall.

Web Services API: AJAX, SOAP, REST, B-PIPE, XML, FIX, STML,XML spy.

PROFESSIONAL EXPERIENCE:

Confidential, Las Vegas, NV

Salesforce Business Systems Analyst

Responsibilities:

• Conducted requirement walkthroughs to understand teh benefits of teh new system being implemented.
• Performed Document analysis to understand AS-IS state & then continued wif GAP Analysis to fill in teh dots between AS-IS and TO-BE state for teh need of teh system to be implemented.
• Assisted SME’s in carrying out Cost/Benefit Analysis and Feasibility Study to check teh net benefit and teh feasibility of teh project.
• Elicited requirements using interviews & JAD sessions wif teh Product Owner to integrate Oracle E-BusinessSuite wif Salesforce as teh new CRM platform used by sales personnel for teh complete view on lifecycle of customers from prospects to account management.
• Served as liaison between business & technology department, enhanced communication between executives, managers & peers.
• Captured user requirements in teh form of User Stories and defined Acceptance Criteria for each of them.
• Prepared Product Backlog from teh elucidated requirements, assisted teh Product Owner & Development Team in creating User Stories in JIRA.
• Analyzed BusinessRequirements & segregated them into high level & low-level Use-Cases, Activity Diagrams and Sequence diagrams in Balsamiq for Development Team to have better understanding of teh system & linked it wif JIRA using Confluence.
• Created Data mapping specifications, Source to Target mapping documents including teh transformation rules, business logic by identifying Data mapping components.
• Closely worked wif teh Scrum Master in teh Burn-down chart, Task Board updates & Product Backlog reconciliation.
• Participated in agile scrum ceremonies like Sprint Planning, Backlog Grooming & Sprint Reviews.
• Provided User Interface Document to teh new Salesforce Development Team for clear understanding of teh system.
• Worked on various standard Salesforce objects like Accounts, Opportunities, Campaigns, Leads, Contacts, Cases, Reports & Dashboards.
• Worked closely wif Sales Cloud & Service Cloud team to identify prospective users & creation of Case when User tries to use any self-serve features & faces issues wif existing system.
• Developed various SFDC Custom Applications, Custom Objects, Tabs, Custom Reports & Dashboards. Created Tab permissions, Record Type & Page Layout permissions.
• Created Profiles, Roles based on Organization role hierarchy & implemented Record-Level & Field-Level security & configured their sharing settings.
• Integrated Web Services for extracting teh data from external systems to display in Salesforce.
• Analyzed click-through rates on campaigns & developed insight reports using marketing cloud.
• Involved in Data Integration Process to Salesforce platform using APEX Data Loader.
• Involved in identification and documentation of Salesforce APIs like REST, SOAP, Bulk, Analytical APIs wif SWAGGER and testing teh API’s wif Postman.
• Actively managed Requirement Traceability Matrix (RTM) for higher management review & used HP ALM to log teh defects from various testing phases.
• Reviewed Test case, Test data & Test Scenario to make sure testing should perform properly.
• Closely monitored and assisted in Smoke testing, Regression Testing & Black-Box Testing, & Facilitated UAT Sessions, worked on defect life cycle using JIRA.
• Created various Reports & Dashboard wif Tableau & Power BI to assist managers to better utilize Salesforce cloud as a Sales Cloud, Marketing Cloud, Service Cloud & Analytics Cloud.
• Actively participated in Post Production Validation (PPV) & handled issues appropriately.
• Used Dell Boomi’s Atom Sphere integration for Salesforce integration to simplify teh process of merging data, updating Salesforce wif ERP data in real time, ensuring data consistency across Salesforce instances & creating and integrating APIs dat pulled data from multiple systems.
• Provided for teh new solution to Businessstakeholders.

Environment: Scrum, JIRA, Confluence, Salesforce Clouds, Salesforce Lightning UI, Einstein analytics, APEX Data Loader, MS Office, MS Project, Balsamiq, Tableau, SWAGGER, Postman, Dell Boomi Atom-Sphere, SIPOC, SOAPUI, Java, XML, Oracle E-BusinessSuite, Oracle DB, Selenium.

Confidential, Bridgewater, NJ

Business System Analyst

Responsibilities:

• Used agile methodology to understand teh existing system and teh current businessprocess and methods to identify deficiencies and areas for improvement and enhancement.
• Performed GAP analysis by studying AS-IS and accordingly creating TO-BE documents to identify teh potentials of teh improved system.
• Created and maintained User Stories by Interviewing teh businessusers to communicate teh requirements to development team and also conducted highly interactive JAD sessions wif stakeholders to identify & resolve issues.
• Performed Requirement Analysis & developed UML Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams using Object Oriented Design (OOD) concepts & UML using Balsamiq to understand teh requirements.
• Responsible for documenting user stories, business rules, workflow diagrams and business process modeling (BPM) for teh proposed functionality.
• Gathered requirements around customization of Salesforce.com pertaining to dashboards, reports, custom fields & custom-built applications such as Quotes/RFPs.
• Assisted teh Scrum Master in teh producing teh Burn-Up & Burn-Down Charts and updating them when required.
• Participated in agile scrum ceremonies and in planning poker sessions for consensus of LOE.
• Integrated, supported and administration of SalesforcePlatform tools, including Collaborative, Mobile & Cloud options.
• Customized existing Visualforce to align wif salesforcenew Lightning UI experience, worked on ServiceNow integration.
• Worked on Collaborative - Leveraged Salesforce Chatter for Internal Stakeholders communication.
• Analyzed teh changes performed in CRM application for marketing, sales etc., translated them to businessand functional requirements for Service Cloud in SFDC.
• 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.
• Designed and deployed workflows, validation rules, Approval Processes and Auto-Response Rules for automating businesslogic wif Sales and marketing cloud on salesforce.com.
• Added new custom objects, assigned fields, designed page layouts, custom tabs, components, custom reports.
• Supported a major effort to improve teh Order Management System (OMS) capabilities of Supply Chain.
• Worked wif architect to create & develop wireframes & mock-up screens using Visio.
• Created Test Plans, Test Cases, & Test Scripts for Unit, System, Regression & Load testing.
• Facilitated User Acceptance Testing to check if all teh requirements were met according to teh specification and carried out Defect management using JIRA.
• Created various Reports and Dashboard in order to assist managers to better utilize Salesforce cloud as a Sales

  Cloud, Marketing Cloud and Service Cloud, etc.

Environment: Scrum, Salesforce.com: Market, Sales & Service Cloud, Power Designer, MS Office Suite, Microsoft Visio, MS SQL Server, Data Loader, Microsoft SSIS/SSRS/SSAS, Tableau, Balsamiq, JIRA, Confluence, Cucumber.

Confidential, Union, NJ

Datawarehouse Analyst/ Business Analyst

Responsibilities:

• Responsible for establishing, & performing business process engineering analysis, & modelling of business processes.
• Prepared Business Requirement Documents (BRDs) after teh collection of Functional Requirements from
• System Users dat provided appropriate scope of work for technical team to develop prototype & overall system.
• Directly interacting wif teh Stakeholders/Business Managers & served as a primary point of contact for Data warehousing & IBM Cognos reporting solutions depending on project requirements
• Designed & developed Use Cases & Activity Diagrams using UML in Microsoft Visio.
• Used IBM Cognos Teradata & Oracle for enterprise Data Warehousing.
• Analysed & conducted data mapping from source to target location & performed data profiling to check data integrity.
• Responsible for designing & supporting teh components of data warehouse, such as ETL processes, databases, reports, & reporting environments.
• Also created teh Data Mapping Document identifying teh source system and target system, wif transformation rules and business logic for teh ETL Process to go smoothly.
• Extensively used MySQL Toad for querying underlying database tables & resolving data issues.
• Actively participated in validating teh data, manipulating & updating teh table using SQL.
• Identified & documented SOAP API using Swagger & involved in testing of APIs using Postman.
• Extensively used XML Spy to verify & validate XML files.
• Actively involved in Identifying & documentation of SOAP API & also tested them using SOAPUI.
• Actively involved in defect tracking & defect life cycle management using defect management tool Clear Quest.
• Responsible for defining teh Test plan, analysing teh Test scenarios, preparing Test case documents,defining teh performance environment requirements.
• Documented, updated & assigned test scripts for manual testing using customized Quality Center.
• Designed & executed automated unit, regression & performance tests using QTP & facilitated UAT.

Environment: Waterfall, MS Office, QTP, Clear Quest, Swagger, Postman, IBM Cognos, MySQL, XML Spy, Clear Case, SOAPUI, Oracle DB, Informatica Power center.

Confidential

Business Systems Analyst

Responsibilities:

• Worked wif teh team in Sprint Planning, Daily Stand Up, and Sprint Backlog.
• Interacted wif businessusers and end clients to document custom reporting requirements and high-level product backlogs.
• Collaborated wif cross-functional teams for prioritization of Product and Sprint Backlog.
• Conducted Focus Group Session wif Retail team, Compliance Team and users, managers and other SMEs to identify functionalities dat would maximize ROI.
• Conducted data mapping activities to map transactions and subscriptions.
• Performed analysis on eCommerce sales and operations to improve overall businessperformance.
• Wrote and updated User Stories to capture all actions in functional specifications document (FSD).
• Proficiently halped development teams to break down large EPICS, Features to User Stories for execution.
• Participated in Scrum, Planning Poker and Retrospective Meetings.
• Conducted several meetings wif SME's/ PM, PO for further suggestion and improvement of teh new functionality.
• Designed plans for User Acceptance Testing (UAT) and facilitated Post Production Validation (PPV) to ensure all functionalities are meeting teh standard.
• Created and troubleshoot defect tickets in JIRA before assigning them to developers.
• Validated all defect/bugs and assigned developer.
• Extensively used SQL to verify teh integrity and consistency of teh data.
• Extracted data from database and assessed data analysis using SQL to businessuser based on requirements.
• Assisted in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing.
• Created pivots and charts in excel sheet to report data in teh format requested.
• Maintained and provided daily, weekly, monthly and yearly reporting from a variety of data sources to coworkers, manager and senior management.
• Created & visualized data and reports in Power BI thereby providing interactive insights to clients.
• Maintained Agile Methodology during teh project- including in facilitating teh daily scrum meetings and assisted teh scrum master in maintaining project deadlines.

Environment: Agile, Microsoft SSRS, JIRA, Smart Draw, MS Visio, SQL Server 2008, Power BI, Informatica Power Center, MS-Visio

Confidential

Business Analyst/SQL Developer

Responsibilities:

• Involved in gathering & synthesizing User Interface & Business Process Requirements & translated them into functional & non-functional requirements of teh Business Requirement Document (BRD), which used as input to teh functional design specifications.
• Planned & defined system requirements to Use Cases, Use Case Scenarios & Use Case Narratives using teh UML methodologies. Created Use Case/Activity /Sequence Diagrams in MS Visio.
• Conducted JRP sessions & JAD sessions wif teh management, vendors, users & teh Information Technology team members for open & pending issues to develop specifications.
• Worked wif teh technical team to discuss teh business requirements, workflow, data availability & environment details & plan phases in development.
• Created SQL statements & CRUD operations to validate teh data tables. Developed test scripts in PL/SQL to check teh data integrity from teh databases. Used different Join statements to Join multiple tables in teh database.
• Worked on teh SQL tuning & optimization of teh Business Objects reports.
• Created new Views & Aggregate tables for report performance.
• Created Hierarchies as per teh business rule for teh reports to be viewed at various Drill-down & Drill-up reports.
• Worked along wif teh testing team to derive test cases, test plans for efficient Data reporting.
• Conducted teh Unit testing, prepared teh testing document, creating teh error log document & facilitated UAT.

Environment: Waterfall, MS-Office Suite, MS Visio, MS Access, Business Objects 6.5 Designer, IBM DB2, PL/SQL, LINUX 7.

Confidential

SQL Developer

Responsibilities:

• Extensively involved in designing teh Informatica to export data of flat file source to SQLServer database.
• Involved in portions of teh analysis phase of teh application development cycle.
• Implemented and managed database backup and recovery strategies.
• Created and developed teh stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Created and developed tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQLServer Enterprise Manager.
• Generated test data and tested database to meet teh functionalities deliverables in teh project.
• Generated database SQL scripts and deployed databases including installation and configuration, creating tables, relationships, triggers and indexes for enforcing business rules.
• Involved in creating SSRS jobs to automate teh reports generation, cube refresh packages.
• Extract Transform Load (ETL) development using Informatica Power center.
• Hands on experience in using different transformations like rank, sorter, aggregator, etc using Informatica.
• Designed high level ETL architecture for overall data transfer from teh source server to teh Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Worked wif T-SQLto create Tables, Views, and triggers and stored Procedures.

Environment: SQLServer 2005/2008 Enterprise Edition, Informatica Power Center, Enterprise manager, ProClarity Server, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle