Business Analyst Data Analysis

Seasoned Business Analyst with over * years of extensive experience in the healthcare and automotive industry. Proven expertise in translating complex business requirements into strategic solutions, optimizing processes, and enabling data-driven decision-making. Recognized for a strong track record in stakeholder management, process improvement, and delivering impactful results. Skilled at addressing industry challenges and driving value through efficient, results-oriented strategies.

SUMMARY:

Demonstrated problem-solving, analytical, communication, and interpersonal skills, with the ability to engage effectively with individuals and teams across all organizational levels.

Extensive experience across various System Development Life Cycle (SDLC) methodologies, including Waterfall, Agile Scrum, Waterfall-Scrum Hybrid, and Scaled Agile Framework (SAFe).

Skilled in conducting requirements elicitation using techniques such as JAD sessions, workshops, brainstorming, interviews, benchmarking, prototyping, and document analysis to capture business needs effectively.

Proficient in preparing key documentation, including Business Requirement Documents (BRD), Functional Requirement Specifications (FRS), System Requirement Specifications (SRS), Requirements Traceability Matrix (RTM), Work Breakdown Structure (WBS), and Change Request Documents.

Hands-on experience working with EDI transaction sets as 270/271 and 997 for healthcare eligibility/benefit response and functional acknowledgement.

Expertise in creating architectural and UML diagrams (process flow diagrams, swim lane diagrams, use case diagrams, wireframes, mock-ups, and prototypes) using tools like Lucidchart and MS Visio, facilitating stakeholder understanding of application designs.

Strong capability in managing data artifacts such as Data Dictionary, Data Glossary, and Data Mapping Documents to ensure data integrity and alignment.

Extensive experience in User Acceptance Testing (UAT) and various testing types, including black-box, manual, system, system integration, performance, smoke, scalability, load, stress, regression, automation, GUI, functional, non-functional, and sanity testing. Well-versed in the Software Testing Life Cycle (STLC) and skilled in creating test plans, test cases, and test scenarios.

Proficient in utilizing JIRA for issue tracking, bug tracking, and project management, as well as Confluence for collaboration, knowledge sharing, and artifact management.

In-depth knowledge of Business Intelligence (BI), with hands-on experience in creating reports, interactive dashboards, and analytical tools using Tableau and Power BI, enabling data visualization and informed decision-making.

CERTIFICATIONS:

Certified Business Analyst

Certified ScrumMaster Scrum Alliance

SKILLS & TOOLS:

Software Development Life Cycle

Agile-Scrum, Waterfall, Water-Scrum Fall, SAFe, Kanban, Scrumban

Project Management tools

MS-Project, MS Share Point, JIRA, Confluence, Load Runner, HP Quality Center

Business Skills

Requirements Elicitation, Stakeholder Management, Gap Analysis, Cost-Benefit analysis, Business Process Mapping, Change Management, SWOT Analysis, Conflict Management, Project Scheduling, Leadership, Excellent Presentation and Communication skills

BI and Reporting tools

Power BI, Tableau

Business Modeling tools

MS Visio, Mockups, Lucid Chart, Wireframes.cc

Databases and ETL tools

MS SQL Server, My SQL, Oracle, Informatica Power Center, AWS glue, and AWS Kinesis

Operating Systems

Windows 7,8,10, Windows Vista, XP, Mac OS, Linux

PROFESSIONAL EXPERIENCE:

Client: PNC Bank, Dallas, TX Jan 2023 – Present

Position: Sr. Business Systems Analyst

Project: Treasury Healthcare Claim Processing

Streamline and enhance the efficiency of insurance claim processing by implementing a centralized clearinghouse system. This system ensures seamless communication and standardized data exchange among insurers, healthcare providers, and regulatory bodies.

Responsibilities:

Conducted regular Joint Application Development (JAD) meetings with system architects, developers, database teams, quality testers, and business stakeholders to resolve critical and minute project details proactively.

Collaborated with stakeholders to elicit and document detailed requirements for the clearinghouse system.

Conducted regular feedback sessions to clarify requirements and ensure alignment with business needs.

Transformed requirements into user stories with clear acceptance criteria for Agile sprints.

Created and maintained a Requirements Traceability Matrix using Excel to link high-level and detailed requirements.

Used MS Visio to develop UML diagrams, including Use Case, Activity, Sequence, and Business Process Modeling Notation (BPMN) diagrams, to support detailed requirements documentation.

Actively participated in Agile ceremonies such as Sprint Planning, Daily Stand-ups, Sprint Demos, and Sprint Retrospectives.

Collaborated with the team to set Sprint goals and select user stories for development.

Identified and assessed project risks, implementing mitigation strategies to address potential issues impacting timelines or deliverables.

Developed technical specifications for EDI transactions such as 270/271 to meet business and regulatory requirements.

Supported the Project Manager in managing Change Requests, conducting Impact Analysis as needed.

Facilitated User Acceptance Testing (UAT) sessions, ensuring smooth communication between stakeholders and development teams to resolve issues efficiently and achieve successful delivery.

Collaborated with the project team to interpret state Medicaid and Medicare policies, supporting algorithm research and healthcare analytics development.

Utilized SharePoint to store and organize project artifacts, including requirement documents, business process documentation, test plans, test cases, user manuals, process flow diagrams, meeting notes, and API mappings.

Truck Tracker, Tokyo, Japan Nov 2015 – Aug 2021

Sr. Business System Analyst

Responsible for analyzing diverse datasets to derive actionable insights that supported data-driven decision-making. Played a key role in translating business requirements into detailed technical specifications and collaborated closely with IT teams to ensure alignment between business needs and technical solutions. Specializing in system integration and quality assurance, facilitated smooth operations by supporting end-users and ensuring the seamless functionality of systems.

Responsibilities:

Analyzed large datasets related to sales, inventory, customer feedback, and market trends to extract actionable insights and developed reports, dashboards to facilitate data-driven decision-making.

Translated business requirements into detailed functional specifications and system design documents and worked closely with IT development teams to ensure that the proposed solutions align with business objectives and technical feasibility.

Provided actionable insights to support decision-making processes and strategic planning initiatives within the company.

Performed complex SQL queries for retrieving data from the database, generating ad-hoc reports, and conducting data validation testing.

Created Monthly, Quarterly and yearly Financial Business Intelligence reports to support close financial books.

Specialized in integrating various IT systems and platforms used within the company, such as inventory management systems, customer relationship management (CRM) software, and sales tracking tools.

Developed test plans, test cases, and test scenarios to validate the functionality, performance, and usability of IT solutions.

Provided ongoing support and assistance to users, addressing inquiries, troubleshooting issues, and facilitating knowledge transfer.

Collaborated with quality assurance teams to define and implement quality standards and processes for automotive products. Monitor and analyze quality metrics to ensure products meet or exceed customer expectations.

Demonstrated adeptness in utilizing Pivot Table features for data filtration and sorting, facilitating a focused analysis and identification of meaningful patterns within the dataset.

Moderate expertise in SQL, including proficiency in SQL queries involving aggregate functions, temporary tables, window functions, subqueries, and joins.

Proficient in advanced Excel functions such as VLOOKUP, SUMIFS, IF statements, and skilled in data validation techniques.

EDUCATION:

Indiana University Southeast (Master’s in Business Administration, MBA), New Albany, IN

Contact this candidate