SUMMARY:

• Over 7 years of experience with expertise in Data ware house, Application Development and Production Support in Client/Server Environment using Oracle 11g/10g/9i/8.x, SQL, PL/SQL, Java, J2EE, SSIS/SSRS, Oracle Application Express(APEX), Business Objects and Informatica.
• Experience in all phases of Software Development Life Cycle (SDLC) including analysis, specification, software and database administration, development, maintenance, testing and documentation.
• Excellent proficiency in Data Extraction, Transformation and Loading, Database Modeling and Data ware housing tools and technologies such as AbInitio, ODI and Erwin.
• Profound Knowledge in Star Schema Modeling and Snowflake Dimensional Modeling (Data Marts, Facts and Dimensions).
• Strong technical expertise in creating and maintaining database objects - Tables, Views, Materialized Views, Indexes, Sequences, Synonyms, Database Links and Database Directories.
• Extensive experience in developing PL/SQL Stored Procedures, Functions, Packages, Cursors, Collections (Nested tables and Varrays), Records, Object types and Database Triggers.
• Proficient in Oracle utilities and tools - SQL*loader, Export/Import, TOAD 8.0/8.5/9.0, SQL*plus, iSQL*plus, SQL Developer and SQL Navigator.
• Expertise in generating customized Forms and Reports using Oracle Forms and Reports 6i/9i.
• Expertise in Performance Tuning and Query Optimization using various types of Hints, Partitioning, Bulking techniques and Indexes.
• Profound experience in Tuning SQL queries using utilities like EXPLAIN PLAN, SQL Trace and TKPROF to improve the performance.
• Expertise in designing and developing applications using Oracle Application Express (APEX).
• Expertise in using HTML, CSS, Jquery, JavaScript, and Ajax in APEX applications to have client side programming and validations.
• Extensive experience working in an Agile development environment.
• Experience in implementing Authentication, Authorization on Embedded PL/SQL gateway, Oracle HTTP server and Web logic server.
• Strong experience in Oracle ETL data loading techniques like UTL FILE, SQL loader, Copy Command and External tables from various business source environments.
• Strong knowledge of UNIX Shell Script on Sun Solaris 2.8/2.7 and HP UNIX 12.x/11.x. and Worked on KORN Shell Scripts to write maintenance script for Oracle.
• Excellent background in implementation of business applications and in using RDBMS OLAP, OLTP and OOPS concepts.
• Highly motivated team player with good communication skills and excellent problem solving abilities. Would be willing to work independently or as part of a team.

TECHNICAL SKILLS:

Languages: SQL &PL/SQL, Java, J2EE, C, C++

Web Technologies: JSP, Servlets, XML, HTML, JavaScript, CSS

Operating Systems: Windows, UNIX, Linux

Databases/API: Oracle 9i/10g/11g/12c, MySQL, DB2, MS SQL Server 2005/2000

Version Controls: PVCS, SVN

Other Tools: Oracle SQL Developer, APEX 3.2/4.0/4.1/4.2, oracle Designer 6i/4.7, Toad, SQL* Loader, Workflow, Win Runner, SSIS, SSRS, Winrunner, Rational Rose.

ETL Tools: Informatica (Power Center 5.1/6.2/7.1/8.6.1/9.1.0 ), SQL*Loader.

PROFESSIONAL EXPERIENCE:

Confidential - Topeka, Kansas

Sr. Oracle Developer

Responsibilities:

• Involved in requirements gathering process and assisted the business analysts in understanding the functional specifications.
• Developed the interactive reports using D3JS.
• Participate in the weekly team meets to discuss the status of the application development and discuss detailed work plan.
• Created several pages, regions, page items, computations, validations and page processes at different instances.
• Developed several report regions such as classic reports, interactive reports, dynamic sql reports and also anonymous pl/sql block report regions.
• Developed several computations and validations at page item level and also application item level.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Designed and developed User Interface forms and reports using APEX, Bootstrap Framework, AngularJS for the custom applications and built interactive navigation system for the application.
• Experience in using apex collections to handle data at the page, session and user level.
• Experience using APEX ITEMS package functions to show different types of items in the report columns dynamically.
• Created several shared components such as lists, lovs, tabs and implemented web services to communicate to Teamwork’s BPM Process.
• Experience working with Oracle Workspace Manager to handle transactional data at different instances such LIVE and save point.
• Developed packages, procedures, functions, cursors, triggers, synonyms, views and several other database level objects.
• Implemented page validations using JavaScript, Ajax and Jquery at database level as well as User Interface Level.
• Implemented Jquery features such as Auto complete, fade in and fade out, tooltip and also proficient in using Ajax calls to fetch the data with partial page refresh.
• Developed custom templates to suite the Fonterra base theme using HTML, AngularJS, CSS and JavaScript.
• Responsible for requirement analysis, client interaction and preparation of Technical documentations.

