MARCO DE'MEDICI
**** ** ** ***** #*** ( Fort Lauderdale, FL 33311 954-***-**** (
*************@**.***
CAREER SUMMARY
. 15+ years of advancement and expertise in data analysis, business
analysis and systems software
. Interpersonal communicator, presenter and negotiator working with senior
management and IT departments
. Proven record in improving department inefficiencies and reducing costs
by implementing value-added systems, software and processes
. Advanced in digital marketing with platforms such as Google Analytics,
Facebook, Twitter, Google+, marketing
EDUCATION
University OF Miami, Coral Gables, university of miami
Florida Bachelor of Science, May 1986
Master of Business Administration, Psychology and Chemistry
December 1999 GPA 3.5/4.0
Finance, International Marketing and
Business
GPA 3.7/4.0
Nominated as Speaker of the Class
EXPERIENCE
FRANKLIN TEMPLETON INVESTMENTS, Fort Lauderdale, Florida
Manager, Investment Research, 2007-2009
. Developed report generation systems and business analysis models in MS
Access, Excel and Oracle for the Investment Research department to
increase efficiencies and eliminate inaccuracies
. Engineered performance statistical analysis to develop financial and
budgetary models for
measuring performance impact and increasing stock portfolio returns
. Created automated spreadsheets using Visual Basic for Applications to
assist with portfolio support of over 120 accounts with a net value of
$120 billion dollars
. Led a team of over 100 individuals to reengineer a UNIX database into a
GUI browser based database system,
a $10 million project
Supervisor, Research and Data Technology, 2003-2007
. Led a team of business analysts to upgrade and refine database processes
eliminating 40% of third party data costs
. Established new protocols to cross check the integrity of data in data
warehouses across multiple departments
. Developed a real time broker commission system relational database
reducing fund allocation time by 75%
. Evaluated the IT helpdesk and Portfolio department interaction process
and created a system of rapid IT support for PCs and Executives
. Redefined training parameters for financial analysts and created
comprehensive training program for new hires
Research Systems Business Analyst, 2000-2003
. Analyzed internal data warehouses and incorporated third party data
sources to expand securities information
by over 300%
. Reevaluated data queries and streamlined SQL code to reduce report
generation time over 50%
. Served as the technical consultant to IT department to reduce lead time
for UAT testing and project implementation
. Created an online shopping system for thousands of statistical analysis
presentation slides in MS Access
Senior Graphic Designer, 1996-2000
. Redesigned outdated marketing materials and reformatted them to
streamline production time
. Recruited to be main software lead to improve and to educate department
on use of all graphic design software
. Manipulated interactive software with BI tools to provide department a
more comprehensive view of all marketing lead sources, campaigns and
fund performance.
. Established standardized guidelines for production times and reduced
time to press
OFFICE DEPOT CORPORATE, Delray Beach, Florida
Catalog Manager, 1995-1996
. Implemented the Pindar Quark publishing system to reduce catalog
creation time by 75%
. Automated database zoned pricing and publishing for catalogs for 70
retail zones reducing time to press and allowing creation of 4 more 800
page catalogs per year
. Established back end product database to store over 12,000 product
descriptions and imagery
. Implement marketing project plans and tracked success of catalog
marketing
Graphic Designer, 1994-1995
. Create and maintain catalog databases and catalog page layouts
. Redesign all collateral materials for retail advertising and marketing
consistent with a marketing plan
computer SKILLS
SERVER APPLICATIONS: MICROSOFT EXCHANGE, IIS, AND SQL SERVER
Desktop Applications: Advanced User of Excel, Word, Powerpoint, Quark,
Photoshop, Illustrator, Acrobat
Database: Oracle, Microsoft Access and Filemaker, Sharepoint
Languages: SQL, HTML Intermediate Visual Basic, VBA for Applications
OPERATING SYSTEMS: WINDOWS NT, WINDOWS 8, DOS, UNIX AND LINUX
SKILLS
. EXCELLENT PROBLEM SOLVING AND EXCEL-BASED MODELING SKILLS
. Strong communication and presentation skills in Powerpoint
. Marketing communications and event planning
. Project management experience throughout 13 years at Franklin Templeton