Business Intelligence Etl Developer

Pranav Sangameswaran

https://www.linkedin.com/in/pranav-sangameswaran-2364a818a/ 636-***-****

SUMMARY

ETL Developer with three years of practical experience working on the Business Intelligence (BI) Framework team at Spectrum who is meticulous. competent in developing, constructing, and refining ETL pipelines to support analytics and data warehousing systems. Demonstrated capacity to collaborate across divisions to provide dependable, expandable data integrations. strong knowledge of enterprise BI platforms and data governance best practices, along with proficiency in SQL, data modeling, and performance tuning.

LANGUAGES TOOLS

Python, Shell, SQL, Javascript, HTML Oracle, Teradata, Amazon Redshift, ERWIN Data Modeler EXPERIENCE

BI-IF — An Overhall of Existing Business Intelligence Integrated Framework

● Added Framework logging to all scripts

● Updated and maintained all documentation

● Oversaw a full conversion of all scripts from Shell to Python Migr8 — Spectrum BI’s Database Migration Project

● This was a full and total database migration for all BI from Teradata to Redshift in less than 8 months

● I helped monitor the standard of the table conversion

● I owned the entire data copy process during both testing and final implementation ETL Developer I — Charter Communications - Spectrum July 2021 - Present

● Responsible for developing new Framework scripts and maintaining existing scripts

● Created scripts specifically for data analysis which automatically generated daily email reports

● Supported bug-fixes and error resolution for PROD environment in a timely fashion

● Created a ticketing system for my team through Atlassian’s Chalk using HTML to make buttons

● Created a script to automate a vacuuming process in our Redshift databases

● Worked outside my role as a data modeler in support of the RDM team

Maintained the XDW NSM naming standard for the tab

● I was an active member of the BI Social Committee and helped plan and organize company events and activities

I was solely responsible for organizing and overseeing a table tennis tournament EDUCATION

Saint Louis University, Bachelor’s Degree, International Business

Contact this candidate