Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Vikram Aditya

New York,NY

Summary

Dynamic data engineering leader with extensive experience at Jefferies, specializing in ETL processes and cloud computing. Proven track record in optimizing data pipelines and enhancing performance, while mentoring teams to achieve strategic goals. Adept in Snowflake and stakeholder collaboration, driving impactful data solutions that elevate business outcomes.

Overview

17
17
years of professional experience
1
1
Certification

Work History

Leader Data Engineer Consultant

Jefferies
New York, NY
12.2024 - Current
  • Leading the design, development, and implementation of data pipelines, data warehouses, and other data solutions.
  • Develop efficient and scalable data pipelines for extracting, transforming, and loading (ETL) data from various sources including on-prem database oracle, QVDs to css conversion, coping to S3 buckets in AWS & then loading to snowflake using python scripts/ AWS CLI
  • Create and maintain data warehouses, databases, schemas, tables, views, UDFs, storage integration, internal and external stages, Snowpipe, and Snowflake CLI to store and manage large volumes of data in the cloud.
  • Identify and implement solutions to improve data processing performance, scalability, and reliability.
  • Used a Linux server to automate the jobs via TWS for this data flow/data pipeline.
  • Offer technical expertise and guidance to junior engineers on data engineering best practices and tools.
  • Work with data scientists, business analysts, and other stakeholders to understand data requirements, and deliver solutions.
  • Used AWS QuickSIght to build intuitive Dashboards for the Credit Risk & Market Risk Stakeholders for calculating VaR, PnL Vectors for 1D/10D 95/99 for different Hierarchy including Financial/ Business Hierarchy
  • Used Qlik Cloud for doing POC for some uses cases to calculate Limits/ Delta at different sectors to clauclte the difference between Prior 1D/ 5D

Lead Data Engineer Consultant

Wawa
Philadelphia, PA
07.2024 - 12.2024
  • Improved performance of the existing Wawa Weekly Rewards Dashboard.
  • Created an Iterable dashboard pulling data out of Snowflake for the target email, blast email campaign, CTR, total volume of emails sent, and total clicks metrics.
  • Built views in Snowflake for summary and detailed data aggregated by label, campaign, and month.
  • Designed robust data pipelines to enhance data flow efficiency.
  • Developed automated workflows to streamline data processing tasks.
    Implemented CI/CD practices to improve deployment frequency and reliability.
    Optimized existing workflows for better performance and scalability.
  • Worked on the query optimization of existing queries used in the dashboard that have performance issues.
  • Involved in requirement gathering, building a data model of a new dashboard related to Google Analytics data concerning tobacco, and bringing data into the Data Vault.
  • Collected historical data and third-party data from different data sources with Big Data tools for the Iterable Dashboard to calculate Email Sent, Email Blast, Email Triggered, Offer Click, Email Click, CTR, Total Volume, and Journeys.
  • Conducted data exploratory analysis to identify where the P&C insurer has been successful in writing new business in the past.
  • Worked on data cleaning and ensured data quality, consistency, and integrity using Pandas and NumPy.
  • Worked on outlier identification with box plots, means, and clustering using Pandas and NumPy.
  • Participated in feature engineering, such as feature intersection generation, feature normalization, and label encoding with Scikit-learn preprocessing.
  • Performed univariate and multivariate analysis on the data to identify any underlying patterns in the data and associations between the variables.
  • Built the machine learning model, including SVM, random forest, and XGBoost, to score and identify the potential new business case with Python Scikit-learn.
  • Utilized F-Score, Precision, Recall, and A/B testing

Project Lead Tableau Developer/Admin Consultan

