Priyanka Das

Business Systems Analyst/IT Architect

ac70eb@r.postjobfree.com 469-***-****

PROFESSIONAL SUMMARY

Around8 years of experience in information technology industry as a Business Systems Analyst working on multiple domains like Telecommunications, MS Dynamics CRMwith 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, Testing phases, and its documentation.

Addressed users and stakeholders to elicit, analyze, communicate and validate requirements, identify Functional and Non-Functional requirements.

Authored the SOW (Statement of work), RFI (Request for information) documents.

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.

Excellent conceptual and technical skills in preparing 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.

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

Strong expertise in developing Use Case Model, Activity diagram, Sequence diagrams, and Class diagrams, Business process flow diagrams (BPMN)- AS IS and TO BE diagrams using MS Visio.

Proficient in customizing already existing business practices, workflows, activities and deliverables.

Participated in sprint ceremonies to suggest improvement in scrum process.

Responsible for maintaining Requirement Traceability Matrix to track the development and QA process.

Implemented System, Integration,Smoke, Sanity, Functional, End to End, Positive and Negative and monitored the behavior of the applications during different phases of testing.

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

Software Methodologies

Agile (Scrum), Waterfall

Project Methodology

Unified Modelling Language

Content Management

SharePoint

Prototyping Tools

Balsamiq, Pencil

Business Modelling

MS-Visio, Smart Draw

Business Intelligence

SSRS (SQL Server Reporting services), Tableau

Languages

C, Java, HTML5, CSS3, CSS, XML

Project Management Tools/ Bug Tracking Tools

Mercury Quality Center, JIRA, Rally, HP QC, Version one, MS Project, Team Foundation Server (TFS)

Database Management

MS – Access, SQL Server2008/12/14, SQL, PL/SQL, Oracle Developer

Document Creation/Management

MS Office suite, MS Dynamic CRM 2011/2013,

MS Visio, MS Office Sites (Excel, Word, Publisher, Outlook, PowerPoint, One Note)

Operating Systems

Windows, Linux/Unix, Mac OS

PROFESSIONAL EXPERIENCE

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

Role – Business Systems Analyst/IT Architect

Project Description

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 background analysis on various disposition processing documents and internal DOJ applications.

Analyzed disposition processor and batch processor system documentation and listed the error messages.

Studied Internal and external report documents and documented Disposition Portal analysis content for SOW milestone.

Conducted requirement gathering sessionfor 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.

Analyzed the BCIA agency open arrest data extract record layout reference document and BCIA sexoffender open arrest records to discuss the open arrest report layout for Disposition Portal.

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

Worked on IAMSiteMinder setup for DispositionPortal and Identified roles, trigger points and process for each role.

Discussed usability, Data sources and stream value analysis for disposition processing.

Conducted Business Architecture planning meeting to discuss various scenarios for Disposition Portal.

Enhanced process flow diagram, context diagram of As-Is and To-Be forDisposition Portal.

Analyzed manual disposition processing and documented the disposition flow diagram.

Identified and analyzed ATDR data files and documented the test data.

Discussed the information sharing model and conducted DispositionPortal connectivity meeting with infrastructure and security team.

Discussed and analyzed the disposition cycle data from RAP sheet training document to understand the RAP sheet with CRUS.

Reviewed juvenile disposition documents to collect detail information.

Analyzed NIEM Disposition reporting on-boarding document and data element mapping document to analyze the schemadefinition of XML tags.

Environment: Waterfall, MS Office, Notepad++, MS Visio, Balsamiq

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

Analyzed the scope document and the current business processes to gain better understanding of the projects.

Conducted GAP Analysis after analyzing AS-IS business process and the TO-BE business process.

Responsible for preparing Business Requirement Document (BRD) and then translating into Functional Specifications Document (FSD).

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

Prepared the high-level document and executive slides for various projects.

Conducted interface design calls to finalize the interface required for the project implementation for assisted channel applications.

Involved in finalizing 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.

Developed and executed Test scenarios, Test cases, documented bugs and ensured UAT issues are identified, tracked, reported and resolved to achieve project timelines.

Involved in exploratory testing on assisted channel applications.

Involved in daily testing status calls to provide solution from E2E architecture if required.

Involved in architecting the designing the workflow diagrams in E2E perspective and provided solution for project implementation.

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

SUEZ Water,NYCAug 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, Microsoft, Hyderabad, India Jan2010 – Jun 2014

Role –Business Systems Analyst

Project Description

Project 1

This project is about migration of 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 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. Supported 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