SUMMARY:

• Business and technical requirements analysis and documentation
• Test planning, test case development and execution
• Training documentation and support
• Process improvement and project management

TECHNICAL SKILLS:

• Sharepoint, Cisco Jabber/Webex, Skype Android Studio
• Crystal Reports ePiphany (Infor)
• Microsoft Excel
• Microsoft Expression Web
• Microsoft Office Suite
• Microsoft Project
• MS - SQL/SQL Server Management Studio
• Oracle/PL-SQL/Toad
• Rally (Agile)
• Rational ClearQuest
• Siebel 7.5 Tools & Configuration Apps
• Test Director
• SoapUI
• Visio
• Visual Basic for Applications

PROFESSIONAL EXPERIENCE:

Confidential

Professional Services Consultant

Responsibilities:

• Ongoing development of a public safety/situational awareness Android app using Android Studio and Google Maps APIs
• Repurposed unused Windows desktop PC to function as a web server running LAMP stack (Linux/Ubuntu 12.04 operating system, Apache2 web server, MySQL database and PHP scripting language)
• Assisted colleague in prototyping live-streaming web sales demo for car-sharing startup company:
• Using OBS (Open Broadcasting Software), mixed previously filmed street-level footage of various locations with live demonstration video against a Chroma key green screen
• Set up Raspberry Pi 3 computer running LEMP stack (Linux/Ubuntu Mate 16.04, NGINX web server, MariaDB/MySQL, PHP) to function as a private RTMP video streaming server. Server hosts a sales demo web page with embedded JWPlayer streaming Flash video in near real-time (latency of under three seconds)

Confidential, Minneapolis, MN

Data/Business Analyst

Responsibilities:

• Using Agile methodology: documented and managed requirements for various health plan product automation projects. Facilitated meetings with project stakeholders. Tracked progress using Rally. Participated in QA testing and issue management
• Managed data and enhanced HIOS ID (Health Insurance Oversight System) database systems for on- and off-exchange health plans. Developed and maintained procedural documentation on HIOS data systems. Researched HIOS data errors and assisted in ongoing error resolution activities for various platforms including PRIME, NICE, PULSE and FACETS
• Analyzed nationwide employer group and subscriber data and built queries to generate plan discontinuance notification mailing lists in compliance with the Patient Protection and Affordable Care Act (PPACA)
• Managed monthly and quarterly mailing initiatives including assisting with notification preparation, submitting notifications and mailing lists for print fulfillment and status tracking
• Assisted with reconciliation of corresponding Marketing and Underwriting plan templates submitted to government Health Benefit Exchanges
• Completed and/or reviewed data release registration processes and documentation for release of protected health data to outside vendors

Geospatial Consultant

• Assisted with enhancements to client Trip Planner web application using deCarta’s proprietary LBS platform, RESTful web service library and L2 geo-search engine
• Facilitated JAD discussions and documented functional requirements for application enhancements

Geospatial Consultant

Responsibilities:

• Launched project to in corporate pop-up 360° Virtual Tour images to existing Travel Planning application on customer facing website
• Developed HTML proof of concept demo using deCarta mapping web server with Javascript enhancements
• Trained staff on configuration and use of 360° panoramic lens and camera equipment
• Prepared reference documentation detailing equipment set up, recommended photo shooting techniques and image processing methodologies

Confidential, Minneapolis, MN

Data Analyst

Responsibilities:

• Improved queries for identification of undesired characters in campaign message body field (using regular expressions in Oracle)
• Enhanced and migrated campaign tracking application from Access 2003 to 2010
• Completed and documented data release service re-registration process for eAMP data feeds
• Reworked monthly active campaign Excel report (added viewer functionality to facilitate review of HTML message body content)

Geospatial Data Conversion Specialist

Responsibilities:

• Converted regional and property boundary and street number data between proprietary formats for all Australian territories (MapInfo TAB Format to Rich Map Format) for compatibility with deCarta Drill Down Server platform
• Provided suggested styles and display level configuration for RACQ trip planner Web application
• Developed process documentation and trained staff on data conversion methodology

Confidential, Minneapolis, MN

Business Analyst/Data Analyst/Test Analyst

Responsibilities:

• As part of client on-boarding process, analyzed client data, and reviewed validation and error reports to facilitate data integrity, error correction and loading into Medicare reimbursement data warehouse.
• Collaborated with internal technology and external client contacts to drive the implementation process, assure appropriate data formatting, correct data issues and errors
• Periodically reviewed incoming Production client data to ensure continued compliance to established data format specifications
• Verified all expected data files from clients are received in a timely manner and remedy if required
• Reviewed and maintained data file inventories, production schedules, and issue status databases
• Developed client on-boarding end-to-end process flows and documentation
• Developed and executed web service testing plan, test scripts and defect reporting for AARP patient information/survey portal
• Liaised with development and business teams to document, correct and retest defects

Confidential, Green Bay, WI

Business Systems Analyst

Responsibilities:

• Analyzed, researched and developed cost and benefits estimates, business cases and requirements documentation for multiple customer self-service improvement initiatives (Web and IVR) for the purpose of increasing positive customer experience while reducing total call center contacts
• Facilitated and documented JAD sessions, prepared use cases, test plans and scripts, coordinated and lead testing efforts, managed defect tracking and resolution

Confidential, Lake Forest, IL

Senior Consultant

Responsibilities:

