OBJECTIVE:

To obtain a challenging position as a Business Intelligence Developer allowing me to utilize my SSAS, SSIS, SSRS, and Power BI development skills to design and implement BI solutions.

TECHNICAL SKILLS:

Operating Systems: Unix, Linux, VM Ware ESX, Windows 2003/2008/2012

Programming Languages: T - SQL, PL/SQL, VB.NET, ASP.NET, C#, ADO.NET, ODP.NET, Visual Basic 6.0 with COM, ASP, Java, JSP, JSON, Node.js, XML, HTML, UML, PHP, MDX, DAX, Windows Scripting, VBScript, Bourne & Korn Shell, Python, PERL, PowerShell, JavaScript, and Pig

Databases: SQL Server 7/ 2000/2005/2008 R 2/ 2012/2014/2016, Oracle 9i/10g/11g/12c, MongoDB 3.2/3.4, MySQL 5.6, and Microsoft Access

Business Intelligence: SSAS, SSIS, SSRS, SQL Server Report Builder 2.0/3.0, Visual Studio 2005/2008/2010/2012, Power BI 2.36/2.46, and Tableau 9.3/10

Big Data: Cloudera, Hortonworks and Azure HDInsight Hadoop, HDFS, MapReduce, Hive, HBase, Sqoop, Oozie, Flume, Kafka, Spark, PIG, Cloudera Manager, Cloudera Director, Hue, and Ambari

Cloud: Amazon Web Services EC2, RDS, and S3 as well as Microsoft Azure

Software Applications: Quest SQL LiteSpeed, Quest Spot Light, Quest Performance Analysis, SQL Sentry, RedGate SQL Compare, RedGate SQL Data Compare, RedGate Backup, TOAD, PL/SQL Developer, Eclipse, MySQL Workbench, Geany, Embarcadero ER Studio, Erwin, OLAP (Analysis Services), Mongo Chef, Crystal Reports 8.5/9, SQL Server 2008/ 2012/2014/2016 Reporting Services, TFS, VSO, GIT, Microsoft Project 2010, and Microsoft Office 2003/2010/365

PROFESSIONAL EXPERIENCE:

Confidential

Database Architect\Developer

• Database Architect responsibilities included using SSIS for ETL, Erwin to model in-memory\standard tables, creating constraints (Primary Keys, Foreign Keys, Check, Unique, and Default), indexes, user defined functions, stored procedures, views, synonyms, CTEs, table variables, and triggers. Responsibilities also included creating data flow diagrams, creating coding standards documentation, advising on data flows to and from various applications and databases via REST APIs, assisting with application requirements creation, advocating and following the TOGAF framework, regular SQL Server performance tuning, providing leadership to developers and server engineers, conduct T-SQL code reviews, managing database code promotion, assisting with SQL Server and web server administration, configuring Microsoft Azure as well as Amazon Web Services EC2, RDS, EBS, EFS, and S3 for additional capacity and testing, ensuring PCI Compliance standards are adhered to, and working with the support team to investigate and resolve issues.
• SQL Server Reporting Services 2014 development responsibilities included creating, modifying and performance tuning reports, using the SQL Data Tools to create multiple visually attractive SSRS summary, detail and sub reports featuring cascading parameters and charts. Some reports were based on SSAS cubes. Reports were used by the finance, accounting, marketing, and support departments.
• SQL Server Analysis Services 2012 data warehouse responsibilities included creating fact tables and type 2 dimension tables, using SQL Server Analysis Services to create cubes featuring KPIs, aggregations, hierarchies, and groupings, query cubes using MDX, modifying the data warehouse database as necessary, documenting changes to the data warehouse using Erwin as well as creating constraints and indexes.
• SQL Server Integration Services 2012/2014/2016 development responsibilities included creating data flows to handle integrating data in JSON, XML, and delimited flat files formats. Other sources and destinations for data included MySQL, Oracle, MongoDB, and SQL Server. SSIS was also used load data into the data warehouse and process SSAS cubes in support of business intelligence initiatives.
• Power BI responsibilities included using the Power BI Desktop, Power BI Report Server, and the Power BI Service to create and publish executive and DEVOps support related dashboards featuring gauge charts, KPIs, donut charts, combo charts, cards, bar charts, line charts, pie charts, slicers, and bubble chart visualizations.
• Big Data NoSQL development responsibilities included managing MongoDB 3.4 NoSQL databases on Red Hat Linux and Windows Server 2012. MongoDB development responsibilities involve using Python to read log files and load data into MongoDB, creating queries, collections, indexes, and assisting with the design of REST APIs to allow HTTP method calls against MongoDB databases. Administration responsibilities include creating users, assigning roles, performance tuning, performing imports and exports, and using BASH shell to create scripts for database backup and recovery.

