Data AnalystIntern Resume

PROFESSIONAL SUMMARY

Over 6 years of professional experience as a Data analyst.
Manipulated and analyzed data in a variety formats (SQL, Excel and Tableau).
Used tools advanced Microsoft excel to create pivot tables, used V - LOOK UP and H-VLOOK UP and other Excel functions (INDEX/ MATCH).
Expertise in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive Dashboards with page and dashboard Prompts.
Expertise in designing and developing dashboards and data visualization using Tableau 10.5 (Desktop/Server) using data from multiple sources like Postgres, SQL Server, MySQL & PHP, and SSMS.
Created complex SQL Views and stored procedures join multiple tables for contract data interface files.
Developed SQL scripts to Insert/Update and Deletedatain MS SQL database tables.
Perform data manipulation, data analysis, reporting using Tableau and SSRS.
Experience in Large Data processing.
Used tools like SPSS and CSPro for data analysis and generating data reports.
Prepare data and information for making regular report data analysis.
Supplying Qualitative and Quantitative data to clients and agents.
Presented finding and data to team to priorities strategies and operations.
Database management, QA/QC monitoring data and analyses.

PROFESSIONAL EXPERIENCE

Confidential

Data AnalystIntern

Responsibilities:

Maintaining existing data and Created and maintained incident report logs.
Generated reports using Excel (Pivot Tables).
Generated ondataprofiling anddatavalidation to ensure the accuracy of thedatabetween theDatawarehouse and source systems.
Participated in Requirement gathering fordatamodeling purposes.
Worked closely with other members of the database group.

Data Analyst/ Developer

Confidential

Responsibilities:

Used SQL to perform data analysis and data validation.
DataAnalysis byDataMapping then worked with the design team in the designing of the databases byDataModeling,DataMigration, ReferenceDataAnalysis, and Data Conversion.
Developed, coordinated, documented, reviewed, and implemented standardized research study procedures.
Developeddatamodels for database structures.
Created and maintained research study and databases using MS Excel, and SQL.
Coordinated and performeddatacollection,datacoding,dataentry, queries,datacleaning (data cleansing),datamanagement,datastorage,databackup, anddataanalysis
Developed and prepared summary statistics, research reports, tables, charts, and graphs
Created Models by creating various joins between query subjects
Wrote complex SQL Queries in SQL server

TECHNICAL SKILLS

Database: PostgreSQL/Postgres, MySQL, Microsoft SQL Server, Oracle Database

Excel Analytics: VLOOKUP, HLOOKUP, INDEX/MATCH, CLEAN DATA, VISUALIZE and SUMMARIZE

SQL Analytics: Filtering & Aggregating, Querying Large Database, Creating multiple join relationships and Functions.

Business Intelligence Tool: Tableau 10.5.

Statistical Operations: SPSS, STATA.

Office Tools: Microsoft Word, Excel, Outlook, Access, PowerPoint

ARC: INFO/VIEW 9.2 GIS software