We provide IT Staff Augmentation Services!

Lead Oracle P/sql Developer Resume

0/5 (Submit Your Rating)

Irvine, CA

SUMMARY

  • Over 18 years of total IT experience, which includes more than 10+ years in development and post production support using PL/SQL, SQL (both conventional and ANSI) and other Oracle tools and technologies.
  • Involved in different phases of software development and full life cycle implementations.
  • Strong knowledge in Relational Databases concepts.
  • Experienced in SQL Tuning and Performance enhancements of database applications.
  • Accumulated domain knowledge in Manufacturing and Retail sectors.
  • Strong experience in SLA bound production support across distributed environments.
  • Proficient in Unix/Linux shell scripting.
  • Customer service oriented, strong analytical, problem - solving and conceptual skills.
  • Good knowledge of Data warehouse concepts.
  • Extensive exposure to ET(v)L with pl/sql and Informatica.
  • Proficient in performance tuning using various oracle utilities/APIs
  • Enjoy working in a team as well as independent, being a smooth team player with excellent interpersonal skills.
  • Good exposure with various stages of Oracle Database Administration.
  • Open to learn latest developments with ability to quickly comprehend and deliver solutions.
  • Basic understanding of rapid application development using Oracle Apex.
  • Extensive knowledge in batch jobs / processes design using Shell Scripts, FTP, SCP and SQL * PLUS.
  • Worked in Agile Development environments.
  • Job scheduling experience using Unix cron and UC4 job scheduling tool.

TECHNICAL SKILLS

Languages: SQL ANSI, PL/SQL, XML, JSP and basic knowledge in JAVA and SOAP and RESTful based web services.

Platforms: Unix (HP/Solaris/ Confidential ), Linux (Redhat), Windows XP, Windows 7 and Windows 2012.

Databases: Oracle 7.3 thru Oracle 11gR1 and basic knowledge of Oracle 12c

Tools: Putty, Oracle Forms and Reports, Pl/sql Developer, SQL Developer, SQL Navigator, OEM, TOAD, Factory Planner (i2 Solutions Planning Tool), Informatica, Business Objects, Erwin for Data Modelling, JIRA, VSS, WinCvs, WinScp, Oracle Apex and UC4 job Scheduler

Utilities: Export, Import, Data Pump export and import, SQL*Loader, SQL*PLUS, SQL*DBA, Unix cron and AWR.

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

Lead Oracle P/SQL Developer

Responsibilities:

  • Designed and developed series of batch processes to process the files from across globe and save the data to GEDB database.
  • Automated the warranty end dates processes.
  • Supported the Siebel call center application interface to GEDB.
  • Created Oracle packages, stored procedures, triggers and functions for this warranty database batch process.
  • A number of shell scripts have been created for the entire batch data processing.
  • Created views and Materialized Views for better application performance.
  • Involved in ETL process of data mart development using GEDB data.
  • Developed ETLs for Data Extraction, Data Mapping and Data Conversion using SQL, PL/SQL and various shell scripts.
  • Designed, developed and supporting the Repair order system batch process where files from service depots loaded into the database.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links.
  • Used COLLECTIONS - object, table Types, BULK COLLECTS, PIPELINE functions to process millions of records.
  • Actively involved in developing & tuning of reports.
  • Designed a strategy to monitor the availability of the DB to various web applications.
  • Find and troubleshoot Oracle performance bottlenecks using Tkprof, Explain Plan, few DBMS packages and AWR
  • Prepared Technical Requirement Docs (TRDs)
  • Performed unit testing, integration testing, system testing, UAT and code reviews.
  • Involved in application testing when Oracle DB upgraded from 10gR1 to 11gR1.
  • Developed several database packages for loading and looking up data into / from the repair order database and GEDB using web services.
  • Used external tables to extract from data files, transform with validations to ensure data quality and load the data processed according to business rules.
  • Worked extensively in SQL*PLUS environment for ad-hoc reporting involving several schemas and multiple database servers. Used WITH clause and Oracle analytical functions- RANK, LAG, ROW NUMBER for complex queries.
  • Imported and generated XML files for the repair order DB using various Oracle SQL functions for XML processing.
  • Worked closely with business to troubleshoot and fix / enhance the data flow.
  • Helped the Database Administrator to implement a logical stand by for GEDB. This logical standby DB serves both reporting and fail over purposes.
  • Involved in designing and maintaining table Partitioning on some of the very big tables in the DB schema.
  • Devised an approach to fail over the web application to the reporting DB.
  • Created different interfaces for out bound data to downstream systems.
  • Enhanced the DB code when the MS IIS applications have been converted to java applications.
  • Supported few web applications with SOAP and RESTful web services.

Confidential

Sr. Systems Engineer

Responsibilities:

  • Logical and Physical Database design for locations across AP and Europe.
  • PL/SQL design and development for Capacity and Demand planning for Locations.
  • Data replication from Central to location DBs and vice-versa.
  • Design and development of few Oracle forms and reports for user entering demand details.
  • Job automation using Unix Cron and UC4.
  • Monitoring and trouble shooting of above jobs.
  • Improved performance of tables with more than billion records by creating SQL queries with TABLE PARTITIONs and SUB-PARTITIONs and ANALYTICAL functions.
  • Post processing of data after planning run has been run for reporting purpose.
  • Creation of planning reports with Oracle Reports for planners
  • Production support, which is on call basis for all locations across Europe and AP.
  • Co-ordination between different teams involved in the process.
  • Administration of Location Data bases which includes DB backup, Schema analysis and space management.

Confidential

Systems Engineer

Responsibilities:

  • Creation of Oracle backend interface functions using pl/sql.
  • Connectivity between POS and Unix servers thru TC using shell scripts.
  • Creation of reports and data entry/enquiry screens using Oracle Forms and Oracle Reports.
  • Creation of end of day and end of month batch processing functions for all modules.
  • Provided post production support.
  • Monitoring and trouble shooting online sales transactions.
  • Performance tuning of DB server and applications for optimal use.
  • Backup of DB servers at regular intervals.

Confidential

Responsibilities:

  • Installation of Oracle Server software (Oracle 8) on variety of hardware and OS platforms including, HP-UX, Sun Solaris, Windows NT, etc. Creation of Oracle Databases (Oracle 8.0) for Confidential ’s retail clients.
  • Warehouse design in conformation with customer requirements.
  • Staging area design and creation.
  • Data Warehouse/ staging area tuning for optimal performance. Tune Memory allocation, I/O and physical structures, Resource contention, etc.
  • Creation of OS users/groups, job scheduling, trouble-shooting at OS level, etc.
  • Troubleshoot connection problems on client, middle-tier and server.
  • Provided Operational Support.

Confidential

Analyst Programmer

Responsibilities:

  • Developed front end forms with Forms 4.5
  • Created database Procedures/Functions with oracle Pl/sql
  • Developed shell scripts for the batch process to invoke Oracle’s Export and Import and SQL * Loader utilities.
  • Developed common library routines (Plls) for interface.

We'd love your feedback!