Experience
Current Employer/Experience, not provided online, can be requested through email contact
July 2001-present

Arynth, Inc., Cinnaminson, NJ 08077
Senior Consultant July 1999 - July 2001
Arynth is a consulting and software company focusing on Business Intelligence solutions. Services include business case development, process analysis, project management, prototyping, data and application modeling, data warehouse and data mart design and implementation, OLAP development, data mining projects, SAS and other statistics services, Web site development, programming in multiple languages, and training in concepts and software. Value added resellers of Sagent, Data Junction, Business Objects, and Angoss software.

Data Warehouse Data Integration Analyst - June, 2001 - July, 2001

• Brought existing development environment into synch with production environment in SQL Server 7.
• Exported Sagent plans from production repository and imported into development repository.
• Tested Sagent plans to make sure that there were no data quality issues in development environment.
• Used SQL Server 7 DTS and SQL-DMO environment to synch structures, stored procedures, and data between production and development environments.
• Recreated DTS packages and jobs on development server.
• Monitored ETL process on development server. Performed QA checks.
• Created Business Objects development environment on NT Server, mirroring production environment on more powerful NT 4.0 Server.
• Moved Business Objects universes from production to development and changed connection parameters to use ODBC connection to development database.
• Recreated web structure for Executive Information reporting structure on development server.
• Transferred VB executable that uses Business Objects reports to create Executive Dashboard from production to development and tested for issues on the less powerful server that would require performance tuning.
• Monitored test data as it passed through ETL processes on development server for integration issues.

Business Objects Developer - February, 2001 - June, 2001

• Created reports for end users in Business Objects client/server version against an Oracle data mart and modified existing reports based on user requirements.
• Managed and maintained user security in Business Objects Supervisor.
• Revised established universes against an Oracle 8.1 database on Unix and tested for impact on reports currently in production.
• Switched WebIntelligence auditing from log files to database tables in Oracle. Installed and configured Business Objects auditing universe and reports.
• Installed Business Objects WebIntelligence 2.6 SR2 on a training/demonstration environment utilizing Microsoft Windows NT4 servers, reconfigured WebIntelligence and Broadcast Agent, and tested impact of upgrade prior to installation in production environment.
• Re-installed previously customized WIS files and customized new files created with the service release to provide corporate look to WebIntelligence interface.
• Installed the WebIntelligence SDK, wrote and tested ASP pages to interface with WebIntelligence.
• Installed and tested a WebIntelligence patch to provide downloads directly to Microsoft Excel.
• Provided documentation for Windows NT server tuning for Business Objects.
• Wrote documentation on versioning in Business Objects.

Business Objects Developer/Trainer - November, 2000

• Provided guidance and consultation for a Business Objects 5i server installation on Microsoft NT4.0 with repositories built in both Microsoft SQL Server 7 and Oracle 8.
• Taught accelerated course of Business Objects Designer
• Taught accelerated course of Business Objects InfoView/Reporter/Explorer.
• Provided consulting expertise with the creation of their first Business Objects universe of medical-related data from a SQL Server 7 database in 2 days.
• Researched advanced topics in Business Objects universe creation such as prompts from the universe, using database-specific SQL syntax in constraints, and the creation of user-specific attribute fields.

Data Warehouse Architect/ BI Web Developer - March, 2000 - February, 2001

