Project Manager

James D Ehlen

*** ****** ****** **** ( Buffalo Grove, IL 60089 ( Phone: 847-***-****

E-mail: **********@***.***

Accomplished Project Lead is seeking a position to utilize extensive

background as a Business Analyst, Data Analyst, and Business Intelligence

expert. Well versed in Waterfall and Agile project Methodologies

Extensive knowledge utilizing analytics and reporting tools including: MS

Office Suite (Excel, Access), Oracle Discoverer, Cognos, and Toad,

trained in Business Objects. Experience Managing fast paced Business

Intelligence/Data Warehouse team. I will bring to an organization, broad

experience working directly with executives, business partners across the

organization, and outside customers while using exceptional

written/verbal communication skills. This broad range of skills will

result in outstanding and immediate impact for the business customers and

the organization as a whole.

CCH/Wolters Kluwer, Riverwoods, IL

02/2013 - 03/2014

Senior Business Intelligence Analyst/Contractor

Provide detailed project requirements for a variety of projects ranging

in size and scope. These projects were all strategic in nature as they

will be providing critical analysis for the leading business unit to make

strategic marketing decisions. In this role, I also performed, ETL,

Data Analysis and report creation utilizing Microsoft Access and Excel

for business customers across all levels of the organization.

Volkswagen Credit Inc., Libertyville, IL

02/2012 -

12/2012

Business Systems Analyst/Contractor

In the BSA role, defined business requirements and performed analysis on

various projects, which ranged in size and scope, associated with

deploying a new data warehouse. Utilized Waterfall and Agile project

methodologies depending on the project and scope. I led projects through

the entire development life cycle by working closely with business

clients and third party vendors from across US and Canada. Gathered

accurate and thorough requirements and created actionable stories with

detailed acceptance criteria for the development team. Function also

included communicating project timelines and providing project updates to

the strategic stakeholders during all phases of the project. The

following tools were used during the course of scoping and analysis for

projects: Informatica for mapping and defining source data elements,

Business Objects for defining report criteria, and Rapid SQL.

CCH/Wolters Kluwer, Riverwoods, IL

11/2004 - 10/2011

Business Data Analyst

Create custom reporting for Marketing professionals and executive

management to drive business results and strategic planning. Implement

strategic projects across the company, that contributed directly to the

companies overall revenue by providing critical analysis used in

marketing efforts. Work directly with business customers from around

the world, along with technical resources to provide outstanding

analysis.

. Managed a small team of Business Intelligence analysts for a year and

a half.

. Led and performed strategic analysis for Law and Business unit to

provide a combined customer view from six different platforms

delivering analysis for $575 million dollars in revenue. This is a

yearly project which produces the major analysis for developing the

Business Development Plan for the year. Recognized for my leadership

on this project.

. Delivered a suite of reports surrounding $58 million dollars in

revenue that allowed the Legal Markets Group organization better

understand their customers, sales and models. This information was

used by the business to better align the sales organization to meet

the needs of the customer.

. Led and performed analysis for strategic project sponsored by Tax and

Accounting business unit delivering $420 million dollars in analysis.

Analysis used to reorganize Tax and Accounting unit and marketing

efforts. Recognized by business for performance on project

. Perform the roll of project lead which requires coordinating

resources, documenting business requirements, technical

specifications, testing scripts, and delivering projects by required

dates.

. Provide cross sell analysis to business customers delivering valuable

analytics regarding marketing opportunities.

. Automate and standardized numerous procedures used in the Business

Intelligence department resulting in higher quality analysis in less

time.

. Provide support for Oracle Discoverer application for entire company.

. Provide data and analysis across multiple platforms for realigning

business unit to more effectively meet the need and requirements of

their customers.

. Utilized Oracle Discoverer, Toad, Microsoft Access, Microsoft Excel,

Microsoft Project, Microsoft Word extensively.

. Recognized five times for outstanding achievements.

Discover Financial Services, Riverwoods, IL

5/2002- 10/2003

Senior Associate/Project Lead, Marketing/Pricing

Responsible for implementing strategic projects for Marketing/Pricing

area, including major changes to Cardmember Agreement (Pricing area was

responsible for 50% of revenue earned annually).

. Worked extensively with the company's Law department providing

analysis for litigation purposes.

. Performed analysis on card member portfolio to define areas of fee

revenue opportunity which accounted for 50% of Discovers revenue.

. Utilized Microsoft Excel to provide analysis on various projects to

department and other business partners. Tracked Prime Interest Rate

and implemented rate changes to the card member portfolio.

. Developed and implemented an Intranet application designed to track

the binding agreement for card members by the arbitration provision.

This dramatically reduced the amount of time required to capture this

data and data entry errors. The information recorded was also

immediately accessible and used extensively by the company's Legal

department.

. Performed analysis on card member Portfolio to define areas of fee

revenue opportunity.

. Designed reports to provide upper management with analysis on the

number of card members who went into a default rate and were

reinstated to a lower rate.

Alliant Foodservice, Deerfield, IL

1996-2002

Senior Business Programmer, 5/1997 to 5/2002

Designed, tested, implemented & maintained core application used by

Alliant's sales force as the primary vehicle for order entry. Level III

support for help desk in charge of customer application and sales force.

Primary individual responsible for the design and implementation of code

updates and new features for application utilized by customers.

. Project Manager for the creation of an application designed to analyze

customer profitability and opportunities.

. Took over a stalled, nonfunctional project, and turned the project

around within one month.

. Uncovered major design flaw in the microprocessor used in Hewlett

Packard desktop. Worked with engineers at HP to test and resolve

issues.

. Developed diagnostic tools for field personnel, which drastically

reduced the amount of calls placed to the Help Desk.

. Built and maintained company Intranet site to inform field of updates,

training materials, and new software.

. Wrote training tools and presentations for field personnel.

. Performed database inquiries on Tandem for reporting purposes using

SQL.

. Designed and implemented extensive test scripts for the various

proprietary applications supported.

( Oracle 10g (web version) ( Oracle 9i (desktop version) ( Access ( Excel

( C ( C++ ( Cobol ( PowerBuilder (Visual Basic ( Assembler ( Tandem ( SQL (

MCSE ( Cognos ( Toad.

Bachelor of Science, Finance, Northern Illinois University, DeKalb, IL,

1995

CAREER STATEMENT

PROFESSIONAL EXPERIENCE

TECHNICAL SKILLS

EDUCATION

Contact this candidate