Confidential

Senior Database BI Developer

• SQL Server 2008 R2/2012/2014 development responsibilities included maintaining and supporting data warehouse, using the BIDS/SQL Data Tools environment to create SQL Server Report Server reports, using SSIS packages to create and maintain packages used to move data between database systems and process SSAS cubes, creating dashboards using Power BI, quering cubes using MDX, and modeling databases using Embarcadero ER Studio, creating cubes, in-memory and standard tables, constraints (Primary Keys, Foreign Keys, Check, Unique, and Default), indexes, user defined functions, stored procedures, views, synonyms, CTEs, table variables, and triggers.
• Oracle 11g/12c development responsibilities included database modeling, creating in-memory as well as standard tables, primary keys, foreign keys, check constraints, unique constraints, default constraints, indexes, functions, packages, stored procedures, views, synonyms, and triggers.
• As a member of the architecture team we developed processes to streamline code implementation for both application and database code. I used Embarcadero ER Studio to create data models for all OLTP and OLAP databases. I created documents indicating department guidelines for data architecture (OLTP and MS BI Stack), coding best practices, data modeling best practices, and performance tuning. I also instituted code review process for both application and database code. I partnered with the application team to develop an object oriented approach to their code interacting with the database over an approach that included database code in the .aspx pages. An Amazon Web Services infrastructure was used to create a fast and flexible environment for proof of concept testing. As a result of my partnership with the application development team we engineered an in-memory processes utilizing C# based objects.
• I architected a cloud based Azure HDInsight Hortonworks Hadoop solution utilizing HDFS, Hive, Flume, Kafka, Spark, HBase, Python, Oozie, Pig, and Sqoop. Pig was used to extract data from unstructured flat file data sources. SSIS was utilized to move structured data to and from the Hadoop cluster. SSIS also used to load an OLAP based data warehouse.

Confidential

Database BI Applications Engineer

• SQL Server 2008/2012 development responsibilities included using the BIDS environment to create visually attractive SQL Server Report Server reports, using SSIS packages to create and maintain packages used to move data between systems and process SSAS cubes in support of business intelligence initiatives, model databases using Erwin. Create cubes, tables, constraints (Primary Keys, Foreign Keys, Check, Unique, and Default), indexes, user defined functions, stored procedures, views, CTEs, table variables, and triggers.
• I joined two projects, which were behind on the project plan, and was able to help the projects get back on track. I used SSRS 2008 to create and enhance drill down and nested sub reports. To avoid performance degradation on the production databases I setup database mirroring and database snapshots for the scheduled and unscheduled reports to run against.
• I also used SSIS packages to pull data from Oracle 11g and SQL Server databases before running the data thru SSIS transformations. After the data is ran against the SSIS transformation it is loaded into a destination databases. Some of the SSIS packages were setup to accept parameters passed in at the command line or thru a SQL Server Agent job. Using the parameters allowed the same package to be used against multiple targets without having to open the package to change target locations. For some packages I retrieved XML data from web services using C# based scripting tasks before using stored procedures to parse the XML and load it into SQL Server databases.

Confidential, Atlanta, GA

Lead Database Administrator

