Sql Server Full Time

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

Auburn, GA *****

787-***-**** email: *******@*****.***

Delvis L Vargas

SUMMARY

Senior SQL Developer/Analyst and Software/Web Developer with significant experience in healthcare/enrollment. Expertise in research, analysis of software alternatives, design, database creation and maintenance. Strengths include proven problem solving skills and an ability to work well both in a team environment and independently.

Industries: Pharmaceutical, Communications, Telemarketing, Wholesale, Small business, Intranet/Web system, Life Insurance, government agencies, and Health Insurance. Functional

Areas:

I have been involved in all phases of the software development process, from proposal writing to implementation. Systems Analysis and Design, Technical Writing, Problem-Solving, Coaching/Mentoring, Team Building. Strong familiarity with computer system validation methodology, SAP R/3 Procedures Coordination, System Security and Data Integrity. Methodologies: System Development Life Cycle, Client Server Development, Object Oriented Programming, Computer System Validation (CSV), Productivity Management, Multi-Tier Development, Software Testing.

EDUCATION

DEGREES

Bachelor of Science Computer Science

Universidad Adventista de las

Antillas (Antillean Adventist

University)

Mayagüez, Puerto Rico

CERTIFICATIONS /

LICENSES

The process of billing and collection to medical plans. Productivity Management Seminar.

UPR, Rio Piedras, Puerto Rico.

Keane, Inc.

DocuTools for Policies and Procedures.

Tax Professional.

Performance Technology Associates, Inc.

H&R Block

PROFESSIONAL EXPERIENCE

THE ANTHEM COMPANIES, INC.

HEALTH CARE PROVIDER

Aug 2010 – Present

Business Information Developer – SQL Developer Full Time Job Support Sales Reporting intranet website project. Achieve comprehensive knowledge of IT core functionality in routine support of various Anthem departments.

Experience with database consolidation and integration projects. Created Tidal jobs to schedule data loading.

Responsible for collecting and analyzing business related data for Senior Business Operations.

Over 7 years of IT experience in ETL architecture, analysis, design, development, testing, implementation, maintenance and supporting of Enterprise level data integration.

Over 10 years hands on experience in SQL Server (T-SQL) in writing database objects such as tables, stored procedures, views, triggers, cursors, linked servers, packages and user defined functions.

Over 7 years of Reporting Service (SSRS) reports development supporting sales site. (Requirements gathering & report design).

Perform data analysis and generate reports to provide up to date information and fulfill ad-hoc reporting requests.

Create/ manage SQL Server Agent jobs for data warehouse operations. Identify / troubleshoot database issues. Environment:

