We provide IT Staff Augmentation Services!

Bi Architect Resume Profile

PROFESSIONAL PROFILE:

  • BI DW Architect with close to 11 years of experience in planning, managing and Implementing end to end data warehouse solutions, leveraging expertise and resources to create opportunities for business growth and development
  • In depth experience in areas of Business intelligence BI , Data warehouse DW , Master data management MDM , Data Visualization, meta data management, data governance and quality management
  • Studied with Ralph Kimball on Data warehouse life cycle
  • Facilitated training sessions and brain storming sessions product, system and process improvements
  • Experience in Data Warehousing and Data Mining with emphasis on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems in the Retail, Automobile, Energy, and Infrastructure industries. Involvement in all phases of SDLC Systems Development Life Cycle from analysis and planning to development and deployment.
  • Expertise in designing and developing Schemas, Dimensional Models, OLAP Structures, Cubes, Reports, Mining Models
  • Experience with InMemory analytics with various supporting tools, Self-service BI.
  • Expertise with Optimizing and Tuning standard and Customized OLAP database system to maximize their performance and operation
  • Expertise with designing best data visualization with various Reporting tools
  • Strong leadership skills with the ability to adapt to challenges and to mentor team members.
  • Strong analytical and problem solving skills.

ACHIEVEMENTS:

  • Awarded Microsoft Student Partner by Microsoft India Pvt Ltd in recognition for contribution to the academic Community.
  • Awarded prize in Design Competition for Software Code reviews conducted by Hyderabad Software Exporters Association HYSEA and Government of AP across the State.
  • Successfully completed all the sessions of Leadership skills training conducted by HYSEA.
  • Several prizes won in software debugging, coding, designing contests and Sports Events.

TECHNICAL SKILLS:

ETL Tools

Microsoft SQL Server Integrations Services SSIS 20XX , Informatica 8.x , Kalido

Data Modeling Tools

Erwin 4.x, MS Visio. Kalido DIW, Kalido MDM, MS SQL MDM , MDS , DQS

Databases

SQL Server 2000/2005/2008/2010/2013/2014, Oracle 9i, SQL, MDX, DAX, MongoDB, ,Cassandra

OLAP

Microsoft SSAS, Microsoft Tabular Models, Business Object, COGNOS, QlikView

Languages

C, C , XML, HTML,MDX,DMX, VB,ASP,ADO SQL, T-SQL, Java script, NOSQL, Hive

Operating System

Windows 9x/NT/2000/XP, Windows Server 2008, UNIX Solaris, HP-UX, AIX .

Office Applications

MS Office 2010, 2013

Other Reporting Tools

Microsoft SQL Server Reporting services SSRS, Excel Power Pivot, Excel Power view, Tableau Desktop, Tableau Server, Performance Point Server , ProClarity , Strategic Analyzer

Other Applications

Share Point Services, Microsoft office Share Point Server MOSS 2007, Business Intelligence Development Studio, ASP.Net,ADO.Net,VB.Net

PROFESSIONAL EXPERIENCE:

Confidential

Role: BI Architect

Tools: Tableau, SQL Server 2012, MS tabular Models 2012, MS Reporting Services SSRS 2012, MS Share Point Services, Excel Power pivots, Excel Power view

Responsibilities:

  • Design Tabular model on quick basis connecting to various systems of the organization.
  • Optimize the tabular model for real time In memory processing and providing live reports
  • Designed power pivot, power view data presentation from Tabular model
  • Designed and developed Tableau dashboards connecting to SSAS and excel.
  • Developed Reports on Tableau desktop, designed and set up Tableau server for various security settings
  • Configured and hosted several tableau dashboards on the Tableau Server
  • Multiple dashboards, reports and KPIs on Tableau desktop and server for various departments of the Organization

Confidential

Role: BI Architect

Tools: Microsoft Master Data Service, Data Quality Service, Excel 2013, Explorer

Responsibilities:

  • Design of Entities, Collections, Relations for Master Data.
  • Analyst to talk to business and finalize on the User Hierarchies.
  • Create Feeds to pull in master data from all the Source Systems
  • Mapping data with Golden records and Loading of Master tables and version implementation
  • Configured, designed feeds to load on a regular basis
  • Excel front end to merge, migrate, change the master data

