Highly Trained Business System Analyst
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.
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.
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.
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.
Office Automation Assistant for the U.S. Small Business Administration – Burbank; and Assistant Manager of Bally’s Hollywood.
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