SUMMARY:

Primarily with Microsoft SQL Server, I have over 20 years of experience with: database development, data warehouse, business intelligence, database administration, system analysis, data analysis, application development, and solution design. My bias is to try to focus on designing, troubleshooting and maintaining applications to meet the needs of the business. I try to quickly develop an understanding of company’s operating units, their function, interaction, and effect on bottom line. I have successfully integrated multiple end - user objectives in complex technical and real time environments. I believe I have strong analytical skills complemented by an extensive science and mathematics background. I have been able to assess existing systems and develop new applications to meet customer needs.

EXPERIENCE:

Database Engineer

Confidential, Milwaukee, Wisconsin

Responsibilities:

• Performed Technical Lead DB/Architect duties which included refactoring reporting databases to make reports usable and optimizing all databases for aspects such as parallelism, transaction isolation level, and TempDB configuration.
• Performed code reviews and provided oversight of designs from requirements.
• Performed maintenance and bug fixes for SSRS, SSIS, QlikView documents and stored procedures.

Technologies: Visual Studio 2015, Visual Studio Online, SQL Server 2014, SSIS, SSRS, Git Big Data: Microsoft Azure Methodologies: Agile, Scrum

Microsoft BI Consultant

Confidential, Milwaukee, Wisconsin

Responsibilities:

• Configured SQL Server security for appropriate access for BI users.
• Created Power BI reports and SSRS reports using MDX and DAX from Multidimensional and Tabular SSAS models.
• Learned Microsoft Analytics Platform System for proof of concept to compare with other corporate products.
• Loaded 50 GB csv files with SSIS and configured into data mart in 20 hours that a consulting company had taken over 100 hours to do.
• Using SSIS loaded hundreds of Hive tables into SQL Server to profile Hive ETL for corrections.

Technologies: Visual Studio 2015, SQL Server 2014, SSIS, SSRS, SSAS Multi-dimensional MDX, Tabular DAX, Power BI, Sharepoint, Excel Pivot Tables, Oracle SQL Developer Big Data: Microsoft Analytics System Platform, R, Hadoop, Toad for Apache Hadoop, Hortonworks, Hive, Ambari, HTTP, Kerberos client, Microsoft Hive ODBC

Microsoft BI Consultant

Confidential, Milwaukee, Wisconsin

Responsibilities:

• Maintain and augment Microsoft Power BI reports using PowerPivot and Power Query.
• QA and fix SSIS packages.
• Maintain and run legacy QlikView reports.
• Prototype SSRS reports.
• Support all corporate reporting.
• Create reports to support sales initiatives.

Technologies: SQL Server 2014, SSRS, SSIS, SSAS Multidimensional, PowerPivot, Power Query, Excel Pivot Tables, QlikView, HTML

Senior Data Warehouse Developer

Confidential, New Berlin, Wisconsin

Responsibilities:

• Reverse engineered and documented an 11 year old legacy data warehouse containing 40 dimensions with over 1,000 attributes and 10 fact tables with over 1,000 measures.
• Revised to accommodate a new company sales initiative.
• Improved the accuracy of the daily correction process.

Technologies: SQL Server 2005, 2008, SSIS, Tortoise SVN

SQL Server and SSRS Consultant

Confidential, Burlington, Wisconsin

Responsibilities:

• Developed SSRS reports that combine data from Confidential GP and a custom shipping application for a $100 million in revenue manufacturer as well as correct legacy reports relying on strong T-SQL skills. Developed ERDs of source systems and utilized them to develop, validate, and correct reports.
• Deploy SQL Server Report Manager for the production environment.
• Proof of concept for deploying Microsoft ReportViewer ASP.NET control to view SSRS reports from ASP.NET application.
• Created emergency restore script when production data was corrupted to restore environment.
• Learned Confidential by reading all three of the available books on the market.

Technologies: SQL Server 2008, SSRS, Confidential GP, Visual Studio 2013, ASP.NET, C#, JIRA,.

SQL Server and SSRS Consultant

Confidential, Menomonee Falls, Wisconsin

Responsibilities:

• Convert ad-hoc SQL extracts to SSRS reports, add additional report functionality, and query optimization.
• Work with third party vendor to create scorecard dashboards.
• Administer Report Manager and SSRS subscriptions.
• Provide SQL Server coverage while Assisted Living Concepts moved its headquarters to Chicago.
• Trained new employees in SSRS development and administration.

Technologies: SQL Server 2005, 2008, SSRS, Visual Source Safe

SQL Server DBA, SSIS, SSRS Consultant

Confidential, Wisconsin

Responsibilities:

