Customer Service Sql Server

Freida Oliver

**** ***** ***** **. * Alpharetta, GA 30005

Home Phone 786-***-**** w acelgu@r.postjobfree.com

QUALIFICATIONS

Proficient in the following Applications

SQL Server Management Studio(SSMS), SQL Server Reporting Services(SSRS), Sql Server Integration Services(SSIS), MS

Access, MS Excel, Crystal Reports, MS Report Builder, MS-Project, SunGuard Financial Systems, Citrix, Visio, Windows

OS/Server (Active Directory), Trizetto Qnxt, Siemens Soarian Scheduling, Seimens Soarian Clinicals, Siemens Healthcare

Intelligence/Decision Support Systems, Toad for Oracle, Healthcare query.

Applied IT/Analyst Skills

Data Extraction and Conversion using SSMS and SSIS

SQL Administration

Compose various statistical and financial reports using SQL, Access, and Excel

Data Results Presentation in Published IE reports using SSRS, Crystal Reports, and Excel

Applied Research/Analysis of healthcare systems- Hospital and HMO

Requirements Gathering

Additional Skills

Effective Communication Skills and Customer Service Skills

Technical writing and Documentation

Trouble shooting/Analytical

Ability to learn quickly and use newfound knowledge effectively

Corporate Technical Training

WORK HISTORY

Baptist Health South Florida(Hospital system)

Business Intelligence Consultant 2 06/13-present

Develop and manage the data structures required to support the enterprise using BI tools such as SQL Server

Management Studio, Sql Server Integration Services and Toad for Oracle. Plan, design, and implement application

database code objects, such as stored procedures and views. Build and maintain SQL scripts and complex queries for

data analysis and extraction. Provide database coding to support business applications. Work with business

stakeholders, developers, clinicians, and production teams across functional units to identify business needs and discuss

solution options. Develop and generate standard and ad-hoc reporting, metadata, and report definition from data

warehouse, Siemens Soarian Scheduling, Seimens Soarian Clinicals, Siemens Healthcare Intelligence/Decision

Support Systems.

Simply Health Care

Data Analyst 04/12- 05/13

Apply SQL programming and SSIS(ETL) skills and to extract, cleanse, manipulate, match, and merge data to create

professional reports in response to ad-hoc and recurring queries. Write SQL queries to capture data from various

sources for analysis. Analyze data to report for money recoupment and cost saving opportunities. Develop reports

using SSRS to track and audit claim payments and provider members. Import/Export various sql tables from one

database to another by using Stored Procedures and SSIS packages. Conduct department training on various topics

relating to databases and reporting, as well as create professional course materials.

Preferred Medical Plan

Business Analyst 07/06 to 04/12

Examine and evaluate reporting requirements for various business units across the organization. Used proven

knowledge of specialized reporting tools such as SSRS and Crystal reports to develop reporting structures as required.

Responsible for proactively generating and compiling reports based on findings, complete with recommended

improvements to – or new requirements for – business processes, operational procedures, and their corresponding

Reporting structures; Use applications such as SQL Serve Management Studio, Import/Export(DTS) Wizard for data

extraction.

Secondary Responsibilities: Provide a single point of contact for end-users to receive support and maintenance within

the organization’s desktop computing environment. This includes installing, diagnosing, repairing, maintaining, and

upgrading all PC hardware and equipment to ensure optimal workstation performance. Also troubleshoot problem areas

(in person, by telephone, or via e-mail) in a timely and accurate fashion, and provide end-user assistance where

required. Research, test, and evaluate current and future company software.

Siemens Business Services

Technical Analyst III 02/05-01/06

Analyzed and revised business processes and practices in accordance to our client’s needs and demands.

Resolve escalated issues pertaining to tech support, procurement, and new hires, as well as provide desktop support to

internal clients. Assisted onsite client in network support as it pertained to Active Directory and MS exchange.

Monitor servers and implement rollouts: such as virus def. updates and software upgrades. Train new employees on

our client’s IT procedures and policies, as well as, existing employees on how to improve our quality of service for our

client. Monitor work order queues, to make sure issues were resolved in a timely manner. Used Clarify system to

monitor and amend work orders so that they in accordance to SLA’s

Dish Network

Quality Assurance Supervisor/Trainer 11/03-2/05

Perform quality checks on satellite installations for internal technicians, as well as subcontractors. Make sure Satellite

dish installs are in accordance with company policies, as well as, government standards (NEC). Identify and train

technicians in weak areas based on quality inspections. Trained employees on new satellite technologies as it pertained

to the company’s interest. Coordinate weekly meetings with myself and subcontractors to confabulate about work that

failed company inspection. Also conduct interviews with customers, onsite or over the phone, to make sure technician

demonstrated excellent customer service skills while in the customer’s home. Create weekly team meeting agenda and

review safety guidelines.

Certainteed

Network Administrator 11/ 00-11/03

Installed, supported, and configured the following: Novell 5.0 Network (NDS), NT Server, 2000 server, Active

Directory, Exchange Server, and Fax Servers using TCP/IP, DHCP, and DNS protocols. Installation of and

troubleshooting for Cisco routers, Nortel switches, and Netgear hubs, DSL Modems using frame relay and CDP

protocols. Setup and configured all pc’s for internet and network access. Setup wireless networking equipment using

access points, RF antennas, and 802.11b protocol. Install CAT 5 cable throughout window plant to connect PC’s to

Ethernet network. Made updates to website. Provide internal customer support to employees. Setup and maintained

user accounts on Windows 2000, exchange, and Company MRP (BookMate Pro) software. Configured and setup HP

laser printers to network and well as a Kyocera copy machine. Wrote financial reports using crystal 8 and VB for

Controller; extracting date from a fox pro database. Successfully, managed the following projects: Migration from

Windows 98 to Windows 2000; Server migration to active directory; copier/printer purchases, and Norton Enterprise

rollout. Organized and coordinated companywide training on new software or equipment, as well as wrote training

manuals and reference guides for my classes. Installed and configured applications such as AutoCad, Office XP,

Hyperion, and acrobat reader on PC’s in the facility.

Richmond Redevelopment and Housing Authority

Network Administrator 10/99-11/00

Provided network and desktop support for a quasi-government agency, which consisted of 400 employees placed at five

different sites in Richmond. Supported IBM midrange, windows, and exchange servers, as well as pc’s and Mac’s.

Beta Tech

Program Manager/Instructor 2/97-10/99

Headed and launched Computer Networking department at an adult education facility. Facilitated and assisted in

Curriculum and program development procurement of hardware and software, and teaching a wide variety of computer

classes.

Fanuc Robotics Network/PC

Support 10/95 – 5/96

Troubleshooting network PC’s and Printers, computer audits, hardware and software installation, PC configuration for

3.12 network, deleted user accounts, added user accounts, reset passwords, Wrote Helpdesk procedure manuals, and

organized and tracked PC purchases within the company.

VOLUNTEER EXPERIENCE

Techie Kids 07/10 - present

Chairman of the Board

Responsible for the management, the development and the effective performance of the Board of Directors, also

provide leadership to the Board for all aspects of the Board’s efforts.

Techie Kids is a nonprofit company that offers technology and media focused programs to kids ages 8-17.

Zimmerman MS Bike Ride 4/2011, 4/2012

Food Service Volunteer

Traffic Control

Prepared and served breakfast to the Cyclists who were in the race

Redirected traffic and assisted with parking for the event

E D U CAT I O N

University Of Michigan 1991 - 1995

Ann Arbor, MI

Contact this candidate