Sign in

Data Sql Server

San Francisco, CA
January 09, 2020

Contact this candidate



Awarded Certificate in Computer Programming with Honors and Distinction

oComputer Learning Center (CLC), San Francisco, CA

Master of Arts Degree in Linguistics, The University of Michigan, Ann Arbor, Michigan

Master of Arts Degree in Anthropology, Stanford University, Stanford, California

Bachelor of Arts Degree in Anthropology, George Washington University, Washington, D.C.



SafeSecurity, San Ramon August, 2019, November, 2019

Worked with the SafeLink application. This is a VB.NET application used to register new customers and track changes in the accounts of previous customers for SafeSecurity, an alarm system company recently acquired by AAA. The SafeLInk Application has one main form and 2 panels, Customers and Sites. The Customers panel has 7 sub forms and the Sites panel has 6 sub forms. I made changes in the Customers Additional panel to allow for customers who were AAA employees. AAA employees are supposed to get reduced rates for equipment and services. This also affected the Sites Services sub form and the Sites Equipment sub form. Changing a customer’s status from non-employee to employee causes changes in the types of monitoring services offered and charges for monthly services.

Similar changes for AAA employees were required for the SafeDealerNet application which is an ASP.NET application used by security system Dealers. I made changes to the HTML, vb code and stored procedures for the application. Worked with .NET Framework.

I also modified the Docusign side of both applications which were involved in generating contracts and addenda to contracts. I revised the Customer Sales Review by Management form. This form allows a supervisor to approve or disapprove a discount that a sales rep offers a customer. If there is a change in the discount, the status of a customer’s account can change. When the status is ‘Complete’, a contract can be generated. If there are changes to an existing setup for a customer, an Addendum can be generated. The discount is deducted from the total the customer owes pre-tax. Similar changes were made the VB.NET and ASP.NET programs. There are extensive stored procedures that are called for all of these changes. Some of the stored procedures run on a 3rd database, called Sedona. Changes in text boxes and drop-down lists on both VB.NET and ASP.NET applications cause changes on other parts of the forms.


Santa Rosa Consulting, Legacy Support Team December, 2013, August, 2019

Contra Costa Business Intelligence Group CCDPH, Concord

NetPro program for NetWork providers. Provided user support for NetPro program users and CMU. This included making rate adjustments for providers, running service uploads / extracts, and backing off some clients into backup databases when the client table became too large. The program is written in Visual Basic. SQL Server databases are in the backend. Performed database administration tasks.

Provider Master Maintenance Program in VB.NET. This program reads Excel files which are created by the BHS3718 Contract Extract iSite program. Since the Excel files have come in several different arrangements of column headers, the VB.NET program is written to deal with different input file formats.

New Providers are added to Insyst using this VB.NET program. This VB.NET program inserts and updates provider information in the Provider Master table in Insyst. The program can work on MHS and AOD databases in Insyst. The input data is validated and there is an additional form for data lookup.

835 Files HIPAA Processing VB.NET Program – This program parses intricate .dat Files which come from the State and captures data for specific fields. The data is then copied into EXCEL and into an MHSA Database. This data is the source for programs that create 835 denial reports.

MHSA Job Monitoring Program – This is a Business Intelligence .dtsx program which runs daily and sends out email messages to specific users. This program runs an SQL script which monitors the jobs running on MHSA by running queries against certain system tables and sends out a daily report in .CSV format.


Santa Rosa Consulting, Legacy Support Team December, 2013, August, 2019

Contra Costa Business Intelligence Group CCDPH, Concord

MHSA Job Scheduling and Repair – There are DTS jobs which copy data from tables in the Insyst production database to the MHSA server. If one or more of these jobs fail, I restore the last version of the relevant table and reschedule the job in cooperation with the Insyst database/job manager, taking into account the load on the Insyst system.

Weekly Posting Errors Dashboards DAS and MHS. These Business Intelligence programs use data generated by the CCC002 Posting Errors reports from Insyst..

Background: Previously, there were several steps used to generate a weekly posting errors report for MHS. The users had requested more comprehensive data which is provided by the CCC002 program that runs in Insyst. These SSIS programs represent a simplification of the process and provide data for both MHS and DAS. I went back six months to get data and compared the results of the new CCC002 program with the previous programs that had been used to be sure that the results were accurate. The condensed data is brought into Excel and presented in different pivot tables.

MHS 835 CBO Report -- 835 Denial Reports are emailed to CBO users, Mental Health, Patient Accounting, and IT . SQL Server and Business Intelligence program. The MHS 835 CBO denials .dtsx uses Mental Health Source files in .CSV format. The SSIS program parses a text file which is generated from the .CSV input files. The owner (Dept responsible for correcting an error) for different types of errors is identified. The results are emailed to users via the SSIS program.

CALOMS Reports. This Business Intelligence Program program parses data received from the State on CALOMS denials. Specific errors are identified and reports in Excel format are automatically emailed to users via the program.

Productivity Reports. These reports are created using 3 steps: an SSIS Program, SQL scripts, and Crystal Reports. Previously there were 3 data sources for this report: an Insyst report, PeopleSoft data and an Access .mdb file created by another group. The sources have employment data which includes employee name, employee class, production hours, paid hours.

At one point there was a change on the PeopleSoft side, and I re-wrote the part of the program that deals with PeopleSoft data. Since running a PeopleSoft stored procedure from the SSIS program timed out, I had to find a work-around in the SSIS program by translating the PeopleSoft stored procedures into queries.

Since there is a change over from Insyst to ShareCare, I have developed queries and procedures to get productivity data from ShareCare by analyzing tables in the ShareCare databases. This is incorporated into the SSIS program.

AD HOC Reports for management, Finance, Patient Accounting, Legacy Support team management. These reports usually involve SQL Server queries against databases in MHSA. The reports are often created using Excel. Some of the reports have been on Short-Doyle, claims, BAART services, clients with and without Medical, direct and indirect services.

CSI Generate program for the Reporting group. XML data project. Patient Statements and Client Statements projects. Some data is generated in Insyst in a compound text-table field. This text- table field and the accompanying row data is converted into an XML file on the Insyst side. I use an XML Text Editor to make corrections in the XML file as it comes over from Insyst to be sure that the XML will be valid and well-formed. The XML file is then brought into SQL Server via Excel. The Patient Statements data is processed in SQL Server and the results are provided for the Reporting team.

Documentation: User Manuals, Technical Documentation, Diagramming with VISIO.

Training to run Weekly Posting Errors and other jobs.


Marsh McLennan, San Francisco May, 2013, June, 2013

Analyzed an existing, complex dual reporting system which uses online inputs from various insurance providers, over 12 Access databases, and generates over 20 Excel reports in two different systems. The person who created the system had left the company and current personnel did not know how to get the system to work. I was called in to analyze the system, to fix problems where feasible within time limits, to train business analysts on how to use the system and to create documentation. (Existing documentation for the system was minimal.)

Analyzed two database reporting systems: Chevron and Kaiser. The Kaiser system has online inputs from 5 major insurance providers including a Swiss insurance company, and AIG. A name-normalization database also feeds into the system. The output from the 5 major insurance providers feed into an Analysis database. Raw data is output from the Analysis database. Excel reports feed off the raw data and generate reports.

Analyzed Excel reports for the two systems. Corrected errors in reports.

Trained in-house personnel on the architecture of the two database system; how to set up new databases and run reports; and how to trouble-shoot the Excel reports in case there were unexpected errors.

Created system and user documentation. Created charts outlining inputs and outputs for the systems.


ILS, San Francisco Dec., 2010 –July, 2011, Apr., 2012 – June, 2013

SQL Server:

Wrote T-SQL for comparison of last names in SQL Server database. The purpose was to scan for data entry errors and to create lists of related names. The program searched for various types of entry errors including: name reversals, phonetic similarities. The resulting lists were meant to speed up the search for entry errors and name comparisons.


Rebuilt Access front-end database and SQL Server back-end database. Conversion from 2003 to 2007.


San Francisco Department of Health, San Francisco Aug., 2011 – March, 2012

Compiled documentation for the CCMS, Coordinated Case Management System.

Wrote Behaviorist Users’ Guide. The Behaviorist Application is designed for the Primary Care Behavioral Health Program. It is used by psychiatrists and other health care providers. The function of the program is:

oTo record, view and print a patient’s chart notes and progress notes.

oTo record and view instruments and questionnaires.

oTo assign a treatment pathway and history for a patient.

oTo provide easy access to information about recent patients.

Compiled documentation for the Cluster Server Project which includes deployment plans and build procedures.

Consulted with a financial analyst to get an overview for a budget presentation. Created Visio diagrams for a budget presentation.

Met with technicians to create documentation on the DPH Servers. Compiled documentation on the DPH Servers including:

oPhysical configurations, server room racks, floor plans data jacks

oDatabases and database structures

oSQL Scripts and the Data Dictionary

Used Drupal to create simple websites. Documented Drupal features for the Web team.

Documented the Oracle Business Intelligence tool. Created BI reports for documentation and presentation.


OpsTechnology, San Francisco Sept., 2010 – Dec., 2010

Followed procedures specific to their system for data error detection and system maintenance:

Re-activated suppliers in the system using SQL queries.

Detected data errors for file imports. Relayed data error problems to external customers.

Tracked down image.pdf files for invoices by using queries on SQL Server databases and checking their FTP sites.

Read and wrote XML for import and export files. Created XML file to match ‘createOrder sample inbound call’ in documentation provided by one of their suppliers.

Tools used:

Used XML tools: XmlPad, XmlNotepad, Notepad++

Used debugging tools including: TCP Trace

FTP: Used WinSCP to copy files to their FTP sites and to track down files.


AutoDesk, San Rafael Oct., 2009 – Feb., 2010

Wrote system documentation for programmers and managers. The purpose of this documentation was to describe the programs, databases, tables and queries in the BoM Tool on the SQL Server side and on the Access side, so that a new programmer could more easily understand the internal workings of the program.

Maintained and made major enhancements for the BoM Tool used to create build of material assemblies. The BoM Tool, an Access program, generates part number descriptions and other data. The backend is SQL Server. Output reports are generated in Excel. Wrote stored procedures in SQL Server. Worked with SQL Server databases for development and production. Released revisions for users in development and production. Dealt with business users in Europe and US.

Maintained development and production databases in SQL Server. Backed up databases as needed. Trouble shot databases for problems with data and discrepancies in stored procedures. Wrote complex stored procedures in SQL Server dealing with the addition of rows to BoM tables and with the insertion, deletion and updating of data (T-SQL).

Some data input is from SharePoint tables containing SKU part information. Wrote code to refresh SharePoint data in Access.

Wrote code to allow only one user to work on a product build at a time. If a second user happened to try to open a file, a warning message would appear. A build is considered locked as long as the first user has the build open. Controls on parent forms and subforms are disabled.

Added lock/unlock function to assembly matrix form and part number matrix form. The lock function disables controls on parent forms and subforms, and sets ‘locked’ column values in appropriate tables.

The BoM Tool generates Finished Goods, OPS SPECS and BoM Assembly reports in Excel which are used as input for SAP. Edited VBA code in Access to deal with the generation, formatting and placement of fields in Excel reports.


AlphaDetail, San Mateo March, 2005 – Aug., 2008

Development of the Key Opinion Leader Searcher Tool. This tool is in Access/Excel VBA and is used by pharmaceutical companies to identify influential physicians.

Developed the profile portion of the KOL Searcher tool. Developed T-SQL routines to clean up and enhance secondary research data. The KOL Searcher brought in 30% of AlphaDetail’s income.

