Pranay Oza Email & Phone Number

Morgan Hill, CA, US

Cupertino, California, US

• I am a Technical Program Manager in the IT Governance & Planning team to recognize personal identifying information (PII) with Applications for Data Consistency for AI Models, PCI, SOX, GDPR, CCPA, and PIPL compliance..
• Managed projects with individual application owners to implement and review encryption and storage of PII information that was processed, stored, or transmitted to meet compliance requirements.
• Coordinated with IT infrastructure and applications team to audit administration accounts access. The review included accounts for Cloud, Database, and Systems accounts to review access controls.
• Projects included integrating user data from Slack, Box, Quip, and Wrike into a Dashboard for data-driven decision-making, data cleaning for AI Models, and visualization.
• Collaborative sessions with the data engineering team and developer to integrate data into Apple's DataMart. Responsibility included implementing user privacy and data protection.

San Jose, CA, US

I am an Infrastructure & Cloud Operations Project Manager. As Infrastructure Project Manager, I have been responsible for the infrastructure dependency on public/private cloud deployments, managing resources, and project timeline. On Infrastructure/cloud projects, I have worked closely with Architects and Operations Managers and Network Engineers and Cloud.

San Jose, California, US

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 Project to implementation of security.

San Carlos, CA, US

• 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.
• 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

Mountain View, California, US

• 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.
• Project Manager supporting Enterprise Applications Systems Management team (EASM)
• Managing Operations Metrics / Reporting / Process Improvement
• Manager of the 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

San Jose, CA, US

• I actively supported production Oracle EBS Application and enterprise application databases.
• I led 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.
• 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

San Jose, CA, US

• Lead team member to bring data from a legacy system into Star Schema Data Warehouse (Dimension and Fact Tables). I made vital contribution towards the creation of data models, data interfaces, and design document. In.
• 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 development team to identify top SQL statements and rewrite them, improving performance by 40%
• Used Erwin to model data into Dimensional Data Model (star schema model with dimension and fact tables)

San Jose, CA, US

• 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.
• 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

Certificate, Unix System Administrator

Bachelor Of Science - Bs, Computer Science