• Vacation fill-in for permanent staff. Fulfill ad hoc requests for SSIS and SSRS.

SQL Server DBA

Confidential, Milwaukee, Wisconsin

Responsibilities:

• Completed the deployment of Idera in the environment to make it operational.
• Increased the number of licenses.
• Used Idera to evaluate and optimize databases.
• Automated backups through maintenance plans.
• Created automated procedures to defragment indexes and update statistics selectively.
• Fixed failed SSIS and SSAS packages as well as improve their performance.
• Monitored and improved job execution.
• Prototyped SSRS drill-through sortable reports that showed workflow in client’s Confidential ERP package.
• Developed code to populate the staging environment for data warehouse and refactored existing solution to conform to the Kimball methodology.

Technologies: SQL Server 2008, SSAS, Idera Diagnostic Manager, Confidential NAV.

SQL Server DBA

Confidential, Green Bay, Wisconsin

Responsibilities:

• Learned the Idera SQL Server monitoring suite, improved its implementation within the client’s environment, and provided instruction in its use.
• Monitored, maintained, further developed, and provided system support for databases on 30+ server instances with Mirroring and Failover clustering with colocations in other parts of the country while the client engaged in system upgrades.
• Researched and provided solutions to persistent database issues within the client’s environment.

Technologies: SQL Server 2005, 2008, Idera Diagnostic Manager, Team Foundation Server

SQL Server 2008 SSIS Consultant

Confidential, Brookfield, Wisconsin

Responsibilities:

• While waiting to start a contract with HP, in 3.5 days, learned subject matter domain for one of client's largest customers and revised SSIS package spanning over 30 components to accommodate all the data changes requested by the customer.

SQL Server 2008 SSIS Consultant

Confidential, Mequon, Wisconsin

Responsibilities:

• Provided staff augmentation while client was working through the last phases of a legacy system migration and adding a new major customer.
• Supported and ran weekly ad hoc T-SQL data extracts.
• Automated in an SSIS package an XML data extract that had been done manually for over a year.
• Revised a SSIS package provided by an outside vendor to accommodate a new contractual requirement for a government agency customer.
• Cleared changes through required change management channels.
• Debugged and fixed errors in implemented SSIS packages.

SQL Server, SSIS, and SSRS Consultant

Confidential, Milwaukee, Wisconsin

Responsibilities:

• Turned around a stalled SSRS 2008 project migrating from Access and Crystal Reports platforms for an ongoing national research study.
• Developed, tested, and delivered 6 major reports incorporating significant analytical methodologies used by 80+ and growing major healthcare providers nationally.
• Helped the department restore its credibility.
• Wrote code for easy maintenance and to position them for the future.

Senior Data Warehouse Developer

Confidential, West Allis, Wisconsin

Responsibilities:

• Findings from data analysis and reports used to improve business process.
• Created application to automatically monitor data warehouse’s metadata and automatically defragment the data as needed to prevent performance deterioration.
• Provided design and implementation improvements that reduced data storage requirements and improved query speed as much as nine fold.
• Revenue trending reports in Cognos to audit approximately $185MM in business
• Automated 70+ reports in C# and SQL Server that were previously run manually

Technologies: Visual Studio 2008, C#, SQL Server 2000, MUMPS, Cognos, VBA, Visual FoxPro, Heat Helpdesk

Tech Lead - Data Warehouse and BI Developer

Confidential, Glendale, Wisconsin

Responsibilities:

• Developed enterprise-wide reporting system, consolidating disparate databases, reporting tools and data across four business units, ultimately migrating data to SQL server that now provides metrics that are accurate, relevant and actionable. Success of project led to JCI renewing contract 03/06.
• Built applications to benchmark activities and automate reporting and surveying processes. Introduced data dictionaries, discovery and warehousing components for database serving JCI Battery, Automotive and Controls divisions. Identified trends and developed tracking tool to monitor corporate service agreement, demonstrating that some of the initial assumptions of agreement were flawed. SLA’s included first call resolution; desk-side; CPU replacement; call volumes; ticket prioritization, etc.
• Developed a program method of reconciling the remote management tool with an inventory management tool. Earned HP’s eAward 2006 in recognition of this solution for reporting billable assets, 25% of those assets previously lost under former application; identified $125K in overbillings. Developed a ”Best in Class” Customer Survey process.
• Prepared sales presentation materials that captured the flexibility of the Altiris inventory system in the North American market, leading to roll-out of program in Europe and winning eAward 2003.

Technologies: SQL Server 2000, Crystal Reports, Oracle client, ODBC, Remedy, COM, VBA, ADO,NET, VSTO