Ramesh Gangula

Project: Siemens - Return Quality Performance Cockpit - Migration Project.

Key Responsibilities:

• I work closely with product development teams to ensure that the data are processed and meet the required quality standards and specifications.
• Designing and developing data pipelines using Azure Data Factory, Azure Databricks, Azure Synapse Analytics, Azure Data Lake Gen 2, Azure Key Vault, and other relevant tools, ensuring efficient data ingestion and transformation.
• Extracting data from diverse sources, like RestAPI, CSV, and relational databases, performing data cleansing and transformation using Azure Data Factory and Databricks (PySpark/SQL), and loading it into cloud-based data storage systems while ensuring data quality and accuracy.
• Working closely with the reporting team to cater to curated data based on their requirements for analytics.
• Use tools like Azure DevOps for version control and continuous integration/continuous deployment (CI/CD).
• Utilized the JIRA Kanban Board to track progress.

Project: Siemens - Healthiness (Patient Data Harmonization) - Migration Project.
Key Responsibilities:

• Collaborating with business stakeholders to understand functional requirements and translating them into scalable data solutions, leveraging appropriate Azure services and components.
• Designed and implemented efficient data pipelines using Azure Data Factory.
• Created data pipeline jobs, scheduled triggers using Azure Data Factory.
  Experience with various data storage solutions, such as Azure Data Lake Storage and Azure Blob Storage.
• Conducted performance tuning and optimization of data processes to meet project timelines.

Project: Siemens - Quality Performance Cockpit.
Key Responsibilities:

• Involved in designing, developing, testing, and publishing QS applications.
• Implementing a 3-tier architecture to extract, transform, and load data to build a data model and develop dashboards.
• Creating dashboards using different objects, like KPI, filter pane, pie chart, line chart, straight table, pivot table, combo chart, etc.