Halima Shehu Yakasai
Detail-oriented, results driven professional with over eight (8) years IT experience which includes extensive background in Data Analysis, Data Extraction and manipulation, DB applications, 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. Proven ability to learn and utilize in-house databases and systems to maintain strategic vision of the organization and link it with everyday work. Expert in multitasking and a wonderful team player who can relate and work efficiently with diverse groups.
Databases - MS SQL Server 2012/2014, Oracle 9i, 10g, 11g, DB2
Querying Tools – SQL Server Management Studio 2012/2014/2016/2018, Oracle SQL Developer
Querying Language - SQL, PL/SQL, TSQL
Programming Language – SQL. SAS
ETL/Other Tools - SSIS (Visual Studio),, SAS Base 9.x, Erwin Data Modeler, Jira
Business Intelligence Tools - Tableau 9.1, 9.2, 9.3,10.4, PowerBI, Excel, PowerPivot
Operating Systems – Mac, Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64)
BDP International Philadelphia, PA 01/2019—Present
Develop Tableau workbooks from numerous data sources using Data Blending.
Implement Tableau Mobile dashboards via Tableau mobile application.
Develop Tableau visualizations and dashboards using Tableau Desktop.
Create compelling dashboards using Tableau dashboard and prepare use5r stories to deliver actionable insights.
Used Tableau server as a front-end BI tool and MS SQL server 2012 as a back-end database to design and develop workbooks, dashboards, global filter page and complex parameter-based calculations.
Connect Tableau server to publish dashboard to a central location for portal integration.
Create action filters, parameters and calculate sets for preparing dashboards and worksheets in Tableau.
Involve in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
Worked with team of developers, designed and implemented a BI solution for Sales, Product and Customer KPIs.
Celtic Healthcare Mars, PA 05/2016- 12/2018
Financial Data Analyst
Wrote complex SQL queries using advanced SQL concepts like aggregate functions, Group by and OLAP (Online Analytical Functions)
Developed and produced peer quality metric performance, validated data and processes to ensure accuracy, completeness and consistency of Data using SAS.
Fulfilled numerous data requests for financial profiling.
Wrote SQL queries that were highly tuned using concepts like Explain, Stats, CAST and volatile tables.
Designing the reports as per client requirement and created the reports using Excel file, SQL server and oracle Databases
Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
Created Tableau Dashboard with interactive views, trends and drill downs aong with user level security.
Created and developed parameterized Drill Down and AD hoc Reports using SQL server 2014 Reports Services (SSRS).
Used SAS to import and export data from and into SQL server tables.
Used DTS to migrate the tables to the Data Warehouse. Handled Different DSS (Decision Support System) for various applications
Wrote queries to fetch data from different table by using JOINs, Sub-queries, Correlated sub-queries and derived tables on Teradata platform.
Howard Bank Baltimore, MD 02/2012-05/2016
Business Intelligence Consultant/ETL Developer
Designs logical and physical databases (OLAP and OLTP) or reviews description of changes to database design.
Diagnose database issues related to development activities in development and test environments.
Wrote queries to gather data from different tables by using JOINs, sub-queries, correlated sub-queries and derived tables on SQL server platform.
Assist others with SQL performance tuning including index recommendations or hardware configuration considerations.
Develop database objects such as tables, views, common table expressions, dynamic SQL, foreign key constraints, and stored procedures.
Monitoring database performance indicators of development and test environment to ensure promotion to production environment brings no surprises
Used Pivot tables to create reports that did dicing and slicing functions on data. This is called dimensional analysis and provides a 360 view of what is going on.
Hands on experience to extract, manipulate and build complex formulas in Tableau for various business calculations.
Use data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their Data.
Involved in resolving reporting issues and design issues throughout the reporting life circle
University of Sokoto, Nigeria