SUMMARY:

For 15 years, Confidential has led or participated on teams performing analysis, design, development, implementations, enhancements, and testing of business applications in the following areas: SQL Server Development, ERP, ERP/CRM integration, ETL, Storage Area Networks, data warehouse design and implementation, and reporting.

SKILLS:

Microsoft SQL Server 2008 R 2/2012/2014/2016/2017 Administration/Configuration/Performance Tuning, SQL Server Integration Services - SSIS, SQL Server Analysis Services - SSAS w/MDX, SQL Server Reporting Services - SSRS, T-SQL development, Data Modeling, XML, Team Foundation Services, SQL Server Service Broker, SQLCLR, C#, ASP.NET MVC (Moderate), JQuery (Moderate), Knockout.js (Moderate), Microsoft Azure Data Warehouse, Azure SQL Database, Azure Cosmos DB, Power BI, DAX, SSAS Tabular, REST

PROFESSIONAL AND BUSINESS EXPERIENCE:

Confidential, Richardson, TX

Data Architect

Responsibilities:

• Design data models and integration for Customer Journey Analytics using Azure technologies including Azure Table Storage, Azure Data Lake, Azure Data Factory, and Azure SQL Database.
• Maintain and enhance existing ETL for multiple data marts and LOB applications using SSIS
• Migrate ETL from SSIS to Azure Data Factory for line of business applications
• Assist in DevOps practices by building CI/CD pipelines, configuring work tracking, and test plans using Azure DevOps
• Develop POC to migrate legacy code to cloud technologies.
• Build, integrate, and deploy reports and dashboards using Power BI.
• Mentor developers in areas of schema design, T - SQL, SSAS, SSIS, and SSRS development and implementation.

Confidential, Richardson, TX

Data Architect

Responsibilities:

• Designed and implemented OLTP data models using SQL Server 2012/2016/2017 and Azure SQL Database. These models are for new functionality or enhancing existing back office proprietary systems used for collision repair management.
• Designed and implemented multi-dimensional data models using Kimball concepts and methods. There are several conformed dimensions that have been discovered and are currently being developed and implemented to create a standard enterprise data warehouse bus architecture
• Designed, developed, and implemented various ETL solutions using SQL Server Integration Services (SSIS). These solutions range from connecting 3rd party systems to processing data for a data warehouse.
• Designed, developed, and implemented OLAP databases with Azure Analysis Services (SSAS). Building a proof of concept OLAP database using SSAS tabular mode.
• Designed and developed operational and analytical reports and dashboards using Power BI, SSRS, and Excel.
• Assisted and mentored application developers with T-SQL database development, database design, optimization and performance of database code.
• Worked with developers to implement a database lifecycle management (DLM) process that will leverage Visual Studio Team Services (VSTS aka Azure DevOps) to provide continuous integration with database code using SQL Server Data Tools (SSDT), eventually leading to better DevOps practices and procedures
• Worked with various stakeholders and users to gather and analyze requirements that will impact the data design of current and new systems
• Advised and assisted system administrators with database administrative tasks regarding HA/DR, security, server form factor, etc.

Confidential, Dallas, TX

Data Architect

Responsibilities:

• Assist in the research, procurement, design, and implementation of an enterprise master data management solution.
• Work with the Data Management Office to design and implement data governance and data quality policies.
• Install, configure, and administer Profisee Master Data Maestro environment
• Install, configure, and administer Microsoft Master Data Services environment
• Assist in the creation and management of data governance policies including
• Identifying and defining master data
• Matching policies
• Survivorship and Harmonization policies
• Integration
• Develop database objects including stored procedures, functions, tables, triggers, etc.
• Develop standards and practices for T-SQL development used by multiple development teams.
• Provide code reviews and guidance of T-SQL development to multiple development teams.
• Assist in the design and development of Qlikview dashboards. These applications consume various perspectives of data such as AP, AR, GL, and inventory data.
• Update and create ETL processes using SSIS to store and prepare data to be consumed by various business and reporting applications.
• Database performance tuning for critical data driven applications.
• Evaluate and recommend monitoring tools and methods for critical databases.
• Work with the operations team to design and plan server infrastructure for future OLTP and OLAP databases.
• Research and recommend server form factors for standard SQL configurations relating to but not limited to the following:
• Hardware
• Maintenance
• Policies
• Performance
• Development
• Design POC OLAP databases using SQL Server Analysis server both the multi-dimensional and tabular formats.
• Evaluate other technologies to determine if they can be leveraged for current and future architecture.
• Work with other architects to design the data infrastructure concerning source systems, ETL, the data warehouse, OLAP databases, to eventual reporting tools such as SSRS and Qlikview.

Confidential, Dallas, TX

Database Engineer

Responsibilities:

• Developed database objects including stored procedures, functions, SQLCLR based procedures, tables, jobs, and a full spectrum of database objects. These objects are used to collect data for various email marketing campaigns.
• Designed and developed multiple SSIS packages for 3rd party data integration/import/export. These packages contained one or multiple data flows along with invoking outside resources.
• Created custom transactional replication objects along with custom objects that work with XML and leverage the custom SQL Server Broker Services framework for moving data.
• Using SSAS, I maintained and enhanced the OLAP databases used to collect and aggregate email data. These cubes are used to measure performance of various email campaigns. I received training on the Microsoft Parallel Data Warehouse appliance in order to eventually migrate email data from the data warehouse to the appliance.
• Developed and maintained database objects leveraged by various .NET services that create emails based on marketing and business rules.
• Worked with other database engineers and app developers to increase performance of the system.
• Assisted the database administrators to troubleshoot performance issues.

Confidential, Dallas, TX

Sales and Marketing Business Intelligence Developer

Responsibilities:

• Develop new SQL Server Integration Packages (SSIS 2008) for the Sales and Marketing Business Intelligence (SAMBI) solution Developed and implemented business logic using T-SQL, SQL jobs, and SSIS.
• Migrate existing SSIS 2005 package to SSIS 2008
• Modify existing and implement new logic into the ETL framework using SSIS and T-SQL
• Modify existing and implement new logic into the SQL Server Service Broker SAMBI framework
• Design and create template for database unit test using Visual Studio Team Edition for the Database Professional (DBPro)
• Design and create template for unit testing SSIS packages using DBPro Unit Test functionality.
• Develop database objects including tables, views, stored procedures, user defined functions, Service Broker Objects to enhance the SAM BI database/warehouse.

Confidential, Dallas, TX

Enterprise Business Intelligence Contractor

Responsibilities:

• Lead database developer for the Cubixx application. This is an extension of the ERP inventory management system that uses RFID technology to provide a consignment service of specialty drugs to hospitals around the country.
• Developed and implemented business logic using T-SQL, SQL jobs, and SSIS.
• Developed updated integration between the Cubixx application and the ODS
• Developed specialized reports for Cubixx using SSRS and SQL Mail.
• Designed data model enhancements for Cubixx
• Developed additional integration with RFID data and the Cubixx database using SSIS.
• Developed enhancement to Data Warehouse objects that included tables, views, DTS packages, and other database objects.
• Prepared documentation for operations support.

Confidential, Dallas, TX

Sr. Technical Consultant

Responsibilities:

• Analyzed, designed, and developed a migration strategy to use Microsoft SQL Server Integration Services (SSIS) between the legacy application to the new system.
• Designed and developed database stored procedures, triggers, views, and other objects for OLTP database for data driven application.
• Assisted and maintained data model for the application.
• Provided hardware requirements and configuration for the supporting RDBMS.
• Maintained SSIS packages and enhanced SSIS code for interfaces to other external systems.
• Provide performance tuning analysis and recommendations using “Waits and Queues” methodology for Microsoft SQL Server 2005.
• Developed prototype reports using SQL Server Reporting Services (SSRS) to be integrated into transactional application.
• Developed prototype dimensional data model to develop OLAP cubes for report processing.
• Used SQL Server Analysis Services (SSAS) to develop cubes for report processing of data from data mart.
• Researched use of user-friendly software tools that implement ADO.NET objects to allow for easy configuration against the transactional application.

Confidential, Dallas, TX

Technical Consultant

Responsibilities:

• Assisted in the implementation and configuration of MAS500 ERP system.
• Designed, configured, and implemented ETL packages to migrate date from existing system into MAS500.
• Configured and implemented Microsoft SQL Server 2000 to leverage MAS500 architecture for best performance and availability.
• Configured and implemented RAID strategies in both direct attached I/O subsystems and SANs to allow for maximum performance for MS SQL Server managing the MAS500 database.
• Designed and developed custom database object (i.e. stored procedures, views, tables, DTS packages) to be used in MAS500 enhancements.
• Consulted with clients about database maintenance and administration.
• Implemented and configured Warehouse Automation radio frequency (RF) solutions, including data collection devices, access points, and middleware.-
• Created custom and modified existing crystal reports to be used in MAS500
• Assisted in design, development, and testing of custom web applications using ASP.NET 2.0 framework to be used for custom functionality in MAS500 ERP.
• Assisted in deploying custom web application using IIS technology.
• Assisted in ERP/CRM integration between Sales Logix and MAS500.
• Developed documentation for custom business process and custom process to MAS500 enhancements.
• Consulted on network administration policies with various clients.
• Implemented, integrated, and configured third party products with MAS500 such as Starship shipping software and Warehouse Automation with bar coding software.
• Developed backup policies for various clients using BackUp Exec to backup client databases.
• Analyzed and performed troubleshooting on system performance issues for databases and client machines in which MAS500 is implemented.
• Implemented Business Process System (BPM) software for SOx, SAS, Corbit, etc compliance.
• Provided support to clients concerning MAS500 issues
• Developed custom scripts (T-SQL, VBScript) to customize MAS500.

Confidential, Las Vegas, NV

Implementation Specialist

Responsibilities:

• Implemented Casino Management System (CMS) into various sized casinos through the United States.
• Trained and assisted accounting personnel on the tools and methods used in the slot accounting module of the CMS.
• Trained and assisted casino cage personnel in the ticketing module of the CMS
• Trained and assisted pit and floor personnel in the respective modules of the CMS.
• Worked with DBA to insure proper SQL jobs were run and stored procedures were customized for various casinos.
• Collaborated with IT staffs at casino properties to ensure proper network resources were utilized and machine connectivity and configuration were correct to interact with the CMS.