Manager Data

RICHA PANT

*** **** **** ******

(H) 617-***-**** I adb709@r.postjobfree.com

PROFESSIONAL SUMMARY

Experienced and impactful Analyst who responds to shifting business needs and priorities in a systematic and effective way. Combines excellent technical qualifications with achievements in quality improvement and project task management with a strong desire to work in an information systems environment. Seeking to leverage skills and experience in a leader ship role.

SKILLS

·EDI transaction (834,835,837 (I,P,D), National Council for Prescription Drug Programs (NCPDP 4.2 & 2.2), Healthcare Provider Information Transaction set (274),Medicare, Medicaid & CMS

·JAD Session

·Requirements analysis, elicitation, modeling, and verification.

·Data gathering and analytics to intelligence and knowledge forming using Power BI

·Extraction Transformation and Loading (ETL)

·Enterprise resource planning (ERP) and customer relationship management (CRM) functions.

·SSRS & SSIS

·Team Liaison

·Strong understanding of the complete software development life-cycle-AGILE

·Quality assurance

·Test case scenarios

·Debugging proficiency

·Business artifacts documentation

·Risk management processes and Gap analysis

·Project management

·Methodology implementation

·Release planning

·Operational assessments & management

·Manage multiple priorities and meet multiple deadlines

·Interpersonal and written communication

·Strong conflict resolution skills

·Powerful negotiator

·SQL and databases

·Microsoft Office Suite

·Service Now

·Management tools like JIRA, TRELLO, SLACK, SHAREPOINT (2010,2013,2016), TFS (Visual studio 2012,2015 & 2017)

·Fluent in HTML, XML/XSL

EDUCATION

Salem State University - Salem, MA 2014

Bachelor of Science

PROFESSIONAL EXPERIENCE

Texas Children’s Hospital - Houston, Texas 04/2019- Current

Business Systems Analyst

Conduct business process sessions and modeling sessions.

Write SQL code\query to extract and analyze data from multiple data source.

Track, analyze and interpret data trends and provide relevant conclusions and recommendation to management.

Responsible for creating, maintain, deploying and managing reports for internal analytics teams and our stakeholders.

Create, maintain and support SSRS reports.

Develop, maintain and support SQL statement, stored procedures, views and SSIS package.

Monitor and tune database performance as well as optimize SQL queries.

Provide administrative support and fulfillment of services request for reports, acting as the primary point of contact.

Communicates the project status with the appropriate project stakeholders throughout the implementation project life cycle.

Assist in key business readiness considerations, activities and deliverable to adopt changes resulting from business process or system improvement.

Perform analyses of various reports to compose summaries, business plans, PowerPoint presentations and recommendations to leadership and stakeholders.

Obtain and maintain knowledge of regulatory information with team members.

Ensure that end-users are properly trained in the use of existing processes on an on-going basis so that processes and procedures are not forgotten.

Conduct on-going enhancement of processes, procedures, and audits.

Develop and maintain automated and manual test scripts.

Create and access various database using SQL queries on various database

Survey end-users on a regular basis to address users’ questions, concerns or suggestions about existing processes or improvements.

Establish project plans and conduct work team meetings.

Ensure documentation (i.e., project plans, test plans, policies, and procedures) is accurate, acceptable, and in accordance with Integrated Delivery System standards and policies

Handling Service now tickets.

Determine, analyze, and formulate current practices, user needs, and workflow processed, issues, and potential solutions.

Recommend modifications to application designs or current procedures to maximize the advantages of current systems.

California Department of Health Care Services - Sacramento, CA 06/2017- 03/2019

Application Analyst

Worked on Managed care plans (HMP, PPO & POS) and government sponsored programs (Medicare, Medicaid) with understanding of compliance and regulations of CMS.

Involved in the full HIPPA compliance lifecycle from GAP analysis, mapping, and implementation and testing for processing of Medicaid Claims Served as the primary liaison between the IT Product Team and the Business area.

Assisted JAD session to identify the business flow and determine whether any current or proposed systems are impacted by EDI X12 transaction.

Conducted comprehensive requirement gathering sessions, one-on-one and group interviews for the development of business, functional and system requirement documents.

Assisted Product Manager with writing detailed user stories and prioritize the product backlog to align with the product vision and priorities and write detailed acceptance criteria for each user story.

·Assisted Product Manager with different requests and the review / processing of draw requests.

·Wrote test case and test plan for manual and automation testing.

·Conducted data driven testing to test the application on different sets of data.

·Automated the new features after its implemented, wrote smoke test and end-to-end test.

·Participates and conducted code reviews.

·Worked bug reports that are complete in content and detailed enough to be actionable, locking down reproduction steps in automated test when possible.

·Prepared the summary report of the tests.

·Designed and developed new reports using Crystal Report in terms of quality, accuracy and completeness.

·Provided insights to the Product Owner for prioritizing work and managing the backlog.

·Developed test plans based on user stories and work with users to schedule and complete testing

·Negotiated minimally viable solutions with the team

·Reviewed product documentation including product requirements, tracking communications and updates to training materials

·Involved in the day-to-day implementation of the AGILE methodology of application development with its various work flows, artifacts and activities

·Coached and mentored cross-functional teams on Agile.

·Actively participated in sprint planning, daily stand-ups, sprint reviews and retrospectives to support delivery of tasks.

·Provided mentorship to junior BAs through Community of Practice and other informal forums.

·Organized and lead user acceptance testing with the appropriate project stakeholders.

Coventry Health Care – Richmond, VA 02/2015 - 05/2017

Data System Analyst

·Connected and coordinated data exchange between multiple hospitals and labs.

·Participated in different component of a client deliverable from identifying needs to producing the final report or data extract.

·Evaluated, obtained approval and funding, implementing, and maintaining software applications running on division.

·Participated in identification, troubleshooting, and resolution of application and/or implementation issues.

·Participated in business development by identifying new opportunities and assisting with proposal development.

·Performed comprehensive assessment of the current state at the client and work different cross-functional team to deliver transformative recommendations to adopt agile practices.

·Collaborated successfully with cross-functional development teams to design and manufacture new products.

·Built proactive data validation automation to catch data integrity issues.

·Primary support contact and expert for the Reporting Workbench, Clarity, Crystal Reports, Business Objects, and other reporting applications.

·Automation test development experience using Selenium

·Drafted technical documentation and client presentations.

Molina Healthcare - Hughes Way Building - Long Beach, CA 04/2014-01/2015

Systems Analyst

·Identified system and application needs.

·Participated in requirements meetings and data mapping sessions to understand business needs.

·Coordinated upgrade schedules with vendors and users across the integrated delivery system

·Assisted Quality assurance team with the creation test plans, test cases and test scripts.

·Coordinated statistical data analysis, design, and information flow.

·Developed database objects, including tables, views and materialized views using SQL.

·Documented business workflows for stakeholder review.

·Coordinated with systems partners to finalize designs and confirm requirements.

·Provided continued maintenance and development of bug fixes and patch sets for existing web applications.

·Developed workflow charts and diagrams to ensure production team compliance with client deadlines.

·Documented business processes and analyzed procedures to see that they would meet changing business needs.

Assessed the impact of current business processes on users and stakeholders.

Contact this candidate