We provide IT Staff Augmentation Services!

Msbi Developer Resume

Cleveland, OH

SUMMARY:

  • Over 8 years of strong experience in Software Design, Development, Analysis, Testing with Data mart, Data Warehouse, Data modeling, Stored Procedure/TSQL coding and Business Intelligence tools.
  • Expert in MS SQL Server suite of products like SSRS, SSAS and SSIS of MS SQL Server 2012.
  • Highly Proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Functions, views and Indexes.
  • Expert in developing SSIS Packages to extract, transform and load (ETL) data into the data warehouse database from heterogeneous databases.
  • Experienced in using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
  • Experience in Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Experienced in writing parameterized Queries for generating reports, formatting report layout, sub reports using global variables, expressions and functions in SSRS.
  • Proven ability in defining Query for generating drill down and drill through reports in SSRS.
  • Experienced in creating different types of Tabular, Matrix, Drill Down, Drill Through, Parametrized, Cascaded Parametrized, Cross Tab, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
  • Experience in data warehouse development with Integration Services, Analysis Services, Reporting Services and Report Development using Power BI (Power Pivot, Power Query, Power Maps, Power View) tools.
  • Experience in creating Power BI dashboards using Power BI desktop/service and Power Query.
  • Great knowledge on connecting Microsoft Power BI to various data sources and setting up and configuring Power BI related Gateways and related data connections.
  • Expert in developing Power BI reports and DAX.
  • Developed Tableau dashboards (7x, 8x) consisting of financial/operation/sales performance indicators that are distributed to the regional leaders as well as present findings.
  • Manage the databases in development, QA and Production environments.
  • Experienced in working with Star Schema and Snow Flake Schema modeling to develop ROLAP/MOLAP Cubes using SQL Server Analysis Services (SSAS).
  • Expert in defining data source and building data source views.
  • Data modeling experience focusing on high-activity, normalized transaction systems (OLTP), highly usable de-normalized reporting systems (OLAP) as well as staging areas, Data marts.
  • Expert in Cube designer in Business Intelligence Development Studio to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
  • Solid Knowledge in developing cubes using Partitions, KPI’s, and Perspectives, slow changing dimensions (SCD) etc and created various user roles (SSAS).
  • Created calculated measures and dimensions members using MDX and DAX mathematical formulas and user defined functions.
  • Experience in managing Alerts, Operators and Jobs through SQL Server Agent.
  • Experienced in troubleshooting database issues, Performance Tuning, Query Optimization, Database Backup and Recovery procedures.
  • Skilled in design of logical and physical data modeling using Erwin data modeling tool.
  • Ability to handle multiple tasks and demonstrates initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS:

Databases: SQL Server 2014/2012/2008 R2, Sybase, MYSQL

Database Tools: SSMS, BIDS/Visual Studio, SQL Server Profiler, Import & Export Wizard, Toad, IIS 6.0/7.0,Business Objects, Crystal Reports 9.0, Web Services, XML, SOAP, Clear Case, Clear Quest, Visual Studio Team Foundation Server (TFS), ERWIN 7.3/7.2.

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor, SQL* Plus, SQL Service Broker, CA7

ETL Tools: SSIS,DTS

Languages: C, C++, C#.NET, JAVA, UNIX, SQL, T-SQL, PL/SQL, Java Script, jQuery, HTML, XML

RDBMS: SQL Server 2008 R2/2012/2014, Oracle 11g/10/9i

Reporting Tools: SSRS, Power BI, SharePoint

IDE: Visual Studio 2008 R2/2012

OS: Windows 2014 Enterprise, Windows 2012 Datacenter, Windows NT & XP, Windows 7/8

Other Tools: Erwin, Visio, Visual SourceSafe, MS Office suite.

Methodologies: Agile, SDLC, Scrum

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

MSBI Developer

