Resume: Sven Davis, Consultant

Access, Adabas, Datacom, DB/2, DB2/UDB, DBase III+/IV, DMS, Focus, IDMS, IMS DB/DC, Oracle, SQL Server, SYBASE, Teradata, Total/TOTL, VSAM.

ABAP/4, Abend-Aid, Activex, Ada, ADSO, Advantage GEN, AIX, APS, ASP, AutoCAD, BAPI, BASIC, BMS, Brio, Business Objects, C/C++, CBD, CICS, CLIST, COBOL I/II/III, COBOL/370, COBOL/400, Cognos, CONSTRUCT, Cool:Gen, Crystal Reports, Delphi, DL/I, DYL-280 II, Easytrieve Plus, Excel, Focus, FORTRAN, HTML, IDEAL, IEF, Impromptu, Informatica, NQuire, Java, Lotus Notes, MapInfo, MathCAD, MicroFocus Cobol, MS Office, MS Project, Natural/Natural 2, Omni/SQL, Oracle Forms, Oracle Reports, PASCAL, Platinum ERWin ERX, PL/1, PL/SQL, PowerBuilder, PowerConnect, PowerPlay, PowerPoint, Process Designer, QBE, QMF, QUIKJOB, REXX, RPG III/IV, SAPScript, SAS (BASE), SAS/Connect, SAS/GRAPH, SAS Macro, SAS/SQL, SAS/STAT, SCOBOL, SPUFI, SQL, SQL*Plus, TOAD, Transact SQL, Visual Basic, VB.NET, VBA, Visio, Visual Studio.NET, XML.

Sven Davis has extensive experience with a wide variety of 2GL, 3GL and 4GL's. His DBMS experience spans mainframe, mid-range, and client-server platforms. Mr. Davis' specialized experience includes business operations, workflow, and optimization and needs analysis. He has developed and implemented enterprise systems for clients in the following industries - aerospace, energy generation, engineering, logistics, banking, education, finance, government, insurance, manufacturing, medical, retail, shipping, and transportation. His general experience is in engineering. He has worked on projects ranging from telecommunications satellites to energy-independent housing units. His vocation is his avocation - making things work!

Bank of America, Charlotte, NC 2009 - 2010

Participated in the Basel II project. Designed business intelligence tools to provide comprehensive accounting information processing for the suite of fiscal products, increased source systems utilization, profit center operations, regulatory reports, and improve decision support systems in a datawarehouse environment. Created and implemented database objects, improved data quality, ETL (Extract, Transform and Load) process flows, and business intelligence tools, using Oracle 10g and native utilities, PL/SQL, Unix/Windows Shell Scripting, SQL, Transact-SQL, Teradata SQL and Teradata native utilities, Access, SQL Server, and VBA

Conoco-Phillips, Bartlesville, OK 2008 - 2009

Participated in the Capital Management System (CMS) II project. Designed business intelligence tools to provide comprehensive accounting information and product tracking, increase profit center operations, and improve decision support systems. Created and implemented database objects and business intelligence tools, using Oracle PL/SQL and Business Objects (SAP) Crystal Reports XIR2.

FireHorse Inc., Multiple locations in the U.S. 2003 - 2008

Involved in strategic short-term projects for FireHorse Inc.' clients. The industries involved included: energy generation, logistics, shipping, and transportation. Skills used: Cognos, Crystal Reports, DB2, ERWin, MS Office, Oracle, Oracle Forms, Oracle Reports, Perl, PL/SQL, Process Designer, SQL, SQL Impact, SQL*Loader, SQL*Plus, SQL Server, Teradata, TOAD, UNIX and UNIX shell scripting, Visio, Visual Basic, Windows and Windows scripting.

DFAS, Fort Benjamin Harrison, IN 2000-2003

