DATABASE DEVELOPER DATA ANALYST

Enthusiastic extraction, manipulation, analysis and reporting of data from SQL Server, Access and Oracle database back ends of legal, health insurance, finance, or other applications. Reporting for financial, regulatory, marketing, and business analysis purposes. Database design and application development, as well as some SQL Server administration.

TECHNICAL SKILLS:

• Languages: T-SQL, Access VBA Visual Basic for Applications
• Excel VBA, PL/SQL, NT shell, VBScript, Perl, awk, bash, Korn shell, C , C, XML, HL-7
• Applications: SQL Server 2008, 2005, 2000, 7.0, 6.5 Access 2010 - 2.0 Excel 2010 - 97 SSRS Ringtail
• Oracle 9i 9.2, Oracle 8i 8.1.7 Word 2010, 2003, 2000, 97 Visio Crystal Reports 10 Sharepoint Acrobat IAC SyncSort FoxPro Alpa4 R/S 1 Lotus 1-2-3 WordPerfect CODA Hyperion Pillar QuarkXPress DesignCAD 3D
• Operating Systems: Windows XP, 2000, NT 4.0, NT 3.51 Server 2008, Server 2003
• Windows Vista, Windows 7, Unix, MS-DOS, Macintosh, VMS, RT-11

PROFESSIONAL EXPERIENCE:

Confidential

• Data Analyst and SQL Server Developer processing legal document data and metadata.
• Wrote and modified SQL queries and t-SQL stored procedures in order to manipulate, analyze and report on document data and metadata obtained through electronic discovery and stored in the Ringtail application, with SQL Server as a backend. Some databases contained tens of millions of documents, with hundreds of millions of pages. SSRS was used for reporting, with reports placed on Sharepoint to be run ad hoc or distributed using email subscription. Excel was also used for reporting.
• Loaded raw and previously produced documents into the Ringtail application, and also prepared productions for export using Ringtail. Custom modifications to the process were performed with t-SQL.

Confidential

• Data Analyst and Developer for a medium-size health insurance company.
• Wrote SQL queries and t-SQL stored procedures, including UDF's and triggers, for extracting and analyzing demographic, claims, and financial data stored in two SQL Server based outside vendor applications one for provider information, one for member and claims information . This data was used for regulatory submissions, marketing, and business analysis. Reporting was through Access, Crystal Reports, or Excel.
• Developed of various Access / SQL Server applications, including one for sales commissions based on information in the member database, and one for mapping and transferring member information using HL-7 to an outside vendor's web-based system used in our outpatient centers.
• Converted data from original Access sales commissions system for load into later outside vendor system and validated results. Designed UAT each time this system needed to be configured for new commission plans.
• Data was often exported to Excel and analyzed using grouping, subtotals, pivot tables and worksheet function formulas. Occasionally, Excel VBA was used, as for a user interface for agent ownership of cases.

Confidential

Developed an Access application for Revenue reporting that integrates and analyzes various billing, production, and accounting spreadsheet data feeds. Client was a large, financial printing company.

Confidential

• Start-up company developing both electronics used in chip manufacture and new electronic devices.
• Developed and designed new products, including market research and patent writing.

Confidential

• Systems programmer for a software start-up company focused on developing and marketing a new, innovative database management system. Initially aimed at the data warehouse market, the product was designed to use novel data structures and algorithms to offer increased query speed with decreased storage requirements.
• Analyzed, manipulated and transformed data for use in the development of product prototypes using internal programs in addition to SQLServer and SyncSort.
• Conducted tests comparing product storage space and performance to that of SQLServer and Oracle databases.
• Conducted tests of validity of data after processing by prototype database.
• As a member of the research group, participated in writing patents and examining other patents and relevant literature to ensure our product was unique and did not infringe on any existing patents.
• Technologies used included Windows 2000, SQLServer 2000, Oracle 8i, Oracle 9i, Cygwin, bash, and Office 2000. Access, Excel and VBA used for front end and for performance analysis and reporting.

Confidential

Hired as Assistant Treasurer and later promoted to Assistant Vice President.

• Supported 80 members of the North America Finance group of DrKW, a major international finance and banking institution. Support also included troubleshooting desktop PC, application and server issues. Developed and maintained Access VBA and Excel VBA applications. Excel was often used to analyze extracted data.
• Responsible for development and maintenance of Financial reporting, external interfaces and download applications for the Oracle-based CODA Financials general ledger, including regulatory and tax reports.
• Developed applications for CRS Credit Reporting System and for the Private Equity group.
• Upgraded existing programs and tested to ensure that they were Y2K compliant.
• Performed maintenance and upgrades for CODA, including comparison of reporting between earlier and later versions, in addition to other vendor-supplied applications as well as providing local support for applications developed by the London and Frankfurt offices.
• Upgraded in-house developed applications for Oracle 8.

Confidential

• Developed financial and management reports for use with the CODA Financials General Ledger System.
• Utilized Access as an ODBC front end with CODA data stored in Oracle 7.1 tables in a Windows NT client-server environment. Share- and user-level security were used. The reports and forms developed involved extensive use of queries, modules Access Basic and Visual Basic for Applications VBA , macros, and tables.
• In addition, Access was used to develop a more flexible type of executive information system / report writer to allow users to produce specialized reports over time.
• Developed Access applications to process mainframe downloads from the FISTS fixed income trading system for German head office reporting as well as from the ANLOS General Ledger for tax reporting.

Confidential

In a consulting capacity, developed parts of a system to enter and report on orders, sales, depletions, and inventory for an international liquor importer. Gained extensive experience with queries QBE, SQL, and dynamic , reports, modules Access Basic , and tables, in addition to experience with forms and macros.

Confidential

• Managed mailing list and product sample request databases, including reports Alpha4 and FoxPro .
• Desktop publishing of the newsletter itself, including layout, copyediting, and proofreading. QuarkXPress

Confidential

Used awk and Korn shell scripts in a Unix environment to train and test a FORTRAN neural network simulation of primate visual system motion processing, including three-dimensional structure from motion.