• Database administration responsibilities included supervising 2 database administrators, installing as well as administering 4 clustered and 15 non-clustered SQL Server 2000/2005/2008 R2/2012 64-bit servers on Windows 2003/2008 R2 64-bit servers, setup and maintain database mirroring, table partitioning, page and row level compression, database compression, capacity planning, performance tuning/monitoring utilizing SQL Server (2005/2008 DMVs, Extended Events, DBCC commands, performance monitor, SQL Profiler), responding to Remedy support tickets, creating security policies, data analysis, data integration, setting up maintenance plans, backing up and restoring databases, and setting up performance alerts.
• SQL Server development responsibilities included maintaining and utilizing TFS for database related objects, Master Data Management using Master Data Services, using the BIDS environment to create visually attractive SQL Server Report Server reports, using SSIS packages to create and maintain packages used to move data between systems and process SSAS cubes in support of business intelligence initiatives, model databases using Erwin. Create cubes, tables, constraints (Primary Keys, Foreign Keys, Check, Unique, and Default), indexes, user defined functions, stored procedures, views, CTEs, table variables, and triggers.
• I successfully modeled and implemented a SQL Server 2008 R2 database to capture customer product abandonment data. I created 15 tables, 22 stored procedures, 6 reports using SSRS, and installed an additional instance of SQL Server 2008 R2 on a cluster node for the database to be created on. The database was created to utilize table partitioning on 6 key tables to support a large amount of data while keeping query performance fast. I made sure indexes were utilized to help with query performance and referential integrity was in place to keep the data clean.
• I successfully migrated 23 packages from DTS to SSIS packages and redesigned data flows between internal systems as well as vendors. The critical SSIS packages I redesigned are used as the engine to exchange data with banks, the internal financial department, the internal accounting department, states, customers, and insurance vendors.
• I successfully implemented a SQL Server 2012 Business Intelligence solution on Windows 2008 R2. The solution included SSRS 2012 and SSAS 2012 scaled out from the SQL Server data engine for increased performance.
• Oracle 11g (Windows 2008 Server) responsibilities included assisting with the modeling and development of an enterprise data warehouse, supporting the data warehouse by backing up databases (RMAN, cold and hot backups), restoring databases as needed, imports and exports of databases or schemas, applying patches, performing ad hoc queries as needed, space management, monitor and correct jobs, create TARS as needed, manage SQL loader tasks, manage users and roles, application setup, Performance Tuning using Explain Plan, AUTOTRACE, Timed Statistics, SQL TRACE, and TKPROF.

Confidential, Atlanta, GA

Database Administrator (Contract)

• Database administration responsibilities included on site as well as remote administration of clustered and non-clustered 64-bit SQL Server 2005/2008 servers, migrating 5 SQL Server 2005 instances to SQL Server 2008 R2 running on Windows 2008 R2, maintaining log shipping, table partitioning, page and row level compression, database compression, capacity planning, performance tuning/monitoring utilizing SQL Server (2005/2008 DMVs, performance monitor, SQL Profiler), database consolidation, creating performance reports, responding to FogBugz support tickets, creating security policies, data analysis, data integration, setting up maintenance plans, backing up and restoring databases, and setting up performance alerts.
• SQL Server development responsibilities included using BIDS and Report Builder to create 18 visually attractive SQL Server Report Server reports containing charts and data bars, using SSIS to create and manage 26 data feeds, create 3 data models using Erwin, create tables, constraints (Primary Keys, Foreign Keys, Check, Unique, and Default), indexes, user defined functions, stored procedures, views, CTEs, table variables, and triggers.
• I successfully installed 4 SQL Server 2008 R2 Enterprise instances on a 4 node active\active cluster and migrated 25 databases from 10 SQL Server 2000 instances to the cluster. On some of the larger database I used SQL Server native page compression as well as row level compression on the static tables to reduce the sizes. SharePoint, Web Methods, C# based applications, and Microsoft business intelligence applications utilized the cluster.

Confidential, Atlanta, GA

Senior SQL Server Database Administrator

