Data Engineer

RESUME OF: PETER S. SZYMCZAK

** *** ******

Bayonne, New Jersey 07002

adgo07@r.postjobfree.com

201-***-**** (Cell)

Languages:

MICROSOFT VISUAL SOURCE SAFE 6.0, MICROSOFT VISUAL STUDIO TOOLS FOR APPLICATIONS 2015, MS ACCESS (2.0, 8.0, 10.0, 15.0), VBA/CROSS-APPLICATION PROGRAMMING, MICROSOFT VISUAL BASIC 6.0, ORACLE, PL/SQL, SQL*PLUS, SQL*FORMS, SQL*REPORT WRITER, PL/SQL, SQL REPORT, DBASE III PLUS, LOTUS 1-2-3, SYMPHONY, DCL, VMS, DOS

Technologies:

ODBC/OLE DB, RDBMS, WINDOWS API

Databases:

MICROSOFT SQL SERVER 2008 THRU 2015, MS ACCESS, ORACLE8i, SYBASE SERVER

O/S:

WINDOWS 7 PROFESSIONAL, WINDOWS SERVER 2003/2007, WINDOWS XP, WINDOWS 2000, WINDOWS NT, WINDOWS 9X, WINDOWS FOR WORKGROUPS, OS/2, AIX 4.3.2

Others:

MS OFFICE, SQL NAVIGATOR, TOAD, EMBARCADERO DBARTISAN, NOVELL NETWARE, MICROSOFT ADT, ADOBE ACROBAT, ADOBE ACROBAT DISTILLER, REFLECTION FTP, WISE INSTALLATION SYSTEM, REMEDY

Hardware:

IBM RS/6000 9076 SILVER NODE, VAX 8650, 8700, 8800, PENTIUM TECHNOLOGY DESKTOPS, IBM PS2, AT, XT AND COMPATIBLES

PROFESSIONAL EXPERIENCE:

Tangoe, INC

September 5th 2006 to April 17th 2020

Sr. Software Engineer

Development and maintenance responsibilities of the IPV system built upon a relational database platform (SQL Server 12.0) with various client server screens (Visual Basic 6.0) that enable the user to view and update data content in a variety of ways.

Much of the data is managed with system tables that define specific data fields and the range of valid data values that can be populated with each field. Specific processes need to be followed in order to add, change or delete data values from these tables.

Responsible for the rewrite of the IPV Payment process that is used by Service Delivery users to generate the AP/GL files for all IPV clients that has historically been used and maintained separately. The newly designed process allowed users to run multiple payments at once instead of one at a time. To better streamline, control code change and allow the user multiple flexibility within the process successfully brought the 2 code-bases together into a single system which allows MIS to respond to changes more efficiently.

Development and maintenance responsibilities of the Audit Database application that allows users to enter account lists and to manage all steps involved in conducting an audit, submitting claims and tracking claim status, as well as ongoing validation efforts as applicable.

Implemented claim extraction automation process to move/sync legacy HCL audit data with the Audit Database application for all the legacy HCL clients, allowing integration with Tangoes current processes.

Worked with the Product group to help define and develop a solution to move the Audit DB data into Matrix.

Continuous support the ongoing effort to migrate this data for all clients as needed and requested by the Product group.

Responsible for maintenance and implementation of Power House application developed in Visual Studio. Application uses this process to export and imports a variety of files between Tangoe and its clients, including payment files, reports, HRIS and check feedback imports among others.

Tangoe automates these file transfer processes with the use of Power House application because of its powerful and simplistic capability that can easily be setup in a matter of minutes.

Power House also has automated abilities to create and distribute client vendor invoice images and make them available to another application which is accessed for review by Tangoe’s clients.

Responsible for maintenance and implementation of the GE Utility tool that was created and designed to allow IPV Application to support General Electric (GE) custom requirements that were inherent to the design of Bill Tamer, but not IPV.

Key features of the GE Utility are:

GE Table maintenance – the GE Utility houses unique GE tables required for productions handling that do not exist in IPV. These tables allow for the creation of allocation strings as well as support GE output reporting requirements.

Promotion/Demotion of invoices – the GE Utility allows the production team to promote invoices in a timely manner to help with meeting monthly production timelines and SLAs.

Short Pay / Recycling – the GE Utility also automates the ability to match item IDs, short pay as necessary and recycle when item IDs are available in inventory.

Asset File Review – the GE Utility allows the production team visibility into the current set of asset files in use at any given time as well as visibility into the file details for research purposes.

Responsible for numerous areas of the business processes, such as creation of custom reports, payment files processes and other custom utilities.

Daily production client support to requests and incidents which are submitted and tracked through the use of the SNOW (Service Now) ticketing system.

1800FLOWERS.COM

January 2006 to July 2006

Consultant

Responsible for redesign / reengineering of the 1800Baskets database originally designed using Microsoft Access 2003. The database collects information based on orders taken on the 1800Baskets.com web site which is a new gift service unit of 1800Flowers.com. The application imports web, phone and email orders placed on the 1800Baskets.com via ‘csv’ and ‘txt’ file formats. This information is used to produce shipment detail information based on the placed orders which is later exported and transferred to the third party vendors for delivery. The captured data also contains financial / accounting information which is used to produce different sales and forecast reports. These reports are used internally for review by the 1800Flowers.com management and accounting department.

Tasks Completed

Documentation of current process outlining gap flows and recommendation of enhancements.

Creation of test, validation and production environments along with an underlying directory structure to handle the incoming and outgoing import / export files with archive capabilities. Before this process was performed manually.

Developed cross application communication among Visual Basic for Applications, MS-Access, Excel, MS Word, and MS Outlook components using VBA.

Separation of the MS Access file into application and data files and porting the environment onto the network drive with the application file residing on the local desktop.

Schering – Plough

September 1997 to May 2005

Lead Analyst

Responsible for co-development and maintenance of CAVIAR Computerized Adverse Event Information, Analysis and Reporting system, a client-server based computer system designed to facilitate the entry, tracking and reporting of data related to Adverse Events (AEs). It was developed in-house and customized for use within SPRI by the Research Information Services (RIS) department. It is currently being utilized by the Drug Safety Surveillance/Medical Services (DSS/MS) department of Schering-Plough at multiple Schering-Plough sites, including the Springfield and Kenilworth, New Jersey facilities and international subsidiary facilities. The current Database is developed in ORACLE version 8.1.7 and the front end of the application is developed in MS Access 8.0 version and converted to Access 10 (XP) in 2004.

Wide range of abilities that includes interface design to relational database analysis & design

Extensive knowledge of Form and Report design with heavy use of Visual Basic for Applications in data manipulation, retrieval and reporting.

Developed stored procedures, functions and triggers for Oracle as well as Query objects in MS-Access. Formulate SQL statements of varying complexity to access data from / within the server side. Also frequent implementation of the SQL Pass-Through query methods of querying the Oracle database for better performance results.

Good overall knowledge of all phases of the software development life cycle (SDLC) from conception to deployment, including user training, maintenance and documentation. Detailed working knowledge of the Design, Implementation and Testing phases of SDLC. Creation of System Design Specifications, Unit Test scripts and IQ/OQ documentation. Limited URS / FRS documentation involvement in a validated environment.

Worked closely with the Quality Assurance team to define testing efforts and deliverables for projects requiring validation within Pharmacovigilance Systems Business Unit.

Development and enhancement of manual validation scripts during the Development, System Integration, User Acceptance and Production environments as part of the System Development Life Cycle strategies.

Developed cross application communication among Visual Basic, MS-Access, Excel, MS Word, and MS Outlook components using VBA.

Flexibility in performing multiple roles to support an organization’s business process, from communicating with end users and understanding their needs to writing technical documentation and test plans.

