Establish the overall strategy for network, server, desktop, storage, database, personal and mobile computing and related infrastructure. Oversees development and maintenance of system services and procedures for computer operations, systems administration, and infrastructure support. Responsible for managing the lifecycle maintenance of client facing, infrastructure-owned hardware and software. Lead the infrastructure strategy development and creation of an infrastructure roadmap to support enterprise wide deployment of new technologies. Work with various business departments and the IT department to ensure the infrastructure is scalable, reliable and meets their needs of the business both short and long term. Provide technical guidance with changing technologies within the IT industry. Analyzes changing business needs and application requirements and plans for long term scalability of the IS infrastructure. Manage the design, architecture, and implementation of all IT infrastructures to meet current and future needs focusing on cost effective and resilient designs for growth and technical innovation. Allocates workload and enforces compliance with policies, procedures, performance and management processes. Identify opportunities to improve the infrastructure, including developing and maintaining policies and procedures, ensuring that projects are completed within allocated budgets and timeframes, and maintaining best practices for the infrastructure. Define hardware and software standards with input from project owners and other internal and external stakeholders. Develop a disaster recovery plan to address natural disasters, computer malfunctions, and information security incidents that may hinder normal operations. Develops and directs capacity and performance management processes, procedures and reporting. Review project plans to plan and coordinate project activity.

Maintain development and production servers. Lead the efforts to implement a centralized data warehouse. Build and maintain databases.Produce ad-hoc reports and queries. Create physical data models E/R Studio. Implement development and testing environments.Manage issues, change control requests, development releases, and support for the Cash Reconciliation Application (Cash App) processing $250 million per month in payments: The Cash App processed X12 835 healthcare remits received from payers such as Health Partners, Medicare, Medica, UCare and Medicaid and processes EFT lockbox files from Wells Fargo and ACH payments for non-lockbox on a SQL Server 2000 backend and VB 6 frontend.

Lead Developer of large-scale database development projects on the Risk Reward Management Vault Systems & Development Team. Apply precision and creativity developing solutions via SQL Server 2000/2005, DTS/SSIS, and Analysis Services. Provide mentorship to production and quick hit developers through detailed design and development.

Design robust ETL programs in DTS to load and transform raw data into information.Automate monthly ETL programs using custom audit/error handling tasks, advanced QC tasks, and error logs to record run-time statistics, rows processed, success/failure of tasks, author, database, server, package details, and system notifications to automatically notify users of data availability and details via-email.Build Star/Snowflake relational schemas using partitioned fact tables and various types of SCD dimensions.Build stored procedures for DDL and DML Create views to represent normalized data as a single dataset for ease of ad-hoc queries and provide a layer of abstraction between physical database tables and usersCreate detailed process flow diagrams to depict entire ETL process for each database load using Visio.Design logical and physical data models using Embarcadero’s data modeling tool E/R Studio