Data Analyst Resume
5.00/5 (Submit Your Rating)
BaltimorE
SKILLS:
Programming Languages: Python, R, SQL, VBA, SQL
Business Intelligence Tools: MicroStrategy, Tableau, Power BI, MS Excel, Pivot tables, QlikView, SSRS
Other Tools: MYSQL, HP ALM, SharePoint, PowerPoint, Jira, Microsoft Access, Microsoft Office, GitHub, Jenkins
Certifications: Python 101 for Data Science (IBM Initiative)
Others: AWS, Scikit - learn, NumPy, Pandas, Jupyter, Matplotlib, SSIS, SSAS, ETL, OLAP, Postman (API test)
PROFESSIONAL EXPERIENCE:
Confidential, Baltimore
Data Analyst
Responsibilities:
- Gained a 52% - time improvement through automating the retrieval of AWS resource Cost and Usage reports by querying AWS APIs in Python, performed ETL development Data modelling in the MySQL RDBMS
- Developed a generic JSON to CSV in Python for building the AWS API responses into usage reports
- Identified key metrics and build Tableau Dashboards to monitor and visualize AWS cost and usage that led to insights in optimizing cloud usage and eventually a 22% smaller usage cost
- Developed and manage roll outs schedules, implementation plans and activities for and across all functional groups involved in the release and work across functional groups involved in the release.
Confidential, Baltimore
Data Scientist
Responsibilities:
- Developed a Predictive Model to foresee the need for maintenance of a Wind Turbine using Linear, Logistic Regression, SVM, Decision Trees in Python, the model proposal won a research funding of $400,000 from Siemens AG company
- Developed dashboards in MicroStrategy to visualize wind turbine data and generated insights
- Led a team of 5, conducted meetings, discussions on analytics for business insights with Wind energy Siemens Team
Confidential
Consultant - Data Analyst
Responsibilities:
- Performed data analysis on South West Airlines dataset containing five years of transportation orders with Tableau to identify main profit regions that led to a combined increase in business turnover by $11,30,000
- Analyzed business requirements, developed and executed test cases, use case, user stories, conducted QA testing and involved in writing technical specifications for Farmers Insurance project.
- Developed and constructed ad-hoc reports, dashboards, stories, stack bars, bar graphs, scattered plots, geographical charts in Tableau and Power BI
- Applied technical skills using SAS, Tableau and SQL in data collection, data analysis and reporting to procure data from database structures to report and provide solutions to client requests in a timely manner
- Involved in Regression testing, ad hoc and UAT support cycle’s execution and defects logging and reporting
- Worked with stakeholders and experience operating in SDLC environment and deploying code