Excise Tax Division, Wrote Business Requirements Document for Fuel Tracking System. DOR specificaitons for Avalara 5.0, UAT for FTS-Zytax, IFTA modifications, systems support.

Property renovations, management, & leasing assistance.

Information Technology Analyst, Land RecordsProvided System Administration support for the EnerGov ERP Implementation, a system primarily used for land development and the building permitting and inspections process. Also supported the ActiveNet Parks & Recreation dept. reservations and fees software application.• Participated in Sprint Survey Meetings to review business processes and the systems configuration needed for using the new EnerGov ERP system. Emphasized to Tyler Technologies consultants the internal processes that could be automated to improve internal organizational efficiencies.Informed business users of systems limitations that need to be considered for integrating multiple software applications.• Created New User Accounts and deactivated accounts as necessary. Communicated new account information to users. Monitored system usage and account logins. Provided System Administration support for External Portal User testing.• Participated in Data Conversion meetings for data fields to be loaded into the new EnerGov System. Documented for reference WakeGov’s system configuration settings to be used in production.• Supported the ActiveNet Parks & Recreation reservations and fees collection software application. • Researched FTP capability and the technical configuration needed to automate a daily file transfer.• Worked with ActiveNet Support to resolve issues reported by Park Administrators related to users’ reporting needs and failed credit card processing.• Updated documentation on Sharepoint & added new users.

Business Analyst, NC Residency Determination SystemCFNC is launching a RDS software application for statewide implementation of Residency Determination for student qualification for state grants and in state tuition status at UNC GA colleges and community colleges.• Engaged with the business and development teams to verify and validate business processes, operating rules, and best practice methodology. Wrote user stories for software development sprints.• Participated in Agile sprint planning and daily stand-up meetings. • Researched and documented specific operating processes for RDS Admin training guides.• Evaluated and selected a sizeable sample test group of actual cases from UNC schools’ student applications. Organized the data for easy reference and accessibility, documented case categorization data in spreadsheet format for easy testing reference. • Investigated, researched and wrote documentation for required data fields to support an XML API call to interface the RDS system with the Homeland Security SAVE (Systematic Alien Verification of Entitlements) application for the validation of applicant data.

Client Support. Iron Data develops web-based public sector software used by government agencies used to manage regulatory licensing and professional certifications. I work directly with state and local government personnel to define and facilitate end-to-end delivery of new functionality and issue resolution. Key accomplishments and responsibilities:• Gather, analyze, clarify and document functional requirements for custom web applications, data, workflows, and business processes.• Work with customers to design business processes and workflows to efficiently accomplish business critical functions.• Troubleshoot and track technical issues to ensure they are resolved.• Provide timely and effective communication between technical team and customers to ensure changes in project status are managed effectively.• Review test cases; perform quality assurance and unit testing to confirm that application conforms to customer requirements.• Create customized reports and test data by creating and executing SQL queries against customer databases.• Provide coordination and leadership for project team members to ensure a cohesive customer-facing experience.• Create and maintain technical documentation such as training materials and user guides for customer reference. .

Actively participated in quarterly budget review by staff and citizen panel. Provide citizen input to summarized quarterly municipal budget reports, Comment on method and processes used in making policy decisions. Provide input to some performance measures which influence financial metrics. Provide input to Town Council members. Morrisville Bond Rating upgraded from AA to AAA in June 2013. (Committee focus changed in Nov. 2014).

Tutor for Pre-Algebra - Adv. Algebra, Geometry, Trigonometry, Pre-Calculus, Discrete Math, and AP Statistics. Private Instruction for SAT Preparation using the Summit Educational Program.

Provided second level helpdesk support for a hospital order management replenishment system, updates logged in Salesforce CRM. Investigated and resolved data issues using SQL (SSMS) and knowledge of business processes, addressed issues related to operational data functionality, including issues with Electronic Data Interchange files. Provided QA Testing for new software functionality in Agile software sprints.

Taught Problem Solving, College Math I and II at ITT Technical Institute.

Determined data interfacing requirements; communicated with customers, implementation consultants, systems administrators, and developers, serving as the primary contact with over 100 carriers in establishing automated data transfers using standard electronic data interchange formats. Provided data formatting requirements and file transfer guidelines. Tested and configured new data loads.- Clarified data formatting requirements by referencing International EDIFACT specifications and North American ANSI X12 standards. Communicated with technical staff for carriers in Asia and Europe.- Troubleshoot data loading issues for implementers and customers. Configured and tested new data extracts and loaders using file formats in .edi, .xml, .csv, .txt, and .xls formats.- Supported ongoing production issues providing responsive follow-up for carriers and customers.- Documented internal processes and training references. - Monitored import and dispatch file errors on a daily basis to identify potential issues in autom-ated file imports. Escalated issues as necessary. Notified customers and implementers to determine root cause of failed file imports.

Taught Algebra 1 and Pre-Algebra to Freshman at Garner Magnet High School. Worked with the Professional Learning Circle to raise standardized test scores by 20%.Taught Algebra II Honors & Extensions classes, Statistics, & Pre-Algebra at NHSN. Prepared curriculum materials, classroom activities, & lesson plans. Responsible for maintaining grades, partental contact, and after school help.

• Analyzed and defined business requirements. Worked with users at multiple sites to migrate legacy manufacturing database systems, including SAP to Oracle 11i. • Documented critical processes and provided user training, user support, system configuration, and data analysis for migrations to Oracle ERP. Performed data analysis using SQL relational database, report generating tools. • Wrote the Technical Interface specifications for the Oracle interface with the Automated Warehouse Control System (AWCS). Worked with programmers to validate customized and standard software modifications. Updated the Functional User Specifications for the AWCS system. • Provided project management support for a critical Oracle-AWCS installation in Gunzenhausen, Germany. Interfaced with corporate and German cross-functional teams to troubleshoot technical issues at go-live in order to accommodate a successful implementation.

• Managed the software selection process, evaluated software solutions from multiple vendors for required materials management functionality. • Managed the data migration and software implementation of a new client-server, Windows NT, GUI database software system to replace a mainframe legacy system (Y2K issue). The widely implemented system enabled flexibility in decision-making for Enterprise Resource Planning. • Developed implementation plans, determined and communicated automated scripting and hardware requirements, coordinated schedules with Windows NT Server Administrators, UNIX Server Administrators, and SQL programmers. • Responsible for software upgrades, vendor contact and user notification. • Facilitated and managed a weekly Change Review Board Meeting with a cross-functional team to address ongoing production issues. Tracked and communicated progress, documented issues, and raised concerns to the appropriate parties.