Sql Server Sales
Resume:
Cranberry Twp, PA *****
abg9nc@r.postjobfree.com
Summary
Cory
S.
McDo
well
IT professional with 12 years of proven experience as a business intelligence architect and developer as well as a
database architect and database administrator. Career marked by consistently managing projects on time, within
budget, and to specifications. Excel in collaborating with disparate user groups to clarify requirements and design
solutions.
Work Experience
Data Systems Architect, November 2010 – Present
Millennium Pharmacy Systems, Cranberry Township, PA
Act as the sole database administrator/database architect and sole business intelligence architect/developer for all
databases in the organization (an 800 GB custom billing database, 185 custom customer application databases, the
data warehouse, and the Dynamics GP database).
Architected and implemented a secondary reporting instance to offload the majority of the reports from the billing
database to reduce locking/blocking and I/O. Use database mirroring to create the secondary instance of the
database with database snapshots occurring every 15 minutes. Executed an SSIS package to update the SSRS
data source for the reports to point to the newest database snapshot. During the implementation, upgraded SQL
2005 to 2008 and migrated all the reports.
Developed a process to take files from a third-party company of inventory counts and convert the data to files that
could be loaded into GP to determine the new inventory value. The process created exception files that were
reviewed, corrected, and then brought back into the process.
Assisted with implementing a new process to receive PO acknowledgements, PO receipts, and invoices from a new
consolidated vendor. Each file is processed to convert the vendor item number to a GP item number and load the
file into GP using Integration Manager.
Technical Specialist, June 2006 – November 2010
Dell (formerly Allin Consulting), Pittsburgh, PA
Serve as the lead role in all aspects of the Microsoft SQL Server stack (Database Engine, Analysis Services,
Reporting Services, and Integration Services). This includes training peers on different technologies, working on
complex projects, and serving as a technical lead on other projects.
Architected and developed many BI projects of varying sizes and complexity. All the projects used a variety of
Microsoft technologies including SharePoint 2010 with Excel Services and PerformancePoint Services, Analysis
Services, Integration Services, and Reporting Services. Some of the projects also included dashboards that
provided instant insight into different aspects of the company using graphs, charts, and KPIs.
Executed many SQL Server performance audits for various types of clients to determine bottlenecks, unused
indexes, duplicate indexes, and missing indexes. These audits also included rewriting triggers and stored
procedures, many with thousands of lines, into more concise operations that made the code easier to read and
frequently improved performance by 50% or more.
Developed custom scripts to gather information about SQL Server instances. The information included databases in
each instance, sizes of databases and transaction logs, percent of free space in the files, last backup, SQL Agent
jobs, and other information. These scripts were used frequently at clients to inventory the databases on all the SQL
instances. The results were then evaluated to determine missing maintenance routines along with hardware
recommendations.
Worked on several data warehousing projects that ranged from designing the database, creating ETL processes,
optimizing ETL processes to populate an existing data warehouse, creating Analysis Services cubes, and
developing reporting against the data warehouse and\or cubes.
Designed and developed multiple Analysis Services cubes for clients to allow them to slice and dice their data in
order to make better business decisions. The cubes included things such as custom MDX for calculated measures
and custom security to prevent users from seeing sensitive data regardless of how the cube is accessed.
Developed numerous Reporting Services reports ranging from simple reports to very complex. The reports
extracted information for various data sources, such as SQL Server, Oracle, SharePoint lists, Analysis Services, and
CRM databases. Some of the reports included custom code, advanced grouping, and custom drillthrough.
Developed many Integration Services packages to perform ETL tasks. Upgraded DTS packages to SSIS by
evaluating the DTS package and determining the best way to perform the same tasks in SSIS. When the standard
tasks would not produce the expected results, scripts were used with custom code.
Created hundreds of complex stored procedures for various uses including data extracts, data sets for reports, and
various custom applications. Often times, there was little or no information about the database prior to work
beginning, which required learning the tables, relationships, and data quickly to complete the task in the specified
amount of time.
Performed both internal and external training on several topics including SQL Server monitoring, SQL Server
backups, T-SQL and indexing basics, and SQL 2008.
Keep up with the technology in a fast-paced, ever changing environment and at the same time getting projects done
on-time within budget.
Manager – Application Development, June 1999 – June 2006
Fairmont Supply Company, Canonsburg, PA
Installed, configured, modified, and maintained a SQL Server data warehouse supplied by the ERP software
company. Created and continue to create custom DTS packages, views, and stored procedures that were used in
the preparation of building cubes. The cubes were created in MS Analysis Services. Used virtual cubes to handle
sensitive information, so that users can only see information that they are setup to view. The cubes are used by all
levels of the company to make business decisions using ProClarity. Wrote various MDX expressions to handle
various issues.
Designed, coded, and implemented a sales forecasting system using a SQL Server database as the backend and a
Microsoft Access Data Project front end. The system allows more than 50 users (sales reps and warehouse
managers) to enter the projected sales for the upcoming year or make revisions to the current year forecast at
specified times of the year. Coded security to allow the administrator to specify what sales reps can be seen by a
particular user.
Created a SQL Server database to hold third party product information. The information was presented in text files
that were zipped and burnt to CDs. Determined the structure of the data with limited assistance from the third party.
Wrote a script to open the zip files, unzip the text files, and load the corresponding tables.
Researched, analyzed, coded, implemented, and maintained tables, relationships, and databases using various
commercial products (i.e., Progress, Microsoft Access, & SQL Server). Without formal training, learned Progress
coding techniques to program routines to load and extract data. Also, learned T-SQL techniques to program ETL
routines, scripts, and DTS packages to perform various functions. Allowed the company to avoid cost and time
delay associated with contracting work out to consultants.
Served as lead role in developing complex programs to extract data, load data, and create reports as decision
support tools for use by all management levels within the company. Development includes researching, analyzing,
designing, programming, testing, documenting, and executing. Programmed 300 decision support routines
necessary to prepare the sale of more than half of our business. Routines covered inventory valuation, sales by
customers, recommended min/max values, and inventory stratification.
Converted and migrated data from legacy system to new ERP system. In six months versus the projected nine
months, single-handedly coded, tested, and executed 200+ programs to load all data (i.e., G/L, A/R, A/P).
Completed this task using multiple coding languages.
Oversaw and delegated work to two individuals. Assisted them with any questions they had, but challenged them as
much as possible.
Computer Skills
Software: Microsoft SQL Server 2000\2005\2008, Analysis Services 2000\2005\2008, SQL Server Reporting
Services, SQL Server Integration Services, DTS, PerformancePoint Server, PowerPivot, Microsoft Access,
UNIX, ProClarity, Brio, Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Visio, Microsoft Dynamics GP
Languages: T-SQL, SQL, Progress, VBA, EasyTrieve Plus, COBOL, VB.Net, MDX
Certifications
MCITP: MS Certified IT Professional - Database Administrator
MCTS: MS Certified Technology Specialist - SQL Server 2005
MCTS: MS Certified Technology Specialist PerformancePoint Server 2007
MCDBA: MS Certified Database Administrator
MCP: MS Certified Professional
Education
BS in Management Information Systems, August 1999
Penn State Erie, The Behrend College, Erie, PA
3.69 GPA
Honors: Honors Certificate Freshman and Sophomore years, Dean’s List – 8 semesters
Contact this candidate