TracFone Wireless, Inc.
Miami, FL, United States
Compliance, Accounting, Sql, It
TracFone is seeking an individual to support the Lifeline data compliance reporting area in the Accounting Department with a dynamic and collaborative professional having extensive experience to create and maintain Oracle SQL or any SQL language programs, advanced data analytical skills, strong excel, including financial business knowledge, excellent communication and documentation skills, develop complex data migration, perform in depth data analysis and make data determinations to support the Director with the various data deliverables related to the 44 participating Lifeline states, federal filing preparations, legal investigations/subpoena, and support business processes, compliant with FCC and state specific Lifeline guidelines. The information determined will support compliance requirements for report filings with the State government offices, audits and legal investigations.
Manage and control the Lifeline data deliverable for the 44 states, create, merge, analyze and maintain system queries/tables with the use of Oracle SQL Developer for and State monthly, quarterly, semi-annual ETC compliance report requests of Lifeline customer data. This includes deploying complex data reconciliations and analyzing support for claiming federal reimbursement and prior period monetary revisions due to USAC or other state administrator.
Develop numerous MS Excel Macros with Visual Basic to automatize reports and facilitate processes which includes, monthly reimbursement filings and State Audit Reports. Maintain an automated process for report creation of manual filings for prior years, merging MS Excel with Acrobat Pro in order to process monetary revisions. Provide process automation recommendations when identified. Review and address customer duplication, eligibility resolution, household disputes and issues; meet with other business owners to collaborate timely responses.
Provide Director with the required data support for, State filings and audit requests for compliance with Lifeline guidelines. Support Lifeline internal legal investigations requests and perform root-cause analysis to identify issues, concerns with complex data reconciliation and provide recommendations. Seek information from external administrator(s) for customer information in support of audit requests.
Bachelor Degree required. Major in Computers, Management Information Systems, Accounting Business Administration, Engineering or related discipline.
5-7 years experience required in computer/technical advanced related field or business environment. Extensive experience with Oracle SQL or any SQL language, MS Advanced Excel, Access, Visual Basic.
Must have excellent, strong communication and documentation skills.
Miami, Florida, United States
TracFone Wireless, Inc.
Website : http://www.tracfone.com
We offer the least expensive way to own and use a cell phone in America. No contracts, credit checks, activation charges or cancellation fees and no surprises! Brand name phones from leading manufacturers like Motorola, LG, and Samsung. Choose from simple "Candy Bar" phones, to Bluetooth® enabled Phones. Airtime is purchased online, from your phone or from 90,000 retailers throughout the country. Retailers