Business Intelligence Analyst (Data Science/Analytics)

Behab Patnaik

972-***-****; *****.*******@*****.***

https://www.linkedin.com/in/behab-patnaik/

https://public.tableau.com/profile/behab.patnaik

EDUCATION

The University of Texas at Dallas Dec 2020

M.S., Business Analytics GPA 3.909

Manipal University Jaipur, India May 2017

B.Tech., Mechanical Engineering GPA 3.02

CERTIFICATIONS & TECHNOGIES

Business Intelligence/Visualization: PowerBI, Tableau, QlikView, SSRS, Advanced Excel PowerBI Report Builder

Programming: Advanced SQL, Python, R Programming, SAS Big Data Technologies: Spark, Hadoop

Operating Systems: Windows

Databases: Oracle, SQL Server, MySQL, PostgreSQL, SSIS,SSAS,SSMS BUSINESS EXPERIENCE

Business Intelligence Intern Aug 2020 – Present

Sanjose Systems, Austin, Texas

Identified and designed technical flows according to the client specification

Used Extensive heavy SQL (joins, sub-queries, PIVOT, T-SQL, Stored Procedures, CTE) for complex queries involving multiple tables from different databases and developed reports using Microsoft SQL Server

Identified and designed Business Intelligence Models for Business Processes

Ingested data from variety of corporate data sources and performed required data cleaning and transformations in PowerBI query editor

Writing complex DAX and MDX query languages for developing measures to help solve the business problem.

Performed Query Optimization and Performance Tuning

Performed Solution tests to ensure High quality of end product delivery Operational Excellence Analyst Jan 2018 - Dec 2018 Siemens Kalwa Plant, Mumbai, India

• Prepared a case study to improve the Engineering Change Management process by lowering lead time by 8% as well as reducing the complexity of the process.

• Wrote Advanced SQL Queries to fetch the relevant data related to the change management process from the database for further analysis.

• Analyzed the customer revised order database having a volume of 70000 order instances in excel and prepared dashboards using Microsoft PowerBI which led to better understanding and decision making.

• Introduced 6 Parameter indicators for monitoring and Inspection and came up with a revised EC handling framework.

• Used Python for Implementing Advanced Binary Classification Machine Learning models(Logistic Regression, Decision Tree Classifier, Random Forrest Classifier, voting classifiers, Bagging, and AdaBoosted Models, etc) and Deep Neural Networks to predict whether a change management order will be delayed or not and to find their relative impacts they had on the dependent Binary Variable Delay.

SKILLS

Database Management

Data Modeling

Data Wrangling

Data Cleaning

Data Analysis

Business Analysis

Data Science

Data Visualization

Reporting

Business Intelligence

Statistical Analysis and

Modeling

Machine Learning

Time Series Forecasting

Predictive Analysis

ETL Capabilities

Econometrics

Quantitative Analysis

Marketing Analytics

Business Location

Analysis

Big Data Tech (HDFS,

Spark)

ACADEMIC EXPERIENCE

Business Intelligence/ Data Analysis- SQL PowerBI Excel Tableau ARCGIS SAS

COVID-19 Tracker: Designed executive level Completely Automated PowerBI dashboards and reports to track and identify the daily/monthly active cases, deaths, recovered cases. Wrote several complex DAX measures to make custom KPI’s like fatality rate and YTD Increase to help monitor and see the patterns in the current pandemic.

Marketing Intelligence Dashboard: Designed and produced dashboards in Tableau and detailed reports In PowerBI to analyze and recommend marketing budgeting solutions for a upcoming startup in the laundry business, helping them to optimize their marketing budget for maximum revenue generation.

Retail Analytics Dashboard: Created complex SQL queries, Views, Stored Procedures to retrieve the store performance data stored in multiple tables in a Data Warehouse. Performed Intensive Data Cleaning in Power Query, Identified the Business Process and several KPI’s and made robust data models using Snowflake Schema in PowerBI using which I produced industry standard Dashboards and Reports to help identify the trends and patterns in the stores business performance so that better business decisions could be made.

Marketing Analytics Solutions for JAYS Potato Chips: Used SAS to perform statistical tests, Regression Analysis and Revenue forecasting to provide actionable insights to JAYS potato chips brand to make better pricing and marketing decisions. Data Science/ Machine Learning- Python Excel R

Binary Classification Problem To Predict the Credit Card Defaulters: Implemented intensive data cleaning, imputations and several advanced Machine Learning algorithms like KNN Classifier, Decision Tree Classifier, Logistic Regression and several ensemble algorithms like Random Forest Classifier, Bagging and Pasting Algorithms and Deep Neural Network in Python to accurately predict the Defaulting Clients and found out quantitatively the most relevant predictors of default.

Regression Problem To Predict the House Price in King County: Designed and produced several hyper tuned Machine learning models after intensive data cleaning and imputations like Linear Regression, Lasso Regression, Ridge Regression, KNN Regressor and Random forest Regressor with several other bagged and pasted ensembled regressors and Deep Neural Network Algorithms to accurately predict the House Price in King County.

Multi Class Classification Problem To Predict Cardiac Arrythmia in Patients: Big Data Technology- Hadoop File System, Impala, Hive, Tableau

Risk Factor Analysis For ANT Trucking: Used the massive truck fleet data to refine and analyze trucking movement and to meet the organizational goal of identifying and better understanding the risky drivers. Big Data Technologies like Hadoop File System was used to store the data and Impala and Hive were used to query for relevant data and Tableau was used for providing a industry standard dashboard to resolve the stakeholders needs of identifying the risky drivers and taking relevant actions.

CERTIFICATIONS:

Tableau A-Z Hands-on Training

Tableau Advanced Training

Python For Data Science And

Machine Learning

Python For Data Analysis And

Visualization

Excel Skills For Business – Advanced

Microsoft PowerBI Advanced

The Complete SQL Bootcamp

Excel For Business Data Analysis

Python For Time Series Analysis

Microsoft SQL Server 2019 Essential

Training

Microsoft SQL Server 2016: Query

Data

Power BI Essential Training

Power BI Data Modeling with DAX

Learning Power BI Desktop

Advanced SQL: Logical Query Processing

Advanced PowerBI

Contact this candidate