Resume

Sign in

Sr QA Analyst

Location:
New York, New York, 10002, United States
Salary:
$40 hr on W2
Posted:
March 29, 2011

Contact this candidate

David Glassberg 212-***-****

*** ***** ****** ***, *** York, NY 10002 on1s2a@r.postjobfree.com

Summary of Experience

• Innovative Programmer/Analyst with over 15 years of experience.

• Experience in design, development, coding and testing of business/commercial applications using various Microsoft technologies.

• Expertise in information management obtained from supporting full life cycle system developments projects including Business Requirement management, Quality Assurance management and process , Project management

• Able to effectively collaborate with multi-functional business users and team members in the design, Development and deployment of systems that manage and support business information and processes.

• Experience with Application and Database Performance Tuning & Administration including software version upgrades, software security patch release testing and functional enhancement.

• Experience with tools such as SQL*Loader and SQL, PL/SQL, Import/Export, Stored Procedures/ Packages/Functions, Views, DB Triggers, SQL navigator tool and PL/SQL.

• Used modeling & diagramming tools such as Erwin, ERStudio and Visio along with other Microsoft tools such as MS Word, Excel, Power Point.

• Familiar with custom development SQL, Access and VBA.

• Experience on Data Analysis, Data Modeling, Logical and Physical data structures.

• Effective in data management/application development to streamline the data transmission among the systems to ensure the data integrity/quality.

• Broad experienced with System Development Life Cycle (SDLC) methodologies and Technical System Design Documentations.

• Experience with systems release management, production publication procedures, and production support.

• Work and Develop plans involving Testing, Troubleshooting and Debugging, working with changing specifications to meet deadlines and application requirements.

• Expert ability in eliciting, documenting and evaluating business requirements use cases and models that clearly depict process flows relating to Business Requirements Document (BRD).

• Experience in writing functional requirement specifications, System requirement specifications using Object Oriented (OO) Methodologies based on user requirements.

• Exposure to formal software development and project management Methodologies. Ensure sign-off of all artifacts.

• Strong skills in user research and analysis of the existing systems, Working knowledge of the technical environment (technologies, applications, projects, processes) presents in the functional business area, and business systems strategic roadmaps.

• Directed the long range planning activities, performed Cost-benefit analysis, provided overall technical direction along with business impacts; defined and reinforced departmental, corporate and compliance standards.

• Work with business and application team and devise work breakdown structure.

• Lead and mentored project team on best practices in development, testing and QA.

• Ability to work independently or as part of a team on assigned tasks.

Education

BROOKLYN COLLEGE, Brooklyn, NY

B.S. Computer Science, received Magna Cum Laude 1990

BARUCH COLLEGE, New York, NY

MS SQL Server 2000 DBA Certificate, Introduction and Advanced HTML 2003, MS Access Course and Training.

Technical Skill and Years of Experience

Skill Years Skill Years

Visual Basic 18 Access (97, 2000, 2003, 2007) 15

C 15 Excel 15

C++ 10 VBA 15

SQL Server (2000, 2005) 10 HTML 10

Sybase 10 ASP 05

Professional Experience

LAURAND ASSOCIATES, Great Neck NY Part Time February 2008 - August 2008

Programmer/Analyst

Achievements: Access Database Access 2003 VBA DB used to store and process data for parts supplier.

Responsibilities: Tables, data normalization, queries, forms, reports, all code. Complete project lifecycle. Performed Unit testing, integration testing and code review, closing the issues raised by Quality testing Team

HNTB, New York, NY Consultant August 2007 – February 2008

Programmer/Analyst

Achievements: Access Database Access 2003 VBA DB used to compare data for competing companies seeking NYS DOT contracts.

Responsibilities: Involved in Technical Analysis of the proposed System including architecture design and technical specification.

PB- URS, New York, NY Consultant May 2007

Programmer/Analyst