• Performed analysis and design of new subject areas, Orders and Shipments, to be included in the data mart.
• Performed data quality assessments on the source tables to be used to populate the new subject areas for Orders and Shipments.
• Data modeling of star schema data mart. Reverse engineering and analysis of the structure and content of source data systems.
• Analyzed new subject areas and designed Sagent ETL processes for populating the data mart.
• Documented the refresh process for the data mart, including new subject areas, with Visio diagrams accompanied by text descriptions.
• Provided comprehensive data dictionary, including new subject areas, for the data mart.
• Coded, tested, and debugged Transact-SQL stored procedures for those processes not handled by Sagent.
• Coded, tested, and debugged Transact-SQL stored procedures to create tables specifically for Business Intelligence reporting in Business Objects.
• Created Web-based executive dashboard using Business Objects and Macromedia Dreamweaver.
• Designed dynamic html pages using Javascript to access stored archived reports in both html and pdf formats.
• Analyzed the corporate and business users' needs for a division website for Business Intelligence reporting and implemented the architecture using IIS4.0 web server.
• Designed and implemented in ASP a web-enabled control panel to monitor the functioning and refreshing of the data mart
• Prototyped a VB COM component to dynamically manipulate a Business Objects document to provide users with interactivity while still outputting the document as html. Wrote ASP pages to input data to the VB COM object and then to format the data returned from the VB COM object.
• Designed Business Objects universes to provide access to data mart as well as to custom designed tables created specifically for Business Intelligence reporting
• Installed WebIntelligence 2.5 and debugged install process on development and production NT servers and upgraded both servers to WebIntelligence 2.6 upon version release.
• Documented logical and physical website structure using Visio diagrams with accompany text annotation as to the logic surrounding choices made during the analysis and design of the website.
• Documented the refresh process, including Business Objects reports, running the VB executable and DTS job scheduling, necessary to the operation of the executive dashboard for Business Intelligence reporting.

Web Programmer/Developer - July - September, 2000

• Developed an ASP web page that serves as a user interface to an Excel application via a middle layer consisting of a custom ActiveX control
• Debugged complex implementation issues through a combined use of the Visual Basic and Visual Interdev development environments

Other

• Certified Sagent developer and trainer
• Business Objects developer and trainer

Christiana Care Health Services, New Castle, DE
Senior Systems Analyst July 1999-February 2000
Project lead for the Data Warehouse initiative of an integrated delivery system. Designed, tested, and implemented a successful decision-support database in Oracle based on a star schema model to support the reporting needs of a health plan. Populated the data warehouse utilizing a combination of Sagent extraction/transformation plans and PL/SQL programming scripts. Wrote complex Sagent and SQL plans to transform, scrub and re-code insurance claims data for government reporting. Documented the steps necessary to extract data and populate the data warehouse utilizing project plans and Visio flowcharts. Created Sagent and Cognos OLAP cubes to report to executives from the data mart. Prototyped, designed, and implemented an intranet site for on-line analytical processing access to data available within the data mart. Served as data modeling resource on next data warehouse subject area. Taught colleagues how to utilize ERwin while modeling the requirements for the Patient-centric data mart.

Systems Analyst July 1998- July 1999
Data modeler on a data warehouse initiative to support the decision-making capabilities of a health plan within an integrated delivery system. Synchronized the data model and SQL Server 6.5 database for an Operational Data Store using the ERwin CASE tool then changed the model from the IDF1X modeling methodology to the IE methodology, inserted verb phrases for managing relationships, and renamed indexes according to a data modeling policy. Documented the scope of the initial effort for the data mart and lead the meetings related to gathering requirements. Designed the star schema for the health plan data warehouse using the ERwin CASE tool's dimensional modeling schema and forward-engineered the model into an Oracle database. Authored the policy statement regarding the development of data models, both transactional and dimensional, using ERwin CASE tool. Utilized ERwin to reverse-engineer source databases from FoxPro and Microsoft SQL Server 6.5 and 7.0 for data profiling and field mapping into the data mart. Taught two classes in HTML to colleagues. Attended training for Sagent, Oracle, and MapInfo as well as a Project Management class, a Data Warehousing and OLAP conference, and a Data Management conference.

Thomas Jefferson University Hospital, Philadelphia, PA
Clinical Nurse II, Labor & Delivery August 1991- July 1998
Provided primary nursing care for patients in a high-risk labor and delivery unit. Acted as charge nurse on a rotating basis. Trained incoming professional staff, and mentored nursing students during their clinical rotation. Co-chaired the Salary Model Committee and served on the Critical Care Committee. Served as editor for the unit newsletter, Special Delivery. Obtained CEU's for Critical Care in Obstetrics, Hemodynamic Monitoring, and Advanced Fetal Monitoring. Certified in Basic Cardiac Life Support and Neonatal Advanced Life Support.

