Sql server dba, ssrs, crystal, report developer, ssis, dts, etl

PROFESSIONAL SUMMARY

Skilled professional with experience in all stages of SDLC: planning, analysis, design, implementation, and support in the Healthcare, Human Resources, Quality Improvement, Insurance, Workers Compensation, Government, and Finance areas.

KNOWLEDGE, SKILLS, AND ABILITIES

APPLICATION / BUSINESS / SYSTEMS ANALYST

• Plan, analyze, design, implement, and support systems

• Conduct research on system upgrades to determine feasibility, cost, time required, and compatibility with current system

• Install, configure, and upgrade desktop hardware and peripherals

• Troubleshoot, diagnose, and resolve hardware, software, database, mainframe, network, application, and reporting issues

• Record and maintain hardware and software inventories, licensing, and user access and security

PROJECT MANAGEMENT

• Create and maintain project plans including tasks, milestone dates, status, and resource allocation with Microsoft Project

REPORT

• Utilize Access, Crystal, Cognos PowerPlay, Excel, Oracle Discoverer, and SSRS to create, modify, run, export, print, distribute, deploy, and troubleshoot reports

• Identify and select appropriate data sources, tables, and fields

• Create joins/links between tables

• Design reports with formula including totals, and special fields; discrete and range parameters; dynamic grouping and sorting; sub-reports; cross tabs; and conditional formatting

ETL

• Extract, transform, and load data

PROGRAMMER

• Create, modify, test, and troubleshoot SQL stored procedures and triggers used to update data; to send notifications and data via e-mail; as SSRS data sets; and for SharePoint and other web front ends

• Monitor and optimize system performance using SQL Profiler and Database Engine Tuning Advisor

DATABASE

• 4 years of SQL Server 2000, 2005, and/or 2008 production and development experience most recently in an active/passive clustered environment

• Install, configure, maintain including backups, migrate, modify, troubleshoot, and restore instances and/or databases

• Create, modify, schedule, and/or troubleshoot operators, tables, views, functions, stored procedures, triggers, DTS/SSIS packages, jobs, replication, logins and users

• Administered 43 SQL instances. Darn! If it were 42, it would be the answer to life, the universe, and everything…

WEB DEVELOPMENT

• Front Page and SilverStream

TECHNICAL WRITER

• Gather and document functional specifications and convert them into technical specifications

• Document system problems and resolutions for future reference

• Write technical materials, such as user manuals and procedures

TECHNICAL TRAINER

• Taught Access, Crystal, Excel, Front Page, Groupwise, Power Point, and Word classes

APPLICATIONS

• Microsoft SQL Server 2000, 2005, and 2008; SQL Server Reporting Services(SSRS) 2005 and 2008; SQL Server Integration Services (SSIS) 2005 and 2008; and SQL Server Profiler

• Microsoft Access, Excel, Exchange/Outlook, PowerPoint, Project, Publisher, and Word

• Crystal 7 and 10, Abra, Applix/Heat/Service Desk/Jira, Clarity, XOG, Groupwise, HRMS/PDS, Maximo, Oracle Discoverer, Oracle HR, TELEForm, Great Plains, Cognos PowerPlay, SharePoint, SilverStream, UNIX, and Visio

EDUCATION

BS MANAGEMENT INFORMATION SYSTEMS AND MANAGEMENT

University of Nevada, Las Vegas (Only 2 more classes needed to obtain a third major in Human Resources)

CERTIFICATION PREPARATION

2780B Maintaining a Microsoft SQL Server 2005 Database, 2073: Programming a Microsoft SQL Server 2000 Database, and 2072: Administering a Microsoft SQL Server

WOMEN IN TECHNOLOGY INTERNATIONAL (WITI)

South Florida Regional Network Membership Chair 07/2009 – Current

http://www.witi.com/center/regionalchapter/southflorida/aboutus.php

EXPERIENCE

NEXTWEB MEDIA

INFORMATION TECHNOLOGY Plantation, FL

Database Administrator 10/2008 – 06/2009

• Extracted, transformed, and / or loaded data (ETL)

• Create, modify, test, and troubleshoot SQL Server Reporting Services (SSRS) reports

o Create, troubleshoot, and modify stored procedures used as data sets

o Sub reports; matrix, table, and tablix; filter data with parameters; and conditional formatting

o Deploy reports in Reporting Services and SharePoint

o Create, modify, schedule, delete, and / or troubleshoot data driven and / or standard subscriptions

• Analyze stored procedures with Database Engine Tuning Advisor and implement suggestions such as creating indexes

• Create, modify, schedule, test, delete, and / or troubleshoot SQL Server Integration Services (SSIS) packages, stored procedures, jobs, tables, and views

• Utilize SQL Profiler to troubleshoot issues with SSRS and other reports

• Setup transactional replication by creating publication and push subscription using a remote distributor

• Add articles to existing publications

• Utilizing SQL Server 2005 since 10/08 and SQL Server 2008 in an active / passive clustered environment since 04/09

• Getting familiar with Idera’s SQL Diagnostic Manager

ALLIANCECARE

FINANCE Boynton Beach, FL

Business Systems Project Manager 06/2008 – 08/2008

• Troubleshot, created, and modified Cognos PowerPlay and Crystal reports

• Created Crystal Reports which filtered data with selection formula and contained conditional formatting

• Created and modified SQL Server 2000 DTS packages and jobs

• Troubleshot and resolved issues with systems such as Great Plains, and Cerner Beyond Now HomeWorks

• On 2nd and 3rd days on job, successfully resolved an issue with the electronic submission of Medicare claims

CLARK COUNTY’S UNIVERSTITY MEDICAL CENTER OF SOUTHERN NEVADA

INFORMATION SERVICES Las Vegas, NV

Database Analyst (Applications Programmer) 04/2005 - 06/2008

• Extracted, transformed, and / or loaded data (ETL)

• Administered 43 SQL Server 2000 and 2 2005 instances

• Installed SQL Server and service packs; registered SQL Server instances; and configured, stopped, and started services

• Created, modified, scheduled, and troubleshot SQL Server Database Maintenance Plans including Database Backups, Integrity Check, Optimizations, and Transaction Log Backup Jobs

• Created, modified, and deleted SQL logins and users using SQL or Windows authentication including groups and assigning Server or Database roles

• Setup SQL Mail and SQL Agent Mail

• Created, modified, scheduled, deleted, and / or troubleshot SQL Server Operators, Alerts, Data Transformation Services (DTS), Stored Procedures, Jobs, Triggers, and Tables

• Migrated databases

• Restored SQL Server objects, databases, and instances including one to a new server when the old server died

• Setup, monitored, and modified replication of data from SQL Server 2005 to SQL Server 2000

• Worked with System Administrators and Network Engineers to ensure there was enough disk space

• Worked with System Administrators, Developers, users, and vendors to create, modify, troubleshoot, and repair SQL Server databases including determining the minimum SQL permissions needed for applications to function

• Worked with Computer Technicians and users to setup and troubleshoot Access front ends connected to SQL Server back ends via ODBC; documented it; and provided it to others

• Worked with co-workers to plan, analyze, design, implement, and support a Change Management system with a SharePoint front end and SQL back end for the IS Department which included a calendar and e-mail notifications

• Alerted System Administrators a server was down and worked with them to notify users, troubleshoot, and resolve issue

• Delivered IS New Hire Training

• Guided co-workers in creating, modifying, and troubleshooting Crystal reports

• Utilized UNIX to create, modify, and delete user ids and printers; set and change passwords; and delete files

• Imported and exported data from SQL Server for CA’s Clarity application with XOG

CLARK COUNTY

FINANCE, FINANCIAL SYSTEMS Las Vegas, NV

Financial Systems Analyst II 01/2002 – 02/2005

