SUMMARY

• 13+ years of professional experience in Software Development Life Cycle experience involving Requirements, Analysis, Specification, Design, Conversions, Installations, Maintenance, Upgrades etc.
• Certified oracle pl/sql developer and oracle Database Admin.
• Certified my sql developer and admin.
• Attended trainings from oracle university regarding Oracle HCM technical and Oracle Finance Technical administration
• Create Fusion application environments for Oracle Cloud services.
• Create, maintain and provide support to Oracle Cluster databases
• Worked with Automation team in creating and testing the automated patch bundle application tool for SAAS environments.
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases
• Experience in general troubleshooting, firefighting, and development of scripts, documentation, issue resolution, and TAR support.
• Well versed in implementing System Management and Monitoring procedures.
• Well versed with User Management, Performance Tuning, and Concurrent Processing Settings.
• Database Upgrading from one server to another using Export and Import utility.
• Expertise in installing Discoverer and integrating to ERP Applications.
• Implement Oracle Cloud ERP,HCM,BI,PROJECTS,SCM services in Client locations
• Ensures Data Validation of integrated tools; Oracle HCM, Success Factor, BI Publisher, and other HR tools.
• Implement Oracle Cloud ERP,HCM,BI,PROJECTS,SCM services in Confidential
• Good Knowledge on Oracle cloud services PASS,SASS environment implementation
• Moved all data from Oracle 11i EBS finance system to Oracle cloud R12 SaaS environment
• Supported and maintained Oracle cloud quarterly upgrades R12,R13(19A,19B,19C,19D).Each upgrade perform common testing of applications as administration and once patching complete make sure all services up and running including BI Publisher/Analytics/import and export jobs from third party services
• Configure and Implement multiple oracle financial modules(AP/AR/GL/PO/INV/OM/Assets)
• Work with finance users and help them if they facing any issues with module like Assest books.GL data fixes and PO or Invoice issues.
• Develop and test custom report as per client requirements in BI publisher for Expenses/Requisitions/GeneralLedger/IntercompanAccounting/Payables/Receivables/Payments/Cash Management/Tax/Fixed Assets/Order Management and other related finance modules.
• Ensures compliance of reporting processes and continuous improvement of those processes. Identifies problems and gaps in current processes, HR systems and correct them.
• Provides training and education to employees on HCM and Time and Labor for routine operations.
• Reports the HR systems related data to higher management by designing and developing standard and ad - hoc reports dat helps to upper management in decision making.
• Performs analysis of large data sets in HR Systems to identify opportunities for improvement dat can be leveraged from the data.
• Develop project plans and update go live dates for each and every module.
• Provide status update to all managers about progress of implementation daily basis.
• Gather requirement for custom Reports needed for cloud HCM and finance modules and worked to build reports. Implement all custom reports in test environments. Provide all code migration dates to each department to do testing on Custom Reports.
• Decide Go Live dates after checking with every one and implement code according to plan.
• Migrated all Data from Ceridian Day force to oracle Cloud HCM system
• Built integration and developed reports from Oracle HCM to Ceridian Day force to upload all employee changes/New hire/Termination/promotions/etc. To Ceridian Day force system. Since for only payroll purpose we using Ceridian Day force.
• Day to Day work on preparing Reports from BI publisher as per HR team requirement and also schedule jobs to send those reports to list of users provided by HR team.
• Build graphical representation of data in BI publisher for presentation purposes.
• Built integration and developed reports to pull data from Day force regarding payroll and transferred to Oracle Finance ERP.
• Expertise in RMAN for recovery and cloning.
• Expert in Configuring Workflow Mailer.
• Expertise in applying security patches.
• Troubleshooting Login, Self Service Application, Jinitiator and Network related issues.
• Experienced in writing UNIX shell scripts and setting up cron jobs for database needs.
• Expertise in Cloning of databases from RAC to RAC and RAC to non-RAC.
• Maintaining Hot Backups, Cold Backup.
• Strong Analytical skills and ability to interact with end-users, managers, and technical personnel.
• Good team player, self-motivated and a quick learner.

TECHNICAL SKILLS

Applications: Oracle ERP cloud R12/13/R19/R20, Oracle EBS 11i/R12, Oracle Application Server 10g AS, Oracle Application Server 9iAS. Weblogic 11g/1C SOA BI PUBILISHER ADF

Databases: Installation, Implementation, Administration, Upgrading and Troubleshooting of Oracle 8i, 9i, 10g RAC, 11g RAC.

Tool: /Utilities: TKPROF, STATSPACK, Explain Plan, ORACLE Bug DB, Oracle Demantra, OEM.

Operating Systems: Windows NT/2000/2003/XP, RHEL, Sun Solaris, AIX, HP-UX.

Others: AD Utilities, SQL * Loader, TOAD, XML/BI Publisher, Workflow Builder, SQL Developer.

PROFESSIONAL EXPERIENCE

Confidential, Arlington County, Virginia

Sr. Oracle Cloud Consultant/Project manager

Responsibilities:

• Implement Oracle Cloud ERP,HCM,BI,PROJECTS,SCM services in Confidential
• Good Knowledge on Oracle cloud services PASS,SASS environment implementation
• Moved all data from Oracle 11i EBS finance system to Oracle cloud R12 SaaS environment
• Supported and maintained Oracle cloud quarterly upgrades R12,R13(19A,19B,19C,19D).Each upgrade perform common testing of applications as administration and once patching complete make sure all services up and running including BI Publisher/Analytics/import and export jobs from third party services
• Configure and Implement multiple oracle financial modules(AP/AR/GL/PO/INV/OM/Assets)
• Work with finance users and help them if they facing any issues with module like Assets books.GL data fixes and PO or Invoice issues.
• Develop and test custom report as per client requirements in BI publisher for Expenses/Requisitions/GeneralLedger/IntercompanAccounting/Payables/Receivables/Payments/Cash Management/Tax/Fixed Assets/Order Management and other related finance modules.
• Also since cloud ERP not provided efficient FSG reports like in oracle EBS 11i and R12.Prepared cloud database and daily moved all finance statement generated related tables to this database. Prepared custom reports similar to ebs 11i and r12.Made changes of this custom reports as per finance VP requirements.
• Prepared financial reports, developed processes, and performed variance analysis in accordance with business plan using Excel, Oracle Discoverer and Oracle Financial Reporting.
• Prepared more TEMPthan 700 finance reports in BI publisher for managers for day to day use and scheduled reports to users mail id as requested
• Prepared 300 plus HCM and Taleo reports as per managers and users requirement.
• Provides training and education to employees on HCM and Time and Labor for routine operations. Trouble shoot all Time Card issues for employees who facing issues.
• Develop project plans and update go live dates for each and every module.
• Provide status update to all managers about progress of implementation daily basis.
• Gather requirement for custom Reports needed for cloud HCM and finance modules and worked to build reports. Implement all custom reports in test environments. Provide all code migration dates to each department to do testing on Custom Reports.
• Attended trainings from oracle university regarding Oracle HCM technical and Oracle Finance Technical administration
• Decide Go Live dates after checking with weekly call with finance managers and HCM mangers and implement code according to plan.
• Prepare project plan with go live dates and explain project progress in weekly team calls. Make necessary changes if their is any new requirement or plan changes.
• Provided trainings to 1000 plus employees on Finance system how to use it and provided Trainings to employees how to use HCM functionalities.
• Facilitated multi-unit work sessions to determine requirements, screen flows and processes.
• Liaised between management and users to help define requirements and facilitate work flow.
• Interfaced with Tech Support, Helpdesk and Smart Dog to define and improve support procedures and capabilities through trainings, communications, and documentations across related Oracle projects and future system upgrades.
• Develop project plans and update go live dates for each and every module.
• Provide status update to all managers about progress of implementation daily basis.
• Gather requirement for custom Reports needed for cloud HCM and finance modules and worked to build reports. Implement all custom reports in test environments. Provide all code migration dates to each department to do testing on Custom Reports.
• Attended trainings from oracle university regarding Oracle HCM technical and Oracle Finance Technical administration
• Build graphical representation of data in BI publisher for presentation purposes.
• Support and maintain 11i EBS applications and Databases
• Oversaw all aspects of full life cycle HRMS (OTL, HR & Payroll) in a Financials Environment.
• Implemented Quick Reference Guide training materials for plant and corporate office employees.
• Configured SCM cloud in Confidential and implemented custom Requistions workflow specifically designed for Confidential
• Work on Oracle Fusion Audit system and provide details to auditors
• Work on third party integrated services like Dayforce,wageworks,oracle Taelo to Oracle Fusion Financial ERP and HCM.resolve any import export jobs fails from oracle fusion cloud to third party services
• Write own sql queries and pull data from oracle SaaS finances database and prepare excel sheets as per client requirement
• Identify slow running process in cloud and work with oracle team to make sure request complete in time. If needed perform tuning analysis and provide details to oracle representatives
• Created separate database and applications in PaaS environment in order to support custom reports. Since oracle provided reports in SaaS are not compatible to users. So daily we pull data from SaaS to PaaS.Prepared Excel reports as per our requirments.Written coding to pull this reports from SaaS to PaaS database.
• Work directly with personnel, projects and other departmental technical consultant as required in a functional role.
• Work on Finance administration and support activities
• Implemented Time Card system for all employees’ full time/part time/hourly employees/interns.
• Implement Oracle Fusion HCM services
• Analyze data trends of Comings and Goings, Employee Turn Over, Workforce Demographics, Salary Ranges, provide analysis to senior leadership for Human Capital decisions making.
• Update Oracle HCM database with any HR related changes include New Hire, Separation, Employee’s Department & Location changes, Job title change and Salary adjustments or Promotion.
• Work closely with HCM team and resolve issues
• Work on third party integrated services like Day force, wage works, oracle Taelo to Oracle Fusion Financial ERP and HCM.
• Attend monthly scheduled calls with oracle representative regarding each module upgrade process noledge and perform changes needed according to Confidential systems
• Verify all Security patches release by oracle for cloud environments and make sure all patches applied in you're instance.

