|
Sven H. Davis |
|
|
FireHorse, Inc. | |
|
5190 Neil Road, Suite 430, Reno, NV 89502 | |
|
(702) 403-9207 cell | |
|
www.firehorse-inc.com sven_davis@yahoo.com
| |
|
| |
|
| Title: | Teradata Data Warehousing Analyst
|
| |
|
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 client 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!
| |
|
Some of the services Sven Davis provides include: | |
|
| | • | | | Setting up Teradata, Oracle, and other databases |
|
|
|
| |
|
| | • | | | Setting and tuning system parameters |
|
|
|
| |
|
| | • | | | Tuning the operating system, network, and transaction processors to work with the DBMS |
|
|
|
| |
|
| | • | | | Installing new DBMS versions and applying maintenance fixes supplied by the DBMS vendor |
|
|
|
| |
|
| | • | | | Ensuring appropriate storage for the DBMS |
|
|
|
| |
|
| | • | | | Enabling the DBMS to work with storage devices and storage management software |
|
|
|
| |
|
| | • | | | Interfacing with any other technologies required by database applications |
|
|
|
| |
|
| | • | | | Installing third-party DBA tools |
|
|
|
| |
|
| | • | | | Traditional operations monitoring and reporting |
|
|
|
| |
|
| | • | | | Database performance analysis, corrective action, proactive tuning, maintenance, administration and backup and recovery across the entire database application infrastructure |
|
|
|
| |
|
| | • | | | Data architecting and data modeling as needed |
|
|
|
| |
|
| | • | | | Setting up database environments, instances, database hierarchies, journaling, tables â�â�œ permanent, volatile, global temporary, etc., indexes â�â�œ UPI, NUPI, USI, NUSI, PPI, JI, AJI, HI, etc., and maintaining statistics to support the optimizer |
|
|
|
| |
|
| | • | | | Setting up users, roles, profiles, accounts, rights, and privileges |
|
|
|
| |
|
| | • | | | Setting up triggers, macros, views, stored procedures, UDFs, UDTs, and UDMs |
|
|
|
| |
|
| | • | | | Use repeatable practices to ensure data availability, integrity and security, recover corrupted data and eliminate data redundancy, and leverage database tools to improve database performance and efficiency |
|
|
|
| |
|
| | • | | | Create and maintain database instances, develop and update database build procedures to minimize required maintenance and manual intervention |
|
|
|
| |
|
| | • | | | Design and manage backup and recovery procedures |
|
|
|
| |
|
| | • | | | Design and manage job scheduling, housekeeping, monitoring, and reporting procedures |
|
|
|
| |
|
| | • | | | Design and manage troubleshooting/exceptional procedures such as handling hot AMPs, crashdumps, slowdowns, connectivity EAI issues, etc. |
|
|
|
| |
|
| | • | | | Installing and administering ERP, CRM, and SCM application packages |
|
|
|
| |
|
| | • | | | Developing and implementing Activity-Based Costing (ABC), Active Data Warehousing (ADW), Enterprise Data Warehousing (EDW), Data Warehouses (DW), Data Marts (DM), Decision Support Systems (DSS), Executive Information Systems (EIS) including dash-boarding, Integrated Data Repositories (IDR), Integrated Data Stores (IDS), Operational Data Stores (ODS), and Application Data Stores (ADS) |
|
|
|
| |
|
| | • | | | Encouraging and leading Data Governance (DG) and Data Stewardship efforts |
|
|
|
| |
|
| | • | | | Encouraging and leading Configuration Management (CM) and the adoption/creation of enterprise-wide IT and process standards (Best Practices) |
|
|
|
| |
|
| | • | | | Developing documentation of database information, methods, procedures, tasks, and standards. |
|
|
|
| |
|
| | • | | | Compliance with CMMI/Six Sigma standards. |
|
|
|
| |
|
Experience
| |
|
• FireHorse Inc. Multiple locations in the U.S. 2003 â�â�œ present | |
|
Involved in strategic short-term projects for FireHorse Inc.�s clients. The industries involved included: energy generation, logistics, shipping, and transportation. Skills used: Cognos, Crystal Reports, DB2, ERWin, Informatica, 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.
<;br> | |
|
• 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, Informatica, Microstrategy, MS Office, Oracle, Oracle Forms, Oracle Reports, PL/SQL, Pro*C, Pro*COBOL, Process Designer, SQL, SQR, 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, Informatica, 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, Informatica, 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, Informatica, 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.
| |
|
| Education: | BS Electrical Engineering, California State Polytechnic University, 1992
|
| |
|
| Professional Training: | Teradata Certified Professional |
| |
|
| Teradata Certified Implementation Specialist |
| |
|
| Teradata Certified SQL Specialist |
| |
|
| Advanced Teradata Certified Professional |
| |
|
| Teradata Certified Administrator |
| |
|
| Teradata Certified Design Architect |
| |
|
| Teradata Certified Application Developer |
| |
|
| Teradata Certified Master
|
| |
|
| RDBMS: | Access, Adabas, Datacom, DB/2, DB2/UDB, DBase III+/IV, DMS, Focus, IDMS, IMS DB/DC, Oracle, SQL Server, SYBASE, Teradata, Total/TOTL, VSAM.
|
| |
|
| Software: | 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, VB (Visual Basic 6), VB.NET, VBA, Visio, Visual Studio.NET, XML.
|
| |
|
| |
|
Member number:10017
Additional Contact information is available on the Information Page.
Software Contractors' Guild (www.scguild.com)
Copyright(c) 1995 - 2008 Sven H. Davis, FireHorse Inc., and Software Contractors' Guild,
Post Office Box 257,Nottingham, NH USA 03290-0257
| |