Summary
Overview
Work History
Education
Skills
Timeline
Generic

Ruksana Begum

South Jordan,UT

Summary

Prudent Business Intelligence Analyst with 8 years of experience in gathering, analyzing, and interpreting business data from various sources. Adept at translating complex data into clear and concise narratives, highlighting key findings and actionable recommendations. Skilled in preparing and delivering regular reports to stakeholders to inform strategic decision-making. Proficient in creating compelling visualizations, dashboards, and presentations for senior leadership and board-level consumption. Experienced in collaborating with cross-functional teams to promote strategic data analysis and insights. Continuously identifies strategic data gaps and responds to ad-hoc analysis requests. Committed to staying updated with the latest tools, techniques, and industry trends to drive profit growth and support optimal business strategies.

Overview

11
11
years of professional experience

Work History

Senior Business Intelligence Analyst

BenLabs
05.2023 - Current
  • Gathered, analyzed, and interpreted business data from various sources across all business units. Translated data into clear and concise narratives, highlighting key findings and recommendations to inform strategic decision-making. Utilized advanced SQL, Python, and R for data extraction and analysis.
  • Architected and managed scalable data warehouses and big data solutions using Snowflake and Data bricks. Performed distributed data processing with Apache Spark to handle large datasets efficiently.
  • Prepared and delivered regular reports to stakeholders, emphasizing key findings and data-driven recommendations. Guided the leadership team’s strategic initiatives using advanced statistical analysis and AB testing.
  • Created clear and compelling visualizations, developing insightful dashboards, presentations, and reports tailored for senior leadership and board-level consumption using advanced tools such as Domo.
  • Worked closely with stakeholders and data teams across different business units, promoting a strategic approach to data analysis and insights. Improved collaboration between IT and business stakeholders by serving as a liaison, ensuring seamless communication and alignment of objectives.
  • Identified strategic data gaps and needs for senior leadership, ensuring comprehensive and reliable data for decision-making.
  • Responded to ad-hoc data requests and conducted specialized analyses to address specific business questions or concerns, ensuring timely resolution of issues.
  • Performed data cleaning and processing using Python and R.
  • Reduced manual data entry errors by automating routine tasks using SQL scripts and ETL tools. Designed customized data collection models for specific visualization tasks.
  • Evaluated new BI tools and technologies to maintain a competitive edge in the industry, ensuring continuous innovation.
  • Developed intelligence-sharing dashboards using Domo, providing company-wide access to collected data.
  • Utilized cloud computing platforms to deploy and manage data infrastructure. Implemented serverless data processing workflows using AWS Lambda and automated data pipeline orchestration
  • Mentored junior data scientists and analysts, fostering a culture of continuous learning and professional development. Conducted training sessions on advanced analytical techniques and tools.

Senior Business Intelligence Analyst

Health Catalyst
08.2021 - 04.2023
  • Handled massive quantities of business intelligence data, personally managing large healthcare data sets from wide-ranging sources, including EHRs.
  • Interacted with end users and customers to obtain requirements and formulate technical specifications for data discovery, metric generation, and visualization using Power BI, QlikView, and Tableau.
  • Utilized SQL for data collection and organization across related tables to complete reports and ad hoc analyses, understanding physician treatment choices, and characterizing successes and failures of patient treatment regimens and pathways.
  • Leveraged Health Catalyst software and technologies to perform varied analyses supporting client outcomes improvement initiatives across clinical, operational, and financial domains.
  • Implemented machine learning models in Python, using libraries such as Pandas, NumPy, scikit-learn, and Matplotlib, for predicting patient outcomes, reducing readmission rates by 12%.
  • Collaborated with medical professionals to integrate predictive analytics into patient care protocols, using R programming for advanced statistical analyses like correlation and regression.
  • Created visualizations using Python's Matplotlib and Seaborn libraries to illustrate data trends and findings effectively.
  • Developed and maintained dashboards for monitoring key performance indicators in hospital patient care using tools such as Tableau and Power BI.
  • Developed a predictive model for disease outcomes using historical patient data, achieving 90% accuracy, by implementing machine learning algorithms with Python
  • Ensured compliance with data governance policies and procedures, maintaining data integrity, security for critical data (e.g., HIPAA, CCPA), and accessibility throughout the data lifecycle.
  • Established strong working relationships with clients through exceptional communication skills, fostering trust and collaboration.
  • Achieved successful project outcomes by maintaining accurate documentation and meeting strict deadlines.