Environment: Oracle 11g, SQL, PL/SQL, ORACLE APEX 4.2/4.1, SQL*Loader, Forms, Reports, Agile Methodology, MS Visio, Business Objects.

Confidential - St. Louis, Missouri

Sr. Oracle Developer

Responsibilities:

• Involved in requirements analysis, design and development of the system.
• The project involved detailed design using E-R Diagrams and Data Flow Diagrams.
• Extensively used PL/SQL features such as procedures stored procedures, functions, packages & database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Involved in Technical Analysis of the business requirements.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Extensively used SQL* loader and External Table methods to Load data from CSV and delimited flat files into database tables.
• Created screens using HTML and JSP and Servlets.
• Wrote complex SQL queries and PL/SQL procedures to extract data from various source tables of data warehouse.
• Designed and developed various reports using Oracle Reports 9i.
• Created and used Table Partitions to further improve the performance while using tables containing large amount of data.
• Tuned SQL queries and performed refinement of the database using tools like EXPLAIN PLAN, and TKPROF to significantly improve the system response, time and efficiency.
• Developed stored procedures, functions and packages for updating, inserting and deleting data from the tables.
• Created page processes at several instances and computations in APEX.
• Developed validations using Ajax calls with JavaScript and PL/SQL packages.
• Configure SSL for APEX over web logic server, HTTP server and others in Test and production environments.
• Supported APEX applications and conducted performance tuning for PLSQL.
• Worked on Business Objects (BO) to deploy various reports
• Involved in Unit level testing, Module level testing and System level testing.
• Documented the whole process flow, PL/SQL Packages, log files, locations and description, log tables and possible error messages, process codes and description.
• Detected and corrected bugs during system integration and user acceptance testing.

Environment: Oracle 11g, SQL, PL/SQL, ORACLE APEX 4.2/4.1, SQL*Loader, Forms, Reports, MS Visio, Business Objects.

Confidential - Detroit, MI

Sr. Oracle PL/SQL Developer

Responsibilities:

• Interacting with Business users, gathering and analyzing requirements.
• Involved in the design of logical and physical data model of the components.
• Create and maintain tables, views, procedures, functions, and packages.
• Coordinate with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Forms Developer 9i
• Developed screen layouts, report layouts using Forms and Reports and participated in implementation.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Successfully manipulated Stored Procedures, Functions and Packages using TOAD.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
• Designed and developed various reports using Oracle Reports 9i.
• Created and used Table Partitions to further improve the performance while using tables containing large amount of data.
• Used Designer 2000 for Data Modeling, Design Specifications and to analyze Dependencies.
• Assisted in debugging Visual Basic.NET components
• Developed PL/SQL packages using Oracle Standard/ Custom Exceptions.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
• Responsible for developing custom application using APEX. This involves developing APEX reports and Forms, Conversion of Oracle reports into Oracle APEX reports.
• Provided APEX guidance to technical staff on application maintenance and SDLC process.
• Formulated SQL queries, functions and processes as per customization requirement for APEX.
• Used Oracle Apex4.0 for designing application structure.
• Contributed with database designs and assisted in increasing response time for APEX reports.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Involved in the continuous enhancements and fixing of production problems.
• Used external tables to manipulate data obtained daily before loading them into the tables.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Designed reports that had complex SQL, PL/SQL code and stored the procedures. The filter conditions for the Queries were dynamic in nature and included lexical parameters.

Environment: Oracle 10g, PL/SQL, SQL*LOADER, ORACLE Apex 4.0, SQL PLUS, ASP, HTML, PVCS, TOAD, Java, Developer Suite 6i/9i (Forms, Reports), Windows NT 4.0/2000, UNIX shell scripting.

Confidential, Oaks, PA

Oracle Developer/ Apex Developer

Responsibilities:

• Team member responsible for the development and maintenance of the Inventory Control and Client contract modules
• Interacted with the business users on a regular basis to collect business requirements and specifications.
• Involved in Designing of Data Modeling, Design Specifications and to analyze Dependencies.
• Tested new enhancements and bug fixes before deployment into the production environment.
• Worked as part of a team to launch new application releases under strict time deadlines
• Coded database Triggers, Package, Functions, and Procedures using PL/SQL; and maintained the scripts for various data feeds.
• Optimized and tuned PL/SQL to reduce the loading process.
• Created shell scripts to automate the acquisition and archiving of files.
• Wrote KORN Shell Scripts to prepare files to be merged into the database
• Developed UNIX scripts to create FTP Jobs.
• Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Responsible for designing and maintaining fully integrated and multiple levels help system for the modules.
• Designed the look and feel of the APEX forms (User Interface) along with the users.
• Supported APEX applications and conducted performance tuning for PLSQL.
• Developed the user interface using the Oracle Apex form types depending on the requirements.
• Experience in using JavaScript, HTML, and CSS and also built standard templates to meet the corporate themes for the application.
• Formulated SQL queries, functions and processes as per customization requirement for APEX.
• Involved in preparing functional specifications, release notes, training materials and other documentation.
• Performance tuning of SQL queries for data warehouse consisting of many tables with large amount of data.
• Created Packages, Procedures and Functions that extensively used PL/SQL cursors, user defined object types and exception handling.
• Optimized and tuned PL/SQL to reduce the loading process. Used SQL trace facility and Tkprof along with Explain Plan to accurately assess the efficiency of the SQL statements when the application runs.
• Designed star schemas using dimensional modeling and created fact tables and dimensional tables.
• Involved in writing complex scripts for Data Transformation and ETL process.
• Design and develop revenue recognition applications for multiple elements deal.
• Used ERWIN for logical and physical Database Modeling. Analyzed Business documents, Internal & External Source systems and requirements to develop the Logical and Physical model (Facts and Dimensions) and Business Process Model.
• Analyzed and designed UML model using MS Visio to reflect existing business models.
• Worked on Business Objects (BO) to deploy various reports onto production.
• Developed ETL for Data Extraction, Data Mapping and Data Conversion for various application and processes.

