Project Manager Data Warehouse
Resume:
J eana Thornton
Park City, Utah 84098
Email abmmce@r.postjobfree.com
SKILLS
Software: Microsoft Access Microsoft Office Suite Microsoft PowerPoint Microsoft Excel
Microsoft Windows ’00 XP Microsoft Word 1st Page 2000 HTML Editor TOAD SQL Editor SQLDBX, AS400/ISeries
Hardware: Dell, Gateway, IBM, Iomega, Smart Card media, Toshiba, NICs, A+ training
Systems and Networking: Windows (95/98/NT/2000/ME), TCP/IP, Novell 5.1
Languages: Visual Basic, HTML, PL/SQL Databases: Oracle8i, 9I, 11g Access, Facets, Sybase
HIGHLIGHTS
Over 10 years Medical Reporting experience.
Over 7 years of Data Warehouse experience.
Automated reporting processes resulting in significant cost savings for Intermountain Health Care.
ADDITIONAL INFORMATION
Ability to work well with others, and within a team structure enabling a better work environment.
Success in working with diverse backgrounds through individual or group engagement.
Ability to "absorb" information quickly with little instruction.
Ability to work independently and initiate action.
Comfortable dealing with conflict and offering solutions.
COLLEGE EXPERIENCE
University of Wyoming - 4 Years Outpatient Cardiac Rehabilitation
University of Wyoming - 2 Years of Exercise Physiology Research
Exercise Physiology Internship Specializing in Cardiac and Pulmonary Rehabilitation. -University of Utah
EXPERIENCE
June 2007 – Present
Intermountain Health Care
Senior Reporting Administrator Salt Lake City, Utah
• Supervise, mentor and train users in SQL, Crystal Reports, Oracle, Facets and Enterprise Data Warehouse (EDW).
• Lead company wide initative to go paperless. Converted AS400 System Reports to Crystal Reports. Saved over 50,000 sheets of
paper per week and significant cost savings due to automation.
• Work with departments to automate existing processes. Increase efficency and accuracy of reports by automating manual
processes, thus reducing error, and saving time and money.
• Documented and organized over 300 existing Sybase and Facets, EDW, and AS400 System reports.
• Meet with each department on a quarterly basis to discuss reporting needs.
• Tracks, test, and deliver reports developed in the Reporting Department.
• Work closely with business users and report developers to ensure that reports are delivered accurately and on-time.
• Maintains reports currently in production and resolve problems called into the Help Desk related to reports.
• Convert Access and Excel reports into Oracle enviroment.
• Participate in Facets Systems Upgrade and assess impact to reporting needs.
• Participate in Oracle Upgrade and assess impact to reporting needs.
• Create Ad Hoc Reports based on business needs.
• Conduct company wide presentations explaining reporting standards.
September 2005 – June 2007
RxAmerica
Data Warehouse / Business Analyst, RxInsider System Administrator Salt Lake City, Utah
• Supervise and train Data Warehouse / Business Analysts on SQL, and reporting tool applications.
• Create models and reports using SQL and TOAD SQL Editor.
• Team lead for company wide CRM implementation project.
• Publish reports via the Internet to internal and external customers using SAGENT Design Studio.
• Meet with a internal and external users to identify additional possibilities to create reports and models that would give the
organization a significant boost in revenue, cost reduction or customer satisfaction.
• Facilitate discussions with internal and external customers to anticipate future needs and opportunities for reports and models.
• Make decisions on which data and which decision support applications would be most beneficial.
• Act as a liaison and advocate for the end users of the data warehouse.
• Work closely with internal and external users to understand the current state of information available, and then identify future
needs based on their analysis of business requirements, current state environments, and future state warehousing
implementation
• Provide first-line user support for the RxInsider reporting tool supporting 200 internal and external customers
• Provide training for internal and external customers both on and offsite
• Responsible for overall coordination of user acceptance testing and training.
• Created Policies and Procedures for RxInsider System Administrator Position.
Maintained the RxInsider Reporting Application for over 200 existing clients.
• Skilled at Training and Presenting software applications to internal and external customers.
October 2003 – September 2005
Credit Union Software Support Technician / Crystal Database Administrator Salt Lake City, Utah
• Unix System Administration supporting approximately 300 clients.
• Resolve both software and hardware issues, such as hard drive failures, and printer configurations and connectivity issues.
• Maintained and managed Credit union databases that contained company financials, Home Banking financial services, and
ATM information.
• Responsible for maintaining the Crystal Database ensuring that the reports are accurate and correctly work on clients
systems.
• Repair and remove corrupt data from the database to ensure data integrity.
• Instruct, train and advise end-users on the execution and modification of these reports.
June 2000-2003
eBay Incorporated Draper, Utah
Project Manager
• Selected to manage a pilot program designed to increase new customer usage and retention on the eBay site. Programs were
developed and released on the eBay site as “Live Chat” and eBay Stores.
• Developed Oracle and Microsoft Access database solutions for customer call tracking, which gave management the ability to
query data on virtually any issue for custom-designed reports.
• Provided detailed statistical reports related to the progress of the program to the marketing department, which was then used to
find the optimal communication media needed to maintain cost effective customer support.
• Conducted market research that captured data on target market demographics, competitor initiatives, and e-commerce industry
trends.
• Used market research data to revamp direct e-mail campaign strategy.
• Co-wrote New Member invitation letter to be sent to selected eBay members for program participation, which was sent to over
120,000 eBay members.
EDUCATION
• University of Wyoming, Bachelor of Science, Graduated May 2000
Contact this candidate