Sql Server Customer Service

Babatunde Adegoroye

**** * ******* **

Orlando Florida 32811

(614) -218-7625 Mobile

abhjef@r.postjobfree.com

OBJECTIVE

To secure a position that will offer the chance to use my skills,

experience and provide advancement opportunities.

TECHNICAL SKILLS

SQL Server Integration Microsoft Windows Starbase

Services(SSIS) 2000, XP PowerKana Email

SQL Server Reporting Microsoft Advance Lotus Note Email

Services(SSRS) Excel, Remote Client VPN

SQL Server Analysis Services Microsoft Advance Vector

(SSAS) Access TSYS

SQL Server Management Studio Microsoft PowerPoint, Calyx(Mortgage

(SMS) Program)

Business Intelligence Studio Microsoft Advance Fidelity

(BIDS) Word Passport(Mortgage

C#.NET, Coldfusion Microsoft Visio Program)

Html, XML, and CSS Microsoft Project

Visual Basic.NET (XML and SQL Server

SOAP) 2000/2005/2008

Visual Fox Pro Microsoft Server

Toad(Query Optimizer and 2000, 2003

Reporting)

SOFT SKILLS

Interpersonal Skills Teamwork/ Leadership/ Role

Operating procedure communication model.

Analytical skills Relationship Computer Skills

Management

Administrative and

Clerical

EDUCATION

2008-2010 -Strayer University Atlanta, GA- Msc (Hons) Software Engineering

Management

2003-2007- Franklin University Columbus, OH -(Bsc) Management Information

Systems (MIS)

Minor (Bsc) Information Technology (IT)

ASSOCIATION

Active member Alpha Chi National Honor Society

QUALIFICATION

Database Analyst

February 2008 - Present

CoreLogic

Norcross, GA

. Develop, plan, schedule and implement changes to the database

environment while maintaining critical business data availability.

. Helping with other IT operations activities such as creating and

sending XML specification to the client, creating FTP and FTPs

connection, managing Visual Fox Pro 9 to process data import to the

database, and data encryption

. Enhances data delivery team accomplishments and competence by planning

delivery of solutions; answering technical and procedural questions

for less experienced team members; teaching improved processes;

mentoring team members.

. Identifies client data delivery requirements by interviewing

production and sales department ; studying reporting and end user

needs; evaluating data issues and problems; examining application

scenarios, refining search criteria

. Involving in other project process using agile model

. Plans data delivery by establishing data and metadata architecture

. Developing data models and a data delivery strategy; recommending

warehousing design strategies; evaluating data delivery tools and

architecture technologies; preparing external interface guidelines and

procedures.

. Creating and maintaining existing SQL Server 2005/2008 SSIS package

using multiple control and data flow tasks to generate merge hits from

the production database.

. Creating and generating both ad hoc and report applications using SSRS

. Application monitoring, performance tuning, testing and

availability/capacity planning.

. Work closely with DBA function to ensure availability and performance

essential database services within application infrastructure.

Jr. DBA/Application Support

December 2005 - January 2008 JP Morgan Chase

Columbus Ohio

. Ensuring availability and performance of the databases that support

business applications (e.g. system monitoring, performance tuning,

routine maintenance tasks).

. Involve in high availability process such as replications, database

mirroring, failover, and log shipping.

. Building database schemas, tables, procedures and permissions

. Creating and executing SQL Server backup and recovery policies, and

maintain integrity and reliability of access to information

. Support window and web application to ensure stability and

availability

. Maintain and updating users' account on Active directory (Window

Server 2003)

. Working with development teams to assist in overall database design,

helping developers tune queries, assign proper indexes, create

triggers and stored procedures

. Importing and exporting data to and from the SQL Server databases

. Monitoring the database systems and jobs to ensure minimum downtime

. Troubleshooting and problem solving of SQL databases

. Serving as SME on Microsoft T-SQL, creating and optimizing all

database objects, stored procedures, tables, views, triggers, indexes,

user-defined functions and SSIS packages

. Improving and maintaining the databases to include rollout and

upgrades.

. Actively identify incidents and manage the incident resolution process

to provide service recovery

Jr. Developer/ System Analyst

December 2003 - December 2005 JPMorgan Chase Bank Columbus OH

. Analyzing business needs with the understanding of OO procedures and

managing multiple projects (Five at least) for different line of

business. Transform business needs to technical terms and develop

business and web applications using C# and ASP.net.

. Gathering RDBMS Database Life Cycle process using client's interview,

prototyping, analyzing existing systems to produce a detailed

specifications that will be used in design phase.

. Develop database Oracle SQL and enhance it with Coldfusion web service

application program. Understanding the dependency in the Entity and

Attributes. I also make sure that the ENTITY and Attributes are in

3rd Normalization position.

. Involving in extensive data modeling using ERWIN Data Modeler to

create database logical and physical design.

. Designing a quality RDMS with the options of normalizations,

association/relationship, cardinality, and to avoid data redundancy,

referential integrity, data integrity, and other irregularities.

. Transforming the logical design to physical by writing code to create

schema (if needed), tables, table partitions, file group and, and

also by enforcing data integrity using constraints to the tables.

. Evaluate code to ensure that it is valid, properly structured, meets

industry standards, and is compatible with browsers, devices, or

operation systems.

. Analyze user needs to determine technical requirements

. Maintain an understanding of current Web technologies and programming

practices, and conduct coding, testing, and debugging.

. Identifying options for potential solutions and assessing them for

both technical and business suitability ;Creating logical and

innovative solutions to complex problems

. Drawing up specific proposals for modified or replacement systems and

producing project feasibility reports;

. Presenting proposals to clients, and working closely with developers

and a variety of end users to ensure technical compatibility and user

satisfaction;

. Ensuring that budgets are adhered to and deadlines met;

. Write reusable code with user-defined functions, custom tags and

components

. Facilitated meetings with department managers to coordinate the manual

collection of data required for Conversion. (4 departments, 8

representatives) Coordinated the manual collection of data and

formatted the data to flat files for feed to Conversion Processing

tool.

. Requirements were implemented through the course of development and I

facilitated technical staff and clients for maturity of the Project

Plan. Constant redefinition of feature and functionality boundaries

were handled with open and accessible communication lines to managed

development expectations.

. Develop, plan, schedule and implement changes to the database

environment while maintaining critical business data availability.

. Profound experience in the design and development of SQL Server

Integration Services (SSIS) packages covering a variety of technical

scenarios encountered in the construction of complex data warehousing

solutions.

. Use warehouse to support multiple business and subject areas such as

Finance, Operations, Risk, data analysis, data marketing and Mortgage,

and momentous experience developing MS SQL Server Analysis Services

cubes.

Senior Financial Service Advisor/Customer Service

February 2002 - December 2003 JPMorgan Chase bank

Westerville, OH

. Communicate with the customers on a daily basis to resolve credit

inquiries as well as verbal and written communication skills utilized

daily.

. Calculating and generating customer information financial information

using Microsoft Excel.

. Problem solving in a timely and organized manner to ensure quality

customer service is provided.

. Computer skills have been incorporated with an emphasis in Microsoft

Windows software.

. Enjoy working in a team environment while thriving individually to

provide customers the service they deserve.

. Provide correct solution to problems, Communicate constructive

coaching give to teammates on a daily basis.

. Excel in production standards and the quality of work produced.

Also, I handle merchant dispute projects to serve as an advocate for

the cardholder following VISA, MASTERCARD, and Government REG Z

regulations to resolve the issues between merchants and cardholders.

Contact this candidate