ABHIRAME PILLAI
Senior Data Engineer
Trivandrum,Kerala
Summary
Driven, analytical, and solution-focused professional with a solid foundation in data engineering principles and a natural aptitude for problem-solving. Proficient in SQL and Python for data manipulation and analysis. Committed to leveraging technical skills to design and implement scalable data solutions, optimize data workflows, and enhance data-driven decision-making.
Overview
7
7
years of professional experience
2
2
Certifications
4
4
Languages
Work History
Senior Data Engineer/Data Scientist
FTD India Pvt Ltd
Hyderabad
02.2023 - Current
- Led data engineering projects while contributing to data science initiatives, following Agile methodology, supported by Jira
- Created and maintained scalable data pipelines on GCP, leveraging BigQuery, Dataflow, PubSub, Composer, Cloud Function services
- Aided migrations, ensuring necessary process optimizations for efficiency and cost effectiveness
- Proven proficiency in understanding of Python which aided in contributing towards implementation of Media Mix Model as a newbie in the organization
- Explored and implemented customized scheduling features for airflow across organization
- Ensured data quality through rigorous testing, validation, and monitoring of all data assets, minimizing inaccuracies and inconsistencies
- Provide regular updates and reports on system performance and data quality
- Established standard procedures for version control, code review, deployment, and documentation to ensure consistency across the team's work products
Data Engineer
Quantiphi Analytics
Trivandrum
04.2021 - 02.2023
- Project 1 : Dawn Foods : Worked as the only DE in a 5 member team for the client who is major in food products manufacturing
- Working in a fully agile environment in GCP BigQuery, followed with constant client interactions and building up trust
- Data Model development post understanding the data sources and ensuring data quality through unit testing
- Building new perspectives in business requirements, foreseeing challenges in the future business and suggesting ways of improvising the existing business through data analysis
- Able to bring up data mismatches in the legacy system of client
- Ensured client satisfaction which paved way for another contract with the client
- Project 2 : Ingram AI Recommendations : Worked with a team of 10 for the client who is an American distributor of information technology products and services
- Working in a fully agile environment in GCP BigQuery
- Worked to stitch various data sources which includes SAP, Adobe and ODS
- Ensuring data quality through unit testing
- Understanding and working towards the goal of bringing to frontline the analysis of relevant shopping and cart data of customers and thus achieve recommendation model implementation for the customers based on the historical data of purchases by collaborating with the MLEs
- Project 3 : Brady Corporation : Worked with a team of 5 for the client who is an American developer, manufacturer of specialty products and technical equipments
- Working in a fully agile environment in GCP BigQuery, Composer, Apache Airflow using Python code and ensuring data quality through unit testing
- Challenged to fetch data from multiple API sources including Feefo, BrightEdge, GSC, SalesForce CRM
- Data Model development post understanding the sources
- Debugging cron jobs and validating result set quality to ensure successful ETL runs
- Solving business concerns and requirements through analysis of data which ensures client satisfaction and a green signal for the next phase
- Project 4 : Moet Hennessy : Development of complex BigQuery SQL code to calculate the net profit/loss across the organization
- .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting
- Provided technical guidance and mentorship to junior team members, fostering a collaborative learning environment within the organization
Associate Software Engineer
H&R Block
06.2018 - 04.2021
- Project 1 : Workday : Informatica developer, part of 10 member team to implement Workday HR and finance system in the organization which is crucial at maintaining operational excellence for the organization, by providing realtime data at leaders' fingertips
- Knowledge about existing Informatica legacy code
- Worked with multiple teams to understand various workflows within Informatica
- Coding, code review, testing
- Project 2 : Tax Ops DashBoard : ADF/Power BI developer in a 3 member team creating a one stop solution with Power BI dashboard for the leadership which is predominant for understanding the business growth and dip over a range of areas
- Understanding the leadership requirement
- Participation in planning meetings
- Working closely with senior resources in the US
- Project 3 : Marketing Data Platform : Worked as a Microsoft ADF developer
- Part of an eight member team to provide solution for storing data that is critical for outbound and inbound marketing to execute campaigns, segment clients for existing customers and potential associates
- Worked with multiple teams to understand various business areas
- Coordinating with teams working on legacy code
- Building end to end dataflows to manipulate and store quality results
- Coding, code review and testing
- Agile Development Process
Education
Executive Post Graduation Diploma - Data Science
IIIT
Bengaluru, India 04.2001 -
B.Tech - Electronics And Communications Engineering
University Of Kerala
Trivandrum, India 04.2001 -
Twelfth Grade - Computer Science
CBSE
Trivandrum, India 04.2001 -
Tenth Grade -
CBSE
Trivandrum, India 04.2001 -
Skills
Google Cloud Platform
undefinedCertification
GCP Associate Cloud Engineer
Accomplishments
- Young Achiever Award Quantiphi
- Extra Mile Achiever Award (2) - H&R Block
- ACE Team Player Award H&R Block
Quote
There is a powerful driving force inside every human being that, once unleashed, can make any vision, dream, or desire a reality.
Tony Robbins
Timeline
Senior Data Engineer/Data Scientist
FTD India Pvt Ltd
02.2023 - Current
Data Engineer
Quantiphi Analytics
04.2021 - 02.2023
Associate Software Engineer
H&R Block
06.2018 - 04.2021
Executive Post Graduation Diploma - Data Science
IIIT
04.2001 -
B.Tech - Electronics And Communications Engineering
University Of Kerala
04.2001 -
Twelfth Grade - Computer Science
CBSE
04.2001 -
Tenth Grade -
CBSE
04.2001 -
Similar Profiles
Stephan CrockettStephan Crockett
Senior Desktop Engineer at FTDSenior Desktop Engineer at FTD
Lashonia PennixLashonia Pennix
Independent Contractor Driver at FTD Services LLCIndependent Contractor Driver at FTD Services LLC
FELECIA HICKSFELECIA HICKS
Field Business Consultant at FTDField Business Consultant at FTD