David Wiley Email & Phone Number

Sparks, Nv, Us

Research Triangle Park, Nc, Us

Financial Project. Working with internal subject matter experts in the USA and Europe. Gathering requirements and developing acceptance criteria for the Revenue Recognition Automation project, the purpose is to create a system that will allow Worldwide Clinical Trials to actualize units in an automated manner for all services as they occur. The project is to identify various data points within all current systems that indicate services have occurred - automatically using rules and milestones. Source Systems: [START, SCIFORMA, JIRA] End System: Certinia. DevOps for Requirements. CMMI methodology. Projects: Revenue Recognition Automation, START Tool Web and Reports, Legacy System Migration & Decommission, Balanced Score Card, Unblinded Protocol Deviations / Issues Tracking.

Rosemont, Il, Us

US Foods Holding Corp. is an American food service distributor. With approximately $24 billion in annual revenue, US Foods was the 10th largest private company in America until its IPO. It was founded in August 1989. I was brought into US Foods' executive team and tasked with planning, coordinating, and managing the assimilation of new software applications and programs into an organization's existing computer network. I supported each department by determining its systemic needs, recommending changes, implementing new software solutions and instructing users about the interface.Select accomplishments:•Led the integration of Avalara Tax compliance system with US Foods D-365 Finance and Operations system for the Chef Stores and legacy stores—managed Store and Product setup.•Managed the offshore team as the Senior BA/DA, providing training and guidance on Requirements Gathering & tracing, Design, Analysis, User Acceptance testing, Demos, documentation, Data modeling, etc.•Developed a new feature by displaying the customer’s exemptions of D-365, Tandem customer interface with the Avalara exemption system (business process and data flow design and testing).•Directed the complete lifecycle of the Store Conversion project. Launched new online stores into D-365, Avalara Tax program, setting up security roles, and ready for training.•Oversaw Security Tasks for Identity and Access Management (IAM) for the Store personnel and their roles using D-365. IAM for Avalara Tax software: Admin. Managers and Users.•Environment: [a. D-365 Finance and Operations] [b. Microsoft Azure DevOps, Kanban, daily scrum, Microsoft Teams, Office 365] [c. Snowflake, Azure Cloud, Tableau, PowerBI, SQL development.] [d. Desktop: Excel, MS Access, VBA, Office 365] [e. Diagramming: Lucid Chart]

We Search For You, Inc., is a Business-To-Business Company Helping Companies locate Missing Plan Participants. At the time, the executive team at We Search For You, Inc., was looking for an industry-savvy, strategically-minded Business/Data Analytics Expert to craft a blueprint for the organization’s entire finance operations and leverage various finance-related solutions. Advising and working closely with the management teams, my priority was to oversee all financial activities of the organization, including budgeting, forecasting, building financial models, assisting with financial planning, performing research and analysis, preparing reports, and assisting with close processes. Additional responsibilities included assisting with financial planning and budgeting processes, analyzing financial statements and reports, developing financial models, preparing projections, and performing research and analysis as may be required by leadership. As a Senior-Level Financial Analyst, I was also responsible for providing project teams with financial guidance and assisting with monthly close processes.Select accomplishments:•Compared customers' participant PII data daily to a death data set (Obits, State Data, and the Limited Death Master File). Managed Large Data Sets, finding current deaths and reporting results to customers.•Held complete accountability for all project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.•Established a new HIPPA security framework for future certification, Identify Access Control, Privacy, and Data protection of the customers' PII data.•Negotiated and managed contracts with the data center, hardware, and service providers.•Set up a secure Data Center, supporting seamless data process flow.Env: JIRA, Confluence, Kanban, Scrum, Teams, PowerBI, SQL, [Desktop: Excel, MS Access,VBA,Office365] [ Modelling: Visual Paradigm] [DB: MariaDB] [Sec: FortiClient,Webroot,ExaVault]

Owner. Specializing in - Business Analysis / Prototyping. Business Automation. - Improving and automating business processes. - Developing new product applications - Technical Project Management - Database design and development. Data Centric Applications. - Visual Basic Development (VB, VB.Net, VBA, VB Script). - MS Access/SQL Server - Taking MS Access databases to the web using AlphaFive

