SQL Support

Les Szczepkowski

***-***-***(h), ***-***-***(c)

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

SUMMARY

Five years of Oracle and CrystalReports reporting.

Ten’s of years of SQL(seventeen years with Visual Foxpro)development.

Eight years of .NET and Web Applications development.

Experienced in object-oriented, event-based programming techniques.

Advanced in designing and implementing client/server architectures.

Expert in all aspects of database modeling and design, solid practice

in Oracle and MS SQL databases development and programming.

Extensive reporting for large organizations.

Able to work independently as well as lead a team.

EXPERIENCE:

NYC School Construction Authority - 09/06-09/19

Systems Analyst / Designer / Programmer:

-Developed / maintained / updated / debugged assorted systems

using many software packages and languages (Oracle, Crystal

Reports, FOXPRO 7-9,Access,)to accomplish that task

including Financial Analysis System and other MIS Systems.

-Prepared Bidding Information for Web Posting and Web Publishing.

-Coordinated programming work with other IT consultants.

-Updated/automated Executive Reports to be posted on Internet.

-Coordinated/Supervised generation of quarterly reports for LL24.

-Projects Lifecycle Control, monitoring and statistical reporting

-Provided a wide range of services relating to the analysis and

programming of computer systems.

GENERATION+ MANHATTAN HEALTH NETWORK 09/01-07/06

BROOKLYN NORTH HEALTH NETWORK

Systems Analyst / Designer / Programmer:-Consultant

-Converted / maintained / updated / debugged assorted systems

(FOXPRO 2.6 to Visual Foxpro 8.0) connected to MS SQL 2000,

using Visual Pro Matrix Enterprise v 7.0 application generating

tool.

-Managed and coordinated all aspects of development of web based

HR System involving technology consultants and organization wide

Staff.

-Participated in making department wide information technology

Recommendations to the HR Director.

-Supervised IT group within HR department.

-Developed extensive set of reports using Crystal Reports and VFP 8.0

Extensive analysis and design of HR and Benefit Systems.

-Provided a wide range of services relating to the analysis and

programming of computer systems (Systems Analysis Systems Design

using UML and OOP).

CITIGROUP -CITIBANK INVESTMENT SERVICES 01/01-07/01

Snr. System Analyst / Designer / Programmer:-Consultant

-Converted / enhanced / debugged Workflow System from existing

Visual Foxpro Application to Client connecting to MS SQL .

Existing applications partially generated by previous contractors

using Visual Pro Matrix v5.0 was missing Pro Matrix project files

and was mixed with out-of-the project forms and objects and required

recreation of the Pro Matrix project.

-Performed Formal Software Inspection and Code Review to improve

reliability and efficiency of the System. Increased

the execution speed of Queries and Reports.

-Team leader for two consultants.

DONALDSON, LUFKIN &JENRETTE -FIXED INCOME DIVISION 07/96-12/00

Snr. System Analyst / Designer / Programmer:

-Developed / maintained / updated / debugged assorted systems

involving specialty tasks and using software, netware and

languages VISUAL FOXPRO 6.0, VISUAL C++ 6.0, VISUAL BASIC 6.0) to

accomplish that task including Financial Analysis System, Risk

Control System and many other Management Information Systems.

-Participated in a large scale Client-Server system development

using VISUAL C++ 6.0 and MS SQL.

-Managed conversion of Client-Server applications involving

cooperation of many staff members.

-Developed Reporting System using Crystal Reports.

THOMSON FINANCIAL SERVICES - New York 10/93-07/96

Snr. System Analyst / Designer / Programmer:

-Managed full life cycle of new systems (Customer Support and

Contracts Maintenance) starting from business analyses and users

needs, then recommending possible ways of Information Processing,

designing the systems, implementing and debugging, training users

and supporting additional requirements

-Converted existing Accounting System from Foxpro 2. 0 DOS into

VFP 3.0, adding new features (Tax Calculation, Management Reports)

-Created link between systems working under different

platforms(VAX, Unix, and DOS) for automatic data transfer.

-Created reports from MS SQL Database using Crystal Reports and VB

EDUCATION: LEARNING TREE INTERN. - New York

Migrating to Visal Foxpro, Visual Foxpro 6.0 Advanced

C++ for C programmers

SEAGATE SOFTWARE -New York

Introduction and Advanced Crystal Reports

ORACLE EDUCATION CENTER - New York

ORACLE 8.0 : SQL, SQL*PLUS AND PL/SQL

TECHNICAL UNIVERSITY - Wroclaw, Poland

M. Sc.,Computer Science(Technical/Scientific IS)

TECHNICAL EXPERTISE:

Software: Visual Foxpro 2.5-9.0, MS SQL 7.0/2011, T-SQL, Oracle 11.0,

PL SQL,MSDE, XML, UML, Crystal Reports 8.5-2011

MS Windows, MS Office,PVCS, Source Safe, Rapid SQL,

Visual Pro Matrix.

Contact this candidate