Rob Sanders

**** ** ****** ****** ∙ Bremerton, WA 98311 ∙ ot8l16@r.postjobfree.com ∙ 360-***-****

________________________________________

REPORT DEVELOPER / ANALYST with 9 Years expertise using multiple database interfaces, familiar with rational database structures, multidimensional databases, OLAP, Cubes, Oracle, SQL, SSRS, Visual Studio, Crystal Reporting and Business Objects.

________________________________________

SUMMARY OF QUALIFICATIONS

• Development and maintenance of custom reports and queries in a multi-platform environments.

• Design data models, stored Procedures, and custom views.

• 1 Year, 8 Months experience with Eclipsys Version 4.5 to 5.0 SP3 creating reports and stored procedures.

• Perform data analysis to ensure data integrity, accuracy, and to answer whatever business questions requested at the time.

• 7+ years expertise using SQL in SQL 2000, SQL 2005, Oracle, Access.

• 2+ years using SQL Reporting Services with SQL 2005.

• 2+ years experience using both Crystal reports and Business Objects.

TECHNICAL SKILLS PLATFORMS AND TOOLS

• SOFTWARE: Visual Studio .NET, MS Office, Crystal Reports, Business Objects, Eclipsys, SQL 2000, SQL 2005, SSRS, MS Project, MS FrontPage, Boston Workstation

• DATABASE: Oracle, Access, SQL Server 2000, SQL Server 2005, Teradata

• APPLICATION DEVELOPMENT: ASP, HTML, XML, Java Script, VBScript, VBA, VB, SQL

________________________________________

PROFESSIONAL EXPERIENCE

REPORT WRITER/ANALYST July 2008 – April 2010

HARRISON MEDICAL CENTER Bremerton, WA

• Gathered, organized, validated, and manipulated data to answer business questions as needed by management.

• Designed and programmed custom reports throughout the organization. Maintained current reports created in Crystal Reporting 10 and SQL Reporting Services. Created Ad-hoc reports as needed and carry out report projects as required.

• Meet with Executive and Department leadership to discuss reporting needs and provide support as needed.

• Created scripts using Boston Workstation to automate user tasks which saved time, money and results in greater accuracy.

• Daily use of SQL 2005 with SQL Reporting Services and Crystal Reports 10. I created custom queries, views, models, and stored procedures using T-SQL and I’m familiar with other variations of SQL. I integrated custom reports with the hospital’s electronic medical records system (EMR).

________________________________________

PRODUCT (PRICING) ANALYST September 2006 – July 2008

SAFECO INSURANCE COMPANY Seattle, WA

• Utilizing knowledge of one or more Safeco products, including pricing, policy, intended market/customer, competitive advantage and positioning, sales growth history and trend, profitability and strengths and weaknesses of competitor offerings.

• I constructed complex quantitative data models to answer questions by gathering and structuring data, creating formulas or queries to manipulate data, validating data accuracy and integrity and insuring the models output answers the intended questions. Created Ad-hoc reports as needs arise.

• Collaborated with others across the organization to achieve objectives; uses communication skills and organization savvy to partner with people of different skills, expertise and perspectives to reach individual and joint goals.

• Use of a variety of data sources and tools including MS Access, MS Excel, MS Word, SQL Server 2005, SQL Integration Services, SQL Reporting Services, TSQL, OLAP Cubes, Data Warehousing and VBA to present, report, and create state legal filings. I enjoyed building automated special tools from MS Access & MS Excel using VBA to create efficiencies in the work place.

DATA ANALYST May 1999 – May 2005

ELECTRONIC DATA SYSTEMS Indianapolis, IN

• Investigated casualty data; identified casualty related payments and notified potential liable parties. Tracked Casualty cases, arranged for repayment of casualty related expenses, and communicated casualty related information to members, attorneys, and insurers.

• Managed client projects, acting as a liaison between customer and technical solutions/support group to identify business processes, systems and product requirements.

• Formulated and defined systems scope and objectives using information technology and industry knowledge/requirements. Considered the business implications of the application of technology to the current business environment.

• Maintained client Web sites using MS Front Page, ASP, VB Script, Java script. Supported all aspects of the business cycle including proposals, feasibility studies, and implementations.

• Documented problems and correction procedures. Gathered hardware/software requirements for customer orders. Managed department projects as assigned by the director. Conducted case reviews to continually update and push cases forward.

• Analyzed data for trends and analysis. Created reports utilizing Crystal reporting, SQL, Business Objects, MS Access, MS Excel & MS Word.

MILITARY SERVICE

• UNITED STATES MARINES CORPS February 1982 – March 1990

Honorable Discharge

________________________________________

EDUCATION AND TRAINING

2009 MCP Certification; Supporting Users and Troubleshooting Microsoft XP Operating System

2008 Eclipsys Corporation Atlanta, GA

• Configuration I and II (EMR)

• Report Writing (EMR)

2006 – 2008 Safeco Insurance Seattle, WA

• MS Excel Pivot Tables (2006), Using Safeco Tools and Resources (2006), Security (2006), Executing Our State Plan (2007), New Cost Guide (2007), True Pricing For Personal Home (2007), MS Outlook Work Smarter (2007), MS Access “Basics” (2007), MS Access “Queries & Filters” (2007), MS Access “Multiple Table & Parameter Queries (2007), MS Access “Action Queries & Calculations” (2007), MS Access “Basic Reports & Forms” (2007), Overall Rate Selection (2008).

2000 – 2005 Electronic Data Systems Indianapolis, IN

• For Your Eyes Only-Information Security Awareness (2001), Security Awareness Refresher (2002), Workplace Harassment for Individual Performers (2002), Digital Workflow Overview (2003), Employee Self Service (2003), Security Awareness Refresher (2004), MS Excel 2003 Fundamentals (2004), Advanced Business Communication – Business Writing for Results (2004), Business Objects Fundamentals (2004), Crystal Reports 8.5 – Introductory Report Design (2004), Export Control (2004), Medical Terminology (2004), MS Excel 2003 Proficient User (2004), Project Management – The Fundamentals (2005), Managed Change (2005)

2003 Crystal Users.com Milwaukee, WI

• Crystal Reports Design 8.5 Advanced for SQL Users

2001 – 2002 Ivy Tech Community College Indianapolis, IN

• Information Technology

Contact this candidate