Sql Data Analyst Resume
2.00/5 (Submit Your Rating)
SUMMARY
- Data enthusiast passionate about discovering what can be uncovered from large datasets. Persistent learner who loves encountering new challenges and stays calm under pressure. Capable in creating visual representations of data in Tableau to convey conclusions and present them to an audience.
TECHNICAL SKILLS
Languages: Python, SQL, VBA, Unix
Libraries: Pandas, NumPy, Matplotlib, Seaborn, Scikit - learn
Database: SQL Server, MySQL, SQLAlchemy, MongoDB, SQLite, Access, SSIS
Other: GitHub, Excel, MS Office, Flask, Tableau
PROFESSIONAL EXPERIENCE
SQL Data Analyst
Confidential
Responsibilities:
- Create processes to extract data from our database, format it to the client’s specifications, and load it to an output file which the client can access on an FTP site
- Build reusable stored procedures to update tables and return outputs
- Maintain, debug, and fix PowerShell and SQL scripts
Product Master Data Specialist
Confidential
Responsibilities:
- Improved process for creating records of new products by upgrading a system using Access to one that uses SQL, saving over two hours of working time daily
- Designed and built the system used to track requests from other departments to change product data and advised the QlikView team how to display these metrics in a report
- Built an ETL process using SSIS to report inconsistencies in the data, automate the process for getting approval and create load files to correct the data in SAP
- Created and ran SQL scripts to complete Ad Hoc requests
Data Science and Visualization Tutor
Confidential
Responsibilities:
- Instructed students how to code with 1:1 online support sessions
- Focus areas include: Python, Pandas, Matplotlib, SQL and GitHub