OnBenchMark Logo

Praveen (RID : qzyclk109sju)

designation   Postgres SQL Developer

location   Location : Noida, India

experience   Experience : 8 Year

rate   Rate: $16 / Hourly

Availability   Availability : Immediate

Work From   Work From : Any

designation   Category : Information Technology & Services

Shortlisted : 2
Total Views : 86
Key Skills
MS SQL Server 2017/2016/2012 PostGre SQL MySQL Talend SnowFlakes SSIS SSRS MongoDB
Discription

Praveen

|Major Skills

MS SQL Server 2017/2016/2012, PostgreSQL, MySQL, Talend, Snowflake, SSIS, SSRS, MongoDB

Career Profile

  • Having 8 years of experience as a Database developer/SQL developer
  • Having experience in analysis and development in MS SQL Server 2017/2016/2012, MySQL, PostgreSQL, MongoDB
  • Experience in loading huge data in Database from multiple sources like file, API and different databases using Talend and SSIS ETL.
  • Creating the database objects - schemas, tables, indexes, views, user-defined functions, cursors, triggers, stored procedure and constraints.
  • Having basic knowledge of java to configure user defined components.
  • Experience of handling S3.
  • Experience in R to perform big data analysis.

Experience in creating stored procedures and functions in SQL server using complex queries/subqueries/dynamic queries and other functionality of MS SQL SERVER.

  • Experience in creating database structure (ex: Table, View).

Experience in Query Optimization.

  • Experience in gathering and understanding change requirements and functional requirements.
  • Initiative-taking, with ability and interest in learning new technologies and adapting quickly to new requirements and environments.
  • Configured, optimized and supported high availability (Replication) MongoDB cluster.
  • Optimized MongoDB CRUD Operations
  • Monitored deployments for capacity, performance, and reliability
  • Identified, troubleshot and resolved live MongoDB issues
  • Fixed response time of a solution through SQL optimization, increasing speed by 4.7X

Educational Qualification

M.C.A from UIM, Allahabad, Dr. A.P.J Abdul Kalam Technical University (Formerly - UPTU)

Work Experience

 

Module Lead (https://www.smartenergywater.com)

Project Undertaken:

Smart Customer Mobile (SCM)

Description: SCM is simplifies utility-customer interaction for a better customer experience. SCM has the user- friendly interface that allows customer to conveniently manage their account and perform day to day function. It is used by customers to track their day-to-day usage of energy and water consumption. SCM is also used by the utilities to alert their customers during outages or to answer simple customer service inquiries.

Responsibilities

      • Managing multiple clients to customize SCM.
      • Working on Talend to create jobs to load data from multiple sources to different targets.
      • Used Talend to extract the data from database to provide different type of reports.
      • Created new tables, written stored procedures and some user defined functions. Created
      • SQL scripts for tuning and scheduling.
      • Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
      • Created and scheduled the jobs for batch processing.
      • Involved in performance tuning to optimize SQL queries using query analyzer.
      • Created indexes, Constraints and rules on database objects for optimization.

CPAU

Description: It is a web application designed and developed for a Utility service. This software divides into different modules: -

      • Payment
      • CSP
      • Usages of Utility
      • Reports

Responsibilities

      • Design and deploy data table structures, reports, and queries.
      • Create Database object, write stored procedure.
      • Interacting with the busines
 
Matching Resources
My Project History & Feedbacks
Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon
Loading…

stuff goes in here!