Data Analyst Power Bi

Precious Effiong

281-***-**** ***.*********@*****.*** www.linkedin/in/preciouseffiong

PROFESSIONAL EXPERIENCE

AMD Remote

Sr. HR Data Analyst Oct 2022 – Present

• Analyzed workforce data for 25,000+ employees across multiple business units, identifying trends and providing actionable insights into pay equity, employee engagement, and headcount growth, supporting policy adjustments that improved employee satisfaction scores by 5% year-over-year

• Automated data validation processes, using Excel macros and functions, reducing manual reporting time by 40 hours per month and improving data accuracy by 15%

• Developed and maintained dashboards in Excel and Power BI, improving leadership visibility into key HR metrics by 30% and enabling faster decision-making

• Collaborated with HR and Finance teams to align workforce analytics with business objectives, leading to 20% faster completion of quarterly reports; played key role in system testing stages for focal and performance review cycle, resulting in 99% accuracy rate in compensation data

AMA Consulting Group Remote

Data Analyst(PT) Mar 2022 – Sep 2022

• Reduced report delivery time by 50% through the development of Excel macros to manipulate call center data for Power BI table import, improving data collection efficiency

• Built interactive Power BI dashboards to visualize business metrics, including performance and evaluations, of over 100 agents; reduced analysis time by 85% monthly, and identified agents for further training which led to 10% increase in productivity

• Piloted the migration of an Excel spreadsheet with over 300,000 records to MySQL, reducing data processing time by 60% and improving data integrity by 95%

• Trained 5 program managers to use Power BI dashboards for monitoring daily activity, which contributed to a 20% reduction in call wait times

AMD Remote

Program Management Analyst Jun 2021 – Sep 2022

• Streamlined the project-based accounting process, resulting in a 15% reduction in errors and a 20% reduction in manual hours spent on quarterly accounting

• Successfully managed statements of work (SOW) for 10 contractors, overseeing invoice approval/rejection, funding of purchase orders, and monthly accrual audits, resulting in accurate financial reporting and minimal errors

• Implemented data validation checks, reducing data entry errors by 15% and ensuring a higher level of data accuracy in headcount reports and dashboards.

Goldman Sachs Dallas, TX

Operations Summer Analyst Jul 2019 – Aug 2019

• Performed quality assurance activities in oversight of the on-boarding process for Client Onboarding Group’s bank loans desk

• Maintained effective relationships with over 10 bankers to collect and perform detailed verification on provided documentation to identify data quality issues and ensure data integrity

• Performed required KYC screenings and due diligence on over 20 client profiles in adherence to regulatory requirements to analyze potential risks while maintaining confidential handling of sensitive client data SELECTED ACADEMIC PROJECTS

Greystar Real Estate Partners: Database Design for Campus Recruitment Team Mar 2021

• Led a team of 3 to collaborate with end-users to compile, clean and normalize data in Excel spreadsheets for database design

• Developed Azure SQL database using SSMS by utilizing conceptual ERDs and logical database design in the translation of business needs to technical requirements; queried database data to perform CRUD operations using complex SQL queries EDUCATION

Southern Methodist University, Cox School of Business Dallas, TX Master of Science in Business Analytics, GPA: 3.60/4.00 May 2021 Prairie View A&M University, Roy G. Perry College of Engineering Prairie View, TX Bachelor of Science in Computer Engineering, Minor in Management Information Systems, GPA: 3.69/4.00 May 2020 TECHNICAL SKILLS

Advanced Excel (VLOOKUP, Pivot tables, Macros) • Power BI • Tableau • SQL • Python • Visio • R • Alteryx

Contact this candidate