Mercy Abraham Email & Phone Number

New Jersey, United States

New Jersey, United States

• Analyzed various data and created required sales reports for shipping medical supplies to the customers. • Used variance report after analyzing customer segments to understand differences in needs and expectations, enabling targeted service improvements.• Maintained various clients, group and department catalogs as per stated company compliance.• Using past data, worked on different predictive models for demand forecasting in SMS ERP. Further analyzed customer needs, such as forecasting call volumes, chat inquiries, or identifying potential churn risks.• Analyzed and verified the data from different source files to fulfil client’s requirement as per management requirements.• Worked with data pipelines to extract, transform, and load data from various sources into a unified data repository for data analysis.• Responsible for data aggregation from different data sources for report generation• Compliance with the provisions of the Health Insurance Portability and Accountability Act of 1996 and its implementing regulations, as amended (“HIPAA”)• Generated regular reports and dashboards that visualize KPI trends, highlighting areas for improvement.• Supported pharmaceutical manufacturer client on data needs and insights.• Analyzed data, identified trends, implemented optimizations on a day-to-day basis, build dashboards and delivering timely reports to support analyses.• Evaluated data and reported findings for accuracy, completeness, scope; ability to provide reasoning for data variations.

New Jersey, United States

• Collaborated closely with cross-functional teams to understand business objectives and identify analytical requirements.• Designed, built, and maintained business dashboards and reports using SQL, Looker, and Big Query.• Performed data extraction, transformation, and loading (ETL) processes.• Conducted thorough data analysis to derive actionable insights and recommendations.• Presented findings to stakeholders through clear and compelling visualizations and reports.• Continuously learn and stay updated with industry trends and best practices in data analysis.• Created optimized pivot tables and charts using worksheet data and external resources, modified pivot tables, group data, and sorted items.• Wrote and optimized diverse SQL queries, working knowledge of RDBMS like SQL Server

Certification, Business Analyst

Bachelor'S Degree, Accounting

Master'S Degree, Accounting

Certification, Data Analyst