Data Analyst Business Systems

Amandeep Kaur Cheema

Business and Data Analyst *********@*****.*** Ph: 469-***-****

Professional Summary:

Around 9 Years of Business Analysis Experience, demonstrated expertise in gathering business requirements, process improvements, and system implementation across industries such as payment gateways, healthcare, and insurance.

Skilled in eliciting and documenting clear business requirements to drive the successful implementation of custom software solutions and business systems.

Experience in analyzing and optimizing business processes to enhance productivity, reduce manual efforts, and streamline workflows, using technology solutions and automation.

Proven ability to collaborate with key stakeholders across departments such as Sales, IT, Finance, Operations, HR, and Compliance, ensuring alignment on project goals and deliverables.

In-depth knowledge of system integration, ensuring seamless connectivity between CRM, ERP, and third-party platforms to enable efficient data flow and operations.

Strong understanding of industry regulations (e.g., HIPAA for healthcare, state insurance regulations), ensuring all processes and systems comply with legal standards.

Good Working Knowledge of HIPAA Regulations and Claims Processing

Expertise in developing custom reports and dashboards using BI tools and SQL, enabling leadership teams to track key performance indicators (KPIs) and make informed decisions.

Proficient in using Agile methodologies (Scrum, Kanban) to manage sprints, backlogs, and deliverables, ensuring projects are completed on time and meet quality standards.

Led UAT sessions, working closely with stakeholders to ensure system functionalities met business requirements and user expectations before deployment.

Acted as the primary liaison between business and technical teams, ensuring stakeholder expectations were met through effective communication and consistent progress updates.

Created detailed process flow diagrams, SOPs, and functional documentation to enhance understanding and training of internal teams, streamlining new process implementations.

Provided tailored solutions to meet client needs, ensuring user-friendly interfaces, robust data reporting tools, and streamlined processes that improved customer satisfaction.

Led the customization of payment systems and insurance platforms, tailoring features to meet client-specific business requirements and regulatory standards.

Offered continuous support and troubleshooting during the post-deployment phase, ensuring smooth system adoption, issue resolution, and identification of areas for improvement.

Developed comprehensive training materials and facilitated knowledge transfer sessions for end-users, ensuring efficient onboarding and system adoption.

Technical Skills

Programming Languages

C, C++, HTML, XML, SQL.

Data Base

MS Access, Oracle (SQL Series), DB2

Methodologies

Agile, Rational Unified Process RUP, Waterfall, JAD, UML

Operating Systems

MS-DOS, Windows95/98/NT/2000/XP, Apple McIntosh, Linux

Software

MS Office Suite(Word, Excel, Access, PowerPoint & Outlook), MS Visio, Rational Rose, Rational Requisite Pro, Adobe Acrobat, MS Office FrontPage, Lotus Notes

Mainframe

COBOL, DB2, JCL, CI CS, MVS

Processes/Technologies

Rational Unified Process (RUP), Waterfall, UML & Microsoft Office SharePoint 2007

Automation Tools

Requisite Pro, Win runner, QTP, Test Director, Quality Center

Professional Experience

Pay funnels – Houston, TX May 2022 – Present

Business/Data Analyst

Responsibilities:

Collaborated with client-side stakeholders to gather and validate business requirements for payment gateway integration.

Facilitated workshops with client teams from Sales, Operations, and Finance to align solution design with end-user workflows.

Led the customization of dashboards and reporting tools for client-specific KPIs, using Query Studio and custom SQL queries.

Created functional and technical documentation for client-specific plug-in development within the payment application.

Performed GAP analysis between existing client processes and Pay Funnels platform capabilities to ensure successful onboarding.

Efficiently handled claims processing as well as enrollment, medical-management and workflow processes involved during and for the project given.

Conducted User Acceptance Testing (UAT) sessions with client stakeholders to validate end-to-end payment processing workflows.

Designed and implemented secure access roles and business units to ensure data privacy and compliance with client policies.

Managed sprint planning and tracking using Agile methodologies to ensure timely delivery of client deliverables.

Configured workflows and integrations to support client needs for automated reconciliation and reporting.

Performed production shakeout validations for client environments to ensure application stability during go-live.

Analyzed client data pipelines using Informatica PowerCenter to enable accurate ETL for financial data processing.

Developed and executed test cases for client-specific scenarios in payment failure handling and refund workflows.

Provided training to client end-users on data reporting tools and the Pay Funnels interface.

Created project plans tailored to each client, including timelines, milestones, and resource estimations.

Worked with cross-functional client teams to resolve escalated issues during post-deployment hypercare period.

Alethes, Austin, TX Sep 2020 – Apr 2022

Business/Data Analyst

Responsibilities:

Gathered and analyzed business requirements from Alethes’ stakeholders to define clear project scope and deliverables.

Facilitated workshops and discovery sessions to identify gaps in existing business processes and propose optimized solutions.

