PROFILE SUMMARY

• Over 8 yearsof programming experience as Oracle PL/SQL Developer.
• Expertise in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Extensive experience in Software Development Life Cycle (SDLC) using Waterfall Model, Rational Unified Processing (RUP), Agile (SCRUM) and CMM methodologies.
• Experience designing Entity Relationship - ER Diagrams,Data flow diagrams, Data dictionary, Database normalization andstandardization.
• Expertise in Client-Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADand SQL*LOADER.
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-WriteandTransportable table spaces.
• Strong experience inData warehouse and Extract Transform Load (ETL) processes.
• Good knowledge on logical and physicalData Modelingusingnormalizing Techniques.
• CreatedTables, Views, Constraints, Index(B Tree, Bitmap and Function Based).
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developedmaterialized viewsfor data replication in distributed environments.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling forOLTPand dimension modeling forOLAP.
• Experience inOracle supplied packages (UTL FILE, DBMS SZCHEDULER, DBMS SQL), Dynamic SQL, RecordsandPL/SQL Tables.
• Loaded Data into Oracle Tables usingSQL Loader and External Tables.
• Partitioned large Tables usingrange/list/hash partitions.
• Worked extensively onRef Cursor, External TablesandCollections.
• Expertise inDynamic SQL, CollectionsandException handling.
• Experience in SQLperformance tuningusing Explain Plan and TKPROF for Cost-Based Optimization (CBO). Used Optimizer Hints and created new indexes.
• Good knowledge of key Oracle performance related features such asQuery Optimizer, Execution PlansandIndexes.
• Experience inETLtechniques and Analysis and Reporting including hands on experience with the Reporting tools including Cognos.
• CreatedUNIX Confidential and PERL Scriptsfor invoking SQL scripts and scheduled them using crontab.
• Experience with defect tracking and analysis using different defect tracking tools such asTeam Foundation Server (TFS) and Quality Center (QC).
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Databases: Oracle 11g/10g

Oracle Tools: TOAD, SQL Developer, SQL*PLUS, Oracle Procedure Builder, Oracle Enterprise Manager

ETL Tools: SQL*Loader, Datastage, Informatica

Reporting: Oracle Reports

Languages: SQL, PL/SQL, Unix Confidential Programming, R

Version Control: CVS, HARVEST, Subversion, Red Gate

Other Tools & Packages: VMware, IBM Rational Rose Memory Detection Tool, Rational Rose UML, Cognos, WebFocus, QTP, Win Cap, Adobe, Dreamweaver, MS Office

Operating Systems: Windows 8 / 7 / XP, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Little Rock, AR

Sr. Oracle Developer

Responsibilities:

• Coordinated with the Business Analyst and End users to gather requirements.
• Design and develop Technical Design document, Data Flow diagrams.
• Built PL/SQL Programs translating business requirements into PL/SQL Packages.
• Worked onSQL*Loaderto Load data from flat files obtained from various facilities every day.
• Created and modified severalUNIX Confidential Scriptsaccording to the changing needs of the project and client requirements.
• Wrote Unix Confidential Scripts and PERL Scripts to process the daily files like archiving the file, extracting date from the file, unzipping the file and remove the invalid characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• DevelopedAdvanced PL/SQL programs using DBMS SQL Dynamic queries, External Tables, Global Temporary Tables, Analytical Functions etc.
• Created PL/SQLstored procedures, functions and packagesfor ETL processes to populated d Data warehouse and for moving the data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application.
• Query and Performance Tuning using Explain Plan and Trace file/TKPROF. Rewrite queries and createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Involved in data loading usingUTL FILE in PL/SQL, External TablesandSQL*Loader.
• Wrote UNIX and PERL scripts to download and manipulate files.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Experience in usingoptimizer hints to choose an optimumquery execution plan.
• UsedBulk Collect/Bulk Inserts/Bulk Updatesforbetter performanceand faster retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Involved inETLcode usingPL/SQLin order to meet requirements for Extract, transformation, cleansing and loading of data from source to targetdata structures.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILE package.
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle development tools like Toad, PL/SQL DeveloperandSQL* plus.
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• UtilizedPL/SQL records, PL/SQL tables, collections(nested tables and arrays) for bulk data processing and handling.
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL likePL/SQL Records, PL/SQL Tables, Object typesandDynamic SQL.
• Experience inTest First Development and Agile software development methodology.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle Exadata/11g, SQL, PL/SQL, Linux, Confidential scripts, Perl, Subversion (SVN), Autosys, NDM, IBM MQ, ADG, Golden Gate, SQL Developer, TOAD, PAC2000

Confidential, Fayetteville, AR

Sr. Oracle Developer

Responsibilities:

• Analyzed Business requirements and built corresponding technical design documents
• Developed AdvancedPL/SQL packages, procedures, triggers, functions, andcollectionsto implement business logic usingSQL Navigator.
• Generated server sidePL/SQL scriptsfordata manipulationand validation leveraging materialized views for remote database instances.
• Involved in creatingUNIX Confidential scripting for Batch processing and FTP files.
• Involved in table redesigning with implementation of Partitions Table and Partition Indexes to makeDatabaseFaster and easier to maintain.
• Experience inDatabase Application Development, Query Optimization, PerformanceTuning andDBAsolutions and implementation experience incomplete System Development Life Cycle.
• Designed and developedGUI screens in Oracle Developer Suite - Forms & Reports.
• Performed modifications on existingformas per change request and maintained it.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day. Used standard packages likeUTL FILE, DMBS SQL, and PL/SQLCollections -BULKBinding involved in writing database procedures, functions and packages for Front End GUI.
• Carried out performance tuning, SQL Query optimization and re-write queries. Used Explain Plan and TKPROF.
• Involved in the continuous Production support and enhancements and fixing of production issues.
• Designed, implementedandtuned interfaces and batch jobs usingPL/SQL.
• DevelopedUNIX Confidential scriptsto automate repetitivedatabase processes.

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL Developer, Apex, Linux, Confidential scripts

Confidential, Memphis,

Database Analyst

Responsibilities:

• Responsible for system analysis, development, documentation and unit testing.
• Developed and modified PL/SQL code for new enhancements and resolved known issues, as per business requirements.
• Enhanced database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges by incorporating business standards throughout the files.
• Database Tuning/TKPROF & Application SQL Tuning with stats collection.
• Extensively used SQL*LOADER and EXTERNAL TABLES to load data from flat files obtained from sources.
• Used collections (PL/SQL tables, v-array, and nested tables) for reading (bulk-collect) and adding / updating (FORALL operations) of data into the database.
• Used standard packages like UTL FILE, DMBS SQL, PL/SQL Collections, and used BULK Binding. Involved in writing database procedures, functions and packages for application.
• Developed UNIX Confidential Scripts to FTP the data to Oracle Clusters and automate routine processes.
• For the purpose of backend analysis, developed anonymous blocks in PL/SQL to resolve data issues.
• Provided production support and maintained data.
• Participated in change and code reviews to understand the testing needs of the change components. Working on troubleshooting defects in timely manner.

Environment: Oracle 11g, SQL, PL/SQL, SQL Developer, Apex, Red Gate

Confidential, Houston, TX

Oracle PL/SQL Developer

Responsibilities:

• Developed data validation, load processes using PL/SQL, Stored Procedures, Functions and Triggers.
• Used TKPROF and Explain Plan for Optimization.
• Wrote complex PL/SQL subprograms, packages, procedures, functions and DB triggers using Toad to implement the business logic.
• Used data Normalization techniques.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Created Control Files and used SQL* Loader to upload bulk data.
• Design automated interfaces using UNIX and PERL scripts to transform and load data.
• Troubleshooting the errors that occurred when the production and testers hit a roadblock.
• Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing, and loading of data from source to target data structures using Datastage tool.
• Involved in migrating database from oracle 9i to 10g database.

Environment: Oracle RDBMS 9i/10g, TOAD, PL/SQL Developer, PL/SQL, Erwin, Oracle Forms and Reports 9i, SQL Scripting, Perl, UNIX Scripting.

Confidential

Sr. Oracle Developer

Responsibilities:

• Actively involved in Analysis, Design of the application, and developed the logic in the oracle backend with normalization concepts.
• Developed stored Procedures, Functions, and Packages as per business requirements and was involved with the tuning, performance, optimization of queries and standardization of the code.
• Involved in creating System documentation such as Technical Specification, Unit Test Plan, System Flow Diagram and Data Flow Diagram using MS-Word, Visio.
• Wrote SQL scripts for creating tables, Indexes, Grants and Synonyms in different schemas and made modifications for the existing tables as per business logic.
• Developed UNIX Confidential Scripts and PL/SQL procedures to automate the routine tasks and to extract and load data for month-end batch processing.
• Tuning SQL queries in order to increase the performance related issues of the existing database procedures and functions using Explain Plan & TKPROF.
• Created PL/SQL procedures using REF Cursors, used in developing reports.
• Used SQL* Loader and PL/SQL stored procedures for data conversion processes.
• Designed database structures for effective data extraction, validation and error logging.
• Developed UNIX Confidential scripts to automate load process, scheduling batch jobs and loading data into the Database using SQL* Loader.
• Used CVS for code versioning, branching and merging.
• Responsible in Production Deployment, Production Planning and Production support Preparing System Documentation and User Documentation for the future reference.
• Provided production support and maintained data.

Environment: Oracle 10g, PL/SQL, PowerBuilder, Informatica, SQL PLUS, TOAD, SQL Navigator, SQL* Loader, Confidential Scripting, UNIX, CVS