SUMMARY

Confidential has 18 years of experience in Information Technology consulting in the United States. He has expertise in various functional areas that include Pre-sales, Project management, Database application development, Data Modeling, Data warehousing, Business Analytics, Data Integration, Enterprise architecture and business process management. He has excellent communication and interpersonal skills in addition to project management and team building skills. He has facilitated information gathering and developed internal project plans for Implementations, upgrades and migrations. He has provided consultancy to a variety of clients on ERP Implementation, database clusters, business continuity and high availability solutions. He has several years of experience in the area of database application development and database production control operations. He has experience with application, data architecture, capability planning, and alignment of IT to corporate and business unit strategy. He has a master certificate in Mastering process methodology and Solutions from Villanova University and has been trained in Savvion, Pega BPM tools. Additionally, he is a trained certified enterprise architect from IBM also has acquired certificate in operational strategy from MIT.

TECHNICAL SKILLS:

• Hardware: Unix Systems Sun E-10000, 450,Aix IBM-RS/6000, IBM/AS-400, Sun Sparc Center 2000 with LVM RAID 0 1, 10 Juke Box, HP9000 with ADSM, EMC- SRDF TimeFinder BCV's, Service guard, Windows RAC, Linux RAC , Veritas HA cluster, Exadate V2, Exalogic.
• Operating Systems: Sun Solaris 10, HP 11.00, Enterprise Linux RHEL 5 , AIX V5.3
• Software: Oracle 5.1A, 5.1B, 6.0, 7.0.1.6, 7.3.2, 8.0.4, 8i, 9i rel 1 2 ,10g , 11g, Peoplesoft 7.5, 8.0, Oracle Financials 10.7, 11.2, R12 casegen Ver 2.0 , SQL Forms Ver3.0, Ver4.0, Ver 4.5 , Oracle Reports 2.0, 2.5, Oracle Enterprise Manager, Java Programming, C, C , , XML, JSQL, JDBC, Erwin Data Modeling Tool, Unix Shell Programming Expertise, PERL, Precise Oracle Application Tuning Tool, SQLNavigator, BMC Patrol, Oracle Developer Server 6.0.5, Quest Software Products SqLab, DbArtisan, SpaceManger, Shareplex, Iwatch, Golden Gate, Informatica ETL 6.2 , Microsoft SQL Server 2008, BCP, T-SQL. JavaScript, Sql Anywhere, TimesTen-IMDB Cache, CA Wily Introscope, ITIL foundation, Archimate, TOGAF 9, Progress-Savvion 2013, Pega 6.3, Oracle BPM Suite, DODAF, FEAF, MODAF, ZACHMAN frameworks, sparx Enterprise Architect.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Principal Architect

• As a Principal Architect provided technical and architectural direction and guidance to project teams and ensured alignment of IT resources with business priorities. As part of distributed application development, I work with onshore and offshore teams in coordinating, supporting and assembling the final delivery to the production environment.
• From Start, designed and architected the data requirements for business Intelligence dashboard project by extracting HR, payroll and Time data from the production system to the business intelligence platform and utilized IBM-MQ-FTE for data integration activities.
• I have managed data migration and application development activity using agile methodology. As an Agile team organized sprint planning sessions, Created user stories, decomposed the user stories into manageable tasks, estimated the tasks and as a team, entered in Rally and assigned to individual developers and to appropriate tasks. Conducted daily stand up meetings, update Rally software about the daily tasks performed. At the end of each sprint provided the Demonstration of accomplished/completed user stores to the Product owner and obtained the acceptance.
• Worked across with members of different IT departments like Security SiteMinder , Portal, Web Tier in coordinating and developing Progress-Savvion BPM workflows in creating and Orchestrating the migration related actives starting from Siteminder account creation, Portal Mega Menu, access Control list privileges and data migration activities using Java methods, soap web services, shell scripts and database stored procedures.
• Used Progress-Savvion BPM software to orchestrate the workflow in an effective manner to accomplish the desired result. Monitor and trouble shoot in-flight work being orchestrated by the underlying Business Process Management Engine.
• As an individual contributor and member of Scrum team created and developed application solutions and resolved the migration and post migration issues reported by QA team or by the clients.
• As a member of ADP's Architecture committee, involved in weekly/monthly Incubation architecture design review/solution, evaluation and feedback activities.

Principal Architect Confidential

• As a Principal Consultant provided industry leading technical direction and guidance to project teams and ensured appropriate, business aligned cost effective solution and client approved oracle technologies are delivered. As part of my role, I work with clients in various capacities to define enterprise, application/database integration strategies and supporting technologies that are in alignment with client's business goals and objectives. I Provide application database support for implementation of Oracle ERP SOA framework, for manufacturing and financial clients across United States and Australia.
• Articulated the key aspects of architecture and design i.e. Scalability, high availability and manageability. Evangelized, facilitated and introduced new technology features through presentations and documentations.
• Researched and advised to resolve complex technical issues related to system, OS, architecture, network, performance of enterprise applications. Developed appropriate technical project plans and co-ordinate activities in preparation of CRP's Conference Room Pilot testing activities.
• Performed software evaluation and reported on fit/gap analysis of the new software that is requested.
• Provided tuning solutions for Oracle 11i environment, using SQL profiles and other techniques after thorough evaluation of the application and database performance.
• Mentored and managed team of offshore DBA's in completing the installation and configuration of the Oracle R12 application and 11g RAC database.
• Liaised with business users, process owners and functional teams in resolving performance problems and optimizing the daily, month-end jobs.
• Created performance strategy, as a pro-active measure, for the implementation of ERP Finance module to provide a sustainable performance.
• Selected tools and software like Autopilot for archiving and strategic performance effectiveness. Provided technical support and guidance on database security using transparent tablespace encryption technologies.
• Provided guidance on application development in context of application performance. The comprehensive architecture involves full suite of oracle products consisting of EBSR12, SOA, ESB, GoldenGate and OBIEE with Single sign-on option.
• Familiarity with the Master data management tools including Hyperion DRM concepts and templates. Have detailed knowledge of service oriented architecture and experience in designing and supporting SOA based solutions. Managed the SOA project to streamline and consolidate multiple account creation process from various banking systems into single centralized account creation process using oracle SOA suite. Performed coordinated efforts and resolved operational issues with various technical support groups.
• As a data Integration Lead, ensured appropriate and effective data integration solution is built to integrate with Oracle R12 Finance ERP modules using oracle enterprise service Bus/SOA suite. Analyzed, evaluated and advised the real-time data integration solution using the Oracle GoldenGate and the Oracle Data Integrator.
• Demonstrated the Entire Oracle SOA architecture on a pre-installed laptop, which was a complete suite, entirely installed by me.
• Advocated and presented Oracle Web Service Manager OWSM Policy features to be used as a centralized security and for SOA governance. Presented Database Vault features to prevent insider security breach.
• Facilitated and participated in defining solution architectures which includes evaluation, selection and integration of necessary technical components to create solution designs that support the defined functional and non-functional requirements.
• Evaluated and Liaised with the testing team in choosing between Oracle OEM 12c and HP testing suite. Based on true findings and evaluation leaned towards HP testing suite.
• Facilitated and assisted in the building of as-is model and to be model. Created overarching enterprise Meta model. Operationally Familiar with IBM Rational system architect tool.
• Very familiar with Rational System Architect setup/configuration and publishing the Encyclopedia. Used statistical analysis and provided visual reports.

Supported pre-sales activities, responded to RFP and presented appropriate technology capabilities to various clients across North America.

Confidential

Database Architect - Consultant

• Created the installation plan and deployment plan for installation of two node Oracle RAC database to monitor the Exadata production servers and the Standby Server.
• Installed appropriate OEM plug-ins to monitor Exadata compute and storage nodes.
• I had executed the entire operation single handedly to client's satisfaction. As a token of support and note of thanks, my client provided appropriate endorsement in the linkedin site.

Environment: Exadata V2, Exadata Storage Server Software - Version: 11.2.1.2.0, Linux x86-64, Active Cell Version 11.2.1.3.1, RAC, ASM, Oracle 10.2, 11.2, Oracle OEM 11 Grid Control, Enterprise Linux x86-64

Confidential

Principal Consultant

• As a Principal consultant/Development DBA managed and maintained Oracle Exadata V2 Production servers with a solid team of database professionals. I have supported various application databases in size ranging from 1Tb to 15TB.
• Initially, when Oracle wheeled in the servers, the Cluster had only 1 OCR file in the system Data Group. Based on the cluster health check conducted by Oracle, oracle advised us to create additional two OCR files. After analyzing and investigating the existing storage, I first created OCR files in the two node QA cluster one in DATA disk group and other in RECO disk group and then executed the same in the production database with ultimate precaution. OCR and Voting disk files were placed in the ASM storage.

• Based on Oracle's recommendation, I reset the CSS miscount to 60 instead of 30 as this change was originally implemented by the internal network security team. Recompiled rdp module to use infiniband switch rather than UDP protocol as per oracle's advice to boost the interconnect transfer latency.

• Performed a rolling patch upgrade method with Oracle Bundle Patch 5 p6880880 in all Database servers. During this patch I have shutdown/restarted the database and CRS without any issues several times. Performed Storage cell patch jointly with the Linux SA, in applying the Cell Patch part of Bundle Patch 5, ILOM Patch, and Infiniband switch firmware patch.

• Created a new QA database instance in the Exadata server after analyzing the storage space in the ASM disk storage cells. Exported selected tables from the Production Database based on query criteria to create a test set of production data. Created the Exadata production database in the UAT test server by using the RMAN's duplicate option.

• Observed cell node performance by directly logging into the Cell Nodes running top and scripts provided by oracle Onecommand scripts. Used cellcli, dcli commands across multiple database nodes to query the details when creating the SR to Oracle.
• Used Oracle OEM extensively to monitor the database and responded to the OEM alerts with regards to query performance and observed the Cell waits for I/O in violet color as highlighted OEM.
• Familiar with issues related to Bloom filters and storage indexes. By passed the bugs with the storage indexes by enabling oracle recommended hidden parameter kcfis storageidx disabled TRUE
• Have used the OSWatcher utility to gather system trends and diagnose problems.
• Identified and placed highly active transaction tables in the SSD Drives to reduce the I/O waits and to improve the query performance. Created the RDA reports for oracle in support of the SR for trouble shooting purpose. Production consists of half rack with 4 DB nodes and 7 Cell Nodes. QA node is Quarter Rack viz. two database nodes and four cell nodes.
• Installed 11g Grid control software on the Standalone Linux server and created ASM instance through asmca. Created multiple diskgroups DATA, SYSTEMDG, REDO. Created single development database instance placed all files in the ASM storage. Added additional disks to the disk group using the asmca tool, to extend the storage space of the disk group. Monitored DATA disk group average response time, average throughput MB per second, and Hot and Cold Reads through OEM.

Environment: Exadata V2, Exadata Storage Server Software - Version: 11.2.1.2.0, Linux x86-64, Active Cell Version 11.2.1.3.1, RAC, ASM, Oracle 10.2, 11.2, Foglight, Oracle OEM 10g Grid Control, Enterprise Linux x86-64, OBIEE

Confidential

Asst Vice President Oracle DBA

• Attended Exadata V2 training by Oracle and Supported the Oracle 11g Exadata databases for the Development/UAT and the Production databases running on 64 GB Ram 8 nodes symmetrical RAC cluster with Exadata Smart Flash Cache, Hybrid Columnar Compression, storage indexes with Full Rack model. Applied the CPU patches, upgraded the database from 10g to version 11g, and applied the standard database auditing to be in compliant with Global Information security standards.
• Supported Sophis a cross asset front-to-back portfolio and risk management application. Provided database support for Oracle ERP application.
• Handled the major database outages using predefined process called MIH Major Incident Handling including taking emergency action to stabilize the system.
• Followed appropriate change management procedures in implementing the changes to the application/database. Engaged the team from respective discipline in resolving the outages and handed over to the counter parts in Singapore and London when engagement exceeded beyond local working hours FTS Model approach .
• Converted the standby database to snapshot standby made it read write mode, for the app. team to test their application against the DR database and converted back to physical standby.
• Worked with caution, when performing database maintenance activity in shutting and
• Re-starting the databases configured in VERITAS active-passive cluster configuration.
• Froze the service groups before shutting down the database and un-free zed the serviced groups after starting the database since the oracle database is configured as a critical resource.
• Trouble shoots database fail over issues during the planned and unplanned circumstances resolved failures due to memory and storage related issues. Performed database switch over and fail over to the DR using the data guard configuration in a planned environment During the scheduled half yearly DR test .
• Created, modified and deleted the Autosys jobs and relocated the jobs from one instance to other instance. Put the jobs on Ice, updated and modified the job status based on the need.
• Responded to alerts generated by monitoring systems and to the tickets generated in the HP service center. Performed the quality control checks on the database server, when a new application is inducted into production.
• Worked with the development team, on case by case basis to tune and trouble shoot technical and performance related issues. After completing a pre-defined backup procedures de-commissioned obsolete servers. Deployed the application releases to the production databases and performed quality control evaluation and standardization checks. Provided outstanding support to application team in handling critical database/application issues in timely and responsible manner.
• Very familiar with RTB and BTB process and procedures. Provided monthly updates to the CDR from the database front CEO Direct Report .

