PROFESSIONAL SUMMARY:

• 8+ years of experience as MS SQL Developer in administration and development of Database Design and Development in SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 system in OLTP and OLAP environment.
• Extensive experience in SSIS, SSAS,SSRS of MS SQL Server and Power BI
• Highly expert in translating Business System Design document into technical design document
• Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
• In - depth knowledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer and Cross Joins.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2012/2008R 2/ 2008/2005/2000.
• Delivered BI Reporting Solutions InPower BI and Reporting Services (SSRS).
• Experience in scheduling SSIS packages using SQL Server Agent.
• Strong knowledge of using variables and expressionsin packages.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Excellent skills in implementing ETL Packages using DTS and SSIS 2016/2014/2012/2008 R 2/2008/ 2005.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, and XML).
• Well versed in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using BCP, Bulk Insert & DTS utility.
• Extensive Knowledge in SSAS storage, partitions and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Good Knowledge in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Expert in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data
• Proficient in Creating business critical KPIs using SQL Server Analysis Services SSAS representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Strong experiences to Design, deploy, and maintain various SSRS Reports in SQL Server 2012.
• Designed and developed different type of reports including Tabular forms, Dashboards, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, custom report, drill down reports using SSRS.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
• Experience in developing Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Responsible for Deployment of the report to report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
• Created Dashboards and other virtualization reports using Power BI
• Worked on all types of transformations that are available in Power bi query editor
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Extensive experience in report writing using SQL Server Reporting Services like Tabular report, Matrix report, Chart report, Pie Charts and column report.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Extensively involved in the SSAS Storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Effective communication and interpersonal skills with the ability to focus on multiple tasks in a high-pressure environment.

TECHNICAL SKILLS:

Databases: MS SQL server 2005/2008/2012/2014/2016 , Oracle, Teradata, MS Access.

Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, SSIS, SSRS, Business Intelligence Development Studio, Data Transformation Services, SharePoint

Languages: Transact- SQL, SQL, HTML, XHTML, C, XML, C#, ASP.NET MVC.

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS.

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports, Business Objects, Tableau, Power BI

SQLServer Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler.

DataModeling Tools: Erwin tool, Microsoft Visio 2000/2003

Source Control: TFS 2010/2008, VSS, SVN, Bitbucket

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, Maryland

Sr.MSBI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.
• Experienced in database design process and data modeling process.
• Analyzed the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.
• Designed SQL Server Database and Table Design with Schemas, Constraints and Views.
• Created Database Schema and number of database Objects like tables,views, stored Procedures,User defined functions using SSMS.
• Extracted data from various sources like Excel files and Text file from Client servers.
• Created SSIS packages which involved a variety of transformations such as Slowly Changing Dimension, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion before loading the data into Data Warehouse.
• Designed the data model based on star schema and created the tables and indexes and developed the scripts to load the data mart tables.
• Identified issue and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.
• Created Dashboards and Reports Using Power BI, SSRS and SSAS Analytical Tools .
• Created SSRS Data Driven Subscriptions .

Environment: MS SQL Server 2016/2012,SSIS, SSRS, SSAS,POWER BISSMS, Visual Studio 2017,T-SQL, Windows 2003 Server,TFS, Service Now

Confidential, Denver, Colorado

SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Worked with Client to resolve the Data issues in FACETS Environment
• Worked with ETL team to resolve some of the data (ETL) issues (SSIS is used to move the data from FACETS Oracle database.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Used SSIS 2014 to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Responsible for creating the reports using Power BI and SSRS 2014.
• Developed several dashboards using Power BI for Business KPI’s
• Data migration (import & export - BCP) from Text Files to SQL server.
• Designed SQL SSIS Packages in Business Intelligence Development Studio (BIDS), to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2008, 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks in Visual Studio 2015.
• Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Build data visualizations and reports from DW and OLAP cubes using PowerBI, SSRS, and possibly Tableau
• Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard and deploy packages to production Server.
• Created business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance
• Experience in using Audit functions and extensively used Exception Handling for catching and reporting errors
• Designed and developed different type of reports including Tabular forms, Dashboards, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, custom report, drill down reports using SSRS.
• Extensive experience in creating enterprise reports using SSRS using Report Manager, Report Builder, and BIDS
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Build reusable macros to control QlikView objects for ease of use by the users.

Environment: SQL Server 2014 SSIS, SSRS, QlikView, Visual studio 2015, MS Visio 2007, XML, VB.Net. SQLServerBIDevelopment Studio (BIDS), TFS, Power BI

Confidential, Dulles, VA

Sr.ETL/MSBI developer

Responsibilities:

• Created numerous T-SQL Queries, stored procedures, triggers, cursors and functions to implement medium to complex business logic for in-house applications and websites.
• Identified and corrected exceptions and inconsistencies in transactional data and continuously enhanced data quality based on requirements gathered from business units.
• Developed business intelligence solutions (Dashboards and Reports) using Excel and SSRS to deliver operational and strategic reports to all customer facing departments.
• Participated in logical and physical database architectural design by applying data modelling methodologies - Entity Relationship concepts and normalization.
• Maintained documentation related to database development platform guidelines, methods and standards.
• As part of team, gathered and documented software development requirements and design using software development life cycle (SDLC) methodologies. Do performance monitoring and provide analysis on SQL tuning required, indexing strategy, SSIS packages optimization, etc. Migrated old SQL server system to support Unicode as NAS gets ready to support Internationalization in its platform. Migrated all the existing DB objects.
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Designed multiple SSRS based reports for the reporting needs of the NAS business team.
• Developed various reports using SSRS, which included writing complex stored procedures for datasets.
• Created Tableau scorecards, dashboards using stack bars, bargraphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Understanding and translation of various existing SSRS reports to Tableau dashboards.
• Involved in Report Authoring, Report Delivery (using both Pull and Push strategy) and Report Management for various types of reports support provided to the business users for Analytical and reporting purposes.
• Understanding and translation of various existing SSRS reports to Tableau dashboards.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Demos given to business users and other stake holders of NAS
• Involve in the system design of new projects and initiatives across NAS.
• Good leadership, organizational, oral/written communication, Interpersonal, analytical, and problem resolution skills. Thrive in both independent and collaborative work environments.

Environment: SQL Server 2012, SSIS, SSRS, SQLServerBIDevelopment Studio (BIDS) Visual studio 2013, MS Visio 2007, ETL,TFS, T-SQL, Tableau

Confidential, Birmingham, AL

MSBI Developer

Responsibilities:

• As a part of BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing and Implementation of BI Analytics and Reports.
• Involved in creating database objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Parameterized Stored Procedures, Constraints and Roles.
• Experienced in creating complex store procedures with Pivot, Un-Pivot, triggers and functions.
• Experienced in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, XML Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in Incremental data loading.
• Developed SSIS 2012 Packages to migrate data from Oracle, Access, flat files and Excel into SQL server 2012 for further Data Analysis and Reporting by using multiple transformations.
• Involved in development of Incremental Load process using SSIS Packages for Cerner application.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
• Delivered 20 different packages which were an Ad-hoc request in the project.
• Involved in Automation of Incremental load process using Red gate tool.
• Involved on call production support 24/7 for Production Jobs.
• Involved as a Lead for UAT team for bug fixes and production issues.
• Involved in transforming data from dev into Stage & Prod environments using BCP Process.
• Worked closely with Business People for gathering business requirements for the reports, data load processes and for the Cubes development.

Environment: SQLServer2012, SQLServerBIDevelopment Studio (BIDS) 2012, SQL LightSpeed, Visual SourceSafe, T-SQL, MS Access, Windows XP/2007 Server.

Confidential, Columbus, OH

SQL Server BI Consultant

Responsibilities:

• Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Involved in developing creative MS SQL solutions including Store Procedures, Views, Functions, User Defined Data Types, DTS/SSIS jobs, and job schedules assuring optimal functionality and adherence to corporate coding Specifications.
• Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Responsible for creating database objects like table, Views, Joins, Store Procedure, Triggers, Functions etc. using T-SQL to store data and to maintain database efficiently.
• Extensively used Execute SQL Task, Data flow Task, Look up, Script logic component, Union All etc. in SSIS packages.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Staging DB to Data warehouse.
• Good Knowledge in Analyzing, designing, building &, testing of OLAP cubes with SSAS and in adding calculations using MDX.
• Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and Reporting tools.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Created business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Developed many Tabular Reports, Matrix Reports, drill down Reports and Charts using SQL Server Reporting Services (SSRS). Also created many multi valued parameters in the reports.
• A Used Reporting Services to consume data from SharePoint sites and display reports and dashboards on SharePoint sites.
• Identified and worked with Parameters for parameterized reports in SSRS 2008 R2.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Delivered comprehensive BI through MS solutions including MS Excel, Microsoft Office SharePoint Server (MOSS), and Performance Point Server 2007 Improved Report Performance and performed unit testing.

Environment: MS SQL Server 2008, Visual Studio 2008, VB.Net, C#, VB.Net, MS SQL Server Management Studio, SSIS, SSRS, Report Builder, SSIS-2005, Unix, Teradata, Team Foundation Server (TFS), Office, Excel, SharePoint

Confidential

SQL Server Developer

Responsibilities:

• Involved in Gathering end user requirements, developed applications and different audit functionalities depending on the requirement acting for both system analysts and application developer.
• Composed user requirement documents, created technical specs and design documents for various projects.
• Generated complex T-SQL queries, sub-queries, co-related sub queries, dynamic SQL queries etc.
• Programming in SQL server using stored procedures, triggers, views, user-defined functions
• Used ETL to implement the SCD transformation, to maintain historical data in data warehouse.
• Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS.
• Involved in database design, normalization, de-normalization in building data warehouse and reporting systems.
• Involved in query tuning by creating cluster and non-cluster indexes on tables, and used index tuning wizard.
• Worked with several control flow tasks, data flow tasks, transformations (derived column, lookup, merge join, conditional split, slowly changing dimensions, data conversion etc.) in SSIS packages.
• Involved in installation, configuration, maintenance, deployment and troubleshooting SSRS reports.
• Created complex reports like table report, matrix report, cascading report, sub reports, drill down, drill through and chart reports using complex data set queries, stored procedures, views in SSRS 2005/2008.
• Created ADhoc reports more often based on end user requirements.
• Performed daily DBA activities, security assignment, user setup, backup, restore and job monitoring on MS SQL Server
• Expert in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data
• Generated and formatted reports using global variables, expressions and functions.
• Involved in developing parameterized reports using single values, multi values and cascading parameters.
• Built effective queries for high performance reporting and rendered them to html, xml, pdf, MS word and excel formats using SSRS (2005/2008).

Environment: SQL server 2000/2005/2008 , SQL Query Analyzer, SQL profiler, IIS 6.0, Oracle 9i, Enterprise Manager, ERWIN Data Modeler, SSIS, SSRS, SSAS, Windows Server 2003/2008, OLTP, OLAP, DTS, HTML, XML, C#, .Net, Visual Studio 2008, ETL, MS Access

Confidential

SQL Developer

Responsibilities:

• Involved in the installation of SQL server. Installed SQL server enterprise manager tools using SQL Setup.
• Created complex SQL queries, stored procedures, triggers, views, functions to implement business logic.
• Optimized queries by looking at execution plan for better tuning of database.
• Designed and developed various complex reports using drill down, drill through, cross tabbed reports etc.
• Responsible for ongoing maintenance and management of existing reports. Also, to optimize report performance.
• Used Report manager to deploy reports, schedule reports and created groups and users.
• Designed and developed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different transformations like lookup, merge join, fuzzy lookup, derived columns etc.
• Involved in automating SSIS packages using SQL server agent jobs, windows scheduler and third part tools.
• Experience in Developing and Extending SSAS cubes, Dimensions and data source view SSAS-Data Mining models and deploying and processing SSAS objects
• Implemented event handlers & error handling in SSIS and notified process results to various communities.
• Experience in configuration of report server and report manager scheduling in SQL Server Reporting Services (SSRS).
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Generated Sub-Reports, drill down reports, Drill through reports and Parameterized reports using SSRS.

Environment: MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Server Management Studio, MS Excel, T-SQL.