Manager Oracle

Oracle Enterprise Applications and Primavera Senior Engineer with 8+ years of Information Technology experience, especially in ERP and Retail domains (Client Server and Web Applications).

Strong functional knowledge, installation, integration, and implementation and administration experience in various Oracle Applications like Oracle Primavera P6 EPPM, Oracle Contract Management, Oracle PPM, and PRA (Primavera Risk Analysis) and integration with, Oracle Universal and Enterprise Content Mgmt, Oracle Autovue, Oracle SOA, Oracle Business Process Management, Oracle Enterprise Manager, Oracle Business Intelligence Publisher, OBIEE, Oracle Access Manager, Oracle Identity Manager and Other third party applications like Microsoft Sharepoint 2007 and 2010, and Citrix Presentation Server 4.5, Xenapp 5 and 6.

Strong working knowledge on Oracle (9i, 10g and 11gr2) (database software installation, RAC, upgrade, database creation, taking backups, export and import), and Sql server (2005, 2008, and 2008R2) (database software installation, Cluster, upgrade, database creation, taking backups, export and import) (Database Servers), database HARDENING and DBA activities.

Monitoring the Database using “Oracle Enterprise Manager Grid Control” tool.

I have sound knowledge on Web logic (10g, 11g, and 12c) WebSphere (7 with FixPacks, and 8), Jboss (4.0, 5.1 and 6.0), and Tomcat (Application Servers/clustering), Apache, OHTTP, IBM HTTP and IIS (Web Servers) including Installing, Clustering (SSL and non SSL), Redirection of application servers with (mod_jk and middle wear in Jboss) (Plug-ins in Web logic and Web Sphere) and deployment.

I work on managing the data center setup by handling the Vmware ESX, and Oracle OVM virtualization for live internal Oracle Products (Primavera) and deploying the various Windows servers (2003r2, 2008, 2008R2), Linux servers(RedHat Linux, Oracle Linux, Solaris), Unix servers (IBM AIX, HP UX) with Operating Systems of 7 different languages on the infrastructure and maintaining them.

Oracle Peoplesoft Application implementation experience.

Awarded for the delivery excellence many times.

Experienced in working in most complex SCRUM projects, which are task oriented and limited timelines to finish the tasks.

Experienced in Perl, Shell and C scripting.

Designing and Developing the Test Plan Document, Strategy and Scenario Documentation.

Designing the Automation Framework, creating Master plans and Sub plans, writing the common functions for the usage of the team members and automating the manual test scenarios.

Experienced in working with IBM Rational Clear Case software configuration management.

Designing, modifying and executing the Automation and Manual test cases though Quality Center.

Working with Primavera (Client Server and Web Application) functional testing (One of the largest ERP Providers in US) project, and worked on SAP testing.

Proficient in Software Development Life Cycle (SDLC), CMM, and CMMI processes.

Designing the Use Cases to understand the functionality of Primavera PM Application and performing the User Acceptance Test for every Cycle.

Conducting web based training on the Virtualization Mgmt, Application and Database Cluster setups, and Database backup and restore mechanism.

Experienced in deploying, installing, implementing and testing the Web based, client server ERP products.

Certified SAP-SD Functional Implementation specialist.

Working knowledge on LDAP setup and running.

Worked with the log reporting tools like Webtrends and analyzing the details.

Experience in Java Server Technology.

Configuring the Collaboration Setup on the Servers.

Strong working knowledge on 7 different languages (Operating Systems), they are: English, French, German, Russian, Japanese, Traditional and Simplified Chinese and do compatibility test on these different Operating Systems.

Conducting internal process audits & process reviews for ensuring strict adherence to the process parameters/systems. By applying software configuration management principles.

Holds proficiency in focusing on Continuous Process Improvement by taking responsibility of Process Consultant for VM Management.

Conducting trainings for new recruits to ensure to enhance their skills and attune to them to the prevalent norms adhered to on the floor.

I have also worked on all the patches and service pack releases on various locales.

Exposure to using Load Runner for Performance Testing of the Web Applications.

Migration from Baan and Mfg ERP Systems to centralized SAP ERP system.

Exposure to RDBMS Concepts and worked on Data Warehousing concepts.

Deployed and Tested various applications developed on (windows and Web) C#, VB.Net, ASP.Net, Oracle8i, 10g and 11, SQL Server 2005, IBM DB2, MS Access, ASP, XML, AJAX, JavaScript & VBScript.

Handling the defect life cycle.

Preparing the client deliverables – Bug summary report, Test summary report.

Bug Verification – Reporting and Management, and Change Control using Quality Center and VSS for Configuration Management.

Experience includes in Financial Services, Travel & Transport, Utilities, Telecom, Retail & Distribution and Hospitality and 6+ years of expertise in ERP and Retail domains.

Excellent Leadership skills, Team player with good communication and written skills with exemplary analytical and problem solving skills.

Excellent interpersonal communicator and good listener who effectively interacts with the team, clients and all levels of management. Enthusiastic learner who quickly grasps concepts and technical skills.

Technical Skills

Operating Systems: Oracle Linux4, 5, and 6, Red Hat Linux, Oracle Solaris, IBM AIX, HP UX, MAC Ios, Windows 2008R2, 2008, 2003

Data Center Mgmt: Vmware ESX, and Oracle OVM

Languages: C, C++, Java, 4Test

Frameworks: Oracle ADF, Eclipse RCP

Models and Views: EJBs, WebServices, java beans, Portlets, Struts, JSF, CSV and XML files, and SWING, JSP, JS and ADF faces

Testing Tools: Fitnesse, Silk Test, Quality Center, QTP, QTC, Test Director, BugDB, Bugzilla, VSS (Configuration Management Tool), Webtrends

RDBMS: SQL-Server 2005, 2008, 2008R2, Oracle 10g, Oracle 11g, MS Access, My-SQL

Concepts: Data and File Structures, Forms, Object Oriented Analysis and Design, Operating System, Networking, System Analysis and Design, Software Engineering, Project Management, MIS and ERP

Areas of Expertise

Enterprise Servers: Dell Servers, Sun Fire, IBM Servers and HP Servers

Oracle Apps: Oracle Primavera EPPM, Oracle Contract Management, Oracle Universal and Enterprise Content Mgmt, Oracle Autovue, Oracle SOA, Oracle Business Process Management, Oracle Enterprise Manager, Oracle Business Intelligence Publisher, OBIEE, Oracle Access Manager, Oracle Identity Manager

SQL Server and Oracle: Installing and configuring the databases writing triggers and development PL SQL.

Web Logic, Web Sphere, and Jboss: Deploy Cluster and Configure Load balancing

Oracle HTTP, IBMHTTP, IIS: Deploy and Configure

Functional Domain: ERP and Retail

SAP – SD CRM: SAP – SD CRM Implementation and working.

Professional Experience:

Oracle Corporation (Primavera), Hyderabad, India Jan 2010 to Present – IC3

Oracle Corporation is the world’s leading computer technology company that specializes developing computer hardware systems and enterprise software products, particularly database management systems. The company builds tools for database development and systems of middle-tier software, enterprise resource planning software, CRM, and supply chain management.

My Roles:

Installing, implementing, upgrading and integrating Oracle Primavera P6 EPPM (8.2, 8.1, 8.0, and 7.0 (all Sps,)), Oracle Contract Management(12, 13(all Sps),14), Oracle PPM, and PRA (Primavera Risk Analysis) products with various Oracle Applications like Oracle Universal and Enterprise Content Mgmt, Oracle Autovue, Oracle SOA, Oracle Business Process Management, Oracle Enterprise Manager, Oracle Business Intelligence Publisher, OBIEE, Oracle Access Manager, Oracle Identity Manager and Other third party applications like Microsoft Sharepoint 2007 and 2010, and Citrix Presentation Server 4.5, Xenapp 5 and 6.

Implementing the Oracle Primavera P6 EPPM, and Contract Management applications on customer environments and providing the functional and technical know how about the product to the internal, customer and partnering teams

Installing, configuring (SSL and Non SSL) and monitoring Oracle database software(10g, 11gr1 and 11gr2) including setting up creating instances, setting up RAC, upgrading the database, taking backups, by exporting (datapump, backup, and export) and restoring (importing, impdatapump, and backup) monitoring using Oracle Enterprise Manager Grid Control tool

Installing, configuring (SSL and Non SSL) and monitoring Sql server (2005, 2008, and 2008R2) (database software installation, Cluster, upgrade, database creation, taking backups, export and import) and DBA activities.

Using SQL Server Reporting Services for generating and presenting the reports.

Managing the data center setup by handling the Vmware ESX, and Oracle OVM virtualization for live internal Oracle Products (Primavera) and deploying the various Windows servers (2003r2, 2008, 2008R2), Linux servers(RedHat Linux, Oracle Linux, Solaris), Unix servers (IBM AIX, HP UX) with Operating Systems of 7 different languages on the infrastructure and maintaining them.

Installing and configuring (Clustering, Proxying, SSL setup)various supported application servers like, Web logic (10g, 11g, and 12c) WebSphere (7 with FixPacks, and 8), Jboss (4.0, 5.1 and 6.0), and Tomcat (Application Servers/clustering), Apache, OHTTP, IBM HTTP and IIS (Web Servers), deploying the builds regularly on them and managing by administering.

