Data Information Systems

Avinash Yekkala **** Pruneridge Ave, Santa Clara, CA 95051 https://www.linkedin.com/in/avinashyekkala *******.*@*****.***.*** 857-***-****

EDUCATION

Northeastern University Boston, MA

Master of Science in Information Systems Dec 2017

Relevant Courses: Data Management & Database Design, Data warehousing & BI, Adv.Data science,

Big Data Arch and governance, Planning and managing information systems, IT auditing, Intellectual property.

Bhaskar Engineering College Andhra Pradesh, India

Bachelor of Technology in Electronics and communication Engineering April 2012

TECHNICAL EXPERTISE

Programming Languages: Python, R, Pig, Hive,C++, Java Database: MySQL, MS-SQL, PostgreSQL, Mongo DB, Orient db Version Control: Git, SVN Framework: Hadoop, PySpark Operating System: Windows, Linux Virtualization Tools: Virtual Box BI Tools: Tableau, Power BI, Qliksense Tools: Informatica, Jupyter, Toad, SSIS, SSRS, SSAS, Orange, Weka, See-test, Appium, Selenium Computing Libraries: Pandas, Numpy, Tensor-flow, Seaborn Cloud: AWS – S3, EC2, EMR

EXPERIENCE

KONY LABS – HYDERABAD,INDIA (Associate Test Engineer) Feb 2014 to Dec 2015

Performed Manual, Automation and data base testing in agile methodology.

Took Initiation in developing and testing Automation scripts in see-test and Appium tool using PYTHON and JAVA and I saved thirty-minute man hours per day for my organization.

Created Black-berry installation, testing procedures and prepared a document on its testing procedures and led a team of three members for testing.

Authorized and reviewed test cases for the project which resulted in mitigating cumbersome testing process.

Teamed up with onsite members to review project status and prepared project charter

C-EDGE TECHNOLOGIES – MUMBAI, INDIA (Assistant System Analyst) Oct 2012 to Feb 2014

Planned, Co-ordinated analysis, design and extracted data from multiple source systems into data warehouse RDBMS while ensuring data integrity.

Performed Data analysis and ETL on structured and un-structured data using Kimball architecture to solve complex business problems.

Built data frames in Jupyter and used python libraries and executed data analysis to get reports on missing data.

Worked on customer churn model to predict the credit card business and identified threats related to customer attrition which causes revenue loss and improved revenue by 2% by executing machine learning algorithms like regressions, classifications and recommender systems.

Created story-board on business discoveries using Business Intelligence tools and communicated to end clients which resulted in actionable outcomes.

ACADEMIC PROJECTS

Contoso Data warehouse and Analysis Dec 2016

Created data warehouse for sales and inventory by integrating data from various sources such as flat files, db files in MSSQL, mysql, postgre using ETL tools like SSIS and Talend using Star schema. Implemented SCD’s, currency conversion and error handling.

Visualized business findings by creating dashboards on Tableau, Qliksense, PowerBI and power pivot tools.

Neural Networks prediction and sentiment analysis using NLP Apr 2017

Filtered user comments whether customers commented positively or negatively for a product.

Used web scraping to download the comments from amazon site and used bag of words model to separate the positive and negative words from a comment

Executed ANN, CNN and DBN for separating comments and found out number of positive and negative reviews.

Contact this candidate