Sql Server Engineer Developer Oracle .Net Java
Resume:
Timothy McKee
. **** East Phillips Lane Centennial, CO 80122 . ********@*****.*** . 720-
SQL Database Engineer
Professional Summary:
. Experienced Information Technology professional specializing in Oracle
and Microsoft SQL Server database development for 10+ years. Proficient
working with business end-users to understand their requirements as well
as the technical skills to develop the application requests. Detailed full
lifecycle experience in solving important business problems through
technology.
Technical Skill Set Summary:
Oracle Database: Oracle 8-10, PLSQL, Packages, Stored
Procedures, and Database Triggers
Microsoft SQL Server Microsoft SQL Server 2000, 2005, SQL Server
Database: Integration Services (SSIS), T-SQL
Tools: TOAD, Power Designer, ERWIN, CVS, Subversion,
InstallShield 6-10x, Crystal Reports
Methodologies: Agile/Scrum, Rapid Application Design (RAD),
Unified Modeling Language (UML)
Languages: C#, Java (Sun Certified Java Developer),
PowerBuilder Power Script
Web related Technologies: JavaScript, HTML, Themes, XML/XSLT, WSDL, Web
Services
Microsoft Technologies: .NET Framework 2.0/3.5, ASP.NET, C#, ADO.NET,
AJAX Control Toolkit, IIS, Visual Studio
Professional Experience:
Standard and Poor's Centennial, CO 08/06 - 05/10
Application Specialist
. Designed and developed Oracle databases tables, packages, and stored
procedures, and triggers to implement database solutions and statistical
reporting for data quality monitoring of financial researchers. Refined
tables and SQL queries to retrieve data faster and store information more
efficiently. Participated in the analysis and design of the database
schema that holds sensitive financial data.
. Used Microsoft SQL Server suite of technologies (Management Studio, TSQL,
Stored Procedures, SSIS) to implement database solutions to support an
analytical tool for financial professionals. Used Microsoft Report
Definition files to developed reports that compare data between two
financial models.
. Participated in Agile/Scrum activities such as sprint planning and daily
stand up meetings.
. Created Intranet applications using Visual Studio (ASP.NET, ADO.NET, C#,
Microsoft IIS). Modified and converted internal client server
applications programs into the .NET architecture to support comprehensive
fundamental and analysis solutions of company financial data.
. Modified and converted existing client server PowerBuilder applications
programs into Intranet ASP.NET applications.
Bentley Transportation Englewood, CO 04/01 - 08/06
Senior Software Engineer
. Technical Engineer, responsible for architectural design,
implementation, delivery and maintenance/enhancements of customer
products. Created labor estimates on feature development and act as a
technical guide and mentor to other team members.
. Analyze existing Oracle stored procedures and queries for the purpose of
optimizing database application performance. Designed and developed
Oracle and Microsoft SQL Server tables, stored procedures, views,
functions, and triggers to implement database solutions.
. Productized applications utilizing Visual Studio.NET (ASP.NET, ADO.NET,
C#, Visual SourceSafe, Microsoft IIS) for State's Department of
Transportation (DOTs) Right Of Way applications.
. Created Microsoft IIS ASP 3.0 Web applications connecting to Microsoft
SQL Server and Oracle RDBMS for retrieving and updating database
information for (DOTs) Outdoor Advertising applications.
. Created PowerBuilder workflow style applications and Crystal reports
that track parcel information for DOTs.
Electric Lightwave Systems Inc. Vancouver, WA 06/99 - 02/01
Senior Programmer
. Performed applications system analysis and programming activities.
Formulated and defined system scope and objectives to develop and modify
moderately complex telephony and billing information.
. Designed and maintained applications systems using Java, Oracle PL/SQL,
Sybase TSQL, and PowerBuilder.
. Wrote Sybase-stored procedures to retrieve and maintain data within
PowerBuilder applications. Developed Sybase stored procedures, triggers,
and DB-LIB functions to load and validate data for billing packages.
Used ERWIN data modeling tool for synchronization of models, scripts and
databases that support telephony applications.
Development Consultant Denver, CO 09/93 - 04/99
Database/Application Developer
. Designed and maintained applications systems using Java, Oracle PL/SQL,
Sybase TSQL, and PowerBuilder.
. Extended and improved the functionality of a "Bill Of Lading"
application. Used imaging OCX software, developing reports and data entry
windows for shipping and customers billing for an international shipping
company.
. Assisted in the design and development of Oracle/PowerBuilder
applications used to retain land acquisition information for road and
transportation works. Created the database design using modeling tools,
and utilized Microsoft's OLE and DDE to connect to MS Word, MS Excel, and
engineering graphic tools.
. Designed, implemented, and tested database applications for a telephony
user-driven tracking system. Reengineered the Telephony Sales application
into an Oracle/PowerBuilder application, establishing application
standards and providing users the ability to view and update information
from a database that consisted of over 90 tables. Created Oracle tables,
triggers, PLSQL stored procedures, and fine-tuned SQL statements.
. Created a Case Management System for the City and County of Denver, using
Microsoft's Windows NT, Microsoft SQL Server, Erwin 2.0, and
PowerBuilder. Developed windows for users to enter, retrieve, and update
information related to a criminal cases, generating statistical reports.
Refined tables and SQL queries to retrieve data faster and store
information more efficiently. Participated in the analysis and design of
the database schema that holds sensitive criminal data.
. Maintained and enhanced existing applications involving wire order
deposits and trades. Wrote Sybase-stored procedures to retrieve and
maintain data within PowerBuilder applications. Developed Sybase stored
procedures, triggers, and DB-LIB functions to load and validate data.
Part of a team to automate the design, development, and sales of a
yellow pages system. Created user databases, diagnosing system problems,
enhance databases, granted user roles and permissions, enforcing
integrity standards, and backed up and restored Sybase databases.
Defined database objects and structures using the S-Designor CASE tool
Education:
Park University/Bachelor of Science in Management/Computer Information
Systems
Certifications
AmeriTeach
Microsoft Windows Communication Foundation (WCF)
Developing XML Web Services Using ASP.NET
Developing ASP.NET Web Applications
Programming a Microsoft SQL Server 2000 Database
Sun Microsystems
Web Component Development Using Java Technology
Java Programming Language
Sun Certified Java Developer 1.2
United States Air Force
Photo Specialist - Top Secret Clearance
Contact this candidate