We provide IT Staff Augmentation Services!

Sr. Msbi Developer(ssis/ssrs/ssas) Resume

3.00/5 (Submit Your Rating)

Melbourne, FL

PROFESSIONAL SUMMARY:

  • Around 6+ years of IT Experience in System Design, Development and Support of Microsoft SQL Server 2014/2012/2008 R2/2008/2005 in Development, Data warehouse, Test and Production Environments on various business domains like Financial, Insurance and Health Care.
  • Experience in Data Schema Design, and Table Design.
  • Experience with T - SQL in constructing Tables, Triggers, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
  • Experience in using multiple join statements to retrieve data from multiple tables.
  • Experience in Creating Backend validations using Insert/Update and Delete triggers and Created views for generating reports.
  • Worked in SDLC ( Systems Development Life Cycle) for developing systems/Software.
  • Experience in writing Programs for implementing Stored Procedures for different tasks. Worked with Development teams in relation to application tuning.
  • Experience in MS Business Intelligence tools like SQL Server Integration Services, Analysis Services and Reporting Services.
  • Migrated DTS objects to SQL Server Integrated Services environment, migrated data from SAS environment to SQL Server 2005/ 2008/2012/2014 via SQL Server Integrated Services.
  • Implemented SSIS data, created maintenance procedures and provided data integrity strategies.
  • Created ETL packages using SSIS to move data from various heterogeneous data sources.
  • Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
  • Implemented error handling and roll back process in ETL load.
  • Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases
  • Expert in removing the Duplicate (De-duplication) rows from a table and applying Fuzzy lookup in SSIS
  • Worked with Financial companies for application related pricing and security applications
  • Experience in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Implemented Snow Flakes Schema and Star Schema
  • Experience in multidimensional databases with demonstrated ability to create calculated members and MDX scripting
  • Proficient in building Cubes, defining d Relationships and creating Hierarchies in SSAS
  • Expertise in creating Cell Level Security in cubes using SSAS.
  • Developed Reports using efficient data retrieval techniques
  • Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
  • Built and wrote MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server 2005/2008/2012 Analysis Services Business Intelligence (SSAS, SSRS)

TECHNICAL SKILLS:

Databases: SQL server 2000/2005/2008 R2/2012/2014, MS Access

Operating Systems: DOS, Linux, Windows 2000/XP/Vista/7

SSAS: , (SSRS), MDX, Crystal Reports.

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS, ETL Informatica V8 & V9, Datastage.

Other Tools: Microsoft Visual Source Safe, Microsoft Office, MS Visio.

Data Modeling Tools: Microsoft Visio 2000/2003, Erwin, Liquid XML, JDBC, Dreamweaver, Macro Express

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

Programming languages: C,SQL,PL/SQL,T-SQL,.NET,C#, C++, Java, Pascal, COBOL, Unix, Assembly( 8085,8086 )

Data Warehousing & BI: SQL Server, Business Intelligence Studio, SSIS, SSAS, Access Manager, SQL Server 2008 Analysis Services and SQL Reporting services, DTS, ProClarity, Performance Point Server (PPS)-2007, MOSSf

PROFESSIONAL EXPERIENCE:

Confidential, Melbourne, FL

Sr. MSBI Developer(SSIS/SSRS/SSAS)

