Z

Z

BENEDICTA A. KUSI

Business Intelligence Analyst

Dynamic technology professional with more than four (4) years of IT experience, including an extensive technical background in Relational Database applications, Data Analysis, ETL Development, Data modeling, warehousing, and Systems Administration. Strong knowledge of Oracle/SQL Server Architecture, schema, and Transaction management. Keen researcher with robust resolution pedigree; utilizing knowledge of relational databases and Business Intelligence models to improve on efficiency and effectiveness of the organizations IT functions towards achieving a goal.

Digital Realty Sept 2021 - Present

New York, NY (remote)

Data Analyst

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.

CONTACT

862-***-****

adw4b8@r.postjobfree.com

Bordentown, NJ

SKILLS

Data Analysis & Reporting

Data Visualization

Advanced Problem-Solving Business Transformation Process Improvement

Data Strategy

Issue Resolution

Leadership

EDUCATION

Keystone College

Business Administration – BBA

La Plume, PA

Suncoast Credit Union June 2020 – August 2021

Tampa, FL (remote)

Tableau Developer / Data Analyst

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.

CURE Auto Insurance October 2019 - May 2020

Princeton NJ

Financial Data Analyst

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.

Available on Demand.

REFERENCES

TECHNICAL SKILLS

Databases

MS SQL Server, Oracle, Snowflake

Querying /Programming Language

SQL (PL/SQL, T-SQL), NoSQL, SAS

ETL/Other Tools

SSIS, SAS Base 9. x, Erwin Data Modeler, Alteryx, Jira

Business Intelligence Tools

Tableau, PowerBI, SSRS, Excel, PowerPivot

Operating Systems

Mac, Windows

Contact this candidate