SUMMARY

Motivated and disciplined senior information management architect with a proven record of solving complex, real world problems, available as a Microsoft SQL lead designer or senior database developer. Extensive expertise in commercial ETL/data warehouse, accounting/finance, E - commerce, high volume OLTP, SQL conversions/migrations, CLR application development, and/or executive decision support systems. Expert at architecting information system technology to efficiently maximize organizational decision making and eliminate process redundancy.

Database Architecture Skills 15 years

• Extensive experience with commercial Tier One systems, ETL, large scale data warehouses, BI systems and portals, and high volume public facing internet sites.
• Design to deployment Greenfield development of business intelligence systems for complex KPI presentation, trending analysis, reporting, and dynamic Business Performance Metrics.
• Senior design architect for transaction intensive OLTP and/or data warehouse for multi-terabyte commercial database systems
• Development of schemas, procedures, functions, triggers, constraints, and partitioned tables
• Extensive data modeling with entity design tools Embarcadero, Visio, Erwin, SQL Diagrams
• Development of process automation to eliminate repetitive tasks
• Development of set based application code management for rapid object deployment
• Development of maintainable well-designed stored procedures for KPI decision support
• Development table based robotic systems for code validation and stress testing
• Development of central database warehouse sourced by multiple remote data sources
• Development of metric reports for financial and marketing/finance departments

Database Administration Skills 15 years :

• Extensive experience with enterprise scale MS-SQL 2012/2008R2/5/2000 database management, including OLTP, ETL and DSS systems.
• Physical and logical architectural database design including hardware specifications
• Large database maintenance, backups, and DSR recovery plans
• Database performance tuning, optimization, trouble shooting, code reviews
• Security settings and role definitions
• OLTP multi-server replication, mirroring, log shipping
• Develop and deploy automated monitoring tools to anticipate problems
• 24x7 on call NOC support and production rollout support/ Jobs scheduling and alerts

Application Development / System Architecture Skills 15 years

• Extensive experience with full life cycle development in CLR enterprise scale environments.
• Visual C .NET, Visual Basic.NET, ASP.NET, Web services, CLR, XML, Windows services, and multi-tier development
• Work with business users to define project expectations and scope
• Design project plan with deliverable schedules
• Team lead, coordination, and management
• Automated Unit/QA and UAT testing for robust scalability and bug elimination

Recent Engagements:

Confidential

Senior architectural consultant responsible for the end-to-end optimization of multiple SQL 2012 enterprise class high volume data warehouses used to expose corporate client specific BI information to commercial consumers. Reviewed/corrected schemas, SSIS packages, stored procedures, and reporting processes to comply with Kimball dimensional modeling concepts and ETL industry best practices. Worked with developers, business stakeholders, and production DBA team to implement design changes in a timely and cost efficient manner. Designed, developed, and coded CLR 4.5 C meta data driven Windows Service automation framework to replace SSIS. Framework scales to N number of databases and services.

Confidential

Senior member of Corporate Architectural Review team responsible for pre-release design review and approval of all MS SQL database applications for over 20 different LOBs. Detailed SME subject matter expert for high volume OLTP web facing applications and terra data mission critical warehouse systems emphasizing entity schemas employing Kimball Dimensional Model star schema design principles and methods. Review and enforcement of normalization concepts, efficient schemas, T-SQL procedures/UDF functions, table constraints, index optimization, views, SSIS packages, SSRS, C deployed functions, SQL execution plans. Senior contributor to production and QA optimization issues including simulated robotic load stress testing, profile trace evaluation, and capacity planning. Reviewed, critiqued, and improved more than two hundred full life cycle applications from architecture design to deployment. Active architectural participant in Oracle and Iseries database conversions to Microsoft SQL. Developed automated C code scan tool to run against SQL database objects to quickly locate established best practice failures. Developed .NET front end application with SQL 2008 R2 to record release tickets used by Bank of America code and performance review teams to log quality control tickets. Conducted over 25 SQL candidate SME reviews on behalf of Bank of America management. Developed Bank of America SQL best practices and policies documentation and standards. Encouraged the use of TFS Team Foundation Server as the official source code repository for all SQL objects to track changes, maintain version control, and automate deployments.

Confidential

Web metrics data warehouse development for Texas based energy retail company's enrollment and payment website. TXU Tealeaf package analyzer employed to capture real time web traffic for storage in SQL 2008 R2 database warehouse. Mission critical reporting systems developed with C designed for operations, marketing, rates of change analytics, and web development team. Procedures developed to identify web site errors and user frustration points.

Confidential

SQL 2008 architect/senior developer for high volume web facing transaction OLTP systems for the entire US Bank North American ATM network. Extensive C CLR 4.0 development for mission critical ETL involving multiple databases deployed multiple servers. Senior design architect for all phases of the SQL 2008 data warehouse application used by US Bank employees to field and correct real time customer ATM issues and make real time corrections.

