Aakriti Sharma

Tools Used:
R Programming | Tableau | Excel

    ● Performed multiple independent value Linear Regression on Product Sales using R
       Programming to determine sales dependency on variables
    ● Conducted tests like Ramsey RESET to verify all regressions assumptions (linearity,
       multicollinearity, heteroscedasticity, serial correlation, outliners) are obeyed
    ● Applied corrections to data by performing Box-Cox, Box-Tidwell to meet linearity assumption
    ●… Show more

Tools Used:
R Programming | Tableau | Excel

    ● Performed multiple independent value Linear Regression on Product Sales using R
       Programming to determine sales dependency on variables
    ● Conducted tests like Ramsey RESET to verify all regressions assumptions (linearity,
       multicollinearity, heteroscedasticity, serial correlation, outliners) are obeyed
    ● Applied corrections to data by performing Box-Cox, Box-Tidwell to meet linearity assumption
    ● Generated a 3D graph using regression plane to show independent and dependent variables
    ● Created 4 geographical representations of sales and demographic data using Tableau
Show less

Tools Used:
Hadoop | Python | Spark Apache | Jupyter

    ● Performed data cleaning and analysis of Skytrax customer rating data to perform regression and        classification analysis for prediction of recommendation
    ● Implemented regression analysis on data and found independent variables having most impact        on ratings
    ● Determined best fit regression model based on Mean Square Error of various test models
    ● Conducted sentimental analysis and created best… Show more

Tools Used:
Hadoop | Python | Spark Apache | Jupyter

    ● Performed data cleaning and analysis of Skytrax customer rating data to perform regression and        classification analysis for prediction of recommendation
    ● Implemented regression analysis on data and found independent variables having most impact        on ratings
    ● Determined best fit regression model based on Mean Square Error of various test models
    ● Conducted sentimental analysis and created best fit model using elastic net regulation
    ● Executed random forest classification using decision tree
Show less

Tools Used:
R Programming

    ● Performed logit and probit analysis on variables to determine a customer’s loan acquisition               power
    ● Produced final regression model for main effects and interaction terms variables and provided        spreadsheet prediction for the same
    ● Implemented neural network analysis on significant variables determined from logit and probit
       analysis
    ● Created a prediction model of the neural network and used this model… Show more

Tools Used:
R Programming

    ● Performed logit and probit analysis on variables to determine a customer’s loan acquisition               power
    ● Produced final regression model for main effects and interaction terms variables and provided        spreadsheet prediction for the same
    ● Implemented neural network analysis on significant variables determined from logit and probit
       analysis
    ● Created a prediction model of the neural network and used this model to perform sensitivity               analysis for the neural network
Show less

Tools Used:
MS Visio | MS Word | MockPlus

    ● Performed in-depth investigation of a healthcare system and generated requirements                      through research
    ● Overhauled requirement gathering from Business Owner and key stakeholders and created               Business Requirement Document(BRD)
    ● Analyzed business system flow using different conceptual modeling techniques for system               analysis including Entity Relationship Diagrams (ERD), Data… Show more

Tools Used:
MS Visio | MS Word | MockPlus

    ● Performed in-depth investigation of a healthcare system and generated requirements                      through research
    ● Overhauled requirement gathering from Business Owner and key stakeholders and created               Business Requirement Document(BRD)
    ● Analyzed business system flow using different conceptual modeling techniques for system               analysis including Entity Relationship Diagrams (ERD), Data Flow Diagram (DFD) and Unified               Modeling Language (UML)
    ● Implemented requirement, regression, smoke, user-interface, and usability testing to validate        the system
Show less

Tools Used:
Google Analytics

    ● Determined peak time frame of pervious marketing campaigns and the dollars spent on each
       campaign to analyze success of campaigns in the past
    ● Analyzed the effective of previous campaigns by evaluating factors like New users, Clicks, Cost        per Click, Sessions, Bounce Rate etc.
    ● Identified key words and geographic regions that will result in strong campaign impact
    ● Established budget for impactful advertising… Show more

Tools Used:
Google Analytics

    ● Determined peak time frame of pervious marketing campaigns and the dollars spent on each
       campaign to analyze success of campaigns in the past
    ● Analyzed the effective of previous campaigns by evaluating factors like New users, Clicks, Cost        per Click, Sessions, Bounce Rate etc.
    ● Identified key words and geographic regions that will result in strong campaign impact
    ● Established budget for impactful advertising campaign based on region and degree program Show less

Tools Used:
R programming

    ● Performed data profiling on a dataset of 1.7 M records of customer survey input, to provide               business insights 
    ● Executed association rules on dataset to understand the factors determining Net Promoter               Score (NPS)
    ● Evaluated and visualized dataset using various R Packages like ggplot and mathplotlib to               perform statistical analysis
    ● Applied machine learning techniques like Logistic… Show more

Tools Used:
R programming

    ● Performed data profiling on a dataset of 1.7 M records of customer survey input, to provide               business insights 
    ● Executed association rules on dataset to understand the factors determining Net Promoter               Score (NPS)
    ● Evaluated and visualized dataset using various R Packages like ggplot and mathplotlib to               perform statistical analysis
    ● Applied machine learning techniques like Logistic Regression, Naïve Bayes, Random Forest, SVM,        and used different performance metrics to evaluate the NPS
    ● Built decision tree models to predict bad reviews and its category, to setup an advanced warning        system for proactive resolution of issues Show less

Tools Used:
MS Project

    ● Developed a project plan to stream line a preexisting data analytics process of finding social               media influencers
    ● Interacted with all stakeholders to establish requirements and gather feedback throughout the        project life cycle
    ● Created an issue tracker and change log, and defined metrics for measuring success of the               project
    ● Recommended changes and provided a comprehensive document outlining… Show more

Tools Used:
MS Project

    ● Developed a project plan to stream line a preexisting data analytics process of finding social               media influencers
    ● Interacted with all stakeholders to establish requirements and gather feedback throughout the        project life cycle
    ● Created an issue tracker and change log, and defined metrics for measuring success of the               project
    ● Recommended changes and provided a comprehensive document outlining scope and                      significant milestone Show less

Tools Used:
DataStage | VBA | Excel | Notepad++

    ● Created a customizable VBA script that parsed DataStage jobs (in XML format) to extract
       relevant details of job
    ● Automated the process of analyzing 1800 queries, saving 85% time approximately while                      eliminating manual work
   ● Conducted knowledge sharing sessions with team members leading to code reusability and               increased efficiency

Tools Used:
Putty | SVN Repository

    ● Developed a UNIX batch script for import and export of SVN repository jobs reducing
       execution time by 80%
    ● Streamlined the process to a single-window operation which resulted in 75% of reduced effort
    ● Modeled script to increase reusability across different teams and projects