Environment: Exadata V2, dbfs , Red hat Linux Cluster Farm on GFS, RAC, ASM, Oracle 10.2, 11g, Precise 8.5, Oracle OEM 10g Grid Control, Nimbus, Oracle Virtual Servers, Solaris 9,10, HP Unix 11.0, IBM AIX Servers, Veritas Cluster Storage Foundation, Veritas Clusters.

Confidential

Database Project Lead/Specialist

• As a senior database professional, worked closely with the development team, in trouble shooting critical application and database issues of the Airline Crew Management System developed using C , Tuxedo, MQ series and Web logic.
• Provided hands-on support to clients in managing RAC servers using Windows/Linux/Unix operating system.
• Analyzed and supported the application team in identifying application bugs and poorly performing SQL statements by modifying and changing the SQL statements. Performed top down approach in analyzing the performance issues from the Unix/Linux servers from memory, storage down to database SQL statements.
• Used dbms quick tune, dbms sql tuning advisor, access path advisor and PLSQL profiler to tune the packages, procedures and sql statements, created sql profiles in other cases. Several years of DBA experience have provided tremendous knowledge in application tuning and sql tuning specifically.
• Configured rsa/dsa public/private keys to enable password free access to oracle accounts.
• Configured the standby database for DR, tested and validated Switch over and fail over operations before setting up in the production. Performed hands-on testing the fail over and switch over using data guard. Recreated the primary database and the standby database after failover operations.
• Attended internal training on GoldenGate architecture and system administration.
• Monitored the database server and recommended additional memory for the server to improve the performance and reduced the swap usage from 50 to 8 . Recommended RAID configuration parameters, based on the application I/O requirement in choosing a correct stripe size. Provided sizing recommendations to Jeppesen clients in choosing server, storage and database configuration parameters. Handled diplomatic and convincing, conversation with Jeppesen clients providing critical and satisfactory solutions.
• Created oracle database using Oracle Virtual Servers template for proof of concept to the QA testing and Deployment teams. Managed and maintained Informix databases, migrated Informix databases to Oracle 10.2 using oracle migration tool kit.

Environment: IBM AIX Power Servers , Informix 7.1, 9, Red hat Linux Cluster Farm on GFS, RAC, ASM, Oracle 8.17.4, 9i, 10.2 10g , 11g, TOAD 9.0, BMC Pro active net, Oracle Virtual Servers.

Confidential

Development DBA Payroll Application

• Deployed and monitored Steams responded with appropriate response when lags in messages are encountered in the reporting environment of the Pay role module.
• Installed and Managed the RAC databases On Sun OS, using ASM on NAS/SAN storage to support development environment created detailed project plan to migrate other environments like system test, user acceptance test and Production.
• Created partitions for OCR Voting disk on raw devices. Installed Oracle locally on the Local file system on each node for added redundancy of homes. Used ASM for database files, control files, redo log files. Created the Backup and recovery scripts for backing up the database, voting disks and OCR using ocrdump.
• Active member of yearly database recovery DR exercise. Collected and analyzed data for capacity planning and performance monitoring.
• Created workload baselines, peak baselines, AWR awrddrpt.sql work load comparison reports to trouble shoot performance spike issues. Created ASH reports to understand/resolve transient performance problems.
• Provided performance measurements and other metrics for database servers by utilizing OEM and other tools/scripts. Developed, maintained and implemented processes and procedures for environments including backup, recovery, security, cloning and patching.
• Ensured that proper licensing is maintained on all database software products by tracking usage and documenting environment as new systems are implemented and old systems are decommissioned.
• Assisted team with database-related problem determination. Assisted developers with design, testing and other database development issues.
• Provided long term and short-term impact of proposed solutions and developed workable solution.
• Demonstrated ability in providing critical root cause analysis report to the management for crucial incidents. Ability to manage multiple project tasks with changing priorities and tight deadlines.
• Hands on experience in managing mission critical applications with right attitude and composure.