Business Intelligence Analyst

Traeger Grills
05.2019 - 08.2021
  • Regularly tracked sales data, identified highs and lows in trends, and reported findings to respective teams to mitigate low sales periods.
  • Established and maintained SKU master data in global ERP systems, ensuring standardization across the organization and supporting consistent data governance practices.
  • Increased sales efficiency by 92% year-over-year by streamlining data analysis and reporting processes.
  • Analyzed ecommerce and retail sales data, assisting in data-driven decision-making and strategy formulation for the entire organization.
  • Gathered data from various sources such as webpages, CSV files, Excel, and APIs. Utilized tools like Pandas and ETL processes to collect, clean, and structure data, building robust data pipelines.
  • Ensured collaboration with stakeholders such as S&OP, manufacturing, R&D, marketing, etc., to align master data processes.
  • Designed and built databases from the ground up for various products in PostgreSQL and MS SQL Server. Identified dimensions and facts, created ERDs, and constructed tables in DBT, ensuring robust data pipeline maintenance and optimal database performance.
  • Supported supply chain finance team, production team, marketing team, and social media content team in making data-driven decisions for their respective KPIs. Created multiple visualizations to aid their client meetings with thorough data analysis.
  • Built reports on Excel, Domo and Power BI to present weekly sales reports to the supply chain director, CTO, and CEO of the company every Monday.
  • Improved forecasting accuracy by analyzing historical sales data and identifying patterns for future projections. Utilized advanced statistical techniques and data visualization tools to meticulously analyze inventory and sales data, providing actionable insights for demand planning and market strategy development.

Business Intelligence Analyst

Caterpillar
06.2017 - 03.2019
  • Collected and integrated data from various logistics and transportation sources, including route planning systems, GPS tracking (using tools like Fleet Complete), and inventory databases (using MS SQL and Excel)
  • Utilized SAS programming for auditing data, developing data, and performing data validation QA to improve efficiency.
  • Modified and optimized existing SAS programs to include new contracts, significantly improving accuracy from 89% to 96%.
  • Performed data cleaning and validation on invoice records using tools like Python (Pandas), Excel, and SQL to ensure accuracy, consistency, and compliance with organizational standards.
  • Designed and maintained interactive dashboards to visualize invoice metrics, such as payment cycles, outstanding balances, and vendor performance, using Tableau.
  • Collaborated with finance and accounting teams to address invoice-related issues, ensuring timely resolution and accurate financial reporting.

Jr Business Intelligence Analyst

Google India
08.2013 - 12.2015
  • Gathered and integrated game data from various sources, including server logs, player activity databases, and in-game event tracking systems.
  • Conducted in-depth analysis of player behavior and engagement metrics using SQL and Python to identify trends, patterns, and insights.
  • Developed key performance indicators (KPIs) to measure game performance, player retention, and monetization, ensuring alignment with project goals.
  • Designed and implemented A/B tests to evaluate the impact of new game features, balance changes, and marketing campaigns, using statistical analysis to derive actionable insights.
  • Utilized machine learning techniques to build predictive models for player churn, lifetime value, and in-game spending, improving targeting strategies for player retention and monetization efforts.
  • Leveraged advanced analytical tools and technologies, including SQL, Python, R, Tableau, and BigQuery, to perform data analysis and visualization tasks effectively.
  • Generated comprehensive reports and presentations for stakeholders, summarizing key findings, insights, and recommendations to drive game development and strategy.

Education

Master of Science - Management Information Systems

University of Illinois At Springfield
Springfield, IL
05.2017

Skills

  • SQL Expertise
  • Python Coding
  • R Programming
  • Advanced Excel
  • Tableau
  • Power BI
  • Domo
  • QlikView
  • Gap analysis
  • Machine Learning
  • Ad-hoc Analysis
  • Statistical Analysis
  • Data Modelling

Timeline

Senior Business Intelligence Analyst

BenLabs
05.2023 - Current

Senior Business Intelligence Analyst

Health Catalyst
08.2021 - 04.2023

Business Intelligence Analyst

Traeger Grills
05.2019 - 08.2021

Business Intelligence Analyst

Caterpillar
06.2017 - 03.2019

Jr Business Intelligence Analyst

Google India
08.2013 - 12.2015

Master of Science - Management Information Systems

University of Illinois At Springfield
Ruksana Begum