SQL Server, SSIS, Java, VBA
Resume:
617-***-**** (Cell)
603-***-****(Home)
******@*****.***
Marina Geller
Technical Skills
Java, Visual Basic, VBScript, JavaScript, HTML, XML, CGI, SQR
DBMS
SQL Server, Oracle, Sybase, MS Access
OS
Windows, DOS, Open VMS
OTHER
ERWin/ERX, Crystal Reports, MS Word, MS Excel, PCAnywhere, InstallShield, MS Project, Visual InterDev, FrontPage, Hyperion, BJS, Hive, Pentaho
OBJECTIVE: Database Developer/DBA
Experience
Epsilon, Wakefield, MA, Sr. Database Developer 01/2010-01/2017
Projects:
Industry: Marketing
*Applied technology: Oracle (7, 8i, 9, 10g) SQL Server (2000,2005,2008), SSIS, Java, Excel VBA
Implementation and support of Mid-Market clients` marketing databases (SSIS, Java, C#, T-SQL, PL/SQL).
SQL Server and Oracle development – procedures, triggers, functions, scripts.
Consulting and troubleshooting for multiple clients / account teams.
Research and evaluation of ETL tools such as Pentaho, Talend, etc.
Research of BigData tools – Hadoop, Hive.
Training of newly hired developers.
Equifax, Wakefield, MA, Sr. R&D Database Developer/DBA 09/1998-01/2010
Project listing:
Industry: Marketing
*Applied technology: Oracle (7, 8i, 9, 10g), SQL Server (7, 2000, 2005, 2008), Sybase 11, Access, Excel, SQR, Broadbase, Brio (Hyperion), VB, Java, ErWin.
Database design, implementation, maintenance, development. Triggers, packages, procedures, sequences. Data loads using SQL Server DTS and Oracle Sql*Loader.
Designed and developed a significant part of the standard ETL system for the company in Java. The system works against Oracle and SQL Server databases.
Standard reports in Brio (Hyperion) and SQR against SQL Server and Oracle databases. Ad hoc reports and extracts against Oracle, SQL Server, Sybase, and Access.
Developed mailing campaign automation using SQR against Sybase database. Wrote open VMS scripts. Worked on improvement of existing SQR code maintainability and performance optimization.
Converted an API application from Windows 95 to Windows NT.
Developed application prototypes using VB and Java.
Wrote code-generating macros in MS Excel and MS Word.
Infrasoft North America, Inc. Danvers, MA, Sr. Developer 05/1998–08/1998
Project listing:
Industry: Road Design
*Applied technology: Visual Basic v5, MOSS for Windows v1.3
Project: Automatic Page Layout
This project is a significant part of MOSS drawing system; its goal is to automate the procedure for producing a composite drawing. Application allows user to establish a layout for the blueprints, i.e. a template with viewports, and automatically generate paged plans and profiles from a nominated centerline. Also, user can modify the created layout, add and delete sheets. After the layout is finished it can be saved in the file and used with AutoCAD or MOSS drawing utility.
Personal contributions include design and coding forms, modules, collections, classes, and user controls for this project in Visual Basic v.5 environment. Project specifics require using Windows and MOSS API calls and working with graphics (C and Fortran modules).
Expo International, Inc. Canton, MA, Developer 01/1998–05/1998
Project listing:
Industry: Technical Shows
*Applied technology: Visual Basic v5, Access v7, and Crystal Reports v6.0
Project: Survey System
Application allows exhibitors to collect and process attendees’ information gathered from badges and surveys, generate several formats of output files, and generate dynamic post-show reports. Personal contributions included coding of several modules, report design and implementation using Crystal Reports engine API functions.
*Applied technology: Visual Basic v5, HTML 2, CGI scripting
Project: Web Badge Registration System
Web-based application for show badge ordering. Application generates a data file that can be imported into the badge printing system database and sends e-mail confirmations when badges are sent to the customer. Personal contributions included complete system design and implementation.
*Applied Technology: HTML, CGI, VBScript, Jscript, FrontPage
Designed and developed several dynamic Web Registration pages.
ProSource Systems, Inc. Needham, MA, Developer 05/1996 – 01/1998
Project listing:
Industry: Health Care
*Applied technology: Visual Basic v4, Watcom SQL v4.0, SQLServer v6.5, Oracle v7.0, ERWin/ERX v2.5,
PCAnywhere v7.52, MS Word 97, Excel 97, Crystal Reports v5.0
Project: MCAP
Application allows hospitals, insurance companies, HMOs etc. to use predefined criteria to validate appropriateness of care provided to an individual during hospital stay. Personal contributions included design of database schema, graphical user interface (GUI), and database access for: Report Wizard, User Defined Report, Report Maintenance, export utilities, and file transfer scripts.
Industry: Computer Hardware Manufacturing
*Applied technology: Visual Basic v4, Access v2.0, SQLServer v6.5, Crystal Reports v5.0
Project: LearnEdge
Training Administration application designed to automate and manage training functions. Personal contributions included GUI, database access functionality, reports, updated system workflow, and business rule implementation.
Industry: Custom Software Development
*Applied technology: Visual Basic v4, Access v2, ERWin/ERX v2.5
Project: Phoenix
Designed and developed a software application to support administrative functions. The application manages all employee personal information, project assignment status, and cost analysis formulas. Individual contributions included database design, GUI design, workflow design, functional and technical documentation.
Khabarovsk State Technical University, Russia, Instructor / Developer 1980 - 1996
Industry: Education
*Applied technology: Access v1, SuperCalc v4, Time-Line v4 and v5
Designed and developed a construction equipment parameters database, demo programs using Time Line macros, calculation tables, schedules, and implementation plans. Provided instruction on use of spreadsheets.
Provided instruction on building construction administration and technology.
Education MS Technology and Economics of Civil Engineering 1978.
Contact this candidate