Data Analyst Intern Resume Charlotte, NC - Hire IT People

CORE TECHNICAL SKILLS:

Tools: and Statistics - VISIO, Tableau, Informatica, SSIS, SSRS, Autosys, Base SAS, Regression, Classification, Clustering

Programming languages: C++, python, Unix Shell Scripting, Perl, SQL, PL/SQL, Java, Hibernate

Database and Processing: OLAP, OLTP, T-SQL, Dimensional Data Modelling, Oracle 11g, MySQL, MS SQL Server, Filemaker

PROFESSIONAL EXPERIENCE:

Data Analyst Intern

Confidential, Charlotte, NC

Responsibilities:

Developed T-SQL queries for data-analysis and data extract knowledge of joins and understanding database landscape
Designed and built scripts to migrate data from mainframe into MySQL server tables enabling savings of $50,000
Conceptualized and built interactive reports and dashboards from multiple data sources in public domain using Tableau
Restructured reporting process with SQL Server Reporting Service enabling business rely on it to make critical decisions
Automated the pre-and post-data retention process that enabled savings of 40 hours per week
Configured and managed various version control systems including tools like CVS, GIT and Source Tree

Data Analyst

Confidential

Responsibilities:

Migrated a desktop application into online application (Ad*views online) that includes modules for tracking spending data and automating the data process right from the requirement till testing phase
Expertise in writing SQL Queries, dynamic-queries, sub-queries and complex joins for generating complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors
Managed optimization of SQL queries with join, indexes using SQL Analyzer to improve the performance time
Created SSIS Reusable Packages to extract data from staging tables, Multi formatted Flat files, Excel, XML files into partitioned tables in the Database with incremental load
Developed Packages using SSIS Designer for export data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server and performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server
Developed operational Drill-through and Drill-down reports with complex formulas using SQL Server Reporting Services
Designed different kind of reports such a Sub Reports, Charts, Matrix reports, linked reports using SSRS
Involved in Extraction, Transformation and Loading (ETL) data from various heterogeneous sources into target Data Warehouses and Data Marts using Informatica power center
Designed and developed a tool to verify post migration data using MySQL and shell script generating end user reports
Streamlined timely Loading of Data of a star schema using Informatica Mappings and Reusable Transformations
Developed Informatica Mappings by usage of Aggregator, Sequence Generator, Update Strategy, Joiner, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router
Experienced with VLookup and created pivot tables and charts using worksheet data, sorted items and group data
Experienced in all stages of the SDLC (software development lifecycle) and Object Oriented Analysis and Design utilizing project life cycles such as Agile/SCRUM methodology, Waterfall methodology

We provide IT Staff Augmentation Services!

Data Analyst Intern Resume

Charlotte, NC

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship