Larry's Resume
Resume:
Country Club Hills, IL ****8
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