SUMMARY:

• Seeking a position programming web base applications or database development.
• Completed an Associate degree in Computer Science and welcome the opportunity to learn and advance knowledge in other areas of programming with database development, design and administration and/or web application development.

TECHNICAL SKILLS:

Languages: Visual Basic.Net, ColdFusion, C#, C++, C, Java Script, VB Script, COBOL, Visual Studio 2005 - 201 2, VSCommunity, T-SQL, PL/SQL, UNIX Shell Script

Databases: MS SQL Server 2000-201 2, Oracle (8I, 9I, 10g), MS Access, Dbase

SQL Tools: Query Analyzer, Enterprise Manager, Data Transformation Services, SQL*Plus, Toad for Oracle

Hardware: IBM PCs and compatible, VAX mainframe, UNIX HP 4000

Op. Systems: UNIX, Windows (8) 2012 - Windows 2000 - 3.1, MS-DOS, Windows NT 4.0, Novell Netware

Reporting Apps: MS SQL Reporting Services 2003-201 2, MS SQL Analysis Services, Cognos Impromptu Administrator 7.0, Crystal Reports XI with Business Objects and Crystal Reports Server

EMail Clients: MSExchange, MS Outlook, OpenMail Client, Lotus Notes 4.6

Software: MSOffice (Word, Excel, Access, PowerPoint, SchedulePlus, MSOutlook), WordPerfect, Lotus 123, Quattro Pro, MSWorks, WordPerfect Office, MSProject, Harvard Graphics, PaperPort, Chartist, Internet Explorer, Netscape Navigator, Acrobat Adobe Pro 6.0, PCAnywhere

Web Applications: Visual Studio 2003-201 2, ColdFusion MX, Server Side ColdFusion MX Administrator, DreamWeaver MX, IIS Web Server, WS FTP, Apache Tomcat 2.0 Web Server

Telephony Apps: Genesys IVR Application Studio, Genesys IVR Call Routing Application

PROFESSIONAL EXPERIENCE:

Confidential

Senior Programmer Analyst, Team Lead

Responsibilities:

• Maintain, analyze, modify and write new code in applications written in VB6.
• Maintain version control of application developments in Visual Source Safe.
• Maintain, analyze & write PLSQL stored procedures, views, triggers, functions in Oracle 9i database.
• Develop reports using Crystal Reports 7 and 10.
• Configure, deploy and maintain MS SQL Server 2008 R2 for Ryan White Careware Database.
• Perform Back-up and Restore of databases in both Oracle 9i and SQL Server 2008R2.
• Monitor and maintain MS SQL Server Performance and Tuning.
• Write code to integrate XML application with an existing VB6 WIC Clinical application.
• Write Oracle XML store procedures to integrate into VB6 application to support Growth Chart application.
• Modify web method to consume services from a Gateway Service Center for Voucher Control.

Confidential

Reports Developer

Responsibilities:

• Develop SQL stored procedures in DB2 AS400.
• Develop Reports in Access 2010 to PDF format to ASP Report Center Application.
• Classic ASP, .NET, HTML, JavaScript, CSS, VB Script, ADO.Net Web Programming.
• Maintain version control of application developments in Visual Source Safe.

Confidential

Database Engineer

Responsibilities:

• Configure, deploy and maintain MS SQL Server 2000/2005/2008/2008 R2/2012.
• Develop and maintain Maintenance & Optimization Plans.
• Develop and maintain SSIS packages for data output and imports.
• Develop TSQL Programming scripts.
• Develop Reports using SSRS.
• Perform Back-up and Restore of databases.
• Monitor and maintain MS SQL Server Performance and Tuning.
• Monitor scheduled nightly processes.
• Maintain updates and upgrades for Great Plains Dynamics Application.
• Maintain updates for Cogsdale Addin for Great Plains Dynamics.

Confidential

Senior Programmer Analyst

Responsibilities:

• Maintain, analyze, modify and write new code in applications written in VB6.
• Maintain version control of application developments in Visual Source Safe.
• Maintain, analyze & write PLSQL stored procedures, views, triggers, functions in Oracle 9i database.
• Develop reports using Crystal Reports 2008.

Confidential

Database Systems Analyst Lead

Responsibilities:

• Supervisor to IT Team. Mentor, train and evaluate employees.
• Write, communicate and assess business requirements.
• Developed and maintained several Access databases using an ODBC link to the main CMS Oracle database using ADO, DAO in VBA for Applications.
• Analyze and identify data and metadata for data mining in Oracle database using Toad.
• Document database designs, relationships and objects.
• Create User Documentation Manual for each Application and train staff members on functional use of customize MS Access Applications.
• Create ETL scripts in Oracle PL/SQL for various report outputs (CSV, Excel, MS Access).

Confidential

Database Systems Analyst

Responsibilities:

• Developed and maintained several Access databases using an ODBC link to the main CMS Oracle database using ADO, DAO in VBA for Applications.
• Analyze and identify data and metadata for data mining in Oracle database using Toad.
• Use Life Cycle Development Process for each application created.
• Document database designs, relationships and objects.
• Develop requirements document for each project.
• Create User Documentation Manual for each Application and train staff members on functional use of customize MS Access Applications.
• Develop Ad-hoc, Forecast, Matrix, and Trend Analysis reports.
• Create ETL scripts in Oracle PL/SQL for various report outputs (CSV, Excel, MS Access).

Confidential

Applications Programmer Analyst

Responsibilities:

