We provide IT Staff Augmentation Services!

Sr. Msbi Developer/(ssis, Ssrs, Ssas) Resume

Denver, CO

SUMMARY:

  • A Microsoft Business Intelligence Professional with 8 years of strong experience in all phases of SDLC, including gathering Business Requirements, Design, Development, Testing and Implementation of large - scale enterprise applications in Healthcare and Financial domain.
  • Expert in Performing Transformations using SSIS; ADHOC, Parameter, Cascading Reporting using SSRS, Developing Cubes using SSAS.
  • Broad experience with Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP and OLAP as per business needs.
  • Worked with T-SQL, DBCC, DCL, DDL, DML, PL/SQL Scripts and established relationships between tables using Primary Keys & Foreign Keys.
  • Highly proficient in the use of T-SQL for developing complex Stored Procedures, Views, Sub queries and SQL joins to simplify complex queries involving multiple tables.
  • Very strong in creating and maintaining database objects like Indexes, User Defined Functions, Triggers, recursive queries using CTEs in SQL Server.
  • Experience in implementing different types of Replication models like Snapshot, Transactional and Merge Replication.
  • Experience in Change Data Capture (CDC), Change Tracking (CT).
  • Expert in Query Tuning activities including Updating Statistics, Re-building and Re-organizing Indexes.
  • Expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.
  • Experience in developing reports and dashboards in MS Power BI.
  • Excellent Experience in publishing Dashboards to Tableau Server.
  • Rebuild online index and worked with Dynamic Management Views (DMV) for improving query performance based issues on the server.
  • Resolved issues with Indexes, Blocking and locking issues to remove the performance bottlenecks and used Profiler to solve Dead Locks.
  • Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology.
  • Expertise in developing complex SSIS Packages including C# scripting to extract data from heterogeneous data sources.
  • Developed SSIS packages for processing fact and dimension tables with complex transforms and Slowly Changing Dimensions type 1 and type 2 changes.
  • Hands on experience in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
  • Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using (SSRS).
  • Experience in developing various kind of reports like Cascading parameters, Drill down, Drill through, Sub Reports and Charts.
  • Experience in designing complex reports including sub reports and formulas with complex logic using SSRS.
  • Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
  • Experience in analyzing Data ware house by building cubes using SSAS.
  • Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SSAS.
  • Created and scheduled SQL SSIS Jobs.
  • Solid Knowledge in developing cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions etc. and created various user roles.
  • Experience in Agile (Kanban and Scrum) and water-fall methodologies.
  • Strength in problem solving and effective team player with excellent analytical, troubleshooting, and conflict resolution.
  • Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#.NET, VB.NET, ADO.NET
  • Designed Dll's for the SSIS packages for scripting task using C#
  • Strong experience in mentoring team members and writing documentation.
  • Good analytical, written, communicational and interpersonal skills.
  • Have proven track record working with various environments and a valuable ability to quickly pick up new technologies and become an asset to the company in a minimal amount of time.

TECHNICAL SKILLS:

DATABASES: MS SQL Server 2005/2008/2008 R2/2012, Oracle

PROGRAMMING: T-SQL, PL/SQL, C, HTML,C# .NET, VB.NET, ADO.NET

WEB TECHNOLOGIES: Active X, Internet Information Services (IIS).

ETL TOOLS: DTS, SQL Server Integration Services (SSIS).

OLAP TOOLS: SQL Server Analysis Services (SSAS).

REPORTINGTOOLS: SSRS, Report Builder, Micro Strategy, Click View, Tableau, MS Power BI.

VERSION CONTROL: Team foundation Server (TFS), Visual Source Safe (VSS).

OPERATING SYSTEMS: Windows XP/2007/2010

DATAMODELLING TOOLS: Erwin 4.x/7.x, MS Visio 2000/2003

AGILE TOOLS: Jama 4.0 and Rally

SQL SERVER TOOLS: SSMS, Enterprise Manager, SSDT, Query Analyzer, Profiler, Performance Monitor

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Sr. MSBI Developer/(SSIS, SSRS, SSAS)