Confidential

Short term project to convert SQL 2005 databases to SQL 2008. SSIS ETL process to populate data warehouse for electronic discovery from multiple data sources. Management reporting queries. C utility programs for extensive data and file manipulation.

Confidential

SQL 2005 database development related to the core platform Business Acquisitions application suite. SQL 2005 database development related to the mission critical Enterprise Product Platform. SQL 2005 database development related to the core component product rating engine. Multiple legacy SQL 2000 ETL data warehouse system conversions to SQL 2005 deploying SSIS. Scoped project requirements, met with users, prepared detailed conversion plan including new data models. Analyzed legacy VB 6 code and optimized ETL process for SQL 2005 SSIS packages. Replaced all SQL 2000 tables with newly designed and optimized SQL 2005 tables, views, procedures, functions, and triggers. Deployed entire process to test servers and obtained client signoff. Developed installation process and related documentation for DBA production deployment. Complied with Blue Cross internal testing and design documentation. In addition to conversions, assisted development team members in optimizing stores procedures related to other production projects. Assisted team with complex modifications to an Access 2007 front end application used to insert/update/delete customer service representative contract metrics.

Confidential

Automated manual BI process from T-SQL scripts/Access to SQL 2005 stored procedures. Streamlined T-SQL, improved speed via query optimization, modified tables, and enhanced metrics.

Confidential

Developed e-commerce commercial web site using SQL 2005, C, Visual Studio, ASP .net. Worked with design team to finalize beta and then developed/deployed production version. Senior technical developer, database designer, and .NET architect. Developed back and recovery plans, maintenance schedules, hardware usage metrics, user metrics, and alerts for 24x7 database monitoring. Developed stored procedures, views, functions, and triggers.

Confidential

Conversion of multiple mission critical SQL 2000 databases and DTS ETL packages to SQL 2005 x64 cluster, including upgrade to SSIS. CLR- C programming required. Converted/developed over 600 SSIS packages. Replaced multiple Access 2003 databases with SQL 2005 databases.

Confidential

Conversions of SQL 2000 DTS packages to SQL 2005 SSIS. Development of ETL reporting for departmental metrics. Work with Tealeaf web packet analyzer and Coral8 complex event processing system to elevate real time web user metrics for mission critical marketing applications. Development of Statistical based Marketing models for site property ranking. Database development for on line web applications.

Confidential

Short term project to conversion SQL 2000 databases to SQL 2005. Extensive use of SSIS to convert DTS packages. Development of migration plans for SQL 200 to SQL 2005. Development of SSIS ETL packages for movement of data into reporting sub systems.

Confidential

Short term project to convert legacy financial reporting applications to SQL 2000. Replaced Access 2003 desktop application logic with stored procedures and DTS packages. Employed .NET 2005 to automate FTP file transfers, data import processes, and shipping and receiving application.

Confidential

Project included the following:

• Design and architect SQL 2000 database systems to replace existing legacy system.
• Created three tier staging system for development, QA and production.
• Design and development stored procedures and views for a 24x7 on line transaction processing system.
• Designed system for transferring multiple remote data repositories into central SQL data warehouse.
• Design and develop system plan and architecture for multi-tier internet based client interface, com objects, SQL stored procedures, and data interchange. The design included the logical and physical layout of databases.
• Design and develop internet based user interface to replace existing C programs. The internet interface used ASP, ASP, and SQL 2000 for retrieval and display of data to user.
• Design and develop Com objects to use in retrieval and storage of SQL data to and from web based interface.
• Design and develop SQL stored procedures to replace existing business logic.
• Design and develop SQL stored procedures, daily processes, and Crystal templates to replace reporting system. This design included triggers for inserts, updates and deletes.
• Design of XML interface to exchange data between SQL 2000 server and remote client interface.
• Develop and train internal staff on ASP, IIS, ADO, Com, SQL, Transact SQL, SQL 2000 user defined functions and commercial transaction processing techniques. Mentored client staff on transact SQL, indexes, joins, views, and optimization techniques. Transferred knowledge to staff on how to call procedures inside C, ASP, VB, and com .
• Design and develop daily auditing process to detect and correct errors, find possible revenue shortfalls, and detect processing flow bottle necks.
• Prepared company for SAS audit by locating system weak points and shoring up controls and processes.
• Developed .Net web interface to replace Visual Basic 6.0 applications as well as for new applications.
• Designed and developed real time sales taxing engine for calculating telecommunications taxes in all fifty states.
• Ported SQL database and related to stored procedures to Oracle.
• Developed new VB.N ET Win forms / C applications to replace legacy systems.