Created interfaces to provide standardized and consistent reporting for the U.S. Army and Department of Defense agencies. Compartmentalized and streamlined the processes and procedures. Provided training in SQL and PL/SQL for Report Writing to end users and peers. Performed SQL tuning for better system performance. Developed software to enhance project goals. Performed DBA and QA functions. Performance-tuned all reports and processes for end of Fiscal Year Reporting, reducing processing time from 3 days to less than 5 hours. Skills used: Brio, Cognos, EDI, Embarcadero Entity-Relationship (ER) Studio, Essbase, FTP, SQR, Microstrategy, MS Office, Oracle, Oracle Forms, Oracle Reports, PL/SQL, Pro*C, Pro*COBOL, Process Designer, SQL, SQL Impact, SQL*Loader, SQL*Plus, SQL Server, Teradata, TOAD, UNIX and UNIX shell scripting, Visio, Visual Basic, VBA, Windows and Windows scripting.

UCLA Medical Center, Sylmar, CA 2000

Designed and developed Aftercare in Oracle. Performed the business operations, workflow, optimization, and needs analysis. Performed the data analysis, modeling, and mapping using Designer and Developer 2000, as well as ERWin. The data entry screens were Oracle Forms. The reports were Oracle Reports and SQL*Plus. Integrated data from Access prototypes and hard-copy patient records. Designed aftercare to be scalable and expandable (breadth and depth). Identified issues to be resolved in future modules and scope expansions. Skills used: Access, Activex, Brio, Crystal Reports, DB2, DTS, ERWin, Essbase, Excel, FTP, HTML, Java, Lotus Notes, Microstrategy, MS Office, MS Project, Oracle, Oracle Forms, Oracle Reports, PL/SQL, Powerpoint, SQL, SQL*Plus, SQL Server, Transact SQL, UNIX, VB (Visual Basic 6), VBA, Windows NT Server, Windows and Windows scripting.

BAX Global, Irvine, CA 1998-2000

Participated in the migration from mainframe to Oracle Financials. Customized the oracle tables to meet BAX's needs. Extracted the business rules from existing applications and translated them for Oracle. Applied the masking, editing, and constraints. Set up the alarms and the user prompts. Normalized and improved data quality controls of the accounts receivable (AR) and MSA accounting systems before extracting, transferring, and loading the oracle tables using SQL Loader. Designed custom reports and forms to add functionality to the oracle financials implementation. Skills used: Access, Adabas, Brio, Cognos, Crystal Reports, DTS, ERWin, Essbase, IMS DB/DC, Microstrategy, MS Office, Oracle, Oracle Forms, Oracle Reports, PL/SQL, Process Designer, SQL, SQL Impact, SQL*Loader, SQL*Plus, SQL Server, Teradata, TOAD, UNIX and UNIX shell scripting, Visio, Visual Basic, Windows and Windows scripting.

Burbank-Glendale-Pasadena Emergency Response System, CA 1993-1997

Involved in the collaboration of efforts involving local, state, and federal agencies, to provide a comprehensive emergency response system. Migrated data from various platforms; enforced referential integrity and normalization; implemented federal and county regulations, and integrated the data from several jurisdictions into the existing Geographic Information System (GIS). This led to more timely emergency response efforts and greater safety for emergency workers. Skills used: Access, Adabas, Cognos, Crystal Reports, DB2, DTS, ERWin, IMS DB/DC, MS Office, Oracle, Oracle Forms, Oracle Reports, PL/SQL, Process Designer, SQL, SQL Impact, SQL*Loader, SQL*Plus, SQL Server, Teradata, Teradata Utilities (BTEQ, FEXP, FLOAD, MLOAD, PMON, TPUMP), TOAD, UNIX and UNIX shell scripting, Visio, Visual Basic, VSAM, Windows and Windows scripting.

Member number:10017
Additional Contact information is available on the Information Page.
Software Contractors' Guild (www.scguild.com)
Copyright(c) 1995 - 2009 Sven Davis, FireHorse Inc., and Software Contractors' Guild, Post Office Box 257, Nottingham, NH USA 03290-0257

Sven Davis

FireHorse, Inc.