We provide IT Staff Augmentation Services!

Msbi /sql Server Developer Resume

Newport News, VA

PROFESSIONAL SUMMARY

  • 2+ years of experience in Data Analysis, Design, Implementation, Administration, and support of Business Intelligence using SQL Server SSIS, SSAS, and SSRS.
  • Strong programming experience in TSQL, PL/SQL Development (SQL SERVER 2016) and Report Development (SSIS, SSRS), Performance Analysis, Deployment Script Development, Production Support.
  • Published reports to Azure - based Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps).
  • Excellent hands-on experience in groups, hierarchies, and measures, KPIs
  • Expert in working on all phases of Data warehouse from gathering requirements to testing, implementation, and support.
  • Excellent knowledge in Performance tuning methodologies at a database level, ETL, and Report Level.
  • Proficient in the ER-Data Modeler, for the designing of Conceptual Design, Logical Design, and Physical Design and setting up the database model.
  • Excellent knowledge of Data Warehousing methodologies and concepts, including Star schema, Snowflake, ETL processes, Dimensional modeling and reporting tools.
  • Proficient in applying transformation rules - Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split.
  • Expert in Creating, configuring and Fine-tuning SSIS packages, SSRS reports and T-SQL queries using tools like SQL profiler Monitoring tool.
  • Experience in creating jobs, alerts, SQL mail agent, and schedules for SSIS Packages in SQL Server Agent.
  • Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and data Integrity, SQL joins and query Writing.
  • Good exposure on 2016 version of SQL Server Management studio. Worked on SQL Server 2014 migration to 2016.
  • Optimized all major relational database and data warehouse and accessed multidimensional databases and flat files using micro strategy.
  • Proficient in applying transformation rules - Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split.
  • Expert in generating reports using SQL Server Reporting Services (SSRS).
  • Proficient in SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler.
  • Strong Knowledge in Data Analytics tools such as Power BI, Tableau, QlikView etc.
  • Expertise in DAX & MDX Languages which helps in understanding and analyzing the data.
  • Worked in all the products in Power BI such as Power BI Pro, Embeded, Premium, Power BI Mobile

TECHNICAL SKILLS:

SQL Server Tools: SSMS, BIDS, Enterprise Manager, DTS, Profiler, DTA, Upgrade Advisor

ETL & Reporting Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), SQL Server Reporting Services (2005/2008R2,2012,2014), Tableau, Qlikview, MS Access, MS Excel, Jasper reports, Power Pivot, Power View.

Databases: SQL Server 2008/2008 R2,2012,2014 MS Access, Oracle 10g/9i/8i

TSQL, PL: SQL, C

Operating System: Windows 7/8/10, Windows XP/98/95, MS DOS, Mac OS X

Scripting: HTML, XML, VBScript, C#

Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash.

PROFESSIONAL EXPERIENCE:

Confidential, NewPort News, VA

MSBI /SQL Server Developer

Responsibilities :

  • Business requirements gathering, proposing a system design.
  • Extract Transform Load ( ETL ) development using SQL Server 2005 , SQL 2008, SQL 2008R2 , 2012,2014 Integration Services (SSIS).
  • Creating New Data Warehouse and loading the data from different source systems.
  • Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design ( Star Schema ) and maintenance .
  • Created SQL Server Reports using SSRS 2005 .Identified the data source and defined them to build the data source views.
  • Experience in Developing and Extending SSAS Cubes , Dimensions and data source view SSAS - Data Mining Models and Deploying and Processing SSAS objects.
  • Developed Analysis Services Project. Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS . Responsible for identifying and defining Data Source and Data Source views. Created cubes and defined the dimensions.
  • Designing the Dashboards in EHR system for monitoring and Extracting the data one server to another
  • Scheduled weekly DBCC DB Re-index & other Database Maintenance Jobs to check database consistencies
  • Implemented Backups using lite speed and Maintenance plans and device various Recovery methodologies
  • Automated most of the DBA TASKS and monitoring stats
  • Proactively monitored, determined and solved issues at SQL /database.
  • Maintaining and Analysing HealthCare Records with EHR Systems by analyzing the Clinical Data with SSAS Cudes
  • Set up SQL Profiler to trace various Database activities, application Responses and Performance tune them
  • Responsible for testing to optimize the procedures and triggers to be used in production.
  • Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery whenever needed.
  • Build and maintain complex SQL queries using T SQL for data analysis, data mining and data manipulation. Organize analytical data; ensure data quality and aggregate data for strategic reporting and performance optimization on database solutions.
  • Created/designed reports using SQL Server Reporting Services according to user requirements.
  • Responsible for writing SQL queries, Procedures, Functions and Database triggers .
  • Generated parameterized reports, sub reports , tabular reports using SSRS 2008
  • Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, Drill through, Sub reports for top selling equipment in the company, top sales based on region and sales based on season.
  • Made Master Child package using variables and Execute package task in SSIS.
  • Deployed, Tested and Scheduled SSIS packages .
  • Developed incremental loading using MERGE statement in SQL server 2008R2 .
  • Writing relational and multidimensional database queries
  • Configuring, deploying and maintaining database servers

Environment : SQL Server 2016, SQL Profiler, SSIS, SSRS, SSAS, SQL*Plus, MS Visio, T-SQL, MS Office.

Confidential, Irving Texas

SQL Server Developer

Responsibilities:

  • Extracting and Loading data into SQL Server Database using SSIS .
  • Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
  • Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2008/2005 (SSAS)
  • Created SSIS Packages to migrate slowly changing dimensions
  • Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
  • Experience in creating complex SSIS packages using proper control and data flow elements.
  • Generated matrix reports , drill down, drill through, sub reports, chart reports, multi parameterized reports.
  • Developed reports and deployed them on server using SQL Server Reporting Services (SSRS) .
  • Pulling data on a daily basis from OLTP database to OLAP or staging database using the SSIS packages.
  • Create a Tabular models based on an existing model already in SQL Server Data Tools and by extracting the metadata and data from a PowerPivot for Excel file (.xlsx).
  • Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
  • Transferred data (ETL) to Data ware house Environment using SSIS .
  • Used Data Partitioning, Snapshot Isolation in SQL Server 2005.
  • Developed different types of Tabular models , Matrix Reports , Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS)
  • Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS.
  • By using cached mode in Tabular Models , integrate data from multiple sources including relational databases, data feeds, and flat text files.
  • Designed SSRS 2008 reports with Cascaded Parameters, Gauges and Interactive Charts , etc.
  • Excellent report creation skills using Microsoft SQL Server 2012/2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
  • Designed reports within SSRS product to replace Jasper reporting service .
  • Created SQL Server Reports based on the requirements using SSRS 2008.
  • Highly responsible for development and management of PPS, SSAS, SSRS and SSIS projects.
  • Building KPI reports for the cubes and optimizing the reports.
  • To analyze long running queries and tune the same to optimize application and system performance.
  • Maintained the database consistency with DBCC at regular intervals.
  • Involved in development activities included hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting.
  • Involved in partitioning of cubes in order to increase the performance of cubes ( SSAS ).
  • Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
  • Worked very closely with Business Customers , End Users and resolved any business process related issues .

Environment: Windows server 2008/R2, IIS 6.0, MS SQL Server 2008 SSAS, SSRS, SSIS, Tabular Data models, Microsoft Business Intelligence Development Studio (BIDS), Jasper Reports, DB2, T-SQL, DTS, OLAP, OLTP, Microsoft Excel, SQL Server Agent, TFS 2010, Office-2008, MS Excel.

Confidential

Sql developer

Responsibilities:

  • Involved in creating various Database Objects - Tables, Indexes, Store Procedure, Trigger, Views, and Roles. Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler
  • Designed and developed reports using Microsoft SQL Server Reporting Services (SSRS)
  • 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 and Drill down reports using SSRS.
  • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
  • Generated multi parameterized reports in MS SSRS 2012 allowing users the ability to make selections before executing reports; thus, making them user friendly
  • Designed Data flows, Workflows and jobs to load data from source to target
  • Responsible for data warehouse ETL development and maintenance, SSRS report creation, and SQL query performance tuning.
  • Developed, enhanced, and supported processes using Transact SQL and SSIS which moved data from the Oracle system and other sources into the SQL Server warehouse. Assisted in conversion of ETL processes from Oracle to SQL stored procedures
  • Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analysing multi-dimensional reports in SSRS
  • Improved the performance of SSRS reports by tuning the Stored Procedures and TSQL queries using various join conditions. Created XML, PDF, EXCEL files using SSRS
  • T-SQL development included queries using joins, subqueries, ranking functions, derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF), constraints & Database triggers
  • Environment: SQL Server 2012, Microsoft SQL (T-SQL), SSIS, SSRS

Hire Now