Consultants

[ Home | Contents | Search | Post | Next | Previous | Up ]

NickPelts
Contractor Profile

Projects_completed: 11
Experience_in_years: 07
Certifications: NA
Home_office: Cleveland, OH
USD_Rate: 40
per: man/hour
Travel: prepared_to_travel_onsite
Source: Other
Remote Name: 65.43.175.228
Date: 30 Jan 2005
Time: 14:56:17 -0500

Executive_Summary

I have over six years of experience in C#, VB.NET, Visual Basic, Active-X technologies, XML, ADO, OPC, COM/DCOM, ASP.NET, ASP, HTML, XML, JavaScript, SQL Server, Oracle, MS Access, InfoPlus.21, Crystal Reports, Crystal Reports 9 Enterprise, Report Application Server (RAS).

Work_Experience

11/04 – 12/04 Marlboro Manufacturing, Inc. Alliance, Ohio *Developed reports for company’s several departments *Utilized Crystal Reports 9.0 to generate custom reports *Analyzed existing SQL Server databases and performed data mapping of the fields to be used in the reports *Developed SQL Server stored procedures that acquired and returned report data *Developed C# application that allowed company’s managers to input the data that was used to generate reports, modified complex reports at runtime, and displayed the reports *Created XML Schemas that were used to map the report data 7/04 – 11/04 Healthcare Process Consulting, Inc. (HPC). Cleveland, Ohio *Enhanced company’s both production and administration web applications *Optimized existing SQL Server databases for faster data retrieval and processing *Created SQL Server database that stored old and expired data *Developed SQL Server stored procedures that returned data, populated database with new students’ information, moved students’ medical information from the database server to the local server for further processing, and performed maintenance of the database *Utilized Crystal Reports 9.0 to generate reports/forms that contained students’ medical evaluation and were sent to the providers *Developed VB .NET application that provided company’s management with providers’ listing and available service areas that were used to generate reports 2/04 – 6/04 Eberhard Manufacturing Company. Cleveland, Ohio *Developed reports for company’s various departments *Utilized Crystal Reports 8.5 to generate custom reports *Analyzed existing SQL Server databases and performed data mapping of the fields to be used in the reports *Developed SQL Server stored procedures that returned report data *Created scheduling in SQL Server that moved report data to other report specific tables *Wrote several VB.NET and C# applications that used Crystal Reports objects to programmatically modify reports at runtime and displayed the reports 9/03 – 11/03 Nistar Data Systems. Cleveland, Ohio *Enhanced an existing web application for company’s internal use *Utilized Microsoft Visual InterDev to edit and create ASP pages *Performed conversion of MS Access database to SQL Server 6/03 – 7/03 Ernst & Young. Cleveland, Ohio *Developed reports for company’s internal use *Utilized Crystal Reports 9 Enterprise to generate custom reports *Utilized Report Application Server (RAS) to access desired reports and programmatically modify them at run time *Analyzed existing SQL Server databases and performed data mapping of the fields to be used in the reports *Developed SQL Server stored procedures that returned report data *Utilized Microsoft Visual InterDev to create ASP pages that displayed report data on the web using ActiveX control 10/02 – 3/03 Actual PC. Cleveland, Ohio *Developed e-commerce web application for computer manufacturing company *Performed application logical and physical design *Utilized Visual Studio .NET to create web pages and web controls *Developed administration web application that allowed managing of the products, categories, manufacturers of the carried products *Engineered SQL Server 2000 database including stored procedures *Created functionality of exporting all products from SQL Server to CSV file. This file was used for submission to Yahoo Shopping and contained information about the appearance of the entire Yahoo Store 8/02 – 9/02 Everstream. Cleveland, Ohio *Developed reports for Concurrent Computer Corporation *Utilized Crystal Reports 8.5 to generate custom reports *Utilized Visual Basic that was used to acquire report data from SQL Server 2000 and Oracle databases and to display the reports *Performed individual testing of the reports 5/00 – 10/01 ABB Automation, Inc. Cleveland, Ohio Developed enterprise-reporting system for British Petroleum *Experienced in SQL Server 2000 and InfoPlus.21 4.0 programming and administration which involved development of SQL Server and InfoPlus.21 stored procedures and triggers *Utilized Seagate Crystal Reports 8.0 to generate custom reports *Utilized Microsoft Visual InterDev to create ASP pages that acquired and displayed data on the web *Developed various Visual Basic applications that performed modifying of the reports at run time, archiving and printing of scheduled reports, reporting of errors to event concentrating servers, and sending e-mail notifications to operator *Performed individual testing of the reports Developed application that emulated scanners for film coating machine for DuPont *Developed, maintained, and configured Visual Basic application that performed emulation of the scanners and actuators for film coating machine *Utilized OPC and COM/DCOM interfaces for data acquisition and process control *Modified C++ code of an existing OPC server in order for the emulation application to be able to communicate with it 2/00 – 3/00 Binnacle. Cleveland, Ohio *Developed and maintained the migration of Microsoft Access user interface to MS SQL Server database *Integrated Access application with external data mapping software package that was used to generate electronic feed files for further submission to a remote mainframe of a third party insurance company 8/98 – 2/00 Software Infinity. Cleveland, Ohio *Designed and developed Business Information Systems *Participated on four- person team developing sales and marketing software that managed company’s clients, prospects and their interest in products and services *Wrote several Visual Basic applications integrated with customer service and accounting databases *Utilized MS SQL Server database that was used to store data *Wrote conversion application to convert multiple-format MS Access and Dbase databases into SQL Server tables *Wrote 15+ user screens in product/services and contact related areas *Used third party custom controls and other software *Utilized Crystal Reports that enabled users to view and print custom reports *Developed Web interfaces using ASP and ADO objects that allowed to access some system features remotely and do not require any special setup on the user end

Skills

Operating Systems Windows 95/98/2000/XP, Windows NT 3.5/4.0 Server and Workstation Languages C#, VB.NET, ASP.NET, Visual Basic 6.0, C++, ASP, JavaScript, XML, OPC, COM/DCOM Databases SQL Server 6.5/7.0/2000, Oracle 8i, MS Access 95/97/2000/XP, InfoPlus.21 Tools Crystal Reports 9, Crystal Reports 9 Enterprise, Report Application Server (RAS), Microsoft Office, Visio

Education

1993 - 1997 Odessa State University. Odessa, Ukraine B.S. in Computer Science 2002 Cleveland State University. Cleveland, Ohio Additional coursework in C++