SUMMARY

• Over 5+ years of experience in Oracle Database Development using 9i, 10g and 11g, 12c, SQL and PL/SQL.
• Expertise in using PL/SQL programming
• Vast experience working on various platforms such as UNIX, Linux and Windows.
• Proficient in writing UNIX shell scripts and Windows batch scripts.
• Proven ability to plan, coordinate and implement complete software Life Cycle development.
• Experience in loading data from flat files to Oracle tables through SQL Loader.
• Experience using Oracle built in packages like UTL FILE to read and write to OS files.
• Experience in Data Analysis, design and development of data warehouse and data marts and their maintenance.
• Experience using Oracle built in packages like DBMS DATAPUMP, DBMS LOCK, DBMS OUTPUT, DBMS STATS, DBMS LOB,DBMS UTILITY, UTL MAIL etc.
• Experience in JAVA concepts such as OOPS Concept.Collections, Garbage Collection, Exception handling,File I/O, Design Patterns.
• Experience in Java/J2EE Development, Support and Implementation of Intranet, Client - Server applications using Java/J2EE Technologies like Core Java, JDBC, XML, Junit, and Hibernate.
• Proficient in Creating Oracle Stored procedures, Functions, packages, cursors, ref cursors, Nested Tables, Varraysand Associative arrays
• Experience in XML functions like XMLELEMENT and XMLFOREST etc.
• Experience using CURSORS, REF-CURSORS and DYNAMIC SQL.
• Experience using Oracle Aggregate functions and Analytical functions.
• Proficient in creating Oracle DB objects like Tables, Views, Materialized Views, indexes, PL/SQL procedures, functions, triggers and packagesetc.
• Experience using oracle supplied hints to tune the queries- append, parallel, driving site, no index, use nland first rows.
• Proficiency in application servers such as JBoss, WebLogic, Web Sphere, Apache Tomcat, Glassfish, IBM BlueMix.
• Good knowledge on web-based GUIs using HTML5, XMLfor web enabled applications.
• Good Understanding of database design, Data Modeling-conceptual, logical and physical.
• Proficient in using oracle collections -bulk collects and bulk binds Performance tuning of PL/SQL code.
• Experience using various scheduling tools like control-M, Autosys, Dbms schedular.
• Extensively worked on ORM tools like Hibernate and widely experienced in implementing Hibernate Inheritance/ Collection / Association Mapping.
• Good knowledge of spring IOC, MVC and spring's integration with Hibernate technologies,JDBC.
• Good experience in J2EE Testing in developing test cases with Junit for Unit testing, and logging using Log4J.
• Experience in issue tracking and agile project management activities using HP ALM.
• Experience with Agile/Scrum methodologies to iterate quickly on product changes, developing userstories and working through backlog.

TECHNICAL SKILLS

Relational Database: Oracle 9i/10g/11g/12c, MS SQL Server 2012, 2008, 2005, 2000, 7.0, 6.5, MS-Access, IBM DB2 7.0.

Languages: SQL, PL/SQL, T SQL, shell scripting, Perl, C / C++, Java, J2EE, XML, HTML5.

Operating System: Unix, Windows 95/98/Me/XP/NT/2000, DOS, Linux, Windows Server 2003.

Tools: SQL Developer,Toad,Eclipse, Autosys, Putty, Datastage, Informatica, Powercenter 8.6, Junit, Log4j.

Dimensional Modeling: Erwin 4.1/3.5.2/3. x, Dimensional Data Modelling, Star Schema Modelling, Snow-Flake Modelling, Fact and Dimensions Tables.

PROFESSIONAL EXPERIENCE

