Bayer Us Llc, Pittsburgh, Pa
Leverkusen, North Rhine-Westphalia, De
-> Worked on data cleaning and reshaping, generated segmented subsets using NumPy and Pandas in Python-> Wrote and optimized complex SQL queries involving multiple joins and advanced analyticalfunctions to perform data extraction and merging from large volumes of historical data stored inOracle 11g, validating the ETL processed data in target database-> Good understanding of Teradata SQL Assistant, Teradata Administrator and data loadExperience with Data Analytics, Data Reporting, Ad-hoc Reporting, Graphs, Scales, Pivot Tables and OLAP reporting->Identified the variables that significantly affect the target->Continuously collected business requirements during the whole project life cycle->Conducted model optimization and comparison using stepwise function based on AIC value->Applied various machine learning algorithms and statistical modelling like decision tree, logistic regression, Gradient Boosting Machine to build predictive models using scikit-learn package in Python->Developed Python scripts to automate data sampling process. Ensured the data integrity bychecking for completeness, duplication, accuracy, and consistency->Generated data analysis reports using Matplotlib, Tableau, successfully delivered and presented the results for C-level decision makers->Generated cost-benefit analysis to quantify the model implementation compared with theformer situation->Worked on model selection based on confusion matrices, minimized the Type II errorEnvironment: Tableau 7, Python 2.6.8, Numpy, Pandas, Matplotlib, Scikit-Learn, MongoDB, Oracle 10g, SQL.