Professional Summary

• Software professional with 13 years of experience utilizing SQL, Oracle 8i 10g, 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 SQL and Oracle Server environments.
• 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 SQL Reporting SSRS and Crystal Reports.
• 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.

Technical

• Oracle 8i -10g, MS SQL Server 2000/2005, SQL, PL/SQL, T-SQL, MS Query Analyzer, Oracle DBA Studio, SQL Enterprise Manager, Crystal Reports XI, Oracle Enterprise Manager, PL/SQL Developer,
• SQL Reporting Services SSRS , Visual Basic, .NET, SQL .

Business

• Applications: Accela Automation, Property Tax Billing, Pension and Union Management System, Government, Data Integration and Conversion, Reporting .
• Phases: All Phases of Software Development Life Cycle SDLC .
• Tools Standards: MS PowerPoint, Adobe Photoshop, Adobe Pagemaker, MS Publisher, MS Frontpage, Visio 2003, MS Office.

Professional Experience

CONFIDENTIAL

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.
• 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

CONFIDENTIAL

Programmer Analyst

• This was a data conversion project going from SQL Server to Oracle and also involved client specified report generation.
• 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.

CONFIDENTIAL

Crystal Reports Developer

• Port of Confidential had migrated their systems to Accela Automation and required report development for this new platform.
• Development of Crystal Reports per client requirements.
• Skills Used: Crystal Reports, SSRS

CONFIDENTIAL

Database Developer

• 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.
• 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

CONFIDENTIAL

System Integrator

• 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.
• 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

CONFIDENTIAL

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.
• 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

CONFIDENTIAL

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.
• 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