Lead Business Analyst
Abu Dhabi National Hotels Compass ME LLC
Total years of experience :18 years, 4 Months
>> Taking care of all commercial reporting needs - providing statistical insights to senior management; helping them in taking strategic and informed decisions.
>> Producing spend trends and in-depth analysis multiple businesses for variety of audiences.
>> Delivering key projects to succeed major transformation projects to improve the data delivery, revamping organisational and supply chain processes.
>> Successfully implemented dashboard for tracking the savings initiatives outcomes.
>> Aligned the data structure and category alignment in line with the group's structure.
>> Produced Import analysis on regular items that generated savings.
>> Identified gaps in systems data and suggested remediation to overcome such issues.
>> Maintaining strong relationship with all stakeholders across the business.
>> Excelled in using various BI tools such as R, Power BI, QlikView etc.
>> Experiencing the implementation of AWS cloud application tool - forming a Data Lake and aligning the structure to form a Datawarehouse.
>> Establishing direct connection between Datawarehouse and Power BI to feed real-time data into Live dashboards; also set up mechanism to generate periodic reports.
>> Responsible for validating the Data quality through checkpoints and plan reviews.
>> Highlighting gaps in existing procurement process, had brainstorming on potential solutions and finalise the course of actions.
▪ Taking ownership of regional data delivery, data migration and MI content - preparing data execution plans that suits the split region environment and serve the purpose.
▪ Reviewing and assisting with current state data assessments, identifying potential gaps, document them and provide corrective action plans.
▪ Bridging the gap between business and IT by engaging the legacy and cross-functional teams across the organisation through variety of workshops.
▪ Collaborating with business owners to develop data and analytics use cases including data monetisation opportunities.
▪ Leading the business data SMEs and data specialists on migration of data, improving data quality and invoking of governance rules to implement the global strategy across the region.
▪ Analysing data quality, availability - taking measures to conform regional environmental and regulatory policies; preparing recommendation plan to improve the data.
▪ Act as a trusted advisor to local leadership in relation to how their data assets may best utilised to address challenging business queries.
▪ Strategically plan and implement data governance framework and processes accordingly.
▪ Collaborating with global data strategy team - producing data definition and development including execution plans.
▪ Successfully managing existing KPIs in place, Identifying new KPIs and setting up benchmarking for effective reporting - meeting the agreed SLAs.
▪ Assisting region with customisation of HBB system that allows HR to manage health related benefits for employees.
▪ Spreading awareness of global data initiatives within the split region.
▪ Triggered effective data quality monitoring and remediation initiatives.
▪ Working with Operations & Technology colleagues in region, ensure effective management of the estate of tools and reporting applications for region.
▪ Evaluate and manage metrics for regional reporting - helping management drive continuous process improvement.
▪ Responsible for validating the Data quality through checkpoints and plan reviews.
▪ Providing regular updates to global data design, governance & operations teams.
▪ Developed a successful traceability matrix to keep track of all activities; promptly highlight risks and issues to all stakeholders and escalate as needed.
▪ Developing Qliksense based dashboards and reports for various levels of audiences.
▪ Controlling documentation over regional systems and data interface maps.
▪ Working on multiple projects simultaneously while meeting tight deadlines.
▪ Liaising with end users or business to ensure benefits realisation.
▪ Collaborating with cross-functional areas to keep all stakeholders on same page.
▪ Working remotely, delivering key projects under difficult circumstances with minimal or no supervision.
▪ Working closely with the data management team across the region to develop understanding towards data initiatives.
- Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
- Led projects under various transformation programmes, streamlining overall organisational vision and approach.
- Successfully delivered projects following SOA principles under transformational programmes.
- Excellent knowledge and understanding of implementing 12-factor app principals within core projects.
- Managed expectations by engaging process owners; interpreted processes of RFP/RFQ, POs, Outline Agreements, Invoicing and Payment mechanism.
- Collaborated with Internal Audit team, reviewed the transactional modules and processes in R/3 SAP - ensured audit compliance and transparency.
- Produced spend analysis for across the directorate targeting various audiences.
- Developed data model on multiple tiers to address different levels of audiences.
- Delivered projects such as organisational charts, dashboards, KPIs, periodic reports, spend analysis and supply chain analysis that provided a comparative analysis and helped management in taking strategic decisions.
- Prepared project plan, resource plan, identifying risks and maintaining risk register, estimating, maintained traceability matrix, monitored project status.
- Tracked project activities against detailed project plan and updated plan accordingly to accommodate agreed changes.
- Conducted one-to-one interview sessions with variety of stakeholders for customer satisfaction and to ensure business needs are fulfilled.
- Led team of dedicated professionals, delivered key projects to succeed major transformation programmes; took measures to improve the data delivery, revamped organisational and supply chain processes.
- Earned knowledge of Data Lake through various sources, maintained Data warehouse; produced contiguous data source, developed coherent end-to-end processes to produce state-of-the-art cubes for deliveries.
- Identified and reviewed quality measures in compliance with Internal Audit, Finance, Legal and other relevant organisational environment teams.
- Conveniently communicated and influenced at C-level.
- Worked on multiple projects simultaneously while meeting tight deadlines.
- Liaised with end users or business to ensure benefits realisation.
- Documented standards, best practices, and ETL procedures.
- Experienced in SQL, Oracle, Access, MySQL etc., generated effective and complex queries to produce meaningful data for analysis.
- Excelled in using various BI tools such as R, Power BI, QlikView, Tableau; competent in reading/writing scripts in Python, C#, .Net etc.
- Produced reports through state-of-the-art tools such as SQL, SSIS/SSRS, Rosslyn Analytics, SAP Business Objects, SAP R/3 systems, Oracle, SharePoint etc.
- Surpassed in advanced MS Excel; VBA Macros, Pivot Tables, VLOOKUP etc.
- Expert in using MS Project and Primavera for project management purposes.
- Collaborated with cross-functional areas to keep all stakeholders on same page.
- Analytical, adaptable, attention to detail and excellent communicator.
Key Responsibilities:
- Having full system development lifecycle experience, my daily routine included maintaining strong relationship with the key stakeholders on significant projects in Community Banking, ensuring Senior Management engagement in all decision-making stages.
- Effectively organised workshops with variety of stakeholders to produce high-level user stories based on Scrum framework.
- Worked with subject matter experts, product owners to refine high-level user stories into sprints and formulate detailed technical specification with offshore developers.
- Eliciting various UML/structural diagrams using variety of tools such as Visio and Rational Rose for the ease of developers in order to develop understanding towards the system.
- Documenting the Business process modelling through wireframes and concept diagrams to demonstrate the ‘As-Is’ and ‘To-Be’ business processes.
- Assisting Business Project Managers on key project management activities while working on business change projects.
- Designing, developing test cases with in-house testers and managing defect lifecycle along with resting activities.
- Effectively transitioned software development efforts to a test-driven development process by bringing QA testing on top-level in line with development cycle in order to improve the quality of code, developer's productivity and the functionality of the software.
- Leading testing teams to ensure the UAT scripts have been designed appropriately with true reflection of the requirements in order to obtain the quality of the project.
- Depending upon the project scale, generating strong communication plans in order to keep stakeholders within the loop, providing regular updates through various periodic reports allowing senior management to review the on-going progress by showing the overall transitional trends with the help of various graphs and charts figuring out all the experiential updates highlighting the positive and negative aspects.
- Aligning relevant business documentation processes assuring that all previous lessons learned situations are met and ensure that the change is documented accordingly.
- Facilitating post live testing and user training activities in compressed community banking environment.
- Sufficient knowledge of SQL Server used to extract information from Tables, generating required reports. Understanding and manipulating complex and optimised SQL queries.
- Having good understanding of Database Schema allows data manipulation effectively.
- Performing data analysis using advanced Excel skills i.e. manipulating raw data through pivot tables, VLookups and advance graphical representations.
Key Responsibilities:
- In collaboration with working Project Managers contributed to formulate Project Initiation Documents, Project Plans, designing UML/User stories, creating UAT testing scripts and Quality reviewing measures in compliance with Organisational environment.
- Responsible to ensure that enough information has been gathered to further pass on to the development teams for further actions.
- Prepared successful communication plans keeping every stakeholder within the loop using several communication tools (i.e. LiveMeeting, NetMeeting, video conferencing, local intranets and many other resources) to update them with Periodic/Status reports ensuring the transparency.
- Engaging key suppliers for small to large sized projects, drafting their procurement contracts to ensure that all stakeholders are on a same platform to agreed milestones.
- Managing Risk Registers listing all identified risk factors/opportunities and their Impacts with the probability of occurrences in order to conclude the Risk Management Plan.
- Preparing QA review documentation, matching the Business Case requirement by involving the key stakeholders/End Users ensuring that things are going into the right direction.
- Maintained the track of all on-going processes and issue logs, forwarded to PM through Change process highlighting to alternate solution in order to rectify the issue.
- Successfully produced periodic reports through SQL Server using basic SQL expertise.
Key Responsibilities:
- Performed a key role over R/3 SAP PM (Plant Maintenance) system during the business process analysis phase throughout the implementation period in collaboration with external consultants in order to complete the research process.
- Discovered various requirement-gathering techniques to manage stakeholders. Developed skills in designing UML/State diagrams, applied business process modelling techniques.
- Later provided relevant PM support to the end-users by conducting training sessions at several site locations to educate them about the newly implemented SAP system, which helped them to understand the planning, control, and processing of scheduled maintenance, inspection, damage-related maintenance, and service management to ensure availability of operational systems, including plants and equipment delivered to customers.
- Completed relevant documentation for future consultancy in case problems occur, this would help users identifying the issues and finding out possible remedies.
- Enhanced my expertise in Microsoft products but later was more inclined towards SAP support and developed my skills within the same area.
Completed Thesis on post-SAP implementation issues and potential remedies.
Final project demonstrated a successful banking system detailed on integration based on centralised information.
URL removed due to policy violation. Please contact support for further information.