Azam Shaik

Team Lead- Power BI Architect – with 13+ years of experience in Data Analytics, Business Intelligence-Power BI, Data Engineering and Technical Solutions, Architectural Designs, BI requirements and defining the strategy, technical architecture, implementation plan, delivery of databases & Data warehouse and for establishing the long-term strategy and technical architecture as well as the short-term scope for a multi-phased data warehouse effort. Managing and lead a technical team of both onsite and offshore members. Evaluate existing IT systems (Oracle, SQL Server, ETL, BI, and Data Modeling) and provide recommendations for To-Be architecture compliance/evolution, including specific recommendations for implementation within AWS and Azure

• Experience in Business Intelligence, Data Development , Data Analytics and Business Analytics
• Act as an intermediary between business requirements and technological solutions, assisting in the development of technological options that satisfy the demands of clients.
• Lead Power BI architect driving architecture and governance decisions including Power BI Premium capacity and Pro license provisioning and allocation, user training and support, Dev, Prod environment configuration, reference diagrams and governance documents.
• Developed large-scale analytical models via Power BI Datasets and Azure Analysis Services to serve as semantic layer for data visualization, report development, and ad hoc analysis
• Work with clients to grasp their business issues, produce technical architecture, and help define the scope of the solution while advancing the client to a more mature state.
• Created target architecture diagrams and led architecture meetings including server topologies and hardware requirements to support multiple environments (Dev, Test, Prod) for both Azure and On-Premises environments
• Converted client requirements and current state processes into modern and/or enhanced MSBI solutions leveraging Power BI, SQL Server Analysis Services and Azure Analysis Services, and other MS Azure technologies
• Developed custom paginated operational reporting solutions targeting Power BI Report Server and Power BI via both T-SQL queries against SQL Server and DAX queries against Analysis Services Tabular database leveraging report parameters and expression-based formatting
• Experience in Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, and Fact and Dimension tables.
• Experience in ERP-SAP, Primavera, CRM and Statistical Software like SPSS Power BI External Business Intelligence Integration 
• Knowledge of data modeling, integration, governance, security, and architecture
• Manage the data analytics team for data analytics program. Responsible for data delivery from data sourcing, data transformation to data modeling and validation
• Power BI data modeling, report design, development and deployment of the Power BI Service and Reporting server;

  experience managing end-to-end projects and managing the team in this area.

• Experience in designing the external enterprise/modern data warehouse solution plans for SQL Server, Big data, Oracle and Snowflake, Azure Cloud technologies
• Proven experience in High Level Designs(HLD) and Low level designs(LLD) and/or delivering interactive Data solutions that meet the needs of diverse sets of stakeholders
• Experience in designing the solutions for structured and unstructured data architectures for Dimensional and modern data warehouses
• Developing and implementing an overall organizational data strategy that is in line with business processes and Analyzing structural requirements for new software and applications
• Experience in Project Management-Planning, Development, Execution and Delivery using Jira, WBS techniques
• Experience in Banking- Business Intelligence-Power BI architectural enhancements – digital banking Products journey insights reporting, CASA, Credit Cards, Partnership Credit Cards reporting, NHL and external Reporting like IBM BPM, Development.
• Experience in providing Business Intelligence solution for different scenarios and implementing BI solutions like Azure Data Lake Gen2, Power BI Data Flows, CDM, Power BI, different report publishing options and team building
• Recommended architectural improvements, design solutions and integration solutions for Business Intelligence solutions and data analytics
• Having Good communication Skills, Good organizational skills and have professional attitude and ethical approach
• Sincere, quick learner, self-motivated, team player and achiever

Master of Computer Applications