For a complete resume send email to will_fadel at hotmail dot com
SUMMARY
Early Adopter with a zeal for learning new technologies -- see Self Study
entry under the "Education" Section
12+ years of database administration, development & programming (OLTP & OLAP):
Access 2.0- 2007, SQL 6.x - SQL 2008
12+ years of expert level T-SQL development, VBA
12+ years of Data Modeling, Architecture (Physical/Logical)
12+ years of direct interaction with all levels of end-users with a focus on
mapping workflows, BPM and dataflows
10+ years of extensive experience with ETL projects (DTS, SSIS) and exposure
to other non-Microsoft tools
10* years of advanced performance tuning, replication, Log Shipping and
Clustering
10+ years of heavy duty VLDB (4+ TB) administration and maintenance
8+ years of C# & VB programming experience
8+ years of WSS & SharePoint administration, customization, architecture and
programming
7+ years Heavy experience with VLDB (4+ TB) and very large data transfers (2+
TB)
7+ years of extensive experience with DW and SSAS (2000 - 2008) - Star &
Snowflake
7+ years of advanced expertise in MDX queries and data mining (DMX)
7+ years of building Report Portals with SSRS (2000 - 2008) and SharePoint
(2001 --> 2007) or WSS (2.0 & 3.0)
5+ years experience of programmatically converting numerous DTS packages to
SSIS (DTSX) formats
2+ years experience working with all features of SQL 2008 and use of all new
enhancements
Recent test by Microsoft and placed in the 94th Percentile for SQL Server
expertise
TECHNICAL SKILLS
Technical Focus:
Business Intelligence (SSIS, SSAS, SSRS), SharePoint Development and Integration
(OBA, Excel
Services, BDC, VSTO), MS SQL Server Development
Programming Languages:
C#.Net, VB.Net, VBA, T-SQL, VB5-6 and C++
Scripting / Web Languages:
ASP.Net 1.1 - 3.5, ASP, VBScript, JavaScript, ColdFusion Markup Language (CFML),
HTML,
DHTML, XML, XSL, CSS, WSH, Shell Scripting and Summation Scripting
Data Access Technologies:
ADO.Net 1.1 - 3.5, ADO, ActiveX, OLE DB, ODBC, DAO, RDO, JRO
Components:
COM/DCOM/COM+, MTS, MSMQ
Databases:
MS SQL Server 6.x - 2008 SP1, Access 2.0-2007, Oracle 8i-10g and dBase IV+ and
others
SQL Tools
BCP, DTS/SSIS, SSAS, SSRS, SSNS and SSSB
Doc. Mgmt. / Portal Systems:
SharePoint Portal Server (2001 -2007), iManage, HummingBird, Content Management
Server
Software Tools Used:
VS.Net (2003-2008) & 6.0, MS Office Dev. 9x, 2000, XP & 2007, ColdFusion Studio,
VSS
Operating Systems:
NT 3.x,4.x, 2000, 2003, 2008, Windows 3.x, 9.x, 2000 and XP; DOS, Unix
Data Modeling Tools:
Visio, Embarcadero's ER Studio 7, ConceptDraw, ERWin
Reporting Tools:
Crystal Reports, SQL Server Reporting Services (SSRS). Actuate Reports
Currently Studying
ASP.Net 3.5, LINQ, SOA/Web Services, Entity Framework development
Performance Point Server, Silverlight 2.0 and Windows Workflow Foundation
IT/MIS EXPERIENCE
01/2010 - 02/2010
CalWater (Robert Half)
Sr. Consultant
San Jose, CA
Implemented a Full MS BI Prototype to train Developers, End Users and
Technical Staff
Installed, configured and customized SharePoint (MOSS 2007 Ent.) in integrated
mode with SSRS 2008
Designed and implemented complex dynamic SSIS (ETL) packages (SSIS 2008)
Developed complex dynamic SSRS Reports 2008 (Parameterized Matrix Multilevel
DrillThroughs / OLTP & OLAP)
05/2009 - 07/2009
Bank of NY Mellon (ADS)
Sr. Consultant
San Francisco, CA
Designed and implemented complex dynamic ETL packages (SSIS 2005)
Working with Business and Technical users, developed complex dynamic SSRS 2005
(Parameterized Matrix Multilevel) Reports
Converted various Crystal Report reports into SSRS reports
Integrated SSRS 2005 BI reports with SharePoint (WSS 3.0)
02/2009 - 04/2009
TekSystems (Omniture)
Sr. Consultant
San Francisco, CA
Designed and implemented complex dynamic SSIS 2008 packages - Pipeline &
Staging table QC
Wrote, edited and optimized Stored Procedures, T-SQL queries, CTEs and
Functions (SQL 2008)
Designed and implemented Data Models (Visio, ER/Studio)
SQL 2008 Server Performance Tuning and T-SQL Query Performance tuning
12/2008 - 02/2009
KForce Prof. Staffing (McKesson)
Sr. Consultant
San Francisco, CA
Designed and implemented complex dynamic SSIS 2005 packages
SQL 2005 Server Performance Tuning, T-SQL Query Performance tuning
Designed archiving and table partitioning strategy to deal with reduced disk
space and performance degradation
06/2008 - 10/2008
Hicks Consulting (CNet)
Sr. Consultant
San Francisco, CA
Working with Business and Technical users, developed and Integrated SSRS 2005
BI reports with SharePoint 2007 (WSS 3.0)
Developed KPI Dashboard and BI Report Portal Integrating SSRS 2005 with WSS
3.0
Tuned the performance of underperforming queries and optimized indexes on
large tables in Client's Databases
10/2007 - 06/2008
CE2 Corporation, Inc.
Sr. Consultant
Pleasanton, CA
Created dynamic SSIS 2005 packages programmatically
Converted Legacy ETL Packages from Macros, Stored Procedures and DTS to
Dynamic SSIS Packages for SQL 2005
Created complex custom ETL Scripts and SSIS packages to Scrub GeoSpatial Data
for ESRI / GIS applications
Built Prototype GIS applications with SQL 2008 RC0 - using Geometry CLR Data
types
Designed, Administered and Developed MOSS 2007 and ASP.Net 2.0 (C#) LOB
Applications
Created ASP.Net 2.0 (C#) EVMS Reporting Application and Integrated it with
SSRS 2005
Developed and Integrated SSRS 2005 BI reports with SharePoint 2007 (MOSS)
Designed and Developed a Prototype Office Business Application (OBA) using
Visual Studio Tools for Office (VSTO)
7/2007 - 10/2007
Engineering Solution, Inc (Sprint)
Sr. Consultant
San Francisco, CA
Converted Legacy ETL Packages from Macros, Stored Procedures and DTS to
Dynamic SSIS Packages for SQL 2005
Designed and Upgraded Physical and Logical Database Architecture from Access
2003 and SQL 2000 to SQL2005 (64Bit)
Converted Legacy near real-time reporting application (consuming IDEN Data)
into a WinForm C# application
Designed and Prototyped an SSRS 2005 Reporting Architecture and Created
Reports based on said architecture
Performed Performance Tuning and Improved overall Performance of DBs by an
average factor of 10 Times
3/2006 - 12/2006
Wells Fargo
Sr. DBA / BI Developer
San Francisco, CA
Upgraded 200+ SQL 2000 DTS packages to SQL 2005 (SSIS) package format
Designed Technical Architecture (Dimensional Modeling, Physical Design, ETL
Development)
Prototyped an OLAP Star Schema (SQL 2000) - Kimball Method
Created, Tested and Deployed ETL Packages (SSIS 2005) and Scripts to populate
relational Data Mart
Converted Unix Shell Scripts to T-SQL Scripts, C# Components, VB.Net ETL
scripts and SSIS transformations
Designed Complex SSIS packages interfacing SQL 2005 with Oracle 10g
Gathered and documented business requirements, Security requirements,
Enterprise Data Sources and External Data Feeds
Designed Snowflake Schema based on the assessment for end user reporting and
Analysis needs
Developed Business Analysis Applications and Ad-Hoc/Custom reports using MOSS
2007, SSRS 2000/2005 and Crystal Reports
Migrated Oracle 10g Databases, PL/SQL Scripts to SQL 2000/2005
Installed SQL 2005 and all necessary tools in the Development, Staging (UAT)
and Production Environments
Installed and utilized the Oracle 10g .Net Data Provider for use with SQL 2005
and VS.Net 2005
Collaborated with other Business units and Designed a blueprint for a
SharePoint 2007/Office 2007 based reporting portal
4/2004 - 3/2006
California Medical Association
Sr. SQL DBA / Developer
San Francisco, CA
Created Procedures, DTS & SSIS ETL packages to consolidate data CMA's 36
County Societies, MBC and the AMA.
Created, Tested and Deployed ETL Packages (SSIS 2000 & 2005) and Scripts to
populate relational Data Mart
Designed, implemented and maintained several 9+ TB Databases and their related
Cubes
Created Multidimensional Expressions (MDX) and Data mining Expressions (DMX)
for use with SQL 2005 by End Users
Working closely with CMA users, Senior CMA Executive staff and various County
Executives to gather requirements and
specifications for various Data Interoperability / Data Warehousing projects.
Developed SSRS 2005 architecture and applications to allow end users to
transmit data and create ad-hoc reports.
Developed various applications such as CMA Directory, Call Tracking, Policy
Compendium Automation and Contract
Management Database applications that automate document and report creation via
the office suite and SSRS 2005.
Designed and deployed various Crystal Reports and Access 2000 Data Projects to
allow users to dynamically query SQL data.
Using various Data Modeling tools, designed UML and ORM Schemas and Use Case
Scenarios for Enterprise Solutions
Converting legacy multi-value system (MVS) mainframe database to a MS SQL OLTP
and Data Warehouse / OLAP Cubes.
Converting legacy VB applications to VB.Net, ASP.net and C# and ColdFusion
code to ASP.Net (C#).
Integrating an Interwoven (iManage) document management system (DMS) with
SharePoint Portal 2003
7/2003 - 3/2004
VARIOUS STAFFING AGENCIES
Consultant
Bay Area, CA
HummingBird DMS Integrator - Intel [Spherion]
Implemented, maintained and administered HummingBird Portal, DM 5.1 with
Collaboration, Imaging and WorkFlow.
Integrated existing workflow applications with HummingBird WorkFlow using
ASP.net.
Gathered requirements for ASP.Net applications and created design documents
Integration Engineer - Reed, Smith, Crosby, Heafey [Apex Systems]
Created ActiveX routines (DTS to Access, Summation and Concordance) and
Scripts to populate Litigation DBs
Created Litigation Support Databases using Access 2000, Summation and
Concordance.
Integration Engineer - iEnvision Technologies, Inc. [Robert Half Int'l]
Created DTS packages for the Metadata extraction of File information of over
200,000+ documents for migration
Installed, Administered SQL server backend for WorkSite Server 7.2, WorkSite
4.x, MailSite, Office 2000 Integration Module
Installed, configured and deployed HummingBird Backend System Components.,
Client installations and Customizations
Converted Lotus Notes R5 Document Management System into iManage DMS format
for a large financial firm.
Converted Legacy DMS in a Mac OS/Unix environment into HummingBird DMS/Win
2000 for a midsize law firm.
Designed and tested customization functions of HummingBird DMS/WebTop & Portal
for client using JavaScript.
5/2002 - 5/2003
Sedgwick, Detert, Moran & Arnold
Sr. Application Developer
San Francisco, CA
Application Development
Converted Legacy Access Database libraries, references and classes from 16 bit
to 32 bit, or re-created their functionalities.
Migrated and consolidated 70+ MS Access Databases
Managed development of new Client/Server applications and created guidelines
for creation of N-tier applications.
Implemented an OLAP Data warehouse to Create BI reports using Crystal Reports
& Excel for a Multi-Million dollar Arbitration.
Designed various Stored Procedures in SQL 2000 and DTS packages to automate
various IT administrative tasks and
Litigation Support projects and using WSH, Shell Scripting, VBScript, ActiveX
and DTS
Using the DTS object model, programmatically created dynamic DTS packages for
redistribution as bas modules
Designed and Modeled a document metadata repository in order to allow for
migration to a new Document Management
System
Designed, created and maintained separate Development environment for the firm
employing the following tools: Visual Studio,
SQL Server 2000, Office XP Dev, Visual SourceSafe and Separate testing
environment for deployment of new applications
Prototyped environments for Windows 2000, SQL 2000, Exchange 2000, SharePoint
2001, SharePoint Team Services (WSS)
Migrated some VB6 apps to VB.Net and customized portal using C#.Net, ASP.Net
and XML
Using an Access 2000 Access Data Project (ADP), Designed a reporting interface
with CMS Open for the CFO to generate
dynamic financial reports. Designed and created, Views, Stored Procedures,
Triggers and DTS Jobs for External Data Imports.
Portal, Intranet, Internet and Extranet Development
Redesigned, tested, deployed, and supported firm's XML/XSL Internet website
and Intranet applications.
Designed, tested, and deployed various SharePoint webparts using C# and
VB.net.
Implemented a digital dashboard / Portal solution allowing the firm to
integrate and centralize structured data (normalized) and
non structured data (non-normalized) - employing ASP, XML/XSL, COM, SQL Server,
MS Exchange, N-Tier Architecture,
SharePoint Server and MS Office XP applications to create collaborative tools
and Web Parts
Supported and re-designed and re-architected the Firm's XML/XSL Internet Site
and Intranet ASP, JavaScript, DHTML, CSS, etc
7/2001 - 5/2002
VARIOUS STAFFING AGENCIES
Consultant
Bay Area, CA
App. Developer & Help Desk Orrick, Herrington & Sutcliffe [PC Personnel]
Developed and deployed a Help Desk Access 2000 application used to inventory
hardware and usage for the SF Branch office
Created custom usage reports for the help desk from the Remedy CRM MS SQL
Backend using Access and Excel
Debugged errors in DeltaView, PC Docs and various other applications.
Relocated Help Desk, deployed PCs, installed new software and migrated DMS to
the Office 2000 environment.
Fielded 50-75 calls per day for the Call Center, and escalated calls to higher
help desk tiers as needed.
Legal App. Developer Various Chicago / San Francisco Law Firms [Independent]
Developed and deployed SQL based Applications and Administered SQL Database
backups, recovery and security.
Automated, designed, created and maintained DTS packages programmatically
Completed Access 2000 and MS Office Automation projects for a Custom Contract
Tracking and Billing Database
Completed various Website development projects utilizing ASP, ActiveX,
JavaScript, ADO, SQL and XML/XSL and DHTML.
02/2001 - 07/2001
True Points, Inc.
Sr. Web Developer
Chicago, IL
Synchronize the Cold Fusion and SQL changes made between the Development and
Production environments via DTS
Developed complex DTS packages that imported client information into DW
Developed Cold Fusion 4.5 and ASP applications using SQL 2000 as a back end on
Windows 2000.
Designed Physical and Logical (Data Model and Schema) Structure of the main
transactional SQL database for the company
Created SQL Server 2000 triggers, temporary tables, stored procedures,
extended stored procedures, and cursors.
Created extended stored procedures using C++ to enhance SQL Server security
and prevent injections attacks.
Developed Cold Fusion 4.5 applications using SQL 2000 as a back end on Windows
2000
Using Access 2000 Designed a Bug Tracking / Task List Database that generated
Excel Task Lists and emailed to Dev Team
10/2000 - 02/2001
First Union Securities.
Application Developer
Chicago, IL
Designed complex DTS Packages to extract data from Informix DW into SQL for
Data Analysis and Reporting
Designed data warehouse financial reports using Access, Excel, Crystal Reports
8.0, e-Actuate Reports, and Informix SQL
Re-designed and enhanced an automated response Multi-User Access 2000 Database
for the Data Warehouse Team.
Using Access 2000, linked to an Informix database and automated dynamic report
creation and Excel import to generate over
300+ Formatted Excel reports dynamically, saving FUS $3 Million+
|
