Load data from several different systems from a flat file into tables in an Oracle database Compare data from legacy system to the data from the Oracle 19c cloud databaseCreate PL/SQL procedure to report the count differences and data differences Create PL/SQL procedure to do the comparisons of the data

Convert Oracle 6i Forms and Reports on a Windows operating system to Oracle 12c Forms and Reports on a Linux operating system.Compile, test and debug each Form and Report• Evaluate and identify effective solutions to fix Forms and Reports code which is not working correctlyUpdate code when needed Used Git for version control

Research database tables, packages, procedures and functions to find specific data for business needsCreate several SQL queries to pull data from those tables found from the researchInstall and configure Oracle Forms 11g, Weblogic, and Fusion Middleware on a Linux platform. Worked to get it to run on a staging server to match the production server.

Create Oracle PL/SQL packages, procedures, functions, and triggers for LEVO System to validate addresses, find addresses within a specific proximity using latitude and longitude using Oracle spatial packages and various other functionalitiesCreate tables, alter tables create relationship between tables and objects in the database Import data from flat files into Oracle database tablesExport data to a flat files.Analyze dataCreate external tablesCreate Jobs to run database processesMonitored and Maintained database processes and ensured all ran properly and debugged errors.Create database triggers. Use DML, DLL, DQL, DDL, DCL TCL commands

Automate the payment and invoice management by creating and maintaining several pl/sql procedures and packages and Unix scripts to manipulate and export or import data from a flat file and SFTP files to Wells Fargo or files received from Wells FargoCreate package with several procedures that will create a gun transfer or cancel a gun transfer from warehouse or another store • Create procedures to gather across multiple databases using database links analyze and manipulate the data, write to a flat file and send to Agilone. Create procedures in packages export product data from a very large file into database tables, manipulate the data and create a flat file for Agilone. Had fun learning about parsing clob datatype using the tokenizer methodology Create and maintain multiple procedures, packages, functions and triggers using PL/SQLFind root causes and resolve issues in the various applications and implement solutionsMonitor processes using Unix commandsCreate and modify Unix shell scriptsCreate database objects (tables, sequences, views, indexes, etc.)Create concurrent requests to run the procedures and Unix shell scripts. Create, maintain and tune database stored procedures, triggers and scripts for optimal performance by finding functionality problems and performance bottlenecks

Create, design and maintain Oracle forms and reports for the CIR (Credit Information Reporting) application. Work with the user extensively in order to include all their business rules and processes that is required for the application. Create procedures, packages, functions and triggers using PL/SQL.Work with users to ensure the application is working as scoped and designed.Insure that data integrity is maintained in the databases.

Create service catalog forms, scripts and tables in Service Now. Create complex ad-hoc SQL queries in Microsoft SQL and CCL to support the project. Develop complex Excel-based reports using complex pivot tables, charting, macros and linked to the ODBC sources.Provide analysis, design, configuration, testing, implementation and support (technical and functional) of administrative, financial, or clinical information systems.Solve common and moderately complex issues, incidents, and problems according to the agreed upon service levels and according to IS Standards. Collaboratively works with peers, internal and external stakeholders, and vendors.Test applications, systems and configurations for projects of moderate complexity and according to IS standards.Collaborate with key stakeholders in the training of peers, end-users, and other IS team members

Create, design and maintain Oracle forms and reports for the MMCS application. Technical Project Lead of the Structures/Bridges project and RFMS project . Work with the Business Project Lead, and utilize UDOT's and UDOH’s Software Development Project Management Methodology. Work with Business Project Lead and User Group to define user requirements.Create, design and maintain the Oracle forms and reports for the Structures/Bridges project (UDOT) and MMCS project (UDOH).Convert the Diagnosis and Procedure Applications, which was built in a COBOL legacy system called MMIS to and Oracle forms environment. Work with the user extensively in order to include all their business rules and processes that is required for the new application. (UDOH)Create procedures, packages, functions and triggers using PL/SQL.Analyze and implement logical and physical data base designs, provide data modeling support to development project teams. Create and maintain a detailed work plan.Analyze data security requirements in data base designs, performs performance tuning functions.Evaluate and test software packages, make recommendations for use of products to users, install new updated versions of software, develop long range plans and standards for use.Assist in the development of training on the use of the Structures/Bridges and Diagnosis/Procedure applications. Ensure that the trainers understand the use of the application.Work with users to ensure the application is working as scoped and designed.Insure that data integrity is maintained in the databases.Maintain a good working knowledge of data base management methodologies, application programming, data base software, data modeling and data administration.

