Sql Server Data

PROFESSIONAL SUMMARY

Over * years of in-depth experience in database design, development, administration and maintenance of SQL Server 2014/2012/2008/2008R2 large scale databases.

Extensive experience in Microsoft stack of BI solutions - SSAS, SSIS, SSRS with MS SQL 2012/2008/2005.

Expert level skill in creation of database objects such as Tables, Views, Indexes, DDL/DML Triggers, User Defined Data Types, User Defined Functions, User Profiles, Data Dictionaries, Table Normalization and Data Integrity.

Proficiency in writing complex T-SQL queries, subqueries, joins & Stored Procedures.

Excellent experience in designing, maintaining and tuning RDBMS especially MS SQL Server.

Highly experienced in Performance Tuning and Optimization of complex SQL queries.

Skills in creating & monitoring SQL Server Jobs, Alerts and SQL Mail Agent.

Extensive experience in Enterprise ETL process using SSIS

Created different SSIS Packages & implemented various debugging & troubleshooting tools like Precedence constraint, Data Viewer, Breakpoints, Checkpoints, Event Handling, Logging, Error Output & Transactions.

Experience in extraction & migration of Data from heterogeneous data sources like Flat File, Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS, SSIS, BCP & Bulk Insert utilities.

Experience in Transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Data conversion, Lookup, For Each Loop, Merge Join, Sort and Derived Column.

Strong Knowledge in Enhancing and Deploying the SSIS Packages from Development Server to Production Server.

Used change data capture (CDC) control task that makes efficient data loading (incremental load after initial loading of data).

Proficiency in creating different types of Reports such as Cross-Tab, Drill-down, Drill Through, Summary, Parameterized, Sub reports and formatting them using SSRS.

Skills in creating Customs Reporting Templets, Dashboards & Visualization using SSRS, Excel & Power BI.

Experience in managing report server & report subscription.

Experience in configuration of Reporting Services & launching Report Builder for ad hoc reports.

Designed and Built Multidimensional Cubes with a Star & Snowflakes schema using SQL Server Analysis Services (SSAS).

Migrated DTS packages, reports and Cubes from SQL Server 2000/2008/2012 to SQL Server 2005/2008/2012/2014.

Complete knowledge in optimization tools such as Database Engine Tuning Adviser, SQL Server Profiler, Execution Plan and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.

Skills in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures.

Experience in data cleansing activities using Data Quality Services (MS DQS).

Good operating knowledge in third party tools such as NetBackup, Lite Speed Pervasive ETL, SQL Assistant ERWIN, Red-Gate and Spotlight.

Worked closely with development and Technical Support team to resolve quality issues.

An excellent team player & technically strong person who has capability to work with business users, project managers, team leads and architects, thus maintaining healthy environment in the project.

24x7 Production Database on Call Support.

TOOLS AND TECHNOLOGY

RDBMS: SQL Server 2005/ 2008/2008R2/ 2012/2014, DB2

Database Tools: SSIS, SSAS, SSRS

Reporting: SQL Server Reporting Services (SSRS), Report Builder, MS Excel & Power BI

Languages: VB.NET, C#, C++, T-SQL, E-SQL

MS-Office: Microsoft Office Tools

Operating Systems: Windows Server 2000, 2003, 2008, 2008R2, 2012

Tools: Backup Utility, Lite Speed for SQL Server, Visio

PROFESSIONAL EXPERIENCE

Client: T Rowe Price, Owings Mills, MD 03/2016- Present

Role: SQL Developer

Developed new database/database objects and maintained existing database environment.

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code to implement business rules.

Created SSIS Packages to load data into Data Warehouse using Data Flow Task, Execute SQL Task, Bulk Insert Task, File System Task, Send Mail Task, Script task, Data Profiling Task and various transformations.

Improved Performance and Optimized T-SQL statements by creating Clustered and Non-Clustered Indexes by using Database Engine Tuning Advisor & SQL profiler.

Performed Transformation of data using various SSIS built-in tools like Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Fuzzy Look Up, Fuzzy Grouping Pivot & Row Sampling.

Performed Incremental load with several Data Flow Tasks and Control Flow Tasks using SSIS.

Performed the physical database analysis and feasibility requirements. This involves the performance, security, archival, maintenance, and recovery requirements.

Wrote VB.NET code for Script task to perform functions that are not available in the built-in tasks and transformations that SSIS provides.

Run Import/Export wizard to provide Excel Format reports to Managers.

Created Views and Indexed views to reduce database complexities for the end users.

Deployed, Tested and Scheduled SSIS packages.

Transferred data from enterprise data warehouse to data mart.

Monitored SQL Server agent jobs using Job Activity Monitor.

Worked with Application Developers to design databases and database objects to support development activities and achieve optimal efficiency.

Optimizing performances of long running queries and Stored Procedures using SQL Profiler, Database Engine Tuning Advisor and Execution Plan.

Undertaking data cleansing activity by removing redundant and inconsistent data.

Integrated SSIS packages with the windows batch to trigger the package.

Environment: SQL Server 2005/2008/ R2/2012/2014, BIDS, Visual Studio 2013/2010, T-SQL, Autosys, MS Access, MS- Excel, SSIS, SSRS, SSAS,Windows Server 2008R2

Client: Ethiopia Commodity Exchange 07/2010- 01/2016

Role: Database Developer (MS SQL)

Worked with users and development staff to assess & determine requirements to the BI solution.

Performed T-SQL performance tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008/2012.

Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them

Extracted data from heterogeneous sources and transferred to OLAP using SSIS 2012

Involved in automating SSIS Packages using SQL Server Agent Jobs and configured various event driven e-mail notification process in SSIS packages.

Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.

Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)

Developed different kinds of reports such a Sub Reports, Charts, Matrix reports, Linked reports.

Used cascaded parameters to generate a report from two different data sets.

Created Ad-Hoc Reports, Summary Reports, Sub Reports, Drill-down & Drill-Through Reports using SSRS

Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).

Created Alerts for successful or unsuccessful completion of scheduled Jobs.

Created various SQL Server jobs and monitored them using Job Activity monitor.

Deployed SSRS report to SharePoint and Report Server Web Service.

Configured report server and report manager for SSRS report deployment and management.

Created Report Subscription using Data Driven and Time Driven Report Subscriptions.

Designed SSAS cube for different business segment and created Calculated Measures using MDX and tuned Cubes for better performance by deleting unused aggregations by using Usage Based Optimization tool in SSAS.

Involved in Creation of a Knowledge Base for DQS and performed data cleansing activities by modifying incorrect & invalid data.

Rebuilding/Reorganize indexes and running Database Consistency Check Commands (DBCC).

Responsible for problem identification, troubleshooting, performance tuning and index tuning.

Implemented and supported Quest spotlight application and the backend SQL database to monitored the overall I/O activity of the SQL server

Routinely checked the SQL server error logs for failed or aborted overnight jobs.

Monitored growth of database objects for capacity planning.

Maintained full backup, differential backup and transaction log backup regularly.

Collaborated with network operators, application developers, and DBAs to enhance end user experience.

Environment: SQL Server 2005/2008/ R2/2012, BIDS, Visual Studio 2012/2010/2008, T-SQL, MS Access, MS- Excel, SSIS, SSRS, SSAS, Report Builder 2.0/3.0 & Power BI

Education

Masters

Training

Microsoft SQL Server 2005, 2008, 2008R 2& 2012

Microsoft Office™ tools (Word™, Excel™, Access TM and PowerPoint).

Dimension Modelling

Reference

Available upon request

Contact this candidate