Faith A Okeh

ad01yl@r.postjobfree.com 551-***-****

PROFILE

Dynamic technology professional with about FIVE (5) years plus of IT experience, including extensive technical background in DB applications, Data Analysis, ETL Development, Data modeling and 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 database and Business Intelligence models to improve on efficiency and effectiveness of organization’s IT functions towards achieving a goal.

EXPERIENCE SUMMARY

Highly organized and result-oriented professional with experience in Data Reporting and Business Analysts/ Analysis

Proficient in MS Office suite, MS Access, Google Suite

Proficient in all Microsoft applications, Word, and PowerPoint, with advanced Excel skills (Pivot Tables, VLOOKUP, Macros), Power BI

Experience assisting Business Analysts in gathering requirements for development for the purposes of formulating and applying mathematical modeling and interpreting information that assist management with decision making policy formation.

Experience with Tableau Dashboard Visualization

Tableau Developer

Experience in Data Analysis and manipulation of complex data set for business need

Knowledge of SQL to generate queries in Database for exporting purpose.

Strong project management skills with good working knowledge and understanding of business and operational processes.

Ability to interact and work with internal & external stakeholders/vendors/clients at all levels.

Self-aware, reflective, and able to learn from mistakes, with an ability to learn quickly while on the job.

Tableau Developer, Experience with Tableau Dashboard Visualization.

COMPUTER SKILLS

Windows7 and 8,10, Microsoft Office suite (Visio, Excel, Word, Project, Access, OneNote, Power point, Outlook), Microsoft CRM, MYSQL, SQL, TERADATA, Power BI, TABLEAU, Business Analysts.

PROFESSIONAL EXPERIENCE:

Senior Data Analyst May 2021 - Date.

Boston Consulting Group-Summit NJ, United States

Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems.

Work with business teams in various areas of field sales to develop reports or address data needs to provide reporting solutions.

Perform and document data analysis, data validation, data mapping/design, by accessing multiple sources, specifically data residing in data warehouses.

Synthesize and translate Business data needs into creative visualizations in Tableau.

Extract, Upload and Manipulate data on Enterprise Business Intelligence Software

Write SQL query, sub-queries and perform table joins and complex data merges.

Manipulate Tables on Excel and Import to SQL using Enterprise Business Intelligence

Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas per business needs.

Identify and translate business needs and requirements into customized design and implementation of intuitive information dashboards, reports, and visualizations that are optimized for performance and use best practices!

Manipulate data on Salesforce for Visualization purpose.

Create complex reports on Adobe Analytics

Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality.

Associate Data Analyst Nov 2018 to May 2021

Boston Consulting Group-Summit NJ, United States

Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas per business needs.

Data migration and Data validation/Testing through MS Access and MS Excel

Wrote VBA codes for automated transferring of data between spreadsheets and workbooks.

Wrote VBA codes for exporting queries from Access Database to Excel

Importing data to Access and SQL Server from flat files and Excel spread sheets.

Manual review and correction of numerous errors and gaps for dataset using Data Analysis Expressions

Maintained Access database for the purpose of extracting reports.

Developed interactive Microsoft Excel dashboards for presentations purpose and the use of Power Bi.

Worked with the Business users to understand what reports were critical, non-critical and not needed.

Created an MS Access database to collect data systems to provide lists, status reports and management overview reports.

Created BI reports in pivot charts, graph, and other visualization format to Analyze trends.

Created Dynamic Charts/Graphs in MS Excel and MS Access using VBA.

Maintained system databases, e.g., rent rolls and tenant files, in MS Office.

Imported data from pre-existing text files and excel spreadsheets.

Generated the necessary BI reports and information to litigate tax appeals for properties Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas per business needs.

Data migration and Data validation/Testing through MS Access and MS Excel.

EDUCATION:

Bachelor of Science (BSc.)

Microbiology

University of Ogun State, Nigeria

College degree applied health science HCCC NJ

CORE COMPETENCIES

Analytical Skills, Time Management, Microsoft Office Suite, Client Management, Team Leadership, Communication skills, Business Development, Data Analysis, Business Analysts

INTERESTS

Languages: English (Native Speaker) Yoruba

Activities & Interests: Business News Business Analytics Music (Bass Player) Personal Fitness Traveling Reading

References Available Upon Request

Contact this candidate