Achievements: Access Database Access 2003 VBA DB used to track the construction projects for the new WTC and Transit Hub construction.

Responsibilities: Implementing application in OOD and Design patterns. Tables, data normalization, queries, forms, reports, all code. Complete project lifecycle.

SCHOOL LINK, New York, NY Consultant April 2007

Programmer/Analyst

Achievements: School Link Database Access 2003 VBA DB used to track the lunch systems used in NYC schools.

Responsibilities: Co-ordinate with the QA lead for development of test plan, test cases, test code and actual testing, responsible for defects allocation and ensuring that the defects are resolved.

SUBSTITUTE TEACHER, NYC schools, New York, NY September 2006 to 2007

Substitute Teacher

Achievements: Substitute Teacher for Math, Science, English classes

CLIFFORD CHANCE US LLP, New York, NY April 2006 to June 2006

Programmer/Analyst

Achievements: Initial Checks Database Access 2003 DB used to check incoming data for consistency and correctness before loading to Introspect.

Responsibilities: Tables, data normalization, queries, forms, reports, all code. Complete project lifecycle.

KATTEN MUCHIN ROSENMAN LLP, New York, NY October 2004 to November 2005

Programmer/Analyst

Achievements: Firm Name Change Task Across all applications, intranet, etc. Daily New Data Job SQL Server 2000 DB to DB transfer. Update of Invoice Generator app. from Access 2000 to VB6, SQL Server

Responsibilities: SQL Server 2000 Database, triggers, jobs, etc. Firm Intranet HTML, ASP. Daily updates. User Maintenance. Used Visual Source Safe for source code maintenance.

FISH AND NEAVE, New York ,NY June 2003 to September 2003

Litigation Support Developer Analyst

Achievements: TV Guide Access 2000/SQL Server 2000; Full project life-cycle

Responsibilities: Litigation Support, Access DB Updates, SQL Server Tasks

ROYAL BANK OF CANADA, New York, NY February 2003 to June 2003

Programmer/Analyst

Responsibilities: Access 97 DB development, maintenance, updates., Sybase table linka

KATTEN MUCHIN ZAVIS ROSENMAN, New York, NY September 2002 to February 2003

Programmer/Analyst

Achievements: Sign In Sign Out Time management. SQL Server 2000, VB6, KMZR Invoice Generator Access 2000, VBA

Responsibilities: SQL Server 2000 Database tasks, Access 2000 application development, maintenance, updates

MORGAN STANLEY CO., New York, NY June 1998 to June 2002

Programmer/Analyst

Achievements: CS - Optime Time management. Sybase 11, VB6. Conference Room DB Global use. Web Accessible. Access 97.

Responsibilities: Access 97 DB application development, maintenance, updates. Excel 97 application development, maintenance, updates

PHILLIP MORRIS CO., Rye, NY January 1998 to March 1998

Programmer/Analyst

Achievements: Sales Data Application VB5, Excel 97

Responsibilities: Access 97, Excel 97 application development, maintenance, updates

BANKERS TRUST CO., New York, NY September 1995 to April 1997

Programmer/Analyst

Achievements: Best Link/BT World Financial data reporting. VB5, Excel 97. NASI DB Access 97, Oracle DB table links

Responsibilities: Access 97, Excel 97 application development, maintenance, updates

BMG MUSIC, New York, NY October 1994 to September 1995

Programmer

Achievements: BMG Classics DB SQL Server, Excel 97. RCA Daily Sales DB SQL Server, Excel 97

Responsibilities: Access 97, Excel 97 application development, maintenance, updates

FEDERAL RESERVE BANK OF NEW YORK, New York, NY July 1990 to October 1994

Programmer

Achievements: Fedline3 VB 3.0, Visual C++ 1.5. Fedline Incoming Processor Application C. Electronic US Treasury Auction application.

Responsibilities: Access 97 DB application development, maintenance, updates. Excel 97 application development, maintenance, updates



Contact this candidate