PROFESSIONAL SUMMARY:

• Over 7 yearsof programming experience as anOracle PL/SQLDeveloper in Analysis, Design and Implementation of Business Applications using teh Oracle Relational Database Management System (RDBMS).
• 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, Dynamic SQL, RecordsandPL/SQL Tables.
• Loaded Data into Oracle Tables usingSQL Loader.
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience withData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques.
• 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 concepts, ETL.
• Partitioned large Tables usingrange partition technique.
• Experience with Oracle Supplied Packages such asDBMS SQL,DBMS JOBandUTL FILE.
• CreatedPackagesandProceduresto automatically drop table indexes and create indexes for teh tables.
• Worked extensively onRef Cursor, External TablesandCollections.
• Expertise inDynamic SQL, CollectionsandException handling.
• Experience in SQLperformance tuningusing Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such asQuery Optimizer, Execution PlansandIndexes.
• Experience withPerformance Tuningfor Oracle RDBMS usingExplain PlanandHINTS.
• Experience inETLtechniques and Analysis and Reporting including hands on experience with teh Reporting tools such as Cognos.
• CreatedShell Scriptsfor invoking SQL scripts.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• I worked as a key member of its mobile website development team. My work involves using multiple programming languages such as JavaScript, HTML and CSS, and libraries like Backbone, i18n, Stripe and Parse.
• Implemented UI design using HTML and CSS.
• Provided multi-language support using i18n library.
• Developed payment gateway using Backbone, Stripe and Parse.
• Designed and built signup and login pages using HTML and JavaScript and used Parse to save user information on teh cloud.

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g, MS SQL SERVER 2000/2005/2008,DB2/UDB, Teradata, SAP Tables and MS Access.

