Sql Server Data

Adam N. Wilburn

**** ********** **. **********, ** 15227

Land: 412-***-**** - Mobile: 412-***-****

****.*******@*******-*********.***

EDUCATION: Bachelor of Science - Computer Science, Mathematics

Westminster College, New Wilmington, PA

CERTIFICATIONS AND TRAINING:

MCTS: SQL Server 2008 Database Administration and SQL Server 2008 Database Developer

Microsoft Certified Professional: SQL Server 7 Administration, SQL Server 7 Database Design, SQL Server 2000 Administration, and SQL Server 2000 Database Design exams.

Microsoft Internal SPT401: SharePoint Products and Technologies

Complete JDEdwards Technical Training (complete track of JDETechnical courses)

Complete Cognos software training for both Impromptu and Powerplay (all offered coursework)

Customer Service Managerial Training

Certified Scrum Master

ITIL Foundation Certified

Six Sigma Black Belt Training

Six Sigma Lean Professional (SSLP)

Change Management Specialist (CMS)

Toastmasters Competent Leader

PMP certification classes completed – testing to be schedule

EXPERIENCE:

Celerity, Cranberry Township, PA 06/17 – 12/17

Database Administrator

Primary database resource for all data projects when working with client Fresenius medical

Team database lead for ScheduleWise platform in all SDLC based environments (Dev, QA, Staging, and Production)

Developed database architectural design models and worked to implement design changes while keeping regression work to a minimum.

Developed core stored procedures for ScheduleWise application designs.

Maintained production operating systems and database backup strategies.

Managed movements of data between environments and developed an automated process to allow on demand or scheduled database refreshes

Provided ongoing assessments of database health through periodic checks and work with product owners to allow for and present continuous improvement options

Developed database reporting mechanisms and platform in SQL Server Reporting Services

Developed reports and managed data sets for PowerBI (PowerPivot, PowerView, and PowerQuery) and Tableau based reporting

Troubleshot and fixed data integrity and invalid data issues.

Developed procedures for finding worst performing code and creating indexes or code fixes

Assisted in process development for operating a more agile development process through scrum

Applied system patches and upgrades

Worked with team to troubleshoot issues across multi-tiered architecture supporting links between Cold Fusion and Angular tiered software layers

Maintained HIPAA compliant security measures across all systems

BNY Mellon – Eagle Investment Systems Pittsburgh, PA 07/16 – 01/17

Senior SQL Server Database Administrator

Worked as the lead DBA and shift manager for evening team that is part of a larger group supporting 24/7 data and network operations.

Primary responsibility is supporting one of the world’s largest hedge funds.

Worked on developing multiple tabular based cubes for measuring KPIs including but not limited to performance, security, and policy data.

Used Microsoft PowerBI tools to build reports with PowerPivot and PowerView

Developed and implemented improved processes for database management, change management, and controls management.

Responsible for mentoring multiple SQL Server and Oracle database administrators during and outside of scheduled shifts.

Actively participated and lead activities for multiple employee resource groups in the organization.

Acted as both team and company ambassador or creating and supporting an increasingly more digitalized workplace and socialized work platform.

Supported multiple functions of IT including SharePoint, Windows Server VMs, network administration, and active directory across multiple forests.

Worked on plans to build out additional high availability solutions using SQL Server clustering and/or VMWare.

Joy Global, Warrendale, PA 04/15 – 03/16

SharePoint Contractor

Fully architected and developed an end-to-end Project Server 2013 based solution from hardware to software and reporting on relational and multidimensional structures.

Assist company in transitioning from a team based organization to a project oriented matrix type organization.

The implementation covered management of project tasks as well team based tasks using complex priorities to determine that staff is working on most relevant tasks and managing time appropriately.

