SUMMARY:

• Technical Business Analyst with 11 years experience as a Business Analyst and 3 years experience in SQL Programming and HR/Payroll Support. Excellent analytical and problem - solving skills. Able to contribute to a project team at all points in the system life cycle. and experience in the following technologies:

TECHNICAL SKILLS:

Hardware: IBM, PC, and Macintosh platforms

Database: Oracle (virtual and physical), AS400, and Unix

Software: PAM for Securities, PAM for Mortgages, Eagle/PACE, SAP, MS SQL Server, Microsoft Office Suite, FactoryTalk Transaction Manager, MIDL Data Configuration Manager, VMware, Lawson HR/Payroll, Project InVision Time Tracking and Repository, Allaire Cold Fusion 5.1, Oracle Portal 9i, FrontPage 2000, DreamWeaver, Developer and Designer 2000, NetMeeting, Crystal Reports, PeopleSoft HR/Payroll, MS Access, and Adobe

Languages: Informix 4GL, SQL, SQR, ColdFusion, JavaScript, HTML, Oracle WebDB, Visual C++, Cobol, DBL, RPG, and ASP

PROFESSIONAL EXPERIENCE:

Confidential, West Des Moines, IA

Business Systems Analyst

Responsibilities:

• Develop and implement client deliverables by conducting discovery sessions, gathering data, performing data analysis, and creating functional requirements documentation.
• Conduct business case analysis by
• Facilitate discussions to gather requirements
• Research to understand the business
• Defining the scope and objectives
• Developing and documenting system processes and workflows
• Writing, executing, and validating test cases
• Assist project managers, business users and developers in researching issues resulting in the modification of existing systems, processes, and information.
• Design, document, and implement changes to the production environment.
• Share project documentation with the team using Sharepoint.
• Run adhoc SQL queries for data requests from business users and department managers.
• Helped with the integration of two company’s processes, systems, assets, and data.
• Support and upgrade PAM for Securities trading application.
• Support and upgrade PAM for Mortgages loan application.
• Support the Eagle/PACE reporting application.
• Execute month end close activities every month.

Confidential, Columbus, NE

Business Analyst

Responsibilities:

• Saved Confidential hundreds of thousands of dollars using PLC data collection to: monitor up/downtime of machinery to improve productivity. send auto-email alerts when preventive maintenance is needed to prevent/mitigate production downtime. send auto-email /text message alerts when chemical readings fall outside set limits.
• Automate data flow to display on large flat screen monitors in various departments so managers, shift managers, and employees can see how their machines are performing at all times.
• Gather and Define requirements, analyze and design to specifications, and validate the data being collected and reported.
• Created workflow diagrams in Vizio.
• Troubleshoot plant floor printing issues as necessary.
• Create and print barcode labels as necessary for various departments.
• Meet monthly with department managers to prioritize the data collection work and provide project status updates.
• Upgraded the data collection software to improve system stability, functionality, and performance.
• Gained experience using VMware while working with virtual servers.
• Assisted with annual inventory data upload from hand-held scanners to the database so Accounting can run metrics.
• Took the initial CFR21 - Part 11 (FDA software compliance for electronic records)
• Helped troubleshoot issues and pending upgrade to the KRONOS Workforce Manager application.
• Carried a pager on rotation and addressed production issues that required immediate attention.

Confidential, Des Moines, IA

Business Analyst

Responsibilities:

• Saved Wellmark tens of thousands of dollars being paid on duplicate claims.
• Improved claim processing capacity from lines per claim.
• Defined and Analyzed Requirements from the Business Units.
• Documented High Level & Detailed Requirements, Estimates, Scope Changes, and Test Plans.
• Collaborated with Business and Technical resources.
• Developed and executed detailed System Integration test plans.
• Ran adhoc SQL queries to find test claim data during system integration testing.
• Assisted the Business Units with their UAT work as needed.
• Built a customer billing/invoicing and reporting program in Access for the EC Solutions department.

Confidential, Des Moines, IA

Programmer / Analyst

Responsibilities:

• Supported the Lawson HR/Payroll (SQL based) systems at Meredith Corporation for 2 years.
• Coded system changes in SQL based on business requirements.
• Performed unit testing on the system changes.
• Developed Meredith's online time tracking application.
• Designed and maintained Meredith's intranet website.
• Met weekly with HR and Payroll staff regarding project status, upcoming business needs, and production issues.

Confidential, Fort Dodge, IA

Webmaster

Responsibilities:

• Designed web pages for an online music gear auction site, Musichotbid.com using ColdFusion and FrontPage 2000.
• Scanned photos of music gear and uploaded those images to the auction site.
• Created animated images using JavaScript.
• Updated auction website on a daily basis.
• Updated daily featured auction/mall items.