Project Customer Service

Michael Mejorada

**** *. ****** **., *****, Illinois 60714

Cell: 847-***-****

*.********@*******.***

SUMMARY

Accomplished business, system and technical analyst experienced with all

phases of System Development Life Cycle (SDLC) and programming concepts.

Over 20 years experience in creating functional and technical designs,

application development, system maintenance, and web support. Proven record

of creativity and resourcefulness in leading multiple projects and meeting

deadlines. Excellent customer reputation resulting from service-oriented

attitude. Proficient in numerous development languages/tools/hardware.

Strong communication and project management skills.

TECHNICAL SKILLS

Windows XP/Vista/7 Cobol XML C

IBM AS/400 JCL SQL CICS

WSS/SharePoint Access Visio VSS

MS Office Suite MS Project WinRunner PeopleSoft

PROFESSIONAL EXPERIENCE

Allstate Insurance Company, Northbrook, IL

1990 -

2009

Nation's largest publicly held personal lines insurer and a Fortune 100

company, with $130 billion in total assets

Business Analyst (2003 - 2009)

Supported the customer communications team on 50+ projects for auto,

property and specialty lines including boats & RV's. Received several

internal recognition awards for uncovering potential issues prior to

production releases and for recovering troubled projects.

. Business Analyst: Identified project pre-requirements/requirements;

created requirements documents, functional/technical designs and test

plans. Researched client requirements to create business rules for the

processing and generation of insurance policies. Performed unit testing

and participated in integration testing. Head Business Analyst in

multiple highly visible projects such as being in charge of implementing

the necessary infrastructure for Allstate to re-enter the Massachusetts

auto insurance market to create and sustain long-term profitable growth

in the state. In addition, led the countrywide implementation of the

FullPay product which offered customers the option to receive a

discounted premium on a bound policy.

. Technical Lead: Primary lead in a team that migrated Visual Source Safe

(VSS) to Windows Sharepoint Services (WSS) databases impacting an entire

division. For the customer communications department provided detailed

instructions, communicated updates, as well as status on moving to this

web based site. In addition, active primary lead as Department Security

Coordinator (DSC) for authorizing service requests.

. Project Management: Coordinated projects for internal team Manage

Customer Dialogue (MCD); created and maintained project plans, timelines

and documentation. Collaborated with other project managers to review and

provide high-level estimates to clients. Managed project plans using

Microsoft Project.

. Meeting Facilitation: Facilitated status, walkthrough and ad-hoc

meetings; provided solutions to business and system issues in project

design walkthroughs. Met with business clients and project technical

teams to ensure project scope and consistent handoffs of requirements

were being delivered.

. Team Leadership: As one of the few business analysts well-versed in

multiple lines of insurance, mentored and provided cross-training to 10

members of the team, including other business analysts and offshore

partners. Volunteered to participate in the Emerging Business (EB) call-

out program that directly influenced growth results, by engaging our

existing policyholders and was 1 of 15 employees recognized for results

achieved. Presented and documented a benefit/cost savings spreadsheet

that captured actual/planned benefits of all projects worked on and

encouraged other BA's to recognize their own results as well.

System Integration Analyst (2001 - 2003)

Created synergy between the Multi Access Integration (MAI) strategy and

back-end system areas. MAI strategy allowed customers to contact Allstate

via website (Allstate.com) and/or using the 1-800-Allstate toll free

number.

. Technical Lead: Performed as technical lead on multiple state rollout

assignments for the Auto Instant Quote Project (Web based).

. Subject Matter Expert: Played major role on key projects as a subject

matter expert; served as "point person" to help determine area's

involvement in major initiatives. Performed multiple queries to extract,

transform and load both SQL and XML data using PeopleSoft applications.

. Project Management: Coordinated projects involving multiple areas;

created and maintained project plans, timelines and documentation.

Collaborated with project managers to review and provide high-level

estimates to clients.

Technical Analyst (1990-2001)

Facilitated research and development of Allstate's proprietary legacy

system

. Technical Lead: Performed as technical lead, planned group projects for

migrating company's legacy system to year 2000 compliance.

. Business Partner: Worked along side business partners to develop business

requirements and analyzed systems logic to develop over 120

functional/Technical designs

. Customer service: Coordinated relationships between teams. Main

participant in on-site field and hotline support of 10,000 AS/400 users

nationwide.

Allstate Motor Club, Glenview, IL

1988-1990

Division of Allstate Insurance Co, with more than 2.5 million members, and

celebrating over 45 years to provide members with peace of mind on the

road.

Programmer (1988-1990)

. Programmer: Designed and coded a test matrix for development and log

tracking; analyzed and debugged system errors in applications and

programs

2 EDUCATION & TRAINING

3

4 Bachelor of Science in Computer Information System, DeVry University

Presidential Honor Society member at DeVry University

Business Analyst Professionals Essentials

Requirements Management - Traceability

Requirement Attributes - Framework

International Institute Business Analyst (IIBA) Training

Project Management Fundamentals

Contact this candidate