We provide IT Staff Augmentation Services!

Bi Architect Resume

SUMMARY:

  • 15+ years of extensive experience building DW/ BI solutions using MSBI Stack (Azure BI, SSIS, SSAS, SSRS and SQL Server DB).
  • Good knowledge on Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, OLAP, OLTP, Star Schema, Snow Flake Schema, Fact Table and Dimension Table.
  • Expertise in developing complex MDX solutions using Calculated measures, Scope statements.
  • Experience in Requirements Analysis, Designing BI Solution Architecture, Dashboard Designing, Data modeling, Development, Deployment and Production Support.
  • Expertise in preparing Technical Design Documents, and reviewing code and design doc.
  • Experience in Performance Tuning for SQL DB as well as ETL and SSAS cubes
  • Experience in writing complex MDX queries required to create SSRS reports.
  • Experienced in PerformanceTuning to identify the bottleneck and improving the performance of Cube processing.
  • Performed Quality Assurance of data loading between cube and warehouse using MS - Excel.
  • Good knowledge on BIDS (Business Intelligence Development Studio) to build SSAS solutions and to extract SSAS structure from existing cube database.
  • Good experience in Relational Databases like SQL Server with hands on Working knowledge in SQL.
  • Experience in Self service BI tools such as PowerPivot, PowerView, PowerQuery and PowerMap.
  • Thorough knowledge of Software Development Life Cycle (Waterfall and Agile) including Planning, Analysis, Design, Implementation, Maintenance and Onshore/Offshore model.

TECHNICAL SKILLS:

Programming: PL/SQL, T: SQL, VBA, C#, Python

Databases: SQL Server 2000, 2005, 2008, 2012, 2014, Oracle 8i, 9i, MS Access, Azure SQL DB, Azure SQL DW

Business Intelligence: SQL Servicer Analysis Service, Azure Analysis Services

Reporting Tools: SSRS, XLCubed, MS Excel, PowerPivot, PowerBI

ETL Tools: SSIS, Azure Data Factory

Configuration tools: Team Foundation Server (TFS)

Operating Systems: Windows NT/XP/7/8

Project Management Tools: Microsoft Project Planner, MS Office

Other Tools: SQL Server Management Studio, Visual Studio, Visio, ER Studio, PowerApps, Microsoft Flow, Attuniy CDC for Oracle

PROFESSIONAL EXPERIENCE:

Confidential

BI Architect

Responsibilities:

  • Architecture Design for overall BI Programme
  • Dashboard design and development
  • Tech lead for the team for strategic changes.

Environment: Database - Azure SQL DW, Azure SQL DB, SQL Server 2014; Reporting - PowerBI; OLAP - Azure Analysis Services; ETL - SSIS 2014, Azure Data Factory; Scripting - Powershell; Apps - PowerApps, Microsoft Flow.

Confidential

BI Tech Lead and Report Developer

Responsibilities:

  • Analysing user requirements and translating them into technical specification documents.
  • Designing Dimensional DB Models for Reporting.
  • Populating Dimension and Fact tables from ETL staging tables using Stored Procedures (SPs)
  • Creating SPs for reporting Datasets on SQL azure using PSI deployment model.
  • Maintaining and Optimizing Stored Procedures
  • Creating and maintaining performance Reports using SSRS RDLC

Environment: SQL Azure, C#, RDLC, TFS 2013, Agile Scrum

Confidential

BI Tech Lead, Architect and Scrum Master

Responsibilities:

  • DB Architect for the team for designing Dimensional Models and optimizing the datawarehouse
  • Designing SSIS packages for ETL
  • Designing and Optimizing SSAS cubes.
  • Data validation for the SSAS cubes against Source and DW data using excel.
  • Creating and Maintaining reports using SSRS and MDX Queries
  • Data analysis for user storiesand finalizing Acceptance criteria and assumptions for user stories with Product owner
  • Developing and documenting Reusable components to monitor data and process issues.
  • Scrum Master for Monthly team dealing with Sprint Planning, Sprint progress monitoring, Stakeholder management and scope control.
  • Review of technical design documents for all MSBI projects in the account.
  • Functional Analyst for MBS BI team dealing with, analysis of Product backlogs, Analysis of Changes in systems, Creation of BRDs for Product requirement, Functional testing of Product deliverables.

