Sql Server Data
Resume:
Esther Helena Jackson
Richmond, VA 23231
***************@*****.***
Self-motivated and detail-focused Information Systems Professional; seek a
challenging position as a report developer for EPIC systems using Business
Objects. Experienced in troubleshooting, designing, developing, testing
and customer interface. Over 20 plus years of experience in various areas
of Systems and Business Analysis and Software Development on the Legacy
platform; 1 year working experience in Epic; 3 years of working experience
in SQL Server database development and over 12 years in Healthcare
industry. Strengths include strong communication (verbal and written),
time management skills, fast learner, comfortable taking initiative and
staying focused in stressful situations.
EPIC Certifications:
. EPIC Reporting Workbench Report Writing And Administration - Spring 2008
. EPIC SQL Structures And Reporting - Summer 2009
. Clarity Data Model - Willow Inpatient - Summer 2009
Software Skills
Clarity Epic Reporting Workbench; Epic KB_SQL; SQL Server 2000/2005; BI
Analysis Tools; Crystal Reports 2008; SharePoint; Microsoft Office 2007
Products; Micro Focus Cobol; Teradata; TSO/ISPF; JCL; SQL; COBOL; CICS;
FILE-AID; Xpediter; DB2; QMF; CA-7; ENDEVOR; SyncSort; DTS Compare; DTS
Prompt ; SAP (training)
Professional Experience
2007-Present University of Virginia Health System Charlottesville, VA
Application Programmer Analyst
Working in the Data Warehouse, Decision Support Team for UVA Health System.
Develop reports in EPIC Clarity using Crystal Report for the HIM and Willow
modules.
Strong experience with ETL tools, including SQL Server Integration Services
(SSIS), Data Transformation Services (DTS) and ETL package design.
Developed a strong relationship with clients. Understand business requirements
in order to facilitate client's needs.
Developed detail program specifications; then reviewed with users and
technical analysts to ensure application or system changes requirements are
met.
Strong knowledge of SQL including queries, views and stored procedure.
Working with the Data Architect to develop metadata definitions and structures
within the Data Warehousing.
Provide on-call production support for the SQL Server 2000 and 2005 databases
Modified DTS packages and created tables to process for SQL Server 2000.
Created a proposal on a cost effective solution to migrate the production DTS
jobs/tables from SS 2000 to SS 2005.
Provide status report on projects, problems and any departmental issues.
Use SharePoint to coordinate projects, schedules and store documents.
1999-2006 WellPoint/Anthem BCBS Richmond, VA
Sr. Programmer Analyst
Recruited as a permanent employee after contract expired with Renaissance.
For 6 years supported the COBOL/DB2 legacy platform, which included but not
limited to; production support, development, analyzing data, testing and user
support.
Created the unit and integration testing documents as well as maintained test
results.
Worked closely with business analysts to clarify user requirements.
Analyzed system components such as data flow and define the systems
structures.
Worked on the Forklift project that moved the claims/enrollment legacy data
warehouse to a Server platform.
Worked closely with customers to ensure all drug, enrollment and claim changes
are implemented successfully.
Converted the enrollment programs coded in Micro Focus Cobol to SQL server
scripts, making them more efficient. Reducing the monthly production run time
from 3 days to 4 hours.
Using TERADATA SQL, made retro active market segment changes to the drug and
Enrollment & Activity Databases.
Developed programs to specifications; created test plans and provided
supporting documentation as required.
Provided 24 hours on-call technical support of monthly batch jobs.
Analyzed and performed database SQL tuning of existing applications, by
creating Tables, Triggers, Functions, Procedures, Indexes, etc.
Determined methods to automate data gathering from the legacy systems and
moving that data into the TERADATA platform.
Regularly communicated issues and project status with manager.
Team oriented with good interpersonal skills and the ability to collaborate
effectively with coworkers.
Worked closely with new team members, mentoring them on the technical and
business process of enrollment.
1998-1999 Renaissance Richmond, VA
Consultant (Anthem)
Converted programs, test and document for Y2K specifications.
Provided on call support for the Mainframe CURS enrollment system.
Developed and maintained mainframe programs using COBOLII and DB2.
Generated custom reports in COBOL and retrieved data using SQL.
1996-1998 Computer Sciences Corporation Richmond, VA
Programmer II
Developed, tested, implemented and supported COBOL/DB2/CICS programs that
accessed large tables for an inventory system. Provided 24 on-call technical
support.
Created and ran queries using the QMF utility.
Trained in SAP.
1990-1996 SYSCON Corporation Dahlgren, VA
Tester II
Provided testing for the AEGIS navigation system.
Analyzed the weekly reports; created test scenario, used during site testing.
1988-1990 General Medical Corporation Richmond, VA
Computer Operator
Insured that daily, weekly and monthly batch jobs ran successfully.
Education
1983-1988 VA Union University
Richmond, VA
. B.S. - Mathematics
. Minor - Computer Science
.
Contact this candidate