September 9, 2004 at 6:54 am
Wanted: SQL Server 2000 performance expert in the NYC area for a consulting position to perform a review of a Wall Street bond trading system. This system has been in production for a few years and is very database intensive. As the database has grown, performance has deteriorated. We are looking for someone to perform the following functions as a consultant:
1) Analyze the database design
2) Analyze the worst performing code (stored procs, UDFs, triggers, etc)
3) Analyze the indexes used
4) Suggest the "biggest-bang-for-the-buck" changes that will improve performance
The position would require the consultant to work onsite. After initial analysis, the consultant would be assigned someone to work closely with them and answer their questions.
We consider ourselves very SQL-savvy, but are to the point where we need a fresh opinion.
Only experts with performance-tuning experience need apply. If you are interested, please reply to this posting.
September 10, 2004 at 12:28 pm
suggestion: given the high cost of such specialists' time you ought to have your documentation in order prior to their arrival... I just happen to know a rather talented fellow who could document your business rules, SQL/SPs, user-defined data types, data structures, et al.
My resume in enclosed...
Howard Z. Wertenteil
212-982-0384 / howard_nyc@yahoo.com
SUMMARY
As an IT professional, I have more than 15 years diversified experience in business application development, reverse engineering of legacy applications, documenting systems, writing user guides, assembling business plans, drafting policies, drafting standard operating procedures, etc. Clients have ranged from Prudential Insurance to JPMorgan Chase to smaller, less structured organizations.
SKILLS
Windows XP, ASP.NET (Beta), Visual Basic (VB.NET, VBA, VB5, VB6), HTML (1.0, 2.0, 3.0, 4.0), C/C++, Java (EJB, J++), MS-SQL Server (6.5, 7.0), MS-Office (95, 97, 2000, XP), MS-Excel, MS-Word, MS-PowerPoint, MS-Outlook, MS-Explorer, MS-Internet Assistant, MS-Project, Internet Explorer (5.0, 5.5, 6.0), Netscape Navigator (5), MS-Visio (95, 2000), MS-Access, Mercury WinRunner, Mercury QuickTest Pro, Oracle, PowerBuilder, DocToHelp, Crystal Reports, RoboHelp (8.5, 9.0, 2000), RoboInfo (2000, 3, XP), ForeHelp, Lotus 1-2-3, Quattro Pro, Word Perfect, Folio, Adobe, Lotus Notes, NetViz, and Remedy ARS.
EXPERIENCE
APR 2004 -- MAY 2004
Forest City Ratner Companies, Brooklyn, NY
Project Manager / Procedures Writer
Real Estate Management & Development. Four week project to draft replacement for Disaster Recovery Plan (DRP).
** Drafted compliance matrix with Sarbanes-Oxley Act sections 302 and 404.
** Drafted project plan. Detailed approximately 600 tasks to be performed over a period of nine months.
** Drafted statement of work. Specified resources need and deliverables to be completed. Mapped to high level business goals.
** Drafted outline (table of contents) for replacement DRP. Transferred existing content into replacement.
** Assembled list of tasks for subject matter experts (SME) to document existing IT infrastructure.
** Coordinated handoff to staff member.
Environment: Word 2002, Visio 2002, Outlook 2002, Project 2002, Windows 2003 Server, Microsoft Active Directory, etc.
OCT 2003 -- APR 2004
New York, NY
Business Plan Writer / Content Writer
Consulting firm(s). Assisted a number of speculative startup firms in developing their business plans and financial modeling. Including:
** Art gallery -- discussion/design of web site to display high-end art and sculpture.
** Freelance articles -- written for various publications. Topics included: focus upon corporate preparedness for audits; etc.
Environment: Word 2000, Visio 2000, Outlook 2000, Access 2000, Project 98, ASP.NET, Internet Explorer, etc.
SEP 2002 -- SEP 2003
Sesame Workshop, New York, NY
Project Manager / Procedures Writer
Television production ("Sesame Street™", etc.). Project management and documentation of infrastructure migration from WIN 98 to WIN XP (and Office 97 to Office XP) of 400+ workstations.
** Assisted departmental director in setting up Project Management Office (PMO) with SW-CMM. Almost completely paperless.
** Analyzed and documented business processes. Established procedures for streamlining responses by helpdesk.
** Clarified and documented standard operating procedures (SOP) for helpdesk and network support team during migration.
** Documented evolving infrastructure during migration. Wrote technical procedures for assemblage of workstation configurations.
** Wrote test plan for stress testing of builds of workstation configurations to evaluate impact upon 35 line-of-business applications. Wrote many of the specific test cases.
** Reformatted documentation to web edition. Established style manual and content guidelines. Installed and supported eHelp's RoboInfo. Wrote detailed policy manual.
** Managed training sub-project (400+ users ranging from administrative staff to executives), including: vendor selection, RFI/RFP/RFQ document cycle, auditions, focus groups and scheduling of training.
** Provided Tier II and III support for power users of Office 97 and Office XP.
** Documentation exceeded 1100 pages. All materials 'audit-ready'.
Environment: NetWare 6, MS Windows 2000 Server, MS Windows XP, MS Office XP, Visio 2002, Outlook 2002, Project 2000, Internet Explorer 6, RoboInfo, Remedy ARS, Mercury QuickTest Pro, etc.
AUG 2001 -- SEP 2002 (note: no activity during SEP 2001 -- NOV 2001)
New York, NY
Business Plan Writer / Content Writer
Consulting firm(s). Assisted a number of speculative startup firms in developing their business plans and financial modeling.
Including:
** Promotion/marketing unit -- discussion/design of web site to assemble specific demographic population subset (i.e., "Bridge-n-Tunnel", "DINC", etc.) that would match a client's targeted audience to invite to social gatherings, etc.
** Speaker bookings -- design of database tool to manage and support the booking of speakers/lectures/workshops/etc. Researched and assembled tentative listing of experts on various subjects for partnership/owners.
** Freelance articles -- written for various publications. Topics included: focus upon "911" recovery efforts; corporate preparedness against future events; neighborhood reactions; making the most of 'down time'; etc.
Environment: Word 2000, Visio 2000, Outlook 2000, Access 2000, Project 98, ASP.NET, Internet Explorer, etc.
FEB 2001 -- JUL 2001
Pfizer, Inc, Brooklyn, NY
Business Analyst / QA / User Documentation
Pharmaceutical. AMS ("Application Management System") implemented automation of paper-based workflow. Thin client application developed expressly for MS Internet Explorer 5.5, with users distributed across the United States (1000+ users at 50+ sites).
** Application developed in compliance with FDA regulations& guidance. Including: 21 CFR 11, xGMP, GLP, GCP, IQ/OQ/PQ, etc.
** Web based applications ("thin client") designed to support usage in multiple time zones / sites / work environments / etc.
** Validation protocols of new applications. Includes: software, hardware, and related (human) workflows. Compliance with corporate goals and FDA regulations.
** Wrote test plans. Ran testing. Reported errors and oversights to developers, revised testing as application matured.
** Advised project team members about revisions to validation requirements based on best practices, regulatory directives, application development standards, CMM, GUI standards, etc. Consideration for advancing to next level of "maturity model".
** Contributed Visual Basic functions to validate various specialized data sets (i.e., area codes, etc.).
** Revised functional requirements and related documents. Participated in full SDLC ("Software Development Life Cycle").
** Evaluated quality of interface/workflow. Wrote (and developed) standards and procedures. Including: GUI standards, reviewed application's interface, critiqued compliance with standards, etc.
** Wrote training materials and coordinated syllabus with in-house trainers. Performed end-user training.
** Wrote site-specific implementation procedure.
** Wrote on-line help for application.
** Wrote ad-hoc Access/VB/VBA applications to: construct test plans, assembled complex Word documents, analyzed data, etc.
** Heavy use of MS-Word macros and associated VBA coding.
Environment: ASP / VB.NET / ASP.NET, Internet Explorer 5.5, Word 2000, Visio 2000, Outlook 2000, Access 2000, RoboHelp 2000, SQL Server 7.0, Visual Basic 6.0, Visual Developer, Crystal Reports, etc.
SEP 2000 -- DEC 2000
Chase New York Bank (AKA: JPMorgan Chase), New York, NY
Analyst/Writer/QA
Large Bank/Brokerage. Documented telecommunications infrastructure for eleven floors of new offices for Chase's ETech™ Division. The data network included: 1000+ workstations, 61 Cisco switches and routers, patch panels, etc.
Materials assembled included:
** Complete mapping from corporate WAN through panels and switches to individual workstations.
** (QA) Diagrams provided for corporate helpdesk and disaster recovery planning.
** (QA) Reported inconsistencies and oversights to other members of the team.
** Configuration specifics of routers/switches/backbone documented.
** Wrote ad-hoc VBA/SQL applications to: assemble complex Word documents, analyze data, etc.
** Prepared materials for web-based deployment ("e-publishing").
Environment: Internet Explorer 5.5, Netscape Navigator 5, Excel 97, Word 97/2000, Visio 2000, Project 98, NetViz, Lotus Notes, Access 97, various Cisco utilities, etc.
JUN 1999 -- JUN 2000
FreshTalent, Inc., New York, NY
Business Plan Writer
Consulting firm. Assisted a number of startup firms (i.e., "dot-com wannabes") in developing their business plans, presentation skills, and financial modeling.
Including:
** Employment web site -- focused upon Wall Street professionals and support staff. Edited business plan, researched competition and compared strengths and weaknesses.
** Commodities investments company -- trading of commodities/futures. Edited business plan, taught presentation skills. Designed prototype application suite, including: screens (entry/edit/trade), regulatory reporting, performance evaluation of investments, portfolio tracking, etc.
** Book reseller web site -- focused upon secondary market of remnants and minor authors. Edited business plan.
** Paperless office web site -- focused on liberating white-collar professionals from paperwork and related delays. Edited business plan, researched competition and compared strengths and weaknesses, assembled list of potential investors.
Environment: Internet Explorer, Word 97, Visio, Outlook 98, RoboHelp, Oracle 9, SQL Server 6.5, Visual Basic 5.0, PowerBuilder, etc.
FEB 1999 -- JUL 1999
Marsh & McLennan, New York, NY
Workflow Analyst / Technical Writer
Insurance/re-insurance. Payroll Department for Fortune 500 company, processing complex payroll needs for 28,000+ employees. Departmental planning for migration to PeopleSoft (scheduled for 1Q2001) included need for detailing current work process.
Work performed including:
** Documented workflows to create a departmental level Standard Operation Procedures manual.
** Worked with team of Deloitte & Touche consultants; coordinated and discussed efforts.
** Interviewed staff of twenty payroll administrators and tax accountants.
** Wrote ad-hoc VB/VBA applications to: assemble complex Word documents, analyze data, etc.
** Completed draft covered seventy-five workflows. Additional materials included: departmental glossary, interdepartmental workflows, etc.
** Documents exceeded 900 pages.
** Materials prepared for web deployment.
Environment: Excel, Word, Visio, Lawson, PeopleSoft, Crystal Reports, PowerBuilder, etc.
APR 1998 -- SEP 1998
New York City Transit Authority, New York, NY
Business Analyst / Specifications Writer
State agency. Division of MTA managing the buses and subways of New York City. As a member of team of 35, which was mandated to design & implement replacement for personnel management application to process the activities of 35,000 employees.
Work performed including:
** Modules: payroll, scheduling, crewing, management, etc.
** Assigned as analyst of "Timekeeping" module responsible for payroll processing, sick leave, absence-from-work, generating weekly timekeeping information formatted for transmission to mainframe applications.
** Interviewed and assembled documentation for workflow which hitherto had been oral tradition.
** Functional specifications generated exceeded 600 pages.
** Included screen and report layouts, data structure specifications.
** Wrote ad-hoc VB/VBA applications to: construct test plans, assemble complex Word documents, analyze data, etc.
** Contributed to test plan design and assembly of test data sets.
** Materials prepared for web deployment.
Environment: Excel, Word, Visio, Client/Server development, Oracle 8.0, Oracle Forms, PowerBuilder, etc.
SEP 1997 -- APR 1998
Prudential Insurance, Roseland, NJ
Business Analyst / Specifications Writer
Insurance provider. Member of large team that designed and implemented application to offer 24X7 access to insurance policy information (on mainframe platforms) via robust IVR.
** Assignment focused upon specific components and workflows, goals oriented towards producing detailed functional specifications.
** Interviewed subject experts.
** Located existing documentation (and any related materials). Performed cross-reference and fact checking.
** Authoring detailed, accurate specifications revising due to changes in direction; assisting others; etc.
** Materials prepared for web deployment.
** Wrote ad-hoc VB/VBA applications to: construct test plans, assemble complex Word documents, analyze data, etc.
Environment: Excel, Word, Visio, Visual Basic 5.0, Lotus Notes, various propriety mainframe applications, etc.
JAN 1990 -- JUL 1997
…various clients
BRAB
Champagne Productions
Chase New York
Computoll
Drexel
GCI
General Vision Services
Klein & Heisler
Merrill Lynch
MKI
NasTel Technologies
NYNEX
Rodman & Renshaw
TDR
Tel-Advantage
TPA
Wilson, et al
Z+R
END OF RESUME (UPDATED: 13-MAY-04)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply