Victor Frankfurt

Address: *** *** ****, ****** *****, IL 60061

Phone: 847-***-****

E-mail: aczjua@r.postjobfree.com

SUMMARY

Software analyst and developer with extensive experience focused on developing highly reliable client-server and web-enabled object-oriented systems. Solid analytical, requirement and database design skills. Strong mathematical background.

TECHNICAL SKILLS

Operating Systems: Windows 8/7/Vista/XP/2000/NT/98/95/3.1, MS-DOS

Languages: VB 6, VBA, SQL, Transact-SQL, XML, XSL, UML, HTML, ASP, Assembler

Databases: MS SQL Server, MS Access, SYBASE, IBM DB2, Teradata DB, Oracle

Development Tools: Crystal reports, Citrix's MetaFrame, MS Office, MS Visual SourceSafe, PVCS, Visio, Rational Rose, IIS, Sheridan software, VSView

Libraries, Methods,

and Technologies: ADO, OLE DB, RDO, DAO, ODBC, COM, DCOM, ActiveX, Win32 API

PROFESSIONAL EXPERIENCE

Consultant 02/2004 – Present

Data Managers, Inc, Vernon Hills, IL (05/2015 – 09/2016)

Support, developed, enhanced and implemented variate things for existing applications in several small companies.

Environment: VB/VBA, MS Access, MS Excel, SQL Server, Visio.

Discover Card, Riverwoods, IL (02/2015 – 12/2015)

Designed, developed, enhanced and implemented the Vendor Auditing System (VAS - Face 2). This application is developed for auditors to assist them in the auditing of vendor compliance with federal, state and Discover regulations. This process includes:

Designing and creating a MS Access 2010 database.

Creating many tables, forms and reports in MS Access and MS Excel

Creating extensive communication between Access, Excel, Word, and Outlook.

Environment: VB/VBA, MS Access, MS Excel, SQL Server, Visio.

DeVry Education Group, 3005 Highland Parkway, Downers Grove, IL (08/2014 – 01/2015)

Analyzed the old applications that had multiple MS Access databases and established proper data security.

Environment: VBA, MS Access, MS Excel, Visio.

Focus Products Group International, LLC, Lincolnshire, IL (05/2014 – 07/2014)

Designed, developed, and implemented the Purchase Reporting Tool (PRT). Designed, developed, and implemented the Purchase Reporting Tool (PRT). This application uses order and transaction data to create a weekly purchasing forecast and other logistics management reports.

Environment: VBA, MS Access, MS Excel, Visio.

Discover Card, Riverwoods, IL (05/2013 – 03/2014)

Designed, developed, and implemented the Vendor Auditing System (VAS). This application is developed for auditors to assist them in the auditing of vendor compliance with federal, state and Discover regulations. This process includes:

Designing and creating a MS Access 2010 database.

Creating many tables, forms and reports in MS Access and MS Excel

Creating extensive communication between Access, Excel, Word, and Lotus Notes.

Environment: VB/VBA, MS Access, MS Excel, SQL Server, Visio.

McDonald’s, Oak Brook, IL (10/2011 – 05/2013)

Designed, developed, and implemented the Compliance Management System (CMS). The CMS is developed to support the Procurement & Supplier Management teams with activities relating to: Contract Management, Asset Management, Supplier Performance Management, Support Management, Risk Management, Supply Chain Management, and Contact Management. The database is a centralized collection of data associated with the Restaurant Technology Life Cycle (RTLC) Process to help the users: Visualize the IT assets within the stores and how they are used, Identify the contracts associated with each of the assets, Identify assets & contracts associated with each suppliers, Collaboration across teams, Capture RIM documents associated with suppliers & assets.

Environment: VBA, MS Access, Oracle, MS Excel, MS Outlook, MS Visio

BioSante Pharmaceuticals, Lincolnshire, IL (04/2011 – 10/2011)

Created a VBA Office application called Medical Safety Query. This application is a tool that helps create and manage medical studies. This application includes several tables, forms, and reports, which are automatically created and sent to investigators by e-mail.

Environment: VBA, MS Access, MS Excel, MS Outlook, SSIS, Visio

McDonald’s, Oak Brook, IL (11/2010 – 01/2011)

Created a VBA Access application called Asset Tracker. This application keeps track of all software installations and upgrades throughout the company as well as all of their interdependencies. This application also creates several reports which show the software upgrade history and cost prediction analysis for new upgrades.

Analyzed the source code of automated windows processes for migration to UNIX server and documented their behavior with specification documents and flow charts.

Environment: VBA, MS Access, Visio

Abbot Labs, North Chicago, IL (9/2010 – 10/2010)

Made enhancement in existed application written on VB.NET that retrieved data from DB2 on AS400 and created set of XML files in windows folder

Environment: VB.NET, MS Access, XML, AS400.

Discover Card, Riverwoods, IL (3/2010 – 9/2010)

Designed, developed, and implemented an MS Access VBA application. This application assists in generation and testing of new credit cards. This process includes:

Creating a replicated MS Access 2003 database.

Creating several forms and 20 reports in MS Access and MS Excel

Developing functionality to synchronize data in the MS Access database with the Teradata database by using the ADO object.

Creating functionality to transfer data back and force between MS Access tables in Windows to flat text files in Unix

Updating MS Access data with transaction data from MS Excel.

Environment: VB/VBA, Teradata DB, MS Excel, MS Access application.

Abbot Labs, North Chicago, IL (11/2008 – 04/2009)

Designed, developed, and implemented additional functionality to the previously developed ROI calculator application within MS Excel, obtaining data from MS Access, using VBA.

Environment: VB/VBA, MS Excel, MS Access application.

Cardinal Health, Waukegan, IL (02/2008 – 09/2008)

Designed, developed, and implemented the physician/clinician relation project using RAD software development methodology. This application supported the everyday communication between Cardinal’s employees from the research and development and marketing departments with physician/clinician experts. Held responsibility for all of the stages of the life cycle of this project.

Environment: Windows XP, Visual Basic 6, VBA, MS Access, MS Visio, and MS PowerPoint

Abbott Labs, North Chicago, IL (11/2007 – 12/2007)

Designed, developed, and implemented the ROI Calculator application using RAD software development methodology. This application provided a user-friendly interface for a large amount of data contained in different excel spreadsheets.

Environment: VBA MS Excel, and VBA MS Access, MS Visio,

Protective Life Insurance, Bannockburn, IL (05/2007 – 10/2007)

Provided enhancement and support of existing Access/Excel/Word VBA applications. This was a core business application that supported all of the communication between the company and its clients.

Environment: Windows XP, Visual Basic 6, SQL Server 2005, Transact SQL, VBA, MS Access, MS Excel, and VBA MS Word.

Abbott Labs, North Chicago, IL (10/2006 – 04/2007)

Designed, developed, and implemented the PLT project using RAD software development methodology. This application supported the monthly project status reporting of the portfolio projects which are monitored by the Project Leadership Team (PLT). Held responsibility for the reporting part of this project which included the design, development, and implementation of many functions and stored procedures for SQL Server and more than fifteen complicated Crystal Reports.

Environment: Windows XP, Crystal Report XI, Visual Basic 6, SQL Server, Trans Act SQL, and MS Access.

Walgreens, Deerfield, IL (08/2005 – 10/2006)

Designed, developed, and implemented the MAPS (Media Analysis and Planning System) project. This project was designed to coordinate the advertising of all 6000+ Walgreen’s stores. Held responsibility for all of the stages of the life cycle of this project.

Environment: Windows XP, Visual Basic 6, SQL Server, Trans Act SQL, VBA, MS Access, and MS Excel.

WPS, Madison, WI (11/2004 – 05/2005)

Designed the underwriting small group reporting project which consisted of 21 reports which reflect the complete underwriting processes, from receiving the application to making the final decision.

Designed, developed, and implemented a process for committing underwriting information to FileNet. This process included service calls to the WEB Service for PDF report generation, creating a TIF file from a PDF, and committing the TIF file to FileNet. This process was implemented as object method and was created using VB 6, SQL Server, and Trans Act SQL

Environment: VBA, MS Access, MS Word, MS Excel, SQL Server, Trans Act SQL, Visio, Crystal Reports 10

Walgreens, Deerfield, IL (02/2004 – 09/2004)

Designed, developed, and implemented an extension to the Loss Prevention Exception (LPX) System. This system produced reports to narrow or eliminate the potential loss related to the transaction process.

