Project Manager Oracle
Resume:
RAJINDER PANDHER
PROJECT MANAGER – Infra, BI, Data Migration and ERP
Certified PRINCE2 PMP Practitioner
***************@*****.***
SUMMARYSenior Project Manager with experience in SOX Compliance. Expertise in managing projects within Information Systems Infrastructure, Oracle EBS Financials, Seibel OBIEE, Cognos, Informatica and BI environments. Solid background in directing programs to implement Enterprise Resource Planning, Delivery and Change Management.
Proven ability to bridge technology and business goals to provide productive solutions. Demonstrated success leading and mentoring cross-functional teams in multi-environments in order to maximize levels of productivity. Excellent communicator with emphasis on building strong client relationships and making professional presentations.ERP Systems, Data Migration and ETL, Data Warehouse Systems, Revenue & Inventory, Oracle CRM, Business Intelligence, eCommerce, Data Security, Staff Development, DMZ, PeopleSoft, Agile, SOX Compliance, Capacity Planning and Performance, B2B, Strategic Planning, Budgeting, BCP, Document Management, Backup and Recovery Systems implementation.
ACHIEVEMENTSIimplemented Data Warehouses, ETL and BI reporting systems as a PM at United Defense (A3 Bradley), HP (EIFFEL), Agilent (EIFFEL), Sun Microsystems (VISIBLE FACTORY), Inland Empire Health Plan (COGNOS), Cisco (Everest), JDSU (Maverick), Juniper (Blitz) and NetApp (Matrix, Operational and Business Applications Reporting). Well versed hands-on Architect - in OBIEE Reporting and Dashboard creation, through Oracle RDBMS, Oracle EBS templates, DAC/Informatica, Data Migrations, Data Marts and Repository/RPD builds.
CERTIFICATIONSPRINCE2 Practitioner PMP http://www.apmgroup.co.uk/PRINCE2/PRINCE2Home.aspAPICS - Certified Supply Chain Professional http://www.apics.org/certification/CSCP/Cognos 8 BI (4 certifications – Report Authoring, Data Modeling, Server Management etc.)
PROFESSIONAL EXPERIENCE
Company Confidential, San Mateo, CA Apr ‘11- Todate
Project Manager – Major Bank Infrastructure, Databases, Applications, Knowledge Transfer, DR, 10gRAC / Data GuardWorking in a fast paced SAAS / Cloud Computing environment, managing multi-million dollar infrastructure projects for major national banks.Using MS Project, project plans, effort estimation, budgets and project control through EVM.Managed software requirement gathering, development of applications, testing of end product.Managed - ITIL related SLAs, reports, RFCs, CABs, meetings with teams and management.
NetApp, CISCO / TCS, Sunnyvale, CA Jan ‘10-Sep ‘10
Project Manager – BI & EDW – Cognos8 / BO / TD / Oracle / Data Migration (DataStage/Informatica)Worked on Operational ITIL Matrix Management and Business Reporting for Infrastructure and Business Application departments. Managed a team of 10-30 members, locally and offshore. The team consisted of DBAs, Report developers, Informatica ETL developers and Offshore delivery Manager. Interacted with Sr. Business Managers to set clear expectations and produce high quality reports, meeting / exceeding client expectations. Regularly briefed the management on the progress of building 150 Cognos, OBIEE and BO reports and custom ETL, interaction on boundary application development teams. Conducted WebEx meeting for stake holders with the offshore development team to get incremental sign-off on complex reports and various kinds of SLA Dashboards. Supervised L1 – L5 tech support. Took part in Month End, Quarter End and Year End Data Migration war room activities, meetings and customer support. I was a member of the Data Team whose role was to look at Data Quality, Data Cleansing, Data Validation and looking at the whole process of migrating data from the ODS to the EDW Systems. Producing Documentation and highlighting issues with all the Data Objects to be migrated (both Master Data and Transactional Data). This role is mainly using my technical experience. Worked on process improvement of the QA and Test Teams, consolidating Global Business Partner BI teams under EDW Department, creating a BICOE / BICC for Cisco.
Juniper Networks / IBM Global, Sunnyvale, CA March – June 2009
Consultant - Project Manager – ERP / Siebel / UCM / OBIEE / Data Migration / Capacity PlanningWorked on the IBM Global Service team, supporting Deloitte’s implementation of CRM / UCM.Worked with Oracle Expert Services to provide Production Readiness Review for Siebel CRM, UCM and OBIEE Production cut-over planning and UAT. Interacted with the management on technical issues. ERP Application, Database testing and stabilization, clusters, RAC, Data Guard, RMAN, Apps / Web / DAC servers Data Warehousing, ETL and reporting stabilization and support. Worked on OBIEE RPD, Data Migration performance, ETL, Data Marts, reports, dashboards. There were lots of Data Cleansing, Data Validation and Data Consolidation issues and I basically had to take ‘garbage in’ and return ‘good out’. Worked on improving performance of Data Migration throughput; I had to work extremely long hours and weekends to ensure successful Siebel UCM data Migration (with signoff).
JDS UNIPHASE, Milpitas, CA Jun – Nov 2008
Project Manager - ERP, OBIEE, EDW, Data Migration, SSC, UAT, DR and BCPWorked on Maverick Project upgrading Oracle 11.5.7 to Oracle 11.5.10.2 ERP Deployment. Co-ordinated the Deployment Plan between Deloitte and Oracle On-Demand Teams, to trigger tasks during Production Cutover (shutdown and enable 11.5.10) followed by Disaster Recovery plan execution testing. Co-ordinated between JDSU and Oracle Infrastructure and network teams to streamline IP Addresses and connectivity for DR practice. Worked with Oracle SSC team to expedite bug removal, stabilization, UAT and application of custom patches. Worked with teams for - DW, Data Migration, OBIEE on Linux and integration with the ERP. Troubleshooting ETL, data cleansing, performance of data throughput.
FUJITSU CONSULTING INC., Sunnyvale, CA Jul 07 – Jun 08
Project Manager – Oracle ERP, DMZ, Performance, SOX, Security, BI, DW, ReportingInterface with client executive team to define project requirements and translate business objectives into tactical plans. Manage development, design and delivery of end-to-end solution.Lead cross-functional teams through development, testing and production.Planned and led conversions, upgrades, and implementations. Carried out performance and concurrent manager tuning, project management, cloning, patch application, code migrations, data fixes, and printer issue resolution. Instrumental in creating and implementing processes, tools and guidance for performing system, user acceptance and performance testing for a large enterprise system integration/migration project.
NEOPOST INC., Hayward, CA Apr – Jul 07
Consultant - Oracle ERP, Leasing, Order Processing and Financial ReportingSupported multiple Oracle versions, from 8i to 10g, as well as Oracle Apps and Seibel systems on Sun Solaris and Linux operating systems. Managed Oracle Financials, Manufacturing and Leasing modules in production environment, and carried out Siebel CRM implementation in development environment. Performed sql and database tuning, cloning, troubleshooting, RMAN backup and recovery.
VISA Inc., Foster City, CA Jun – Oct 06
Sr. Reporting Analyst – Financial Management BI Reporting and Data WarehousingManaged project planning, requirements, testing compatibility and implementation of the systems, enhancements and tools.Performed Data Synchronization, data mapping, volume of data exchanged between multiple data sources and Cognos 8 BI Reporting and Analysis systems. Managed and coordinated the processes for managerial reporting as well as analytic reporting for the VP and SVP Reporting. Ensured documentation and testing of the processes and controls were completed timely, accurately and within budget.
Network Appliances Sunnyvale CA Mar 2006 - Jun 2006
Senior Oracle Apps DBA Hardware Upgrade and SOX Compliance, Oracle 11i eBusiness System User Tech SupportProvides Oracle 11i eBusiness Suite and applications hardware upgrade process.Conducted performance improvement and optimizations on Oracle 11i eBusiness Suite production server.Assisted in SOX compliance audit of the Oracle 11i eBusiness Suite systems.Oracle on Demand DBAs and Oracle off-shore DBAs coordination.Assisted BSAs and Developers to optimize the ERP system usages, troubleshooting and bug fixing issues.
LPA SYSTEMS INC Woodcliff, NY Dec 2005 – Mar 2006
Project Manager
Oracle Applications - Cognos Performance Reporting Project:Trained and Certified on Cognos DecisionStream ETL, Cognos Server Admin., Cognos ReportNet Report Authoring and Cognos Framework manager Metadata Modeling. Installation, configuration and troubleshooting of MS SQL Server 2000 and Oracle RDBMS as repositories and installing Cognos tools like ReportNet, DecisionStream, PowerPlay and Oracle Performance Applications.Supervise consultant work on client sites and liaise with the customers to provide customer service.
STANFORD UNIVERSITY ITSS Stanford, CA Sep 2005 – Dec 2005
Senior Oracle Apps DBA
Oracle 11i eBusiness Suite – Oracle 11i Upgrade Tech Support
Oracle Applications Upgrade Project:Worked with the DBA and Systems Administration team to assist in the upgrade project. Worked on refreshing and cloning different databases for the 11i applications upgrade.Created automation scripts for automating daily tasks.
COHERENT INC Santa Clara, CA May 2005 – Aug 2005
Senior Oracle Apps DBA
Oracle 11i Upgrade and AGILE 9.0 Upgrade and User Tech Support
Agile 9 Applications Upgrade Project:Worked with the business manager and the Agile Systems Administrator, to stabilize the Agile System after an inadvertent mishap by a company DBA. Supported the 11i Oracle Applications DBA team during the upgrade to 11.5.10.Documented the Standard Operating Procedures for the Agile Application group.
CISCO SYSTEMS Santa Clara, CA Oct 2004 – Apr 2005
Project Manager (Accenture Program Management Team)
Oracle Applications Upgrade Project – Chair Lead for Infrastructure DBA/Patch Application Board/Oracle Tech Support:Lead the bug fix and tech support team work with the users, Business Systems Analysts, Infrastructure DBA team and the Module leads. Chaired the Patch Application Group meetings and the Oracle Tech Support special development group meeting.Managed the creation of one-off patches at Oracle, co-ordinate the approval for application of these patches from team leads and then co-ordinate the application of patches by the Infrastructure DBA team, during the various test cycles.
INLAND EMPIRE HEALTH PLAN San Bernardino, CA Jan 2004 – July 2004
Manager Business Intelligence – Implementation Decision Support System and User Training
Cognos OLAP and ReportNet Healthcare Reporting and Data Warehousing Project:Affected the turnaround of an ineffective database team by motivating team members, revising procedures and operations, providing customer service training, and communicating their accomplishments to management which resulted in superior inter-departmental relations and a higher degree of employee satisfaction and productivity. Lead the Decision and Technical Support Team staff of 15 support personnel in providing technical support to more than 200 users in the Claims, Medical Services, Pharmacy, and other healthcare departments.Supervise a team of technical database specialists and oversee the technical support of approximately 350 database users, including troubleshooting, IT server support, database and BI applications, and database groups. Maintain and administered the Oracle 11i Applications Database, Healthcare Reporting Data Warehouse, and Cognos Reporting system utilizing SQL Server RDBMS, Oracle RDBMS, Access 2000, and reporting utilities including Cognos PowerPlay and ReportNetManage various databases and related technologies, including Microsoft SQL Server 2000, Oracle 9i, and Perot Systems Diamond databases.
LITHONIA LIGHTINGS Conyers GA Oct 2003 – Nov 2003
Senior Oracle Applications DBA
Oracle Manufacturing and CRM Upgrade Project:Delivered advanced technical support to the implementation team and developers in successfully upgrading the company’s CRM module on their system that utilized Oracle 9 RAC on Red Hat Linux for the Database, and Windows NT for the Oracle 9i application server.Contributed to the upgrade from 11.5.8 to 11.5.9 CRM application of family packs. Administered the form servers and monitored the Oracle Financials Database. Tuned applications and performed troubleshooting, including troubleshooting of PL/SQL packages.
KEANE INC.,
SUN MICROSYSTEMS Newark, CA June 2000 – June 2001
Project Manager – Implementation of Manufacturing Data Warehouse and Reporting System Managed the design, testing, and implementation of a manufacturing testing and quality assurance data warehouse and Solaris web server designed to handle over 3,000 concurrent users at a growth rate of 60-75 gigabytes of data per month for data reliability and scalability.Installed Oracle 8i and 9i and Java and XML tool sets, managed the Oracle Applications Manufacturing module (10.7 and 11i) and manufacturing site data warehouses, and implemented the database on Veritas Cluster to ensure high availability.Developed data models of complex data structures for a very large database (over one terabyte) in a UNIX environment.Designed logical and physical data models for manufacturing sites in Scotland and California.Trained users on related technologies, advanced DBA techniques, and BRIO reporting tools.
ELECTRON ECONOMY Cupertino, CA Jan 2000 – June 2000
Data Warehouse Manager – Implementation of SCM Data Warehouse and Reporting System
E-Commerce Supply Chain Management Project:Led a team of four data mining experts, assisted in data mining efforts, and evaluated software for data warehousing and data mining with Oracle Database on UNIX environment.Established data warehousing techniques for the company. Used Oracle Warehouse Builder and BRIO.Created ODS and Data Marts for SCM, Sales and Marketing.
HEWLETT-PACKARD/AGILENT Palo Alto/Cupertino, CA June 1999 – Dec 1999
Project Manager – Project Ecom Order Tracking system and Eiffel Financial system : Year 2k Oracle Upgrade, Tuning and DBA Training
E-Commerce Group Worldwide Order Tracking System and Eiffel Financial System (WW) Project:Created a world wide order tracking system utilizing Oracle technology.Integrated LDAP and WebLogic software and supported the WebLogic implementation, connectivity, and integration troubleshooting.Cloned 14 very large databases and data warehouses for Agilent’s company spin-off.
SOFTNET SYSTEMS Mountain View, CA Aug 1998 – June 1999
MIS DIRECTOR – Implementation of Peoplesoft ERP (Financials and HRMS), Clarify CRM SystemLed a broad range of projects to implement Enterprise Resource Planning (ERP) systems on an UNIX platform that resulted in more efficient business processes and better integration.Led the implementation of Oracle, Oracle Applications, PeopleSoft, Clarify, Legato, and Oracle Enterprise Manager, planned and architected the complete PeopleSoft and Clarify implementation and integration, and created a data warehouse for reporting using Informatica.
KINETICS, INC Santa Clara, CA June 1998 – Aug 1998
Project Manager – Oracle 11.0.3 NCA Implementation and Technical Staff Training
Implementation of Oracle Applications 11.0 NCA (All Modules) Project:Served as consultant to the implementation Project Manager in support of the implementation of Oracle 11.0 NCA Financials, SCM Project, Manufacturing, and HR modules.Ensured compliance with the project’s technical requirements during the implementation.
ASPECT TELECOMMUNICATIONS San Jose, CA May 1997 – June 1998
Senior Oracle DBA
Oracle Financial Management System Project:Managed large-scale UNIX and NT systems, providing multidisciplinary infrastructure support for manufacturing and financial business functions, including planning for and ensuring security, automated monitoring, capacity, maintenance, and performance tuning.Implemented and then managed the Oracle Financial Management System which included database creation in both testing and production environments.
UNITED DEFENCE (FMC) San Jose, CA Apr 1995 – Apr 1997
Senior Systems Engineer- Project Lead for Data Warehouse and Reporting
A3 Bradley Fighting Vehicle Program: Served as Senior Systems Engineer on the Bradley A3 Program for the US Department of Defense (DOD).Led a 10-member team of engineers that performed analysis and worked with users to develop hardware and software requirements. Oracle Data Warehouse and UNIX administration.
EAGLE COMPUTERS Ludhiana, India Mar 1993 – Mar 1995
Oracle DBA Performed Oracle database administration, data archiving, and recovery. Developed and produced financial reports. Created custom applications for the banking industry.
MILITARY SERVICE India Jan 1974 – Dec 1988
MANAGER – MIS / HR / SUPPLY CHAIN / TRAINING / ARMAMENT/ TRANSPORT / ACCOUNTING / GENERAL STAFFPerformed above duties over a span of 15 years.Managed military personnel, equipment stores, payroll and accounting, canteen stock procurement and sales, Regimental funds and Officers’ mess accounting, personnel training / leave planning / entertainment / counseling.Imparted technical training to officers and men, lectures, demo’s and promotion exams etc.,Managed several high priority Defense projects, computerization, coordination of brain-storming sessions, test and evaluation of high tech equipment etc.,Coordinated imported meetings, brain-storming sessions, equipment trials and evaluations.Managed and organized, the updating and printing of Training Manuals.Held positions like – Air Defense Troop Commander (150 Specialist Personnel), Battery Second-in-Command (500 Specialist Personnel), Missile Battery Commander (250 Specialist Personnel), Air Observation Post – Flight Commander (150 Specialist Personnel), Regimental Adjutant, HQ School of Artillery – General Staff Officer (‘G’ Branch).
PROFESSIONAL TRAINING
Microsoft:Microsoft SQL Server 2000 AdministrationMicrosoft Win 2003 Server Administration
Oracle University: Oracle 11i Applications Systems Administration and RACMaster’s Certificate, Oracle Applications DevelopmentMaster’s Certificate, Oracle Enterprise Database Administration Oracle Database Administration, Win NT
Patternsoft: Oracle 11i Installation, Upgrading, and Patch ManagementOracle 9i New FeaturesOracle 6i Forms and Reports
University of California, Santa Clara:UNIX Advanced Utilities and Shell Programming
Cognos University:Cognos BI Series 8 Studios and OLAPPowerPlay Series 7ReportNet 1.1 Report Authoring, Data Modeling, and Administration
Other:Sun Education – Sun Solaris Unix System AdministratorHewlett-Packard Education – HP-10.x UNIX System AdministratorInformatica University – PowerCenter 6.0Business Objects University – Business Objects 5iClarify University – Data ModelAPICS – CPIM Courses (certificate of completion) Finance for Non-Financial Managers
EDUCATION
PUNE UNIVERSITY / School Of Artillery – MS Tech Systems (Award Pending)SJSU - Systems and Software Requirements Analysis and Management UCSC Ext. - Course work in Computer Science and Project ManagementAS (Physics, Chemistry & Mathematics), Punjab University
TECHNICAL SKILLS
RDBMS – Oracle 8i-10g, SQL Server, Data Guard
UNIX operating systems (Sun, AIX, HP-UX, Linux) and Windows 2003 server.
LAN, WAN, TCP/IP, HTTP, FTP, DMZ and HTTPS.
Microsoft Project, Visio, Unix Shell and PL/SQL.
Client/Serve and web based software architecture, network, design, and integrationProject Management, SOX Compliance, Data Security, Technical Writing, Enterprise Resource Planning (ERP), Delivery and Change Management, PeopleSoft, Agile PLMApplications – Oracle EBS Applications 11i/R12, PeopleSoft, Agile 9 PLMFunctional Oracle ERP – AR, AP, GL, OM, Purchasing, INV, BOM, ASCP, P2P, QTCFunctional Accounting, Supply Chain, Inventory, Payroll and HR Management industry experience. Peoplesoft Financials and HRMS implementation.BI and Data Warehousing – Siebel, OBIEE, BO, Cognos, RTM, DOORS and DiscovererETL – Informatica, DecisionStream, Oracle DataPump and SQL*LoaderEBS - NFS Mounted Shared Apps Tier, DMZ, PCP, Load Balance, Concurrent Managers, iSupplier, iProcurement, WorkFlow, sql tuning, code migration, Vertex Tax update, cloning, autoconfig, printer issues, Init Parameters optimization, bug tracking / removal, postscript printing pick slips / cheques, patch application, tkprof, autotrace, explain plan, tablespace issues, ASM, RAC, tomcat, indexes, gather statistics, performance optimization, archivelogs, data files, RMAN, OEM
Contact this candidate