SUMMARY

• SQL Data Architect with extensive Confidential intelligence, data warehousing and reporting background with organizations including Confidential .com, Confidential, and Healthcare Partners. My experience as a data architect has included the development of data models for reporting and application platforms as well as assisting in the design and development of the presentation mediums for reporting solutions.
• Data architecture means understanding the vision of the complete data layer and materializing that vision in such a way that the raw data from the OLTP systems meet the needs of the Confidential and I have experience doing this in the last several positions I have worked in. My experience includes:
• Implemented processes to automate many previously manual reports, ETLs, and data warehouse functions
• Complex T - SQL development and query optimization using execution plans and DMV’s to identify performance problems and bottlenecks
• Developed custom CLR stored procedures for automation and error management of SSIS package logs, SQL Server jobs, report schedules, and other miscellaneous data warehouse functions
• Analyzed Confidential needs for the purpose of designing efficient, optimized data models/schemas that supported providing intelligent data analysis
• Provided training to teams on SSIS and SSRS development
• Designed data marts for both reporting and application consumers
• Production DBA experience, including security, encryption and backups
• Optimized multiple SQL Server instances using SQL Profiler, Database Engine Tuning Advisor, DMV’s and PerfMon
• Designed, implemented and maintained SSRS Reporting infrastructure to work seamlessly with pre-existing ETLs and systems
• Developed dimensional models and surfaced them inside custom dashboards
• Designed and deployed reporting models to include an SSRS layer and reporting data marts for real time dashboard analysis using Dundas Dashboards
• Lead Informatica/Autosys resource for one of the nation’s top 3 financial institutions’ mortgage servicing revenue generating reporting solution. This included an extremely large Informatica implementation, managed and scheduled through Autosys jobs.

• SQL Server 2005/2008, SQL/TSQL, ETL, SSIS 2005/2008, SSRS 2005/2008
• MS Excel 2007, MS Access 2007, MS Visio 2007, VBA, SQL CLR, ASP.NET
• C#, Relational Database Design Theory, SharePoint, OLAP, XML, XPATH
• Dashboarding, Informatica 9.0.1, Autosys Job Scheduling, Putty, WinSCP

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Senior Application Developer/Team Lead

Responsibilities:

• Lead the development and ongoing maintenance of a large Informatica 9.0.1, scheduled and managed in Autosys
• Developed SSIS packages as needed for various applications as requested
• Managed data loads between different environments

Confidential, New York, New York

Presentation Layer Architect

Responsibilities:

• Designed reporting layer data model and access architecture
• Designed and implemented SSRS reports to integrate with the new data warehouse, including dashboards and scorecards
• Assisted in the design of a front end custom web application for presenting SSRS reports and cube data

Confidential, Salt Lake City, Utah

Data Architect

Responsibilities:

• Drafted Implementation Plan for upgrading from SQL Server 2005 to SQL Server 2008
• Designed SSRS architecture for outside domain access.
• Redesigned pre-existing data model to support multi-client subscription model architecture
• Implemented replication for distributed workload management and reporting
• Designed mirroring process for the support of the Salt Lake City Center for the Arts ticketing system.

Confidential, Murray, Utah

SSRS Development

Responsibilities:

• Converted Oracle reports to SSRS
• Implemented a custom dynamic web page for displaying SSRS reports on multiple SSRS servers in a pre-existing web application
• Designed a Multi-lingual reporting architecture for any number of languages

Confidential, Murray, Utah

Database Administrator/Architect

Responsibilities:

• Developed new ETL processes, implementing SSIS as the administration piece.
• DBA duties included security, encryption and backups
• Began development of performance monitoring dashboards for various sql server instances
• Redesigned and started implementation of a relational hierarchical model for the Confidential HIS data dictionary
• Optimized performance on existing and new servers for existing and new product lines.
• Maintained overall health of servers and made suggestions for ways to improve server architecture.
• Optimized multiple SQL Server instances using SQL Profiler, Database Engine Tuning Advisor, DMV’s and PerfMon

Confidential, Santa Monica, CA

Database Engineer / ETL Developer

Responsibilities:

• Maintained ETL processes and debugged any known issues
• Examined ETL processes for possibly performance improvements as well as possible mistakes in logic
• Provided suggestions for ways to improve the overall data warehouse infrastructure through improved data models, improved ETL’s, or newer technologies
• Researched and resolved data anomalies previously unresolvable

Confidential, Salt Lake City, UT

ETL Developer

Responsibilities:

• Implemented maintained SSRS Reporting infrastructure to work seamlessly with pre-existing ETLs and systems
• Created SQL CLR/SSIS process to handle all logging, precedence validation, automatic restarting, email notifications, and several other administrative tasks associated with jobs, packages, and reports that need to run on the server
• Lead the Confidential Intelligence initiative from a architecture, design, development, and implementation perspective within the Healthcare Economics division
• Implemented processes to automate many previously manual reports, ETLs, and data warehouse functions
• Developed custom CLR stored procedures for automation and error management of SSIS package logs, SQL Server jobs, report schedules, and other miscellaneous data warehouse functions
• Rebuilt several very complex ETLs to provide for automation and various performance improvements
• Managed maintenance of index creation and other basic performance features to improve data warehouse performance
• Created process to automatically loop through all databases on production servers, back them up to a network path, and then immediately restore said backups to a dev box for dev purposes
• Converted DTS packages to SSIS and optimized their performance

Confidential, Salt Lake City, UT

Business Intelligence ETL Developer

Responsibilities:

• Implemented SSRS organizational policies to meet the needs of all departments in the company.
• Communicated on multiple projects between an array of 10-20 people simultaneously
• Maintained SSRS environment and managed all report requests for all user groups
• Developed custom dashboards streaming real time analytical data for performance monitoring
• Developed database structures and systems to allow for SSAS implementation and data warehousing
• Primary developer on BI team
• Developed ETL farm for harvesting 2005 production environment and reconciling with 2008 warehouse ready environment
• Developed ETL’s to harvest data from all SQL formats, including XML data types via XPath SQL code
• Extracted data from a variety of data sources, types, and formats and loaded data into SQL Server environments
• Experience manipulating data inside packages and then loading into SQL Server
• Frequently developed indexes to improve server performance
• Wrote service to iterate through registered servers using SMO Application object and back up servers every 48 hours
• Implemented complex packages via SSIS to harvest data from a variety of structures into SQL Server 2008 environment
• Contributed in the initial and ongoing development of MOLAP Data Warehouse environment through the design of dimensions, data source views, and cubes

Operations Analyst

Confidential

Responsibilities:

• Analyzed, organized, presented, and implemented process improvements saving $350K in 2008
• Coordinated and successfully managed and completed multiple projects simultaneously
• Collected diverse statistical data elements for the purpose of workflow analysis and process improvement for customer service and implemented changes.
• Monitored the department to determine agent specific needs and satisfy those needs in a timely manner
• Distributed reports to all levels of management for collaborative analytical purposes
• Identified key technology needs within the company and worked closely with the B.I. team to satisfy those needs through ASP.NET development, database development, Web Services development, data warehouse development and Confidential process changes
• Developed custom C# ASP.NET applications for process monitoring and internal operations
• Designed systems for moving data from a variety of formats via ETL’s to SQL Server 2005 for the purposes of SSAS implementation
• Developed custom reports in SSRS for different Confidential units within the organization
• Implemented reporting solutions via VBA in Excel, Outlook, and Access 2007