Diamond Resorts, Las Vegas, Nevada: Transitioned the “Atlas” legacy system to a new "Clarity" platform. Created web application using JavaScript, HTML, Jquery and Ajax, Oracle PL/SQL and Mod_PL/SQL. Ebay, Salt Lake City, Utah: Created a routine to extracted data from a large scale Oracle/SQL Server database using C#. Gathered requirements, performed analysis, supported development and tested processes.

Created a routine to extracted data from a large scale Oracle/SQL Server database using C#.Developed complex ad-hoc SQL queries and Excel-based reports using complex pivot tables, charting, macros and linked to the ODBC sources.Gathered requirements, performed analysis, supported development and tested processes.

Maintained and supported the GCSS (Global Combat Support System) Oracle Infrastructure. Analyzed log files to ensure systems were running properly. Maintained a good working knowledge of data base management methodologies, application programming, data base software, data modeling and data administration. Monitored processes using UNIX commands. Created new databases, involving importing and exporting: installing and configured database software for Oracle Application development environment.

Created SQL statements to extract data for users.Find root cause and resolve SQL Server database issues and implemented solutionsProvided technical assistance to users.Responsible for troubleshooting and problem solving of SQL development.Ensure that the associated hardware resources are allocated to the databases and ensure high resilience and performance tuning.Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management.Responsible for improvement and maintenance of the database.Responsible for implementation and release of database changes according to agreed timescales and costs.

Created and maintained user accounts.Monitored several Control-M production systems.Provided appropriate security authorizations to Control-M users.Detected database problems by analyzing server database logs.Gained Knowledge of security procedures and regulationsAssists with system level user tests, documentation, and trainingResponsible for implementation and release of database changes according to agreed timescales and costs.

Project Lead for MasterCard Output Feed file and Exceptions process.Created, maintained, optimized and debugged Oracle packages, procedures and triggers. Conducted and managed weekly meetings with client.Reduced number of exceptions produced by the daily Output feed file by 90%.

Perform analysis on the current mainframe system by gathering current system flows, defining and gathering the systems requirements, collecting user requirements, identifying interface requirements, performing a feasibility study and creating functional and technical specifications. Design and develop legacy system into an Oracle system. Write and maintained various PL/SQL packages, procedures and functions to adhere to the business rules. Write a PL/SQL procedure to extract data from the database using Oracles XML functions such as XMLAGG and SYS_XMLGEN. Create a Web Service to accept an XML document. Create PL/SQL procedures to parse and store the XML document data into the database.

Responsible for ORACLE and Microsoft SQL Server database administration, database design, data modeling, data dictionary, and overall database performance monitoring, capacity planning, tuning, and database security management. Perform logical and physical data modeling, database design and implementation, including maintaining and updating the database architecture. Perform installations, configuration, and upgrades of corporate database servers. Ensure database backups and recoveries are functioning. Troubleshoot functionality problems and performance bottlenecks. Perform data manipulations in production databases, including data imports/exports to Test/Dev schemas. Create and evaluate database release scripts and packages. Perform SQL scripting, stored procedures, code reviews, and optimizations. Create, maintain and tune database stored procedures, triggers and scripts for optimal performance. Update, maintain and debug C# code for a web application. Produce builds each week.

Monitor, maintain and improve integration and interface functionality between Oracle applications. Create PL/SQL procedures, triggers and reports. Create and enhance custom 6i Forms and Reports. Troubleshoot and resolve Oracle and Tomax API and transactional errors. Migrate and convert data between legacy and RDMS systems. Modify and enhance Oracle eBusiness Suite Applications using standard Oracle tools and methods. Work one on one with users to solve problems.