KIMBERLY LEMONS

Demonstrated expertise in customer service and sales within a dynamic sales environment. Established and nurtured client relationships while consistently achieving sales targets. Aiming to apply these transferable skills to enhance customer satisfaction and drive sales success in a new position.

eXcelerate Analyst Training - SQL, Excel, and Power BI Data Analytics Boot Camp (October 2024 - April 2025)

SQL Beginner and Intermediate Boot Camp Training (August 2024 - October 2024)

• Proficiently extracted diverse real-world data requests, credit card payment metrics, credit and lending financials, and consumer demographic metrics for banking related data, while utilizing Snowflake in a hands-on boot camp setting

• Applied a comprehensive suite of intermediate SQL techniques, encompassing intricate joins (left/right/full/inner), where statements, order by statements, limits, various date functions (DATEADD, MONTHNAME, DAYNAME, YEAR, DATEDIFF, MONTH, QUARTER, etc.), and aggregation functions (SUM, AVG, COUNT, MIN, MAX)

• Skillfully crafted complex calculated fields, significantly contributing to the formulation and execution of intermediate SQL calculations to create key metrics.

Advanced SQL Boot Camp Training (January 2025 - February 2025)

• Proficiently extracted diverse real-world data requests, encompassing account volume, credit risk, financial performance, and consumer demographic metrics for banking operations and financial data, while utilizing Snowflake in a hands-on boot camp setting

• Applied a comprehensive suite of advanced SQL techniques, encompassing intricate joins (left/right/full/inner), having statements, unions, temporary tables, case statements, group by, and subqueries

• Skillfully crafted multi-page intermediate to advanced queries

Microsoft Excel Formulas Boot Camp Training (February 2025 - March 2025)

• Utilized XLOOKUPS, IF, IFS, and nested intermediate formulas to manipulate financial and operational data records for various Excel datasets in a hands-on boot camp setting

• Created financial and operational summary metrics through the utilization of SUMIFS, AVERAGEIFS, and COUNTIFS

• Manipulated various date data records via the usage of various date functions (TEXT, MONTH, YEAR, DAY, TODAY, and DATEDIF)

Power BI Boot Camp Training (March 2025 - April 2025)

• Data Transformation: Imported data from various data sources such as Excel, CSV, and .txt files while utilizing Power Query to perform data modifications such as date additions, mathematical calculations, refresh updates, and adjusting data types.

• Visual Storytelling with Power BI: Harnessed the visualization capabilities of Power BI to craft impactful narratives and translated insights into visually captivating stories via a dynamic dashboard through the formulation of various charts and graphs (cards, donut charts, combo charts, bar graphs, and column charts), theme selections and corporate branding, filtering, sorting, and data aggregation.

• Data Modeling: Created relationships through the identification of various tables' primary vs. foreign keys as well as created valuable business metrics through DAX columns and measures via common DAX functions (SUM, CALCULATE, and FILTER)

• Inducted into Million Dollar Sales Club
• Warehouse Employee of the Year