• Responsible for leading a team of 2 database administrators, administering 3 active/active clustered and 24 non-clustered SQL Server 2005/2008 servers located in various global locations. The applications, which utilized the SQL Servers included SAP, Analysis Services, Reporting Services, SharePoint 2007 and various third party and .NET web applications.
• Database administration responsibilities included administering 32-bit and 64-bit SQL Server 2005/2008 servers, maintaining transactional replication, log shipping, table partitioning, capacity planning, performance tuning/monitoring utilizing SQL Server (2005/2008 DMVs, performance monitor, SQL Trace, SQL Profiler), database consolidation, creating performance reports, responding to UniCenter support tickets, responding to MOM alerts, creating security policies, data analysis, data integration, setting up maintenance plans, backing up and restoring databases, setting up performance alerts, code release for OLTP and Analysis Services (SSAS) projects, process management, and consulting with application developers on SSIS packages.
• SQL Server development responsibilities included modeling and developing a data warehouse, creating and maintaining reports through SQL Server Reporting Services, using SSIS to create and manage data feeds with vendors and legacy systems, managing ETL process to data warehouses, working with developers on data mining and Key Performance Indicators, MDX queries, T-SQL queries, data modeling using Embarcadero ER Studio, creating tables, cubes, use SSIS to process cubes and populate data warehouse, create constraints (Primary Keys, Foreign Keys, Check, Unique, and Default), indexes, user defined functions, stored procedures, views, CTEs, table variables, and triggers.
• I successfully migrated 35 databases from 7 SQL Server 2000 and 5 SQL Server 2005 database servers to SQL Server 2008. Once the databases were successfully migrated the redundant SQL 2000 and 2005 boxes were removed from service. The migration effort also required the modification of database objects to take advantage of the new SQL Server 2008 T-SQL capabilities (CTEs and table variables). I also added stored procedures to support new application functionality. Through performance tuning T-SQL and redesigning DDL I was able to bring website page loads down from 19 seconds to 3 seconds. I was also able to reduce the time an SSRS report took to load from 6 minutes to 4 seconds.
• Oracle 10g (Windows 2003 Server) responsibilities included backing up databases (RMAN, cold and hot backups), restoring databases as needed, imports and exports of databases or schemas, applying patches, performing ad hoc queries as needed, space management, monitor and correct jobs, create TARS as needed, manage SQL loader tasks, manage users and roles, application setup, Performance Tuning using Explain Plan, AUTOTRACE, Timed Statistics, SQL TRACE, and TKPROF.

Confidential, Atlanta, GA

Senior SQL Server Database Administrator

• Responsibilities included leading a team of 3 database administrators, administering 75 active\active clustered and non-clustered SQL Server 2000/2005 servers located in the United States, Australia, and the United Kingdom. The applications, which utilized the SQL Servers included Analysis Services, Reporting Services, SharePoint 2007, BizTalk 2006, Microsoft Communications Server 2007, Microsoft Dynamics CRM 3.0/4.0, various third party and .NET web applications.
• Database administration responsibilities included administering 32-bit and 64-bit SQL Server 2000/2005 servers, maintaining transactional replication, log shipping, database mirroring, table partitioning, capacity planning, performance tuning/monitoring (SQL Server 2005 DMVs, SQL Profiler, DBCC SHOW STATISTICS, DBCC SHOWCONTIG, DBCC DBREINDEX, DBCC CHECKDB, Performance Monitor), creating performance reports, responding to Remedy support tickets, responding to MOM alerts, creating security policies, data analysis, data integration, setting up maintenance plans, backing up and restoring databases, code release for OLTP and Analysis Services (SSAS) projects, and process management.
• SQL Server development responsibilities included creating and maintaining reports through SQL Server Reporting Services, using SSIS to create and manage data feeds with vendors and legacy systems, managing ETL process to data warehouses, working with developers on data mining and Key Performance Indicators, MDX queries, T-SQL queries, using SSIS to process SSAS data cubes and dimensions, data modeling using Embarcadero ER Studio, creating tables, SSAS star schemas, cubes, constraints (Primary Keys, Foreign Keys, Check, Unique, and Default), indexes, user defined functions, stored procedures, views, CTEs, table variables, and triggers.
• I architected and implemented an Analysis Services solution, which utilized a 2 node SQL Server 2005 Enterprise 64-bit active/active cluster. Multiple Analysis Services instances and database server instances where created to handle the data warehousing needs for each region the organization operates in around the world. The solution also involved scaling the Reporting Services and integrating Performance Point with SharePoint servers.
• I successfully migrated a 2 node active/active 32-bit SQL Server 2005 Standard cluster which supported SharePoint databases to an active/active 64-bit SQL Server 2005 Enterprise platform. SharePoint is a very complicated application to migrate, but I was fortunate enough to have the skills to make the SQL Server portion of the migration to a 64-bit platform successful. Thanks to good planning and testing when the SharePoint application servers were turned on they worked seamlessly with the new 64-bit SQL environment.
• I created an ETL process using SSIS to move data from SalesForce.com to a database supporting a .NET portal application. The process used DBAmp and required 14 dynamic stored procedures, 2 triggers, and 7 CTEs.
• Oracle 10g (Windows 2003 Server) responsibilities included backing databases up (RMAN, cold and hot backups), restoring databases as needed, imports and exports of databases or schemas, applying patches, performing ad hoc queries as needed, space management, monitor and correct jobs, create TARS as needed, manage SQL loader tasks, manage users and roles, application setup, Performance Tuning using Explain Plan, AUTOTRACE, Timed Statistics, SQL TRACE, and TKPROF.
• Oracle 9i (Windows 2003 Server) responsibilities included backing up databases (RMAN, cold and hot backups), restoring databases as needed, imports and exports of databases or schemas, applying patches, performing ad hoc queries as needed, space management, monitor and correct jobs, create TARS as needed, manage SQL loader tasks, manage users and roles, application setup, Performance Tuning using Explain Plan, AUTOTRACE, Timed Statistics, SQL TRACE, and TKPROF.

