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.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship