EDUARDO D. ESTIPONA
**** ****** **. ******, ******** 60031
abnei2@r.postjobfree.com
____________________________________________________________________________
________________________
SUMMARY: Thirty plus years proven accomplishment in financial
management, accounting back office operations, budgeting
and actual expense analysis, cost trending and forecasting
coupled with exceptional analytical skills and attention to
details.
A highly motivated team player, demonstrated expertise in
project management, vendor management, contract
negotiation, record management, and disaster recovery
planning and implementation. With acquired financial savvy
and business acumen, and ten years of market data
experience, peers considered me as a SME (subject matter
expert) in the business of market data finance, entitlement
operations and market data desktop technology.
Excellent work ethics effectively trained and managed peers
and subordinates, resulting in maximized efficiency and
productivity. Streamlined the work process flows by
leveraging technology that saved Wachovia $800K in 2000,
$900K in 2001, $491K in 2008 in actual market data expense.
Strong interpersonal and communication skills, proven
expertise in acquisition and integration of various market
data accounts and products, and in identifying and
consolidating corporate synergies resulting in million
dollar company saving.
EXPERIENCE:
Sep 2009 to Jan 2010 Exelon Corporation - Chicago
IT Consultant - Business Analyst - Contracted thru Arthur
Lawrence Worldwide
. Using CLARITY FSR developed, tests, remediated 200 PI
(Performance Indicator) reports used by utility
companies for SEC and FERC compliance and reporting.
. Participated in systems and integration, UAT testing.
. Developed nine to ten business objects to build one
PI. Includes headers, charts, grids, commentary,
footers, links, and bookmarks.
. Ensure that formulas, bookmarks, macros, are in order
and data are linked accordingly from OLAP Essbase
cubes.
Jul 1999 to Mar 2009 Wachovia Securities - Chicago
Senior Financial Analyst /Market Data Services
IT Market Data Process Analyst / Application Development
. Reconciled and processed $130M market data spend
incurred by corporation. Tracked and analyzed volumes
of market data cost, reviewed various pricing against
current contract with exchanges and data providers,
and provided expense trending and forecasting reports
to the management.
. Streamlined invoice processing by leveraging
technology resulting in increased efficiency and
reduced FTE requirements. Converted large invoices
from paper to electronic invoicing, developed a
spreadsheet to reconcile invoices from Bloomberg,
OPRA, Dow Jones, AMEX, and NYSE
. Spearheaded project in streamlining the
reconciliation and payment process of 2,500 monthly
invoices paid to Thomson Reuters saving the company
$60K in administrative cost annually.
. Reviewed exception reports, researched any
discrepancies, and developed a vendor variance
analysis report, compared actual expenses versus
allocation to all lines of business. Collaborate with
application developers & enhanced the market data
inventory tracking system and participated in UAT
(user acceptance testing), and provided various Ad-
hoc reports to all LOB.
. Audited and consolidated all market data exchange
entitlements accounts resulting to an annual savings
of $800K in 2000, $900K in 2001, and $491K in 2008.
. Maintained all IT maintenance, hardware and software
invoices, developed an Access database tracking
actual IT monthly cost. Review and approved all IT
contractual invoices. Ensure all current market data
exchange and vendor invoices are paid, prepared and
processed journal entry to accrue unpaid market data
expenses.
. Implemented a monthly and quarterly budget variance
cost analysis and provided reports to CIO. Researched
and resolved issues regarding budget versus actual
cost center charges.
. Obtained data from various internal and external
customers and vendors needed to prepare the requested
monthly ad-hoc reports and to produce required
monthly reporting.
. Audited Thomson updater and Reuters RMDS system and
compared user entitlement with invoices including
exchange invoices. Entitled various users with
different market data desktop (e.g. Thomson One,
Reuters 3000, Bloomberg terminal) including third
party exchange entitlements.
. Run a monthly internal report to monitor real time
and delayed data feed and reported such quote meter
usage (ticks) to various exchanges (Amex, NYSE, OPRA,
Nasdaq).
Nov 1987 to Jun 1999 Fannie Mae - Chicago
Financial Analyst: February 1996
to June 1999
. Analyzed annual audited financial statements of
various lenders determining financial stability and
minimized credit risk;
. Analyzed and resolved issues involving mortgage
lenders' eligibility exceptions;
. Prepared monthly budget variance analysis and submit
reports to senior vice president and various line of
business leaders;
. Maintained Fixed Asset System reconciled and tracked
all fixed asset and equipment for the Chicago Region.
Reconciled fixed asset general ledger account;
. Assisted Finance Manager in preparation of annual
budget and related account analysis;
. Reconciled and maintained leasehold and leasehold
improvement accounts for the Chicago regional office.
Associate Accountant: July 1989 to
February 1996
. Handled general ledger, disbursement, and
clearing/suspense account reconciliation;
. Processed payroll, ensured accuracy of data, and
coordinated with corporate accounting on the
distribution of check payment stub.
. Developed and implemented an electronic Excel time
sheet form and converted the manual/paper time sheet
process to electronic filing, eliminating paper time
sheet reporting and improving time sheet submission
efficiency;
. Analyzed accuracy of reconciliation module of
accounting systems;
. Assisted internal customers in reconciling and
processing travel expenses and providing reports.
. Review and approved all travel related expense of the
whole Chicago region.
. Researched test materials, developed worksheets, and
initiate procedures in resolving various out of
balance general ledger accounts;
REO Disposition Specialist: November
1987 to June 1989
. Reviewed all REO files, verify accuracy of HUD 1
Settlement Statement; analyzed form 571 cash
disbursement requests for property taxes, attorney
fees, & other foreclosure related expenses. Approved
payment of form 571 cash disbursement request
submitted by various lenders.
. Developed monthly REO charged-off analysis report,
maintained inventory of foreclosed Real Estate Owned
property & Charge Off losses incurred with
disposition of REO.
. Coordinated valuation of FNMA acquired properties
with real estate appraiser and the timely disposition
of such property with external real estate brokers.
Mar 1986 to Oct 1987 Holiday Inn City Centre - Chicago
General Storeroom Manager:
March 1987 to October 1987
. Developed, implemented and maintained inventory
procedures in controlling supplies, food and
beverages;
. Assisted the Food and Beverage Manager in
reconciliation and analysis of hotel supplies, food
and beverage requirements;
. Managed three FTE and effectively managed the smooth
flow of materials and supplies of the hotel
storeroom.
Night Auditor:
March 1986 to February
1987
. Responsible for the daily accounting and auditing of
sales, occupancy, bar and restaurant receipts;
. Analyzed, summarized, and streamlined daily, weekly
and monthly sales and occupancy status of the hotel;
provided such reports to management including
quarterly and annual reports.
Aug 1981 to Feb 1986 Corporate Brokerage, Inc. - Manila, Philippines
Bookkeeper, Payroll Supervisor, Accounts Payable /
Receivable Clerk
. Effectively handled accounts payable / receivable,
bookkeeping and payroll distribution functions
including general ledger reconciliation;
. Responsible for the company petty cash account and
bank account reconciliations, act as liaison with
various financial institutions and various government
agencies.
. Supervised and trained four FTE supporting day-to-day
back office accounting operation.
May 1975 to Jun 1981 Amco Manufacturing Philippines Inc. - Bataan,
Philippines
Production Supervisor, Pattern Maker, Spreader
. Managed eighteen full time employees in two shifts,
effectively achieved production targets by training
subordinates and implementing effective managerial
skills.
. Headed task force, developed, and implemented
effective maintenance of work in process inventory.
. Developed efficient methodology of pattern
arrangement to cut denim jeans, resulting in a huge
company savings in material costs.
EDUCATION:
1976 to 1981 Polytechnic University of the Philippines, Manila
Philippines
Associate in Accounting
ADDITIONAL SKILLS / TRAINING:
. MSA / CICS - Account Payable and Fixed Asset Modules
. People/Soft - G/L, Accounts Payable, Fixed Asset
Manager, Purchasing Modules
. Lotus 123, Word Perfect, Word, Power Point, Harvard
Graphics
. Time management
. Stress Management
. Grammar and Correspondence Course
. Presentation Skills
Fannie Mae - In house training - Chicago, IL
. Microsoft Excel - Basic and Intermediate Courses
CompUSA Software Training Division - Niles, IL
. Microsoft Access - Basic and Intermediate Courses
Catapult Software Training Division - Chicago, IL
. Hyperion Enterprise - GL/AP modules and Financial
Reporting modules
. Systems and Database Design -
First Union Securities - CMG/ITS training program -
Chicago, Illinois
. Computer Training Programs for Accountants and Auditors
Center for Review and Professional Development Inc. -
Philippines
. Various IT Computer Based Training Programs - Wachovia
Securities - Chicago, IL
IRIS- Integrated Reporting Information System
EAGLE - GL Accounting Journal Entry Interface
OCR Oracle 11.i AP module
CISCO 11.3 - Internetworking Course
Data Dictionaries and Relational Principles
Data Flow Diagrams
Database Fundamentals
Entity Relationship Diagrams
First Union - Financial Services 101
ESSBASE - Basic Corporate Accounting and Reporting Cubes
Fundamentals of Internetworking
Internetworking Essentials, Devices, and Bridging
Protocols
Introduction to ORACLE Essbase Cubes
LAN Fundamentals - TCOM13E
Systems Analysis Fundamentals
TCP / IP Protocols - TCP/IP Architecture and Routing
WAN Technologies
. IT Application Development - Product Development &
Maintenance Process Training
Estimation Process Training
First Union Securities - Chicago, IL
. Intermediate Financial Accounting Review Course
American Management Association - Chicago, IL
. Mortgage Loan Processing, Mortgage Loan Underwriting
Mortgage Bankers Association - Chicago, IL
. Basic Real Estate Transaction - Salesperson
Qualifications
Real Estate Education Company - Chicago, IL
. First Concern Line Level Training - Customer Service
Holiday Inn City Centre - Chicago, IL
. Tariff and Customs Laws Advance Course
Bureau of Customs, Philippines
. Supervisory Development Course
Amco Manufacturing Philippines, Inc.
Currently taking SERIES 7 course with Securities
Training Corporation and will take the test within one
year.