SUMMARY:

• 6+ years of experience working as a SQL Server/Business Intelligence Developer. Highly experienced in requirements gathering, design, development, testing, deployment, and maintenance of SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) projects.
• Expert knowledge in developing multidimensional databases using SQL Server Analysis Services (SSAS). Excellent knowledge in creating and configuring OLAP Cubes, and working with Star/Snowflake schemas, creating custom hierarchies, and building attribute relationships for optimal query performance.
• Extensive experience in developing various types of reports using SSRS, including Tabular reports, Matrix reports, drill down reports, drill through reports, parameterized reports, and subreports.
• Excellent experience in deploying and managing SSRS reports, setting custom processing properties, and assigning report - level or item-level security as required.
• Hands on experience in creating Cached instances of reports, as well as creating Report Snapshots after the report is deployed to a report server.
• Experienced in creating Email subscriptions and Windows File Share subscriptions for on-demand report distributions.
• Excellent experience in extracting, transforming, and loading data using SQL Server Integrations Services (SSIS). Experienced in creating complex SSIS packages using various control and data flow elements.
• Extensive experience in migrating data from various sources such as Excel, Flat Files, and MS Access databases to different destinations using SSIS.
• Experienced in using SSIS functionalities like error handling, logging, and working with package configuration files.
• Excellent experience in T-SQL programming. Hands on experience in creating stored procedures, Triggers, User Defined Functions, and writing complex queries using T-SQL.
• Extensive experience in developing Data Definition Language (DDL) and Data Manipulation Language (DML) queries using T-SQL.
• Diligent, reliable, result oriented, and with an ability to multi-task and meet deadlines.
• Highly motivated with excellent interpersonal, communication, and leadership skills.

TECHNICAL SKILLS:

Languages: T-SQL, C#, VB.

Web Technologies: ASP.NET, ASP, ADO.NET, HTML, CSS.

Environment: s/Tools: SQL Server Business Intelligence Studio (BIDS), SQL Server Data Tools (SSDT), Visual Studio 2005/2008/2010/2012, .NET Framework 2.0/3.5/4.0/4.5, Tableau, Power BI.

RDBMS: SQL Server 2005/2008/2008 R2/2012/2014, MS Access.

PROFESSIONAL EXPERIENCE:

Confidential, Sterling, VA

SSRS/SSIS Developer

Responsibilities:

• Responsible for the development, testing, and deployment of executive reports using SSRS.
• Worked directly with clients to gather requirements and to design report projects accordingly. Developed various types of SSRS reports according to the clients' requirements. These include Tabular reports, Charts, Matrix reports, Parameterized reports, and Drill-through reports.
• Involved in projects to automatically update reporting databases by extracting data from various data sources, transforming the data as required, and loading the output periodically to the destination tables. Used SSIS to accomplish these tasks.
• Responsible for the management and maintenance of reports after deployment to the report server. Assigned roles to users based on the access level required for each report.
• Created executive dashboards for grouping similar reports to make it easier for users to find related information in the same location.
• Created linked reports, as required, to limit user access to the pre-specified scope for data security.
• Provided reports to users in the required formats through email subscriptions on pre-defined schedules.
• Designed and developed complex stored procedures that use different SQL Server functions necessary to support SSRS reports.
• Designed SSIS packages for extracting and transferring data between SQL Server databases and sources like Excel, CSV, XML, and flat files by using the various transformation options provided by SSIS.
• Implemented logging mechanisms in SSIS packages to analyzed the execution of tasks and to troubleshoot the packages in case of execution failure. Used variables and expressions to save the log files in custom folders.
• Created SQL Server jobs for running SSIS packages to automate the process of updating databases within specific schedules.
• Created web applications using ASP.NET platform that supports the integration of SSRS reports for display within web portals.

BI/SSRS Developer

Responsibilities:

• Responsible for designing report projects using SSRS for creating different kinds of reports according to business requirements. Created summary reports, ad-hoc reports, parameterized reports, and drilldown reports, along with other kinds of reports, using SSRS.
• Responsible for designing SSIS solutions to import data from source files into SQL Server reporting databases. The source file formats include flat files (Text, CSV), Excel, and XML.
• Involved in the maintenance and enhancement of existing Analysis Services databases by adding new cubes, dimensions, measure groups, calculations, and defining aggregations as required.
• Designed Report Templates for generating ad-hoc reports as per user requirements.
• Used Query Parameters, Report Parameters, and multiple expressions in SSRS to create interactive reports that display data to users based on their security scope.
• Created Email Subscriptions and File Share Subscriptions to deliver reports to multiple users based on report parameters.
• Created complex stored procedures and User Defined Functions for reporting purposes.
• Performed troubleshooting of stored procedures to enhance general report performance.
• Developed ad-hoc SSRS reports that employed Analysis Services databases as a data source. Established Attribute relationships and created custom Hierarchies for SSAS dimensions for optimal query performance.
• Wrote complex T-SQL queries that used multiple joins, sub-queries, table variables, and other functions to produce data outputs for analysis.
• Designed and implemented relational database objects, including Tables, Views, and User Defined Functions.

Jr. SQL Server/SSRS/SSIS Developer

Responsibilities:

• Involved in the migration of data between multiple databases and between multiple environments through the use of T-SQL scripts.
• Responsible for scheduling SQL Server Agent jobs to run T-SQL scripts on specified schedules for updating records and inserting new records into selected tables.
• Created SSIS packages to extract data from data sources such as Access Database, Excel spreadsheets, and flat files as part of data migration process into SQL Server databases.
• Worked closely with clients to define reporting requirements, and used the requirements as guidelines to design, develop, and deploy reports using SSRS.
• Used functions and expressions extensively in SSRS to display various calculated values in tabular or chart reports. These include Mathematical functions for numeric fields, Data and Time formatting functions, Text formatting functions, etc.
• Exported and distributed reports to clients in several formats as required, including PDF, Excel, Word, HTML, CSV.
• Created various T-SQL queries, views, and stored procedures for extracting and manipulating data from various databases.
• Carried out the installation and configuration of Microsoft SQL Server in different environments as required, including the configuration of SSRS and SSIS components.