We provide IT Staff Augmentation Services!

Sql Data Analyst Resume

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

Hire Now