Piyush manoj patil

Piyush manoj patil

Data Analyst
India

نبذة عني

Certified data analyst dedicated to advancing in dynamic tech environments, exhibiting ambition and a strong professional drive. Currently seeking a career transition to apply and enhance skills, extracting insights from…

الخبرة

Programmer Analyst

Cognizant Technology Solutions
Dec 2021 - حتى الآن · 4 سنوات 7 أشهر

Worked as sql developer with roles and responsibilities as

1. **Database Development:**
- Designing database tables and structures.
- Writing efficient SQL queries to retrieve and manipulate data.
- Creating and maintaining database objects such as tables, views, stored procedures, and functions.

2. **Data Analysis:**
- Analyzing and understanding database schema and data requirements.
- Writing complex SQL queries for data analysis and reporting purposes.
- Identifying data patterns, trends, and anomalies.

3. **Performance Tuning:**
- Identifying and resolving performance issues in SQL queries and database procedures.
- Optimizing SQL queries and database performance.

4. **Data Integration:**
- Importing and exporting data between different databases and systems.
- Integrating data from various sources into the database.

5. **Database Administration:**
- Performing database maintenance tasks such as backup and recovery.
- Monitoring database performance and ensuring high availability.

6. **Documentation:**
- Documenting database designs, schemas, and processes.
- Writing technical documentation for database objects and procedures.

7. **Collaboration:**
- Collaborating with other team members, such as software developers, data analysts, and business analysts.
- Participating in team meetings and discussions related to database development and data management.

8. **Troubleshooting and Support:**
- Providing support and troubleshooting assistance for database-related issues.
- Investigating and resolving data discrepancies and integrity issues.

9. **Continuous Learning:**
- Keeping up-to-date with the latest developments in SQL and database technologies.
- Learning new tools and techniques to improve database development and performance.

10. **Security:**
- Implementing and maintaining database security measures.
- Ensuring data integrity and confidentially.

Programmer Analyst

Cognizant Technology Solutions, Pune
حتى الآن

Collaborated with project managers to develop and execute cost-saving strategies.
Developed and implemented SQL queries to ensure database integrity.
Utilized SQL queries to analyze and extract insights from large datasets for effective reporting and analytics.

المهارات

إدارة قواعد بيانات DB2 أوراكل لغة الاستعلامات الهيكلية (SQL) مزود بيانات SQL Server من مايكروسوفت خدمات تقارير SQL Server Power BI Python Data Visualization Data Analysis Excel NumPy Pandas MySQL
الإبلاغ عن هذا الملف الشخصي؟