SUMMARY

• 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.

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, MicroStrategy

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: Tableau Desktop, Tableau Server, Microsoft SQL Server Reporting services SSRS, Excel Power Pivot, Excel Power view, 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, Dublin, OH

BI/Tableau Architect

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, Dublin, OH

BI Architect

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, Chicago, IL

BI Architect

Responsibilities:

• Design Tabular model for the existing DW of the client’s data.
• Developed Tableau POC for ipad dashboards
• Designed power pivot, power view, JQuery on Sharepoint
• Few Reports developed out of Microstrategy for specific department.
• 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, Dublin, OH

BI Architect

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

Confidential, Chicago, IL

BI Architect

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

BI Architect

Responsibilities:

• Designing dimensional model for the existing Relational database of Confidential 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.