JOHN T. CROSTHWAITE

**** ******* **.

Escondido, Ca. 92027

760-***-****

QUALIFICATIONS

Solutions-focused, team oriented Data Warehouse Architect and Developer, MSSQL Full Stack Analyst with broad-based experience and hands-on skill in the successful implementation and integration of enterprise-wide Business Intelligence, Data Warehouse and Collaboration Systems. Proven ability to successfully analyze an organization's critical support requirements, identify deficiencies and potential opportunities, and develop innovative solutions. A broad understanding of computer hardware and software, including installation, configuration, integration, management, troubleshooting, and support. Development of migration, capacity planning, monitoring, disaster recovery and end-of-life strategies.

TECHNICAL SKILLS

Microsoft Windows Server 2008, 2012• MSSQL 2005, 2008, 2008 R2, 2012, 2014, 2017, SSIS, SSRS, SSAS, PostgresSQL, Informix, Azure, AWS, Virtual Platforms, Agile framework, T-SQL, SharePoint 2007/2010, Business Objects • TeamCenter TCSE 9, C, Java, Cobol, Fortran, Python. XML. Erwin and Toad data modeling.

PROFESSIONAL EXPERIENCE

Independent Contractor January 2016 – 2023

Database and Data Warehouse Development

Technical Consultant for Clients as architect and developer creating IT Data Warehouse environments within MSSQL Database Systems. Clients include a San Diego Legal firm, Retail Store, MW Associates/Ware Disposal, Healthcare, Encore Financial. San Diego Semiconductor, B. Media.

MSSQL development for Data Warehouse, and relational database modeling.

Architecture and Development CRM system including the data modeling and development of ASP interfaces utilizing SQL queries. SSIS development for ETL, MultiDimensional Cube in SSAS and SSRS report generation.

Extract and Load of data contained in XML, CSV and flat file sources into data model supporting customer asset management system and customer relationship databases.

Data scrubbing, conformity, data normalization and data rules analysis completed on highly normalized customer database.

Big Commerce Web Retail and Database maintenance within AWS.

Cymer Inc. San Diego May 2006 – January 2016

Senior Systems Analyst/Data Warehouse Architect

MSSQL database architecture, SQL development, and MSSQL administration for application and Data Warehouse utilizing full stack of MSSQL services, SSMS, SSIS, SSAS, SSRS.

SharePoint 2010 Content and Application Administration and Management including migration from MOSS 2007, third party integration, MSSQL Report Server integration, WEB front-end Load Balancing, MSSQL 2008 R2 database clustering, SharePoint Architectural design, Document Migration, Disaster Recovery planning, Backup/Restore Procedures and System Monitoring.

SharePoint Site infoPath and workflow development and management. Maintain full pipeline of development, test, QA and production systems.

Management, architecture and development of Data Warehouse and applications supporting Business Intelligence Systems.

Integration of operational databases. Oracle, PostgresSQL, MSSQL into Enterprise data farm. Development ETL progresses supporting Business Intelligence platforms.

Business Intelligence Systems architecture with SharePoint 2003, SharePoint 2007 and SharePoint 2010, Business Objects XI, IIS, Apache/Tomcat Microsoft SQL 2000, Microsoft SQL 2005, MSSQL 2008 including ETL processes developed in SSIS. XML file processing of data related to laser diagnostics. SSRS development for SharePoint embedded reports.

Administration, maintenance and consolidation of MSSQL 2000 and MSSQL 2005, MSSQL 2008 database and servers related Data Mart/ Data Warehouse, Documentum eRoom and Documentation Repositories.

Major contributions in system upgrades, performance tuning, system health monitoring, database consolidation and architectural designs.

Administration and maintenance of Siemens TeamCenter 9 platforms supporting Engineering Documentation Repository.

Architecture Team Center 9 server and application farm, IBM Webshpere Application Server and Versant 7 database.

Architecture, design and deployment of High Availability platforms including load balancing of application nodes and clustering of database servers utilizing the MSSQL 2008 HA concepts and SharePoint 2010 technologies.

Deployment of Enterprise monitoring solutions, including Microsoft SCOM, Netreo, Omni and Quest Spotlight.

By Referral Only - Carlsbad Sept 2005 - May 2006 Senior Systems Analyst/Data Analyst

Architecture and Development of Siebel 7.8 CRM system including the development of ASP interfaces supporting messaging and transaction processing of XML packets.

SSIS ETL development providing data integration between Siebel Systems and Financial system.

EIM data mapping and import processing of operational and legacy data stores.

Data scrubbing, conformity, data normalization and Data Rules analysis completed on highly de-normalized customer database.

Support of in house WEB applications written in Java over a MS-SQL database.

Support of Cold Fusion WEB environment and Multi-Tiered load leveling system platform. HTML, XML, Java, ActiveX, Visual Basic, XMLDOM, HTTP, IISSQL, and SQL programming.

Viejas Enterprises March 2003 – Sept 2005

Data Warehouse Developer/Senior Systems Analyst

Architecture, requirements, implementation and integration of major Financial Data Warehouse supporting the extraction and summarization of operational InfoGenesis POS transaction data. Project involved conversion of concepts developed for Micros POS interfaces to financial accounting system. Interfaces where designed utilizing MS-SQL Enterprise Manager with a combination of DTS, ActiveX, SQL and Stored Procedures to extract and aggregate daily sales transactions.

