Data Developer
Resume:
Paul Okonkwo
**** ***** ***** **, *** **** Phone: 480-***-****
Chandler, AZ 85224. Email: ***********@*****.***
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