Manigopal Pakkurthi

Background

About Manigopal Pakkurthi

Professional Summary Experience: 3.2 years of IT experience Industry: Information Technology (IT) Role: SQL Developer | Python Developer Technical Skills: Python, SQL, PL/SQL, Data Migration, Database Optimization, ETL Automation, Performance Tuning, Pandas, NumPy, SQLAlchemy, PyODBC, PostgreSQL, SQL Server, MySQL, Oracle Certifications: Python Foundation, Python for Data Science (Great Learning) Key Achievements & Expertise Database Development & Optimization: Designed and optimized complex SQL queries to improve performance and data retrieval efficiency. Created and managed database schemas, tables, indexes, views, and stored procedures to support business applications. Fine-tuned slow-running queries using indexing and optimization techniques, reducing query execution time significantly. Data Migration & ETL Automation: Automated data migration workflows between PostgreSQL and SQL Server using Python, improving efficiency. Extracted, cleaned, and integrated data from Excel files using Python for structured data management. Developed reusable Python scripts for seamless data extraction, transformation, and loading (ETL) across multiple RDBMS platforms. Python & SQL Integration: Utilized SQLAlchemy, pyodbc, psycopg2, and cx_Oracle for cross-platform database connectivity and automation. Automated database health checks and extracted server performance data using Python. Implemented error-handling mechanisms using Python exception handling and SQL error logging to ensure smooth database operations. Performance & Scalability Improvements: Developed partition exchange and table archiving procedures for large audit tables, optimizing storage and retrieval performance. Automated repetitive database operations, reducing manual intervention and enhancing productivity. Collaboration & Stakeholder Engagement: Worked closely with application developers and analysts to understand business needs and provide tailored database solutions. Ensured smooth deployment of database updates and enhancements in production environments.