Pawan Harne

Senior Product Development Analyst | Database Developer, SQL Server, MySQL, and GraphDB at intellimation.ai
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Mumbai, Maharashtra, India, IN

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Microsoft Certified: Azure Data Fundamentals
    Microsoft
    Jan, 2022
    - Nov, 2024

Experience

  • intellimation.ai
    • India
    • Software Development
    • 1 - 100 Employee
    • Senior Product Development Analyst | Database Developer, SQL Server, MySQL, and GraphDB
      • May 2023 - Present

      1. Administered and maintained multiple SQL databases, ensuring data integrity, security, and availability.2. Optimized database performance by analyzing query execution plans, indexing strategies, and database statistics, leading to a 30% improvement in application responsiveness.3. Using Power BI created reports, dashboards, and data visualizations.4. Write Cypher queries, Neo4j's query language, to retrieve and manipulate data.5. Design the graph database schema, including nodes, relationships, and properties.6. Liaise with the broader Neo4j ecosystem, including Neo4j Desktop Show less

    • Product Development Analyst
      • Sep 2021 - May 2023

      1. Design and create database structures, tables, relationships, and constraints, entity-relationship diagrams (ERDs), and schema definitions.2. Monitor and analyze database performance using profiling tools.3. Conduct regular database maintenance, including defragmentation and statistics updates.4. Ensure data consistency and accuracy during migrations.5. Collaborated with development teams to fine-tune SQL queries and improve application performance, resulting in enhanced user satisfaction.6. Implemented automated database backup and recovery strategies, minimizing data loss and downtime during critical incidents. Show less

  • GreenPoint Global
    • United States
    • Financial Services
    • 100 - 200 Employee
    • Ms SQL Database Developer
      • May 2019 - Sep 2021

      1. Write and optimize T-SQL queries, functions, triggers, and stored procedures. 2. Ensure efficient data retrieval, manipulation, and storage within Azure SQL Database. 3. Perform data recovery and restoration as needed. 4. Integrate Azure SQL Database with other Azure services such as Azure Data Factory. 5. Set up monitoring and alerting for Azure SQL Database using Azure Monitor and Azure Alerts. 6. Use PowerShell scripts for automated database tasks and deployments. 7. Deploy database changes to different environments (development, testing, production) in a controlled manner. Show less

Education

  • NCRD Sterling Institute of Management Studies
    Master of Computer Applications - MCA, MCA
    2019 - 2022
  • Pillai College of Arts,Commerce and Science
    Bachelor of Science - BS, Information Technology
    2014 - 2018

Community

You need to have a working account to view this content. Click here to join now