Post Job Free
Sign in

Sql Server Developer

Location:
Hayward, CA
Posted:
September 29, 2012

Contact this candidate

Resume:

Sr. Application Developer

Summary

Cover Letter

CurrentLocation US: Hayward, CA

Industry

Information Technology / Computer / Software

Compensation

Current: 77000

Desired: 80000

WillingtoRelocate No

PreferredLocations

Travel Availability

MyPerfect Job

DesiredTitle Application Developer

Cover Letter

Hello, My

name is Will. I am an application developer with approximately 7 years of database and application development experience. I have also been developing web based applications using ASP, Cold Fusion, JavaScript and more for approximately 5 years. I have a very strong international background and I have been working with law firms in various capacities for most of my professional life. Until recently, I was the Senior Application Developer at Sedgwick, Detert, Moran & Arnold. My primary toolset, for the past 7 years, mainly consists of: Microsoft Office Visual Basic for Applications (especially Access, Excel and Word), Visual Basic 5 &6, SQL 6.x, 7 and 2000, Cold Fusion, ASP, JavaScript and HTML. I have worked with small Access databases as well as huge databases (SQL Server, Informix, and Oracle). I used ADO, RDO, JRO, OLE DB and COM in my development. Using Transact SQL, I have created stored procedures, extended stored procedures (C triggers and cursors. I automated processes and integrated systems to allow various departments to collaborate and streamline data entry and centralize business logic. Using Cold Fusion, VB/JavaScript and HTML I have also developed secure Internet / Intranet / Extranet dynamic websites. My web development skills can contribute significantly to any website creation, administration and enhancement. Also, as a consultant, I advised small to mid size law firms on how to use existing technologies to effectively increase their return on investment. I have done everything from assembling their desktops to creating LAN networks and creating custom legal databases for their specific needs. I am also an American Bar Association (ABA) certified Corporate Paralegal with over 4 years experience in litigation and corporate matters.

I worked for various large law firms in Atlanta, and Chicago. I am looking for a position that will challenge me and utilize my technical and legal skills to advance my career. Please review my resume and feel free to contact me via email or by phone at any time.

Wael (Will) Fadel 510-***-**** - Home 510-***-**** - Fax **********@*******.***

to top

Resume

TECHNICAL SKILLS

Technical Focus: Automation, Collaboration, Integration, and Standardization

Operating Systems: MS-DOS; Windows 3.x, 9.x, 2000 and XP; NT 3.51,4.0

Programming Languages: T-SQL, Visual Basic, MS Office VBA and C++

Scripting / Web Languages: ASP, VBScript, JavaScript, ColdFusion Markup Language (CFML), HTML, DHTML, XML, XSL, CSS and Summation Scripting

Data Access Technologies : ActiveX, COM, OLE DB, ODBC, ADO, DAO, RDO, JRO

Components: COM/DCOM/COM+, MTS, MSMQ

Databases: Access, MS SQL Server 6.x - 2000, Informix, Oracle 8i, dBase IV+

Reporting Tools: Crystal Reports, e-Actuate Reporting Suite

Software Tools Used: Visual Studio 6.0, MS Office Dev. 9x, 2000 & XP, ColdFusion Studio, Visual SourceSafe, MS Project

Web Servers: Internet Information Server 3 - 5, ColdFusion Server 4.x

Software: Back Office, Exchange Server, Index Server, MS Proxy Server

Litigation Support Software (Supported, Maintained and Used): Summation 5.21, Blaze LG and iBlaze; Legal Access Ware (4.0), ZPrint LoadFile and Image Inspector; Concordance; iManage; CaseMap, TimeMap, NoteMap, TextMap and other CaseSoft related software; Corporate Focus; DOCS Fusion; dTSearch; eDiscovery Solution Powered by Dolphin Search, Doculex; IProView, Opticon, CheckCite, HotDocs and Full Authority; Inmagic/DBText; JFS Litigators Notebook; LDIS; LiveNote; MS Project; PC Law; PCDocs; PowerDocs; Premise; Q&A; Sanction II Legal Presentation Software; TextBridge / Omnipage; Trial Director, DocumentDirector and DepositionDirector; Visionary; West Mate; Westlaw and more!

IT/MIS EXPERIENCE

5/2002

- 5/2003Sedgwick, Detert, Moran & Arnold

Sr. Application Developer

San Francisco, CA

Application Development

* Bridged communications between users, internal departments (e.g. Marketing, Finance department, etc.) and vendors in handling in-house and outsourced projects

* 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

* Oversaw the development of new in-house Client / Server applications and created guidelines for the Full Life Cycle of the creation of N-tier and possible Microsoft DNA applications.

* Designed and maintained various Insurance Coverage Databases and their reports using Access 2000, VB 6.0, SQL Server, Crystal Reports and ASP

* Designed a reporting Front End to interface with CMS Open for the CFO to generate dynamic financial reports using ADO, VB 6.0, MS Access (unbound application) and Stored Procedures running under Window 2000 and MS-SQL Server 7.0

* Converted Legacy Database Applications 16 bit libraries, references and classes to their 32 bit equivalents OR re-created and re-designed their functionality due to the Word XP Rollout

* Designed various Stored Procedures in SQL 2000 and DTS packages for various administrative tasks and synchronize the data

pertaining to users, their iManage / WordAssist customizations across the enterprise using VB, ADO and DTS Designer

* Updated mechanisms used to update the Web server with data stored on the network

* Re-Designed and enhanced the firm\'s Access Database Template and its modules

* Exported, and Supported Data Transfers from various databases and document types to other formats.

* Distributed Database Updates via Replication and Synchronization

* Conducted Data Analysis of a very large database for a multi-million Insurance arbitration

* Conducted technical interviews on behalf of client to acquire Oracle Developer Experts for multimillion dollar arbitration

* Trained, created and maintained training curriculums for end users and technical personnel for XML, HTML, Access and VBA, Lit Support Software, Office XP, etc

Intranet, Internet and Extranet Development

* Tested, deployed, supported and Improved Firm\'s XML/XSL Internet Website and Intranet ASP, JavaScript, DHTML, CSS, etc

* Installed Support for International Localization on IIS

* Designed, translated and Created the firm\'s Japanese Web Pages

* Created a survey site for Firm\'s users to identify Cases and Databases used for pre Word XP Rollout

* Proposed a digital dashboard (Portal) solution that would allow 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 Extranet Initiative for Major client - Assisted in the design of the application\'s physical architecture, database architecture. Assisted with the choice of vendors and the outsourced support for the application Oracle 9i/ Oracle 9 As web server

Standards / Policies

* Introduced documentation procedures and systems for In-House, Off-Site and trial site projects

* Analyzed and recommended standards and implementation of system changes for Lit Support, Application and Web Development (Client/Server and N-Tier), and Database to increase protection of sensitive corporate data

* Created guidelines for Intranet Security, Dynamic Content Management that would not require content managers to be web developers

* Researched, developed a strategy for the Integration for various data sources throughout the enterprise

Litigation Support

* Provided Litigation Support In-House / Off-Site and during trials and arbitrations

* Supervised the litigation support specialist in San Francisco

* Designed, developed, maintained and supported Summation, Concordance and other legal applications

* Created scripts to administer the users and cases in Summation using Summation\'s object model

* Designed and supported PowerPoint and various presentations in trials and arbitrations

* Provided Hardware Setup, Presentations, Transcript and Movie synching and digitization

* Provided hardware, software and presentation recommendations, testing, setup

2/2002

- 5/2002Orrick, Herrington & Sutcliffe

Consultant - Help Desk & Developer

San Francisco, CA

* Developed, deployed and maintained a Help Desk application used to inventory printers and usage for the SF Branch office

* Created Access 2000 database for the Librarian to inventory all publication, manuscripts, videos and other Law Library media

* Created custom usage reports for the help desk from the Remedy CRMS SQL Backend using Access and Excel

* Fielded call for the Call Center and/or escalated calls to higher help desk tiers if needed- handled 50-75 calls a day

* Assisted with the deployment of PCs, installation of new software and Migration to the Office 2000 environment

* Assisted with the relocation of the Help Desk to the new centralized location in West Virginia

* Supported Office Suite applications, Adobe Acrobat and various Commercial off the shelf products

* Assisted developers in debugging errors in DeltaView, PC Docs and various other applications

07/2001

- 02/2002

Various Law Firms

Legal App. Developer / Consultant

.

Chicago, IL / SF, CA

* Intranet development projects utilizing ASP, ActiveX, JavaScript, ADO, SQL and XML/XSL and DHTML

* Developed, deployed, managed SQL Servers and SQL Databases, backups, recovery and Security

* Designed, created and maintained DTS packages programmatically

* Migrate SQL Servers from SQL 6.5 Enterprise to SQL Server 2000 Enterprise

* Finalized some Access database applications for old clients

02/2001

- 07/2001True Points, Inc

.

Sr. Developer

Chicago, IL

* Developed Cold Fusion 4.5 applications using SQL 2000 as a back end on Windows 2000

* Improved the performance of Cold Fusion templates and stored procedures

* Created various extended stored procedures to enhance SQL server security and prevent SQL Server Injections attacks using C++ and native extended stored procedure

* Created SQL Server 2000 triggers, temporary tables, stored procedures, Extended Stored Procedures and cursors

* Configured the development environment: installed and configured Windows 2000, Exchange 2000 (integrated it with Active Directory), the firewall, Proxy server and SQL Server 2000, Cold Fusion Server 4.5

* Created an Access database that automates the synchronization of the Cold Fusion and SQL Server database changes made between the Development and Production environments (VBA)

* Installed and configured MailSite server on remote production servers

* Installed VeriSign SSL Certificate for Production environment and secured web server and database server against SQL server attacks in code or other methods

* Created Certificate Key Pair for request file, Obtained Certificate from VeriSign, Installed Certificate and Activated SSL

10/2000

- 02/2001First Union Securities

.

Application Developer

Chicago, IL

* Designed data warehouse financial reports for business units using Crystal Reports 8.0, e-Actuate Reports, and Informix SQL

* Used VBA to optimize and improve performance of an Access 97 Database used to automate receiving, maintaining and managing data warehouse report requests and various departmental projects

* Automated a system that allowed Business Units to send in report request to the Data warehouse team and generate a response and a receipt to deliver reports as governed by the SLA. Using VBA for Access 97, Excel 97 and Word 97 and the Office COM this system allowed for seamless integration with all three Office apps and email to minimize user intervention and human error

* Automated the creation and formatting of Informix reports received as delimited text files then dynamically generated and exported the reports to Excel Workbooks for a multi-million project using Access 97, Excel 97 and the Office COM

11/1999

- 10/2000Avenew.Com, Inc

Web Application Developer

Itasca, IL

* Researched, analyzed, developed and implemented enhancements to existing and new applications

* Converted Middle Object written in C++ into SQL stored Procedures for use with ColdFusion Pages

* Created a SQL backend / ASP front-end to track bugs in the testing stages of development using Stored Procedures, trigger, etc

* Designed dynamic Cold Fusion applications using a SQL Back End for use on Intranet and Internet

* Created stored procedures, triggers, temporary tables, views, cursors and optimized SQL server for use with ODBC

* Integrated Java Applets and Servlets and Crystal Reports into Cold Fusion Applications

* Installed, configured and repaired NT Server, IIS, Interdev, Studio, SQL Server 6.5, Cold Fusion, etc.

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

* 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

* Using 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

* Created Functions, Subroutines; Debugged applications; Optimized Performance using VB 6

* De-normalized Tables to boost performance; Secured Databases for Remote Access By External Users (RAS)

* Replicated Database for Synchronization for Laptop users using JRO

* Documented all development made to applications in databases used for billing and source control

LEGAL / RELEVANT EXPERIENCE

02/1997

- 02/1999Universal Outdoor, Inc

.

Corporate Paralegal / Application Developer

Chicago, IL

Reported to General Counsel

Litigation & Administrative Support

* Coordinated with over 70 outside counsel firms and provided lit support for all US lawsuits and International Arbitrations

* Mass produced documents in response to interrogatories and document production requests

* Documented and trained additional legal department support staff for Access 97, Word 97 and Practice Support Software

Database Programming & Technical Support

* Designed Access 97 Multi-user Database (VBA) for department use to track all legal matters

* 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

* Researched and documented feasibility of integrating scanning technology into 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

Policies

* Formulated departmental and company wide policies relating to Computer and Network Usage Policy, personnel management, safety issues, document destruction and outside counsel billing

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.

* Scan Documents into Tiff, import them into Databases, OCR and convert them into various formats

* Database Design, research and report creation

* Conducted computerized legal and non-legal research and prepared court filings

* Coordinated Litigation Support Projects

EDUCATION

11/2000

- Present

Self Study

Hayward, CA

Advanced self study courses (leading to additional certifications):

Advanced Cold Fusion; MS SQL 2000 - Programming and Administration; Visual Basic 6; Microsoft Office Automation &

Integration - Access, Excel, Word, Power Point (VBA); XML & XSL; Oracle Developer 2000 (PL/SQL, Forms, Reports, Graphics);

Java (Programmer & Developer)

07/1998

- 07/1999

MicroHard Technologies

Chicago, IL

Completed Courses for the Following Certification (Taking Exams Soon):

Microsoft Office User Solutions Expert (MOUS)

Microsoft Certified Solution Developer (MCSD)

Microsoft Certified Database Administrator (MCDBA)

Microsoft Certified System Designer (MCSE)

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 Chinese3.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

to top

Contact Information

Will Fadel

650 Buckwheat Court Unit 6110

Hayward, CA 94544

US

email **********@*******.***

Phone: 510-***-****

Phone: 510-***-****

Industry: Information Technology / Computer / Software

City: Hayward

State: CA

Zip: 94544

Country: US

Date: 00000000

to top



Contact this candidate