We provide IT Staff Augmentation Services!

Data Analyst Intern Resume

Charlotte, NC

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

Hire Now