Responsibilities:

  • Responsible for requirement gathering from Business users.
  • Worked in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets, Oracle, Salesforce and heterogeneous data to and from SQL Server.
  • Responsible for analyzing, transforming and visualizing the date using MS Power BI.
  • Improved query performance by adding covered indexes, adding file groups etc.
  • Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
  • Responsible for creating joins, joins with custom SQL & blending data from different data sources using MS Power BI Desktop.
  • Done the calculations using MS Power BI (Aggregate, Date, Logical, String, Table, LOD Expressions)
  • Implemented data validations using script task and script components.
  • Responsible for administering user, user groups, and scheduled instances for reports in Tableau.
  • Created and scheduling of Jobs
  • Created and deployed Reports utilizing Tableau to design complex reports.
  • Scheduled Jobs to run SSIS package using UC4/Atomic scheduler.
  • Used DTS Migration Wizard to convert DTS to SSIS packages and develop new SSIS packages.
  • Worked on PL/SQL developer to interact with Oracle databases.
  • Developing cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions etc. and created various user roles
  • Involved in implementing Data blending, Replace references, customized queries and advanced visualizations in Tableau.
  • Experience in implementing Data blending, Replace references, Customized queries and advanced visualizations in Tableau.
  • Responsible for designing and deploying data visualizations using Tableau.
  • Designed Dll's for the SSIS packages for scripting task using C#
  • Created packages in SSIS with error handling using various data transformations.
  • Creating and managing schema objects such as tables, views, joins, indexes, functions, procedures, CTE’s, triggers & maintaining Referential Integrity.
  • Improved query performance by adding covered indexes, adding file groups etc.
  • Created and deployed Reports utilizing SSRS to design complex reports.
  • Created cascading parameters for SSRS reports as well as drill-down, drill through, sub reports and interactive sorting capability.
  • Implemented subscriptions and snapshots in the SSRS Report Manager, report security, report delivery. Integrated reports from SSRS with SharePoint.
  • Migrated existing SSIS packages and SQL Server databases to new HIPPA server for security compliance.
  • Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#.NET, VB.NET, ADO.NET
  • Worked closely with Micro strategy team for reporting requirements.
  • Scheduled Jobs to run SSIS package using UC4/Atomic scheduler.

Environment: SQL Server 2008/2012, SQL, Enterprise manager, SSAS, SSIS 2008/2012, SSRS,MDX Cubes, Tableau, MS Power BI, SQL Compare, SQL Data Compare,UC4/Atomic, Rally, SQL Sentry.

Confidential, Broomfield, CO

Sr. MSBI Developer/ Tableau (SSIS, SSRS, SSAS)

Responsibilities:

  • Responsible for requirement gathering from Business users.
  • Worked in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets, Oracle, Salesforce and heterogeneous data to and from SQL Server.
  • Responsible for analyzing, transforming and visualizing the date using MS Power BI.
  • Improved query performance by adding covered indexes, adding file groups etc.
  • Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
  • Responsible for creating joins, joins with custom SQL & blending data from different data sources using MS Power BI Desktop.
  • Done the calculations using MS Power BI (Aggregate, Date, Logical, String, Table, LOD Expressions)
  • Implemented data validations using script task and script components.
  • Responsible for administering user, user groups, and scheduled instances for reports in Tableau.
  • Created and scheduling of Jobs
  • Created and deployed Reports utilizing Tableau to design complex reports.
  • Scheduled Jobs to run SSIS package using UC4/Atomic scheduler.
  • Used DTS Migration Wizard to convert DTS to SSIS packages and develop new SSIS packages.
  • Worked on PL/SQL developer to interact with Oracle databases.
  • Developing cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions etc. and created various user roles
  • Involved in implementing Data blending, Replace references, customized queries and advanced visualizations in Tableau.
  • Experience in implementing Data blending, Replace references, Customized queries and advanced visualizations in Tableau.
  • Responsible for designing and deploying data visualizations using Tableau.
  • Designed Dll's for the SSIS packages for scripting task using C#
  • Created packages in SSIS with error handling using various data transformations.
  • Creating and managing schema objects such as tables, views, joins, indexes, functions, procedures, CTE’s, triggers & maintaining Referential Integrity.
  • Improved query performance by adding covered indexes, adding file groups etc.
  • Created and deployed Reports utilizing SSRS to design complex reports.
  • Created cascading parameters for SSRS reports as well as drill-down, drill through, sub reports and interactive sorting capability.
  • Implemented subscriptions and snapshots in the SSRS Report Manager, report security, report delivery. Integrated reports from SSRS with SharePoint.
  • Migrated existing SSIS packages and SQL Server databases to new HIPPA server for security compliance.
  • Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#.NET, VB.NET, ADO.NET
  • Worked closely with Micro strategy team for reporting requirements.
  • Scheduled Jobs to run SSIS package using UC4/Atomic scheduler.