Clinical Nurse I, Neurosurgical Unit MAY 1990 - August 1991
Provided primary nursing care for patients on a neurosurgical/neurology/adolescent unit. Attended discharge rounds on patients. Acted as charge nurse on rotating basis. Precepted new graduates and oriented them to night shift.

The Office Nurse, Philadelphia, PA
Contributing Editor, Book Reviews May 1990 - February 1991
Selected books to be reviewed and contacted publishing companies. Recruited qualified professionals to perform the reviews. Edited and published the finished copy in the journal.

Design Experience
Maternal Child Health Nursing Links http://www.pages.drexel.edu/~sg963pfa (currently offline)
Original website designed by myself. The site is devoted to providing links of interest to nurses in the field of Maternal-Child Health Nursing. Graphics were obtained as per a linkware agreement and the site adheres to the principal of giving credit where credit is due. The site was coded entirely by hand using Notepad, no other HTML generators or WYSIWYG editors were used. The site is in the process of getting a makeover utilizing new navigation methods, and new means of information presentation.

Couch Corner Graphics http://members.bellatlantic.net/~klevan
This website is designed to provide linkware graphics for amateur website designers and others not graphically inclined. All of the graphics displayed on the website were designed by the author using Paint Shop Pro. The site is published and maintained with WebMasterPro and has been updated with Macromedia Dreamweaver. The site demonstrates the wide range of graphics available for navigation panels and demonstrates the advanced elements of drop down/fly out menus. Also, the site illustrates different forms of photo/image manipulation available to enhance presentation on websites.

Skills
Web Development: HTML, XML, Cascading Stylesheets, JavaScript, VBScript, ASP 2.0, Macromedia Dreamweaver 3/Fireworks 3 Studio, Macromedia Dreamweaver 4 / Fireworks 4 Studio, Allaire HomeSite, WebMasterPro, Sagent WebLink, Business Objects WebIntelligence, Microsoft FrontPage 98 & Visual Interdev, Netscape Navigator and Netscape Communicator, Internet Explorer, Eudora Light and Pro.
Data Warehouse: Star schema and dimensional modeling, Sagent Data Mart Server, Design Studio, and Automation.
OLAP: Sagent Analysis, Cognos, Business Objects.
Databases: Oracle Enterprise Manager and DBMS 7 and 8, Microsoft SQL Server 6.5 and 7.0, Microsoft Access.
Modeling: ERwin CASE tool and ModelMart, VISIO Standard 4.0, VISIO Professional 5.0, and VISIO2000
Groupware: Lotus Notes 4.5 and LotusScript.
Simulation: Ithink Simulation software.
Statistics: SPSS Statistical Package.
Languages: C, PL/SQL, Transact-SQL, Visual Basic, HTML, JavaScript, ASP.
Operating Systems: Windows 3.1, Windows NT, Windows 95, Unix.
Mapping: MapInfo and MapMarker.
Graphics: Paint Shop Pro, Macromedia Fireworks, Photoshop, and Microsoft Image Composer.
Project Management: Microsoft Project 98.
Office Suite: Microsoft Office '95, '97, and 2000.

Education
Masters of Science in Information Science March 1999
College of Information Science and Technology
Drexel University, Philadelphia, PA
GPA of 3.941/4.0.
Relevant course work included:
C Programming and Software Project Management
Database design with ORACLE on UNIX, and ACCESS on PC workstations
Structured Analysis and Design and Object-Oriented Analysis and Design
Human Interface Design
Internet Development
Computer Supported Cooperative Work

Bachelor of Science in Nursing May, 1990
Summa Cum Laude
School of Nursing
University of Pennsylvania, Philadelphia, PA
GPA of 3.82/4.0.

Awards
Dean's List: 1987-88, 1988-89, 1989-1990
Dorothy Mereness Award for Scholarly Writing
Sigma Theta Tau, Xi Chapter, Nursing Honor Society

