SQL Developer Resume

SUMMARY:

Microsoft Certified Professional SQL server developer (MCPS) with two years of IT
Experience in Database and Business Intelligence technologies with expertise on ETL process and Reporting using SQL Server, SSIS and SSRS.
MCPS: Microsoft Certified Professional
MS SQL Server 2012 Integration Services (SSIS)
MS SQL Server 2012 Reporting Services (SSRS)
Expertise in writing T - SQL statements (SSMS), Stored Procedures, CTEs, User defined functions,triggers and Views, providing efficient data retrieval and manipulation and ensuring data consistency.
Experience in providing Logging and Error handling for SSIS Packages.
Microsoft Visual Studio.
Agile methodology & entire SDLC, database design.
Reports & Packages troubleshooting.

WORK EXPERIENCE:

Confidential

SQL Developer

Responsibilities:

Implemented ETL business intelligence solutions to consolidate data from different sources into SQL Server database using SSIS, worked with different types of files (Excel Files, Text files and XML files).
Created SSIS Packages using Transformation in control flow and data flow such as Derived Columns, Conditional Split, Script Task, Lookup, Execute SQL Task, merge join, multicast, etc., to develop ETL solutions and load Data into staging databases.
Developed business intelligence dashboards (sub-reports, parameterized, drill-down and drill through reports) using SSRS. Used gauges, charts, matrices etc., with complex Stored Procedures as data sets.
Created and maintained database objects like Joins, Stored Procedures, CTEs, UDFs, Triggers and Views.
Documented all database objects, procedures, views, functions & packages for future references.
Worked with and without BA. Prepared Business requirement documents BRDs.

Confidential

Project Manager

Responsibilities:

Started my career as a project manager for many construction projects with many civil engineering tasks.
Had the opportunity to use MS SQL Server with some basic SQL tasks until I decided to get certified and change my career to be SQL BI developer.