Consultant Resume San Francisco, CA - Hire IT People

SUMMARY:

Senior SQL Database Developer with expertise in design, development, and implementing database systems in financial, healthcare, insurance, government, and banking industries.
Excellent teamwork and collaboration skills, organized and detail oriented, ability to manage multiple projects under tight deadlines in fast - paced and changing environments.

TECHNICAL SKILLS:

Software: SQL Server 2008, T-SQL, SSIS, Microsoft Office VBA.

Systems: Windows, LINUX/UNIX, VAX/VMS, VM/CMS, TSO/ISPF

PROFESSIONAL EXPERIENCE:

Confidential

Consultant

Responsibilities:

Developed and used a historical database of risk metrics used to semi-automate the production of three PowerPoint presentations. These presentations were generated and vetted under tight deadlines, and then forwarded to the risk committee of the Confidential board and to other Confidential stakeholders.
Maintained, modified, and ran a number of T-SQL scripts used to monitor bank exposure level by various customer business and geographic segments.
Designed and implemented a sequential pipeline of SQL views used to produce a Risk Identification overview report.
Designed and implemented a user-friendly database used to generate worksheets showing cross-functional responsibilities by both risk type and balance sheet categories.

Confidential, San Francisco, CA

Consultant

Responsibilities:

Diagnosed, tested, and repaired a set of “broken” microsoft access inventory control databases.
Assisted with producing allocation and validation data for testing of cash vault application database.

Confidential

Senior Information Analyst

Responsibilities:

Re-wrote monthly close process in T-SQL, reducing closing time from one week to several hours.
Automated production of several hundred Excel spreadsheets from SQL Server database
Produced statistical reporting ETL files for state regulatory agencies, including several in XML.
Supported the majority of Confidential 's Ad-Hoc database query requests

Confidential, San Francisco

Consultant and FTE

Responsibilities:

Designed, implemented, pushed into production, and supported a multiple-user CRM with role-based security, probably saving WF at least $50,000 in licensing fees according to manager’s estimate
Designed and implemented an automated process to extract and transpose financial institution (FIRE) data, saving WF at least $20,000 in consulting fees
Assisted in streamlining monthly Acordia referral reporting process from approximately ten business days to two business days, and took over responsibility for reporting process
Translated website database from Access to SQL Server. Modified and maintained website database. Maintained website ASP code

Confidential, Larkspur, CA

Consultant

Responsibilities:

Debugged, enhanced, and documented Access-based portfolio accounting system.
Implemented contact tracking database to be used by Aperio partners.
Performed daily reconciliation of custodial portfolios and cash balances.

Confidential, Torrance, CA

Consultant

Responsibilities:

Maintained, supported and enhanced Confidential ’s Automobile System Engineering Informtion databases.
Automated the data collection and database deployment procedures and collapsted three database variants into one code base.

Confidential Francisco, CA

Senior Technical Financial Analyst

Responsibilities:

Designed, implemetned and documented client Top 200 Product Indexing System.
Analyzed, proposed and implemnted SQL solution for nine-percent variances in package sized for equivalent generic drugs.

Confidential, San Francisco, CA

Consultant

Responsibilities:

Analyzed and cleaned vendor data downloads.
Documetned data quality problems and presented detailed list to vendor.

Confidential, San Mateo, CA

Vice President, Information Manager

Responsibilities:

Created and maintained a $273M asset portfolio database.
Created series of Brio Queries collecting delinquency information from Oracle databases.
Automated production of Credit Department’s montly board package, cra; used Pivot tables to summarize informatin and export to Excel.

Confidential, Novato, CA

Principal Systems/Business Analyst

Responsibilities:

Analysis and design of web based financial and budgeting system.

We provide IT Staff Augmentation Services!

Consultant Resume

San Francisco, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship