Pujesh Pradhan Email & Phone Number

Pittsburg, Ca, Us

San Francisco Bay Area

- Developed and maintained data pipelines on Snowflake using Python and SQL, ensuring efficient data processing and storage.- Implemented various data ingestion methods, including Kafka, APIs, Salesforce, Marketo, and gRPC, to streamline data acquisition into the data warehouse.- Collaborated closely with the Sales Operation team to curate and analyze data, leading to the development of interactive dashboards using Tableau and Appsmith for actionable insights.- Spearheaded initiatives to establish and maintain robust data quality practices across the organization, emphasizing data governance and adherence to best practices.- Proactively explored new features of Snowflake, testing their functionality and assessing their potential to enhance company operations.- Planned and managed tasks and projects within the team, ensuring smooth execution and timely deliverables.- Facilitated knowledge sharing within the team, keeping everyone informed and up-to-date with emerging technologies and best practices in data engineering.

Kathmandu, Nepal

- Optimized complex SQL queries in Vertica Database to improve performance of the application.- Designed and developed relational database models to support frontend engineers in the further development of their task. - Developed and maintained procedures, triggers, functions within the system with Oracle PL/SQL to extract and transform data using the provided logic. - Constructed complex SQL queries as required for the application. - Developed Shell scripts to automate script verifications in Linux system.- Mentored new team members to help them acclimate to the company's and the team's norm.- Integrated BI Tool (Tableau) to provide clients a better reporting experience as part of department wide "Innovation day" and was recognized as one of the best ideas.

Bengaluru Area, India

- Managed all aspects of Oracle Database Administrator for 45+ production and 60+ non-production databases which includes design, installation, creation, monitoring, storage management, security, backup, and recovery. - Built PL/SQL and Shell scripts to automate day to day task and configure alerts.- Achieved competency in Oracle GoldenGate and performed column addition, table addition and data replication between source and target databases. - Managed restoration, migration and upgradation of databases using RMAN. - Accomplished the migration and upgradation of SCMS production database from 9.2.0.8 to 11.2.0.4.- Worked on upgradation of SIEBEL database which is of 7.5TB from 11.2.0.3 to 11.2.0.4.