Steven Philips (408) 841-1885 opportunities@philipsfamily.net www.philipsfamily.net 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. Computer Skills * MS Office Professional Suite (Word, Excel and PowerPoint) - Twelve years. o Excel Proficiency with functions, formulas, histograms, pivot tables & graphs for statistical analysis o PowerPoint presentations & animation o Word Proficiency with page layout, graphics, mail merge, & publishing. * Microsoft Visio 2000, 2002 & 2003 - Five years experience o Data modeling o Process Mapping o Reverse Database Engineering to map database o 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 Steven Philips (408) 841-1885 opportunities@philipsfamily.net www.philipsfamily.net