Sql Server Data

AWILDA RIOS

**** ********* **.

Altamonte Springs, FL 32714

Cell : 407-***-****/ E-mail : ***********@*****.***

[pic]

OBJECTIVE:

To secure a position that will effectively utilize my skills and experience

in MIS and programming.

PROFESSIONAL EXPERIENCE:

PRC, Maitland, FL

Project Analyst

February 2005 to May 2010

Accomplishments:

. List merging and purging, and reporting on numerous client

databases.

. Project management, data conversion, data administration,

troubleshooting and reporting.

. Combine data from various data sources as required.

. Collect and analyze data; deliver reports to internal staff.

. Produces reports on Access and Crystal Reports that are

aesthetically pleasing and easily understood.

. Access and SQL Database maintenance and associated tasks.

. Interaction with account managers, project managers and clients.

. Create VBA functions and sub routines.

. Correctly modify existing VBA code and Access queries.

. Produce detailed project documentation.

City National Bank of Florida, Miami, FL

Programmer/Database Analyst:

2000 to July 2004

Lead database programming and administration. Responsible

for the Analysis and Implementation of several

Systems. Major Activities include database design,

maintenance, installation, data mining scripting, SQL

Stored

Procedures, DTS, Crystal Report writing.

Accomplishments:

. Responsible for the implementation of the BSA (Bank Secrecy Act)

system. Performed BSA application analysis, created a temporary

data warehouse to keep track of transactions to comply with the

Patriots Act and BSA, created data dictionary for the Imports,

created database, stored procedures, DTS, Jobs Schedules and

documentation.

. Defined structure of data sources for reporting using the

datawarehouse.

. Active participation in OnBase upgrade, planning and database

migration to the new SQL server.

. Provided the analysis and led the implementation of Goldmine

application. Provided many customs reports and database updates.

. Created the stored procedures and report interface for several

applications.

. Participated in the conversion to the Xtria tickler system and

provided logistical support to the lending and credit departments.

. Online Banking Conversion. Created all reports to analyze and

clean up the data. Created all verification reports and performed

data conversion.

. Convert Access applications to MS-SQL.

. Designed and implemented E-partner/ACH Access database for Online

Banking Department.

. Provided extensive support during RPL conversion providing all

database comparison and creating new report modules for the

application.

. Built data mining scripts to produce financial analysis report

required by executive management to monitor Loan Officers

performance.

. Performed all upgrades system maintenance, application and database

administration for the Payroll application (UltiPro) and Cognos.

Provided SQL databases and support for the conversion of Payroll

system to an inter-sourcing model.

. Designed and implemented SQL database to create monthly reports for

monitoring the loan portfolio conforming to the OCC

recommendations.

. Performed Paragon conversion.

. Developed SQL database to process the ACH Returns.

. Redesigned and convert reports from R&R report writer to Crystal

Report 8.5.

. Create and Modify Visual Basic code.

. Designed several Crystal Reports for the different departments of

the Bank.

Banco Popular of Puerto Rico, San Juan, PR

Information Systems Specialist

April 1998 to March 2000

Accomplishments:

. Developed and implemented access databases and interfaces between

programs.

. Provided maintenance and modifications to access database and

programs.

. Provided specialized training and support in programs to end users.

. Act as a trouble-shooter for a variety of systems and software problems.

. Upgraded and installed existing and new software.

. Created and customized reports utilizing Crystal Reports and IBM AS

400.

Puerto Rico Computer, San Juan, PR

Jr. Programmer

June 1997 to March 1998

Accomplishments:

. Developed and maintained programs utilizing FoxPro and Visual Basic

. Provided support to end users in a variety programs.

. Upgraded and installed programs.

. Delegated to provide training and support to end users in a variety of

programs.

EDUCATION /CERTIFICATIONS

Interamerican University, Cupey P.R

Bachelor of Business Administration, Major: Management Information

Systems, May 1997.

Seagate Software

Crystal Report Intro 7.0, January 1999.

University of Miami (School of Continuing Studies)

Visual Basic I, II and III, September 2000.

Productivity Point International

Crystal Report 8.0 Advance, January 2001.

Total HTML, April 2002.

M20723: Programming a SQL Server 2000 Database, May 2002.

M2072 Administering a Microsoft SQL Server 2000 Database.

IT Skills:

Languages:

. Visual Basic 6.3

. T-SQL

. HTML

. ASP

Databases:

. SQL Server 2000, 2005/2008

. Oracle

. Access 97, 2000, 2002

SUMMARY OF QUALIFICATIONS:

. Knowledge and experience with the following Software: Monarch,

FoxPro, Microsoft Office, Lotus, Peachtree, Quicken, QuickBooks,

Crystal Report 8.5, 9.0, 2008Wausau, R&R Report Writer, Metavante

datawarehouse (Oracle based), UltiPro, GoldMine, OnBase, PayPlus,

MortgageWare, MartketLink

. Experience with the following Operating Systems: Windows 2000, XP,

NT, 98, 95, Vista and DOS.

. Highly motivated; work well independently and as part of a team.

. Excellent interpersonal skills, able to relate well with people

from diverse background and cultures. Strong analytical and problem

solving skills. Motivated self-starter.

. Ability to handle pressure, exhibit sound judgment, and communicate

decisions clearly. Well organized and detail oriented.

. Fluent in Spanish: written and verbal skills.

Contact this candidate