Jimmy Smart Email & Phone Number

Alpharetta, Georgia, United States

- Civilian contractor to the US Army through Magellan Federal- Create an internal Sharepoint site for shareholders by using various methods such as Power Automate to pull, clean and export a daily team personnel data set. Imported personnel records and certifications into corresponding subfolder within the Sharepoint site for quick look up.- Worked with the Rangers team to create automated monthly reports based on Ranger School graduation and drop out rates using Power BI and Adobe Acrobat.- Created various ad hoc reports within Power BI, Excel and Power Automate based on team need.

Alpharetta, Georgia, United States

- Utilized Alteryx to engineer dynamic workflows, integrating diverse data blending and cleansing techniques to establish an automated system that significantly enhanced workflow efficiency.- Proficiently employed Excel and executed SQL queries to extract and transform data from diverse company servers and local sources, ensuring the comprehensive cleansing and organization of data obtained from Salesforce and SAP data warehouses. Resulted in the generation of detailed daily, weekly, and monthly data visualization reports.- Engineered interactive and insightful Tableau dashboards, empowering key stakeholders in data-driven decision-making. Notable contributions including the creation of a live Actuals vs Forecast, Budget vs Forecast and expenditure heatmap using SQL based coding to for a workforce of over a 1000 personnel.- Developed and maintained a sophisticated dashboard to capture and illustrate utilization across the organization. This interactive tool showcased resources' actual hours per timesheets, allowing users to customize views based on level manager, team, or individual resource. Implemented filters facilitated a detailed breakdown of hours, including billable hours, admin/training or PTO.- Collaborated seamlessly with cross-functional teams, identifying business requirements and delivering innovative, data-driven solutions. Provided weekly status reports to the Professional Services EVP leadership team by creating and maintaining the business operations utilization deck, which tracks YoY business unit performance against the top organizational KPIs.

Norcross, Georgia, United States

-Successfully provided integration support and product matching between recently merged companies (CSG and White Cap) by interpreting large files of data through Excel.-Utilized various functions (Vlookup, If-statements) along with filtering techniques to quickly and accurately sort compare data while comparing products between files.-Submitted finalized reports to Shareholders and Subject Matter Experts through the creation of comparison files in order to improve overall strategies and operations. -Proposed solutions to improve system efficiencies.

-Performed data wrangling, data cleaning and time series analysis of historical weather data collected for 5 cities over a 10 year time span to create a predictive model to be used as an economical tool for those affected by weather conditions in the Gulf Coast.-Modeled the training data to several regression algorithms with XGBoost achieving a RMSE of 0.1 and accuracy of 33% on the test data.-Performed data cleaning on a dataset consisting of 250 common drugs that were prescribed by 25,000 unique licensed medical professionals. EDA techniques to remove outliers and conduct cross-correlation of variables. -Showcased data visualizations to reveal trends that correlated opioid prescription spikes with factors that included prescribing medical specialties, their geographical locations and genders.Implemented predictive classification models on prescribing prescriptions.-API data wrangling of stock exchange data, Inferential statistics of hospital data and SQL projects

Greater Atlanta Area

-Partnered with clients to ensure candidate’s qualifications met company requirements through CRMs, ATS and job boards.-Interacted with hiring managers to properly provide them with top level developers, testers, analysts, engineers and project managers to fill their organizational and team roles.-Trained and mentored 100s of candidates for initial and final interviews along with conducted post interview analysis with both the client and the candidate.-Created and maintained databases to store beneficial data of clients and candidates to better prepare for future requirements.

Data Science

Activities and Societies: Intensive course in Python, SQL, data science, machine learning and Capstone Projects

Bachelor Of Science (Bs), Broadcast Journalism