Sql Server
Resume:
Rob Sanders
**** ** ****** ****** . *********, WA 98311 . ************@*****.*** . C.
[pic]
REPORT DEVELOPER / ANALYST with 9 Years expertise using multiple database
interfaces, familiar with rational database structures, multidimensional
databases, OLAP, Cubes, Eclipsys, Allscripts, Oracle, SQL, SSRS, Visual
Studio, MLM's, Crystal Reporting and Business Objects.
[pic]
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.5 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, SQL 2008, 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, SQL 2008, SSRS, MS Project, MS
FrontPage, Boston Workstation, Allscripts.
. DATABASE: Oracle, Access, SQL Server 2000, SQL Server 2005, SQL Server
2008, Teradata
. APPLICATION DEVELOPMENT: ASP, HTML, XML, Java Script, VBScript, VBA,
VB, SQL
[pic]
PROFESSIONAL EXPERIENCE
Consultant - Report Developer
August 2010 - Present
Vitalize Consulting Solutions Inc.
. Travel to customer site or work remotely as required by the customer.
. Gather report requirements from the contracted customer.
. Design custom SQL Queries, Stored Procedures and Functions to pull
data from the customer databases.
. Create reports using SSRS and SQL Development Studio. Convert older
Crystal Reports to SSRS.
. Integrate reports into customers EMR Eclipsys software. Currently
working on numerous Pharmacy reports.
. Test and confirm the customers' needs have been met.
SSRS Report Developer June
2010 - August 2010
Blue Horseshoe Networking, LLC
. Gather report requirements from the contracted customer. This was
done via telephone as all work was completed remotely.
. Design custom SQL Queries, Stored Procedures and Functions to pull
data from the customer databases.
. Create reports using SSRS and SQL Development Studio. Convert older
Crystal Reports to SSRS.
. Integrate reports into customers EMR Eclipsys software. Worked with
Eclipsys 5.0 SP3, Pharmacy, ClinDoc, Ambulatory, Emergency, Allscripts
reporting.
. Test and confirm the customers needs have been met.
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) Eclipsys.
. Implemented Eclipsys Reports using Express Load and Unload, and by
SSRS or Crystal report integration processes. Experience working with
Clinical Documentation, Pharmacy, Ambulatory Care, Emergency
Department, Dietary Department,, Rehabilitation, Wound Care,
Prescription Writer, Sunrise Clinical Manager, Allscripts and
Palliative Care Reports .
[pic]
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), 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)
2001 - 2002 Ivy Tech Community College
Indianapolis, IN
. Information Technology
Contact this candidate