SQL Server SSIS/SSRS Developer Resume

SUMMARY

Over 2 years of IT experience in MS SQL Server (SSIS/SSRS/SSAS)
Good experience in supporting the different phases of project life cycle (SDLC) - Analysis, Design, Implementation, Testing, and debugging.
Experience in optimizing the database by creating various Clustered, Non-clustered Indexes, Data Modeling, Normalization and building Referential Integrity Constraints.
Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modelling.
Strong in SQL Query Tuning, Database Triggers, Stored Procedures, reducing time for night batch jobs by reviewing SQL code, modifying database query.
Expertise in writing SSIS Template Package using - Configuration, Logging, Error Reporting and Variables in SQL Server Integration Services to make package portable which Deployment and Troubleshooting.
Worked on MSBI (SSRS) in developing the reports such as Data Bar Reports, Drilldown Reports, Dashboard Reports, Map Reports, and Pie Chart Reports, Parameterized reports.
Knowledge in Tableau Desktop, Tableau Reader, and Tableau Server worked on multiple version of Tableau 7/8/9.0
An Enthusiastic and goal oriented team player with excellent analytical, communication and interpersonal skills and proficient in technical writing and presentations.
Very good track record of communication, analytical, interpersonal, presentation skills and Team skills combined with self-motivation, initiative and the ability to think outside the box

TECHNICAL SKILLS

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Tableau Desktop 9/8.X/7.X, Tableau Server, Tableau Reader.

Database: SQl Server 2014,2012,2008, MS Accesses, Oracle

Tools: & Packages: SQL Server Management studio, Profiler, Business Intelligence Development studio (BIDS), ETL, Visual Studio .NET,SAP

Programming Languages: T-SQL, PL/SQL, HTML, C, C++, Core Java, ASP.Net, VB.Net

Operating Systems: Windows XP/Windows 7, Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential

SQL Server SSIS/SSRS Developer

Responsibilities:

Written complex T-SQL queries and created Stored Procedures, Triggers, functions and Views.
Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables.
Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join, script component and Slowly changing dimension.
Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services (SSIS).
Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
Developed custom reports and deployed them on server using SSRS.
Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.

Environment: MS SQL Server 2012,2008, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, Visual Studio 2008, Windows XP

Confidential

Database Developer

Responsibilities:

Created tables, views, indexes based on the requirements
Wrote complex SQL queries to retrieve information from the databases depending on the requirement.
Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
Create T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables
Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS.

Environment: MS SQL Server 2008, T-SQL, SQL Windows Server 2008, and MS Access and Excel.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship