Gregory Hidlay Email & Phone Number

Maryland, United States

For Banking Client• Developed several business-critical ETL processes utilizing Azure Data Factory, Logic Apps, Python, and SQL• Developed SQL Stored Procedures and processes used in client-facing reporting• Updated, debugged, and maintained legacy SQL stored procedures integral for day-to-day functions• Took over and managed team dedicated to client data integration, got the program in a usable state and created a roadmap for improving it using Azure Data lake and Databricks, For Health Tech Client• Created ETL Process using Azure Data Factory for client• Built out Data Lake that utilized Azure Gen 2 Data Lake Storage• Ingested data using ADF Pipelines and custom Python Azure Functions for exception handling and transformation.• Created custom Azure Logic App to automate Email notification based on different triggersFor Health Services Client• Designed Database and Data Warehouse• Developed automated ETL process to populate Data Warehouse• Created customized reporting showing key business metrics for client• Utilized Power BI to reproduce required reports for the client• Used Python and Software 3rd-party API to acquire and load data into DatabaseFor Health Tech Client• Created ETL Process using AWS Glue for client• Built out Data Lake that utilized AWS S3, Athena, and Dynamo• Developed Python scripts using Glue to transform and clean data.• Created custom JSON payload that allowed for greater scalability with new clients and evolving business needs

Franktown Colorado

• Use SQL to query database and create custom reports for senior and site-level staff.• Use Python along with various APIs to streamline processes and gather/clean data.• Automate tasks using custom VBA scripts, saving site staff up to 500 labor hours per month and immeasurable time saved for accounting office staff.• Assisted with web development of employee intranet using vb.net• Developed custom Wordpress Plugins for Marketing using, PHP, Javascript, CSS and HTML.• Spearheaded Renter's Insurance rollout and process automation bringing coverage to our 60,000+ tenants and generating 5M+ in previously unrealized Annual Revenue.• Managed Blue Moon Software rollout to 250+ properties, giving our site staff the option to provide E-Signatures, and ensuring leases were in-line with local laws. • Managed company-wide switch from Dropbox to Google Drive and Gsuite when Dropbox increased their price by over 200%, cutting annual costs by approximately $400k.• Managed adoption of Orion BI toolset for multifamily Yardi database• Ad hoc data analysis and reporting projects.• Presented to over 500 people at Annual Company Meeting regarding company-wide project roll outs

Kansas City

• Developed and delivered reports to senior-level management.• Used statistics and knowledge of 6-Sigma to create month-end trend analysis report.• Overhauled chart of accounts and financial statement mapping to improve clarity for entire accounting office.• Automated commission calculation spreadsheets for monthly posting.• Quickly learned and mastered Dealer Management Software.• Ad hoc accounting work.

Bloomsburg, Pennsylvania

• Completely originated web presence using Wordpress and HTML.• Built custom Wordpress plugins using PHP and Javascript• Used customer service skills to ensure pleasant engagements with tenants.• Adhered to strict time and budget constraints.

Wichita, Ks

• Taught advanced level math concepts to approximately 60 students.• Adapted teaching to suit different learning styles and backgrounds.• Developed and presented daily lesson plans.

Wichita, Kansas Area

• Small group training leader.• Responsible for accurate grade management of over 100 graduate and undergraduate students.• Provided research support and data management for professors.

Wichita, Ks

•Provided students tools to succeed in academics.•Inspired students to achieve goals through individual determination.•Wrote formatted reports on student progress and documented plans for improvement.

Columbia, Sc

•Deploy marketing strategies to help Kaplan Test Prep and Admissions increase its on-campus presence at the University of South Carolina.•Use branding and social networking to advance Kaplan’s business development goals.

Bloomsburg, Pa

• Helped to relieve pressure created by merger of two banks. • Learned the structure of loan documentation and loan insurance. • Created system for digitizing loan insurance documentation. • Designed Excel database for loans and accurately managed their status.

Master'S Degree, Economics

Bachelor Of Science (Bs), Finance, Economics