Hoss Feshari

• Designed and developed enterprise-grade web applications using OracleAS TopLink (JPA), enabling high-performance data persistence and seamless integration.
• Applied JPA object modeling to simplify data persistence layer and reduce development complexity.
• Architected and implemented multi-threaded customer order system using master/slave pattern, supporting real-time processing of customer requests.
• Engineered a message-driven Java daemon to handle diverse message types (MQ, HTTP, XML, Web Services), launching concurrent processes dynamically for order fulfillment.
• Integrated backend RDBMS and third-party systems (JMS, MQ, Email) for seamless transaction routing and processing.
• Implemented robust logging and thread-level error handling, ensuring traceability and reliability in high-volume processing environ- ments.
• System remained one of the most stable backend services 3 years post-deployment, validating architectural choices and long-term scalability.

• 2023-11 - 2024-11 Enterprise API Architect
  • Developed a Python-based API using REST principles to automate data synchronization between Rally and Jira, reducing manual
  transfer time by 80%.
  • Integrated AI models (e.g., anomaly detection) to proactively identify undocumented API behaviors during Rally ’Jira migration,
  improving error detection rate by 60%.
  • Leveraged Pandas for high-volume data transformation and migration, increasing data processing speed by 40% during project sprints.
  • Built custom Excel parsers in Python to automate complex data structure transformations, enabling scalable and accurate reporting for
  migration analytics.
  • Automated Jira board and issue management with Python API, improving setup efficiency for new teams and reducing configuration
  time by 50%.
  • Maintained Jira integrity by scripting automated checks for custom fields, backlog versions, and components post-migration using
  Python.

• Created validation scripts to verify field-level accuracy across 10k+ Jira issues post-migration, ensuring 99.9% data consistency.
  • Streamlined user role and permission automation using Jira API, reducing onboarding time for new team members by 70%.
  • Architected automated ETL pipelines using Java APIs to integrate data from 10+ disparate sources, improving ingestion speed by 60%.
  • Leveraged PySpark and Azure Databricks to process 20M+ records monthly, optimizing ETL workflows and reducing compute costs by 35%.
  • Built hybrid-cloud ETL workflows integrating Azure and AWS S3, enhancing data accessibility for downstream analytics teams.
  • Automated DB code generation from structured files (CSV, Excel) using Bash, reducing manual errors and boosting script reliability by 80%.
  • Deployed Python Django-based APIs for global client data ingestion, supporting real-time updates to DW and increasing reporting freshness by 90%.
  • Modeled and optimized Tableau OLAP datasets, reducing report query time from 20s to • Designed high-performance DW architecture on MySQL using advanced SQL and stored procedures, enabling analytics for 10+ global teams.
  • Implemented Azure DevOps CI/CD pipelines to manage DW/Tableau deployments, cutting manual intervention by 70%.
  • Automated endpoint security policies using PowerShell, aligning cloud assets with corporate compliance standards.
  • Streamlined vendor data ingestion by automating ETL workflows using Python/Java and pattern-recognition logic, reducing manual effort by 50%.
  • Integrated AWS Glue for cataloging and transforming 200GB+ of semi-structured data weekly, boosting ETL throughput.
  • Improved Athena query performance by 3x using Glue Data Catalog with custom partitioning on key datasets.
  • Enabled real-time, serverless analytics via Amazon Athena over S3, eliminating infrastructure maintenance and cutting query costs.
  • Ensured 99.99% uptime for Azure-hosted DWs using automated backups, restoration scripts, and performance monitoring.
  • Automated cross-platform SFTP operations and server tasks using Bash, Python, Perl-eliminating manual jobs and reducing failures by 70%.
  • Delivered Azure-based analytics platform to support $6M-$24M, $7M-17M sales deals with real-time insights and executive dash- boards.
  • Integrated multiple satellite Tableau servers with DW backend, standardizing reporting across 5+ regional business units.

Led migration of high-volume transaction services to VISA Data Center, ensuring secure and uninterrupted service continuity for enterprise clients.
• Overhauled and migrated applications using reverse engineering and cross-platform debugging across JBoss and WebSphere on Red Hat, addressing security gaps per VISA compliance.
• Wrote extensive Core Java code to refactor legacy systems and minimize service disruption during infrastructure overhaul.
• Implemented enterprise-grade XML validation (DTD, XSD) and secure configurations to align with VISA's global security standards.
• Refactored and hardened codebase to comply with Veracode security protocols, resolving 100+ vulnerabilities in preparation for audit.
• Diagnosed and resolved integration issues in Customer Acceptance environment, ensuring system stability for transaction testing using simulators.
• Re-architected application to phase out EJBs and JBoss, transitioning to tcServer to improve maintainability and reduce licensing costs.
• Developed comprehensive JUnit and mock-based test suite (Mockito, PowerMock) to validate migration integrity and catch regression bugs early.
• Conducted performance benchmarking pre- and post-migration, achieving 25% response time improvement.
• Configured testing tools to support DB migration from Sybase to Oracle, ensuring data consistency and schema alignment across environments.

• Led implementation of enterprise Data Warehouse using Oracle CDC, enabling non-intrusive real-time replication from OLTP systems.
• Utilized Oracle CDC with Auto Log Archive Mode to migrate live data to the warehouse via PL/SQL and Oracle AQ, preserving OLTP performance while enabling analytics.
• Defined business-driven data mappings to ensure audit traceability and compliance reporting.
• Enabled targeted business insights by capturing change events, directly supporting operational and strategic decisions.
• Engineered PL/SQL auto-generation framework using Perl, shell, XML, and Java, accelerating large-scale data distribution and reducing manual effort by 70%.
• Delivered Sybase-to-Oracle migration of 9.8M+ records using in-house tools (Perl, Java, PL/SQL), avoiding third-party ETL cost and ensuring full control.
• Developed custom ETL scripts in Perl/Java/PLSQL for efficient data transfer and transformation across platforms.
• Completed migration 11 months ahead of schedule, demonstrating efficiency and planning precision.
• Built and deployed enterprise-grade server-side components for the Data Service Provider group to support robust internal data services.
• Developed Core Java APIs and automated WebLogic deployments via Maven and JUnit, enabling CI/CD for backend data services.
• Built JSP web application as a UDS client, enabling secure document upload/download capabilities for 3+ internal programs.
• Designed data-driven architecture supporting 3 divisions, allowing configurable expansion without code changes.
• Developed external-facing web portal for client issue tracking, integrating with internal JIRA system for seamless triage and resolution.
•Implemented middleware layer using Oracle Objects to enforce dynamic business rules and ensure DB-level integrity.
• Applied OOD principles to PL/SQL design for efficient and scalable application-DBMS interaction.