• Develop new applications in VB.NET and C#.Net.
• Maintain applications written in VB6.
• Maintain version control of application developments in Visual Source Safe.
• Maintain applications written in MS Access Databases with VBA for Applications.
• Develop reports using Crystal Reports and SSRS 2005.
• Maintain, analyze & write T-SQL stored procedures, views, triggers, functions and DTS packages in MS SQL2000 databases & MS SQL2005 databases.
• Monitor ETL process in SQL Server 2005 Integration Services (SSIS)
• Create process deployment scripts in T-SQL and create written process procedures from test environment to production environment for change control.
• Develop and Maintain MSWord Smart Docs.
• Fulfill ticket request assigned via Track-It Web ticketing system

Confidential

Crystal Reports Applications Support

Responsibilities:

• Develop reports using Crystal Reports XI R2 and SSRS 2005.
• Write and run scripts in Oracle 9I using Toad and MSSQL Server 2005 to maintain Manatron Web Application.
• Convert custom PL/SQL scripts to T-SQL scripts for SQL2005 environment.
• Maintain applications written in VB6 and MS Access Databases with ADO and DAO for Applications.
• Manage change request from Test to Production environment in Oracle and MS SQL2005 databases.
• Manage IIS server updates to web applications. Configure several web application pools for memory management.
• Configure Registry files for application multi-environment database change overs.

Confidential

Senior Technical Support Analyst

Responsibilities:

• Maintain AdvantEDGE CRM package built by Portrait formerly AIT for support of call center.
• Create and enhance monthly, daily reports and ad hoc analysis using Crystal Reports for Accounting and Customer Service Call Center. Maintain reporting procedures.
• Using Oracle PL/SQL, SQL*Plus and Toad to analyze and debug stored procedures for optimal efficiency. Create new stored procedures, functions, triggers and views to ensure business rules are processed in Oracle database on UNIX operating system.
• Document database designs, relationships and objects.
• Analyze and identify data and metadata for data mining.
• Establish project plans and project management guidelines for all major projects.
• Plan and conduct structured monitoring of production databases and applications to ensure environment is stable and capable of meeting ongoing business needs.
• Monitor ETL process in SQL Server 2000 Data Transformation Services (DTS).
• Backup support for UNIX System Administrator writing shell scripts and monitoring systems.
• Backup support for Telephony Administrator writing applications in Genesys IVR Application Studio then post back to the Apache Tomcat Web Server. Backup Admin support for IVR Call Routing Application. Maintain Lucent ACD systems and predictive dialing technologies. Operate NICE recording devices.
• Installed Crystal Reports XI.5 Enterprise and Business Objects Crystal Report Server.
• Converted Crystal Reports from Crystal Reports 8 to Crystal Reports XI
• Developed Website / Web Application for Crystal Reports XI.5 using Business Objects and Crystal Report Sever using Visual Studio 2005 Professional as a Visual Basic.Net Web Application.

Confidential

Application Reports Developer

Responsibilities:

• Develop and maintain reports using Microsoft SQL Reporting Services for various application modules for several departments. Including Accounting, CRM reports for Member Services, Customer Service, Marketing, Education, Event Scheduling, Statistical, charting and Ad-Hoc report building.
• Creation and enhancement of monthly, daily reporting and ad hoc analysis using SQL Reporting Services.
• Use Microsoft VB.Net & C# to modify and enhance interfaces to the NetForum application built by Avectra.
• Develop stored procedures, functions, triggers and views to ensure business rules are processed in SQL database.
• Monitor ETL process in SQL Server 2000 Data Transformation Services (DTS).
• Using MS SQL Server database, analyze and debug stored procedures for optimal efficiency.
• Document database designs, relationships and objects.
• Analyze and identify data and metadata for data mining.

Confidential

Help Desk Report Writer Specialist

Responsibilities:

• Provide help desk support for desktop applications and Access databases.
• Developed several Access databases using an ODBC link to the main Oracle order entry database (TIMSS) using ADO, DAO.
• Interface with users to define functional specifications for database development and reports.
• Provide data model and prototyping of database design with user specifications.
• Developed Access database using an ODBC link to Great Plains MSSQL tables to generate Accounting Disbursement Forms with extensive use of VBA code.
• Developed several reports using Cognos Impromptu Administrator 7.0. Set up table links from Oracle with an existing catalog as needed for reports. Extensive use of Impromptu Scheduler for monthly report processes.
• Write batch programs to automate processes for reports. Conversion of reports from Impromptu to PDF to PDF executables to transfer to FTP.
• Maintain web application to provide access to 160+ chapter reports via ftp from webpage application.
• Provide staff training classes in MS Office Applications
• Provide backup support for Oracle Database Administrator in maintaining TIMSS.
• Provide backup support for Internet Application Specialist.
• Write code in ColdFusion and troubleshoot errors as it relates to web applications with database support.
• Provide backup support for Network Administrator in backing up SQL Server 2000, Windows 2000 Professional Server, Microsoft Exchange Server, IIS Web Server and ColdFusion MX Server.
• Create Outlook form for Help Desk to allow staff to ask for help with eases of use and allow for MIS staff to track issues and solutions.
• Developed Access database to collect Help Desk inbox messages to create reports to show progress of issues resolved in an effective and timely manner as well as with the associate member the issue was assigned to. Used CDO and ADO code to interact with the Microsoft Exchange Server.
• Work with Database Administrator and Database Developer in the conversion process of converting data from Oracle database system using Oracle PL/SQL, SQL*Plus to MS SQL database system using SQL Enterprise Manager.
• Received training in Web Application Development and Administration in Microsoft VB.Net & C# to modify and enhance the NetForum application built by Avectra using Microsoft .Net Technology.

Confidential

Help Desk Support

Responsibilities:

• Provide help desk support for desktop applications and Access Databases.
• Developed several Access Databases using an ODBC link to the main Oracle order entry database.