Summary
Overview
Work History
Education
Skills
Technical Skills
Timeline
Generic

ASIFUZZAMAN RATUL

Queens,NY

Summary

Strategic-minded Senior Business Analyst with over 5 years of proven expertise in leading cross-functional teams to deliver innovative solutions that drive business growth and efficiency. Proficient in both Waterfall and Agile methodologies, adept at conducting comprehensive requirements analysis, gap assessments, and facilitating stakeholder collaboration to translate business needs into actionable plans. Skilled in data analysis and modeling using SQL, with a track record of leveraging Tableau and DOMO to produce insightful visualizations. Experienced in managing full project lifecycles, from conception to implementation, while ensuring adherence to timelines and budgetary constraints. Strong communicator and collaborator, adept at bridging the gap between technical and non-technical stakeholders to achieve project objectives. Seeking to leverage expertise in business analysis and technology to drive continuous improvement and deliver tangible value to the organization.

Overview

6
6
years of professional experience

Work History

Business Analyst

HealthPlanOne
Trumbull, CT
01.2023 - Current
  • Managed software development life cycle (SDLC) processes, including requirements analysis, design, development, testing, deployment, and maintenance, adhering to both Waterfall and Agile methodologies.
  • Utilized SQL to extract, manipulate, and analyze data while designing efficient database structures for business solutions using data modeling techniques.
  • Developed interactive dashboards and reports using Tableau, DOMO, and other reporting tools to visualize key performance indicators (KPIs) and provide actionable insights to stakeholders.
  • Utilized Jira to streamline project management by tracking tasks, user stories, and sprints for timely achievement of project milestones.
  • Developed functional specifications, business process flows, system diagrams, and user manuals to facilitate efficient collaboration.
  • Analyzed large datasets using advanced Excel functionalities such as pivot tables and VLOOKUP to identify trends, patterns, and opportunities for process improvement.
  • Interfaced with CRM systems like Salesforce to gather, analyze, and interpret customer data, providing insights for sales and marketing strategies.
  • Managed SharePoint sites for document storage, collaboration, and version control, ensuring data integrity and accessibility for project teams.
  • Created use case diagrams to visually represent system interactions and functionalities, facilitating requirements elicitation and validation with stakeholders.
  • Monitored project progress using metrics such as timeline, budget, resources utilization.
  • Conducted interviews with subject matter experts to gather information on existing systems and procedures.
  • Designed test plans, scenarios, scripts, cases, and results matrices to validate system functionality.
  • Developed reports using SQL queries to track progress against key performance indicators.

Associate Business Analyst

Flowers.com
New York, NY
01.2021 - 01.2023
  • Gathered, documented, and analyzed specific requirements to assess their impact on platforms. Converted business requirements into functional requirements, ensuring clear communication and handover to engineering and testing teams for delivery.
  • Reviewed and confirmed test cases for comprehensive coverage, ensuring quality outcomes.
  • Created detailed process flows and user stories to document system requirements and design solutions.
  • Built and maintained relationships with key stakeholders across the business and technology sectors to foster collaboration and alignment.
  • Developed and executed SQL queries to generate operational reports using Tableau, enhancing data-driven decision-making processes.
  • Provided technical assistance with software applications and databases used by end-users.
  • Facilitated sessions with users, Project Managers, and Subject Matter Experts to gather business requirements, significantly reducing project turnaround time.
  • Identified areas of risk and cross-functional dependencies from conception through delivery, mitigating potential issues early in the project lifecycle.
  • Coordinated with IT teams to ensure smooth deployment of new technologies into production environments.

Jr. Business Intelligence Analyst

L'Oreal
New York, NY
10.2018 - 01.2021
  • Managed the SDLC for various projects, from design and analysis to testing and implementation, ensuring timely delivery and adherence to requirements
  • Implemented CRM strategies that improved customer relationship management, leading to a 20% increase in customer retention
  • Developed ad-hoc queries to support brand and technical teams, ensuring data accuracy and fulfilling specific analysis requests
  • Collaborated with technical teams and vendors to maintain data pipelines and integration, ensuring accurate and up-to-date information
  • Analyzed existing reports post-ETL process using SQL, ensuring data consistency and reliability
  • Created daily, monthly, and quarterly KPI reports to measure sales and marketing progress, leading to actionable insights and strategic adjustments
  • Conducted root cause analysis to identify and resolve data and process issues.
  • Conducted data analysis, helped created reports and dashboards using Tableau and Power BI.
  • Developed complex SQL queries to extract and analyze data from multiple sources.
  • Managed and organized documentation for Business Intelligence systems modifications.
  • Monitored system performance, identifying areas for improvement.

Education

Bachelors in Science Information System -

Mymensingh Polytechnic Institute
01-2018

Skills

  • Forecasting and planning
  • Operations Analysis
  • Pivot tables
  • Process Development
  • User Acceptance Testing
  • Requirements Gathering
  • Agile Methodology
  • Software Development Lifecycle
  • Gap analysis
  • CRM Systems
  • KPI Tracking
  • Data Visualization

Technical Skills

  • SQL / Tableau / DOMO /SharePoint / Jira / Trello
  • Google Analytics / Salesforce Analytics
  • Visio and Rational Rose Modeler / Microsoft Office

Timeline

Business Analyst

HealthPlanOne
01.2023 - Current

Associate Business Analyst

Flowers.com
01.2021 - 01.2023

Jr. Business Intelligence Analyst

L'Oreal
10.2018 - 01.2021

Bachelors in Science Information System -

Mymensingh Polytechnic Institute
ASIFUZZAMAN RATUL