Nancy Steele
908-***-**** (H) 908-***-**** (M) **5 N Prospect St, Washington NJ 07882
******.******@*******.*** http://www.linkedin.com/in/nancyasteele
Bank of America Merrill Lynch
Global Research, Global Banking and Markets 03/2010 - 04/2011
COO Publishing - Officer, Publisher III
. Provided monthly management reports to the Macroeconomics business
manager on Research Analyst client contact and publishing productivity to
determine compensation and on publication readership thru url clicks and
email opens by audience to analyze audience consumption (MS Excel 2007
and 2010 with OLAP cube analytics).
. Provided mapping instructions to production maintenance groups and
systems to synchronize the Research Analyst Team hierarchies in two
systems (Compass system to RDW database/RDR system)
. Compiled and executed the instructions for the movement of team mappings,
analysts, templates and historical data.
. Provided ad hoc readership reports for American and European Equities,
GEM and Global Credit, Economics, Rates & Currencies, Global Wealth
Management Equity Strategy and Commodities teams.
. Provided an analysis by email domain to control entitlements for Senior
Management
. User Acceptance Testing of new functionality for Quarterly System
releases
. Analyst Team profile maintenance
Tax Reporting Services, Global Wealth Management 12/2005 - 06/2008
Project Team - Senior Project Analyst
. Business Requirement Specifications for Client Tax Reporting projects:
text download, e-delivery, State reporting, subsidiary transmissions,
entity consolidated statement conversion, 1099 and NRA 1042-S, Trust and
Retirement changes to Mainframe and short form subsystems and W9/W8
annual solicitations.
. Ran recurring conference calls: NRA project lead; test and production MS
Project Plan and system schedule reviews
. Facilitated resolution in test & production for program & data
remediations (Rational Clearquest)
. Tax Season Business Support: remediated target population 1099-OID, Cost
Basis and Gain/Loss calculations of Structured Products, (OID, CPDI and
Equity Units, via data import, population analysis, remediation and
mainframe re-load (lookup and text formulas, subtotals and pivot tables)
(IBM 3270 Mainframe, MS Excel 2003)
. Mainframe Report Distribution tracking and maintenance (2100+ reports);
provided ad hoc text download and requirements design support
Financial Services & Reporting, Reconciliation & Control, Retirement
Services Group 12/2001 - 12/2005
ESOP Share Plans - Resolution Accountant / 401k Resolution Specialist
. Fractional share conversion requirements (Advest merger); Windows XP
conversion intranet application implementation and requirements
. Omnibus Reconciliation Procedures for fractional share, legacy retail and
SOP subaccounting system (Blueprint, MS Access)
. SOP multi-currency fed fund wire reconciliation and related exposure
research and reporting (intranet)
. Plan reconciliation: exposure research, trading and reporting (MLII
mainframe)
Private Client Bookkeeping System (PCBS), Financial Management Services
09/1999 - 12/2001
Client Bookkeeping strategic initiative Requirements, Test and Issues to
migrate flat files (IDE) account processing to DB2
Validation - Team Leader
. Ran daily test issues meetings: Conversion and Engine programs, Desktop
screens and Mainframe and Desktop reports
. Desktop screens, reports, tables and files: validated System Integration
(SIT) and User Acceptance Testing (UAT) results
. Business Continuity Plan - converted from MS Word and expanded in the
LDRPS database
Conversion - Project Analyst
. Requirements: Conversion mapping of Client Data, Positions and Balances;
Account Purge logic (for 178 tables);
Account Maintenance; Bulk Transfer Residual Processing; and Purge
Synchronization issues (IDE to DB2)
. System & User Acceptance Test validations and issues resolution for
Client Data, Position and Balance tables
(SQL SELECT SPUFI, TSO download, MS Excel IF formulas)
Policies & Procedures, Office of General Counsel 08/1996 - 09/1999
Publishing Corporate Policy and Procedure Manuals and Bulletins,
Information Memos and Online documentation for Corporate Risk Management of
Global Wealth Management and Global Banking & Markets, Domestic and
International, Operations and Branch Offices
Production Manager
. Design and Production: Coordinated manual and document projects for hard
copy and online distribution
. Conducted Domestic and International conference calls for risk management
documentation projects
Electronic Publishing Technologies Manager
. Desktop Publishing: maintained bilingual templates for ML Japan
Securities and ML Canada (Adobe Framemaker)
. Maintained InfoMapping template integrity for HTML and Framemaker
conversions (MS Word)
. Flexible Work Arrangements / Telecommuting: coordinated Division pilot of
business users
. Desktop Video Conferencing: implementation; performed setup and
maintenance (Windows NetMeeting)
. MS Outlook training: conducted sessions for Risk Management executives
and other personnel (conference room training)
Staff Assistant / Financial Controller
. Tracked and Analyzed $4 Million multi-costcenter budget on linked
forecasting system; annual budget planning (MS Excel)
. Statistical reports, budget forecasting and tracking: Depreciation,
Supplies, Consulting, Training and Productivity (MS Excel)
. Compiled the CAO's Risk Management Policy and Procedure Quarterly
Highlights on publishing projects (MS Word)
Cash Management Account (CMA) Operations 05/1993 - 07/1996
Information Management - Project Coordinator
. Constructed databases: (1) Information Management MIS Reporting and (2)
Department Automation Projects with an
FTE Cost Savings and Value-Added Analysis, conducted via interviews with
all sections and implemented related projects (MS Excel).
. Maintained CMA Rearchitecture (CMAR) post-implementation Production
Issues Log (MS Access)
. Visa Products Table Setup and Maintenance (DB2): Employee Access
Accounts, Life Management Service and Visa Business Client
. Provided Ad Hoc Reports: Branch Office, Operations and RSG Marketing:
Accounts Receivable, Overdrafts, ATM fees (macro/Excel/CCAT wire)
Monetary Authorizations - Assistant Supervisor
. Supervised eight VRU CSRs processing ACH transfers and exceptions for
emergency margin credit releases on debit cards based on trade or deposit
activity; handled requests from Branch Service Escalation Teams and
Branch Offices to resolve credit limit and EFT transfer inquiries.
Transfer Agency Mutual Fund Operations, Financial Data Services, FPG
04/1992 - 03/1993
Trades Processing - Retirement/Tax Specialist
. Prepared Quarterly IRS tax returns (941 and 1042) for 36 Transamerica
mutual funds
. Resolved Penalties & Interest by creating an ad hoc tracking system
(Lotus)
. Retirement New Accounts: set-up, trading, quality assurance; identified
exchange rounding issue (Vision desktop system)
Mutual Fund Operations, Financial Data Services, Funds Processing Group
10/1990 - 04/1992
ACATs - Senior Processing Specialist / Funds Control - Senior
Reconciliation Specialist
. NSCC Broker-To-Broker Transfers: liaised with external, non-proprietary
mutual fund groups, reconciled incoming portfolios' house account
discrepancies (dividends); processed outgoing portfolio and position
transfers and Letters Of Instruction.
. Reconciliation and Exposure reporting: G/L (trading/suspense/receivable)
account pair-off logic requirements (mainframe)
VISTA BANCORP 08/1986 - 10/1990
Audit & Compliance
Administrative Assistant to the Auditor and Compliance Officer
. Conducted Audits of Financial & Administrative Controls: Home Equity,
DDA, Installment Loans, CD/Savings, Branch and Fraud
. Coordinated post-data conversion branch reviews and Client Data
remediation
. Prepared Audit Reports and Quarterly Audit Highlights for the Board of
Directors (MS Word-DOS).
. Coordinated desktop Compliance Training for Federal Regulations (B, Z and
CC: Consumer Protection, Truth In Lending and Funds Availability)
Recognition
Special Achievement Award (1994) FTS VRU dupes, menu-skipping: Voice
Response Unit transfer duplication analysis, new process and reporting; CMA
Rearchitecture Authorizations Reports requirements; COBOL II Desktop
screens UAT; and EFT/Visa Credit Lines issues
Team Player Award (2000) PCBS Reports SIT Validation: converted mainframe
and new desktop system reports
Spotlight Awards (2) SIT Management Coverage: cycle testing systems liaison
for 800+ weekly email inquiries on results and coding issues (2001); OASIS
System Mainframe G/L Reconciliation pairoff logic; Legal & Estate Transfer
System fund maintenance (DBase); ACAT Fail to Deliver reduction (1992)
Difference is You Awards (4) - Excellence: Conversion program UAT
validation, 2001; Leadership: Financial Management Services Group United
Way campaign coordination, 2000; Quality Service: Production Summary Report
UAT, 2000; Quality Service: Conversion program SIT validation (Positions,
Balances, Client Data) 2000
Education
A. A., General Studies - Northampton Community College, 3.46 GPA; Phi Theta
Kappa (honors), 05/1986
. 3rd year - Accounting and Banking (BA in Finance); theatrical directing
and acting;
. 65+ corporate Technical, Compliance and Management training courses
(Series 7 preparation, 6 Sigma foundation, Wharton Business School and
Learning Tree International CAPM courses.
. Commercial Arts Foundation, Parson's School of Design, 1979
Citizenship
United Way Group Coordinator: Financial Management Services (2000); United
Way Division Controller: Global Quality & Systems Support (1997);
AMerrillCan Idol: Employee Giving Campaign performer (2006 and 2007);
Operation Smile: fundraising (1996, 1997)
Private Fund-Raising Benefit: with 600 attendees (1998)[pic]