Sumit Raju

* Built scalable ETL pipelines for the Air Quality Study, integrating multi-year pollution data with health outcomes and enabling advanced statistical modeling (GLM, IPW). * Engineered reproducible workflows for the Extreme Heat Analysis Project, handling large spatial–temporal datasets and producing high-resolution exposure and health-risk indicators. * Developed geospatial data pipelines for the Active Transportation Accessibility Project, merging SAM indices, CIMD layers, population, and income data to generate equity-focused accessibility insights. * Automated data cleaning, transformation, and feature engineering across all projects, using Python, SQL, GeoPandas, and AWS to improve reliability, reproducibility, and analytical efficiency.

• Processed and documented 15+ diverse datasets for the Department of Environment and Local Government (ELG), showcasing expertise in data mining techniques

Developing IT solutions and providing data analytics to the UNB Co-op office • Building interactive dashboards and analyzing approval data using Microsoft PowerBI, replacing MS Excel, hence improving the efficiency of the overall process by more than 50% • Conducting 3+ business problem analyses every month using DAX and visualization tools to optimize reporting solutions for the university • Programming automated workflows in MS Power Automate, hence saving up to 20 hours of manual approval work per week • Digitalizing the UNB Co-op approval system, hence reducing the paper usage by approximately 90%

Built microservices powered by AI technologies with the data science team to provide data science solutions that include working with Python, AWS and large datasets • Collaborated with the team to develop three Data-as-a-Service microservices—Prep & Store, Model & Analyze, and Ready using Python and AWS Glue • Coded data preprocessing utilities such as JSON parsing, column transformation, data conversion/casting, column selection & dropping, and timestamps creation • Developed Python functions to perform schema validation and metadata recording • Performed ETL operations using Pyspark and AWS S3 buckets for extracting data from databases (RDBMS/NoSQL) and file formats such as CSV and JSON, transforming data with operations such as sorting, mapping, and joins, and loading the transformed data back to the AWS S3 buckets • Created data partitions in AWS S3 buckets for faster processing of data improving load time by 300%+ • Supported the team in building predictive analytics demos using Machine Learning algorithms for clients • Developed utilities for error logging and debugging the microservices using Python loggers

Spearheaded the web development team, managed projects, and orchestrated web-performance activities • Supervised and mentored a team of 5 web developers for 16 months • Implemented 4 projects to improve the SEO ranking of Lenovo’s web pages using improved Meta tags • Initiated and coordinated all web-performance activities across the EMEA region using Blue Triangle’s performance analysis tool and GT Matrix, reducing the page load time by 30 seconds • Implemented Agile Framework and Waterfall Methodology to allocate tasks to the team on a daily basis • Created project timelines to ensure timely completion of projects using tools such as ProjectLibre • Prepared resource estimations and capacity planning processes with managers to improve the team efficiency by at least 30% • Headed daily scrum to plan the team’s daily work and reduced the scrum time from 30 minutes to less than 15 minutes • Collaborated with stakeholders in BMS, Triage meetings, architecture-level discussions, and discussions on Wireframes to understand the business requirements and convert the business ideas to fully functional web features or a web page • Collaborated with the analytics team to develop product recommendation API and interface for the Lenovo Cart page using data science concepts, leading to multimillion-dollar revenue generation worldwide. • Functioned as a web developer in critical and complex projects such as community site development

Principal web developer committed to enriching the user experience of Lenovo’s customers • Built new features and responsive web pages and fixed bugs on Lenovo.com using web technologies such as HTML, CSS, JavaScript, jQuery, AJAX, Python and PHP • Maintained and supported over 20 internal websites written in different languages • Designed and coded an Intranet portal for the web team to enable effective internal team collaboration • Created parallax, long-scroll, animations & graphics-heavy websites to enhance their visual appeal • Improved end-of-life products experience and recreated the global warranty page • Provided adequate training to 20+ junior web developers on web technologies

Individual contributor working in a team to produce innovative & cutting-edge websites • Developed landing pages, microsites, and promotional emailers for the company’s clients • Built jQuery plugins such as accordion menus, image galleries, tab menus, carousels, and JSON-based configurator and worked on jQuery animations, interactive websites, and Google Maps API

At UNB, some areas of my academic projects included cleaning, preparing, and analyzing data, building and testing statistical models, and conducting predictive analysis based on historical data using Python and R Programming to identify and propose solutions to significant problems faced by the companies in consideration.

The Future of Work Skills Program supports emerging leaders in developing proficiency using 10 human-centric skills to reach peak performance-faster. In completing the program, I've been certified in: active & self-directed learning; reasoning, problem-solving & ideation; critical thinking & analysis; analytical thinking & innovation; creativity, originality & initiative; leadership & social influence; complex problem-solving; systems analysis & evaluation; and workplace readiness.