Venkata Jayandra Kumar Lade

• Joined iCapital through Acquisition in August 2022
• Delivered comprehensive reports highlighting key trends, patterns, anomalies, presenting findings to senior management for informed decision-making purposes.
• Led the biggest effort to combine all the different activity data produced through iCapital-acquired platforms and built one huge dashboard to show total Active users, Year-to-date active, User population, and many others. So that the executive team can track company KPIs
• Automated the coupa Invoice being sent to client using snowflake and Tableau which helped finance team to move away from excel. Which reduced 90% of manual intervention and also data error prone now.
• Working with different stakeholders to know about the products to gather requirements to provide data analysis and dashboard
• Working with platform specialists team to support their marketing campaigns by pushing the appropriate data to Salesforce and also build a dashboard to track the KPI for different campaigns which led to increased activity across the platform.
• Partnered with Data Science team and targeted right segment of customers with marketing email resulted in increase of 5% Monthly Active Users to platform.
• Build a tableau dashboard to generate PDF reports that can be shared directly with clients to show their financial advisor usage across the SIMON platform.
• Build / Restructure data pipelines to pull the data using DBT.

Tools : SQL, Snowflake, DBT, Tableau, Python

Team Name : Enterprise Digital Marketing

(Jan 2020 - Sep 2021)

• Led 2020 Marketing efforts which drove 750K customers to provision their CapitalOne card to PayPal
• Led 2020 Marketing effort resulting in 100K registrations for product called EWA and drove around 1Billion Spend using EWA
• Automated the process of customer segmentation from end to end, which reduces our campaigns execution time from days to hours.
• Supported all Enterprise Digital product and feature marketing campaigns including building the customer segmentation strategy
• Implemented A/B testing as part of the experimentation
• Developed and published data visualization dashboards for all digital marketing campaigns
• These tableau dashboards will pull together results across all owned channels (email, harmony, home page) using the data from snowflake databases and external 3rd party data aggregators (Kochava)

Team Name : Digital Enterprise Customer Analytics

(Apr 2019 - Jan 2020)

• Responsible for fulfilling the ad-hoc request based on the business requirements
• Responsible for validating a Data Science project output and recommending necessary steps like feature selection to make the model better
• Build/developed SQL Scripts on various platforms like Snowflake and Databricks (Pyspark SQL Scripts) to automate the tasks which are used for the teams day-to-day work and reporting
• Developed Python/Databricks scripts for loading the data into snowflake either from S3buckets or from Local space
• Used GitHub for maintaining/documenting the scripts on which we worked, and the same scripts were used in automation
• Developed/Maintained dashboards in tool called SuperSet, which has been greater help to our Product Owners.

Team Name : LiftNShift Team

(Sep 2018 - Apr 2019)

• This part of Ascent LiftNShift team performing migration of Data from Teradata to Snowflake
• Responsible for the validating the Data quality, descriptive statistics and checksum of data migrated to Snowflake
• Developed Python scripts for automating the daily validations on migrated data. which helped building Baymax (Tableau Dashboard) - daily health metrics which tells about the stability of migrated data
• Created Metadata and registered the same using Nebula
• Responsible for handling/maintain Process Health Tracker ( Tableau Dashboard). Tracker became a central platform to know about the health of tables and process. And also, to know about the team and their owners.

Tools : Sql, Snowflake, Databricks, Python, Tableau, Superset