Troy Zellers

Troy Zellers Email and Phone Number

Advisor I Financial Service Projects and Analytics at ConocoPhillips @ ConocoPhillips
Bartlesville, OK, US
Troy Zellers's Location
Bartlesville, Oklahoma, United States, United States
Troy Zellers's Contact Details
About Troy Zellers

Troy Zellers is a Advisor I Financial Service Projects and Analytics at ConocoPhillips at ConocoPhillips. He possess expertise in microsoft excel, accounting, recruiting, interviews, access and 22 more skills. Colleagues describe him as "It is a pleasure getting the opportunity to recommend Troy Zellers. Troy is a stand-up guy. Honest, hard-working and great attitude, Troy is the kind of guy you want working for your organization. I've known Troy for more than several years and I can tell you he is a man of character, integrity and class.", "Troy was a very reliable, dedicated, and observant team member at United Linen.", and "Troy was a diligent student. He was very passionate about the projects and ministries that he took on. He was great at motivating and leading teams and would be a great addition to any organization."

Troy Zellers's Current Company Details
ConocoPhillips

Conocophillips

View
Advisor I Financial Service Projects and Analytics at ConocoPhillips
Bartlesville, OK, US
Employees:
16855
Troy Zellers Work Experience Details
  • Conocophillips
    Conocophillips
    Bartlesville, Ok, Us
  • Conocophillips
    Advisor I Jva & Cost, Nxtgen Finance
    Conocophillips Jan 2024 - Present
    Houston, Texas, Us
  • Conocophillips
    Advisor I Financial Service Projects And Analytics
    Conocophillips Jan 2023 - Jan 2024
    Houston, Texas, Us
    Responsibilities:PRA Data Modernization Data Lead-Migrated SAP PRA data from Teradata to Snowflake -Took the lead in validating views for SIT, UAT, and HVR replication testing.- Managed TEK System resources to ensure the delivery of reports and the adoption of best practices for a smooth business transition.- Led discussions with financial services groups and IT concerning PRA data in Snowflake and reporting, providing regular updates to business leaders and users about the project's progress.- Collaborated with the business to conduct testing on reports created by TEK.Knowledge Sharing- I am currently leading the Run the Business Training initiative, collaborating with the team to strategize and sustain the business's eagerness to enhance their understanding of data analytics. The aim is to tailor our approach to meet the organization at its current level of capabilities, supporting their journey to elevate their skills in data analysis.- Developing knowledge sharing documents and leading knowledge sharing meetings, emphasizing the use of Snowflake, UiPath Task Capture, PBI/BOBJ Analysis, EPI USE, Production Scripting Tool, and Legacy PPA tools.Citizen Developer Director Role- Presenting program achievements and its value in various forums, including TMT showcases, orientations for new hires and interns, and TaxTalks.- Evaluate D&A (Data & Analytics) levels and their corresponding use cases.- Assisted with developing Ad Hoc queries for data gathering for multiple groups in Financial ServicesAccomplishments:- Effectively implemented R1z within program deadlines, without imposing additional resource demands on the nxtgenERP program, and achieved a defect-free implementation. - We successfully migrated 13,537 GBs of data, encompassing over 7,500 Teradata objects. Our migration process adhered to a 30-minute SLA, with an additional 300 GBs of monthly replicated data. Furthermore, we seamlessly converted 850 Business Object Reports to PowerBi.
  • Conocophillips
    Advisor I Sap Pra Production & Revenue Support
    Conocophillips Jun 2022 - Dec 2022
    Houston, Texas, Us
    Responsibilities:•Establish new Financial/Quantitative Acumen for Data Control Production Support and Empowering Others to deliver results and solve problems with confidence. Impacting groups such as NAPRA, Data Control, and IT.•Collaborate with Production users to identify pain points and manual processes in order to develop efficiencies through automation and reporting.•Share knowledge with Production Associates by explaining system impacts and how to trouble shoot items, which in turn builds their skill set and confidence.•Create Ad Hoc custom queries from PRA/Enertia/EU/L48 data to facilitate quick decision-making within NAPRA and with our business partners.•Assist with determining best tool to process legacy PPAs and helping pull data and altering existing tools to accomplish PPA.Accomplishments:•Collaborating with PRALS Production support by fixing reports, breaks in SAP PRA, and knowledge sharing about interfaces and current processes.•Empowering Production users by sharing knowledge on uploads, SAP transactions, and reference material to create efficiencies within the teams.•Expand knowledge of DC Production Support team by sharing the table structures behind SAPs screens and the data flows to Revenue.•Built multiple queries and tools for PAs and DC Support in order to research when issues arise, monthly master data checks, and automation of monthly processes.•Became Advanced Citizen Developer – Data & Analytics.
  • Conocophillips
    Sr Analyst I Sap Pra Revenue Support
    Conocophillips Nov 2016 - May 2022
    Houston, Texas, Us
    Responsibilities:•Team lead for SAP PRA Revenue Support•Liaison between SAP PRA Production and Revenue during acquisitions and divestitures •Work directly with accountants and IT to resolve system issue•Triage questions and issues from end users to determine if ticket needs to be submitted with COP IT or SAP directly•Test notes and upgrades to PRA before implementing to PRD•Training end users in PRAAccomplishments:•2022 Currently converting Shell assets acquired in the Permian Basin, will book 1st time in COP PRA May Accounting•2021 Accomplished Concho conversion into SAP PRA from Enertia within 9 months after acquiring over 6,000 wells operated and 4,000 wells non operated - Designed and tested conversions from hCXO's accounting system Enertia to SAP PRA - Mined through data and built comparison reports between systems by using SQL, Teradata, and Spotfire - Developed a process in order to use Crawford PPA Workplace within SAP to accomplish hCXO PPAs in order to shut down hCXO Enertia application •2019 – 2020 Revenue Team lead to shut down ConocoPhillips legacy production/revenue accounting oracle system EU (Enterprise Upstream) - Streamlined PPA processes in EU to complete backlog of over 15,000 PPAs in 5 months - Created Spotfire reports to accomplish conversions of legacy transactions into SAP PRA•2018 Successfully implemented SAP Enhancement Pack 8, Service Pack 8, HANA SP2, and unbolt CPRA•Effectively worked with COP’s ERP BASIS team to continually have SAP globally stable after implementation•Improved Eagle Ford Asset runtime from 20+ hrs for current month and PPA to current month 3 hrs and PPA 6 hrs•Able to quickly and efficiently query large amounts of data through SQL in order for the business and/or management to make decisions on accurate data
  • Conocophillips
    Revenue Staff Analyst I San Juan Enterprise
    Conocophillips Apr 2014 - Nov 2016
    Houston, Texas, Us
    Responsibilities:•Team lead for SAP PRA implementation with revenue testing and validation of master data•Accurately and timely booking monthly volumes processed through the Enterprise Plant in the San Juan Basin•The point of contact for Owner Relations, Audit, Litigation, and Regulatory inquiries for San Juan Revenue•Trouble shoot issues with Novistar EU that occur during monthly closing or for PPAs Accomplishments:•SAP PRA Implementation – successfully implemented SAP PRA July 2016 - booked 6,500+ wells within normal close•Federal Fuels Implementation – accurately process revenue accounting fuels for San Juan in January 2015 accounting for regulatory reporting to the ONRR in February•NGL Pricing Implementation - accurately calculate pricing NGLs for San Juan in July 2015 accounting for regulatory reporting to the ONRR in August
  • Conocophillips
    Revenue Analyst I San Juan Unit Expansions
    Conocophillips Dec 2012 - Apr 2014
    Houston, Texas, Us
    • Ensure all meters and property codes are set up correctly within EU (Novistar) and TIPS (The Intelligent Plant System) in order to process PPAs• Problem solve issues when PPA processes error out or GLs are not as expected• Monthly reviews of GLs for all PPAs processed that accounting month• Track and process current San Juan Unit Expansions• Completed San Juan's Unit Expansion backlog in 1st quarter of 2014.
  • Conocophillips
    Recruiting Coordinator I Sourcer
    Conocophillips Mar 2012 - Dec 2012
    Houston, Texas, Us
    • Provided hiring, offer, and diversity metrics for business unit’s and recruiter’s• Analyzed organizational trends through use of created metrics• Coordinated requisition process by populating job description information into Taleo• Partnered with recruiters, HRBPs, and Center of Excellence advisers to remain within compliance regulations• Scheduled interviews, including phone interviews, on-site interviews, and travel arrangements for candidates• Assisted with building interview guides, offer letter generation, and initiating pre-employment due diligence process• Managed COP_Careers Twitter account with an average increase of 15% in followers each month
  • Zellers 5K Memorial Run
    Co Creator
    Zellers 5K Memorial Run Feb 2008 - May 2013
    • Raising awareness in the community while gaining sponsorship from new and past sponsors• Advertising for the Memorial run via billboard, flyers, facebook, and twitter• Maintaining day of race operations with registration of 150+ participants• Average money raised is $10,000 to benefit scholarship fund and the American Diabetes Association
  • American Self Storage
    Assistant Office Manager
    American Self Storage Jan 2012 - Mar 2012
    • Maintained daily ledgers for all current customers and billing notices to the customers.• Provided tours to new customers to show our facility to provide peace of mind to the customers.• Created and maintained the companies social outlets such as: Twitter, Facebook, Google+, and Storage Advertising.
  • Craftistas
    Operations Director
    Craftistas Aug 2010 - Jun 2011
    My team of 4 individuals seized a market opportunity. Won 1st place overall at the Donald W. Reynolds Tri-State business plan competition in Las Vegas, Nevada and 2nd place at the Donald W. Reynolds Governor's Cup business plan competition in Little Rock, Arkansas.
  • John Brown University
    Assistant To The Resident Director
    John Brown University Aug 2010 - May 2011
    Siloam Springs, Ar, Us
    • Intentionally built relationships with residents and RA’s while developing mentoring relationships.• Directed weekly meetings with RA staff and RD concerning dorm activities, administrative responsibilities, and discussed the enthusiasm of the dorm.• Administrated the dorm weight room by hiring staff to work scheduled hours to supervise and managed the staff to create an environment of pride for all men in the dorm.
  • Arkansas Support Network
    Kids Club Supervisor
    Arkansas Support Network May 2010 - Aug 2010
    Springdale, Arkansas, Us
    • Delegated daily activities and have sufficient supplies for the campers.• Recorded administrative reports such as, time sheets, travel logs, expenditure forms, and incident reports.• Conducted daily observations of the campers in order to be objective during episodes from campers or staff.
  • John Brown University
    Resident Assistant
    John Brown University Aug 2009 - May 2010
    Siloam Springs, Ar, Us
    • Incorporated monthly suite activities in order to build community within the dorm.• Solicited weekly meeting with RA staff to communicate goals of the week and situations that needed to be addressed.• Weekly rounds through the dorm to facilitate friendships with residents and ensure safety precautions were being followed.
  • United Linen & Uniform Services
    Assistant To Operations Floor Manager
    United Linen & Uniform Services 2005 - 2009
    • Assembled a Microsoft Excel spreadsheet for CEO in order to manage and see all the productivity levels of the routes.

Troy Zellers Skills

Microsoft Excel Accounting Recruiting Interviews Access Social Networking Strategic Planning Social Media Teamwork Employee Relations Employee Benefits Customer Service Taleo Applicant Tracking Systems Talent Acquisition Sharepoint Bookkeeping Mentoring Revenue Analysis Oracle Financial Business Objects Avature Onenote Sales Process Record Keeping General Ledger Maintenance Administration

Troy Zellers Education Details

  • John Brown University
    John Brown University
    Accounting
  • Bartlesville High School
    Bartlesville High School

Frequently Asked Questions about Troy Zellers

What company does Troy Zellers work for?

Troy Zellers works for Conocophillips

What is Troy Zellers's role at the current company?

Troy Zellers's current role is Advisor I Financial Service Projects and Analytics at ConocoPhillips.

What is Troy Zellers's email address?

Troy Zellers's email address is tr****@****ail.com

What is Troy Zellers's direct phone number?

Troy Zellers's direct phone number is +191821*****

What schools did Troy Zellers attend?

Troy Zellers attended John Brown University, Bartlesville High School.

What skills is Troy Zellers known for?

Troy Zellers has skills like Microsoft Excel, Accounting, Recruiting, Interviews, Access, Social Networking, Strategic Planning, Social Media, Teamwork, Employee Relations, Employee Benefits, Customer Service.

Who are Troy Zellers's colleagues?

Troy Zellers's colleagues are Rami Zougheib, Leslie Sanders, Ron Julun, Gaute Sædberg Nilsen, Joseph Goodno, Gary Lovett, Shawn Fincher.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.