Working as a Business Analyst, developed technical documentation for a new project called SPD – Summary Policy Description, which was initiated by the HR department to improve accessibility and personalization for policy information. This project used Visio, MS Word, and MS Excel and VBA

Environment: Windows NT, Visual Basic 6, SQL Server, Trans Act SQL, VS-View VideoSoft Control Library, Visio, and MS Excel VBA.

Navigant Consulting Inc., Oakbrook Terrace, IL 07/1999 – 12/2003 Lead Software Developer

Led the effort to design, develop, implement, and support the Recovery Insurance Billing System (RIBS) for a Fortune 500 chemical manufacturer's risk management department. RIBS facilitates tracking, invoicing, collecting, and reporting the recoverable costs involved in resolving complex long-tail claims with the organization's insurance carriers. RIBS produce quarterly reports, insurer bills, annual reports and other management reports. RIBS also allocates the claims resolution costs to the appropriate insurers using complex settlement algorithms, posts the consumption of insurance coverage to the appropriate layers of insurance, produces the quarterly invoices and tracks the payment of the invoices.

Environment: Windows NT, Visual Basic 6, Seagate Crystal Reports 8.5, MS Access, Citrix's MetaFrame.

Designed, developed and implemented a user interface to the Real Estate Appraisal project. It is a WEB application that is intended to provide an online service for real estate appraisers. Held responsibility for the design, maintenance, and administration of a SQL Server.

Environment: Windows NT, Visual Basic.NET, ASP.NET, and SQL Server

Designed, developed, and implemented the Medical Practice Management Software. This product helped to more effectively manage doctors' office information. The application is used to schedule patient appointments, keep patient overviews and summaries, manage insurance authorization referrals, and create reports for effective practice management. Responsibilities included analyzing user requests, building the data model, creating the database, user interface, reporting system and all underlying logic.

Environment: Windows XP, Visual Basic 6, Crystal Reports 8.5, and MS Access

Participated in the development of the Regulatory Discovery and Production System (RDPS) for a major telecommunications company. Designed and developed a DLL Loader that produced an online reporting system for this project. This DLL worked on a server and produced 17 different reports. The input to this DLL was the client’s request; after the validation of the client information, the DLL makes a call to the database (SQL Server) and retrieves an appropriate record set in XML format. Then, through the use of a DOM object, the DLL created a report in XML format, and by using XSL, created the real report in HTML format and sent it to the client.

Environment: Windows 98, Visual Basic 6, SQL Server, ASP, IIS, XML, XSL and HTML

Designed, developed and implemented the Central Issues Tracking Reporting System (CITRES). This was a generic application used to track issues (bugs and enhancements) during all stages of application development. CITRES made communication between developers and business users more structured and helped in managing change control during system implementation.

Environment: Windows 98, Visual Basic 6, MS Access

Trans Union, Chicago, IL 06/1994 – 07/1999 Programmer Analyst

Took part in re-engineering effort that customized incoming data requests from the customer

Designed, prototyped, and coded large areas of on-line functionality and reports. Created objects' classes and stored procedures utilizing Visual Basic and Transact-SQL

Held responsibility for the complete life cycle development of a number of projects such as statistics, source data review, trending, statistical threshold intervention, accept media, work pool tables maintenance, and others.

Environment: Windows 3.1, Windows95/98, Visual Basic 4/5/6, Sheridan Data and Designer Widgets, Visual Basic add-on custom controls, a VS-View add-on for report writing in Visual Basic, Seagate Crystal reports 7, MS Access, and Sybase 10/11

Created flowcharts and program specifications via Structured English utilizing existing assembler programs

Environment: IBM Mainframe, JCL, IBM PC, MVC, Assembler, COBOL, TSO-ISPF, XPEDITER, SoftTest, and Visio

EDUCATION

MS Computer Science, University of Byelorussia, Minsk, USSR

CERTIFICATION/TRAINING

Microsoft Certified Professional

Business Intelligence and Cognos 8.4, Advanced Computer Training, Chicago, IL

Advanced WEB development in .NET (ASPX), IT Quality Group, Chicago, IL

Programming with Visual Basic .NET, C# .NET IT Quality Group, Chicago, IL

E-Commerce (Web Development) Advanced Computer Training, Chicago, IL

Sybase Advanced Transact-SQL, Sybase Chicago Training Center, Chicago, IL

CICS Program, DePaul University, Chicago, IL

Contact this candidate