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. I used Agile Methodology, Wrike, Quip, and Radar tools to manage requirements, assign tasks, and manage the project’s progress. I formulated weekly status reports for project status with milestone status, dependency, resource utilization, and Risks. I worked closely with the Application Development, Database, and Storage/infrastructure teams to clean data for AI Models and SOX/PCI audits.• 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 Engineers to deploy appropriate solutions.

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 management tools like CrowdStrike, Exabeam, Netskope. The project implementation included working with Architect, Network Security teams, and Network Administrators to implemented network policy and monitoring processes.

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 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• I have managed projects to implement database and system security/redundancy/failover• I worked on a project to upgrade to Cisco network and Palo Alto firewall

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 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 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• Managing Projects/Programs to gather required environments/infrastructure• Pre-Production environments migration from one Data Center to Standby (failover) siteEnvironment: Oracle RDBMS with ASM/RAC, Linux, OVM, Golden Gate, OEM monitoring for Siebel/BRM/EBS

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 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 ReportingEnvironment: Oracle 10.2 with RAC/ASM, and MS SQL Server 2005

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 addition, 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 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)• Designed and developed security procedures for Data Warehouse access to comply with the Sarbanes Oxley ActEnvironment: Informatica PowerCenter 8/7, OBIEE 9.0, and Erwin

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

Certificate, Unix System Administrator

Bachelor Of Science - Bs, Computer Science