Experience

Card Integrity

• United States
• Business Intelligence Platforms
• 1 - 100 Employee

• Solutions Architect

  • Sep 2023 - Present

  Oak Brook, Illinois, United States Responsible for the development of new features and enhanced data processing methodologies. Also implementing improvements in performance and reliability of the operational software and designing changes to data architecture with the goal of increased efficiency in data storage, accessibility and expandability. [VBA, SQL, Access, Excel]



PNC

• United States
• Financial Services
• 700 & Above Employee

• Business Analysis Advisor

  • Mar 2020 - Sep 2023

  Downers Grove, Illinois, United States Complete ownership, from design through production support, of new multi-user Excel/Access applications in the areas of mortgage loans origination and underwriting. [VBA, SQL, Access, Excel, Toad/Oracle] Olso (see below), multiple consulting engagements with PNC between Jun 2016 and Sep 2018.



National Express LLC

• United States
• Transportation/Trucking/Railroad
• 700 & Above Employee

• Consultant

  • May 2019 - Apr 2022

  Lisle, Illinois, United States [VBA, Excel 2003, Excel 2010, Excel 2016] ▪ Development and maintenance of Revenue and Expense Monthly Close accruals data collection template used in multiple locations (several hundreds, US and Canada). ▪ An Excel-based app for extracting of the accruals data entered into the field templates and generating corresponding Journal entries.



Card Integrity

• United States
• Business Intelligence Platforms
• 1 - 100 Employee

• Software Architect

  • Oct 2018 - Mar 2020

  Oak Brook, IL Responsible for the development of new features and enhanced data processing methodologies. Also implementing improvements in performance and reliability of the operational software and designing changes to data architecture with the goal of increased efficiency in data storage, accessibility and expandability. [VBA, SQL, Access, Excel]



PNC

• United States
• Financial Services
• 700 & Above Employee

• Consultant

  • Jun 2016 - Oct 2018

  Downers Grove, IL * Conversion/adjustment of the below-mentioned Access/SQL-Server-based loan processing application to assure its continued normal operation in the new Access/Oracle-based environment. * Conversion/adjustment of numerous SQL-Server-based operation management reports to work in the Oracle-based environment. * Redesign/enhancement of a multi-user (250+) loan processing application encompassing several front/back-end Access databases and an SQL Server database.



BMO U.S.

• United States
• Banking
• 700 & Above Employee

• Consultant

  • Jun 2017 - Nov 2017

  Chicago, IL * Developed automated tools to boost accuracy, effectiveness and speed of analysis and verification of data conversion/movement between the BMO native systems and the now being integrated Lease Loan business recently acquired from GE. For various business, legal and technical reasons, the Lease Loan business remains largely unaltered and its systemic integration into BMO overall structure requires bilateral daily multi-stage conversion and movement of customers and financial data. This cyclic… Show more * Developed automated tools to boost accuracy, effectiveness and speed of analysis and verification of data conversion/movement between the BMO native systems and the now being integrated Lease Loan business recently acquired from GE. For various business, legal and technical reasons, the Lease Loan business remains largely unaltered and its systemic integration into BMO overall structure requires bilateral daily multi-stage conversion and movement of customers and financial data. This cyclic daily data exchange has been tested, adjusted and tuned since 2016. Show less



Waterton

• United States
• Real Estate
• 400 - 500 Employee

• Consultant

  • Oct 2014 - Nov 2017

  Chicago, IL * Automated various processes of data manipulation and analysis for Accounting and Finance areas. * Developed a variety of miscellaneous applications in Excel and Access, ranging from “Office Sitting Chart” to “IT Change Control” tool (two-tire client-server architecture, Excel/Access). * Implemented in Excel a residential property markets’ ScoreCard model for the use in property acquisitions and development, and in REIT management areas.



Zurich North America

• United States
• Insurance
• 700 & Above Employee

