STEVEN HAGSTROM

**** ********* **** • Libertyville, IL 60048 • 847-***-**** • acu370@r.postjobfree.com

PROFESSIONAL SUMMARY

Strong experience in facilitating Joint Application Development (JAD) sessions to gather requirements. Proficiency throughout the complete SDLC (software development lifecycle) including requirements definition, SWOT analysis, business analysis. Highly skilled with Waterfall, Scrum and Agile SDLC methodologies. Polished written communication skills; adept at preparing business requirements documents, functional requent irements specifications, system design specifications, and project plans.

Key Qualifications:

Good skills with writing and using SQL to access data warehouse database and report on information for the business application.

Consummate strengths in creating use case and test case scenarios, system flow charts, and dataflow diagrams. Significant expertise in software defect tracking, reporting and swift resolution.

PROFESSIONAL EXPERIENCE.

From July 0f 2015 to current

I have been a stay at home dad while working on taking some online classes and improvement and furthering my career.

Business Analyst March 2015 – July 2015

King Limousine (As independent recruiter) Mount Prospect IL

Conducted JAD sessions to develop a working plan for development new Accounts payable system, as well as new scheduling tool so drivers have less empty rides to and from airport.

Scheduled business planning meetings to plan and implement changes in existing software to improve billing and getting faster response.

Wrote and developed Access reports using SQL to create reports on drivers and customers.

Developed client specifications for new projects, scheduled project with development to insure the completion within client project timeframe; designed and made changes to client forms and re indexed. Planned several phased-in changes for client product changes and new releases..

Business Analyst Nov 2014 – Jan 2015

CIGNA Healthcare (Randstad Technologies Contract) Chicago, IL

Worked with Cigna Healthcare systems to identify ways to automate the way to report to the state all Medicare and Federal being covered by Cigna heath system. Using Microsoft access to create reports for client. Met with clients to identify the Healthcare Waivers and ways to count these patients in the different waiver types. Wrote and developed SQL data query in Access to validate Medicare and state reports.

Worked specifications for HR system to be able to update employee training and education changes. Added ability to add completed certificate tracking.

Operations Analyst April 2014 – August 2014

CVS/Caremark Buffalo Gove, IL

In charge of scheduling and running of CMS required to report the data back to Medicare and Medicaid, and place orders back into Re-cycle work baskets; ran reports to validate and check for data accuracy, and tracked Medicare claims as they are processed to prevent errors. USING SQL in Access to create user reports. Worked on new business analysis of Med D client specifications; scheduled changes for Med D client projects.

Business Analyst Oct 2013 – April 2014

Chase Bank (Tekmark Global Contract) Chicago, IL

Work directly with customers on forms design, and field indexing for entry of customer data; updated user documentation with necessary changes to business process.

Scheduled business planning meetings to plan and implement changes; managed several program update projects. Wrote and developed user acceptance testing for government projects, as well as data flow diagram charts for the government lock box system.

Developed client specifications for new projects, scheduled project with development to insure the completion within client project timeframe; designed and made changes to client forms and re indexed.

Planned several phased-in changes for client product changes and new releases.

Conducted several JAD sessions gathering user requirements, use cases, and building BRD (Business requirements documents)

Business Analyst June 2013 – Oct 2013

Contract position from MVP Abvie Abbott Park Ill

Worked on two projects as a Business analyst, working with Global Medical to report off label to support their agreement with the office of Inspector General. As well as the switch over from Hyperion database, to IBM TM1 for their account systems, and the building of two new cubes, Wrote Data flow diagram help identify gaps in the data base.

Business Analyst Contract position from Manpower April 2012 - June 2013

Abbott Laboratories Abbott Park Ill

Worked extensively with development of use case scenario’s as well as the use of Visio and all Microsoft products. Worked as an integral member of the Human Resources team developed and wrote both functional data and business requirements for the Human Resources Proxy and the People Search process for use with Abbott’s People Search process

Business Analyst April 1999 – July 2011

CVS/Caremark Buffalo Grove, IL

Managed both medium and small projects with teams from offshore and local.

Worked on a labeling project for prescription medication and updating of bar coding on the label to a new format, Extensive testing was preformed to meet all HIPA requirements. The project was built in multiple phases due to the complexity of the project. Label testing had to be extensive because changes to Prescription number and movement of the different parts of the prescription label.

Used ITIL services to manage and process service request for the Mail Order system to process request to fix problems with the system and scheduling changes. Developed and wrote use case scenarios and dataflow diagrams. Also wrote several business requirements, System and UAT test procedures.As integral member of data warehouse team, supported multiple sales projects to enhance system operations and sales force automation; wrote several SQL queries to report on the customer and prescription history.

Actively supported CVS Links application system which allows Mail Order pharmacies to enter and process prescriptions; applied strong interpersonal skills toward facilitating cooperative and productive efforts among all levels of management and cross-functional personnel. Defined requirements for Auto Letter and developed innovative system to distribute letters to patients and doctors regarding prescriptions.

.

EDUCATION

Bachelor of Information Technology (Digital Investigations) Graduated: 2014

American InterContinental University Schaumburg, IL

CERTIFICATIONS

PMP Certification Completed 2012

MicroTrain Northbrook IL

ITIL version3 Certification Completed 2012

MicroTrain Northbrook IL

Master Certificate in Business Analysis Obtained: 2011

Villanova University Villanova, PA

TECHNICAL SKILLS

Operating systems: Windows 7, Microsoft Office (Access, Word, Excel, PowerPoint), Microsoft Project, Project Workbench, Visio, DataXpert, QMF, IBM Fault Analyzer, IBM Tools DB2 Administration, DB2 Table Editor, Microsoft SQL Server, MySQL, Mercury Test Director, HP Quality Center, HP Service Manager, SharePoint, Agile, Scrum ( working on scrum master certification)

Contact this candidate