Proven troubleshooting and research skills for developing successful solutions to users’ problems, as well as the ability to provide workarounds if solutions are inadequate.

Responsible for conversion of the application from Microsoft Access 98 to Microsoft Access 2002

THINK NEW IDEAS

January 1997 to September 1997

Rapid Application Developer

Responsible for the development of Model Designer application.

Model Designer is used to enter database definitions, dimension definitions, multidimensional data, functions and calculation rules. It is used to map analysis space to the relational Data Warehouse. This application outputs Model Definition files that are used to define and build the Business Model on the server. The objective of this application is a high-level model of the business using terminology readily comprehended by executives as well as analysts.

All forms, reports, modules, macros and queries were developed in MS Access 2.0 and MS Access 97 database environment.

DLB SYSTEMS

September 1994 to January 1997

Sr. Software Engineer

Responsible for co-development and project leadership of Field MONITOR a field-based clinical trials management system designed to run on laptop computers. This system allows the user to enter, update, query and report on clinical trials information during the planning, initiation and monitoring stages. It also has built-in mechanism for storing and retrieving text to allow all the associated study documentation to be accessed electronically.

Field MONITOR is a child system of MONITOR (Clinical Trials Management System developed in ORACLE) and focuses around the trip report performed by the Clinical Research Analyst.

Most of the functionality of Field MONITOR is inherited from the MONITOR system which involved the knowledge of ORACLE*Tools and ORACLE relational database. The major difference is Field Monitor’s graphical user interface and operation under Microsoft Windows environment.

All forms, reports, modules, macros and queries were developed in MS Access database environment.

RUTIGLIANO & ASSOCIATES

June 1994 to September 1994

Consultant

Responsible for the development and implementation of a Telecommuting Survey for the AT&T Law Division offices in New Jersey. This application gathered information from hand written survey questionnaires producing reports based on different response categories by AT&T employees. This information was collected due to Clean Air Act policies proposed for the state of New Jersey beginning in the year 1995.

All forms, reports, modules, macros and queries were developed in MS Access database environment.

AUTOMATED CONCEPTS INC.

May 1993 to June 1994

Consultant

Responsible for the development of an Accounting Information System for the Division of Alcoholic Beverage Control Department for the State of New Jersey.

The on-line data entry accounting application allows the various ABC bureaus to capture all financial transactions relating to the posting of license fees, adjustments and returns.

The application allows for daily reconciliation of all moneys collected and reported to the Department of Treasury. The client can select and execute all reports from their location and generate any report necessary to validate input transactions and document accounting audit trails.

This system has replaced a manual process and fully automates the accounting needs for the Client. This improved method of processing will allow for faster processing of applications and permit requests and provide management with timely reports as needed.

The applications software was developed using Oracle 6 and its related tools and is maintained by OTIS.

Using Microsoft Access developed and implemented an in-house Hardware/Software Inventory system for SONY Electronics Inc.

This system keeps track of all hardware and software data gathered from numerous region offices in the US.

All forms, reports, modules, macros and queries were developed in MS Access using the ODBC connectivity to manage data flow from the SYBASE server.

Developed and implemented an in-house Hardware/Software Inventory system using Microsoft Access.

This system keeps track of data of all hardware, software and technical manuals, which is located on the SQL Server database.

All forms and reports developed in MS Access using the ODBC connectivity to manage data flow from the SQL server.

Performed major modifications to the existing recruiting system, designed using Microsoft Visual Basic. Responsibilities include modification of forms and Visual Basic Code to meet the standards of the ACI's New Jersey region office.

PRUDENTIAL REALTY GROUP

June 1991 to April 1993

Programmer/Analyst

Developed and implemented a Dynamic/Five Year Forecast system integrating such Oracle Tools as SQL*PLUS, SQL*FORMS, SQL*REPORT WRITER and PL/SQL.

This system captures information supplied to us in a file format by an outside vendor. It is later used in a Portfolio Analysis, which includes projected numbers over the term of 30 years.

Developed and implemented a BOMA (Business Office Managers Association) application integrating such Oracle Tools as SQL*PLUS, SQL*FORMS, SQL*REPORT WRITER and PL/SQL.

This system collects information on office buildings in the U.S., tabulates it and distributes the information to all members of the Association. Data is divided into information on specific buildings and how they compare to buildings with similar location/size/age.

Developed Property Manager Performance and Market Value/NOI applications, integrating such ORACLE Tools as SQL*PLUS, SQL*FORMS, SQL*REPORT WRITER and PL/SQL. Involved as a team member in the development of a Far Summary of Property and Accounts applications integrating ORACLE Tools mentioned above.

PRUDENTIAL SECURITIES

May 1988 to June 1991

Programmer/Analyst

Designed, coded and implemented an Accounting Reconciliation System using SQL*FORMS, SQL*PLUS and SQL*REPORT.

System tracks and reports Daily, MTD and YTD Profit and Loss figures for the firm.

Designed, coded and implemented a Daily Call Sheet System using SQL*FORMS, SQL*PLUS and SQL*REPORT. System produces reports, which are distributed to senior management identifying potential risk to Prudential Securities for all government securities transactions.

Designed, coded and implemented a Prudential Securities / Thomson McKinnon conversion system using Dbase III Plus. System functionality included capture and analysis of all Thomson McKinnon personnel for comparison to Prudential Securities personnel with respect to job function.

EF HUTTON & COMPANY INC.

September 1986 to April 1988

PC Programmer/Analyst

Designed, coded and implemented complex brokerage applications for users within Trading Operations using Dbase III Plus, Symphony and Lotus 1-2-3. Acted as the liaison to the Trading Operations Managers, providing system solutions to meet business information requirements. Provided PC training and support (25 PC's and peripherals) for all level of users.

MICROBYTE SYSTEMS

January 1986 - December 2015

(President / Owner)

MicroByte Systems specialized in providing computer automation and support across different types of business industries.

Some of the customers included the following:

PIER Trucking (Transportation and warehousing industry)

European Day Spa (Health and Wellness)

Spa Rejuv (Health and Wellness)

Polmar Iron Works Inc. (Architectural Metal Fabrication)

Responsible for network management, software development and database administration.

Custom development, installation, maintenance, and use of computer software, systems, and networks including installation / coupling of RJ45 and Ethernet cables.

Implementation of email, database and file servers.

Configuration of routers firewalls, routing protocols, and switches.

Troubleshot, repaired software and hardware problems on PCs, laptops, workstations and printers.

Consulted individuals and groups on computer equipment needs and recommended upgrade options.

Support and deploy, Windows 7, Windows 10, Windows XP, Microsoft Office and other office environment software and security based applications.

Deployed, managed and administered Microsoft Server 2003 and its network infra-structure.

MOST RECENT COURSES/Conferences:

Impact of ICH Standards on Adverse Event Reporting Sept. 1999

Electronic Adverse Event Reports Using MedDRA Workshop Dec. 1998

DIA Conference June 1998

ICH Medical Terminology and Electronic Standards May 1998

Using Power Builder Workshop - August 1993 (Automated Concepts)

Introduction to UNIX - August 1993 (Automated Concepts)

Introduction to C Language - June 1993 (Chubb Institute)

Microsoft/Advisor Developer Conference – Nashville – June 1997

Oracle Courses

Develop PL/SQL Program Units - Oracle Corporation Jan. 1999

Windows’95 Architecture for Developers-CHUBB Institute Nov. 1998

SQL*FORMS V4.5: May 1996

Introduction to PL/SQL June 1991

SQL*FORMS V3.0: New Features for the Experienced Dev. June 1991

Adv. Techniques for SQL*FORMS 3.0 & SQL*ReportWriter Sept. 1992

EDUCATION:

St. Peter's College (1986) - BS, Computer Science,

Minor in Mathematics

Contact this candidate