Sr QA Analyst
Resume:
David Glassberg 212-***-****
*** ***** ****** ***, *** York, NY 10002 *****.*********@***.***
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