PROFESSIONAL SUMMARY:

• Confidential with sixteen years in an Information Technology career including design, implementation, support, documenting, reporting and lead of multiple projects and system environments.
• Twelve years of SQL Server database analysis, administration, performance tuning, query optimization, indexing, backup and recovery routines.
• Data Modeling and implementation of data warehouses using the Kimball Methodology.
• Architect, development, and implementation of Business Intelligence solutions including SharePoint integration.
• Constructed SSIS/DTS Packages for ETL, data extraction and transformations, and automation routines.
• Developed, implemented, and administered reporting and analytic solutions.
• Creation and troubleshooting of stored procedures, functions, triggers, queries, and database scripts.
• Maintained development version control and releases to test, staging, and production environments.
• Hands - on experience at leading all stages of system life cycle efforts.
• Competent at establishing clear and concise objectives and managing projects through to completion.
• Took initiative to handle responsibilities independently as well as a proactive member of a team.

TECHNICAL SKILLS:

Databases: SQL Server PDW Oracle 8i/9i/10g/11g DB2 MS Access

Languages/Development Technologies: T - SQL SQL MDX

Business Intelligence: SSIS/DTS SSAS SSRS PerformancePoint PowerPivot PowerView SharePoint 2010/2013 Excel 2007/2010/2013 Cognos BI Software

Tools: Visio Visual Studio TFS SharePoint Designer VMWare Workstation Microsoft Office Products

Operating Systems: Windows Server R2Windows 2000 - 8.1

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Lead, architected, and implemented Data Warehouse and Business Intelligence solution that included criminal justice and probation trending and analysis for a county government using the Microsoft BI Stack and SQL Server 2014. Developed dimensional data model. Designed flexible ETL using SSIS for incremental and historical loads with built in auditing and notifications. Assisted in design and creation of SSRS Reports and SSAS Multidimensional cubes. Mentored team members.
• Lead and architected an Enterprise Data Warehouse (EDW) and Business Intelligence solution at a mid-size public transportation authority using the Microsoft BI Stack and SQL Server 2012.
• Provided consulting and technical expertise at an energy corporation, to implement an appliance based Parallel Data Warehouse migration.
• Assisted with the development of a health care funding analytic solution directed for the University’s health science schools and medical center.
• Conducted interviews with stakeholders, statisticians, and subject matter experts to document and clarify ridership business processes, metrics, reporting needs, business rules, latency, historical tracking, procedures and issues.
• Designed, converted, and performed ETL enhancements applying best practices to replace the SQL 2005 data warehouse destination with PDW, witnessing 300% report and 100% ETL execution performance gains. ETL enhancements included SSIS Packages, type 1 and 2 slowly changing dimension logic, hashing, stored procedure and view modifications.
• Performed extensive data analysis on complex proprietary disparate data sources.
• Participated in brain storming sessions to determine and develop data models.
• Established table and database geometry for PDW based on size of tables and query usage.
• Configured and executed processes for historical data using PowerShell scripts to bulk copy from the SQL Server 2005 production data warehouse and load into PDW.
• Involved in performance optimization of PDW queries.
• Created database jobs and batch files to execute scheduled incremental ETL in order to sync PDW and new data mart environment with production environment.
• Generated SQL validation scripts to check the reconciliation of data between production and implementation environment.
• Troubleshot errors from schedule packages, PDW, and defects noted via independent QA in data validation, Cognos reports, and SSAS cubes. Provide resolution to remediate.
• Mentored technical staff and provided assistance on PDW configuration and querying, historical load, creating database objects, and developing SSIS packages.
• Participated and lead client and team meetings in making various business decisions.

Confidential, Englewood, Colorado

Responsibilities:

• Provided technical support, monitoring, maintenance, and processing for several casinos using the proprietary IGT Mariposa Business Intelligence environment built with SQL Server 2005/2008R2 data warehouses, SSIS ETL, and SSAS cubes.
• Performed player, slot, and table data mart and ETL upgrade due to WinOasis gaming source updates.
• Captured requirements and organized efforts to create web functionality for the Cosmopolitan Patron Identity Member to associate their account with a reservation, login and view their point balance, and be presented with cash offers based on their tier status. Discovered and created source views and procedures in the Teradata data warehouse environment for web services.

Confidential, Frederick, Maryland

Responsibilities:

• Presented supporting documentation and analytical insight on various aspects of the servicing portfolio to communications, executive management and others.
• Delivered support for the Servicing Integration Unit currently underway by providing analytical information via Microsoft Business Intelligence suite to various business areas.
• Provided data warehousing modeling insight and development of SSIS packages for data extraction and transformation in preparation of post-closing final document executive dashboard data.

Confidential, Germantown, Maryland

Responsibilities:

