data analyst resume example with 4+ years of experience
JessicaClaire
, , 609 Johnson Ave., 49204, Tulsa, OK100 Montgomery St. 10th Floor
H: (555) 432-1000
C:
resumesample@example.com
Date of Birth:
India:
:
single:
:
LinkedIn Profile
http://linkedin.com/in/lydia-Claire-1a9662157
Summary
Meticulous Data Analyst with 3 years of experience driving business success. Proven ability to gather and analyze requirements and translate needs to project teams. Dedicated to continuing professional growth through training.
Skills
Structured query language (SQL)
Database management
Transact SQL, MySQL, familiar with NoSQL
ETL tools (SSIS, SAP), MS Office
Tableau, Google data studio, Power BI
Data quality, SQL reporting
Fluent in Python, familiar with Java, C#
Data Structures, algorithms, statistics
Azure, Git, GitHub
Waterfall, Agile development methodologies
Cross-functional teamwork, Team management, Multitasking
Software Development Life Cycle (SDLC)
Experience
Data Analyst, 05/2021 - Current Lockton – Portland, OR,
Use SSIS to create packages, data flows and control flows; Use SSRS for creating reports
Extract, transform and load data to destination tables using SSIS, SSMS, C#. Write Excel formulas, use VLOOKUP’s, Pivot Tables and other functionalities
Create complex T-SQL queries, views and stored procedures for the data migration purpose and work on optimization of the queries for better performance.
Prepare forecasts and identified trends through data analysis and tracking. Collect, track and organize data to evaluate current business and market trends.
Complete quality assurance reviews to assess accuracy of data and validate results. Maintain security and data integrity of databases. Collaborate cross-functionally with business analysts, developers and testers to explain new process transformations.
Assist in the operations, analysis and monitoring of the regulatory reporting cycle
Involved in research, writing specifications and prototyping for the development of new functionalities on OTCFin's reporting platform
Graduate Research Assistant, 09/2019 - 04/2020 Partners Healthcare System – Needham, MA,
Designed and developed business rules for online data collection from system
Performing and shaping data integration from different sources in the university to a native repository, analyzing the integrated university data and visualizing in tableau
Assisted in writing review articles and research papers in Microsoft office for various pharmacy-related areas such as oral assessments
Prepared graphs, pie charts, and tables in excel sheets for the survey results. Created and maintained ad hoc reports. Revitalized technical support to the students.
Data Analyst, 10/2016 - 10/2018 Lockton – Tampa, FL,
Involved in understanding of data extraction, involving Online Transfer Processing (OLTP) system and centralized database server
Worked to Identify, analyze and interpret trends or patterns in complex data sets
Learned problem solving skills, statistical skills, worked with cross functional teams and took independent responsibility of projects
Contributed to development of projects using Python and Java
Created database using MySQL, wrote several queries to extract data from database, executed quality control checks in the form of SQL queries to ensure data integrity and enforce business rules.
Education
Master of Science: Computer and Information Science, Expected in 12/2020 - Texas A&M University - Kingsville, TX, GPA: Status -
Completed coursework in Database Management Systems, Operating Systems, Cloud Computing and Programming Languages. 3.91 GPA
Bachelor of Technology: Computer Science, Expected in 06/2018 - Osmania University - Hyderabad, Telangana, GPA: Status -
Completed coursework in Computer Architecture, Data Structures, Principles of Programming Languages, Design and Analysis of Algorithms
Software Projects
School Report Dashboard (2021) – Created a dashboard for student reports and class reports using student data in Google Data Studio (https://datastudio.google.com/reporting/e5a20da9-0c2c-453b-b19b-e991cd5afd1f)
My website (2020) - Implemented a small website, with the use of Heroku deployed it. Utilized: Python, Flask, HTML, CSS (https://lydia07.herokuapp.com/)
Interactive Data Visualization (2020) - Implemented a Data Visualization of the student’s data to test and analyze the growth of students in different departments during the past year. Used python built in library bokeh, which is used for interactive data visualization. Utilized: Python, Bokeh (https://github.com/lydiaClaire7/Interactive-Data-Visualization)
Bookstore Database Desktop Application (2020) - Implemented a desktop application for storing information about the bookstore. Used tkinter for implementation of the user interface. Utilized: Python, Sqlite3 (https://github.com/lydiaClaire7/BookShopApplication)
K-Rail fence cipher (2020) - Implemented K- Rail fence cipher which is a transposition cipher that jumbles up the order of the letters of a message using a basic algorithm. Utilized: Python (https://github.com/lydiaClaire7/K-Rail_Fence_Cipher)
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.