PROFESSIONAL SUMMARY:

• Over 6+ years of experience in Oracle Database Development using 9i, 10g and 11g, 12c, SQL and PL/SQL.
• 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.
• Expertise in writing UNIX shell scripts and hands on experience with scheduling of shell scripts using AUTOSYS.
• 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, Varrays and Associative arrays
• Experience in XML functions like XMLELEMENT and XMLFOREST etc.
• Strong Knowledge of Data Warehouse architecture in Designing Star Schema, Snow Flake Schema, FACT and Dimensional Tables.
• Experience using CURSORS, REF-CURSORS and DYNAMIC SQL.
• Extensive experience in developing strategies for Extraction, Transformation, Loading (ETL) data to various sources into data warehouse and Data Marts.
• Proficient in creating Oracle DB objects like Tables, Views, Materialized Views, indexes, PL/SQL procedures, functions, triggers and packages etc.
• Proficiency in application servers such as JBoss, WebLogic, Web Sphere, Apache Tomcat, Glassfish, IBM BlueMix.
• Good knowledge on web-based GUIs using HTML5, XML for 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 user stories 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, Tableau

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, St Louis, 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 using JAVA for accessing the Database.
• Involved in developing persistence layer using JDBC with JAVA, SQL and stored Procedures.
• Having experience in different version control software like Subversion.
• 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,XMLFOREST and 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, Altova Xmlspy, HP ALM 12.0

Confidential, Atlanta, GA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Created Design documents by understanding the requirements and there by develop jobs.
• Interact with business Analysts, gather requirements and convert them into Technical specs.
• Extracted data from different sources, process the data and generate the files and transfer these files to Target Systems.
• Created and monitored database maintenance plans for checking database integrity.
• Developed common Jobs, Shared containers and Server Routines, which are used across the project in most of the interfaces.
• Analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.
• Developed UNIX shell Scripts used to validate the files.
• Implemented Slowly Changing Dimensions (Type 2) while loading data into dimension tables to hold history.
• Used Constraint Based loading & Target load ordering to efficiently load tables with PK-FK relation in the same mapping.
• Executed Stored Procedures from different part of the mapping and used the data set in the mapping.
• Wrote Shell scripts and Stored Procedures for regular Maintenance and Production Support to load the warehouse in regular intervals and to perform Pre/Post Session Actions.
• Created Unix Shell Scripts that takes care of end-to-end automation. Developed UNIX shell Scripts that trigger jobs, transfer the output files, perform basic validations on file.
• Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.
• Created new Tables, Indexes, views, synonyms and Sequences in the Oracle database for new business changes.
• Created and modified Procedures, Functions and Packages as per the requirement.
• Involved in PL/SQL query optimization to reduce the overall run time of stored procedures.
• 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.
• 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.
• Provided on demand Ad-hoc reports per business requirement.
• 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 Sql Loader to load the flat file-csv file data to Oracle tables.
• Automated the process of migration from SQL server to Oracle by using AUTOSYS.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.

Environment: Oracle10g/11g, SQL, PL/SQL, IBM InfoSphere DataStage 11.3, Sql Developer, Windows NT, UNIX, Autosys, Tableau, 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.
• Designed and developed DataStage jobs to extract from legacy systems to Stage and from Stage to ODS and finally to EDW.
• Perform bulk loads using sql loader.
• Extensively worked on DataStage stages namely Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, and Row Generator stages in accomplishing the ETL Coding.
• 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 data warehouse 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.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.

Environment: IBM WebSphere DataStage 9.1/8.7/8.5, Oracle11g, SQL, PL/SQL,Sql Developer, Windows NT, Putty, Autosys, Jira 4.1, SQL LOADER