• Working for Florida Department of Economics and opportunitiesDevelop, plan, evaluate, implement and validate guidewire deployments on day-to-day basis. Leads project and discuss technical details with the team member. Responsible for providing recommendations and attaining design approval for new technologies and major enhancements to existing systems. • Provides support to Security in the development of appropriate audit controls and procedures to ensure the integrity and protection of company resources. • Works with customers to understand business objectives in order to ensure functional and technical designs meet requirements and are in compliance with the ACG infrastructure and IS technology standards. • Create, Upgrade and migrate databases from 11g/12c/19c RAC environment to Oracle environment. This involves various deployment activities and troubleshooting database problems and implementing the solution in DEV, QA, UAT and Production environment.• Create ACG Disaster recovery environment using Oracle Dataguard replication for several applications such as Claims Datamart, Sales and Service Insurance system, Guidewire and Automotive Datamart. • Create/Implement database security using Oracle Transparent Encryption technology on ACG Claims, Emergency Road service database environment. This includes encrypting PCI and PII data in the database at the tablespace level.• Created RMAN automated Scripts to implement backups on various Florida department of economics and opertunities databases. Restore the database to Point-in-Time in case of database or application problems. • Run orachk periodically and deploy the recommendations/fix provided in exachk on all DEO databases.• Maintain and responsible for day-to-day activities on Peoplesoft, Sales and service, Liferay, Specialty Lines, Automotive DataMart, Claims DataMart and Guidewire application databases. This involves • Refresh test database with production database backup

• Develop, plan, evaluate, implement and validate guidewire deployments on day-to-day basis. Leads project and discuss technical details with the team member. Responsible for providing recommendations and attaining design approval for new technologies and major enhancements to existing systems. • Provides support to Security in the development of appropriate audit controls and procedures to ensure the integrity and protection of company resources. • Works with customers to understand business objectives in order to ensure functional and technical designs meet requirements and are in compliance with the ACG infrastructure and IS technology standards. • Create, Upgrade and migrate databases from 11g/12c/19c RAC environment to Oracle exadata X-7-2 /environment. This involves various deployment activities and troubleshooting database problems and implementing the solution in DEV, QA, UAT and Production environment.• Create ACG Disaster recovery environment using Oracle Dataguard replication for several applications such as Claims Datamart, Sales and Service Insurance system, Guidewire and Automotive Datamart. • Create/Implement database security using Oracle Transparent Encryption technology on ACG Claims, Emergency Road service database environment. This includes encrypting PCI and PII data in the database at the tablespace level.• Created RMAN automated Scripts to implement backups on various ACG databases. Restore the database to Point-in-Time in case of database or application problems. • Run exachk periodically and deploy the recommendations/fix provided in exachk on all ACG exadata databases.• Maintain and responsible for day-to-day activities on Peoplesoft, Sales and service, Liferay, Specialty Lines, Automotive DataMart, Claims DataMart and Guidewire application databases. This involves • Refresh test database with production database backup• Deployment of various script to Create tables, indexes, synonyms, procedure, packages and functions.

• Develop, plan, evaluate, implement and validate guidewire deployments on day-to-day basis. Leads project and discuss technical details with the team member. Responsible for providing recommendations and attaining design approval for new technologies and major enhancements to existing systems. • Provides support to Security in the development of appropriate audit controls and procedures to ensure the integrity and protection of company resources. • Works with customers to understand business objectives in order to ensure functional and technical designs meet requirements and are in compliance with the ACG infrastructure and IS technology standards. • Create, Upgrade and migrate databases from 11g/12c/19c RAC environment to Oracle exadata X-7-2 /environment. This involves various deployment activities and troubleshooting database problems and implementing the solution in DEV, QA, UAT and Production environment.• Create ACG Disaster recovery environment using Oracle Dataguard replication for several applications such as Claims Datamart, Sales and Service Insurance system, Guidewire and Automotive Datamart. • Create/Implement database security using Oracle Transparent Encryption technology on ACG Claims, Emergency Road service database environment. This includes encrypting PCI and PII data in the database at the tablespace level.• Created RMAN automated Scripts to implement backups on various ACG databases. Restore the database to Point-in-Time in case of database or application problems. • Run exachk periodically and deploy the recommendations/fix provided in exachk on all ACG exadata databases.• Maintain and responsible for day-to-day activities on Peoplesoft, Sales and service, Liferay, Specialty Lines, Automotive DataMart, Claims DataMart and Guidewire application databases. This involves • Refresh test database with production database backup• Deployment of various script to Create tables, indexes, synonyms, procedure, packages and functions.

• Develop, plan, evaluate, implement and validate guidewire deployments on day-to-day basis. Leads project and discuss technical details with the team member. Responsible for providing recommendations and attaining design approval for new technologies and major enhancements to existing systems. • Provides support to Security in the development of appropriate audit controls and procedures to ensure the integrity and protection of company resources. • Works with customers to understand business objectives in order to ensure functional and technical designs meet requirements and are in compliance with the ACG infrastructure and IS technology standards. • Create, Upgrade and migrate databases from 11g/12c RAC environment to Oracle exadata environment. This involves various deployment activities and troubleshooting database problems and implementing the solution in DEV, QA, UAT and Production environment.• Create ACG Disaster recovery environment using Oracle Dataguard replication for several applications such as Claims Datamart, Sales and Service Insurance system, Guidewire and Automotive Datamart. • Create/Implement database security using Oracle Transparent Encryption technology on ACG Claims, Emergency Road service database environment. This includes encrypting PCI and PII data in the database at the tablespace level.• Created RMAN automated Scripts to implement backups on various ACG databases. Restore the database to Point-in-Time in case of database or application problems. • Run exachk periodically and deploy the recommendations/fix provided in exachk on all ACG exadata databases.• Maintain and responsible for day-to-day activities on Peoplesoft, Sales and service, Liferay, Specialty Lines, Automotive DataMart, Claims DataMart and Guidewire application databases. This involves • Refresh test database with production database backup• Deployment of various script to Create tables, indexes, synonyms, procedure, packages and functions.

• Performing Day to day DBA activities• Working with Different teams and gathering the requirements for the project.• Responsible for end to end execution of projects.• Managing and helping other team members.• Managing 60 TB of Datawarehouse database exist in Exadata X4-2 half rack.• Handling 60TB of Datawarehouse db. in Oracle EXADATA X4-2 (DMA with knowledge on Cell Administration).• Hands on experience on disk and other component replacement without DB downtime.• Worked on X4-2 RACK consolidation. Combined 2 quarter Rack to half RACK.• Hands on experience on adding new serials to Platinum gateway server.• Implemented IORM, DBRM to cap the resource usage on storage/database nodes on EXADATA X4-2.• Installation and configuration of oracle transparent gate for MS SQLSERVER.• Hands on experience on OEM 12c implementation.• Hands on experience on SSIS package creation and transfer date to Oracle from Informix and MSSQLSERVER.• Worked on Oracle RAC implementation in AWS(POC).• Hands on experience in DB restoration in MSSQLSERVER.• Hands on experience in data transformation from Informix to Oracle • Implemented Hybrid Columnar Compression for history tables.• Used Data pump for exporting and importing tables, schemas and table spaces.• Expertise in installation (CRS/RDBMS binaries 10/11g/12c).• Managing Hadoop in cloudera. • Import new users through Hue.• Schedule Data ingestion using spark-submit.• Hands on experience installing Anaconda 3.5 in Hadoop cluster• Implemented SSIS 2008 ETL processes to load data from source files to target tables• Created database link between Oracle 10g and SQL Server 2005.• Administering SQL Server High Availability and Disaster Recovery strategies.• Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.• Worked on configuring SQL Server with minimum privileged access.• Worked on SQL Server 2012 migration from SQL Server 2008.

• Solid Exposure to Exadata Configurations including X2-2, X2-8, full rack, half rack and Qtr rack and the latest X3-8.• Solid understanding of key Exadata features including Hybrid Columnar Compression, Exadata Smart Flash Cache, Exadata Storage Index and Exadata Storage Management & Administration.• Hands on experience in Implement golden gate 11g and integrating with OEM.• Oracle Exadata server & database management (DMA with knowledge on Cell Administration, Linux Administration and management of other Exadata components like Infiniband).• Implemented IORM, DBRM for boosting storage/database performance on EXADATA v2/x2.• Hands on Experience in configuring Integrated Golden Gate on Exadata Machines for data Replication.• Hands on experience in Implementing Oracle Revenue Management and Billing(ORMB).• Hands on experience in implementing OBIEE installation and creating data source.• Configured standby solution for Oracle Ebusiness Database and applications.• Production Support experience in Hyperion.• Troubleshoot issues which arise during patching. • Resolve the concurrent manager, concurrent programs issues and performance issues related to concurrent programs • Create custom concurrent managers, request groups and DB services mapping for load balancing and failover. • Hands on experience on PCP Setup. • Daily health check and proactive monitoring of Production instance. • Daily Database clone using RMAN duplication and Cloning the oracle apps instances (scheduled or on-demand) from prod to test using rapid cloning process. • Sysadmin activities like user creation, responsibility assignment, profile value change etc. • Created shell scripts to automate tasks like patch merging, health checks, post-clone steps, directory clean-up etc. • Support to general technical issues faced by developers. • Support Sev-1 Oracle service requests created for release bugs.

• Quarterly CPU patching with detailed patch analysis. • Troubleshoot issues which arise during patching. • Prepared patch impact analysis and execution plan for Min baseline patches (30 products, 100 patches) for Extended Support on Ebiz 11.5.10. • Resolve the concurrent manager, concurrent programs issues and performance issues related to concurrent programs • Daily health check and proactive monitoring of Production instance. • Monitor the Application System with Oracle Applications Manager (OAM). • Cloning the oracle apps instances (scheduled or on-demand) from prod to test using rapid cloning process. • Modify and track customizations on template files during AutoConfig customization. • Sysadmin activities like user creation, responsibility assignment, profile value change etc. • Generate diagnostic reports using tools like SQLT, TRACEANALYZER, TOAD, Oracle Diagnostics etc • Created shell scripts to automate tasks like patch merging, health checks, post-clone steps, directory clean-up etc. • Support to general technical issues faced by developers. • Support Sev-1 Oracle service requests created for release bugs. • Implement Datapump for 11.2.0.2 in UA environment and refresh database using DP backup.• AWR and ASH report creation for analyze performance issues.

Role : DBAProject : RaceAfricaEnvironment :Oracle 10g, sqldeveloper,linux CentOS,RMAN,XshellDuration : Feb-2009 to Mar -2010Responsibilities: • Installation and configuration of Oracle for production server under Linux CentOS environment.• Configure datagaurd physical stand by for production database.• Upgrade quality server using database upgradation assistant from 10.2.0.1 to 10.2.0.4• Restored PROD database on server crash. • Test Recovery of Production database twice in a week on quality server .• Configure Rman backup with remort server• Applying CPU critical patch update on production server for every 3 months• SQL tunning for application developer team improve performance of loads.

OneAPPS is a leading provider of professional, outsourcing and enablement services for Largecap and Midcap mid-market organizations.It is a concern that placed professional to there client place.Exide Technologies.Exide Technologies, with operations in more than 80 countries and fiscal 2011 net sales of approximately $2.9 billion, is one of the world's largest producers and recyclers of lead-acid batteries. Role : Oracle Apps consultantClient: Exide TechnologiesEnvironment : Oracle core 9i,10g Toad, Oracle Apps 11i and Linux.Duration : Jan-2006 to Jan 2009Responsibilities: • R12 Installation and configuration.• Installation and configuration E-Business suite and upgraded of Oracle database from 9i to 10g(10.2.0.2).• Configure datagaurd physical stand by for production database.• Applied CPU patch for database on every Quter.• User creation and allocating Quota for the users as per server resource availability .• Granting specific privileges and roles to the users.• Implement Datapump for 10.2.0.4 in UA environment and refresh database using DP backup.• Daily increamental hot backups and weekly cold backups using RMAN.