نبذة عني
Skilled in using digital analytics tools i.e., Power BI, Power Apps, Power Automation to build reports. Experienced to connect Power Apps with various data sources, such as SharePoint, Microsoft 365, SQL Server. Worked o…
Skilled in using digital analytics tools i.e., Power BI, Power Apps, Power Automation to build reports. Experienced to connect Power Apps with various data sources, such as SharePoint, Microsoft 365, SQL Server. Worked on Power Automation Procedure to run queries automatically i.e., Power App, Power BI – SharePoint. Applying RBAC i.e., Role Level Security in Power Apps, Power BI to carefully design the roles and permissions. Collaborated with teams for automation procedure and implemented solutions using Power Automation and Power Apps. Created complex automated workflows using Power Automation, integrating applications to achieve seamless operations. Proficient in working with RDBMS, SharePoint and manipulating data in SQL and NOSQL for data analysis. Experienced in analytics using SQL-generated data, Python, Microsoft SQL Server, SSRS, SSAS-tabular, SSIS. Experience slicing and pivoting SSAS OLAP cubes, Azure Active Directory, OAuth and RLS (row level security). Proficient in making DAX, OLAP, Power queries, Power BI, Power Pivot, Power Query, Measures/column, in Power BI. Expertise in using data query editors in transforming the dataset sing SQL language, and power query editor.
الخبرة
Reporting Analyst
• Worked on Power Apps and Microsoft Power Automation, to streamline workflows and automate repetitive tasks.
• Utilized SQL queries to tap into a centralized repository database and built prototype reporting for various balance sheet reports used in scheduling, cost controls, communication team and regulatory reporting obligations.
• Utilize technical skills to efficiently and effectively extract and manipulate data from client databases or other source systems to meet various reporting needs (weekly, monthly, quarterly, and ad hoc reports)
• Develop and implement new reporting for Investment and Corporate Banking and Global Markets.
• Working on troubleshoot and debug issues in power query editor with Power BI reports and dashboards.
• Worked on filters, parameters, DAX measures and calculated sets for preparing dashboards and worksheets in Power BI.
• Used visualization reports tools like KPI, slicer, graph, and allowing end users to utilize full functionality of the dashboard.
• Worked on Power Automation Procedure to run queries automatically by SharePoint to Power BI
• Worked on connectors in Power Apps, Power Automation to connect with specialized in-house applications, work with the management of the cross teams enhancing the report quality.
• Stayed up-to-date with the latest features and updates in Power Automation, continually improving automation capabilities and staying at the forefront of automation trends.
• Utilize knowledge of CM’s businesses, products, and risk measures to provide insight and analysis in support of performance and strategic objectives on Salesforce.
• Participate in and contribute to project and team meetings, interacting and collaborating with team members and other departments, as appropriate, in order to understand project requirements.
• Applying RBAC in Power Apps, to carefully design the roles and permissions.
• Manage requestor expectations, and meet agreed upon deadlines; produce work that is timely and accurate. Strive to provide great customer service and anticipate follow-up inquiries.
• Connected to data sources, importing data from Azure Data Lakehouse, Azure Synapse, Azure Data Factory.
• Work with the functional lead, and other delivery teams to design and implement data models that support the business intelligence solutions.
• Data collection, management techniques (ETL) and the development, interpretation of data to determine requirements, retrieve, analyze and deliver insights and recommendations.
Reporting Analyst / Power BI
Worked on Power Apps and Microsoft Power Automation, to streamline workflows and automate repetitive tasks.
Utilized SQL queries to tap into a centralized repository database and built prototype reporting for various balance sheet reports used in scheduling, cost controls, communication team and regulatory reporting obligations.
Utilize technical skills to efficiently and effectively extract and manipulate data from client databases or other source systems to meet various reporting needs (weekly, monthly, quarterly, and ad hoc reports).
Develop and implement new reporting for Investment and Corporate Banking and Global Markets.
Working on troubleshoot and debug issues in power query editor with Power BI reports and dashboards.
Worked on filters, parameters, DAX measures and calculated sets for preparing dashboards and worksheets in Power BI.
Used visualization reports tools like KPI, slicer, graph, and allowing end users to utilize full functionality of the dashboard.
Worked on Power Automation Procedure to run queries automatically by SharePoint to Power BI.
Worked on connectors in Power Apps, Power Automation to connect with specialized in-house applications, work with the management of the cross teams enhancing the report quality.
Stayed up-to-date with the latest features and updates in Power Automation, continually improving automation capabilities and staying at the forefront of automation trends.
Utilize knowledge of CM’s businesses, products, and risk measures to provide insight and analysis in support of performance and strategic objectives on Salesforce.
Participate in and contribute to project and team meetings, interacting and collaborating with team members and other departments, as appropriate, in order to understand project requirements.
Applying RBAC in Power Apps, to carefully design the roles and permissions.
Manage requestor expectations, and meet agreed upon deadlines; produce work that is timely and accurate.
Strive to provide great customer service and anticipate follow-up inquiries.
Connected to data sources, importing data from Azure Data Lakehouse, Azure Synapse, Azure Data Factory.
Work with the functional lead, and other delivery teams to design and implement data models that support the business intelligence solutions.
Data collection, management techniques (ETL) and the development, interpretation of data to determine requirements, retrieve, analyze and deliver insights and recommendations.
Reporting Analyst / Power BI
Developed visual report, dashboards and KPI using Power BI desktop using DAX and transformation in Power query editor.
Collaborated with teams for automation procedure and implemented end-to-end solutions using Power Automation.
Created various visualizations reports tools like KPI, metrics, data slicer, line & area graph, text cards, geo maps, gauge charts and allowing end users to utilize full functionality of the dashboard.
Worked on filters, parameters and calculated sets for preparing dashboards and worksheets in Power BI.
Developed visual report, dashboards and KPI scorecards using Power BI desktop.
Connected to data sources, importing data and transforming data for Business Intelligence.
Created new measures and columns for getting required results in data view and report view.
Power BI Marketing Analyst
Collaborated with business and technology partners to elicit information / data requirements and articulate requirements.
Provided support to the development and testing teams to resolve data issues.
Provided data governance and data availability support to technology teams and business users and ensure requirements regarding privacy and security of data, data governance and access controls are appropriately captured.
Ensured data is maintained in compliance with enterprise data standards, policies and guidelines.
Build and supports reports using a combination of BI tools and SQL.
Contribute to data deliverables including contribution to the overall project business requirements and data requirements documents.
Tech Support Advisor
Work with clients to solve various types technology problems, including Wi-Fi/network connectivity; hardware and software issues.
Use resources, technology, and problem-solving skills to troubleshoot mobile POS network issues which include tablet and printer connectivity with cabled and wireless LAN and WAN devices.
Take ownership of customer issues through to resolution or escalation while providing accurate and prompt feedback both to the customer and teammates.
Follow company policy and procedures for the proper escalation of unresolved issues to appropriate internal teams.
Maintain a high percentage of issue resolution within first customer interaction.
Help Desk Analyst
Work directly with business users with variety of level of expertise and requirements to identify and translate the business case into technical requirements for development of full analytics solutions.
Evaluate query designs, data structure, and data quality to provide recommendation for improvement as needed.
Removed troubleshoot system failures or bugs and provided solutions to restore functionality.
Experienced of AWS Administration, providing security and following the SOP (Standard of Procedures).