SUMMARY

• 16+ years of IT experience of Program management involving Oracle Applications(ERP)+DB and fusion technology using different methodologies Oracle Unified Method(OUM), AIM and agile
• Project Management professional - PMP Certified
• Expert in setting up and managing onsite/offshore 24x7 managed services(support)
• Involved in Sales initiatives, played the role of solution architect, resource allocation planning, PMO office, created proposals and presented in Orals.
• Involved in massive 11i, R12 implementation projects, and multiple upgradation projects from 10.7, 11.0.X to 11i(11.5.1 thru 11.5.10.2) to R12.1.3 and databases starting from 7.3.2. to 12c
• Expertise in configuring and maintaining Oracle Apps Modules like financial, manufacturing, ASCP and maintaining a separate Advanced Planning and Scheduling (APS) instance
• Senior in the Emerging Technology group in Fujitsu Americas.
• Well versed in Oracle APPS DBA, Unix shell scripting, JSP, Java and OC4J,
• All Fusion middleware SOA-BPEL, Jdeveloper, Demantra, OBIEE, Hyperion, Oracle Access manager, OID, Oracle Transportaion Management(GTM), weblogic, 10gAS.
• Excellent communication skills, strong analytical and logical abilities in business analysis and technical documentation
• Global cross culture work experience in GE-ITALY, SONY- Japan and various cities in USA and India.
• US Green Card Holder

PROFESSIONAL EXPERIENCE

Senior Program Manager

Confidential

Responsibilities:

• Leading multiple Project teams to deliver business solutions and manage Project stakeholders and customer expectations
• Part of the Oracle PMO.
• Provide effective Client Engagement and Project Management following both PMP and Cognizant’s standard policies
• Periodic evaluation of the status of program; Planning, risk evaluation & executing their relevant mitigation plans
• Effectively manage multiple sub projects and releases in parallel as an integral part of the program
• Derive deliverables, schedules, work plans & primarily accountable for managing the delivery
• Weekly & Monthly Program review with the Customer management to appraise on the program status
• Created multiple sales proposals and did presentations, orals to the clients on the various upgrade (including R12.2), platform (OS - any Endian format) migrations of RDBMS & ERP and fusion implementations.
• Periodic analysis & review of the CSAT and program & project status with the senior management
• Handle escalations and derive amicable solutions across multi-disciplinary project teams involved
• Budget, cost & resource forecast and to maintain the revenue profit margin through various strategies
• Manage multiple project teams,motivating them, appraising them & managing their performance
• Manage the sucessful transition operation of Keybank leasing, SUNGL, Supertrump, procurement and financials, ariba systems from previous vendor (Wipro)
• Prepared SLAs, Lead iTAR- access security initiative
• Participated in CAB to propagate CRs from Dev to QA and then PROD.
• Was single point of escalation of all the support issues for the PROD and multiple nonprod instances in JPMC, Swiss Re, Wellcare, Cigna, Keybank for Xcelys, Oracle Financials accounting, OBIEE, Hyperion and been the point of escalation
• Senior Program/project Manager for clients Xeta Technologies, E&Y, Phillips Service center, Longos brothers, Toyota NA, Jostens Inc, Confidential, Berlin industries, Yamaha, Toyota Boshuka
• Organize Weekly client meetings, prepared Weekly status report to clients, templates for daily status health check for applications, handle change management, offshore resources management and offshore time management.
• Prepared and presented proposals and solution design documents for various clients
• Managed the upgrade of Oracle applications from 11i, R12 to R12.0.6
• Architected the SSH option for Mobile web applications instead of Telnet.
• Innovative solutions like a custom jsp that can start/stop MWA in version 11.5.8
• Migrated the PROD system from non-RAID disks to RAID 10 disks
• Worked closely with Functional team to solve issues on Enterprise Budget and planning, payroll extract
• Managed cross functional team involving SQL server, Unix admin, Demantra, SOA-BPEL, Hyperion and lot of other Fusion applications.
• Prepared solution design, estimation and Configured Dataguard setups and Parallel concurrent processing
• Audited the installation of R12 PROD system running currently with HR and Payroll system
• Performed the monthly updates of Vertex.

Confidential

Responsibilities:

