GARIMA SINGHAL E-mail: ad3r71@r.postjobfree.com Phone: +1-937-***-****

LinkedIn: https://www.linkedin.com/in/garima-singhal/ EDUCATIONAL QUALIFICATIONS

UNIVERSITY OF ILLINOIS URBANA-CHAMPAIGN, Gies College of Business May 2022 Master of Science in Business Analytics (Concentration: Data Analytics in Finance), GPA – 3.91/4.0 Urbana-Champaign Area, Illinois

WRIGHT STATE UNIVERSITY, Russ College of Engineering December 2018 Bachelor of Science in Computer Science with a minor in Mathematics, Graduated Cum Laude, GPA – 3.59/4.0 Dayton, Ohio

WORK EXPERIENCE

Senior Associate, Data Engineer – Capital One June 2022 – December 2023 o Developed an automated rules engine, saving Customer Service Agents 70% of time on Validation of Debt cases. o Constructed rules engines using Java and Spring Boot, seamlessly integrating with APIs, AWS S3, and RDS databases. o Collaborated closely with agents, resolving real cases to understand daily challenges. o Achieved substantial reduction in agent servicing time, elevating customer satisfaction. Data Engineer – Infosys LTD. (CLIENT: CHARTER COMMUNICATIONS) February 2021 – August 2021 o Developed ETL pipelines using Adobe Data, FTP files, and Alteryx to aggregate data into SQL Server, significantly cutting down manual work by 90%.

o Conducted data analysis and research to gain strategic insights for targeted marketing campaigns to attract new customers, leading to a remarkable 20% increase in customer acquisition. o Rewrote and migrated approximately 70 SQL scripts from SQL Server to Oracle SQL Developer, resulting in overall cost reduction.

Senior Associate Software Engineer – Infosys LTD. (CLIENT: WAL-MART) April 2020 – January 2021

Project – SUSE Linux server’s migration to Walmart Cloud Native Platform (WCNP) o Successfully moved SUSE Linux server applications to WCNP and utilized Azure for efficient file storage. o Conducted thorough analysis of application dependencies, including database and Java dependencies, ensuring compatibility adjustments during the cloud migration process. Tested applications on Docker before the actual migration. o Examined Walmart servers to extract high-quality data, actively engaged in code modifications, compilation, and debugging in Unix. Executed SQL query remediation, transitioning from IBM Informix to Azure SQL for seamless application operation in the cloud.

o Achieved significant cost reduction by optimizing the operation of multiple data centers across the United States, enhancing overall security measures.

Associate Software Engineer – Infosys LTD. (CLIENT: WAL-MART) February 2019 – April 2020

Project – Data and Analytics Engineer

o Engineered ETL processes for Slack and Zoom Meeting data using SQL server and Python, optimizing data handling based on intricate SQL queries.

o Automated data loading and SQL database refreshing with Python scripts and Azure Data Factory pipelines, executed weekly for efficiency and resulting in reduced manual work by 90%. o Enhanced SQL performance and productivity with custom stored procedures and elevated productivity by 70% through automation workflows in Alteryx.

o Constructed and improved Power BI and Tableau reports, delivering valuable insights to stakeholders for informed decision- making.

PROJECTS

Team Lead & Business Analyst - Capital One Pro Bono March 2023 – Oct 2023 o Led a team of 6 analysts to empower a non-profit organization with data insights for securing government and stakeholder funding. o Collaborated on understanding the business model, strategizing based on client input, and maintaining effective communication. o Utilized Python for data cleaning and analysis, generating insightful visualizations via Tableau. o Presented compelling visualizations and strategic funding plans to the client and leadership at C1, fostering a strong client relationship. o Successful partnership led to increased funding for community support. Project Lead & Data Scientist – Strata Decision Technology September 2021 – May 2022 o Led a team of 5 data scientists, transforming capital expense management for Strata’s clients, ensuring a streamlined process. o Collaborated on gathering requirements by effectively communicating to the client on weekly basis and crafting a tailored action plan seamlessly integrating with healthcare equipment data. o Conducted meticulous syndicate data research on the FDA website, enhancing our understanding of healthcare equipment. o Hands-on data analysis using Python, Data Modeling, and Visualizations allowed for pinpointing equipment lifespan and potential recalls, enabling hospitals to make informed budget decisions. o Presented our research and analysis to the senior leadership at Strata and achieved exceptional customer satisfaction and saved millions by delivering a robust capital expense plan, ensuring financial efficiency and strategic spending. LICENSES & CERTIFICATIONS

Business Development: Strategic Planning LinkedIn Learning, January 2024 AWS Certified Solutions Architect – Associate Amazon Web Services (AWS), March 2023 Introduction to Business Analytics: Communicating with Data (with Honors) University of Illinois Urbana-Champaign, July 2020 PostgreSQL Essential Training LinkedIn Learning, July 2020 IBM Data Science Professional Certificate IBM, June 2020 The Complete Oracle SQL Certification Udemy, January 2020 TECHNICAL SKILLS: SQL (My SQL, Teradata, Data Lake, SQL Server, Oracle, PostgreSQL), MongoDB, SAS, Python, R, Java, Hive, Machine Learning, Microsoft Excel, ETL (Extract, Transform, Load), Alteryx, Linux, MATLAB, Market Research and Analysis, Business Strategy, Data Modelling, Data Mining, AWS, Microsoft Azure, Tableau, Power BI, Jupyter Notebook SOFT SKILLS: Analytical, Strategic, and Critical Thinking, Problem Solving, Teamwork, Communication, Leadership, Decision Making, Attention to Detail, Time Management