Over 15 years of experience in the fields of Computer Software Design, Database Administration/Application Administration, Development Forms/Reports/PLSQL , Re-Engineering, Data Warehouse, Data Conversion, Data Modeling, Testing and Integration. Database Architect, who possesses good knowledge of Financial and Business Applications/Administration. Skilled at all phases of information systems management and Administration. Good understanding of Data warehousing concepts and handled massive amount of data in a Large Database environment. Experience handling VERY LARGE DATABASES from DBA as well as Developers perspective through innovative ideas.

TECHNICAL SKILLS

• Hardware: HP Superdome, NCR Tower Mini , Altos Mini , Novell Netware, Unisys Mini , Wang Mini , Data General Mini , Sun , IBM
• Operating Systems: Unix, HP Unix Superdome, IBM AIX, SCO, AT T: RedHat Linux, Caldera Linux, Centos Linux, DOS, Windows
• Languages: Oracle Database 11gR2/10g/9i/8i, 7.3 - 7.0, Oracle Dev Suite 10g: Forms 10/9/ 6i/5.0/4.5, PL/SQL, Reports 10/9/6i/3.0/2.5, SQR with Oracle, TKPROF, DBVERIFY , Oracle 10g Grid Control/OEM, RMAN with catalog , Oracle DataGuard, Performance tuning, Database Upgrade 10g to 11gR2, 9.2 to 10gR2 and 10g R1 to 10g R2, Oracle Disaster Recovery, RAC Oracle GI-Grid Infrastructure 11gR2 RAC ASM , Virtualization, Vmware, Virtualbox . Source Control: TORTOIS
• Oracle Application E-Business Suite-Financial R12 11.5.10, CU-Consolidated Upgrade, HR, Supply Chain, Application Object Library
• Other Tools Lang. Sql-Developer, TOAD, SQL Navigator, Shell Scripting, Perl, ERWIN Data Modeling tool , JBuilder, JavaScript, HTML, PHP, MYSQL, Apache Web Server on Linux , PeopleSoft HRMS/PR/BENEFITS , SQL Server 7.0, Java SE 1.3 good understanding of general concept of Java, RMI, Servlet, JDBC, JDBC-Drivers, Interbase's Drivers, Interfaces, Classes, Object Serialization, Applets , Java J2ME , Oracle Web/Application Server AS10g,9iAS , Developed stored procedures for Web Application under Oracle Web Server environment XML Com, XPath, DTD , Nokia WML Sdk wireless , PHP, MYSQL one project only , SQL SERVER Administration, SSIS, T-SQL, Visio.

PROFESSIONAL EXPERIENCE

Confidential

Sr.Oracle DBA Platform: Oracle 12c, 11g-R2 ,10G. IBM AIX, oracle on window as well

• Playing a lead role to mitigate various oracle Production/Dev. supports request. Thorough experience of RMAN backup and recovery. Help Develpers in their PL/SQL code for enhancements. Can write complex queries to verify data.
• MHS using various vendor applications to run their day to day hospital and finance related tasks, Oracle is one of the underlying databases that I support.
• LAWSON ERP DATABASE is the core database that I am responsible with as well. I am the only in-house ORACLE DBA. Created new and maintaining existing Materialized Views for immediate replication.
• I was also involved in couple of database Upgrades, and fresh installation of ORACLE SOFTWARES on Unix in.
• Supporting Logical DataGuard and whenever DataGuard is not up to the speed with production, investigated the reason and fixed it. Archivelog gaps etc were monitored by UNIX SHELL SCRIPTS.
• Fresh Oracle Software installations and several of Oracle Client installations have also been completed. Since there's a significant amount of users using crystal report and can connect to the oracle databases therefore ODBC configuration etc frequently needed . Provisioned ASM base Filesytem as well as filesystem based datafiles.

Confidential

Sr.Oracle APPS DBA Platform: Oracle 11g-R2, EBS R12, TOAD, SQL-Developer, SUN SPARC

• TVA was implementing a new Oracle Application module named iExpense for 3000 simultaneous users. Most of the activity involved in was Oracle Application cloning with Load Balancer. There were 10 different databases for which every month we have to arrange 3 clones to support various kinds of development and QA activities for 2TB transactional database. Involved at the tail end of the project, since more cloning was needed.
• Heavy use of RMAN backup and Restore for the EBS Ebusiness cloning. Also involved in EBS patching.
• Veritas cluster is being used to support High Availability environment. Performing all the other day to day DBA duties. Support fail-over of concurrent manager, using complex symbolic link, which infrastructure team devised over the period of time.
• Involved in Code enhancement by using PL/SQL for various INTERFACES sending data from E-BUSINESS ERP to other applications.

Confidential

Sr.Oracle DBA/Database Architect

• While performing as a DBA, performed backup/restore, cloning, installation of software, and writing shell scripts. Quickly moved to the Database Architect role, so high profile projects can be put in production.
• Platform:Oracle 11Gr2, AIX Unix, 12c OEM, TOAD, SQL-Developer, Dataguard
• Senior Database Administration role to support upward of 5TB Data Warehouse/Master Data Management MDM Health Care domain application.
• A good sized Data Warehouse team offshore and onshore needed DBA support, development issue resolution, and solving repetitive failing jobs.
• Toad and OEM 12c AWR/ADDM cloud tools are used to monitor various database issues. Spot Light monitoring tool was evaluated, installed, and then discontinued. Some of our Reports are produced through DATAGUARD reporting database . DataPump was used to transfer Billions of rows, then moved dump file between the machine, while these tables at source owned by one schema and in another machine will be populated into different schema, while also dealing with PHI and HIPP restricted zone on various machine.
• To achieve various kinds of optimization, Advanced Compression is adopted for direct load path, and various other suggestion were made made like parallel Processing, Table Partitioning and Collection Type etc.
• 500 Million to 1 Billion records table posed a daunting task for various kind of queries and other kinds of data manipulation. Partition technology is used in a calibrated manner to take advantage of it in the best possible way. Powerful hardware can insert 25 million rows in one hour. There were tables in the database with 42 indexes on a single table. SPM is used for freezing the desired sql plan.
• INFORMATICA processes that run for an extended period of time, 10-12 hours, and triggered ORA-01555 errors , while in other scenarios temp spaces ran out for certain queries, and other issues were analyzed and suggestion were made to resolve.
• Coordinated with Unix, Storage, and Network team to evaluate performance bottlenecks on high profile processes. Coordinated to allocate more CPU powers to certain applications running on AIX stack.

Confidential

Sr.Oracle DBA/Database Architect

• Supported Oracle Databases with EBusiness. APPS/EBusiness database, Accounts Payable AP , Accounts Receivable AR , and General Ledger GL modules configured and used by the business .
• Linux OEL 5.7, 11g/10g Databases, As10g, Forms/Reports, EBUSINESS 11.5.10 CU2, Virtualization
• Orange Lake Resort had a project to move Oracle databases and Oracle Application Servers OC4J Container and configuration on newer hardware plus far newer OS, in addition to their very important ready-made mortgage related application named DAYBREAK /i-FLEX owned by ORACLE Corporation.
• For database migration, as Lead DBA, understood the integration of DAYBREAK application, and developed the plan to finally complete the Oracle Database Migration on the newer Hardware with far newer version of Linux OEL 5.7. Fresh Installation of the Oracle Databases were done, and brought that installation to the required patch level as the source machine, and then migration, testing, building, development boxes were done. Further several patches were applied on the Oracle Application Servers also to make it JAVA 6 compliant.
• Installed 11gr2 RAC. 11gr2 RAC to RAC cloning, created various RAC related services for load balancing purposes, so individual node can be assigned to groups departments as their primary database instance.
• A more sophisticated DATABASE backup system was developed from ground up full database backup through RMAN with Catalog. This state of the art backup that was designed in a such a manner that without any human interference , 3 days of RMAN backup will stay on the respective machine and then any backup older than 3 days will be deleted automatically, while every night these backup files will be copied to the TAPE. This state of the art backup was developed, by using ORACLE RMAN, Unix Shell Scripts, and Perl. That backup model will be rolled out onto the other databases.
• Database Cloning was done, maintaining 6 environments for each application. At the same time keeping Application Server 10g in sync with the production.
• Grid Control was used to receive alerts and managing the ORACLE databases on day-to-day basis, in addition to the CLIENT/SERVER version of ORACLE ADMIN TOOLS.
• Mentored Oracle PL/SQL Developer in how to write optimized code and tuning the code for the performance. Further some of the Distributed queries were optimized after rewriting PL/SQL code.
• Cleanup database links, going from one database to 2nd database, and from the 2nd databases to the 3rd databases, because of these intricacies, some time it was hard to find the root cause of the link not working.
• Worked with Unix admin regarding RPM of Linux platform, as various versions of Oracle Databases and Application Server installations needed very specific version of RPM.
• DATA-PUMP used for moving schema around the databases.
• Involved in PCI and Sarbanes-Oxley compliance/audit control , and created separate zone for secure and non-secure data.
• Creating Users and assigning responsibilities in ORACLE ERP EBUSINESS SUITES had these modules of EBUSINESS Suite: GL/AP/AR/HR/Benefits, irecruitement, and iprocurement, further EBUSINESS suite uses, OID and SINGLE-SIGN-ON.

Confidential

Oracle DBA

• Migrating Upgrading of 7 mission critical Oracle Databases ver. 9.2.0.8/10.2 HP Unix EMC VERITAS Storage to Oracle 11gR2 SUN-Solaris with ASM on Hitachi Storage. Total close to 50 servers were upgraded to 11gr2 .
• Performed day-to-day Oracle DBA activities in the following ORACLE environment.
• RMAN Convert is used to convert data files from HP-Unix to Solaris Unix during platform migration.
• Various kind of import/export tasks were accomplished through DATA-PUMP as well as Imp/Exp utility.
• Provided on-call production support to the databases spread across the mix of HP, LINUX, SUN, AIX Unix addressed the issues of backup jobs failure, file system space issue, pages generated by the Grid Control.
• Supported combination of Oracle 9.2.0.8 to 11gR2. Combination of RAC and Non-RAC with DATAGUARD.
• Applying patches/PSU work with Oracle support for the conflicting patches.
• Full-fledged RMAN and Grid Control Managed Database environment. Reviewed AWR report to address performance issue.
• Databases using ASM as well as Unix file system.
• Closely coordinate with the developers to address their performance issues.
• Take action based on various alerts generated by Grid Control.
• Fixing space issues while logs were shipped and applied at the standby but were not cleared yet by the job at the primary databases.
• To put blackouts during server-maintenance in GC GridControl .
• In case Agent is not communicating with the GC GridControl , bounce the agent.
• Developed some Unix Shell scripts to automate database operations.
• Developed or modified some Oracle backup and recovery scripts
• Autosys Unix software is used to schedule the jobs.
• Oracle E-Business 11i:- Cloned within multinode environment, applied patches, and incorporated secure Certificate in Oracle Wallet so https request can be made from the application plsql procedure through Concurrent Manager. In addition to 11.5.10, also had installation of R12.
• Database sizes were 5-15 Terabytes. Further also moved this Oracle EBUSINESS database and application on to 11gr2 on Solaris platform from HP.

Confidential

Performance Tuner/Sr.Oracle Developer

• Oracle 11gR2 with AIX UNIX
• Worked as Database Architect for each business requirement and Present that solution to the technical/business team and answer any question raised by the member of the team. Supported this Enterprise level Datawarehouse / Master Data Management MDM application through innovative solutions.
• Queries were based on outer-joined and 4-8 pages long in a denormalized Data Warehouse environment where STAR Schema is employed. Located the performance bottleneck, where DBA's and Development team don't agree where problem is in the database or within the code.
• Developed REF-CURSOR based queries to send data from Oracle Back end to .NET based front-end application since these were online data viewing applications.
• Developed programs to migrate data between various systems to the tune of 500 million rows over the Database link and still make sure, they finished within prior window of time set.
• Processes failed because of TEMP tablespace issue pinpointed problem or come up with a solution to minimize volume of sorts/grouping data. Scalar queries are also used along with Analytic functions, Developed Triggers and Stored Packages/Procedures/Functions and used union clauses.
• Further performance issues on Group by clause along with user-functions were also solved. Also used Table type variables, Materialized view, nested queries and nested CASE WHEN.
• Designed summary tables to sufficiently serve the end user needs while using PARTITION tables
• Developed Shell Script to run SQL scripts and generated logs on Unix.

Confidential

Oracle Data Warehouse Developer-Architect/DB Performance Tuner

• Worked with a team of Data Warehouse/TELL developers, with Multiterabytes of data. All the proof of concept for database Design/Data Modeling were done by using ERWIN type of tool and Visio, so once it's approved it can be transformed to production schema. Good understanding of identifying and non-identifying relations, one-to-many and many-to-many etc relations used in ERWIN.
• Developed PL/SQL Packages/Procedures/Functions/Triggers for the ETL process.
• Developed many complex queries with plenty of Analytic functions embedded in them. Used table partition.
• Performance tuning of complex query that deals in with Multiterabytes of data.
• Search for long running queries, blocking locks, and other DBA related activities involved in.
• Developed Unix shell scripts to automate the processes.

Confidential

Oracle Data warehouse Developer-Architect

• Data Conversion/Migration, Performance tuning within Data Warehouse Application, Oracle 10g,Unix
• ERWIN data modeler used for design, maintenance and enhancement of this Data Warehouse application.
• Cingular maintaining very critical database of their infrastructure information i.e. Tower locations, its zoning, tower types, cable types, antenna, port connected to, network elements installed, cabinets type, frequency .
• Because of Merger/Acquisition which created new opportunity to consolidate the data from different carrier into this one single company wide database.
• Developed data Conversion/Migration scripts by using Oracle PL/SQL, and did the performance tuning on other existing codes.
• Participated in team meetings to find out best way to migrate the information into the existing system and defined data architecture standards and procedures.

Confidential

Oracle Application DBA

• E-Business Suite-Financial, Application 11.5.10 CU2 , Database 10g/9i ,OS: HP Unix, SUN Unix Windows, TOAD, Oracle OEM, Forms/Reports
• Production Databases with Apps
• Responsible for managing and supporting Oracle E-Business Suite Oracle Application and Database for a 5 Billion dollar company and close to 2 Terabytes of database. Responsible for the following while playing a lead role in the major upgrades and rollout of a high availability system that runs 24/7, 365 days.
• Application cloning frequently. Installation of E-Business Suite. Applying Patches and troubleshooting, fairly good familiarity with AD BUGS, AD APPLIED PATCHES tables.
• Helped Developer in Oracle Reports and Forms versions - 10/9i/6/ , Helped developers to manipulate millions of row while minimizing the performance impact on the system. Some of the GL and Accounts Payable AP reports developed. Developed Interfaces for Oracle Financial GL AP .
• Support Developer on Custom PL/SQL code to identify the bottleneck within the ORACLE FINANCIAL APPLICATION and help them to write a PL/SQL optimized code. Developed Data Conversion / Data migration routines to support the business need sometime pertaining to data warehouse while other time to exchange data between the other business partners.
• Identify the long running CONCURRENT MANAGER JOBS and coordinate with the Application Admin and user. Also monitor the processes at the Unix OS level through the TOP etc commands.
• Recently Configured a Multi-node Oracle Financial Application with Load Balancer, where 3 servers are involved, one for Database, Concurrent Manager Report, while 2 additional servers are used for Forms Apache webserver to support the load balancing of forms session.
• In the absence of Application Admin, Creating new users in the application and assigning responsibilities. Adding printers in the Application. Additionally coordinate with UNIX admin to configure a new printer at UNIX level first then we have to add in the application.
• Involved in Workflow Mailer configuration. Trouble shoot, if workflow etc did not turned-on
• Monitor Orphan processes at the Operating system level with the combination of UNIX top command and FND CONCURRENT REQUEST etc and kill them.
• Closely work with Application administrator to make sure all daily/weekly invoicing, interface jobs completing successfully, and in case of error coordinate between the development team .
• Monitor log and out file destination periodically cleaned-up by concurrent request. Performance tuning queries.
• At Tracfone we are using these Application Module GL ,Purchasing PO ,Account Payables AP ,Account Receivables AR ,Fixed Assets FA ,Inventory INV ,Order Management OM ,Trading Community Architecture TCA ,E-Commerce Gateway E-Commerce ,Warehouse Management

Production Database without APPS

