Business Analyst/ Crystal Report Developer
Resume:
MICHAEL P. FERRARO
Chicago, Illinois 60631
Email: *****************@*****.***
Cell: 901-***-****
I am an analyst, and reporting professional with extensive experience in business intelligence, database marketing, custom report
development, geographic analysis and Interactive Visualization development utilizing such tools as Crystal Reports, Crystal
Xcelsius, Crystal Clear, Adobe Flex, Information Builders Focus, Visual Fox Pro, Access, SQL Server, Oracle, SPSS,
MapInfo, Personify, Postgre SQL, and ArcGIS. I have also used these tools to perform market research, market and sales
analysis and segmentation, resource balance and deployment. Not only do I have extensive knowledge of these tools, I also
posses the experience of utilizing them to identify serious decision making issues and to help managers understand their
significance and to quantify the potential outcomes of various action alternatives.
I look forward to the opportunity to discuss the position and to use my skills to fulfill the mission as a Business / Data Analyst and
Custom Report designer / Interactive Visualization developer.
I believe that I possess all of the skills and requirements to successfully assume this position utilizing my skills and experience.
• Years of marketing management experience.
• 20 years of experience with Crystal Reports and Crystal Enterprise as a user and an administrator.
• Experience creating Stored Procedures and Views in SQL Server required for custom reports in CampusVue the academic institution
management software.
• Experience creating custom reports in Crystal Reports for use in CampusVue the academic institution management software.
• Years of experience designing interactive visualizations utilizing Crystal Xcelsius and Adobe Flex.
• Years of corporate strategic planning experience.
• Years of experience in market research and analysis.
• Experience with companies that sell through distribution and direct sales forces.
• Experience working for government agencies.
• Managed national trade shows and have been involved in packaging and POP design.
• Conducted training programs and made presentations to various national associations.
• B.A. in Speech Communication, English and Secondary Education.
• M.S. in Marketing Communications with a concentration in quantitative analysis.
• Communications background with experience as a Commercial Photographic Illustrator, Industrial Filmmaker,
Slide-Show Producer, I have created countless presentations using PowerPoint and as a Designer and Developer of
Interactive Visualizations using Crystal Xcelsius and Adobe Flex.
I look forward to the opportunity to contribute.
Sincerely,
Michael P Ferraro
MICHAEL P. FERRARO
6861 Overhill Ave.
Chicago, Illinois 60631
Email: *****************@*****.***
Cell: 901-***-****
SUMMARY OF QUALIFICATIONS
I am a business/market intelligence professional, strategic planner, marketing analyst and manager, with extensive experience. I possess expert
computer and database marketing skills. I have an extensive skill set which includes the creation of visualizations and Reports using such tools as,
Crystal Reports, Crystal Xcelsius, Crystal Clear, Adobe Flex, SPSS, Information Builders Focus, MapInfo and ArcGIS. Experienced in
market research, analysis and segmentation, sales force balance and deployment, desktop mapping and geographic data visualization. I have
extensive experience in primary and secondary research. I am skilled in data extraction and analysis from mainframe; client server and PC based
data. I have extensive experience with MS SQL Server, Postgre SQL, Oracle, Information Builders Focus, Fox Pro and Access. I possess
professional skills in photography, cinematography and slide show production. I am a strong communicator with excellent team building skills.
PROFESSIONAL EXPERIENCE
Harmer Consultants, Inc. (William Blair & Co) 2013
Business Analyst/ Crystal Report Developer
• Performed analysis of existing SQL Server databases and reports in order to modify existing and create new Crystal Reports reports.
• Created Stored Procedures and Views required for new reports.
• Modified existing Stored Procedures and Views to accommodate changing business rules.
• Modified existing Crystal Report Reports to accommodate changing business rules.
Rasmussen College, Oakbrook, IL 2012-2013
Business Analyst/ Crystal Report Developer
• Performed analysis of existing SQL Server databases and reports in order to develop new reports in Crystal Reports.
• Created new custom reports as they migrated to a new academic institution management software system, CampusVue. Both the old
and the new systems utilized SQL Server as the database, however the old system utilized SSRS for reporting
• Analyzed Stored Procedures and Views to identify tables and fields in both old and new systems.
• Mapped database, table and field conversions from old reports (SSRS) to new databases, tables and fields to be utilized in the to be
created custom reports in Crystal Reports
• Created Stored Procedures and Views required for reports in CampusVue
• Created custom reports in Crystal Reports for use in CampusVue the academic institution management software
American Litho, Carol Stream, IL 2012
Crystal Report Developer
• Created custom reports from new ERP Systems, one utilizing SQL Server on its back end and Crystal Reports for its reporting tool and
the other ERP system utilizes Postgre SQL on its back end and requires the use of Crystal Clear a Java based Crystal Report like tool
• Reports From both systems required extensive use of complex formulas, Graphic data representations and a lot of conditional formatting.
Both sets of reports also required the extensive use of parameters for customizing the end user experience.
Camcraft, Hanover Park, IL 2012
Crystal Report Developer
• Created custom reports from its new ERP System which utilizes SQL Server on its back end and Crystal Reports for its reporting tool
• Developed a series of reports that had been produced in their old system that utilized a variety of tools including Cognos and Toad
• Reports were extremely complex requiring hundreds of complex formula fields and extensive use of parameters.
MICHAEL P. FERRARO page 2
Association Management Center (AMC), Glenview, IL 2011
Crystal Report Developer
• Created custom reports (Business Objects (2008), Personify and SQL Server)
• Developed reporting standards
• Responsible for documentation and Quality Control
Chicago Metropolitan Agency for Planning (CMAP), Chicago, IL 2008-2010
Regional Indicators Analyst
• Created and developed Web Based Interactive Visualizations
• Generated XML output for Interactive Visualizations by creating IBI Focus procedures
• Created custom visualizations utilizing Crystal Xcelsius and Adobe Flex
• Generated ETL scripts utilizing FoxPro, SQL Server
• Generated various unique Data Sources for Visualizations
CJK Software Consultants, Overland Park, KS 2007
Business Objects and Crystal Reports Development and Administration (Sprint Corp)
• Managed a team of developers responsible for installing and implementing a new instance of Business Objects (v. XI R2)
• Created custom visualizations utilizing Crystal Reports, and Crystal Xcelsius
• Created custom reports and reporting standards
• Responsible for the administration of Business Objects
Robert Half Technology, Memphis, TN 2006
Technology Consultant-Crystal Report Development (Various Clients)
• Created new Crystal Reports for various clients.
• Revised and up-dated existing Customer Reports
• Worked in whatever database environment the client utilized (SQL Server, Oracle, Fox Pro, d-Base and Excel.
Building Specialties (USG Corp), Memphis, TN 2004 - 2005
Marketing Manager
• Created and administered a computerized project-tracking program for the sales force.
• Created software to manipulate data (Access & FoxPro)
• Created reports to help sales force and top management utilize and manage the data (Crystal Reports)
• Created electronic forms to permit data collection and a two way communication process (Omniform)
• Converted paper forms to electronic forms to expedite daily tasks.
• Extracted data from corporate data source (Cognos PowerPlay) to perform various ad-hock analyses of opportunities within existing and
potential customer and market bases (Excel, FoxPro, Quattro Pro, Crystal Reports and MapInfo)
THOMAS & BETTS CORPORATION, Memphis, TN 1993-2001
Manager, Strategic Marketing
• Responsible for creation and development of T&B Customer Consultancy Program designed to help a select group of customers utilize
modern marketing and computer techniques, understand their own marketplaces, identify potential opportunities and sell more
effectively.
• Increased customers’ businesses by 20-35% in following year with incremental sales totaling $35 million.
• Developed a division marketing information base utilizing PC, Client Server based and mainframe databases (FoxPro, Oracle, Crystal
Reports and MapInfo)
• Developed predictive models and other analytical tools, as well as created targeted marketing lists and developed competitive intelligence
(D&B Market Outlook, SPSS, Excel, FoxPro, Crystal Reports and Quattro Pro)
• Developed tracking programs to increase sales to target markets. (FoxPro, Quattro Pro, MapInfo and Crystal Reports)
• Identified highest potential accounts for the sales force. (FoxPro, SPSS, MapInfo and Crystal Reports)
• Defined market potential and calculated market share and sales performance measures for all regions and product lines. (SPSS, FoxPro,
Crystal Reports, MapInfo and Quattro Pro)
• Automated annual budgeting process. (FoxPro and Crystal Reports)
MICHAEL P. FERRARO Page 3
PANDUIT CORPORATION, Tinley Park, IL 1981 - 1993
Manager, Market Research and Development
• Directed the corporate strategic planning process.
• Established marketing plans and programs designed to maximize effectiveness of corporate sales effort in key markets.
• Designed and executed both original and secondary research, direct mail marketing and sales incentive programs, as well as the
development of sales forecasts and other predictive and planning models (D&B Market Outlook, SPSS, Excel, FoxPro, Crystal Reports,
Quattro Pro, Lexis and Nexis)
• Directed market intelligence efforts and created applications and systems using microcomputers and mainframe information retrieval
systems ( FoxPro, Dbase, SPSS, MapInfo and Crystal Reports, SPSS, Excel, FoxPro, Quattro Pro, Lexis and Nexis)
• Programmed a Competitive Cross Reference System
• Wrote and managed sales training programs.
• Supervised staff of five.
• Developed reports utilizing Crystal Reports
PETTIBONE CORPORATION, Chicago, 1975 - 1981
Assistant Advertising Manager / Marketing Manager
• Coordinated $400 Million inventory reduction program through 37 branch locations.
• Developed forecasts and sales goals.
• Organized and managed corporate participation in national trade shows.
• Developed sales aids for all product lines.
• Managed an office staff of 30.
• Created sales brochures, catalogs and annual report, as well as managed photographic services department.
• Wrote, directed, photographed and edited films, videos and slide presentations.
• Supervised creative staff.
• Created photographic illustrations, doing large format advertising and catalog photography.
EDUCATION
Roosevelt University, Chicago, IL
• M.S., Marketing Communication
Northeastern Illinois University, Chicago, IL
• B.A. in Speech Communication, English and Secondary Education
Contact this candidate