Abhishek Guleria

The objective was to create Invoice Data so that client can offer various offers to their customers. Analyzed the data stored in Google Big Query and 3rd Party data, containing the customers information, their purchase history, subscription plans, sales data etc. Client wanted to create MRR report based on Invoice Data. Migration of Data from SQLite to PostgreSQL and have automated data migration process, the frequency is monthly.

Worked on creation of SQL scripts for CRM team.

Extract data from various data sources and loading, cleansing and transforming the data. Developed Data in the Data lake by ingestion, cleansing and processing data to create canonical models. Developed Spark code in Pyspark using Spark SQL & Data Frames. Utilize my Python and SQL expertise to design, test, document, deploy and maintain program to meet individual client requirement in accordance with SDLC standards and guidelines. Performance tuning of Spark queries and have implemented Data Quality checks. Conduct data cleaning, manipulation, modification and combination using variety of steps and functions. Worked closely with business and Data Science teams to encourage statistical best practices with respect to experimental design, data capture and data analysis.