Candidates About

 

Vikrant Dharia                      

Experienced Business Analyst and Project Coordinator with strong analytic and technology expertise with over 10+ years of experience in Retail, Government, E-Commerce/ Omni channel, Supply chain & Logistics domains. Possess the ability to think out of the box and develop innovative business solutions which offer maximum business value to projects.

·         Comprehensive knowledge of Waterfall SDLC, complete UML Artifact, Scope definitions, and AGILE development framework with Scrum.

·         Involved in the projects from Pre-Initiation to Project implementation and closing.

·         Worked around constraints in Legacy systems/data variances and kept users engaged throughout the project phases.

·         As a Business Analyst, worked on multiple projects simultaneously and supported enhancements after deployment.

·         Created Business Requirements Documentation (BRD), Requirements Traceability Matrix (RTM) and Functional Requirements Documentation (FRD), Work Flows.

·         Played the role of Business Analyst, Tester, Data Analyst and basic SQL developer for reports and analysis as per the need of the projects.

·         Expertise in coordinating project management activities like defining/managing project scope, planning various activities for execution, estimating business value/impact and providing a periodic status report to management.

·         Excellent written and oral communication skills, presentation skills, analytical problem resolution skills, leadership, strategic planning, organizational and Interpersonal skills.

·         Strong skills in dealing with software development lifecycles (SDLC), both Waterfall, and Agile/Agile scrum.

·         Expertise in defining and documenting Business process flows and “As-Is” & “To-Be” processes.

·         Experience in data collection from multiple sources, interpretation, presentation, and management of reporting and decision-making.

·         Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.

·         Experience in working with cross functional and cross cultural team environments, different levels of management and liaison between system users, management and development teams.

·         Expertise to see the issue in the big picture, analyze the functioning of the system as a whole, break it down into smaller elements, identify bottlenecks, develop unique custom solutions.

·         Providing business requirements and instructions for Site personalization and customization. Worked with Performance testing teams for testing deep and highly trafficked e-Commerce sites.  Experience in Retail - Web application environments (Shopping Cart, Check Out).

·         Effective skills in applying various management tools like SWOT.

·         Competent in Creating Unified Modelling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.

·         Experience in Business Process Automation/Improvement, Business Process Re-engineering and Business Transformation and analyzing the complex modules and business processes.

·         Facilitated JAD (Joint Application Development) sessions, working sessions, review sessions, brainstorming sessions, walkthrough sessions, KT sessions, and offshore meetings.

·         Expert in conducting requirement gathering sessions, feasibility & Impact Analysis, Cost & Benefit Analysis, User Acceptance Testing (UAT) and Risk analysis.

·         Knowledgeable in Dot Net, Java, API – remote calls, Database stored procedures and functions that helps facilitate JAD sessions for complex technical solutions.

·         Ensured effectively and consistent application of standard and Operational process and Compliance of all laws and policies.

 

AREAS OF EXPERTISE

 

Analytics & Reporting	Problem solving	Documentation
Communication	Relationship management	Business strategy planning
Change management	Business process analysis & design	Negotiating & delegating

 

TECHNICAL SKILLS

 

Operating Systems	Windows
Business modeling and requirement management Tools	MS Visio, MS Office (word, PowerPoint, excel, Outlook)
Domain	Government, Retail, E-commerce, Supply chain & Logistics
Languages	API, HTML, C#, Java, VB.Net, VBA
Database	MS SQL Server, Oracle, MS Access
Content Management	MS – Share Point
Testing Tools	JIRA, HP ALM
Other Tools	MS Project, Share point, Balsamiq, SalesForce, Tableau.
Software Methodologies (SDLC)	Agile/Scrum, Waterfall
Documentation Tools	Confluence/JIRA, MS Office Suite – Word, Excel, PowerPoint
CRM	Salesforce

 

PROFESSIONAL EXPERIENCE:

 

 

Walgreens, Chicago, IL                                                                             June 2016 - Present       

Description: The scope of the project is to develop a service metric dashboard that comprises various functional areas of operations, finance, billing & collection and customer management in order to arrive at the key process indicators for the Top Management Decision making by efficiently involving the data migration, integration and mapping processes

 

Role: Sr. Business Analyst

Skills/tools: Agile Methodology, Sprint Planning, TOAD, JIRA, Visio, SharePoint, MS Access, SQL Server, MS Office, HP ALM, Mock-up screens.

 

Responsibilities:

·         Conducting user interviews, gathering requirements, analyzing the requirements.

·         Facilitated JAD sessions with SMEs’, Business Change managers (BCM) managers to understand the business process; gather Business Requirements and identified changes for the applications.

·         Coordinated and managed daily Agile meetings and addressed end to end issues and resolutions daily.

·         Identified the current Business Process, defined Use Cases from the requirements, created Sequence.

·         Diagrams using tools like MS-VISIO and developed a revised Business Process Model.

·         Managed and led a team of 4 people including development, and testing resources.

·         Actively involved in prioritizing requirements (vs.) deliverables throughout the SDLC in association with the Business Partners.

·         Created reminders (internal and external to project) and task alerts, to ensure that every one is aware of the Upcoming changes in the Infrastructure and ensured that the Infrastructure is Silent.

·         Conducted JAD sessions to finalize the Billing system design, scoping of functionality to be implemented per Release and design changes needed in Middleware services for Billing and Retail systems.

·         Implemented Process improvements for Order Processing in billing and Middleware systems.

·         Defined a solution and included case types, documents and other tasks using IBM Case Manager & Worked on Data Analysis to identify and enhance the Cycle, Time& Cost metrics associated to the issues of concern.

·         Performed detailed data mapping from Legacy to the new web-based integrated system.

·         Executed SQL/join queries to validate the data for to-be processes.

·         Provided deliverables quality assurance, management support for requirements and impact analysis for the Unified Billing Program.

·         Extensively worked on custom Reporting using Tableau, Performing BI Analytics using Tableau

·         Negotiated and managed multiple priorities, project plans, time frames and trade-offs, ensuring the Technical team understood the expected results of the projects.

·         Served as a point of contact to handle and share requirements between Business Partners, Development Team, Testing Team, Design Team and Management.

·         Communicate any further enhancements to the Technical Team based on the BP’s reviews and feedback.

·         Created Exceptions and Dependencies between applications that were delayed due to incompatibility issues.

 

 

Client: Panera Bread, St Louis MO                                                   Nov 2013 – May 2016

Description: This project to roll out mobile kiosk solution in 900 corporate café’s across US. The goal was to enable customers to place dine in and to go orders using in house Kiosk and their mobile phones with access to online payment options. The solution was to reduce wait times, improve accuracy and minimize or eliminate crowding.  A secondary goal was to provide customers a notification when their food is ready. Also, the solution included a product for inventory management.

 

Role: Sr. Business Analyst/consultant

Skills/tools: Jira/Jira Agile,  MS- Office (Word, Excel, Outlook, Power Point), MS- Visio, SWOT analysis, Competitive landscape analysis, Omni channel

 

Responsibilities:

·         Interfaced with business users to document ordering, receiving, customer picking, inventory processing and reporting processes for click & collect orders

·         Interacted with various stakeholders to collect their user stories; document, manage and ensure real-time tracking of them as project proceed.

·         Consulted with business team to identify, define and document business needs and objectives, current operational procedures, problems, input and output requirements.

·         Analyze business data, to understand customer behavior and also organizational activities of past in customer ordering and fulfillment processes.

·         Worked on Business Case Development and carried out intensive research with Business and System executives to set the strategic goals and future

·         Created Business Requirements Document (BRD), Use Case Specifications, Systems Requirements Specification (SRS), Functional Specification and User Stories; also created ad hoc reports as per the situation needs.

·         Extensively used Tableau features like Data blending, Extracts, Parameters, Filters, Calculations, Context Filters, Hierarchies, Actions, Maps etc.,

·         Studied the current system functionalities & behavior and documented “As-Is” process; later upon business requirements and identifying the application shortcomings developed “To-Be” processes.

·         Created mockup screens and presentations for designing the receiving, binning, and customer pickup processes on the mobile handheld devices

·         Oversaw end to end activities of SDLC from planning to implementation of product; conducted User Acceptance Testing (UAT).

·         Created a Requirements Traceability Matrix (RTM); Kept a track of product backlog, sprint backlog, and time estimates using Agile tools like Jira.

·         Worked with supply chain and café management teams for menu builders, inventory management, and their needs.

·         Performed estimations for implementing the system requirements and charted out a project plan for execution involving all the stakeholders and assigning responsibilities.

 

 

Client: Essex Properties, Palo Alto, CA                                                           Feb 2012 - Oct 2013

Description: Operates as a self-administered and self-managed real estate investment trust which is engaged primarily in the ownership, operation, management, acquisition, development and redevelopment of real estate. This project is related to developing a CRM application for a client to streamline the process of addressing complaints in properties, thereby enhancing customer experience. A customer (tenants) centric approach is carried out in executing the project; the application is developed in such a way that customer feels it simple & easy to report and the same will be reported to concerned service teams.

 

Role: Business Analyst

Skills/tools: Agile/Agile Scrum, Jira, Visio, UAT, Balsamiq, User training documentation

Responsibilities

·         Conducted multiple requirements gathering sessions with every stakeholder; inputs are gathered from documents, organized into formatted user stories, updated in tools like Jira Agile.

·         Conducted customer surveys, workshops and get together with chosen tenants (focused groups) for involving them into ongoing application development process.

·         Worked towards preparation of requirements management plan, business and functional requirement documents.

·         Gathered & sorted business requirements from stake holders, converted them into respective functional & non-functional requirements for development of solution.

·         Prepared test case scenarios, customer survey reports and wireframes for proposed application.

·         Created data flow diagrams and process flow diagrams to facilitate better system understanding.

·         Created new custom objects, assigned fields, designed page layouts, custom tabs and components.

·         Created multiple approvals and workflows to meet business needs.

·         Outlined the organization hierarchy and created profiles, roles accordingly in Salesforce; worked on visibility and sharing settings around them as required by the business.

·         Designed different custom dashboards for various user groups based on their business functionalities and needs.

·         Created and deployed several reports for different user profiles based on the need in the organization.

·         Designed various types of email templates for auto response to customers.

·         Developed training programs and training documentation for service teams in getting adapted to new CRM platform.

 

Client: Walmart, Bentonville, AR                                                                  Oct 2010 – Dec 2011

Description: The goal of this project is to eliminate the delivery errors in order management at distribution centers performing cross docking and also improve time management in fulfilling order shipments. In most instances errors occur in cross docking stage; shipments are either having products less or more than the order placed by the store. This is creating a total imbalance of supply chain system leading to a loss in economic terms.

 

Role: Sr. Business Analyst

Skills/tools: MS Visio, MS- Office (Power Point, Excel, Word), Human Factor Analysis, KPI analysis, Process analysis, Negotiating & Delegating, Logistics, Supply chain management.

 

Responsibilities

·         Developed business process flow diagrams in Visio, identified critical points which are creating issues.

·         Gathered As-Is information by following the concerned stakeholders in their day – to –day activities, studying their operations behavior.

·         Optimized efficiency of supply chain & logistics planning by eliminating the errors occurring at distribution centers; thereby enhancing product availability at stores.

·         Conducted workshops and brainstorming sessions with various stakeholders in the project to gather their individual requirements; documented and analyzed them to develop functional tasks.

·         Used MS-Visio for flow-charts, Use- Case process model and architectural design of the application.

