Business Intelligence Developer

UCHE OKEKE

Phone: 081******** Email:*******@*****.***

Summary:

Over 4 years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client-Server Applications and Database systems using SQL Server 2008/2012/2014.

Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.

Extensive experience in using Microsoft BI products like SSIS and SSAS for implementation of ETL methodology for a variety of sources (Flat/Excel/Access/XML/SQL/Oracle) and data analysis.

Extensive experience using reporting tools like Power BI and SSRS in the creation of reports and dashboards.

Expert in Data Warehouse development starting from inception to implementation and ongoing support. Strong understanding of BI application design and development principles.

Highly experienced in the whole cycle of SQL Server Integration Services (SSIS 2005/2008/2012), Packages (Developing, Deploying, Scheduling, Troubleshooting and Monitoring) for performing Data transfers and ETL purposes across different servers.

Utilized Python and Python libraries like Numpy and Pandas for cleansing and preparation of large data set for datamining analysis process.

Identified, created and tracked organizational Key Performance Indicators.

Experience writing Linux shell scripts for automated execution of tasks.

Evaluated Business Intelligence goals, objectives, decision support needs and performance requirements to meet business objectives.

Prepared data for BI solutions including identification of missing information and lack of quality to the client.

Education:

Knowledge Systems Institute

M.S. Computer and Information Sciences: May 2013 – Dec 2016

Illinois Institute of Technology

M.S. Electrical Engineering: Jan 2009 – Dec 2010

University of Oklahoma

B.S. Electrical Engineering: May 2004 – May 2008

Skills Set:

SSIS 2012/2008, SSRS 2008,MS-SQL Server 2014/2012/2008,C#, PL/SQL, T-SQL, MS Visual Studio 2008/05/03,VSS, Python, Power Pivot, MS-SQL Server Management Studio, PL/SQL Developer, Windows XP, Oracle 10g, Team Foundation Server (TFS), Linux, STS, Git, PowerBI

Certifications:

Microsoft Certified Solutions Associate (MCSA): BI Reporting – Certified 2020

Applied Data Science Module: Unit 1 Certification - Certified 16 Sept 2019

Professional Experience:

Company: Systemspecs, 136 Lewis Street, Lagos, Nigeria

Role: Software Developer

Duration: 05/2018 –06/2019

My role as a software developer was primarily the creation of Jasper reports for their Java applications.

Responsibilities:

Customized the implementation of existing Jasper implementation.

Created the ADHoc view according to the required domains.

Created Users and Roles in the database.

Created new Input Controls like Drop down lists on Jasper Server.

Performed Unit testing with different test cases.

Created SQL database tables, views, procedures and functions as per requirement.

Designed and developed Financial and Billing reports using iReport and deployed onto Jasper Server.

Utilized excel to create an interactive dashboard as per company requirement.

Company: PSAV, Chicago, IL

Role: MS SQL/BI Developer Consultant

Duration: 11/2015 – 11/2016

The main goal of the project was the consolidation and integration of data from Oracle, excel files and SQL databases into a SQL Server database as well as design and implement an ETL process for loading the data warehouse.

Responsibilities:

Created SSIS packages to load data from Oracle, Excel and SQL database into SQL database staging environment.

Created Data Mapping Document for the migration process to the Data warehouse.

Created SSIS packages which utilize Change Data Capture to ensure incremental loading is performed efficiently when loading data from Stage to Data warehouse.

Increased the decision making capability of staff by providing real time report information.

Created reports using Power BI desktop.

Created and tracked Key Performance Indicators.

Performed analysis and provided Key insights on the data.

Created a company online dashboard utilizing Power BI Services.

Provided support in the user acceptance testing and ensured maintenance of reports.

Company: Emmi Solutions, Chicago, IL

Role: MS SQL/BI Developer Consultant

Duration: 07/2015 –10/2015

The main goal of the project is to design and implement a migration strategy data from legacy SQL system to the new system.

Responsibilities:

Designed migration strategy for the migration process.

Created 13 SSIS packages using SSIS 2014 for the migration of data from the legacy SQL system to the new system.

Modified packages to ensure the required minimum 95% success rate for data for each table being migrated is fulfilled or a roll back of the data occurs as per requirement.

Created and utilized database snapshots when performing performance testing to optimize performance of packages.

Configured, deployed and ran SQL server jobs using SQL Server job Agent.

Company: Health Care Service Corporation, Naperville, IL

Role: MS SQL/BI Developer Consultant

Duration: 08/2014 – 06/2015

The primary aim of the project was the migration from MS Access backend setup to SQL Server backend setup.

Responsibilities:

Designed the ETL procedure required for modifications to the existing data.

Creation of 20 SSIS packages for the migration of data from MS Access to SQL Data warehouse.

Created OLAP Cubes for reporting purposes.

Created Excel Pivot tables from the Cubes which were used for reporting.

Improved efficiency of stored procedures from 3hours to 30mins using execution plan and SQL Server Profiler.

Assisted in the training of new and less experienced employees.

Company: Gallup, Omaha, NE

Role: Systems Application Developer

Duration: 05/2014 – 08/2014

The aim of the project was to perform data munging on the source data and implement a migration strategy to a new database.

Responsibilities:

Created data models using Erwin Data Modeler

Creation and design of migration strategy for over 3 terabytes of data.

Coordinated with team lead in the Implementation of migration strategy.

Converted data into actionable insights by predicting and modeling future outcomes

Company: Gateway EDI, Saint Louis, MO

Role: MS SQL/BI Developer Consultant

Duration: 11/2012 – 05/2013

The aim of the project was to design, create and implement new ETL processes for the backend of a vendor reimbursement web application as well as create monthly billing reports and vendor reimbursement reports for the accounting department.

Responsibilities:

Designed and implemented SSIS packages for credit and debit memo reimbursements.

Created stored procedures for the Vendor Initiated Processing Packages.

Created Cubes for data analysis and report creation.

Created the Data source views, hierarchies, Calculated members, Aggregations and Attribute Relationship involved in Cube creation.

Identified Key Performance Indicators (KPIs) driving Vendor participation in vendor programs.

Created Drill Down reports from Cubes using SSRS.

Contact this candidate