JANET MEDRANO
Katy,USA
Overview
22
22
years of professional experience
1
1
Certification
Work History
Contract Administrator (Contract)
GOLDENPASS LNG
- Current
- Assist with data migration for open text conversion from I: Drive
- Review contracts files for adherence to data privacy rules
- Condition contracts log for data analysis by reviewing contracts and extracting required information such as notice addresses, payment terms, confidentiality, etc.
- Prepare contract files for migration into OpenText including file naming convention, MSG conversion to PDF (Special Project)
- Support recordation process of RFP’s, supplier correspondence, executed contract and approvals.
- Shared Mailbox (Contracts):
- A. Compare Opentext workspaces against Contracts folders in the shared Mailbox to:
- I. Review documentation and correct any gaps with the existing workspaces.
- Ii. Rename files and folders, when needed, to match Opentext standard naming convention.
- Iii. Create additional workspaces, for Contracts on the Share Mailbox, if identified.
- Confirmations
- B. Migrate all Confirmations documents into an Opentext Folder. Provide a report of the number of documents migrated and ensure are accurate and completed.
- C. Term: 1 day
- D. Completion Date: January 10, 2024
- KYC Onboarding
- E. Migrate all KYC vendors folders into OpenText.
- I. Create OpenText Third Party profiles.
- Ii. Rename documents to match OpenText naming conversion.
- Iii. Upload all documentation.
- Iv. Update KYC report fields.
- V. Review both the Shared Mailbox and the I:/drive Folder to validate there are no missing profiles in Opentext.
- Vi. Prepare and provide a report with completed tasks for Company sign off.
Contracts Lead (Contract)
APACHE CORPORATION
01.2022 - 01.2022
- Assist the development and fulfillment of Supply Chain Contracts, specifically Master Service Agreements.
- Applies commercial acumen, knowledge of commercial contract law, and Apache guidelines, practices, and requirements to develop appropriate terms and conditions
- Uses knowledge of SAP Ariba to improve the efficiency and effectiveness of the contracting process
- Utilizes approved Apache contract templates when available and engages clause owners when required
- Develops master agreements, contract service call-offs, amendments, and contract addendums
- Advises and participates with Category Management and Strategic Sourcing team during commercial negotiations
- Maintains appropriate contract files in accordance with document retention policy and supports required audit activity
- Interfaces with the Category Management and Strategic Sourcing team to drive alignment on category and contracting strategies and requirements
- Collaborates with legal, risk, and other functional/asset teams to ensure continuity and a consistent approach to contracts development and implementation across the business
- Establishes strong relationships with key business leaders within Apache to facilitate information sharing, best practices, and lessons learned
- Ensures that sound, fit-for-purpose contracts are developed at the highest standard and to the scheduled requirements of the business requestor
- Supports the contracting team in driving towards achievement of all aspects of contract excellence in planning, solicitation, development, negotiation, execution, and administration of contracts
- Ensures compliance with related policies and contract processes and standards
- Participates in the development and maintenance of the Contracting Standards & Key Procedures
- As required, supports the resolution of issues/disputes (pricing, quality, timing, claims, liens, etc.) associated with contracts
Contract Administrator/Credit Collections Specialist (Contract)
TEXAS UNITED MANAGEMENT
01.2021 - 01.2022
- Monitor the Companies accounts receivable and identify overdue accounts (60-120 days)
- Contact customers with overdue accounts and attempt to either collect the overdue amount or negotiate a payment plan
- Use credit bureau data (Equifax), post office information, internet searches or other tools to try to locate customers who have moved or changed phone numbers
- Maintain records of contracts and attempted contacts with delinquent account customers as well as records of any payments collected from customers
- Work with customer service to resolve issues and complaints concerning billing
- Submit regular reports on the status of unpaid accounts and any repayment progress
- Assess creditworthiness of existing or prospective customers (review applications, statements, balance sheets, reports, etc.)
- Other duties as assigned
- Process contracts and related documents in document retention system
- Maintain electronic contract files, including all amendments, correspondence and any other relevant documents affecting the life cycle of the contract
- Other duties as required, including periodic review of internal contract forms and processes
- Initiate new vendor set up in system
- Monitor the workflow process to ensure all contract requests are actioned timely
- Review project data to ensure complete and accurate information is available to fulfill contract requests
- Prepare contracts in accordance with assigned templates, guidelines and established contract policies and procedures
- Initiate new vendor profile setup
Contract Administrator (Contract)
OXY PETROLEUM
01.2020 - 01.2021
- Coordinated contract issues with Credit, Commercial and Legal departments
- Communicated and interacted with traders, mid-office and other corporate stakeholders to facilitate contract negotiation and administration
- Processed contracts and related documents in document retention system
- Maintained electronic contract files, including all amendments, correspondence and any other relevant documents affecting the life cycle of the contract
- Other duties as required, including periodic review of internal contract forms and processes
- Initiated new vendor set up in system
- Monitored the workflow process to ensure all contract requests are actioned timely
- Reviewed project data to ensure complete and accurate information is available to fulfill contract requests
- Prepared contracts in accordance with assigned templates, guidelines and established contract policies and procedures
- Initiated new vendor profile setup
Collections Specialist/Contract Administrator
LINESTAR INTEGRITY SERVICES, LLC
01.2019 - 01.2020
- Oversaw the collection of past due customer invoices, researching and resolving payment discrepancies
- Handled a portfolio of 6 large accounts
- Recommended credit limits for accounts and specialized in problematic customers
- Managed the job/contract setup for 3 operational entities of LineStar (Tucker Energy Solutions, LLC, Tucker Midstream, Inc and Tucker Construction Co.). Setting up and maintaining approx. 600 a month. Dealing directly with project managers across all entities as well as the billing teams
- Updated all purchase orders, change orders in Vista
- Updated contract items in Vista to match the current SOV
- Implemented a new month end process for closing out jobs, includes closing of approximately 320 jobs per close a month
- Supports the Corporate Controller during the month end process
- Reviewed all contracts and negotiated NET terms to be within NET15-NET60, as well as, reviewed the customers invoice requirements
Accounting Specialist / Office Manager
KATY AREA ECONOMIC DEVELOPMENT COUNCIL
01.2014 - 01.2019
- Handled monthly and year-end financial accounting and bookkeeping
- Assisted with accounting; processed employee payroll
- Served as the principal 401K administrator
- Provided office administrative support to President/CEO, and VP
- Answered all incoming calls to the office and arranged hospitality services for all KAEDC meetings
- Handled multi-calendar management and prepared monthly and committee event/meeting materials and packets
- Handled office building issues, document and correspondence editing and revision
- Booked travel accommodations
- Handled website and social media content management
- Researched when needed; handled CRM database management and emailed proposal development
- Handled computer maintenance/information technology troubleshooting pc, tv, and multi-media needs in conference rooms for meetings; troubleshoots printer and HP plotter diagnostics and coordinate service repair
- Interfaced with commercial real estate brokers and special project coordination
- Handled administrative management of complete new hire process and set-up and new hire employee training
- Served as the GoTo Meeting administrator and Zoom conferencing administrator
Midstream Technical Administrator
MITSUI E&P LLC
01.2012 - 01.2014
- Reviewed all partner correspondence, which included AFE’s for midstream facilities and/ or construction field operations facilities
- Handled midstream joint venture balloting and midstream budget reporting
- Prepared and reviewed midstream systems balances including gas processing plant balances and report findings to management
- Initiated AFE approval process in Share Point for internal approval by stakeholders
- Ensured that all deadlines are met in preparing joint venture ballots for Mitsui elections as part of full cycle processing of such documentation from initial receipt through transmittal to partners and associated internal follow-up analysis, tracking and record keeping
- Attended AFE proposal meetings when held
- Created and maintained AFE logs of essential proposal data to assure proper life cycle processing, tracking, storage, and retrieval; tracked and prepared periodic report of AFE changes against total authorized expenditure
- Analyzed the historical plant product stream for all gas-processing plants and prepare reports with recovery rates
- Prepared forecasts of plant production based on inlet gas stream throughput, and historic recovery rates to functional areas requiring production outlook
- Verified monthly oil and condensate production as reported by operators
- Established contact with counterparts at operating companies and other cross client customers as needed
- Sought out updated plant maps from operators and created maps with midstream capacity and usage descriptions as required; tracked operating and capital budgets for reporting to management and periodic Board of Managers meetings
- Monitored and reviewed quarterly and annual budgets
- Developed variance reports explaining changes between forecast and actual
- Tracked tie-line reports for accuracy of operator’s forecasts
- Prepared and developed various ad hoc reports required by management
- Assisted transportation manager with exhibit and presentation preparation and with other various administrative tasks such as booking travel arrangements, calendar management, and p-card reconciliation
Project Controls Specialist – Project Administrative Support
AUDUBON ENGINEERING LLC
01.2010 - 01.2012
- Handled proposal and project set-up in Dynamics for pipeline T&M, onshore T&M, and subsea T&M groups
- Companywide allocation corrections for invoicing purposes in coordination with accounting, weekly man hour and burned reports submitted to PM utilizing AnyView
- Handled expense report reconciliation; scheduled travel arrangements and calendar management for project controls manager
- Technical Project Administrator II – Project Administrative Support
- Served as one of three project administrators to Director of Central Engineering Services
- Performed technical support to I&E engineering groups and project managers
- Handled RFQ and RFP package preparation utilizing document control specified procedures
- Performed all revisions on Central Engineering SOP’s utilizing document control procedures
- Identified and documented tag numbers on PFD and P&ID’s utilizing TrueView (Cadsoft)
- Handled conference and meeting set up and breakdown
- Coordinated L&L’s and scheduled department meetings for Central Engineering department in Houston and Louisiana offices utilizing GoTo meeting and Live visual conferencing
- Maintained and distributed digital camera, meters, and PPE to project team members traveling to site locations
- Maintained P&E licensure and renewal for project team members; handled multiple calendar management via Outlook
- Ordered and inventoried office supplies for project teams
- Approved office supply order invoices and processed for payment utilizing Oracle
- Processed expense reports for project team members and scheduled travel arrangements for project team members
Technical Project Administrator I – Project Administrative Support
ENBRIDGE ENERGY
01.2009 - 01.2010
- Served as the technical administrator providing support to Deepwater/Repair Systems PM
- Provided administrative assistance support to project team members including engineering, document control, procurement, and quality control staff
- Handled document control support utilizing intercompany SharePoint, Live Link, and Chevron e-room for vendor document receipt and maintaining document activity
- Provided administrative assistance as needed to procurement manager, utilizing payables skills and general ledger coding
- Prepared ITB and RFQ vendor packages in coordination with document control procedures
- Proofed and edited project work scopes and SOP’s utilizing document control procedures
- Handled heavy calendar management utilizing Outlook and deliverables tracking
- Ordered and inventoried office supplies for project team
- Processed expense reports for project team members and scheduled travel arrangements for project team members
Operations Support Manager
WC CABLE SERVICES
01.2004 - 01.2009
- Provided operation’s/administration management for the Houston location office
- Developed SOP’s for administrative staff in five departments; provided executive administrative support to CEO and VP of operations and developed new hire process for employees and independent contractors
- Processed background investigation checks using required Comcast approved vendor for potential new hire employees and independent contractors; scheduled UA’s for potential new hires
- Maintained highly confidential information such as rates of pay, UA results, background investigation results, employee reviews and employee increment increase
- Prepared invoice utilizing internal company tracking system and access database and submit weekly to client, Comcast
- Developed and implemented interdepartmental procedures per the client requirement to ensure efficient service job completion and customer satisfaction in dispatch department
- Served as the direct contact for client regarding all operation related procedures
- Developed and implemented interdepartmental procedures per client requirement to ensure the quality and efficiency in the return of all assigned work orders back to the client check-in department
- Utilized customer service skills to resolve damage claims to subscriber property in a timely and cost-effective manner
- Project Administrator III
- Provided project administrative assistance for two Houston office locations
- Developed SOP’s for administrative staff in five departments at two separate office locations
- Provided administrative assistance to operations director and two project managers
- Developed new hire process for Houston locations employees and independent contractors
- Processed background checks in Kroll system for potential new hires
- Maintained highly confidential information such as employee rates of pay, UA results, background investigation results, employee performance reviews and employee increment increase
- Handled invoice creations in Oracle system and submitted weekly invoice to Comcast
- Developed job descriptions and operating procedures for three internal check-in clerks
- Handled accounts payable, receivable, and GL account coding for Houston project
- Worked with weekly profit and loss and accrual projections submitted to corporate finance department, regional operations manager, and local management; profit and loss and accrual projections submitted to corporate finance for Month end accounting
- QC Administrative Assistant II
- Served as the administrative assistant to regional QC manager supporting two Houston locations
- Performed efficient and accurate data entry of all assigned QC inspections and operations production/completion data for two Houston locations
- Processed and distributed back charges for two QC Houston locations
- Distributed to corporate QC department local QV data projections interpreted in weekly Houston team roll up report (Six Sigma)
Education
Bachelor of Science - Logistics And Supply Chain Management
Colorado Technical University
Colorado Springs, COSkills
- Microsoft Office applications QuickBooks proficiency SAP and Ariba knowledge Open Invoice and Open Text familiarity Project management tools expertise Oracle database skills Neon CRM experience GrowthZone and MemberZone capabilities Dropbox collaboration tools TrueView design software skills AnyView application knowledge Microsoft Dynamics proficiency LinkedIn administration skills Salesforce CRM expertise Office 365 webmail administration Amex travel booking experience P-Card financial management skills GIS service knowledge Kroll background check expertise HFA/AS400 system familiarity TechNet resource utilization skills CSG operational knowledge Equifax credit services experience Warehouse shipping and receiving certification Forklift operation certification
Certification
Forklift operator
Timeline
Contracts Lead (Contract)
APACHE CORPORATION
01.2022 - 01.2022
Contract Administrator/Credit Collections Specialist (Contract)
TEXAS UNITED MANAGEMENT
01.2021 - 01.2022
Contract Administrator (Contract)
OXY PETROLEUM
01.2020 - 01.2021
Collections Specialist/Contract Administrator
LINESTAR INTEGRITY SERVICES, LLC
01.2019 - 01.2020
Accounting Specialist / Office Manager
KATY AREA ECONOMIC DEVELOPMENT COUNCIL
01.2014 - 01.2019
Midstream Technical Administrator
MITSUI E&P LLC
01.2012 - 01.2014
Project Controls Specialist – Project Administrative Support
AUDUBON ENGINEERING LLC
01.2010 - 01.2012
Technical Project Administrator I – Project Administrative Support
ENBRIDGE ENERGY
01.2009 - 01.2010
Operations Support Manager
WC CABLE SERVICES
01.2004 - 01.2009
Contract Administrator (Contract)
GOLDENPASS LNG
- Current
Bachelor of Science - Logistics And Supply Chain Management
Colorado Technical University