SUMMARY

• Experienced BUSINESS ANALYST with expertise in financial, accounting, and healthcare systems. More than 10 years experience as an analyst and developer. Additional skills include:
• 7 years as a business analyst talking to managers, writing specifications, flowcharts, process flows,
• designing IT systems, and some business modeling
• 10 years customer service skills and a good ability to express complex concepts to non-technical people
• 5 years as an IT consultant designing systems and writing documentation
• 7 years testing experience to correct problems and design systems
• 7 years experience with database relationships, schemas database structures , data mapping, tables and
• queries for creating new IT systems
• Certification in MS Excel 2007 and Access 2007 plus 5 years advanced proficiency in Word, SharePoint,
• MS SQL, and Visio. Also some PowerPoint, and Project

TECHNICAL SKILLS

• MS Products/Office Access, Excel, SQL Server, Word, HTML, Front Page, PowerPoint, Visio, SharePoint
• COBOL, DB2, CICS, VSAM

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

• Configuring the Inspro Insurance system to add/change features to produce policies.
• Learning new features of vendor written software by a third party company
• Using SQL to produce results
• Working with testing the systems we changed
• Using Excel, Word, Visio, PowerPoint, and SDLC project lifecycle

Confidential

Data Analyst

• Worked with the Sage Act database system to keep track of their membership
• Emailed membership lists to each of the groups nationwide to ask if the group was correct
• Accepted the responses from the groups and updated the Sage Act database
• Called some of the groups to confirm issues

Confidential

Business Analyst

• Dept of Transportation
• Worked with GIS to learn their system and help them with interfacing with other systems.
• Business Analyst worked to help facilitate the purchase of a new Right of Way IT system by an outside
• vendor to keep track of road changes using Word and Excel. This was then uploaded to SharePoint

Confidential

Student

• Completed many refresher classes about MS Office Excel, Access, PowerPoint, Word, Visio, and Project.
• Received certification on MS Excel and MS Access 2007

Confidential

Business Analyst-Consultant

• Worked with outside vendors to determine the cost to upgrade the clinics' EHR software for meaningful
• use . All upgrade cost information was documented in Excel and put on SharePoint.

Confidential

Data Analyst III

• Created Parts Distributor Dashboard reports and documentation using Axapta, MS SQL, Excel weekly to
• help determine profitability. Documented all changes, and new features about the Dashboards in Excel
• and put them on SharePoint. Worked with management to upgrade/design the features of these processes.
• Created Parts Distributor Scorecard reports and documentation using MS SQL, Excel, Access, and
• SharePoint to show the most profitable Parts Distributors each week. Uploaded data using MS Sql
• Management Studio Express to the database using SSIS. Documented changes and new features about the
• Scorecards in Excel and put them on SharePoint. Worked with management to make changes to this
• system.
• Created a Top Rolling 25 Parts Sales report and documentation in the company each week using Excel to
• show which parts are most profitable. Documentation about the sales report were detailed in Excel and put
• on SharePoint. Made changes for management to make better use of this process.

Confidential

Business Analyst-New Hampshire

• Created test cases in support of a Medicaid system using MS SharePoint and IBM Rational resulting a
• successful Medicaid system to sell to any State government. Documented detailed design features in Word
• and put them on SharePoint.

Business Analyst-Wyoming Medicaid

• Developed Cold Fusion/HTML Medicaid applications for Third Party Liability TPL on an MS SQL Server
• Created detail systems design documents for TPL using MS SharePoint
• Worked with Sr. Business Analyst and Team Lead to make changes to the programs.
• Business Analyst-TennCare
• Developed Claims, Eligibility, MAR, Drug Rebate, and EPSDT test cases using MS SharePoint
• Worked with the development team and supporting the client in user testing for TennCare. Documentation
• for user testing was written in Word and put on SharePoint.
• Worked as a BA as the liaison between the development team and ACS management for TennCare
• Developed Claims, Drug Rebate, and EPSDT process flows/systems documentation as required using MS
• SharePoint and Visio

Confidential

• Dept of Mental Health Developmental Disabilities
• Statistical Programmer 2
• Combined and developed a real-time complaint reports and documentation using MS Access database
• resulting in better management reports. Wrote process documentation and data flows in Word. Worked
• with manager to determine the best approach to develop the database.
• Provided statistical information to the Department about customers in need Statewide resulting in better
• management reports
• Provided Excel technical help to surveyors Statewide to better process and store information in the system
• Provided other management reports from MS Access SQL-relational databases and Excel resulting in
• better information to management. Wrote documentation for the surveyors about how to better use the
• server to store their information.

Confidential

Student

Completed many technical classes about VB.Net, ASP.NET, ADO.NET, XML, T-SQL, Crystal Reports

Confidential

Functional Analyst

• Provided needed support to Institutional Advancement, Alumni Affairs, and Finance department using SCT
• Banner with Oracle relational database to better serve the client base. Wrote documentation to serve as a
• how to document about what to do for future processing. Worked with department heads and management
• to develop the reports and provide support.
• Produced needed financial and alumni reports, queries, and documentation for MS Access SQL , Excel, and
• PowerPoint to provide management with better reports. Worked with department heads and management to
• develop the reports and provide support.

Confidential

Recruiter

• Recruited tax and audit professionals for companies from many states
• Met and talked to both clients and candidates about new opportunities and develop their careers

Confidential

Senior Programmer Analyst

• Part of development team that created the first successful and more efficient Pharmacy/Medicare
• Benefits system disease management using Cobol and DB2 relational databases mapped from flat files
• Developed new procedures to send/receive data to facilitate claims processing
• Wrote systems requirements documentation prior to systems development and helped analysts to
• system test the systems. Worked with management to determine the needed changes to the systems.

Confidential

Senior Consulting Systems Engineer

• Lead analyst for an Accounts Payable System using Cobol, VSAM, DB2 relational database and CICS
• resulting in producing overpayment checks daily to customers.
• Worked with an outside vendor to describe the Accounts Payable to be used in a data warehouse

MIKE PFEIFFER

• Developed many supporting sub-systems as required including to track Unclaimed Property for
• uncashed checks plus, divested hospitals, and Government law suits. Wrote all supporting documentation.
• Successfully completed the yearly A/P Disaster Recovery to insure successful processing after a disaster
• Used the HCA Project Management SDLC for tracking development of systems