Data Analyst Contract Specialist

CALEB ADEWALE ADELEKE

Contract Specialist/Data Analyst

PROFESSIONAL PROFILE

A dynamic, motivated professional with the experience and proven work ethic to implement analytical plans, resolve data gaps, and administer all phases of complex contracts. Dedicated leader who is known for identifying potential data sources, pinpointing data gaps, and ensuring efficient data loading. Able to determine and fulfill stakeholder requirements and monitor all contract phases to execution. Out-of-the-box thinker who is comfortable working in teams or independently to ensure compliance with regulations and agreements.

CORE COMPETENCIES

Contract Management & Analysis

Data Analysis & Manipulation

Business Development

Financial Operations

Data Migration &Transformation

Data Conversion & Loading

System Integration

Accurate Reporting

Business Requirement Gathering

Functional Specifications

Data Warehousing

Use Case Diagrams

WORK EXPERIENCE

AstraZeneca Pharmaceuticals LP, Gaithersburg, MD, October 2021 to September 2024

CONTRACT SPECIALIST/DATA ANALYST

Initiate Contract processing from request stage through negotiation, execution, purchase order issuance, invoicing and payment

Supervision of a team of Contract Specialists for teamwork and effectiveness

Collaborate with Procurement & business owner in pre-award contract negotiation process during which the modalities of providing services, payment schedule and other terms & conditions are agreed and presented in a Statement of Work

Cross-collaborate with stakeholders, Finance and Procurement teams to follow the contract lifecycle from draft and negotiation through to final approval

Administer all aspects of the department PO tracker, utilizing SharePoint while partnering with key stakeholders to set up new vendors in Coupa via ServiceNow and Adobe.

Prioritize and address the needs and queries of stakeholders in matters related to suppliers, ensuring information is updated and accurate.

Utilizing Power BI to develop data dashboards, charts, and visual aids to support decision-making across departments.

Monitor the progress of contract movements and generate status reports for use by internal and external stakeholders.

Synthesize, study, and analyze contract data while maintaining historical contract information.

Examine, assess, and ensure goods and services are as expected and properly invoiced, confirm payment is processed to terms, and liaise with vendors and accounts payable to resolve payment issues.

Serve as first point of contact and SME in all issues concerning new vendor set up or updates in addition to providing support to legal operations in setting up global vendors in SAP.

Assist with negotiations of claims, manage contractual changes, and resolve disputes or conflicts with contractors.

Stay up-to date with legislative changes, coordinate with the legal department as needed, and ensure all deadlines and conditions described on contracts are met.

Detect and analyze potential risks involved with specific contract terms and implement measures to minimize risk.

United Healthcare, Washington, DC, June 2019 to September 2021

DATA ANALYST

Demonstrated expertise in garnering meaningful insights regarding providers related to their daily Medicare and Medicaid activities.

Scripted, performed, and analyzed the results of complex queries in order to deliver detailed reports on open and closed gaps along with payments due to each provider based on the closed gaps utilizing SQL.

Ensured the highest level of data accuracy and integrity of data pulled and utilized statistical methods to evaluate and analyze numerical data using MS Access, MS Excel, Oracle, SQL, and/or other applications.

Collaborated on the design of tables, views, and stored procedures and indices using T-SQL and created trend reports in Tableau and Power BI to identify potential program or systematic vulnerabilities.

Contributed extensively to brain storming sessions with Risk Managers, Team Leads, and other stakeholders to devise a plan to find the correlation of at-risk enrollment behaviors.

Served as a committee member to participate in discussions and supported the leadership team by providing ad hoc reports and analysis.

Conducted data profiling to increase the accuracy and efficiency of reporting and analysis.

Navy Federal Credit Union, Vienna, VA, January 2018 to June 2019

DATA ANALYST

Accountable for monitoring contractor activities and requests, such as Bank Guarantees (BG), Advance Payment Guarantees (APG), Letters of Credit (LC), etc.

Delivered weekly and monthly reports on customer activities as required for each project in support of the Online Account Manager.

Compiled, reviewed, and manipulated data using SQL with import/export data obtained from various external file formats using SSIS.

Produced spreadsheets and pivot tables with advanced Excel functions and identified and interpreted critical trends or patterns over time.

Merged and cleansed multiple data sources to allow for different views on application data in a single dashboard and collected data to be used for Tableau visuals.

Presented information to other lines business as a meta role to highlight value of Tableau as a BI tool.

Designed, integrated, and maintained SQL programs and conducted reviews to find invalid/out of range data.

Established databases, data collection systems, data analytics, and other strategies to optimize statistical efficiency and quality.

Personal Trust Microfinance Bank, Lagos, Nigeria, July 2016 to January 2017

HEAD, BUSINESS DEVELOPMENT (AG MD/CEO)

Employed control and authorization over a broad range of daily operations within the bank, including financial and business development functions.

Directed and oversaw all activities and team members across multiple units and branches while reporting to the Board of Directors.

Corestep Microfinance Bank, Lagos, Nigeria

MD/CEO, November 2012 to January 2015

Presided over accounting functions and staff, provided strategic leadership and direction to the company, and implemented measures to enhance the performance of the organization.

Engaged with the Board of Directors to discuss current operations and provide advisement.

HEAD, CREDIT & MARKETING, August 2012 to November 2012

Created, implemented, and ensured compliance with marketing policies and strategies and reviewed and improved existing credit policies.

Directed credit administration and management tasks and coordinated a wide array of marketing activities.

Previous Experience

Wollydee Associates, Blanchardstown, Dublin, Ireland, October 2009 to December 2010 FINANCIAL ADVISER

Alpha Royal Financial Services, Portlaoise, Ireland, November 2007 to September 2009 ACCOUNT EXECUTIVE

Intercontinental Bank Plc., Nigeria, April 2003 to December 2006 RELATIONSHIP OFFICER/MANAGER

City Express Bank Plc., City, Country, February 2001 to March 2003 RELATIONSHIP OFFICER

EDUCATION

Professional Diploma in Financial Advice(QFA), 2010

University College, Dublin, Republic of Ireland

Master of Business Administration (M.B.A.) in Marketing Management, 1997

Lagos State University, Lagos, Nigeria

Bachelor of Science (B.Sc.) in Microbiology, 1983

University of Ibadan, Nigeria

PROFESSIONAL AFFILIATIONS

Fellow, Chartered Institute of Bankers of Nigeria (CIBN)

Member, Nigeria Institute of Management. (NIM)

Member, Institute of Bankers, Ireland (IoB)

VOLUNTEERISM

Donated time as a volunteer to teach the elderly how to open e-mail account and various uses of internet at local library in Ireland

ADDITIONAL INFORMATION

Languages: English, Yoruba

Technical Proficiencies: SharePoint, Coupa, ServiceNow, CounselLink, MS Office, Advanced Excel, MS Visio SQL, SQL Server, T/SQL, SQL Loader, Tableau, Power BI, RDBMS

Interests: Music (Jazz, RnB, Blues, afrobeat) Soccer, basketball, athletics, travelling, socializing

Upper Marlboro, MD 443-***-**** *************@*****.*** LinkedIn

Contact this candidate