Fnu M.

About Fnu M.

Mustafa is a proficient Business Data Analyst with more than 6+ years of extensive experience in project management, system configuration, data analysis, and client support. With a strong educational background and significant professional experience, Mustafa excels in driving project success and delivering high-quality outcomes for organizations. He holds expertise in Agile methodologies, SQL programming, and generating data-driven insights. Mustafa is skilled in leveraging tools such as SQL, PowerBI, and Jira to optimize project workflows, generate actionable insights and statistical insights, and enhance user experiences. He has a demonstrated record of delivering complex projects within deadlines and budgetary constraints, emphasizing enhanced operational efficiency and data security.

Experience

1. Data Analyst

   Health Alliance Plan

   Jan 2022 — Present · Troy, MI, US

   Performed in-depth data analysis using complex SQL queries and data visualization tools like Power BI to identify trends, generate actionable insights, and support decision-making processes.• Responsible for providing Source to Target Mapping based on the data requirements by Client.• Identified and documented data sources and transformation rules necessary for populating and maintaining the data warehouse content.• Performed data mining and validation to ensure data accuracy between the data warehouse and source systems.• Handled Claims Processing and Claims Scrubbing for HMO, PPO, Medicaid, and Medicare programs.• Developed Excel reporting tools utilizing VLookups and Pivot Tables, and created macros to automate and mass-produce reports efficiently.• Prepared test datasets and conducted data testing using PL/SQL scripts. Additionally, utilized MS Excel for data mining, data cleansing, data mapping, maintaining a data dictionary, and performing in-depth data analysis.• Demonstrated understanding of Star Schema, Snowflake, Data Warehouse methodologies.• Monitored and analyzed key performance indicators (KPIs) for AWS Cloud Infrastructure, delivering actionable insights to drive continuous improvement efforts.• Expertise with Oracle database including SQL/ PL SQL, indexing, partitioning, views, materialized views, performance tuning and optimization.• Analyzed and evaluated technical, structural, and data content changes for EDI transaction sets 834 (Enrollment and Maintenance), 837 (Professional, Institutional, and Dental Claims), and 835 (Claim Payment/Advice).• Utilized Tableau to extract data from external sources, transform it into the required format, and prepare it for use in dashboards.• Collected and documented business requirements for integrating third-party applications with AWS Cloud Infrastructure, ensuring seamless data flow• Provided support and escalation response for Single Sign-On (SSO), performing root cause analysis and resolution.

Education

• Northern Illinois University

  Master of Science - MS

  2019 — 2021

• Jawaharlal Nehru Technological University

  Bachelor of Engineering (B.E.)

  2012 — 2016