Sql Server Quality Assurance

Chuck Umeh

**** ****** **** ******, **** ***** * 614-***-**** * E-

Mail:**********@***.***

_________________________________________________

Professional Summary

Eager to contribute highly application implementation skills and ability to

translate business requirements into technical architectural design,

development and executable strategy for the implementation of data

warehouse, data marts and integration of application processes for you

firm.

_________________________________________________

Professional Profile

* IT professional with advanced technical skillset and expertise in the

design, development and implementation of enterprise data warehouse

(ETL), enterprise application integration(EAI), systems integration,

testing/quality assurance, software development.

* Excellent problem-solver who envisions business and technical

perspectives to develop workable solutions in the development,

implementation and solving day to day application issues.

* Motivated achiever who implements new technology and enhanced existing

applications that will streamline application processes and delivers

scalable project deliverables in a timely manner and within budget.

EDUCATION

2 Years Information System Management at CLC Atlanta, U.S.A

6 Months Training Course, Oracle Developer 2000 Norcross, U.S.A

1 Month Training Course on MVS, Delta Technology, Atlanta, USA

Informatica ETL PowerCenter 7.1 Development and Administration

AREAS OF EXPERTISE

Application Development Programming Languages & Software

Application

Extract, Transform, Cleanse and Load (ETCL) JAVA, SQL, VB.net, PERL, UNIX

Enterprise Application Integration (EAI) Oracle, SQL Server, Teradata,

DB2

Application Development Informatica Power Center 7.1.2

thru 8.6

Process Improvement First logic, Automate, ERWIN,

TAOD

Application Process IBM MQ, CA7 job scheduler,

Business Objects

Professional Experience

HedgeWorld Investments, Powell, Ohio may 2010 Present

FX Trader

* Trade G7 Global Currency on daily basis by analyzing market trends,

and integrating result set with daily technical and fundamental aspect

of analysis and then place trade from among the G7 currencies that I'm

following that day.

* Administer and lead the production support of HedgeWorld Investments

trading

platform (HedgeTrader 7).

* Coordinate and work with different groups in the IT Department in

identifying the root cause of application issues from the different

modules integrated into HedgeTrader Platform e.g. (Order Book,

Benchmark Fixing, streaming prices, request for quote and CLS Module)

reported by clients and come up with a resolution fix to case issues

using the following tools e.g. SQL, Perl, Unix-Korn Shell Script,

Oracle, and SQL Server.

* Work with clients in resolving application and connectivity issues

from HedgeTrader Prime Brokerage Application. Support clients who have

electronic issues or functional questions to our suite of client-

facing trading and routing products. Monitor risk and limit thresholds

for FX Prime Broker clients using Limit Manager coordinate with Limit

Team for Limit changes and issues.

* Diagnose, resolve and manage alerts with clients that relate to

technology problems with our electronic trading infrastructure e.g.

(prime broker clearing & settlement issues, price feed delays,

problems with order routing processes, exchange/vendor connectivity,

infrastructure outages and communicate to affected client community.

Dedicated Technology, Columbus, Ohio Aug.2007 to may 2010

Senior Informatica Consultant at Ohio Dept of Education

* Designed, documented and implemented ETL policy and standards for the

enterprise data warehouse at ODE.

* Re-wrote business rules for existing Informatica ETL processes and

developed complex to large scale ETL processes for new project

initiatives

* Upgraded Informatica PowerCenter and Metadata Manager/Super Glue from

V8.1.1 to V8.4. Developed Unix shell and Perl scripts to support

Informatica data and metadata integration processes.

* Documented ETL processes architectural design and its relationship

from source to target database. Trained, recommended and supported in-

house developers with issues related to the overall ODE data

warehouse.

* Designed and maintained database logical and physical models for the

enterprise data warehouse (Star Schema dimensional model) using the

Erwin tool.

CheckFree Corporation/Fiserv, Columbus, Ohio, Dec.2005 to Aug.2007

Senior Software Developer

* Designed and documented ETL based on requirements gathered while working

on a cross-functional project team.

* Developed ETL using Informatica workflows, mappings and sessions to load

large data volumes from multiple sources into an enterprise data

warehouse.

* Supported the daily ETL cycle, including correcting production quality

issues.

* Prepared technical documentation of product sub-systems.

* Conducted unit & integration testing for functionality and limits.

* Performed moderately complex bug verification, release testing and beta

support for assigned products.

* Researched problems discovered by QA or product support and assigned to

fellow team members and sometimes, developed solutions to the problems.

* Administered Informatica Power Center and created new KSH scripts to

automate the execution of new ETL jobs using CA7scheduler.

Habitat for Humanity International, Americus, GA, June.2003 to Oct.2005

Data Warehouse Analyst

* Acted as a key contributor for the direction of enterprise data

warehouse and Informatica Implementation.

* Analyzed, designed, developed, documented, tested, maintained and

provided implementation support for informatica, oracle, SQL server

and Teradata database. Maintained Habitat enterprise logical and

physical models through the use of Erwin tool.

* Designed and developed informatica ETL mappings base on business

requirement. Performed extensive debugging and performance tuning of

mappings, sessions and workflows including partitioning, memory tuning

and cache management. Administered Informatica servers, repository

server and metadata reporter.

* Provided production support for data warehouse environment.

* Provided subject matter expertise for all questions related to systems

analysis, design, implementation, maintenance, and enhancements for

areas of responsibility. Analyzed information needs of the users and

provided reports and outputs as necessary, worked within the

established information request and prioritization system.

* Worked with the end-users to improve the existing systems and

procedures. Responsible for executing systems user requisitions for

systems configuration changes, database field and Informatica

parameter field changes. Documented standard procedures for system

application management and identified future requirements for systems

enhancement.

* Participated in Informatica Powercenter organizations, conferences,

and seminars for professional development.

Independent Implementation Specialist, Zurich, Switzerland, Aug 2001to June

2003

* Successfully implemented quicken POS systems that eliminated need for

antiquated, obsolete application.

* Successfully implemented and deployed automated receipt batch

processing systems and by adopting my developed program I was able to

safe the company $7567 dollars on annual fee.

* Built web based, database driven applications using the following

technologies: MS SQL server, ASP, JAVA, J2EE.

* Administration and Management of Vantive CRM.

S1 Corporation, Atlanta, GA, Aug 2000 to Aug 2001

SQL DBA/Web Developer

* Built applications using internet and windows development tools.

* Played a direct role in programming, maintenance, technical support

and administration of the applications.

* Responsible for the development of all three tiers on web based

application using HTML, CSS, JAVA, PHP, UNIX, Apache and SQL server.

* Responsible for maintenance and debugging of current database and web

code. Developed custom intranet/extranet forms and data content

management applications.

* Responsible for the maintenance of Time Wizard and Business Engine

database. Designed and created events, processes, status monitoring

scripts, procedures, and alerts.

Delta Airline/Technology, Atlanta, GA, Nov 1998 to Aug 2000

Application Specialist

* Responsible for the maintenance of Baan and Ace applications on oracle

database.

* Remote support for approximately 70,000 Delta Airline employees, world

wide.

* Optimized LAN/WAN with Network Management software (Tem Clients, MVS,

DRN network) with performance and fault monitoring to minimize network

downtime.

* Troubleshooting for network connectivity, hardware, software, and

printing for NT networks, UNIX and Delta Mainframe systems and

software products (TSO, CICS, MVS).

Contact this candidate