Phakruddin sheik
Software Engineer
Hyderabad,TG
Summary
Dynamic Software Engineer with expertise in Snowflake and AWS, previously at Carelon Global Solutions. Proven track record in optimizing SQL queries and automating processes, enhancing team productivity. Skilled in Informatica and Python, with a strong ability to troubleshoot and resolve complex issues, ensuring data integrity and seamless software deployment.
Overview
7
7
years of professional experience
Work History
Software Engineer
Carelon Global Solutions Pvt Ltd
07.2024 - Current
- Working on the Snowflake tool by writing the end-to-end SQL queries for the logic implemented in the mapping.
- Using AWS Cloud Services like S3, Cloud Watch, lambda functions and Glue jobs to trigger, monitor, and identify the logs of the application jobs.
- Performance tuning of queries.
- Automated the process to send mails on failures.
Systems Integration Senior Analyst
NTT Data Information Processing Services
10.2023 - 06.2024
- Design, develop, and test ETL mappings, sessions, and workflows using Informatica PowerCenter or Cloud.
- Write and optimize SQL queries, stored procedures, and functions for data manipulation, extraction, and loading.
- Create and maintain database objects like tables, indexes, views, and synonyms.
- Troubleshoot and resolve issues related to ETL processes and database performance.
- Developed several reusable transformations and mapplets that were used in other mappings.
- Create and maintain technical documentation, including mapping specifications and design documents.
- Understand data structures and model data for effective ETL processes.
- Implement data quality rules and validations to ensure data integrity.
- Enhanced team productivity by streamlining workflow processes and implementing time-saving strategies.
Senior Software Engineer
Inventech Info Solutions Private Limited
05.2023 - 09.2023
- Involved in all phases of SDLC from requirement gathering, design, development, testing, production, user training and support for production environment.
- Worked on the Oracle tool by writing the end-to-end SQL queries for the logic implemented in the mapping.
- Develop the mappings using needed Transformations in Informatica tool according to technical specifications.
- Developed several reusable transformations and mapplets that were used in other mappings
Associate Software Engineer
Satsan Software Technologies Pvt Ltd
01.2018 - 04.2023
- Involved in understanding the sources, targets, transformed the data, mapped the data and loading the data into targets using Informatica.
- Developed Parameter file generation mapping.
- Developed audit statics mapping for capturing source and target counts and failure status.
- Understanding the functional specifications and the documents related to the development and involved in the data analysis.
- Mainly Involved in Development, Testing, Migration.
- Created deployment document for code migration across all environments.
- Involved in addressing defects and issues identified during data load.
- Collaborated with cross-functional teams to develop, test, and deploy high-quality software solutions for clients.
- Participated in sprint planning sessions by estimating task complexity and prioritizing work items.
- Enhanced application performance through optimization of algorithms and data structures.
- Developed well-organized training materials for end-users, enabling seamless adoption of new software features.
Education
Bachelor of Technology -
Al-Ameer College of Engg & IT
Visakhapatnam, India 04.2001 -
Skills
Snowflake
Timeline
Software Engineer
Carelon Global Solutions Pvt Ltd
07.2024 - Current
Systems Integration Senior Analyst
NTT Data Information Processing Services
10.2023 - 06.2024
Senior Software Engineer
Inventech Info Solutions Private Limited
05.2023 - 09.2023
Associate Software Engineer
Satsan Software Technologies Pvt Ltd
01.2018 - 04.2023
Bachelor of Technology -
Al-Ameer College of Engg & IT
04.2001 -
Similar Profiles
DINESH HDINESH H
Associate of Adjustment of Claims at Carelon Global Solutions PVT LTDAssociate of Adjustment of Claims at Carelon Global Solutions PVT LTD
Roopal JainRoopal Jain
Senior Actuarial Analyst at Carelon Global Solutions Pvt. LtdSenior Actuarial Analyst at Carelon Global Solutions Pvt. Ltd
Sushmitha J GowdaSushmitha J Gowda
Claims Associate at Carelon Global Solutions Pvt LtdClaims Associate at Carelon Global Solutions Pvt Ltd
Yami IlangovanYami Ilangovan
Service Delivery Manager at Cognizant Technology SolutionsService Delivery Manager at Cognizant Technology Solutions
Supriya PrathipatiSupriya Prathipati
Microbiologist, Laboratory Quality Control at Niedlfree Technologies Pvt LtdMicrobiologist, Laboratory Quality Control at Niedlfree Technologies Pvt Ltd