Principle Customer Support Analyst Database Programmer Resume
New, YorK
SUMMARY:
- Senior Database Developer / Analyst with 20+ years of experience working with users in developing application screens, procedures, triggers and reports using SQL and Oracle technologies.
- Extensive experience with SQL, PL/SQL stored procedures scripts and trigger programming in Oracle Server and SQL server environments.
- Oracle Forms and Reports programming.
- Strong organizational, problem - solving and analytical skills. Detail oriented.
- Work well in a team as well as an individual contributor.
- Strong communication skills. Effectively able to communicate with all levels of users (technical and non-technical).
- Able to support users with their data-entry, database and product questions.
TECHNICAL SKILLS:
Technology and Tools: Confidential database software 3 years JavaScript 1 year Oracle SQL, PL/SQL (Oracle vers. 7 thru 11g), - 14 Years Oracle Forms and Reports (vers. 6i thru 10g) - 11 years Pledgemaker donor database software - 11 years SQL Server SQL, Transact SQL - 10 years DataEase database software - 10 years Microsoft Office Word, Excel, Outlook, Access
PROFESSIONAL EXPERIENCE:
Confidential (New York)
Principle Customer Support Analyst Database Programmer
Responsibilities:
- Worked with customers supporting and resolving issues with Confidential ’s products including:
- Corrected defects in JavaScripts used in product customizations.
- Adjusted configuration settings to better accommodate customer needs.
- Developed/Tested Oracle PL/SQL scripts to find and correct data errors in back-end Confidential database tables.
- Analyzed user issues with Confidential ’s CRM (Publicstuff) mobile app.
- Performed support ticket management for assigned VIP customers by meeting with them weekly to review ticket status and priority and by escalating, as needed, tickets needing extra attention.
Confidential ( Jericho, NY)
Business Analyst/Developer
Responsibilities:
- Developed/Tested PL/SQL scripts in an Oracle 10g environment for use in reporting and data uploads.
- Worked with vendors/users to resolve system issues.
- Troubleshooted issues with data feeds/exports and submitted to development team for fixes and enhancements.
Confidential, ( New York, NY)
Programmer/Analyst
Responsibilities:
- Created PL/SQL scripts in an Oracle 11g SQL Developer environment to extract and transform data to be compatible with Confidential software upload tools.
- Analyzed, designed and documented conversion requirements.
Confidential ( NY, NY)
Conversion Programmer
Responsibilities:
- Created PL/SQL scripts, functions and stored procedures in an Oracle 11g SQL Developer environment to extract and transform data to be compatible with Confidential software upload tools.
- Imported data translation tables from Excel to Oracle 11g tables
- Performed and used Oracle performance tuning tips and tricks.
- Performed post-production back-end data updates to Confidential base tables.
Confidential ( New York, NY)
Database Developer / Forms & Reports Developer / Systems Analyst Developer
Responsibilities:
- Evaluated alternatives and developed recommendations for technology/process solutions to meet business requirements.
- Gathered, analyzed and documented user specifications to determine their system and reporting needs in a systems/business analyst role.
- Created data entry validation protocols using database triggers and manipulated data and performed bulk updates to data using PL/SQL and SQLPlus scripts in the Oracle 9i/10g database.
- Maintained Oracle 9i/10g back-end/Pledgemaker (third-party Oracle forms) front-end database including validating, testing, and correcting custom work during Pledgemaker upgrades.
- Designed, coded and implemented system enhancements, database schema design, stored procedures, functions, views, triggers and reports using SQLPlus, Oracle SQL, PL/SQL and Oracle Forms and Reports.
- Projects included:
- Uploaded and converted data between systems (imports and exports) using Oracle 9i/10g SQL Loader and PL/SQL scripts and stored procedures.
- Converted and uploaded data from a RTL scanner database to an Oracle 10g database using PL/SQL scripts and stored procedures in a SQLPlus environment.
- As part of the implementation of a scanner project used by the Data-Entry department, I created the PL/SQL scripts and stored procedures needed to translate and upload the data from the scanner system’s export file to the various tables of our Oracle donor management database. As part of the process, data validations were performed to maintain data integrity within the Oracle database and some fields were calculated, derived or defaulted based on the existing data in the export and/or the donor’s record.
- Designed, coded, integrated and implemented Oracle 10g forms modules including the creation of the back-end tables, indexes, sequences and triggers to enhance a third-party Pledgemaker user interface (Oracle 10g back-end).
Confidential
Programmer/Analyst
Responsibilities:
- Gathered, analyzed and documented user specifications to determine their system and reporting needs in a systems/business analyst role.
- Created data entry validation protocols using database triggers and bulk updated data using Transact-SQL in the SQL Sever database and PL/SQL and SQLPlus scripts in the Oracle 7i/8i database.
- Designed, coded and implemented system enhancements, database schema design, stored procedures, functions, views, triggers and reports using SQLPlus, Oracle SQL, Transact-SQL, PL/SQL and Oracle Forms and Reports.
- Involved in the conversion from a SQL server database to an Oracle database (data mapping, testing). Created export files from the SQL Server/DataEase database. Verified data integrity of the conversion to the Oracle back-end/Pledgemaker front-end database.
- Maintained a SQL Server back-end/DataEase front-end database.
- Programmed database triggers to maintain database integrity and automate data-entry in related tables.
- Manipulated data and performed bulk updates using SQL Server stored procedures and Transact-SQL scripts.
- Designed and coded DataEase (a DOS-based user interface tool) forms, reports, and menus.