ETL Tools: Informatica (PowerCenter 5.1/6.2/7.1/8.6.1/9.1.0, PowerMart 5.1, Power Connect/Power Exchange for SAP R/3, MainFrame and Oracle Change Data Capture (CDC), AB Initio 1.8 and SQL*Loader.

Reporting: Business ObjectsDeveloper Suite 5.1/BO XIR2, Cognos Suite, Cognos Report Net 1.1MR2, Crystal Reports, Oracle Reports 2.5

Operating Systems: UNIX (Sun Solaris, LINUX, HP UNIX, AIX), Windows NT/98/95/2000 & Windows XP

Data Modeling: Erwin 3.5.2, 4.0

Languages/Utilities: SQL, PL/SQL, Unix shell scripts,Java, XML, C and C++

Other Tools: AutoSys, Control-M, PVCS, WIN CVS, Informatica Data Quality, B2B Data Transformation, Informatica Power Exchange Informatica 9.1.0 Developer/Analyst, TPump, Fast Load

PROFESSIONAL EXPERIENCE:

Confidential, Birmingham, AL

Oracle PL/SQL Developer

Responsibilities:

• Coordinated with teh front end design team to provide them with teh necessary stored procedures and packages and teh necessary insight into teh data.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Created and modified severalUNIX shell Scriptsaccording to teh changing needs of teh project and client requirements.
• Wrote Unix Shell Scripts to process teh files on daily basis like renaming teh file, extracting date from teh file, unzipping teh file and remove teh junk characters from teh file before loading them into teh base tables.
• Involved in teh continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functions and packagesfor moving teh data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancement in teh application using TOAD.
• Createdindexes on teh tables for faster retrieval of teh data to enhance databaseperformance.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Extensively involved in usinghints to direct teh optimizerto choose an optimumquery execution plan.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• CreatedPL/SQL scriptsto extract teh data from teh operational database into simple flat text files usingUTL FILE package.
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools like Toad, PL/SQL DeveloperandSQL* plus.
• Partitionedthe fact tables andmaterialized viewsto enhance teh performance.
• Extensively usedbulk collectionin PL/SQL objects for improving teh performing.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
• Extensively used teh advanced features of PL/SQL likeRecords, Tables, Object typesandDynamic SQL.
• Handled errors usingException Handlingextensively for teh ease of debugging and displaying teh error messages in teh application.

Environment:Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP

Confidential, San Diego, CA

Oracle Developer

Responsibilities:

• Extraction of data from different flat files into Oracle Database using SQL Loader.
• Gather Business rules from teh end users dat are to be incorporated into teh system.
• Createdtechnical documentsbased on teh design documents provided by teh business.
• Worked on PL/SQL Tables, Records and Collections.
• Wrote PL SQL Procedures, Functions, and Triggers for Insert, Update and Delete transactions.
• Worked on Database Links to import/export data.
• CreatedLogical and PhysicalModels usingERWIN.
• Created Shell scripts for regular back up instance start and shut down.
• Handled errors using system defined exceptions and user defined exceptions likeINVALID NUMBER,NO DATA FOUND and PRAGMA EXCEPTION INIT.
• Worked with Bulk Collects to improve teh performance of multi-row queries.
• Worked onMaterialized viewby creating anestimated costand solved costing issues in Production release.
• Tested teh original and optimized codes thoroughly for failures before exporting to other environments.
• Developed multiple layouts in a single template to get teh desired output usingOracle BI Publisher administrator.
• Changed existing logic within teh packages for optimum performance using Oracle Hints, Explain Plans and Trace Sessions.
• Analyzed Oracle objects and created Partitions for very large tables to reduce disk contention and improve performance.
• Worked onDBMS SCHEDULERto automate jobs.
• Implementedtriggersbased on teh business rules.
• Optimizing and fine tuning theCrystal Reportsfor efficiency.
• Used ADO, ODBC for accessing and retrieving teh data from database to Crystal Reports.
• Worked on minimizing CPU overhead byTuning SQL Statements, Tuning Subprogram Invocation and Tuning computation-intensive PL/SQL Code.
• Creating and Maintaining of different levels of users with different levels of securities by creating User Roles and Privileges.

Environment:Oracle 11g, SQL Developer, UNIX Shell scripting, ETL, Oracle Enterprise Manager, HP-UNIX,ERWIN 3.5, Toad 8.0, Crystal reports 9.0, MS SQL server 2008.

Confidential, Dallas, TX

Oracle Developer/Analyst

Responsibilities:

• Developed AdvancePL/SQL packages, procedures, triggers, functions, IndexesandCollectionsto implement business logic usingSQL Navigator. Generated server sidePL/SQL scriptsfordata manipulationand validation and materialized views for remote instances.
• Created management analysis reporting usingParallel Queries, Java stored procedure, HTP Packageand WEB.SHOW DOCUMENT. Participated in change and code reviews to understand teh testing needs of teh change components. Worked on troubleshooting defects in timely manner.
• Involved in creatingUNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to makeDatabaseFaster and easier to maintain.
• Experience inDatabase Application Development, Query Optimization, Performance TuningandDBAsolutions and implementation experience incomplete System Development Life Cycle.
• UsedSQL Server SSIS toolto build high performance data integration solutions includingextraction, transformation andload packagesfordata warehousing.Extracted data from theXMLfile and loaded it into thedatabase.
• Designed and developedOracle forms & reportsgenerating up to 60 reports.
• Performed modifications on existingformas per change request and maintained it.
• UsedCrystal Reportsto track logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day. Used standard packages likeUTL FILE, DMBS SQL, and PL/SQLCollections and usedBULKBinding involved in writing database procedures, functions and packages for Front End Module.
• Used principals of Normalization to improve teh performance. Involved inETLcode usingPL/SQLin order to meet requirements for Extract, transformation, cleansing and loading of data from source to targetdata structures.
• Involved in teh continuous enhancements and fixing of production problems.Designed, implementedandtuned interfaces and batch jobs usingPL/SQL. Involved in data replication and high availability design scenarios withOracle Streams. DevelopedUNIX Shell scriptsto automate repetitivedatabase processes.

Environment: Oracle 10g/11g, PL/SQL, SQL*LOADER, Oracle Streams 10g (Replication), SQL PLUS, HTML, SQL Server SSIS, TOAD, XML, HP-UNIX shell scripting

Confidential

Oracle Developer/Analyst

Responsibilities:

• Involved in full development cycle ofPlanning, Analysis, Design, Development, TestingandImplementation.
• Designed logical and physical data models for star and snowflake schemas usingErwin.
• Wrote sequences for automatic generation of unique keys to supportprimary and foreign keyconstraints in data conversions.
• Created and modifiedSQL*Plus, PL/SQLandSQL*Loader scriptsfor data conversions.
• UpgradedOracle 9i to 10gsoftware in different environments for latest features and also tested databases.
• Developed and modifiedtriggers, packages, functionsandstored proceduresfor data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Worked onXMLalong with PL/SQL to develop and modify web forms.
• Designed Data Modeling, Design Specifications and to analyzeDependencies.
• Creatingindexeson tables to improve teh performance by eliminating teh full table scans and views for hiding teh actual tables and to eliminate teh complexity of teh large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases usingOracle Hints, for Rule based optimization.
• UsedDiscoverer 2000to provide end users easy access to data and halp in data analysis.
• Created some Custom reports and Forms for teh end users to check teh details and errors.

Environment:Oracle 10g, SQL*Plus, PL/SQL, Erwin, Oracle Designer 2000,Windows 2000, Toad.