PROFESSIONAL SUMMARY:

• 6 + 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
• Extensive Experience In T - SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2012/2008R 2/ 2008/2005/2000.
• Delivered BI Reporting Solutions In Power BI and Reporting Services (SSRS).
• Experience in scheduling SSIS packages using SQL Server Agent. And 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.
• Experience 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
• 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.
• 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, Miami, Florida

SQL Server/SSIS Developer

Responsibilities:

• Developed various T-SQL stored procedures, views, and adding/changing tables for data load and transformation, and data extraction.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, and UDFs.
• Created complex queries involving CTE’s, Sub-queries and Joins.
• Created Indexes for fast retrieval of the data. Involved in Performance tuning and Query Optimization using execution plan.
• Created new database/tables to put in the extracted data and rebuild the relationship.
• Created SSIS packages to pull data from AS400 IBM DB2 and exported to SQL Server and designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2016.
• Created the SSIS /DTS packages and scheduled them using Sql Server agent.
• Deploying SSIS Packages in Integration Service Catalog.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Utilized event handling effectively to generate audits and logs for the generated SSIS packages.
• Deployed SSIS Packages from Dev/Staging/Production using Package Configurations.
• Creating Dashboards and Reports Using Power BI

Environment: MS SQL Server 2016/2014,SSIS, SSRS, SSAS,POWER BI SSMS, Visual Studio 2017,T-SQL, Windows 2003 Server,VSTS, Service Now, BIDS(2008).

Confidential, Baltimore, Maryland

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Involving in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.
• Working on database design process and data modeling process.
• Analyzing the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.
• Designing SQL Server Database and Table Design with Schemas, Constraints and Views.
• Creating Database Schema and number of database Objects like tables, views, stored Procedures,User defined functions using SSMS.
• Designing and developing 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.
• Extracting data from various sources like Excel files and Text file from Client servers.
• Creating 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.
• Designing the data model based on star schema and created the tables and indexes and developed the scripts to load the data mart tables.
• Identifying 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.
• Creating Dashboards and Reports Using Power BI .
• Creating SSRS Data Driven Subscriptions .
• Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data

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

Confidential, Denver, Colorado

SQL Server/SSIS/ETL Developer

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.
• 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.
• Used SSIS 2014 to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Responsible for creating the reports using Power BI and SSRS 2014.
• Developed several dashboards using Power BI for Business KPI’s
• 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.
• 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
• 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

SQL Server 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, SQL Server BI Development Studio (BIDS) 2012, SQL LightSpeed, Visual SourceSafe, T-SQL, MS Access, Windows XP/2007 Server.