We provide IT Staff Augmentation Services!

Sr Oracle Pl/sql Developer Resume

2.00/5 (Submit Your Rating)

Ann Arbor, MI


  • Over 6 years of programming experience as an Oracle and PL/SQL developer in Analysis, Design, Data Modeling (Logical and Physical) and Implementation of Business Applications using Oracle products
  • Database: Using Oracle 10g/11g/12c, Teradata TD13/TD12, SQL, PL/SQL, SQL*Plus, SQL Server 2005/2008. Proficient in working with PL/SQL. Expertise in TOAD (Tool for Oracle Application Developers).
  • Extensively worked on PLSQL - Functions, Procedure, Functions, Packages, Ref-Cursors, Triggers, Views, Materialized Views, Hits and Indexes.
  • Strong hands on experience usingTeradata utilities (B-TEQ, FastLoad, MultiLoad, FastExport, and Tpump).
  • Strong Data warehousing experience using Informatica Power Center, Power Connect for ETL, OLTP, OLAP, Data Mining, and Scheduling tool. Worked with heterogeneous source systems like flat files, RDBMS, and XML.
  • Data Modeling: Data modeling knowledge in Dimensional Data modeling, SCD, Star Schema, Snow-Flake Schema, Dimensions and Fact Tables, Physical and logical data modeling and De-normalization techniques.
  • Experience in data cleansing/profiling operations on Source data (From source to Staging) and experience in performing SCD Type 1,2 and 3 on Target data.
  • Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof, Table Partitioning.
  • Involved in providing Extensive production support to various Applications along with server Maintenance projects 24x7.
  • Experience in Using JIRA for bug tracking, Issue tracking and project management.
  • Experienced in MS Power BI Desktop and Power BI Service.
  • Knowledge in generating periodic reports based on the statistical analysis of the data from various time frame and division using Power BI.
  • Extensive knowledge in writing DAX queries to measure the calculated columns.
  • Worked extensively on Power BI and created Reports/Dashboards using different type of Slicers and different Visualizations like Bar Charts, Line Charts, Graphs, and Pie Charts etc. to make it more attractive and explored data in a Variety of ways and across multiple visualizations using Power BI.
  • Extensive knowledge in Transform and combine the data using Query Editor in the Power BI and publish to Power BI Service.
  • Proficient in creating SQL Server reports, handling sub reports and defining query for generating drill down reports using SSRS.
  • Experienced in generating monthly and quarterly reports as bar charts for the management using different techniques like data filtering and deploying reports to Power BI Service.
  • Proficient in Power BI data visualization to analyze and obtain insights into large datasets, create visually powerful and actionable interactive reports and dashboards.
  • Experience in developing applications using Agile, Scrum and Waterfall methodologies.
  • Experience in developing reports and forms using Oracle forms and reports 6i/9i.
  • Good experience in version control of documents and database objects using tools like VSS and SVN.
  • Experience in developing applications using Agile, Scrum and Waterfall methodologies.


Approaches: Waterfall, Agile/Scrum, SDLC, STLC

Programming Tools: C, C#, SQL, PL/SQL, R, JAVA

RDBMS: Oracle 9i/10g/11g, SQL Server 2008/2005/2000 , MS Access 9.0/7.0, Teradata 12/13, Sybase, UDB DB2, My Sql.

Databases: Oracle, SQL SEVER

Reporting Tools: Power BI, SSRS, Oracle Reports

Defect Tools: JIRA

Operating Systems: Windows NT/ 2008/2000/2003/ XP/Vista/7,Linux, UNIX

Utilities: OKTA, TOAD


Confidential, Ann Arbor, MI

Sr Oracle PL/SQL Developer


  • Involved in various stages of SDLC like Requirement gathering, high level design, low-level design, Coding.
  • Performed discussions with data modeler to update the data model for new requirements.
  • Designed/developed tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages for ETL.
  • Involved in PL/SQL code review and modification for the development of new requirements
  • Developed PL/SQL code for various levels of front-end validations
  • Integrated customized forms into Oracle Applications and added new forms and registered in Oracle applications
  • Developed multiple reports using Reports for listing the customers who visited the center
  • Used PL/SQL and SQL *Loader to import /export data from various sources
  • Analyzed the security holes in the PL/SQL and Java script coding. Fixed all the security hole and bugs in most of the packages and also fixed security hole in control file’s of the SQL*loader
  • Extracted data from the source views by writing the procedures to load the data into staging tables
  • Created materialized views on remote source database and automated scheduler of refreshing of materialized view on source side.
  • Created SQL Loader script generator application using UNIX shell scripting and PL/SQL
  • Database security by authenticating users, using logon triggers.
  • Created indexes on tables and optimized procedure queries.
  • Fine tuned the SQL queries using optimizer hints for joins, parallelism and Explain plan
  • Fine tuned the PL/SQL queries by creating complex views, using explain plan and use TKPROF if necessary
  • Created the integrity constraints and database triggers for complex data validations
  • Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL. Enhanced it with creating exceptions for error handling
  • Written complex Oracle SQL queries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators.
  • Copied the data from oracle database to an external directory in an XML format.
  • Used SVN to version control all the database scripts.
  • Developed and implemented several types of Financial Reports by using SSRS. Validated reports and resolve issues in a timely manner.
  • Scheduled Automatic refresh and scheduling refresh in Power BI service.
  • Migrated existing self-service reports and ad-hoc reports to Power BI.
  • Creating relationships between different datasources in Power BI to visualize the data and build the reports.
  • Created sub-reports, drill down reports, summary reports, parameterized reports, and ad-hoc reports using Power BI.
  • Wrote Calculated Columns, Measures, and Queries in Power BI desktop to show good data analysis techniques.
  • Responsible for Unit, System and UAT testing the data and provided the test evidence reports.
  • Involved in UAT testing, Bugs fixing and the code was sent to Production.
  • Executed the test scripts in Quality Centre and raised the defects.
  • Responsible for writing the functional and technical design documents and maintaining the documentation

Environment: Oracle 11g, Oracle Forms 6i, Reports 6i, PL/SQL, SQL*Plus, SQL*Loader, PL/SQL Developer 6.0, Toad 9.1, UNIX, Erwin r4, XML, SVN, Informatica power center tool 8.1.1, QC 10.0, Windows.

Confidential, San Jose, CA

RDM Developer


  • Involved in getting the User Requirements, Data Modeling & Development of the RDM Application.
  • Extensively used SAP Power Designer to create data models
  • EncapsulatedPL/SQLprocedures and functions in packages to organize application.
  • Extensively used Views, Cursors, Store procedures, Packages, Collections and Triggers.
  • Written complex Oracle SQL queries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators.
  • Participated in Performance Tuning using Explain Plan and created local indexes to increase the performance and to make the database objects more manageable
  • Used Bulk collect and Forall in stored procedures to improve the performance and make the application to run faster.
  • Responsible for creating objects, deploying jobs and providing production support for Reference Data Management (RDM) application
  • Collaborated with Hadoop team to provide data masking and data encryption for RDM application.
  • Involved in UAT testing, Bugs fixing and the code was sent to Production. Executed the test scripts in Quality Centre and raised the defects.
  • Designed python scripts to scrape data from websites.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, flat files,, SAP Business Objects, SAP Power Designer, Teradata 15, and Python 2.7.

Confidential, Irvine, CA

RDM Developer


  • Gathered requirements from Business users and created a Low level technical design documents using high level design document.
  • Participated in the design meetings, and prepared technical and mapping documentation.
  • Wrote SQL scripts to create temporary tables and developed control files for SQL*Loader to load from legacy system into the temporary tables.
  • Created various types of procedures using PL/SQL and SQL queries for data validation, data cleansing.
  • Designed and developed the scripts to create table, views, indexes and sequence.
  • Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
  • Involved in using dimensional modeling, created fact tables, dimensional tables and other database objects in the Star schema model.
  • Involved in Performance tuning, Included creating indexes, providing Hints, modifying tables, analyze tables and estimate stats.
  • Wrote Procedures to drop appropriate Indexes on tables to improve the performance of loading.
  • Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Worked on improving the Performance of SQL queries by extensive usage of Explain plan and various hints and indexes.
  • Participated in performance tuning, unit test case preparation and execution.

Environment: Oracle 10g, Informatica, flat files, SQL Loader, SQL * plus, PL/SQL, Erwin 4.0/3.5.2, and Unix Shell Scripting.

We'd love your feedback!