Harshith Mysore Venkatesh

Client Name: One Trust

• Worked on setting up Airflow standards and best practices for the orchestration
• Setting up data marts for marketing; developing the respective dimensions/facts and respective aggregated data models as per business needs using DBT/Airflow/Snowflake
• Extensively worked on Adobe Analytics data; transferring the data from s3 to snowflake and then respective aggregated data models and validating the same against adobe analytics report suite, developed full load strategies via Airflow
• Involved with SFDC and Marketo data and tailoring the same as per reporting needs

Client Name: Salesforce, Inc. ( Slack Technologies )

• Leading Sales team offshore and ensuring deliverables
• Spearheaded the migration project post acquisition by Salesforce ; worked on planning, designing and execution of channeling data to data warehouse from new business systems
• Designed and created ETL code installations in Matillion, aiding in transitions from Hive to Snowflake.
• Optimized broken and inefficient assets through effectively troubleshooting technical processes and workflows.
• Interpreted data models for conversion into ETL diagrams and code.
• Collaborated with business intelligence staff at customer facilities to produce customised ETL solutions for specific goals.
• Worked on gathering data from different systems such as Salesforce , People.AI via API and creating a data lake for the same.
• Worked on bridging financial data between Salesforce and Workday.
• Designed complex queries for Aggregate tables to aid business reporting for key Sales and Financial metrics.
• Supporting Quarter / Year end financial queries posted by business users / analysts

Client Name: Orange-Belgium

• Worked closely with customers to efficiently resolve issues.
• Provided timely and pivotal support in handling the day to day business challenges of the client.
• SPOC for the unix file transfer application: Supported the existing file transfer flows and created many file transfer flows via unix shell script between the client and it's partners, hence providing smooth file exchange.
• Experience on Abinitio : Worked on day to day business handling of the client, which compromised of a daily DWH chain: ETL processing of disparate data sources(CRM, Billing etc..) and loading into Data Warehouse(Netezza DB) for business reporting.
• Experience on MSBI : provided support for the ETL processing of routine Call center data, Shop sales, Billing, USSD (SSIS & SSAS) and ticket data and played a part in keeping the business reporting afloat.
• Automated most of manual task by equipping myself with languages such as power shell, Unix Shell Script and Ui Path. Major automations involving such as closing of PeopleSoft tickets which saved as much as 3 hours of manual task per day
• Critical file transfer flows of file transfer application were monitored via automated script written in unix shell scripting for proactive monitoring.
• Has experience working on schedulers such as TNG and Dollar Universe($U).