D.L. Williams

Freelance Database Expert & Book Writer

Location:Phoenix, Arizona, United States
2 Skills
Specialized Skills and Aptitudes:
I have specialized in developing reports, distribution reporting systems, decision support systems, executive information
systems and business intelligence software solutions. These solutions have utilized a wide range of technologies,
? SQL Server 7, 2000-2008 (SQL Server Analysis Services, SQL Server Data Transformation Services,
Integration Services, Reporting Services)
? Advanced T-SQL Techniques and Stored Procedure Design.
? Troubleshooting and Performance Tuning
? Legacy RDBMS Proficiency (Teradata, DB2, Etc.)
? Crystal Reports
? Visual Basic (.Net)
? ASP and ASP.Net
I am very well rounded with experience in programming, analysis and operations management. I have experience defining
key performance measures for various operations, managing to those performance measures and also the necessary
skills to build effective IT solutions to report on operations, at an enterprise level.
? OLTP and OLAP Database Design and Documentation
? Advanced SQL programming and automation.
? Multiple Report design and delivery tools.
? Website design and programming.
? End-to-end management information processing and report platform development and administration.
? Effective communication in gathering various sets of system requirements.
? System unit testing and user acceptance review.
? Workflow process analysis, evaluation and enhancement.
Development/Software Proficiencies:
? N-Tier Application Design.
? SQL based transactional and reporting system design.
? ADO.Net, ODBC, OLE-DB (ADO), RDO proficiency.
? SQL Interface analysis tools and presentation packages (Visual Basic and Interdev6, Seagate Software products).
? OLAP, EIS, business intelligence and related software packages and engineering.
? Software packages:
MS SQL Server and Analysis Services MS Visual Studio (6 and .NET)
MS SQL Server Reporting Services Business Objects XI
Seagate Crystal Reports (Server and Web
MS Access, Macros and some VBA
MS Excel 2000 OLAP Reporting Brio Enterprise (Similar to Cognos and Business
Macromedia MX Suite HTML and ASP (VB and Java Script)
Internet Information Server Borland Visual C++ Builder
Teradata RDBMS
CRM and Specialized Business Applications:
EDS Metavance
QCSI QMACS Version 4.8, 4.10, QNEXT
Remedy Support
Portera Invisic Version7
Platinum ERA Version 7
Sales Logix
Western International University.
2002-2004 Information Systems
G.P.A.: 3.53
University of Phoenix.
1997-2001 Business Management/Information Systems
1994-1995 G.P.A.: 3.37
Sanford-Brown College.
1992-1993 Computer Programming
G.P.A.: 3.67
Saint Louis Community College. (Florissant Valley Campus)
1988-1990 Mathematics/Engineering
G.P.A.: 3.3
Employment History:
2007-Current Genesis Development West Inc.
Database and Reporting Consultant-1099
Worked with multiple clients to build or update SQL database reporting platforms and other specialized
applications. Toolset includes: SQL Server, SSIS, SSRS, OLAP Applications, Business Objects,
Crystal Reports, Raw T-SQL and Stored Procedures (for SQL Server Express implementations), MS
Access and Excel, and more.
2006-2007 Nautilus Insurance Group
DBA-Reports and Specialized Applications
Build and Administer multiple application databases, datamarts and application backend data
processing. Utilize T-SQL, SQL-Server 2000 and 2005, DTS, Datastage, MS Analysis Services,
Hyperion Essbase, Business Objects, Brio, MS Reporting Services etc. Responsible for
troubleshooting and performance enhancements to existing SQL procedures and also designing
and building new processes, procedures and database objects.
2005-2006 Blue Cross Blue Shield of Arizona
Business Intelligence Analyst
Process analysis and requirements documentation. Programming in Teradata and SQL Server
RDBMS with Business Objects and MS Access as front-end tools.
2003-2005 Schaller-Anderson
Systems Analyst-Reports
Build and maintain corporate report systems and files. Work to streamline current
process and report distribution methodology. Technical Support of existing report
selections. Troubleshooting any report issues on an on-call basis.
2000-2003 The Alexander Group
Enterprise Report Systems Engineer
Build and administer enterprise reporting systems, delivered in both the web and clientserver
environments. The data warehouse/ staging structures are built
in SQL Server 2000. The ETL Processes are built via SQL Server DTS services so no other specialty
software was required to move and format data. Reports are built in Crystal reports and ASP
(depending on the required functionality). Applications utilize
both client and server-side scripting technologies. Visual Studio, SQL Server and Seagate Crystal
Reports encompassed the tool set. I also worked with SQL 2000 analysis services with Excel XP to
meet site analytical needs.
2000-2000 Telephia
Data Applications Developer
Build and administer enterprise reporting systems (internal). Utilize SQL Server
(views and stored procedures), Crystal Reports, HTML and ASP to
deliver decision support reporting and analysis, via corporate intranet. Define
file structure and automated posting (Seagate Info) and detailed (dimensional)
analysis (Seagate Analysis). Expanded reporting fact tables to OLAP data sources
via SQL Server 7 OLAP Services. Evaluated various enterprise data warehouse
solutions (emphasis on Brio).
1999-2000 Knowledgenet
Database Analyst
Organize, create and administer all marketing and sales reporting structures via
SQL Server 7, Crystal Reports, MS Access and Visual Basic. Create complex query
views to collect information used as the basis for the corporate EIS database
and Crystal reports. Supervise training and workflow for junior analysts. Also in
charge of specialized applications programming for sales lead allocation and clean-up.
1998-1999 McKesson Healthcare Delivery Systems
Core Technologies Analyst
Analyze, design and document solutions to complex operational issues, related
to current production operations, systems additions, enhancements and special
client requests (Oracle and Microsoft environment). I work very closely with
operations and IS Development to ensure that project requirements and
objectives are met and properly documented. Within the department, I
specialized in internal organization, and projects that required a high level of
structure and control reporting. I was requested to develop an
internal system, by which analyst and team project hours spent could be
recorded and evaluated for future project sizings (MS Access Database).
Customer Service Unit Supervisor
Multiple Sclerosis Pathways (Berlex Betaseron Program) Customer
Service Unit (CSU). Inbound and outbound call center supervision,
staffing, training and quality control. Responsible for process
improvements, meeting CSU statistical performance measures and
employee relations. Organizing and managing specialized CSU
operating areas (Alternate Distribution Methods). Creating and maintaining
complex statistical tracking and reporting tools (MS Access Database).
1997-1998 ENCORE Staffing (On-Site at WorldCom Wireless). Phoenix, Arizona
Manager-Call Center Training and Staffing
*Short Term Consulting-Department Operations Enhancements: Creation of a Department Reporting
System (Over-All Department Standings, Supervisory Team Standings and Individual CSR Results).
*Program Development and Management. Manage all aspects of recruitment and training for contract
call center CSRs (800 hour temp-to-perm).
1993-1997 Express Scripts Incorporated. Tempe, Arizona
Supervisor-Department Operations
*Call Volume and Workflow Management-Ensured effective Call volume
distribution and penetration via multiple hunt group, ACD System.
Design, Implement and Support basic and supplementary department
functions (i.e. Pharmacy, Claims Reimbursement and Billing research
*Direct Staff Supervision-Day to day motivation and support of 45 CSRs, 4 Lead
Representatives and 4 Research Coordinators.
*Tracking and Reporting Department Progress-Maintained daily statistical results from all
areas of Customer Service. Responsible for producing all reports on Department or
Individual performance. Responsible for maintaining the department’s periodic report
submission schedule.
*Interdepartmental Communication-Demonstrated effective use of communication skills in
interacting with staff and all levels of management. Demonstrated effective written and oral
communication skills.
Trainer/Lead Representative
*Direct Representative Training-Responsible for designing , implementation and maintaining
training material and procedures. Responsible for classroom, on-the-job and follow-up
training of Customer Service Staff as well as oral presentations.
*Documentation-Responsible for reviewing and documentation all new procedural information
presented to the department. Responsible for creating training guides and step-by-step
system manuals.
Customer Service Representative
*Basic CSR Duties-Provided benefit information to members via inbound
“800” number.
*Performed other c
Skills (2) Rating
Book Writing