Apu Kumar Ghose

Minimized report generation time from 90 minutes to under 2 minutes by optimizing complex SQL queries. Designed and developed an interactive application replicating Power BI dashboard functionality for dynamic visualization of metrics. Built the application with Python, FastAPI, Retool, GCP, Tableau, Docker, Kubernetes for scalable, user-friendly interaction. Developed and integrated data pipelines to pull data from multiple sources (Google BigQuery, APIs) for real-time visualization. Implemented advanced analytics features (drill-down, custom filters, predictive modeling). Conducted user training and created documentation to support adoption. Optimized performance, reducing data load time by 85%, and migrated or repurposed Excel functions into new tools. Architecture designed for fintech/portfolio contexts; selected cloud services and ensured project feasibility. Also developed project management, portfolio and investor relations platforms using Go, Java, AWS, and Go-based real-time c

Architect/Design, develop, build, and deploy APIs using microservices architecture with Kafka, Java Spring Boot, Vue, Docker, and Kubernetes. Integrate GraphQL endpoints with frontend components. Design and optimize complex SQL queries for large datasets, ensuring efficient data retrieval and processing for reporting and analytics. Work with NoSQL databases to manage unstructured and semi-structured data for flexible storage. Participate in sprint planning, team development discussions, project plan reviews, code reviews, pair programming, system design, database design, cross-team collaboration, and mentoring. Lead engineering team to handle critical issues. Create proof-of-concepts. Technologies used include Python, Java Spring Boot, Redis, Cassandra, MySQL, Databricks, GitLab, AWS, shell scripts, GraphQL, Kafka, React, Vue, Docker, Kubernetes.

Developed Python-based API for accessing ShotGrid and integrating with tools used in the Animation and VFX department. Provided production support to resolve show-stopper issues. Resolved necessary package dependencies in Rez environment. Added new features in the in-house software. Used shell scripts for version control, package dependencies, database migrations, servers, static files, and virtual environments. Collaborated with cross-functional teams across the organization. Evaluated project constraints and proposed alternatives as needed. Technologies used: Python, REST, PostgreSQL, ShotGrid, Rez, gRPC, shell scripts.