Doris Anyingu Email & Phone Number

Hyattsville, Md, Us

Dallas, Texas, United States

Data Analyst Consultant for Walmart• Participate in meetings with the business users and experience owners in understanding the business requirements and analyze use cases to develop detailed map strategy.• Imported data from SQL Server DB, Azure DB, Sharepoint and other sources into Power BI and Power Pivot.• Transforming data with Power Query on-prem in power bi desktop and Power Query online with Power BI data flows.• Generate computed tables, columns, and sophisticated… Show more Data Analyst Consultant for Walmart• Participate in meetings with the business users and experience owners in understanding the business requirements and analyze use cases to develop detailed map strategy.• Imported data from SQL Server DB, Azure DB, Sharepoint and other sources into Power BI and Power Pivot.• Transforming data with Power Query on-prem in power bi desktop and Power Query online with Power BI data flows.• Generate computed tables, columns, and sophisticated measures using DAX.• Used Power BI, Power Pivot and SSRS to create impactful reports and visualizations that show market trend analysis for end users.• Publish Power BI Reports in the required originations and dashboards available in Web clients and mobile apps. • Used MS Power Automate to automate processes in Power BI and generate notifications to users.• Deploy and configure Power BI on premise data gateway.• Publish and schedule automated refreshes per business needs.• Implement object level security (OLS) and Row level security (RLS) on reports/Dashboards based on requirements.• Created/assigned workspaces and managed user permission to the capacity.• Created automation framework for about 79 reports and reduced processing time by 82%• Worked extensively with relational database concepts with a solid knowledge of T- SQL. • Write complex SQL queries to create views, stored procedures, temporary tables, and user defined functions involving multiple tables to be used for the reports. • Enhanced the performance of SSRS reports by eliminating unnecessary joins and columns.• Built and modified SSAS cubes both in the Tabular and Multidimensional Models for use in generating reports.• Created SSIS packages to export and import data from CSV files, text files and Excel spreadsheet. • Implement Azure data services including Azure Data Lake, Azure Data Factory and Azure Analysis Services (Azure Synapse Analytics). Show less

United States

Data Analyst Consultant for Hilton Worldwide• Created packages in SSIS to load data from different sources to staging tables transforming this data and loading into an ODS. • Actively engaged in client meetings in requirement gathering and development updates. • Wrote views, stored procedures, CTEs and functions which I used extensively in the development process. • Actively engaged with other team members to gather requirements, design, code, debug, document, implement and… Show more Data Analyst Consultant for Hilton Worldwide• Created packages in SSIS to load data from different sources to staging tables transforming this data and loading into an ODS. • Actively engaged in client meetings in requirement gathering and development updates. • Wrote views, stored procedures, CTEs and functions which I used extensively in the development process. • Actively engaged with other team members to gather requirements, design, code, debug, document, implement and maintain various database objects. • Extensively used joins and sub queries for complex queries involving multiple tables from different databases. • Performed operations to optimize and trouble shoot SSIS packages, queries, stored procedures, indexes and reports. • Analyzed meaningful use report requirements and developed the reports using Microsoft Visual Studio 2010 - 2017. • Developed ad hoc reports in excel used for decision making to determine providers’ bonuses. • Scheduled reports based on day to day and sent them through email in required format (excel, PDF). • Managed day to day activities to ensure the completion of deliverables on time by providing a weekly status report on progress made. Show less

Msc, Biostatistics

Bachelor Of Science - Bs, Agronomy / Crop Production