Summary
Overview
Work History
Education
Skills
Timeline
Generic

Rohit Nagaram Chandrashekhar

New York,USA

Summary

Data steward with 8+ years of experience in ETL, Analysis, Ingestion, leading cross-functional BI teams, data privacy, establishing enterprise-wide data governance standards and delivering scalable, version-controlled BI solutions with strong client engagement skills and providing deep insights administering server and security.

Overview

8
8
years of professional experience

Work History

Sr. Alteryx Developer

JP Morgan Chase & Co.
03.2024 - Current
  • Developed key reporting for FRB Integration Transition workstream dashboard, forecasts on incentive, salary estimates for the extensions of 6, 9, 12, 15, 21, 24 months and merged with WFA.
  • Created attributes using Pi(AWS) data and SAP pulls of LOBs for FRB expenses for Acquisition Related Policy ARP and Pillar Performance Reporting PPR firm wide via CCB admin.
  • Managed Financial Risks with Cost Estimates of contractors and vendors who are active and terminated timely in WFA, created reports, updated Cost centers automatically.
  • Built and maintained BI workflows and dashboards for cross functional teams with successful development and submission of External reporting and provided Finance actionable insights for strategic decision-making.
  • Mapped FR 700+ vendors, 900 + contractors, 3358 employees to JPMC LOB and functions.

Lead Alteryx Developer/Admin/BI Specialist/SME

Ford Motors
01.2023 - 02.2024
  • Led the team and submitted collections of Alteryx workflows to automate the process of onboarding Qlikview & Qlik Sense dashboards with the Certified Log Provider application.
  • Represented GDIA - Global Data Insights & Analytics team enabling the business to create timely, accurate analytics and visualizations to drive decisions and automate processes in Alteryx, QlikView, and Qlik Sense tools in regard to solution enablement and data governance.
  • Supported CLP Office hours in resolving issues and impediments in Alteryx of different teams of Ford across the globe and used Alteryx Scheduler to schedule jobs and handled Deployment of multiple teams across Ford.

Sr. Alteryx/BI Developer

Blue Cross Blue Shield
02.2022 - 01.2023
  • Built HealthSparq module of Wellmark by architecting the data modules of Provider Finder, Cost Estimation, Site Usage and System Performance.
  • Developed solutions for the Source to Target Data Repository from New Data Lake, using embedded SQL queries and API calls for the Eligibility/Enrollment and Benefits, Radiology and Imaging Services.
  • Dealt with fixing data inconsistency of Google Analytics and Data Studio for the live data and extracted data, overcoming inconsistent column formats, and replicating data for visualization.

Sr. Alteryx Developer

Transamerica
01.2021 - 01.2022
  • Managed development of 12 dashboards of Vendor Management, Asset Transfer Accounting, IFRS). Reduced ETL error frequency by 90% and big data query spillage on Impala servers from 1+ TB to
  • Optimized and reduced query runtime from 4+ hours to

Data Privacy Specialist

EA Sports (Electronic Arts)
07.2020 - 01.2021
  • Data Privacy Team of EA, built the data packs based on GDPR and other global privacy laws and developed dashboards for the SARs received from all over the world and reported to CPO and EVP every week.
  • Worked with legal advisors of EA around the world to ensure company policies are met and send out the data packs to the players and customers as an EA Data Protection Officer.

Alteryx Developer

Transamerica
09.2017 - 07.2020
  • Developed solutions for Global Reinsurance and Retirement Plan P & L owning FAR and Pegasys, addressing data issues and conducting trend analysis for improved data quality and delivering with approvals.
  • Tested, reviewed, documented and versioned code before Deployment and maintained in locked environments for Audit Inspections, CAB Approvals, SOX/SOC approvals and Gatekeeper reviews.

Education

Master of Science - Computer Science

University of Illinois

Skills

  • ETL
  • Data Warehousing
  • SQL, Oracle, Hive, Impala
  • Big Data
  • Cloud (Azure, AWS, GCP)
  • Python
  • Reporting tools (Tableau, Power BI, Qlik)
  • API integration
  • SAP Business Objects
  • Google Analytics
  • Amazon Redshift
  • Data Studio
  • QlikSense
  • R
  • AQT
  • One Jira
  • MongoDB
  • SharePoint
  • Programming

Timeline

Sr. Alteryx Developer

JP Morgan Chase & Co.
03.2024 - Current

Lead Alteryx Developer/Admin/BI Specialist/SME

Ford Motors
01.2023 - 02.2024

Sr. Alteryx/BI Developer

Blue Cross Blue Shield
02.2022 - 01.2023

Sr. Alteryx Developer

Transamerica
01.2021 - 01.2022

Data Privacy Specialist

EA Sports (Electronic Arts)
07.2020 - 01.2021

Alteryx Developer

Transamerica
09.2017 - 07.2020

Master of Science - Computer Science

University of Illinois
Rohit Nagaram Chandrashekhar