• Extracted, transformed, and / or loaded data (ETL)

• Utilized Microsoft Project to create and maintain project plans

• Scheduled mainframe jobs

• Trained others how to create and run reports

• Utilized Access, Crystal, Excel, Maximo, and Word to create, run, export, print, distribute, and / or troubleshoot reports

o Identified and selected correct data sources, tables, and fields; and created joins between tables in Crystal/Access

o Designed Crystal reports with database, formula, parameter, running total, and special fields; discrete and range parameters; dynamic grouping and sorting of data; sub-reports; cross tabs; and conditional formatting

o Created reports with graphs, charts

• Instrumental in the planning, analysis, design, implementation, and support of a system to track bids, CBE’s, and RFP’s with an Access front end and SQL back end

• Facilitated the definition, prioritization, and documentation of functional needs by interviewing users; scheduling and leading meetings; and translating results into Visio diagrams and Word documents

• Provided technical guidance to teams evaluating alternate solutions by researching vendors, hardware, software, laws, policies, and contracts; and recommending modifications to processes with/without system enhancements

• Converted functional needs to technical specifications and then created/worked with others to create/purchase solutions

• Worked with users and vendor to negotiate statement of work and hardware/software maintenance contract

• Performed/coordinated demonstrations, purchases, installs, removals, testing, training, and support of hardware/software; creation, modification, and deletion of user ids; resetting of passwords, creation of shortcuts, mapping of network drives, and modification of login scripts

• Acted as liaison

• Troubleshot, diagnosed, and resolved hardware, software, mainframe, network, and application issues

• Interpreted, submitted, logged, assigned, transferred, and completed user’s requests

• Used Word to create documents with headers and table of contents which were populated by responses to questions

HUMAN RESOURCES, SYSTEMS Las Vegas, NV

Human Resources Analyst I/II 09/1999 – 01/2002

• Extracted, transformed, and / or loaded data (ETL)

• Created Microsoft Project plans with assignments and time frames

• Created normalized Access databases with splash screen containing macros to merge data with Word documents

• Developed, coordinated, and conducted training on individual and group basis

• Taught Access, Crystal, Excel, Front Page, Groupwise, Power Point, and Word classes

• Utilized Access, Crystal, Excel, and Word to create, run, export, print, distribute, and troubleshoot reports

o Identified and selected correct data sources, tables, and fields; and created joins between tables in Crystal/Access

o Designed Crystal reports with database, formula, parameter, running total, and special fields; discrete and range parameters; grouping and sorting of data; sub-reports; cross tabs; and conditional formatting

• Directed Departmental inventory then analyzed results and recommended disposals, replacements, and purchases

• Planned, analyzed, designed, implemented, supported, and utilized HRIS

• Acted as liaison between users and DBA, Financial Systems, IS, management, and vendors

• Coordinated demonstrations, evaluations, purchases, installations, modification, training, support, and removal of hardware/software; creation, modification, and deletion of user ids and network rights; and modification of login scripts

• Guided teams in analyzing and documenting current processes/systems using Word and Visio

• Facilitated the definition, prioritization, and documentation of functional needs by interviewing users; scheduling and leading meetings; and translating results into Visio diagrams and Word documents

• Provided technical guidance to team evaluating alternate solutions by researching laws, policies, and contracts; researching, evaluating, and making recommendations regarding hardware and software; and recommending modifications to processes with/without system enhancements

• Converted functional needs to technical specifications and then created/worked with others to create/purchase solutions

• Created TELEform Designer forms and exported them in PDF writable format; and created web pages in SilverStream

• Modified templates, applied styles, changed titles, inserted hyperlinks, and modified HTML in FrontPage

• Troubleshot, diagnosed, and resolved hardware, software, mainframe, network, and application issues

• Installed and uninstalled hardware and software; created shortcuts; mapped network drives; and modified user ids

• Interpreted, submitted, logged, completed, tracked, and ensured completion of user’s requests

SIERRA HEALTH SERVICES

HUMAN RESOURCES, INFORMATION SYSTEMS Las Vegas, NV

Human Resources Information Systems Analyst 05/1998 – 06/1999

• Directed and monitored other staff’s completion of tasks and represented HRIS division in HR management meetings

• Extracted, transformed, and / or loaded data (ETL) and created normalized Access databases

• Member of the ORACLE HR / Payroll implementation team

o Documented and communicated report specifications to programmers; coordinated user review, critique, and sign off of reports; and tested reports created by programmers

o Conducted and coordinated user testing of ORACLE HR

• Utilized PDS, ORACLE Discoverer, Access, Excel, and Word to create, run, export, print, and distribute reports

• Administered Equity Edge’s Security by creating user ids and passwords

• Analyzed inventory and suggested disposals, replacements, and purchases; and convinced IS to replace HR’s computers

• Planned, analyzed, implemented, supported, and utilized HRIS

• Facilitated the definition of functional needs by interviewing users, and coordinating meetings

• Coordinated demonstrations, purchases, installations, removals, testing, training, and support of hardware and software

• Researched, evaluated, and made recommendations regarding hardware and software

• Provided technical guidance to team evaluating alternate solutions

• Recommended modifications to processes with/without system enhancements

• Created/collaborated with others to create/purchase technical solutions

• Troubleshot, diagnosed, and resolved hardware, software, mainframe, network, and application issues

• Installed and uninstalled hardware and software; created shortcuts; and mapped network drives

• Interpreted, submitted, logged, assigned, transferred, completed, and ensured completion of user’s requests

• Acted as liaison between users and DBA, IS, management, ORACLE development team, programmers, and vendors

• Coordinated the creation, modification, and deletion of user ids and network rights

• Developed, coordinated, and conducted training on an individual and group basis

• Trained users how to use Access, Excel, Exchange, Word, ORACLE HR, PDS, and ABRA

QUALITY IMPROVEMENT AND RESEARCH, STUDIES Las Vegas, NV

Quality Improvement and Research Analyst 05/1997 – 05/1998

• Member of breast cancer, diabetes, and mental health study teams that conducted studies prior to and post implementation of projects to improve patient treatment and achieve NCQA accreditation

• Analyzed, designed, implemented, supported, and utilized QI&R systems

• Extracted, transformed, and loaded data (ETL) by

o Writing SQL queries, running queries, exporting data, importing and scrubbing data with Excel or Access

• Created relational databases with queries, forms, and reports in Access; user documentation; and conducted training

WORKERS COMPENSATION Las Vegas, NV

Workers Compensation Analyst 08/1996 – 05/1997

• Supported and utilized workers compensation case management system by maintaining data dictionaries; creating and deleting user ids; creating and resetting user passwords; retrieving data; and entering data

HUMAN RESOURCES, BENEFITS Las Vegas, NV

Benefits Technician 04/1995 – 08/1996

• Administered Family Medical Leave Act(FMLA) and employee performance review programs

• Planned, analyzed, designed, implemented, and maintained Access databases to track FMLA and performance reviews

• Interpreted, communicated, and ensured employees and managements compliance with the law, company policies, and company procedures regarding benefits especially FMLA and performance reviews

• Delivered policies and procedures portion of new hire orientation

• Executed enrollments, changes, and terminations to the Cafeteria, Child Care Subsidy, 401(k), and ESPP plans

• Assisted with Cafeteria, Child Care Subsidy, 401(k), and ESPP plan audits

• Helped with service awards program and benefits fair

• Utilized Access and PDS’ proprietary reporting tool to create, run, print, and distribute reports

MEDICAL RECORDS Las Vegas, NV

Records Clerk 09/1994 – 04/1995

• Posted job announcements; alphabetized, sorted, filed, retrieved, copied, faxed, and mailed documents

• Operated a 7 line switchboard with 16 trunk lines and routed calls to appropriate staff

Contact this candidate