Perr&Knight

Administration

• Leading and optimizing the full contract lifecycle, driving precise and efficient execution of client contracts in compliance with company policies.
• Coordinating internal and external reviews and approvals to advance agreements to execution, tracking agreement status, outstanding items, and responses to support timely completion
• Serving as the primary liaison with external legal counsel regarding client contracts
• Overseeing version control, draft circulations, and redlining throughout the contract negotiation process; identifying non-standard contractual terms and provisions and escalating concerns appropriately
• Maintaining accurate and up-to-date contract records within the internal contract management system, including monitoring expiration dates and keeping contracts current
• Managing and updating legal agreement templates and implementing efficient processes for contract review, approval, and execution
• Developing and maintaining training materials and resources related to internal contracting processes, providing annual training to internal stakeholders
• Reviewing and approving external legal counsel invoices, ensuring expenses are accurately allocated to the appropriate client or project

Contracts Administrator

Software Engineer

• Designing, developing, and maintaining complex SQL queries, stored procedures, functions, and views to support data processing and reporting needs.
• Building and enhancing ETL workflows to extract, transform, and load data from various internal and external systems.
• Developing scalable and efficient data transformation logic to support business requirements.
• Creating and maintaining staging tables, integration layers, and curated datasets for downstream consumption.
• Optimizing database performance through query tuning, indexing strategies, and execution plan analysis.
• Participating in data model design and contribute to improving database structure and maintainability.
• Troubleshooting and resolving data quality and performance issues within ETL processes and database environments.
• Assisting in deploying database changes across development, staging, and production environments.
• Collaborating with business analysts and application developers to translate functional requirements into technical solutions.
• Performing unit testing and support system and user acceptance testing for new enhancements.
• Maintaining clear documentation of database objects, ETL workflows, and technical design decisions.
• Adhering to coding standards, version control practices, and change management procedures.

Programmer

Insurance

• Accessing/reviewing insurance related laws and regulations
• Performing competitive research
• Organizing/presenting competitive information in a meaningful format
• Drafting basic product documents for new programs and creating state required forms to address compliance issues
• Preparing support and compliance reviews, including forms checklists and transmittals for form filings, including drafting explanatory language
• Working directly with state filings analysts
• Corresponding directly with clients on project goals and results
• Managing own deadlines and workload for multiple projects
• Drafting form interrogatory responses
• Recommending solutions and/or alternatives to clients
• Keeping informed on industry trends, changes in the marketplace, etc.

Contracts Administrator

Programmer

Insurance Forms Consultant