• Supported 2 terabytes database in addition to that we have few 1TB , 500MB databases too , monitor for the blocking locks, dead lock situation and monitor for the long running queries
• Support and maintain two fail-over sites of a primary database customized/ homegrown DATAGUARD setup .
• Capacity planning for the space brain stormed the extent management time to time , monitoring cron jobs failures and coordinated with the business and developers.
• Install and configure Oracle 10gs on various platforms. Analyze Statspack Report
• Modified existing Shell scripts to add more conditions etc into that.
• Used Oracle 10g RMAN with Catalog, created rman repository, wrote scripts for backup, Periodically used disaster recovery scenario ,especially in hurricane season to switch over the database operation to a host which was physically located at different location and that host computer remained in sync with primary database through dataguard.
• Installed and managed OEM 10 GRID Control, integrated rman with OEM and GRID.
• Experienced import/export of 50-150GB of data. Handling distributed data issue, issues related to bringing in large amount of data through the database link.
• Database Architect recommended database design and review PL/SQL code of other developers before it goes to production.
• Setup RMAN solutions for Oracle Databases

Confidential

Sr.Oracle Report Developer

• Oracle Suite 10g
• Developed Several Mortgage related Reports by using Oracle Developer Suite 10g out of their data warehouse application
• Most of these Oracle 10g Reports were developed out of Flex cube application, and reports output were produced in PDF formats.
• Used HTML with JavaScript and JSP to pass the input parameters to the Reports.

Confidential

Sr.Oracle System Integrator/Developer

• Forms/Reports/PLSQL, Oracle DevSuite 10g, Performance Tuner/Optimizer Oracle Database 9i release 2 ,OS: HP Unix Windows , TOAD, JBUILDER
• Avmed used HP3000 machine with Amisys Application Healthcare application . Project was started to migrate all the application, programs, processes, Scheduler, virtual printer software etc.
• Request will come from First Web Based Application sitting on First server, requested application to be run from 2nd machine while preserving legitimacy of the request . From 2nd machine HTMLDB front-end will be launching the Oracle Reports and report request will go to the Scheduler first to run, and at the time of actual execution of report, Scheduler will send the output to the Virtual printer, from there bursting software will split the report as per the predefined criteria.
• Oracle Reports was the report writing tool, HTMLDB was the front-end tool used at AvMed.
• Designed Authorization and Authentication Scheme by using HTMLDB a new product from ORACLE uses same SQL/PLSQL . Put together a solution that's how user from one Readymade Web based Amisys Application will excess HTMLDB application and will launch the Oracle Report, OR HTMLDB data entry screen, while preserving the session information, passwords etc. It will also verify that request came from another server is the valid request in terms of security perspective.
• Pros Cons were provided in terms of using Oracle Forms vs. HTMLDB before AvMed selected HTMLDB for few departments and for others Oracle Forms 10g
• Identified bottleneck in the system as per DBA perspective. Since Database architecture was not very conducive for Database Administration, therefore adhoc solutions were provided, instead of reengineering the system.
• Developed very complex Oracle Reports by using DevSuite 10g some of them contains 4-5 groups with so many repeating frames etc.
• Worked with both the format .RDF and .JSP format of Oracle DevSuite10 Report.
• Optimized Queries, since very commonly used table had 30-40 million rows. Developed commonly used routine in PL/SQL. Played role of PL/SQL and Database Architect.
• Offered training to the existing Cobol/RPG programmers about Oracle SQL, PL/SQL in a classroom type of setting.
• Amisys Application stores DATE data in numeric format, therefore lot of unusual solution were developed to actually use the data in a true date format.
• Special code was added in the Oracle Reports that will make sure that 'NO DATA FOUND' message along with report headings to be printed even if there is no data fetched for the Oracle Report.

Confidential

Oracle PL/SQL Administrator/DBA

• E-Business Suite-Financial - Application 11.5.10 CU1 , Database 9i ,OS: HP Unix, SUN Unix Windows , TOAD
• At Tracfone we are using these Application modules : General Ledger GL , Purchasing PO , Account Payables AP , Account Receivables AR , Fixed Assets FA , Inventory INV , Order Management OM ,Trading Community Architecture TCA , E-Commerce Gateway E-Commerce , Warehouse Management
• TracFone is in the business of selling prepaid cell phones and cards. This business requires 24/7 support by IT Operation Dept. This is the shop where extremely good response time for the transaction is essential.
• Involved in application Cloning, Core Database Cloning, and Applying Application Patches
• Review PL/SQL code and other objects procedures, functions, packages, triggers, constraints, indexes, database structures etc from senior developers before that code goes to the production. To make recommendation and suggestions for the purpose of optimizing the code. To review PL/SQL code with this point in mind that proper error handling is done and nothing in the code that may trigger deadlock situation within the database.
• Day to Day DBA related work: adding data files, changing privileges of the object, creating users etc, Database cloning, Facilitate in Disaster Recovery Planning DRP , Monitoring of Archive logs to apply in a timely manner. Debugged processes failed during Fail-over or Switch over in connection of DRP. Setting-up of Cron-Jobs. In case of Database Lock, findings Core causes of the lock. Database Installation and upgrades on new Servers. Database support for Performance tuning.
• Developed PL/SQL code procedures, functions, packages, triggers to meet emergency needs. Developed PL/SQL code to manipulate and fix erroneous data. Developed programs to encrypt and decrypt online data without effecting performance.
• Support Oracle Forms and Oracle Reports related issue.
• Developed complex queries and programs to manipulate 100-200 million rows in shortest possible time.
• Developed Unix Shell Scripts to automate the processes and generate log files through the cron jobs.
• To upload and download Data-Warehouse feed through SQL LOADER and UTL FILE package of Oracle. Developed programs to manipulate ASCII files.
• Frequently used DBA Tools Explain-Plan and in some cases used TKPROF to pin point bad code.
• Familiar with various techniques how to work with massive amount of data.

Confidential

Oracle Developer

• Oracle Forms 6i/4.5, Reports 6i, PL/SQL, Oracle 9i/8.1.7/7.3 OS: Unix Windows NT
• With limited budget and delayed project was completed at lightning speed.
• Developed Forms, Reports, PL/SQL code to accommodate their onboard promotional credits and Taxes. The whole onboard and shore side application is passed through the major upgrade in terms of application as well as software development tools
• Actual goal of the project was to move Forms/Reports to 9i while maintaining other older versions too.
• Developed new Oracle Forms and modified existing Forms in 9i and 6i / 4.5 to incorporate their new business rules in terms of onboard refundable and non-refundable credits.
• Developed new reports and modified existing reports using Oracle Reports. Some of those reports are Preliminary and Final Guest Statements printed on pre-printed Stationery.
• Create new procedures and modified existing procedure to run as batch processes. These batch processes/procedures are called from the Unix Shell script that was also developed by me.

Confidential

Oracle Developer

• Oracle 9i/8.1.7 OS: Unix Windows NT, TOAD
• Developed and modified Stored Procedures, Functions, Packages and Triggers PL/SQL code for a Financial Data Warehouse/Data Mart Application for Central Bank Regulatory Reporting by using Oracle 9i running on HP Unix Operating System. These Stored Procedures basically run on daily, monthly, quarterly and on annual basis and generate data for individual Latin American countries Central Bank
• Latin American countries used to have their local system to produce Central Bank Regulatory Reporting, but CitiGroup CitiBank decided to Develop a Centralize Data Repository and produce report out of this Data Mart application, so they can discard variety of computer systems and languages those were used for Regulatory Reporting in different Latin American countries. This was very high visible and time sensitive project, because in case of not fulfilling the Central Bank reporting requirements they can close down the branch.
• Developed complex queries to manipulate the data by using inline views, union and grouping function of oracle to its maximum extent .
• Used SQL Loader to upload data from CVS.
• Used Microsoft Excel for Reconciliation purposes.
• Actively involved in probing and fine-tuning of queries and removing performance bottlenecks
• Day to Day DBA support: Creating indexes, setting-up of privileges for the objects and users. Addressing Deadlock situation in the Database. Making Schema Changes. Monitoring performances for the jobs. Space allocation etc.

Confidential

Oracle Developer

• Oracle 9i/8.1.7 OS: Unix Windows NT, TOAD
• Kemper was in the process of implementing third party Pyramid Application SIR Project, Client/Sales/Marketing Centric Application Customization and addition of new modules that did not exist at all in the Pyramid application . Pyramid Wizard creates VB front end.
• Developed Stored Procedures, Functions Packages PL/SQL to support front-end applications. These procedures functions are called from the front-end VB application to validate complex business rules.
• Extensive use of different kind of Database Triggers wherever 'VB COM' and stored procedures were not feasible to use.
• Involved in data modeling through ERWIN for additional modules in pyramid application
• Creation of tables, indexes, constraints, synonyms, sequences, jobs and maintaining privileges for the object those were created by the developer.
• Extensively used UTL FILE oracle package to manipulate text files
• Residing on AIX UNIX for the purpose of data conversion from various legacy system massaging and consolidation of data were also done
• Further regular feed was uploaded from the text files for Data warehouse and Analysis purposes. Star Schema is used for Data warehouse feed so optimum performance can be achieved while applying complex queries. LOB Large Object columns are used instead of LONG for notes data. In the application all the capabilities are provided to manipulate the LOB data. Shell scripting along with awk sed is used while working on Unix environment to ensure the existence of files and directories, and to automate the execution of programs.
• Performance Tuning: Significant number of queries was optimized during probing either index column's sequence were changed or new index were added, or sequence of tables in 'FROM clause' were changed etc to achieve maximum performance . Explain plan was used.
• Some of the routines were developed in JAVA/SQLJ, and called from oracle procedures/functions.
• To coordinate and assist business Analyst to put the requirements together.

Confidential

Oracle/Web Developer Data Modeler

• OS: Unix Windows NT, SQL Navigator, TOAD, ORBIT
• Day to Day DBA related work pertaining to this particular application, Adding Table spaces, exporting/importing data before major changes goes to the Production, so schema level back-up can be restored. Since application was maintaining its own data tables etc , creating Indexes.
• Further several other DBA related tasks: Adding files into table spaces, managing roles, assigning privileges to the different kind of objects and creating synonyms, recommending regarding query optimization using different hints i.e. use hash etc.
• Developed a web-based Global Talent Management System Talent Profile, Candidate Slating, Leadership Supply, Position Profile using HTML FrontPage 2000 , JavaScript, XML,Oracle8i Database Oracle Web Server/Oracle Application Server 9iAS -Web Toolkit , Oracle Stored Procedures Triggers PL/SQL code . Lots of Dynamic PL/SQL Code was developed .
• Oracle Web Toolkit was extensively used to include data within HTML TAG.
• Designed Developed Schema to support front back end processing. ERWIN data modeling tool used for logical and physical design
• Accomplished data migration from one application denormalized structure into another application normalized structure .
• Developed many complex SQL Queries to produce Ad-hoc reports.
• Developed and implemented complex JavaScript functionality that manipulated web form fields, and dynamically changed the contents of lists using values retrieved from the Oracle database. Resolved issues those were browser specific Internet Explorer and Netscape since application had to work with both the browser was a requirement. Helped in homegrown security related Forms in Oracle Form6i to support application, so user can customize the privileges of a user and application through Oracle Forms instead of going to a DBA. Dynamic SQL/HTML is developed by using third party tool called Orbit, written in Oracle Forms6i Developed new reports and customize existing reports using Oracle Report 6i/3.0 Confidential Senior Oracle Developer Oracle 2000 Version 2.1 Forms 5.0, Oracle Report 3.0, PL/SQL, SQL Plus . OS: Unix Windows NT Development of Purchase Order/Sales/Marketing module along with all supporting forms such as cost price, discount, supplier, customer, sales history etc. strong in designing complex forms with CLASSES Developed complex queries. Developed PL/SQL procedures, functions, packages, code to migrate data from more than one legacy system and manipulated it. Developed database packages, procedures and functions to run every night for the purpose of transferring information that was added, updated and deleted in system during the day. Developed end-user Oracle Reports on Pre-Printed Forms for instance Purchase Order , Inventory Status etc Installation of Oracle on individual machines and managing production directories. Confidential Consultant Human Resources, Benefit and Payroll application. Tosco used Oracle as a back-end with PeopleSoft application. Developed 80 to 100 SQR reports out of PeopleSoft application. Developed Reports using SQR from PeopleSoft and gained the experience of PeopleSoft, People Code Panel and Panel Designer. Confidential Consultant Worked at Yale University and used Oracle Developer/2000 Database 7.2 Oracle Forms 4.5, SQL Plus 3.1, PL/SQL, Oracle Report 2.5 . Design and Developed a series of Oracle forms for Admission department of the university to accommodate data entry of thousands of applications. for applicant's Biographic ,Academic, Geographic, etc information Developed advance level of SQL Query and PL/SQL code, including database procedures and Data Definition Language in PL/SQL to develop an interface. Developed new forms and customized existing forms, integrated these forms with the base line banner product to extend its local functionality.