We provide IT Staff Augmentation Services!

Bi Architect And Sme Resume

SUMMARY:

  • Overall 16 plus years of experience with over 10 years of experience in developing large scale software, business intelligence, ETL, and data warehousing Projects using AWS, Big Data, Power BI, Microstrategy, Oracle and Microsoft technologies.
  • Strong Leadership, Teamwork, Client Management, and problem - solving skills
  • Worked extensively in all phases of a SDLC like Requirement gathering & analysis, data modeling, analysis, implementation, performance tuning, documentation, production support and maintenance.
  • Strong Experience in BI tools, MS Project, Microsoft .Net (ASP.Net, C#, VB) and SQL Server

TECHNICAL SKILLS:

Business Intelligence: Power BI, Microstrategy, ETL, Microsoft BI Stack (SSIS, SSRS, SSAS)

Data Warehouse Skills: Dimensional Modeling, Star and Snowflake schema designs.

Cloud: AWS, Microsoft Azure, Dell Boomi

Big Data: Hadoop, Spark, Horton Works, Python

.Net Technologies: C#.Net, VB.Net, Asp.Net, Windows Applications, Crystal Reports

Databases: Redshift, MS SQL Server, My Sql, Oracle, TeraData (Workshop attended)

Analysis & Design: UML, Use case writing, Class Diagram, Sequence Diagrams

PROFESSIONAL EXPERIENCE:

BI Architect and SME

Confidential

Tools: Microsoft BI Stack (SSIS, SSAS, SSRS), Power BI, Microsoft SQL Server, Microsoft Azure, Azure Analysis Services

Responsibilities:

  • Working as BI SME to move organization from Cognos to Power BI and Azure Analysis Services
  • Data Modeling for Azure Analysis Services Tabular Model.
  • Integrate Sales, Marketing, Inventory, Customer, Finance Data into Tabular Models to get one system for unified reporting
  • Power BI Embedded reports in Microsoft Dynamics 365
  • Implementing Power BI across the organization. Migrating from Cognos.
  • Design and implement the effective Visualizations in Power BI through native and custom Visuals
  • Design and create Power BI reports and dashboards to provide valuable, relevant business insights and analytics to various departments across the enterprise.
  • Use Azure services, functions, power shell scripts for automation.
  • Executive Power BI Dashboards for C-Level users.
  • SSRS reports delivery to email for store managers and sales reps.

Senior Delivery Lead - BI and Applications

Confidential

Tools: Microsoft BI Stack (SSIS, SSAS, SSRS), Power BI, Microsoft SQL Server, Microsoft Azure, Dell Boomi, Snow Flake

Responsibilities:

  • Analyze the business processes of RT (Sales, Inventory, Pricing, financial reports) and translate into requirements documents for BI solution
  • ETL: Implement the integration of various source systems into one Data warehouse. Thorough Dimensional Modeling.
  • Design and implement the Ad-hoc Reporting framework using MS BI Stack and Power BI
  • Design and create Power BI reports and dashboards to provide valuable, relevant business insights and analytics to various departments across the enterprise.
  • Used Spark, Python, OLAP services, data marts & cube design for advanced analytics and Trend analysis reporting.
  • Executive Power BI Dashboards for C-Level users.
  • SSRS reports delivery to email for store managers and sales reps.

Big Data / Reporting Delivery Lead

Confidential

Tools: AWS, Redshift, Horton Works/Cloudera, Apache Nifi, Power BI, Microsoft SSAS

Responsibilities:

  • Build Data Lake organization wide using Amazon Web Services and ETL with Apache Nifi
  • Implement the Big Data structure using Horton works/Cloudera platform.
  • Implemented Power BI reports and Dashboards to show data mining/discovery results
  • Created Executive dashboards in Power BI to show Sales growth and Inventory forecasting.
  • Commercial Data Warehousing/ Data Marts Implementation and dimensional modeling.
  • Designed and Implemented SSRS reports for detailed sales transaction reports
  • OLAP modeling and implementation using Microsoft SSAS for adhoc - reporting using Power BI.
  • Multi Data source mashing in Power BI for cohesive reporting.
  • Complex DAX calculations in Power BI reporting
  • Created Power BI workspaces for collaboration among users.

Senior BI Lead

Confidential

Tools: Microsoft BI Stack (SSIS, SSAS, SSRS), Power BI

DB: Microsoft SQL Server

Responsibilities:

  • Worked as a hands-on Architect BI Consultant.
  • Setup Reporting platform on Power BI. Implemented executive Dashboards.
  • Implemented Collaborative Power BI workspaces for Users to share their reports across organization
  • Built and Maintained ETL processes gathering data from Wholesale, retail, E-com and ERP systems.
  • Implemented the integration of various Banners’ source systems into one Data warehouse.
  • Developed OLAP services, Power BI Dashboards, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week
  • Maintenance of ETL processes with database as SQL Server 2016.

BI Lead

Confidential

Tools: and Technologies Used: Microstrategy 9.0.1, Microstrategy 10 DB: Oracle 10g

Responsibilities:

  • Worked as an onsite Technical Data lead for Liz Confidential ’s Enterprise Retail/Whole Business Intelligence Platforms.
  • Managing a team of 5 developers.
  • Expert in all aspects of Retail BI (Sales, Inventory, customer, operational, financial Analytics)
  • Responsible for business analysis with users, technical design and delivery.
  • Designed and implemented the integration of various source systems (ERP, CRM, MRP) into one Data warehouse.
  • Took the Mobile BI initiative, designed Mobile BI interfaces, interactive dashboards and documents for iPad, tablets and Mobile screens.
  • Designed and implemented the Ad-hoc Reporting framework.
  • Designed and implemented the centralized MDM system for single source of information across the enterprise.
  • Implemented statistical analysis & Data mining tools perform demographic analysis, customer analysis and business information analysis to identify business patterns, market gaps & opportunities.
  • Designed and created reports and documents to provide valuable, relevant business insights and analytics to various departments across the enterprise.
  • Integrated Dashboards to Microsoft SharePoint site of the enterprise through web parts.
  • Used OLAP services & Intelligent cube design for advanced analytics and Trend analysis reporting
  • Implemented the scheduled reporting
  • Worked as a Project Manager. Managed a team of 10 developers
  • Designed and delivered the distributed Replenishment system for Confidential ’s warehouses and stores.
  • Extensive work in ASP.net and sql server.
  • Managed client at Confidential ’s through close interaction.
  • Managed client’s requirement, get them translated into functional documents, get it implemented by project team and deliver it to Confidential ’s at agreed timelines.

Hire Now