Environment: Sun Solaris 10, Sun RAC, ASM, Oracle 8.17.4, 9i, 10.2 10g , Tivoli, TOAD

• Server : Sun Fire 4800 Server domain A-Node1 , Sun Fire 4800 Server domain B-Node2
• Ram : 16GB for each node. HCA : 1 dual-port HCA 2gbps for each node.
• CPU : 6x USIII Cu 1.2GHz 6x USIII Cu 1.2GHz,
• Ethernet: Ports ce0, c31, ce2, and ce3 ce0, ce1, ce2, and ce3,
• Storage: Sun StorEdge T3 array with 9 x 36GB drives

Confidential Production DBA Risk Analysis Management

• RAM is used for: Trade captures and position keeping for equity derivatives Calculation of Profit and Loss Settlement Database interrogation for reporting and management information purposes for risk calculations and scenario analysis using models.
• RAM Risk Analysis and Management is a framework that has been developed in-house by the Equity-Linked Technology group in Merrill Lynch ML since 1996 to support the 7x24 Equity-Linked Trading businesses. Deals and transactions are processed on RAM to support global trading activities within Equity-Linked Trading, Portfolio Trading and Global Equity Finance and Services GEF S , and Cash Trading in Hong Kong.
• Event monitoring is done by Patrol and tickets are automatically created in the Remedy system. Precise and Teamquest for Oracle is used to monitor the database and server performance. Teamquest special module for Oracle helps to trouble shoot live performance issues as well as historical performance data.
• High availability solution is by provided by veritas cluster by monitoring the oracle database, listener processes. In the event of any failure the oracle database mount points are mounted to the standby node after un-mounted from the primary host the services are interrupted only for a short moment.
• This application is supported by two standby databases. Many batch operations and database exports are taken from the standby database by bringing it up in read-only mode.
• Created/modified JIL's Job information Language scripts for new/old autosys Jobs. Resolved critical performance and oracle related issues efficiently and effectively.
• Used oracle 9.2.0.7 Standby database to deliver down stream database requirements.
• Created databases using ASM storage and migrated databases to ASM.
• Added and maintained tablespaces in the RAC environment, monitored and tuned interconnect cache performance. Created services, maintained and monitored node apps.
• Maintained and added user access changes to key tables protected by Virtual Private Database configuration.
• Worked as a Performance Analyst and Project Manager to meet the rising demand to and manage the operational desk. Assigned tasks and managed the offshore team at Sathyam on day-to-day basis, to ensure proper service delivery.

Environment: Sun Solaris 10 Veritas HA clusters storage Foundation with 24cpu/50gb of RAM, Sun RAC, Oracle 8.17.4, 9i, 10.2 10g , Tivoli, Informatica Powercenter 6.5, TOAD 9.0, Precise I3, Teamquest, Autosys.

Confidential Production DBA

• Created the SQL profile of the application before tuning the queries. Optimizing SQL code being top priority, Modified and choose execution plans, worked with joins, traced SQL statement execution, built indexes that support efficient queries, optimize virtually all type of SQL including views, hierarchical queries, table scans, group by, and sub queries.
• Tuned the Siebel predefined queries using the stored outlines, as they were generated dynamically. Cached the Key indexes to enhance the performance of the PDQ's.
• Maintained a high-availability database by Installing Oracle 9.2 of Data Guard services for the field compensation system that used Callidus software application package.
• Upgraded the Siebel Production database of 800 gb size to 8.1.7.4 64 bit architecture, to implement the keep buffer pool as well as to increase the SGA to a 20 GB Relocated the SGA starting address, for the large size .
• Kept the server running at peak performance by capturing the highly resource intensive Sql statements causing the CPU thresh hold to reach 90 or higher, using the Unix Sar utility. Placed the SQL statements in the database and published in website for the application team and the management to plan opportunities/budget and to tune the Sql statements with the support of the DBA team.
• Installed the Statspack data collection software to monitor and troubleshoot the performance issues and to track the usage pattern of the database server.
• Installed Oracle Rel. 10.0.1.4 database software and upgraded the Development, Integration Environment to 10.0.1.4 from Oracle 8.1.7.4 using controlled manual, 42 steps upgrade process instead of DBUA.
• Installed Oracle 10.0.1.4 client on the Siebel application server with security patch.
• Worked closely with the Siebel application team to upgrade the Sibel 7.0.4 application to Siebel 7.8. Monitored the Upgrep process to tune the Sql statements. Monitored the Merge process and provided fastest restoration of database by using Oracle Rman 10g. Used Data Compression method to save storage space 65 GB database backed up in 4 GB .
• Monitored the EIM Jobs to reduce the execution time by adding appropriate new indexes to core tables.

• Used Rman Duplicate command to refresh the test and integration environment.
• Used Rman Tablespace point in time recovery to recover from logical corruption after operations ran the job incorrectly.
• Restored the rman backup to a sandbox to test the recoverability of the production database and recovered it successfully.
• As Informatica Administrator, migrated the folders, created users, troubleshoot the Informatica production errors to support the data warehouse team.
• Implemented security measures to protect data, applied Oracle's quarterly security patches, Password protect the Listener to close the security loopholes.
• Installed and evaluated golden gate software to support application data requirement.
• Installed the Foglight client software on the production server to get monitored by the centralized Foglight server.
• Installed Oracle 10.1.0.2 10g Release 1 on Windows RAC, 32bit Windows Terminal Server with 4gb of memory, 2 Dual core with support from the Oracle technical business support team. As a secondary DBA, supported the databases configured on ASM running on RAC Linux Advanced Server 2.4.21-27.Elsmp environment. Configured Tivoli for oracle to backup the databases on the RAC environment.
• Used 10g expdp, Sql tuning advisors, undo advisors. Installed Database control and Grid Control software of Enterprise Manager. Used AWR and ADDM to find resource intensive sql statements.
• Installed and configured Oracle Dataguard Disaster recovery system with OEM and administered through OEM and command line operation.
• Provided secondary support/oncall DBA support to SQL server databases.
• Excellent data modeling experience for new relational database design and enhancement to existing models. Translate the logical design to physical design and implement the database structure. Perform re-engineering of source models when necessary. Assist the Data Architect to ensure the Data Architecture is applied properly.

Environment: Sun Solaris 8,9, Oracle 8.17.4, 9i, 10.1, Tivoli, Informatica Powercenter 6.5, TOAD 8.5, Foglight, AppRador, UDB on UNIX.

Confidential Data Analyst

• Reviewed Informatica workflows and applied tuning strategies to reduce the execution time.

• Configured database parameters and created rman scripts for backup/recovery and restoration. Used dbms Stats to collect statistics. Used the Oracle statspack to tune waits on the database.
• Responsible for applying the changes to tables and other objects creation.
• Tuned the application PL/SQL procedures for performance improvement.
• Used the Oracle 9i Enterprise manager in stand alone mode to monitor SQL plan of the Informatica mappings and long running queries to optimize the sql statements.
• Reverse-engineered the data model for the existing sales force automation application, using ERWIN for documentation purpose.
• Reviewed the backup and recovery options available to the application team when the application is migrated from test/QA environment.
• Provided database support for the client's systems migration project that involved deploying a Biztalk server in place of a legacy Mainframe server for data transmits between field based sales force and the central database. The Biztalk server, with MS SQL server as the underlying database, was used as messaging middleware to transmit data between field laptops and the Oracle master database.
• Converted the existing mainframe DB2/SQL programs to Oracle/PLSQL and migrated the Mainframe jobs to Unix shell script programs. The programs were used to extract the profile of healthcare professionals for data scrubbing by IMS. Also developed shell scripts and ms-dos batch files to automate the process entirely.
• Created jobs/scripts to notify in advance, about the database/OS space related issues. Monitored the rollback segments, database growth, and performed capacity planning for future space requirements.