• Analyzed source data systems and ePiphany (SSA Outbound Marketing) datamart architecture, documented and oversaw implementation of change requests for message campaign process improvements. Developed comprehensive data dictionary
• Designed, developed and tested Siebel SmartScripts for automation of Call Center incidents via the Web (Siebel eService) to improve quality of data collected and reduce number of follow-up clarification calls between client and support staff
• Trained and supervised application test team members on conducting CVP data verification and voice recognition validity testing. Improved and documented testing process. Managed and reported daily test results and productivity estimates to account management team
• Conducted analysis and prepared requirements documents, process mappings and activity diagrams for marketing campaign projects. Developed macro-powered Excel spreadsheets for data tracking and trend analysis. Managed and improved sales lead generation enrollment and withdrawal process for agents. Coordinated process improvement initiatives for MC&L (Marketing Campaign and Leads) production support team with respect to monitoring and balancing outbound lead volumes, managing and tracking issues and their root causes, and improving file handshaking process between systems.
• Conducted site visits to principal client locations, interviewed and observed call center staff with respect to current technology/telephony challenges. Assisted with documentation of baseline technology architecture and acted as liaison between client contacts and technology assessment team
• Improved existing US Postal Service Siebel Smartscripts to streamline flow and minimize page count. Revised and enhanced existing reference materials for in-house developed call center agent scripting system by assimilating complex application development concepts and feedback from users into straightforward, logically organized training and reference documents
• Researched requirements and developed technical specifications based on JAD session outcomes. Configured Siebel Call Center administrative attributes including lists of values, predefined queries, group administration, and roles and responsibilities. Designed/modified and documented application elements (business components, applets, views, screens) using Siebel Tools
• Trained and managed a team of test analysts on testing methodologies and call center systems applications including Siebel ePharma 7.5, I3 telephony suite, Witness call recording, Interactive Recorder, and Totalview workforce management and acted as liaison between Testing and Development teams. Developed MS Access-based test tracking tool for test case creation, system requirements mapping, defect tracking and reporting in compliance with client validation requirements. Acted as liaison between document authors and Validation Coordinator to ensure that all software development life cycle deliverables complied with current FDA-mandated validation requirements. Participated in preparation and review of System Requirements documents
• Developed MS Access-based PMO reporting tool using data exported from Rational ClearQuest database, developed public queries and user-customizable reports within ClearQuest application using Crystal Reports. Managed project critical paths and interdependencies between project releases. Optimized and documented current MS Access-based VRU reporting tool to improve ETL method and enable processing extremely large numbers of VRU Call and Transaction records over multiple months. Developed volume and utilization reports in Excel updateable via ODBC links to MS Access. Modified, enhanced and customized MS Access PMO database tool to include tracking of human resources, travel, equipment and supplies expenses, and budget reporting based on user-modifiable queries. Managed and reported on project related issues and trained permanent client staff member on PMO administrator responsibilities
• Modified, enhanced and customized MS Access PMO tool to include inter-project milestone dependency functionality, cross-program tracking capabilities, customizable milestones, issues and action items reports, automated milestone/project health calculation, automated data table archiving and user-friendly record navigation. Documented, tracked and assisted in resolution of project issues and action items

Confidential, Brookfield, WI

Associate Consultant

Responsibilities:

• Assisted in design of prototype e-commerce web site for a local catalog retailer dealing in brand name logo apparel
• Developed user requirements, use cases, objects and associated models for an internal corporate document management application
• Attended instructor-led training and engaged in self-paced CBTs for MS SQL Server 7.0 Administration and Implementation, Rational Rose and the Unified Modeling Language, Object Oriented Analysis and Design, Visual Basic 6.0, SilverStream, NetObjects Fusion, Symantec Visual Page and Java

Database Project Intern

Responsibilities:

• Analyzed, designed and tested enhancements to a cross-platform, client-server ordering system for an international telecommunications client using ACI 4th Dimension (cross-platform, RDBMS development tool)
• Designed and implemented a Web-accessible interface for a switch auditing system
• Prepared project documentation and acted as liaison between For Solutions development team, customer IT staff and end users
• Designed interface and contributed to programming code to a database updating application for compliance with national (UK) telephone number conversions
• Expanded knowledge of issues involved in Macintosh and PC cross-platform systems development

Confidential, Milwaukee, WI

Facilities Coordinator

Responsibilities:

• Designed and maintained database applications using MS Access to organize and monitor current property leases and critical dates, environmental remediation projects, foreclosed real estate status, building renovation projects, signage procurement projects, internal Architectural and Design services billing, and furniture and equipment inventory
• Interpreted, abstracted, composed and revised lease documentation and managed rental rate changes
• Determined specifications and administered bidding, purchase and installation of interior and exterior M&I Bank signage in conjunction with acquisition, conversion and remodeling projects
• Maintained procedures for building evacuation, disaster recovery and business resumption

Confidential, Milwaukee, WI

Assistant Supervisor

Responsibilities:

• Supervised six employees in the functions of purchasing, budget monitoring, statistical reporting, billing for services, and building operations for a regional check processing facility
• Compiled $7.0 million capital and expense budget annually, facilitated annual product re-pricing activities
• Created and maintained macro-powered Lotus 1-2-3 spreadsheets to analyze and track monthly expenses, capital expenditures, revenue, profit and loss position, asset inventories, and depreciation data
• Prepared monthly volume, productivity, expense and revenue forecasts
• Obtained bids and negotiated contracts for capital asset acquisitions, facilities remodeling, equipment rental/maintenance, purchased other services and supplies
• Coordinated and conducted staff training and contributed to development of procedures manuals
• Responded to staff PC hardware/software queries and troubleshooting issues and performed functions of Assistant LAN Administrator