Business Intelligence Analyst
Resume:
MICAH HIRSCHMAN ***** Tennessee Ave
*****@*********.*** Los Angeles, CA 90064
PROFILE
Expert-level capabilities in data analysis and reporting, extending Excel
to respond to business-specific needs, often in conjunction with SQL-based
databases. Examples include automated sales-data analysis and reporting,
invoicing systems, business dashboards and complex finance- and/or
investment-related modeling and analysis.
. Skilled in achieving process improvements in complex organizations.
. Effective in interpersonal communication and management presentations.
. Facilitate project management abilities with language proficiency,
math competency and software skills.
CAREER PROGRESSION
. Toyota Financial Services Torrance, 2012 - Present
Sales Analytics & Reporting Consultant
- Partnered with the Sales organization to establish requirements for
analytical tools, ensuring a high-quality useful deliverable:
Dealer performance, trending, benchmarking, rule-based alarms in an
appealing dashboard format.
- Architected, developed, and deployed dynamic analytical tools that
measure performance and identify opportunities, at any level from
dealer, sales rep, district, region, etc.
- Utilized various business and data tools to extract critical data
used for sales analytics (OneSource, Brio, Hyperion, Netezza,
Excel, Access, SQL).
- Developed custom ETL software to automatically validate and load
monthly extracts.
- Took ownership of meaningful projects directly affecting the
company's bottom-line and ability to grow its market share.
. HIT Business Consulting Los Angeles, 2009 - 2011
Consultant, Business Process Automation
- Leverage existing data sources (databases, accounting systems,
etc.) to provide automated, graphical views on business operations,
performance and forecasting.
- Improve client productivity by freeing high-value employees from
low-value data-management tasks.
- Provide custom analytical tools and training, using a flexible,
configurable approach, within Excel
- Industries and solutions:
o Investment Funds/Real Estate (Calculate distribution,
reinvestment and capital account change effects on daily
returns, by fund, by property and by investor)
o Pharmaceuticals (multi-user, multi-scenario, networked NPV
calculator utilizing users' own spreadsheets)
o Telecommunications (automated commission calculation and
terminating trunk pricing analysis)
o Physical Security (automated invoicing system using complex,
multi-site pay- and bill-rate rules)
. 90210 Surgery Medical Center (Ambulatory Surgery Center) Beverly
Hills, 2007 - 2008
Business Development (Consultant)
- Focused on business- and operations-improvements by implementing
standard processes in billing, accounting and reporting, and
improving staff knowledge of IT systems.
- Led efforts to more fully integrate third-party billing services
into the ASC's business operations.
- Designed and implemented wireless electronic data-capture within
the facility and during surgeries to increase billing speed,
decrease errors, eliminate paper processes and improve data
sharing.
. Assil Eye Institute Beverly Hills, 2007
Practice Administrator (Consultant)
- Managed all aspects of an ophthalmology practice specializing in
cataract and refractive surgery with three facilities, over 30 full-
time employees, and revenue in excess of $6 million per year.
- Led the reorganization of finance, accounting and marketing
efforts.
- Designed, implemented, integrated and maintained a business
operations "dashboard" information system linked directly to the
business' practice management IT platform.
- Implemented departmental and company incentive structures.
- Facilitated departmental goal-setting.
. Amgen Thousand Oaks, 2004 - 2006
Project Manager, Business Analyst, Software Developer (Independent
Contractor)
- Improved decision making by developing an Excel-based tool to
forecast the level and type of personnel needed across 15
departments and hundreds of field studies of new pharmaceutical
agents for Amgen, a worldwide leader in drug development.
- Led project to validate projections against historically verifiable
data to produce more accurate models of human resource needs for
the various therapeutic development groups.
- Familiarity working in all phases of the Software Development Life
Cycle (requirements gathering, preparing functional designs,
planning, implementation, testing, training, monitoring, reporting,
support, etc.)
. Hewlett-Packard Palo Alto, 2000 - 2003
Product Manager - Network Service Operations
- Restructured network hardware and software support-services pricing
to maintain HP as a preferred Cisco network equipment partner and
support-provider for HP customers.
- Automated an application consisting of multiple database systems,
eliminating extensive manual data entry, and improved cycle times.
- Designed, developed, implemented and maintained an automated
pricing/quoting tool that reduced quote times from three weeks to a
few hours, enabling HP sales reps to quote million-dollar RFPs they
were previously unable to bid.
- Participated as a key team member in winning a $14 million multi-
year worldwide support contract.
- Designed flexible pricing system for worldwide and regional use.
. AlliedSignal Aerospace (Honeywell) Paris, 1998 - 1999
New Business Development Manager
- Managed the region's monthly cash collection effort, resulting in
accounts receivable reduction of $3.2 million.
- Implemented processes to improve sales and pricing functions for
business unit that sold aircraft systems and services for
commercial, military, and general aviation markets.
- Designed and implemented regional sales reporting process using
Access and Oracle data warehouse, covering over 1,500 customers.
- Improved account managers' understanding of key-customer buying
patterns, providing more accurate information for decision making.
Project Manager, Financial Analyst Phoenix, Summer 1997
- Focused on operational and pricing issues resulting in increased
visibility and potential to improve financial performance.
- Audited ordering system and designed financial administration
process and information system implementation plan to provide
pricing flexibility, improve reporting capability and increase
bottom-line profits in the business aviation segment.
- Worked with the marketing group to analyze discounting structures,
identified critical factors and clarified pricing policy.
Confirmed that discounts were too high and presented solution.
. Air France Alaska and New York City, 1989 - 1996
Master Flight Operations Officer
- Planned and supervised all aspects of flag-carrier flight dispatch
and aircraft logistics, including flight planning and load control.
- Prepared flight plans and conducted complete pre-flight pilot
briefings (weather, route, NOTAMS, performance, etc), submitted and
reviewed Air Traffic Control flight plans, including fuel
requirements.
- Calculated and monitored compliance with safety procedures
including weight and balance distribution and limitations, and
hazardous material shipments.
- Managed and trained ramp team on proper load procedures per company
rules.
- Designed and implemented software application to automate data
collection for station operating reports, which eliminated manual
procedures and improved data integrity and personnel productivity.
EDUCATION
University of California, Los Angeles (UCLA)
. MBA, Accounting/Finance, 1998
. BA, French Literature with significant coursework in math and computer
science, 1988
IT PROFICIENCY
. Expert Excel business-rule modeling and data management in networked
database environments
. SQL, VBA, Business Intelligence Tools, entire MS Office software suite
ADDITIONAL INFORMATION
. Native English, fluent French, conversational Spanish, intermediate
German and Farsi, beginning Russian
. Private pilot, Dispatcher
. References available upon request
Contact this candidate