We provide IT Staff Augmentation Services!

Sql Developer Resume

SUMMARY

  • Over 7 years of experience in IT environment with primary skill on the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and Business Intelligence suite.
  • Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2/2012.
  • Expertise in developing reports, packages and cubes in SQL Server 2005/2008/2008r2/2012 BIDS, SQL Server 2012 DATA TOOLS.
  • Experience in creating views, complex stored procedures, triggers, functions in T - SQL.
  • Experience in Configuring the Deployment Environment in PROD and QA for SSRS and SSIS.
  • SQL Server 2005/2008/2012 OLAP database development including Data mining, working with changing dimensions.
  • Good at ETL(SSIS), Data and Dimensional Modeling knowledge with experience in developing data movement, data cleansing and data integrity processes.
  • Developing reports in SSRS on SQL Server (2005/2008/2012).
  • Sound Experience and understanding of SSAS, OLAP cube and Architecture.
  • Report management, Report delivery andReport security.
  • Worked in Data modeling, creating star and snowflake schemas in SSAS.
  • Experience with ad hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
  • Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating Cross-Tab, Conditional, Drill-down, Top N, OLAP and Sub reports.
  • Experience in Application Design, Backups, Disaster Recovery Planning, Security Management, Managing server and clients, T-SQL, Stored Procedures, Functions, Cursors and Triggers etc.
  • Implemented Side by Side Migration of MS SQL SERVER 2005 to 2008/2008r2/2012.
  • Extensive experience in data migration between homogenous and heterogeneous system using various tools (DTS, SSIS, BCP, Bulk Insert, PDI).
  • Expert in SSIS Packages for OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) using transformations.
  • Experience in administrative activates comprising Performance Tuning, Query Optimization, Client/Server Connectivity, Indexing, Updating Statistics.
  • Experience in scheduling and deploying reports on report manager.
  • Experience in generating complex consolidated reports using Pentaho Reporting Development (PRD) tool.
  • Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
  • Strong experience in mentoring with team members, documentation and 24/7 on call production support.

Hire Now