Environment: AIX, Oracle 9i, Oracle 8.1.7, Siebel e-Pharma, Informatica Powercenter 6.0, TOAD, SYBASE SQL Anywhere, ERWIN.

Confidential

Database Developer/DBA

• Created/Configured Oracle resource manager for online and batch jobs that were scheduled for automatic execution.
• Created several development, test and production databases for various application requirements.
• Configured the name server for Oracle name resolution as an alternative for the existing local name resolution.
• Configured the Oracle9i data guard for the standby database setup remote archiving through oracle net .
• Tuned the existing application PL/SQL procedures for performance improvement.
• Created backup and recovery scripts using the Recovery Manager.
• Configured the Oracle Enterprise Manger to track various alerts/events for SLA requirements and for event notification purposes.
• Installed Oracle 9I Application Server, and configured services.
• Installed Cognos Impromptu on windows 2000 server and configured the catalog for reporting purposes.
• Installed, upgraded, maintained and supported OEM 2.2 and OEM 9i on Solaris 2.8 and Windows 2000. Configured jobs and events to automate startup, shutdown, backup processes and monitor the storage growth.
• Installed Oracle 8.1.5 on Linux 7.1 and configured the application.

Environment: Sun 420, Oracle 9iAS, Oracle 8.1.7 with OEM , RedHat Linux 7.1, Jrun, Cognos Impromptu.

Confidential Sr. Oracle DBA Consultant

• Migrated Oracle 7.3.4 databases to Oracle version 8.1.7. Created extensive documentation of the migration process for reference.
• Created/setup the Multi-Master replication process for the client's finance rating service database. Created read-only snapshots and materialized views between replicated databases. Used the DBA studio to set up the Advanced Multi Master replication process in addition to supplementary scripts.
• Created partitioned tables and indexes for performance improvement.
• Installed and administered i-planet web server on Solaris 8 environment. Created PL/SQL wrappers for java stored procedures.

Environment: Sun E-10000 Solaris 8 , I-Planet,Oracle 8.1.7 Oracle Enterprise Edition with advanced replication option

Confidential

Siebel/Oracle DBA Consultant

• Involved in design and implementation of the Call center using the Siebel CRM.
• Installed Siebel Gateway Server, Gateway Name Server and Enterprise Server.
• Installed Siebel Server Manager to monitor and collect the statistics.
• Used EIM processes to perform data loads.
• Tuned the SQL statements for optimal performance.
• Designed a database for College Profile Application. Built the logical model and demonstrated it to the business team and developers. Implemented the application with a team of developers using Oracle 8.1.6 and Solaris 7.
• Automated the backup process using the Recovery Manger RMAN with and without catalogue. Created read-only snapshots using advanced replication for decision support database. Migrated the existing data model from Oracle 8.1.6 to UDB DB2 database on the IBM RS6000 Unix Server.

Environment: Sun Solaris 2.6, Windows NT 4.0, Oracle 8.1.6, Siebel Ver 6.0

Confidential

PeopleSoft/Oracle DBA Consultant

• Moving the Menus from Dev-to test and test to QA and QA to prod
• Migrate the SQR's, Panels, Menu's using the same migration path.
• Refresh the database for production test.
• Startup shutdown the Tuxedo application tuxedo server.
• Startup/shutdown the process scheduler
• Fine tune SQL statements and trouble shoot performance issues.
• Participated in Tax updates Schedules.
• Used the Data mover to export and import the data.
• Familiar with configuration manager, application server, process scheduler and peopletools utilities.
• Trouble shoot crystal reports and fine tune sqr programs.
• Familiar with 3 tier architecture involving the Tuxedo Transaction Manager.
• Involved with EDI Manager/data loads.

Environment: IBM RS6000, Windows NT 4.0, Oracle 8.0, Peoplesoft

Confidential Sr. Oracle Production Database Specialist Lead Consultant

