BI Solution Architectg

Cloud Based BI Data Warehousing Data Visualization

ARCHANAJAIN

Phone: 669-***-**** Email: *******.***@*****.***

LinkedIn

Profile

Accomplished Business Intelligence Solution Architect with a 14-year stellar track-record of implementing complex BI Solutions.

Worked extensively on cloud based BI architecture on environments like Azure and AWS

Global professional – Worked for multiple Fortune 500 customers in the United States, Europe and India.

Deep experience in Project, Program, Process and People management for extended, complex software projects along with building BI solutions for Banking, HR, Health and Public Services, Capital Markets and Operational Functionality.

Skills

Cloud Based BI Architecture

Deep experience in design and development of cloud based BI architecture on Azure and AWS

Data Visualization

Extensively used tools like Tableau and Power BI to provide Dynamic Dashboards.

Microsoft BI Architecture

Accomplished across the Microsoft BI stack – SSIS, SSRS and SSAS.

Data Modeling

Specialization in design and optimization of conceptual, logical and physical data models.

Data Warehousing

Significant experience in designing Data Warehousing and Marts models using MS SQL Server including Data Integration, Data Security, Metadata Management, Data Governance, and Data Quality.

Project and Program Management

Managed multiple complex projects with complete people and process management responsibilities. Exposure to both Waterfall and Agile Methodologies using Rally.

Work Experience

DATEWARE HOUSE ARCHITECT SOLUTION ARCHITECT - Fortinet Inc.

Aug 2018 – Till Now

Developed Enterprise Data warehouse for the IT division of Fortinet.

Architected complete Dimensional Data Modeling to pull in financial data from upstream data sources.

Developed BI solution using SSIS, SSAS and SSRS for covering complete calculation logic in the business dashboards.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Restricted data for particular users using Row level security and User filters.

Developed Tableau visualizations and dashboards using Tableau Desktop.

BUSINESS AND INTEGRATION ARCHITECT TECH MANAGER–Accenture Inc.

Sep 2012 – March 2018

●Led a team of technical architects in developing various data warehouses and marts on various platforms including cloud platforms such as AWS and Azure.

●Worked on Azure data warehouse to provision various client data warehouse on the cloud and help in machine learning algorithms.

●Implemented big data Mongo DB for web analytics team for Travelers customer to analyze their web traffic to develop business dashboards.

●Worked with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.

●Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

●Worked on multiple projects for clients in developing complete end to end BI solutions using SSIS, SSAS and SSRS dashboards.

●Integrated and data modeled various customer legacy database systems and migrated them to cloud based BI solutions to enable predictive analysis and competitive analysis for a major European Customer.

●Developed various reports pertaining to Accenture Sales and Pipeline on Power BI and MS BI stack. This model included dynamically generated tables and charts for stake holder visualization on mobile/IPAD.

●Managed Roadmap, create detailed requirements, prioritize project deliverables and ensure delivery.

●Clients Involved: Accenture Digital, Unilever, Verizon, Travelers, AON.

TEAM LEAD Accenture Inc.

Apr 2009 – Sep 2012

●Designed and built analytical models to generate various C-Suite dashboards in MS SSRS reporting tool.

●Led a web analytics team by integrating upstream source system databases and developing reports for clients using HADOOP and HIVE.

●Worked as offshore SME for ETL solution from Smith Barney to Morgan Stanley ClientServ application as a part of MS takeover using SQL Server as data warehouse and SSIS as ETL solutions.

●Represented Accenture as Onshore co-coordinator based out of our customer American Express with core responsibilities of requirement analysis, system design, estimating timelines.

●Clients Involved: Health Dialog, Morgan Stanley American Express

SOFTWARE ENGINEER- Accenture Inc.

Dec 2003 – Apr 2009

●Worked on developing several .NET solutions for major clients such as Bell South.

●Designed and implemented the ETL layer like Business Objects BODI and MS SSIS by developing data warehouse and operational databases.

●Worked extensively with various teams while data modeling and developing ETL, analytical and reporting layers of BI stack

●Clients Involved: Health Dialog, Accenture Command Center, ATnT, Kaiser

Education

●BACHELOR OF ENGINEERING– Computer Science, Visveshwaraya Tech University, India

●MICROSOFT CERTIFIED TECHNOLOGY SPECIALIST AND MCSD (SQL SERVER, BI)

Contact this candidate