Sql Server Crystal Reports

Marcia Hill

**** ******* *****

Paradise, CA ****9

Contact: 530-***-****

Email: ************@*****.***

PROGRAMMING AND SCRIPTING LANGUAGES: TCL, JAVA, JavaScript, SQL, Visual Basic, ASP, HTML, XML, XHTML

DATABASE SYSTEMS: Oracle, MS SQL Server, MS Access, Sybase

REPORTING SOFTWARE: Sisense, Crystal Reports 2013, MS Reporting Services, MS Analysis Services, SQL Server Integration Services

EMPLOYMENT HISTORY:

Software Consultant

Randstad Technologies

June 19, 2017 – present

Job Description and Responsibilities:

1) Automated Case Management Enrollments by transforming user requirements into table driven specifications/parameters.

2) Created SSIS Packages to support the CM automation by combining data from three different systems

3) Updated Business Rules in TCL for automated tasking/case management enrollments

Development Application Consultant

Exl Healthcare

May 1, 2006 to April 26, 2017

Job Description and Responsibilities:

1) Code and test business rules in TCL and/or JAVA for health management software to verify fields, send automated letters and/or automated tasks.

2) Interface experience with data preparation and troubleshooting issues when importing and exporting data.

3) Develop Reports, Letter, and Analytic Dashboards through the use of Crystal Reports 2011/2013 and Sisense.

4) Develop T-SQL for Stored Procedures, Views, and adhoc queries.

5) Worked with clients on reporting/letter specifications and any issues related to existing reports and/or rules.

6) Fluent with Oracle, MS Sql Server, and MS Access Databases.

Programmer Analyst

Delicato Vineyards

March 1, 1999 to February 1 2006

Job Description and Responsibilities:

1) Programming in Visual Basic 6 (updating to .NET) for custom winery application

2) Developed reports in Brio and Crystal Reports.

3) Managed the data warehouse with SQL Server Integration Services (SSIS).

3) Third level of support for Help Desk with issues and/or matters related to the SQL Server database and/or Winery application.

4) Programmed in ASP, HTML, JavaScript, and Multi-Dimensional Expressions for Sales Dashboards and HR custom web based application.

5) Experienced in Microsoft Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).

6) Administrated updates to fix issues in SQL Server and Exchange Server.

7) Programmed Stored Procedures, functions and triggers in SQL Server.

Programmer Analyst

Vanstar Corporation (merged with Inacom)

August 1 1998 to Feb 17 1999

1) Programmed Stored Procedures and Functions in Oracle and Sybase

2) Helped troubleshoot and QA issues in the application

EDUCATION

BS in Business Administration, MIS, Option: Software

California State University, Chico

Contact this candidate