Objective: Process Analyst/ Database Analyst/ Project Manager
My specialties are analysis, streamlining and implementation of processes by using key software tools for automation. Companies strain to do more with less making my skills essential. My experience, as shown below, is extensive in project management, process development, and relational database development. I have experience with companies large and small, helping each become more efficient in their diverse processes. I am highly adept at learning new programs, new systems and new processes to accommodate each need.
Work Experience
Stanford Hospital and Clinics – Adecco & SHC Jan-2007 - Present Palo Alto, CA
Sr. Quality Analyst & Database Analyst II / Access DBA
Develop new metrics and indicators for many prominent departments at Stanford and utilizing new methodologies to track progress.
Work closely with physicians to build new metrics or data mine to support best practice outcomes. (Anesthesia, Otolaryngology, Orthopaedic, General Surgery, Plastic Surgery, Colorectal)
Develop MS Access Database to calculate The Joint Commission Core Measure algorithms, AHRQ government health indicators, Patient Safety Net Metrics Development (PSN)
Engagement with vendor to perform quality assurance for implementation of Business Objects for the new internal data warehouse.
Ad-hoc reports executed with crisp knowledge of data model within SHC based on administrative data to show trends through run or control charts.
Continued to support Excel working templates and macro development
Documentation of processes and training manuals
My specialty at SHC has been to analyze data and automate reports using Access, Crystal, MIDAS+, Web Intelligence and other software as needed. I developed databases to track and trend AHRQ PSI metrics and Core Measures that were reported on a quarterly and monthly basis utilizing both MIDAS and Access processes. I utilized Access to track PSN System that leverage the UHC downloads to generate canned reports as well as other ad-hoc report capabilities. For preexisting processes using VBA code, I would troubleshoot and modify the code as needed in Excel and Access. I would create useful views in MIDAS Report Track and data extracts from DataVision to facilitate data needs through ODBC connections to other databases. Education in Six Sigma methodologies and statistical analysis using Minitab 14.
Hewlett Packard – TAC Worldwide Sep-2006 – Jan-2007 Cupertino, CA
Business Process Analyst III / Access DBA
Data Source & Report Consolidation by Access to generate one super view as a single source of truth.
Data Modeling & Process Mapping utilizing Visio
Database Architecture development in Access environment
Excel working templates and macro development and usage
Documentation of processes using Word and Visio
On Time Delivery Tool generated & built from the ground up using sustainable processes and little VBA coding to ensure ease of use for non DBA/Programmer specific users. Data consolidation from multiple data sources to provide single source of truth for business processes and groups to leverage.
Chevron Texaco – Rose International Jan-2006 – Sep-2006 San Ramon, CA
Business Process Analyst III / Data Analyst
Excel Workbook Management
Template generation
Data Modeling
Data Continuity
Process Mapping
Built Analytical tools using Excel, to align business strategy planning requirements for tracking data to plan IT investments. Mapped out process using Visio. Created a physical data model based on the logical data model in Access & Visio. Built Excel macro using VBA to streamline a business planning process saving the company $4,000 annually.
Hewlett Packard – TechLink Systems May-2004 – Jan-2006 Sunnyvale, CA
Business Process Analyst III / Project Manager
Developed an Access database for inventory hierarchy
Information gathering for future database development from user community
Web Development & content hosting
Consolidation of Brio Queries
Ongoing duties to streamline data metrics. Consolidate spreadsheets into automated Access databases. Data Analysis of Excel workbooks & related metrics. Drive internal web page development, security and content. Saved 350 man hours on an annual basis going forward on various metrics gathering methods and processes. $200,000.00 in savings in process alignment and automation. Use of a data warehouse BW/DW for R3/SAP/APO by using Hyperion/Brio Insight and Explorer
Cisco Systems, Inc. – IPS/The Armada Group Oct-2002 – May-2003 San Jose, CA
Business Process Analyst III / Project Manager
Developed an Access database for inventory tracking. Developed a separate database to track PO and Vendor history.
Data Analysis of Oracle databases using MS Access ODBC to capture regular metrics.
Implementation of new process flows on an ongoing basis to collect new metrics
Mapped and analyzed current portfolio management process. Designed and developed a system to integrate data for multiple department projects, to monitor associated budgets, allocate resources, and provide management reporting capabilities. Solution reduced manual intervention, and increased accuracy and availability of information. Saved 10-15 man-hours per month, avoided costly errors, and increased decision making capacity. Trained key users and demonstrated opportunities to external organizations.
The Armada Group Aug-2002 – Oct-2002 Santa Cruz, CA
Business Process Analyst III / Database Analyst II
Plan and design MS Access database for data capture.
Streamlined the metrics and collection process.
Develop a cohesive standardized process flow.
Database Administration using pre set tools for Access creation.
Created an Access database around the established process. Defined method for maintaining and processing data. Created an automated system for data collection and metric presentations.
Applied Materials Dec-1999 – Aug 2002 Santa Clara, CA
Business Process Analyst II / Database Analyst II
Data Analysis of Oracle databases using Microsoft Access to capture regular metrics.
Streamlined the metrics process for Applied DST saving $40,000 annually
Implemented new process flows on an ongoing basis to collect new metrics.
Relational Database development for end user tools in their process flow.
Database Administration using pre set tools for access creation.
Implemented new data metric collection methods. Streamlined the process and set up for automation. Saving the company time, effort and money. Established other departments to handle similar metric collecting methods.
MS Office Professional Suite (Word, Excel and PowerPoint) - Twelve years.
Excel Proficiency with functions, formulas, histograms, pivot tables & graphs for statistical analysis
PowerPoint presentations & animation
Word Proficiency with page layout, graphics, mail merge, & publishing.
Microsoft Visio 2000, 2002 & 2003 – Five years experience
Data modeling
Process Mapping
Reverse Database Engineering to map database
Process flows for ISO certification.
Hyperion / Brio : Intelligence - Explorer - Insight 6.2.x to 8.x. Object oriented GUIs built in Java – 4 year experience
MS Access with VBA – Nine years (95, 97, 2000, XP & 2003).
Relational Database Experience RDBMS & Architecture development.
ODBC connection to & usage of ERP packages; Oracle, SAP / R3 / APO / BW, KB/MIDAS, & MS SQL Server
Oracle 9i with SQL Plus and DBMS DBA
Visual Basic – Intermediate level Used for VBA in Access to build GUIs.
FrontPage 98 - 2000, HTML, DreamWeaver MX & FTP tools like Reflections & WS_FTP. Website administration, architect, & maintenance
Adobe Photoshop 7.0 & CS – 5 years experience.
Adobe Acrobat Professional 7 & 8 – 2 year Experience
Internet/Email software; Firefox, Netscape, Internet Explorer, Lotus Notes, Eudora & Outlook
Operating systems Win 95-98/NT/2000/XP Professional and Red Hat Linux
Business Objects Web Intelligence
Crystal XI
Survey Tracker 5.2 – Survey Software for both web and paper surveys
Language Skills
Fluent Russian Language both written & spoken.
Personal Accomplishments
Married Father of two.
1995 – 1997 Service rendered for the Church of Jesus Christ of Latter Day Saints. Location: Samara & Saratov, Russia.
May 1992 Attained Eagle Scout in the Boy Scouts of America
Education
A.S. Computer Applications
A.A. Liberal Arts
References Available by Request