Aditya Oak

LinkedIn GitHub Tableau Public Hackerrank adcl55@r.postjobfree.com 469-***-**** Denver, Colorado Open to relocation

“Agile developer and problem solver currently seeking a mid-senior role in Data Engineering, Data Science and BI.” EXPERIENCE

BI Developer – II

Comcast Business Denver, CO Aug 2019 to Dec 2019 Tech:

Python 3.7 (xmltree, regex, pandas), SQL Server, Tableau (Desktop and Server), XML o Developed an automated process in Python 3.7 for extracting data from xml files of tableau workbooks o Worked extensively with regular expressions, nested list comprehensions and itertools o Compiled dataframes to deliver 150+ datasets in xlsx templated format o Helped cut down 60% of manual work and effectively replaced features of purchased software o Flourished in an environment of ever-changing requirements, evolved code to meet these o Worked on bug fixes and feature additions

o Developed UI to isolate code from development, avoiding accidental code changes while run by users o Planned, performed and executed deliverables for 2-week sprints in JIRA Programmer Analyst

Acme Manufacturing Company Inc. Denver, CO Jan 2019 to July 2019 Tech:

Python, T-SQL, Tableau, JavaScript, Pick Basic, VBA 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 Participate in code reviews to improve code standardization and consistency. 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 Migrate reports from Tableau into Informer for Multi-Valued data reporting capabilities PROJECTS

On-Prem to Cloud

o Worked with CI/CD pipelines to migrate from SAP BW to Snowflake (CDW) o Used Azure Data Factory to connect to SAP BW and perform full loads into Data Lake o Created JSON files for mapping objects and column names from source to destination o Performed extraction and transformation using PySpark in Databricks o Cluster adjustment in Snowflake to run queries for altering tables o Accessing Hive tables to match changes across sources Systems Development Life Cycle

o Developed proof of concept for a school that wanted to implement online registration for its classes o Established a system request consisting of business need, requirements and value o Analyzed technical feasibility in terms of compatibility, tech used, project size and familiarity with system o Number crunching economic feasibility in terms of cost-benefit, intangible costs and break-even point o Used Unified Modelling Language (UML) to build process flow in terms of use-case diagram, activity diagram o Calculated effort estimation using unadjusted weights and technical complexity factor. Migration between BI tools

o Documented reports and jobs that needed to be migrated from Tableau to Informer. o Broke down calculated fields and LODs that made up the reports in Tableau. o Recreated these calculations in Informer using JavaScript and in-built features. o Replicated SQL Server - Tableau connection and applied it to U2 database - Informer o Monitored jobs and nightly refreshes on both platforms to confirm data refreshes o Conducted trainings for stakeholders on using Informer to create custom reports QUALIFICATIONS

Master’s in Information Systems

University of Texas at Arlington Aug 2016 to May 2018 o Business Stats (Advanced Methods) - A /B Testing, hypothesis testing, confidence interval o Systems Development Life Cycle - System request, gathering Requirements, feasibility analysis o Econometrics - Single and Multiple Linear regression, binary classification, probit model o Relational Database Mgmt. Systems - PL SQL, Normalization, Joins, Subqueries o Big Data Analytics - Databricks, PySpark, Snowflake, Azure Data Factory, DevOps Bachelor’s in Mechanical Engineering

University of Mumbai 2010 to 2014

INTERNSHIPS & OTHER EXPERIENCES

Business Analyst

CVS Health Prospect Heights, IL Oct 2018 to Jan 2019 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 Querying in Teradata to check data loads against previous results. 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 Data Science Intern

Tata Technologies Thane, MH, India May 2017 - Aug 2017 o Use case: Reducing testing time for vehicles on assembly line. o Performed one-hot encoding to expand categorical features into binary ones to enhance model performance o Developed use-case and attributes for breakdown of material handling systems o Classified leading and lagging indicators

Data Analyst – Marketing

ElectroMech Material Handling Systems Pune, MH, India Jul 2015 - Jan 2016 o Used Excel Pivot Tables and Vlookup to summarize customer information from past campaigns. o Analyzed marketing campaigns in terms of leads / opportunities generated vs cost analysis. o Closely followed Standard Operating Procedure for Brand Awareness. o Ensured nationwide presence of firm in conventions and expos. o Added business value by generating 108 customer leads and 45 opportunities. Inventory Analyst – Production

Samarpan Fabricators Thane, MH, India Jan 2015 - Jul 2015 o Analyzing packaging data for tolerance range of finished pouches. o Reduce inventory of discontinued products by referring historical data of design changes o Oversee assembly and testing of packaging machines