Project Manager Quality Control

Eric R. Lichtman

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

Wexford, PA ****0

724-***-**** Cell Phone

y4qwfm@r.postjobfree.com

Objective

To obtain a career with a company, in which my knowledge, creativity, and experience will be an asset to their future growth as well as my own.

Education

Winston-Salem State University: 2003 to 2005 GPA: 3.70

Masters of Business Administration

Relative Courses: Organizational Behavior, Management Information Systems,

Emerging Issues in MIS, Electronic Commerce, Acct Cost Mgmt Sys,

Operations and Production Management, Marketing, Business Ethics

Robert Morris College: 1998 to 1999 GPA: 3.78

BS in Management Information Systems

Field concentration in Networking and Cobol Programming

Relative Courses: Strategic Management Advanced Cobol Database Management

Awards: Deans List Fall 1998 Spring 1999 Fall 1999

Community College of Allegheny County: 1991-1992, 1997-1998 GPA: 3.92

Associates Degree in Business Administration

Relative courses: C Programming Systems Analysis and Design

Work Experience

Lead PowerBuilder/Oracle PL/SQL Developer (Contractor)

Dominion Retail (Pittsburgh, PA) September 2007 to Present

Industry- Utility/Service

Platforms: Windows XP

Software Packages: Harvest 5.1.1, Toad 9.7.2.5, Putty, Lotus Notes, Microsoft Outlook,

Ultra Edit 10.10a

Languages: PowerBuilder (PB) 8.0.4, 11.2, 12.1 PL/SQL, UNIX K-Shell

Databases: Oracle 9i, Oracle 10g, Oracle 11g

Responsibilities include:

- Mentor junior and mid-level developers on programming concepts and company standards.

- Development and enhancements of multiple PowerBuilder applications

- Use of PL/SQL procedures for datawindow retrieval and data processing (DML

commands) within PowerBuilder

- Analysis and maintenance of Batch and Front-End Production issues.

- Systems analysis and design (database and front-end)

- SQL tuning to improve application response time/efficiency.

- Analysis of the impact on migrating to latest version of PowerBuilder

- Analysis and impact of upgrading to latest Oracle database upon existing applications and scripts.

- Migrated current PowerBuilder applications written in PB 8 to PB 11.2 and then 11.2 to 12.1.

- Development and enhancements to PL/SQL packages, procedures, functions, and triggers.

- Database table modeling, indexes. SQL tuning

- Development of new UNIX k-shell scripts and enhancements to existing scripts

- Work with internal and external clients to complete projects

- Coordinate new version releases of applications to desktop & Citrix users.

- Unit testing and system integration testing of enhancements and code fixes.

- Create functional and technical specifications.

- Co-ordinate/maintain multiple versions of applications to be able to work on multiple projects with different release dates (not using Version Control Software). On average I maintain 3-4 versions but have maintained as many as 8.

Sr. PowerBuilder Developer (Contractor)

Premier Inc. (Charlotte, NC) August 2007 to September 2007

Industry-HealthCare/Insurance

Platforms: Windows XP

Software Packages: Microsoft Visual SourceSafe

Languages: PowerBuilder 10.2

Databases: DB2

Responsibilities include:

- Development and enhancements of PowerBuilder application

- Unit testing and system integration testing of enhancements and code fixes.

- Work with business unit on testing scenarios

Sr. PowerBuilder Developer (Contractor)

AT&T Solutions (Orlando, FL) May 2007 to June 2007

Industry-Telecommunications

Platforms: Windows XP

Software Packages: Microsoft Visual SourceSafe, DBArtisan 8.1.3

Languages: PowerBuilder 10.2

Databases: Sybase 12.5.1

Responsibilities include:

- Development and enhancements of PowerBuilder application

- Work with business unit on new project designs

- Unit testing and system integration testing of enhancements and code fixes.

- Create UNIX K-Shell scripts to interact with SYBASE stored procedures and create .dat files

- Create SYBASE T-SQL procedures to process accounts.

- Assist peers with creation of SQL and help them with the understanding of PowerBuilder concepts.

Sr. Powerbuilder Developer (Contractor)

ACS Government Health Services (Jackson, MS) January 2007 to May 2007

Industry-HealthCare/Insurance

Platforms: Windows XP , EAServer (Jaguar)

Software Packages: StarTeam Client 6.0 version control

Languages: PowerBuilder 8 & 10.5 using PFC

Databases: DB2

Responsibilities include:

