EXPERIENCE

Confidential

DBA/Developer

• Create custom database ETL scripts using internal Cerner CCL proprietary client database language, and PL/SQL with various custom client tools and SQL Developer.
• Create custom reports according to various Health Care Facility needs, using Java, Javascript and a customized version of the Eclipse BIRT reporting tool
• Updated VB6 in proprietary health care programs as needed for bug fixes, and upgrade requests.
• Create internal documentation on all projects and update in Tortoise SVN Repo
• Agile SDLC Environment.

Confidential

DBA/Developer

• Create and Modify various SSIS packages for SQL Server 2008.
• Create new packages in line with existing TSQL packages for various Record Type integration in the ARCVAL system.
• Create and Modify various SSRS reports as needed for new ARCVAL system.
• Report to Sr. DBA/Architects on any database discrepancies to coincide with TSQL packages being created.

Confidential

DBA/Developer

• Create and Modify various SQL Server/Access In House Applications.
• Including altering any T-SQL, or SQL queries within C , Java programs as required.
• Prepare detailed Technical Business Documentation for the Business Analysts to Efficiently test the Newly updated In House VBA Apps and Reports.
• Troubleshoot SQL Server Database Issues and Trouble Tickets: Including tasks such as Add/Update User Profiles, Perform Backups, upgrade patches as needed to SQL Server SAP database system. Optimize reports and load queries for increasing efficiency and speed of processing.

Confidential

DBA/Developer

• Create New/Modify Crystal Reports/SSRS running off of SQL Server for SAP database upgrade to Business One
• Alter/Update Excel Spreadsheet VBA Macros to coincide with the SAP database upgrade to Business One.
• Maintain/update check for errors in ETL Processes for database upgrade. Run queries to check for any data discrepancies.
• Create any New Custom Tables/Views that are necessary to implement the in-house or any ad-hoc reports that were requested against SQL Server SAP database.
• Prepare detailed Technical Business Documentation for the Business Analysts to Efficiently test the Newly updated Excel and Crystal Reports.
• Examine SSIS packages to ensure proper data transformations occur to new database from previous Syspro database.
• Alter any T-SQL, triggers, etc. as necessary for SAP upgrade.
• Troubleshoot SQL Server Database Issues and Trouble Tickets: Including tasks such as Add/Update User Profiles, Perform Backups, upgrade patches as needed to SQL Server SAP database system. Optimize reports and load queries for increasing efficiency and speed of processing.

Confidential

DBA/Web Developer

• Create custom websites using PHP, MySQL, Adobe CS4, Java
• Create and maintain Databases for client websites in MySQL, SQL Server, Oracle
• Including altering PL/SQL, T-SQL, triggers, packages, etc.
• Alter existing Java, C .NET programs for clients as per dealing with DB upgrade.
• Create/Modify Reports in Crystal Reports for Clients
• Automate processes with UNIX shell scripting
• Work with Other Software Development Teams to Complete Websites in a Timely, Efficient Manner.

Confidential

DBA/Developer

• Create New/Modify various Forms and Reports for various internal clients in Oracle with Oracle AP, AR, Gl
• Alter Existing Access Macros SQL Code to coincide with the database upgrade that was occurring in a Oracle 9i System.
• Maintain/update mapping for existing ETL Processes in Datastage.
• Gather Detailed Requirements on the AdHoc Needs for new Crystal Reports/Business Objects/Reporting Services 2005 Changes
• Prepare Detailed Technical Business Documentation for the Test Team to Efficiently test the New Macros and Crystal Reports.
• Work with Other Team Members to Update Tables, Create Users, and Manage the SQL Server Database.
• Make any necessary changes needed in the Java code that changed with the upgrade.
• Troubleshoot SQL Server/Oracle Database Issues: Including tasks such as Add/Update User Profiles, Perform Backups, upgrade patches as needed to SQL Server/Oracle database systems. Optimize reports and load queries for increasing efficiency and speed of processing.

Confidential

DBA/Developer

• Create, Test PL/SQL Aggregation Procedures including any Index Rebuilding necessary for the CDR Datamart Aggregation Tables from DB2 using Oracle 10g, Oracle SQL Developer, and TOAD.
• Reverse Engineer Business Rules for Aggregation Procedures from IBM DB2.
• Automate processes with UNIX shell scripting
• Gather Detailed Requirements on Aggregation Procedures for CDR Call Data for Sprint Data Warehouse and turn into Business Rules for PL/SQL procedures
• Prepare Detailed Technical Business Documentation for the Test Team to Efficiently test the Aggregation Procedures.
• Maintain/update mapping for existing ETL Processes in Datastage
• Work with Other Team Members to Update Tables, Create Users, and Manage the SQL Server/Oracle Databases.
• Troubleshoot Oracle/DB2/SQL Server Database Issues: Including tasks such as Add/Update User Profiles, Perform Backups, upgrade patches as needed to various databases. Optimize reports and load queries for increasing efficiency and speed of processing.
• Update Java code to coincide the database changes.

Confidential

ORACLE DBA

• Create New/Modify various Forms and Reports for various internal clients in Oracle 10g with Oracle AP, AR, GL, Purchasing, BOM. Created Oracle Manufacturing Apps as well.
• Update AdHOC SQL reports for Clarity and Performance Enhancement
• Alter VB.NET, C .NET Code to Coincide with Oracle upgrade.
• Create/Alter New or Existing PL/SQL for various Internal Client Needs
• Automate processes with UNIX shell scripting
• Work with Other Team Members to Update Tables, Create Users, and Manage the Database.
• Update Java code to coincide the database changes.
• Troubleshoot Oracle 9i Manufacturing E-business suite Database Issues: Including tasks such as Add/Update User Profiles, Perform Backups, upgrade patches as needed to Oracle Manufacturing database system. Optimize reports and load queries for increasing efficiency and speed of processing.

Confidential

Oracle/SQL Server DBA/Developer

• Analyze and Develop new procedures, packages, triggers, using PL/SQL, TOAD, Oracle 9i for LifeCad Navisys system conversion. Utilize SQL Server 2000 and integration with VB .Net and Visual Studio .Net as well.
• Update Oracle/DB2/SQL Server report queries to run more efficiently.
• Convert old in-house PL/SQL procedures to fit the new system upgrade for Navisys system Conversion using Oracle 9i.
• Alter VB.NET, C .NET, Java code to coincide with Database upgrade in Navisys.
• Maintain/update mapping for existing ETL Processes in Datastage
• Utilized PeopleSoft for Integration with Internal Financial Website for Goldman Sachs
• Convert DB2 Procedures to Oracle 9i PL/SQL.
• Alter any PL/SQL, T-SQL, triggers, packages, etc in Oracle/SQL Server as required by upgrade.
• Troubleshoot SQL Server/Oracle Database Issues: Including tasks such as Add/Update User Profiles, Perform Backups, upgrade patches as needed to Oracle SQL Server upgrades. Optimize reports and load queries for increasing efficiency and speed of processing.

Confidential

DBA/Developer

• Create proprietary Oracle Databases using the Oracle 9i Developer Suite. Databases creation/maintenance for Agent Access and Agent call routing in DB2, Oracle 9i for ODCIC project.
• Creation of new Database to feed off of the Oracle 9i Sprint Datamart to speed up reporting production times, VBA development for reporting team needs to create customized reports for call statistics, and creation/management of various new and existing Crystal Reports.
• Automate processes with UNIX shell scripting.
• Maintain/Develop new ETL Processes in Datastage.
• Keep track of and resolve Trouble Tickets relating to any datamart issues for my project.

Confidential

DBA/WEB DEVELOPER

• Create custom websiteS using PHP, MySQL, Adobe CS3.
• Create and maintain Databases for client websites in MySQL, Sql Server, Oracle
• Create/Modify Reports in Crystal Reports for Clients
• Automate processes with UNIX shell scripting
• Create Custom Access Databases for Clients

Confidential

Oracle DBA

• Manage the Oracle 9i Database needs for the Main Student Loan Website housing all Loans for all Universities Colleges and Technical Schools, resolving any and all issues related to student loan records. This meant logging all tickets into HEAT to keep track of any and all issues involving the loans.
• Updating tables, creating customized views for daily, weekly, and monthly reports. Create triggers and procedures relating to custom tables and views, etc.
• Train employees on Oracle SQL use and report writing.
• Troubleshoot Oracle 9i Database Issues: Including tasks such as Add/Update User Profiles, Perform Backups, Create Views/Tables as needed, upgrade patches as needed to Oracle 9i database system. Optimize reports and load queries for increasing efficiency and speed of processing.