PROFESSIONAL SUMMARY:

• Software professional with 15 years of experience utilizing SQL, Oracle 8i - 10g, PL/SQL.
• Experienced in Data Migrations, 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 SKILLS:

Technical: Oracle 8i -11g, MS SQL Server, SQL, PL/SQL, T-SQL, MS Query Analyzer, Oracle DBA Studio, SQL Enterprise Manager, Crystal Reports XI, Oracle Enterpris Manager, PL/SQL Developer,SQL Reporting Services (SSRS), Visual Basic, .NET, SQL+., Performance Tuning

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 -San Diego, CA

Database Administrator/ Database Developer

Responsibilities:

• Maintained SQL Server Databases both in house and on client sites.
• Resolved issues with client databases.
• Revised maintenance scripts for various versions of SQL Server
• Created SQL Stored Procedures to migrate data into the current live system.
• Maintained various other databases: Oracle My SQL
• Created Jobs to be run by the SQL Server agent for maintenance.
• Setup Backup & Recovery (tested backups)
• PL/SQL development
• Performed Performance tuning on new queries to run by application
• Tested and setup Replication and Mirroring (on some client server)
• Performance tuned Imageware’s Application passed sql commands to make the system more efficient when retrieving data from the database.
• Setup oracle 12c environment

Confidential - Walnut Creek, CA

Programmer Analyst

Responsibilities:

• 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
• Performed Performance tuning on new queries to run by application
• Pl/SQL development

Confidential - Sacramento, CA

Programmer Analyst

Responsibilities:

• This was a data migration 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 (BI reports).
• PL?SQL Devlopment

Confidential - San Francisco,CA

Crystal Reports Developer/ Database Developer

Responsibilities:

• Port of San Francisco 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 (BI Reports) SSIS
• PL/SQL Devlopment

Confidential - Loomis, CA

Technical Consultant/Database Developer

Responsibilities:

• 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. Usually utilizing PL/SQL. Performance Tuning.
• 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 off-site gathering business requirements, performing project analysis and project configuration documentation
• Skills Used: Oracle, SQL Server 2012, PL/SQL, Transact SQL, Visual Basic .NET Oracle SSIS
• Performance tuned co-workers scripts to make the conversions and interfaces faster and more efficient

Confidential - Sacramento,CA

System Integrator-Lead

Responsibilities:

• Supported Data Migrations 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)(BI Reports)
• 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 off-site 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 SSIS SSRS and MS Access SSIS

Confidential

Database Developer

Responsibilities:

• 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

Responsibilities:

• 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 off-site 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 SSRS SSIS