- Development and enhancements of PowerBuilder application to meet HIPPA standards for National Provider Ids

- Help develop technical documentation and provide feedback/suggestions to Project manager on what needs to be done

- Modifications to existing scripts to support National Provider Id

- Unit testing and system integration testing of enhancements and code fixes.

Sr. Oracle Developer (Contractor)

Delta Dental of Virginia August 2006 to December 2006

Industry-Dental Insurance

Platforms: Windows XP

Software Packages: Toad 8.6.0.38, PLSQL Developer, Microsoft Visual SourceSafe

Languages: PL/SQL

Databases: Oracle 9i, 10g

Responsibilities include:

- Development and enhancements of Oracle PL/SQL packages, procedures, & functions.

- Modifications to existing script to support new schemas and make use of existing DML packages, procedures, and functions.

- Support existing code by working through help desk tickets and correcting the issue(s) then documenting the error through company standard process.

- Unit testing and system integration testing of enhancements and code fixes.

- Development of test plans for QA testers in regards to business requirements.

- FTP files between servers for print vendors and users.

- Develop control scripts & UNIX scripts with sqlldr calls to load data into the database.

Sr. Programmer Analyst (Contractor)

InsureWorx (Denver, CO) May 2006 to July 2006

Industry- Insurance

Platforms: Windows XP

Software Packages: Borland StarTeam versioning control, PowerDesigner,

Oracle Forms and Reports (limited)

Languages: PowerBuilder 9.0.1, PL/SQL

Databases: Oracle 9i, 10g

Responsibilities include:

- Maintenance of PowerBuilder 9.0 applications using PFC and 6 layers of inheritance.

- Development and maintenance of report and document generating Oracle PL/SQL

packages and procedures called from within PowerBuilder.

- Unit testing and system integration testing of enhancements and code fixes.

- Documentation of defects. How to reproduce the defect and what was done to correct the defect.

- Correspond with QA group and client in regards to system enhancements and maintenance.

Sr. Programmer Analyst (Contractor)

Swift & Company (Greeley, CO) January 2006 to May 2006

Industry-Meat Processing

Platforms: Windows XP

Languages: Powerbuilder 9.0.3,

Databases: AS400 & DB2

Responsibilities include:

- Designing and coding new maintenance screens for Order Management application.

- Create low level design documentation to determine the best approach to reaching

the business goals and needs

- Assist peers with SQL syntax and other programmatic concepts.

- Interact with customers to determine the functionality needed to meet the business goals and to enhance the current Order Management application to improve usability.

- Testing and debugging new and existing script.

- Designing of new database tables and /or columns and their relationships to existing tables and/or columns.

Sr. Programmer (Contractor)

Bank of America (Charlotte, NC) September 2005 to January 2006

Industry-Financial

Platforms: Windows XP

Software Packages: TOAD 8.5.1, Reflections, ERwin

Languages: PL/SQL & UNIX K-shell,

Databases: 9.2i

Responsibilities include:

- Developing UNIX K-Shell scripts to be called from Maestro scheduling tool to begin processes that support the business.

- Developing static and dynamic PL/SQL, functions, and stored procedures to

support business Segment Level Reporting. Created CURSORs dynamically,

statically, and reference cursors. VARRAYs were used for sorting of multi-level

records pulled from different tables.

- Tuning of SQL, testing, and debugging scripts. Used MULTI table inserts to speed up processing time.

- Develop and analyze from low-level design documentation to determine the best approach to reaching the business goals and needs.

- Designing of new database tables and /or columns and their relationships to

existing tables and/or columns.

Systems Analyst

Sara Lee Intimate Apparel (Winston Salem, NC) June 2001 to July 2005

Industry-Textile/Manufacturing

Platforms: Windows NT and 2000 and UNIX

Software Packages: PowerBuilder 5, 6.5, & 7 with Cornerstone (Foundation class on top

of PFC), Crystal Reports 8.5, Install Shield 5.5 and TOAD, ERwin

Languages: Powerbuilder 5, 6.5 & 7 with PFC, Advantage:Gen, PL/SQL, UNIX K-shell,

SQL

Databases: Sybase, Oracle7.3, Oracle 8i, Oracle

Responsibilities include:

- Designed and maintained, 5 Powerbuilder applications using Oracle backend and Sybase backend

- Creation of functional and technical specification documents.

- Full life cycle experience

- Worked with team of 20 plus developers in different IT areas

- Handle security for three applications used by Planning, Purchasing, and

Quality Control departments. This requires getting the proper documentation

signed, assigning userids and passwords, and access levels to the applications.

- Develop CoolGen and PL/SQL code to support financial/costing applications.

- Maintain and write Sybase stored procedures to support Quality Control Powerbuilder application.

- Coordinate and lead meetings.

- Overall job was to support, maintain, and develop new applications for

Purchasers, Schedulers, Planners, Quality Control and Costing personnel,

- Develop programmatic solutions to meet the business requirements on existing applications

- Develop simple and complex PL/SQL to run in a weekly batch process to retrieve data for the I2 Planning System

- Create new tables, synonyms, and views in each of the databases to support new applications and enhance existing applications

- Maintain a Purchase Order Fax application and make sure it stays on-line

- Make sure weekly reports get refreshed over the weekend

- Develop new Crystal reports for internal clients

- Develop step by step documentation on installation of applications

- Assist/Teach peers/team members in learning, writing and debugging PL\SQL script.

- Develop/support batch scripts, which included analysis and correction of data and/or coding logic errors.

- On-call support of batch processing using UNIX scripting and PL/SQL. Analyze problem when job ABENDS, document, and correct issue.

Programmer Analyst II August 2000 to June 2001

Advanced Technology Systems (Dayton, Ohio)

Industry-Government/DoD

Project: Convert three existing client server systems into a single web-based system.

Platforms: Windows NT and 2000

Software Package: EA Studio 3.5 (PowerBuilder, PowerSite, Jaguar, and PowerDynamo)

Languages: PowerBuilder 7.0, PL/SQL, JavaScript and HTML 4.0, SQL

Database Tools: Oracle 7.3, Oracle8i, and Oracle Reports

Responsibilities included:

- Peer reviewing design documentation and programs

- Develop programmatic solutions to meet the client’s requirements

- Train new development team members on the connectivity of each element of the architecture, coding techniques, how to read System Design Documents and format an approach to developing a programmatic solution, and how to use templates to develop new stored procedures

- Develop screen shots and test screens to demonstrate to the client

- Determine the impact that changes to the database structure will have on existing programs.

- Support other programmers with their development, debugging and maintaining of programs

- Helped develop the standards to be applied when developing the screens for the web-based design

- Developed a standardized Error message Function for the web portion of the project using JavaScript.

Programmer Jan 2000 to July 2000

Solutions Now, Inc (Cleveland, Ohio)

Industry- Insurance

Project: Develop, design and maintain programs for Self Funded Insurance Company

Platforms: Windows 95 and 98

Languages: PowerBuilder 6.5 & 7.0, SQL

Database Tools: SQL Anywhere 5.0, and Oracle 7.2, TOAD

Responsibilities included:

- Design and Develop programs based on client requirements

- Maintain and debug existing programs

- Consult with the client to obtain user requirements for programs to be developed

- Peer review other developer’s code

- Develop the programs using PowerBuilder Foundation Class (PFC)

Programming Intern Aug 1999 to Dec 1999

SmithKline Beecham:

Industry- Medical/Manufacturing

Platforms: Windows 95 and 98

Languages: PowerBuilder 6.0, SQL, Visual Basic, Mainframe Cobol, and JCL

Database Tools: Oracle 7.2 and Microsoft Access

Responsibilities included:

- Documentation of existing Cobol Script

- Create a database in Microsoft Access and import existing data to be used for testing

- Development of a program that will delete records from the database based on the age and type of record. This program would run in a batch process.

- Develop a reports program using Powerbuilder 6.0

- Maintaining, testing and debugging existing code

Resident Assistant Jan 1999 to May 1999

Robert Morris College (Coraopolis, PA)

Responsibilities included:

- Supervising events in the residence hall

- Handling any disputes among residents

- Help students adjust to college life

- Provide a safe and secure residence

Peer Tutor Sept 1998 to Dec 1999

Robert Morris College (Coraopolis, PA)

Responsibilities included:

- Teaching students to understand the concepts of their courses and how to apply those concepts

- Courses tutored: Cobol Programming, Database Management (SQL and Access), Financial Accounting, Algebra, and Statistics

Retail Manager Nov 1990 to Mar 1992

Jeans West Men’s Store (Pittsburgh, PA)

Responsibilities included:

- Set employee schedules

- Standard paperwork: bank deposits, sales tracking, inventory tracking, and payroll

- Opening and closing of store.

- Loss prevention

- Store front window designs.

- Customer service

Contact this candidate