SUMMARY:

• Over 7 years of IT experience as MS SQL Server/Business Intelligence Developer 2014/2012/2008 /2005/2000 in various Industry verticals like Banking, Health Care and Finance.
• Extensive experience in Installation and Configuration of MS SQL Server 2012/2008R 2/2008/2005/2000 .
• Extensive knowledge and experience on all the phases of Software Development Life Cycle (SDLC) involving Planning, Analysis, Design, Development and Implementation.
• Good Experience in creating Databases, Tables, Constraints, Stored Procedures, Indexes, Functions, Views, Triggers, Joins, Cursors and Common Table Expressions.
• Expert in writing T - SQL queries and SQL scripts using various DDL and DML commands.
• Extensive experience in Microsoft SQL Server Business Intelligence (BI) platforms including MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) and MS SQL Server Analysis Services (SSAS).
• Proficient in creating and developing SQL Server SSIS Packages to Extract, Transform and Load (ETL) data from various data sources such as MS Excel, Oracle and MS Access.
• Experience in using tools like MS SQL Profiler, SQL Query Analyzer, SQL Server Agent and Query Execution Plan.
• Hands on experience in creating workflows with Tasks, Containers and various Transformations such as Derived Column, Data Conversion, Conditional Split, Multicast, Sort, Aggregate and Merge Join.
• Experience in providing logging, error handling by using event handlers and custom logging for SSIS Packages.
• Expert in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Highly experienced in Developing, Deploying and Scheduling SSIS and SSRS packages.
• Good understanding of Reporting Services with Report Authoring, Report Management, Report delivery and Report security.
• Extensive experience in generating Tabular Reports, Matrix Reports and Ad hoc Reports using SQL Server Reporting Services (SSRS).
• Highly skilled in creating Cross-Tab, Tablix, Drill-down, Drill-through reports and handling parameterized reports using SSRS.
• Experience in using Global variables, Expressions and Functions for the reports.
• Expert in designing Star schema and Snowflake schema with Facts and Dimensions.
• Working experience in developing Cubes, Fact Tables, Dimensions and data source view using SQL Server Analysis Services (SSAS) involving multidimensional data.
• Created calculated measures and dimension members using Multi Dimensional Expressions (MDX).
• Strong experience in development, maintenance and optimization of OLAP cubes and data sets.

TECHNICAL SKILLS:

Languages: C, C++, SQL, T-SQL, PL/SQL, VB.NET, C#.NET, Java, J2EE, JSP, ServletsSQL Server Tools: SQL Server Management Studio, SSIS, SSRS, SSAS, SQL Profiler, Query Analyzer, Data Transformation Services, Business Intelligence Development Studio, Visual Studio, Import/Export Wizard

Databases: Microsoft SQL Server 2014/2012/2008 R 2/2008/2005/2000, DB, MS Access, Oracle 11g, Teradata, Informatica

Web Technologies: HTML, XHTML, JavaScript, JQuery, CSS, XML

Business Tools: Word, Excel, PowerPoint, Access, Outlook, Power BI, Tableau

Operating Systems: Windows Server 2012/2008/2003, Windows XP/Vista/7/8, Linux

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, Tx

SQL Server BI Developer

Responsibilities:

• Actively participated in developing efficient use of Joins and sub-queries in queries that involve data from multiple tables, also developed T-SQL queries involving joins, Stored Procedures, Common Table Expressions and Views to implement security.
• Performed documentation for all kinds of reports and DTS and SSIS packages.
• Analyzing already existing reports and increasing the performance on these reports.
• Design and develop SSIS packages for data transformations and importing into new database.
• Proficiency in packages to extract, transform and load data (ETL) using SSIS.
• Extensively worked on control flow tasks such as Loop Containers, Execute SQL Task and data flow tasks by using different Sources, Transformations and Destinations such as Excel Source, Flat File Source, Data Conversion, Derived Column, Excel Destination, OLE DB Destination etc.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Worked with report subscriptions in SSRS 2016 to send the weekly run automated reports to end users
• Worked in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS)
• Generated the weekly, monthly, and quarterly internal reports by using SQL Server Reporting Services (SSRS) for the managers.
• Create different SSRS Reports based on the user's requirement.
• Used SQL Server Reporting Services (SSRS) for all reporting purposes, creation of new and modification of existing reports.
• Worked with Team Foundation Server for source control, working with CRs (change requests) and DRs (Deployment Requests).
• Schedule and manage daily/weekly, monthly and year-end sales and operational reports based on the business requirements. Design new reports and write technical documentation.
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables.

Environment: MS SQL Server 2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services(SSRS), MS Visual Studio 2010, T-SQL, Microsoft Excel, SQL Server Management Studio, Business Intelligence Development Studio (BIDS)

Confidential, Richmond, VA

MS SQL Server BI Developer

Responsibilities:

• Involved in Installation and Configuration of MS SQL Server 2012.
• Extracted data from a staging database and performed the various transformations and load data into the Data Warehouse Database.
• Created complex Stored Procedures, triggers and other SQL joins and statements for applications.
• Created Database objects - UDFs, views, triggers, cursors to meet the business requirements.
• Created Indexes and partitioned tables to get the high level performance.
• Used different Control Flow Tasks and Data flow Tasks for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and cleansing the data from different Sources.
• Developed the packages with monitoring features and Logging capturing the audit information of the packages and their execution results for support and troubleshooting.
• Used FTP and SFTP servers to transfer files to vendors.
• Involved in debugging / troubleshooting stored procedures, upgrading existing ones according to new requirements.
• Scheduled SSIS Packages as Jobs using SQL Server Agent.
• Involved in planning, defining and designing data based on business requirement and provided documentation for further reference.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS.
• Created complex stored procedures in the database and used them in the reporting services environment while creating data sets.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Administrated the created Reports by assigning permission to the valid user for executing reports.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules.

