SKILLS SUMMARY

More than fifteen years of experience in data analysis, data management and validation, database development, web applications development and needs assessments for the State of Illinois Department of Public Health and Walmart Corporate Compliance. Strong background in data analysis and statistical reporting, web-based applications and database development and management, geographic information systems (GIS), graphic design, end-user training and support documentation and project management. Advanced experience in the following languages and software; RSA Archer eGRC versions 4 and 5, Tableau version 7, Microsoft Office (Access, Excel, Word, and PowerPoint), PeopleSoft, Remedy, Visual Basic script, active server pages (ASP), hypertext markup language (HTML), cascading style sheets (CSS), JavaScript, ArcGIS and MapInfo.

EXPERIENCE

August 2012 to Present

• Serve as systems coordinator, developer and reporting analyst responsible for enhancing and maintaining the Early Warning System, the Product Removal Tracking System and other systems used throughout Product Safety and Compliance. Responsible for creating a data transformation process and reporting system to identify new trends in injury hazards and property damage hazards associated with the sales and consumer use of consumer products sold at Walmart stores, Sam’s Club and online stores.
• Responsible for identifying metrics and creating new reports based on metrics identified
• Responsible for assisting the Product Removal Manager with conducting product removals as CPSC recalls or product removal requests are received
• Provide training and technical assistance to end users of all systems and software used throughout the company
• Leverage Archer, SharePoint, Tableau, and Microsoft Access to:
• Create a new database using Microsoft Access to track and monitor product removals and facility responses
• Developed an Archer solution to track and monitor suppliers, product testing results, concessions and violations
• Leverage Tableau to create a new reporting system in order to conduct data analysis using multiple data sources; consumer product reviews and complaints, products recalled or withdrawn, products causing property damages or injuries and product testing results
• Created and implemented a product supplier scorecard by identifying, defining and developing metrics

Compliance Systems Manager
Confidential Bentonville, Arkansas

January 2011 to August 2012

• Serve Corporate Compliance Home Office and Field Leadership by orchestrating, building, implementing, and supporting custom system solutions, providing technical service and analytical reports to all Compliance subject matter areas in order to mitigate and proactively identify regulatory risks and resolve system and process opportunities
• Leveraged Archer, Business Intelligence, SharePoint, Tableau, and existing ISD solutions to:
• Develop questionnaires and dashboards for the purposes of conducting Compliance audits at Walmart stores, Sam’s Clubs, Home Office buildings, distribution centers and return centers
• Develop an application and created reports for tracking and mitigating highly regulated products containing volatile organic compounds as required by Product Safety Compliance
• Developed Archer solutions and applications to solve Sam’s Club Compliance Weekly Food Safety Assessment
• Developed Archer questionnaire for California and New Jersey Pricing Accuracy
• Developed questionnaire for conducting audits specific to product recalls effectiveness
• Developed Archer application according to local regulation to track and monitor emergency fire pump diesel engine run-time logs for Environmental Compliance
• Facilitate numerous questionnaires/audits for California Environmental Compliance Team and Walmart Home Office buildings
• Provide enriched analytics and data automation by combining multiple data sources using Tableau, Archer and Microsoft Office Products
• Climate & Execution Thematic Maps and Data Analysis-
• Developed a mathematical methodology and database which combines data sets and metrics from all Compliance areas in order to conduct detailed analysis and determine stores’ and clubs’ regulatory risk profile. Results are published using analytical software in a dashboard view for easy access at end-user level.
• Identified, defined and developed metrics for Product Safety & Compliance in order to create a reporting system in order to determine product safety risks and product category risks
• Analyze customer product reviews and product complaints data to identify risk or increases in injury or property damage incidents
• Prepared visualization of OSHA visits and violation study
• New Jersey pricing investigations thematic maps and data analysis
• Regulatory visits study for each Compliance subject matter area
• Risk Management heat maps and grids
• Assisted Director of Weights and Measures Compliance by creating Archer dashboards to display numerous reports from numerous applications
• Enhanced the Climate & Execution reports by simplifying and automating the data collection and calculation process and migrating the final report from paper format to a web-based solution
• Provided Compliance Dashboard technical support to all Walmart associates
• Assist Compliance Subject Matter Area experts by editing, reviewing and documenting actions assigned to stores and clubs
• Publish and manage tasks for stores and clubs to complete
• Provide technical assistance and support to Home Office based associates, Field Team associates, store managers, personnel managers and asset protection managers and coordinators
• Completed Leadership Foundations for personal and career development

Springfield, Illinois

March 2004 to January 2011

