Wendell F. Moore, Jr.

**** ****** ***** **. **********, KY 40229 502-***-**** addg2h@r.postjobfree.com

DATA ANALYST PROFESSIONAL

Demonstrated Expertise in Analytical and Logical Reasoning for Examining Relevant Data Components

Highly analytical and strategy-focused IT professional with over a decade in SQL expertise, extracting and managing data, working with multiple databases and data extraction tools. Proficient in all aspects of data verification and presenting solutions to leadership, helping them reach targeted milestones. Leverage strong fundamental programming and technological abilities while thriving in dynamic work environments, implementing and managing multiple projects, identifying problems and developing innovative business solutions, pulling creative data sources into the decision-making processes.

Technology Expertise Programming Languages – SQL, Python, VBA, HTML, XML Database Management Tools – SSMS, Toad Database Developer, PGAdmin, Oracle SQL Developer Databases – SQL Server, Greenplum, Postgres, Netezza, Oracle Software – Access, Excel, Word, Visio, SharePoint, Project, Cognos, Jira, Confluence, IBM Data Stage

PROFESSIONAL EXPERIENCE

APERITY, LLC Louisville, KY 2019 - Present Data Analyst

Aperity is an innovative provider of business analytics and supply chain management tools for the CPG, Wine & Spirits and Agri-business industries.

•Responsible for helping to build and manage client's data ingestion and data usage that drives their advanced analytics in the area of Consumer and Marketing Analytics and Insights.

•Help to develop a deep understanding of the business and their clients, then partnering across Aperity to identify new and innovative solutions to solve their unmet needs.

•Monitor clients’ ETL cycles, troubleshooting any errors and recommending process improvements.

Accomplishments:

–Successfully learned Aperity’s Integrator software, implementing updates to the clients’ data flows for their ETL chains.

–Oversaw the creation of a new database for provider meta data. Successfully migrated data from multiple locations to the new centralized Provider Data Model.

–Created mask databases of clients on SQL Server to be used in the migration of their data to Greenplum. This is part of Aperity’s move to a Generic Data Model (GDM) for current and future clients. During the set-up of the GDM, assisted with the creation of SQL scripts, views and stored procedures as well as performing tests of the Python scripts and Data Stage chains.

ADP, INC. (FORMERLY SHPS HUMAN RESOURCE SOLUTIONS – 2004 to 2012) Louisville, KY 2004 - 2018

Benefits Specialist II: 2014 – 2018 - Continuation of the Data Manager role as member of the Benefits Operations Team under ADP’s service model, keeping the client experience as a priority.

•Managed multiple clients on ADP’s Benefits Marketplace platform, ensuring that their deliverables met Service Level Agreements.

•Performed data extraction and analysis for reporting, research and error resolution purposes.

•Responsible for gathering data from carriers as well as serving as a point of contact for client, vendors and leadership.

Accomplishments:

–Provided Subject Matter Expertise and mentoring to team members, helping them meet deadlines set by leadership during the migration of clients to a new, automated job management system.

–Ensured successful Annual Enrollments for clients by making improvements to the carrier enrollment process, using SQL and MS Office skills to provide timely reports and updates to stakeholders.

–Recognized by my clients for Service Excellence and by leadership and peers for being Results Driven and showing Insightful Expertise.

Data Manager: 2012 – 2014 - Critical role as part of the Large Market Eligibility & Enrollment (LMEE) Team

•Utilized SQL knowledge to perform research and data management of SHPS’ legacy systems during acquisition by ADP, developing queries that made updates to the tables for various company databases.

•Provided data analysis along with understanding of the client’s product issues and their data flow in and out of the system.

•Performed exception management, including critical evaluation of existing procedures.

Accomplishments:

–To ensure that new ADP deliverables were being met by the team, collaborated with the Technical Services to design and implement a ticket tracking process which automatically generated Seibel service request tickets of LMEE Team daily deliverables. A variation of this process was later adapted by the Benefits Operations Team.

–Mastered subject matter expertise of the Staging Load application, a SHPS’ legacy program that validates client data before posting it to the database. Improved upon the process’ efficiency and existing documentation.

Business Analyst II: 2010 – 2012 - Contributor to Spending Account Management (SAM) Operations

•Supervised various aspects of SAM Operations including technical and leadership support, managing all daily reports, and ensuring HIPPA rules were applied in all aspects of operation.

•Participated in daily tech board calls and regular software release meetings.

•Assisted in the migration of clients to the SAM platform by updating and creating new email templates using HTML, XML and performing Document Imaging case set-up work.

Accomplishments:

–Established a procedure for notifying participants of overpayments in their flexible spending plans, allowing them to remain in compliance with ERISA and IRS regulations.

–Using SQL queries and database development software, developed ad-hoc reports for Executive team during client migrations and system release updates.

–Collaborated with the Reports Technician to improve existing reports. Analyzed the entire process, introducing new methodologies which resulted in on-time, accurate reports and processor stats.

EARLY EMPLOYMENT

SHPS HUMAN RESOURCE SOLUTIONS Louisville, KY

-Supervisor, Paperless Reimbursement Team 2009 - 2010

-Business Analyst, SAM Operations 2008 - 2009

-Technical Consultant, Government Team 2004 - 2008

GANNETT DIRECT MARKETING SERVICES Louisville, KY - RPG Programmer/Analyst 1995 - 2004

DAWAHARES, INC. Lexington, KY -Computer Operator & Reports Manager 1992 - 1995

EDUCATION & PROFESSIONAL DEVELOPMENT

Eastern Kentucky University Richmond, KY Bachelor of Science in Mathematics Minor - General Business

University of Kentucky Lexington, KY Computer Science courses

University of Louisville Louisville, KY Data Mining courses

PROFESSIONAL DEVELOPMENT

University of Michigan on Coursera - Python Programming

University of Colorado, Boulder on Coursera - Advanced Business Analytics

ACQUIRED SKILLS

Python Programming, Data Analysis, Data Modeling, Data Cleansing, Data Visualization, JSON, Web Scrapping, Regression Analysis, Predictive Modeling Business Intelligence, Tableau, API

CORE COMPETENCIES

- Relational Databases

- Data Extraction, Transfer & Loading

- Data Management

- Data Research & Analysis

- Project Management

- Process Improvement & Testing

- Root Cause Analysis

- Operational Efficiencies

- Technical Documentation

- Post Implementation Verification

Contact this candidate