Quality Assurance Data

Location:

Northbrook, IL

Posted:

November 27, 2012

Contact this candidate

Resume:

Title:Computer Technical Support

*******@*******.***

Document

Source below

NAME: Alex Saginur

ADDRESS: **** ******* **

CITY: Northbrook

STATE/PROVINCE: IL

ZIP/POSTAL CODE: 60062

COUNTRY: USA

EMAIL: *******@*******.***

PHONE: 847-***-****

CANDIDATE ID: 117432

CITIZENSHIP: US

Citizen

EDUCATION: Bachelor Degree

EXPERIENCE: 5

WILL RELOCATE: No

RELOCATION INFO:

JOB WANTED: Any

RATE NEEDED: Open

HOMEPAGE:

HOTSKILLS: business analyst =4+ yrs, Quality assurance =3+ yrs, Programmer analyst =5+

yrs, Data warehousing deve =5+ yrs

ESUME

Alex Saginur

3254 SANDERS RD NORTHBROOK, IL 60062TEL: (847) ***-***********@*******.***

Objective A challenging and demanding position that will create and enhance my current

and future skills in the financial and/or manufacturing arena of the system analytical

field and in Software Testing and/or Quality Assurance, IT implementation and support.

Computer skills Hardware: IBM-PC CLONES, IBM Netfinity, RS6000, Sun E-10K

Operating Systems: WINDOWS 95/98/2000/NT, UNIX, VMS, MS-DOS, DB2, OS

Programming Languagesand Data Bases: SQL, PL/SQL, VISUAL BASIC, PRO/C, COBOL, PL1, ALGOL,

Shell Script, HTML, PERL, ASP, ORACLE, SYBASE, SQL Server 7.0, MS ACCESS, MS EXCEL

Applications: COGNOS, ERWIN, WINRUNNER, Test Director, TOAD

Professional experience

01/2001

PresentProspect design, Inc. Lake Bluff,

IllinoisBusiness Manager

Developing short-term & long-term strategies for new business

partners & associates. Implementation web site, testing, maintenance and client

support.

10/200001/2001Allstate Insurance Northbrook, Illinois Business Analyst

Analyzed and maintained a sub-system of the Allstate Investment System. Monitored and

analyzed financial transactions in ORACLE environments (UNIX, 2000, NT & 98 platforms on a

TOAD system). Conducted functional and integration tests for multiple trading

systems.(Automation testing: WINRUNNER, Test Director) Analyzed system requirements and

produced testing specifications. Developed and designed test plans and executed test

scripts Analyzed and interpreted business information using COGNOS Power Play(offers

users an ability to easily wander through their information package). Implemented Data

Warehouse solutions using Star and Snow Flake Schemas. Created Library Server Load Status

reports based on UNIX Shell scripting and PL/SQL procedures. Improved performance by

analyzing and updating monitoring scripts that collected statistical information on

database objects. Active member of the Allstate Support Team.Environment: SQL, Oracle,

UNIX, 2000, NT, 98, Data Warehousing on WEB, PL/SQL, ASP05/2000 10/2000 Northern Trust

Banking Company Chicago, IllinoisSystem Analyst Analyzed and documented data sources and

transformation logic. Created, modified, validated and moved into production --

analytical policies and procedures. Performed tests and supporting efforts on SQL server

(Sybase System 11) based on the PIER system. Assisted end-user with interfaces into G/L,

Accounts Payable/Receivable (SAP) Developed and analyzed system design specifications in

order to support business requirements. Documented current and proposed systems

operations, business process, policiesand procedures. Estimated work effort and plan

technical portion of project. Developed and designed test plans and executed test

scripts. Provided end-to-end coverage of all end-user needs using COGNOS Impromptu.(for

delivering reports based on interactive query and reporting tools). Moved applications

into production and assisted with post-implementation issues.Environment: SQL, Oracle,

Oracle Financial, Unix, NT, Sybase, RL/SQL, Data Warehousing, ERWIN

03/199905/2000Zurich Kemper Life

Schaumburg, Illinois Data warehousing analyst Redesigned and enhanced

CK4 and KILICO systems that supported traditional and annuity products for life insurance

companies. Developed, tested and implemented conversion programs for CHECKFREE IRS TAX

and FORMMAKER systems. Developed system design specifications in order to support

business requirements. Created import/export interfaces into GL, AP, AR, CM, FA (IBM

AS/400) Designed and implemented conversion tasks to migrate data from CK4 mainframe to

Oracle based COMPASS database. Participated in full life-cycle development, including

design, analysis, coding, testing, installation and production support of the systems.

Provided financial analysis data mart using OLAP. Distributed data warehouse information

to users based on COGNOS packaging tools. Presented assistance and technical guidance to

less experienced staff and conducted walk-through and training sessions for new team

members. Simplified the logical data model by organizing data entities in a more optimal

fashion for analytical processing (from Star to Snowflake schema).Environment: SQL,

Oracle, Oracle Financial, UNIX, NT, Visual Basic, PL/SQL, Data Warehousing, ERWIN

09/1996-

02/1999

Dyntel Corp. North Chicago, IllinoisData Warehousing developer / System manager

Developed Oracle based Integrated Resource System (MIRS) for the United States Military

Entrance Processing Command (USMEPCOM). Designed and implemented features that provided

automation and communication capabilities for data sharing on all levels of the USMEPCOM

through distributed architecture. Analyzed business requirements in close coordination

with external customer and functional user personnel. Managed staff of six developers.

Supervised and approved internal inventory and financial controls. Executed operating

budget within specified framework. Analyzed, designed and updated ORACLE database with

more than 350 tables and 3000 columns. Designed and developed ORACLE forms and reports

using Developer 2000. Implemented systems that coordinated communications between the

host and 65 outlying stations(Used Impromptu to allows users import queries from Cognos

query). Participated in all phases of software development cycle, including analysis,

design, development, support, and maintenance and enhancements of the system. Documented

current and proposed systems operations, business processes, policies and

procedures.Environment: SQL, Oracle, Oracle Financial, UNIX, NT, Developer 2000, PL/SQL,

Data Warehousing, ERWIN09/199209/1996 Chicago Messenger Service Chicago,

IllinoisProgrammer analyst Participated in design, development, implementation and

maintenance of VB4.0 and MS Access based system. Implemented data entry, data entry

validation, logical data consistency check, and inventory control and distribution

functions of the system. Designed and developed VB and MS Access forms and reports for the

system. Developed an application to perform order processing and shipment updates.

Implemented and maintained a VB4.0 based system to support transportation tasks processing

based on time and location of delivery.09/198906/1991 Merchants Home Delivery Service Des

Plaines, IllinoisProgrammer analyst Maintained and supported applications for Inventory

Control in warehouse, G/L application & data and accounts receivable/payable. Responsible

for data flow of the above mentioned items to HQ.

Education 1983

1987 Georgian Technical University Tbilisi, GeorgiaBS in Computer Science

Additional courses 1998

Greenbrier and Russel, Inc Schaumburg, Illinois Certificate in

Developer 2000: Build Forms 1994 Atlantis Technologies, Inc Arlington Heights,

IllinoisCertificate in Developing Client Server Applications 2001 Solex Computer Academy

Wheeling, Illinois Certificate in Software testing and Quality Assurance

References Available upon request