Steven Lerner

***** ****** **. ********, ** *****

Phone: 323-***-****, Cell: 213-***-****

E-mail: acuj7o@r.postjobfree.com

Qualifications:

System and Data Process Analysis, Business Analysis (Scrum/Agile), developing and designing functional prototypes, GUI, full scale applications. Architect, design and create databases, software implementation, user training and support.

Languages: SQL, Crystal Reports, Visual Basic, ADO, DAO.

Strong Analyst, Team Player, Detail Oriented, Result Oriented, Self-Motivated

Experience:

TelePacific Communications Los Angeles, CA

Project Manager /Senior Software Engineer 2/2004 – 8/2015

Full Life-Cycle Development (SDLC) Commissionable Entity Sales Commission System (CESC) including:

Business Analysis

BRD and UFR (User’s Functional Requirements) documentation

SQL Database Architect, Design and Development (including tables, triggers, stored procedures, functions, views etc.)

Process Flow and Data Flow

Design and development fully functioning GUI prototypes

Design, development and testing multifunctional, user-friendly and very intuitive user interfaces in a “multi-document environment” (MDI)

Data analysis including data modeling, interpretation, transformation etc.

Data nesting and validation

Design, development and implementation flexible reporting tools

Design, development and implementation thousands reports including

oInformative

oStatistical

oAnalytical

oCombined

Exporting reports into PDF, MS Excel, CSV and MS Word formants as stand-alone files or email attachments

System deployment and implementation

User’s training

System maintenance and upgrades

Users support

Using:

SQL 2005/2008/2008 R2,

Crystal Reports 10.0,

MS VB 6,

MS Excel 2010,

MS Word 2010

Outlook 2010

MS Visio 2010,

MS Project 2010,

ADO,

Adobe Photoshop 7,

Adobe Reader,

Icon Workshop,

Install Shield 11.

Managing group of up to 7 front-end and back-end developers.

Successfully designed, developed and delivered single platform Commissionable Entities Sales Commission System (CESC) including:

Employee commission

Wholesale commission

Vendor Referral commission

Agency Commission

Created hundreds reports, commission statements, management analytical tools for Finance, Sales and Marketing departments.

Documentation, User Manuals, end-user support, solving problems.

Awarded by “Excellence Plus 1 Achievement Award” in 2005

Awarded by “Excellence Plus 1 Best Achievement Award On-Spot” in 2006

Awarded by “Excellence Plus 1 Best Achievement Award On-Spot” in 2008

Awarded by “Employee of the Quarter” in 2009

Countrywide Home Loans Calabasas, CA

Short term contract: Business / data modeling analyst 05/2003-07/2003

WorldVision Monrovia, CA

VB-Crystal Report Developer, short term contract 01/2003-03/2003

ING Financial Network Harbor City,CA

Crystal Report developer 10/2002-01/2003

LA County, Office of the Assessor Los Angeles, CA

Programmer/Analyst 5/2000 – 4/2002

Toyota Motor Sales USA Torrance, CA

Programmer/Analyst 7/1999 – 2/2000

Mission Critical Technologies Beverly Hills, CA

Programmer/Analyst 2/1999 – 7/1999

Education: Advanced Education Center Northridge, CA

Visual Basic 5, 6 Advanced course 5/1998 – 10/1998

Certificate

Bramson Ort Technical Institute New York, NY

Computer operating Systems, computer applications 3/1993 – 2/1995

Diploma

State Polytechnic University Odessa, Ukraine

Mechanical Engineering 1976 – 1981

MS - Technology of Machine Building

Reference: Available upon request.

Contact this candidate