Mohammed Muzafar Ullah Khan
Business Data Analyst
Mail: ****************@*****.***
Phone: +1-281-***-****
Location: Chicago, IL 60659
SUMMARY
Around 3 years of industrial experience of working as a data analyst including big data analysis, data monitoring, statistical inference, data visualization, and ETL Data pipelines.
Experience of building Tableau and Power BI dashboards for reporting, data visualization, and facilitating business decisions for stakeholders.
Knowledge of Data modeling, enterprise data management, data presentation, visualization, optimization, predictive analysis, business research and quantitative analysis.
Generated Use Cases, Use Case Diagrams, Sequence Diagrams, Activity Diagrams, and Class Diagrams using MS Visio and MS Word, improving documentation clarity by 40% and streamlining development workflows. SKILLS
Methodologies: Agile/Scrum, Waterfall
Language: SQL, Python, R, Spark
Project Management Tools: MS Project, MS Excel, MS SharePoint
Analysis Skills: SWOT analysis Cost/benefit analysis, GAP analysis,
Tracking/Other Skills: Jira, Microsoft Visio, JAD, RTM, UAT EDUCATION
Cloud Technology: AWS, Databricks
Documentation: FRD, BRD, SRS
ERP Planning: MS Dynamics Nav, QuickBooks, NetSuite, and Xero, JD Edwards
Analysis Tools: SOLVER, SAS, Google Analytics, MongoDB Business intelligence tools: Power BI, Tableau
Operating System: Windows, Linux
Masters in Engineering Management, Trine University, Detroit, MI, USA August 2021 – May 2023 Bachelors in Mechanical Engineering, JNTU, Hyderabad, Telangana, INDIA June 2016 – December 2020 EXPERIENCE
Business Data Analyst, United Healthcare Group, USA May 2024 - Present
Collaborate with cross-functional teams to gather and analyze business requirements, translating requirements into functional specifications for software development projects.
Collaborated with cross-functional teams in a Scrum environment to define and prioritize business requirements, ensuring alignment with project goals and stakeholder needs.
Applied project management tools such as JIRA, Trello, and Microsoft Project to track project progress, manage tasks, and coordinate with team members, resulting in a 30% increase in project completion rates on schedule.
Conduct user acceptance testing (UAT) to validate the effectiveness and accuracy of implemented solutions.
Employed SQL and data visualization tools to analyze large datasets, enabling data-driven decision-making and providing actionable insights to senior management.
Created and maintained interactive dashboards and reports using Power BI, providing real-time performance metrics to support executive-level decision-making.
Business Data Analyst, Freddie Mac, USA May 2023 – April 2024
Led information-gathering meetings and JAD sessions to gather business requirements, deliver business requirements document and preliminary logical data model.
Influenced the creation and refinement of Power BI dashboards, leading to a localized 14% increase in data accessibility within the team, which facilitated more efficient strategic planning and resource allocation efforts.
Co-ordinated in refining the existing process by integrating Python scripts into Excel-based reporting tasks, which contributed to reducing manual efforts and ensuring timely and accurate generation of financial and operational.
Facilitated Scrum ceremonies, including daily stand-ups, sprint planning, retrospectives, and backlog grooming sessions, improving team communication and project transparency by 30%.
Business Data Analyst, Experion Technologies, INDIA July 2020 – August 2021
Incorporated Python, and SQL to extract, transform, and analyze data from sources, providing insights to support decision-making.
Managed project schedules and resources using MS Project and Primavera P, achieving a 15% improvement in project timeline adherence and a 25% increase in resource utilization efficiency.
Optimized data processing workflows by leveraging AWS services, including S3, Glue, and Redshift, reducing data retrieval time by 30% and improving query performance by 25% for business intelligence reporting.
Created graphs and charts such as Pie charts and bar charts using MS Excel, leading to a 20% improvement in data visualization effectiveness.
Conducted thorough analysis utilizing SQL queries, GAP analysis, and SWOT analysis to identify areas for improvement.
Implemented business intelligence tools such as Tableau to analyze data, resulting in a 20% increase in decision-making efficiency.
Leveraged VLOOKUPs and HLOOKUPs to rigorously validate data integrity, cross-referencing data from datasets resulting in a 25% enhancement in data accuracy
Proficient in using Microsoft Visio to create comprehensive and detailed business process workflows, flowcharts, and diagrams that visually represent complex business processes and system