**** *. ***** *****

Country Club Hills, IL ****8

708-***-****

LARRY ROGERS

Career Summary Background in information systems as a Database Analyst. Ten years of SAS

programming experience and five years of SQL. Understand what users want with emphasis on data

extraction, import and export. Focused on solutions to help develop and maintain users

request on a timely basis. Selected areas of technical knowledge include:

Hardware: IBM 3090 Mainframe, Microsoft PC WindowsNT2000, Sequel Server, IDX

Software: Access, Excel Spreadsheet, FTP Encryption, DTS Packages, Stored

Procedures, Paradox Dos, DBMS, Table talk, JCL, MVS, VSAM

Languages: SAS, Cobol, Basic, SQL

Experience Independent Contractor, Chicago, IL 2004–Present

Surveyor (Contract Assignment)

Complete on - line questionnaires for various products and services of contracting companies.

Also participate in focus groups, on- line chat rooms, and one - on – meetings and telephone interviews. Products and services range from household products to downloading files from the internet.. Results yield data that companies use in terms of effective management to increase productivity.

McEllin & Associates Chicago, IL 2005-Present

Data Analyst

Providing multiple ad hoc reports for various companies. Using Access Database alone with

Excel Spreadsheet. Data is extracted from CD’s and floppy disk to provide the necessary

data to import into a table in Access Database and query the data to output a report or run macros in Access to output the report in Excel Spreadsheet. Reports are created weekly and

monthly.

Advocate Health Care, Mount Prospect, IL 1998–2003

Database Analyst

Responsible for reports and files that are sent to various vendors or customers.

Detail design projects are due within a daily, weekly, monthly and quarterly

timeframe. Data integrity was of the highest priority. Reports were converted from

IDX data to sequel server enterprise data. Selected accomplishments include:

Developed access reporting using macros to output several financial ad hoc reports at once.

Wrote SQL queries on IDX and Sequel Server Enterprise Manager extracting raw data.

SAS programs were written and executed to output files, datasets or reports.

Designed DTS packages in sequel to execute multiple files when execution began, files were FTP to various vendors due to sensitive data.

Developed stored procedures to capture queries and use with DTS Package.

Support Finance, Eligibility, Medical Service, Claims and Referral Department in terms of creating and developing reports that are details and results oriented.

Provide assistance to the DBA staff installing Microsoft WindowsNT2000 computer, downloading patches to wipe out viruses and taking care of printer problems.

Referral report was developed to capture services that were not rendered by the primary physicians to help saved the organization revenue.

Help to create a SQL reporting manual for those individuals who are not familiar with SQL and Sequel Server Enterprise Manager.

Developed HIPPA flow chart to show how sensitive data is process from the requestor to the contact person.

Posen School District, Posen, IL 1996–1998

Substitute Teacher

Tau Taught fourth to eighth grade using a lesson plan to schedule all course activities. Selected accomplishments include:

Developed class projects for students in the Computer lab.

Taught students a variety, of ways to study in including group participation.

Informed parents on students’ progress.

Re-enforced learning skills through game activities.

MCA Fashion Accessories, Country Club Hills, IL 1994–1996

Sales Representative

Responsible for the movement of the product in various stores such as K-Mart,

Marshals and small boutique stores. Selected accomplishments include:

Performed cold contacts by scheduling appointments with the store buyer.

Provided sample products to store managers.

Contacted the stores to ensure that products were well stocked.

American Medical Association, Chicago, IL 1990-1994

Group Leader

Responsible for medical schools correspondence on the East and West coasts.

Programming consisted of data extraction for the medical students and physicians.

Depending on the department needs, a report for business transactions was

provided. Selected accomplishments include:

Developed reports in Paradox to maintained number of student enrollments.

Wrote Programs in SAS to create a report listing, output datasets and files.

Master file used for data extraction and data manipulation.

Table talk provided quicker access to data reporting.

Wrote JCL code.

Education Chicago State University

B.A., Management Information Systems

Minor Economics

Award AHC MVP Recognition Award 2000

Commitment and Exceptional Performance

References References available upon request

Larry Rogers Page 2

Contact this candidate