Confidential, Atlanta, GA

Senior Database Administrator/Developer

• SQL Server 7/2000/2005 (Windows 2000/2003 servers) responsibilities included administering clustered and non-clustered SQL Server database servers, maintaining transactional replication, capacity planning, performance tuning/monitoring (SQL Server 2005 DMVs, SQL Profiler, DBCC SHOW STATISTICS, DBCC SHOWCONTIG, DBCC DBREINDEX, DBCC CHECKDB, Performance Monitor), creating performance reports, responding to support tickets, security, data analysis, data integration, setting up maintenance plans, backing up and restoring databases using SQL LiteSpeed, setting up performance alerts, code release, process management, consulting with application developers on SSIS and DTS packages.
• I successfully migrated 8 SQL Server 2000 database servers to SQL Server 2005, setup databases, setup pull transactional replication between SQL Servers in different physical locations, setup performance alerts, database mail, and migrated DTS packages to SSIS, and setup maintenance plans for all the databases on the servers. I also setup and tested a SQL Server 2005 Enterprise 64-bit active/active cluster utilizing a SAN used at a disaster recovery facility.
• SQL Server development responsibilities included creating and maintaining reports through SQL Server Reporting Services, using SSIS to create and manage data feeds with vendors and legacy systems, data modeling, creating tables, constraints (Primary Keys, Foreign Keys, Check, Unique, and Default), indexes, user defined functions, stored procedures, views, and triggers.

Confidential, Atlanta, GA

Database Administrator (Contract)

• SQL Server 2000 (Windows 2003 servers) responsibilities included administering clustered and non-clustered SQL Server 2000 database servers, maintaining transactional replication, capacity planning, performance tuning/monitoring (SQL Profiler, DBCC SHOW STATISTICS, DBCC SHOWCONTIG, DBCC DBREINDEX, DBCC CHECKDB, Performance Monitor), security, data analysis, data integration, setting up maintenance plans, backing up databases, restoring databases, setting up performance alerts, code release, and process management.

Confidential, Atlanta, GA

Database Administrator

• SQL Server 2000 (Windows 2003 servers) responsibilities included administering clustered and non-clustered SQL Server 2000 database servers, maintaining transactional replication, capacity planning, performance tuning/monitoring (SQL Profiler, DBCC SHOW STATISTICS, DBCC SHOWCONTIG, DBCC DBREINDEX, DBCC CHECKDB, SHOWPLAN TEXT/ALL, Performance Monitor), security, data analysis, data integration, setting up maintenance plans, backing up databases, restoring databases, setting up performance alerts, code release, and process management.
• SQL Server 2000 development responsibilities included assisting developers with creating and maintaining reports through SQL Server 2000 Reporting Services, DTS packages, data modeling, creating tables creating needed constraints (Primary Keys, Foreign Keys, Check, Unique, and Default), creating indexes, creating user defined functions, stored procedures, views, and triggers.