Phone: 510-***-****

Prashanth Chandrappa

Email: ac0w43@r.postjobfree.com

Experience: Data Engineer with 3+ years of experience in interpreting and analyzing data for driving business solutions. Proficient knowledge in statistics, mathematics, and analytics. Excellent understanding of business operations and analytics tools for effective analyses of data and building the applications.

Data Engineer/Developer

IBM

July 2011 - December 2014

Project: Financial Data Warehouse, Deutsche Bank

Managed data operations team and collaborated with data warehouse developers to meet business user needs and maintain data integrity.

Consulted with and trained analysts to effectively access data and optimize dashboards.

Maintained SQL scripts to create and populate tables in data warehouse for daily reporting across departments.

Archiving, Historization, Version Range Delete (VRD) and supporting production environment and handling the Oracle Production issues.

Monitored the production Oracle alert logs for database errors and system resource availability and resolved system memory and data issues.

Project: Department of Works and Pensions, UK

Experience with creating ETL processes to source and link data, assist in developing internal tools for data analysis.

Utilized the ETL(Informatica) process to integrate client data into the system.

Wrote scripts for Encryption and decryption for inbound and outbound files using GPG utility (Red Hat Linux).

Wrote and implemented updates to existing client data by putting digital signature and verification using GPG utility.

Fixed existing standard scripts to meet updated database structures.

Created migration scripts for new data sources by creating data pumping scripts Using SQL queries.

Technical Skills

Programming and Scripting: R, SAS, Python, Numpy, Pandas, Matplotlib, SQL, Unix/Linux Shell Scripting, HTML, CSS, JavaScript.

Software: SQL Developer, ETL Informatica, Tableau, Putty, WinSCP, Toad for Oracle, Oracle 11g, RStudio, Minitab, SAS 9.4, MS Office Suite.

Statistical Techniques: Regression Models, Time series, Dimensionality reduction, Hypothesis testing and Confidence intervals, Principal Component Analysis, ANOVA, A/B testing.

Machine Learning: Classification techniques, Clustering, Feature engineering, Ensembled learning, Neural networks.

Additional Experience & Projects

Student Assistant – Assistive Technology Services Office, CSU East Bay

Testing, debugging and customizing software such as Kurzweil, Dragon, Jaws and Zoom text per each user preferences.

Training students, staff and faculty on AT software and hardware.

Migrated software from physical to virtual server and integrate it over the campus wide network.

Sentiment analysis of live tweets using Naïve Bayes Algorithm

Used Naïve Bayes algorithm to categorize into five emotions and determined the polarity of tweets.

Presented the analysis using bar-plot, ggplot, wordcloud and comparison cloud.

Predictive Analytics, Data source - Retail store

Developed actionable insights to improve sales which predicted a revenue growth of 1.7% for a retail store client

Performed Elasticity Modeling to optimize price and a Market Basket Analysis to promote sales

Education

M.S. in Engineering Management, December 2016. California State University-East Bay, Hayward, CA, USA

B.E. in Mechanical Engineering, June 2011. Sri Jayachamarajendra College of Engineering, Mysore, KA, India

Contact this candidate