We provide IT Staff Augmentation Services!

Sql/ Bi Developer Intern Resume

4.00/5 (Submit Your Rating)

Austin, TX

Hire Now

SUMMARY

  • Strong experience in the use of T - SQL and PL/SQL for developing complex Stored Procedures, I ndexes, T ables, V iews, User defined F unctions, J oins, Triggers and C ursors in SQL Server Management Studio.
  • Hands on experience on Data conversion, Data modeling, Normalization and SQL Server Enterprise manager.
  • Hands on experience o n C reating, M aintaining and C onfiguring SSIS packages.
  • Involved working with heterogeneous data source like Excel, Flat file, Oracle, DB2, and SQL Server Management Studio.
  • Strong experience in Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Experience in supporting Microsoft Azure systems including SQL Server hosted on Azure Virtual Machine and Azure SQL Databases(DBaaS)
  • Experience in Performance Tuning, Database Engine Tuni ng Advisor, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
  • Highly proficient in creating and implementing SSIS solutions for ETL and Business Intelligence process for Data Integration and Migration services
  • Ex cellen t SQL development skills in developing data-intensive solutions against an RDBMS, such as SQL Server, Postgres or Oracle.
  • Expe rience in operating on in an Agile scrum environment
  • Hands on experience on Database Backup, Recovery and applied necessary SQL Server database Service packs, hot fixes and Security Patches.
  • Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into an environment and working well under pressure.
  • Authorized to work in United States for any employer

TECHNICAL SKILLS

Operating systems: Windows XP/7/10, Windows Server 2016/12/08, UNIX/LINUX

Databases: SQL Server 2016/14/12, MS Access 2000/8.0

Terradata: 14.0, DB2

Languages: T-SQL, MDX, DAX, XML, MYSQL, HTML

ETL and Reporting tools: SSDT 2016/14/12, BIDS 2008R2/08, SQL Server Integration Services 2016/2014/2012/2008 R2), SQL Server Reporting Services (SSRS 2016/2014/2012 /2008 R2), PowerBI, SQL Server Analysis Services

Others: MS Office, Crystal Reports XI, Visio, Service Oriented Architecture (SOA), Azure, SQL Server Notification Services, Visual web developer, MS FrontPage, Windows Scripting Host, Erwin Data Modeler, MS Visual, SAS/Access, SAP Business Objects, Micro Strategy, ER-Studio, Microsoft TFS, Microsoft GIT, HP Quality Center, LAN/WAN, TCP/IP, VPN, hubs, switches, routers, firewalls.

PROFESSIONAL EXPERIENCE

Confidential - Austin, TX

SQL/ BI developer intern

Responsibilities:

  • Created ETL Packages using SSIS for extracting, cleaning, transforming and loading data from Staging tables to partitioned tables with incremental load.
  • Developed, deployed, and monitored SSIS Packages.
  • Implemented data validation by using T-SQL queries to confirm that SSRS reports data results that are being returned are correct.
  • Created packages using the various control flow tasks such as Data Flow Task, Execute SQL Task, Execute Package Task, File System Task.
  • Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer.
  • Participated in design discussions with Database architects and Application architects.
  • Designed the Data warehouse and done the mappings from Source to the Target tables.
  • Developed SSIS packages to extract, transform and load data from Oracle and SQL Server databases into Data Warehouse.
  • Identified the dimension, fact tables and designed the Data-Mart using Star schema.
  • Created Indexes for faster data retrieval from the database.
  • Wrote Stored Procedures and Functions for better performance and flexibility.
  • Deployed SSIS packages into various Environments (Dev, UAT and Prod) using Deployment Utility.
  • Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
  • Created and Designed Data Source and Data Source Views and configured OLAP Cubes (Star and SnowFlake Schema) using SSAS.
  • Worked as a developer in the process of creating reports from OLAP, sub reports, bar charts and matrix reports using SSRS.
  • Collaborated with data engineering team in the creation of reusable components as they relate to the Azure data management frameworks.
  • Reporting to the IT Director, Chief Executive, having excellent time management, confidentiality and communication skills.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship