Data Analytics Support Resume
New York, NY
TECHNICAL SKILLS
Scripting and Programming Stack: Python (Pandas, Sci - Kit Learn), Python AI (Keras/Tensorfow), SQL, H2O ai, R(Tidyverse), SQL, Deeplearning4J ( Java AI for Hadoop), Unix
Relational Database Management Systems: Oracle, MS SQL Server, Sybase, MySQL, Databricks -SPARKSQL
Cloud Services & Office Applications: IBM Bluemix (DSX Studio, DashDB), AWS (S3, Athena), MS (Azure ML, Power BI-Excel, Office) Google (Tensorflow Learn, Analytics)
PROFESSIONAL EXPERIENCE
Confidential, New York, NY
Data Analytics Support
Responsibilities:
- Currently testing an LSTM RNN model (Keras Tensorflow) for an Investment Advisory group for predicting cryptocurrency trade volume and subsequent price changes for crypto currencies that they’re interested in tracking (e.g. Ethereum) for their client portfolios.
- Optimizing a linear DNN model (Keras Tensorflow) for use as a regressor to improve prediction accuracy in comparison to a regression trees model and an Azure wide neural network under implementation
- Reviewed Chiller Power Plant Data from the Power Engineering group (Smith Engineering) for data anomalies from the sensors for feature values
- Worked with the power engineer who was managing and wrangling the sensor source data for data munging of the time series data prior to running machine learning models
- Worked with implementing regression models (SVR) in the Sci-kit Learn library with the data for accuracy score and further feature engineering
- Lead a team of junior analysts on dynamic pricing analysis of e-commerce data in Python and Spark for the cllient
- Updated and prepared e-commerce pricing reports from raw data (Excel,csv) source documents using filtering and joins (Dply library in R) of the E-Commerce client’s (Caprice Electronics) products ranging from industrial to computer peripheral products
- Worked on Web Data extraction of e-commerce site listings of client and competitor products (Python & Selenium) through a web scraping application for price monitoring
- Reshaped price and web data and checked for statistical outliers in R prior to regression analysis
- Implemented Spark SQL scripts on a Databricks cluster for querying big data sets of retail financial intelligence data from the web site
- Worked on Pandas scripts to emulate Excel functions (e.g. Vlookup ) to check for historical product data against existing supplier database files and competitor reports
- Converted raw data from Excel to SQL (R & SQLdf) for updating product vendor SKU files and price testing new e-commerce sale files
- Developed sales reports from the data to support the sales manager in supplier acquisition and managed the relationships with new suppliers
Confidential, Mountainview, CA
East Coast Remote Tech Market Research & Data Analyst
Responsibilities:
- Conducted primary market research surveys for data acquisition by interviewing respondents over the telephone that were using analytical instrumentation
- Conducted market research analysis in software such as MRI medical software used for imaging and analysis applications
- Conducted market research analysis in hardware such as magnetic levitation pumps used for semiconductor fabrication chambers
- Communicated with customers with questions about product pain points and preferred solutions in any model upgrades
- Identified research objectives based on client's secondary market research reports
- Analyzed the client’s secondary market research reports for developing a competitive matrix of the products offered by competing companies
- Trained the market research team through conferences and webinars on the technical aspects of the hardware and software
- Conducted the quantitative Data analysis, along with the project manager, of questionnaire results (Survey Monkey-SM) using Excel, Access, and sentiment text analysis of transcriptions
- Analyzed the data for extracting statistical trends in specific user requirements and presenting the findings to the technology instrumentation client company
Confidential, New York, NY
Technical Support and Device Software Installer
Responsibilities:
- Carried and installed energy efficiency IOT devices for air conditioners at residential sites as part of a Con Edison project on reducing energy demand during peak power use
- Set up the network using a newly developed web based software application for control of the units through the router for the internet connection
- Modified prior installations and performed troubleshooting on older equipment to produce a working network of devices for the customer
- Demonstrated and trained the customer on the software and management of the devices using a smart phone application
- Provided technical support to customers on their equipment by reaching out to them by phone and guiding them on finalizing their installation.
- Obtained and reported the device data to the manufacturing company in Excel through updates using Google Drive
Confidential, New York, NY
Part Time Instructor
Responsibilities:
- Taught and tutored the physical sciences (Chemistry and Physics) for review for the MCAT exam and SAT II exam
- Reviewed the latest version of the AP Physics Exam Workbook for content accuracy
Confidential, Chatsworth, CA
Quality Assurance Analyst
Responsibilities:
- Maintained the ERP data warehouse for raw material product data distributed by chemical manufacturers (e.g. BASF, Rhone Poulenc, Ciba) for cosmetic, medical device and topical over the counter (OTC) applications
- Generated reports on changes, trends, and statistical analysis in Excel using MS SQL Server from data acquired on cosmetic products generated by manufacturing operations
- Worked on software implementation issues such as legacy data migration in accordance with management guidelines when converting over to a new enterprise resources planning software platform
- Developed a SQL driven database application in Sybase for monitoring production and quality control data for distributed products
- Generated and finalized documentation such as change control standard operating procedures for regulatory checks on primary suppliers and contractors
