Sql Server

KAZEEM TOLULOPE ATOYEBI

*** ********** **, *** *** Terre Haute IN 47807,

Mobile Number: 812-***-****

E-mail: ******@*****.**.**

SUMMARY

•

Highly talented IT professional with successful track record in Ab Initio

Architecture and development

•

Extensive knowledge in developing UNIX SHELL scripts and graphs using

various Ab Initio components

•

Experienced in working with EME and Air utility commands

•

High level of expertise in database system

•

Proficient with SQL and PL/SQL in working with Relational Databases

•

Ability to perform in a fast paced environment, meet stringent deadlines,

self-motivated, reliable team player with strong passion for success, trainable

and capable of adding valves in a reasonable time.

•

Ability to visualize, articulate and solve complex problems.

•

Excellent skills in written and ability to communicate at all levels.

EDUCATION

Master of Science: Mathematics December 2010

Indiana State University, Terre Haute, Indiana

Bachelor of Science: Mathematics September 2006

University of Ilorin, Nigeria

TECHNICAL SKILLS

•

ETL Tools: Ab Initio (GDE Version 1.1r; Co-Operating System V2.15)

•

Database: Oracle10g, MS SQL Server 2000/2005/2008,

Mainframe DB2

•

Languages: JAVA, SQL, PL/SQL, Visual Basic, HTML, XML,

•

Scripting: Unix shell scripting

Page 1 of 3

•

Operating system: Windows, Unix, Linux and Solaris

•

Data modeling Tools: SQL*Loader, SQL*Plus and EME

•

Certifications: OCA, OCP, MCP

PROFESSIONAL EXPERIENCE

Synovus, Columbus, GA February 2011 – May 2011

Ab Initio Developer

Synovus is a financial services company with more than $32 billion in assets based

in Columbus, Georgia. It provides commercial and retail banking, investment and

mortgage services to customers in Georgia, Alabama, South Carolina, Florida and

Tennessee.

Responsibilities:

•

Developed and supported the extraction, transformation and load

process (ETL) for the Data Warehouse from heterogeneous source systems

using Ab Initio.

•

Used Ab Initio GDE to generate complex graphs for the ETL process

using Join, Rollup and Reformat transform components and executed using

Co>Operating System.

•

Created .xfr and .dml files for various transformations and specifying the record

format.

• Developed UNIX Korn shell wrappers to run various Ab Initio scripts.

•

Used the sub graphs to increase the clarity of graph and to impose reusable

business restrictions.

•

Involved in development of the transformations (Filters, de-duping, Joins,

Reformat etc) using Ab Initio ETL

•

Modified the Ab Initio components parameters, utilize data parallelism and

thereby improve the overall performance to fine-tune the execution times.

•

Utilized Phases, Checkpoints to avoid deadlocks and multi-files in graphs and

also used Run program, Run SQL components to run UNIX and SQL

commands.

•

Analyze business requirements and developed metadata mappings and Ab

Initio DMLs.

•

Developed business object in accordance to business requirements

•

Involved in setting up of sandboxes and maintaining sandbox parameters.

• Extensively used EME for version control management and dependency

analysis along with Check in and Check out the code.

Environment: Ab Initio CO>OS 2.15, GDE 1.15, Business Objects 4.0, Oracle 10g,

DB2, UNIX, QTP SQL server 2008,UNIX korn shell,Windows XP

Page 2 of 3

NEM Insurance Plc, Nigeria January 2007 – March 2009

Oracle Application Developer

Responsibilities:

• Involved in requirement analysis and prepared system design documents.

• Designed and developed table structures, Stored Procedures and Database triggers to implement business rules.

•

Built Internet access and GUI interfaces to Relational Database Management

Systems (RDBMS).

•

Coded, tested, debugged, documented, and maintained programs.

•

Created detailed project outlines, application design specifications, and test

plans.

• Designed Visual Basic classes for UI and database access modules

• Designed Editor Screen using ASP that enables a user to create multiple trunks at a time. It has an editor capability, which will parse,

validate, debug and execute a query.

• Design and implementation of Backup & Recovery strategies.

• Done the database performance tuning.

• Performed DBA and application analysis tasks.

Environment: Windows NT, Oracle 8i, PL/SQL, SQL Loader, SQL*PLUS, ASP and Visual basic 6.0

REFERENCES AVAILABLE UPON REQUEST

.

Page 3 of 3

Contact this candidate