Responsibilities:

  • Gathered User Requirements.
  • Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, tables, Views and other SQL joins and statements for applications.
  • Designed and developed the SSIS packages that reads from flat files and Relational databases.
  • Used the data transformations like Unpivot, Data Conversion, Derived column etc.
  • Implemented Logging and Error handling functionality for each package.
  • Migrated data between different heterogeneous sources such as Flat file, Excel 2012 using SSIS.
  • Created variables for connection string in order to connect to server dynamically and also to pick source file.
  • Developed the package like Source file will move into history folder after completion of the package.
  • Worked with various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, ftp task, send mail task, For each loop container.
  • Created and scheduled SQL jobs to run SSIS packages on a daily basis using SQL Server Agent.
  • Writing C# code using Script task and Script Component.
  • Designed and developed different reports like Matrix and Tabular reports, Cascaded, Parameterized, and pie chart reports using SQL Server Reporting Services (SSRS).
  • Expertise in developing Ad-Hoc, Drill down, Drill through and Dashboard reports using Local and Global Variables, Expressions and Filters in SQL Server Reporting Services (SSRS). Promoted RDLs to Reporting Service Server.
  • Created well-documented user manual for the contracts intake application to help user understand the SharePoint Portal.
  • Involving in data warehouse development with Integration Services and Analysis Services using Power BI (Power Pivot, Power Query, Power Maps, and Power View) tools.
  • Designing and Developing different reports like Matrix and Tabular reports, Cascaded, Parameterized, and pie chart reports using Power BI.
  • Used various sources to pull data into Power BI such as SQL Server, SQL Azure etc.
  • Scheduled Automatic refresh and scheduling refresh in Power BI service.
  • Deployed web embedded Power BI dashboards refreshed using gateways by using workspace and data source.
  • Professional in communicating Dashboards per Tableau visualization features.
  • Power BI reports design includes designing the report layout, adding tables/matrix/pie charts, creating DAX measures, calculated columns, formatting the report/fields, validating the data against the excel manual reports for its accuracy and performance.
  • Install and configure on premise Gateway.
  • Knowledge on Azure Experience in Custom Visuals and Groups usage.
  • Worked with multiple groups in the company to create SharePoint applications as per their business requirements.
  • Defined relationships between Dimensions and Measure groups.
  • Reviewed cube, changed the cube and documentation according to the requirement based on product valuation and revenue opportunities.
  • Good Exposure in data profiling on wide variety of data and DataModelling in EDW.
  • Performed Documentation Specialist duties for the ODS Production Operations team (research, collaboration, creation, review, consolidation of materials and information for, proofreading, and editing of various documents and communications for team room, Wiki, and shared drive).
  • Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.
  • Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
  • Defined Granularity with in a measure group and drill through actions.
  • Planned Backup strategy based on projects requirements.
  • Resolved any deadlocks issues with the Databases/Servers on a real-time basis.

Environment: SQL Server 2012, SSIS (2012/2008), Power BI, SSAS (2012/2008), Visual Studio 2010/2013, MS Excel 2010, T-SQL, C#, Window 7, Team Foundation Server.

Confidential, Brecksville, OH

SQL Server/SSIS Developer

Responsibilities:

  • Worked on Full life cycle development (SDLC) involving in all stages of development.
  • Worked as a developer in creating complex stored procedures, Triggers, Functions, Indexes, Tables, Views and SQL joins for applications.
  • Used highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.
  • Optimized queries tuned and monitored server performance using SQL Profiler.
  • Implemented different types of constraints on tables.
  • Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
  • Developed SSIS solution for developing a fully-fledged data warehouse solution.
  • Migrated data between different heterogeneous sources such as Flat file, Excel 2012 using SSIS.
  • Performed data conversions from SQL server to flat file using SSIS. Created packages that implements tasks like Execute SQL Task, Data Flow Task etc.
  • Responsible for creating the reports based on the requirements using SSRS 2012.
  • Involved in writing Query for generating drill down reports, identified and worked with the parameters to generate parameterized reports along with that extensively used global variables, expressions and functions.
  • Extracted data from different sources like SAS, Teradata, DB2 and Oracle using Informatica.
  • Identified and defined the Datasets for the report generation.
  • Deployed the generated reports directly on the client’s workstation.
  • Explored and used many enhancements of Power BI in current reports like Content pack and direct connection to databases like SSAS.
  • Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2012 Analysis Services (SSAS) and Power BI for reporting.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Implemented the calculations to aggregate physical measures.
  • Created calculated fields with DAX code to meet additional measures needs that are calculated from existing measures.
  • Identified and defined Fact relationships in SSAS.
  • Involved in DataModelling of variant Data and integrating the data into existing EDW model.
  • Monitored production and test jobs for Operational Data Store (ODS) distributed environment.
  • Monitored mainframe production and test jobs, including the critical overnight ODS data exchange processes.
  • Involved in developing Data Access Components to access the SQL Server Database using ADO.NET.
  • Involved in writing scripts for the clients requirements for reporting purposes.
  • Actively supported business users for change in requests. Gathered user requirements.
  • Implementing Dashboards and Score Cards using Microsoft Performance Point Server and integrated with share point.

