Alyce Poalillo
(Home) [Send email to request phone number] 48-6260, (Cell) [Send email to request phone number] 34-6073
[Send email using form at bottom]
Summary
Senior professional with hands on working experience in Banking, Financial
Markets, Information Technology, Ratings Services, Pharmaceutical Sales and
Marketing, as well as Culinary Products, and with extensive concentration in the
areas of Brokerage, Asset Management, Trading (execution, management and
systems), Sales/Marketing (Data Warehouse, Finance), Mutual Funds, Portfolio
Management-Equity, Fixed Income and Money Markets, Customer Information (CRM),
Customer Privacy and Trust/Private Banking/Asset Management and Securities
Markets Regulatory Compliance.
Strong areas of experience include: application and extract design/development
and implementation; ETL; rules based system extraction, management and
deployment; and systems conversions. Background in project lead/management, with
full project life cycle experience (SDLC), change management and full phase
testing experience. Extensive experience in analysis, technical writing and
documentation including RFPs, SOWs, business requirements and functional
specifications; SOPs; training and training materials; market trends; data and
business analysis and research; cost benefit analysis; and gap and vendor
analysis. Providing consulting services in business process and work flows and
in management organization as well as strategic and tactical business and
technology recommendations and solutions.
Professional Experience
D & B-Parsippany 2/07- Present
PMO
Senior Business Analyst/Consultant
As a consultant working for the PMO, currently on assignment to the new data
warehouse team, creating business requirement, rules, project, quality control
and testing documentation for the staging and data warehouse, data mart and
analytical mart for the detailed trade product. Utilizing System Architect and
DOORS tools, assisting the user groups with gathering and defining requirements
and outlining current and future business process flows and loading
requirements/rules to Quality Center to assist with test correlation. Also
acting as the Change Request Moderator, managing the Change Management process,
including conflict resolution and troubleshooting. Assisting the Project Manager
in the coordination and timing of project tasks, events and resources. In
addition, serving as advisor to the PMO on rules definition, collection and
application.
Intrasphere Technologies ____
11/06-1/07
On assignment at Novartis/East Hanover/Sales and Marketing Finance IT Support
Senior Process (Business) Analyst/Consultant
Analyzed and documented business and daily processes and workflows and made
recommendations for improvement. Analyzed multiple batch feeds, including those
from SAP, and Ariba, and recommended batch process changes to streamline daily
batch runs. Created a testing methodology and test scripts for a
Marketing/Finance system enhancement and managed UAT. Developed a new change
management process and made recommendations for its implementation.
AMP Information Consulting LLC 08/05-Present
Owner and Primary Consultant
Independent research and consulting business conducting internet and print media
research and personal interviews, as well as gap and vendor analysis and consumer
product and service evaluations. Clientele includes small and medium companies
representing financial, food & culinary products, travel, environmental
industries, as well as writers and individuals requiring information or fact
validation. Conduct independent evaluations of product and service quality,
competitive market and trend analysis, and customer service for larger
organizations.
Also consult on reorganization, problem resolution and management of smaller
companies and offices including reviewing P & Ls and general ledgers and
recommending process improvements. See www.ampinformationconsulting.com
Citigroup-Warren, NJ 06/05-04/06
CIB Technology/ Business and Document Services Support
Senior Business Analyst/Employee
Analyzed business needs and created documentation, including business
requirements, traceability matrices, project plans and functional specifications
for software applications. Functioned as the primary analyst for enhancements,
vendor package implementations and some new development, for client server and
web portal applications. Primary business support area was business and document
services, including implementing a mail tracking system and a document imaging
system.
Oppenheimer Funds-NYC 04/05-6/05
CSG/Sales and Marketing Support
Senior Business/Process Analyst/Consultant
Engaged to conduct a detailed independent analysis and feasibility study on a
Web portal application currently used for displaying and reporting fund holdings,
performance and statistics to internal sales and marketing personnel.
Responsibilities also included vendor evaluations and recommendations for future
internal and external development solutions-build verses buy analysis. Reviewed
multiple external feeds to the sales and marketing system for source of data and
inconsistencies, including pricing, general ledger, research and commissions. In
addition, a gap analysis was conducted and a data dictionary and glossary were
created. Data definitions and calculations were researched and standardized
across multiple systems bringing them in line with current market and industry
standards. Acted as a liaison between technology and business resources and as a
project manager for this initiative. Also provided recommendations and strategic
and tactical solutions for process, work and management restructuring and
efficiencies.
Morgan Stanley Trust-Jersey City 07/04-04/05
IT/Mutual Funds
Senior Business Analyst/Team Lead (Consultant)
Senior analyst, leading a team of analysts and technical resources in the
research and development of a Rules-based solution for a Mutual Funds Transfer
Agency System Renovation project. Created a Rules Repository and the methodology
and language to be utilized for a business driven and maintained rules
application. In addition, acted as a Subject Matter Expert, assisting the other
project teams in developing requirements for the System Renovation. Developed
close working relationships with the vendors and the business line
representatives as well as the technical staff and assisting in the logical
database design. Responsible for the development and maintenance of the Gap
Analysis documentation utilized by the entire Project Team to define the scope of
work and create the functional specifications from the business requirements.
Researched market trends and utilized these in a build verses buy analysis of
current Mutual Funds system verses other market products. Created test plans,
test cases and scripts for two major enhancements to Transfer Agency systems and
managed the full testing lifecycle.
JP Morgan Chase - NYC, NY 02/04 – 6/04
Private Bank / IT Solutions Plan Group
Senior Business Analyst (Consultant)
Senior Analyst and QA Tester supporting new releases of a Web based portfolio
management tool for the Private Bank. Performed QA and UAT testing on the
Rebalancing and Account Grouping functionality release, creating regression test
scripts and data integrity checks. Analyzed the business rules and requirements
and prepared the functional specifications for enhancement and optimization of
asset classes and asset allocation, creating a security master, for the purpose
of implementation of new strategic model portfolios and a new portfolio
management process. Performed data analysis and provided tactical and strategic
recommendations for solutions to data integrity and consistency issues in
preparation for a new data management repository. Performed data mapping and
impact analysis on up and downstream systems utilizing the same data. Analyzed 5
different Trust Accounting systems, including OMNI, and multiple vendor products
to determine best source and attributes of asset classes.
Merrill Lynch - Princeton / Hopewell, NJ 03/03 – 02/04
Merrill Lynch Bank & Trust / IT
Senior Business Analyst (Consultant)
Analyst and QA/Tester supporting Finance, Accounting (GL), Treasury
(Trading-Repurchase Agreements, CMOs, Treasuries, MBSs), Trade Operations, Audit
and Compliance and Risk Management for the Bank. Performed detailed business
analysis for new development and system enhancements, user liaison functions,
specifications and requirements documentation, workflow, scope documents and
solution proposal writing, user manuals and training, policies and procedures
manuals, test script creation, testing, and problem/troubleshooting resolution.
Worked with Use Case/Prototyping/RUP Project Management methodology on various
projects including: Summit Systems 3.5 upgrade, Oracle 11i upgrade, SILK testing
system upgrade, Bank Data Repository (BDR), G/L Accounting Reconciliation
Register (for audit/Sarbanes-Oxley compliance) and Documentum implementations.
Designed workflow process for documentation collection and storage for Documentum
implementation. Environment was client server and Web portal technology using SQL
queries, Windows XP, MS, Rational and Silk tools to define, design and enhance
technology solutions.
B of A/FleetBank (former Summit Bank), Cranford, New Jersey 07016 1998 – 2002
Customer Information Systems / Relationship Management Systems (CRM)
Lead Systems Analyst/Project Leader/ (Employee)
Primary user/client groups included Retail Deposits (including Demand and Time
Deposits), Brokerage, Compliance, Legal and Marketing. Project Lead and
Analytical responsibility for the daily enhancement/ development for, and
production support of, the Bank’s central Customer Information System, containing
upwards of 3.2 million customer records, and the Database Marketing system (Data
Warehouse) containing all demographic (CRM) and householding data and customer
privacy indicators. Several tools were used in the design and data
cleansing/integrity for the Data Warehouse including using FileAid and SQL for
queries and testing, as well as ISI and Trillium packages for householding and
warehousing. This includes all functional specifications, design, testing and
report writing for all user requested enhancements/changes as well as interfacing
with 16 other Bank business lines and account files contained within the CIS
system, amounting to about 8 ˝ million accounts. Supported technology initiatives
in all Personal Banking areas including Demand and Time Deposits and all the
related work processes including funds transfer and availability, income and fees
and electronic banking. Additional job responsibilities include the
co-ordination of the work effort of 2 other analysts, functions relating to the
back up to the Department Manager and also responsibility for the integrity of
the system’s data and improving the quality of the input/output and the
processes.
Accomplishments:
1. Recipient of the Bank’s Reach Higher Award for excellence in customer
service/support and demonstrated creativity in troubleshooting and problem
resolution. Nominated by the management of Retail Deposits (Demand and Time
Deposits) for finding technological solutions to business problems and creating
efficiencies in operational workflows.
2. Managed projects to implement a money laundering/fraud detection system
(Early Warning) for new bank accounts, a new system to monitor Reg.O compliance
as well as a new OFAC compliance software package. Provided business analysis and
technical expertise on various OCC and SEC regulatory compliance related issues.
Acted as liaison between Legal, Compliance, Brokerage and Asset Management
(Trust) on numerous compliance issues from an IT perspective.
3. Participant in the Bank’s mentoring program to share experience with other
Bank personnel. Created functional job descriptions for all IT staff.
4. Designed an analyst/project manager training program and several client/user
training programs.
5. Created standardized technical documentation, templates, a quality assurance
process and testing requirements.
6. Improved data integrity by upwards of 12% based on exception reports and
“non-checkable” report. Led teams in completing a full data scrub of customer and
account database-8+ million records- in preparation for conversion to Fleet‘s
customer information system.
7. Created and implemented application extracts (ETL) from Brokerage (ADP),
Personal Trust and Corporate Trust for the Database Marketing Department (RDBMS)
and CIS (Customer Information System)
8. As a consultant for the first 6 months at Summit Bank, team leader assigned
to the Marketing Relationship Management Database Project (Data Warehouse),
managing the implementation of Householding software interfacing with the
Customer Information System and the Relationship Information System.
UpTick Technologies, New York, NY 07/97 – 01/98
General Ledger & Trading Systems
Business Analyst (Employee)
Designed On line trading system, wrote proposals, functional requirements and
designed reports and GUI screens for a small software developer. On line trading
system was for a broker/dealer and included all aspects of securities processing,
trading, commission capture, reporting and securities regulatory compliance. Also
supported daily production and client support for proprietary GL application.
Participated in new business presentations and client retention initiatives.
Prudential Insurance Company, Newark, NJ 12/96 – 06/97
Global Custody/Asset Management
Business Analyst (Consultant)
Did analysis and wrote documentation for a new portfolio and asset management
accounting system (Global Asset Management Dept). Tasks included developing
policies and procedures documentation, writing business requirements, functional
specifications, and project audit documentation as well as performing automated
testing.
Software Tools/ Systems/Applications Experience
MSProject 2000, Windows 2000 and XP, Microsoft Word, Excel, Access, Outlook,
Visio, PowerPoint, Quality Center, CSC/Hogan-RIS, CIS, MSS, Umbrella, Trillium
and Harte Hanks Marketing Databases, NCOA, DMA, ILOG/JRULES,ISI (BankMatch,
BankMatch Review, Innovative Householding, CorpMatch, Dictionary, Analyser) WJM
Early Warning Fraud Detection, Trust Systems- Sungard-InvestOne, SEI, AMTrust,
Trading Systems and Information Tools- Summit Systems, Bloomberg, ADP, Instinet,
Autex, FirstCall, Telerate, Regulatory Experience with: OFAC, Patriot Act,
Anti-Money Laundering, Sarbanes-Oxley, OCC, FDIC, SEC, Customer Privacy
(Gramm-Leach-Bliley), Other: FileAid, EZTRIEVE, FOCUS, Globus, Crystal Reports,
Erwin, DB2, Mainframe, SQL, Rational (RUP), Use Case, Documentum, ImageTag,
Client Server technology.
Education
Montclair High School Montclair, NJ
Fairleigh Dickinson University- (attended) Rutherford, NJ
New York University (Travel Management Program) New York, NY
New York Institute of Finance (attended) New York, NY
Professional Courses
ESI International - Attended the PMI program obtaining certification in Managing
Projects in Organizations, Project Leadership, Management and Communications and
Quality for Project Managers.
Rational- RUP training, Business Requirements Analysis, Testing (Clear Quest)
and Change Management.
Quality Center
Certification in MS Project
|