Solution made use of customizations (developed using C# where necessary) in SharePoint 2013 that allowed for team members and mangers to see work stream of tasks and proposed order of completion based on portfolio management scoring similar to Six Sigma Process Management techniques.

Multiple demand management workflows were designed using Nintex Workflows.

Custom forms designed using InfoPath.

System also made use of full Microsoft BI Stack use focusing on a SharePoint Integrated Reporting Services and Analysis Services interface to manage slack in project hours and costs relevant to overall department and portfolio budgets.

Wrote an exhaustive number of reports using both reporting services and excel to work with relational (TSQL), tabular (DAX), and multidimensional (MDX) data sets.

Use Microsoft PowerBI to develop PowerPivot based reporting.

Designed BIML solutions combining multiple SSIS packages for handling mining machine data transfers to surface machines and project related data sets.

Developed new embedded mining machine interface screens/pages using .Net toolsets (C#, json, MVC, WCF, xaml, xml).

Administrated all system databases

Koppers Inc., Pittsburgh, 8/13 – 04/15

IT Architect, SharePoint/Business Intelligence

Team leader and principal systems and development architect for entire SharePoint ecosystem and Business Intelligence and data warehousing platform.

Lead the organization through implementation of SharePoint 2013 and played primary role in developing companywide site collections and governance model for extranet, intranet, and internet based SharePoint and database implementations.

Introduced concepts for data warehouse using Microsoft BI stack (SQL Server, SSRS, SSIS, SSAS, MS Office tools) and Navision financial software.

Designed architecture for ETL transformations from base Navision systems.

Played primary role in making technical decisions on platform direction and development.

Maintained business systems to be ready for day-to-day operations with minimal downtime.

Lead team through move toward a cloud based infrastructure for SharePoint Online and data assets (using Azure).

Trained and mentored staff on use of primary software based tools and efficiency for their use.

Developed DAX, MDX, and TSQL based reports to design multiple business reports customized based on Navision financials or to replace existing reports in Navision to minimize cases improperly run daily or closing reports.

In addition converted many spreadsheet based processes to report based processes using ETL and various Reporting Services or Excel based toolsets.

Designed reports using PowerQuery and PowerPivot to create new business scorecards and performance management metrics.

Created R based data reports to attempt additional data mining activities (pet project)

Administrated Oracle and SQL Server based databases.

Wilburn Solutions, Pittsburgh, PA 04/01 – Present

Independent Consultant

Providing consulting services to multiple organizations focused on IT development activities specializing in database developments, network design, and application support activities.

Act as a project manager on multiple projects and also occasionally working in supporting and implementing ERP and CRM solutions.

Clients during this work period included The Department of Defense, Dick’s Sporting Goods, Equitable Gas, Pittsburgh Public Schools, Siemens, US Filter as well as various car dealers, body shops and specialty stores.

Chesapeake Energy, Oklahoma City, OK 05/11 – 08/13

Senior Applications Developer/Analyst

Team leader who was responsible for the coordination and execution of efforts to design and develop an enterprise data model, company wide data warehousing platform, and business intelligence systems.

Performed extensive work with multiple applications and databases key to oil and gas exploration such as WellView, SiteView, RigView, FlowCal, AFEMS, Landmark, Aries, and Water Tracking systems.

Built various applications for reporting on well based activities allowing for decision support and analysis of well production, drilling, and hydraulic fracturing processes with real time data capabilities.

Worked extensively with upper management to design new metrics for more productive IT project management, solutions delivery, support, and governance.

Acted as a mentor, team supervisor, and pioneer for the organization in helping to design more robust data systems and business processes.

First president of Toastmaster’s Club for the organization. Designed systems and reports across all of the Microsoft BI stack.

This includes work with SSIS, SSAS, SSRS, DAX, MDX, query design and stored procedure design for reporting and data manipulation purposes.

Led classes to train junior level team members on new architectural, data modeling, and reporting techniques and tools using TSQL, DAX, MDX, PerformancePoint, PowerPivot, PowerView, and PowerQuery as well as various product packages such as Dundas, Tibco Spotfire, and Tableau.

Designed map based reports using ESRI maps and ArcGIS geoplotting to map well locations matched to production data.

Led organization through Project Server Implementation.

Administrated SQL Server and Oracle databases.

Booz Allen Hamilton, Atlanta, GA 06/09 – 05/11

Associate – SQL Server Business Intelligence Architect, SharePoint Architect

Responsible for leading data architecture, design, development, and requirements gathering activities for Data Warehouse, Reporting Services, and SharePoint Development .

Led project to implement SharePoint Farm for highly available reports and development.

Acted as part of Enterprise Strategy team.

Pivotal in design efforts and implementation of SharePoint sites for document management and reports.

Designed multiple dashboards using SharePoint, Performance Point, and Dundas visualizations.

Converted many existing .Net applications into SharePoint Team Pages.

Designed content for multiple SharePoint team sites across full CDC making use of custom SharePoint Designer pages, SharePoint custom lists, and InfoPath forms integration.

Worked closely with CDC staff to determine new projects and manage backlog of project work.

Responsible for managing the day to day activities of seven BI Developers and two Business Analysts while overseeing the data warehouse architecture and participating advanced development activities and software issue support.

In addition, I acted as a mentor to consultant team members and government staff on development toolsets as well as database and application design practices.

Developed extensive number of SSIS packages, SSRS reports as well as working in Excel to design and support multiple PowerPivot based reports.

Designed data sets ported to PowerView for use in drag and drop report interfaces.

Did extensive work with TSQL, DAX, and MDX in designing architectures and custom reports.

Used ESRI maps and ArcGIS to plot and track flu based activity by regions.

Maintained SAS based reports for HR department to employee counts and associated demographic information

Administrated SQL Server daabases.

Microsoft Corporation, Alpharetta, GA 11/07 – 05/09

Consulting Services – SQL Server, Business Intelligence, SharePoint

Worked with executive level employees in order to support Microsoft based solutions and solve the most critical software development, maintenance, and implementation issues for client organizations.

Typical consulting engagements required detailing the customer’s overall business goals, current projects, or technical and business strategy depending on both the client and current scenario.

Once the client’s needs were understood, work began with the appropriate individuals or teams to ensure the companies goals, projects, or strategies are in proper alignment with current best practices.

Overall my top responsibility was making sure each client was able to get the most out of their investment in Microsoft Technologies.

My primary focus was on SQL Server and Business Intelligence Architecture, Strategy, Maintenance, and Development. Through this role my knowledge and development skills were also applied in creating SharePoint Sites, using the ProClarity toolsets, and delivering PerformancePoint implementations.

Performed extensive work with SharePoint Enterprise planning and design for both document management and business intelligence use.

Deployed to Kuwait City with the USAF in order to train soldiers on using SharePoint and excel based reporting techniques.

Worked on many DoD and local government projects as well as SharePoint, architectural, storage, data warehousing, and communications projects across the MS BI Stack and storage designs for companies such as AT&T, Verizon, Time Warner, Cox Communications, Macy’s, Patterson Dental, Auto Trader, Manheim Auctions, EDMC, and Kaplan University.

Consulted on additional activities and projects for Monster.com, MTV, MSNBC, and Disney.

Interfaced and collaborated with SQLCAT VLDB management and development techniques. Worked with Architect teams in discussion and preparation for Master Certification Program Developments.

Strategic Energy, Pittsburgh, PA 06/06 – 11/07

Database Architect

In this role, I was acting as the primary and only resource responsible for managing all company wide data management activities.

The company did not have anyone looking after data administration or database modeling, or architectural design before my arrival.

Therefore this role thoroughly tested my skills in being able to survive and prosper when thrown into a highly problematic data design and environment.

Developed processes for better database management, production turnover, and overall IT development and support processes.

Lead and formed both Database Services and Production Support Teams from both external and internal resources.

The teams were then responsible for managing the day-to-day IT based business activities and focused on delivering a data driven solutions that were suited to the function and growth of the organization.

Played architectural role in designing and modeling a data warehouse from transactional database activities.

Implemented and administered Proclarity database toolsets in both SharePoint and Excel.

Remote DBA Experts (RDX), Pittsburgh, PA 01/04 – 06/06

SQL Server Projects and Administration Team Lead

My primary role was to lead database projects and manage the support staff for the company’s SQL Server division.

I was the first SQL Server resource hired and was pivotal in building the core business.

In this position, I lead and managed the day-to-day activities of the SQL Server Group and acted as the Senior SQL Server consultant.

Administrated SQL Server databases and Windows server environments for 14 different clients through remote server access.

In managing these server systems, we guided organizations through major system builds, upgrades, and day-to-day database management while training and supplementing staff as necessary.

Though I was primarily responsible for SQL Server at time my work would also require developing against Oracle or DB2 database environments.

Maintained company SharePoint pages and content.

Freemarkets, Pittsburgh, PA 12/99 – 04/01

Database Administrator/CNC Administrator

Serving as one of two data resources during the earlier days of the company’s existence, this opportunity allowed me to lead the database development of core applications.

At Freemarkets, I was able to finely tune skills in developing web based applications on clustered hardware architectures.

During my employment, I also served as the technical lead and CNC resource for the implementation of JDEdwards One World.

In this position, I also played a major role in the development the corporate Active Directory and a Siebel CRM implementation.

Administrated SQL Server and Oracle databases

Allegheny Technologies, Pittsburgh, PA 07/99 – 12/99

Database Administrator/Network Administrator Consultant

This was my first experience as the sole Database Administrator for a company.

During this contract I supported both SQL Server and Oracle databases.

I also played a major role in an implementation of JDEdwards as a clustered server solution.

Adonix, Pittsburgh, PA 12/98 – 07/99

Systems Programmer/Analyst

This was my first permanent position out of college.

During my time at Adonix, I became proficient at maintaining VAXes, writing DCL, and supporting RDB systems.

Later in this position I began working with SQL Server and Oracle developing a data warehouse for reporting from legacy VAX systems.

Contact this candidate