Praneetha Chandana
Senior Software Engineer
Hyderabad
Summary
Having 5 years 10 months of total IT experience in cloud Application Development, Testing and Support. Drive stability, reliability, and performance by optimizing in application azure data factory pipelines. Gather requirements from business analysts, develop physical data models and create DDL scripts to design database schema and database objects. Process Improvement. An effective communicator with good interpersonal, analytical and completing assigned tasks on time with client servicing abilities.
Overview
6
6
years of professional experience
5
5
years of post-secondary education
Work History
Azure Cloud/Snowflake ETL Developer
SK Life (Health Care) (Coforge)
12.2023 - Current
- Developed ETL processes to efficiently extract, transform, and load healthcare data from diverse source systems into Snowflake Data Warehouse using Azure Data Factory, ensuring seamless integration and data consistency
- Integrated disparate healthcare data sources, meticulously managing data accuracy, consistency, and integrity while strictly adhering to industry compliance standards such as HIPAA
- Designed and optimized Azure Data Factory pipelines to facilitate scalable and reliable data ingestion, transformation, and orchestration, ensuring smooth data flow throughout the entire ETL lifecycle
- Managed and fine-tuned Snowflake databases, including schema design, performance tuning, and query optimization, to support complex healthcare analytics and reporting requirements effectively
- Conducted comprehensive data validation and testing to ensure the accuracy, completeness, and reliability of ETL processes, implementing robust data quality checks and error handling mechanisms
- Monitored ETL jobs closely, swiftly identifying performance bottlenecks and proactively resolving issues to uphold optimal system performance and ensure uninterrupted data availability for healthcare stakeholders
- Generated detailed technical documentation encompassing data mappings, ETL workflows, and system architecture diagrams to facilitate seamless knowledge transfer and ensure project transparency
- Fostered close collaboration with cross-functional teams, including data analysts, business stakeholders, and solution architects, to deeply understand healthcare data requirements and deliver tailored ETL solutions that meet specific project needs
- Ensured compliance with stringent healthcare data privacy regulations (e.g., HIPAA) and implemented robust security measures to safeguard sensitive patient information across the data lifecycle
- Spearheaded continuous improvement initiatives by staying abreast of the latest ETL technologies, best practices, and emerging trends in healthcare data management, proactively recommending and implementing enhancements to optimize processes and drive greater business value.
Azure Cloud/Snowflake ETL Developer
HSCRM (Health Care) (Coforge)
07.2022 - 12.2023
- Developing Azure Data Factory Pipelines to Load data from SFTP to Blob
- And from blob storage to Snowflake
- Data migration from on premises to snowflake
- Involved in Development and Testing of ADF Dataflow pipeline
- Creation of Design Deliverables including Data Mapping documents, Detailed Component Design and Technical Architecture Document
- Implemented end to end flow in order to pull the Data from sterling folder to Azure Data Lake, Snowflake tables using ADF Data flow Pipeline
- Worked on the CI/CD pipelines to deploy the code
- Worked on Azure Devops Agile board for tracking User Stories.
- Reviewed project requests describing database user needs to estimate time and cost required to accomplish projects.
Senior Software Engineer
Orkla(Health care) (Amazon)
07.2020 - 07.2022
- Being responsible for the planning, implementation, and growth of the AWS cloud infrastructure
- Build, release, and manage the configuration of all production systems
- Manage a continuous integration and deployment methodology for server-based technologies
- Work alongside architecture and engineering teams to design and implement any scalable software services
- Ensure necessary system security by using best in class cloud security solutions
- Stay current with new technology options and vendor products, evaluating which ones would be a good fit for the company
- Implement continuous integration/continuous delivery (CI/CD) pipelines when necessary
- Recommend process and architecture improvements
- Troubleshoot the system and solve problems across all platform and application domains
- Oversee pre-production acceptance testing to ensure the high quality of a company's services and products.
- Spearheaded the adoption of modern programming practices, promoting continuous improvement in development processes.
- Mentored junior developers, fostering professional growth and enhancing team productivity.
- Conducted thorough testing to identify and resolve bugs, ensuring optimal software performance.
- Streamlined development workflows, increasing team efficiency and reducing time spent on repetitive tasks.
- Stayed current on industry trends, incorporating emerging technologies into new projects when appropriate.
- Implemented robust security measures to protect sensitive data and ensure system integrity.
- Developed scalable applications using agile methodologies for timely project delivery.
ETL Developer
ICA Report Management (Concentrix)
06.2018 - 07.2020
- The primary objective is to derive actionable insights from business data and compiling them into one easily accessible storage and formulate customized strategies
- Development of application using Azure Data Factory
- Extracting the data from different Source Systems, Transforming, and loading into Destination
- According to the business requirements application of various components like creating data factory
- Creating the Linked Services for various Source Systems and Target Destinations
- Parameterizing the Datasets and Linked Services using the Parameters and Variables.
- Developed custom reports for business stakeholders, providing valuable insights into key performance metrics.
- Evaluated new technologies for their feasibility in enhancing current processes or addressing business requirements.
- Reduced processing time for ETL tasks through the implementation of parallel execution strategies.
- Increased data accuracy by implementing thorough validation checks and error-handling mechanisms.
- Gathered, defined and refined requirements, led project design and oversaw implementation.
- Developed database architectural strategies at modeling, design, and implementation stages to address business or industry requirements.
Education
B.Tech - Bachelors of Technology
Jawaharlal Nehru Technological University
Eluru 01.2013 - 12.2017
Skills
Database programming
Accomplishments
- Azure DP - 203 Certified
- Azure DP - 900 Certified
Core Competency
- Azure Data Factory
- Data Lake
- Development
- Testing
- Support
Technology Proficiency
Azure Data Factory, AWS, SERVICE NOW, REST-API, Azure DP - 203 - Certified, Azure Data Fundamentals DP-900 - Certified, Azure Fundamentals AZ-900 - Certified, Azure Data Factory, Data Lake, Azure cloud SQL server, Synapse, AWS Solution Architect, EC2, S3, Lambda, Snowflake cloud database, MYSQL, DB2, Windows, Linux, Azure Data Factory, Azure Cloud SQL, Data Lake, Agile, Waterfall
Domain Sub Domain
- Health care
- Banking
- Finance
- Insurance
Timeline
Azure Cloud/Snowflake ETL Developer
SK Life (Health Care) (Coforge)
12.2023 - Current
Azure Cloud/Snowflake ETL Developer
HSCRM (Health Care) (Coforge)
07.2022 - 12.2023
Senior Software Engineer
Orkla(Health care) (Amazon)
07.2020 - 07.2022
ETL Developer
ICA Report Management (Concentrix)
06.2018 - 07.2020
B.Tech - Bachelors of Technology
Jawaharlal Nehru Technological University
01.2013 - 12.2017
Similar Profiles
Schnaison DelvaSchnaison Delva
Medical Interpreter at Health CareMedical Interpreter at Health Care
Carol PattersonCarol Patterson
Community Health Nurse at Health careCommunity Health Nurse at Health care
Bensouidi LatifaBensouidi Latifa
Registered Nurse at Health CareRegistered Nurse at Health Care
S N Aditya MurthyS N Aditya Murthy
Lead Product Manager - Digital Supply Chain at Dr Reddy's LaboratoriesLead Product Manager - Digital Supply Chain at Dr Reddy's Laboratories
Abhiram BarikAbhiram Barik
Architect at ZscalerArchitect at Zscaler