Abhilash Goud Maddi
New Haven,CT
Summary
Enthusiastic IT professional with 3+ years of experience, skilled in big data technologies like Apache Hive and Spark, and cloud ETL tools including Azure Data Factory and Databricks. Proficient in Pega development, adept at creating solutions that improve business processes and customer interactions. Combines expertise in Pega with big data and cloud technologies to deliver scalable and efficient solutions. Demonstrated ability to integrate Pega systems with cloud-based data platforms, enhancing operational workflows and data-driven decision-making. Committed to leveraging a blend of BPM and analytics to drive business innovation and efficiency.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Data Engineer
Tata Consultancy Services (Saudi Telecom)
Hyderabad
12.2022 - 11.2023
- Engineered real-time data streaming solutions using Apache Kafka, optimizing data flow and processing efficiency.
- Implemented large-scale data processing frameworks with Apache Spark, enhancing analytical performance and insights.
- Developed and maintained complex ETL pipelines, utilizing Python for scripting and advanced SQL for data manipulation, ensuring seamless data integration and warehousing.
- Utilized the Hadoop ecosystem, including HDFS for scalable storage and Hive for efficient data querying, supporting robust big data infrastructure.
- Applied advanced data modeling techniques and schema optimization to facilitate efficient data transactions and deep analytical queries.
- Established stringent data validation and cleansing protocols to maintain high data quality, ensuring reliability and accuracy in analytics and decision-making processes.
Pega Developer
Tata Consultancy Services(Standard Chartered Bank)
Hyderabad
12.2021 - 11.2022
- Engineered advanced Pega PRPC solutions tailored for Standard Chartered Bank's core banking systems, focusing on complex case management and decisioning capabilities to streamline operations and risk assessment processes.
- Developed and maintained secure API integrations between Pega applications and the bank's SQL and NoSQL databases, facilitating real-time data transactions and ensuring high data integrity in financial operations.
- Implemented Pega Data Pages and Data Transforms to efficiently handle large volumes of banking data, optimizing data caching strategies to improve application performance and user experience.
- Utilized Pega's Database Table Mapping feature to directly map Pega Data Models to the bank's underlying database tables, enhancing data retrieval and manipulation efficiency while ensuring compliance with banking data standards.
- Designed custom SQL queries and stored procedures within Pega to execute complex data aggregation and reporting tasks, supporting the bank's analytical and compliance reporting needs.
- Conducted thorough performance analysis and tuning of Pega applications in conjunction with Oracle and SQL Server databases, applying indexing, partitioning, and query optimization techniques to meet the high-performance demands of banking environments.
Graduate Engineer Trainee
Thermopads Private Limited
Hyderabad
09.2020 - 08.2021
- Developed and managed SQL databases for storing and organizing test data, ensuring efficient data retrieval and analysis for ongoing and historical test results.
- Implemented advanced database querying within LabVIEW to dynamically fetch and update test parameters and results, facilitating real-time data-driven decision-making.
- Designed comprehensive reporting tools within LabVIEW, generating detailed test reports and dashboards that highlight key performance metrics, trends.
- Automated the export of test data to external databases and reporting platforms, enabling cross-functional team access and facilitating collaborative analysis and review.
- Ensured data integrity and security in database operations, applying best practices for data management and adhering to industry standards for data privacy and protection.
Jr.Data Engineer- Intern
Tata Consultancy Services
Hyderabad
02.2019 - 02.2020
- Analyzed and interpreted ETL requirements to develop and enhance data integration solutions, successfully building and optimizing complex ETL/ELT pipelines in Azure Cloud using Azure Data Factory.
- Enhanced data processing performance by conducting thorough back-tracing and optimization of ETL mappings within Azure Data Factory pipelines.
- Developed and maintained stored procedures for efficient data loading into fact and dimension tables in Azure SQL Data Warehouse, ensuring data integrity and accessibility.
- Crafted and executed advanced PySpark/SparkSQL queries in Azure Databricks to meet intricate business requirements, facilitating insightful data analysis.
- Served as the go-to expert for production support, leading the implementation of new data frameworks leveraging Azure Data Factory and Azure Databricks, enhancing operational efficiency.
- Spearheaded the migration of on-premises SQL Server data to Azure Data Lake Store (ADLS), employing Azure Data Factory to ensure seamless and secure data transfer.
- Investigated and resolved complex HiveQL query issues, guaranteeing accurate data representation in reports and aligning source-to-sink data consistency within the SQL Data Warehouse.
Education
Master of Science - Data Science
Sacred Heart University
Fairfield, CT12.2024
Bachelor of Technology -
Vidya Jyoti Institute of Technology
Hyderabad06.2020
Skills
- Mongo DB
- Azure Databricks
- Azure Data Factory
- Apache Spark
- PySpark
- SparkSQL
- Azure Synapse Analytics
- Apache Hive
- Azure SQL DB
- Python
- ADLS Gen 2
- SQL
- PEGA PRPC
- LabViewTesting
Certification
1) Microsoft Azure Fundamentals AZ-900
2) Microsoft Data Fundamentals DP -900
3) Microsoft Azure Data Engineer Associate DP-203
4) Pega Certified System Architect 8.6
5) Mongo DB python Developer Path
Achievements
Recognized for exceptional academic adaptability and swift mastery of complex subjects, earning the "Quick Study Scholar" accolade at BITS Pilani for outstanding performance in advanced engineering and technology coursework.
Languages
English
Full Professional
Timeline
Data Engineer
Tata Consultancy Services (Saudi Telecom)
12.2022 - 11.2023
Pega Developer
Tata Consultancy Services(Standard Chartered Bank)
12.2021 - 11.2022
Graduate Engineer Trainee
Thermopads Private Limited
09.2020 - 08.2021
Jr.Data Engineer- Intern
Tata Consultancy Services
02.2019 - 02.2020
Master of Science - Data Science
Sacred Heart University
Bachelor of Technology -
Vidya Jyoti Institute of Technology