SEARCH

Senior Oracle Consultant Resume Example

Resume Score: 90%

Love this resume?Build Your Own Now
SENIOR ORACLE CONSULTANT
Summary
To improve company productivity & decision making using my programming and math skills. Highly qualified academic background: two Masters degrees with real world projects and advance trainings. * Certification on R programming, Machine Learning and Tableau with Real life Data Analytic. * More than ten years of IT experience in various database technologies including PL/SQL, Oracle and Unix shell scripts.
Skills
  • Mathematics Software: R Programming, MATLAB, SAS, Tableau.
  • Database: SQL, PL/SQL, Oracle 9i / 10g / 11g, Forms, Reports, Toad, SQL Developer, MySql.
  • Programming Languages: JAVA (Eclipse), Assembly Language (LC3 Simulator), C++, Perl.
  • Web Programming: JavaScript, XHTML, DHTML, XML, CGI, PHP, CSS.
Accomplishments
  • Development of a MatLab program to analyze DNA sequences using 'global alignment algorithm'.
  • Development of MatLab programs that use Singular Value Decomposition (SVD) technique to implement Principle Component Analysis (PCA) and Kernel PCA methods on gene data.
  • Extensive statistical analysis on real life data using multiple regression & ANOVA methods in SAS.
  • Development of Ecommerce shopping cart using JAVA, JSP, Servlets, MYSQL, HTML and SMTP.
  • The website allows users to auction items within a time frame, upload images of the items on sale, search for an item based on keywords, bid on the items on sale, etc.
  • Items are sold to the highest bidders at the end of auction and once purchased, notification is automatically sent to the buyer and seller via email.
  • Development of image directory and search engine for the images using JAVA, HTML and MYSQL.
  • Development of Java programs to solve the Traveling Salesman problem by using exhaustive search technique.
  • Inputs: the matrix representation of a complete undirected weighted graph containing n vertices.
Experience
Company NameCity, StateSenior Oracle Consultant02/2013 to 01/2017
  • Was a part of JDA's (formally Red prairie) Customer1 and Enterprise1 application to maintain the Oracle 11g database for store operations, retail planning, manufacturing planning and supply chain management.
  • Also, provided database support to Jeromes.com, PHP sites and SQL report for finance and inventory team for better future planning for Jerome's stores.
  • Designed PL/SQL package which extract data from Oracle 11g database, converted data feed in XML format, scheduled FTP job through Unix cron job to send XML files to the bank daily.
  • Monitored the whole process for any issues.
  • Worked with PHP team to designed PL/SQL package using utl_http to send delivery emails and phone calls to customer before their schedule delivery through third party vendor.
  • Also, provided database support to make sure all the jobs were running fine and sent report to delivery team.
  • Created new database packages from old .net code to support new PHP web sites for better service on delivery and customer pickup process.
  • Used Oracle 11g PL/SQL features like Ref cursors, loops, exceptions, UTL_File, autonomous blocks & Oracle JSON package to write new and modify existing packages, procedures, functions, triggers for regular database management.
  • Worked with PHP team to create and modify existing database process to support new changes as per requirements.
  • Created and managed SQL Report for finance department to manage daily and monthly finance process.
  • Designed and created new Oracle package to predict cash flow for business analytic team to help future finance and inventory management.
  • Mentored junior employees on Jerome's database life cycle and provided database training on day to day support process for PHP and BI team.
  • Traced the Oracle database system for slow running process when needed and provided solution for better future performance.
  • Created/Modified Unix korn shell scripts to schedule cron job to load data files on daily and weekly basis for internal and external client.
  • Worked with regular database support issues for Jerome's internal client like job abend, missing data, locking issue, system performance using Jira and Spice work ticket system.
  • Worked on TortoiseSVN repository for source control management to update the database code for next installation cycle.
  • Environment: Oracle 11g, SQL Report, XML, Gers Customer1/Enterprise1, Solaris, Jira, SpiceWork, SVN.
