Sr Oracle Pl/sql Developer Resume
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