Confidential, Boston MA

Senior Fusion Apps admin

Responsibilities:

• EBS upgraded from 11.5.10.2 to R12.1.3
• Oracle Database upgrade from 11g to 12C
• Work closely with Finance and HR team to planning and gathering requirements. Schedule release according to their requirement.
• Support finance modules in R12.1.3 like
• Installed Apex ORACLE REST DATA services version 5 for new project
• Regularly working on EBS refresh cloning DEV/QA environments from production
• Patching, cloning of R12 applications and databases
• Worked on pl/sql coding and performance issues in production databases
• Worked on BI publisher,ADF integration with EBS R12 and xml and reports generation
• Worked on Daily users tickets login issues, Oracle forms and Reports issues
• Create users and schemas assign responsibility and menu as per user requirement using user management
• Created workflows in R12 instances make sure up and running 24X7
• Created New RAC databases and configuration of EBS instances
• Moved oracle database and EBS application to AWS environment
• Upgraded oracle databases and WebLogic services present in AWS servers
• 24*7 on-call production support handling weekday, weekend, nighttime, and holiday outages with focused effort to minimize downtime.
• Performed Non-RAC to RAC and RAC to Non-RAC cloning.
• Managed databases on Exadata
• Moved oracle database and EBS application to AWS environment
• Upgraded oracle databases and Weblogic services present in AWS servers
• Tracking invalid objects, compiling and validating the invalid objects.
• Troubleshoot several user issues like apps login issues, dbc file issues, JDBC connection pool issues, yellow bar issue and other connectivity issues.
• Resolved the apache or http server issues of Oracle EBS by checking the log files.
• Monthly EBS deployment scripts via Jenkins configure and execute scripts and troubleshoot any issue during Jenkins deployment

Confidential, Massachusetts

Sr. Fusion middleware Admin

Responsibilities:

• Support and maintain all EBS R12.2 installation patching in R12.2
• Audit confirmation in EBS R12.2 databases
• Installed Weblogic 10.3.6 and ADF 11.1.1.7 as part of OHI Implementation
• Weblogic and OID Integration for OHI and SOA
• Setup JSTAT Monitoring (for Java Memory Usage and GC) in Weblogic
• Setup automated JMX Ports pickup for multiple managed servers
• Develop Reports using pl/Sql as per requirement for finance system and provide reports to consultants.
• Check pl/Sql coding present running in system. If any performance changes fix code and improve performance of the system.
• Schedule jobs to pull required reports and provide to users.
• Interact with admin and gather requirements about reports needed for project.Devlop reports as per requirement.
• Setup WLST monitoring for Leaked connections in Weblogic
• Monthly SOA Purging to cleanup old instances
• Implemented Enterprise User Security (end-to-end) for all the Oracle Databases
• Automated Complete Oracle Database User and Role Management via EUS and Shell Scripting
• Automated Role v/s Table Grants via Shell Scripting
• Automated the Daily Oracle Database User Reporting for the Audit Team via Shell Scripting
• Automated the Config Migration process (used in OHI) via Shell Scripting
• Automated Post Clone steps for OHI Database cloning via Shell Scripting
• Netbackup and Disk backup Scripts for Database RMAN backups
• Space monitoring and detailed html reporting for the nas filesystem used for DBAs backup/download/trace/dump files
• Other Shell Scripts - Weblogic Log Rotation, DG Report collection, Weblogic Server startup-shutdown, FRA monitoring and alerting, Oracle Database User Reports, Monitor changes in SQL PLANS, Various OHI Daily Reports
• Basic Performance Tuning using OEM and DBMS SQLTUNE
• Monitoring database/application in Oracle Grid 11i/12c
• Generated OEM Production Tablespace Reporting for pre alerting Tablespace usage
• Generated OEM Heap Memory Usage Reporting for Weblogic Servers
• APEX Tasks like Building and Managing Workspaces, Users, SQLs, Images
• RMAN Upgrade from 11.2.0.2 to 11.2.0.3
• Schema/Table refresh using Data pump and DB link
• OID Administration, Monitoring, and Troubleshooting
• Shell Scripts for OID Monitoring - LDAPBIND, Log Errors, Space Check, Super User logins
• Generating AWR and ADDM report for investigating the cause of performance issue
• Code Migration till production server
• 12/7 On call Support
• Coordinate with Offshore for Tasks and Shift-Handoffs
• Worked as an active team member in all phases of Supporting and Enhancements.
• Worked as Offshore Primary Contact for OHI Implementation and Support
• Upgraded database from 11.2.0.2 to 11.2.0.3 as a part of OHI implementation
• Create/Upgrade the 11g databases manually and using DBCA/DBUA on RAC
• Perform Database Clones, Restores and Recovery using RMAN
• Create Restore points, perform Database Flashbacks (via SQLPLUS and RMAN), manage FRA
• Installation of Weblogic 10.3.6 and Creating Databases for OHI Implementation
• Installed Weblogic 12C
• Worked with Oracle Corporation & opened TARs (SR’s) to resolve number of bugs
• Daily troubleshooting in response to problem tickets and production support
• Pro-active checks to ensure database availability and providing support for customer issues
• Work with development and operations staff in resolving problems quickly and efficiently
• Customer interaction for issue resolutions and discussions

Confidential, Redwood Shores, CA

Sr.Oracle Admin (DBA & Development)

Responsibilities:

• Create Fusion application environments for Oracle Cloud services in PaaS and SaaS environments.
• Develop and support 3000+ plus databases and support multiple development teams.
• If developers facing any performance issues
• Create, maintain and provide support to Oracle Cluster databases in PaaS and SaaS environments.
• Build environments based on Oracle Virtual Assembly Builder and Oracle Virtual Machine,
• Worked with Automation team in creating and testing the automated patch bundle application tool for SAAS environments.
• Develop Reports using pl/Sql as per requirement for finance system and provide reports to consultants.
• Check pl/Sql coding present running in system. If any performance changes fix code and improve performance of the system.
• Schedule jobs to pull required reports and provide to users.
• Interact with admin and gather requirements about reports needed for project.Devlop reports as per requirement form admins
• Worked on performance tuning, JVM Heap size tuning of Oracle Weblogic servers.
• Troubleshooting issues on Weblogic server configuration, startup and performance issues.
• Experience in writing shell scripts for automating routine tasks, creating monitoring scripts and setting crons.
• Experience in writing Weblogic WLST scripts for automating routine tasks and configuration of Weblogic environments.
• Creation of Custom Applications, menus and responsibilities.
• Maintenance of Oracle Databases and Oracle Applications.
• Working on System Administrator Activities.
• Installation of Oracle Database and Oracle Applications.
• Responsible for supporting multiple instances, activities include installation, maintenance and upgrade of Oracle E-business Suite / Fusion databases.
• Supported cross-product support across entire EBiz suite and solved database/middle-tier issues with the development and release of Application products.
• Worked on latest EBS / Fusion applications technology as well as Portal, IAS, Enterprise Manager.
• Install, configure and troubleshoot all components of Oracle Applications techstack and maintained multiple Oracle databases.
• Perform day-to-day database administration and ensure integrity, security and availability of applications environments.
• Provisioning of Fusion Applications environments and Troubleshooting on FA environments relating Middle Ware and Identity Management.
• Manage storage and host resources for all the development and QA teams.
• Regular database activities, backups monitoring, issue resolving through EMS(Environment Management System Tool)
• Conduct training and mentor new hires on the core environment management platform.

Environment: Pl/Sql, Red Hat Linux 5, OEL 5.4,Windows 2003,11g R1, Oracle Applications EBS R12.1.2, 11g RAC,TOAD, Developer 6i. FUSION APPLICATIONS, OVM servers, PAAS, SAAS

Confidential

Applications DBA/Oracle Developer

Responsibilities:

• Develop Reports using pl/Sql as per requirement for finance system and provide reports to consultants.
• Check pl/Sql coding present running in system. If any performance changes fix code and improve performance of the system.
• Schedule jobs to pull required reports and provide to users.
• Interact with admin and gather requirements about reports needed for project.Devlop reports as re
• Performed database upgrade from version 10.2.0.4 to 11.2.0.3
• Moving custom codes from test databases until production, code migration through HPPPM. Involved in upgradation of Oracle Applications version 11.5.10.2
• Maintained Applications file system like re-link applications programs, copy files to destinations, and generate message files etc. using ad utilities.
• Developed various shell scripts for daily schema refreshes using data pump.
• 24*7 on-call production support handling weekday, weekend, nighttime, and holiday outages with focused effort to minimize downtime.
• Performance tuning of Oracle Database, applications and queries
• Conduct Pre-patch analysis for different types of patches as requested by customer.
• Configured Workflow Notification Mailer for inbound and outbound processing.
• Maintenance and support of Development, Test and Production environments.
• Converted single instance e-business database to Oracle 11g RAC