SUMMARY:

• Oracle PL/SQL with 7+ years of experience in Design, data modelling, analysis, performance tuning.
• 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 Complex SQLs, 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 and 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 practice, 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, TOAD.
• 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.

WORK EXPERIENCE:

Confidential, San Antonio, TX.

Sr. 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, Elemental for Production Support.

Confidential, Austin, TX.

Sr. 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, Spartanburg, SC.

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, Florence, SC.

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 Analyse 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.

Confidential, Burlingame, CA.

Oracle Developer

Responsibilities:

• Analyzing the requirement specifications.
• Developed several Oracle Stored Procedures
• Generated reports for management to review for system functionality as against the old legacy reports.
• Created forms for data input.
• Wrote Form Triggers, and Program Units.
• Involved in generation of monthly status of order reports.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Identifying test execution strategy and scope and Establishing test acceptance criteria.
• Supporting the application throughout the production release life cycle.
• Documenting Business Requirements Document (BRD) and Project Initiation Review Checklist (PIR).
• Strong analytical and problem solving skills.
• Creating database objects like tables, indexes, views, packages and procedures using PL/SQL Developer.
• Participated in system analysis and data modeling.
• Worked on XML along with PL/SQL to modify/create interface between systems.

Environment: Oracle 9i, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP.