Detail-Oriented Business Analyst with Data & BI Expertise

TARIQ MEHMOOD

*********@*******.*** +1-848-***-**** New Jersey

Summary

Detail-oriented Business Analyst having nine years of Industry Experience. Proficiency in Salesforce, Jira, Tableau, Power BI, Visio and Lucid Charts, MS Excel, Axure, Visio for reporting, dashboard designing and data visualization. Demonstrated success in translating complex data into actionable insights, driving process improvements, and formulating strategic plans for business enhancement. Adept at stakeholder management, requirements elicitation, and fostering cross-functional collaboration to achieve organizational objectives, expert in healthcare, SaaS, or enterprise systems.

Skills

Tools & Technologies

Advanced AI Tools: ChatGPT (GPT-4 / GPT-4o), Anthropic Claude (Sonnet / Opus), GitHub Copilot, Cursor IDE, Microsoft Copilot, Gemini, LLM-based reporting assistants, coding models for SQL/DAX/Python generation

Automation & Data: Power Automate, Zapier, Power BI, DAX, Data modeling, Data Automation, AI-enabled process automation, Tableau, Excel (Power Query / Pivot Tables), SQL

API & Integration: REST APIs, Postman, OAuth 2.0, Webhooks, JSON / XML payloads, Third-party API integration, Firebase Cloud Functions, Google Workspace APIs (Calendar, Drive, Sheets)

Web & Mobile App Design: Responsive web app design, Android & iOS mobile app requirements, UX/UI wireframing (Axure RP, Figma), cross-platform UAT, prototype testing, accessibility considerations

Dashboard Design & Reporting: Power BI dashboard design, Tableau, Salesforce Reports & Dashboards, Excel pivot dashboards, KPI scorecards, executive reporting layouts, real-time data visualization

Experience

1.Horizon Blue Cross Blue Shield of NJ

Business Analyst –II Reporting

Started: 9/15/2024

Project: Data Reporting

Reporting For the Teams: Data Enrollment, Data Maintenance, Ancillary Credentialing and Re-Credentialing, Provider Network, HNJH, Network Outreach and CAA

Developed insightful reports and dashboards using Power BI, Tableau, and Excel, enabling data-driven decision-making.

Led business process analysis, requirements gathering, and documentation to drive efficient reporting solutions.

Built automated reports and Power Automate-driven workflows, streamlining operations and enhancing productivity through end-to-end Data Automation.

Translated business requirements into technical specifications, ensuring seamless report development.

Identified trends, patterns, and insights to support strategic initiatives and process improvements.

Ensured data accuracy and consistency through effective data validation, cleansing, and governance.

Collaborated with cross-functional teams and stakeholders, delivering impactful reporting solutions.

Managed projects using Agile and Scrum methodologies, delivering on time and within scope.

Presented complex data insights to senior management and stakeholders in a clear and concise manner.

Designed advanced DAX measures and Data modeling layers in Power BI to power multi-dimensional reports across enrollment, credentialing, and provider network domains.

Implemented Data Automation workflows using Power Automate to eliminate manual report-refresh cycles, reducing turnaround time and minimizing human error across recurring reporting tasks.

Leveraged AI tools including ChatGPT, Anthropic Claude, and GitHub Copilot for AI-enabled process automation, accelerating SQL/DAX query authoring, documentation drafting, and stakeholder communications across the reporting team.

Demonstrated experience applying AI tools or advanced analytics to automate processes, generate insights, or support decision-making by partnering with reporting leads to surface trends across claims, enrollment lag, and provider data-quality KPIs.

Explored emerging LLM and coding models (OpenAI GPT-4, Anthropic Claude, Cursor IDE) to prototype intelligent reporting assistants and automate repetitive analyst workflows.

Built and maintained internal tooling using modern Automation platforms (Power Automate, Zapier, Firebase Cloud Functions) integrated with advanced AI tools for triage, summarization, and exception alerting across reporting pipelines.

2.Public Consulting Group Austin, Texas

Technical Business Analyst

1/2024 to 09/2024

Project: Ed Plan & Easy IEP

Collaborate with stakeholders to gather and document comprehensive requirements for Ed Plan and Easy IEP projects.

Design user experiences (UX) using Axure RP 10, ensuring intuitive and user-friendly interfaces for special education software.

Deep expertise in UX research methodologies

Resolve User Acceptance Testing (UAT) tickets in JIRA, facilitating smooth transitions from development to production.

Employ Waterfall methodology to manage project timelines, deliverables, and milestones effectively.

Utilize Zendesk for client communications, ensuring timely discussion, feedback, and approval of design specifications.

Conduct thorough testing and perform critical functions on staging and production sites to ensure software quality and reliability.

Generate detailed project reports and updates on Asana, maintaining transparency and accountability.

Customize state-specific and client-specific changes to meet diverse special education needs across the United States.

Facilitate seamless deployment of new features and updates, ensuring minimal disruption to end-users.

Provide ongoing support and training to clients, enhancing their ability to utilize the software effectively for special education requirements.

Designed cross-platform web app and mobile app (Android, iOS) wireframes and UX flows in Axure RP for the Ed Plan/Easy IEP platform, ensuring consistent experiences across desktop and mobile users.

Coordinated API-related work between front-end and backend teams, validating REST endpoints in Postman and documenting payload structures, error codes, and authentication flows for state-specific integrations.

Built dashboard designs for project tracking and UAT progress in JIRA and Asana, surfacing ticket aging, sprint velocity, and state-rollout status to leadership.

Applied AI tools (ChatGPT, GitHub Copilot) for AI-enabled process automation — drafting BRD/FRD content, generating UAT test cases from requirements, and accelerating documentation cycles.

3.United Healthcare New York

Business Systems Analyst

1/2023 - 1/2024

Project: Optum Healthcare (Zip code search of healthcare providers)

Assessed and interpreted customer needs and requirements for United Healthcare's insurance module on website and app and successfully converted manual work to automated processes.

Conducted moderately complex analyses and solved intricate problems with minimal guidance.

SaaS platform where provided users access to connect via Zip code search feature

Performed operations on Tableau and Salesforce for Dashboard development, Collaboration, Data visualization, object creation, task and ticket escalation and Data Analysis.

Played a key role in defining project roles and gathering detailed business, functional, and non-functional requirements for Optum RX.

Stake holder interviews, user interviews, contextual inquiry, survey and questionnaire.

Defined and updated project schedules, tracking and measuring the progress of requirements gathering for Optum project.

Developed business context diagrams, including business data flows and process flows, to analyze and confirm project requirements.

Partnered with stakeholders to assess the operational impact of changes within defined solutions and handling Scope Creep.

Supported ongoing operations, maintenance, and enhancement of existing solutions in collaboration with IT, business owners, and vendors.

Salesforce reporting, cross functional collaboration and data visualization for the Zip code search Optum RX project.

Utilized MS Visio and Lucid Charts for creating flow charts to understand project layout plans.

Employed Jira for user stories and cross-functional collaboration, and Postman for creating and running test cases.

Utilized Confluence for documentation and Power BI for creating charts, graphs, and reports for visual representation.

UAT, use cases, A/B testing, Proto type testing and mapping.

Coordinating suggestions with both business and technical stakeholders and documenting business processes to streamline requirements alignment sessions.

Defined requirements for the web app and mobile app (Android, iOS) versions of Optum's provider zip-code search, validating REST API contracts in Postman and ensuring response payloads matched front-end consumption needs.

Led dashboard designing in Tableau and Salesforce for the Optum RX program — building executive scorecards on provider search volume, geographic coverage, and zip-code performance KPIs to drive product decisions.

4.Payactiv, Inc Silicon Valley, CA

IT Business Analyst (Implementations and Activations)

1/2020 - 12/2022

Served as a connection between IT teams, business demands, and clients in SaaS.

Business Models and Projects:

EWA (Earned Wage Access)

UKG (Ultimate Kronos Group) Census and Timecard Implementation project. (HCM/WFC/Pro/Ready)

Documentation and ticketing:

BRD, FRD, and ERD, User Manuals, Functional and Non-Functional, SRS

Salesforce Ticketing, Reporting, Escalation, and Dashboard Designing.

Jira Ticketing along with user story writing and testing. MS-Excel Reporting.

SaaS protocols: After getting the requirements from third party vendors and clients directly:

Involved in day-to-day SCRUM in an Agile environment providing updates on the testing schedules.

Salesforce reporting, dashboard designing and object creation for better data visualization.

Interact with Business Owners, SMEs, and management teams to identify the scope of the project and to prepare a Business Requirement Document, Use Case, User Story, and Activity Diagrams to further develop technical requirements and/or Functional Specifications.

Collaborated cross-functionally with Sales, Legal, Compliance, and IT departments via Salesforce to Develop and execute strategic plans to streamline onboarding procedures, resulting in a 20% reduction in onboarding time.

Designed end-to-end automated solutions for manual processes in the financial service sector.

Utilized Agile methodologies to enhance project delivery speed and responsiveness to changing business needs.

