We provide IT Staff Augmentation Services!

Sr Oracle Pl/sql Developer Resume

3.00 Rating

Chicago, IL

SUMMARY

  • 12+ years of IT experience in Analysis, Design, Development, Testing and Production Support in Oracle, SQL, PL/SQL and Client Server applications.
  • Experienced in developing Oracle 11g/10g/9i/8i SQL,PL/SQL’s
  • Experienced in developing SAS BI Reports using SAS EG Tool.
  • Expertise in developing Stored Procedures, Functions, Packages, Triggers, Indexes and Views.
  • Expertise in tuning SQL queries using Hints, application tuning using Explain Plan, creating indexes, Collections etc.
  • Expertise in Oracle utilities including export/import, SQL Loader, SQL*PLUS.
  • Expertise in Migration from one technology to another technology ( COBOL, SYBASE and SQL Server to Oracle
  • Expertise implementing securities using Roles, Privileges and Grants.
  • Strong in data base management concepts and UNIX skills.
  • Excellent interpersonal skills, analytical, communication skills and leadership responsibilities.

TECHNICAL SKILLS

Programming Languages: C, C++, UML, Java, Pro *C, VB

Oracle Database: Oracle 9i/10g/11g/12C, SQL, PL/SQL

Servers: ApacheTomcat4.2, Weblogic8.1, Oracle 10gAS,Oracle 11gR2

Design & Other Tools: Rational Rose, Rational Xde, Visio, Data stage7.5

Scripts: Perl, Shell, VBScript, JavaScript

Operating Systems: Linux, Windows 98/2000/NT/XP, UNIX, Solaris

Web and J2EE: EJB, JSP, Servlets, HTML, DHTML, JDBC, JMS

Main Frame: Data Base DB2, COBOL.

GUI and Tools: Oracle10g Developer suite, Oracle9i IDS Developer suite, Forms 5.0/10g, Reports 5.0/10g, Designer 6i/9i, Informatica / Data Stage

Version Control: GIT, SVN,CVS,PVCS

PROFESSIONAL EXPERIENCE

Confidential, Chicago IL

Sr Oracle PL/SQL Developer

Responsibilities:

  • Responsible for On boarding the dealers.
  • Responsible for validating the data in Elastic Search vs Postgres vs 20/20 tool.
  • Responsible writing SQL queries and loading the data into PostGres Database.
  • Creating and Scheduling the job in Chronos.
  • Responsible for resolving the JIRA tickets for the Customer and Invoice domains.
  • Creating the custom and override functions for Dealers.
  • Responsible for Validating the data in Kibana - Sense.

Environment: PostGreSQL, SQL, Unix, ElasticSearch, Chronos, AirFlow, XML,Mesos, Python, Kibana-Sense, AWS, Docker.

Confidential, Chicago, IL

SAS EG Developer / Sr Oracle PL/SQL Developer

Responsibilities:

  • Responsible for resolving the CBOE/C2/CFE Production issues on CDB/DWS.
  • Responsible for setting up C2 DR / CFE DR site for C2 Main and CFE Main.
  • Responsible for creating oracle SQL Query’s and PL/SQL stored procedures and Functions.
  • Responsible for developing the SAS BI Reports using SAS EG Tool.
  • Responsible for developing stored process for SAS Reports.
  • Responsible for preparing the technical documentation for the user requirement.
  • Responsible for providing solution design document for the requirement.
  • Responsible for creating shell scripts to automate deployment process.
  • Responsible for creating indexes to improve the performance of the SQL queries.
  • Responsible for performance tuning of procedures and functions.
  • Responsible for modifying the existing Oracle Tables and Procedures as for the business requirements.
  • Responsible for 24x7 on call support, troubleshooting the C1/C2/C3 Production issues.
  • Monitoring and optimizing the database performance and SQL performance, provided day-to-day production support for CDB/DWS applications.
  • Responsible for setting up control-m jobs, folder structure and users creation for DR Sites.

Environment: Oracle RAC, TOAD, SQL*PLUS, Unix, Shell scripting, Perl,Pro *C, Java, Angular, Control-M, SAS EG, GIT, Stash, Bamboo, Clear case.

Confidential, Chicago, IL

Sr Oracle PL/SQL Developer

Responsibilities:

  • Responsible for validating the user’s data by creating data quality rules.
  • Responsible for modifying the existing Oracle Tables and Procedures as for the business requirements.
  • Responsible for writing Oracle Packages for all acquisition cycles and Data package and data package groups.
  • Responsible for preparing the technical documentation for the requirement.
  • Responsible for providing solution design document for the requirement.
  • Responsible for creating Perl scripts to automate deployment process.
  • Creating the indexes to improve the performance of the SQL queries.
  • Responsible for performance tuning of procedures and functions.
  • Involved in coding, compiling, debugging, testing and full life-cycle unit testing.
  • Responsible for data model and design of the databases.

Environment: Oracle 11g, TOAD, SQL*PLUS, Perl scripting, Share Point, Power Designer, .Net.

Confidential

Responsibilities:

  • Responsible for creating the Control-M jobs from SBIP to DVSZ environment.
  • Responsible for changing external tables into Sql loader control files scripts
  • Responsible for creating the Shell scripts to schedule the jobs.
  • Clone databases with various strategies like Cold/Hot/Logical Refresh and RMAN Backup.
  • Responsible for Security Management by allocating proper privileges.
  • Creating the indexes to improve the performance of the SQL queries.
  • Responsible for performance tuning of procedures and functions.
  • Responsible for loading Bloomberg / Factset’s data into PBR data base.
  • Responsible for loading Instruments, Holdings and Portfolio’s data into database.
  • Responsible for preparing the technical documentation for the requirements.
  • Responsible for preparing the Smart Sync tool to automate the migration process.
  • Involved in coding, compiling, debugging, testing and full life-cycle unit testing.
  • Responsible for modifying the existing Oracle Tables and Procedures as for the business requirements.

Environment: Oracle 11gR2, TOAD, SQL*PLUS, EM Tool, SQL Loader, Export & Import Data, WinSCP, Tectia, Unix, Shell scripting, SVN, Enterprise Architect

Confidential

Responsibilities:

  • Responsible for extracting all hospitals data, send to central database using
  • Pl/sql Stored procedures and Shell scripting.
  • Created the indexes to improve the performance of the SQL queries.
  • Responsible for improving performance of the Reports that are running long time.
  • Responsible for extracting central database data and Sync all Hospitals using Shell scripting and PL/Sql Stored procedures
  • Responsible for performance tuning of procedures and functions.
  • Involved in coding, compiling, debugging, testing and full life-cycle unit testing.
  • Responsible for modifying the existing Oracle Tables and Procedures as for the business requirements.

Environment: Oracle 11g, SQL, PL/SQL, Linux, Windows XP, Redmine, .Net, Putty.

Confidential

Responsibilities:

  • Gathering the requirement from Users, Plan & implement into production servers
  • Responsible for performance tuning of PL/SQL procedures and functions.
  • Responsible for TWS setup for Phase 1.1 & Phase 1.2 interfaces.
  • Responsible for creating the new Shell scripts as for the requirement.
  • Responsible for assigning the tasks to team members.
  • Have good exposure on working with OLTP / OLTA.
  • Identification of various Data Sources like Relational databases, Application systems and Flat files to extract, transform and load data from these sources into Data warehouse.
  • Responsible for reviewing / writing new wrapper Shell scripts for Phase 1.2
  • Responsible for reviewing / raising CR’s to push the updated scripts into production
  • Responsible for investigating the production issues / tickets.
  • Responsible to assigning the production tickets to team members and work together to solve the issues.

Environment: Oracle 11g, SQL, PL/SQL, AIX 5.3, Windows XP, Clear Case, Tomcat Server, BPS server, Rendition server, AlgoSecutiry server, Documentun server, TWS / Tivoli, Manage now,Data Stage.

Confidential, Grand Rapids, MI

Responsibilities:

  • Designed Database Structure, developed PL/SQL procedures, Bulk collections SQL scripts functions & Triggers.
  • Monitored and optimized the database performance and SQL performance.
  • Involved in Migration of Oracle data base 10g to 11g.
  • Created the indexes to improve the performance of the SQL queries.
  • Was responsible for answering problem tickets created by business users and resolving application issues.
  • Involved in coding, compiling, debugging, testing and full life-cycle unit testing.
  • Developed Core Java programs and JDBC connection.
  • Was responsible for modifying the existing Oracle Tables and Procedures as for the business requirements.
  • Was responsible for modifying the VB code (WinFax) to MS Fax service for sending/receiving the quotes to the customers.
  • Created the Quotes List and sent faxes to customers.

Environment: Oracle 10g/11g, SQL, PL/SQL, Toad, UNIX, Windows XP, FTP, VB, MS SQL Server, C++, Crystal Reports, Java Springs, Net Beans, CVS, MS Access, IBM Web sphere 5.2

Confidential, Chicago, IL

Responsibilities:

  • Identify Sybase proc's and implement them in PL/SQL procedures.
  • Responsible for Coding, Debugging, Testing and Full cycle Unit testing in Sybase and PL/SQL.
  • Created Ref cursors for passing data to Business objects.
  • Monitored and optimized the database performance and SQL performance.
  • Created Global temporary tables for temporary data load processes.
  • Responsible for creating the functional specs for all Sybase proc's.
  • Created new tables, indexes, views, SQL scripts, Bulk collections SQL scripts and triggers.
  • Responsible for data loading from the Sybase to Oracle tables and involved in data analysis, design and implementation.
  • Prepared test cases for all batch programs.
  • Created the indexes to improve the performance of the SQL queries.
  • Involved in unit testing and resolved the errors that occurred.
  • Created the new packages, procedures, functions across the client requirements.
  • Designed database structure and developed PL/SQL procedures & functions.

Environment: Oracle 10g, SQL, PL/SQL, Sybase, Rapid SQL 7.2, HP UNIX, Windows XP, JAVA, C/C++, TOAD, PVCS, Pro * C, IBM Web sphere, Business Objects, Novel.

Confidential, Pittsburgh, PA

Responsibilities:

  • Responsible for creating the Functional specs for all interfaces.
  • Identified all COBOL interfaces and implemented them in PL/SQL procedures.
  • Assisted DBA in granting privileges, created new tables, indexes, views, triggers, procedures and functions. Restored the lost data in the tables.
  • Created Algorithms for all hospital interfaces & Medical interfaces.
  • Responsible for preparing the flow charts for all interfaces.
  • Prepared test cases for all batch programs.
  • Designed database structure and developed PL/SQL procedures & functions.
  • Monitored and optimized the database performance and SQL performance.
  • Involved in coding, compiling, debugging, testing and full life-cycle unit testing.
  • Involved in unit testing and fixed the errors that occurred
  • Created new packages, procedures, functions across the client requirements.

Environment: Oracle 10g, SQL, PL/SQL, COBOL, Toad, HP UNIX, Windows XP, ASP.Net, MS Visio.

Confidential, Detroit, MI

Responsibilities:

  • Monitored and optimized the database performance and SQL performance, provided day-to-day production support to all applications.
  • Developed Triggers and PL/SQL stored procedures.
  • Restructured SQL to improve query response times by up to 25% and performance tuning of procedure, functions.
  • Identification of various Data Sources like Relational databases, Application systems and Flat files to extract, transform and load data from these sources into Data warehouse.
  • Extensively used Data Stage Designer to design & develop various Server jobs for ETL using stages like ODBC, Sequential File, Hashed file, Aggregator, Transformer, Merge, and Sort etc.
  • Created/Modified the shell scripts for data load application as for upstream application.
  • Created and managed database tables and control files for data loading.

Environment: Oracle 9i, SQL, PL/SQL, SQL * loader, Toad, HP UNIX, Windows XP,FTP, Erwin, Cognos, Ascential data stage 7.5.1,autosys

We'd love your feedback!