Business Analyst

SUJATA LINGAYAT

630-***-**** ******.********@*****.***

SUMMARY

Accomplished Business Analyst with strong domain knowledge of Healthcare and Retail industries. Strong technical skills in Data Warehousing, Business Requirement gathering, Functional and Non-Functional Requirement elicitation and documentation.

A result-driven leader focused on exceptional performance through strategic team leadership, managing complexity and track record of substantial problem-solving skills.

Excellent written and oral communication and project management skills with an outstanding work ethic and a commitment to excellence.

TECHNICAL PROFICIENCIES

DW Technologies : Informatica 8.6, 9.1

Database Packages : Teradata, Oracle 11g, SQL Server 2005, 2008

Modeling Tools : Microsoft Visio

Languages : SQL, PL/SQL, Java Script

Operating Systems : Windows NT, Windows 2000, DOS, UNIX.

Testing Tools : HP Quality Center 12.2

Automation/Scheduling Tool : CA Workload Automation 11.3

Reporting Tool : Tableau, SSRS, Microstrategy.

Certifications : Certified ScrumMaster®(CSM®), Trained in SAFe( Certification pending)

PROFESSIONAL EXPERIENCE

Centene April 2020 – Present

Healthcare Domain Business Analyst

Collaborate with business units (Care management, Utilization Management, Member & Provider Services, Claims, Pharmacy & Network team) to define important KPIs to monitor the performance of the health plan.

Built product performance dashboards for executive leadership using KPIs to show the performance of Marketplace, Medicare and Medicaid products.

Developed utilization report for emergency department and out of network visits.

Collaborated with Care Management to identify the opportunities to reduce emergency services utilization by promoting Urgent care, In Network providers & Telehealth.

Analyzed Grievances in Billing & Financials category to identify the Providers that balance bill the members. Using this analysis developed an educational campaign for Providers.

Collaborated with Member/Provider Services, Pharmacy, Provider Relations, Medical Management, Networking & Claims departments to better triage Member & Provider inquiries.

Improved member retention by identifying & closing out 43% unused channels from the tracking system and resolving member/provider requests within SLAs.

Capgemini Jan 2018 – April 2020

(McDonalds), Retail Domain Business Technical Analyst

Worked with several teams within McDonald's USIT, USORT & Security to ensure established processes and deployments to Restaurant Systems Solutions (POS, Back Office, etc.) are scheduled in a timely manner and executed as planned.

Involved in long term strategic plans to improve deployment from both a technical and process standpoint.

Worked on Planning, scheduling and managing multiple deployments to ~14000 McDonald's restaurants without colliding with each other.

Managed requirements gathering, development, testing and execution of deployment reporting through the entire deployment lifecycle.

Recommended deployment approaches based on remote deployment standards and best practices and communicate them to business partners & project managers.

Analyzed deployment progress, running queries, deployment reports using SQL & MS Excel, created/modified metrics to evaluate the process of the releases and providing status.

Performed call volume analysis of pre-production Test deployments to plan for ~14000 restaurants.

Collaborated with business partners to manage expectations & outcome for deployments.

Coordinated with development, packaging and QA team to understand the pre-requisites & functionalities of the software releases to understand the dependencies & planning considerations.

Accenture Services Pvt. Ltd. Feb 2007 to May 2016

(Duke Energy), Utilities Domain Business Analyst / ETL Lead Sept 2012 to May 2016

Assisted in developing business architecture such as scope, processes, alternatives, and risks.

Collaborated with the client to gather business rules/requirements, converting into user stories and constructing easy-to-understand data and process models.

Ensured that user stories are good, has business values and story points.

Accountable for ensuring user stories to have acceptance criteria.

Proficiently helped development teams to break down large user stories for execution.

Worked closely with development team and QA team for testing software releases.

Provide recommendations for developing and modifying systems to meet client needs.

Reviewed & recommended Test approach, Test plans, and test cases for clients.

Ensure that the data mappings in UI matches per requirements/data dictionary.

Assisted in production issues to find the root cause & for developing ETL enhancements/fixes.

Managed maintenance tasks & creation of problem resolution documents.

Data analysis using Oracle SQL to propose solutions to roadblocks.

Monitored, tracked & documented the progress of the project by using requirement traceability matrix.

Duke Egencia Business Travel Account Project (Duke Energy), Utilities Domain

ETL Lead/Functional Analyst Oct 2011 to August 2012

Implement a solution for reconciling the business travel transactions and to match and load them to Expense Management System in PeopleSoft.

Led team of 2 offshore developers and 2 testers during all the phases of project.

Worked on requirement gathering, creation of Business Requirement Documents & its approval. Converted those requirements into technical designs, created ETLs and Unit Test Plans.

Analyzed business requirements & processes through analysis, interviews & workshops.

Conducted periodical follow up meetings with clients to review the requirements, explore any new requirements and find potential solutions.

Evaluated risks, steps during implementation, testing processes & potential trainings.

Expertise in the usage of SQL queries in SQL Server & Oracle for data analysis & verification.

Managed gathering the test data sets from vendors for system, UAT, integration & negative testing.

Led the testing efforts and worked as mentor to the testers to test these efforts.

Managed ETL code review & Review of scheduling applications per QA checklist and maintained Defect Life Cycle in QC.

Treasury Management Project (Duke Energy), Utilities Domain

ETL Developer Feb 2007 to Sept 2011

Managed wire transfers transactions and acknowledgments between banks and banks to vendors.

Gathered requirements, created technical designs for developing/modifying ETLs, creation of deployment plan & migration documents.

Involved in creation of test plans and their execution.

Designed, developed and delivered innovative Scheduling Solutions using scheduler application to handle transactions and acknowledgements between the client & BOFA, & is now adopted by other teams across the organization which in turn saved 60% of time & efforts of other teams.

Fixed the defects related to Informatica Mappings. Involved in the verifying the data and the schedules related to defect.

Led deployment activities for Go-Live and resolution of issues in post go-live "storm" period.

EDUCATION

Bachelor of Commerce, University of Mumbai, India

CERTIFICATIONS

Diploma in Computer Software Applications

Contact this candidate