Environment: MS SQL Server 2012+, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SSMS, SSAS, Business Intelligence Development Studio (BIDS), MS Excel, MS Visual Studio 2010, Windows 7, C#, VB Script, Java

Confidential, Columbus, OH

MS-SQL Server/MS BI Developer (SSIS/SSRS)

Responsibilities:

• Involved in installation and configuration of MS SQL Server 2008.
• Involved in planning, defining and designing data based on business requirement and provided documentation for further reference.
• Involved in Data modeling to develop the database design using ER Studio.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Common Table Expressions and user defined functions for this project.
• Created Indexes to get the high level performance.
• Involved in migrating data from MS SQL server 2005 database to MS SQL server 2008 database.
• Created SQL Server Integration Service packages to populate data from the various data sources into SQL Server
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split and Derived column.
• Scheduled jobs for backup, and created alerts for error reporting.
• Created various Tabular and Matrix Reports using SSRS.
• Created Adhoc Reports using Report Builder 2.0 in SSRS.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Created reports to retrieve data using stored procedures that accept parameters.
• Configured the report server and generated the report models for user interactions.
• Generated database monitering and data validation reports in SQL Server Reporting Service (SSRS).
• Scheduled report delivery in formats like PDF, excel file, CSV and text files by creating subscriptions on the report server to business users as an email attachment.
• Optimized queries and performances using various SQL Server tools such as SQL Profiler, SQL performance monitor, execution plan and index tuning wizard.

Environment: MS SQL Server 2012, Microsoft Visual Studio, SQL server Integration Services, SQL server Reporting Services, SQL server Analysis Services, MS Office 2010(MS Excel, MS Access), MS Windows 7, Query Analyzer, SQL Profiler, SQL Server Agent

Confidential, Chesapeake, VA

SQL Developer/DBA/SSRS/SSAS

Responsibilities:

• Worked as a developer in creating complex tables, views, joins, triggers, cursors, stored procedures and statements for application.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Involved in Developing, monitoring and deploying of SSIS packages.
• Successfully extracted data from staging to ODS, applying complex transformation and finally loading to DSS after creating Dimensional and Fact tables.
• Created OLAP cubes, dimensions and data source views for the analysis using SSAS.
• Developed custom reports, tabular, drill down, parameterized, cascaded, drill through and adhoc reports using SQL Server Reporting Services.
• Used various transformations and tasks to create several ETL packages in SSIS.
• Worked with data migration utilities (Import & Export - BCP, Bulk Insert) from various sources to SQL Server.
• Involved in migration and conversion of reports.
• Optimized DTS package queries and stored procedures using SQL Profiler and Query Analyzer.
• Used MDX queries to retrieve the data from the cubes by actively creating OLAP cubes.
• Implemented best practices to maintain optimal performance and optimized SQL queries for maximum efficiency.

Environment: MS SQL Server 2008/2012, SSIS, SSRS, SSMS, Clustering, Performance Tuning, UNIX, MS SQL Reporting Services, MS Access 2007, SQL Profiler.

Confidential, Newark, NJ

SQL Server SSIS/SSRS Developer

Responsibilities:

• Create ETL packages to move data from various types of sources such as Excel, Access, Flat files, CSV to database.
• Performed logging in SSIS packages to capture error data and for error handling.
• Scheduled jobs for executing the stored and developed SSIS packages.
• Migrated data from SQL Server 2005 database to SQL Server 2008 database.
• Worked extensively with all the Control Flow and Data Flow tasks in SSIS.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived Column etc.
• Provided documentation of planning and designing data based on business requirements.
• Created datasets using T-SQL and stored procedures and are defined for generating reports.
• Developed various complex T-SQL queries using stored procedures, views, triggers and functions for data manipulation and data consistency.
• Developed the packages with monitoring features and logging the audit information of the packages and their execution results for support and troubleshooting.
• Actively created Multi-Dimensional cubes using SQL Server Analysis services.
• Generated different types of reports like drill down and drill through using SSRS.
• Scheduled the reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel sheet.
• Responsible for exception handling to catch and report the errors.

Environment: MS SQL Server 2005, DTS, MS Access, SQL Query Analyzer, MS SQL Server Integrated Services and MS SQL Server Reporting Services, T-SQL, PL/SQL, SQL Profiler, Windows XP/ NT / 2000/2003, Microsoft Excel.

Confidential

SQL Developer

Responsibilities:

• Involved in different stages of Project Life Cycle.
• Actively participated in gathering Business Requirements and System Specifications.
• Involved in the installation and configuration of SQL Server 2000 on development server for designing and testing.
• Created new Databases, tables, established relationship among tables in a database.
• Created stored procedures and functions to support efficient data storage and manipulation.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Defined Constraints, Indexes.
• Used SQL Server System Catalog to find Stored Proc, UDF, Triggers, indexes and constraints on existing databases.
• Implemented batch processing using Jobs and DTS.
• Migrated data from Flat files to SQL server 2000 using DTS (Import and Export Wizard)
• Scheduled Jobs using SQL Server Agent.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Analyzed the performance of SQL Server databases using SQL Profiler.

Environment: SQL Server 2000, DTS, MS Access, MS EXCEL, T-SQL, Windows 2000 server.