SUMMARY

• Oracle PL/SQL with 8+ years of experience in Design, data modelling, analysis, performance tuning.
• 5 years of experience working with Oracle 8i/9i/10g including PL/SQL programming
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Solid experience in translating business requirements into creation of Database Objects.
• Strong Exposure in writing Simple and ComplexSQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
• Experience in metadata modeling, development of all three layers (Physical, Business Model and Presentation).
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Having a good knowledge and experience in STAR Schema, FACT, Dimension tables,
• Experience in supporting 8 mission critical application, 10 critical application and 7 non critical applications.
• Experience working in model of Client, vendor & IT management team.
• Implemented many industry best practise, IT standards, guidelines and process.
• Extensive experience on using SQL, PL/SQL, ORACLE Database, and many other ORACLE facilities, such as Import/Export, SQL*Loader and SQL*PLUS.
• PL/SQL: Strong back - end programming experience using PL/SQL, SQL, HTML, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes - B - tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export/Import Utilities, Ad - hoc queries using SQL.
• Developed procedure / packages for OLTP, OLAP data warehousing environment.
• Good experience in Unix Cron jobs, batch processing with highly complex data model.
• Expert in monitoring query performance using OEM, TOADD.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Knowledge of architecture/technology needs of the organization based on business priorities, strategies, goals, and economic viability
• Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.
• Significant experience in 24/7 Production Environment Support.
• Knowledge on Informatica Power Center

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, C, Shell Programming (Bourne, Korn), Perl Scripting, Visual Studio.NET 2003/2005.

Databases: Oracle 8i/9i/10g/11g, MS SQL Server 2005/2008, MySQL, MS Access.

Reporting Tools: Oracle Forms & Reports 6i/9i/10g, Crystal Reports 8.0, SQL Server Reporting Services (SSRS), SSIS

Tools: TOAD 8.x/9.x, SQL Developer, PL/SQL Developer, Humming Bird 10, F-Secure 5.3, SFTP, Rational Rose, Microsoft Visio, ER-Studio, Erwin, MS Visio, BI, DWB.

DB Utilities: SQL Loader, Export / Import, Data pump, Explain Plan, TKPROF.

Operating Systems: UNIX, LINUX, Sun Solaris 5.X, Windows NT/XP/Vista/7/8.1, Windows 95/98/2000, Windows Server 2003/2008.

PROFESSIONAL EXPERIENCE

Confidential, ERIE PA

SENIOR ORACLE PL/SQL DEVELOPER

Responsibilities:

• Designed/developed/Modified tables, views, materialized view, stored procedures, packages and functions.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
• Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
• Used SQL loader to load the data from the files provided by the interfacing applications.
• Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
• Created partitioned tables and partitioned indexes to improve the performance of the applications.
• Wrote PL/SQL Database triggers to implement the business rules in the application.
• Created external tables to handle huge volumes of data which is not used frequently.
• Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
• Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL language for the top management for decision making.
• Implemented all modules logic by using Triggers and Integrity Constraints.
• Good understanding of database objects and ability to triage issues.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Created materialized views required for the application.

Environment: - -Oracle 11g, Toad, PL/SQL, Reports10g, Forms10g, Data Modeling, Data migration, SQL Navigator, Unix Shell Scripting, Window NT, AIX, FTP, SFTP, NDM, PL/SQL Developer, SQL*Loader, Version Control Software CVS, ElemenTool for Production Support.

Confidential, PITTSBURGH

SENIOR ORACLE PL/SQL DEVELOPER

Responsibilities:

• Developed stored procedures to extract the data from different sources and load it into data warehouse.
• Analyzing the data and Mapping the data requirements developing Stored Procedures, Functions and Triggers.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Maintaining daily batch cycle and providing 24 hour production support.
• Developed Korn shell scripts to kick off back end PL/SQL, SQL programs.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• Utilized SQL*Loader to load flat files into database tables.
• Created SQL*Loader scripts to load data into temporary staging tables.
• Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.
• Partitioned tables and indexes for better performance of application
• Contacting Application Team and clients to gather the information for migration. Reviewed architecture.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Involved in handling the changes in compiling scripts according to the database changes.
• Developed reports using complex queries as per client request as a part of production support.
• Provided on call support, solved the user issues and made necessary changes.
• Resolving Production severity Issues in time and meeting the SLA.
• Writing high quality and well documented code according to standards.

Environment: - Oracle 10g, SQL Server Reports 10g, SQL, PL/SQL, Toad, Oracle RDBMS,SQL Developer

Confidential, RALEIGH, NC

ORACLE PL/SQL DEVELOPER

Responsibilities:

• Support in requirements gathering from the end users
• Update design documents according to the changes made to the application
• Designed/developed/Modified tables, views, stored procedures, packages and functions.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging.
• Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
• Developed various Reports using the BI Publisher.
• Used SQL loader to load the data from the files provided by the interfacing applications.
• Created new Procedures, Functions, Triggers, Materialized Views, Packages, Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
• Created partitioned tables and partitioned indexes to improve the performance of the applications.
• Wrote PL/SQL Database triggers to implement the business rules in the application.
• Implemented all modules logic by using Triggers and Integrity Constraints.
• Good understanding of database objects and ability to triage issues.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Code SQL Stored Procedures and integrated with application
• Involve in Unit Testing for the application developed using test cases

Environment: - PL/SQL, Oracle 10g, 11g, Java, Unix shell scripting, Oracle Forms, Oracle Reports, SQL Developer, BI Publisher, Informatica Power Center, Eclipse

Confidential

ORACLE PL/SQL DEVELOPER

Responsibilities:

• Involved in the maintenance and enhancement of the application.
• Maintaining Logical and Physical structure of the database.
• Creating table spaces, tables, views, scripts for automatic operations of the database activities.
• Coded various stored procedures, packages and triggers to in corporate business logic into the application.
• Used the technical document to design the database tables.
• Data conversion from flat file to intermediate tables using SQL*Loader, Data mapping
• Created control files for SQL*Loader.
• Gather Database and User Level Statistics and Analyze Overall System Performance.
• Designed/developed tables, views, various SQL queries, stored procedures, functions.
• Monitor database and system backups, developed Oracle Stored procedures, functions, packages, and triggers that pull data for reports.
• Develop UNIX shell scripts to administer the system.
• Extensively worked with Dynamic SQL, Composite data types & Global Temporary tables.
• Responsible for purging and archiving the production databases.
• Used UTL JOB to automate the PL/SQL procedures and packages.
• Involved in Interacting with users, error fixing by enhancing PL/SQL packages, stored procedures & functions.
• Data conversion from flat file to intermediate tables using SQL*Loader and also created control files for SQL*Loader.
• Communicate issues and progress to project manager.
• Performed logical backup using export and import utilities.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Involved in Unit Testing Stored Procedures and Functions.

Environment: - PL/SQL, Oracle 10g, 11g, Java, UNIX shell scripting, Oracle Forms, Oracle Reports, SQL Developer, BI Publisher, Informatica Power Center, Eclipse