Business Systems Analyst

Priyanka D

Business Systems Analyst

ac95gf@r.postjobfree.com 916-***-****

PROFESSIONAL SUMMARY

Experience in the software engineering industry as a Business Systems Analyst working on multiple domain/technologies like California Justice Information Systems, Telecommunications and Microsoft CRM with experience in implementation and Integration strategies within a team-oriented environment utilizing quantitative and qualitative analytical skills.

Extensive experience in Software Development Life Cycle (SDLC) including Agile (Scrum) and Waterfall methodologies with emphasis on the Analysis, Design and Testing phases

Developed BRD (Business Requirement Document), FRD (Functional Requirement Document) and worked on getting approval on the BRD/FRD documents from stakeholders and presented the same to the development and testing teams.

Inspected the Gap Analysis, SWOT Analysis to check the compatibility of the existing system infrastructure with the new business requirements.

Strong expertise in developing Use Case and Swimlane Diagrams using MS Visio.

Responsible for maintaining Requirement Traceability Matrix to track the Analysis, Development and QA process.

Skilled with elicitation techniques like Interviewing, Brainstorming, Group Discussions and Questionnaire to capture inputs required for functional design which included detailed process maps, UI mock ups.

Aided in creating, updating and maintaining QA Artifacts, Product Backlog, Sprint Backlog, Reports & Metrics to update required stakeholders.

Software Methodologies Agile (Scrum), Waterfall

CRM Tools Ms Dynamic CRM 2011/2013

Content Management SharePoint

Prototyping Tools Balsamiq, Pencil

Business Intelligence Tools SSRS, Tableau, Power BI

Business Process Modelling Tools Ms Visio, Enterprise Architect

Web Technologies HTML, CSS

Project Management Tools/ Bug Tracking Tools JIRA, MS Project, Microsoft Team Foundation Server (TFS)

Database Management SQL Server 12/14, Oracle 11g/12c

Strong expertise in developing Use Case Diagrams, Activity diagram, Business process flow diagrams (BPMN)- diagrams using MS Visio.

Participated in sprint ceremonies to suggest improvement in scrum process.

Determined the customer relationship management (CRM) process and allocate the necessary resources for smooth functioning of the procedures.

Assisted in supporting the real-time users during the User Acceptance Testing (UAT) phase and contributed in successfully delivering the application within the deadlines.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

State of California, Department of Justice (DOJ) Jul 2018 – Present

Role – Business Systems Analyst/IT Architect

Project 1:

California Sex and Arson Registry

This project is an enhancement to CSAR (California Sex and Arson Registry) in pursuant to Senate Bill 384. This law will transition California’s lifetime sex offender registration to a tier-based system. To successfully transition and continuously support the tier-based registration system, complete criminal history information will be required, including: state, federal, and military conviction and sentencing data; risk assessment data; and state and county level incarceration data

Project 2:

Disposition Portal:

The Disposition Portal: Error Management project focuses on delivering a web-application that can securely present data to external Criminal Justice Agency (CJA) actors. Actors will consume this information in order to improve the data quality of the criminal histories held at the California Department of Justice. This will help facilitate both DOJ and the external agencies efforts to meet their legal mandates through a higher-quality, more-timely, and targeted information exchange.

Responsibilities

Conducted requirements gathering sessions for documenting Business, Functional and Technical requirements required for CSAR Tiering.

Developed Technical use cases for Tier Assessment User Interface Form and Tiering Queues to in cooperate all the functional and technical requirements

Created Systems Analysis Documentation for CSAR Tiering along with documenting process flow diagram, context diagram of As-Is and To-Be

Worked on requirement change management process document and maintained version on SharePoint

Broken down the Business Requirements into technical epics and user stories in JIRA for development team and testing team to help understand the in-depth functional details

Conducted requirement gathering session for error report, logging and auditing requirements for disposition portal and documented end to end use case scenarios and associated business requirements.

Reviewed the data mapping document to analyze mandatory fields for developing screen mockups and developed Disposition Portal dashboard, list view page and error detail page using HTML/CSS/Bootstrap libraries.

Conducted meetings with stakeholders to document functional flow diagrams with field reps/ ATOSS team for current process analysis.

Worked on IAM SiteMinder setup for Disposition Portal and Identified roles, trigger points and process for each role.

Environment: Waterfall, MS Office, Notepad++, MS Visio, Balsamiq, Dispo Processor, Batch Processor and CSAR application

VERIZON COMMUNICATIONS Inc., Irving, TX Feb 2016 – Jun 2018

Role – IT Architect/Business Analyst

Project Description

Project 1

The scope of this project is to improve the customer experience by re-architecting the billing format feeds and storage that supports digital (Verizon.com) and assisted (Optix Billing) channels in Verizon Consumer Markets.

Project 2

This project will create the ability to allow agent assisted channels a systematic process that provides the ability to gather details electronically from a customer and capitalize on the opportunity to enroll a customer in auto pay and paper free billing at the same time.

Responsibilities

Conducted project initiation meetings by involving various teams of impacted applications.

Involved in designing workflow diagrams from E2E perspective and prepared High-Level documents and executive slides for Optix Billing and PCI Compliance projects.

Conducted interface design calls to finalize the interface required for the project implementation and finalized the UX Screens for the changes in the deposit flow in the assisted channel (Optix Billing)

Involved in resolving impediments that affected the performance of the Scrum Development Team.

Conducted exploratory testing on assisted channel applications (Optix Billing).

Developed test scenarios, test cases, re-tested bugs and ensured UAT issues are identified, tracked, reported and resolved to achieve project timelines.

Designed the workflow diagrams in E2E perspective and provided solution for project implementation.

Environment: Agile, Waterfall, JIRA, MS SQL Server 2012/2014, MS Office Suite

SUEZ Water, NYC Aug 2014 – Jan 2016

Role – Senior Business Analyst / Data Analyst

Project Description

This project aims in creating energy dashboards for business units with various operation areas including minute data frequency in different metrics by using operations calculation dictionary based on the formulas for each metric involved in different operation areas including the in and out conversion units with restrictions specified for each default metrics.

Responsibilities

Documented energy defined formulas with the defined restrictions and standardized the formulas.

List and map IPN based on each operation location to the standardized default IPN and units in and units out for each default IPN.

Standardize the nested function for each metric and identified the empty nested functions.

Verify and raise error for any gaps in formulas or incorrect formulas for each metric.

Create partitioning based on Default IPN, locations and designed reporting mockups for energy consumed each location.

Involved in creating aggregated and analytical data through SQL Queries.

Creating the data mapping document for capturing entity attribute domain and behavior.

Created user defined functions for conversion rule for each metric based on the operation location.

Analyze and sort the minute data in excel and load it into a staging table through control file.

Apply conversion rule and convert the data value based on each metric type and load the converted data into destination table.

Write stored procedure to load the data, migrate the data by applying conversion rules from temporary table to by applying the formulas for each metric load from staging table to target table.

Environment: Oracle11g, Erwin Tool, Tableau, SQL, PL/SQL, MS office suite.

TCS India Private Ltd, Hyderabad, India July 2011 – Jun 2014

Role – Business Systems Analyst

Project Description

Project 1

This project is about the migration of the existing banking system from sales Logix to the MSCRM for providing better Reporting, Client Tracking, Information Storage and Archiving, Capturing the outbound phone call, Number of visits made, Number of sales made, number of products activated or used, and the number of leads captured.

Project 2

In a bid to provide a one-stop fix to the business needs, this application is integrated with Global Microsoft SALES database to present an automated revenue profile of partners to the MS Business Managers. EAM, a new integration to OEM CRM is a Microsoft’s proposal to introduce a referral program where ecosystem partners / OEM service providers refer license sales Opportunities to distributors for fulfillment and receive a commission.

Responsibilities

Involved in functional analysis, design documentation and requirement gathering.

Converted activities or leads to opportunities, associated competitors with opportunities.

Worked on supporting the CRM production environment and resolving the issues for CRM production environment.

Gathered requirements for Building reports and dashboards in Microsoft Dynamic CRM for monitoring campaign, lead, prospect, opportunity, account and activities.

Involved in various meetings held based on data migration of the current CRM 4.0 version to the CRM 2011 version i.e. Sup ported Data Migration from legacy system to Dynamics CRM.

Assisted in developing custom SSRS reports for MS Dynamic CRM.

Used MS SQL database for data extraction and data analysis.

Surveyed variety of users to develop customized dashboards according to their security roles.

Participated in the weekly status update meetings with the business team.

Implemented Data Modelling techniques including Data Visualization, Data Warehousing and Data Mapping.

Traced requirements throughout the development process and verifying adherence using the Requirement Traceability Matrix (RTM).

Knowledge in generating Reports, Analytic Snapshots and Dashboard and Enabling Email Services.

Efficient in reformulating strategies through Process Re-engineering, Change Management, Release Management, Process Improvements and UAT Testing.

Environment: MS Dynamics CRM2011, Business Intelligence (BI), RDBMS (MS SQL Server, T-SQL, SSRS), SharePoint, waterfall methodology, MS Office Suite

Contact this candidate