We provide IT Staff Augmentation Services!

Msbi Lead And Developer Resume

TampA

SUMMARY:

  • More than 6 years of IT experience in complete Software Development Life Cycle and Agile Methodologies including Requirement Analysis, Design, Development, testing, Implementation.
  • Strong Expertise in SQL Server 2005/2008/2012 components such as SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services)
  • Adept at interfacing with end users to gather requirements and produce functional requirements, Ample knowledge of Relational Database Management Systems (RDBMS) & Entity Relationship Diagram (ERD).
  • Experience in Migrating SQL 2005 databases to SQL 2008 and SQL 2012.
  • Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
  • Experienced on subscriptions, report snapshot and report cache.
  • Expert in Extracting and Transforming data using SSIS in SQL Server 2005/2008/2012, SQL Server Import Export Wizard, Bulk Insert Task and Bulk Copy Program (BCP).
  • Experience in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file.
  • Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012 ) generated drill down reports, parameterized reports, linked reports, sub reports in SSRS 2005/2008/2012 using Tabular format.
  • Communicated with multiple business groups to design and develop reports using Microsoft Reporting Services
  • Experienced in automating the system by using Notification service and creating alerts, jobs and maintenance plans.
  • Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Services (SSIS).
  • Expert in customizing SSIS Script Task and Script component using c#.net
  • Will work "hands - on" when required but understands the value and importance of delegating work and responsibilities.
  • Proficient in High Level Design of ETL DTS Package for integrating data from heterogeneous sources.
  • Quick learner, excellent communication skills and good performer both in team and independent job environments.
  • Have extensive domain knowledge in Health Care insurance and Retail.

TECHNICAL SKILLS:

  • MS SQL Server 2005/2008
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016
  • Visual Studio
  • SSMS
  • BI tools (SSRS
  • SSIS
  • SSAS)
  • Bulk Copy program (BCP)
  • SQL Server Data Tools
  • Windows NT/2000/2003/XP/VISTA/2008
  • Windows 7
  • HTML
  • XML
  • Internet Information Server (IIS)
  • MS Office.

PROFESSIONAL EXPERIENCE:

Confidential, Tampa

MSBI Lead and developer

Responsibilities:

  • Extensively involved in designing the integration part to flow the data form one system to another by interacting with the business users from multiple systems.
  • Extensively involved in design of AWS servers of test and UAT environment and designed the ETL data model based on the existing database table structures
  • Coding of SSIS Packages to migrate data from various sources and loading them into SQL Server Database.
  • Performed Unit testing of the SSIS extract packages and also building validation packages to check the accuracy of the data migrated.
  • Designed and developed the Power Bi solution for reporting and dashboard creation.
  • Performance tuning of stored procedure, SSIS Packages and reports and Wrote complex join queries using T-SQL.
  • Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.
  • Created and modified Stored Procedures, Functions, and Indexes.
  • Created SQL Server Jobs and Schedules for automated and timely execution of Daily, Weekly and Monthly processes and scheduled.

Environment: SQL Server 2012, TFS, Microsoft Visual Studio 2012, T-SQL, SSIS, SSRS.

Confidential, Atlanta

MSBI developer

Responsibilities:

  • Extensively involved in creating SSIS Packages to migrate data from various sources and loading them into SQL Server Database.
  • Played major role on production support (operations) running and scheduling jobs, backups and so on.
  • Involved in SSIS Package creation from package design documents to package build.
  • Involved in Unit testing of the SSIS extract packages and also building validation packages to check the accuracy of the data migrated.
  • Performance tuning of stored procedure, SSIS Packages and reports.
  • Wrote complex Join queries using T-SQL.
  • Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.
  • Created Test packages to validate the SSIS packages build.
  • Created and modified Stored Procedures, Functions, and Indexes.
  • Experience in configuration of report server and report manager scheduling in SQL Server Reporting Services (SSRS).
  • Created SQL Server Jobs and Schedules for automated and timely execution of Daily, Weekly and Monthly processes.
  • Environment: SQL Server 2012, TFS, Microsoft Visual Studio 2012, T-SQL, SSIS, SSRS.

Confidential, Charlotte

SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Implemented triggers and stored procedures and enforced business rules via checks and constraints.
  • Created indexes on selective columns to speed up queries and analysis in SQL Server Management Studio.
  • Worked on querying data and creating on-demand reports in SSRS reports and send the reports via email.
  • Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
  • Created Parameterized, Drill-down and Sub-Reports using RDL. Promoted RDLs to Reporting Service Server.
  • Worked on SQL Server Upgrade from 2008R2 to 2012.
  • Migrated SSRS reports from 2008 to SSRS 2012.
  • Defined the logging process for all the packages, populated it with entries like inserted record, updated record and error record.
  • Scheduled the SSIS packages and Jobs
  • Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008.
  • Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using SQL Server Integration Services (SSIS).
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
  • Performed data transfers using BCP and BULK INSERT utilities.
  • Created an automated ETL summary report which consists of the summary information for all the loading activities done each day and month.

Environment: SQL Server 2008 R2, SQL Server 2012, Microsoft Visual Studio 2008/ SQL Server Data Tools, T-SQL, SSIS, SSRS

Hire Now