Reno, Nevada, Us

Designed and developed Death and Life Audit services and solutions for Unions, pension funds, Insurance, Viaticals, and local and state government entities. Managed verification and validation of requirements. Directed QA and testing. Managed Hardware updates and Software Development. Oversaw Data Governance. Compared customer participant PII data daily to a death data set (Obits, State Data, and the Limited Death Master File). Large Data Sets, finding current deaths, and reporting results to customers. Designed and developed the data environment and system to process large data sets daily. Increasing the market capability.  Managed all project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance. Business Analyst/PM on the design and development of the Lifestatus360 SaaS platform. Oversaw process flow, data models, GUI interfaces, Use Cases, and event processing. (LS360) BA for the customer's Use Cases for custom ETL, Processing, report, and output.  Established a new NIST and HIPPA security framework for security certifications. Established processes to obtain a LADMF security certificate. Established Role-Based access control (RBAS) & and tracking user activity to protect PII in a SaaS environment and processing. Reviewed customers’ yearly security questionnaires. Established contracts with the data center, hardware, and service providers. Worked with Customers to derive custom data processes and data analysis projects. Transition projects from MS SQL to MySQL To MariaDB.Environment: Jira, Confluence, Office365, Visual Paradigm, Agile, Kanban, (DB: MS SQL, My SQL, MariaDB, Access) (Sec: HIPAA & LDMF framework) (Low-Code: Alpha Software) (Salesforce DRM) (Code: VB, VBA, SQL)

Duluth, Georgia, Us

Assigned to Kaiser Permanente IT Group in Pleasanton, CA. Working on the eGRC (governance risk & compliance) projects. To date RAC (Recovery Audit Contractor) Audit Program, Fraud, Waste and Abuse Compliance (FWAC) program and Compliance Legal & Regulatory Affairs (CLRA) program. Working in the capacity of a Business Analyst to gather requirements from the different business elements to create new interlinking applications on a common platform. Working in the capacity of a data analyst to automate to integrate the different information / processes with current business process. Automate the Extract, Cleanse and Load processes. Broaden the use of tools to improve the analyst/investigation efforts. Tools to date: - SQL Server - Informatica - Oracle- RSA Archer- Blaze Advisor- MS Access Processes: - Agile Analysis - Agile modeling -

- Review and adjust current system data artifacts (i.e. model, analysis artifacts, mappings, flows etc)- Produce data mappings and conversion documents- Perform JAD and interview sessions to determine requirements- Create and maintain requirements- Plan scenario and data test scriptsTechnology: MS Access, Excel, VBA, Spark Enterprise, Windows XPIndustry: Beverage and ManufacturingApplication Focus: GM, Financials

Senior Product Engineer – Project Management – Business Systems Analyst - Development Purpose:Retail enterprise integration for the development of business rules as they pertain to automatic in store and centralize signage. Integration with Manugestics, POS and other retail enterprise information islands. Concentration on grocery and electronics retail area. (Food Lion, Pathmark, Piggy Wigglys, Verizon, CompUSA)Managed a distributed outsource project of 15 man team. The conversion of a Microsoft based thick client to a JSEE thin client. Geared for IBM WebSphere. Incorporating a Business Rules Engine (BRE) to allow for the visual representation of rules and to eliminate scripting. Development and management of new product functions and integration with partners. Management and development using Agile/XPM methods. Business Analysis used to improve the workflow and collaboration. Verification & Validation of software. Application rollout and onsite implementation: - Java, J2EE, IBM WebSphere, QuickRules Business Rules Engine Sector – Retail.

Business Systems Analyst – Project Management Consultant (Contract) Purpose:Auditing of the current Project Management process and Sox’s compliance. (IBM Rational Pro, Spark Enterprise)Services provided:Business AnalysisSwim lane, process modeling, Matrix , decision table developmentWorking with the current staff to determine if the current management process is a proper SDLC and SOX’s compliance. SOX compliance audit. Review of the current requirements and design documents. Review of the PMO office deliverables. Risk Analysis

Masters, Software Engineering

Bachelor Of Science - Bs, Computer Science

Bachelor Of Science - Bs, Computer Science