• Upgrade the instance to 11.5.10.2 for both US english and Canadian French
• Upgrade from Oracle Internet Time (OIT) to Oracle Time & Labor
• Install Restricted HR to use it with OTL
• Upgrade the Oracle Internet Expenses (OIE) to patchset K
• Run datainstaller for loading data to HR tables that are related to OTL.
• Install SOA 10.1.3.3 BPEL server in HA configuration and load balancing. Ensure that it is able to connect to the EBS.
• Deploy custom Bpel applications using ANT
• Understand the usage of Jdeveloper and deploy it on development BPEL servers.
• Involved in migrating from Jinitiator to SUN-JVM for Microsoft Vista desktops
• Configure workflow for both out-bound and in-bound processing
• Solved the issue with French email approval by upgrading the xml parser
• Configure printers using CUPS
• Designed the production instance with BIG IP and separate web, forms, concurrent manager, database tier per requirements of the client. Also designed the development instances as they moved the whole instance from SUN OS to Linux.
• Upgraded the instance from 11.5.4 to 11.5.10.2
• Upgraded the database from 8.1.4 to 9.2.0.8 and then to 10.2.0.3 RAC with dataguard
• Applied the 10g inter-operatability patches
• Migrated the database from SUN OS to Linux using the export and import method. A vanilla database has to be created on the Linux with all the necessary datadictionary, tablespaces, users and grants created prior to this.
• Migrated the Applications 11.5.10.2 from SUN OS to Linux. This was done using the advanced Staged appl top method. On Linux the forms and http tier were separated using the forms metrics server-client architecture based on the client request. Also the concurrent managers were separated from the DB server.
• Worked with Unix admins in issues faced while installing 32-bit Linux for Applications and 64-bit Linux for DB and OS patches.
• Identified the problem with the SAN disk configuration if it is symmetrix where clarion doesn’t. Worked with the UNIX admin in resolving that.
• Applied latest Daily Business Intelligence 7.3
• Worked with network and functional team on the connectivity of Application Desktop integrator with the EBS.
• Solved the REP-3000 problem and the ADI report publish problem by installing a x-server and propertly defining the Display parameters
• Configured SMTP and IMAP accounts for workflow mailer with an inbox in microsoft exchange.
• Defined and documented the production and development instance design, the cloning and refresh strategy, backup/restore strategy, daily maintenance .
• Configuring the load balancing of apps tiers, solving the issues and documenting all post load balancing tasks
• Working on the performance tuning of custom Discoverer sqls

Confidential ., Itasca, IL

Oracle Applications DBA

Responsibilities:

• Upgraded the Production System from 11.0.3 to 11i using the maintenance wizard
• Designed the 11i Production System with 2 apps tier and 1 database + admin tier with SAN disks
• Configured the load balancing with all the HTTP + Forms on one apps tier and RF (mobile web application MWA) on the another apps tier, which is being appreciated by the client DBA manager
• Configured multiple JServ load balancing on HTTPS + Forms apps tier
• Configured MWA dispatcher to load balance between 2 sets of 6 MWSA telnet ports
• Developed Unix Script for switching the RF from one set of ports to another on a daily basis when the warehouse shift changes wherein the script is designed in such a way that no existing users will be affected by this change and new users will be redirected to the next set of ports
• Developed JavaScripts for monitoring the RF users and performing basic tasks such as messaging, broadcasting, and killing the user sessions to get rid of "already signed on" message, which is better than Oracle provided MWA Server Manager in a way that this can be executed from the Unix Shell or Windows command prompt and does not require JServ, and can be added to a batch job for monitoring purposes
• Tuned the RF performance by analyzing the trace report generated by the RF and by properly scheduling the gather schema statistics
• Configured standard manager and custom manager with different workshifts and processes to suit the client needs
• Configured 3 separate database listener ports for Forms, RFs, Concurrent Manager to reduce the SQL*Message to Client Waits
• Performed the load monitoring tests, generating charts, and sent them to client on daily basis
• Tuned the applications and database by figuring the custom concurrent programs and root cause of their performance bottleneck with the help of wait events
• Cloned the development, patch instances with the hot backup of prod on a regular basis using Rapidclone and also made this to run in a batch mode by changing the copy of adcfgclone.pl
• Applied patches to production environment
• Performed 3 successful mock upgrades from 11.5.7 to 11.5.10.2
• Performed the REAL PROD UPGRADE single-handedly
• Applied Italian and Spanish NLS versions for the users in Rome and Madrid
• Merged and applied the iHelp for US English, Italian, and Spanish
• Solved the issues in CRPs that followed mock upgrades with custom.pll(s) and forms, and check printing in Evergreen
• Solved the post upgrade issues in AP and GL module, load balancing problem and support the LIVE instance
• Gave suggestions to the client side DBA about improving the process followed in maintaining the Applications and cloning DEV and TEST instancesm, also fine-tuned the applications for faster throughput