Environment: SQL Server 2012, SSIS (2012/2008), SSRS (2012/2008), SSAS (2012/2008), Visual Studio 2010/2013, MS Excel 2010, T-SQL, C#, Window 7, Team Foundation Server.

Confidential, Minneapolis, MN

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, tables, views and other SQL joins and statements for applications.
  • Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
  • Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, Instances, Linked Servers and Indexes.
  • Maintained data integrity by performing validation checks.
  • Developed SSIS project for transferring the data.
  • Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
  • Created SSIS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
  • Imported data from various sources into a staging area, merges the data into the OLTP data model, and presents it to all levels of the over-600 users.
  • Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
  • Identified and defined the Datasets for report generation.
  • Created SQL Server Reports using SQL Server Reporting Services (SSRS).
  • Created Subscription of Reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis.
  • Created parameterized, drill-down and drill-through reports. Wrote the queries for the drill down reports.
  • Documented all database changes and follow and enforce change and release management processes.

Environment: SQL Server 2005/2008, BIDS 2005/2008, SSRS 2005/2008, SSIS 2005/2008, DTS, MS Access, Visual Studio, T-SQL, Windows.

Confidential, Columbus, OH

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data using Erwin.
  • Created complex Stored Procedures, views, Triggers, Tables and other SQL joins.
  • Modified current database by adding tables, altering referential integrity and relationships to support the control system.
  • Created clustered /non-clustered indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures.
  • Used Triggers to generate customized error messages.
  • Created SSIS package to schedule the jobs for batch processing.
  • Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
  • Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
  • Worked with Package Configurations for SSIS package deployment.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
  • Expertise in generating reports using linked reports, sub reports and filters in SQL server reporting services (SSRS).
  • Created parameterized reports, Drill down and Drill through reports using SSRS.
  • Deployed and configured the reports in the Report Server.
  • Created Subscription of Reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis.
  • Developed stores procedures to transform the data from Enterprise Data Warehouse to data mart to build dimensions and load data to fact tables.

Environment: SQL Server 2005, SSIS (2005), SSAS (2005), Erwin, Windows Server 2003, MS Visual Studio 2008.

Confidential

MS SQL/BI Developer

Responsibilities:

  • Involved in requirements gathering, analysis, design, development, change management, deployment.
  • Installed and Configured SQL Server 2008 successfully.
  • Created Stored Procedures, User defined functions, Views, Triggers, Indexes and Wrote T- SQL codes maintaining query standards for the project.
  • Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers and Worked on Index tuning, stored Procedure tuning.
  • Scheduled Daily and weekly Jobs and Alerting using SQL Server Agent.
  • Created SSIS packages using SSIS designer for export heterogeneous data from OLE DB Source, Excel spread sheets and Flat files to SQL Server 2008.
  • Generated packages using various Transformations like Lookups, Derived Column, Merge Join, For Loop, For Each Loop, Conditional Split, Union all and etc.
  • Utilized SSRS reporting services to generate different types of reports from the database.
  • Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and Sub Reports.
  • Prepared the detailed project layout, analyzed existing technology involved, and documented work performed and stored in Visual Source Safe (VSS).
  • Evaluated database performance and performed maintenance duties such as Tuning, Replication, Backup and Recovery.

Environment: MS SQL Server 2005/2008, SQL Server Integration Services, SQL Server Reporting Services, DTS, MS Access, MS Excel, Windows 2003 servers, T-SQL, PL/SQL, Visual Studio 2008.

Confidential

Junior SQL Server Developer

Responsibilities:

  • Installed and configured SQL Server 2005 successfully on Windows Server 2003.
  • Created other database objects like tables, views, Stored Procedures, User Defined Functions, Triggers and indexes.
  • Error handling using Try-Catch Block.
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
  • Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
  • Automated Stored Procedures to load data into staging and production environments in a timely manner using SQL Server Agent.
  • Used the Control Flow and Data Flow Tasks and Transformations in Creating SSIS (ETL) Packages.
  • Created Master Child package using variables and Execute package task in SSIS.
  • Assisted the front end application developers with their queries.
  • Taking Database full Backup, Transaction log backup & differential backups.
  • Configured Snapshot replication for reporting, user acceptance test and development servers.
  • Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: SQL Server 2005, T-SQL, VB, MS Word 2005, DTS, SQL Profiler, Visual Source Safe, DTS/SSIS 2005, Import and Export Wizard, BCP, Windows Server 2003, UNIX.

Hire Now