Aditya Oak

Python and BI Developer II

Comcast•  August 2019 - Present

o Data mapping of dense Tableau reports to capture essential metadata about existing reports o Support documentation by extracting unmapped fields and attributes using XML files o Developed an automated process using Python 3.7 for data cleaning and fetching over 150 concise datasets o Worked extensively with regular expressions and xml files to capture data from a SQL query o Leveraged ODBC connection to perform data manipulation of SQL databases and tables

Programmer Analyst

Acme Manufacturing Company Inc.•  January 2019 - July 2019

Technologies: Python, MS SQL (SSMS), Tableau (Desktop and Server), JavaScript, Pivot Tables, VLOOKUP’s, Pick Basic Duties: o Handle programming bug fixes and feature requests from stakeholders via a ticketed system. o Debug up to 1400 lines of code consisting of imports, reads, declarations, displays and writes o Develop complex SQL queries (joins, subqueries) that run custom Tableau reports for Sr. Mgmt. o Design UI for screens and menus pertaining to order entry, inventory, production and accounting o Creating calculated fields in datasets using JavaScript and Lodash library o Creating Python GUI using packages: tkinter, NumPy o Complete data migration from Tableau into Informer for Multi-Valued data reporting capabilities

Business Analyst

CVS Health•  November 2018 - January 2019

Technologies: Excel, SAS, Teradata, Informatica, VMware Duties: o Work on targeting campaigns and ETL requests by healthcare providers for claims and customer data. o Validate client requests and analyze data with over 50k rows, report back with necessary modifications. o Run SAS code on cleaned data and submit files for data loading using Informatica. o Perform QC checks and data validation based on healthcare nomenclature. o Submit for further processing and participate in daily meetings with manager and team.

University of Texas at Arlington

Computer Information Systems, MS•  August 2016 - May 2018

Courses: Data Mining, Systems Development Life Cycle, Relational Databases, Project Management, Econometrics, Big Data Analytics, Object oriented programming, Data Warehousing and Business Intelligence. Technologies: Tableau, SQL, Python, Java, STATA, MS Project, SAP Hana, VMWare, Spark, Hadoop, SQOOP, StarUML, Excel Pivot Tables