• Served as the State of Illinois Primary Care Officer by managing the State Primary Care Office grant funded by the United States Health Resources and Services Administration (HRSA)
• Prepared and managed the annual budget of $262,000 for the State Primary Care Office Program
• Worked cooperatively with HRSA’s National Health Service Corps (NHSC) and Office of Shortage Designation to increase access to health care for United States residents
• Informed and assisted local health organizations with NHSC programs and assisted them to become NHSC qualified
• Assisted health professionals by identifying job opportunities throughout Illinois
• Provided technical assistance to local health organizations to assist with recruiting and retaining health care professionals to promote and improve access to health care
• Worked cooperatively with the Illinois Primary Health Care Association, Illinois Critical Access Hospital Network and the Western Illinois Area Health Education Center to increase access to healthcare in underserved areas throughout Illinois
• Reviewed each organizations annual grant application and prepared grant agreements
• Monitored and verified compliance for all grantees’ objectives
• Served as the Health Professional Shortage Area Data Analyst by conducting community health needs assessments to identify areas and population groups throughout Illinois having limited access to health care
• Prepared and submitted Health Professional Shortage Area designation applications and Medically Underserved Area/Population designation applications to the United States Health Resources and Services Administration (HRSA) as directed in HRSA’s Federal Register
• Conducted state-wide surveys and worked with state agencies to identify and create a master database of all primary medical care physicians, dentists, psychiatrists and licensed core mental health providers in Illinois.
• Analyzed and defined rational health care service areas throughout Illinois based on socioeconomic demographics, public transportation routes and private traffic patterns
• Conducted contiguous area analysis to determine if health care is accessible by analyzing socioeconomic demographics, healthcare provider reports, and potential physical barriers in contiguous areas to determine if healthcare resources are available
• Reviewed local health clinics’ NHSC Recruitment and Retention Applications and provided the NHSC with the State of Illinois’ recommendation for approval
• Reviewed HRSA’s proposed rule change to the Health Professional Shortage Area and Medically Underserved Area/Population designation process, submitted comments, conducted and presented the impact analysis for the State of Illinois
• Created, managed and enhanced a mapping solution used by the Center for Rural Health staff to assist with automating program functions
• Designed, developed and produced the web-based mapping solution for the Primary Care and Specialty Physician Scarcity Areas in Illinois
• Responded to public inquiries and data requests regarding health professional shortage areas, socioeconomic demographics, primary medical care providers, dental providers and mental health providers
• As the Information Technology Coordinator, developed, maintained and enhanced databases and GIS systems, and managed electronic equipment inventory
• Used Microsoft Access to design, create and implement databases for tracking and reporting applicants and participants in four scholarship programs and the J-1 Visa Waiver Program
• Developed and maintained the web-based application for submitting applications to the Nursing Education Scholarship Program. Automated the application submission process and award notices
• Developed a complex database to track and monitor grant recipients, their multi-year project status, and automated annual reports to verify compliance of grant objectives
• Provided technical assistance to staff on Microsoft Word, Excel, Access, PowerPoint, Outlook, ArcGIS ArcMap, MapInfo, GroupWise e-mail and Corel Suite.
• Managed web site content for the Illinois Department of Public Health, Center for Rural Health.
• Automated grant agreement documents for all scholarship recipients and grant recipients
• Updated statistics and provided fiscal reports for all programs managed by the Center for Rural Health
• As a special project, used ArcGIS ArcMap to develop a mapping and tracking system to monitor compliance of food safety inspections at the Illinois State Fairs held each year from 2007 through 2010. As a result, the map displayed vendors needing routine inspections, identified the vendors having critical violations and identified routes for the inspectors
• Tools include Microsoft Office (Word, Excel, Access, PowerPoint, PhotoDraw and Outlook), Visual Basic script, active server pages, cascading style sheets, ArcGIS ArcMap, MapInfo and GroupWise e-mail

Confidential Sherman, Illinois

June 2003 to January 2011

• Served as a consultant to small business owners to design, develop and produce superior web-based applications and web sites
• Designed and produced professional business products to promote and enhance clients’ business production. Products produced include custom DVD promotions, logos, flyers and business cards
• Provided consultation to various companies throughout Illinois and Missouri. Businesses consulted included realtors, construction companies, professional cleaning services and private not-for-profit organizations
• Tools include active server pages, cascading style sheets, Visual Basic script, Microsoft Office (Word, Excel, Access and PowerPoint), MotionArtist Flash and Pinnacle Studio Ultimate

Confidential Springfield, Illinois

April 2000 – March 2004

• Collected and maintained data from over one hundred data sources to provide a web-based health surveillance system, known as the IPLAN Data System. The sole purpose of the IPLAN Data System is to determine the health needs and priorities for all communities in Illinois. Data system was written in FoxPro and data was stored in DBF files
• Maintained and enhanced the FoxPro desktop version and created a new web-based application using active server pages
• Provided technical support to end users of the IPLAN Data System and to staff on Microsoft Office. Technical support was delivered by telephone, e-mail or in person
• Created Microsoft Access databases to monitor grant opportunities, hospital emergency response and other special needs
• Served as the lead designer for the Department’s Intranet using a web-based content management software. This intranet was developed using Microsoft Content Management Server
• Served as acting lead trainer for the Training and Resource Center, teaching intermediate and advanced levels of Microsoft Word, Excel and Access for a six month period
• Tools included active server pages, cascading style sheets, Visual Basic script, Microsoft FoxPro, JavaScript, Microsoft Office (Word, Excel, Access, PowerPoint and PhotoDraw), Internet, GroupWise e-mail, NCompass Resolution, and Microsoft Content Management Server

SYSTEMS PROFICIENCY

Archer Certified Consultant (eGRC)

Visual Basic Script, Active Server Pages (ASP), Hypertext Markup Language (HTML), JavaScript, Cascading Style Sheets (CSS).

RSA Archer eGRC versions 4 and 5, Tableau, ArcGIS / ArcMap, MapInfo, Microsoft Office (Access, Word, Excel, Power Point, Publisher, Outlook and PhotoDraw), Corel Suite (Word Perfect and Quattro Pro), MotionArtist

EDUCATION B.A., Management and Mathematics minor Confidential University

Confidential Community College