·         Responsible for business process analysis that includes requirements facilitation, definition & analysis, alternatives, software selection, prototyping, business process design and mapping.

·         Conducted meetings and JAD sessions for project definition, resource identifications and deliverable prototype identification.

·         Developed Functional Requirement Document, Workflow diagrams and Use Case Specification document.

·         Assumed the position/personality of employees working in the warehouse to understand human factors leading to the problem.

·         Identified problems in business process, developed innovative solutions by employing new technologies into the workplace, eliminating human related errors in the supply chain.

·         Developed techniques for training the warehouse teams in improving their skill and eliminating errors.

 

Client: Agog Pharma, Mumbai India                                                                     Jan 2010 – Sept 2010                        

Description: Pharmaceutical company manufacturers and distributors of medical devices.

 

Role: Business Analyst

Skills/tools: MS Office, MS Visio, Negotiation, Delegating, Storyboard development, Requirements gathering, Financial analysis.

 

Responsibilties

·         Documented system requirements and buiness requirements and created Requirement Traceability Matrix (RTM) 

·         Performed the requirement analysis, impact analysis and documented Business Requirements Document (BRD) and Functional Specification Document (FSD) using Microsoft Visio  

·         Prioritized deliverables, identified gaps, tracked defects, defined system requirements, created artifacts for testing and development. 

·         Documented the Traceability Matrix for tracing the Test Cases and requirements related to them. 

·          Followed the UML based methods using Microsoft Visio to create Use Cases, Activity Diagrams, Sequence Diagrams, Collaboration Diagrams. 

·         Conducted FRS walkthroughs with technical departments to ensure design is accurate. 

·         Performed functional, smoke, regression, usability, system and integration testing. 

·         Engaged in system testing during User Acceptance Testing (UAT) 

·         Created use case scenarios and documented work flow and business process. 

·         Conducted FRS and URS reviews and walkthroughs with the designers, developers and stakeholders 

·         Involved in Requirements Gathering from user groups and analyzed workflows and UI screen dynamics 

·         Involved in GAP analysis in the identification of business rules, business and system process flows, requirements and assumptions 

·         Training and mentoring all the new hires and current employees for any process development 

·         Created traceability matrix to map Business, Functional, System requirements and test plans 

·         Extensively involved in implementing the Software Development Life Cycle phases from identifying requirements to conducting UAT 

·         Worked with reconciliation team to identify problems in current Invoice system and reporting's. 

·         Created functional requirement documentation, use cases. 

·         Facilitated and attended JAD (Joint Application Development) sessions. 

 

 

Client: GENPACT, Hyderabad India                                                            Jun 2007 – Nov 2009

Description: Financial Firm

Role: Business Analyst

Skills/tools: MS- Office, MS- Visio, Supply chain design

 

Responsibilities

·         Gathered Business Requirements, Interacted with the Users, Designers and Developers, Project Manager and SMEs to get a better understanding of the Business Processes 

·         Conducted JAD Sessions periodically with various stakeholders at various phases of the Software Development Life Cycle (SDLC) to discuss open issues and resolve them 

·         Organized requirements into high level use cases and low level Use Cases Specifications and modeled them into UC, Activity and Sequence Diagrams using Rational Rose. 

·         Created Use Case specifications, business flow diagrams, Activity/State diagram and Sequence diagram using MS Visio. 

·         Performed GAP analysis for the modules in production and also conducted feasibility study for the performance impact analysis. 

·          Responsible for providing documentation to team for troubleshooting and resolving issues reported by system users, facilitating resolutions. 

·          Created Requirements vs. Test Case Matrix in Excel Spread Sheet template used Test Director to store and maintain the Test Repository. 

·          Used the Unified Change Management (UCM) tool, Rational Clear Quest, to maintain and track the Stakeholders requested enhancements and changes. 

·         Conducted User Acceptance Testing (UAT) and collaborated with the QA team to develop the test

 

Educational Qualification

 

·         Bachelor of Technology in Mechanical Engineering