Confidential

Role: BI Architect

Tools: SQL Server 2012, MS tabular Models 2012, MS Reporting Services SSRS 2012, MS Share Point Services, Tableau, Excel Power pivots, Excel Power view, JQuery controls for data grids

Responsibilities:

  • Design Tabular model for the existing DW of the client's data.
  • Optimize the tabular model for real time In memory processing and providing live reports
  • Designed power pivot, power view , JQuery data grids for the data presentation from Tabular model
  • Configured, designed SharePoint site to host the power pivots, power view reports for the end users
  • Designed and developed Tableau reports for supporting mobile usage
  • Security configuration between the tabular model, DW, SharePoint services and user AD's
  • Implemented best practices to efficiently use the huge hardware and multiple cores provided for the In memory analytics.

Confidential

Role: BI Architect

Tools: Kalido, Visual Studio 2008, SQL Server 2008, MS Analysis Server SSAS 2008, MS Reporting Services SSRS 2008, Performance Point Server 2007, Microsoft Office SharePoint Server 2007

Responsibilities:

  • Designed dimensional models from the existing OLTP systems
  • Architectural design for creation of financial, inventory and merchandizing reports.
  • High volume ETL framework SSIS including parent/child relationships, variable and expression management, custom event logging and package management SSIS API
  • Construction of data mart, relational and multi-dimensional modeling, analysis cubes OLAP , and extensive MDX expressions/queries
  • Designing Master data and loading the Master data using Kalido MDM
  • Additional responsibilities : T-SQL and MDX performance tuning, staff monitoring, documentation and best practices

Previous Projects:

Confidential

Role: BI Architect

Tools: Visual Studio 2008, SQL Server 2008, MS Analysis Server SSAS 2008, MS Reporting Services SSRS 2008, Performance Point Server 2007, Microsoft Office SharePoint Server 2007

Responsibilities:

  • Designed dimensional models from the existing OLTP systems
  • Resolve semantic discrepancies in data definitions that arise among multiple sources and projects.
  • Designing OLAP structures depending on the Relational data models and providing the consumption of the cube data by the end user through pre built reports using Reporting Services
  • Coach project teams on various architectures and data issues through all phases of development and maintenance life cycles
  • Implementing dimensional model and creating cubes using MS Analysis services.
  • Designed data mining models to get the trends and sales hidden in the data.
  • Implemented market based analysis algorithm to find the cross sales between items.

Confidential

Role: BI Architect

Tools: SQL Server 2008, MS Analysis Server SSAS 2008, MS Reporting Services SSRS 2008, Performance Point Server 2007, Microsoft Office SharePoint Server 2007

Responsibilities:

  • Designing dimensional model for the existing Relational database of CITI bank.
  • Implementing dimensional model and creating cubes using MS Analysis services.
  • Performance tuning of Cubes and reports using Partitions. Linked measures and linked dimensions.
  • Created sub cubes for better usability
  • Performance tuning of Reports and MDX queries to present real time data on the dashboards for the end users Reports with huge data to run in less than 5 secs .
  • Created Score Cards and Dashboards and present them on the customized Asp.Net pages to Report Critical KPI's using different web parts.
  • Created Mining structures and mining models to predict the Foreign Exchange conversion rate depending the past history from a data warehouse.
  • Designed web parts to present real time Fx conversion rates and risk amount through RSS feeds and Mining models.

Confidential

Role: BI Architect

Tools: SQL Server 2008, MS Analysis Server SSAS 2008, MS Reporting Services SSRS 2008, Performance Point Server 2007, Microsoft Office SharePoint Server 2007

Responsibilities:

  • Extracting, transforming and loading data from ERP to DW using SSIS packages
  • Designing Cubes depending on the Relational data models and providing the consumption of the cube data by the end user through pre built reports using Reporting Services. All the reports are parameter driven like different time periods, currency formats, mining models etc.
  • Created Score Cards and Dashboards using Microsoft Performance point server to Report Critical KPI's
  • Configure and Create SharePoint site with Reporting services integrated mode and Integrate Reports and Performance Point Dashboards into the site
  • Developed dynamic calculated members, Queries cubes and mining structures using MDX and DMX

Hire Now