Data warhouse/ ETL developer, Data Analytics

PRIYANKA PAL

***.************@*****.*** 714-***-**** Fullerton, CA Open to Relocation

https://www.linkedin.com/pub/priyanka-pal/43/4b0/418

Professional Summary

Business Intelligence/Data warehouse professional with over 5 years of industry experience.

Hands-on experience in development of large enterprise Data Warehouses, Reporting Solutions and Data Analytics.

Handle multiple projects independently and as a project team member, meeting deadlines.

Well versed with all the phases of Software Development Life Cycle.

Education

Master of Science, Management in Information Systems, Concentration- Business Analytics, California State University-Fullerton, May 2017.

Bachelor of Engineering in Computers, University of Mumbai, India, May 2009.

Skill Set

RDBMS & EDW: Teradata 12/13, SQL Server 14 • NoSQL Database: Exposure to MongoDB. • Languages: SQL, R Programming, HTML5, CSS.

Statistical Analysis Techniques: Hypothesis Testing, Chi square, T-test, ANOVA, Linear and Logistic Regression, Correlation.

Machine Learning Techniques: Supervised Learning- Regression, Classification using Discriminant Analysis (LDA/QDA) and KNN, Resampling using LOOCV and K-fold cross-validation, Decision Trees including Regression and Classification trees, CART. Unsupervised Learning- PCA and Clustering.

Business Decision Making: Time Series Forecasting using Regression and Decomposition Models, Autocorrelation and Trend/Seasonality/Cycle analysis.

Analytical Software: XLMiner, Tableau, Data Analysis plus, Forecast Pro, R Studio. • Scripting: UNIX • ETL: SAS DI Studio, Pentaho (Spoon)

MS office Tools: MS- Excel (Filter, Vlookup, Subtotal, Pivot Table, Goal Seek, What-If Analysis), Visio, PowerPoint, and Word.

Tools and Utilities: Teradata Utilities (FastLoad, Multiload, BTEQ, SQL Assistant), SAS management console.

Project Management Tools: Microsoft Project 2016, Excel (Advanced), Solver, Marketing Engineering – XL

Independent Research - BI/ Data Analytics Projects Aug 2015 – May 2017

Social Media Analytics: Yelp Business Analysis (SQL, R, MongoDB, Tableau 9.3, MS Excel, Pentaho Spoon, ETL, Forecast Pro, Time-series Analysis)

Create database and collections in MongoDB and loaded JSON files. Developed ETL jobs in Pentaho (Spoon) to process the stored files in MongoDB.

Normalize unstructured JSON data to 3 NF and process data/data cleansing using R. Libraries RJSONIO, jsonlite, tibble, dplyr, sqldf.

Natural Language Processing(NLP) for sentiment analysis, review text mining to create worldcloud using unigrams & predict review rating from word polarity.

Using logistic regression, multiple linear regression and CART, predicted the business ratings from various factors; location analysis using clustering.

Time-series analysis to find trend and seasonality patterns in reviews received & forecast customer increase using winter’s exponential smoothing method.

Perform Visual Analytics using Tableau, SQL, Excel. Create interactive dashboards and publish data stories on Tableau Public, provide visibility to KPIs.

US Crime Data Analytics (XLMiner, Tableau 9.3, MS Excel)

Crime pattern analysis based on various violent crimes, location and population demographic.

Develop and finalize K-means clustering, K-Nearest Neighbor (KNN) Classification and Multiple Linear Regression (MLR) using different model evaluation metrics such as MAPE, RMSE, and Adjusted R-Square.

Presentation of the modeling results and data insight using Microsoft PowerPoint and building interactive dashboard through Tableau.

Mobile House Sales Forecasting (Forecast Pro, Regression, Box-Jenkins, Decomposition Models)

Examine past 15 years’ data to determine the time series is not stationary using Autocorrelation functions in Forecast Pro.

Decompose the time series in to underlying components and analyzed long term trend, seasonality and cycle present in the data.

Forecast cyclic factors using Linear/Quadratic Regression Model including cyclic indicator and evaluate the best model based on Adjusted R-squared.

Forecast Sales using multiplicative decomposition model based on MAPE value of the Fitted Forecast, draw conclusion and suggest recommendations.

American Automobile Association (AAA) emergency road service calls forecast (Forecast Pro, Time series, Dynamic Regression, MS Excel)

Examine past 5 years’ data & forecast emergency road service calls for next 5 months using predictors such as unemployment rate, daily temperature & rainfall.

Investigate the increase of emergency road service calls per member as compared to less increase in club membership.

Involved in statistical model building using multiple linear regression and dynamic regression and evaluated the final model based on MAPE, RMSE, Bayesian Information Criterion (BIC), Ljung-Box statistics, R-squared and Adjusted R-squared values.

Work Experience

Associate Technical Consultant

Teradata Corporation, India (Client – Vodafone Australia) Mar 2013 – July 2015

Responsible for analysis, end-to-end solution development, testing and implementation of Large-scale Data Warehouses (more than 100+ Terabytes).

Develop cost effective ETL/ELT jobs & mappings (Push and Pull data from various sources), consolidating various data sources of variety of formats.

Plan and design test cases for System Integration, Unit Test, Production Verification through business scenario testing & comparative analysis of data.

Experience in data modeling, working with both 3NF relational data model, dimensional model (Star and Snowflake schema) and OLAP/OLTP concepts.

Strongly knowledgeable in SQL programming using Joins, Unions, regexes, OLAP Rank functions, Aggregate functions, date/string functions, Sub queries, Grouping, logical expressions, Indexing mechanism and other Teradata utilities such as Teradata SQL Assistant, BTEQ, FastLoad, MLoad and Fastexport.

Develop Release Notes, Code Packages & Operation Guide to ease the deployment & roll out process. Assisted in Micro-Design document development.

Populate slowly changing dimension tables using type 2-dimension changing and maintaining the full history of the data.

Troubleshoot and debug complex codes and production issues, evaluate and determine root cause, deliver best solutions to client adhering to SLAs.

Database object creation, migration, writing, testing, and debugging complex SQL queries for data integration and cleansing.

Work in cross-functional team, maintain quality communication with client-side and onshore team located in Australia, Philippines in the event of process failure, feed file related issues & other application specific matters.

Applied project management techniques while leading a team of 4 developers, ensuring functional and technical design specifications are met during application build and test, within timelines.

Technical Associate

Tech Mahindra Ltd (Client - AT&T Inc.) July 2012 – Feb 2013

Serve as a Techno-Functional consultant for AT&T ‘s software application ‘Global Craft Access System’ which maintains the workforce management of their technicians involved in field jobs.

Tech Mahindra Ltd (Client-Etisalat DB Telecom Pvt Ltd (EDB) May 2010 – May 2012

Involved in developing BI reporting solutions, business logic discussion with clients, requirement gathering & analysis, unit testing of reports developed.

Creating daily/weekly/yearly business reports using MS Excel, Teradata BTEQ, SQL, Unix shell scripts; to provide solutions relating to customer retention, target marketing, campaign management, CRM, revenue assurance & fraud management and regulatory requirements.

Conducting ad-hoc analysis implementing appropriate statistical techniques, making conclusions and suggesting effective recommendations to business.

Recording Etisalat’s business performance through KPIs by creating monthly metrics using Tableau Reports, MS Excel (Pivot tables, functions, charts etc).

Built data loading scripts in Teradata and complex SQL queries for data reconciliation, data analysis of 50 million+ records.

Awards and Honours

Teradata Corporation - Project Long Service Award (Q4, 2014), Employee of the Quarter (Q4, 2013)

Tech Mahindra Ltd - Employee of the Quarter (Q1, 2012), Best Team Award (EDB-BI Team) in FY11-12-Q1

Contact this candidate