Database developer
Resume:
JASON MILLER, MCPS
Downingtown, PA 19335
*********@*****.***
Qualifications
I am a senior database administrator and developer since 1994. I have worked on a number of system development projects and participated in all phases of the development cycle. Technical knowledge and experience includes; extensive data modeling, logical and physical database design, server installation, back-up and recovery, maintenance, triggers, stored procedures, SQL Agents, traces, deadlock resolution, performance tuning, linking servers, ETL (DTS & SSIS) design, user administration and security, Visual Basic coding, Source Safe, ADO, RDO, DAO, Access and Windows. While the majority of my experience has been Microsoft SQL Server based, the past six years I have focused on Linux based MySQL development. Applications background includes several assignments involving financial applications including an assignment at Hyperion Software contributing to their financial modules and reporting applications for UBS Asset Management.
Skills
MYSQL, MICROSOFT SQL SERVER, LINUX, WINDOWS, PVCS, VISUAL SOURCE SAFE. PLUS FAMILIARITY WITH MANY APPLICATIONS AND ENVIRONMENTS.
Experience
Susquehanna International Group (SIG)
December 09 - Present
Developed and maintained Linux ETL shell scripts to populate a geographically diverse distributed reference environment to support thousands of autonomous trading daemons.
Enhanced Pricing Parameters database. Stores pricing parameters from administrative services and supplies relevant requests for quoting engines.
Created archive database for susex traffic. Efficiently stored captured traffic from recorders to an archive database of over 25 billion rows (1-2TB of data weekly).
Responsible for maintaining historical archive of reference data.
Supported development of the tick and quote databases.
Supported internationalization of propriety trading platform.
Support ad-hoc requests for data anomaly analysis.
Conning & Company
July 02 – December 09
Created a compliance engine to verify investment portfolios against our client's trading & compliance guidelines. Engine is completely driven by user selected options, allowing a multitude of possible tests.
Supported IT separation from parent company to new owners and including data model changes necessitated by vendor of investment accounting system.
Complete responsibility for administration and lead developer of Conning's data warehouse.
Design and implementation of log shipping solution for data warehouse.
Planning and implementing hardware, OS and version upgrade to SQL2005 64bit.
Planning and overseeing SQL 2000 to SQL 2005 upgrade.
DB support for Conning’s Client Billing Application.
Conversion for DTS to SSIS, as package changes require.
Maintain and create new loads for addition extracts from CAMRA accounting system.
Developed new routines for reporting procedures per Portfolio Management and Investment Accounting requirements.
Increase efficiency of load routines. Tuning various load processes increased performance by 75%.
Developed system of checks for monitoring nightly batch processes and automating notification via pager.
Ajilon, Inc.
November 01 - June 02
Client: Anthem Insurance Companies, Inc.
Design DTS scripts for data load to vendor, consolidating multiple regions.
Provided information and insight for performance tuning.
Created stored procedures for data cleansing and normalization.
Provided SQL for ad hoc reporting.
Corporate Information Technologies, Inc.
September 99 – October 01
Client: Medspan, Inc.
Complete rewrite and translation of Call Tracking Application from Access to SQL7.
Created stored procedures for calculation of new business bonuses and retention bonuses.
Translated Access data feed process to SQL7 stored procedures.
Created SQL Scripts for comparison of vendor data to internal reference data and for referral/provider analysis.
Client: UBS Asset Management
Responsible for rewrite and update of custom reporting application.
Update SQL Server stored procedures for new accounting rules effecting yields.
Upgrade applications to ADO 2.0, providing seamless connection to SQL Server and DB2.
Functional rewrite of Leased Occupied management application.
Client: Aetna/US Healthcare
Responsible for tuning Sybase stored procedures. The tuning involved rewrites, modification and/or creation of indexes, and rearranging table layouts.
Resolved blocking, locking issues involved with front end member maintenance program.
Tested and researched installation procedures from Aetna's software management.
Client: In House Projects
Design, implementation and support of an application to process data feeds from insurance providers, normalize data, and consolidate data for distribution to clients with a SQL 7 environment.
Supervised and assisted development of an Access database for rate information entry.
Inter*Act Systems, Inc.
December 96 – September 99
Design, implementation and support of pilot program to warehouse (star-join schema) information from the IPN system. Responsibilities included table design and indexing, stored procedure design and tuning, trigger design and tuning. (SQL 6.x)
Determined system requirements, and sizing for pilot server and production server.
Design, implementation and support of a derivative (aggregation, data-mart) of the data warehousing project. Responsibilities included table design and indexing, stored procedure design and tuning, trigger design and tuning. (SQL 6.x)
Enhanced and debugged the front-end (VB 4-32bit) and actively provided support for backend processes (Sybase) for Inter*Act’s OLTP database.
Rewrote the code for the kiosk used through out all chains (greater than 2800 installed copies running) of Inter-Act’s client sites. Continued through three complete product releases.
Corporate Information Technologies, Inc.
December 94 – December 96
Client: ConnectiCare, Inc.
Design, implementation and support of the Concurrent Notes Review System (both user front end VB4-32, and SQL6.0 backend).
Responsible for stabilizing underwriting's employer reporting database. Optimized application’s stored procedures and queries to improve performance.
Client: Asea Brown & Boveri
Developed reporting system using Crystal Reports, PowerBuilder, and Oracle stored procedures.
Responsible for gathering, documenting, and disseminating requirements for the Market Channel Database.
Charged with updating Visual Basic code to version 4.0 in the Order Processor system. Also responsible for bug fixes in Visual Basic code and SQL statements in the Order Processor System.
Client: Aetna Life & Casualty
Charged with coding a Visual Basic application to predefined specifications for the National Accounts Quotations and Proposal system. 3-tier architecture using VB classes and DAO. Responsible for Database class, and multiple user forms.
The database class is responsible for initializing the database, setting up basic database objects, verifying the integrity of the database’s attachments, and automatically reconnecting database tables whose attachments have been severed.
Solution had to be DBMS independent. Transactions used to manually cascade changes and deletions through database.
Client: Hyperion
Completed development of a Process Automation system in Visual Basic 4.0, using DAO and several Windows API calls. A system that allows users to schedule tasks to be run at future dates and assigned dependencies upon other tasks, so that execution would branch upon the success or failure of execution.
Modified Process Automation’s setup program to become a standard, generic setup program.
Client: Ensign Bickford
Designed and built a Request for Bid Proposal system using Visual Basic. System tracks bids as they come in; references EB’s master part number list; creates custom lists for individual clients; and uses Microsoft Access to report on sales statistics generated by the system.
Designed a document storage facility used to upload job control document files into a “database” of information.
Client: Hyperion
Designed and built a system in Excel using VBA for translating Excel Spreadsheets into flat text files for importing into Hyperion Financials system. Validation of data was supported by balancing entries and compensating for discrepancies by adjusting a “Suspense account”.
Optimized SQL pass-through queries gathering data from database and created reports based on this information.
Client: Fleet Bank
Was a member of a team responsible for developing a Loan Scrub System to check commercial loan portfolios for errors, omissions, and inconsistencies. Loan data was verified against and compared to data residing on a mainframe.
Did extensive SQL coding for database updates and retrieval.
Debugged and modified code using Microsoft Access.
Client: ConnectiCare
Accountable for design, development, implementation and on-going support of several Insurance database development projects.
Performed initial information gathering and worked closely with the client area to ensure business requirements were satisfied. Projects were completed using Access, Excel and Word, and included Small Business Plan Quoting System, Workers Compensation Case Management System and Provider Directory System.
Metro Realty Group, Ltd.
May 93 – November 94
Responsible for the development of BITS, a commercial real estate Asset and Facilities Management Database.
Maintained a Novell NetWare operating environment and produced detailed financial analysis spreadsheets utilizing Microsoft Excel.
Education
Commenced: Rochester Institute of Technology B.S., Computer Engineering
Central Connecticut State University B.S., Computer Science, graduated August 2009
Contact this candidate