Assisted with the documentation of system and business requirements, specifications, design, and development of use cases and test-case scenarios and helped in developing test plans for user acceptance testing.

Closely worked with the Third-party vendors (UKG, ADP, Paychex, Paycor, Paylocity, QuickBooks, Rippling’s, Vicennium and several others) for timecard and census solutions.

Involved in translating the initial high-level visions into User Stories, Product Backlogs, and any other supporting artifacts required for planning.

Owned third-party API integrations with payroll/HCM platforms (UKG, ADP, Paychex, Paycor, Paylocity, QuickBooks, Rippling) — defined REST endpoints, payload schemas, error handling, and authentication flows in Postman, ensuring reliable timecard and census data exchange.

Drove dashboard designing in Salesforce for the EWA and UKG implementation programs — onboarding-funnel scorecards, ticket-aging reports, and client-health views consumed by Customer Success and leadership.

5.Payactiv, Inc Silicon Valley, CA

Business Operations and Implementation Analyst

7/2017 - 12/2019

Responsible for: Clients Onboardings process, from product overview to mark LIVE for the EWA project in SaaS platform.

Evaluate, analyze, and communicate systems requirements on a continuing basis, and maintain systems processes, including the delivery of monthly status reports to all appropriate parties.

Partner with stakeholders across business units to develop analyses and documentation in a collaborative way.

Translates conceptual customer requirements into functional requirements in a clear manner that is comprehensible to developers/project team.

Help sales and support teams to align with customer needs and perform user acceptance testing.

Analyze data and metrics, identify problem areas, and provide actionable insight to management.

Provides input to Engineering and vendors on defects and required enhancements.

Getting the requirements from stakeholders and implement them for the client and business side, communicate them to the inter-departments which include, IT, Activation, Implementation, Finance, Customer Success, Customer Support, Engineering, Fraud, Risk, Timekeepers, Escalations, Payactiv Cards, and sales, and following the Agile process.

Salesforce processing (Ticketing, Reporting, Escalation) for different tasks, and diligent record maintenance.

Identifies customer pains and provides long-lasting solutions, for future prevention. Removing

Obstacles, using feedback to improve the structure by conducting meetings with the product,

technical teams, and other stakeholders.

6.Apple Bank New York

Junior Business Analyst

6/2015 - 12/2016

worked with project teams and assisted with business analysts to make sure the products or applications in development meet the needs of the end users.

Smart applications for mobile banking.

Managed projects with Business Analyst and served as the secondary liaison between clients and multiple internal groups to clarify goals and meet standards and deadlines.

Helped Business Analyst and other stakeholders in Identifying and analyzing user requirements, procedures, and processes to develop optimization

strategies.

Collaborated with stakeholders to define features, integrations, and partnerships.

Delivered timely support by tracking issues and communicating resolutions to end users.

Recommended improvements to existing or proposed systems to enhance solution functionality.

Helped BA to Improve process and procedures to achieve key performance metrics.

Surfaced insights and findings to support business and technical decisions.

Collaborated with cross-functional teams under BA supervision, Agile teams gather and analyze business requirements, ensuring alignment with project goals and objectives.

Participated in Agile ceremonies with BA and other teams, such as daily stand-ups, sprint planning, and retrospectives, fostering open communication and iterative development.

Supported web app and mobile app (Android, iOS) design efforts for Apple Bank's mobile banking platform — gathering customer-facing UX feedback, validating screen flows, and assisting with cross-device UAT for account access, transfers, and statement viewing features.

Education

BS – Computer Science

2013 - 2017

Certifications

Business Analysis (Microsoft)

Project Management Foundations (Microsoft)

Business Application Engineer (Cisco)

Engaging Stakeholders for success (Cisco)

Process Mapping & Workflow Diagrams

Knowledge Management & Documentation Standards

Wireframing & UX Documentation

Sprint Planning & Backlog Grooming

KPI Definition & Reporting Strategy

Risk Management & Mitigation Planning

API Requirements & Integration Analysis

Agile Framework

Agile and Waterfall Methodologies

Stakeholder Relations

Business Process Modeling

Scrum Ceremonies and Business Design

Data Validation & Reconciliation

Research and Negotiation

SDLC

CRM Reporting & Pipeline Analysis

BRD and FRD Documentation

User Story Development

Executive Reporting & Documentation

Requirement Analysis

Technical Support (Software/Web/App)

Process Improvement & Optimization

Project Management

Data Reporting

Cross-Functional Collaboration

Data Analysis and Reporting

Analytical Thinking

Contact this candidate