BENEDICTA A. KUSI

• Worked on data cleansing project and reviewed mismatches between the inventory system and Billing system
• Generated quotes based on the cross connect design provided in the system
• Performed ad-hoc reporting analysis as well as manipulated complex data on MS SQL server
• Generated data quality reports and resolved data quality issues
• Engaged in quality control (data reconciliation) activities like QA and UAT through the review of reports, data files, client deliverables
• Excellent IT skills, particularly with Salesforce and Excel, and an ability to use other MS packages
• Understand and provide configuration level support for Salesforce.com applications including report creation and mobile enablement
• Demonstrated proficiency in data manipulation (Excel or other related data manipulation tools), data modeling, custom objects, permissions, SQL queries
• Translate and clarify Business requirements into IT requirements specifications
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
• Developed and enhanced reports connecting to single or multiple data sources to improve performance
• Provided reporting, analysis and insights about sales drivers and key revenue performance metrics to support corporate analytics.

· Created Views and Database Triggers, Stored Procedures, and Functions using SQL such that information entered by a certain WM can make appropriate changes to the respective tables.

· Wrote complex SQL queries using advanced SQL concepts like Aggregate functions.

· Performed ad-hoc reporting analysis as well as manipulated complex data on MS SQL server.

· Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub- queries and used concepts like Explain, Stats, Cast, and volatile tables on SQL server

· Involved in extensive data validation by writing several complex SQL queries and involved in back-end testing and worked with data quality issues.

· Analyzed duplicate data or errors in data to provide appropriate inter-departmental communication and monthly reports.

· Experienced in Data mapping, Data transformation between sources to target data models.

· Analyzed reporting requirements and developed various Dashboards.

· Involved in extraction, transformation, and loading of data directly from different source systems like flat files, Excel, Oracle, and SQL Server.

· Experience in creating various views in Tableau (Tree maps, Heat Maps, Scatter plot).

· Experience in creating Filters, quick filters, table calculations, calculated measures, and parameters.

· Responsible for developing, analyzing, and reporting key risk indicators and key performance indicator metrics that enable management to make timely and effective decisions related to threats, risks, and control requirements.

· Utilized SQL to develop stored procedures, views to create result sets to meet varying reporting requirements.

· Built and supported the transformation of various data inputs into the companies Data Warehouse.

· Designed and developed Insurance, Reinsurance, Claims, and Financial Reports Using SSRS.

· Identified Data discrepancies and worked with the database team to find better solutions.

· Supported business lead for special assignments and ensured production efficiency.

· Use data visualization tools to provide an easy-to-understand interface for end-users to quickly identify key themes within their Data

· Designing the Reports as per client requirements and creating the reports using Excel files, SQL Server, and Oracle databases.

· Developed and produced peer quality metric performance: validated data and processes to ensure accuracy, completeness, and consistency of data using SAS.