SUMMARY:

• Seasoned professional experienced in working with all functional areas and at all organizational levels.
• Exceptional troubleshooter who quickly identifies and resolves operational and technical problems.
• Excellent business and project planning skills.
• Quick and adaptable learner.
• Equally comfortable working independently or as part of a team, either in a leading or a subordinate role.
• Expert in designing, organizing and processing data. Specializes in Application Development in Excel and Access (100's of users is not a problem ), with an occasional use of SQL Server as a back end (when data storage needs exceed ~1 GB). Extensive VBA programming.
• A typical app would effectively have a 3 - layer 2-tier architecture. Efficient, compact and intuitive UI designs.
• When tasked with reworking or fixing an existing app or process, "10x smaller, 100x faster" is typical outcome.
• Working with project managers, application owners, data providers and users with respect to performance requirements system integration security data structure, size, storage and accessibility application configuration, deployment, maintenance and upgrades user interface design
• Performing software/application testing and design/implement necessary changes with respect to data compatibility data transfer performance speed accuracy fault tolerance reliability usability
• Creating, documenting and/or updating user manuals deployment/installation instructions peration manuals technical notes on application design technical notes on software design

EXPERIENCE:

Consultant

Confidential, Chicago, Illinois

Environment: VBA, SQL, Access 2013

Responsibilities:

• 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 Confidential .
• 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.

Confidential, Downers Grove, Illinois

Environment: VBA, SQL, Access 2013

Responsibilities:

• Redesign/enhancement of a multi-user (250+) loan processing application encompassing several front/back-end Access databases and an SQL Server database.

Confidential, Schaumburg, Illinois

Environment: VBA, Excel 2010

Responsibilities:

• 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.

Confidential, Chicago, Illinois

Environment: VBA, Excel 2003/ 2007/2010/2013 , Access 2010, Windows 7

Responsibilities:

• 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.

Confidential, Downers Grove, Illinois

Environment: VBA, Excel 2007/2010/2013 , Access 2003/2010, SQL Server 2008, Adobe LiveCycle Designer, Windows XP, Windows 7

Responsibilities:

• Developed an Access-based multi-user application that can predicting corporate clients’ healthcare buying ps 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 Confidential ’s health plans Business Plan Agreements with their group clients.
• 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.

Confidential, Deerfield, Illinois

Responsibilities:

• 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 /control information and data depository (two-tire client-server architecture).
• There are hundreds of underwriters that use this application countrywide. VBA, Excel 2003, Windows XP

Confidential, Rosemont, Illinois

Responsibilities:

• 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.
• VBA, Excel 2003/2007, Access 2003, Windows XP

Confidential, Chicago, Illinois

Responsibilities:

• Developed several Excel-based VBA-programmed applications for Confidential .
• 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.
• Developed a specialized project scheduling and manpower tracking tool. A key contributor to design solutions. Excel, VBA

Confidential, Arlington Heights, Illinois

Responsibilities:

• Developed tools to assist in the analysis of regional real estate markets. Excel, Word
• Performed market analysis and prepared sales forecasts. Excel, Word
• Developed job costing models and various pricing strategies. Excel
• Designed and coded a Pocket PC application for floor plans mapping surveys. eMbedded VB

Confidential, Carol Stream, IL

Responsibilities:

• Fully designed, implemented, and serviced a relational database application in a network environment. This modular groupware application encompasses project management and employee work time reporting. The very extensive work in developing new data model and process logic involved reviewing the 20-year old legacy application (code, data model, system processes), and figuring out current business processes and requirements through interviews and analysis of current business documentation (forms, memos, reports, etc.). Massive GUI development for data input and soft/hard reporting. Performed data conversion, employee, and documentation. Access, VBA, SQL
• Developed, implemented, and serviced a specialized project/product/customer tracking and reporting software linked to the network-based project database for the use by the company’s Management. Special care was taken in development of a suitable User Interface, especially the forms for Data Input and Data Query. Performed extensive coding of business constraints. Wrote a special search engine and report generator. Access, Excel, VBA, SQL
• A key contributor to UI design solutions and business process changes, a decision maker on all technical issues for both projects.
• Provided support for the developed applications.