Prepared detailed Business Requirement Documents (BRDs) and Functional Specification Documents (FSDs) for client approval.

Collaborated with Alethes’ technical teams to design scalable workflows and system enhancements based on stakeholder feedback.

Worked with cross-functional teams to map current-state vs. future-state business processes for key operational functions.

Led the creation of user stories, epics, and acceptance criteria in alignment with Agile project delivery for Alethes’ internal tools.

Coordinated and executed User Acceptance Testing (UAT) with Alethes’ business units, validating solutions against functional needs.

Monitored sprint progress through burndown charts and Jira dashboards to ensure deliverables were met within the client timeline.

Acted as the liaison between business and IT teams, ensuring seamless communication during solution design and implementation.

Provided actionable insights through data analysis, enabling Alethes to improve their decision-making and strategic planning.

Created reports and dashboards to support KPIs tracking and data visualization for Alethes’ leadership and operations teams.

Developed training materials and conducted knowledge transfer sessions for end-users and system admins post-deployment.

Supported go-live and post-implementation phases with production validation, issue tracking, and resolution planning.

Ensured compliance with security standards by defining access controls, business units, and user roles based on Alethes' requirements.

Managed stakeholder expectations by regularly communicating project updates, risks, and mitigation strategies.

Citizens Memorial – Bolivar, MO Jan 2018 – Aug 2020

Business/Data Analyst

Responsibilities:

Gathered and documented business requirements from physicians, nurses, and administrative staff for improvements to EMR (Electronic Medical Record) workflows.

Collaborated with clinical stakeholders to identify gaps in patient care coordination and proposed system-level enhancements.

Supported the implementation of MEDITECH EMR modules, aligning system capabilities with clinical workflows across inpatient and outpatient settings.

Led data validation efforts and user acceptance testing (UAT) to ensure successful EMR system upgrades and reduced post-go-live issues.

Involved in Service Oriented Architecture (SOA) of the claims processing system.

Developed business process models to optimize patient registration, discharge, and billing procedures, reducing administrative delays.

Coordinated with IT and compliance teams to ensure all workflows and data processes adhered to HIPAA and other healthcare regulations.

Prepared SOPs and user guides to support training and onboarding of medical staff on newly implemented healthcare technologies.

Monitored and reported key performance indicators (KPIs) tied to patient care delivery, scheduling efficiency, and turnaround times.

Participated in cross-functional teams involving pharmacy, radiology, and lab departments to streamline diagnostic order entry and reporting.

Designed and delivered reporting dashboards for clinical leaders using data from EMR systems, focusing on readmission rates and patient outcomes.

Supported the integration of medical devices and third-party systems (e.g., billing or imaging platforms) with core hospital systems.

Led post-implementation reviews and conducted root-cause analysis of issues arising during system deployment.

Involved in the full HIPAA compliance lifecycle from gap analysis, mapping, and implementation and testing for processing of Medicaid Claims.

Created workflows for community health outreach programs, enabling better coordination of screenings and follow-ups across rural clinics.

Facilitated regular stakeholder meetings to review project progress, risk assessments, and roadmap adjustments.

Worked with data analysts to develop custom reports for quality compliance reporting, including CMS and Joint Commission standards.

CFM Insurance – Concordia, MO May 2016 – Dec 2017

Business/Data Analyst

Responsibilities:

Collaborated with underwriting and claims departments to gather and define business requirements for enhancements to the policy administration system.

Conducted gap analysis between legacy systems and proposed insurance platform upgrades to streamline claims processing and policy issuance.

Developed functional specifications for automation of quote generation, policy renewal, and endorsements workflows.

Supported implementation of a customer self-service portal, enabling policyholders to access documents, make payments, and file claims online.

Facilitated stakeholder workshops to define business rules for new insurance products and rating algorithms.

Worked with QA and development teams to design and execute test cases for end-to-end policy lifecycle scenarios (bind, issue, endorse, cancel, reinstate).

Created process flow diagrams to visualize claim intake, adjudication, and settlement workflows for internal training and documentation.

Performed data mapping for integration between CRM, billing systems, and third-party data providers (ISO, DMV, etc.).

Led UAT sessions with underwriting teams to ensure system updates aligned with regulatory requirements and business needs.

Managed Agile sprint backlogs, writing user stories and acceptance criteria for insurance-specific functionalities.

Developed reports and dashboards to track policy volumes, claims ratios, and agent performance metrics using internal BI tools.

Supported compliance audits by ensuring documentation and workflows adhered to Missouri state insurance regulations.

Liaised with external vendors to coordinate delivery of third-party data feeds (loss history, property characteristics, etc.) used in underwriting models.

Created training materials and conducted knowledge transfer sessions for internal users and support staff post-implementation.

Provided ongoing production support during system transition, addressing user queries, resolving bugs, and identifying areas for continuous improvement.

Education: Bachelor’s in business Administration

Contact this candidate