Pravin Kumar Viswanathan

• adlzld@r.postjobfree.com • https://www.linkedin.com/in/pravinvp6 • Brea, California • 657-***-****

Business Intelligence / Data Analyst

Accomplished and results-driven professional with hands-on experience in E-commerce and apparel industries; leading, executing, and implementing advanced practices to accomplish business development opportunities. Demonstrated delivering valuable insights via data analytics and advanced data-driven methods. Proven track record of providing support to expand existing data delivery platforms and creating new data collection systems that optimize data management, delivery, and quality. Adept at preparing detailed documents and reports, while executing complex internal and external data analyses tasks. Excellent understanding of business operations and analytics tools for effective data analysis. Proven ability to support key decisions for enterprise initiatives involving KPI tracking & improvement, organizational realignment, and corporate growth.

Skills

Technical Skills: Data Mining, Machine Learning, Business Intelligence, Business Process Improvement

Languages & Tools: R, Python, SQL, C, C++, Java, PostgreSQL, MS Access, MySQL, SQL Server, Jira, MS Visio

Visualization Tools: Alteryx, Tableau, Power BI, MS Excel

Statistical Skills: Statistical Modelling, Time Series Analysis, Classification, Clustering, Regression

Business Skills: Business Plan & Development, Requirement Analysis, Client Relations Management, Team Building & Leadership, Financial Analysis, Public Speaking

Career Experience

Business Development Analyst, Eathot Eservices, India 4/2015 to 1/2018

Established and employed databases, data collection systems, data analytics, and other strategies in alignment with business goals to increase awareness of risk, while enabling the implementation of preventative measures. Deciphered progress into business reports and dashboards by utilizing Tableau, Excel, MySQL Server.

Proficient in ad-hoc queries, developed numerous reports for analyzing and comparing the KPI with the target as well as processes across business systems (Sales, Delivery, and Vendor panel).

Identified patterns between products and markets by using Tableau and delivered exceptional support in creating marketing strategies.

Devised and executed a new delivery model called 'Fourier Delivery.' Uncovered trends and relationships in delivery demand and supply using ad-hoc queries and reduced delivery cost by 35% and increased productivity by 15 to 20%.

Accomplished 55% year-on-year revenue growth and increased market share by 20% in the first two years by more granular targeting of marketing campaigns to better cross-sell and up-sell based on customer needs and history.

Brought down CAC (Customer acquisition cost) by 25% by zoning in on the customer segments by targeting valuable customers by performing and evaluating the classification models.

Spearheaded day-to-day business operations, such as creating mock-ups, management reports, strategy slide decks, dashboards, or advanced visualizations to tell a coherent story, while presenting business pitches to two large venture capitalists with a keen focus on enhancing business expansion.

Business Development & Client Acquisition, Gurudev Apparels, India 7/2013 to 4/2015

Oversaw business development efforts, including Statement of Work (SOW), Proposal development, client presentations with a keen focus on driving the company's business, and increasing sales revenue. Monitored and negotiated risks on delays or changes while serving as the client's point of communication aimed at enhancing customer experience. Planned and implemented each stage of manufacturing in compliance with the timeline requirement of clients in close collaboration with the operations team.

Communicated with accounting and operations teams to manage International export as well as sales procedures of logistics, legal, and banking procedures for export orders.

Established and enforced innovative marketing strategy to meet buyer's needs and requirements as well as market changes that resulted in attaining orders worth $2M in 2016.

Acquired two new clients (Shoeby, LPP SA) in 2015 by collaborating with international clients in Europe and the USA for marketing and procuring orders.

Education & Credentials

Master of Science in Information Systems & Business Analytics, 5/2020

California State University, Fullerton, CA

Bachelor of Technology in Information Technology, 11/2013

Kongu Engineering College, Erode, India

Professional Affiliations

IEEE- Associate Chairperson, Kongu Engineering College, India

Active member of Business & Data Analysis Club, Students Alumni Association and Indian Students Association

Key Projects

COFFEE CHAIN ANALYSIS

Analyzed dataset of a coffee chain to identify KPI and forecast sales and profit.

Data mining techniques used: Statistical modeling, manipulation of data structures, train-test-validation, fit regression model using MLR (forward, backward, stepwise for regression selection), KNN, CART using R.

TIME-SERIES DATA MINING OF STOCK MARKET DATA TO CREATE INVESTMENT PORTFOLIO

Analyzed stock market data of NYE, NASDAQ, and AMEX to create an investment portfolio.

Cleaned, manipulated raw data and stored using PostgreSQL DB.

Explored and performed ETL on the dataset using R. Optimized data structures using data frames.

Performed financial analytics (Returns, stats, distributions, pricing model) using R packages.

Performed portfolio optimization using Markowitz portfolio model, applying the ‘PortfolioAnalytics' package.

Created an investment portfolio by training the model, and on testing it outperformed SP500 indexes.

FORECASTING ELECTRICITY LOAD AND PRICE USING AUTOMATED INFORMATION SYSTEM

Forecasted electricity load using past data to plan production and resources for NYISO.

Designed automatic extraction of real time data from the source every 5 minutes. Performed necessary ETL.

The Automatic Arima technique was used to fit model to create R (time series) plot with 95% intervals.

Tested the model with statistical standard error measures, thereby validating the model.

Forecasted the next 30 days load and created load proposal with recommendations at different confidence levels to advise the production department of NYISO.

Contact this candidate