• Provided leadership, guidance, mentoring, project decisions, planning, design, and conducted team meetings for various clients and multiple projects.
• Consulted with business analysts and stakeholders to satisfy enterprise needs and functionality.
• Gathered requirements, analyzed data, created statements of work, and implemented Microsoft Business Intelligence self-service solutions to improve reporting and decision making.
• Modeled database dimensional schemas with star and snowflake design.
• Implemented SQL Server Data Warehouses, Data Marts, and Operational Data Stores for efficient data retrieval and historical storage of state agency statistical, case management, driver license, motor vehicle, and university research data.
• Created historical and incremental ETL processes that successfully extracted, transformed and loaded data from disparate sources including Oracle, SQL Server, SAP Web Services, Text Files, Access, and Excel sources.
• Improved ETL performance more than 50% at one client over previous solutions via SSIS Packages, indexing, query optimization, and data modeling.
• Migrated data used in existing Oracle and SQL Server databases and spreadsheets for existing transactional databases, data warehouses, and storage to new SQL Server database environments.
• Implemented SSRS solutions including report development, configuration, management, creation of source parameterized stored procedures, and deployment. Reports included data sources from SQL Server, Analysis Services, and SAP BW Web Services.
• Developed and configured SSAS cubes including aggregation and partition performance tuning techniques with multiple dimensions and hierarchies, one-to-many, many-to-many, and relationships, calculated members and KPI’s.
• Produced hierarchical departmental PerformancePoint metric dashboards for SharePoint ation that included analytical reports and scorecards.
• Deployed pivot tables, reports, and dashboards to the SharePoint portal.
• Delivered Microsoft sponsored POC’s, demonstrating the functionality of the Microsoft BI product suite.
• Created a SharePoint external list user interface to store and update metrics.
• Setup of SQL Server high availability solutions including database mirroring, clustering, replication and log shipping.
• Recommended and implemented database performance enhancements.
• Administered and maintained transactional and reporting database environments.
• Set up multiple virtual machine environments for testing and demos of various solutions.

Confidential, Hagerstown, Md

Business Intelligence Support

Responsibilities:

• Created a scalable database and stored procedures to document and maintain Decision Stream ETL mapping from the IBM AS400 to the SQL Server data warehouse.
• Improved ETL performance 20% by modifying over 150 Decision Stream source queries.
• Implemented backup routines and performance enhancements for the Data Warehouse.
• Modified General Ledger ETL Fact build full refresh to an incremental.

Environment: SQL Server 2005, Windows 2003, Cognos Upfront

Confidential

Database Analyst / Programmer /Technical Lead

Responsibilities:

• Participated actively in Joint Application Design sessions with the customer. Conferred with team members in design and gathering requirements from the customer. Reviewed team tasks, application design, and database design. Planned and directed roll of changes to the production environment.
• Fully upgraded Database and SSRS production environment from SQL Server 2000 to SQL Server 2005. Corrected incompatible stored procedure syntax and converted existing DTS Packages to SSIS Packages. Replaced replication with database mirroring, improving overall system failover.
• Implemented a SSRS solution of including configuration, report design, creation of source stored procedures and deployment.
• Redesigned database schema and created stored procedures for database access due to .NET web application upgrades.
• Designed a prototype multi-dimensional SQL Server SSASOLAP cube.
• Produced ETL processes using SSIS/DTS to extract, transform and load data.

Environment: SQL Server 2005/2000, Windows 2003/2000, .NET 2.0/1.1, Visual Basic 6.0, ASP

Confidential

Database Analyst / Programmer

Responsibilities:

• Developed, implemented, and modified data mart schemas within SQL Server and Oracle data warehouses for loading data cubes and reports from disparate sources.
• Streamlined ETL processes to schedule data warehouse imports and timely updates of data cubes utilizing DTS.
• Produced Cognos Impromptu catalogs and query definitions as the basis for multi-dimensional Cognos Power Play models.
• Generated hierarchical multi-dimensional data cubes with Cognos Power Play.
• Deployed data cubes and reports to the Cognos Upfront portal and custom web sites.
• Installed and administered server and client side Cognos products.

Environment: Oracle 8i/9i, SQL Server 7.0/2000, Windows 2000, Cognos BI Suite

Confidential

Database Analyst / Programmer

Responsibilities:

• Gathered requirements for updated Human Resource data source. Automated data import process creating a DTS Package to replace operations previously handled by a Visual Basic executable.
• Maintained and published administration site presenting application usage detail, utilizing Web Trends to display web statistical reports.

Environment: SQL Server 2000, Windows 2000, Visual Basic 6.0, Active X, ASP

Confidential

Oracle Database Administrator / Analyst

Responsibilities:

• Completed requirements of automating snapshot data replication allowing the Civil Engineers a single entry point of the fixed asset data. Wrote Visual Basic Windows program and database triggers to populate production data.
• Discovered source data field mappings, deciphered data elements, and developed thirty-three Actuate Reports. Modified and created new queries to access the data. Designed hierarchical navigation and set properties within the Actuate Portal, hosting reports.

Environment: Oracle 8i/9i, Windows NT 4.0, Citrix, Power Builder