BI Analyst Nottingham | nidhi.r.saini@gmail.com | +44 7776258324 | LinkedIn | GitHub Professional Summary Adaptable data professional with 4 years of experience in data analysis, business intelligence, and data visualization using SQL, Python, and Tableau to deliver actionable insights. Skilled in building models, developing reporting pipelines, and supporting business strategy through data-driven insights. Recently completed a Master's in Data Science, focusing on machine learning and big data technologies. Confident in communicating findings to diverse stakeholders and solving complex problems independently. Work Experience Passport 365, United kingdom , Product & Data Analyst Intern (July 2024-September 2024) • Collaborated with senior management to design databases for two projects, achieving a 30% reduction in data loading time and a 50% decrease in data duplication by implementing a SQL Server schema across 27 tables. • Transferred data using API and Excel, ensuring data integrity and automating workflows using dbt, Python, Azure Data Factory, and Azure Automation to load data into SQL Server. • Improved data loading efficiency by 40% and reduced manual intervention by automating data pipelines, delivering business insights and sustainability solutions for long-term process efficiency. Rudder Analytics, India , Analyst (January 2023 - August 2023) • Developed retail performance dashboards using SQL and Tableau, collaborating with 2 data analysts and stakeholders to deliver insights on sales trends, inventory management, and customer behavior. • Deployed and monitored dashboards on Tableau Cloud, ensuring optimal performance and data integrity for retail operations, while conducting regular investigations into customer behavior and operational bottlenecks. • Worked with a team of 6 to optimize Google BigQuery datasets with Power Query and DAX, creating 7+ sales and inventory reports in Power BI, helping improve product availability and reduce stockouts. • Spearheaded the migration of 30%+ dashboards from Google Data Studio (Looker) to Power BI, improving visualization clarity and reducing reporting time by 25%. • Led hiring, training, and assessment for 30+ team members, revamping Tableau courses to enhance team skills and demonstrating leadership in retail analytics and use case development. Capgemini, India, Senior Analyst (October 2020 - January 2023) • Pushed 20+ dashboards to Tableau Server as an administrator, collaborating with 12 developers and QA testers to ensure data integrity and visualization accuracy for retail and power systems data. • Improved 250+ dashboards by creating a quality review document, contributing to 8% of new tasks in a team of 25+ developers, with a focus on data security and compliance. • Led N-1 architecture development with 2 teams, collaborating with senior management and clients to turn data insights into actionable strategies, demonstrating strong project management skills and problem-solving in complex retail scenarios. • Partnered with 40 analysts to utilize Microsoft Excel, SQL Developer, Informatica (ETL), and Tableau for data analysis projects, enhancing scalability through AWS. • Designed efficient data pipelines and infrastructure, demonstrating strong analytical skills in managing large datasets and improving operational efficiency in an Agile environment. Projects • Chronic Kidney Disease Prediction: Used advanced analytical thinking and statistical methods to develop machine learning models, improving the accuracy of early diagnoses. Conducted research and developed prototypes to refine predictive algorithms. • SST Anomaly Forecasting: Solved complex forecasting problems using time series analysis and innovative approaches, contributing to the business intelligence strategy by enhancing the accuracy of key performance indicators and driving sustainability efforts. • Customer Behavior Analysis: Conducted deep investigations and created prototypes to identify customer behavior patterns, using data to inform decisions about product placement and store layouts. Education University of Nottingham, UK MSc in Data Science Modules include Machine Learning, Statistical Analysis, Programming Languages, Big Data Technologies, Time Series, Forecasting, and Data Science with Machine Learning. Punjab Technical University, India Bachelors in Computer Science Engineering Graduated with honours, achieving a final grade of 80.8%. Coursework included Cloud Computing, Artificial Intelligence, Relational Databases, and Computer Networks.
