Data Warehouse Developer

LAURE A. ROBINSON

***** *** *****, ******, ** ***33-8970, 317-***-****

SUMMARY OF QUALIFICATIONS

Exceptional design/analysis capabilities. Business Intelligence and Data Warehouse experience including

Report Dashboard building and maintenance and ETL development. Skilled at requirements gathering

and specification writing. Application administrator for Informatica and Business Objects. Proficient

with Office 2010 and software testing. Project Coordinator experience including: staff supervision/

training, configuration control, schedule/ budget estimates, technical documentation and data analysis.

Excellent verbal and written communication skills and teaching/training background. Highly motivated,

intelligent, organized, detail-oriented, expressive individual.

COMPUTER APPLICATIONS

Proficient: Informatica, SQL, HTML, Crystal Reports, MS Office Databases: Oracle, DB2,

SQL Server

Experience: ClearQuest, Visio, Hyperion Reporting, Business Objects, Unix, C#, Active Reports,

Visual Basic,

and Visual Studio

PROFESSIONAL EXPERIENCE

SOFTWARE DEVELOPER, Interactive Intelligence, Indianapolis IN, June 2011-Nov 2012

Research issues, apply and test corrections to Crystal Reports designed for analysis of call center data

on both Oracle and SQL Server. Maintain and write .net reports for current release software using

Visual Studio 2010, Active Reports 6, and C#. This involves: working with Program Managers and

developers to create written specifications, verifying data sources, stored procedures, and

transformations, then designing and testing the report prior to submission. Perform peer code reviews

for both report and database changes.

SENIOR SOFTWARE DEVELOPER, Liberty Mutual Insurance, Indianapolis IN, June 2006-June

2009

Created BTEQ and Unix scripts to support balancing and metadata processes for Enterprise Data

Warehouse. Created and updated financial reports using Hyperion Brio. Developed ETL process to

automate monthly claims metrics reporting. Created balancing scripts for Large Loss project.

Completed SharePoint training and served as site coordinator for e-collaborate site. Updated scripts to

resolve parameter file contention during monthly load process.

SOFTWARE ENGINEER, Liberty Mutual Insurance, Indianapolis IN, Aug. 2004 – June 2006

Took over ETL/Unix on-call and deployer responsibility for MIS Support team. Trained incoming

team members for on-call support. Assisted with workflow design changes to support transition to

Autosys vs. Informatica scheduler. Updated and enhanced Informatica development standards to

reflect changes and trained development teams on new requirements. Developed automated process

for TRIA monthly extracts. Analyzed and coded corrections and enhancements to existing ETL

processes. Received Bronze Award as team member for AIP project including requirements, design,

development and testing of data mart fact and dimension table loads.

PROGRAMMER/ANALYST, The HealthCare Group, Indianapolis IN, Sep. 1999 – Aug. 2004

Lead ETL developer for Enrollment portion of Data Warehouse and member of Claims development

team to support transfer of health plan member information stored in Facets. Designed technical

specifications and coded ETL mappings for several large Data Mart Fact tables. Developed

specifications and documentation and researched and resolved issues at both a coding and a source

data level. Identified a number of design flaws and suggested appropriate alternatives. Served as

Administrator, Supervisor, and Designer for Business Objects. Use Informatica, SQL and Unix.

PROGRAMMER/ANALYST, AIMCO, Indianapolis IN, Jan. 1999 – Sep. 1999

Develop and maintain financial applications and Oracle database front-end programs using Visual

Basic 5.0 and SQL in a client-server environment. Developed program to reconcile disbursement

banking accounts used by several properties. Used Crystal Reports to display and print results from

Access tables. Updated program to import A/P chargeback data from PeopleSoft to Computron.

Modified vendor matching program for use in conversion from Computron to PeopleSoft. Updated

budget program to read e-mail export request and extract actuals from Hyperion database into ASCII

file attached to reply.

LAURE A. ROBINSON

(continued)

PROFESSIONAL EXPERIENCE (continued)

SR. QUALITY ASSURANCE SPECIALIST, AIMCO, Indianapolis IN, Nov. 1997 – Dec. 1998.

Tested financial applications for conformance with requirements, standards, etc. and provided feedback to

developers. Worked with users for final user testing. Developed training documents for new applications and

assisted documentation team with writing user guides. Project lead for the quality assurance of the transition

of all corporate accounting from Computron in Indianapolis to PeopleSoft in Greenville.

PROOFREADER, Macmillan Computer Publishing, Indianapolis IN, Aug. 1996 – Nov. 1997.

Proofread computer books for grammar, spelling, punctuation, clarity, and conformance to design. Although

content validity was not one of my assigned duties, I often corrected technical errors and was commended by

the editorial staff on several occasions. I was also recognized by the department for developing a matrix to

assist production of a book type with a poor design sample enabling tracking of all issues requiring

consistency across the series.

TEACHER, Adams Twelve Five Star Schools, Thornton, CO, Aug. 1994- Feb. 1996.

Taught the Science portion of a 10th grade integrated course that also included English, History, and Art. As

a team, we developed related lessons that still met the required curriculum. I also taught Chemistry in the

Community and College Prep Chemistry to high school students. At the middle school level, I taught 7th

grade Math and Science, along with a 6th grade Keyboarding class. I developed a variety of student

evaluations and maintained accurate documentation of these using a gradebook application. I communicated

openly with parents about difficult situations.

SENIOR TECHNICAL WRITER, Computer Sciences Corp., Boulder, CO, July 1992 – Feb. 1994.

Managed conversion of documents to BookMaster and incorporation of change pages for software revisions

for the Air Force Satellite Mobile Ground System. Supervised clerical staff and estimated workload for

documentation conversion projects. Completed a large project on time and within my estimated budget.

Attended and held regular staff meetings. Became a ProcessMaster Administrator. Developed and presented

a training course for BookMaster, an IBM mainframe publishing tool.

TECHNICAL WRITER, ARC Professional Services, Boulder, CO, Dec. 1988 – June 1992.

Wrote and edited Software User's Manuals and Positional Handbooks to support the Department of Defense

Air Force Satellite Program in Script and BookMaster. Assisted with business proposal preparation and the

outline of a Software Development Methodology Manual. Received an award due to customer recognition of

the quality of my work. Provided database support for our technical library using dBase IV and did quality

assurance checks on outgoing business correspondence.

TEACHER, Science, Math, Computers, St. John's School, Longmont, CO, Aug. 1984 – June 1988.

Taught 7th, 8th, and 9th grade Science, Algebra, and Geometry. Taught computer literacy, word processing,

and BASIC to all levels. Designed lessons and evaluations to support curriculum and communicated with

parents as needed. Developed and implemented a complete Outdoor Education curriculum. Edited the

newsletters for the school and assisted with schedules for elective courses. Responsible for promotion, set-

up, and judging of annual School Science Fair. Sponsored Student Council and 9th grade graduation and

coached girls 4th and 5th grade volleyball.

EDUCATION

MASTER OF ARTS DEGREE in Psychology with emphasis in Behavioral Genetics and Statistics,

University of Colorado, Boulder, CO

BACHELOR OF ARTS DEGREE in Biology and Psychology, cum laud, Marian College,

Indianapolis, IN

TEACHER CERTIFICATION in Secondary Science and Math, University of Colorado, Boulder,

CO

Contact this candidate