Environment: Oracle 10g/9i, SQL, PL/SQL, Apex 3.2,UNIX, UML, Business Objects, Windows XP, SQL*PLUS, SQL*Loader, Erwin, SSRS.

Confidential, WI

Oracle PL/SQL Developer

Responsibilities:

• Coded PL/SQL sub-programs and modified the existing PL/SQL program units for customer Contact Employees (CCE’s) relationships.
• Customer Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
• Developed several Packages, Procedures, Functions and Triggers to use in multiple series of other backend programs using PL/SQL.
• Involved in Logical and Physical Database design and Star Schema design. Identified Fact tables, Transaction tables for Small Business and Consumer Markets (SBCM) customers.
• Written SQL scripts to create database objects like tables, views and sequences.
• Constant monitoring and performance tuning of Oracle10g database, checking the most queries.
• Developed batch programs using UNIX shell scripts to generate reports daily, weekly & monthly for Customers Markets.
• Created Korn Jobs to perform regular updates to database tables to keep in sync with the data coming from other sources.
• Performed review and analysis of deadlocks and database performance tuning.
• Conducted code walkthrough & internal/peer reviews on application code and other deliverables.
• Documented the whole process flow, PL/SQL packages, log files, locations and descriptions, log tables and possible error messages, process codes and descriptions.
• Involved in the continuous enhancements and fixing of production problems.
• Worked closely with the Application Development teams to identify and implement continuous improvements and effective problem resolution strategies.

Environment: Oracle 9i, SQL, PLSQL, SQL*Loader, KORN Shell script, Erwin, TOAD, Web Logic, HTML, Java, J2EE, Unix, Install base.

Confidential

PL/SQL Developer

Responsibilities:

• Assisted in database designing by creating database objects such as Tables, Views, and Indexes.
• Worked with Sub-queries/Correlated Sub-Queries in Different areas of the database.
• Received data from source (Market data & Communications) and imported the data to the interface table using SQL * Loader.
• Developed validation programs to validate the data before importing into the payables table.
• Designed, developed, tested and implemented using Oracle Forms.
• Responsible for Designing, development, testing and deployment of Oracle Alerts, Triggers and debugging for Oracle Forms.
• Used Cron Jobs to schedule various reports.
• Developed PL/SQL packages and database triggers.
• Successfully designed and developed standard and custom reports using Oracle Reports and Pro*C.
• Used Informatica Reusable functionality by developing Mapplets, Parameters and Variables to make the ETL objects easy to maintain and understood by operations.
• Extensively used Data transformation as part of developing the Informatica B2B code.
• Used Normalizer transformations, XML Transformations (XML target, XML parsers, XML Generator) and all the functionality of Informatica (Mapplets, Stored Procedures, Update Strategy, Router, Joiner, SQL Transformation Etc...) to interpret business logic into ETL mappings.
• Integrated Crystal Reports into web application using Java/J2ee. Worked on data conversion from old data to new data.
• Good command, experience and knowledge in RICE (Reports, Interfaces, Conversions, Enhancements) Components
• Worked on Unix Shell scripts, batch jobs and also worked on Scheduling and Automation of Unix shell scripts/Batch jobs.
• Involved in design, development, testing, implementing, various reports using Oracle Discoverer and Oracle Reports.
• Implemented parameters, condition, filters and calculations in reports through Oracle Discoverer Desktop.
• Worked on Migration of process from servers to different upgraded servers.
• Fixing bugs in previously designed reports.
• Developed custom reports like Non Moving Product Reports, Over Stocked Product Report.
• Developed Revenue reports like Monthly and weekly Revenue, Total Revenue and Monthly Transaction and Revenue Comparison Reports
• Worked with front end team on developing the application in ASP.NET.

Environment: Oracle 9i/8.x, PL/SQL, SQL*Loader, SQL Navigator, SQL*Plus, UNIX, Windows NT 4.0/2000/XP Windows2000.