Siddharth Ashok Patro

1. Data Product Portal (DPP)

• Built scalable ETL pipelines to process and ingest metadata from diverse sources into Databricks and Neo4j.
• Designed and implemented GraphQL APIs to power data discovery and lineage visualization features.
• Developed backend systems for metadata processing, enabling governance and compliance tracking across data assets.
• Optimized pipeline performance to ensure real-time metadata updates for end users.

2. Project NOVA

• Developed Python automation scripts (Selenium WebDriver) to scrape, categorize, and organize documents.
• Implemented workflows for secure storage of documents in Azure Storage Accounts.
• Extracted and stored metadata into SQLite and Azure Data Lake for downstream integration.
• Designed ingestion processes to support scalable metadata analytics and reporting.

3. Gas Growth Visualization

• Built pipelines to ingest and process oil & Gas price data into Azure Data Lake.
• Ensured data accuracy, reliability, and timeliness throughout ingestion and storage processes.
• Implemented security measures to safeguard sensitive energy market data.
• Developed Power BI dashboards to visualize price trends and deliver actionable insights to
  stakeholders.

4. IoT Time Series Data Management and Analytics

• Designed, Implemented and Orchestrated the E2E Automation Process for adding new sensor tags to live streaming data from the PI Server, utilizing Azure IoT Stack and SQL Database components to optimize system efficiency and reliability.
• Developed a custom docker hosted IoT .NET PI Backfill adapter to stream past data from oil rigs/refineries/wind around the world to a centralized storage location for the external consumers to be ingested with features such as: disaster recovery, self-healing backfills capabilities, end-to-end dashboards to track metrics for each module, and auto-recovery upon failure or VM crash.
• Created a hierarchical data model with defined types and instances using Data bricks and Scala language, specifically for implementation in Azure Time Series Insights, to analyze and monitor sensor tags for visualization.
• Implemented automation of IoT resource provisioning and deployment process by developing PowerShell scripts and ARM templates.
• Implemented configuration of Azure cloud services to enable endpoint deployment for Azure IoT solutions.

• Developed an Audit Trail Application to track and record chronological updates happening on the various domain objects (Project, Operations, and Ops Activity etc.)
• Captured the changes done from the database using Mongo change event feature and provide the user the ability to compare the changes done on a domain object.
• Implemented applications using .NET MVC, Angular5, HTML5, CSS for Front-End and MongoDB as the database.
• Coordinate software system installation and monitor equipment functioning to ensure specifications are met.
• Develop and direct software system testing and validation procedures, programming, and
  documentation.

• Developed a web application for healthcare services to maintain and record complete medical history of its patients and provide an interface for patients to monitor their health; based on MEAN (MongoDB, Express, Angular, Node) stack.
• Assessed the usefulness of pre-developed application packages and adapt them to a user environment.
• Prepared cost-benefit and return-on-investment analyses to aid in decisions on system implementation.
• Documented all codes and various function tests to increase understandability and maintainability by others and took the lead to keep track of the progress of the modules for every meeting.