• Consultant

  • May 2016 - Aug 2016

  Schaumburgh, IL * Various projects to automate work processes related to data management, analysis and reporting. One substantial project of note is an automated system designed to handling the back-end financial data processing and agile managerial reporting for their international and domestic re-insurance activities related to major catastrophic events, like natural disasters on the scale of Hurricane Sandy in 2012, for example.



US Foods

• United States
• Food and Beverage Services
• 700 & Above Employee

• Consultant

  • Aug 2011 - Feb 2015

  Rosemont, Illinois * Developed Excel/Access-based applications for the Financial Planning and Analysis Group. 50/50 VBA programming and direct Excel-Access development. These applications are used in 1) advanced operational planning and 2) for weekly submissions to payroll and to company’s main data systems. Expanded the application’s scope and features during the second and the third assignment periods.



Health Care Service Corporation

• United States
• Hospitals and Health Care
• 700 & Above Employee

• Consultant

  • Jul 2012 - Oct 2014

  Downers Grove, IL * Developed an Access-based multi-user application that can predicting corporate clients’ healthcare buying preferences based on a proprietary math model and complex firmographic data. Now the tool is in its second year with close to 200 users (account executives) in Texas and Illinois. * Developed an Excel-based application to summarize and chart daily updatable status reports (from production database downloads) for work-in-process client accounts. * Developed an Excel-based application… Show more * Developed an Access-based multi-user application that can predicting corporate clients’ healthcare buying preferences based on a proprietary math model and complex firmographic data. Now the tool is in its second year with close to 200 users (account executives) in Texas and Illinois. * Developed an Excel-based application to summarize and chart daily updatable status reports (from production database downloads) for work-in-process client accounts. * Developed an Excel-based application that allows creation and maintenance of emulated dynamic PDF documents (this is after the initial design team proved in their 4-months effort the Adobe LiveCycle Designer not equal to the task). One dynamic document can reduce the resultant PDF document’s page count by up to 90% as compared to an equivalent set of static documents. One dynamic document eliminates multiple stand-alone static document templates. Now there is only one template per state per year to cover the full document complexity of BCBSIL’s health plans Business Plan Agreements with their group clients. In the summer of 2014, enhanced UI and functionality for the 2015 version (the third one) of the tool. * Developed an Access (front end)/SQL Server (back end) application for daily maintenance and management of client accounts with three tiers of user access/functionality levels. Show less



Markel

• United States
• Insurance
• 700 & Above Employee

• Consultant

  • Nov 2011 - Jul 2012

  Deerfield, Illinois * Developed an Excel-based application to collect client information and calculate premiums for management liability insurance. The application uses locally run workbooks in combination with network-located reference/control information and data depository (two-tire client-server architecture).



Deloitte

• Business Consulting and Services
• 700 & Above Employee

• Consultant

  • Sep 2008 - Mar 2011

  Chicago, Illinois * Developed several Excel-based VBA-programmed applications for Deloitte's National Tax Technology Group (NTTG). These applications are used by the tax practice primarily to gather, document, process, and analyze data for the purposes of tax calculations and filings. These applications operate in both desktop and network modes with multiple data sources (input and output) like external spreadsheets, text/csv/pdf files, MS SQL Server or Access databases. A key contributor to UI design solutions,… Show more * Developed several Excel-based VBA-programmed applications for Deloitte's National Tax Technology Group (NTTG). These applications are used by the tax practice primarily to gather, document, process, and analyze data for the purposes of tax calculations and filings. These applications operate in both desktop and network modes with multiple data sources (input and output) like external spreadsheets, text/csv/pdf files, MS SQL Server or Access databases. A key contributor to UI design solutions, a decision maker on all projects' technical issues. * Upgraded several applications for reliability, performance, and features. Provided support for the developed applications. Worked with the users on problem resolutions and design enhancements. Show less



Nokia

• Finland
• Telecommunications
• 700 & Above Employee

• Consultant

  • Aug 2010 - Nov 2010

  London, UK * Developed a specialized project scheduling and manpower tracking tool. A key contributor to design solutions.