Satheesh Manoharan

Project: ORBIT
Feb 2024 - Present
Technologies: Apache Superset, Dremio, ClickHouse, dbt, PySpark, Databricks

Description:
ORBIT is a self-service analytics tool based on Apache Superset, allowing users to create charts and dashboards based on their KPIs and requirements.

Roles and Responsibilities:
Created datasets using PySpark, integrating them into Dremio as views via dbt.
Developed dashboards for non-technical teams based on their KPIs.
Enabled user self-service analytics and metric engineering.
Collaborated with stakeholders to ensure tools meet business needs.

Project : eCom Dashboard & Apex Analytics
April 2023 - Present
Technologies: React-based Frontend, ClickHouse, Kubernetes, PySpark, Databricks, Apache Superset

Description:
eCom Dashboard: A unified platform for monitoring key performance indicators (KPIs) and business metrics related to bookings and various sub-products, providing insights into different trends and performance metrics.
Apex Analytics: An Apache Superset-based analytics tool used to analyze traffic patterns on Maersk.com, track user journeys, evaluate the performance of specific pages and products, and assess KPIs defined by product owners.

Roles and Responsibilities:
Monitored and enhanced in-house eCommerce analytics tools used by 4,000+ users.
Gathered, cleaned, and transformed data from multiple sources.
Created and maintained dashboards and reports using Apache Superset and a custom React-based application.
Analysed datasets to identify trends, patterns, and actionable insights.
Conducted statistical analysis to support business decisions.
Developed data visualizations and presented findings to stakeholders.

Project: Test Data Services
May 2022 - April 2023
Client: Hamburg Süd (Owned by Maersk)
Technologies: Oracle SQL, PL/SQL, Jenkins, TDM

Description:
Managed the Test Data Management (TDM) process, including providing Oracle data dumps and anonymizing production data for testing environments.

Roles and Responsibilities:
Produced test bed dumps using artificial and anonymized data, automating processes for efficiency.
Created ad hoc queries and optimized data execution procedures.
Collaborated with testing teams to improve test stages and visualizations.
Monitored and fixed issues in production anonymization data dumps.
Ensured test data security and compliance with privacy policies.
Developed and managed automated processes for test data generation.

Project: OPT IMP PCR & IR – DISTRIBUTED
June 2019 - July 2021
Client: Discover Financial Services
Technologies: IBM Optim Infosphere, Oracle SQL, PL/SQL, Unix Shell Scripting

Description:
Worked with IBM Optim Infosphere to extract production data and apply advanced encryption and masking techniques for data protection.

Roles and Responsibilities:
Reviewed and analyzed over 2,000 Oracle tables for privacy protection.
Developed and implemented data extraction and masking requests using IBM Optim Infosphere.
Created Unix shell scripts for handling sensitive columns and logging processes.
Automated and scheduled data management processes using Autosys.
Collaborated with cross-functional teams to ensure data privacy and project success.

Project: HOME GROWN PCR – DISTRIBUTED (BAU)
December 2018 - May 2019
Client: Discover Financial Services
Technologies: Oracle SQL, PL/SQL, Unix Shell Scripting

Description:
Supported data management operations for banking and loan products, ensuring PII desensitization and data subset creation for testing environments.

Roles and Responsibilities:
Conducted routine data scrubbing and desensitization.
Automated PCR processes and scheduled tasks in Autosys.
Provided support during batch runs and shared test data with application teams.

Project: SPACE CONTROL ALLOCATION
August 2015 - November 2018
Client: Yang Ming Marine Transport Corp.
Technologies: SQL, PL/SQL, Forms6i, 11g, OBIEE 11g, OBIEE Admin Tool

Description:
Simplified container space allocation for shipping vessels, integrating dynamic data and OBIEE for predictive analysis.

Roles and Responsibilities:
Coded, tested, and enhanced application functionalities.
Prepared technical documentation and analyzed customer requirements.
Developed OBIEE repositories, dashboards, and reports.

Project: OPERATIONAL ACTIVITY (OA)
December 2016 - January 2018
Client: Yang Ming Marine Transport Corp.
Technologies: PL/SQL, Reports 11g, OBIEE 11g, OBIEE Admin Tool

Description:
Developed a tracking system for containers based on loading and discharge locations, integrating EDI file transfers for customs requirements.

Roles and Responsibilities:
Created PL/SQL stored procedures and contributed to OBIEE development.
Developed dashboards and analysis reports for container tracking.

Project: CUSTOMER RELATIONSHIP MANAGEMENT (CRM)
December 2017 - November 2018
Client: Yang Ming Marine Transport Corp.
Technologies: PL/SQL, Reports 11g, OBIEE 11g, OBIEE Admin Tool

Description:
Managed a CRM system to track business growth, customer interactions, and meeting schedules, including automatic notifications.

Roles and Responsibilities:
Created PL/SQL stored procedures and weekly summary reports.
Supported CRM system functionality and OBIEE reporting.

Project: AGENT FREIGHT FORWARDING SYSTEM

June 2014 - November 2016
Client: Yang Ming Marine Transport Corp.
Technologies: Oracle SQL, PL/SQL, Oracle Forms & Reports

Description:
Developed and maintained the Agent Freight Forwarding System (AFSYS+), a comprehensive platform for shipping-related functions.

Roles and Responsibilities:
Created forms, reports, PL/SQL procedures, and functions.
Designed functional and technical documents based on requirements.
Resolved client defects and interacted with clients for changes.
Developed reusable objects and database procedures.