## BIO
SIOBHAN HANSEN Tech Consultant COMPUTER SKILLS: *
**Hardware:** IBM Freeway, 3090 Series, Amdahl, IBM PC's and Compatibles * **Languages:** SAS, SAS/Graph, SAS/Macro, SAS/Data Step, SAS/STAT, HTML, COBOL, BASIC * **Operating Systems:**OS/390, MVS/ESA, PR/SM, VM/XA, WINDOWS/95,98,NT, MS/DOS, UNIX * **Software:** MS/Excel, /Word, /PowerPoint & /Access, FoxPro and R&R, MXG, MICS, OMEGAMON, TMON, RMFMON, BMC BEST/1, BEST/1 CAPTURE, Visualizer & Mainview Predict **<u>EMPLOYMENT HISTORY</u>** 11/97 to 12/01 Merrill Lynch & Company, Incorporated New York, NY Capacity Planner/Performance Analyst * Led project to forecast increased trading at market open using TMON data for CICS, workload analysis, OS/390 SMF/RMF data and BEST/1 modelling for projections. Trained another staff member in use of the BEST/1 product on this project. * Developed SAS analytical reports of resource utilization data (i.e. SMF/RMF,MICS, MXG, TMON) by system, workload, shift etc. * Produced CPU, I/O, Processor Storage and Sysplex Coupling Facility capacity planning studies with BEST/1 modelling, MICS and MXG. * Prepared presentations of study results for senior management including input to departmental annual technology and budgeting report for future hardware requirements as well as studies addressing specific capacity issues and data center requirements. * Set up automated performance reporting system on the web which required production mainframe jobstreams on multiple systems, an automated SQL Server jobstream using SQL Scheduler as well as BMC Visualizer automated scripts and templates and some knowledge of HTML. * Fulfilled frequent Ad-Hoc reporting requests. * Assisted and mentored junior SAS programmers 3/95 to 11/97 NYU Medical Center New York, NY Capacity Planner/Performance Analyst * Established capacity planning function from organizing vendor presentations and demonstrations for senior management evaluation for acquisition thru implementation of products, development of methodologies and techniques. * Oversaw vendor installation and assisted and ensured proper customization of the purchased software i.e. BMC BEST/1 CAPTURE, BEST/1 and Visualizer * Set up automated Visualizer database update procedures and daily monitoring reports. * Designed template for annual Capacity Plan and produced capacity plan for the next year based on workload growth scenarios. Prepared management presentation of results. * Troubleshooting problems and Ad-Hoc reporting/monitoring * Using SAS, MXG, BEST/1&Visualizer, TMON/MVS and TMON/CICS and MS/Office to do * Performance analysis, reporting and presentations to management. SAS Programmer/Research Assistant * Developped statistical analyses programs, physician profiling and outcomes reporting using SAS/Base, SAS/Stat, SAS/Graph and SAS/Macro on PC and Mainframe. Data processed included NYU Medical Center Hospital Information Systems (HIS) data as well as state and national hospital information data sources. * Produced physician profiling/LOS (length of stay) reporting system, using HIS data merged with an in-house information database. This system produced at least 200 individualized graphs from a scheduled end-of-month SAS/MVS job which initiated a completely automated process using a file download to an SQL server to execute a series of Base SAS, SAS/Graph, SAS/Macro and print jobs. * Participated in Caesarean Section study working with staff RN/research assistants in designing questionnaire and developing collection screens, editing, analyses, and reporting/presentation SAS programs. * Trained and oversaw personal in data entry and a junior SAS programmer * Fulfilled frequent Ad-Hoc reporting requests 1990 TO 1995 CONSULTANT/INDEPENDENT CONTRACTOR Prodigy Services Company White Plains, NY 6/94 to 11/94 * Applied SAS programming expertise to develop a centralized Decision Support Database, converting VSAM, DB2, COBOL and flat files to SAS Data Libraries. * Provided AdHoc reporting and developed and implemented automated weekly and monthly report procedures. * Designed, developed and implemented in production programs to support New Business Ventures Marketing group, based on specifications. First Data Technologies Medford, MA 3/94 to 6/94 * Provided AdHoc SAS reporting on resource utilization and requirements. * Designed and developed performance utilization reporting. * Worked with team of analysts to produce a study of system migration requirements for planned data center move. * Analyzed and implemented changes to system parameters to improve service. Fidelity Corporation Boston, MA 12/93 to 3/94 * Provided analytical support and JCL expertise in implementation and standardization of Disaster Recovery procedures. * Provided AdHoc SAS reports as requested. Amdahl Corporation / Aetna Life and Casualty Middletown, CT. Storage Management Dept. 2/93 to 11/93 * Designed and developed automated storage management reporting system in SAS using MICS measurement and utilization data. * Provided SAS AdHoc reporting in support of SMS conversion effort and Tape Mount Management implementation. * Rewrote older SAS programs to improve efficiency significantly shortening run times and reducing CPU consumption. Blue Cross of Massachusetts Boston, MA 1/91 thru 11/92 * Modeled claims processing system, being evaluated by BC for purchase, using BGS BEST/1 modeling software. * Forecasted hardware requirements to support full implementation of the cp system, and potential performance bottlenecks and tuning options. * Designed and developed performance reports in SAS and participated on a team of systems personnel monitoring the performance impact of new software releases and account conversions. * Prepared capacity planning studies and presentations, including a memory modeling study which resulting in delaying the purchase of additional memory for a year. * Performed Data Center consolidation study based on scenarios provided by EDS, to whom BC Data Processing was outsourced at this time. * Installed new release of MXG software. GTE Government Systems Corporation Needham, MA 2/90 thru 11/90 * SAS programming of statistical analyses and graphics presentations. * Developed performance monitoring reports. * Produced five year capacity plan, including attaining long range business group forecasts, workload measurement, resource usage trending, and building BGS BEST/1 models for scenario projections and presentations. 1982 to 1990 Blue Cross of Massachusetts Office of Capacity Management Boston, MA * Served in positions of Capacity Planner (1987 to 1989), * Lead Programmer (1986 to 1987), * Programmer/Analyst (1984 to 1986), * Programmer (1983 to 1984), * Data Analyst (1982 to 1983). * Lear
