Jonathan Squire Email and Phone Number
Jonathan Squire work email
- Valid
- Valid
Jonathan Squire personal email
- Valid
Experienced SQL Developer/Data Engineer, specializing in client migrations between legacy platform and newly implemented systems, with a demonstrated history of successful utiliziation of SQL Server, Microsoft SQL Server Integration Services, and report development with Microsoft SQL Server Reporting Services.In my current role, I assist external clients with migrating existing legacy recruiting systems to Bullhorn's ATS platform. In addition to development of custom SQL coding to accomplish this task, I also work with clients to both develop the core requirements and to develop reporting solutions, utilizing Bullhorn's IBM Cognos powered Canvas Reporting.Prior to my current role, I was a Systems Analyst at Tourico Holidays, where I was a member of the Financial Systems team. In this role I was responsible tier 2 support of financial applications, the development of ETL solutions to combine multiple complex data sets (150 million+ rows), writing new, and maintaining existing, SQL code, and designing reports utilizing Microsoft SSRS. Previously, I've held multiple billing systems positions within the End User Billing department at Frontier Communications. In these roles I was involved in multiple large multi-billion dollar acquisitions, specifically in the role of data conversion and mapping of legacy billing products from multiple data sources (DB2, Arbor, Oracle, etc.) to newly established billing codes in the target system (DB2).Specialties: MS SQL, Oracle SQL, SQL Queries, Adhoc Reporting, Automated Reporting, ETL Development, SSRS, SSIS, Excel, Financial analysis, Revenue Assurance Operations, Contractual Compliance, Month End Settlements, Video Content, IBM Cognos, Bullhorn Canvas, Integration, Migration
-
Data Engineer Team LeadNewbury PartnersSouth Carolina, United States -
Data Engineer Team LeadNewbury Partners May 2022 - PresentDaytona Beach, Florida, United States -
Data EngineerNewbury Partners Jan 2019 - May 2022Daytona Beach, Florida AreaAnalyzes client data, assists Sales Director and team with scoping Level of Effort for new projects, and coordinates implementation of complex data migrations in conjunction with Project Managers and clients to achieve successful migration from legacy recruiting ATS/CRM systems to Bullhorn’s ATS platform. Provided team lead support to Senior Vice President, Technology over the course of several months during high growth period in the business until a proper fit for a management role could be found.• Successfully migrated numerous clients from more than 20+ unique legacy platforms, including bespoke systems• Delivered one of the most complex data migration projects undertaken in the company’s history, resulting in a successful Bullhorn migration for an Enterprise client who previously failed multiple times to implement Bullhorn successfully• Lead product testing and migration from an internal homegrown file server to a files.com system, including establishment of best practices to ensure efficiencies and minimize monthly surge costs•Provided training to team members, existing and newly hired, on best practices and procedures for data migration projects• Developed training documentation covering complete end-to-end processes to aid in ramp-up of new employees• Lead Engineer on the Newbury team for the PrismHR Payroll project, including developing standardized templates and workflows to ensure all necessary baseline data is delivered on each project• Automated key pieces of the PrismHR Payroll process to reduce labor hours by approximately 75% per data export request received from the PrismHR team• Works closely with Project Management team to achieve client goals within scope of Statement of Work and project budgets• Constructed “standardized” migration scripts for most common legacy platforms• Utilized advanced SQL concepts including PIVOT, UNPIVOT, CTEs-based updates/deletes, etc.• Builds custom reports utilizing Bullhorn’s Canvas system -
Systems AnalystTourico Holidays Aug 2017 - Jan 2019Orlando, Florida Area• Supported financial & accounting systems• Developed and supported multiple Microsoft SQL Server databases• Supported the development of an MariaDB database• Designed and developed SQL code for financial and operational reports• Converted existing SQL code into stored procedures to enable automation via SQL Server Agent Jobs• Developed financial reports utilizing Microsoft SQL Server Reporting Services• Assisted Vice President of Finance with the maintenance of QlikView modules• Established the automation of hourly, daily, weekly, monthly and quarterly reports for finance teams• Tuned legacy SQL code to increase processing performance• Acted as Tier 2 support to IT teams for finance applications and reports• Automated ETL solutions to reduce or eliminate manual processes related to refreshing various reports• Designed data conversion solutions to load data from multiple platforms into a consolidated reporting database -
Senior Financial AnalystFrontier Communications May 2016 - Aug 2017Deland, Fl• Participated in the generation of SQL queries utilized for monthly video settlements process• Tasked with the execution of monthly, quarterly and ad-hoc SQL reports• Responsible for monthly reporting utilized by team for generation of vendor invoices• Supported the Billing Manager with the generation of settlement invoices for over $50m per month• Prepared monthly subscriber penetration/activity reports for internal partners and external vendors• Interacted with Video Product Management to determine cost of sales on a holistic and granular level• Contributed to system enhancements and upgrades, including rollout of new internal tools • Responsible for vendor relations• Participation in new video market roll-outs• Submission of monthly payments to Infinium financial system• Reviewed contracts to validate contractual compliance• Provided guidance to Product Management on content costs per geographical area• Revenue Assurance Operations related to contractual compliance and validation of accurate rates being paid on a monthly basis -
Senior Systems AnalystFrontier Communications Aug 2014 - Apr 2016Deland, Fl• Prepared reports and analysis for management (7, 30, 60 and 90 day)• Supported revenue assurance operations using advanced SQL queries• Tasked with the design and development of SQL queries to validate successful system changes• Lead product mapping for integration of billing codes for the acquisition of Verizon’s “CTF” properties• Assisted with product mapping and conversion of billing codes for the acquisition of AT&T’s “CT” properties• Documented all new billing codes and processes for internal audit compliance and testing purposes• Acted as technical liaison and provided feasibility and functionality guidance to business and Information Systems partners on complex projects• Managed projects on behalf of DPI Tables team to ensure all deadlines and SLAs were met• Delivered sign off on requirements, test cases, and “go/no go” decisions for complex projects• Exceeded individual goal of recovering a minimum of $100,000 in lost revenue, per year• Tasked with creating ad-hoc SQL queries to validate customer billing• Involved in complex product requests, for both new and existing portfolios• Key presence in new product launches, promotional planning, and systems functionality analysis• Provided day to day billing systems support through internal trouble tickets• Delegated and monitored work assignments for Billing Advisers• Coordinated requests for bill messages with billing systems corrections -
Senior Billing AnalystFrontier Communications Dec 2012 - Aug 2014• Acted as technical resource and provided feasibility and functionality guidance to business partners for both minor and major projects• Key presence in new product launches, promotional planning, and systems functionality analysis• Responsible for documenting new processes and procedures within the department• Delegated and monitored work assignments for Billing Advisers• Worked with accounting, finance, marketing and regulatory teams on reporting• Tasked with creation of SQL queries to validate customer billing and/or successful launch of new products and services -
Billing AdviserFrontier Communications Oct 2012 - Dec 2013• Responsible for creating and supplying contract priced products to account executives• Monitored HEAT ticket queue and resolved billing system concerns as needed• SOX compliance and adherence• Tasked with DPI Tables configuration and maintenance -
General Manager SpecialistFrontier Communications Oct 2010 - Oct 2012• Worked closely with mid-level and senior field, contact center, corporate, legal and regulatory management teams• Responsible for providing resolution to high-profile corporate escalations• Tasked with responding to and addressing regulatory complaints• Developed training updates on key subjects, including vital requirements by regulatory bodies and system updates/changes• Prepared hourly and daily reports for senior corporate management -
Customer Service SpecialistFrontier Communications Mar 2008 - Oct 2010
Jonathan Squire Skills
Jonathan Squire Education Details
Frequently Asked Questions about Jonathan Squire
What company does Jonathan Squire work for?
Jonathan Squire works for Newbury Partners
What is Jonathan Squire's role at the current company?
Jonathan Squire's current role is Data Engineer Team Lead.
What is Jonathan Squire's email address?
Jonathan Squire's email address is jo****@****ail.com
What schools did Jonathan Squire attend?
Jonathan Squire attended Southern New Hampshire University.
What are some of Jonathan Squire's interests?
Jonathan Squire has interest in Collecting Antiques, Exercise, Sweepstakes, Nascar, Home Improvement, Shooting, Reading, Gourmet Cooking, Sports, The Arts.
What skills is Jonathan Squire known for?
Jonathan Squire has skills like Telecommunications, Vendor Management, Call Centers, Project Management, Integration, Sql, Reporting And Analysis, Business Analysis, Revenue Assurance, Team Leadership, Business Intelligence, Analytical Skills.
Not the Jonathan Squire you were looking for?
-
Jonathan Squire
Princeton, Nj5comcast.com, gmail.com, dowjones.com, dowjones.com, amazon.com3 +185665XXXXX
-
Jonathan Squire
Louisville, Ky4momentive.com, dowjones.com, hexion.com, hexion.com -
5gmail.com, cedarcrest.edu, cedarcrest.edu, rosemont.edu, moore.edu
4 +121528XXXXX
-
-
Jonathan Squire
Massachusetts, United States
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial