SUMMARY

• To obtain a contractual/full time position as an Oracle PL SQL / ETL / Database Developerwhere skills obtained from work and professional work can be utilizedHighlights
• OverallTwelveYearsof experience inInformation Technology
• Experienced Software developer in the design and development of high quality business applications using Oracle technologies
• Eight years extensive experience in Oracle PL/SQL development (Packages, Stored Procedures, Functions and Triggers) in accordance with coding standards
• TwoYears’ experience inDatabase AdministrationwithOracle and SQL Server
• One Yearexperience inData ModelingandSystem Designing
• Worked on projects involvingSystem Studies, Analysis, Design, Coding, Debugging, Testing and ImplementationofBusiness ApplicationSoftware
• Expertise in usingStored Procedures, Triggers, Constraints, Oracle Packages, Shell Scripting, MS Access, MS Office, MS Visio, VBScriptandCrystal Reports
• Proficient inDatabases Conversions, Migration Application Tuning, Security Backup, Restore, Indexes, ETL, Portal, Oracle Application Server 9iAS, Oracle, Teradata, UNIX, LINUX, SQL Loader, TOAD, FTP, Data warehouse, Version Control Tools, Tortoise SVNandEnd - User support
• Excellent experience in Tuning, Performance and Optimization of queries.
• Extensive experience working on Waterfall and an Agile development environment.
• Extensive experience in high volume of data processing and fast paced database environments
• Worked in close cooperation with project managers and other team members
• Installation, configuration and deploymentexperience ofOracle10g and10g Application Server
• Worked independently and part of a group, to deliver under pressure and tight schedules
• ExcellentProblem Solver, Committed to Work, Good Team Player and Target Oriented

TECHNICAL SKILLS

Databases: Oracle RDBMS 12c, 11g, 10g, 9i, 8i, 8x, 7x, 6x and SQL Server 6x, 7x, 2000

Designing Tools: Designer 2000, Erwin, ER Studio, Toad Data Analyst

Development Tools: Developer 11g, 6i, APEX, IDS 9i, Discoverer, Designer 2000, Visual Basic

Languages: COBOL, RPG, FoxPro, HTML, ASP, JAVA, SQL, PL/SQL

Operating Systems: HP UNIX, LINUX, AIX, SUN Solaris, Windows NT, Windows 2000

Hardware: IBM RISC System 6000, SUN Solaris, HP, Compaq

Character Tools: SQL PLUS, Server Manager, RMAN, SQL Loader, Export/Import, Partitioning

GUI Tools: Oracle Enterprise Manager, SQL Server Enterprise Manager, Data Stage, Crystal Report, Microsoft Project, Erwin, DB Artisan, Quest Software, Toad and Humming Bird, SDLC

PROFESSIONAL EXPERIENCE

Confidential, Wilmington Delaware, USA

Sr. Application Developer

Responsibilities:

• Involved in database development by creating Oracle PL/SQL Packages, Stored Procedures, Functions and Database Triggers
• Rewrite lot of applications code to improve the performance of the query
• Involved in writing PL/SQL coding to generate notifications and case notes as part of the application development
• Involved to create Concurrent jobs through Oracle Concurrent Manager and make schedules
• Involved to tune Discoverer Reports. Use SQL Developer and Teradata for database coding, design, changes, generate new queries, format and tune the SQL
• Generate APEX Forms and Reports on different web applications
• Used Tortoise SVNfor version control and Black Duck for code scanning
• Involved in writingcomplex queriesto generatead-hoc reportsas per client request as a part of production support
• Extensively used the advanced features of PL/SQL likeAnalytical functions, Performance hints, Subtypes, PLSQL Records, PLSQL Tables, Bulk CollectandDynamic SQL
• Involved inTuning, Performance,Optimization of queriesandstandardizationof the code
• Involved in designing thelogical and physical modelof database objects using Toad
• Extensively used PL/SQL tables, cursors and exception handling
• Created high level detailed design documents. Involved in Gathered Requirements Technical Documentation, Unit testing and Integration Testing
• Involved in production support and On-call

Environment: Oracle Ver. 11g, UNIX Servers, Windows environment, PL/SQL, SQL Developer, Toad, Discoverer Reports, Oracle Concurrent Manger etc.

Confidential, USA

Sr. Oracle Developer

Responsibilities:

• Involve to develop new module and maintain existing modules of Offender management system application
• Responsible for coding and maintaining PL/SQL packages, procedures, and function constructs to support the functionality behind numerous processes
• Rewrite applications code to improve the performance of the queries
• Use TOAD for database design, changes, generate new queries, format and tune the SQL
• Involved in writingcomplex queriesto generatead-hoc reportsas per client request as a part of production support
• Involved in writing PL/SQL coding to generate notifications and case notes as part of the application development
• Involved in conversion of data from one platformto another platform
• Responsible for maintaining and implementing Development Standards
• Using advance features of PL/SQL like Analytical functions, Performance hints, Collections / Varrays Subtypes, PLSQL Records, PLSQL Tables, Object types and Dynamic SQL
• Involved in theanalysis, design, development, customization, testing and implementationof the system

Environment: Oracle 11g, Toad, Oracle FormsV5, Oracle Developer Suit 10g, 10g Application Server, SQL, PL/SQL, Oracle Database 10g, WebUtil, J2EE, Jar Files, Windows XP, LINUX

Confidential, Wilmington Delaware

Sr. ETL Developer

Responsibilities:

• Involved in load data from File to Stage and different layers like Source, ODS, ADS and DMA and finally to main legacy data warehouse to support different lines of business
• Involved in database development by creating Oracle PL/SQL Packages, Stored Procedures, Functions and Database Triggers
• Rewrite lot of applications code to improve the performance of the query
• Extensive Knowledge and working of Bulk Collect for data retrieval and data loading
• Create and maintain Shell scripts to run Oracle Stored Procedures and Packages
• Use TOAD for database design, changes, generate new queries, format and tune the SQL
• Workedwith Parallel Extender forParallel Processingto improve job performance while working withbulk datasources.
• Involved in writingcomplex queriesto generatead-hoc reportsas per client request as a part of production support
• Extensively used the advanced features of PL/SQL likeAnalytical functions, Performance hints, Subtypes, PLSQL Records, PLSQL Tables, Bulk CollectandDynamic SQL
• Involved inTuning, Performance,Optimization of queriesandstandardizationof the code
• Involved in designing thelogical and physical modelof database objects using Toad
• Extensively used PL/SQL tables, cursors and exception handling
• Created database links to access data from remote databases.
• Involved in conversion of data from one platformto another platform
• Created high level detailed design documents. Involved in Gathered Requirements Technical Documentation, Unit testing and Integration Testing
• Involved in production support and On-call

Confidential, USA

Sr. Oracle Developer

Responsibilities:

• Develop and use server coded objects like storedProcedures, Functions, Packages and Database triggers
• Generate new queries,reports and regenerate the graphs
• Involved in designing thelogical and physical modelof database objects using Toad and Oracle Designer.
• Normalizationof the Data Models for the applications
• Rewrite lot of applications code to improve the performance of the query
• Use TOAD for database design, changes, generate new queries, format and tune the SQL
• Involve Oracle web development tools, functional design, coding, testing and documentation
• Involvedin the process of migration from Oracle Forms 5 and Reports toOracle Developer Suit 10gbeing upgraded to be web deployed J2EE using Oracle 10gAS as part of the Oracle 10g Conversion projecton the LINUX environment
• Involved in writingcomplex queriesto generatead-hoc reportsas per client request as a part of production support
• Involved in conversion of data from one platformto another platform
• Used Database trigger for makinghistoryof insertion, updating andall kind ofAudit routines
• Responsible for maintaining and implementing Development Standards
• Involved in theanalysis, design, development, customization, testing and implementationof the system

Environment: Oracle 10g, Toad, Oracle FormsV5, Oracle Developer Suit 10g, 10g Application Server, SQL, PL/SQL, Oracle Database 10g, WebUtil, J2EE, Jar Files, Windows XP, LINUX

Confidential

Oracle Developer

Responsibilities:

• This application developed on Oracle 8i database with Developer 2000 Version 6i
• My job responsibility was being upgraded to be web deployed J2EE using Oracle 10gAS as part of the Oracle 10g Conversion project
• Designed and developed server coded objects like storedprocedures, packages, triggersextensively using advanced features and thus incorporating the advanced functionality
• Involved in the conversion of over150 Reportsand45 Formsusing Oracle Developer 2000
• I had led the upgrade process of Oracle Forms and Reports Version 6i to10g including the setup of the Oracle 10g Application Server and Oracle HTML DB V1.6 on Oracle Development Environment

Environment: Developer 2000 V6i, Oracle Developer Suit 10g, 10g Application server, SQL, PL/SQL, Oracle RDBMS V9i, Toad, OLE, WebUtil, J2EE, Jar Files, Windows 2000, Windows XP

Confidential

Oracle Database Developer

Responsibilities:

• Responsible for understanding the customer requirementanalysis, design, developmentandimplementationof the system
• Involved in designing thelogical and physical modelof database objects using ER-Win
• Normalizationof the Data Models for the applications
• Involved inMigration of Databasesfrom One version to another version
• Worked withOracle Enterprise Manager, ToadandDB Artisan
• Designed and developedstored procedures/packages/triggers
• Involved in performance fine-tuning of the queries/report usingPL/SQL and SQL Plus
• Involved in writingcomplex queriesto generatead-hoc reportsas per client request as a part of production support
• Workedwith Parallel Extender forParallel Processingto improve job performance while working withbulk datasources. Worked with most ofthe parallel stages applying different partitioning techniques.
• Extensively used the advanced features of PL/SQL likeSubtypes, Records, Tables, Object typesandDynamic SQL
• Involved in the design and development of Forms and Reports using Developer2000
• Created Form through Developer 2000templatesas for Form design usingVisual attributes, Property Classes, Alters, Messages, Object groups and Tool bars

Environment: Developer 2000 V6i, Discoverer, SQL, PL/SQL, Oracle RDBMS V9i, Designer 2000, Oracle Enterprise Manager, Management Server, Oracle Tuning Pack, Toad, UNIX, Windows 2000