Environment: Database - SQL Server 2012; Reporting - SSRS 2012, Proclarity, Excel, Powerpivot, Powerview; OLAP - SSAS-2012; ETL - SSIS 2012; MDX;

Confidential

BI Architect

Responsibilities:

  • Senior Developer/Architect for creating Dimensional Model and maintaining centralized Data-warehouse across all Product control teams in Wholesale Banking.
  • Importing, mapping and cleaning data received from various sources using SSIS for accurate revenue forecasting.
  • Creating reports for data quality alerts using SSRS and MDX, by comparing various sources of data.
  • Creating Dashboards using SSAS and XLCubed.
  • Changing old Excel and Access based controlling systems to more automated and flexible systems with MSBI, VB .Net, VBA Macros and SQL server 2005 and 2008 DB.
  • Production support and performance tuning for existing Datamarts using Profiler and Database tuning advisor.
  • Creation and maintenance of web based dashboard systems for Marketers, Traders and Management for Performance analysis and tracking.
  • Analysis of existing process flow for P&L and Risk management and designing new application of better control and reduction of manual intervention.
  • Interactions with stakeholders (end users and management team) to manage their expectations and new change requests. Communicating the stakeholders regarding the status and changes. end users to design their own reporting dashboards and helping them publish them on centralized web servers

Environment: SQL Server 2005; XLCubed, Macro based excels; OLAP - SSAS 2005, SSAS-2008; ETL - SSIS 2005; Application - VB .Net, MS Excel, VBA Macro

Confidential

Reporting Tech Lead and Architect

Responsibilities:

  • Design, development and support of Datamarts (MS SQL Server 2005/2008 and SSIS2005) and maintenance of DBs including Replication and mirroring
  • Design and Development of OLAP Cubes (SSAS2005) and Reports (SSRS2005)
  • Design, development and scheduling of SSRS reports and Maintenance of the same.
  • Creation of new tools and reports for CFOs and Bankers using Excel VBA and SQL server (T-sql)
  • T-SQL and MDX Query tuning and performance tuning of long running reports and stored procedures.
  • Coordinating with Application teams and end users of the reports
  • Interactions with end-users to evaluate business requirements and prioritize the queue
  • Managing the IBD Reporting team (size 8-14) in Bangalore office

Environment: Database -SQL Server 2005,2008;T-SQL; Reporting - SSRS 2005, SSRS 2000, Crystal Reports 9.0, OLAP - SSAS 2005, ETL - SSIS 2005; MS Excel, MS Access, VBA Macro

Confidential, New York, NY

Reporting Tech Lead and Architect

Responsibilities:

  • Design, development and support of Datamarts ( MS SQL Server 2005 and SSIS2005)
  • Creation of new tools and reports for CFOs and Bankers using Excel VBA and SQL server ( T-SQL)
  • Design and Development of OLAP Cubes ( SSAS2005) and Reports ( SSRS2005)
  • Design, development and scheduling of SSRS reports and Maintenance of the same.
  • T-SQL Query tuning and optimization of long running reports and stored procedures.
  • Scheduling and Tracking tasks and efforts for the reporting team.
  • Coordinating with Application teams and end users

Environment: Database - Oracle8i, SQL Server 2000& 2005, Reporting - Powerbuilder6.5 Datawindow, Crystal Reports9.0, SSRS2000& 2005, OLAP - SSAS2000& 2005, ETL - DTS 2000& SSIS 2005; MS Excel, VBA Macros

Hire Now