User

Data Engineer

BMT Score
86
86%
  • Remote

Available for

About Afroz

Having  7+ years of IT experience on PostgreSQL Database Development & Data Analyst. Good experience in PostgreSQL Administration activities. Good knowledge in Data Analysis & Data mining domain. Good knowledge in pentaho ETL tools & BA Server. Having good knowledge on linux and windows platforms.
 

Tech Stack Expertise

  • Tech Stack Expertise

    PostgreSQL

    PostgreSQL

    0 Years
  • Tech Stack Expertise

    Java

    Spring Boot,Java 8

    0 Years
  • Tech Stack Expertise

    Kotlin

    Maven

    0 Years
  • Tech Stack Expertise

    MySQL

    MySQL

    0 Years
  • Tech Stack Expertise

    Microsoft .Net

    Rest API

    0 Years

Work Experience

Images

Data Engineer

  • January 2016 - January 2023 - 7 Year
  • India

Projects

Images

AePDS

  • February 2017 - December 2017 - 11 Months
Technologies
Role & Responsibility
     The Food & Civil Supplies Department of Andhra Pradesh Government has been battling with various issues like corruption, misuse of rations allotted to the Fair Price Shops by the vendors, misappropriation of commodities by using fake ration cards. The Food & Civil Supplies Department has requested for a solution to track the flow of commodities right from stores to the beneficiaries.  To overcome from this state government introduced POS machines. By using these machines beneficiary have to give his thumb print while taking ration from fair price shop (FPS). We provided web service to that POS machine vendor for verification
    .
    Role and Responsibilities: 
     Getting Data from various data sources such as Excel, Text, XML, CSV and different SQL files.
    Restore the ​different  SQL Backup Files and Convert Data into Postgresql Format & load into Live tables.
    Creating tables like Star Schema & Snowflake schema tables and ​Develop Dynamic and Statistical reports of different departments for Central DashBoard.
    Writing the complex queries & Analyzing data and publishing with accurate reports.
...see less
Images

AST2 PLATFORM

  • May 2019 - January 2020 - 9 Months
Technologies
Role & Responsibility
     Integrating a new tool Jaeger Tracing used by AST2 PLATFORM to monitor the incoming new requests and response for
    Distributed context propagation.
    Distributed transaction monitoring.
    Root cause analysis.
    Service dependency analysis.
    Performance / latency optimization.

    Role and Responsibilities: 
     Gathering client requirements and analysis through SCRUM meting
    Analyze service requirement and create REST Full Services in Java.
    Create the spring Boot services
    Create the Jaeger Tracer to see the request response performance
    Write the coding for Jaeger tracer in spring boot application
    Create and read the restful Api
    Using the SQL Developer tool and with using JDBC got the data from data base
    Did unit testing for every functionality developed.
    Jenkins build and deployments, end to end testing of gateways.
...see less
Images

Central AePDS.

  • January 2021 - January 2022 - 13 Months
Technologies
Role & Responsibility
    After Successfully implantation of AePDS project in Andhra Pradesh. The Gov of India take the decision to implement this project into 25+ states. To avoid fake dealers, beneficiary by using  these ePOS machines beneficiary have to give his thumb print while taking ration from fair price shop (FPS). We provided web service to that POS machine vendor for verification.

    Role and Responsibilities: 
       Designed and Implemented Table Partition to handle large data Tables
       Creating database Architect, users & roles assign privileges and Perform the Database cloning using users manage.
       Managing historical data & Data warehouse SCD 1, SCD2  & SCD 3 & Experience in Bulk data loading By Using ETL.
       Performed backup and restore utilities like pg_dump, pg_dumpall, pg_basebackup,pg_restore etc.
       Identify the long running queries, Dead tuples, blocking queries & doing some maintenance Activities.
       Analyze the transaction Data & provide Accurate Reports charts,Graphs  by using Pentaho BA Server.
       Automate repetitive Data flow tasks by creating stored procedures,  Functions & creating schedulers in crontab.
      
...see less

Industry Expertise

Education

Education

in Btech

Bengaluru University
  • January 2011 - June 2014

Our Suggestions