SUMMARY

• Over 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.
• Expertise in writing SQL queries, Views, Materialized Views, PL/SQL procedures, Functions, Cursors, Collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL. Enforcing data integrity using integrity constraints & database triggers.
• Generated SQL and PL/SQL scripts to install create and drop database objects, including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Substantial development experience in creating stored procedures, PL/SQL Packages, Strong knowledge in Oracle cursor management and exception handling.
• Implemented privacy, security, and auditing.
• 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/SQL, Sql statements procedures and functions that are called in the Java Scripts.
• Experience in Informatica Power Center (versions 9.5/8.6/ 7.1) including Power Center Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Admin console and Teradata
• Extensively Worked on Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in OLTP and OLAP.
• Experience in application development using various advanced features of Oracle like Bulk Collections, Table Functions, Bind variables, Autonomous Transactions, Dynamic SQL, Object types and Records.
• 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 *Plu s. 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.
• Monitor and maintain application at support level.
• 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, 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), INFORMATICA 9.1

Operating System: Oracle Enterprise Linux, Red hat Linux, Sun Solaris, 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, XML, HTML/XHTML.

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Database Developer

Responsibilities:

• Involved in the analysis, design, development and testing phases of Software Development Life Cycle (SDLC)
• Developed new codes for data loads and modified the existing load scripts to load data into Data Warehouse from different sources as per the requirement.
• Developed Stored Procedures, Functions, Packages and SQL Scripts for database transactions using PL/SQL.
• Development of database triggers, cursors, packages, procedure & functions using PL/SQL & SQL.
• Worked on end to end flow in Data Warehouse.
• Maintain the Packages and Procedures version of changes in Tortoise SVN.
• Documenting the modifications and enhancements made to the application systems and databases as required by the project.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
• Extensive experience in data migration techniques using Oracle External Tables, SQL* LOADER, UTIL file loader and batch processing.
• Backup and recovery were performed on weekly, monthly basis
• Worked on importing data from Flat files from Legacy Applications to Oracle DB using SQL Loader.
• Extensively used SQL*Loader to load the data from the flat files to the database and validated the data with the PL/SQL procedures.
• Optimizing performance tuning at source, target, mapping and session level.
• Involved in performance tuning on SQL using AUTO TRACE, EXPLAIN PLAN, TKPROF utilities.
• Extensively worked on UNIX shell scripting for creating and maintaining the parameter files, executing database procedures, calling Informatica workflows, and job scheduling
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Used external tables to manipulate data obtained daily before loading them into the tables.
• Developed SQL*loader scripts to load data in the custom tables.
• Developed PL /SQL code for updating payment terms.
• Performed normalization of the OLTP database to eliminate redundant data.
• Prepared Handbooks for the application.
• Database design and development including Tables, Primary and Foreign Keys, Indexes, Stored Procedures and Database access policies for the company
• Preparation and execution of test plans for unit & system testing.
• Provided Application Server Level and Production Database Level support.
• Analyzing the test results and recommending modifications to the applications to meet project specifications.
• Developing and implementing the test validations of the applications specifications
• Wrote efficient stored procedures for the optimal performance of the system
• Monitored performance and optimized SQL queries for maximum efficiency.
• Performed unit testing and integration testing for various development applications in ORACLE 11g and ORACLE 12c.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Developed PL/SQL Procedures at the database level that were used in the mappings through Stored Procedure Transformation.
• Performed debugging the code and creating the exceptions to handle bad data and send them to error log files and Testing and debugging of the applications.
• Handled various exceptions to troubleshoot PL/SQL code.
• Improve the performance of the slow SQL queries by implementing advanced features of Oracle like Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types and Records.
• Monitoring the system performance and tuning the SQL codes by reading the explain plans.
• Experience in scheduling the jobs in Autosys
• Coordinating code builds between environments.
• Analyses the warehouse data provided reports for the same.
• Involved in Code Review, Code Walk Through, and Unit Testing.

ENVIRONMENT: Oracle 12c/11g, SQL, Oracle Data Integrator (ODI), PL/SQL, UNIX, C#, .Net, Toad, TFS, shell Scripts, SQL*Loader

Confidential

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, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges on OLTP server.
• Supported Advance PL/SQL using Cursor, REF Cursor, and Native Dynamic SQL
• Backup and recovery were performed on weekly, monthly basis
• Participated in system analysis and data modeling, which included creating Tables, Views, Materialized Views, Indexes, Synonyms, Triggers, Functions, Procedures, Cursors and Packages.
• Expertise in working with Records, Collections and Dynamic SQL.
• Hands on experience of database Backups and Recovery strategies using RMAN, Export Import Utility (Classical & Data Pump) and Transportable Tablespaces
• 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.
• Performed Backup and Recovery procedures in 24x7, Windows/Linux/Solaris environments using the incremental and full back up strategies.
• Created custom ETL tools using PL/SQL procedures, functions and a QC environment with MS Access and Excel.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages. Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application
• Monitored indexes and analyzed their status for performance tuning and query optimization
• Used SQL Loader and PL/SQL scripts to load data into the system application. Loaded Data into Oracle Tables using SQL Loader.
• Technical lead and one of the developers of an APEX frontend PL/SQL backend web application called Work Queue Management (WQM) to help and manage the daily, weekly, and monthly distribution of its work. The application will save the Call Center managers and supervisors three hours a day of scheduling work.
• Strong experience in Informatica Power Center for ETL (Extraction Transformation and Loading) of data from multiple source database systems in both UNIX/Windows environments.
• Ensure proper communication to all concerned parties on status of production incidents throughout the incident life cycle, business impact and root cause analysis.
• Attend CAB calls for any change related process in production.
• 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 Arrays, Nested tables, associative arrays with INDEX BY VARCHAR2
• Optimizing PL/SQL code and SQL queries by using Explain Plan, Analyze, Indexes and Hints
• 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, MS Access, Excel, Oracle Reports 10g, SQL*Plus, SQL*Loader, TOAD, Clear Case, UNIX.

Confidential, St. Louis MO

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.
• Developing highly complex applications using Oracle 10g database as backend with expertise in design and development of Oracle PL/SQL packages and procedures.
• Involved in the design of Data-warehouse using Star-Schema methodology and converted data from various sources to oracle tables.
• Generated SQL and PL/SQL scripts to install create and drop database objects, including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms. Handled errors using Exception Handling extensively for debugging and maintainability
• Extensively used PL/SQL Developer for creating database objects, running the command scripts for inserting the configuration data items.
• Deleted obsolete/outdated backups for easy management and efficient storage utilization.
• Created SQL/UNIX script to check Reconciliation errors on daily basis.
• Provided support to offshore team to resolve the issues related AML application, Root cause Analysis.
• 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.
• Developed complex triggers in reports before/after for validation of user input on the application system.
• Responsible for back end stored procedures development using PL/SQL predefined procedures.
• Used Explain Plan and hints to tune the SQL.
• Utilized SQL*Loader to load flat files into database tables.
• Created PL/SQL based ETL process to transfer data from sources.
• Used PL/SQL developing to load data from the source table to the target table based on the business logic.
• Developed conversion programs to bring Legacy details into Oracle table using SQL*Loader, PL/SQL Package and populated data into base tables.
• Created PL/SQL blocks using Cursors, REF Cursors, Collections - Nested Table, Various Complex Triggers
• 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: Oracle 11g, SQL* Plus, UNIX Shell Scripting, PL/SQL, SQL * Loader, TOAD.