Pooja Keste

Highly motivated and experienced Database Specialist with a proven track record in database design, implementation, and management. Expertise in optimizing database performance, ensuring data integrity, and implementing robust backup and recovery solutions. Proficient in SQL and NoSQL databases, data warehousing, and data migration. Seeking a challenging role where I can leverage my skills to improve data accessibility, efficiency, and security.

Database Specialist - RioMed Technologies India Pvt.Ltd. - Pune, Maharashtra

(2022-01)

• Led data migration projects, ensuring data integrity and minimal downtime.
• Supported 50+ production databases and reduced incident resolution time by 35%.
• Executed MySQL 5.7 to 8.4.8 upgrade with zero data loss.
• Generated monthly reports to validate data accuracy, identifying and resolving discrepancies to maintain data quality.
• Configured and maintained SSRS, auto-backup, and replication solutions for enhanced data availability and disaster recovery.
• Developed and implemented a data warehouse solution that reduced data retrieval time by 50% for complex queries, improving reporting efficiency.
• Implemented NoSQL databases to meet high-performance and scalability requirements, supporting growing data volumes.
• Implemented database replication techniques to ensure data availability and fault tolerance, minimizing data loss in the event of system failures.
• Contributed to the design and implementation of a data lake to store and analyze unstructured data, enabling advanced analytics capabilities.
• Developed and implemented database performance tuning strategies to optimize query execution, improving application responsiveness.
• Coordinated with vendors to resolve database-related issues and implement product updates, ensuring system reliability and security.
• Participated in the development and implementation of database disaster recovery plans, minimizing business disruption during outages.
• Managed database security audits to ensure compliance with regulatory requirements, protecting sensitive data from unauthorized access.

Data Engineer - Xapotech Systems (P) Ltd. - Noida, Uttar Pradesh

(2019-05 - 2022-12)

• Translated business requirements into quantitative queries and collected/cleaned data, ensuring data quality for analysis.
• Built scalable databases capable of efficient ETL processes using SQL and Spark, supporting large-scale data integration.
• Evaluated and optimized data pipelines, increasing efficiency for daily processing of massive datasets.
• Utilized MongoDB to create NoSQL databases that harvested data from diverse sources, enabling flexible data storage and retrieval.
• Utilized machine learning techniques to build predictive models and identify trends and patterns in data, providing actionable insights.
• Developed data visualization dashboards and reporting tools using Tableau, Power BI, and Looker to communicate insights and support decision-making, improving data-driven decision making.
• Developed and implemented data pipelines to ingest, transform, and load large volumes of data from various sources using Apache Spark, streamlining data integration processes.

Assistant Professor - MESCOE Wadia College Campus - Pune

(2016-12 - 2019-04)

• As Assistant Professor in the Department of Computer Engineering.
• Developed and implemented lesson plans aligned with departmental and university curricula, effectively engaging students in interactive and stimulating learning experiences.
• Facilitated group discussions, seminars, and workshops to foster critical thinking, problemsolving, and teamwork among students.
• Established and maintained effective relationships with students, colleagues, and the university administration.
• Mentored undergraduate students in research projects, fostering their interest in academia.
• Utilized evidencebased teaching practices to improve student outcomes.
• Participated in outreach programs to promote STEM education in underrepresented communities.
• Collaborated with community organizations to provide experiential learning opportunities for students.

M.E. - Computer Engineering - Savitribai Phule Pune University (2016)

MESCOE, Wadia College campus

Diploma - Data Analytics - Big Data Technologies - KNOW-IT, C-DAC ACTS (ATC), Pune (2022-08)