Data Project
Resume:
Sumedha Sharma
**********@*****.***
Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
Extensive experience in requirement elicitation techniques like JAD sessions, Document analysis, Prototyping, Brainstorming, Requirement Workshop with Users, Subject Matter Experts (SMEs) and business Stakeholders.
Skilled in performing Gap Analysis and Impact Analysis by identifying existing technologies, documenting the enhancements to meet the end-state requirements.
Extensive experience with Business Analytics on data warehouse systems for various reporting systems within an organization.
Proficient in interacting with Stakeholders, Subject Matter Experts (SMEs), System Analysts and Technical team with excellent communication and interpersonal skills.
Well versed in different management scenarios like Change Control, Quality Assurance, Defect Tracking, System Integration and Scheduling.
Excellent business writing skills in creating business requirements document (BRD), use-case specifications, functional specifications, and systems requirements specification (SRS).
Experience with data analysis and data architecture.
Experience in performing root level analysis for data problems by identifying the system processes that lead to inaccurate data. Implemented validation checks as and where required.
Competent in Creating Unified Modelling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
Proven expertise in creating test plans, UML diagrams, flowcharts, screen mock-ups and systems requirements specifications.
Expertise in testing GUI Objects, Functionality and System testing including Integration, Performance, Stress, Load, Backend and Regression Testing of Client/Server and web based applications.
Analysis/Testing Tools
UML, Rational Rose, RequisitePro, Rational Clear Case, Caliber, Balsamiq, Domo, MS Project, MS Visio, MS
Office Suite, Sharepoint, Jira, Rest Console Mercury Quality Center, Soap UI and Rest Console,
Education
Bachelors in Commerce 2003 Punjab University India
Certifications
Informatica PIM Admin/User
Scrum Master
Professional Experience:
Dept of Correction New York
Lead Business Analyst Oct 2019- Dec 2020
Project: LMS Implementation-
The project is to implement an integrated Cloud based department-wide Learning Management solution that is highly configurable to meet the needs of all Dept of Correction units and can be supported by the DOC Information Technology Division.
Documented the affected business processes and worked with Implementation Partners to configure them in LMS system according to client requirements
Supporting the Learning Management System (LMS) project by developing test plans/scripts and coordination of testing activities
Shared knowledge in LMS functionality by assisting Client with administrator training and troubleshooting
Actively involved in configuring various configurations such as setting preferences, Security roles, Questions and tests in Production environment
Tested the batch and walk in functionality to validate the information is correctly flowing between Rapidld and Cornerstone
Created the data mapping documents for Historical Data Loads and Master Data Loads to support and validate data integration loads to production
Validating data accuracy and maintain admin security roles in the LMS and assist with data transformation
Verifying that the data loads are correctly mapped and validated the same in Production
Assisting DOC with UAT activities including UAT test scripts, training and assisting with any issues occurred at time of executing UAT testing.
DHS Dept of Homeless Services New York Feb 2019- Aug 2019
Sr.Business Analyst/Scrum Master
Project: Enterprise Reporting Portal
The project is to give users the ability to access all their reporting needs from a single platform instead of getting the reports generated from various different applications. Along with existing reports the users can also create their own custom reports and the management can have the dashboard view of the requested KPI’s
Senior Business Analyst Role
Elicited requirements from various users group and translated them into user stories
Created various data mapping documents to understand the data availability for the reports requirements
Evaluated potential enhancements to current reports and made recommendation for new reporting needs.
Analysed various data set to ensure integrity and structures to help provide business recommendations i.e. performance Metrics
Met with developers and QA team to ensure the understanding of the requirements and test validations for the portal
Met with the UX designer to create the Mock –up designs/Wireframes for the developers to understand the flow of the portal
Participated in the daily Scrum meetings to answer any questions related to BA activities and to give the status information on the work pending and on going
Worked with the product owner and the team for grooming sessions and managed the Jira board with the work assigned.
Scrum Master Role
Acted as a Scrum Master for Product team with a focus on guiding the teams towards improving the way they work
Assisted team to remove impediments and assisted in prioritization and resolutions of software defects
Organised and facilitated daily stand-up meetings, reviews, retrospective, sprint, release planning and demos
Interfaced with PMO office to ensure the project goals and requirements are being met
Worked with the Scrum team and Product Owner to negotiate the minimum visible product for delivery
Tracked and effectively communicated team velocity and sprint/release progress to management
Provided support and coached team members on Agile principles and provide general guidance on the methodology.
Church Pension Group New York May 2017- Jan 2019
Senior Business Analyst/Product Owner
Project: Church Pension Process Revision/Alfresco/CRDB Replacement
Senior Business Analyst Role
The Church Pension Process Revision dealt with changes with new rules incorporated by the church pension group for the retirement and pension processes(DB plans, DC plans,403b plans, Roth and RSVP plan) . The old BW system was replaced, and a new Ben Admin system was developed to fulfil the new and improved business processes while leveraging some of the existing processes from BW.
Documented the As-Is/To Be processes across various functional areas and met stakeholders for eliciting the requirements.
Arranged and facilitated JAD sessions for all the teams to talk about the requirements and discuss the design.
Coordinated the UAT efforts for all the different functional areas as a UAT lead
Documented the Job aids with collaboration with the client services training team for the future training purposes
Arranged multiple meetings with various business areas to smoothly execute UAT and provided with the test scripts and test data whenever needed.
Alfresco –The project was to upgrade the application from the existing version to a new version with new enhancements requested by business.
Used reverse engineering technique to document the business stories and processes currently existing in the application
Documented new business requests and estimated with the development team for feasibility in terms of delivery for new requests
Trained QA with the existing processes in application for their testing efforts
Worked as a liaison between business, development and QA team and helped resolved all the queries or additional information requested
Created test scripts for UAT and coordinated UAT with business. Documented the results and created bugs in Jira to be tracked by QA and development team
CRDB Replacement –CRDB system was serving as a database and stored the data information across most of the applications. The project was to replace existing CRDB functionality and merge it into Enterprise Data Warehouse
Prepared data mapping documents for the medical systems to get clean information in EDW.
Documented the existing and current processes for data flow in various applications and transformed business need and requirements in user stories
Worked with the data architecture and application support team to understand the impact of the changes this replacement will bring into business
Product Owner Role
Worked on multiple projects/enhancements/production support tickets for different business units
Implemented the monthly release process to support the coordinated application releases(Scrum of Scrums)
Worked with different business stakeholders to understand the goals derived are aligned with business objectives
Maintained and prioritized the backlog and ensured that the stories in backlog are prioritized for each sprint
Participated in project planning, daily standup meetings (scrums), demos, retrospectives, sprint planning, release planning and other Scrum-related activities
Works directly with senior leadership within each functional area to keep them abreast of design specifications and/or changes
Implemented new processes within the organisation to improve efficiency
Created UAT Test Scripts and coordinated UAT activities for each sprint and worked with business units to document the results in Jira
Documented business and data processes to understand the flow of information for various different teams
Participated in backlog grooming and planning sessions for different teams and sprints
Coordinated bi weekly Sprint Demo’s with collaboration with the development, Application support and QA team to show business the progress of the work in sprint
Worked with different business units to bring forth the concerns and issues in the daily stand up meetings and tracked them in the daily issue list.
State of Delaware, Newark, DE Jan 2015 - March 2017
Lead Business Analyst EDW/MMIS
Project: DMES-Delaware Medicaid Enterprise System
The project was initiated for replacement of legacy MMIS or enhancements for state to receive enhanced federal funding, to drive innovation for new capabilities and services, such as web-based, self-service tools that allow better access to information through a secure portal. Clients will be able to request eligibility and providers will receive prior authorizations and submit claims online and provide state health managers with near-real-time healthcare trend data to identify emerging needs in new Cares Management System
Worked collaboratively with stakeholders to research and elicit, analyse, validate and document business requirements, and to verify that those requirements clearly reflect true business needs.
Participated in JAD sessions with Stakeholders for translating business requirements to Design and documented the purpose and results of each JAD session.
Documented the rules in the existing legacy system as appropriate for incorporation into the new DMES rules engines including: benefit plan assignment, pricing rules, and the edit and audit rules
Reviewed Design Specification Document with stakeholders for accuracy and thoroughness.
Responded to inquiries in timely fashion keeping it professional and helpful.
Reviewed and monitored the work plans associated with the DDI phase of the MMIS.
Continuously worked with business teams to improve processes and delivery for their functional MITA business areas.
Conducted training workshops for the stakeholders for new system.
Worked with stakeholders to document and test T-MSIS Reporting
Monitor the business area for potential items or requests that need to follow the change control process.
Attended deliverable walkthroughs to enhance understanding and facilitate the approval process
Participated with the DHSS Requirements Change Control Board and process as needed.
Assisted the UAT manager with UAT planning, creation and execution of User Acceptance Testing and tracked and documented the results using HPE ALM.
Attended conference calls between State and Fiscal Agent and maintained meeting minutes.
Provided Stakeholders with guidance on monitoring and support during production go live.
Tracked and documented all the issues and concerns from Stakeholders after Go –Live.
Assisted Stakeholders and attended meetings with Fiscal Agents to document the Change orders after go live.
Environment: Windows XP Professional, MS Excel, Oracle, UML, MS Office suite, SharePoint, Business Objects, SOA, LDAP.
IPG, New York Aug 2014 - Dec 2014
Senior Business Analyst
Project: RMD Reporting
The primary objective of the project was to give senior and middle management insight into the organization’s support and compliance structure by providing detailed KPIs and metrics. The reporting ensured smooth on-boarding of new agencies and supported existing business units.
Conducted interviews with multiple key project stakeholders to understand the requirements to document and to create mock-ups.
Designed the navigation flow, screen mock-ups and user interface for the full-featured reporting functionality.
Performed the data mapping and defined data source, filter and target to facilitate the ETL team to feed the data into data warehouse.
Performed GAP analysis to understand the existing system and documented the gaps with the system
Conducted meetings with technical teams to ensure all the data required for reporting is available
Coordinated with all departments to ensure reporting changes will not conflict with internal applications and/or other reports.
Prepared Workflow diagrams, designed new process flows and documented the business process and various business scenarios
Designed and executes tests for new or updated reporting to verify they perform according to specifications.
Investigated reporting issues and defects reported by users
Facilitated, and recorded project meetings, such as BRD Review sessions.
Coordination of UAT to ensure every functionality and scenarios are captured for overall success of the project.
Prepared reporting instructions and explains the data of reports to users.
Environment: Windows XP Professional, MS Excel, Oracle, UML, MS Office suite, SharePoint, Business objects.
NYC Dept. of Education, Brooklyn NY Dec 2013 - June 2014
Lead Business Analyst
Project: CTE Application
This project involved a program management system that would allow the CTE office to capture complete, accurate, and quality CTE program data, and analyze and compare the effectiveness of CTE programs throughout the city based on the program resources and demographics of the population served. This is a system that serves as the foundation for evaluating all NYCDOE academic programs
Consulted with stakeholders to identify, define and document business needs and objectives, current operational procedures, problems, input and output requirements, and levels of systems access.
Drafted User stories for documenting the requirements in the Business Requirement Document.
Act as a liaison between departmental end-users, technical analysts, information technology analysts, design, configuration, testing and maintenance of management system to ensure optimal operational performance.
Lead the weekly progress meetings and resolved any queries from the stakeholder’s.
Created Requirement Traceability Matrix using Caliber to make sure the current project requirements are being met.
Created, maintained and evolved documentation for change management process.
Created business process flow diagrams using Visio.
Conducted JAD and brain storming sessions with the business users and stakeholders.
Conducted meetings with all the division supervisors to ensure that all the requirements are met.
Implemented the approved suggestions and modified the current process flows.
Documented Dashboard reporting requirements for the application insuring the KPI’s.
Analyzed the feasibility of and developed requirements for new system ensuring the system design fits the needs of the users.
Plymouth Rock Insurance, Quincy, MA Sept 2011 - Nov 2013
Sr. Business System Analyst
Projects: Underwriting 2.0 and LDAP Integration
Underwriting 2.0:
The aim of this project was to upgrade an existing BPM application for Personal and Auto New Business and Endorsement for New Jersey and PRAC with a new application “Underwriting2.0”. This enterprise project aligned the underwriting rules, workflows and underwriting logic for PRAC NE and NJ companies including an evaluation through an underwriting rules engine called MODEL 14.
Analyzed technical processes with business users, drafting and documenting functional/technical requirements for business systems enhancements.
Responsible for leading the ETL efforts in design efforts for Business Intelligence and analytics for statutory reporting of claims data.
Facilitated client interviews and workshops to gather, understand, and set client's project goals, objectives, complex business needs and potential opportunities.
Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development.
Worked with QA for defects validation.
Worked as an Interface between users and the technical teams involved in the application development for the better understanding of Business and IT processes.
Conducted Joint Application Development (JAD) sessions with end users to provide for accurate statement of system requirements and a better understanding of common goals.
Created change requests and change management of a process and document.
Involved in making changes in the Model database to match the existing database with company set name conventions and data dictionaries.
Conducted Daily Defect status and Progress meeting reports with team; carried out defect tracking using HP Quality Center for identifying and documenting all issues, functionality gaps and new functionality needs.
Collaborated with the developers in reviewing and validating test plans and test cases, ensuring that the final application catered to the user requirements.
Extensively involved in writing Manual Test cases and User Acceptance Testing (UAT) scripts.
Assisted in System, Integration and Regression Testing and database testing.
Involved in analysis of Test Plans and Test cases, detecting bugs in the system, preparing the Defect reports using Test Director and interacted with developers for Debugging.
Tested the Various XML inputs regarding the rules in Model 14 using Rest Console and getting the output for validating the results
Reviewed the Defects entered by the QA team and prioritized the defects and assigned them to the development team
Prepared UAT Materials, including the UAT Process, UAT Test document which would include step-by step process for UAT as well as all the tests that would cover all requirements.
Worked with the Training Group to build training materials as well provided any suggestions/ tool tips to assist in User Training
LDAP Integration:
The aim of this project was to synchronize Active Directory with LDAP (RHDS) for Authorization and Personalization for Web Applications and Web Services (on ESB). Red Hat Directory Server will support authentication and authorization for users and applications. The server maintains two trees, one which is an Active Directory replicated tree and a second one called an Application Tree. The replicated Active Directory tree will be used for Authentication. The Application Tree maintains nodes representing various applications and its child nodes represent users, groups etc and its related attributes used for authorization.
Analyzed technical processes with business users, drafting and documenting functional/technical requirements
Documented the LDAP Solution proposal
Prepared Use Cases, Activity Diagrams, Sequence Diagrams, and Class Diagrams according to the UML methodology.
Involved in extensive testing regarding sync process between the AD, RHDS and Application according to the Application tree.
Prepared test cases and validated the same using Apache Directory Studio for LDAP.
Daily meeting with the windows security administrator to run the scripts to execute various test cases in production and non-production environment.
Created multiple How to Documents for validation process.
Mercury Insurance Group, California Oct 2010 - Sep 2011
Sr. Business Systems Analyst
Project: Product Alignment FR and Claims
Mercury Insurance offers Property and Casualty and auto insurance through a comprehensive, web-based policy and claims administration system. The project aim was to upgrade existing third parties web services like Tucarfax, Prefill, System Admin Services, FR/Credit Scores and Claims. I was involved with FR / Credit Scores. The aim of this service was to calculate the premium by utilizing the Insurance score as part of premium calculation Criteria.
Gathered requirements, organized team meetings requirements from business users such as insurance policy managers, generated business process models, & use-case models, and created business requirements document (BRD) & functional requirements document (FRD).
Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
Involved in testing the SOAP messages across the web site and made sure results returned in XML format
Facilitated and managed JAD sessions with committee of SMEs from various business areas including auto insurance, home insurance, etc.
Responsible for creating data mapping documents required for the ETL team.
Experience using SOAP UI and validating XML Scripts.
Performed Business End-User testing of all Financial Responsibility Scenarios using both Soap and Rest Console. Also created the test cases for the same.
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.
Created functional requirement documents for the impacting projects
Performed criteria table updates for each project.
Developed XML-based data generation and validation extensions for internal QA framework and implemented test designs utilizing these data.
Analysis of business requirements and system requirements of the client.
Facilitated and led JAD sessions aimed at functional requirement walkthroughs for all the impacting projects and updated the documents based on recommendations (if any).
Documented and delivered Functional Specification Document to the project team.
Used MS Project to manage schedules, deadlines and resources and collaborate on the project.
Interacted with the developers on resolving the reported bugs and various technical issues
Environment: Microsoft Office Suite, Microsoft Visio, Java, J2EE, HTML, XML, UNIX, Windows NT/XP, Oracle, SQL, SQL Server, ETL.
Valley National Bank, Wayne, NJ Aug 2009 - Oct 2010
Business Analyst
This project involved the online portal through which users can manage their money online. This is a consumer product where we are enabling the users to manage their money online. Some of the product features such as online real time fetch of internet bank account statement, Wallet to track expenses, passbook to categorize expenses and incomes, auto categorization of transactions, portfolio, Liabilities, Net worth, Alerts & Reminders, budgets etc.
Lead, conducted and facilitated meetings with business users and information technology personnel.
Directed the project using rational Methodologies and acted as a RUP consultant for the whole project life
Worked on multiple stages of a project life cycle from conceptualizing, formulating and defining system scope cycle
Articulated business requirements from user interviews, and workshops and then converted requirements into technical specifications for developers.
Responsible for consulting with users and vendors for needs assessment.
Developed detailed analysis of users' needs (business specification, hardware requirements, software requirements, and flow charts).
Created work orders and Business Requirements documents.
Developed system related procedure/manuals, and provided system training.
Prepared detailed written documentation and business requirements. (Charts, work flow tables, specifications). Negotiates specification changes, test and implementation dates.
Identified methods, hardware or software that enhances productivity through research.
Developed a good understanding of the business unit's function.
Effectively communicated technical issues in non-technical terms to the business unit.
Monitored system implementations and user satisfaction.
Defined the business logic in capturing and presenting holder’s information in the portal application
Defined business and functional requirements on behalf of the business to provide to system Analysts for implementation.
Conducted Daily Defect status and Progress meeting reports with QA team; carried out defect tracking using Clear Quest for identifying and documenting all issues, functionality gaps and new functionality needs.
Collaborated with the QA team in reviewing and validating test plans and test cases, ensuring that the final application catered to the user requirements.
Provided project manager with regular status updates assisting the overall project management initiative.
Environment: Windows, Oracle, SQL, MS Visio, MS Access, XML, Business Intelligence, UML, Java, Requisite pro, Rational Clear Quest.
Lowe’s, Mooresville, NC May 2008 - August 2009
Business System Analyst
The aim of this project was to increase sales by simplifying and enhancing the selling process and tools, through the deployment of the Sterling Commerce application to support multi-channel selling, and provide a platform for flexible selling and enhanced functionality.
Prepared User Requirements Specification Document.
Attended meetings with managers to understand various process plans, business process, and functionality in detail.
Followed the Rational Unified Process of development through the Entire Software Development Life Cycle.
Identified major deliverables and collected business requirements for the project.
Designed and developed Workflow Diagram using UML.
Assisted the development team in interface development and performing unit testing.
Effectively worked with QA teams to review test requirements and documentation.
Maintained weekly project status reports, issues and documents.
Drafted project chart which included project goals, business case, opportunity statement, and high level timeline and team assignments for the projects.
Involved in Change Control Management and Configuration Management.
Developed Test Scripts, Test Plans and Test Cases from business, technical and functional requirement & Use Cases using Rational Clear Quest for defect tracking.
Led the User Acceptance Testing (UAT) sessions for business users.
Performed Regression and GUI testing.
Created Business Requirement Documents, Functional Requirement Specifications and System Impact Specifications for the Contract Management system
Created Use Case documents and building Process Flow diagrams using MS Visio
Used Star schema methodology in building and designing the Logical data model in the dimensional Models.
Creating and tracking Defects and Requirements using Mercury Quality Center
Conducting System Testing and Regression Testing, identifying application errors and interacting with developers to resolve technical issues
Conducted Regression, Configuration, Connectivity and Smoke Testing
Worked with Quality Control Teams to develop Test Plan and Test Cases.
Worked as a liaison between the Business and Technology Department.
Responsible for managing the migration of the department’s website using Web Builder and ensuring that there are no broken links on the intranet.
Wachovia Corporation, Charlotte, NC Apr 2007 - May 2008
Business System Analyst
This project revolved around the core credit card and billing application project. The aim of the project was to implement a centralized billing system that maximizes automation. The system performs all the functions of credit card processes such as Marketing, Payment, Getting Credit Bureau report and Transaction Summary.
Conducted user interviews, gathering requirements, analyzing the requirements using Rational Rose requisite pro - RUP
Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio.
Identify, research, investigate, analyze, define and document business processes
Conducted workflow, process diagram and GAP analyses to derive requirements for existing systems enhancements
Assisted with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place
Responsible for identifying and documenting business rules and creating detailed Use Case
Conducted User Acceptance Testing (UAT)
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 detailed knowledge of application features and functions assess scope and impact of business needs throughout analysis and completion of all enhancement specifications
Acted as a resource in understanding how IS systems carry out business functions and assists in ensuring the timely and effective implementation
Worked on MS-Excel and Visio while developing use cases.
Conducted QA testing with the technical team.
Developed timelines for project delivery, and managed projects and resources to successful completion.
Used SQL, Toad, Data Warehousing and Data Cleansing for the arrangement of customer data.
Used Data mapping for collecting the data.
Contact this candidate