Prudential Financial
Newark, NJ
03.2023 - 05.2024
  • Created Automation pipeline using REST API curl command for Metrics Insight Application to pass parameter/arguments after weekly sales process get refreshed
  • Used REST API for automation of Tableau Prep Workflow to Tableau Server
  • Completed training in Power BI & converted existing Ramm Athena Reports from Tableau to Power BI Dashboard
  • Solved critical enhancements to ILI Licensing Dashboard
  • Build new Term Conversion Dashboard, Third Party Bob data sources with security alignment using Power BI, with Data Sources connected to Azure
  • Created/Maintained GIT repository using Source Tree/Bit Bucket for all the new components under SAS/Hadoop/Tableau/Autosys deployments through Jenkins
  • Involved in Tableau Server & hadoop server Upgrade for the maintenance in DEV/QA/DR/PROD
  • Created new LDAP groups requests for new Data Sources to be published under different project folders
  • Used Tectia for all SAS/Hadoop testing/deploying components directly to DEV using service account
  • Built 6 Historical TDE for Weekly sales for 2023, validated data, updated sql for historical_tables
  • Updated Calendar Autosys events for 2023 & 2024 to ensure all jobs run with no failures
  • Resolved ongoing issues with Saleslink workbook by splitting them into separate workbook
  • This project is about Leading & Managing Wealth Management Data Visualization Team which involved building new automated tableau dashboards & data pipeline workflows for CAC (Client Advisory Centre), RISK Exposure & MSVA Campaign users by providing one stop shop to the business for making their intuitive decisions
  • Used advanced chart visualizations in Tableau-such as dual axis, box plots, bullet graphs, treemaps, bubble charts, and waterfall charts-to solve complex problems and to create interactive dashboards and visualizations
  • Served as a Tableau Liaison to mentor our team on all Tableau best-practices while supporting other developers specifically in data-source identification
  • Collect, review, and document business needs and requirements with stakeholders and define business case, user documentation, process flows, coordinate design reviews, and serve as a liaison between technology and business units within CAC, MSVA & Wealth Management Risk
  • Implemented ETL process in Alteryx to extract data from multiple sources (Tera data, Excel, CSV) & schedule workflows
  • Managed end to end complex data migration, conversion, and data modeling using Altered and created output files as Tableau TDE/Hyper
  • Created JIRA request related to user requirements by converting them to stories
  • Designed Data Model layout for KPI table & final Summary Segment & Household table based on the visualization requirement
  • Built Trading Cost Dashboard which helps MSWM to mitigate the risk of regulatory issues and/or client litigations
  • Delivered FA Discretionary Dashboard which will help Risk Officers to compare FA within Complex under Region & determine their National Rank calculated based on Risk Model
  • Delivered E-Trade Account Migrated Tracking Dashboard
  • Built AWL Dashboard to track Primary Secondary work locations
  • Built Snowflake Migration Dashboard to Track Tables Migrated to Snowflake PROD by various categories
  • Built Call Agent Dashboard, QA Scorecard, Client Engagement Dashboard, Client Activity Dashboard, CAC Dashboard for analyzing Key Metrics
  • Integrated Tableau Dashboard into 3D Portal & navigating it to Web Report
  • Implemented Data Level Security, Production support

Sr. Tableau Data Visualization Lead/Solution Architect Consultant

Morgan Stanley
NYC, NY
04.2018 - 03.2023
  • Established key business goals and priorities with team, clients or project management sponsors
  • Leveraged business performance and development techniques to assist organizations
  • Used technologies to revitalize lagging business processes
  • Work directly with the system end-users, MIS Data Analysts, lead Architects and Program Manager to translate complex information requirements into effective visualization dashboard
  • Built IHC Credit Risk dashboard, Market Risk dashboard, LVE Dashboard, CIO Cloud Dashboard, T+1 Dashboard, CCAR Dashboard, Risk Based Profit & Loss dashboard for executives
  • Integrated Tableau Dashboard into Web Portal & navigating it to OBIEE Report
  • Migrated LVE Project using Qlik Sense as POC
  • Executed Ctrl M Script for scheduling the Tableau Extract Refresh based on batch script
  • Experience as Site Admin for managing & Implementing Data Level security at different sites, projects, folders, data sources over the Tableau Server
  • Utilized Tableau Desktop for blending databases and creating different interactive views and dashboards
  • Worked on BRD, FRD, New Jira request, QC in HP ALM, CR & defects
  • Liaison with offshore team as per requirement on daily basis
  • Built MIS Executive mobile dashboard using Tableau Mobile
  • Worked on CTQ & Cascading metrics for Sales & Customer Operations, Repo, Customer Servicing & Sales team
  • New Integrated scorecard built using tableau evaluating QA / Compliance Scorecard & Risk Alerts for entire LM focusing on Repo team
  • Worked on Daily Huddle, Associate 10-10, UM Matrix, QA View, Inventory Management & Summary Views having action & URL filters pulling out daily & monthly Metrics with the threshold values roll up to different levels
  • Worked on blending of geo-data with maps for Pre Approval View with drilling down from Nation to Dealer Hierarchy for Sales Originations team
  • Reviewed, investigated and adjust Mizuho Customer Relationships in their Master Data Management (MDM) solution
  • Implemented monitoring mechanisms to track the quality and performance of master data over time
  • Generate and distribute reports and dashboards that provide insights into data quality and compliance
  • Documented and maintained Metric Intake template for different process metrics & categorized them under Quality, Customer & Economics scorecards
  • Delivered SAS scripts for these CTQ metrics & data sets to off-shore team
  • Identified data issues and provided recommendations for resolution to ensure optimal performance
  • Worked with EDS team to pull the data out of CORE staging to CORE for few Data Warehouse Dependencies
  • This project is about the PMATT application, PMATT is a PPM Tool for Principal-Network Planning and Engineering which gathers all AT&T -- NTD, NCD-BAU, RCD-BAU & OAA projects categorized based on technology type as wireless, Uverse, Mobility are created and updated
  • Created Technical Design Document from the functional specification documents
  • Generated dashboards to compare the expected weekly project heath vs projected project heath used dual axis for comparison
  • Trained Business Customers on tableau software

