Talent's Information
-
Location
Bengaluru, India
-
Rate
$12.0 per Hour
-
Experience
7 Year
-
Languages Known
English,Hindi
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
-
PostgreSQL
PostgreSQL
0 Years -
Java
Spring Boot,Java 8
0 Years -
Kotlin
Maven
0 Years -
MySQL
MySQL
0 Years -
Microsoft .Net
Rest API
0 Years
Work Experience
Data Engineer
- January 2016 - January 2023 - 7 Year
- India
Projects
AePDS
- February 2017 - December 2017 - 11 Months
-
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.
AST2 PLATFORM
- May 2019 - January 2020 - 9 Months
-
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.
Central AePDS.
- January 2021 - January 2022 - 13 Months
-
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.
Soft Skills
Industry Expertise
Education
in Btech
Bengaluru University- January 2011 - June 2014