Confidential ., San Jose, CA

Oracle Applications DBA

Responsibilities:

• Worked on the fresh installation of Oracle Apps 11.5.10 CU1
• Converted to Multi-org after initial Financial and HRMS setup
• Applied 11i.HR.K family pack
• Responsible for running data install utility for HRMS and Payroll
• Upgraded Payroll tax Q Series (QUANTUM) version 2.7.0 and solved issues related to Quick pay run for Payroll
• Installed and configured Application Desktop Integrator (ADI) and the Web ADI for GL
• Installed Discoverer administrator edition, configure plus and viewer, and created EUL
• Evaluated the performance of custom concurrent programs, forms, MODPLSQL using Oracle CEMLI tool
• Solved the query problem in Approval Management Engine
• Solved the expense report lines for the items not getting generated problem in internet expenses
• Create custom top XBOL TOP and made it accessible for SSWA, MODPLSQL, Forms, concurrent programs
• Migrates workflow, AOL from development to CRP instances using WFLOAD, FNDSLOAD respectively
• Created printer queues, configured printers in ERP for all the client printers and responsible foe OPTIO printers that is check printing
• Provided a solution for document attachments for each invoices in Payables
• Installed Apache and accessed the invoice documents from a 3rd party software thru a URL
• Designed the JSP version of PCO LOG that can be called from Oracle ERP

Confidential, San Diego, CA

Oracle Applications DBA/ Sys Admin/ Change Management Coordinator

August 2004 - September 2005

• Migrated AOL objects using Mercury Object Migrator and Kintana Object Migrator
• Upgraded Object Migrator from 4.1 to 5.1 and then to 6.1 (for 11.5.10)
• Configured remote and network printers to Unix using /etc/hosts, Sam, Jet direct, and Oracle Applications
• Defined types, styles, and drivers
• Defined PCL initialization code in drivers
• Performed user and responsibility management
• Registered custom forms and concurrent programs
• Performed flex field management
• Supported Developers in packaging their change requests from PVCS
• Provided a case study of upgrade from 10.7 to 11.5.10 and solved issues during upgrades
• Documented all the problems and solutions faced
• Designed and maintained the audit report of the users not having the 30 days password change rule
• Designed and maintained the audit report of the users not logged in for some time
• Designed and maintained the audit report of the list of new responsibility and the authorized owner
• Designed and maintained the audit report of the periodic concurrent requests scheduled by users who left Sony and scheduled by their replacements
• Identified descriptive flex fields not registered in the applications but used by PL/SQL scripts at the backend
• Designed and maintained the audit report of the users and concurrent requests having deleted printers as their default printer
• Designed and deployed a tracking system for the change requests using Oracle Forms 4.5, AOL setups, Unix Shell Script and Java, OC4J, PVCS
• Developed a periodic report which gives hourly status of the change requests
• Changed the existing process to make it compliance with Sarbenes-Oxley (SOX) audit
• Conducted weekly change management meetings with various units of Sony and discussed agenda and change requests

Confidential, Japan

Oracle Applications DBA/ Sys Admin

Responsibilities:

• Involved in Oracle EBS implementation for the Vaio division, which involves supporting the end-users in all their bench marking tests and CRP till they Go Live
• Defined users for end users and assigned correct responsibilities
• Defined responsibilities with seeded or custom request groups and menus with proper exclusions
• Created a CUSTOM TOP wherein the developers will put their custom Forms, Reports, SQLs, scripts, HTML, JSPs, and Java classes
• Registered the custom forms and reports and ensure proper execution
• Registered custom Shell Scripts and JSPs and set to execute them through menus in applications
• Defined custom request sets
• Responsible for printer management
• Maintained system and user profile options
• Managed concurrent processing and created Custom Managers with specific specialization rules and workshifts based on the business requirement
• Managed and maintained flexfields
• Responsible for installing patch, testing, development, and QA instances of Oracle 11.5.9 suite on two tier architecture
• Enabled autoconfig
• Upgraded the database from 9.0.2.3 to 9.0.2.4
• Upgraded database from 32-bit Oracle to 64-bit Oracle
• Applied Oracle Application tablespace model (OATM), which is the latest model
• Applied the RDBMS patches (OPATCH) and Applications patches (ADPATCH)
• Installed and maintained OC4J to support third party applications
• Took and monitored regular backups
• Configured and ensured that dblinks between OLTP and APS are using IPC protocol
• Upgraded Discoverer to 4.1.47
• Created and maintained end user layer (EUL)
• Restored and cloned both the RDBMS and Applications using Rapid clone (adcfgclone.pl, adpreclone.pl)
• Monitored locks on schema objects, long running concurrent requests, SQL performing more I/O, daily CPU and memory message, statspack report (sp report), row chaining and other performance tuning related activities
• Developed and maintained Unix Shell Scripts and PL/SQL procedures for monitoring the system status and mailed when problem occurs
• Supported the development team via analysis, troubleshot, and seeked the technical assistance of Oracle by raising TARs

Confidential, MO

Oracle Applications DBA/ Sys Admin

Responsibilities:

• Involved in EMC implementation of Oracle to have a single database instance shared by multiple divisions within the Motors and Appliance Controls (MAC) business group
• Followed technology, governance, and application standards developed by the Emerson IT Shared Services organization which had Manufacturing, SCP, Demand Planning, Distribution such as Inventory, Order Management, and Quoting modules
• Defined custom responsibilities
• Validated this with functional persons and End Users
• Created and migrated users, custom responsibilities, custom menus, custom functions using Kintana Object Migrator
• Created custom request groups with seeded and custom reports
• Coordinated with the validation of these with end users and prepared the final ready to go for production
• Assisted the development team with Sys Admin expertise, raise TARs and suggest and deployed feasible solutions

Confidential

Oracle Applications DBA/ Sys Admin

Responsibilities:

• Involved in implementation of E-business suite with a business model that separates Advanced Supply Chain modules from the other E-business modules
• Installed EBS and added new modules
• Supported the development team via analysis, troubleshot, and seeked the technical assistance of Oracle by raising TARs
• Analyzed and applied patchset G, H for PO (iProc), INV, DM, AP, AR, ASCP, and DP on different instances
• Performed monitoring and supported smooth execution of inbound and outbound interfaces and data loaders
• Upgraded the database from 8.1.7.1 to 8.1.7.2 and 8.1.7.4
• Upgraded database from 32-bit Oracle to 64-bit Oracle
• Applied the hot fix on Demand Planning (DP) module as recommended by Oracle
• Assisted in changing the status of batch in demand plans (bug in Patchset G but automated in Patchset H)
• Created and maintained application end user
• Allocated proper responsibility for the users created based on the requirement
• Performed printer management
• Solved issues regarding MSONEW and MSONWH64 in ASCP module and ensure smooth running of plan
• Applied the RDBMS patches and application patches (ADPATCH)
• Upgraded Forms Server 6i to patch set 8 and 9 and installed the required inter-operatability and additional patches
• Performed applications management such as Demand Planning, Oracle Express server, Discoverer Viewer and Plus, Mobile Web Application (MWA) Servers
• Installed and maintained OC4J to support third party applications
• Responsible for backup, restore, and clone both the RDBMS and Applications
• Performed migrations of AOL objects across instances using ODWA and a customized migration tool via FNDLOAD
• Monitored locks on schema objects, long running concurrent requests, SQL performing more I/O, daily CPU and memory message, statspack report (spreport), row chaining, and other performance related activities
• Developed and maintained Unix Shell Scripts and PL/SQL procedures for monitoring the system status and mail when problem occurs

Confidential, CA

Oracle Applications DBA

Responsibilities:

• Supported the development activities of one-day financial close project
• Worked on split project that involved replicating the 11.0.3 applications from the source instance in Sony, New Jersey and tailored it to the needs of Confidential
• Provided production support for the Sony 10.7 instances also
• Studied and analyzed the production database
• Supported the Applications using the utilities ADADMIN, ADCTRL, and Concurrent Manager
• Resolved problems on roles and responsibilities of applications users
• Maintained and took care of tablespace and file system
• Developed and maintained Unix Shell Scripts and PL/SQL procedures for the interfaces to transfer data inbound and outbound Oracle databases from the other database systems
• Refreshed the production instance using the backup datafiles and the technology stack from east coast instance
• Configured the form and web components and maintained it for the same
• Implemented forms server load balancing
• Configured Secure Sockets Layer (SSL) using Encore
• Configured TCF for pegging and action export functionality
• Configured Workflow 2.0.3
• Monitored and supported the production 10.7 database and solved issues regarding locks, storage requirements, user security maintenance, and closed tickets raised by the end users
• Applied Oracle Application patches using adpatch
• Coordinated with Oracle Consultant and figured out the merits and flaws in the Applications maintenance model and worked on removing the flaws

Confidential, Danbury, CT

Oracle Applications DBA

Responsibilities:

• Supported the Oracle database and Oracle Applications from offshore (Mumbai)
• Worked in a team that solved the problem within the time restrictions
• Participated in R&D and suggested improvements involving the database and applications
• Studied and analyzed the production database going to the client site
• Set up the offshore team and system
• Received the case calls logged by the end users
• Diagnosed the problem and came up with a solution
• Applied the solution and got the client's acceptance
• Applied the patches on the application using ADPATCH
• Supported the applications using the utilities ADADMIN, ADCTRL, and Concurrent Manager
• Resolved problems on roles and responsibilities using Sys Admin
• Developed and maintained Unix Shell Scripts and PL/SQL procedures for the interfaces to transfer data inbound and outbound Oracle databases from the other database systems
• Migrated the Oracle databases and the Oracle Financial Applications running in the production environment to their latest versions respectively
• Upgraded the Oracle databases and Oracle Financials from 7.3 and 10.7 to 8i and 11i respectively
• Upgraded 22 such databases to 11i
• Performed the pre-migration steps such as checking the system tablespace, archive mode, and auditing
• Installed Oracle 8i software
• Ran the migprep to prepare the Oracle7 DB for migration
• Upgraded the Oracle Database 7.3.4 to 8.1.6(8i) using migration utility
• Performed all the post-migration steps such as changing the pwd of OUTLN user and converting Longs to LOBs
• Applied the patches both for the database and for the Applications 11i
• Took regular backups such as logical backups daily and physical backups on a time chart basis (complete, cumulative, and incremental)
• Migrated the Oracle Applications from 10.7 to 11i
• Applied patches on the Applications using ADPATC
• Worked on the New Lending System that had 4 Oracle databases in Unix and 3 databases on NT and had one standby database that was in Kingswood, UK that kept itself updated with respect to the primary database in Italy on a daily basis and in case of any disaster the standby database was activated and would become the production server
• Created the standby database in Kingswood, UK
• Wrote Shell Scripts to transfer the logs from Mondovi to Kingswood, applied the logs, and activated the standby database
• Transferred the using CONNECT Direct
• Created 3 databases in NT and 1 in Unix and performed maintenance of all the databases
• Took regular backups such as logical backups daily and physical backups on weekly basis
• Planned and prepared the disaster recovery manual for primary and standby databases

Confidential

Oracle DBA

Responsibilities:

• Worked with ATLAS, which is a system for Collections Management, with Oracle 8i as back end, and the functionality deals with the tracking and collecting back of loans from defaulted (delinquent) customers
• Involved in monitoring and scheduling of import and export jobs in the database, maintaining and controlling access to different functionalities of the application for different users, providing full fledged functionality for importing the data from data files provided by the host (mainframe) into the ATLAS system's database through a series of import options, filters, prioritization options and worklist optionsCreated database in a distributed environment using dblinks
• Used NLS parameters for Japanese characters
• Took regular backups
• Created and assigned new users and roles
• Imported and exported data
• Created and maintained primary structures and objects
• Performed query optimization using TKPROF and Explain Plan
• Created and assigned new users and roles
• Imported and exported data
• Created and maintained primary structures and objects and performed query optimization
• Worked in the development phase of the Material Management
• Performed the internal quality assessment of personnel and payroll
• Responsible for project management
• Reviewed the coding done by the Peers