Lead Data Visualization Consultant

Credit Suisse
NYC
10.2015 - 03.2018
  • Established key business goals and priorities in collaboration with teams, clients, and project sponsors.
  • Leveraged business performance techniques to drive organizational development initiatives.
  • Revitalized underperforming business processes through strategic technology utilization.
  • Collaborated with end-users, data analysts, architects, and program managers to create effective visualization dashboards.
  • Analyzed data using Teradata SQL for comprehensive management, analysis, and reporting.
  • Developed multiple executive dashboards, including IHC Credit Risk, Market Risk, and T+1 dashboards.
  • Integrated Tableau dashboards into web portals, enhancing accessibility of OBIEE reports.
  • Executed Ctrl M scripts to automate Tableau extract refresh scheduling.

Senior Business Intelligence Consultant

Capital One
Plano, TX
10.2013 - 09.2015
  • Utilized Tableau Desktop to blend databases and create interactive views and dashboards.
  • Developed business requirement documents (BRD), functional requirement documents (FRD), and managed Jira requests.
  • Collaborated daily with offshore teams to address project needs and requirements.
  • Created a mobile dashboard for MIS Executive using Tableau Mobile for enhanced accessibility.
  • Analyzed critical to quality (CTQ) metrics for Sales and Customer Operations teams.
  • Designed an integrated scorecard using Tableau to evaluate QA, compliance, and risk alerts, focusing on Repo team.
  • Executed various reporting tools including Daily Huddle, Associate 10-10, and Inventory Management to track key performance metrics.
  • Integrated PostgreSQL databases with applications via APIs to streamline data access.

Senior Business Intelligence Consultant

AT&T Mobility
Redmond, WA
02.2013 - 09.2013
  • Performed Data Analysis for report requirements to test for DWH dependency or any Data Discrepancy
  • Efficiently mapped business requirements and processes to technical solutions
  • Communicated with Business Analysts, JSP and Java Developers, DBAs, Functional Users, Managers and Executives for reviewing Business Requirements
  • Tested Business Objects reports for data validation and compared results with TOAD for Oracle 11g
  • Scheduled reports to Share Point WebSite for Business Users and Owners
  • Tested all the reports that are migrated and analyzed the performance of the BO XIR3.6
  • Use of BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies
  • Created Business Objects Reports - Drill-down, cross-tab, master-detail reports and created queries to extract data for multi-dimensional analysis
  • Created filters, user objects, variables, free hand SQL and stored procedures
  • Designed universes, Classes and Objects using Business Objects Designer
  • Generated Summary of operations, project schedule reports using cross tab & slice and dice, Alerts & Multiple Data providers
  • Resolved loops using aliases and contexts by checking the integrity and also developed user objects
  • Created a logical representation of the data model in the Designer module
  • Created classes, objects which represent the database structures that are used by Business Objects and Web Intelligence users to run queries and to create reports
  • This project is all about implementation of End-to-End BO Solutions for Small Business lending
  • Reviewed Business Requirement documents and created Technical Specification documents for Universe Development and Reporting Solutions
  • Involved in performance tuning & reduced the coding in the process of building the Universes
  • Created Adhoc reports, Modified reports, crystal reports, cross tab reports accessible through Infoview
  • Designed, developed, maintained and tested universes for supporting ad hoc queries and canned reports
  • Created simple Xcelsius dashboards on defects fixes for the estimate and efforts
  • Create various Reports by pulling the OLAP data from Data Warehouse like Sales of Products, by Region wise, Reports Based on time like Year, Quarter, Month, Week, Geographic reports and Comparative reports
  • To patterned advertisement effectiveness by these reports further action are planned by their management to improve in lacking areas by conducting various events and meetings
  • Created/Deployed/Scheduled reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @functions, Cross tab, Chart, Master/Detail, Formulas as per the requirement of the end-user
  • Used Designer Module to implement Universe, Joined the Tables, created Prompts and queries, parsed the Objects, applied Contexts and Aliases to remove cyclic dependencies
  • Developed universes, WebI and Desktop reports from the Oracle database

Business Intelligence Intern

JWH Global Data Systems
East Brunswick, NJ
01.2012 - 12.2012
  • This project is all about the implementation of end-to-end BO solutions for small business lending in BOA.
  • Reviewed Business Requirement documents and created Technical Specification documents for Universe Development and Reporting Solutions.
  • Involved in performance tuning and reduced the coding in the process of building the Universes.
  • Created ad hoc reports, modified reports, Crystal reports, and cross-tab reports accessible through InfoView.
  • Designed, developed, maintained, and tested universes for supporting ad hoc queries and canned reports.
  • Created simple Xcelsius dashboards on defect fixes for the estimates and efforts.
  • Create various reports by pulling the OLAP data from the data warehouse, such as sales of products by region, reports based on time like year, quarter, month, week, geographic reports, and comparative reports.
  • Leveraged the functionalities of multiple data providers, Master/Detail, cross-tab, and charts while creating Webi reports.