Responsibilities:

  • Installed and Configured Microsoft SQL Server 2008/2012/2014 .
  • Created Tables, Views, Indexes, Stored Procedure and Triggers. Used multiple join statements to retrieve data and update the tables. Created Backend validations using Insert/Update and Delete triggers.
  • Worked on Cross platforms like SAS (Statistical Analysis System) to SQL server, Transformed the SAS Macros to SSIS.
  • Extensively used Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources and converted SAS environment to SQL Server.
  • Developed, monitored and deployed SSIS packages.
  • Worked in transferring the data using SQL Server Integration Services packages extensively used SSIS Import/Export Wizard for performing the ETL operations.
  • Heavily involved in the design/development of the applications using ASP. Net, VB.Net
  • Extensive knowledge of using Package Configuration wizard to configure SSIS packages.
  • Expertise in creating Property Expressions, Script Tasks for SSIS packages.
  • Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008/2012/2014 .
  • Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
  • Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
  • Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS 2005/ 2008/2012/2014 . Extensively worked in sorting the data, defining subtotals for the reports.
  • Responsible for Application security of the developmental application system databases
  • Migrated DTS objects to SQL Server Integrated Services environment, migrated data from SAS environment to SQL Server 2008/2012/2014 via SQL Server Integrated Services
  • Implemented SSIS data, created maintenance procedures and provided data integrity strategies.
  • Experience in multidimensional databases with demonstrated ability to create calculated members and MDX scripting.
  • Worked in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Involved in Analyzing, Designing, Building and testing of OLAP Cubes using SQL Server Analysis Services(SSAS)
  • Created Data Model or the Marketing Information System Team using Erwin.
  • Implemented Snow Flakes Schema and Star Schema
  • Worked with Development teams in relation to application tuning and Performance tuning
  • Involved in the Database design (Logical Data Modeling and Physical Data Modeling) of the system and worked with tools like ER Studio 8.5
  • Expert in creating Star schema cubes using SSAS.
  • Extensively worked on OLAP cubes using SSAS.
  • Created and Managed OLAP Cubes using SSAS.
  • Involved in writing MDX queries and performance optimization of the SSAS cubes.
  • Used Performance Point Server to create reports, scorecards and dashboards.
  • Involved in Performance Tuning of Code using execution plan and SQL profiler. Added Indexes to improve performance on tables.
  • Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
  • Worked in SDLC( Systems Development Life Cycle) for developing systems/Software

Environment: MS SQL Server 2008/2012/2014 , MS SQL Server Integration Services 2005/2008/2012 , SQL Server Analysis Services, MDX Cubes, MS CRM 3.0/4.0, Windows Server 2003,.NET, ASP.NET, Erwin, SQL Query Analyzer, VB.Net, C#, Unisys, Wintel, Visual Studio 2013,Visual Fox-Pro,MYSQL, HTML, Java Script, Jquery, Index Tuning Wizard, SDLC, Data Warehousing.

Confidential, Salem, OR

Sr. SQL BI Developer(SSIS/SSRS)

Responsibilities:

  • Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
  • Created Tables, Views, Indexes, Stored Procedure and Triggers. Used multiple join statements to retrieve data and update the tables. Created Backend validations using Insert/Update and Delete triggers.
  • Extensively used Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources.
  • Developed, monitored and deployed SSIS packages.
  • Worked in transferring the data using SQL Server Integration Services packages Extensively used SSIS Import/Export Wizard for performing the ETL operations
  • Extensive knowledge of using System Variables and creating User-Defined Variables for SSIS Packages.
  • Experience in designing the project design document.
  • Analysis of 834 and 820 EDI Transactions for Health Insurance Exchange (HIX).
  • Create Test Case and Test Scenario based on X12 834 E2E Functional Testing.
  • Worked on trouble-shooting of claim processing issues with the providers and hospitals .
  • Hands on experience with daily claim processing and uploading 837 files into database.
  • Worked extensively on analyzing and testing the 837 institutional and professional EDI transactions.
  • Extensive knowledge of using package configuration wizard to configure SSIS packages.
  • Implemented SSIS data, created maintenance procedures and provided data integrity strategies.
  • Worked with Development teams in relation to application tuning and Performance tuning
  • Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
  • Designed and created Report templates based on the insurance data.
  • Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008/2012.
  • Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
  • Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
  • Created data driven subscriptions for different users using Report Manager.
  • Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS 2008/2012. Extensively worked in sorting the data, defining subtotals for the reports
  • Identified and added the report parameters and uploaded reports on to the report manager and organized them in folders.
  • Worked in SDLC (Systems Development Life Cycle) for developing systems/Software.
  • Created ETL packages using SSIS to move data from various heterogeneous data sources.
  • Tested the application for deployment, Function and behavior

Environment: MS SQL Server 2008/2012, Teradata12, MS SQL Server Integration Services 2008/2012, SQL Server Analysis Services, MDX Cubes, NET, Tidal, ASP.NET, Erwin, SQL Query Analyzer, VB.Net, C#, Visual Studio 2013, System Monitor/Performance Monitor, Event Viewer, SAN, Source Control Management System, Index Tuning Wizard, SDLC, Data Warehousing, Data Transformation Services (DTS).

Confidential, New Brunswick, NJ.

SQL BI Developer(SSIS/SSRS/SSAS)