Developed Visual Basic, MS Access VBA and Excel VBA programs.

Worked with AlphaGraph, a Visual Basic program which reads named objects on PowerPoint slides, combines them with Excel data files, and generates Excel charts using templates.

Worked with and enhanced AlphaSurvey, a program which takes PowerPoint files as input and generates XML files.

Enhanced KOL Searcher tools. The KOL Searcher is a MS Access program that generates Excel output using parameters selected by users. The data input for the KOL Searcher is generated in SQL Server. Used SQL Server to create total fields used as part of the input data. Added Exontrol’s grid, a 3rd party program with its own code, to the KOL Searcher for the profile portion of the tool. Used SQL Server to create input for Inflow maps. Used the Stat Transfer program to generate files used in Statistical Analysis

Worked with struts for AlphaDetail’s web-based Customer Service Tool. Updated JSP, Java, struts and back-end SQL Server database for web-based Portal. Compiled and deployed changes using Ant.


WORLD Savings, Oakland Aug., 1998 – Nov., 2002

Programmed Online Loan Application (OLA), a VB 6 front-end ActiveX program which captures loan application data and inserts it into a SQL Server 7.0 database. Developed Access 2000 back-end which performs queries against SQL Server 7.0 tables, generates and prints a standard loan application using ADO, COM. The program is accessed via the INTERNET using IE Explorer 5.0. Updates to the VB 6 ActiveX document are downloaded to users’ PCs automatically. The program can be used to upload data from a user’s PC to the mainframe using FTP. We had over 400 loans uploaded per month. Provided user support for OLA.


WORLD Savings, Oakland Aug., 1998 – Nov., 2002

Developed ACCESS Runtime program for users who did not have ACCESS 2000. Trouble shoot program. Dealt with MDAC version issues. Used Regedit, Regsrvr32 to make Registry changes.

Edited SQL Server 7.0 stored procedure and VB 6 program which is used to generate text files to be sent to Fannie Mae and Freddie Mac. Wrote SQL Server stored procedures to generate Ad Hoc reports.

Developed EXCEL VBA program that copies spreadsheet, formats it and creates HTML page from it which is displayed as the Telefinance Calls Daily Report on the INTRANET. The SQL Server job scheduler runs this program daily.

Internet Loan Group Report -- SQL Server stored procedure populates a table on the DataMart which is used as the source of an EXCEL pivot table. VBA code refreshes the pivot table. Edited registry and wrote code so that ADOBE dialog box would not appear while .PDF files were created from pivot table. Wrote VB code to send .PDF files to users via OUTLOOK (COM).

Used Data Transformation Services in SQL Server 2000 to create a text file. Included the DTS job in a SQL Server job that called stored procedures, and FTP-ed the result to another server.

Created ACCESS report using Microsoft Project tables for PeopleSoft project.


DATA PROCESSING SKILLS Development of applications and utility software programs through the use of analyst consultations, programming tools, data entry, testing, debugging, and documentation

ENVIRONMENT: Windows NT/2000/XP/Vista, Mainframe - IBM system/370 4341 processor under OS/VS1 using VM/SP with CMS, Amdahl 5890 - MVS/TSO/ISPF, Versioned Object Base VOBS, UNIX; MS IIS

PROGRAMMING: VB.NET, Visual Basic, SQL Server 2008, SQL Server 2012, MS ACCESS, EXCEL VBA, Word VBA, basic Java, XML

INTERNET: HTML, CSS, Created ActiveX documents using VB that could be downloaded via Intranet. CCSF Web Developer program. VB Script, ASP.NET

PC SKILLS: QUICK C/THINK C, C++. Designed, coded and debugged business and graphics programs.

IBM PC Programming knowledge of BASIC. Skills using Word, FrameMaker, Crystal Reports.

GRAPHICS: VISIO, PhotoShop, CorelDRAW, Macromedia DIRECTOR (Business Presentations, Multimedia)

Contact this candidate