Confidential, StLouis, MO

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in SDLC gathering requirements from business. Developed views to make easy interface implementation between the different schemas.
• Developed stored procedures and functions to facilitate consistent data entry into the database.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, functions, procedures, cursors and packages.
• Created procedures for validation purposes as per business requirements.
• Developed Spring Container, Controller classes, Spring Configuration XML file.
• Created and modified client validations in existing services as per business requirements.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Involved in performance tuning on SQL using AUTO TRACE, EXPLAIN PLAN utilities.
• Involved in developing the DAO’s for accessing the Database.
• Involved in developing persistence layer using JDBC, SQL and stored Procedures.
• Having experience in different version control software like Subversion and Github.
• Created stored procedures using dynamic SQL to populate data into temp tables from physical tables for reporting purpose.
• Involved in working with IMPLICIT CURSORS, EXPLICIT CURSORS and REF CURSORS.
• Created materialized views using different clauses like FAST, COMPLETE, FORCE, ON COMMIT.
• Used PL/SQL collections, Table Types, And Record Types.
• Wrote stored procedures to provide extra functionality, including loading and modifying of data and retroactive business rule changes.
• Extensively used XML functions like XMLELEMENT,XMLFORESTand etc. for data loading from XML requests and also for creating XML responses.
• Involved in writing user stories and technical debts to backlog in VERSIONONE as per the business requirement.

Environment: Oracle11g, 12c, SqlPlus,Sql Developer, Java/J2ee, Spring, Eclipse, Junit, Xml,AltovaXmlspy, HP ALM 12.0

Confidential, Atlanta,GA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Interact with business Analysts, gather requirements and convert them into Technical specs.
• Move data between the servers using FTP and SCP.
• Created new Tables, Indexes, views, synonyms and Sequences in the Oracle database.
• Created Procedures, Functions and Packages as per the requirement.
• Update and modify procedures, packages, functions based on the change request.
• Handled Exceptions- predefined and user defined. Used Raise, Raise application error to handle the exceptions in the application programs.
• Used UTL FILE package to read and write to OS files.
• Used PL/SQL collections, Table Types, And Record Types.
• Optimized PL/SQL code using bulk collects and bulk binds.
• Optimized SQL queries using ExplainPlan, TKProf, Sql hints to improve the performance of the queries.
• Used partitioning methods-Range, Hash and list for Tables and Indexes.
• Used local and global indexes.
• Created views and materialized views to improve the performance.
• Used DB LINKS to pull data from remote tables and populate the materialized views and used DBMS MVIEW.REFRESH to refresh the materialized views.
• Used DB LINKS to pull data from remote tables and populate the materialized views and used DBMS MVIEW.REFRESH to refresh the materialized views.
• Used SQL hints like append and parallel to improve the performance during bulk loads.
• Used Sql Loader to load the flat file-csv file data to Oracle tables.
• Created token files to ensure complete data availability before the automation process initiates in order to migrate the data to new environment.
• Automated the process of migration from SQL server to Oracle by using AUTOSYS.
• Used Secure Shell, putty to connect to UNIX machines.
• Created new stored procedures and debugged the existing ones.
• Created and monitored database maintenance plans for checking database integrity.

Environment: Oracle10g/11g, SQL, PL/SQL, Toad, Sql Developer, Windows NT, Putty for UNIX, Sharepoint,Autosys, SQL LOADER.

Confidential, St Louis,MO

Senior Oracle PL/SQL Developer

Responsibilities:

• Conduct meeting with users to gather new requirements.
• Understanding the business requirements and analyzing the data.
• Creating new database objects based on the business requirement.
• Created new tables, indexes, views, sequences, synonyms
• Download the files from mainframe server to local server using FTP.
• Perform bulk loads using sql loader.
• Used direct load and parallelism to increase the performance of bulk loading using sql loader.
• Made changes to existing code PL/SQL procedures and packages as per business requirement.
• Created new functions- to meet the new business requirements and perform financial calculations.
• Created procedures and packages.
• Used these user-built functions to manipulate the data while loading to production tables from staging environment.
• Tuned sql queries using explain plan, oracle supplied hints.
• Created and used DB Links to connect to remote databases.
• Created materialized views- as part of tuning process.
• Interact with database administrators to create the new database objects in tests, UAT production environments.
• Interact with database administrators in implementing partitioning- table and indexes for very large datawarehouse tables and tuning the sql queries and PL/SQL code.
• Used Range partitioning to partition by tables and local indexes.
• Used oracle hints such as append and parallel to tune bulk insertion.
• Addressing jira defects raised by testers.
• Involved in writing windows batch scripts to run the sql scripts and automate the process using the scheduling tool- Autosys.

Environment: Oracle11g, SQL, PL/SQL,T-SQL, Toad,Sql Developer, Windows NT, Putty, Autosys, SQL LOADER.