Sales Data

ROSANNE WISELY

*** ***** ***** ****: 610-***-****

Narberth, PA 19072 Email: ******@*******.***

SUMMARY

Excellent written and oral communication skills and problem resolution abilities. Ability to relate

and interact with all levels within an organization. Excellent organizational and time

management skills. Dedicated and focused with the ability to work on several projects at one

time, set priorities, and meet deadlines to achieve goals. Strengths include attention to detail,

communication skills, excellent research and writing skills, willingness to form positive

relationships with clients and colleagues at all organizational levels and to support a team

environment. Motivated by supporting functional needs to assist individuals in achieving

corporate goals. Quickly learns and applies new concepts and technologies.

Professional Experience

Careers Express, King of Prussia, PA 2006-Present

Business Support Analyst (Consultant)

Data analyst in support of a data migration to a new intellectual property management software

system including finance, patents, trade secrets, trademarks, domain names and copyrights. Patent

and invention data was loaded from old systems. Prior to implementing the new system, data was

analyzed using Microsoft Excel and Access 2007. Files were created with reformatted data and

loaded into the new system. A new online invoicing system was also implemented

Data is represented in Excel spreadsheets or Access databases

Added functionality to spreadsheets to check for duplication, discrepancies, and

formatting of data

Developed Access reports

Made decisions on data after review

Developed SQL queries to obtain requested data and develop reports

Data Analyst (Consultant)

Supported a conversion from a legacy database to an Oracle database by resolving issues related

to customer data that would not load into the relational database. Data issues were resolved using

various methods of research.

Coordinated written and oral communication between all impacted departments

Wrote correspondence concisely and accurately

Worked as liaison between business and technical groups by arranging meetings,

discussing issues and barriers, and resolving problems

Created Excel spreadsheets containing reports extracted from databases using advanced

Excel processing including formulas, formatting, exporting and importing data

Conducted extensive research on internet to verify customer information in the current

database

Updated databases with correct customer information

Learned new enterprise software for researching and updating databases

Resolved issues related to database conversion

Trained new users to use the online system to correct and update the legacy system so

that the data will be formatted correctly and load into the Oracle system

WYETH PHARMACEUTICAL, Collegeville, PA 1997- 2006

Programmer/Analyst

Supported Sales and Marketing Decision Support Systems and Customer Service. Supported and

maintained legacy systems by making code changes to COBOL programs and JCL updates.

Researched questions from clients. Received data files from outside vendors to load into system

and extracted data from system to send to clients and vendors. Developed quality assurance

procedures to validate data loads using Excel spreadsheets. Extracted data from legacy system to

load into Oracle database tables using SQL Loader on a UNIX platform

Maintained mainframe legacy systems by supporting internal customer data, sales force data,

decision support data, internal sales data, and government sales data. The batch systems were

written in COBOL. Provided JCL and systems documentation to the operations support staff.

Loaded weekly internal direct and indirect sales data from the legacy mainframe system into

the data warehouse. This data was extracted from the mainframe legacy system in the form

of a data file and loaded into Oracle tables. Business rules were applied to this data before it

was loaded.

Developed quality assurance procedures to validate data loads by comparing previous data

load to the current data load. Oracle tables were compared and differences were noted. The

tables were then imported into Excel for the business users to review.

Resolved user concerns and questions involving data issues with immediate turn-around

providing excellent customer support for two separate departments.

Extracted direct sales data from legacy databases to provide a vendor with weekly sales data.

Data was provided in the file format requested

Provided a quarterly customer data file to a vendor so that new customers could be added to

their customer database.

Represented IT on projects

Provided excellent support 24-7 with no interruption to business.

Worked with sales force teams to provide data for computing sales force expenses, setting

goals and incentive compensation. Provided monthly data files to a vendor for incentive

compensation.

Recognized for outstanding effort in support of an important Springboard Comme rcial

Excellence initiative by helping to establish a Direct-to-Practitioner sampling capability

called Wyeth Samples Direct. This new program supported requests from health care

professionals not called on by Wyeth sales representatives.

Maintained the integrated customer view request system. The integrated customer view

system gave a complete picture of a customer by providing information that was stored in the

system. A business analyst would send a spreadsheet containing the customer information

already known and a matching process gave the extra information.

RSI CONSULTING, NEWTOWN, PA 1995- 1997

Programmer/Analyst (Consultant)

Provided consulting services to Core States Bank by working on re-engineering projects.

Formulated and defined systems scope and objective through fact-finding and researching

existing system. Conducted interviews with business users to determine their needs and what

functionality they wanted added to the system. Modified existing programs when a change was

needed.

Redesigned the existing statement sent to corporate customers by making extensive changes

to existing COBOL programs, and updating the form. Information was extracted from an

IMS database

Changed the existing lock box system from an IMS database to a DB2 database

BELL ATLANTIC, Philadelphia, PA 1991 - 1995

Programmer/Analyst

Conducted a full range of programming skills including program design, program coding, testing

and debugging, and documentation for application programs and operator instructions.

Demonstrated ability to be resourceful and achieve results by working with a diverse team. Used

analytical skills to standardize systems.

Managed large systems containing local and long distance phone messages, phone rates, and

customer data.

Developed a phone rating IMS database containing the rates by country. Rates were used for

toll calls and local calling and changed based on area and time.

Consolidated three different phone company systems into one by integrating New Jersey Bell,

C&P Bell into Bell of Pennsylvania’s phone message and rating system.

Maintained phone message rating system using COBOL, IMS, IMS/DC and VSAM files.

Implemented system procedures for operations and maintained existing procedures.

Implemented a new data warehouse for customer information by converting IMS legacy

databases into DB2 tables. These tables were used on a Sybase platform with a new system

designed for customer sales representatives.

Provided support 24-7 with no interruption to business

Areas of expertise:

Skills:

Languages

COBOL, SQL

Operating Systems

IBM OS/360, Windows 2003/ NT/ XP, UNIX

Tools/Utilities

Visio, Microsoft Office Suite, IBM-JCL, IBM Utilities, File-Aid, Abend-Aid

Databases

DB2, IMS, Oracle

Education

MS in Education, Temple University, PA

BS in Math, Cabrini College, Radnor, PA

Contact this candidate