SUMMARY

• Around 6+ 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.
• Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.
• 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).
• Knowledge of database architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
• Experienced in data migration, data handling, data extract, transformation and loading for databases in distributed, cloud, data warehouses and file databases.
• Proficient in ETL Processes using Oracle PL/SQL, Unix Scripts and SQL*Loader for data migration to Enterprise Data Warehouse with large data volume.
• Experience in Data Migration across various databases as well as within the same database across different systems.
• Strong working experience in use of SDLC methodologies, standards and Gathering the Requirements, Data Analysis, Design, cleansing, Development, Implementation.
• 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.
• Good Knowledge of implement SOA & Web Center Applications using Oracle Cloud Services
• Experience working with Business Intelligence Tools and Reporting tools like Business Objects and Crystal Reports.
• 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, MYSQL, SQL*Loader, Erwin, Toad, Oracle Enterprise Manager Informatica 9x/8x

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

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

Other Tools: SQL Developer, Oracle Enterprise Manager, SQL*Plus, SQL*Loader, MS Office, JIRA, Erwin, MS Visual Studio 2007, Crystal Reports, Informatica Power Center.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK

Languages and Web Technologies: SQL, PL/SQL, XML, HTML/XHTML.

PROFESSIONAL EXPERIENCE

Confidential, Monroeville PA

Oracle PL/SQL Developer

Responsibilities:

• Analyzing the new Requirements (PCR and DBCR) and preparing the design/Tec Spec documents.
• Developed new codes for data load 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.
• Developed SQL scripts to create database objects like tables, views and sequences.
• Wrote complex PL/SQL queries and performed data analysis.
• Providing support in end to end integrations.
• Created Triggers, Stored Procedures, Packages and SQL Scripts.
• Developed SQL*loader scripts to load data in the custom tables.
• Developed PL /SQL code for updating payment terms.
• Prepared Handbooks for the application.
• Preparation and execution of test plans for unit & system testing.
• 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.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
• Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling
• Analyzing the data needs for the customized reports. Mapping the data requirements developing Stored Procedures, Functions, Views, Materialized View and Triggers.
• 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 UNIX Shell scripts to automate repetitive database processes.
• Experience in UNIX shell scripts in writing deployment code for migrations.
• Developed PL/SQL Procedures at the database level that were used in the mappings through Stored Procedure Transformation.
• Utilized SQL*Loader to load flat files database tables.
• Handled various exceptions to troubleshoot PL/SQL code.
• Formulated procedures, functions
• Optimizing and fine tuning the Crystal Reports for efficiency.
• Used ADO, ODBC for accessing and retrieving the data from database to Crystal Reports.
• Created indexed views, and appropriate indexes to reduce the running time for complex queries
• 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.
• Used ETL to load the data from various sources in to CDW.
• 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), Crystal Reports 11, PL/SQL, UNIX, C#, .Net, Toad, TFS, shell Scripts, SQL*Loader

Confidential, Reston, VA

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.
• 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.
• Designed and developed reports using Crystal Reports XI version.
• Created Crystal Reports using Crystal Reports formulae, Grouping, Parameters, Selection criteria.
• Extensively used PLSQL tables and Bulk loader utility for processing data and loading into oracle tables.
• 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
• Data migration (import & export - BCP) from Text to SQL Server
• Built and maintained SQL Scripts, Indexes, reports and queries for data analysis and extraction.
• Generated reports for inactive and active clients, inactive and active accounts and various transactions for different client types using crystal reports
• Involved in analysis, design and coding of Oracle processes in PL/SQL to built packages.
• Validated and loaded data into Oracle Database using DB links and external tables from CSV files for Merge Case, Person, and Provider Use Cases.
• Created Tables, Views, Materialized views, and constraints.
• Develop PL/SQL code for designing the reports mapping each report to its own package.
• Used Clear case for version controlling and Clear Quest for ticketing system.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• 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, Crystal Reports, Excel, SQL*Plus, SQL*Loader, TOAD, Clear Case, UNIX.

Confidential

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 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.
• Designed the Oracle Partition strategies, Exchange Partitions, Performance tuning and data analysis, Data optimization, scrubbing and manipulation of staged data using PL/SQL packages.
• Extensively used PL/SQL Developer for creating database objects, running the command scripts for inserting the configuration data items.
• 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 PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Developed data model, SQL Queries, SQL Query tuning process and Star Schemas.
• Used PL/SQL tables, pragma autonomous transaction to avoid mutating problem in database trigger.
• Suggested and Implemented indexes for faster retrieval of data in Weekly and Monthly Metrics reports.
• Created records, tables, collections (nested tables and Varrays) for improving performance by reducing context switching.
• Involve in the backup database, data migration, restoration and recovery
• Worked on data conversion, loaded data from different Sources into the Temp data backup environment using SQL Loader and validated the data before loading it into oracle tables.
• Optimizing PL/SQL code and SQL queries using Explain Plan, Indexes and Hints.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Involved in fixing the bugs while using different versions of crystal reports and work station issues.
• Configured packages using Package configuration wizard to allow package run on different environments.
• 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
• 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/10g, Crystal Reports, SQL* Plus, UNIX Shell Scripting, PL/SQL, SQL * Loader, TOAD.