Visual Studio (2015-2012 Visual C#), Microsoft SQL Server 2000-2012, MS Office, MS Visio, MS Access; Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Business Object, MS Excel and Flat Files, Tidal Enterprise Scheduler. OPEN KNOWLEDGE Feb 2007 – Jul 2010

DELVIS VARGAS

Page 2 of 3

787-***-**** email: *******@*****.***

SOFTWARE DEVELOPMENT FIRM

Senior Software Developer – SQL Developer Full Time Job Responsible to maintain/develop, test and support department applications, including but not limited to:

Create and Support applications: Prosecutor Case Management System (PCMS), Document Case File Management, and PCMS Express which create Initial Investigation, indictments, Case Submission Authorization, and Charges records and reports (documents). Gather user requirements.

Experience writing complex SQL/T-SQL and stored procedures to support applications and reports.

NCIC Files which process, validate, and transmit data from Puerto Rico Department of Criminal Justice (CJIS) to the National Crime Information Center (NCIC), Puerto Rico Police Department, Court Administration, etc. The system permits participating Federal and National Agencies to exchange information.

Support the data conversion and upload process. This process uploads the legacy data to the new integrated system.

Exposed to SQL Server Database Administrator functions.

Creates new and update existing department application and reports.

Maintain/Support Sex Offender website.

Application testing and troubleshooting. Test application and suggest possible technology solutions

Mentor IT department personnel in technology solutions. Environment: Visual Studio 2005-8/2010 (VB.NET, and Visual C#), Microsoft SQL Server 2005/8 (T-SQL), MS Office, Crystal Reports, ASP.NET, ADO.NET, HTML, MS Visio, MS Access. METRO IT RESOURCES FORMERLY KNOWN AS KEANE, INC.

(INFORMATION TECHNOLOGY CONSULTING FIRM)

Aug 1998 – Jan 2007

AT MAPFRE PUERTO RICO

INSURANCE AND HEALTH COMPANY

Dec 2006 – Jan 2007

Business System Analyst Full Time Job

Gathering System Requirements for the Informativas Project. The Informativas System is new system that will replace the current process (which include a lot of manual intervention from the IT Department) for the generation of tax informative Forms (480.6A, 480.6B, 480.7, and 1099) and the corresponding electronic files required by the Department of Treasury. The system permits the users to manipulate the data and generate reports. AT LILY DEL CARIBE

PHARMACEUTICAL INDUSTRY

Jan 2003 – Sep 2006

It Consultant / Computer System Validation Coordinator Analyst Full Time Job Validation Coordinator activities as the creation/revision of validation deliverables at Lilly Del Caribe (Carolina).

Provide validation expertise for information systems to ensure compliance with company policies and procedures, in alignment with applicable regulations.

Research and interpret client- and vendor-supplied documentation in order to write/approve documents.

Develop, execute and/or review/ approve validation packages (validation plans, test plans, validation protocols, procedures, test summary report, among other deliverables).

Ensure development and execution of SDLC documents including, Plans, Requirements, Design, IQ, OQ, PQ, Summary Reports, Systems Periodic Review Report, Self-Inspection, Quality Assurance Review, Disaster Recovery Plan (DRP), Business Continuity Plan (BCP), System Security Plan, System Security Administration, Backup and Restoration, Standard Operating Procedures (SOPs), among other deliverable.

Provide and coordinate validation support to business operations through execution and documentation of CSV activities.

Follow up IT Quality Plan.

Provide support in the coordination of SAP Procedures (SOP) Environment:

MS Office, MS Internet Explorer, MS Project, MS Visio. AT LILY DEL CARIBE May 2001 – Dec 2002

DELVIS VARGAS

Page 3 of 3

787-***-**** email: *******@*****.***

PHARMACEUTICAL INDUSTRY

It Consultant Analyst Full Time Job

Microsoft Windows Migration Project. The purpose of this project is the migration of the business PCs and servers, supported by IT Department, from previous version of the operating system to newer ones. Responsible for systems testing to ensure all computer systems are in compliance with the new version of the operating system.

Provide leadership: Responsible for directing team members in execution of protocols, system test functions and deployment. Assure the quality.

Development of Test Package Cases/Scripts.

Create Test Data.

Execute the Test Scripts.

Logs Test Incidents.

Interacts with deployment team as needed regarding testing.

Manages testing incidents.

Create and/or approve applications installation instructions.

Prepare test report documentations.

Environment: MS Office, MS Project, MS Visio, MS Internet Explorer, SQLBase (Gupta), Symantec Ghost, Reflection, Lotus Notes, Remedy, ISOTrain, Norton Utilities, Symantec Ghost among others. AT PUERTO RICO TELEPHONE COMPANY (VERIZON)

TELECOMMUNICATION

05/98 - 02/01

Senior System Analyst Full Time Job

Involved in various projects in client server environment. Design and implementation of miscellaneous billing system, electronic billing system, contract manager system, project manager system, etc. Heavily involved in Y2K conversion project.

Gather user requirements.

System analysis.

System and database design.

Coding, testing, documenting, data migration.

Maintenance and support.

Environment: Clippers, Data flex, Visual Basic, Centura (Gupta), Oracle, Erwin, Crystal Report, MS Access, SQL Server, Dbase, Fox Pro.

Additional Professional Experience

MAJOR SOFTWARE SYSTEM, NEW YORK

CONSULTING SERVICES

Programmer / Analyst

For a communications company as consultant responsible for design, modify and implementing a large-scale system. The program interacts with a PBX phone system, read the data from it and process it to make customer billing. Environment: Clipper, Dbase.

PERFECT CUT CARPET, NEW YORK

SMALL BUSINESS

Programmer / Analyst

Responsible to design and develop a software package including a POS, payroll, accounts receivable, accounts payable for internal use of a carpet firm. Create purchase order. Update inventory products. Among other things. Environment: Clipper, Dbase.

Contact this candidate