SUMMARY

• Around 8+ years of IT experience in Implementation, Design and Development of Client/Server & Web - server applications using Oracle on UNIX & Windows Platforms.
• Expertise in Oracle 12c/11G/9i/8i, SQL, PL/SQL, Oracle Forms 10g/9i/6i, Reports10g/ 9i/6i and UNIX shell scripting.
• Experience in application software analysis, design, development, implementation, maintenance, and documentation of commercial applications through out various phases of project life cycle.
• Interacting with Business users, gathering and analyzing requirements.
• Experienced in System Analysis, design and implementation.
• Logical and physical data modelling. Monitor database performance & Tuning
• Good understanding of Oracle data dictionary and normalization techniques.
• Experienced in Oracle 10g/9i/8i/8.x/7.x systems, SQL*Loader, Export, Import and SQL*Plus.
• Proficient in Oracle Data base design with relational models and very good experience in entity and attribute identification and developing the Entity-Relationships.
• Writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
• Experience in writing Stored Procedures, Functions, Database Triggers and Packages using PL/SQL.
• Enforcing data integrity using integrity constraints & database triggers.
• Enforcing security by creating roles, granting system and object privileges on the tables, stored procedures.
• Loading data from flat files into database tables using SQL*Loader.
• Automating data loading, extraction, reports generation using UNIX Shell scripting (Bourne shells).
• Involved in Forms Migration from 6i to 9i using Migration Assistant Tool.
• Wrote and modified Oracle PL and SQL, Sql statements procedures and functions that are called in the Java Scripts
• Knowledge of database architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
• Experience in developing applications using forms (10g/9i/6i) and reports (10g/9i/6i).
• Well experienced in backend programming (Triggers, Procedures, and Functions) using Oracle 10g/9i/8i/8.x and web enabled application development and deployment using Oracle application server.
• Experienced in loading data using SQL *loader and using SQL *Plus.
• Sound experience in creating HTML pages using Oracle Web tool Kit on Oracle Web Server.
• Good in writing complex SQL queries according to business rules.
• Actively involved in capacity planning, creating views, materialized views, partitioning tables and creating indexes etc for optimization process.
• Involved in query tuning using Explain plan and TKPROF.
• Developed Data Mapping and Data Conversion scripts using SQL, PL/SQL.
• Extensively used UTL FILE package to write the data from oracle tables to a flat file.
• Written complex SQL’s using joins, sub queries and correlated sub queries.
• Wrote Test cases and performed data validation and process testing for application moving into production.
• Excellent in problem solving, logical and analytical abilities.
• Team Player with Analytical skills, ability to quickly adept to new environment and available as needed for training.
• Ability to work independently and as part of a team, deliver under pressure and tight deadlines.

TECHNICAL SKILLS

RDBMS/Application Sever: Oracle 12c/11g/10g/9i/8i/, Developer 11g/10g/9i/6i suite (Forms 10g/9i/6i, Reports 10g/9i/6i), Oracle Designer 2000/6i, Discoverer 9i SQL*PLUS, Server Manager/SQL*DBA, Export/Import, SQL*Loader, Erwin, Toad, Oracle Enterprise Manager Informatica 9x/8x

Languages: SQL, PL/SQL, Unix shell scripting (Bourne shells)

Operating System: Oracle Enterprise Linux, Redhat Linux, Sun Solaris for SPARC 8.0/2.6, HP UNIX 10.2, IBM AIX 4.1, Windows-2000/NT/98/95, MS-DOS

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK

Languages and Web Technologies: SQL, PL/SQL, Java, J2EE, Shell Scripting, XML, HTML/XHTML.

PROFESSIONAL EXPERIENCE

Confidential, Waukon, IA

Sr Oracle PL/SQL Developer

Responsibilities:

• Involved in SDLC gathering requirements, creating detailed Documentation HLD and TDD which includes all Business requirements and technical specifications.
• Initially contracted to develop multiple MS Access desktop based reporting applications for upper level.
• Involved in scrum meetings, Business requirements meetings.
• Developed stored procedures, functions, triggers and packages to facilitate consistent data entry into the database.
• Participated in system analysis and data modeling, which included creating Tables, Views, Materialized Views, Indexes, Synonyms, Triggers, Functions, Procedures, Cursors and Packages.
• The business logic in MS Access was converted to PL/SQL and either placed in the APEX application.
• Expertise in working with Records, Collections and Dynamic SQL.
• Developed Database Triggers for audit and validation purpose. Used pipelined functions for faster data accessibility. Writing validation packages using PL/SQL package.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance. Developed Installation scripts for all the deliverables.
• Created custom ETL tools using PL/SQL procedures, functions and a QC environment with MS Access and Excel.
• Fair knowledge in web based software development and usage of programming tool Java such as JDBC connection and establishing relationship with Oracle databases.
• Involved in working with implicit cursors, explicit cursors, and REF CURSORS.
• Experience in using various oracle PL/SQL collections Varrays, nested tables, associative arrays with INDEX BY VARCHAR2
• Involved in working on Oracle Pseudo columns like ROWID, ROWNUM, SYSDATE, SYSTEMTIMESTAMP, USER etc.
• Create various user defined exceptions to control the process based on the business requirement.
• Involved in generating numbers for primary key values using Oracle sequence objects.
• Extensive experience in design, development, and enhancement and managing applications oracle PLSQL.
• Worked in all deployment processes to SIT, QA and Production Environments.
• Handled various errors thrown throughout the integration process and coordinated with the team. Updated status of the development on daily basis.

Environment: Oracle Database 12c/11g, Oracle Forms 6i/11g, JAVA, MS Access, Excel, Oracle Reports 10g, SQL*Plus, SQL*Loader, TOAD, Clear Case, UNIX.

Confidential, Austin, TX

PL/SQL Developer

Responsibilities:

• Involved in all phases of software development including gathering requirements, creating specifications, development of database objects, developing code and validating programs.
• Involved in development of User Interface Objects (Forms9i and Reports9i) and Testing of entire module.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
• Extensively used PL/SQL Developer for creating database objects, running the command scripts for inserting the configuration data items.
• Involved in migrating forms from 6i to 9i using migration assistant.
• Involved in moving the code to production using Change Management Procedures.
• Documented all the packages, procedures and functions involved in ETL process.
• Written many database triggers for automatic updating the tables and views.
• Responsible for back end stored procedures development using PL/SQL predefined procedures.
• Used Explain Plan and hints to tune the SQL.
• Used UNIX Shell scripts to deploy the Oracle forms and reports to production servers.
• Involved in loading the data from flat files to Oracle tables using SQL*Loader and C.
• Involved in creating user documentation and providing End user training.

Environment: ORACLE11g, SQL* Plus, UNIX, Forms 9i, Reports 9i, PL/SQL Developer, C, SQL * Loader, TOAD.

Confidential, Atlanta, GA

Oracle PL/SQL Developer

Responsibilities:

• Gathered the requirements from the data analysts and architects and performed technical analysis to reach a viable solution.
• Designed database structures for effective data extraction, validation, run detail notification and error logging.
• Used and PL/SQL stored procedure for data conversion and interfaces processes.
• Designed and developed PL/SQL functions/ stored procedures/ cursors/ triggers/ packages.
• Performed several Automations written in Perl-DBI/DBD and UNIX Shell scripting in an agile environment.
• Used Perl to implement reports and new features in the Web GUI.
• Involved in writing complex/ad-hoc queries to generate reports as per client request as a part of production support.
• Involved in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views etc.
• Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.
• Involved in fine tuning and optimization of different SQL queries to insure faster response time.
• Involved in Unit Testing and Performance Testing for reports.
• Used SQL Trace, Analyze, Explain Plan Utilities, and Hints to develop better SQL Queries.
• Worked as Production Support Developer to solve real time issues.
• Resolved Priority Production Support Issues and Defect Fixes.

Environment: Oracle 10g, Perl, UNIX, shell script, SQL*LOADER, TOAD.

Confidential

Jr Oracle PL/SQL Developer

Responsibilities:

• Developed Oracle forms, database triggers, cursors, stored procedure
• Developed PL/SQL Packages, Functions. Utilized SQL*Loader to load flat files database tables.
• Responsible for SQL tuning and optimization using Analyze, EXPLAIN PLAN, TKPROF utility and optimizer hints
• Utilized PL/SQL developer tool in developing all back end database interfaces
• Worked on responsible for performing code reviews.
• Developed user documentation for all the application modules.
• Also responsible for writing test plan documents and unit testing for the application modules.
• Worked in Oracle Cursor, Exception Handling, Collections like REF, Nested tables, VARRAYS and IOTs.
• Developed graphical interface of Adobe Designer enables users to quickly design forms, Maintain form templates.
• Created database scheduler scripts and applications using UNIX shell scripts, SQL *Plus script.
• Maintained performance tuning by using SQL-Related Performance Tools like SQL Trace and TKPROF, Indexes and Clusters etc.
• Upgraded, maintained and troubleshooter for Oracle Forms and Reports.

Environment: Oracle 10g, Oracle Reports 6i/10g, TOAD, Unix Shell Scripts, SQL*Loader, EXPLAIN PLAN and TKPROF tuning utilities.