SUMMARY

• Over 12+ years of experience in Software Development Life Cycle (SDLC) - Software analysis, design, architecture, development, design and integration using Oracle PL/SQL technologies.
• Oracle PL/SQL Developer Certified Associate, with strong knowledge of SQL and PL/SQL
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Expertise in Client-Server application development using Oracle 12c/ 11g /10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER .
• Expertise in Oracle database design, creation and management of schemas, writing DDL, DML, SQL queries
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Partitioned large Tables using range partition technique.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Experience in working with ETL tools like Informatica
• Oracle Certified Professional, Java Programmer SE 8 with very good knowledge of Advanced Java technologies
• Good understanding of Object orientated design principals and design patterns.
• Extensive development experience with Java/J2EE technologies including Application Tier using Java Servlets, and Presentation Tier using JSP, JSTL, HTML and Custom Tag Libraries
• Good experience in working with distributed system architectures using J2EE concepts like JDBC and JNDI
• Expertise in using Framework like Spring and Hibernate.
• Experience in client-side technologies such as HTML, JavaScript, AJAX, JSON and JQuery.
• Good knowledge of PYTHON and MONGODB
• Experience in creating analytical reports using Oracle BI Publisher and Oracle Report Developer
• Experience in software testing, Junit testing, regression testing and defect management using HP ALM.
• Experience in working with IDEs such as Jdeveloper, Eclipse and Net beans.
• Extensive experience in Software Development on Windows 10/XP, UNIX.
• Experience using Waterfall, Scrum and Agile methodologies.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Database: Oracle 12c/11g/ 10g/ 9i, MySQL, SQL Server, MongoDB

Programming Languages: Java, SQL, PL/SQL, Python, T-SQL

Java/J2EE Technologies: Core Java, Servlets, JSP, JSTL, Java Beans, JDBC, JNDI, Struts, Spring, Hibernate

Web Technologies: HTML, XML, CSS, Java Script, DOM, AJAX, JSON, JQuery, Angular JS, REACT

Database Tools: TOAD, SQL Developer, SQL*Plus, Erwin, Informatica

IDE Tools: JDeveloper 12.x/11.x/10.x, Eclipse 4.x/3.x, NetBeans

Web Application Servers: Oracle WebLogic Server 12.2.1.3, OC4J 10.1.3, Apache Tomcat 8.0/7.0

Operating Systems: Windows 10/XP/2000/NT, Linux, UNIX

Source Code / Version Control: Microsoft TFS, GIT, CVS, Serena PVCS, Rational ClearCase, Jenkins

Reporting Tools: Oracle Business Intelligence Publisher, Oracle Report Builder

Methodologies: Waterfall model, Agile, Scrum

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Developer

Environment: Oracle PL/SQL, Oracle SQL, TOAD, Java, JSP Servlets, BI Publisher, HTML, Java Script, CSS, Ajax, Log4j, JDeveloper 11.1.2.3, UNIX, WebLogic Server, Agile/Scrum Methodology

Responsibilities:

• Involved in Project Architecture, Functional analysis, Process Workflow and migration of data from the NY State
• Represented the team in client calls to gather the requirements and providing the weekly status report and periodic project implementation status.
• Developed various PL/SQL objects like procedures, functions, packages, Cursors and triggers in accordance with the business needs.
• Created database objects like tables, views, synonyms, indexes, views, materialized views and sequences.
• Developed more than a dozen of reports using Business Intelligence Publisher.
• Developed web pages using JSP, JSTL, Servlets, HTML and JavaScript.
• Used TFS as version control tool for effectively managing the code changes and experience with Agile/Scrum methodology
• Responsible to prepare the Low-Level design document
• Handled the Build Deliveries, analyzing the production issues.
• Involved in Unit Testing and User Acceptance Testing.
• Provided Build releases to QA Team.

Confidential

Senior Database Developer

Environment: UNIX, Oracle PL/SQL, Oracle SQL, TOAD, Informatica, Shell Script, HTML, CSS, JSP, Oracle BI Publisher, Windows

Responsibilities:

• Involved in Project Architecture, Functional analysis, Process Workflow and designing of the database.
• Developed the logic to match the name and date of birth, from various arrest feeds with child welfare databases using Soundex and UTL MATCH.
• Created database objects like tables, views, synonyms, indexes, views, materialized views and sequences.
• Developed various PL/SQL objects like procedures, functions, packages, Cursors, pipeline functions and triggers in accordance with the business needs.
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Presented several technical presentations on Oracle database operation.
• Optimized SQL statements and PL/SQL blocks by using Oracle Hints, Explain plans, profiling, collecting statistics and Trace sessions for Cost based Optimization.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like AUTOTRACE and DBMS SQLTUNE
• Coordinated with DBA in creating and managing tables, indexes, table spaces, auditing and data quality checks.
• Designed, Developed, Tested and Maintained BI Publisher reports and supported all aspects of Oracle report development in support of information sharing and application development initiatives
• Responsible to prepare the Low-Level design document
• Provided Build releases to QA Team.

Senior Database Developer

Environment: Oracle PL/SQL, Oracle SQL, TOAD, SQL * Plus, SQL*Loader, SQL Developer, Shell Scripts, Oracle BI Publisher, UNIX Oracle Application Server

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created reports to plug in with the front end using Oracle BI Publisher.