Ramesh Gangula

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

Key Responsibilities:

• Stakeholder Collaboration: Engaged with business stakeholders to gather functional requirements, ensuring alignment with data integration objectives.
• Data Extraction & Loading: Utilized Azure Data Factory (ADF) to extract data from Azure storage services and load it into cloud data stores, streamlining data processing workflows.
• Pipeline Optimization: Developed and implemented optimized ADF pipelines, resulting in a significant reduction in execution time and improved processing efficiency.
• Data Transformation: Transformed Parquet files into Delta format, achieving a reduction in storage requirements and enhancing processing speed.
• Automation with Logic Apps: Implemented Azure Logic Apps to automate notifications, reducing manual efforts and enabling real-time updates on job statuses for business users.
• Spark Application Development: Engineered Spark applications within Databricks notebooks using PySpark and Spark SQL for efficient data extraction, transformation, and aggregation across various file formats.
• Incremental Data Loading: Employed Incremental Load methodology in ADF to seamlessly integrate new data files and records, ensuring up-to-date data availability.
• Slowly Changing Data: Implemented SCD1 for fact tables and SCD2 for Dimension tables for the slowly changing data.
• Pipeline Orchestration: Utilized ADF components such as Pipelines, Linked Services, Datasets, Lookups, Get Metadata, For Each loops, and If conditionals to orchestrate seamless data workflows.
• Data Modeling : Creating and maintaining data models that provide efficient access to structured and unstructured data for analytical purposes.
• CI/CD : Used tools like Azure DevOps for version control and continuous integration/continuous deployment (CI/CD).
• Data Security: Created and integrated Azure Key Vault to securely store connection string details and certificates, ensuring robust data security within ADF pipelines.
• Support & Maintenance: Provided comprehensive support and proficiently addressed issues arising throughout the hypercare and support phases, ensuring continuous system reliability.
• Agile Methodology: Collaborated as part of an agile team, participating in daily stand-ups, story grooming, iteration planning, and retrospective meetings to ensure project alignment and timely delivery.

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.