• Created and Maintained a 450 GB Customer Information System database running on a HP V Class server using Oracle Database Version 8.0.4.
• Designed, implemented and reverse-engineered the data model for the Customer Information System application for Pennsylvania Power and Light company. Used Erwin CASE tool for data modeling In-house/Intranet applications.
• Created partitioned tables and indexes and multiplexed the data loading process. Set up the database parameters for optimal SQL performance and resized the SGA to improve the performance of the direct SQL Loader process. Used PRECISE an application tuning tool to improve the application performance and to monitor the data block contention/wait status/locks caused by different SQL statements.
• Used LogMiner to setup auditing policies to monitor and report the DDL changes against the application tables. Used Probe-Profiler API to profile PL/SQL applications and to identify performance bottlenecks. The collected profiler performance data was used to make performance improvement/efforts/determining code coverage for PL/SQL applications.
• Worked on a project to create Oracle Internet Directory, and LDAP based directory service using Oracle enterprise Security manager tool.
• Created/configured databases for data warehouse/data marts. Supported the data warehousing team as a data analyst providing the meta-data information on the data model.
• Created outlines OUTLN Schema to implement PLAN STABILITY.
• Created and maintained a hot standby database for the existing production database.
• Developed several SQL/UNIX shell scripts to monitor the growth and the extents of the database objects. Created a PL/SQL program to estimate the total disk space consumed by the daily batch jobs.
• Supported Oracle Application v 11i/11.0/10.7 SC installation, customization and administration. Performed Oracle application patch management. Worked with application object library and admin utilities like ADPATCH, ADADMIN, ADCTRL, ADRELINK etc.
• Designed the backup and recovery procedures for the database. Used tools like EMC-BCVs and FRDSOS to backup and recover the oracle database.
• Involved in the setup and configuration of the SRDF Symmetric Remote Data Facility .
• Performed database recovery using the SRDF set of disks. Configured the required init.ora parameters to speed up the recovery process. Performed tablespace level recovery to restore individual application tables.
• Created various test and development databases to host different stages of Implementation of the Peoplesoft HRMS and Financial modules. Migrated Peoplesoft Application Menus, SQRs and Panels from development database to Test, QA and Production environment.
• As first member of the team, he had built the finest team of oracle professionals within the organization and completed mission critical projects by working with team of professionals from then Anderson Consulting.

Replication and Standby Systems

• Monitored and tuned OPS using dynamic performance views, Explain Plan and automatic tuning of parallel executions.
• Maintained Advanced Replication, Free Lists, Free List Groups and pctfree parameter for OPS storage management.
• Created database partitioning to improve the performance and to improve maintainability.

Environment: HP 9000 V Class Server HP 11.00 O/S, Sun Solaris 2.5 , Oracle 8.0.5, 8.1.7, Tivoli, Adsm, Sqlbacktrack, SqlNavigator Oracle Version 8.0.4, 8.0.6, 8I 8.1.5, 8.1.6, 8.1.7 , sqlserver 7.

Confidential

Development Database Administrator Consultant

Created and maintained production, development and the test databases. Created stored procedures, packages and functions in support of development efforts. Refreshed the test database on weekly basis and verified sanctity of the database integrity by ensuring all the objects like packages, functions, procedures, triggers before moving into the Production environment. Created and automated daily/weekly backups. Monitored database performance and availability with Patrol.

Environment: Sun Servers Solaris 2.5 Oracle 7.3.4, BMC Patrol.

Confidential

Team Leader

• The role involved design development of Prophet 2000 application, which catered to the accounting and retail needs of a major cold storage retail company in Singapore.
• Forms development was done using Oracle Forms Generator Oracle Case Generator . Oracle/Sun Solaris Environment

Environment: ICL Unix Server, Oracle Version 6.0.

Confidential Application Developer

• The role involved requirements gathering, design, development and implementation of the prestigious Asian Frequent Flyer program. The application development was done using Oracle 6.0 under IBM/RS-6000.

Environment: IBM RS-6000 Servers Oracle 6.0 Confidential Application Developer

• The role involved coding, testing and deployment of key modules in the custody investment system. This system was developed under IBM-AS/400 using Cobol-400 for a leading multi-national bank in Singapore. The system was developed using Oracle Version 5.1B . Microsoft 'C' was used as a programming environment for processing and printing sophisticated reports.
• Involved in the development and implementation of share accounting system for banking Industry. The system was originally developed using MF COBOL under UNIX, and later migrated to Wang COBOL environment.

Environment: IBM AS/400, Wang OS, IBM-PC compatibles.

: