Data Analyst

Irene Ukiru

Cell No: 919-***-**** **********@*****.*** Fuquay Varina, NC 27526

Business Data Analyst

A versatile Business Intelligence /Data Analyst with exceptional analytical and statistical background utilizing data from diverse sources to provide Extract, Transform and Load build dashboards, create reports, planning and forecasting models to answer business challenging questions. Key strengths in requirements definition, stakeholder relations and project management. Plan, coordinate and execute activities involving cross-functional teams to deliver quality results.

TECHNICAL SUMMARY

DBMS/RDBMS: Microsoft SQL Server 2019, MS Access, SQL Server

BI TOOLS: SQL Server Management Studio (SSMS), MS Visual Studio, SSIS, DAX Studio, Power BI, SSRS.

ETL TOOLS: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), SQL Job Agent, Windows task scheduler

REPORTING/DATA VISUALIZATION: Excel, Power BI, Tableau

DATA MODELING: Excel, Power BI, & SSIS

LANGUAGES: SQL, Python

OFFICE TOOLS: MS Word, PowerPoint, Excel, Access

PROFESSIONAL EXPERIENCE

Smart Data Analytic Plano, TX (Remote) Jan 2020 - Present

Business Data Analyst

Duties and Responsibilities

•Converts complex data from multiple sources into meaningful and easy to understand formats for various stakeholders.

•Manages end to end complex data migration, conversion, and data modeling (using SQL), and create visualization using Power BI to develop high quality dashboards.

•Experience in SQL queries using joins and sub-queries/nested queries, views, CTE and store procedure and indexes.

•Identifies and implements solutions for performance tuning extraction and integration of data to and from databases for reporting, decision support and analysis.

•Responsible for ongoing maintenance and change management to existing reports and optimize reports performance.

•Implements automated solutions to provide data/reports to third party vendors.

•Maintains, designed, developed, and deployed reports in MS SQL Server environment using Power BI.

•Generated sub-reports, parameterized reports, drill down and drill through reports, and modified the existing reports to meet the changes specified by the users.

•Leads team in maintaining, monitoring and performance tuning various database objects like stored procedures, parameterized stored procedures, user defined functions, tables, views for use in reporting.

•Manages collaboration with specific department managers and project managers to create Business Requirement Documents (BRD) for various projects which improved efficiency and accuracy in data extraction, report creation, functionality, and delivery.

•Ensures proper documentation for job failures and process.

•Conduct interviews with key business users to collect information on business processes and user requirements by interviews and brainstorming.

•Participates in Daily Scrum sessions.

•Update fields and data types and heavily utilized case statements logics for developing business logic.

•Develop new and modify existing SQL code based on the requirements to generate data reports.

•Implement ETL process in SSIS to extract data from multiple sources (SQL Server, XML, Excel, and CSV) and schedule workflows.

Environment: SQL Server, SQL SSIS, Windows server 2010, Windows XP, Visual Studio 2019, Visual Studio 2019, Visual Studio 2012, and MS Office, Visio 2010

Raleigh RDU Airport Raleigh, NC Aug 2018 – Dec 2019

Business Data Analyst

Duties and Responsibilities

•Identified and implemented solutions for automated extraction and integration of data to and from databases for reporting, decision support and analysis using SSIS, Excel and Power BI.

•Maintained, designed, developed, and deployed reports in MS SQL Server environment using SSIS and Power

BI.

•Generated sub-reports, parameterized reports, drill down and drill through reports, and modified the existing, reports to meet the changes specified by the users.

•Scheduled automated runs for monthly, weekly, and daily reports onto the Dashboard.

•Led team in maintaining, monitoring and performance tuning various database objects like stored procedures, parameterized stored procedures, user defined functions, tables, views for use in reporting.

•Configured report viewing security for the stakeholders using Report Manager.

•Managed collaboration with department managers to create Business Requirement Documents (BRD) for various projects which improved efficiency and accuracy in data extraction, report creation, functionality, and delivery.

•Assisted with company transition process after acquisition by developing and delivering timely ad hoc reports

Environment: MS SQL Server, Visual Studio, SQL SSIS, Power BI, DAX Studio, Windows server 2010, and MS Office

Emirates Airlines Dubai, UAE Jan 2017 –Oct 2019

Data Analyst

Duties and Responsibilities

Designed and implemented SQL Server Integration Services solutions as ETL packages, analyzed the data and reported on passenger bookings using SSRS.

•Implemented error handling and event handling techniques in SSIS to ensure efficient package execution.

•Developed data marts with dimensions and fact tables based on business requirements using Power BI and DAX Studio.

•Implemented slowly changing dimension methodologies to maintain and update historical data corresponding to dimension tables in data mart.

•Led team in development of reports using Power BI. Managed standard and data-driven subscription of the reports and query optimization to improve performance.

•Generated executive-level dashboards used by upper management to gauge regional, branch level and product performance on daily, monthly, quarterly, and annual basis.

•Wrote parameterized queries for generating various reports, formatting report layout, sub-reports using variables, expressions, functions, sorting data, and defining data source for reports using SSRS.

•Developed and optimized complex stored procedures, views, user defined functions, and triggers.

•Engaged and participated in daily Scrum meetings.

•Partnered with business project stakeholders to understand business processes, document project requirement, and create functional and non-functional specifications accordingly.

Environment: MS SQL Server, Visual Studio, SQL SSIS, Power BI, DAX Studio, Windows server 2010, and MS Office

EDUCATION

AAS Degree IT & Cloud System Admin May 2021

Durham Technical Community College

Diploma in Customer Service Dec 2005

Nairobi Institute of Business Studies

Diploma in Computer Studies Dec 2001

Kenya Christian Industrial Training Institute

Contact this candidate