Peter K. Studner Associates - Corporate Sponsored Outplacement Services
Home Outplacement For Recruiters For Job-Seekers Resources for
Super Job Search IV
French
Connections
For Our Clients Maps to Our Offices

Peter K. Studner Associates, Inc.
Recruiters: to contact this person, please note the candidate's code
and then fill out our
FORM.


Highly Trained Business System Analyst
03.481.G.09

A highly trained business systems analyst with 13 years of progressively increasing responsibilities in developing systems tools for analyzing databases, transitioning company data warehouses, analyzing and repairing software, documenting database maintenance, and providing executive benefits and corporate-owned life insurance production support for a leading benefits management company.

Expertise includes outstanding skills in automation, telecommuting, software analysis and repair, documentation, transitioning databases, development of benefits production tools, converting, and database maintenance.

EXPERIENCE

MullinTBG, a Prudential Company, Los Angeles, California                                        1996-2009

Quality Assurance Analyst (2008-2009)

Tested high-volume transactional products in several platforms for software functionality, integration, performance, usability and security for a leading retirement benefits subsidiary of a Fortune 500 insurance company. The company’s Oracle database stores benefit and insurance data for 65,000 participants, including senior executives of major U.S. corporations.

  • Worked on defining and implementing test strategies, design, documentation and plans for all assigned projects.

  • Gathered requirements from different users and worked closely with database administrators in developing database upgrades that enhanced productivity by 30%.

  • Worked closely with the development team to determine appropriate solutions for addressing software anomalies and/or implementing improvements.

Business Analyst (2005-2007)

As a result of the merged between Mullin Consulting, Inc. and TBG Financial in 2006, the Mullin database (an SQL server) was converted into TBG’s database (Oracle Enterprise). Worked as the project manager with three other business analysts, converting client and fund investments information. The database transition consisted of 305 clients, 602 plans and 40,000 participants.

  • Managed, monitored and maintained each plan’s portfolio daily valuation to reflect the participant’s daily balance on the company’s database and website.

  • Provided production support during the implementation of MullinTBG’s internal and web-based applications.

  • Performed custom data retrieval from Mullin’s database and made changes directly into the database using SQL or PL/SQL prior to Mullin’s merger with TBG Financial.

Senior Associate I (2003-2005)

Worked as project manager developing a new dataloader tool for insurance and benefits data.

  • Wrote specifications for client and server validations for the error log. This report identified dataloading errors and saved time in locating errors.

  • Worked as project manager, developing a new dataloader tool for daily fund investment prices, rates and dividends. This included the writing of specifications for client and server validations.

  • Managed the manual calculations of fund returns for benefit statements and the website.

Senior Associate II (2001-2003)

As a result of the merger between Mullin Consulting, Inc. and MCG Chicago in 2001, worked as project manager converting insurance data from the MCG database into Mullin’s database. The transition included 100 major clients and 20,000 participants.

  • Worked closely with the Crystal Report Business Analyst in designing and developing custom insurance reports for the company’s clients.

  • Managed the loading of daily and monthly insurance company net asset values and fund returns into the system and website.

  • Managed gathering general insurance fund information and posted it to the company’s website.

Associate (1999-2001)

Led the conversion data of plans for more than 200 clients from an old Paradox system to a new SQL system.

  • Worked as Systems Administrator, configuring and setting up insurance and client information for existing and new plans. Controlled security access for databases.

  • Managed loading insurance and benefits data into the system.

Analyst (1997-1999)

Worked as the Client Administrator, providing clients with monthly insurance, benefit reports and information about their plans.

Junior Analyst 1996

Worked on client enrollment projects, underwriting activities and relations with insurance companies.

PRIOR EXPERIENCE

Office Automation Assistant for the U.S. Small Business Administration – Burbank; and Assistant Manager of Bally’s Hollywood.


EDUCATION

DeVry University, Long Beach, California

Bachelor of Science, Computer Information Systems, GPA 3.59, Dean’s List, 2005

Los Angeles City College, Los Angeles, California

Associate of Art, Business Administration, 2000
Associate of Science, Computer Technology, 2000

Computer Learning Center, Los Angeles, California

Diploma, Computer Systems and Programming, 1996

AWARDS AND SKILLS

Employee of the Month: 1996, 1997, 2003 – MullinTBG

Languages: English/Spanish Bilingual

Software Languages: SQL, PL/SQL, Crystal, Visual Basic, C++, HTML, VP Script

Super-Job-Search is a registered trade mark by Peter K. Studner. All rights reserved.
Copyrighted © Peter K. Studner 1997-2006
http://www.superjobsearch.com
Los Angeles - Burbank - Westlake Village - Irvine
Mailing Address: P.O. Box 241957, West Los Angeles, California 90024-9757
(310) 470-6688 - FAX (3