SUMMARY:

• Over8yearsof experiencewith expertiseinData Base Design, Data ware house,Application Development andProduction Supportin Client/Server Environment usingOracle 11g/10g/9i/8.x, SQL, PL/SQL, Oracle Data Integration,AbInitioandCognos.
• Experience in all phases ofSoftware Development Life Cycle(SDLC)including analysis, specification, software and database administration, development, maintenance, testing and documentation.
• Excellent proficiency inData Extraction, Transformation andLoading, DatabaseModelingand Data ware housing tools and technologiessuch as Ab Initio, ODI and Erwin.
• Profound Knowledge inStar SchemaModeling andSnowflakeDimensional Modeling(Data Marts, Facts and Dimensions.
• Strong technical expertise in creating and maintaining database objects - Tables, Views,Materialized Views, Indexes, Sequences, Synonyms, Database Links and Database Directories.
• Extensive experience in developingPL/SQL Stored Procedures, Functions, Packages,Cursors, Collections(Nested tables and Varrays),Records, Object types and Database Triggers.
• Proficient in Oracle utilities and tools -SQL*loader, Export/Import, TOAD 8.0/8.5/9.0, SQL*plus, iSQL*plus, SQL Developer and SQL Navigator.
• Expertise in generating customizedForms and ReportsusingOracle Forms and Reports 6i/9i.
• Expertise inPerformance Tuning and Query Optimizationusing various types ofHints, Partitioning, Bulking techniques and Indexes.
• Profound experience inTuning SQL queriesusing utilities likeEXPLAIN PLAN, SQL TraceandTKPROFto improve the performance.
• Strong experience in Oracle ETL data loading techniques likeUTL FILE, SQL loader,Copy Command andExternal tablesfrom various business source environments.
• Strong knowledge ofUNIX Shell ScriptonSun Solaris 2.8/2.7andHP UNIX 12.x/11.x.andWorked onKORNShell Scripts to writemaintenance scriptfor Oracle.
• Highly motivated team player with good communication skills and excellent problem solving abilities. Would be willing to work independently or as part of a team.

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g, MS-SQL Server 7/2000, MS Access.

Scripting: SQL, PL/SQL, UNIX Shell Scripting, ASP andJava.

Languages: C, C++, COBOL, Java, HTML/DHTML, XML, PERLandT-SQL.

Reporting Tool: Business Objects,CrystalReportsAndCOGNOS8.

ETL Tool: Ab-Initio, ODI

Query Tools: TOAD, SQL Developer,SQL Navigator, SQL* Plus, iSQL * Plus

Operating Systems: HPUX, Solaris 7.0/8.0,MVS, Windows 2000/NT/XP/7/98 and UNIX. GUI: Developer 2000-Forms 6i/9i, Reports 6i/9i

Packages: Micro Soft Office Suite- MS-Word,MS-Excel,MS-Power point.

Other Tools: SQL*Loader, MS-Visio, MS Project Professional 2003, PVCSVSS, IBM Rational ClearCase, Autosys, Opalis, ESP.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

• Interacting with users to gather Business requirements andAnalyzing, Designing and Developingthe DataLoading Processand Reporting systems.
• Designed anddeveloped a huge databaseof 120tables and itsdata load processfrom flat files and alsodesigned complex functional viewsforPayrollapplication.
• Extensively usedSQL Loader, UTL FILE and External Tablemechanisms to load legacy data, feed files data and data from various sources into theOracledatabase tables.
• Designedand developed thePackages, procedures, functionsefficiently in loading, validating and cleansing the data.Also worked on creating users and roles as needed for the applications.
• Extensively usedUTL SMTPand windows blattechniquesto develop themonitoringprocesses toautomatically notifythe source systems, administrators and users throughemail alerts on missing feed files, unsuccessful job runs and load statusof scheduled load processes and backup jobs.
• ExtensivelywrotethePL/SQL and SQLprograms and Designed and developed theviews, materialized views, functions, procedures, packages, triggers and cursors.
• CreatedCursors, Collections and database triggersfor maintaining complex integrity constraints and implementing thecomplex business rules.
• Worked onPerformance tuning using thePartitioning and indexingconcepts (Local and Globalindexes on partition tables).
• Involved in the design and development ofuser interfacesand customization ofReports using ASPand as well as COGNOS.
• Involved inData Extraction, Transformation and Loading(ETL process) from Source to targetAndWorked on Windows Batch scripting,scheduling jobs and monitoring logs.
• Worked onProduction supportfor the backend database and reporting applications.
• Involved inimporting Source Tablesfrom the different databases.
• Involved inPerformance testing, User Acceptance testingof the application and participated inCode and Design Reviews, Status meetings and Walkthroughs.
• Involved in continuousenhancement, optimizationand fixing of problems.

Environment: Oracle10g/11g,PL/SQL,SQLLoader,Cognos, ODI,SQL*Plus, Windows NT 4.0/2000/XP andUNIX.

Confidential -Tampa,FL

Sr. Oracle PL/SQL Developer

Responsibilities:

• Analyzed Business Documents, Internal & External Source systems and Requirements to developEnterpriseData warehouse (Star Schema)Logical and Physical Model(Facts and Dimensions) and Business Process Model
• Worked with Business Analysts and clients, Analyzing and assessing the business specifications and designing and developing the POPS and Equifax applications.
• Involved inExtraction, Transformation and Loading(ETL) of the datafrom the Heterogeneous databases.
• Extensively usedSQL Loader and UTL FILEmethods to load thefixed length,csv and pipe delimited flat filesfrom Mainframe and DB2into the Oracle database.
• UsedUNIX Shellscripts (KORN) for Extracting and Parsing data from the files. FTP process is extensively used to send and receive the flat files.
• Developed storedprocedures,functions, packages andDB triggersextending the functionality andfor retrieving the data from the database for solving complex queries.
• Created Stored Procedures, functions and Packages inOracle 10gusingSQLandPL/SQLfor the Audit Trail usingOracle 10gas backend.
• Involved in debugging and tuning thePL/SQLcode, tuning queries, optimization for the Oracle database using Explain Plan, hints and also worked on Partition tables using Range method.
• Worked on table partitioning (Range and List) and deploying local indexing on portioned tables.
• Creating Test scripts for the generated final Reports.
• Provided the Production and Technical support the users.
• Prepared technical documentation of all modules for user level and system level maintenance.
• Created promotion scripts and documents for migrating objects from once database instance to other instances.

Environment: Oracle 10g, SQL PLUS, PL/ SQL, SQL*Loader, XML, Korn Shell Scripts, Cognos, Windows XP, MS-Excel, Solaris and HP-UX, TOAD.

Confidential - Dublin, OH

Sr. Oracle PL/SQL Developer

Responsibilities:

• Worked with Business Users to gather requirements for developing newReportsand alsoChanges in the existing Reports.
• Designed and developed Reports according to user specification. Used advancedSQLlike analytical functions, aggregate functions for mathematical and statistical calculations.
• Extensively Involved in Performance tuning and Optimization of the SQL queries.
• WroteStored Procedures, Functions,PackagesandtriggersusingPL/SQLto implement business rules and processesand alsoperformed code debugging usingTOAD
• Set up batch and production jobs throughAutopsies.
• CreatedShell scriptsto access and setup runtime environment, and to runOracle Stored Procedures, Packages
• CreatedUNIXShell Scripts to execute Oracle procedures.
• Designed processes to extract, transform, and load data to theData Mart.Andextensively used SQL*LOADERmethodto load data from flat files.
• Worked with Business Users to gather requirements for developing newReportsor Changes in the existing Reports.
• Designed and developed Reports according to user specification. Used advancedSQLlike analytical functions, aggregate functions for mathematical and statistical calculations.
• OptimizedSQLused in Reports and Files toimprove performanceto higher extent.
• Implemented Join, Expression,Aggregate, Rank, Lookup, Update Strategy, Filter and Router Transformations in Mappings.
• Extensivelyused IMPORTutility to load the exported files.
• Migrated reports from Crystal Reports Version 10 to Crystal Reports Version 11.
• Automating data loading, extraction, report generation usingUNIX shell scripting.
• Responsible for the production issues and bug fixing.

Environment: Oracle 9i, Oracle Reports 6i, SQL, PL/SQL, Erwin, TOAD, Unix,ETL,PVCS Version Manager, Exceed, Test Director.

Confidential - Oklahoma City, OK

Oracle PL/SQLDeveloper

Responsibilities:

• Involved in gathering business requirements, clarification and system design.
• Extensively workedinEnd-to-End phases of the application design, development, testing, production deployment and documentation.
• Prepared proto-types for the system design & approach and participated in business users presentations.
• Developed ComplexUNIXshell scripts and Autosysjobs for the scheduling and automation of the application jobs execution.
• Involved in Source code release to higher environments (QA, UAT and Production) using theIBM Rational ClearCase version controltool.
• DevelopedPL/SQL packages, procedures, functions, Indexes, sql scriptsfor the implementation of the very complex business requirements.
• Implemented theCOPY commandsuccessfully to insert huge amounts of data into the target system fromODS.
• Developed validation programs to validate the data before importing into the payables table.
• Designed, developed, tested and implemented using Oracle Forms using Forms 6i/9i.
• Responsible for Designing, development, testing and deployment of Oracle Alerts, Triggers and debugging for Oracle Forms.
• DevelopedPL/SQL packages and database triggersandImproved performance of the extract - loads and existing applications for huge volumes of data by optimizing the queries, indexing and redesigning some of the scripts.
• Extensivelysupportedproductionfor all the UNIX, Autosys, Oracle and Reporting issues.
• Used Cron Jobs to schedule various reports.
• Prepared test data and expected resultsfor the system testing with possible business functionalscenarios to make the system bug-free.
• Involved in tuning using EXPLAIN PLAN and used hints to tune the queries.
• SupportedBOXIreports testing and prepared expected results using complex sql queries.
• Involved inSystem testing, Performance testing, User Acceptance testingof the application and participated in Code and Design Reviews, Status meetings and walkthroughs.

Environment: Oracle10g,PL/SQL, SQL*Plus COPY, BOXI, SQL*Plus, Windows XP and UNIX, IBM Rational ClearCase.

Confidential

Database Developer

Responsibilities:

• Gained experience in C & C++ programming on UNIX for RAMINFO Applications and also developed PL/SQL Code for updating the payment terms.
• Interactingwith Business users, gathering and analyzing requirementsand Involved inunderstanding the Requirementsof the end Users/Business Analysts and DevelopedStrategies for ETL processes.
• Provided technical solutions in the form ofMDD(Minor Development Document) for the Process Change Requests from Business.
• Involved in thedesign of database schemasanddata mappingof client’s databases withDCX’s transactions databases.
• Involved inthedesign oflogicaland physical datamodeling using ERWIN Tool.And alsodesigned star schemas using dimensional modeling and created fact and dimensional tables.
• Writing complexSQL queriesandPL/SQLprocedures to extract data from various source tables of data warehouse.
• Involved inPerformance tuningand optimizationof SQL queries for data warehouse consisting of many tables with large amount of data.
• CreatedPL/SQLpackages, procedures and functions that extensively usedPL/SQLcursors, user defined object types, exception handling.
• Active involvement in Optimization Process through database capacity planning, creation of materialized views, partitions, tables, views, indexes etc as.
• Designed ETL to extract external data (Oracle, Excel file)and load data using SQL*Loader.
• Designed UML Models (Visio) and Relational data Models for applications.
• Worked onBusiness Objects(BO) to deploy various reports onto production.
• Developed ETL forData Extraction, Data MappingandData Conversionfor various application and processes.
• DevelopedUNIXShellScriptsforautomating the executionprocess.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Automating data loading, extraction, report generation usingUNIX shell scripting.
• Created aninduction manual for the ETLprocessand production support document
• Involved in preparingdocumentationand user support documents.

Environment: PL/SQL, Oracle 9i,Maestro Scheduler, ERWIN 3.5, AIX UNIX, Windows NT/2000, SQL Navigator, Windows NT/2000/.