Confidential . Toronto, ON

Oracle Developer

Responsibilities:

• Actively involve inAnalysis and DesignusingDeveloper 2000 V6i, Oracle RDBMS 9iandDesigner 2000
• Involved in thenormalization of the Data Modelsfor the application
• Designing and developing customizedOracle Forms and Oracle Reportsfor Client/Server environment
• Creation ofPL/SQL Functions, Cursors, Packages, Stored procedures. Database triggers
• Involve inTuning, Performance,Optimization of queriesandstandardizationof the code
• Responsible for providing connectivity usingTCP/IP, SQL Net
• UsedPL/SQL tableto avoid mutating problem in database trigger
• Used Database trigger for makinghistoryof insertion, updating andall kind ofAudit routines
• Involved in performancefine-tuningof thequeries/reportsusing PL/SQL and SQL Plus
• Migrated datafrom Text file to ORACLE database
• Created stored sub programs withDynamic SQLat both Client and Server side

Environment: Developer 2000 V6i, Discoverer, SQL, PL/SQL, Oracle RDBMS V9i, Designer 2000, Oracle Enterprise Manager, Management Server, Oracle Tuning Pack, Toad, UNIX, Windows 2000

Confidential

Oracle DBA

Responsibilities:

• Databasemigrated from Oracle7 to Oracle8i on HP/UNIX. The migration on HP/UNIX included Converting of word-size and testing 64-bit release and applied patch 8.1.7.5.0
• Worked withOracle Enterprise Manager, Oracle Management Server and NET 8 Admin
• Optimized queriestime with aggregated,partitionedand de-normalized to star and snowflake data-marts,materialized viewsand indexes.
• IntroducedOracle partitioning optionin the project, which brought about a dramatic performance boost
• Streamlined Oracle RDBMS management using software that includes Enterprise Manager Console with Performance, Tuning,Quest Software, Toad, DB Artisan and Humming Bird
• Upgraded Enterprise Manager to 2.2 withFAT and THIN client support using Apache Server
• Trouble shooting / problem solvingin Oracle Server or Client as needed
• Createdmaterialized views, Analyzed Query Plans, Partitioning and Indexingto increase the speed of queries.
• Responsible for Data conversion usingSQL*Loader
• UsedRMANfor Backup and Recovery
• Installed and configured Omniback on HP-UX platform for Oracle database backup/restore
• Worked onPeopleSoft and G.I.S.that involves Oracle databases withpartition cartridge

Environment: Oracle V8i/V8/V7.3, HP-UX (V10.20 and V11.0), Windows NT, OmniBack, Exceed, PL/SQL, Windows 98, Oracle Enterprise Manager with Diagnostic and Tuning Pack, Oracle Management Server, Recovery Manager, Toad and DB Artisan

Confidential, Toronto, ON

Oracle Database Developer

Responsibilities:

• Studied the business requirements and was involved in designing the conceptualData Model, Entity - RelationshipData Model using Erwin
• Designed the application model, created the Data Flow Diagrams and Module designs
• Designed and developed server coded objects like storedprocedures/packages/triggersextensively using advanced features and thusincorporating the advanced functionality
• Involved in thedesign and developmentof Oracle Forms and Reports using Developer 2000
• Created Forms with Developer 2000templatesas for Form design usingVisual attributes, Property Classes, Alters, Messages, Object groups and Tool bars
• Tuned frequently usedSQL Statements and PL/SQL Blocksusing Tuning Pack
• Designed, wrote and supported 2 applications, a complete Membership management system (over 8,000 members) and a Conference registration tracking system inMSAccess 2000.Includes reports which integrate withMS Word 2000and using Contact data fromMS Outlook 2000.
• Involved intrainingcustomers on front-end application of the system.

Environment: Oracle Developer 6i/6x, Discoverer, VB, VBScript, MS Access,Oracle 8i/8x Databases, SQL Server,SQL, PL/SQL, JAVA, Toad, Windows NT, Windows 98

Confidential

Oracle Developer/Junior DBA

Responsibilities:

• Involved in theanalysis, design, development, customization, testing and implementationof the system
• DevelopedLogical and Physical modeling of databaseobjects usingER-Win
• Responsible for coding for call routines for Reports as well as Forms using menu module of Developer 2000
• DevelopedDatabase Packagesfor Complex monthly application processes
• Involved in the generation of over 50MIS reportsusing Reports 3.0/2.5
• Developed an integrated interface to connect data submitted from the web intoMS SQL Server 2000, usingMS Accessfor administrative data entry, then export accounting-related data intoPeachtree Accounting
• Developed a Service Request, Payroll and Invoicing application using their wide-area network inMS AccessandMS SQL Server 2000
• Helped team members in writing efficientstored procedures/ packages/ triggersand gave solutions to their problems in software development activities

Environment: Developer 2000 V2, MS ACCESS, MS SQL Server, Forms 4.5/5.0, Report 3.0/2.5, PL/SQL, SQL*Loader, Oracle 8.0/7.3, Erwin, UNIX, Windows NT