We provide IT Staff Augmentation Services!

Sql Server Developer And Data Analyst Internship Resume

3.50/5 (Submit Your Rating)

East Windsor, NJ

Hire Now

SUMMARY

  • Over 4 years experience in SQL Server Development and BI development.
  • Extensive experienced in managing large amount of data with table partitions, writing complex T - SQL queries and sub-queries to retrieve information from multiple tables with millions of rows and linked server.
  • Professional in creating indexes, stored procedures, user-defined functions, views, temp table, CTE and so on in SQL Server management studio.
  • Experienced in creating ETL packages and improve ETL performance to load large amount of data into data warehouses and performance large amount data extractions
  • Expert in using Microsoft Excel, Power BI tools like Power Pivot and Power View to analyze data with virtualization and create Pivot tables with KPIs, calculated columns, slicers, hierarchies and charts etc.
  • Excellent in creating reports and dashboards using Tableau and Qlikview to achieve data virtualizations.
  • Professional in using business analyst tools like Google Analytics, Hadoop Hive to extract data and analyze data.
  • Experienced in writing indexes, stored procedures, triggers, views, user-defined functions and complex T-SQL queries to retrieve information from tables with millions of rows.
  • Experienced in creating ETL packages to load large amount of data into data warehouses using lookup and conditional split transformation in SSIS 2008/2012.
  • Excellent in creating drilldown reports, drill-through reports, matrix reports, parameterized reports, graphical reports using SSRS 2008/2012 for advanced business analysis.
  • Proficient in creating, modifying, and managing relational databases, multidimensional databases, and data warehouse.
  • Excellent in designing multi-dimensional cubes using SSAS with fact table, dimensions and measures.

TECHNICAL SKILLS

  • T-SQL
  • SQL Server Management Studio (SSMS) 2008/2012
  • Microsoft SQL Server Integration Services (SSIS) 2008/2012
  • Microsoft SQL Server Reporting Services (SSRS) 2008/2012
  • Microsoft Server Analysis Services (SSAS) 2008/2012
  • Power Pivot 2013
  • Power View 2013
  • Tableau
  • Qlikview
  • Hadoop Hive
  • Google Analytics
  • DAX
  • MS Excel
  • MS Power Point
  • MS Word

PROFESSIONAL EXPERIENCE

Confidential, East Windsor, NJ

SQL Server Developer and Data Analyst internship

Responsibilities:

  • Involved in creating and optimizing employee information databases using SQL Server Management studio and generating business requirements.
  • Created stored procedures, clustered and non-clustered indexes. Wrote complex T-SQL queries such as sub-queries, temp table, CTE, to retrieve data from large tables with millions of rows.
  • Designed ETL processes to perform bulk insert and large amount data extractions using lookup transformation and conditional split transformation data using SSIS 2012.
  • Created drilldown, drill through, matrix reports with parameters and filters to display company employees’ information using SSRS 2012.
  • Created SSIS packages and use foreach loop container to load groups of flat files into SQL Server databases.
  • Created Power Pivot reports with slicers, hierarchies, measures, KPIs, charts on daily basis.
  • Created dashboard virtualizations using Tableau and Qlikview to read data in meaningful ways.
  • Built compelling Map-based Power View Reports including multiple visualizations.
  • Involved in designing data model, data warehouse structure and optimizing teh databases.

Confidential

SQL Server Developer and BI developer

Responsibilities:

  • Gathered requirements from business analysts, built customer information data model and data warehouse based on these requirements.
  • Created financial reports with various data virtualizations using Tableau and Qlikview.
  • Created table partitions, stored procedures, functions, indexes, views and modified existing code to produce accurate results for meaningful uses.
  • Created dynamic SSIS packages for data integration from Flat Files into SQL Server databases using Foreach Loop Container.
  • Created financial product reports and customer payments reports with drilldown, drill through, matrix, charts, virtualizations and parameters using SSRS 2012 and Tableau.
  • Used SSIS 2012 to create complex ETL processes involving variables and expressions for various control flow options and data flow transformations, such as Conditional Split, Derived Column, Lookup, Union All, Sort etc.
  • Created OLAP cubes by importing data from multidimensional databases and defining its dimensions, attributes, measures, calculations, and hierarchies using SSAS 2012.
  • Communicated with users, managers, and other resources in conceptualizing and developing reports and analytical tools that meet their needs
  • Created sales performance dashboard with filters using Tableau, Qlikview.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship