TECHNICAL SKILLS
Technical Focus: Business Intelligence, Enterprise Application Integration,
Collaboration and Automation
Programming Languages: C#.Net, VB.Net, VBA, T-SQL, VB5-6 and C++
Scripting / Web Languages: ASP.Net 1.1 - 2.0, 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 - 2.0, ADO, ActiveX, OLE DB, ODBC, DAO,
RDO, JRO
Components: COM/DCOM/COM+, MTS, MSMQ
Databases: MS SQL Server 6.x - 2005 SP2, Access 2.0-2003, Oracle 8i-10g and
dBase IV+ and others
SQL 2005 Tools: 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-2005) & 6.0, MS Office Dev. 9x, 2000 & XP,
ColdFusion Studio, VSS
Web Servers: IIS 3 - 6, ColdFusion Server 4.x
Operating Systems: NT 3.x,4.x, 2000, 2003, Windows 3.x, 9.x, 2000 and XP; DOS,
Unix
Data Modeling Tools: Embarcadero's ER Studio 7, ConceptDraw, ERWin
Reporting Tools: Crystal Reports, SQL Server Reporting Services (SSRS)
IT/MIS EXPERIENCE
06/2008 - 9/12/2008
Hicks Consulting (CNet)
Sr. Consultant
San Francisco, CA
* Installed, Administered and Customized SharePoint 2007 (WSS 3.0 ), Report
Portal for the Business Network group
* Prototyped and Demonstrated a Performance Point Server and SharePoint 2007
(MOSS) Portal Solution
* Integrated SSRS 2005 with WSS 3.0
* Tuned the performance of underperforming queries and defragged indexes on
large tables in Client's Databases
* Working with Business and Technical users, developed and Integrated SSRS 2005
BI reports with SharePoint 2007 (WSS 3.0)
10/2007 - 05/2008
CE2 Corporation, Inc.
Sr. Application / BI Developer
Pleasanton, CA
* 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
* Created custom ETL Scripts and SSIS packages to Scrub Environmental and
GeoSpatial Data for ESRI/GIS applications
* Developed and Integrated SSRS 2005 BI reports with SharePoint 2007
* Mentored and trained users on T-SQL, VBA and other languages
* Designed, implemented and supported Enterprise level Hardware, Software and
Networking
7/2007 - 10/2007
Engineering Solution, Inc (Sprint)
Sr. DBA / BI Developer
San Francisco, CA
* Converted Legacy near real-time reporting application (consuming IDEN Data)
into a WinForm C# application
* Designed and Upgraded Physical and Logical Database Architecture from Access
2003 and SQL 2000 to SQL2005 (64Bit)
* Converted Legacy ETL Packages from Macros, Stored Procedures and DTS to
Dynamic SSIS Packages for SQL 2005
* 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
5/2006 - 12/2006
Wells Fargo
Sr. DBA / BI Developer
San Francisco, CA
* Gathered and documented business requirements, Security requirements,
Enterprise Data Sources and External Data Feeds
* Designed Technical Architecture (Dimensional Modeling, Physical Design, ETL
Development)
* Designed Snowflake Schema based on the assessment for end user reporting and
Analysis needs
* Developed Business Analysis Applications and Ad-Hoc/Custom reports using SSRS
2000/2005
* 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
* Upgraded SQL 2000 DTS (ETL) to the new SQL Server Integration Services SQL
2005 (SSIS) format
* Converted Unix Shell Scripts to T-SQL Scripts, C# Components, VB.Net ETL
scripts and SSIS transformations
* Designed Complex SSIS packages interfacing SQL with Oracle 10g
* Collaborated with other Business units and Designed a blueprint for a
SharePoint 2007/Office 2007 based reporting portal
3/2006 - 5/2006
Wells Fargo (TMC Software)
Consultant
San Francisco, CA
* Prototyped an OLAP Star Schema (SQL 2000) - Kimball Method
* Created, Tested and Deployed ETL Packages and Scripts to populate relational
Data Mart
4/2004 - 3/2006
California Medical Association
Sr. SQL DBA / Developer
San Francisco, CA
* 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.
* Created Procedures, ETL packages to facilitate the consolidation of data from
CMA's 36 County Societies, MBC and the AMA.
* 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 MX
code to ASP.Net (C#).
* Integrating an Interwoven (iManage) document management system (DMS) with
SharePoint Portal 2003
* Created Multidimensional Expressions (MDX) and Data mining Expressions (DMX)
for use with SQL 2005 by End Users
7/2003 - 3/2004
VARIOUS STAFFING AGENCIES
Contract 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 Litigation Support Databases using Access 2000, Summation and
Concordance.
Integration Engineer - iEnvision Technologies, Inc. [Robert Half Int'l]
* 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 and
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 synchronized
the data pertaining to users' iManage / WordAssist customizations across the
enterprise using WSH, Shell Scripting, VBScript, ActiveX and DTS
* 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
* Designed, created and maintained separate Testing environment 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
* 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
Contract 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
* 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
* Synchronize the Cold Fusion and SQL changes made between the Development and
Production environments via DTS
* 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 SQL DTS Packages to extract data from Informix Data warehouse 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+
11/1999 - 10/2000
Avenew.Com, Inc
Web Application Developer
Itasca, IL
* Researched, analyzed, developed and implemented a wide range of enhancements
to existing and new applications.
* Designed dynamic Cold Fusion applications, and integrated Java Applets and
Servlets and Crystal Reports.
* Created a SQL backend / ASP front-end to track bugs in the testing stages of
development.
* Created SQL stored procedures, triggers, temporary tables, views, and
cursors.
04/1997 - 11/1999
Various Small Law Firms
Legal App. Developer / Consultant
Chicago, IL
Full System Life Cycle Development - Customized solutions for small to midsize
law firms
* Conducted Interviews with Clients (Attorneys and Paralegals) and Determined
Software and Hardware Needs
* Designed Multi-User Client Server Database centric applications using Access
97 and 2000 or Visual Basic Front End and SQL Back End for use by internal
corporate departments and law firms
* Using Access and Excel VBA, designed wizards that allowed the users to create
custom reports based on the customized tables, queries and report Templates for
their changing business requirements
* Using VBA allowed users to dynamically create Tables, Forms, Queries, Reports
and Modules
* De-normalized Database Tables to boost performance; Secured Databases for
Remote Access By External Users (RAS)
* Replicated Access Databases for Synchronization for Laptop users using JRO
* Designed and updated intranet sites for client using ASP, JavaScript and SQL
to allow users to dynamically update content
* Tested, implemented and debugged new applications; conferred with clients
regarding system changes/modifications
* Provided advice, assistance and technical support for users with new
applications
* Documented all development made to database applications used for billing and
source control
* Migrated various Visual Basic 4 applications to Visual Basic 6
* Created Functions, Subroutines; Debugged applications; Optimized Performance
using VB 6
LEGAL / RELEVANT EXPERIENCE
02/1997 - 02/1999
Universal Outdoor, Inc.
Corporate Paralegal / Application Developer
Chicago, IL
Reported to General Counsel
Database Programming & Technical Support
* Designed Access 97 Multi-user Database (VBA) for department use to track
Contracts, Easements, OC Billing
* Designed Access Interface to allow users to create dynamic reports.
* Designed Access Wizards to allow users to create Ad-Hoc queries and reports.
* Converted Text, HTML, CSV Documents, Excel Spreadsheets to Access 2.0 & 97
Databases
* Tested and surveyed Litigation support, document management, case management,
time & billing software for the department
* Integrated scanning technology into custom Access database using ActiveX
* Installed and configured software and hardware for users
* Performed trouble shooting on hardware and software
* Provided technical support for network users
* Assisted network administrators in setting up the network and configuring
users
Litigation & Administrative Support
* Coordinated with over 70 outside counsel firms and provided lit support for
all US lawsuits and International Arbitrations
* Trained legal department support staff on Access 97, Word 97 and Practice
Support Software.
* Tested and surveyed litigation support, document management, case management,
time & billing software.
* Formulated departmental and company-wide computer/network usage and office
management policies.
* Mass produced documents in response to interrogatories and document production
requests.
01/1996 - 02/1997
Various Temporary Agencies
Litigation Support Paralegal
Atlanta, GA & Chicago, IL
* Assignments with (including but not limited to): Sidley & Austin, Kilpatrick &
Cody, Winston & Strawn, etc.
EDUCATION
Present
Self Study
Hayward, CA
Advanced self study courses (leading to additional certifications):
SQL 2008 - Programming and Administration
PerformancePoint Server 2007, Silverlight 2.0
SQL Analysis Server / Business Intelligence (BI), On-line Analytical Processing
(OLAP), SharePoint; VB.Net; C#;
07/1998 - 07/1999
MicroHard Technologies
Chicago, IL
Completed Courses for the Following Certification:
Microsoft Certified Solution Developer - VB 6 (MCSD) Microsoft Certified
Database Administrator (MCDBA)
Microsoft Certified System Engineer (MCSE) - NT 4.0
08/1995-12/1995
National Center for Paralegal Training
Atlanta, GA
Certificate of Completion in Business Legal Transactions, 3.3/4.0
ABA approved program, Accrediting Council for Independent Colleges and Schools
accredited school
06/1992-12/1994
University of Georgia
Athens, GA
Double Major B.A. in Political Science & History, Minor in Chinese 3.6/4.0 GPA
Global Studies Certificate, 3.76/4.0 GPA (East Asian Area) with additional
studies in International Development, International
Human Rights, Asian Economic Development
Financed 100% of College Expenses
PROFESSIONAL MEMBERSHIPS
Association of Computer Machinery (ACM)
Bay Area Association of Database Developers (BAADD)
Bay.Net User Group (Bay.Net) |
