Microsoft Office Project

DHAVAL SOLANKI

Cell No: 226-***-**** *************@*****.***

SUMMARY

IT Professional with over 8 years of experience skilled in the areas of:

Competent in analyzing and creating Narrative Use Cases, Use Case Diagrams, Activity diagrams, Data/Flow/Navigational flow diagrams using UML Tools like MS Visio.

Analyzing production issues to determine root cause and resolution by reviewing production logs and source systems.

Adept in system and integration testing by reviewing test procedures, creating test plans/test cases, executing test cases and maintaining appropriate test data. An active participant in executing detailed test scripts for User Acceptance Testing (UAT), identifying defects and assisting team members in correcting errors in UAT.

PROFFESSIONAL EXPIRIENCE

Blue Cross Blue Shield of Michigan, Detroit, MI April 2012 – August 2018

Project: New Member Portal & Health Care Benefits Online (HCBO)

Team: Digital Experience.

Consultant: Lucid Technologies

Role: Senior Systems Analyst.

New Member Portal: The main purpose of member portal is to provide transparency, clear and simple customer experience. New Member Portal – is a new responsive site which combines 3 different portals (BCBSM, BCN and IKA) which Allow members to view their coverage, claims information and Explanation of Benefits, Copay information for different plans under single login which will give transparency to member and allow them to take health assessments, which will reduce premiums.

HealthCare Benefits Online (HCBO): The main purpose of Group Portal is to provide transparency to the group representative and improve their user experience. This portal allows the group representatives the ability to better service their employees by viewing their claims, EOB’s and coverage levels. The group representative may also add, change or cancel employee coverage via HCBO.

RESPONSIBILITIES

Perform lead system analyst and SME functions for Michigan Member Portal, Web Support and Customer Servicing tools, and Member Benefits Administration and Insight3Sixty systems.

Perform lead system analyst functions for the Michigan Employer HR portal. (HCBO).

Review new solution designs by attending Quality Review meetings, perform impact and gap analyses and approve technical design documents produced during the design phase of the project.

Process lead for the Incident and Ticket management ITIL functions, performing incident life cycle management process such as new incident triage, severity determination, defect root cause analysis, creation of application defect tickets, implement data remediation, adherence to the corporate SLAs and remediation of tickets.

Responsible to ensure service levels are maintained in Production for the mission critical applications.

Responsible to communicate the impact of incidents to Internal and external stakeholders by following established processes such as enterprise system alerts and posting advisory messages on the retail sites.

Responsible to generate daily and weekly operations reports for list of open tickets, statistical reports for Business and IT executive leadership review.

Report status of ongoing projects to executive leadership.

Mentor junior team members, removing roadblocks to their daily tasks and lead team in projects and testing to ensure overall quality.

Developed and strengthened skills with Agile development methodology by performing the role of Scrum Master. Here, the stories in the current and upcoming sprints were reviewed to ensure that stories were documented accurately and ready to be taken up for development/testing.

Involved with vendor management (V2Sort and Technosoft) in prioritization of defects and open tickets to ensure timely and thorough resolution.

IT Owner of MBA (Member Benefit Application) – which is used to store all Benefit information of all NASCO and Medicare Advantage groups.

Gather High Level Requirements and document them in PDM (Project Data Manager – Mainframe) and conduct business walkthrough of the requirements.

Prepare and execute test plans, test scripts and test case documents for UAT based on functional and technical specifications for HCBO (Health Care Benefits Online).

Work with NASCO Mainframe (NPS) with membership and Claims to identify and resolve issues.

To ensure quality, execute regression test cases manually after each code change/fix and review test outcomes.

Actively participation in Production support team to review logs and determine the root cause of issue.

Conduct Super Triage meeting with developers and business to go through Severity 1 issues and their resolution on Web-Ex.

Report Bugs using JIRA and also fix bugs by analyzing Logs assigned to me.

Run SAML Request/Response using Mid-Tier application (Interact) to determine root cause of issues.

Test all CSR (Change Service Request) in the migration of Group Portal.

ENVIRONMENT

NPS Mainframe, Interact, JIRA, Clear quest, Mongo DB, SOAP UI, Oracle, Toad, XML, Microsoft Office Suite, Adobe CQ (Content Management).

Johnson Controls,Milwaukee, WI. September 2011 – March 2012

Project: Sales & Operations Planning

Team: Sales & Operations Team.

Consultant: SVK Solutions.

Role: Quality Analyst/Business Analyst.

Sales & Operations Planning project: The main purpose of this Data-Warehousing project was to provide Transparent Automated Global and Regional (Americas, Europe and APAC) Operations Trend report to Senior Management with information required to manage risk and understand relevant Business trend over different LOB (Line of Business). Additionally this S&OP project checked the data loaded into the data warehouse against the source systems CMS, CBS and ODP using Business Objects info view tool.

RESPONSIBILITIES:

Worked closely with the Business to understand the Functional Specifications and system requirements and other issues throughout the project life cycle.

Analyzed Business Requirements documents to understand the detailed comprehensive test strategies to verify the system changes that meet the needs of the client.

Prepared and Executed Test Plan, Test Scripts and Test Case Document for User Acceptance Testing (UAT) based on functional and Technical Specifications.

Executed Regression test for each system (CBS, CMS & ODP) in SAP Business Objects Info view tool which deals the different status of the order/contract such as Scheduled, Unscheduled, Unreleased and Pipeline manufactured in different plant for different LOB (STC & LTS).

Verified the lead-time of different LOB in different regions and the quantity of the contract order in Data warehouse against source system.

Allocate Resource for the project as per the timelines, and handled resource and project issues with the upper management.

Helped in testing other project GSDM (Global Supply Data Master), the purpose of the project is to maintain a single master file of all the suppliers from all over the world.

Reported bugs using Quality Center and kept track of them.

Generated the detailed reports of the Bugs, Pass-Fail report.

Performed Regression test once the bugs were fixed and accordingly close the defect.

Conducted Weekly meetings with the Project team to prepare an overall QA status report and share it with the Team/upper management using HP Quality Centre 10.0

ENVIRONMENT:

Business Objects XI R/3, HP Quality Center 10.0, Web Intelligence, Microsoft Office Products like Excel and PowerPoint, SQL Server, SAP

Merrill Lynch, Jacksonville, FL October 2010 –September 2011

Project: International Merrill Lynch Personal Advisor Project.

Team: Global Operations Change Management Team. (Phase 1 & 2).

Consultant: SVK Solutions

Role: Quality Analyst / Business Analyst.

International Merrill Lynch Personal Advisor Project: The main purpose of this IMLPL project was to provide similar platform for International advisor as well as domestic advisors and maintain a global data master record centrally.

RESPONSIBILITIES:

Analyzed business requirements and business objectives, and used the information to develop detailed comprehensive test strategies to verify system changes that met the needs of the client.

Prepared and Executed Test Plan, Test Scripts and Test Case Document for System Integration Testing (SIT), User Acceptance Testing (UAT) based on functional and Technical Specifications.

Performed UAT’s for different Source Systems to get automated feed followed by Control-M jobs and manual upload where Source systems do not exist.

Executed regression test, which deals with Entering New supplier information.

Allocate Resource for the project as per the Time lines and attended conference call with offshore team to have a weekly status report.

Wrote and executed Test Scripts manually for IMLPL (International Merrill Lynch Personal Advisor) for wealth management.

Performed Software Application Testing, regression, functionality and negative tests by executing the Test Scripts.

Coordinate between Developers and End users.

Followed up with developers on defects status on a daily basis.

Reported bugs using Quality Center and kept track of them.

Generated the detailed reports of the Bugs, Pass-Fail report.

ENVIRONMENT:

HP Quality Center 10.0, Microsoft Office Products like Excel and PowerPoint

Farleigh Dickinson University, Teaneck, NJ August 2008 - December 2009

Role: Computer Lab Assistant.

RESPONSIBILITIES:

Assisted students with

oMaintaining their records.

oProduction Operations Management (POM) software.

oHTML Coding.

Answered computer questions and resolved problems regarding webmail and Microsoft office in Large User system.

Troubleshoot Equipment such as Laptops and Projectors in Classrooms.

COMPUTER SKILLS:

Microsoft Office, SQL, HTML.

EDUCATION:

Farleigh Dickinson University, Teaneck, NJ

MBA in Finance, Additional Concentration in MIS, GPA 3.4 December 2009

Honors: Scholarship of $6000.00 from University

Entrepreneurship Development Institute of India, Ahmedabad, India

Post Graduate Diploma in Business Entrepreneurship Management September 2006

Som-Lalit Institute of Business Administration, Ahmedabad, India

Bachelor of Business Administration April 2005

Contact this candidate