SUMMARY

• Senior software professional with 13 years of experience as with utilizing Oracle 8i 10g, SQL, PL/SQL
• Experienced in Data Conversions, Interface Development, Application Support and Report Development
• Proficient in development of queries, procedures, triggers, functions and reports in both Oracle and SQL Server environment
• Worked on multiple projects that involved converting client data from various sources text files, Dbase, MS Access, SQL Server and Oracle utilizing ODBC, MS Access, T-SQL, PL/SQL, and Visual Basic.NET
• Experienced in developing reports in Crystal Reports and SQL Reporting SSRS
• Valued experience at providing support, advice, and scripts for Oracle, SQL Server and MS Access databases
• Oracle Certified Professional Database Administrator 8, 8i 9i OCP-DBA , Oracle Certified Associate 9i PL/SQL Developer, and Microsoft Certified Professional SQL Server Administration 2000 MCP
• Detail oriented team player with excellent organization and problem solving skills

SKILL SETS

EMPLOYER EXPERIENCE SUMMARY

PROFESSIONAL DEVELOPMENT / CERTIFICATIONS / COURSES

PROJECT DETAILS

Position: Programmer Analyst

This was a short term contract that involved the development of Oracle stored procedures to augment the short comings of their current pension and union management for benefits, pensions and reporting.

Responsibilities:

• Development of Oracle Procedures to enhance functionality of current applications
• Modify Oracle stored procedures and functions to allow them to work in Oracle 11G
• Review stored procedures for compatibility and assist the employees in the IT department with issues or questions

Skills Used: Oracle Stored Procedures, Oracle 11g

This was a data conversion project going from SQL Server to Oracle and also involved client specified report generation.

Responsibilities:

• Development of Oracle Stored Procedures to assist in database system conversion
• Development of 70 Crystal Reports as per client need

Skills Used: Oracle Stored Procedures, SQL Server, Crystal Reports, Oracle

Responsibilities:

• Development of Crystal Reports per client requirements.

Skills Used: Crystal Reports, SSRS

Position: Technical Consultant

This project was for the business analysis of clients' processes, Accela Automation software configuration and data conversion. My role was interfacing with clients' project and IT staff to plan appropriate Accela software configuration, data mapping, and reporting services. All work performed for City and County Governments.

Responsibilities:

• Provided support, advice and scripts for Oracle and SQL Server
• Created procedures, triggers, functions and interfaces necessary for the conversion or project using PL/SQL, Transact SQL or Visual Basic .NET
• Developed Crystal/SQL Reports using gathered specifications from client
• Worked with clients both on and offsite gathering business requirements, performing project analysis and project configuration documentation

Skills Used: Oracle, SQL Server, PL/SQL, Transact SQL, Visual Basic .NET Oracle

Supported Data Conversions from various platforms and software packages for Government Entities.

This project involved converting client data from various sources text files, Dbase, MS Access, SQL Server and Oracle utilizing ODBC, MS Access, T-SQL, PL/SQL, and Visual Basic.NET. My role included interfacing with project managers and clients to plan appropriate data mapping, conversion format, and implementation plan.

Responsibilities:

• Provided support, advice, and scripts for Oracle, SQL Server and MS Access databases
• Developed Interfaces between software packages.
• Developed Crystal Reports SQL Reporting Services SSRS
• Created procedures, triggers, functions, and interfaces necessary for the conversion using PL/SQL, Transact SQL or Visual Basic .NET
• Worked with clients both on and offsite to gather business requirements, perform project analysis, and created design documentation
• Created and modified interfaces between Hansen and other vendors

Skills Used: ODBC, MS Access, T-SQL, PL/SQL, Visual Basic.NET, Oracle SQL Server and MS Access

Position: Database Developer

This project involved creating and modifying Transact SQL stored procedures and functions for the Property Tax Billing software used by 20 California counties. I handled the conversion of data from various sources using PL/SQL, Transact SQL, and VB.NET.

Responsibilities:

• Created custom Crystal Reports
• Assisted in data Conversions from various platforms including both Oracle and SQL Server databases
• Developed interfaces between software packages.
• Stored procedures created using Batch Oriented Methodologies

Skills Used: PL/SQL, Transact SQL, VB.NET, Crystal Reports, SQL Server

Position: Data Conversion Specialist

This project involved converting client data from various sources text files, Dbase, MS Access, SQL Server and Oracle using ODBC, MS Access, T-SQL, PL/SQL, and Visual Basic.NET. My role included working with city governments to provide support in resolving Hansen software functionality issues, ODBC, and various database/data problems.

Responsibilities:

• Provided support, advice, and scripts for Oracle, SQL Server, and MS Access databases
• Created procedures, triggers, functions, and interfaces necessary using PL/SQL, Transact SQL, or Visual Basic .NET
• Worked with clients both on and offsite to gather business requirements, perform project analysis, and create design documentation
• Created and modified interfaces between Hansen and other vendor applications
• Interfaced with project managers and clients to plan appropriate data mapping, conversion format and implementation plan

Skills Used: ODBC, MS Access, T-SQL, PL/SQL, Visual Basic.NET,