Prachi Kale Email and Phone Number

I'm a Data Engineer from the last 3 years at Tata Consultancy Services, I have hands-on experience in •Collaborate with business stakeholders to comprehensively grasp data analysis requirements and proficiently translate them into technical solutions.•Design and consistently maintain an optimized data pipeline architecture within Microsoft Azure's cloud environment, employing Data Factory and Azure Databricks.•Implement a structured data transfer process, moving data through logical stages from the System of Records to the Raw Zone, Refined Zone, and ultimately the Produce Zone, facilitating seamless translation and denormalization.• Develop robust Data Factory pipelines capable of efficiently bulk copying multiple tables from relational databases to Azure Data Lake Gen2.•Compose PySpark and Spark SQL transformations within Azure Databricks to execute intricate business rule-based transformations, ensuring data integrity and accuracy.• Used denormalized datasets to Power BI for modeling and visualization purposes, sourced from the produced layer within the Data Lake.• Create and sustain data models and schemas to underpin analytical requirements utilizing Power BI, ensuring consistency and relevance in data interpretation.• Conduct thorough exploratory data analysis exercises to uncover valuable insights and discern trends or patterns inherent within the dataset.• Craft compelling visualizations and reports using Power BI to effectively communicate discovered findings and insights to stakeholders, enabling informed decision-making processes.I’m hands on in all stages of the software development cycle, from planning and design to testing and deployment. Requirement gathering, impact analysis, assessment and design solution at functional and technical levels. Mostly experience in software development in agile methodology.Also worked as a Database Administrator for one year at Tata Consultancy Services,• I have been providing AD work, enhancement and maintenance related to Database of applications, worked with complex sql queries.• Collaborated with software developers to optimize SQL queries and enhance application performance.• Created complex SQL queries and optimized database performance to improve query responsetimes.• Developed and implemented database backup and recovery strategies, minimizing data loss risks.I believe continuous learning and development to keep myself up-to-date and up-skilled