Quality Assurance Sql Server

Objective

Seeking a position in software development/quality assurance where I can

utilize my knowledge and experience in programming, analyzing, developing

and testing software business applications.

Experience

Client: Repsol Houston, Texas

Jun 2010 -Sept 2010

Allegro or other ETRM system experience ( risk or trading experience)

Document via e-mail production issues

Troubleshoot and analyze with development team/business issues with Allegro

Write Use Cases

Client: Adapt2Solutions Houston,

Texas Jun 2009 -Oct 2009

. Designed and developed custom reports to work with Entegrate Energy

Trading and Risk Management System, the reports were created to

accommodate FERC 552 Purchase and Sales report regulatory compliance

requirements. iReports and Jasper Reports were used in the

development.

. Designed and developed accounting audit functionality for Entegrate

Energy Trading and Risk Management System. Oracle PLSQL packages and

triggers were used in the development.

Customers: USGypsum, Spark Energy

Client: Allegro Corporation Houston,

Texas July 2008 -Jan 2009

. Assist in the configuration of Allegro software application to accept

and load inbound files (.CSV files, flat text files) provided by the

client, Integration of Allegro application with systems via creating

and implementing Interfaces.

. The Interface outlines can be summarized in three interfaces that were

produced for the Repsol LNG Project: The Hermes Price Import for use

to import prices for settlement and analysis purposes, SAP Financial

Detail Export and the ICE Transactions Import.

. The interfaces were based on stored procedures that I created and

implemented to import, validate and update data (prices,

volatilities, interest rates, exchange rates, and credit limits).

. To be able to identify data faults in the working of the interfaces I

have created and implemented a set of Errors Capturing reports.

Customers: Repsol LNG

ATMOS Energy Houston, Texas

Dec 2006 -Jun 2008

. Created new custom reports using Crystal Reports to work with the Allegro

system. Allegro is an energy risk management and trading system used by

Atmos Energy to mange their natural gas trading and scheduling.

. Migrated existing Crystal Reports form version 9 to 10 to get them to

work with the Allegro application.

. Test the modified reports and Tied out the Results to pre migration

reports.

. Created database views, tables, triggers and packages to aggregate and

gather data needed by the new reports.

. Analyzed existing reports and modified them to better address Atmos

business needs.

. Created formulas, sub-reports and parameterized reports.

LODESTAR Corporation Houston Texas

Jun 2006 - Nov 2006

. Assist in the configuration of LODESTAR'S software application to accept

and load inbound files sent by the client. Lodestar software application

is used to manage and gather electrical meters data and to produce bills

reflecting electricity consumption.

. Create detailed test scripts and use cases to test all functional

requirements for a Kansas City Power and light needed to implement

Loadstar software application.

Customers: Kansas City Power and light

ATMOS Energy Houston, Texas

Jun 2006 -Nov 2006

. Modify in house written custom Crystal Reports to work with the new

Allegro Energy Trading Software release 7.6 and it is new database

structure.

The work is part of on going efforts to migrate from Version 6.09 to

7.6

. Modify Database Views used be the reports to work with new database

structure.

. Test the modified reports and Tied out the Results to pre migration

reports.

. Created new custom reports using Crystal Reports based on Atmos

requirements.

Client: AdvantEDGE Amman, Jordan

Jun 2003 -Oct 2005

. Worked as a web designer and developer, developed web pages using

Microsoft's ASP.

. Wrote Java scripts and Visual Basic scripts to access and manipulate the

data and post business transactions to the database behind the web site.

. Used Microsoft SQL server 2000 to create and maintain the database.

. Wrote database PL-SQL packages, stored procedures and functions to

process data based on the required business rules.

Jenin Centre for Strategic Studies Amman, Jordan

May 1999 -Jun 2000

. Designed and Created Database system (Oracle 8i) to keep track of

articles, posted by the company, dates on which they where posted,

authors and other related details. The company posts articles/news/events

coverage on local and regional on line news web sites.

. Wrote reports that use SQL queries to present various needed reports.

Reports where written using Crystal Reports. The front end of the

application was done in Visual Basic 6.0.

Client: Abu Shakra Trading Agency Amman, Jordan

May 1994 -Aug1997

. Worked in the IT Department, supported Inventory, accounting and

purchasing programs/database systems. The programs were written in

FoxPro.

. Developed custom reports to fit the company's specific needs.

. Worked on the migration form the old version of the system to the new

one, including Data Migration.

Education

Bachelor in Computer Science and Information Systems

Aug 2003

Philadelphia University Amman- Jordan.

Skills/Knowledge

Programming:

Oracle Forms and Report Writer 6i, 9i and 10g, Visual Basic, C ++, OOP,

Java script, ASP, ASP.net, HTML, FoxPro2, FrontPage, Programming, PL/SQL

Database:

Oracle 7/8i/9i/10g, MS SQL Server 7.0/2000.

Platforms:

DOS, Windows 95/98/2000/XP/NT.

Training Courses

Trained in Application Java Script, V.B Script, HTML, SQL server and ASP

in New York Computer Academy.

Toastmasters International Member (Houston TX): attending weekly on going

leadership and communication training.

Contact this candidate