Executive Summary

• Managed Global Oracle E-Business (Finance/HR/CRM), OBIEE, Hyperion Technical Architecture portfolios.
• Managed DBA teams supporting various applications with database size up to 10TB.
• Managed Data Warehouse for OBIEE Applications.
• People management skills including conducting performance evaluations and provide guidance.
• Have a Solid Technical understanding of Oracle ERP – Database – Business Intelligence & SOA Technology Suites.
• Have Lead 4 Full Life Cycle Oracle ERP Financial & HRMS Implementation and participated in 4 implementations (Global Experience).
• Extensive experience with Data Warehouse and ETL/Data Integration tools.
• 18 years of experience working in various roles in the Information Technology field.
• 10 years of experience developing & Architecting Meta Data Management and Enterprise Application Integration solutions.
• 8 years - Strong Information Technology Program Management experience.
• Proven ability to bridge technology and business goals to provide productive solutions.
• Experience in interfacing with key business units including Marketing, Finance, Operations, Design and Development in a multi-cultural environment.
• Extensive knowledge of Systems Development Lifecycles(SDLC) and Project Management Standard Operating Procedures (PMSOP)
• Certified ITIL - Foundations

Technical Skill Inventory

RDBMS Technology: Oracle DB (9i, 10g,11g), MSSQL, MySQL, Oracle Development Suite, Oracle HA Solutions (RAC), ASM
Business Intelligence : XML – BI Pub, Oracle DWB, Oracle Data Mining (OLAP, OLTP) Oracle Discoverer, Oracle DBI, Hyperion
Web / Application Server: Oracle 9iAS, 10G, Oracle Portal, SSO
IDE / Prog. Language Knowledge: HTML, DHTML, SQL & PL/SQL, Shell Scripting, Perl/TK, and TCL & Shell, Visual Basic, XML, Java & J2EE, SOAP & SOA.
Oracle E-Business Technology: Oracle 10.7, 11i, 12i
Functional Knowledge: Order Management, Order Entry, AOL, AR, BOM, INV, GL, AP, PO, ASSET, Advance Pricing, iPayment, iProcurement, iReceivable, iRecruitment, Payroll, TCA, Campaign Management, HRMS Self Service, Comp Work Bench, OLM, OLB.
Full Life Cycle Program Managed: Order-To-Cash, Procure-To-Pay, Global Data Warehouse / Analytical (Financial & HCM Analytics), OBIEE Implementation seeded & Custom analytics, HCM Financial Implementation. Project Accounting (Clarity – PPM – Oracle)

Professional Experience

Confidential, Oct 2007 – Present Technical Lead, ERP Applications and Database Administration Provide Technical Leadership, set goals and standards within the department, and oversee day to day operations.

• Provide advice to the senior management on all technical and architectural decisions.
• Built Application and Database SLA’s in conjunction with the Business Partners and End Users.
• Managed projects to migrate an EBS single instance DB to 11gR2 RAC instance with ASM.
• Managed a project to implement Data Guard for EBS Application database at a remote site for DR.
• Managed 60 instances including EBS and Non-EBS instances for OBIEE, Kronos, Hyperion, Assist – Help Desk ticket, Clarity – time mgmt, ADP Middleware etc.

Manage technical resources, both onshore and offshore. Tasks also include hiring, conduct performance reviews, train and mentor associates. Coordinate among various departments including Product Managers, Business contractors, Designers, Systems Administrators, Marketing, and Business Development on different aspects of the project. Evaluate products and upgrades for cost and compatibility. Oversee and implement system upgrade strategies.

• Built SLA’s in collaboration with Business owners to ensure the organization goals are met or exceeded.

Successfully lead complete life-cycle implementations involving Oracle ERP, OBIEE Warehouse and SOA. Being pro-active and anticipate the potential issues and plan for disasters. Effectively manage and provide feedback on operational and project budgets to management.

• Managed resources in implementing multiple projects which include Online Billing, iProcurement, Oracle Learning Management, Advanced Pricing, Latin American Financials, India and Brazilian Localizations.
• Developed project plans for migrating oracle environments (both Oracle EBS and non Oracle EBS) into an E25K to utilize its superior computational power and clustering capability.
• Toughest challenge was to plan and mitigate the hardware and personnel resources in implementing 15 major projects within a span of 3 months with various technical and business process challenges.
• Technically competent to handle major projects including migrating the EBS applications across platforms.
• Projects implemented includes setting up multiple features of Oracle EBS, like Compensation Work Bench, Forgot Password, OATM, TDE, German and Chinese Language, and multiple Family and CPU patches.
• Managed the implementation of Shared APPL_TOP for Oracle Applications.
• Implemented Data Guard for Hyperion systems in Windows environments and Oracle EBS in UNIX.
• Established a new catalog based RMAN backup system for a reliable Database Backup and Recovery.
• Established an Oracle Grid control/Enterprise Management system to monitor DB and Apps Activities.
• Well versed with Project management process like AIM and SOX compliance activities.
• Built guidelines for code development and application design to improve performance and better programming.
• Worked with Data Center Operations team in using the SAN and NAS resources effectively.
• Use multiple Microsoft tools like Project, Power point, Excel to document and project the plans and results to the upper management.

Confidential,U.S.A. Apr 2005 – Oct 2007 Sr. Principal Consultant

• Performed Conceptual Architecture Design in implementing Oracle Suite of products involving 12i EBS suite, Siebel, OTM and integrating it with the Oracle Application Server Suite.
• Project Lead in migrating a single instance to multi-node RAC under 11i Apps.
• Managed various projects involving database upgrades from 9i to 10g and 10g to11g.
• Managed and supervised technical staff of 3 members, assigned tasks and monitored their progress.
• Project/Tech lead in implementing 11i Apps on 2 node RAC (both 9i and 10g) and multiple apps nodes with load balancing.
• Conducted workshops and training on Database upgrade, ASM, Backup and Recovery.
• Worked with Oracle Sales teams in building presentations and work with clients in suggesting suitable technologies to fit their needs.
• Built Tech Documents for Design Architecture, migrations, cloning.
• Led an Application Development team of 5 members in building RICE objects.
• Extensively worked on RAC in both 9i and 10gR2.
• Performed System Administration tasks in Linux/Unix Environments.
• Coordinate the development activities involving customization of XML Publisher for check printing, Sales orders, purchase orders, Pick Slips etc.
• Activities include Architecture design and prepare implementation strategy including planning/management of DBA/Sys admin resources.
• Develop conversion strategy with the Conversion team leads in multiple successful implementations.
• Administered and managed teams involved in maintaining large databases of size 800GB in a Single and Multi-Tier Architecture on both UNIX and NT Operating Systems, and planning enhancements to an existing system.
• Implemented 11i with various configurations including shared application tech stack.
• Installed 10g Grid control to monitor several 9i and 10g instances and servers.
• Implemented Load Balancing with Big IP, Radware Load Balancer.
• Worked in implementing RMAN independently and with Veritas NetBackup.
• Added a new middle tier on an existing 11i application.
• Performed 11i middle tier tuning. Fixed Autoconfig/Cloning issues.
• Tuning of SQL Scripts and Reports 6i code.
• Coordinated and fixed issues involving Data Warehouse, J2EE issues at client sites in collaboration with Oracle Support.
• Configuring Linux environment to install Oracle Applications.

Confidential,PA Mar 2002 - Mar 2005 Implementation Team - Manager

• Lead a team of 12 members, implementing Oracle HR applications, working on various activities including DBA, Development and Conversion. Planned and implemented methods to clean the legacy data feeding into the Oracle.
• Managed 11i (11.5.5) implementation and maintenance of Oracle HR Application.
• Managed an Upgrade of Oracle Applications from 11.5.5 to 11.5.9.
• Installed 11.5.10 Version of Vision Instance.
• Mentoring couple of junior DBA’s and Project planning and implementation.
• Implemented Self Service Web Applications (5.0) including customizations.
• Implemented Single – Sign on. Integrated Oracle HR applications with Site Minder
• Performed and built an infrastructure for automated data loads for all company acquisitions.
• Planned and Implemented Organization and Position hierarchy.
• Upgraded Database from 8.1.7.1 to 8.1.7.4 and Migrations from 8.1.7.4 to 9.2.0.4, Apache 1.3.9 to 1.3.12, JInitiator from 1.1.8.13 to 1.1.8.22, Zip tools for Solaris O/S.
• Coordinated application of several Major patches, Family packs for Human Resource Applications and user testing after applying them.
• Administered Discoverer versions 9i(on Solaris), 4i, 4(Windows) as a standalone iAS implmentation.
• Setup ODBC connections for data transfer from Heterogeneous systems (AS/400 to Oracle).
• Developed a Backup and Recovery strategy using RMAN and built custom scripts to execute them including, early warning systems by paging in case of a problems.
• Implemented statspack for monitoring the Database performance.
• Defined requirements and created, upgraded and cloned development, test and production database.
• Reviewed, recommended and implemented system releases and enhancements.
• Created procedures to analyze the tablespace utilization and fragmentation, and suggest the required tables to export/import or rebuild indexes based on the fragmentation and contiguous extents.

Confidential,OR (As a Consultant) Oct 2001- Mar 2002
Project Manager

• Performed 11i implementation of Oracle Applications.
• Migrated Oracle 7.3.4 database to Oracle 8.1.7.
• Cloned several 11i Oracle Application databases needed after the implementation of 11i Oracle Applications.
• Debug several scripts to ensure validity of database objects and regenerated forms, libraries and menus.
• Train DBA’s to handle all the new features of 11i Apps and 8i RDBMS.

Confidential,AZ Oct 2000- Oct 2001
Manager

• Managed a team of 3 DBA’s, assigning tasks and provide direction.
• Installed 11iStore Application and interfaces with a 10.7 Production environment using DB links.
• Installed 11iConfigurator Application.
• Installed and upgraded Oracle Applications from 10.7 to 11i for Financials and Manufacturing Applications on a HP-9000, including preliminary planning and configuring the server.
• Upgraded Oracle 8.0.6 database to 8.1.6 and migrated Oracle 7.3.4 to 8.1.6.
• Working with the Business Analysts and the Application Developers with customizations for the 11i Upgrade.
• Performed System Administrator Tasks required for implementing 11i applications.
• Groomed 2 DBAs in handling the 11i EBS Applications and Database Maintenance.
• Fixed problems with datafiles of a tablespaces that grew beyond 2GB, preventing oracle from completing the regular backups.
• Worked on defragmentation of tablespace and recovered free space from tablespaces.

Education

MS, Mechanical Engineering/Computer Science