Business Intelligence Intern

VForce Infotech
Iselin, NJ
11.2010 - 12.2011
  • Evaluated current BI solutions and identified areas where improvements can be made.
  • Performed ad-hoc analyses on complex datasets to answer specific questions from management teams.
  • Gathered data from multiple sources and consolidated it into a single repository for easier access and analysis.
  • Educated users on correct interpretation of financial, statistical and qualitative data.

BUSINESS OBJECTS DEVELOPER/ANALYST

i28 technologies India Pvt Ltd
Thane, India
04.2008 - 08.2010
  • Install and configure Web Intelligence and Broadcast Agent server based on iterative performance statistics
  • Implemented Security Features of Business Objects like row level, object level and report level to make the data secure
  • Used Report Conversion Tool to convert Desktop Intelligence reports to Web Intelligence reports

Education

Master of Science (M.S.) - Computer Science

New Jersey Institute of Technology
Newark, NJ
08.2012

Bachelor of Science (B.S.) - Electronics & Commuincation

University of Rajasthan
Jaipur, India
07.2008

Skills

  • Tableau Desktop
  • Tableau Server
  • Tableau Prep
  • Tableau Mobile
  • Qlik Sense
  • QMC
  • Business Objects
  • Universe Designer
  • Crystal Reports
  • Google Analytics
  • Datawatch
  • Power BI
  • AI & ML
  • Alteryx
  • Panda
  • Numpy
  • MS Access
  • MS SQL Server 2005/2008/R2
  • Oracle 9i/10g/11g
  • Teradata
  • Snowflake
  • Hadoop
  • Saleslink
  • DataBricks
  • AWS
  • Azure
  • Postgres
  • SAS
  • Excel
  • XML
  • UML
  • MDX
  • SSIS
  • ETL
  • HTML
  • SSAS
  • SSRS
  • JENKINS
  • AUTOSYS
  • SOURCE TREE
  • GIT
  • Informatica
  • REST API
  • Ctrl M
  • Putty
  • Tectia
  • Leadership Experience
  • Team Management
  • Project Management
  • Product Owner Experience
  • Strategic Planning
  • Time Management
  • Data pipeline development
  • Data warehousing
  • ETL processes
  • Cloud computing
  • Data visualization
  • Performance optimization
  • Dashboard creation
  • Stakeholder collaboration
  • Machine learning
  • Data quality assurance
  • Scrum methodologies
  • Technical documentation
  • Data analysis
  • Team mentoring
  • Resource allocation
  • Team leadership
  • Risk management skills
  • Documentation and reporting
  • Vendor management
  • Requirements analysis
  • Collaborative mindset
  • Budget control
  • Excellent communication
  • Analytical skills
  • Employee coaching
  • Interpersonal skills
  • Professional demeanor
  • Business case development
  • Risk management
  • Time management abilities
  • Project planning
  • Cost control
  • Effective project management
  • Team building
  • Cross-functional team management
  • Leadership skills
  • Multi-stakeholder asset management
  • Agile methodology
  • Team collaboration
  • AWS services
  • Automation scripts
  • Architecture planning
  • GitHub collaboration
  • Python programming

Certification

  • Tableau Desktop
  • AWS
  • Snowflake
  • Power BI
  • Azure

Timeline

Leader Data Engineer Consultant

Jefferies
12.2024 - Current

Lead Data Engineer Consultant

Wawa
07.2024 - 12.2024

Project Lead Tableau Developer/Admin Consultan

Prudential Financial
03.2023 - 05.2024

Sr. Tableau Data Visualization Lead/Solution Architect Consultant

Morgan Stanley
04.2018 - 03.2023

Lead Data Visualization Consultant

Credit Suisse
10.2015 - 03.2018

Senior Business Intelligence Consultant

Capital One
10.2013 - 09.2015

Senior Business Intelligence Consultant

AT&T Mobility
02.2013 - 09.2013

Business Intelligence Intern

JWH Global Data Systems
01.2012 - 12.2012

Business Intelligence Intern

VForce Infotech
11.2010 - 12.2011

BUSINESS OBJECTS DEVELOPER/ANALYST

i28 technologies India Pvt Ltd
04.2008 - 08.2010

Master of Science (M.S.) - Computer Science

New Jersey Institute of Technology

Bachelor of Science (B.S.) - Electronics & Commuincation

University of Rajasthan

Similar Profiles

CREATE PROFILE
Vikram Aditya