Pranay Oza
*********@*****.***
www.linkedin.com/in/pranayozapmp
Technical Project Manager
I am a Project Manager with 15 years of experience in the Information Technology industry.
Overview of my Skillset and Experience:
I have technical skills with the ability to identify and analyze to solve problems
Ten years of experience in our software design and development of web and Client/Server Applications in Software, Online sales & subscription, Semiconductor, and Transportation Industries
Experience in SDLC methodologies like Waterfall, Agile, RUP and SDP-R10
Strong understanding of design, development, implementation, and testing of the project lifecycle
Proven ability to bridge the gap between business needs and IT implementation
Extensive experience in working and managing projects in the areas of Infrastructure/Environment Management, Software Development, Data Migration, and Mergers & Acquisition
Demonstrated excellent interpersonal communication skills with all levels of management and customers
Excels at communicating with stakeholders to provide accurate reporting and information regarding the ongoing projects and initiatives
Expertise in coordinating, negotiating and motivating onshore and offshore resources in support of timeline and IT project deliverables
Education in PMI Project Management Professional (PMP)
Education Agile Scrum & Kanban and ITIL – Foundation
AREAS OF EXPERTISE
Project Skills: Agile Scrum & Kanban, MS Project, MS Visio, Share Point, Communication Management, Quality Management, Resource Management, Risk Management Schedule (Time) Management, Scope Management
Hosting Platform: AWS Amazon Web Services, VMware Hybrid Cloud, Microsoft Azure, Oracle Virtual Machine (OVM)
Database: Oracle 11gR2, MongoDB, NoSQL, Oracle RAC/ADG, Hadoop, MS SQL Server 2014
Applications: ServiceNow, Oracle Siebel CRM, Workday, Salesforce, Oracle BRM/ Fusion Middleware
Operating Systems: RedHat Linux, Oracle Enterprise Linux (OEL), Oracle Solaris, Windows, Oracle ASM, NetApp IB/FCP for Storage Management
Languages/Scripts: Python, PERL, awk, UNIX Shell Scripting, Oracle PL/SQL, C, and C++
PROFESSIONAL EXPERIENCE
TiVo Inc. Nov 18 to Present
Infrastructure Project Manager
I am a Project manager for Business Continuity & Risk Management team. I have been responsible for deploying Private/Public Cloud infrastructure for business continuity. Also, I have managed the deployment of security management tools like CrowedStrike, Exabeam, and Netscope. During project deployment, I have worked closely with Network Engineers, Network Security Team, Technical Architect, and Operations Managers to implement appropriate solutions.
I have Managed Disaster and Recovery implement plan for Enterprise Applications to secondary Data Center. Responsibility includes failover setup & testing for SLB, Storage, VM environment, and monitoring tools. I worked closely with the Architect, Technical Team, and Technical Managers to implement DR solutions.
I have managed the infrastructure project to consulate data centers and infrastructure move/migration Co-loc data center managed by AT & T. I worked with Enterprise Application owners, Architect, Technical Team Managers, and Vendors for a smooth migration to new Data Center.
I have managed Project to implementation of security management tools like CrowdStrike, Exabeam, Netskope. Also, I worked with executive and auditors to implement and California Consumer Privacy Act (CCPA).
SamTrans, San Francisco Bay Area, CA September 2012 to Nov 2018
Software/ Infrastructure Project Manager
I have managed IT project to upgrade vehicle GPS/radio system and mobile data terminals, Oracle database upgrade and migration to Virtual/Cloud (AWS) environment, upgrade from Cisco firewall to Palo Alto network firewall to improve PCI security, and desktops migration to VDI.
I have experience in delivering IT projects on-time and under budget
Managed project to implement the Payment Card Industry (PCI) security standards for Oracle 11g database and VMware environment and Palo Alto firewall
Managed project to upgrade VMware, SAN storage and network equipment to support VoIP upgrade for customer service, a database for failover, Interactive Voice Response (IVR) application and VMware cloud
Developed and implemented IT plans and disaster recovery
Planned and managed test cases for Mobile Data Terminal (MDT) integration with Trapeze MDT/AVL software for para-transit operation
Manage onsite vendors and consultants who provide support and maintenance for Information Technology projects
Pre-Production environments migration from one Data Center to Standby (failover) site.
I have managed projects to implement database and system security/redundancy/failover
I worked on a project to upgrade to the Cisco network and Palo Alto firewall
Intuit Inc., San Francisco Bay Area, CA September 2009 to September 2012
Database Project Manager
I have been an integral part of the project team at Intuit Inc. to build and deploy SAS/Cloud environment. I managed the project to build RAC 11gR2 clusters with ASM and Active Data Guard. I also managed OEM monitoring deployment for Database/VM/Siebel/BRM/EBS and NetApp.
Project Manager supporting Enterprise Applications Systems Management team (EASM)
Managing Operations Metrics / Reporting / Process Improvement
Manager of a project to build and deploy 300 Oracle RAC 11g clusters, Active Data Guard and Golden Gate replication
Part of the project team to deploy Oracle SOA architecture, Oracle Siebel CRM, Oracle BRM on the virtual environment
During performance testing, I worked with onshore and offshore team to meet the timeline
Managing Projects/Programs to gather required environments/infrastructure
Pre-Production environments migration from one Data Center to Standby (failover) site.
Environment: Oracle RDBMS with ASM/RAC, Linux, OVM, Golden Gate, OEM monitoring for Siebel/BRM/EBS
Cypress Semiconductor Corporation, San Jose, CA 1999 – 2009
Oracle EBS/RAC Administrator (2007 to 2009)
I actively supported the production Oracle EBS Application and enterprise application databases.
I led a project to migrate from the stand-alone database to Oracle RAC for Fault Tolerance and High Availability; this included the installation and configuration of Oracle9i and 10g RAC Real Application Clusters on RedHat Linux and Solaris operating systems
Implemented partitioning tables and bitmap indices resulting in 30% performance improvement
Automated refresh of Oracle EBS for development using Oracle Rapid Clone and NetApp Snap/Flex Clone
Collaborated on a project to migrate from Ingres Legacy System to Oracle EBS for Order Management and Warehouse Management System
Performed Backup and Recovery through RMAN, and Cloning of Oracle Database through Hotbackup and Cold backup
Led proof of concept (POC) project for the Finance Department to bring data from Oracle E-business Suite (EBS) to Oracle OBIEE for Dashboard and Reporting
Environment: Oracle 10.2 with RAC/ASM, and MS SQL Server 2005
Data Warehouse Administrator (2002 to 2007)
Lead team member to bring data from a legacy system into Star Schema Data Warehouse (Dimension and Fact Tables). I made a vital contribution to the creation of data models, data interfaces, and design document. Also, I collaborated with System Administrator to plan storage management and configuration for the optimal I/O performance of database servers.
Anticipated and planned for Data Warehouse growth of 500%
Used Informatica Power Center to develop ETL (Extract, Transform and Load) procedures to move data from transactional systems to Data Warehouse
Actively participated in Data Warehouse Project, which included ETL development, analysis, design, build, testing and documentation
Worked closely with the development team to identify top SQL statements and rewrite them, improving performance by 40%
Used Erwin to model data into a Dimensional Data Model (star schema model with dimension and fact tables)
Designed and developed security procedures for Data Warehouse access to comply with the Sarbanes Oxley Act
Environment: Informatica PowerCenter 8/7, OBIEE 9.0, and Erwin
Operations Database Administrator (1999 to 2002)
I was responsible for monitoring ETL performance, evaluating and recommending third-party tools (e.g., Toad Spotlight, monitoring user data access for reporting to comply with security procedures). Also, I was responsible for daily backup, storage management, and planning for different recovery scenarios. Additionally, I designed the database schema, tables, indices, and materialized views.
Implemented Sarbanes Oxley Act controls for databases and enterprise systems
Supported production databases (24/7) for Manufacturing, Marketing and Sales Database with 99.98% uptime
Administrated and Planned Database Upgrade, Patching and System Changes
Set up automated database refresh to support development efforts
EDUCATION
Computer Science (Minor in Mathematics and Physics) – attended, San Jose State University
Certificate, UNIX System Administration (Solaris), University of California Santa Cruz Extension
TRAINING
PMI Project Management Professional (PMP)
ITIL – Foundation
Agile Scrum & Kanban
Oracle Database Administration and Golden Gate by Oracle Corporation
Informatica Power Center Development by Informatica Corporation