Installing and configuring critical technologies and third party software products like Oracle Primavera EPPM, Oracle Contract Management, Oracle Universal and Enterprise Content Mgmt, Oracle Autovue, Oracle SOA, Oracle Business Process Management, Oracle Enterprise Manager, Oracle Business Intelligence Publisher, OBIEE, Oracle Access Manager, Oracle Identity Manager and Other third party applications like Microsoft Sharepoint 2007 and 2010, and Citrix Presentation Server 4.5, Xenapp 5 and 6 on the servers.

Working on critical devreqs and prioritizing the devreqs to deliver on time.

Preparing product, and Master backlog and delegating the work to the team in the SPRINT meetings.

Working on sustenance and release development and bug fixings.

Managing the Bug life cycle and maintaining the bug count.

Attending the daily scrum meeting to ensure the activities go according to the plan.

Attending the daily calls with various development, testing heads and tracking the progress of the release.

Designing and maintaining the Tested Configuration guides, Product Technical documentation, and maintaining the ROAD Map for technology adoption.

Evaluating the new third party technologies for integration with Primavera products

Cognizant, Hyderabad, India Feb 2009 to Jan 2010 Associate Projects

Cognizant Technology Solutions is the world’s leading Software Testing firm, having great exposure and expertise in various domains like, ERP, Health Care, BFS, and Retail.

HealthCare and ERP at Cognizant:

Worked as a Team Lead in ESI (Express-Scripts) project, one of the top Health Care Service providers in United States.

Client is one of the world’s leading Health Care service providers. They provide complete support in health care domain.

Technology: Deploying the ESI Web Application on WebSphere application server using IBM HTTP, Apache and IIS Web servers on IBM AIX and RedHat Linux Operating systems running on Vmware ESX servers and testing the compatibility with SAP-SD and CRM applications.

My Roles:

Setting up and installing oracle 10g, and 11g database software on various servers, implementing the Oracle Peoplesoft applications for time sheets of ESI, and monitoring the space and performance to make sure the large testing and development teams accessing the applications not facing any issues.

Deploying the ESI web application and integrating with Oracle applications.

Installing the WebSphere Application Server with updated Fix Packs regularly and deploying the Web Applications.

Upgrading the databases and creating new database instances and taking the backups periodically on Oracle database servers.

Deploying the production builds on the infrastructure before going live and verifying the health.

Deploying the daily builds on the servers and providing the application access to the testing teams

Attending the daily calls with the client and updating the tasks performed for the day and representing my team.

Managing the infrastructure through VMware Vsphere .

Generating the reports every month and sharing with the stakeholders

Achievements:

Submitted POC and successfully won the new project

Done certification in Health Care HIPAA

AppLabs, Hyderabad, India May 2006 to Feb 2009 Software Engineer

AppLabs is a global IT services company specializing in quality management, testing, and certification solutions. AppLabs is CMMI Level 5, ISO9001 and BS7799 accredited with over a decade of experience behind it, AppLabs has become a trusted partner to more than 600 companies, providing both quality assurance and third-party validation.

ERP at AppLabs:

Worked in Primavera Project, one of the top ERP Application software Development Firms in United States.

Client is the world’s leading project and portfolio management Software Company. They provide the software foundation that enables all types of businesses to achieve excellence in managing their portfolios, programs, projects and resources. It is estimated that projects totaling more than $5 trillion in value have been managed with their products.

Technology: Deploying the Primavera Web Application on Weblogic/Jboss Application Servers, Apache/IIS as Web Servers, Oracle and SQL Server for Database server setups and Client Server setups.

Working on Installation and Integration of Primavera P6 and Primavera Contract Management applications with various third party supported applications

Working with Oracle Weblogic clustering with Apache and Weblogic web proxy servers.

Setting up the Windows/Linux Servers for the deployment and setup and configure the Application Servers (Weblogic/WebSphere/JBoss). Deploying the application on JBoss/Weblogic and clustering, redirecting with web servers and load balancing.

Setting up the Apache/IIS Web Servers and configuring.

Clustering, Load balancing, and redirecting the Apache/IIS Web Servers with Web logic Application Server on both Windows/Linux operating systems.

Redirecting the Apache/IIS Web Servers with JBoss Application Server on both Windows/Linux operating systems.

Running multiple configurations and domains on JBoss/Weblogic Servers.

Setting up the Windows \Linux Servers for the deployment and setup and configure the Database Servers (Oracle and Sql). Setting up the Oracle and Sql database on both Windows and Linux server machines.

Supporting the Primavera product releases and ensuring the quality deliver of products

Installing and Testing the client’s ERP application on Standalone, Client Server, and Web Application on JBoss/Weblogic with Apache and IIS Server Setups on Linux and windows.

Tracking the logs.

Creating VMs for clients and server operating system installations

Managing the VMs using Vsphere

Working with IBM Websphere clustering using network deployer and IBM HTTP, IIS

Setting up the Windows \Linux Servers for the deployment and setup and configure the Database Servers (Oracle and Sql). Setting up the Oracle and Sql database on both Windows and Linux server machines.

Designing the Use Cases and doing User Accept Test on each and every release.

Conducting internal process auditing and ensuring that all the metrics and principles are met by the team

I have also worked on all the patches and service pack releases on various locales.

Maintaining and updating the process artifacts regularly to enhance quality.

Conducted a presentation on ‘Application Server Clustering' for the QA Dept. of AppLabs and conduct regular trainings on AS and WS related topics.

Integrating the Primavera Timesheets with PM application.

Designing and Developing the Test Plan Document, Strategy and Scenario Documentation.

Technical Writing:

Documented the entire User Manual of the Implementations, Application Server Cluster Setups and Testing process.

Environment Used: Standalone, Web Server. (Worked on Application Server, Database Server setups)

(DataCoe Systems) Dabur India Ltd. Hyderabad, India. SAP ERP Test Engineer May 2005 to May 2006

Worked as SAP ERP Implementation, UAT and Compatibility from DataCoe Systems at Dabur India.

Dabur India Limited IT services wing’s knowledge and technology are key resources which have helped the Company achieve higher levels of excellence and efficiency. Towards this overall goal of technology-driven performance, Dabur is utilizing Information Technology in a big way. This is helping in integrating a vast distribution system spread all over India and across the world. This will also cut down costs and increase profitability.

Dabur India Limited is a leading Indian consumer goods company with interests in health care, Personal care and foods. Over more than 100 years they have been dedicated to providing nature-based solutions for a healthy and holistic lifestyle.

Dabur’s SAP implementation program:

Migration from Baan and Mfg ERP Systems to centralized SAP ERP system from 1st April 2006 for all business units.

Implementation of a country wide new WAN Infrastructure for running centralized ERP system.

Setting up of new Data Centre at KCO Head Office.

Extension of Reach System to distributors for capturing Secondary Sales Data.

Roll out of IT services to new plants and CFAs.

Forward Integration of SAP with Distributors and Stockists.

Backward Integration of SAP with Suppliers.

Implementation of new POS system at Stockist point and integration with SAP-ERP.

Key Challenges:

Key Challenges were to deploy the web application on Jboss/Weblogic application Servers with Apache/IIS as web server setups.

Analyze the logs through log reporting tools.

Ensuring the compatibility and the functionality of the application to be implemented .

My Roles:

Setting up Web Logic application server environment and deploying the web application on the application server setups and configuring the Apache web server.

Installing the database server software, setting up the customer database and configuring with applications.

Reporting and monitoring the web application trends through Webtrends.

Deployed on different Operating Systems and the Servers.

Deployed the Application Server Setups and Collaboration Setup.

Deployed on Microsoft SQL Server and Oracle.

Installed the DB2 Universal Database client software

Conducting audits and maintaining the strict process for the successful completion of the task.

MAINTEC Hyderabad, India

Development ProEd Engineer March 2004 to May 2005

Accenture is a multinational management consulting, technology services and outsourcing company headquartered in Dublin, Republic of Ireland. It is the largest consulting firm in the World. The international company was first incorporated in Bermuda in 2001. Since September 1, 2009 the company has been incorporated in Ireland.

My Roles:

Deployed application by using Tomcat servers

Installed and worked on MSSql Server, Oracle, etc

Deployed the Contact /Payment Capture, and Locator Selector Applications.

Maintaining all the process artifacts regularly for the smooth and successful completion of the project.

Keeping the valuable project related data up to date in a secure and reusable format.

Maintaining the project baselines and workflow in an efficient manner.

Creation of Functional Specifications/ Flow Diagrams.

Analysis of Functional specifications and recommendations for change taken and adopted by the development team right from the Requirements gathering phase.

Creation of User/System Flows for testing and writing test cases using MS Visio tool sent across to be used at the clients end for testing as a model to be used.

Education

2002 - 2004 Masters of Business Administration (MBA) IT

1999 - 2002 Bachelors in Computers

Technical Qualifications

1. Diploma in Software Engineering from CMC

2. SAP SD Implementation

3. Certified in UNIX from SSI

4. PGDCA

Achievements

Done the project on ‘ERP implementation Structure’ in PEPSI Co, Hyderabad, AP.

Conducted a presentation on 'Performance Testing and Test Automation'' for the QA Dept. of AppLabs. Presented case studies on the topics of ISO and CMM in the office.

Winner of one of the talent shows conducted by Maa Television and acted in the Ad films which were shown on Television.

Organized and hosted various inter - collegiate events, represented the college and companies for various events and seminars

Actively participated and hosted the cultural shows, events and seminars in the college.

Interests

1. Love to take up any challenge and explore new and untreated paths.

2. Optimistic and Workaholic in achieving career goals and meeting requirements.

References

Available upon request.

Contact this candidate