Data Analyst Resume
SUMMARY
- For 5+ years, I participated on teams doing analysis, design, development, implementations, enhancements and testing of applications in these areas: Healthcare, Internal corporate Applications, Financial, Marketing and Sales.
TECHNICAL SKILLS
Languages: Python, R, SQL, SAS
Python Technologies: Pandas, NumPy, SciKit Learn, Matplotlib, Seaborn, TensorFlow, spaCy, NLTK, Selenium, BeautifulSoup4
Web Technologies: HTML5, AWS
Databases: SQL Server 2000/2005/2008/2012/2014 , MS Access, MySQL
Database Tools: SQL Server Management Studio (SSMS)
Scripting Languages: Java Script
Environment: s: Spyder, PyCharm, Jupyter Notebook
Operating Systems: MS Windows XP,7,8, 10, Vista, 2008, 2007, 2003, Linux
Reporting Tools: Tableau, SPSS
Project Management: Agile, Waterfall.
PROFESSIONAL EXPERIENCE
Confidential
Data Analyst
Responsibilities:
- Created queries in SQL - on-Hadoop environment that separated clients based into different buckets based on the regulatory rules set forth by the federal government.
- Converted control descriptions to assertions using Natural Language Processing packages like NLTK within Python.
- Created dashboards highlighting the nuances of different projects for leaderships using Tableau.
- Extracted data from the legacy system and loaded/integrated into another database through the ETL process.
- Analyzed raw data from clients to analyze the potential risks that the client could face from the regulatory perspective which aided the leadership to sell projects to the client.
Environment: s: Python, SQL, Advanced Excel
Confidential
Data Analyst
Responsibilities:
- Using Amazon Lambda Function was able to automate the need of the different stake holders within the company
- Created S3 buckets for storing information the type of information that was to be stored. Created a Python code specifically to analyze the age of information and then assigned the proper S3 bucket which resulted in effective cost reduction.
- As a team we streamlined four types of real-time management dashboards operational control dashboards, business process dashboards, collaborative dashboard, and business performance dashboard.
- Improved functional applications such as portfolio analysis, due diligence, transition planning, knowledge acquisition, guided support, reporting, risk/issue management, collaboration, tools and feedback.
Environment: s: Python, SQL, Plan View, Jira, Amazon S3, Amazon Lambda, Amazon
Confidential
Research Assistant
Responsibilities:
- Analyzed email exchanges during election using Python from Kaggle and calculated the sentiments of the emails. Developed word cloud to analyze the topics mainly spoken during the email exchanges.
- Became familiar in implementing machine learning and analyzed financial health of finance industry between 2011 and 2016 and traced the impact of the financial crisis and recession on the industry’s health by accessing balance sheet and income statement data items using Python and My SQL.
- Developed models to predict the price of Bitcoin based on the sentiment analysis from Twitter accessed data related to Bitcoin keyword.
- Made a twitter web scraper within Python using Selenium and BeautifulSoup4 for accessing tweets with a certain keyword. This web scraper did not use the Twitter API. MongoDB was used to store the information
- Presented reports on Boston Housing Data Project and I found out that clean air influenced the value of houses in Boston using historical data using Python.
Environment: s: ETL, My SQL, Python, MongoDB, Selenium, BeautifulSoup4
Confidential
Data Analyst
Responsibilities:
- Designed and analyzed the different interviews that were conducted with the customers of the company. The analysis was done using a quantitative approach. Analysis was mainly conducted on Python.
- Analyzed data of customers for a trucking company where the sales of the company were on a decline. After the analysis and execution based on data there was an increase of 15% revenue generation from that particular area.
- Improved database (My SQL), by introducing customer management system in addition to the employment resource management database.
- Presented my findings to the leadership within the company using Tableau. Using this visualization, the leadership made the appropriate strategic decisions as to how they were approaching the client.
Environment: s: ETL, Python, Tableau, My SQL
