LANA GROPEN

** ******* ***** 973-***-****

Livingston, NJ 07039 acqihs@r.postjobfree.com

IS SENIOR BUSINESS ANALYST

Customer focused IS Lead for Consumer and Sales Insights (Business Intelligence Systems Analyst) who assesses business and change management needs, defines comprehensive requirements, analyzes alternatives, and implements solutions that meet the exacting needs of the business. A leader with experience gathering business requirements, initiating and implementing change management processes to enhance the functionality and reliability and capabilities of systems while consistently improving productivity, performance and quality.

Core Competencies: Gathering information Participating and leading workshops Interacting with all levels of client management Business process analysis - process mapping and requirements Cost reduction Customer satisfaction Gaining competitive advantage Nielsen applications and data

PROFESSIONAL EXPERIENCE

MONDELEZ INTERNATIONAL COMPANY 10/2012-12/2014

One of the world's largest snacks companies.

IS Lead Consumer and Sales Insights/ Business Intelligence Systems Analyst

Assessed business and change management needs, defined requirements, analyzed alternatives, implemented solutions and created standard processes. Did troubleshooting for data and software technical issues; during new releases I developed test cases to insure the quality of the product.

REPRESENTATIVE ACCOMPLISHMENTS

Change Management and Communications for Nielsen software:

Assumed leadership position for all change management and communication processes for the software that provided access to the consumption data to over 500 Sales, Finance and Marketing users. These efforts allowed all clients ease of trainings, understanding of any details of deployments of the software and data, and also the ability to work on the reporting and independent analysis.

Established Training for the users of Nielsen applications and Consumption data:

Initiated setup of sales and marketing specific training(s) enabling user community with the ability to use and understand Nielsen applications and data. This effort resulted in savings of $50.000, increased customer satisfaction, and gained competitive advantage within the industry.

Ad – hoc reporting initiatives

Led multiple ad-hoc reporting initiatives for the Business clients with multiple systems for new product reporting; category review reporting; situation assessments reporting:

oAOD Desktop (consumption application)

oAOD Web (consumption application)

oSpark (Shipments application)

Established process for incorporating internal data within Nielsen software:

Established the process to incorporate shipments specific data within the third party software. Ensured setup of the process, its principals and guidelines. Partnered with multiple third party businesses to solidify partnership and to make data and the system business adaptable. Collaborated with internal groups to represent business needs and focus on the process issues to

Lana Gropen Page Two

Identify short and long term business goals. As a result Mondelez sales teams have a stable business process that guarantees data access and accuracy with no cost associated with the business teams.

Change Management process for upgrades and new releases of Nielsen applications:

Led change management and established technical processes throughout Nielsen software releases and upgrades. Collaborated with third party groups and internal partners to permit user community to anticipate upcoming changes. Identified business needs, created change management and communication process between Nielsen partners and company business groups. Modified timelines and process structure to accommodate issues and/or changes brought by Nielsen business partners. Ensured success of annual releases and brought easy transition to the clients with the minimal interruption to the large business community.

Big Data Reporting Efforts:

Partnered with IS colleagues to deliver bigger and better data. Shared information and collaborated across many groups. Led the process of gathering and evaluating what data was already available within the company, how it could be used to benefit others, and what technical capabilities Mondelez could employ to achieve maximum success. Provided subject matter expertise to ensure group goals in the establishment of the multisource reporting.

KRAFT FOODS COMPANY 10/2000-10/2012

Kraft Foods one of the largest American grocery manufacturing and processing conglomerate.

Business Intelligence Systems Analyst/IS Lead Consumer and Sales Insights

Implemented systems upgrades, planned strategies to implement new business needed applications and processes, analyzed change management needs for the Nabisco transition to Kraft Foods, partnered with business and third party software developers to develop requirements for business reporting needs.

REPRESENTATIVE ACCOMPLISHMENTS

Established Business Review Model for Marketing Team:

Provided subject matter expertise for the Nielsen applications and Consumption Data during category initiative to create a unified process.

oServed as a liaison between the business and the IT area, translating varied business needs into application software requirements.

oPartnered with the business clients to develop a process of creating and maintain the model. Functioned as a consultant sharing my knowledge of Excel and VBA. This effort lead to saving of $27.000 for the Marketing group and timely completion of the project.

Sustained on-going multiple reporting efforts for consumption and shipments data:

Performed in-depth analysis of large amounts of data to determine data content, consistency, and quality as part of the project life cycle. Provided insight regarding business cases and data quality improvement efforts. Delivered reports of various complexity levels to internal as well as external partners.

Established Training for the users of Nielsen applications and Consumption data:

Managed and ensured a successful process of the Summer Intern Training Program for Marketing and CIS interns. Partnered with HR to establish functional training schedule; initiated involvement of the business category mentors to participate in the program in order to connect data and technical training with the understanding of the company’s day-to-day business; this effort proved to be an effective move in establishing positive and motivating environment for all trainees.

Lana Gropen Page Three

Communication process through Share Point Team site:

Created the Share Point Team site as a communication venue. Streamlined support and communication processes to the large client community; empowered business users by having access to centralized information.

NABISCO COMPANY 6/1999-10/2000

One of the largest American manufacturer of cookies and snacks.

Programmer Analyst /IS Consumer and Sales Insights

Supported Nabisco’s consumption data reporting tool, defined requirements, analyzed alternatives, implemented solutions and created standard processes.

SQL Database on-going support

Led support and maintenance of the SQL database for consumption data for the BATS application. Set up tables; created queries; established data mappings and connections between multiple product, facts, markets and time period tables.

Enterprise Edition, Inc., Bloomfield, New Jersey 1998-1999

Programmer Analyst

Major Insurance Company, New York, NY 1997-1997

Programmer (Consultant)

EDUCATION AND CAREER DEVELOPMENT COURSES

BS in Mathematics, Kiev University, Kiev, Ukraine

Project Planning, Analysis, and Control, ESI International - PPAC Training, 2013

The Cornell Club 2011

Breakthrough Ideas: How to Think Strategically, 2011

What Does It Take to Be a Successful Leader in today’s World? 2011

The ADKAR Model, Prosci Change Management Certification Program 2009

ProWork Inc., Fairlawn, New Jersey 2006

Training in Visual Basic 5.0/4.0, MS SQL Server, MS Access

Producing Results with Others, Tracom Group - Social Style Training 2005

TECHNOLOGIES

Visual Basic, VBA, Microsoft Office, Outlook, Excel, Word, Power Point, Share Point, Captivate and Tableau

SQL Server, Access, and Oracle.

Contact this candidate