Responsibilities:

  • Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
  • Developed high Level Design of ETL DTS Package in MS SQL Server 2005 for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
  • Created the logical and physical data modeling using Erwin tool.
  • Created SSIS packages to migrate data from Oracle 8i to MS SQL Server 2005.
  • Used BCP utilities, Data Transformation Services (DTS), Extract Transform Loading tool (SSIS) to populate data from various data sources, created packages for different data loading operations for application.
  • Created SQL server Reports using SSRS 2005 for management. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS Reports.
  • Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports
  • Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
  • Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
  • Set up hierarchies and defined Scope of Analysis in the Universe for providing drill down/ drill through options in the reporting environment.
  • Created Queries for generating drill down reports in SSRS 2005.
  • SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
  • Created Condition Objects in the Universe to restrict data
  • Created variables and defined formula to capture user responses to a prompt and to display document information for Web reports
  • Created simple SQL query filters, prompted filters and complex filters to restrict data in reports.
  • Collected business requirements, designed data maps and data models. Created Internal and External Design Documents and Transaction Definition Documents.
  • Created report in SQL Server 2005 and deployed them on local-host for remote access.
  • Created several stored procedures, triggers, views.
  • Tuned lots of ad-hoc queries and stored procedures, by creating indexes, making proper joins.

Environment: MS SQL Server2005/2000, SSRS, SSIS, SSAS, MDX Cubes, ADO,WCF, MYSQL,T-SQL,Asp.net, .NET, Stored Procedures, HTML, XML, IIS 6.0, MS Visual Studio 2005, Visual Fox-pro, DTS, Jquery, Crystal Reports 9.0

Confidential

MSBI Developer(SSIS/SSRS/SSAS)

Responsibilities:

  • Created Tables, Views, Indexes, Stored Procedure and Triggers. Used multiple join statements to retrieve data and update the tables. Created Backend validations using Insert/Update and Delete triggers.
  • Installation of SQL Server 2012/2008R2 on Production and Development environment.
  • Assigned for Database Optimization that involved re-engineering the databases, data and index organizing, performance tuning and query tuning.
  • As a part of the team, configured Transactional Replication with multiple publishers and centralized subscriber for real time reporting.
  • Also implemented Mirroring for DR Plan.
  • Created/altered/modified and tuned T-SQL complex Stored Procedures, Queries, views, tables, and functions on OLTP and OLAP environments.
  • Migrated the SCOM (System Center Operations Manager) 2007 R2 and installed required Service packs and cumulative updates to the SQL Server 2008R2 environment.
  • Broke down complex VBA code from existing Excel reports which has all pivoted data and wrote SQL scripts to overcome the Excel issue as we will be using SSRS for reports down the line.
  • Experienced in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and complex joins and sub queries in SQL Server Management studio (SSMS).
  • Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
  • Creating Logins and Roles with appropriate permissions.
  • Resolving blocking and deadlocks using DMVs, Profiler and killing respective SPIDs and also optimizing the queries, which are involved in blocking and deadlock issues.
  • Created numerous reports using reporting services SSRS and deploying them on SharePoint
  • Broke down complex VBA code to better understand the Excel reports and create SSRS reports out of it.
  • Extensively worked on OLAP cubes using SSAS.
  • Scheduling SQL Server Agent Jobs for updating statistics, checking fragmentation, checking database integrity and backup plans.
  • Involved in capacity planning, sizing and database growth projections.
  • Monitor and modify performance using execution plans and Index tuning.
  • Optimize the performance of queries with modifications in T-SQL queries like remove unnecessary columns, eliminate redundant and inconsistent data, and normalize tables.
  • Interacting with development team in writing good standard TSQL queries.
  • Applied patches, hot fixes, cleared .NET framework corruption errors.
  • Experience in using different PowerShell (DSC, ISE) environments that helps for testing, deployments and for debugging scripts.
  • Documentation, and mentoring the staff.
  • As a part of the team, was always involved in production deployment.

Environment: MS SQL Server 2005, 2008 R2, 2012, ERWIN, MS Visual Studio 2010, PowerShell, Excel, HTML, SSAS, SSIS, SSRS, SQL Server Management Studio (SSMS), T-SQL, Excel VBA (Visual Basic for Applications), BIDS, Oracle, PL/SQL. Idera, RedGate.

We'd love your feedback!