Company NameCity, StateSenior Oracle Developer08/2012 to 01/2013
  • Worked in a team of Enterprise Administrative Systems and Services(EASS) to maintain the Sungard banner system using Oracle 11g database.
  • Was responsible for providing solutions to business departments supported by EASS, implementing production issues and developing projects as assigned by the EASS manager.
  • Worked directly with users to understand their technology needs, gathered requirements, prepared design documents, programmed and tested technical solutions, planned and executed the project to ensure a successful completion.
  • Provided oversight for the technical maintenance of the various ERP application systems, smaller vendor applications, and interfaces between the various systems.
  • Developed and implemented strategies and work plans for providing Integrated ERP technology solutions, as well as keeping an ERP environment operating at optimal performance and responsive to future and current needs.
  • Worked on Oracle 11g database interface that provided data feed in XML format using UTL_File package, Ref Cursor and Bulk Collector from student banner system to SQL server on Suanpsis application.
  • This application verifies international student's information with DHS (Department of Homeland Security) on daily basis.
  • Designed the data mapping for XML element, validated the XML file with XSD file, tested the data feed with users and scheduled the job in AppWorx.
  • Developed Oracle 11g package to verify students address information using Bulk collector, Cursor and UTL_File package from banner system and USPS built in package clean address, tested the package with business users and scheduled the job in Appworx for daily address verification.
  • Created database package to populate scholarship information from banner system using UTL_File, Ref cursor and outer join, into Excel files and scheduled the job in Appworx to send an email to users in the beginning of the semester.
  • Created database interface from student banner system to populate athletes information for every financial year into CSV files, tested the result with business users and scheduled the job in AppWorx.
  • Environment: SQL Developer, PL/SQL, Oracle11g, Unix, XML, Jira, Oracle Forms 11g, Oracle Application12c, SQL server.
Company NameCity, StateEngineer II11/2010 to 02/2011
  • Was part of fraud product team for Falcon 6, to catch credit card fraud worldwide.
  • Responsibilities included analyzing, identifying, communicating, prioritizing, and resolving system level issues for Falcon 6 production environments with focus on performance and operational stability.
  • Provided level 2 operation systems support to external and internal clients by executing incident investigation, resolution, management processes.
  • Directed the efforts of other technical teams within and outside immediate scope of influence to resolve issues as needed.
  • Worked with the management team to develop and standardize application / systems management processes.
  • Responded to requests for operational service, supported within defined Support Level Agreements (SLA)s and also properly escalating enterprise level problems to ensure SLA adherence.
  • Environment: Toad, PL/SQL, Oracle, Unix.
Company NameCity, StateOracle Software Analyst10/2007 to 08/2010
  • Was in charge of Oracle 10g / 11g database for world's largest automotive manufacturer - General Motors (GM), for its trade activities in Mexico.
  • The database is part of GM's 'Trade Management' system to support its worldwide production (includes Asia Pacific, Europe, South America & Australia), import-export shipments and custom filing.
  • Managed monthly reports related to import/export custom filing for Mexican government using Oracle database.
  • Designed, developed, tested and released new Oracle PL/SQL Forms & Reports according to new Government rules & regulations and customer needs.
  • Used PL/SQL features like cursors, loops, exceptions, nested blocks & Oracle built-in functions to write new and modify existing packages, procedures, functions for processing parse data (used Toad).
  • Developed Oracle 10g/11g Forms using packages, triggers, procedures, functions.
  • Extensively used Form features such as LOV's, record groups, program units, master-detail procedures, multi-row block alerts and menus.
  • Also designed Graphical User Interface (GUI) for new Oracle Forms.
  • Coordinated with IBM, Wipro and GM to maintain the database and update it with new worldwide production activities.
  • Worked on performance tuning with DBA to decrease the time of large data retrieval for GM system.
  • Mentored junior employees and provided training on GM's database life cycle, Oracle Forms & Reports, PL/SQL.
  • Created/Modified Unix shell scripts to schedule loading of data files on daily, weekly and monthly basis automatically.
  • Designed Entity Relational (ER) diagrams for new changes desired by the customer for calculating parts inventory in existing data warehouse.
  • Worked with regular support issues for GM like job abend, missing data, locking issue, system performance.
  • Increased user friendliness of the program and made the process more transparent, which allowed non-technical employees of the customer to perform the task themselves, reducing their cost of process.
  • Designed Oracle 10g Reports (example - printing the invoice with barcode to provide shipment information to the custom officer) using Report triggers, invoking Adobe acrobat and Excel.
  • Created SQL.
  • Loader scripts for loading data from flat files into the Oracle database.
  • Worked on TortoiseSVN repository tool for source control management to update the code for next installation cycle.
  • Environment: PL/SQL, Oracle Application (order management, inventory), Oracle Forms/Reports 10g/11g, Unix, Jira.
