Resume

Sign in

Project Management Analyst

Location:
Elk Grove Village, Illinois, 60007, United States
Salary:
70,000
Posted:
May 31, 2017

Contact this candidate

Karl Lowery

*** ****** ****. ******* *******, IL 60169

Cell: 630-***-****

ac0kuf@r.postjobfree.com

PROFESSIONAL OVERVIEW:

Experienced Computer Systems Analyst with diverse industry experience in human resources outsourcing, mostly specializing in Defined Contributions applications. Professional expertise includes systems applications, test planning and execution, query design and execution, project management, and requirements analysis.

QUALIFICATIONS:

Programming and design skills

Cross-tier components implementation

Strong analytical and collaborative skills

Structured query language (SQL) expert

Document management

Landing page development

Web Content Management

Project management

Test Planning and Testing

GUI and tools

TECHNICAL SKILLS:

Skills

Experience

Total Years

Last Used

Workbench Conversations (proprietary application)

Expert

11

Currently using

SQL

Experienced

10

Currently using

HRO Maestro Task Management

Expert

11

Currently using

FTP Utility

Experienced

5

Currently using

Middle Office and Thunderhead Document Tool

Expert

7

Currently using

UPoint Web Configuration Tool

Experienced

2

Currently using

ACCOMPLISHMENTS:

Assisted in developing a process of monitoring system errors.

Performed root cause analysis to identify system errors and improve accuracy by 90%. Our system errors were at 1,000 when process was implemented, we were able to change the system error amount down to fewer than 100 per week.

Awarded with the Certifications of Excellence for contributions to various projects.

Improved the client-relationship statuses on two different clients. Our clients were in stability status when I joined the teams.

Received Enthusiastic Client Certificate recommendations from 3 different clients.

Began as a Setup Configuration Analyst and promoted to a Senior System Analyst.

WORK EXPERIENCE:

Aon Corporation, Lincolnshire, IL 10/2004 – Current

Senior System Analyst 10/2012 - 03/2017

System Analyst 10/2010 – 10/2012

Setup Configuration Analyst 10/2005 – 10/2010

Business Analyst 10/2004 – 10/2005

Responsibilities:

Analyze customer and stakeholder system needs, based on requirements, perform functional analysis and implemented Requirements Management Plans

Identify departmental needs and made suggestions regarding technical direction of enhancements. Various duties included:

oCreated modules using Workbench Conversations to compose modules needed for various items such as activities and edits that updated functionality for clients. This is the main proprietary tool used for setting up and allowing our GUI and web interfaces to communicated with the client’s database.

Develop SQL Queries that would create reports based on information that the client requested, such as YTD statuses and balances. Queries included Joins and Exists clauses that would pull more complex queries. Some of the SQL queries were also created as AQUA queries (Automated Query Update Application), which would update rows in the databases to primarily correct inaccurate data.

Use the Echo tool in Workbench to create test plans that were executed based on the setup requirements and expected results of the enhancements. Some of the test plans could be automated for the more routine actions.

Use HRO Maestro to create task blueprints that helped monitor and document the progress of certain stages of a project.

Use FTP Utility to send files to a third party, as well as pull mainframe files into an easier to read format. This both assisted in showing data positions on file as well as pulling information into spreadsheet type format.

Create Personal Communication Statements (PCS) with Middle Office and Thunderhead. These were such notices that were triggered from activities for on-boarding, DC activity confirmation, Account Statements, and Password or security changes. The tool would help pull specific data such as dates, balances, and other information from databases based on what criteria the activity and participant was running. For example, if a participant had data change on a file to make them eligible for DC enrollment, the pending enrollment date as well as default data would be provided on an enrollment notice.

Use UPoint Web Configuration tool to change the features and functions available to certain populations based on the participant’s criteria.

Utilized Thunderhead document tool and Business Content Studio to create forms and customize the base versions of documents to comply with specific client needs.

Created Fragments, Conditions, and Shared content with Thunderhead in order to control which text will show in which conditions. Data would be pulled from various database elements, based on the form setup in Workbench data modeling tool.

Became a Subject Matter Expert on Thunderhead and assisted in creating company documentation for training new colleagues using the tool.

Conducted training on Thunderhead and UPoint Web Configuration tools, as well as legacy tools, using Powerpoint and written documentation in both classroom and online environments.

EDUCATION AND TRAINING:

Bachelor of Science: DeVry University - Computer Information Systems 2004

Magna Cum Laude Academic Achievement Award



Contact this candidate