business Intelligence
Resume:
David Brian Keller
Denver, CO 80111
Education
Texas Tech University, - B.B.A. Management Information Systems, 1996
Lubbock, Texas
Skills and Knowledge
Skilled in using SQL Server 6.0/6.5/ 7.0 /2000/2005/2008, Sybase Adaptive Enterprise, DB2/AS400, Oracle 7/8/9/10 DBMS. Experienced database development using Erwin, Query Analyzer, Infomatica , TOAD, C#, Visual Source Safe, CVS, PCVS, T-SQL, and PL/SQL. Report development experience using Oracle reports, Crystal Reports 8-2008, Business Objects 6.5, Crystal Enterprise/Business Objects 7/8.5/9/10/11/2008 /XI R1, R2, and XI 3.1 Knowledgeable in systems analysis/design techniques and project management. Skilled in working with a wide range of individuals. Able to work in a leadership capacity or in a group.
Professional Experience
AtTech, Denver, (Client: Aurora Loan Services) Jan/2009-Oct/2009
Senior Developer
· Supervised the conversion of Crystal XI, Business Objects 6.5, XIR2 Desktop reports to Business Objects XI 3.1 Desktop and WebXI Intelligence and universes.
· Developed Oracle Packages, stored procedures and scheduled reports for the finance department.
· Developed SSIS/SSRS/SSAS extracts/ MDX reports and stored procedures for financial reporting purposes.
· Developed a reporting front-en using C# and the BO SDK for a user friendly interface.
Compri Consulting, Denver, (Client: Janus Capital) Jan/2007-Aug/2008
Senior Developer
· Converted reports from a PAS accounting system to a Simcorp Oracle database system using Crystal XI,Business Objects 6.5, XIR2, Desktop/WebXI Intelligence and universes.
· Wrote and maintained mappings, sessions and workflows to support a reporting schema. Architected, created and maintained mapplets for reuse by other Informatica programmers. Tuned lookups against tables with 100+ million rows. Sources and targets were Oracle tables and flat files and XML files.
· Developed SSIS/SSAS/MDX SEC reports for the finance department.
· Prepared and executed test plans for all levels of testing.
Buxton Consulting, Denver, (Client: Transmontainge) June/2005Nov/2006
Database Developer
· Researched data integrity problems on a DB2/AS400 system and developed SSRS/SSAS reporting solutions.
· Developed new reports, stored procedures, and assisted junior report writers.
· Managing 400 plus reports for client.
· Administrator of Crystal Enterprise XI R1 and Business Objects XI R2 in a clustered environment.
Open Technology Solutions, Centennial Sept/2003-May/2005
Business Objects Administrator /Developer
· Installed, implemented and maintained Crystal 10 Enterprise as the first generation reporting solution.
· Developed seventy-plus reports and implemented reporting solution though Crystal 10 and a .NET/C# application.
· Developed about 60 Oracle reports for Bellco Credit Union.
· Redesigned a second generation of reports along with a senior .NET developer, using C#.
· Implemented all 75 reports via stored procedures at the back-end.
· Developed DTS Import/Export packages.
ESG Systems, Englewood, (Client: Megastar Financial) Jan/2002-Aug/2003
Database Administrator
· Worked with requirements analysts to determine business information requirements, created logical/physical data designs using Erwin Studio and collaborated with application developers for final design and implementation.
· Maintained and enhanced four MS Access 2000 databases while converting the functionality to a single C# front-end and SQL Server 2000 backend database.
· Developed a set of stored procedures, triggers, DTS packages to ensure data integrity and cleanse data.
· Created and maintained database documentation in HTML 4.0 as development progressed.
· Developed views to encapsulate commonly used data for easier report development.
· Implemented a standard development, QA, and production promotion strategy.
· Identified opportunities for integration and standardization of data.
· Developed logical and physical data model using the Erwin data-modeling tool.
Consultis, Englewood, (Client: Centura Health) Sep/2001-Nov/2001
Database Administrator
· Hired to upgrade one SQL Server 6.5 and two SQL Server 7.0 databases to SQL Server 2000.
· Moved the three databases to a larger server.
· Reconfigured the mail and active server directory services.
· Migrated existing Transact-SQL stored procedures, views, triggers, and indexes to 2000.
· Developed a set of stored procedures to extract data to another system.
· Tested a proprietary application named CACTUS functioned properly on one of the upgraded databases.
· Tasked with improving existing database tables, views, stored procedures, and triggers using T-SQL and Enterprise Manager.
US West, Denver Feb/2000-Aug/2001
Database Administrator II
· Collaborated on clustered hardware configurations for capacity planning and assisted in the selection of viable hardware solutions.
· Reviewed, tested, and released code and support feature propagation.
· Performed Oracle8i-SQL 7.0/2000 installs, upgrades, and relevant service packs on NT/2000 servers.
· Managed server logins and database users and roles.
· Responsible for design and implementation of data migration between disparate systems.
· Performed daily monitoring of all database systems and environments.
· Set up alerts with appropriate notifications.
· Worked with reporting staff to create efficient and timely a decision support system.
· Developed a Delphi financial reporting application for a small set of canned reports.
MCI SystemHouse, Englewood Dec/1996-Feb/2000
Junior Database Administrator
· Developed PL/ SQL queries, generated reports, and supported users with a PowerBuilder sales/marketing application on a Oracle 7.5/8.0 ERP database.
· Additional duties included writing stored procedures, triggers, and database administration duties.
· Developed and maintained database documentation with HTML.
· Maintained growth statistics space forecasts, tape libraries, and hardware/software inventories.
· Assisted System Administer with local/remote data backup and media rotation.
· Provided 24-hour support on issues that involving problems with production databases.
· Responsible for troubleshooting and resolving system (HW, OS, application) issues.
· Assisted in the coordination of network related activities with internal and external contacts.
· Assisted in database security and integrity by evaluating, implementing, and managing appropriate database monitoring software.
· Monitored security setting, auditing of systems, databases, and applications.
Texas Tech University Jan/1992-Dec/1996
Student
U.S. Air Force July/1986-Dec/1990
Aircraft Armament Systems Specialist
Contact this candidate