SQL/BI developer Resume

SUMMARY:

6+ years experience in Database Design, Development and maintenance of database applications on SQL Server 2000/2005/2008/2008 R2 in BI environment and Web Development.
Expert in creation of Databases objects, Stored procedures, Triggers, Views, User Defined Functions, security, DTS, SSIS, SSRS, BCP, T - SQL, Backups, Recovery, and SQL Server Agent, SQL server profiler using SQL SERVER.
Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2008/2012/2014.
Excellent knowledge of Normalization/De-Normalization, Data Design methodology and build Referential Integrity across multiple tables.
Experience in Database Backup, Recovery and Disaster Recovery procedures.
Experience in involving in SQL DBA activities
4+ years in designing, developing and testing software using C# and ASP.NET.
Diverse range of experience in other programming languages: .NET, JavaScript, SQL, ASP.NET, LINQ to XML, PHP, CSS3, HTML5, AJAX, JAVA, C#, C and batch files

TECHNICAL SKILLS:

Databases: SQL Server 2005/2008/2012 (Stored Procedures, Functions, SSRS,SSIS, SSAS, Triggers & Indexes, Design and Development).

Programming: T-SQL, PL/SQL, C#, ASP.NET, Visual Basic 6.0, VB .NETOperating System: Windows 2012/2008 R2 Advanced Server, NT & Windows 9x, Linux

Database Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio .NET 2015/2013/2010, SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), ODBC, OLAP, OLTP, DBCC, BCP

PROFESSIONAL EXPERIENCE:

Confidential

SQL/BI developer

Responsibilities:

Generated matrix reports, drill down, drill through, multi parameterized reports using SSRS.
Using SSRS created well-formed web-based reports
Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets and OLEDB Sources.
Develop views, sub-queries and joins for complex queries involving multiple tables Created joins and sub-queries for complex queries involving multiple tables.
Involved in Creation of database, tables and procedures to update and clean the old data.
Test and evaluates report’s performance and implements necessary solution.
Scheduled and maintained nightly and weekly loads of data by creating the corresponding job task by using Scheduled Jobs and Alerts using SQL Server Agent.
Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
Responsible for Database and Log Backups and Restoration, Backup Strategies and Scheduling Backups
Have used BCP, BULK INSERT to transfer data from and to SQL server database

Environment: MS SQL SERVER 2008 R2, SQL Server 2012, MS SQL Server 2005/2008, SSIS, SSRS, Microsoft Visual Studio 2008, SQL Profiler, Microsoft Visio, MS Office 2003,Excel 2003, Windows NT/2003.

SQL Developer

Confidential

Responsibilities:

Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
Implemented Triggers for checking complex business conditions, providing security for the tables.
Physical Implementation of database into SQL Server 2008 using T-SQL.
Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
Created check constraints to maintain data integrity.
Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
Data migration (import & export/BCP) from Text to SQL Server.
Configured Replication Server.
Worked on a Terabytes of Data.
Planned complete Back-up of Database and Restored the Database from Disaster Recovery.
Generating ad-hoc reports using MS-Excel and Crystal Reports.

Environment: SQL Server 2008/2012, T-SQL, Excel, Access and Windows NT.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship