Paul Okonkwo

**** ***** ***** **, *** **** Phone: 480-***-****

Chandler, AZ 85224. Email: ac8af0@r.postjobfree.com

Proven Quality-driven, results-proven database developer, with strong SQL skills and years of visible achievements with a commitment to ensure strong operations, quality control, and compliance delivered to both internal and external business partners. Track record of successful data modeling and database design. Expertise in implementing efficient data collection and analysis methods to streamline internal and external business processes.

Summary of Knowledge\Experience

Database Professional with 10+ years of experience in data modeling, database design, SQL programming, data analysis and database administration

Extensive knowledge and experience in Computer hardware installation, Desktop support and networking.

Proficient in installation, configuration, maintenance of Microsoft Windows XP, Vista and 7.

Proficient in Microsoft business application suite - Microsoft Word, Excel, power point, outlook.

Good leadership, organizational, oral/written communication, Interpersonal, analytical, and problem resolution skills. Thrive in both independent and collaborative work environments.

Areas of Expertise

SQL Server (2012, 2014, 2016)

SQL Server Integration Services-SSIS

Microsoft Excel – Advanced

Windows Server

Model View controller

Deploy Web Apps Using MSI

Informatica

SQL Server Reporting Services -SSRS

Team Foundation Server - TFS

PowerPivot

Toad Data Modeler

ASP .NET 4.0

C#

Transact SQL

AGILE (SCRUM)

Microsoft Access

Visual Studio

Infinity Framework 4.0

Python

Professional Experience

Wells Fargo (Contractor Database Developer) Tax Credit Asset Management (TCAM) AND

Wells Fargo Equipment and Finance (WFEF) PROJECTS 04/30/2018 – 12/19/2018

using SSRS to develop TCAM and WFEF reports

Solving reports Issues when the project went live.

Create complex queries that is used to run the reports.

Troubleshoot, correct and enhance t-sql queries.

develop, troubleshoot and enhance etl packages using ssdt.

GIT was used for updating ssrs RDL and ETL DTSX files and version control.

LASSI Application software was used collaberration among associates.

skype was used to conduct meetings.

HOTFIX SQUARED INC. SWIFT BTEQ CONVERSION PROJECT

SQL Developer Jul 07/05/2017 - Present

Convert Teradata BTEQ scripts to T-SQL scripts.

Troubleshoot, correct and enhance T-SQL scripts

Tune the T-SQL scripts for high performance using indexes, statistics collection and divide & conquer technique.

Use Informatica to load data from Hadoop landing zone to SQL server and also load from Hadoop Landing zone to Hadoop history tables.

Develop, test and QA for Informatica mappings with SCD-1 and SCD-2 load methodologies.

Produced the Failed and Long running Workflow scripts report daily.

U-HALL INTERNATIONAL

SNR SOFTWARE DEVELOPER Mar 2017 – May 2017.

create complex t-sql queries, stored procedures and functions to solve medium to complex business

logics to implement in-house applications and websites that take care of customer’s needs using sql server 2014.

test t-sql queries to find out the performance issues and rewrite those queries.

check indexes on queries to find out their selectivity.

rebuild indexes on queries.

American Express Phoenix, AZ Nov 2016 – Jan 2017

Data Analyst (Configuration Inventory and IT Asset Management CIITAM)

Analysis of data in Excel to produce reports and refine the data to produce quality data.

Cleansing of data for Management reporting purposes.

Data profiling for completeness analysis, uniqueness analysis, values distribution analysis, range analysis and pattern analysis.

Use of SQL queries to pull data and manipulate data.

Experience with Excel VLOOKUP, Pivot Tables and formulas.

Provision of technical expertise in evaluating, identifying and developing system and procedures for that are cost effective and meet business goals.

Analyze Data to find root cause and to proffer solution.

Good communicator of the flow of the process to assist other colleague and management in decision making process.

A team player but individual contributor.

TAPFIN Tempe, AZ Jun 2016– Sept 2016.

Data Analyst (Vendor Performance Score card project)

Retrieved, validated, and analyzed data from multiple technology tools in order to establish accurate and comparable performance metrics using Excel and T SQL

Worked with business leaders to identify pertinent metrics and key performance indicators for analytical and reporting purpose

Partnered with the Technology team to ensure accuracy, and comprehensiveness of departmental data sets

Effectively communicated with, and responded to, internal requests for client data requests

Leveraged data visualization tools to support data analysis in the development of standard and Ad-hoc reports.

Developed reports and populate presentations with data analysis and recommendations.

Documented business and Technical processes for future references.

Created and maintained highly visible Excel based reports and dashboards for analytical purposes.

Created SSIS packages to extract, transform and load data from multiple sources into a centralized reporting model for reporting and analytical support.

Create file templates for all the programs using the Fieldglass, IQN programs and clean up data, remove duplicates, and upload to the share drive.

Eklipse Consult Chandler, AZ Oct 2012 – May 2016

SQL Developer

Creates T-SQL Queries, storing procedures and functions to implement medium to complex business logic for client applications.

Developed and maintained SSRS reports using relational databases as data sources for client reporting.

Built and maintained PowerPivot models to support self-service business intelligence reporting and analytics

Developed and maintained customized ETL processes for the development team using S.S.I.S.

Designed and implemented database architecture and database objects for enterprise projects

Participated in database code reviews and database architectural designs with members of the team

Participated in query tuning and optimization projects to increase performance of in house applications

Eklipse Consult Chandler, AZ Jan 2010 – Oct 2012

Database Developer

Created stored procedures\functions that extract transform and load data from transactional databases into data warehouse.

As part of a team, led a migration project which involved migration of critical Microsoft access databases to MS SQL 2008R2. This involved medium to complex data mapping and conversion.

Created and maintained SSIS packages to extract transform and load (ETL) data from OLTP production database at specified times into operational data stores.

Created stored procedures and functions for .NET applications

Created and maintained weekly distribution reports to senior managers sites using SQL Server Reporting Services (SSRS)

As part of a team, created data models (entity relationship models) and implemented physical database designs for enterprise applications

NITEL Lagos, Nigeria Feb 2000 – Oct 2008

LEAD SQL DEVELOPER

Created numerous T-SQL Queries, stored procedures, triggers, cursors and functions to implement medium to complex business logic for in-house applications and websites

Performed monthly maintenance review, T-SQL optimization, disaster recovery planning, and testing and custom software database installation support.

Participated in database development Standards and helped establish development protocols, unifying developers and easing the maintenance of database code and objects

Provided training and consultation to employees on in-house developed applications

Maintained documentation related to database development platform guidelines, methods and standards

As a lead database developer, redesigned and developed an enterprise inventory control application which provided a significant cost saving across the organization

Defined the goals of the system and devised flow charts and diagrams describing logical operational steps of programs.

Education

Comptia A+ Mesa Community College, Mesa AZ 2011

B.SC. Computer Science University of Lagos Lagos, Nigeria 1987.

Contact this candidate