MARK ALLEN
1440 Skyline Drive, North Little Rock,AR
Summary
Strategic and analytical professional with 22 years of success in financial analysis and reporting. Talented in delivering advanced reporting to plan, design, execute and evaluate report results. Highly adept in analyzing business needs using technical skills to provide data and information analysis to achieve continuous improvement. Proficient in advanced MS Excel formulas and functions to produce data-driven reports. Collaborative, committed, resourceful, and client focused. Ability to present complex data to a wide variety of audiences, including internal and external executives. Proven ability to build relationships at all levels and be accessible to people across business lines.
Overview
21
21
years of professional experience
Work History
Senior Data & Reporting Analyst
Magellan Health RX, A Prime Therapeutics Company
11.2019 - Current
- Produced quality reports formatted in compliance with data quality standards.
- Maintained ongoing schedule and documentation for all reporting procedures.
- Automated multiple reporting tasks through creation of reporting tools.
- Reviewed and analyzed systems functions and reporting processes for accuracy.
- Managed guidelines for calculations for metrics and analysis.
- Prepared monthly ad hoc reporting in alignment with client needs.
- Collaborated with stakeholders to identify business needs and data sources.
- Developed customized reports, summarizing and presenting data in visually appealing format.
- Created dashboards to monitor and track key performance indicators.
- Utilized data visualization techniques to present and explain complex data sets.
Delivery Systems Analyst
Acxiom Corporation
11.2016 - 11.2019
- Collaborated with solution architects to collect requirements and perform scoping for new client implementations.
- Accountable for ownership of on-time input and output delivery of data sources with clients, vendors, and internal stakeholders.
- Setup and built source tables and databases for Clients.
- Accurately validated source and output data, data formatting specifications, and output requirements according to specifications and service level agreements.
- Utilized SQL in Hadoop tool to perform data segmentation, record audits, and transformations.
- Set up new Client Tenants for MAE and UDL Clients.
- Collaborated on development of automation to eliminate manual intervention.
- Executed and monitored ingestion and extraction jobs.
- Set up and evaluated new source file layouts.
- Migrated historical and current data from Hadoop environment to UDL environment.
- Performed privacy reviews involving PII, PEL, and anonymous data sets.
- Identified, documented, and reported system defects and various bugs to Engineering Team.
- Built Active Directory groups and tenants.
- Performed research and resolution for various network challenges to include space management, instances, node management, cluster configuration, and windows configuration.
- Worked with Google Analytics, dcm_clicks, dcm_impressions, and metadata files.
- External Clients included Bank Executives and various Marketing Executives.
Senior IT Management Solutions Consultant
FIS Global
01.2016 - 11.2016
- Client Management role accountable for gathering information from Banking Clients regarding their challenges with BSA, EDD, OFAC, and AML fraud.
- Assessed Client needs by conducting discovery and scoping sessions.
- Performed a wide variety of data mapping, system architecture, and implementations for various Banks.
- Led Client implementations of enterprise level software programs for financial regulatory compliance.
- Led multiple project FIS Prime deployments of varying size and scope, often with competing timelines.
- Worked collaboratively within a large organization.
- Completed projects on time and within budget.
- Conducted and maintained Data audits.
- Performed detailed research of customer business structures to accurately tailor their unique needs.
- External Clients included Bank Executives.
Business Systems Analyst IV
USBANK
02.2015 - 01.2016
- Business Analyst for ATM/Debit applications and development of new retail banking applications.
- Liaison and technical resource between management, staff, and information systems to define and communicate standards of operational policy, plans, and financial/performance reporting.
- Developed combined business requirements, UI documentation, and test plans utilizing Waterfall and Agile methodologies.
- Assigned tasks to associates, staffed projects, tracked progress and updated managers, partners and clients, as necessary.
- Implemented client training (business and technical) and supervised software integration on client's web portal.
- External Clients included Bank Executives.
Platform Manager
Acxiom Corporation
09.2013 - 07.2014
- Managed various Corporate System applications, system issues, and technical documentation.
- Worked with system design group for improvement and enhancements to existing systems, and other special projects as assigned.
- Supported and managed HRIS, Essbase, Workday, Peoplesoft, Clarity, SAP, and 10 SQL databases.
- Accountable for on-going system optimization and User management.
- Coordinated Change Management processes.
- Led staff of 4 Software Analysts.
- Created and oversaw production schedules and adjusted as needed to meet deadlines.
- Evaluated employee performance and provided feedback and training as needed.
Systems Engineer
Acxiom Corporation
01.2012 - 09.2013
- Dedicated to supporting and improving digital marketing, data processing, and analytical reporting operations to increase overall client satisfaction.
- Assured that all email marketing campaign job processes and production client data marts were updated, available, and met SLA compliance.
- Coordinated cross-functional collaborative efforts with other technical teams when investigating live "client-impacting" production issues.
- Identified flaws in applications, while driving for improvement through detailed workflow analysis.
- Documented case studies and investigation details in online repository.
- Supported Campaign Manager Email, and Cognos BI.
- Utilized heavy SQL and UNIX skills daily.
- Documented system configuration, mapping and processes.
- Supported system users, educating employees on troubleshooting and problem-solving protocols.
ERP Systems Analyst
State Of Arkansas
04.2011 - 01.2012
- Provided ERP / SAP System Support and configuration for State of Arkansas AASIS Payroll HCM Module.
- Supported Human Resources in use of system.
- Created Payroll Processing and Garnishment test scripts.
- Maintained technical documentation.
- Created functional specifications, test, and traceability matrix.
Senior Systems Analyst
FIS Global
08.2009 - 04.2011
- Managed Profile Retail Banking configurations and management of Job Scheduling Systems / Client Servers.
- Analyzed operations of systems which included developing, testing data migration routines, and documenting details.
- Responsible for on call 24/7 system support to data center employees.
- Utilized SAS, Transact SQL, Oracle SQL, ETL, FTP, SFTP, Unix, and TAR to perform job duties.
- Provided operational support for high-volume financial institutions.
- Programmed job scheduling routines.
- Worked closely with internal Business Analysts for client system utilization and functionality needs.
- Lead for various projects.
- External Clients included Bank Executives.
Database Administrator
Bank of The Ozarks
10.2008 - 08.2009
- Managed Database including administration, design, performance, and reliability.
- Performed various functional system configurations.
- Utilized heavy XML, VB tools to create numerous HTML Loan Documents.
- Produced ad hoc reports and documents for senior team members.
- Validated schematic designs.
- Authored and coded logical and physical database descriptions.
- Created scripts and processes for data integration and maintenance.
- Developed data architecture design to enable analysts to perform targeted customer analysis.
Business Systems Analyst
Alltel Communications
02.2007 - 10.2008
- Supported Corporate Systems Applications to include Inventory Accounting, Warehouse Distribution, Supply chain, Accounts Payable, Payroll, HRIS Employee Benefit Systems, and Wireless Revenue Systems
- Conducted classroom system training for all Corporate System Applications.
- Created Business requirements and User Interface mockups.
- Identified process inefficiencies through gap analysis.
- Produced charts and diagrams to assist with problem analysis.
- Educated stakeholders on data protection tactics to reduce breaches.
- Presented business leaders with ROI estimations to drive project planning.
Financial Analyst II
Windstream Communications
08.2006 - 02.2007
- Lead Project to improve functionality of Reciprocal Accounting Database.
- Responsible for month-end closing process (including journal entries, reversals, accruals, and financial statement review.
- Performed collection efforts on delinquent invoices and maintained aging reports.
- Completed and mailed invoices, contracts, policies, and checks.
- Credited for playing key role in reporting over $2 million per year in revenues.
- Developed automation for electronic telecom billing and A/R loads.
- Analyzed monthly balance sheet accounts for corporate reporting.
- Utilized SQL to analyze Circuit Inventory on AS/400 Platform.
TPA Account Relationship Manager
Transamerica Employee Benefits
04.2005 - 08.2006
- Managed relationships with TPA, Group administrators, New Business, Claims, Customer Service departments, and Insurance Agents regarding Premium Billing, delinquency, and reconciliation issues
- Responsible for weekly reconciliations, month end accruals, reversals, and G.L. entries.
- Managed and supervised 4 Premium Accounting Analysts
- Served as project leader for health & welfare administration system conversions, and Vendor/relationship manager.
Application Support Engineer
Lavender & Wyatt Healthcare Systems Inc
08.2004 - 04.2005
- Responsible for troubleshooting AS/400 system issues; escalating as necessary, questioning appropriate individuals on status of items, working with and managing other information system staff to resolve items.
- Provided Training and Support to External clients regarding electronic claims processing.
- Supported ansi 835 and 837 electronic file configurations and system scheduling.
- Verified data integrity and accuracy.
- Assisted Clients with data analytic tools.
- Provided continued maintenance and development of bug fixes and patch sets for existing web applications.
- Communicated with clients to define business objectives and present individualized solutions.
Reconciliation Accounting Supervisor
Arkansas Blue Cross Blue Shield
08.2002 - 08.2004
- Managed 22 employees responsible for member enrollment in health benefit plans.
- Implemented delinquency Procedures for past due Premium.
- Responsible for reviewing reconciliations and evaluating all assigned balance sheet accounts.
- Confirmed that Premium Accounting records were maintained in accordance with Generally Accepted Accounting Principles (GAAP), company policies, and RFP Enrollment Agreements.
- Worked with 834, 835, and 837 electronic files.
- Provided numerous data analytic reports to Executives.
Education
BA - Instrumental Music Education
University of Central Arkansas
Conway, AR1989
Skills
- Face to Face Client consulting experience
- Software training / presentation experience
- MMIS
- Medicaid Pharmacy and Health
- Business / System requirement documentation
- Waterfall / Agile Methodologies / SDLC
- Traceability Matrix creation and management
- UI design
- Data Flow Diagrams
- Gap analysis
- Software Configuration
- Data Mapping
- Data Visualization (Dashboards)
- Salesforce / Servicenow, Jira, Remedy, CASD
- Microsoft excel / Word / PPT
- ANSI X12N 834, 835, 837
- UNIX / LINUX
- Encryption/Decryption (PGP/GPG, SDMS)
- Hadoop / Datamart / Cloudera Manager / Spark
- Pivot tables / vlookups
- Cognos BI Reporting and Analytics
- Tableau
- Redshift / Cogniti Pro
- ETL
- 20 years - MS SQL/ PL-SQL / Oracle
- UDL
- SAS
- PIG
- HIVE
- XML
Timeline
Senior Data & Reporting Analyst
Magellan Health RX, A Prime Therapeutics Company
11.2019 - Current
Delivery Systems Analyst
Acxiom Corporation
11.2016 - 11.2019
Senior IT Management Solutions Consultant
FIS Global
01.2016 - 11.2016
Business Systems Analyst IV
USBANK
02.2015 - 01.2016
Platform Manager
Acxiom Corporation
09.2013 - 07.2014
Systems Engineer
Acxiom Corporation
01.2012 - 09.2013
ERP Systems Analyst
State Of Arkansas
04.2011 - 01.2012
Senior Systems Analyst
FIS Global
08.2009 - 04.2011
Database Administrator
Bank of The Ozarks
10.2008 - 08.2009
Business Systems Analyst
Alltel Communications
02.2007 - 10.2008
Financial Analyst II
Windstream Communications
08.2006 - 02.2007
TPA Account Relationship Manager
Transamerica Employee Benefits
04.2005 - 08.2006
Application Support Engineer
Lavender & Wyatt Healthcare Systems Inc
08.2004 - 04.2005
Reconciliation Accounting Supervisor
Arkansas Blue Cross Blue Shield
08.2002 - 08.2004
BA - Instrumental Music Education
University of Central Arkansas
Similar Profiles
Matiya CromartieMatiya Cromartie
Clinical Pharmacy Technician II at Magellan Health/Prime TherapeuticsClinical Pharmacy Technician II at Magellan Health/Prime Therapeutics
Chera YorkChera York
Medical Writer at Magellan Health/ Prime TherapeuticsMedical Writer at Magellan Health/ Prime Therapeutics
Claudia LobergClaudia Loberg
Account Manager at Partners Rx/Magellan Rx Management/PrimeAccount Manager at Partners Rx/Magellan Rx Management/Prime