Shilpa J. Shivalkar
Project Manager/ Lead Business Analyst/Scrum Master
MBA PMP, CSM
Ashburn, VA firstname.lastname@example.org 315-***-****
PMP certified high performance versatile professional with passion for delivering creative solution, identifying long-term opportunities to produce high-impact ROI and increase customer outreach with cost effective solutions.
Expertise in project/program management, problem solving and nurturing positive relationships with clients and cross- cultural teams at all levels. Versatile experience spans across IT Services, web -based project and mobile app development in the areas of Project Management, Business Analysis, Quality Assurance, Market research, Data Analysis, Product Marketing, Product Innovation and Solution architecture. Effective communicator, team leader and problem solver; able to coordinate and direct all project management processes while managing, motivating, and guiding cross-functional teams. Multi-faceted professional with combined 17 + years of B2C, B2B and B2G (Business to Federal Government) experience spanning across Federal Government, State Government, System Integration, Non-Profit & CPG.
Extensive experience in developing business process workflows and solutions. Comprehensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Testing. Adept at creating and transforming business requirements into functional requirements and designing business models using UML diagrams - Context, Use Case, Sequence, Activity diagrams in Enterprise Architect, MS Visio and Rational Rose for Content Management, Case Management, CRM, Mobile app development and Record Management solutions.
Excellent facilitation skills in conducting walkthroughs, surveys, questionnaires, interviews, brainstorming and JAD sessions. Comprehensive knowledge of RUP, Waterfall, Agile methodology. Strong experience in conducting UAT and documentation of test cases. Participate in quarterly business review meetings with leadership team and well-versed in CMMI Audit and process..
Assisted in the development and management of project plan, scope, business case, risk plan, schedule, timelines, and dependencies, constraints, budget, stakeholder's management plan, communications plan and RACI. Perform necessary risk responses and mitigation. Exceptional problem solving and sound decision making capabilities, recognized by alternative solutions, and confident, accurate, decision-making coupled with excellent communication and interpersonal skills.
Operating Systems: Windows Server 2003, Windows 2000 Server/ Advanced Server, Windows 98/XP/Professional / Windows 2012, RedHat Linux
Databases: SQL Server 2000/2005/2008, Oracle9i/10g/11g R2, MS Access, MySQL
Other Project Tools: HTML5, CSS3, Node .js, Spring Security, Activiti, Solr, Alfresco, eAuthentication, Elastic search and Logstash, Fiddler, MS Visio, Axure, Balsamiq
Process Tools: HP Quality Center, JIRA, Contour, Drop Box, SharePoint, Application Lifecycle Management, Deltek.
Management/Leadership Skills: Project Management skills, Strategic Planning Communications, Business Analytics, Client Relations Management, Critical Thinking, Cross-Functional Team Leadership.
Business Intelligence Tools: Tableau, Kibana, SSRS, Crystal Reports, Pentaho
Machine Learning/AI Tools: R, SPSS, Python, SAS
Life Cycle Expertise: Experience in all phases of Software Development Lifecycle applying Waterfall and Agile methodologies.
Specialty Skills: Process Analysis, Workshop facilitation, Problem solving and structured analysis.
Communications: Competent Communicator and Leader. Chaired Publicity Chair at Toastmasters Spring Conference 2014. Achieved distinguished club status for Loudoun Toastmasters as VP of Education 2015.
Mackson Consulting, Food and Drug Administration (FDA) Dec 2017 till Date
Sr. Principal Consultant (Sr. BA/PM)
Business Need: Development of the Mobile Application for FDA’s Food Safety Modernization Act (FSMA) (MAF) to design and develop a device-agnostic mobile application that would support operations for import inspection by field personnel. The MAF platform enables field inspectors to perform imports inspections, from assignment to completion, through use of a mobile device at the inspection site to capture all key data elements and prepare the information for submission.
Management of project scope, business case, risk plan, schedule/timelines, dependencies, constraints, budget, communications plan and RACI. Conducted team meetings with technical team to understand the project status, any risks and issues. Performed necessary risk responses and mitigation.
Documented the as is state and to be state of systems. Elicited, analyzed and validated business requirements.
Conducting gap analysis for mapping data elements. Performed data mapping, data lineage activities and document information flows. Developed system level user stories following Agile User Story conventions. Supported user stories with wireframes/ design prototypes and source to target mapping.
Created and maintained a hierarchical feature driven view of requirements.
Examined and evaluated current systems to determine and assess capabilities and business rules. Assisted in UAT Support activities including contact center solution research, procurement, set-up and training.
Publish Weekly and Monthly Status Report, provide project deliverables like Solution Architecture diagram, Solution Design document, Requirement Traceability Matrix, submit Test Results, Configuration Management Plan, Operation Readiness document, attend client meetings.Developed Training material and self-paced training website including design of wireframes, layout and developed content including recording and editing training video tutorials for C-level audience.
Designed wireframe for learning portal built with responsive design features in HTML5,CSS3, Java.
Created and edited video tutorial series for Computer based training portal.
Instrumental in setting up a Contact center solution support by implementing a vendor supported CRM solution.
Closely worked with the CEO for documenting CEO’s vision in the effort to acquire new projects/business. Assisting CEO with development the business case and vision.
Developed technical white paper promoting/pitching firm’s technical solution to FDA’s key stakeholders.
Environment: AEM Forms, Java, PhoneGap, Balsamiq, Jira, MS SharePoint, MS Project, Camtasia Studio, Oracle, Documentum, Angular.JS, JQuery, HTML5, CSS3.
Armedia, US Department of Agriculture (USDA) July 2016 to Dec 2017
Position: Lead Business Analyst/Project Manager
Business Need- Improve the oversight of all the FNS(Food Nutrition Services) programs, operated by States and Tribal agencies, through Management Evaluation (ME) and Financial Management Review (FMR). Build an application that will support / track the overall ME and FMR audit process conducted by the seven regions. Improved Search, Report, Evaluate and Data Visualizations capabilities, to aid in the data analysis, ad-hoc Reporting and Dashboards. Required a centralized Content Management system, that will contain the ME and FMR data, across all FNS program areas.
Managed software development project for US Federal Government (USDA).
Facilitated Scrum ceremonies: Daily Stand-up, Backlog Grooming, Sprint Planning, Sprint Review and Sprint Retrospective.
Provided coaching mentorship: Encouraged self-organization while removing roadblocks and impediments.
Managed projects from inception to completion and follow corporate PMO PMBOK-based guidelines: i.e. Create Project Charter, Project Management Plan, conduct Project Kick Off meeting, developed and managed Project Plan, Scope, Budget, Risk Plan and Risk Register, Change Request, Test Plan, Stakeholder Management, Communications Plan, RACI.
Acted as a liaison between the customer and the software development team.
Effectively prioritized multiple assignments and changed priorities as needed to support the developers, customer, and project leadership.
Collaborated with the development team by participating in design meetings and communicating detailed system requirements.
Analyzed and modeled the business domain to create a complete picture of process flows and functional requirements and user stories for the proposed solution.
Facilitate and lead requirements gathering workshops both internally and externally.
Ensured User Stories were consistent and covered all aspects of the Requirements.
Conducted BA handoff meeting with Development team members to ensure user stories are communicated clearly to team members.
Participate in Design sessions to address questions from the Development teams regarding business rules, change request etc.
Created and maintain the Requirements Traceability Matrix (RTM).
Worked directly with software engineers to ensure clear communications on requirements and defect reports.
Performed data analysis and recommend suggestions for Report layouts, Dashboards and enhancements for C-level audience.
Coordinated requirements walk-through and sign-offs, verifying with user representatives/stakeholders that user stories and process models accurately portray specific business needs.
Redesigned low-fidelity wireframes built in HTML,CSS, bootstrap library.
Created UAT test cases and Power Point presentations (demo) for various application.
Review Test Scripts to ensure all the scenarios are accurately covered in it. Performed 508 compliance testing using JAWS.
Facilitate Scrum ceremonies: Daily Stand-up, Backlog Grooming, Sprint Planning, Sprint Review and Sprint Retrospective.
Worked closely with Lead Architect to manage the requirements change management process. Facilitated and Maintained weekly CCB (Change Control Board) to review all changes across the project.
Planned, managed and stabilized technology team releases using agile approach.
Collaborated with technical team in the definition and breakdown of releases, ensuring fully understood by all and smoothly transitioned. Maintained CMMI related artifacts for each release. Peer-reviewed the release package to the customer.
Environment: HTML5,Angular.JS, JQuery, HTML5, CSS3, Node.js, MySQL,Java, Alfresco Enterprise repository, Alfresco Activiti, Elastic search, Logstash, Kibana stack, Jira, Contour, Visio, MS Project, SharePoint,Pentaho.
AGS/Camber, Fairfax City Circuit Courts, Fairfax, VA Dec 14 – June 2016
Sr. Business Analyst
•Evaluated potential software solutions, including off-the-shelf and open source components, and the system architecture to ensure that they meet business requirements.
•Refining business requirements from Project team members. Performed analysis and tracking of requirements.
•Preparing and analyzing AS IS and TO BE work flow scenarios.
Reviewing the design and preparing a GAP Analysis document. This also led to preparing the RTM to identify requirements that were missed and also to ensure that the design is in accordance with the requirements.
•Working extensively with Subject Matter Experts (SME’s) in understanding, extracting the User and Business Requirements pertaining to clients.
•Played a critical role in designing new process flow and documenting the business process. Designed various business scenario and activities of business from the conceptual to procedural level.
•Translated the functional requirements into User Specifications. These User Specifications acted as the final approved requirement / design and also acted as a technical and functional guide to the developers.
•Created prototypes based on the user requirements and conducted product walkthroughs using these prototypes.
•Developed the Test Plan, Test Conditions and Test Cases to be used in testing based on business requirements and tech specifications.
•Worked with the customer and management on User Acceptance Testing to validate business requirements and resolve issue.
•Worked with the project teams to develop and document release and deployment plans.
•Maintained and kept track of Stakeholders’ requests for enhancements and changes.
Perform functional, non-functional, performance testing and regression testing.
•Analyze/Document test results and provide management reports on test coverage.
Involved with the QA team to determine and develop test approaches and methods for Unit Testing, Integration and Functional Testing, Performance and Usability Testing according to application complexity and test requirement.
Environment: MS-Office 2013, SQL Server, .Net 4.5, WPF, C#, JIRA, Oracle 11i, Share Point, Crystal Reports, Windows 7, Sub version, UML, MS Project, MS Visio, Axure
State of Colorado, Fort Collins, CO Jan 12 - Nov 14
Senior Business / Data Analyst
•Involved in all phases of software development life cycle (SDLC) in RUP framework.
Analyzed and collected business requirements, identified system interfaces and created the requirements specification document.
•Applied Unified Modeling Language (UML) methodologies to design Communication Diagram, Use Case Diagrams, Activity Diagrams, Sequence Diagram and ER diagrams.
Extensively interacted with both user group and development team.
•Managed and tracked change control process of requirements and design changes. Documented the changes, issues and their impact on the system design and delivery.
Provided documentation such as requirements management plans, functional requirements, test plans and test cases.
•Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the db2 database.
Incorporated the best practice methodologies as advocated by the Rational Unified Process.
•Designed and analyzed Business Process Model, Use Case model and test procedures based on RUP methodology.
•Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with the process owners & stake holders and document analysis. Performed user interviews.
•Wrote user requirements specification (URS) and Functional requirements specification (FRS) Documents as per the Business requirements and process flow.
Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
•Designed and developed project templates based on SDLC Methodology
Developed UML Use Cases for the application and prepared the detailed Work flow diagram based on the proposed enhancement for the system.
•Interacted closely with the QA lead in formulating the Test Plan and planning the test-schedule.
•Created test cases for manual testing that included inputs, actions and expected result
Participated in User Acceptance Testing. Performed Black Box, System Testing, Security Testing, and Integration Testing to check the functionality of the application.
•Tested the website for security against unauthorized users and unauthorized data access for Single Sign On functionality.Performed Screen validation testing, System Analysis, Smoke test, Regression testing, System Integration testing, GUI testing, UAT (User Acceptance) testing and End-to-End testing.
Environment: Windows 2000/XP, RUP, UML, Visio, Caliber RM, EMC Input Accel, Rational Suite (Rational Requisite Pro, Test Director, Clear Quest, Rational Clear Case), ColdFusion, MS-Office 2003, SQL Server, SSIS
American Red Cross, Ashburn VA Mar 09 – Dec 11
•Established a RUP (Rational Unified Process) centric business analysis methodology.
Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
•Designing and customizing data models for Data warehouse supporting data from multiple sources. Performed Gap analysis and implemented updates for the Data Warehousing Application.
•Performed activities supporting the roll out e.g. the UAT template for Business User for QA, Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database. Run the SQL queries using TOAD and SQL Navigator.
•Assisted system analyst to create Sequence Diagrams and Class Diagrams to show the individual flow of activity and define functionalities of various processes in policy administration system.
•Provided key initiatives in working with users in defining project and system requirements. Conducted Architectural Discussions to prepare the Proposed Architecture and provided insight in the Business Case to the Architecture Review Board.
Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema.
•Execute test scripts, coordinated & conducted UAT testing.
Conducted JAD sessions for communicating with Stakeholders and Project directors
Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
•Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML.
•Performed requirement analysis, went through all the use cases and issue logs.
Conducted mass user interviews with brokers, enterprise user representatives and SMEs.
•Experience on analyzing the system test and systems analysis. Performed Smoke Testing of the product. Testing the functionalities of the system and capturing test results.
Conducted Regression Testing of the product. Raised and tracked defects and managing the defect cycle.
•Interacted with stakeholders during testing. Isolated bottlenecks at different levels and suggesting tune-up methodologies. Wrote SQL queries for back-end testing and validation of data. Worked with Development and Product Support to simulate realistic production scenarios for load and stress testing.
Environment: Windows, MS Office(MS Word, MS Excel, MS PowerPoint, MS Visio), .NET, Oracle, Crystal reports, RUP, UML, SQL, AGILE, SWOT analysis, Java/J2ee,
Pisoft Fairfax, VA Feb 07 – Jan 09
•Analyzed clients systems and business processes. Wrote Business Cases for the Stakeholders to understand the functioning of the new Underwriting System. Conducted user interviews, gathered requirements, and analyzed the requirements by using Rational Rose, Visio and Requisite Pro.
•Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models.
•Developed UML Use Cases using Rational Rose and developed a detailed project plan with emphasis on deliverables. Developed project plans and managed project scope.
•Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall. Coordinating and Developing QA activities.
•Conducted presentations of the QA test results with analysis to the stakeholders and users and documented modifications and requirements.
•Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data. Worked extensively with MS Excel and MS access.
•Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
Performed extensive Requirement analysis and developed use cases and workflows.
•Provided key input in working with users in defining project and system requirements.
Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
•Conducted JAD sessions for communicating with Stakeholders and Project directors.
Environment: UML, RUP, Mainframes, Agile, COBOL, JCL, Db2, Java/J2EE, Oracle, Rose, MS Word, MS Excel, MS Visio
Raymond’s June 01-Sep 06
Gathered high-level requirement for all the external projects in a release.
Facilitated JAD sessions with SMEs and business analysts from other feeder systems for a detailed analysis and a better understanding of impact of various projects on each other.
Responsible to import the parts of the existing reports using Business Objects Live Office to develop the required reports in Microsoft Excel and Word.
•Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.Created functional requirement documents for the impacting projects
Performed criteria table updates for each project.
•Analysis of business requirements and system requirements of the client and also for Property and casualty modules.Worked with SQL queries using MS Access for data manipulations.
•Facilitated and led JAD sessions aimed at functional requirement walkthroughs for all the impacting projects and updated the documents based on recommendations (if any
Created UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
•Reviewed test results and coordinated with testing and development team to correct the issues.
•Analyze business requirements and segregated them into Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and OOD using Borland Together according to UML methodology thus defining the Data Process Models.
Environment: UML, RUP, Microsoft Office Suite, Microsoft Visio, Unix, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, VBScript, C DOORS, C++, NET, ASP.NET, Business Objects, TestDirector
Bachelor’s in Science
Master’s in Business Administration (MBA)
Aptech software development courses
Certified Project Manager-Active (2011-2020) –Liscense #1443974
Certified Scrum Master (2016-2020)-Badge#-622731
Genpact certified Data Science Pro Degree certification Sept.2018
Memberships: Toastmasters, PMI, IIBA, Scrum Alliance