Patrick Robison Email & Phone Number

Certified Data Analyst with a passion for creating valuable and visually appealing business solutions. I am proficient with SQL with the ability to create complex ad-hoc queries while also being certified with Power BI and aiming for other certifications. Using my technical knowledge and communications experience, my goal is to save an organization time and money by making processes more efficient or adding value to them; regardless of the scale. I excel at troubleshooting, collaborating with teams and stakeholders, and communicating my priorities and progress. I constantly aim to practice my skills by creating projects with full walkthroughs on my project portfolio. TECHNICAL SKILLSProgramming Languages: Java, Python (Pandas, NumPy, MatPlotLib, Seaborn) Relational Databases: MS SQL Server, MySQL, OracleBI & Visualization Tools: Power BI, Tableau, MS Excel (Pivot Tables, VLOOKUP, Macros, VBA, etc.)Other Competencies: Visio, Service Now, SmartsheetsFUNCTIONAL SKILLS: Documentation | Communication | Requirement Gathering and Analysis | Project Management | Systems AdministrationHighlights:• Created an automated Dynamics GP smartmap through an ADP integration with SQL using CTEs and window functions to remove outdated department access codes, saving our team up to 5 hours weekly.• Developed an Active Directory group membership report in SSRS by utilizing LDAPS, temporary tables, and stored procedures; improving the overall effectiveness of our onboarding, offboarding, and group processes.• Designed over 300 ad-hoc queries with SQL to visualize and deliver findings through MS Excel, SSRS, or GP smartviews.