Sql Server Project

Charlton Frisco Cranford

*** ******** **. ~ Forney, Texas 75126 ~ 214-***-****

acqscy@r.postjobfree.com

SKILLS SUMMARY

Oracle and SQL Server Database Administration. SAP Crystal Reports and Microsoft SQL Server Management Studio (SSMS) database reporting. Informatica and IBM Unica campaign management administration. The installation, maintaining, and repairing of computer hardware and software. The administration of ServiceNow and HEAT ticketing tracking systems. Supporting customers through emails and phone calls. The ability to handle multiple projects at one time. Root cause analysis and the ability to proactively resolve issues before they become problems. Strong analytical, written and verbal skills. Extensive report writing, case plans and evaluations.

EXPERIENCE:

Business Intelligence Developer Jan. 2014-Present

Baylor Scott & White Health Irving, TX

The manipulation of Oracle and SQL Server databases. The development, maintenance

and support of new and existing SAP Crystal Reports, SSMS and Microsoft Visual

Studio 2010 BI reports required to assist with the business objectives and initiatives. The

use of Stored Procedures, Triggers, Functions, Nested Queries, Sub-queries, Joins,

Unions and Relational database modeling to complete all requested tasks and maintain

departmental database information. The completion of Information Services Managers

data requests. Working with the Health Informatics team on SSMS reporting dashboard

solutions. Research, review, and analyze the effectiveness and efficiency of existing

reports and develop strategies for enhancing and improving the performance of these

reports.

Information Analyst: Aug. 2010-Jan. 2014

Targetbase, Inc. Irving, TX

Cleansing, manipulating, and standardizing data for database updates, utilizing Oracle SQL Developer, Dell Toad for Oracle and IBM Database Interface to develop custom solutions. Perform campaign management activities with IBM Unica to support client’s marketing initiatives. Design workflows with Informatica for each project and document all project phases. Interpret and execute project specifications. Apply business logic and ask appropriate questions if clarity is not apparent. Document and ensure smooth hand-off/project transition to other team members and provides back-up support as needed.

Perform QA activities to verify results from assigned projects and deliverables from other team members. Working with Project managers to complete Ad Hoc reports for requested data.

Level 2 Computer Technician: June 2008-Aug.2010

Securus Technologies, Inc. Carrollton, TX

Perform diagnostics of computer related problems directly with internal and external customers over the telephone and e-mail. Microsoft SQL Server database administration. The replacement of hardware not functioning properly. The configuration of boot drives. The installation, updating, and troubleshooting of software applications. Troubleshoot and develop technical solutions for customer problems related to computer software, hardware and telephony issues. Accurately generate and document tickets within the HEAT ticketing system and provide customers with periodic status, updates and feedback.

Juvenile Detention/Probation Officer: June 2004-April 2008

Dallas County, Henry Wade Dallas, TX

Investigates the circumstances of youths petitioned to appear before the Juvenile Court, assesses probable cause, evaluates cases, prepare pre-disposition reports and make recommendations to the court to assist in determining appropriate case disposition. Formulates and implements case plans and safety plans for intervention and supervision and provide direct supervision of the juvenile during the probation period. Maintains frequent contact with juveniles in their home, school and employer to enhance positive adjustment and deter further delinquent behavior.

EDUCATION

Computer Science, B.S., Summer 2000

Wiley College, Marshall, Texas

REFERENCES

Available upon request.

Contact this candidate