As a data analytics leader, I help organizations in several ways, including: Identify key business insights - By analyzing large volumes of data, a data analytics leader can identify key trends, patterns, and insights that can help the organization make informed decisions and improve business outcomes.Optimize operations - Through the use of data analytics, a data analytics leader can help optimize business operations, reduce costs, and improve efficiency.Improve customer experiences - By analyzing customer data, a data analytics leader can identify areas for improvement in customer experiences, which can help the organization attract and retain customers.Develop data-driven strategies - A data analytics leader can help the organization develop data-driven strategies that align with business goals and help drive growth.Enhance risk management - By analyzing data, a data analytics leader can help identify potential risks to the organization, and develop strategies to mitigate those risks.Drive innovation - A data analytics leader can help drive innovation within the organization by using data to identify new opportunities and develop new products or services.Build a data-driven culture - By promoting the use of data and analytics throughout the organization, a data analytics leader can help build a data-driven culture that supports continuous improvement and growth.

- Oversaw the technical execution of Business Intelligence projects encompassing stakeholders’ engagement, requirement gathering, project scoping, solution design, development, and implementation. - Managed numerous cloud and on-premises data platform projects where involved in designing, developing and implementing data integration, data modelling and Power BI capabilities.- Led the development and roll-out of Power BI Cloud based solutions, technologies, and processes.- Managed a small BI team, based across Australia, India, and Malaysia.

- Engaged with stakeholders to develop business requirements, deliver expert advice, manage expectations to ensure business intelligence, analytics, and reporting suit the current and future needs for the customers.- Developed and designed Enterprise data models that meet client needs and ensuring we align to industry related dimensional modelling approaches i.e., Kimball.- Responsible for all aspects of the ETL and data management process, including design, development, testing, documentation, and support of highly reliable ETL and data management solutions.- Worked with business stakeholders to define requirements and translate into dashboard wireframes for business sign-off.- Responsible for building secure, resilient, and highly efficient Power BI Dashboards and effective Visualization.

- Designed & built SSIS packages to integrate data from organization systems - SAP, Dynamics AX, CRM, SAP BPC, Project Online, Sales Budget Data (Excel Files) and transform and loaded into consolidated global data warehouse while following established standards.- Developed enterprise data warehouse using SQL Server (Consolidating various business functions: Sales, Procurement, Supply Chain and HR) - Built highly performed data model in SSAS Tabular model, Written DAX Expression to implement business logic, designed aggregations, set up processing strategy.- Maintained & Supported existing SSAS Multidimensional data model and identify & recommend opportunities to reuse existing models and optimize them.- Responsible for maintenance, support, and enhancement existing SSRS reports used across various departments and optimize and identify opportunities to consolidate SSRS reports.- Set up, configured, and architected Power BI Solution. Designed analytic & operational dashboards using Power BI Desktop, Power Query (M Language), Write DAX for Measures, Configure on-premise Data Gateway for data refresh, Set up Apps on Power BI Services for distribution- Raised maturity level of company reporting & analytics capabilities by rolling-out Power BI based dashboards at global level which includes requirement gathering from relevant stake holders, designing dashboards, roll-out strategy, user manual & trainings.- Promoted self-service BI capabilities among business users through knowledge sharing & technical guidance.

- Provided technical consulting and guidance to Client teams for the design and development of highly complex or critical modern DW/BI applications.- Provided maintenance & support of client’s exiting data warehouse & business intelligence systems.- Identified opportunities for new architectural initiatives; makes recommendations on the increasing scalability and robustness of ETL/Analytics platforms and solutions.- Responsible for creating new models that align with the Enterprise Data Model, creating subject areas and diagrams as required, entities with definitions, attributes with definitions, named relationships, business keys.

- Engaged with end business users to understand & capture their requirements, designed & developed BI solutions to solve their problems and ensure timely & high-quality delivery.- Identified opportunities for new architectural initiatives; makes recommendations on the increasing - scalability and robustness of their BI/Analytics platforms and solutions.- Co-ordinate with Offshore Team to provide end-to-end solution using SDLC.- Provided L2 (Support) & L3 (Enhancement) work in which responsible to monitor /support day to day BI Operations like overnight ETL process, cube processing / performance, report delivery etc and fix the issues in defined SLA.

- Provided technical consulting and guidance to development teams for the design and development of highly complex or critical client DW/BI applications.- Worked on multiple development projects, made changes/enhancement in existing SSIS packages, cubes and sales reports. Responsible to support and maintaining existing data warehouse, SSIS packages and reporting platform to ensure operational availability.- Assisted in the architecture, development, implementation, and coordination and planning of all data and reporting strategies with internal and external stakeholders.- Responsible for Onsite-Offshore Teams, Revenue Targets, Profitability and ensuring timely & quality delivery.

- Developed SSIS Packages which extracted data from smart card system and loaded in to centralize data warehouse. - Designed multidimensional cube using SSAS.- Developed different level reporting (Employee, Manager, BU Head, HR) using SSRS. - Also Performed QA (Quality Assurance) and CC (Configuration Controller) role.

- Monitor & maintain client mission critical production database servers. - Job monitoring of SQL Jobs Perform troubleshooting for jobs, SSIS packages - Coordinate with database developers team and client stakeholders of database servers.

- Designed & developed database objects - Stored Procedures, Views, Functions, Triggers.- Written & optimized simple & complex T-SQL queries.- Performed performance tuning of SQL, SPs, and databases.