Sunny.U.Okoro

Cell: 312-***-****

Email: ad1zrt@r.postjobfree.com

Portfolio (SlideShare): Sunny Okoro LinkedIn: Sunny U Okoro

Blog: Dozie & Associates Clearance: Security (US Dept of State inactive)

Work Authorization: American Pay Rate: W2, Independent

Education

M.S. Information Technology: Database Systems Technology 2010- 2014

University of Maryland University College Online

B. S. Information Systems Technologies 2010

Cumulative GPA 3.1/4.0

Southern Illinois University Carbondale

Areas of Expertise

•Database, Data Mart, Data Warehouse & BI • DBA • SQL, PLSQL, MDX & TSQL

•Data Modeling • Data Architect

•

Executive Summary

•Experienced Database developer with experience in database development including normalization, database migration, query optimization, Tablespace, Schema, database objects and queries utilizing T-SQL, PL/SQL, PL/pgSQL and other SQL dialects

•Experienced BI developer with experience in utilizing BI applications like SSRS and Power BI

•Experienced ETL developer with experience in data transformation and migrations utilizing applications including Microsoft SSIS and Talend

•Experienced Data Warehouse developer with experience in Data Warehouse methodologies including dimensional modeling, de-normalization and ETL process

Professional Experience

Application Integration Specialist January 2023- November 2023

Amalgamated Bank of Chicago

●Performed Database Backups on SQL Server 2012, 2014 and 2017 platform

●Installed various financial applications and SQL Server database for the bank

●Assisted with various application migration projects

●Restored SQL Server Database

●Utilized Microsoft Power Apps to create forms using Microsoft forms

Sr. Oracle/SQL Database Developer Consultant (Level IV)

Argonne National Laboratory June 2019- October 2019

Lemont, IL

Assisted with the Oracle to SQL Server Data Migration Project.

●Designed and Deployed Database System using SQL Server 2016 embedded with Stored Procedures, Tables, Views, User Defined Functions and Cursors to store and process data

●Utilized TSQLstatements embedded with functions to process data for data validation

● Utilized Oracle PLSQL statements to process data and extract data from an Oracle Data Warehouse and Database Systems including packages, views and user defined function

●Translated Oracle Packages, Views, User Definition Functions and Cursors using TSQL scripts

●Utilized applications to import and export data from Oracle SQL Developer into SQL Server

●Worked with Application developers and DBA to identify and resolve any data issues related to data migrations

●Developed staging tables, functions and views utilizing Oracle PLSQL statements in Oracle 11g database

Founder & Lead Developer (Corp to Corp work)

Dozie & Associates Inc April 2017- Present

Independent work as tutor for college students locally assisting with database projects 2017

SQL Developer

QBE North America August 2017 – October 2017

Sun Prairie, WI

•Worked with other Data Analyst to analyze data for errors using Microsoft Excel

•Contributed with the research and development of the Data Warehouse

IT Consultant

Motorola Solutions July 2015- December 2015

Schaumburg, IL

Database & ETL

•Designed and Deployed Database System embedded with Stored Procedures, Tables, temporary Tables, Views and User Defined Functions (UDF) using SQL Server 2008R2 instance to automate ETL Processing.

•Manipulated and Extracted data using PLSQL statements embedded with functions from Oracle 11g Data Warehouse System using Oracle SQL Developer across multiple fact and dimension tables

•Installed and Deployed Oracle 11g Client to establish linked server in SQL Server Database to extract data from Oracle based Data Warehouse using OpenQuery nested with both TSQL and PLSQL statements within Stored procedures and UDF

•Installed JTDS JDBC driver within Oracle SQL Developer to establish connection with a Microsoft SQL Server database instance

•Utilized TSQL Statements embedded with UDF, Stored Procedures, Views and Functions to extract and manipulate data using SQL Server Management Studio and Oracle SQL Developer from SQL Server Database

•Utilized SQL Server Import and Export utility and bulk insert statements to load data into SQL Server Database

•Installed and utilized Microsoft.ACE.OLEDB.12.0 to create linked server to various Excel files

•Imported and exported files to various Microsoft Excel files using OpenQuery within stored procedures

DBA

•Created and managed user accounts including passwords and privileges for SharePoint and InfoPath user accounts

•Archived and restored Databases within SQL Server instance

•Imported archived production database into a development database for InfoPath application development

•Created and managed multiple databases including ETL and SharePoint database

Analyst

•Collaborated with Business team and Data Architect to review data requirements, data structure and ETL automation

•Resolved data discrepancies with Business team and Data Architect

•Utilized data requirements to analyze data using Excel to discover any discrepancies

SharePoint

Performed research into forms automation using Microsoft SharePoint Server 2010 and InfoPath 2010

•Installed and deployed SharePoint Server in a development server using Windows Server 2008

•Utilized Microsoft Visual Studios 2010 to create and deployed Web Services using C# scripting language

•Designed and Deployed Database System using SQL Server 2008R2 instance embedded with tables, views, stored procedure, constraint, indexes and UDF to store and process data generated by InfoPath 2010

•Utilized ADO.Net within web service to execute SQL Server Stored Procedures to process and retrieve data from a database or user using InfoPath dynamic forms

•Deployed a web services to a SharePoint Server

•Utilized SharePoint Designer to create and manage sites

•Designed and deployed forms using Microsoft InfoPath 2010 to a SharePoint form library

SQL/SSIS Developer Consultant

TriZetto

Greenwood Village, CO August 2012 – February 2013

Database

•Designed various database objects including tables, User Defined Function (UDF) and Stored Procedures within a SQL Server 2008R2 database

•Utilized complex TSQL Statements embedded with functions to extract and manipulate data using UDF and Stored Procedures

ETL (SSIS)

•Designed and deployed SSIS packages using Microsoft Business Intelligence Development Studio 2008(BIDS)

•Utilized stored procedure within each SSIS Packages to retrieve and process data based on input parameters

•Cleaned and Loaded data into a SQL Server 2008R2 database using SSIS 2008 various Control Flow and Data Flow components including Script task, Foreach Loop Container, File System Task and Data Flow like Merge, sort and Row Count

•Utilized C# code to display row count message to end user using Row Count and Script Task

•Utilized custom C# code to log error message using Script Task to a SQL Server Database

•Validated SSIS packages using BIDS and Microsoft SQL Server Execute Package Utility

•Extracted data into various files using Flat File Destination within SSIS packages

Reports (SSRS)

•Designed and deployed complex reports using SSRS 2008 embedded with Stored Procedures to allow user to retrieve data based on input parameters

•Reviewed and updated technical design documents

SQL/Business Intelligence Consultant

Enterprise Recovery Systems Inc. July 2012 – August 2012

Oakbrook, IL

Report & Analytics

•Designed reports using Microsoft Power Pivot and Excel 2010

•Utilized Excel reports to analyze data to discover new trends

Database

•Utilized TSQL embed with functions statements to manipulate data from SQL Server 2008 R2 Database

•Assisted business analysts with TSQL statements

•Created views in SQL Server 20008 database

Intern

United States Department of State Spring 2012

Washington D.C

•Assisted with various office assignment

Quality Assurance Analyst CO-OP

United Parcel Service Information Services August 2010- February 2011

Timonium, Maryland

•Conducted functional tests on software components to determine the quality of data

•Worked with Application and Database Developers to resolve various issues relating to Database or Software Applications

•Linked and updated software requirements and functional requirements using HP Quality Center

•Wrote and updated test conditions and test cases

•Utilized Serena Teamtrack to submit and manage application defect reports

Desktop Assistant Intern

C-SPAN Cable Networks January 2010 – April 2010

Washington DC

Provided daily desktop assistants including

•Installations of new operating system and applications on Microsoft Windows and Macintosh Computers

•Network services installations for various conferences

•Installation of Ethernet switch and Fiber Optic cables for new network servers

•Hardware and application troubleshooting

Database Developer Intern

Southern Illinois University Carbondale May 2009 - July 2009

Microsoft Dynamics AX 4.0 Project

Assisted with installation, configuration and deployment of Microsoft Dynamics Ax 4.0

•Installed and deployed Microsoft SQL Server 2005 database instance using Windows Server and Active Directory

• Installed Application Object Severs using Microsoft SQL Server 2005 and Net Business connection protocols

•Deployed Microsoft SharePoint Service to set up the database and administrative virtual servers

•Managed Dynamics user accounts using Microsoft SQL Server 2005

•Established proxy accounts to allow remote access to Microsoft Dynamics AX 4.0

Academic Research

Data Mining Project Fall Semester 2012

Utilized Microsoft SQL Server 2008 Analysis Service to analyze data into various dimensions

•Created cubes to implement Decision Tree, Regression and Clustering Algorithms

Database Security Project Spring Semester 2012

Implemented a database solution with Oracle 11g for a retail company

•Created users accounts, object privileges and roles for each user accounts

•Utilized PLSQL statements to create various objects including stored procedure, tables, user defined functions and triggers

•Implemented application context to create dynamic views to restrict data based on user account

•Implemented password profile to enhance password security by validating passwords based on established requirements

•Utilized the audit mechanism to monitor users activities including database operations and log ins

•Implemented virtual private database using application context to restrict data to specific user

•Extracted data into Excel for reports

Data Warehouse Project Fall Semester 2011

•Extracted and transformed data from Microsoft SQL Server 2008 into a CSV and text file using SSIS

•Utilized Oracle JDeveloper to load data into dimensional and fact tables using Oracle SQL Loader

•Utilized MS Visio to conduct reserve engineering process to capture ERD of a databases from MS SQL Server

•Utilized Oracle JDeveloper to generate insert statements from a data text file

•Created reports with MS Excel and Power Pivot by retrieving stored queries in MS SQL Server

•Imported data into MS Excel from Oracle 11g and MS SQL Server 2008 Database Systems using SSIS

Technology Summary

Applications:

Microsoft ( Excel, Visio, Visual Studio 2008 & 2010 and Business Intelligence Development Studio(2008) /SQL Server Data Tool(2012))

Oracle (SQL Developer, JDeveloper(Database Development) and SQL Developer Data Modeler), Toad, IBM Data Studio

Business Intelligence:

Microsoft (SSAS 2008 & 2012 Tabular, SSIS 2008 & 2012, Power Pivot, Report Builder, SSRS 2008 & 2012 and Power View)

Talend Open Studio Data Integration, SAP Crystal Reports,

SAP Business Objects Edge 4.0(Web Intelligence Rich Client and SAP Information Design Tool), Tableau, Cognos BI and Informatica PowerCenter Express

Courses:

Database Administration, Distributed Database, Data Warehouse, Data Mining, Database Design, Database Security, Java, Object Relational Database, System Analysis, Web Scripting(PHP,HTML, XHTML, JavaServer Pages, Cascading Style Sheets, VB.NET)

Database & DW Design:

Data Flow Diagram, Entity Relationship Diagram, Normalization, Relational Database Schema, Logical Data Model, Physical Data Model, Dimensional Model, Kimball and Inmon Model, ETL

Databases Systems:

IBM DB2 Express, Microsoft SQL Server 2005,2008 R2, 2012, 2014, 2016 &2019, MySQL 5.5 &5.7, Microsoft Access, Oracle 10g,11g, &12c, PostgreSQL 9.2.4, Sybase SQL AnyWhere 12, Sybase IQ 15.4 and Sybase ASE

Talend(Open Studio):

Palette (tmap, tLogrow, tSortRow, tAggregateRow, tFilterRow, tJoin, tFileOutput,, tFileInput), OLEDB JDBC,Job, Metadata (Db Connection,File Excel,File Delimited)

MS SSIS:

Data Flow(Aggregate, Merge Join, Merge, Row,Count, Data Conversion, Conditional Split,

Sort, Union All, Derived Column, Pivot), Script Task, For Loop Container, Execute TSQL, File System Task, OLEDB, ODBC, Flat File, Excel

Contact this candidate