Data Analyst Resume Example Company Name

DATA ANALYST

Summary

Software Engineer with over 5 years of professional IT experience in Application Development and Support.

My core competencies include:

Experienced in application development using python, django and web technologies (HTML, CSS and Javascript) to create scalable and robust common components which can be used across the whole framework.
Experience in developing complex SQL queries, stored procedures, triggers, cursors, functions and packages on database.
Proficient in object oriented programming (OOP) concepts using python and Linux.
Writing and developing scripts for automation tasks using python and shell scripting.
Experience in project deployment using Jenkins and Amazon web services.
Experience in Production Support, Disaster Recovery Activities, and Auditing.

Skills

Experience

Data AnalystCompany Name | City, State | Mar 2021-Current

Collaborated with database engineers to implement ETL process, wrote and optimized SQL queries to perform data extraction and merging from SQL server database.
Exported/Imported data between different data sources using squirrel sql client.
Create and execute various SQL queries, stored procedures to fetch data for analysis.
Work in Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source system which include loading nested JSON formatted data into snowflake table.
Realistic understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling.

Data AnalystCompany Name | City, State | Aug 2020-Feb 2021

Designed and developed automation tool using python to compare the data in two individual excel sheets.
Used SQL Server as a backend database for storing the records.
Created RESTful APIs with python flask to create a Data Access layer for web applications.
Created dashboards using Splunk to monitor and analyze logs generated in server for visualizing outage information.
Used pytest testing framework to write the test case for the modularized code.
Worked in an SCRUM environment: used JIRA for project management.

Systems EngineerCompany Name | City, State | Feb 2013-Jun 2017

Worked on creating automation scripts for redundant tasks (analyzing excel reports, system admin activities) performed across the internal verticals using Python, Django framework, and Python MySQL connector.
Supporting business critical applications with stringent SLAs.
Executed various MYSQL database queries, stored procedures to perform CRUD operations.
Performed troubleshooting, fixed and deployed many Python bug fixes.
Trained extensively in Agile methodologies and implemented by participating in scrum standups.
Experience in working with the SME team to gather the requirements.

Junior Java DeveloperCompany Name | City, State | Jun 2012-Jan 2013

Involved in Software Development Life Cycle (SDLC) of the application, requirement gathering, and design analysis and code development.
Designed and developed user interfaces using JSP, CSS and implemented Ajax/JQuery for Asynchronous Retrieval of data.
Used Java Script for client side validation and scripting functions.
Implemented Struts framework based on the Model View Controller design paradigm.
Designed and developed business components using Session and Entity Beans in EJB.
Worked on triggers and stored procedures on Oracle database.
Coordinated with the testing team for timely release of product.
Application was deployed on WebSphere Application Server.

Education

Master of Science: Management Information SystemsWilmington University | | City | May 2020

Bachelor of Technology: Electronics and Communications EngineeringJawaharlal Nehru Technological University | May 2012

Academic Projects

Developed an application in python to recognize the handwritten numbers in Spyder IDE.
Built a database for a grocery delivery business model using MySQL. The model is feasible to fetch the tables using MySQL queries.
Analyzed data across multiple sources and prepared a report on current job trends in the USA. Represented the data using Tableau

Resume Overview

School Attended

Job Titles Held:

Degrees

Master of Science : Management Information Systems
Bachelor of Technology : Electronics and Communications Engineering