ROSA MARJALAAKSO
***** *. ******** ****. . ********, IL 60051 . 815-***-**** .
abnbq2@r.postjobfree.com
SUMMARY
Enthusiastic Data Analyst, Inventory Specialist, Research Financial Analyst
and Budget Analyst, with over 15 years experience in two major
universities, pharmaceutical and corporate manufacturing industries.
Recognized for taking the initiative to go beyond expectations with
creative solutions and a keen eye for detail. Known for a positive,
proactive attitude and ability to effectively prioritize, organize and
execute to meet departmental and corporate initiatives. Areas of expertise
include reconciling, financial analysis, issue resolutions, working in
cross functional teams and training. Strong database and business software
skills in SAP, Oracle and BPCS. Strong computer skills in QuickBooks,
Microsoft Office including Word, Excel, Access and PowerPoint. Fluent in
Spanish.
EXPERIENCE
HR Solutions, Inc. Chicago, Illinois August - October 2009
Production Department
An international management consulting firm that provides opinion survey
instruments, training and development services, management assessments, and
results-oriented advisory services.
Data Analyst (Contract position)
. Designed surveys, generated data and statistical reports, created data
files, and produced user-friendly reports that helped guide clients
through detailed survey processes.
. Coordinated with Project Managers and Administrative team to ensure
meeting and exceeding client's needs.
. Daily use of Websurveyor application to create web-based surveys by
inputting HTML codes.
. Knowledge and experience with using an online survey software, Vovici;
STORCK USA, Chicago, Illinois
January - May 2009
Supply Chain
A family-owned and operated German candy manufacturing company that
produces and markets such brands as: Werther's Original, Merci, Riesen to
all over the world.
Supply Chain Coordinator (Contract position)
Provided weekly reports to the Supply Chain manager and buyer pulled from
SAP and created reports in Excel using pivot tables, graphs, VLookups and
formulas that helped determine specific inventory on hand with best before
dates.
. Developed and maintained a Production Planning Report in Excel for all
project plans that provided quick access and visibility to project
issues and inventory on hand.
. Conducted and facilitated a weekly meeting with Brand managers which led
to better communication and improvement of workflow through production
and delivery of each item to the warehouses and customers.
. Analyzed data from SAP and Cognos to identify, summarize data and
prepared summary reports which helped Forecasting discussions with
Supply Chain manager and buyer.
ACCO BRANDS CORPORATION, Lincolnshire, Illinois
July 2006 - October 2008
Data Standards Team
World's largest supplier of branded office products with an annual revenue
of nearly $2B. Products marketed in over 100 countries across the globe.
Data Analyst for Item Creation and Maintenance (Laid-off October, 2008)
Supported the Director and team in the day-to-day activities of data entry
into the Business Planning and Control System (BPCS) and Oracle E-Business
Suite. Analysis of daily data issues reports for the conversion of raw
materials from BPCS to Oracle and reported key findings.
. Initiated and implemented an Excel item setup form and created an
effective timeline setup process that is currently being used corporate
wide resulting in efficient production timelines and on-time product
ordering from customers.
. Managed cross functional team efforts requiring approvals of item data
standards and leading the data change process to which led to on-time
customer receipt of product as planned.
. Worked closely with Product managers to analyze, extract and report data
of over 1,000 SKUs that required removal of Obsolete and Slow Moving
Inventory (OSMI) resulting in a savings of $50,000 in debt and fines.
TAKEDA PHARMACEUTICALS NORTH AMERICA, Deerfield, Illinois
April 2005 - May 2006
Marketing, Production
A wholly owned subsidiary of Takeda Pharmaceutical Company Limited, the
largest pharmaceutical company in Japan. In the United States, Takeda
currently markets products for diabetes, insomnia, wakefulness and
gastroenterology.
Inventory Specialist/Field Communication (One year contract position)
Supported the Production Manager and Marketing team in the day-to-day
activities for the completion of on-time and on-budget promotional
materials. Prepared monthly schedules for the shipment of promotional
materials which resulted in prompt weekly delivery of materials to the
sales force.
. Prepared and proof read Marketing's promotional brochures for correct
medical terminology.
. Inventory management on over 1,000 promotional items by coordinating and
reviewing inventory reports for discrepancies.
UNIVERSITY OF ILLINOIS AT CHICAGO, Chicago, Illinois
September 2002 - August 2004
College of Nursing, Maternal-Child Nursing
Leading program for graduate students of nursing practice, research and
education focusing on family centered health and well being of infants,
children, adolescents and women through their life cycle.
Assistant to the Department Head (Due to budget cuts, title eliminated)
. Managed and tracked all grant submissions, typing, editing, and copying
on a monthly basis.
. Completed and processed human resource documents for faculty and staff
payroll, and new hires.
. Established working relationships with faculty, staff, and students by
acting as a resource on a daily-basis.
. Effectively managed the office efficiency by answering phones,
scheduling appointments and meetings.
NORTHWESTERN UNIVERSITY, Chicago, Illinois
March 2001 - March 2002
Office of Clinical Research and Training (OCRT)
Clinical Research center that provided full-service clinic use and
coordination for Phase I to IV studies.
Research Financial Analyst
. Designed and maintained clinical trial study budgets for Principal
Investigators from Northwestern Memorial Hospital while reviewing the
Protocol for all the medical terminology in order to provide the medical
breakdown of costs and supplies needed for the study.
. Effectively coordinated all facets of contract submissions and relations
with Contract Office of processing contracts that resulted in prompt
approval to begin the clinical trial study.
. Successfully negotiated clinical trial budgets of over $100,000 with up
to 15 Pharmaceutical Companies.
. Maintained effective working relationships with Pharmaceutical Companies
and Principal Investigators.
UNIVERSITY OF ILLINOIS AT CHICAGO (UIC), Chicago, Illinois
August 1997 - March 2001
National Network of Libraries of Medicine (NN/LM), Greater Midwest Region
(GMR)
Library's goal is to enhance access to health information for health
professionals and the public in the areas of Consumer Health, Resource
Sharing and Technology as it relates to the products and services of the
National Library of Medicine.
Budget Analyst
. Designed and maintained a computerized budget system that tracked all
expenses of the $800,000+ yearly budget.
. Audited and reported a $56,000 discrepancy of indirect cost entries that
were calculated and charged incorrectly.
. Provided monthly budget reports to the Associate Director detailing
expended funds and projected expenditures for the remainder of the year.
. Assisted incoming callers on obtaining information on Consumer Health,
medical terminology and services.
. Reconciliation of data from the computerized budget system to the
special purpose general ledger accounts.
. Maintained skills using Excel spreadsheets, word processing, UIC online
accounting software as well as accounting and fiscal management
principles.
EDUCATION
BS, Business Administration, University of Illinois at Chicago, Chicago,
Illinois, 1994