Company NameCity, StatePL/SQL Developer03/2007 to 10/2007
  • Responsible for incorporating new feeds into existing data warehousing system.
  • Responsibilities included assisting Application Analyst (AA) to design components, providing any status update to project lead, resolving issues as they arise, supporting the implementation of the project and addressing any post implementation defects.
  • Created flat files, control files & loaded data to the CVS data warehouse using SQL.
  • loader to input the patient information.
  • Created Unix shell scripts and PL/SQL packages, functions, procedures, triggers using Toad to generate 'RX connect' customer information from nearby competitors.
  • Created SQL Report and Unix Korn shell scripts for sending weekly fax and email to stores' supervisors.
  • Worked with project lead to understand business requirements & back-end component for pharmaceutical retail business.
  • Conducted unit & system testing, worked with the test architect to insure that all areas of the application were error free.
  • Environment: Toad, PL/SQL, Oracle9i, Unix, Window, SQL Report, SQL.
  • Loader.
Education and Training
Masters:Computer Science & Mathematics2006Eastern Michigan University (EMU)Computer Science & Mathematics
Masters:Mathematics2002South Gujarat (Vir Narmad) UniversityIndiaMathematics
Bachelors:Mathematics2000South Gujarat (Vir Narmad) UniversityIndiaMathematics Tableau for Data Science: Real-Life Data Analytic.
Linux/Unix System Administration Certificate. O' Reilly (University of Illinois Urbana-Champaign)2017
* Database Administration Certificate. O' Reilly (University of Illinois Urbana-Champaign)2011
Skills
.net, Administrative, Adobe acrobat, Analyst, architect, Assembly Language, automotive, BI, c, C++, cash flow, CGI, com, credit, CSS, client, clients, CVS, data warehouse, Database Administration, DBA, Database, database management, data warehousing, delivery, DHTML, Eclipse, email, ERP, XML, fax, features, filing, finance, financial, focus, Forms, FTP, Government, Graphical User Interface (GUI), http, PHP, IBM, inventory management, inventory, JAVA, JavaScript, JSON, Korn shell, Linux, Machine Learning, Mathematics, MATLAB, Excel, Window, MySql, Enterprise, Enterprise1, next, Oracle 9, Oracle9, Oracle, Oracle Application, Oracle database, Developer, Oracle PL/SQL, PL/SQL, order management, Perl, predict, processes, Programming, project lead, Python, retail, SAS, scripts, SLA, Solaris, SQL Report, SQL, SQL server, SQL* Loader, SQL*Loader, Statistical Analysis, supply chain management, systems management, Tableau, systems support, phone, Toad, Unix, Unix System Administration, Unix shell scripts, Web Programming, web sites, XHTML
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

School Attended

  • Eastern Michigan University (EMU)
  • South Gujarat (Vir Narmad) University

Job Titles Held:

  • Senior Oracle Consultant
  • Senior Oracle Developer
  • Engineer II
  • Oracle Software Analyst
  • PL/SQL Developer

Degrees

  • Masters : Computer Science & Mathematics 2006
    Masters : Mathematics 2002
    Bachelors : Mathematics 2000
    Linux/Unix System Administration Certificate. O' Reilly (University of Illinois Urbana-Champaign) 2017
    * Database Administration Certificate. O' Reilly (University of Illinois Urbana-Champaign) 2011

Similar Resumes

View All
Senior-Oracle-Retail-Consultant-resume-sample

Senior Oracle Retail Consultant

Goleta, California