Environment: SQL Server 2008/2012, SQL, Enterprise manager, SSAS, SSIS 2008/2012, SSRS,MDX Cubes, Tableau, MS Power BI, SQL Compare, SQL Data Compare,UC4/Atomic, Rally, SQL Sentry.

Confidential, Dallas, TX

Sr. MSBI Developer (SSIS, SSRS, SSAS)

Responsibilities:

  • Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
  • Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
  • Imported data from text files and excel spread sheets into SQL Server database using SSIS package.
  • Extensive experience in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
  • Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, INT, UAT and Production.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
  • Worked on developing Tablix Reports, Matrix Reports, Parameterized Reports, and Sub Reports using SSRS 2008.
  • Experience in creating Ad hoc reports Using Report Builder 1.0 and Report Builder 2.0.
  • Involved in Migration of SSRS 2005 to SSRS 2008.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, Oracle 11g, Hyperion 11.1, Performance Point Server 2007, Report Builder 2.0.

Confidential, FL

Sr. MSBI Developer(SSIS, SSRS, SSAS)

Responsibilities:

  • Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
  • Generated Monthly and quarterly Reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
  • Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS.
  • Used Performance Point Server to create interactive reports with an ability to drill down into details.
  • Generated pivot tables using the cube data in SSAS and delivered reports using SSRS by using the connection string as SSAS.
  • Involved in building of OLAP cubes with SSAS and in adding calculations using MDX
  • Involved in creating Data mappings in SSIS and created data models using ERWIN tool.
  • Use DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Wrote custom T-SQL stored procedures, indexes, cursor, functions and triggers to improve performance, preserve referential integrity, and provide additional application functionality.

Environment: SQL Server 2008, SSIS, SSRS, SSAS, OLAP, OLTP, XML, Windows 2000/2003 Server, Erwin, Performance Point Server 2007.

Confidential, Irving, TX

MSBI / SQL Server Developer (SSIS, SSRS)

Responsibilities:

  • Analyzing the problems in the production environment and try to develop new procedures and methods for monitoring the problems and send alert messages to take pro-active action.
  • Created new database objects like Procedures, Functions, Packages, Indexes and Views using T-SQL in SQL Server 2005.
  • Worked on Client tools like SQL Server Management studio to administer SQL Server.
  • Data conversions and data loads from various databases and file structures.
  • Created SSIS Packages to load the data from different carriers like Verizon, sprint and AT&T.
  • Developed SSIS master package which include number of child packages.
  • Developed parameterized, caching, sub and Ad Hoc reports using SSRS.
  • Wrote Complex SQL Queries to generate Reports based on the business requirement.
  • Designed and developed Drill down and Drill through reports using SSRS.
  • Created Parameterized reports and Linked reports which navigates to other report.
  • Scheduled reports for Daily, Weekly, Monthly reports for various categories and regions based on business needs using Reporting services (SSRS)
  • Formatted the reports using the global variables and expressions in SSRS, deployed the generated reports on to the Reporting server.

Environment: Microsoft SQL Server 2005, BIDS, Team Foundation Server (TFS), Windows server 2003, Internet Information Server (IIS), Microsoft Office 2010.

Hire Now