Developer Project Manager
Resume:
*nd Noah Meyer, MCTS
SQL Server Developer/Excel & Access Guru/Reporting Analyst
Location
Greater Denver Area
Industry
Information Technology and Services
Overview
Current
Business Intelligence Developer at Strategic Computing
Past
Access & Excel Developer/Application Support/Project Manager (Contract) at Charles Schwab
SQL Server Database Developer/Excel & Access Developer/Reporting Analyst at Assurant
Excel & Access Developer (Contract) at Bank of America
Senior RAD Developer (Contract) at JPMorgan Chase
DB2 Database Developer/MS Office Automation Engineer/Business Objects Report Writer
(Contract) at Goldman Sachs
Developer (Contract) at Bank of America
Developer/Project Leader (Contract) at Morgan Stanley
see less
see all
Education
Netcom Information Technology
New York University
The University of British Columbia
Recommendations
4 people have recommended Noah
Connections
500+ connections
Websites
Company Website
Public Profile
http://www.linkedin.com/in/noahmeyer
Flag
Contact Noah for:
*******@*****.*** 347-***-****
career opportunities
consulting offers
new ventures
reference requests
getting back in touch
Send a message to Noah Meyer, MCTS
Get introduced through a connection
0 of your trusted connections can introduce you to this person.
Send InMail
Summary
Microsoft Certified SQL Server developer with 15 years experience working for top-tier
clients in the Financial industry and elsewhere. I have a proven track record for the
rapid development, deployment and support of end-to-end reporting and workflow management
solutions.
Specialties
SQL Server 2008 developer, SSIS 2008, SSAS 2008, SSRS 2008, Excel VBA, Access VBA,
Sybase, DB2 (UDB).
Skills & Expertise
Excel
VBA
Access
SQL Server 2008
VBScript
DB2/SQL
Sybase ASE
Crystal Reports
Business Objects
ASP
HTML
SSIS
InfoPath
DB2
ADO
DAO
OLEDB
PowerPoint
Teradata
WSH
Powershell
Win32
Business Analysis
Business Intelligence
Bloomberg Terminal
Software Project Management
User Acceptance Testing
T-SQL
Microsoft SQL Server
SSRS
ETL
OLAP
Data Warehousing
Database Design
SSAS
PerformancePoint
View All (36) Skills View Fewer SkillsExperience
Business Intelligence Developer
Strategic Computing
Privately Held; 11-50 employees; Information Technology and Services industry
January 2012 Present (5 months)
Developing data warehouse/business intelligence reporting platforms using Microsoft's BI
stack (SSIS/SSAS/SSRS) and integrating solutions into Microsoft SharePoint 2010.
Access & Excel Developer/Application Support/Project Manager (Contract)
Charles Schwab
Public Company; 10,001+ employees; SCHW; Financial Services industry
May 2011December 2011 (8 months) Greater Denver Area
Worked with developers, project managers, business analysts and users throughout
Operations to coordinate the migration of Excel, Access and Extra! Attachmate macros to a
central repository administered and supported by the Operations Technology Services group.
Rewrote code for dozens of user-developed macros to comply with the OTS group's VBA
coding standards.
Coordinated with over 80 departmental contacts to identify macros that needed to be
added to the central repository, arranged user acceptability testing, and deployed
rewritten macros to production.
Using a combination of Excel VBA, Access VBA, T-SQL on SQL Server, and Win32 API calls -
automatically rotated code passwords for Excel and Access macros that are supported by the
OTS department.
Saved OTS department dozens of hours of manual labor and ensured departmental
compliance with firm-wide information security policies.
Supported entire suite of OTS developed applications (macros, C#, VB.Net, ASP.Net, SQL
Server databases with SQL agent jobs and SSIS packages) while entire department was at an
offsite meeting.
Diagnosed and fixed numerous application errors caused by the inability of related SSIS
packages to load data into SQL Server.
Debugged and identified code errors in a C# ASP.Net application.
SQL Server Database Developer/Excel & Access Developer/Reporting Analyst
Assurant
Public Company; 10,001+ employees; AIZ; Insurance industry
January 2010 May 2011 (1 year 5 months) Greater New York City Area
Worked closely with senior managers / users to automate reporting and develop workflow
management tools to assist senior management, credit analysts, and traders manage $28B
investment portfolio.
Automated / reengineered daily positions report replacing previous labor intensive,
error-prone legacy approach.
Eliminated 2 hours previously required to run reports.
Ensured report availability at start of business, vs. previous late morning delivery,
providing critical decision making information to traders / credit analysts.
Utilized WSH scripts, Excel VBA, Access VBA, and Access queries to reengineer Creditor
Reporting System to include overnight updating of Excel spreadsheets with relevant data
from PAM and Bloomberg.
Enabled users to rapidly update individual creditor reports utilizing Excel
spreadsheets.
Integrated external / internal data source including PAM, YieldBook, and Bloomberg into
SQL Server database enabling users to easily view portfolio management reports via user-
friendly interfaces including Excel pivot tables and MS Access forms.
Utilized Windows Scripting Host (WSH) and stored procedures to automate daily
preparation, transformation, and loading of data feeds into SQL Server Database.
Excel & Access Developer (Contract
)
Bank of America
Public Company; 10,001+ employees; BAC; Banking industry
2009 2009 (less than a year) Greater New York City Area
Developed automated solutions in SharePoint, Access and Excel to help the Global Credit
Products Technology group track IT project expenses.
Senior RAD Developer (Contract
)
JPMorgan Chase
Public Company; 10,001+ employees; JPM; Financial Services industry
2008 2009 (1 year) Greater New York City Area
Worked closely with Hedge Fund, Mutual Fund Risk Management, IT to define business needs
and translate requirements into application enhancements. Rapidly addressed production
issues.
Designed, developed, implemented, and supported enhancements. Coordinated UAT testing /
production deployments to users in New York, London, and Bangalore (India). Supported 12+
desktop applications within Global Credit Risk Management.
Ensured full applications functionality during migration from Office 2003 to Office
2007 by testing Access 2003 applications in Access 2007 to determine compatibility issues
and re-write of VBA code as required.
Coordinated migration of Access database application from NY-based Citrix server to
Bangalore-based LAN, significantly reducing time required to run reports.
Documented complex logic to trigger credit risk escalation reports supporting external
development team business analysts in build of strategic reporting system for address
Hedge Fund and Mutual Fund credit risks.
Debugged / fixed Visual Basic 6 application utilized to launch critical risk management
application.
Trained teammates to programmatically customize Access 2007 user interface utilizing
combination of VBA macros and MS Office Ribbon XML schema.
Noah has 1 recommendation (1 co-worker) including:
3rd Josemon J., Vice President, JPMorganChase
DB2 Database Developer/MS Office Automation Engineer/Business Objects Report Writer
(Contract)
Goldman Sachs
Public Company; 10,001+ employees; GS; Investment Banking industry
20052008 (3 years) Greater New York City Area
Worked within the Derivatives operations department to rapidly develop tactical
applications and automate daily report generation via Business Objects / Excel VBA.
Created daily / ad-hoc reports to track risk metrics including confirmation states and
DTCC eligibility for CD and IRP operation teams. Developed macros within Access tool to
retrieve data from DB2 database. Utilized Excel, Access, Word, and Outlook objects models
to develop, debug, support, streamline, and reengineer multiple VBA applications. Queried
internal databases using ADO and DAO. Scraped data from web pages. Generated trade
confirmation documents. Utilized Outlook to automatically email pre-confirmations and
interest shortfall notices to counterparties.
Rapidly (3 month from concept to production) built trade confirmation and settlement
workflow tool with real-time market data feeds for Credit Derivatives and Interest Rate
Product operations teams.
Deployed, trained, supported, and coordinated UAT testing for 500+ users in New York,
London, Tokyo, and Bangalore through multiple UAT / production versions.
Partnered with Operations, IT, and Trading Strategists to program trade confirmation
documents for Bespoke, Nth to Default and Loan CDS type trades utilizing internal document
generation system
Enabled straight-through processing of highly complex, derivative trades.
Automated generation / distribution of risk metrics reports for senior derivative
operations managers using Business Objects Web Intelligence, Desktop Intelligence, Excel
VBA, and WSH scripts written with VBScript.
Eliminated countless man-hours / delays in critical business reporting.
Rapidly built trade confirmation document generation system using Access 2003, Word
2003, Outlook 2003, and text data feeds from GS internal trade confirmations database.
Enabled trading of Mortgage CDS / Mortgage Index products months previous to IT
standard trade confirmation system was deployed to address those trades.
Noah has 1 recommendation (1 co-worker) including:
3rd Menashe S., VP, Goldman Sachs & Co.
Developer (Contract)
Bank of America
Public Company; 10,001+ employees; BAC; Banking industry
2004 2004 (less than a year) Greater New York City Area
Developer/Project Leader (Contract)
Morgan Stanley
Public Company; 10,001+ employees; ms; Financial Services industry
1998 2002 (4 years) Greater New York City Area
Enhanced / supported existing Excel-based P&L reporting system. Utilized Crystal Reports
Designer to develop report templates for Daily P&L application. Coordinated testing with
external application groups dependent on legacy system.
Developed web-based P&L reporting system to generate web-accessible reports in Adobe
PDF and XLS formats.
Built Excel add-in to upload data from disparate controller groups to Sybase database.
Created Visual Basic 6 DLL to validate Excel data prior to upload to Sybase.
Developed web-based trading system for Global High Yield credits.
Built components for Visual Basic 6 web portal application with MS SQL 7 back-end.
Created Excel / Access front-end application with Sybase back end to replace Excel-
based Net Carry system.
Led / trained team of 3 VBA developers in conversion of 500+ Lotus 1-2-3 files to Excel
and rewriting of Lotus macros to VBA.
Built file conversion utilities using Lotus 1-2-3 macros and Excel VBA.
Noah has 2 recommendations (1 co-worker, 1 client) including:
3rd Al R., Senior Software Developer, Morgan Stanley Dean Witter
2nd Ken McAndrew
Certifications
Microsoft Certified Technical Specialist - SQL Server 2008, Database Development
Microsoft
License 3623109
February 2011
Education
Netcom Information Technology
Advanced SharePoint Development
2009 2009
New York University
VB.Net
2008 2008
Non-credit continuing education course.
The University of British Columbia
Bachelor of Commerce, Finance
19931995Recommendations For NoahSenior RAD Developer (Contract
)
JPMorgan Chase
Noah's excellent technical skills in Excel/ACCESS VBA, SQL, RDBMS has been an asset to
our team. He has efficiently supported our global user base. He is an excellent team
player. April 8, 2011
3rd Josemon J., Vice President, JPMorganChase
worked directly with Noah at JPMorgan Chase
DB2 Database Developer/MS Office Automation Engineer/Business Objects Report Writer
(Contract)
Goldman Sachs
Noah is a tremendous doer. He is focused, determined and willing to overcome any
challenge. Noah was always willing to share his knowledge with others and keep everyone in
the loop.
Noah is tremendous technical expert and as a programmer can design just about anything.
June 11, 2011
3rd Menashe S., VP, Goldman Sachs & Co.
worked with Noah at Goldman Sachs
Developer/Project Leader (Contract)
Morgan Stanley
Whenever our team faced a challenge, Noah was our ace in the hole. His determiniation,
ability to adapt and overcome any technical obstacle earned him the respect of the entire
team. January 28, 2012
3rd Al R.,
Senior Software Developer, Morgan Stanley Dean Witter
worked directly with Noah at Morgan Stanley
I hired Noah at Morgan Stanley to do remediation work for us, but quickly noticed that
he was an expert level developer, experienced and diligent, whose breadth of talent could
add significant value to a team faced with complex requirements. He has the intellect,
training and experience to solve any problem with professionalism and superlative results.
A creative and personable individual, Noah displays integrity, discretion and a consistent
ability to deliver on schedule. I'm more than happy to endorse and recommend Noah.
September 30, 2011
Top qualities: Great Results, Personable, Expert
2nd Ken McAndrew
hired Noah as a IT Consultant in 1998
Additional Information
Websites:
Company Website
Groups and Associations:
.NET Developers Join
.NET People Join
.Net Professionals Join
5280 Linked Join
ASP.NET,C#/VB.NET Developer/Programmer Join
Access and VBA Join
BI Developer Network (BIDN.com) Join
Black Belt POWER Networkers Join
Boulder Denver New Tech (BDNT) Join
Business Intelligence Professionals Join
C# Developers / Architects Join
Colorado IT Community Join
Colorado SharePoint User Group Join
Colorado Technology Association Community Join
Database Experts Join
Denver .Net Study Group Join
Denver Consulting Jobs Join
Denver Engineering & IT Professionals Join
Denver IT Jobs Join
Denver SQL Server User Group Join
Denver Tech Jobs Join
Denver Visual Studio User Group Join
DenverTechConnect Join
Developer & Technology Professionals Already a member
Excel Blackbelts Join
Excel Developers Join
Learning SharePoint Join
Link'd In LIVE Colorado Join
Linked To Denver Join
MS Access Development Professionals Join
Microsoft Business Intelligence Join
Microsoft Certified Professional Network Join
Microsoft Developers Join
Microsoft Excel Users Join
Microsoft SQL Server Join
Microsoft SQL Server Developers group Join
PartnerPoint - An Online Community of Microsoft Partners Join
Professional Microsoft Access Developers' Network (PMADN) Join
Rocky Mountain Internet Users Group Join
Rocky Mountain Technology and Telecom Forum Join
SQL Jobs Join
SQL Professionals & Wizards. Join
SQL Server 2008 Join
SQL Server Developers Join
Sauder Bachelor of Commerce Alumni Join
SetFocus Free SharePoint Training Join
SetFocus Free Training Join
SharePoint Users Group Join
SharePoint in the Cloud Join
Visual Basic for Applications Experts Join
Events
Reading List by Amazon
E-Bookshelf
Blog Link
Connect
Ask Noah For More Info
Thanks for requesting a profile update.
Send InMail
Get introduced through a connection
Search for references
Learn More Save Noah's Profile
Advertisement
Network Information
How you re connected to Noah
You
Michael Sheehan
Earl D Shaffer
Khafila Abiola
Barry Klasson
Mike Dolan
... and 1 other
Juliana Mercurio
show fewer names
2nd Noah Meyer, MCTS
Groups you share with Noah:
Developer & Technology Professionals
Note: Groups shared with the viewer are shown here. Other groups, if visible, are shown
under Additional Information .
Viewers of this profile also viewed...
Matthew Nelson
SQL Developer at Bridgepoint Education
Michelle Cragoe
Technical Recruiter at Access Data...
Brooke Schwerdt
Senior Project Manager / Certified...
Tim Zepin
SQL Server DBA - Development and...
Brandi Hager, MCT, MCP, MCTS, MCITP
Senior SharePoint Engineer and...
Levi Martin
Senior Business Analyst, Senior SQL DBA...
Ray Martinez
SQL Developer, SQL BI Developer
Stan Rasor
BI Software Developer at Denver Public...
Joseph Bocchieriyan
BI Developer at Comcast
Brian Bond
Experienced Business Intelligence...
Contact this candidate