Technical Lead Resume Profile
Information Systems
Experience: 18 years
Professional Focus
- Database Development
- Business Intelligence
Business Experience
- Financial Services
- Banking
- State Government
- Education
- Retail
- Medical Billing
- Wholesale/Distribution
Database Platforms
- SQL Server 2012,2008,2005,2000
- IBM DB2 z/OS, AIX, iSeries
- ORACLE 11g, 9i
- Informix
- Sybase Adaptive Server
- MS Access
Business Intelligence Tools
- Microsoft SSRS Reporting Services
- Microsoft SSIS Integration Services Microsoft DTS
- Microsoft SharePoint
- Microsoft PowerPivot
- Microsoft Excel
- SQL Server Data Tools
- Visual Studio/BIDS
- Microsoft Report Builder
- Business Objects Enterprise
- Crystal Reports
Database Tools
- SQL Server Management Studio Toad
- WinSQL
- Quest Central for DB2
- AQT
- RedGate
- PowerDesigner data modeler Sybase Central
- Visual Explain
- DB2 Connect
Source Control/Change Management
- Microsoft Team Foundation Server
- Git, Seapine Surround SCM
- Visual Source Safe
- Endeavor, CA-7, Panvalet
Summary of Professional Experience
- Experienced in all aspects of the Software Development Life Cycle including, gathering and documenting business requirements developing technical design artifacts data modeling engineering/programming solutions performance tuning post-implementation review.
- Strong analytical and problem solving skills.
- Proven experience identifying, recommending and implementing cost effective solutions to business problems.
- Strong written and verbal communication skills.
- Comfortable working in a project team or independent work setting.
- Experienced in multi-level reporting from project team through executive management.
Professional Highlights
- Serving as the technical lead, managed a team of developers employees, contractors and off-shore resources implementing a 3rd party on-line banking product.
- Proposed, designed and implemented an Enterprise Data Warehouse serving central and remote office reporting, ad-hoc inquiry, ETL processes and front-end business systems.
- Proposed, designed and implemented a testing/QA and documentation system to assist centralized and remote developers working with database stored procedures, functions and views.
- Designed and implemented a multi-dimensional multi-terabyte database to support a Hyperion based Enterprise wide Budget and Planning solution.
- Identified, installed and trial tested database development, monitoring and performance tuning software making purchase or pass recommendations to senior management.
- Developed billing, past due and customer mailing interfaces for Banking and Tax levying authorities providing accurate and timely notices for a range of customer repositories from 60K to 2MM customer accounts.
- Served as the technical lead for a team of developers tasked with re-engineering a state-wide taxation system.
Functional Skills Summary
Business Intelligence
- Data Integration
- Reporting
- Data Warehousing
- Database Development, Administration SQL Performance Tuning
- o Stored Procedures/UDF's
- o Schemas/Tables/Views/Indexes/Triggers
- o Complex SQL CTE's, in-line tables, correlated sub-queries
- o Backup/Recovery/Maintenance Plans
- Data Modeling, Database Design
- Coding/Engineering
- Systems Analysis Design
- Technical Design Artifacts
Skills Matrix
Product Skills | Level | Process Skills | Level |
SQL Server | Advanced | Data Integration | Advanced |
T-SQL | Advanced | Database Dev. | Advanced |
SSRS | Intermediate | Data Modeling | Intermediate |
SSIS | Intermediate | Data Warehousing | Intermediate |
SSAS | Entry | SQL | Advanced |
PL/SQL | Intermediate | ETL | Advanced |
DB2 | Advanced | Performance Tuning | Intermediate |
XML | Intermediate | Database Admin. | Intermediate |
VBA | Intermediate | ||
HTML | Intermediate | ||
JAVA | Entry | ||
COBOL | Advanced |