Architecture of Data Warehouse data model

Development of aggregation and summarization scripts utilizing SQL and Stored Procedures

Development of Data Warehouse and ETL process' in MS-SQL and DTS

iMetrikus Inc. March 2000 - March 2003

Senior Systems Analyst

Siebel Call Center 7.4 implementation and data modeling designed to migrate in-house incident management system built in access.

Managed and deployed Siebel Call Center project for Customer Support group to include Siebel workflows, EIM, mail manager, assignment manager and user administration.

HTML WEB content development and site management for interactive healthcare management WEB site.

Team leader of Customer Support and Client Services groups.

Development of Processes and Procedures for Customer Support organization.

Business Objects 4.0 Data Warehouse/Star Schema, meta-data and report development.

Architecture, design and implementation of analytic solutions built with Business Objects 4.0 for analysis of customer transaction behavior.

Creation of Business Objects 4.0 Star Schema against WEB Services Database to analyze customer behavior.

Development of Business Objects reports for use by Product Management and Marketing to derive marketing promotion metrics.

NCR Corporation 1995 - 2000

Senior Product Manager

Product Manager representing Customer Services on cross-functional product teams responsible for the concept, development, quality and deployment of new Products.

Products include Data Warehouse, Multimedia, Transaction Processing, Middleware, Customer Relationship Management, Internet and Enterprise Solution Technologies.

Development of product requirements, processes and procedures, and service plans in support of new product development and ongoing product lifecycle.

Development of Standard Development Process components consistent with NCR's new Program Realization Process initiative.

Third party and partner contract development and negotiation for alliance programs supporting integrated Enterprise Solutions combining third party analytic tools and Teradata's data warehousing platform.

Development of multi- tiered service offers for customer maintenance and annuity contracts based on corporate revenue, margin and profitability initiatives.

Team Leader and mentor of Graduate and Junior Service Process Analysts assigned to develop processes and procedures for global deployment initiatives.

First American Credco 1995

Contract Systems Analyst/Programmer Contract

Contract assignment architecting Credco credit scoring application infrastructure towards EDI applications and platform.

Contract project leader maintaining credit scoring application.

AT&T GIS 1992 - 1995

Senior Systems Analyst

Development Project Lead and Architect of transaction processing systems for multi-node Unix Platforms.

Designed last release of NCR's Multi-Tran TPS to support loosely coupled integration to next generation TPS, NCR TOPEND, providing end users with a migration path from proprietary systems to Unix Open Systems architectures.

Responsible for the design, development, integration and testing of new architecture within a team of five highly skilled senior developers.

Development Project Lead for NCR-ITX proprietary OS conversions to Unix platforms with strong emphasis on release coordination and quality objectives.

Significantly improved the quality metrics of existing release to meet company quality standards. Managed the development activities of several junior and senior analysts and reported status and progress to General Manager, Directors and Senior Staff.

Senior Systems Analyst

Member of Customer Solutions development team implementing multi-tiered CRM solutions for Telco and Retail industries.

Designed segmentation data models and meta-data to support multi dimensional analysis of Teradata data warehouses.

Middleware and GUI development in Oracle/Express supporting Telecommunications Marketing CRM system.

Developed SQL for data extract and load utilities with Teradata Bteq and Fastload to populate Telecommunications Industry Data Warehouse supporting the marketing analysis of customer behavior, product and service usage.

Also developed SQL load utilities to fully populate multi-dimensional data cubes as summary sources supporting segmentation tools used to analyze customer market potentials and track the performance of generated marketing campaigns.

Design of EDI Client/Server systems supporting financial data transactions compliant with X.12 data interchange standard.

NCR Corporation 1984-1992

Programmer Analyst

Graduate Programmer involved in systems integration and testing of mid-range and large systems including, OS, Firmware, Hardware, Diagnostic Tools, Telecommunications, X.24, LU 6, LU 3, Cobol, Fortran, Unix, Pascal and "C" Compilers, Databases, System Tools and User interfaces.

Development of test scripts and programs designed for unit, integration and system stress testing.

Associate Programmer Analyst - Principle Programmer Analyst

Programmer Analyst representing NCR Global Customer Services as a Third Level Service and Maintainability Specialist involved with next generation system development.

Development of service processes for new systems in preparation for general release of products. Critical Sites liaison working with local field support representatives while interfacing with systems engineering groups to deliver solutions to high visibility system problems and defects.

Assignments required frequent travel in U.S. and Europe to manage field support teams and deliver solutions to high visibility system problems.

Principle Programmer Analyst

Team leader of special systems integration projects for customers requiring system configurations outside of recommended specifications.

System integration coordinator responsible for the release coordination, execution of cyclical testing phases and achieving quality metrics in preparation for product release to quality assurance.

Systems included proprietary OS, hardware, database, multi-node distributive processing, transaction processing, telecommunications, utilities and diagnostic.

EDUCATION

San Diego State University

Bachelor of Science in Computer Science

Minor in Astronomy

Minor in Mathematics

San Marcos State University

Extended Studies in Mathematical Sciences

Contact this candidate