Client : Apple India Pvt ltdRole : Data AnalystEnvironment : QGIS, Postgres, FME 2019.1, SQL Lite Studio, PostgreSQL and HLARoles and Responsibilities• Responsible for ad-hoc GIS based Analysis, automation analysis and pilot tasks analysis• Responsible for all database activity associated with MAIL Build and MAIL QA tasks• Good expertise in developing and fine tuning of SQL & Postgres queries• Identify gaps in process, tools, input data and specs based on analysis• To improve quality of product, developed SQL queries for data integrity validation for addressing, Ranges and Access points• Worked on large GIS data. Conduct data mining, data modelling, statistical analysis, business intelligence gathering, trending, and benchmarking. Data analytics supports decisions for high- priority mapping environment• Supported Data Scientists with ad-hoc and production algorithms for feature analysis • Developed and deployed several modelsData Migration (MAIL BUILD) Lead:• Work closely with internal teams, partners, and customers to identify and define address data conversion/ingestion requirements• Develop and implement standardized data mapping and conversion models using the FME and PostgreSQL• Validate, test, and maintain all developed data conversion models to ensure successful upload of data from 3rd party provider to Client server• Analyse existing ingestion processes and identify/address problems impacting the quality of our data conversions and implementations• Work with States to resolve data transformation and data matching problems with another source data• Able to analyse, manipulate and process large data sets using standard tools, without loss of data integrity or quality• Able to plan and deliver to specified deadlines• Experience in Quality Assurance & Quality Control. (manual/ automated)• Improved Mail Build process by using Python scripts and FME workbench• Design and develop address data ingestion processes for ROW countries

As im as team lead i will maintain the team.