Abhishek Pandilla
Hyderabad
Summary
Efficient data engineer and analyst with 5.10 years of relevant technology experience and data processing skills. Data-driven and analytical innovator with excellent problem-solving skills.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Sr. Data Analyst
IPG MediaBrands
Mumbai, Remote
10.2020 - Current
- Created views with optimized SQL Queries.
- Developed complex SQL queries to analyze large datasets for trends and insights.
- Designed, developed and implemented ETL processes for data integration from multiple sources.
- Automated daily reporting processes with Python scripting techniques.
- Lead the design, implementation, maintenance, and support of enterprise data systems architecture solutions.
- Optimized database design and queries for improved performance of analytics operations.
- Lead a team of 5 for database migration from Redshift to snowflake.
Software Engineer
SP SOFT PVT LTD
Hyderabad
08.2018 - 10.2020
- Developed SQL queries to analyze data integrity across various databases.
- Utilized virtual machines for cross-platform compatibility testing.
- Worked with Agile and Scrum methodologies to accomplish project milestones and meet demanding timelines.
- Created automated tests for regression testing of all new features.
- Analyzed user requirements to develop software solutions and created technical specifications.
Education
Bachelor of Technology - Electronics And Communications Engineering
SR Engineering College
Hanamkonda05-2015
Skills
- Data Warehousing
- Python Programming
- AWS Snowflake, Redshift, S3, SQL
- Tableau
- Data Pipeline Design
- Machine Learning
- Big Data tools
- MS Office
key Projects
- Geico:
Designed a data warehouse solution linking diverse data from various platforms and setup a framework for generating actionable insights.
Formulated detailed optimization strategies based on historical and present data.
- Aldi and Quicken Loans:
Led a team of 5 for database migration from Redshift to Snowflake
- Terminix and Datorama:
Migrated data sources from Datorama to snowflake to switch visualization from Datorama to Tableau.
Key Projects
Analytics DataFlowML
- Deployment of the application on multi-node clusters, ensuring scalability and reliability.
- Responsible for testing the analytics component within DataFlowML, including building models to test machine learning algorithms.
- Conducting various types of testing, including functional, regression, end-to-end, and re-testing to ensure the application performs as expected.
- Regular involvement in client calls to understand their business requirements and ensure alignment with project goals.
- Improved application reliability through comprehensive testing and analysis.
Certification
DatoramaDatoramaDatorama
- PG Diploma certification from Edvancer, Hyderabad.
- Received Top Gunn Award for superior performance in Q4 by Kinesso (Dec’21).
Timeline
Sr. Data Analyst
IPG MediaBrands
10.2020 - Current
Software Engineer
SP SOFT PVT LTD
08.2018 - 10.2020
Bachelor of Technology - Electronics And Communications Engineering
SR Engineering College
Similar Profiles
Alejandra Miranda LuhersAlejandra Miranda Luhers
Managing Director at IPG Mediabrands UruguayManaging Director at IPG Mediabrands Uruguay
Edie RobinsonEdie Robinson
Marketing & Account Support at IPG Mediabrands (Rapport WW)Marketing & Account Support at IPG Mediabrands (Rapport WW)
Aman PantAman Pant
Assistant Manager Media Planning & Buying at Interactive Avenues ( IPG Mediabrands )Assistant Manager Media Planning & Buying at Interactive Avenues ( IPG Mediabrands )
THAIS FIORITHAIS FIORI
Programmatic Supervisor at IPG Mediabrands LTDAProgrammatic Supervisor at IPG Mediabrands LTDA
PETLA VENKATA DHATRI VISWANADHPETLA VENKATA DHATRI VISWANADH
Mechanical Engineering Intern at JDK DronesMechanical Engineering Intern at JDK Drones