Jared Sage Email & Phone Number

Columbus, Oh, Us

Columbus, Oh, Us

Shaker Heights, Oh, Us

Dublin, Ohio, Us

Chicago, Illinois, Us

Collaborated with internal bank customers to convert existing Microsoft Access solutions into Microsoft Excel VBA macros. Partnered with CLS teams to maintain existing reporting. Queried Oracle SQL Database to pull datasets for new and existing reports. Refactored existing Microsoft Excel VBA macros leveraged by CLS team.• Reduced manual input of weekly officer reassignment process by 70% after refactoring of existing VBA macro.• Developed Microsoft Excel VBA solution, leveraging Power Query to produce daily report of outstanding GL items, reducing manual input requirements by 80%.

Chicago, Illinois, Us

• Implemented Microsoft Excel VBA solution, leveraging Power Query and Mail Merge to maintain data set of active borrowers with past due balances and generate monthly letters, reducing manual processing by 65%.• Decreased runtime of daily batch audit report by 60% after refactoring of VBA macro.

Bonn, De

Partnered with end customers to develop new and improved Power BI dashboards. Queried SQL Server Databases to define datasets for new and existing reports. Managed suite of MS Access databases, utilizing VBScript and Powershell, providing daily fuel guidance to external customers and available capacity utilization loads to internal customers on an hourly basis.• Scraped data from external vendor websites and uploaded to relevant Azure databases. Managed data import process to Azure databases by composing effective stored procedures. Developed automation with Powershell to create and manage backups of MS Access databases on network share, collectively saving 20 hours of labor per month.• Implemented daily Python script to extract recurring data pulls from Azure database, saving 6 hours of manual execution per week.• Participated in multiple process workshops improving overall system compliance by 40% over 3 months.

Mahwah, Nj, Us

Collaborated with CIO and direct reports on IT intake/output, financial data, and staff metrics. Collected and analyzed interviews with service owners to provide key insights. Delivered IT metrics via Power BI dashboard after extracting and compiling data. • Created a monthly IT scorecard by utilizing Python, Microsoft Power BI, and SQL Server Database. • Implemented Python automation to gather and process customer survey data. • Executed automation with MS Excel, gathering business review scorecards to ensure better strategic planning. • Organized meetings to examine root causes and support IT teams in highlighting and correcting issues.• Boosted SLA success rate to 95% from 50% in nine months, initiating weekly SLA summary reports.• Delivered reliable support to the marketing technology department and decreased carryover incidents by 50%.

Mahwah, Nj, Us

Managed day to day Service Desk Operations and worked with IT Support partners to improve Service Desk Best Practices. Provided high-level statistical analysis to Service Desk Management.