Summary
Overview
Work History
Education
Skills
Accomplishments
Interests
Timeline
Generic

Kartikey Tripathi

Noida

Summary

To be a part of an organization where I can utilize my skills and abilities to spread the technical knowledge, with the scope of continuous learning.

Overview

6
6
years of professional experience

Work History

Senior Business Analyst

Ameriprise Financial
08.2024 - Current
  • As part of the Bank Analytics Product team, developed dashboards using Power BI for various products which included data modelling, writing DAX calculations and making efficient visualizations.
  • Delivered a Deep Dive Analytics project for all Bank products, which involved SQL querying on AWS Data Lake and SQL Server to analyze financial metrics, applied ML clustering algorithms such as K-means, Gaussian Mixture in Dataiku to identify key patterns and customer segments. Utilized marketing analytics to refine targeting strategies and optimize campaigns, driving measurable growth for the bank's products.
  • Delivered insights on customer behavior, resulting in strategic recommendations that directly contributed to increased client acquisition and bank growth.

Team Lead

Cognizant
10.2023 - 08.2024
  • Leading a team and overseeing the implementation of Adobe Campaign Classic and Power BI solutions for a leading American Bank client. Actively working on workflow designing, workflow optimization and planning of Campaigns.
  • Responsible for preparing the data and making it ready in a structured form using Oracle and PostgreSQL which involves rigorous querying involving usage of CTE, Window Functions etc.
  • Performed advanced data analysis via Power BI through features like DAX (Data Analysis Expressions) for creating complex calculations and measures. Created several customized dashboards to meet specific business requirements where users can monitor key metrics, drill down into details, and gain actionable insights at a glance.

Senior Product Consultant

Adobe
04.2020 - 09.2022
  • Created reports and dashboards using Power BI for various Adobe internal functions which involved cleansing of data using ETL(Power Query) and applications of Business Intelligence including extensive usage of Power BI DAX.
  • Performed Data Analytics using SQL on large datasets which involved rigorous advanced querying using JOINS, CTE's, Sub-Query etc.
  • Leading the design and implementation of Adobe Campaign (AC) that will deliver on our customer's business, functional, technical goals.
  • Working on implementation teams through the various stages of the project including : Assessment, Requirements, Design, Build, Testing, Reporting/Tracking, Training and Go- Live.


Analyst

EY
07.2019 - 04.2020
  • Worked on various data visualization and analytics tools, built dashboards on Power BI.Presented reports to clients using Business Intelligence and drove discussions ahead with proper management of resources at each stage.
  • Gained experience on using various ETL tools such as Power Query etc. for transforming/cleansing data.
  • Did POC for analytical tools such as VPhrase with Power BI, Python.

Education

B.Tech -

Jaypee Institute of Information Technology
Noida
06-2019

Intermediate -

St. Joseph's College
Prayagraj
05-2014

High School -

St. Joseph's College
Prayagraj
05-2012

Skills

  • SQL
  • AWS Data Lake
  • Power BI
  • Power BI - DAX
  • ETL - Power Query
  • Dataiku
  • MS - Excel
  • MS - PowerPoint
  • Advanced SQL
  • Marketing Analytics
  • Business Intelligence

Accomplishments

  • Was awarded the Ammy Gold Award at Ameriprise, for successfully delivering a project which contributed towards the Product's success.
  • Was awarded Adobe Spotlight Award for showcasing good problem solving skills.

Interests

  • International Relations
  • Hockey
  • Cricket
  • Quizzing

Timeline

Senior Business Analyst

Ameriprise Financial
08.2024 - Current

Team Lead

Cognizant
10.2023 - 08.2024

Senior Product Consultant

Adobe
04.2020 - 09.2022

Analyst

EY
07.2019 - 04.2020

B.Tech -

Jaypee Institute of Information Technology

Intermediate -

St. Joseph's College

High School -

St. Joseph's College

Similar Profiles

CREATE PROFILE
Kartikey Tripathi