Presentations
"Data Warehousing and the Integrated Health Care System." September 17, 1999. Presentation to the CEO of Christiana Care Health System of the results of the first year of their data warehouse project. Presentation included demonstrations of Web based reporting and Cognos OLAP cubes extracted from the Oracle warehouse.

Teaching
1999
Introduction to HTML Programming
Seminar teaching the basics of HTML Web page coding.
One session for Christiana Care Health System.

Advanced HTML Programming
Seminar teaching the advanced HTML techniques.
One session for Christiana Care Health System.

Publications
Song, I-Y and LeVan-Shultz, K. (1999). "Data warehouse design for e-commerce environment," Proceedings of the International Workshop on the World Wide Web and Conceptual Modeling.

Medsker, C., Ewen, E., Dusterhoft, L., LeVan-Shultz, K., Smith, J., & Gottschall, M. (1998) "Data warehousing in an integrated delivery system: Building the business case," Proceedings of the First International Workshop on Data Warehousing and OLAP.

LeVan, K. (March/April 1990). "Developing attitudes of the teenager and their effect on her prenatal care," The Office Nurse.

LeVan, K. (December 1988). "Psychosocial implications: Type II Diabetes Mellitus as related to compliance," The Office Nurse.

Continuing Education
Training Seminars:

• Unix: The User Environment, SmartForce Online Training, June 2002.
• Web 101, Darrin Graviet, CompuMaster, June 2002.
• Fundamentals of Solaris 8 for System Administrators, D. Torrez, eXceed Education, March 2002.
• Data Warehouse Bootcamp, Pieter Mimno, Informatica Seminar, February 2002.
• Quality in the Corporate Information Factory Architecture, Claudia Imhoff, FirstLogic Webinar, February 2002.
• Code 1 Plus, Address Verification, Group1 Professional Services, January 2002.
• Advanced INTEGRITY Concepts, Vality Educational Services, December 2001.
• Fundamentals of INTEGRITY, Vality Educational Services, October 2001.
• Informatica PowerCenter5, Informatica Educational Services, September 2001.
• Informatica PowerConnect for Mainframe, Webinar, August 2001.
• Vality - Data Re-engineering with INTEGRITY, Vality Professional Services, August 2001.
• IBM MQ Series 5 & MQ Series Integrator, IBM Professional Services, August 2001.
• Building the eCRM Data Warehouse, Sagent Professional Services, February 2001.
• Building and Using a Data Warehouse for Business Intelligence Conference & Expo, DCI, August 2000.
• Business Objects Partners Summit, Busines Objects Americas, July 2000.
• Business Objects WebIntelligence System Administration, Business Objects Training, March 2000.
• Visual Interdev Debugging Environment, Christiana Care Training Seminar, January 1999.
• ADO in Visual Interdev, Christiana Care Training Seminar, December 1999.
• Integrating and Managing Sagent's WebLink, Sagent Professional Services, December 1999.
• Sagent Solutions '99, Sagent, October 1999.
• Introduction to Visual Interdev, Christiana Care Training Seminar, September 1999.
• XML: Designing Your Own Markup Language, Drexel University Continuing Professional Education, August 1999.
• Spicing up Your Webpages with JavaScript, Drexel University Continuing Professional Education, July 1999.
• Sagent WebLink Clinic, Sagent Professional Services, May 1999.
• Introductory and Intermediate MapInfo Training, MapInfo Training Program, April 1999.
• Optimizing the Oracle 8 and Sagent Environment, Sagent Technologies Workshop, January 1999.
• Configuring Microsoft Internet Server and Index Server, Christiana Care Training Seminar, November 1998.
• Web Management with FrontPage 98, Christiana Care Training Seminar, November 1998.
• Building Data Warehouses with SQL Server 7.0, Microsoft Training Seminar, October 1998.
• Sagent Data Mart Software, September 1998.
• Oracle 8 Database Administration and Warehouse Optimization, September 1998.