Data Analytics

SANJULA KAUL

Dallas, TX 267-***-**** **********@*****.*** https://www.linkedin.com/in/sanjula-kaul EDUCATION:

University of Texas at Dallas- Masters’ in Business Analytics; Dean’s Excellence Scholarship (GPA:3.25) May 2021 SRM University, India- Bachelors’ in engineering (GPA:3.6) May 2015 TECHNICAL AND DOMAIN SKILLS:

Programming Languages R, Python, SAS, UNIX, Shell Scripting, MATLAB, HTML/CSS Databases Oracle 11g, Amazon Redshift, AWS S3, Oracle SQL Developer, MySQL Tools Informatica Power Centre V9.0, MS EXCEL, QlikView, Tableau, Shiny R, SAP Lumira Competencies ETL, Dashboarding and Visualization, Data Warehousing, Descriptive & Inferential Statistics, Regression, Ridge, Lasso, Clustering, PCA, LDA, SVM, K-NN, Random Forests, Bagging and Boosting, Text Analytics, Hypothesis Testing, Predictive Analytics, Time Series Forecasting, Decision Trees, Marketing Analytics, Power Pivot, Applied Econometrics, Clinical Trials Data Management.

WORK EXPERIENCE:

Cognizant Technology Solutions, India- Programmer Analyst Sep 2015 – Jul 2019 e-Clinical Data Warehousing Platform, Fortune 500 Global Pharmaceutical Company- Clinical R&D Division

Ensured consistency and accuracy of clinical data by collaborating with clinical trial teams to develop and maintain databases for drug discovery cycle and analysis using SQL and complex ETL.

Optimized the business process by reducing the response time to fetch more than 5,000,000 records by 50% through performance tuning of Oracle views and complex SQL queries.

Improved efficiency of the data management system for client by training 5 new programmers in organizational ETL processes.

Big Decision Sales Analytics, Product Development

Led a team of 4 to develop a dynamic Data Acquisition interface for a Human Capital Management system through Shell scripting and ETL.

Generated reports faster by 25% for Health Care Professionals by automating the process of Data quality checks for more than 100,000 records daily.

Personality Analytics, Product Development

Doubled the revenue and increased the credibility of the product by performing Sentiment Analysis using R and IBM Personality Mix.

Derived meaningful insights by generating dashboards in QlikView which increased the daily volumes and quality of Cognizant deal flow across different business verticals. ACADEMIC PROJECTS:

• Retail Analytics:

o Performed A/B Testing to find which campaign (by Gender) performed better on R with 70% accuracy, using Logistic Regression, Decision Trees, CART and Clustering Techniques for a campaign dataset, thus identifying the potential buyers.

• Effectiveness of Restrained Helmet use in Saving lives and costs of Motorcyclists: o Classified the number of crashes in the last 10 years on motorcycle, the number of restrained helmet drivers and the severity of injury against Age, gender and location using CART algorithm. o Forecasted the pattern of crashes and the crash severity for different locations in next 5 years.

• Impact of Shall-Issue law on crime rate in US:

o Studied the impact of guns on crime in America and performed Correlation Analysis to understand the relation between variables based on the economic theories, reduced Heteroskedasticity and endogeneity in data.

o Analyzed and predicted whether shall-issues law reduces crime-or not by building different types of models like OLS, Fixed Effect, Random Effect models for Panel Data on R. LEADERSHIP AND VOLUNTEER WORK:

https://thepardishi.wordpress.com Active Travel blogger.

Marketing Analytics Club, Marketing Officer, University of Texas at Dallas. Sep2019 - Present

Conducted a Hands-on workshop on SQL using MySQL Workbench. Feb 2020

Contact this candidate