We provide IT Staff Augmentation Services!

Oracle Lead Developer Resume

2.00/5 (Submit Your Rating)

NY

Hire Now

SUMMARY

  • Analytical, highly adaptable systems engineer with extensive experience enhancing operations across enterprises.
  • Proficient in managing database implementation and migration projects providing long - term resolutions to complex challenges.
  • Track-record of success developing, deploying, and evaluating systems aimed at improving quality and efficiency. Advanced expertise in administration and integrated software applications.
  • Astute troubleshooter continually focused on identifying, isolating, and resolving technical issues. Known for building and strengthening relationships across functions to drive cohesive and strategic operations.

TECHNICAL SKILLS

Databases: Oracle 12c/11g/10g, Teradata, Sybase, SQL server 2008Tools Informatica Power Center 9.x/8.x, Business Objects, Toad, SQL*Loader, Visio, SAP PLM, HP Service manager, Microsoft Office, Autosys, Control-M

Languages: PL/ SQL, T-SQL, Korn shell scripting, C, C++

Operating Systems: UNIX, Windows

PROFESSIONAL EXPERIENCE

Confidential, NY

Oracle Lead Developer

Responsibilities:

  • Lead the design and development of complex PL/SQL objects, programs and reports along with code reviews & peer development.
  • Involved in ETL Development using native Oracle tools (SQL*LOADER, Oracle PL/SQL, Informatica).
  • Hands-on experience using advanced PL/SQL features like Bulk binds (Bulk Collect and FORALL), Dynamic SQL and PL/SQL data types. Worked with Oracle Advanced Queuing (AQ) functionality
  • Developed and implemented EDI transactions with SAP system to accept advanced shipment notification as part of supply chain planning. Drive collaboration effort with IT and Business leaders in a Matrix organizational structure to provide innovative, quality solutions to meet business goals and expectations.
  • Influential in leading a that maintains NIS-OPM (Oracle process Manufacturing) serving more TEMPthan 3000 users at over 650 North American locations and processes 1.5 million transactions per day.
  • Designed, developed, and tested (Unit, system, integration and UAT) solutions to business problems with production migration, application hyper care and transition.

Confidential, NY

Senior Oracle Developer

Responsibilities:

  • Fine-tuned the Oracle code to achieve system performance requirements by reviewing stats-pack, SQL Trace, Tkprof, explain plan results.
  • Initiated the optimal PL/SQL code with the goal of doing the minimal amount of me/O needed, using bulk processing, Maximizing SQL & Minimizing PL/SQL, reducing the context switching between PL/SQL and SQL.
  • Developed PL/SQL packages, Procedures using ref cursors returning report datasets utilizing the autonomous transaction to log process progress and errors.
  • Exposed Informatica Designer to design the source definition, target definition and transformations to build mappings. Involved in the validation of those Mappings, data generation & loading using Informatica Power Center.
  • Instituted procedures for generating XML data and utilized DBMS AQ. ENQUEUE oracle package, to enqueue and store in oracle queue tables.
  • Developed UNIX shell scripts to automate SQL scripts for stage and production deployment.

Confidential

Senior Systems Analyst

Responsibilities:

  • Constructed unit test plans that will thoroughly exercise PL/SQL program logic to ensure application adherence to requirements.
  • Integral in the production support activities, resolving production problems quickly and TEMPeffectively.
  • Collaborated with senior developers regarding logical & physical database design, create and maintain logical ER diagrams, transform logical models into physical data models.
  • Designed the mapping to populate the data from OLTP database toOLAP Oracle Data Base
  • Performed error-handling packages using PL/SQL tables resolving user-defined errors.
  • Created Triggers, Packages, Procedures, Functions using PL/SQL and embedding SQL in complex reports.
  • Involved in production support and bug fixing in existing reports.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship