College: California State University, Sacramento
Years: 09/1990 to 12/1994
Degree: Bachelor of Science in Business Administration
Concentration: in Management Information Systems
TECHNICAL SKILLS
Microsoft Applications: Word, Excel, Access, PowerPoint, Project, Visio, Outlook, Front Page
Adobe Applications: Dreamweaver, Photoshop, Fireworks, Acrobat
Web Development: HTML, CSS, ASP, JSP, PHP, SQL, XML, JavaScript, VBScript
Web Servers: Microsoft IIS, Apache, MS Office SharePoint Server
Web Browsers: Internet Explorer, Firefox, Safari, Chrome
Web Accessibility: WCAG, Section 508, Cross Browser Testing, Standards-Compliant, JAWS
Google Technologies: Search Appliance, Analytics, Maps API, Chart API, Docs
Server Technologies: FTP, Telnet, SSH, Windows Server, Linux Server
Content Management: MediaWiki, Plone, TeamSite, WordPress, Windows SharePoint Services
Database Administration: MySQL, Microsoft SQL Server, Microsoft Access, DB2
Database Tools: SQLyog, SQL Server Management, QMF for Windows, Power Designer
Database Models and Concepts: Relational, Star Schema, Stored Procedures, ETL Process
Business Intelligence: Business Objects, Web Intelligence, Designer for Business Objects
Mainframe: COBOL, JCL, CICS, TSO, ISPF, VSAM, Easytrieve, FileAid, Xpediter
Operating Systems: Microsoft Windows, Mac OS X, iOS, Linux
CALIFORNIA PUBLIC EMPLOYEES’ RETIREMENT SYSTEM (CalPERS) EXPERIENCE
Web Applications Developed
- Driving Directions Using Google Maps API
- RSS Feed and Admin
- California Employers’ Retiree Benefit Trust (CERBT) Fund Agency List and Admin
- Software Products Admin
- Office of Public Affairs’ New Project Initiation Request
- Enterprise Architecture Services’ Request for Architecture Work
- Exec/Board Support Reporting System
- Public Employers' Readiness Team (PERT) Training Registration and Admin
- On-the-Spot Recognition Award System
- iBoard Prototype
- User Access Request System (UARS)
- Knowledge Management System (KMS) my|info
- Educational Forum Online Registration and Admin
- Investment Workshop Registration and Admin
DEPARTMENT OF HEALTH CARE SERVICES (DHCS) EXPERIENCE
Applications Developed
- Change Cycle Management System (CCMS)
- Targeted Case Management (TCM)
- Third Party Liability and Recovery Division (TPLRD) Business Objects Reporting System (BORS)
- Notice of Action (NOA) Business Objects Reports
- Medi-Cal Applications Section (MAS) Business Objects Reports
- CHDP Gateway Business Objects Reports
- Project Inventory Report (PIR)
- Enhanced Med-Cal Budget Estimate Redesign (EMBER)
- Response and Surveillance System for Childhood Lead Exposures (RASSCLE)
- Medicare Modernization Act Drug Benefits Program (MMA Part D)
- Child Health and Disability Prevention (CHDP) Gateway
- Application Tracking
- Medi-Cal Eligibility Data System (MEDS)
- Monthly Medi-Cal Eligibility File (MMEF)
- Healthy Families (HF)
- State Client Index (SCI)
- Paid Claims
- Public Health
PROFESSIONAL EXPERIENCE
Position: Senior Staff Programmer Analyst (Specialist)
Employer: California Public Employees’ Retirement System
Duration: 05/2009 to Current
Location: Sacramento, California
Web Site Services Unit (05/2009 to Current)
HTML, CSS, ASP, VBScript, JSP, JavaScript, XML, MySQL, MS IIS, Apache
- Designed, coded, modified, tested, and implemented new and existing internet and intranet web applications.
- Worked as team lead for the CalPERS On-Line Web Accessibility Project for ADA compliance and cross-browser compatibility.
- Worked as technical lead to staff, customers, and projects in defining business requirements, design, programming, and testing of web applications.
- Resolved complex technical issues and problems.
- Assisted customers in analyzing and redesigning current business functions.
- Provided for and organized production implementation support for new applications or database implementations.
- Developed and organized deployment and production support procedures related to supported systems.
- Researched, evaluated, and participated in recommendations of new technology for the development and support of business applications.
- Received two Achieving CalPERS Excellence (ACE) Awards from customers for converting their PDF forms into web applications.
Position: Staff Programmer Analyst (Specialist),
Employer: California Department of Health Care Services
Duration: 04/2008 to 5/2009
Location: Sacramento, California
IBM/DB2 and Business Intelligence Unit (04/2008 to 5/2009)
Business Objects, Web Intelligence, .net, Designer, DB2, QMF, Web Admin, HTML, CSS, ASP.net, JavaScript
- Designed, created, tested, and implemented BO reports for BORS
- Modified, tested, and implemented report and universe enhancements on various systems
- Provided Business Objects XI and Web Intelligence XI training to the BO users
- Administered user access to the BO reports on the intranet and extranet
- Provided technical support to the BO users
- Gathered the requirements to automate the Indian Health Program’s Request for Application process
- Developed the Proof of Concept to automate the Department of Health Care Services’ Request for Personnel Action process using the K2 BlackPearl Business Process Management tool
- Created the SharePoint sites for my Unit and for the Business Objects XI Training
Position: IT Consultant
Employer: Treetops IT Consulting, Inc.
Duration: 08/2003 to 04/2008
Location: Sacramento, California
DHCS – Business Intelligence/Application Developer (10/2007 to 04/2008)
Business Objects, Web Intelligence, .net, Designer, DB2, QMF, Web Admin
- Designed, created, tested, and implemented BO reports for BORS
- Modified, tested, and implemented report and universe enhancements on various systems
- Provided Business Objects and Web Intelligence training to the BO users
- Modified the MEDS Lite 2 screens to make the system more user friendly
- Created the BORS Online Tutorial for the users and management
- Administered user access to the BO reports on the intranet and extranet
- Provided technical support to the BO users
- Programmed and tested various file fixes to the BORS database
Business Objects, Web Intelligence, Designer, DB2, QMF, Power Designer, Web Admin, ETL Process
- Designed the star schema database structure of the NOA BO Reports
- Designed, created, tested, and implemented all the reports for NOA
- Created, tested, and implemented new BORS reports
- Modified, tested, and implemented report enhancements for BORS
- Coordinated the ETL Process between the application developers and database administrators
- Provided NOA and BORS training for all the users and management
- Created the BORS Online Tutorial for the users and management
- Administered user access to the BO reports
- Provided technical support to the BO users
- Maintained and published all the BORS and NOA documentation to the SharePoint website
SQL Server, ASP, VBScript, SQL, Stored Procedures, FrontPage, HTML, CSS, JavaScript, Business Objects, Web Intelligence, Designer, Web Admin Utility
- Gathered requirements for the CCMS and PIR enhancements and new MAS BO reports
- Designed all the web application screen and report changes
- Trained the web application developer to make changes to the ASP code (such as HTML, CSS, JavaScript, and VBScript) and SQL Server database (such as tables and stored procedures)
- Provided knowledge transfer (such as business rules and technical functions) and technical guidance to the web application developer who maintained CCMS and PIR
- Modified some ASP code and SQL Server tables and stored procedures
- Tested and implemented all the intranet and database modifications
- Trained all the users to use the enhanced CCMS and PIR
- Designed, created, tested, and implemented the new Business Objects universe and reports for CCMS and PIR
Business Objects, Web Intelligence, DB2, SQL, COBOL, CICS, JCL, ISPF, TSO, VSAM, Access, Visual Basic
- Analyzed all COBOL programs and copy members to include the new Part D Medicare Status
- Gathered all the requirements needed to convert an existing Access database application into a web-based BO reporting system using DB2 database
- Designed the database structure that will be used by BO
- Designed, created, tested, and implemented all the new reports using BO
- Trained all the users of the new BORS
- Provided technical support for the BO users
- Create the User Guide and Technical Specifications for BORS
- Gathered all the requirements needed to implement the interim and on-going NOA Medi-Cal Reduction of Benefits Notice
- Designed the complex process to automate the creation of the NOA Address File, printing, packaging, and mailing of the NOA, and scanning the tracking bar code of the returned NOA so that the tracking code can be used to update MEDS and the NOA Summary File
- Coordinated the end-to-end testing of the on-going NOA with Electronic Data Systems (EDS)
- Created the Functional Requirements Document (FRD), Technical Design Requirements (TDR), Design Document, MEDS Acceptance Testing (MAT) Turnover Document, and the Data Guidance Package for the NOA and MMA Part D changes
- Created and presented the PowerPoint slides to give an overview of the NOA and MMA Part D changes to DHS
Business Objects, Web Intelligence, DB2, SQL, COBOL, CICS, JCL, ISPF, TSO, VSAM, Easytrieve
- Identified problems with existing CHDP Gateway and Application Tracking COBOL programs
- Modified COBOL programs and created new COBOL programs to fix the problems identified
- Created, tested, and executed all the file fixes for all the DB2 tables affected by the Application Tracking enhancements using Easytrieve programs
- Created and executed test scripts for acceptance testing
- Designed, created, tested, and implemented the new BO reports
- Modified and tested existing BO reports
- Provided technical support for the BO users
Business Objects, Web Intelligence, DB2, SQL, Easytrieve, COBOL, CICS, JCL, ISPF, TSO, VSAM
- Created and executed test scripts for acceptance testing of the CHDP Gateway Newborn Enrollment
- Modified Application Tracking COBOL programs accommodate the new reports required by the end users
- Created, tested, and executed all the file fixes for all the DB2 tables affected by the Application Tracking enhancements using Easytrieve programs
- Created, modified, and tested the BO measures and reports
- Created and tested ad-hoc reports requested by the end users
- Provided technical support for the BO users
Business Objects, Web Intelligence, DB2, SQL, COBOL, CICS, JCL, ISPF, TSO, VSAM, Easytrieve
- Enhanced the appearance of existing BO reports to a more professional look
- Corrected the data calculations of existing reports to get accurate results
- Gathered business and functional requirements for the new BO reports from the CHDP Gateway users, customers, and IT staff
- Designed, created, tested, and implemented new BO reports
- Created Easytrieve programs to file fix existing DB2 data
- Trained the state users to use the CHDP Gateway BO reports
- Trained the state power users to create ad-hoc reports using Web Intelligence
- Provided technical support to the BO users
- Analyzed existing SCI match scoring logic to create the matrix with all the possible permutations of the SCI match scoring logic
- Created the test plan and test data for the SCI match scoring using the new “D” search type
- Tested the SCI match scoring code changes
- Created and executed test scripts for acceptance testing of the CHDP File Clearance component which used the MEDS, Health Families and SCI database
Position: IT Consultant
Employer: IBM Global Services
Duration: 04/2003 to 06/2003
Location: Sacramento, California
DHS – CHDP Gateway Implementation
COBOL, CICS, JCL, ISPF, TSO, VSAM, DB2, Flash
- Created and executed test scripts for acceptance testing of the CHDP Gateway web front-end Flash screens
- Executed test scripts for acceptance testing of the CHDP (Point-of-Service) POS device
- Created and executed test scripts for acceptance testing of the CHDP File Clearance component which uses the MEDS, Health Families and SCI database
Position: IT Consultant
Employer: Eskel Porter Consulting
Duration: 01/2003 to 02/2003
Location: Sacramento, California
California Board of Corrections – Juvenile Justice Crime Prevention Act (JJCPA) System Enhancements
ASP, HTML, CSS, VBScript, JavaScript, SQL Server, FrontPage, Access, Visual Basic, IIS
- Gathered requirements for the enhancements and bug fixes requested by all the users and managers
- Modified existing ASP code and database tables for the enhancements and bug fixes to the JJCPA system
- Designed and modified new and enhanced internet screens, reports, and database tables
- Tested all the internet screens and reports
Position: IT Consultant
Employer: Jin, Inc.
Duration: 02/2002 to 06/2002
Location: Sacramento, California
DHS – CCMS and PIR System Conversion Implementation
ASP, HTML, CSS, VBScript, JavaScript, SQL Server, FrontPage, Access, Visual Basic, IIS
- Gathered all the requirements to convert the old CCMS and PIR written in Access into two separate intranet applications but with one consolidated SQL Server database
- Designed, created, tested, and implemented the CCMS and PIR intranet applications including all the front-end screens, back-end admin screens, reports, database tables, and stored procedures
- Created an Issue Log web application using ASP and SQL Server for users to report CCMS and PIR problems and enhancements
- Created web-based reports to manage MAS staff workload and production installations of all Work Requests
- Provided training to all the users and managers
- Created an online User Guide for the CCMS, PIR, and Issue Log intranet applications
- Converted all the data from the Access database to the SQL Server database
Position: IT Consultant
Employer: IBM Global Services
Duration: 10/2001 to 12/2001
Location: Sacramento, California
DHS – Target Case Management System Enhancement
JSP, HTML, CSS, Java, ASP, VBScript, JavaScript, DB2, FrontPage, Visual Age for Java, WebSphere Studio
- Designed all the enhancements to the existing extranet application screens and reports
- Modified the JSP web pages, COBOL programs, and Java code for the enhancements
- Tested the TCM JSP web pages, COBOL programs, and Java code enhancements
- Created an extranet TCM Application Testing Problem Report Log using ASP for testers to report problems during testing
Position: Senior Internet Solutions Engineer
Employer: EndUse.com
Duration: 07/2000 to 11/2000
Location: San Francisco, California
EndUse.com Proprietary Internet Auction System Maintenance
HTML, ASP, CSS, VBScript, JavaScript, FrontPage, Visual Basic, SQL Server, Visual SourceSafe Server, Windows 2000 Server, IIS, FTP Server, WebTrends Reporting Center Server
- Gathered requirements for enhancements to existing internet websites of all the customers
- Designed, modified, tested, and implemented all the bug fixes and enhancements to the websites of all the customers
- Configured and modified SQL server databases, tables, and views based on bug fixes and system enhancements
- Configured and administered all the (development, test, and production) Windows 2000 servers, IIS web servers, SQL servers, WS-FTP servers, WebTrends Reporting Center servers, Visual SourceSafe servers, and office PCs
- Administered the version control of all the web pages and images of the customers’ websites using Visual SourceSafe
- Provided PC hardware and software technical support to the employees and customers
Position: IT Consultant
Employer: IBM Global Services
Duration: 03/1998 to 06/2000
Location: Sacramento, California
DHS – Year 2000 Conversion
HTML, ASP, CSS, VBScript, JavaScript, FrontPage, Access, SQL, Visual Basic, COBOL, JCL, TSO, ISPF, DB2
- Created and maintained the department's Year 2000 internet and intranet websites written in HTML, ASP, VBScript, and JavaScript
- Trained the webmasters from the department to use FrontPage and to code in HTML
- Created guidelines for a standardized format for all of the department’s internet websites
- Created and maintained the DHS Year 2000 County Conference online registration website
- Created and maintained an Access application to keep track of all the external interfaces for all of the DHS mainframe modules and PC applications
- Designed, created, tested, and implemented CCMS for MAS to keep track of all the work requests, problem reports, and Change Cycle Letters for all of the section’s projects using Access
- Designed, created, tested, and implemented PIR for MAS to keep track of all the section’s projects and projected 120-day employee workload for each project using Access
- Gathered Year 2000 readiness status from the state’s various health organizations with DHS external file interface
- Created system test scripts for the Paid Claims, Public Health, and MEDS Year 2000 conversion
- Modified production JCL and executed system and interface testing
Position: IT Consultant
Employer: KPMG Peat Marwick, LLP
Duration: 03/1995 to 02/1998
Location: Sacramento, California
State Controller’s Office (SCO) – Year 2000 Conversion (01/1997 to 02/1998)
Access, Visual Basic, SQL, COBOL, JCL, VSAM, TSO, ISPF, CICS
- Programmed and tested new COBOL programs to expand all the date fields in the Employment History (EH) file
- Modified and tested the EH and Payroll System COBOL programs to be Year 2000 compliant
- Gathered the requirements for the Year 2000 conversion
- Designed the CICS screens and reports for the Year 2000 conversion
- Designed, created, tested, and implemented an online configuration management system using Access
- Designed, created, tested, and implemented an online time reporting system using Access
- Provided PC hardware and software technical support to the Year 2000 Project team
PowerBuilder, InfoMaker, Windows NT, SQL, COBOL, MVS, ISPF
- Created and tested new COBOL programs to create accounting reports
- Modified the R*STARS mainframe COBOL programs to create new batch reports for the client/server database
- Created PowerBuilder reports using Sybase InfoMaker
SQL, COBOL, JCL, DB2, OS/2, CICS, PROX/MVS, XDB, ISPF
- Modified and tested the R*STARS COBOL programs for the new Year 2000 compliant version 2.1 baseline
- Maintained and executed JCL for system testing
- Maintained the OS/2, Micro Focus COBOL, PROX/MVS, XDB PC development environment used by the development team
- Provided PC hardware and software technical support to the team
SQL, COBOL, JCL, DB2, OS/2, CICS, PROX/MVS, XDB, ISPF
- Modified and tested the SFMS COBOL programs bugs as reported during acceptance testing
