Frederick Sabella Email & Phone Number

Tyler, Texas Area

• Put a roadmap for data conversions as required for Ingersoll Rand Residential HVAC Business Unit to load into the Limited Warranty Management System-WMS.
• Subject Matter Expert for processes including but not limited to Product Registration, InstallBase, Customer, Product, Claims, and Debit/Credit Memo submissions to Oracle R12 E-Business suite.
• Helped the Residential HVAC business with identifying the sources of data needed and the understanding of how the data is used by the system.
• Setup a workhorse Oracle database that is linked to all data sources identified; created tables, views, PL/SQL functions, procedures, and packages for data extractions and utilized Alteryx tool for data loads and.
• Supplied test data for various functionalities of the WMS.
• Prioritized and adapted to wave deployment of WMS and supplied data as per aggressive deadlines.

Tyler, Texas Area

• Led and represented Residential HVAC Strategic Business Unit in Phase 2 of enterprise Oracle R12 E-Business suite integration. Served as Subject Matter Expert and integration lead for several key applications, met very.
• Streamlined response to Strategic Business Unit and Enterprise demands for software enhancements and new business initiatives, by enforcing alignment with company goals, managing expectations and shortening delivery.
• Led and migrated Marketing and Sales 38 Windows 2003 servers hosting applications and databases to Windows 2008/2012 servers. Worked through procurement challenges, limited resources, and technology challenges..

Tyler, Texas Area

• Led cross department project team for the delivery of Electronic Rebate System that handles approximately 80 million dollars in claims a year utilizing agile project development process. Converted manual paper based.
• Designed, managed, and participated in the construction of the migration processes of twenty years of Extended Warranty information to Tavant Warranty Management System, cleansed 20 years of a proprietary legacy system.
• Documented business processes and procedures for designated SOX (Sarbanes-Oxley) systems, including mitigation plan for non-compliance, and designed and implemented recommendations to ensure SOX compliance. Developed a.

Tyler, Texas Area

• Contributed to the success of the home grown Pricing System, addressed VB6 price engine performance and flat file pricing integration by writing Price Engine and Price Book packages using Oracle PL/SQL. Designed and.
• Reduced shipping costs by re-writing Extended Warranty print program to enable the mail/sorting machine to insert four specific dealer contracts in one envelop in place of one contract. Saved company around $60,000.00.
• Integrated Extended Warranty agreement information with Third Party Partner Company and enhanced the Extended Warranty print program to create XML file and securely FTP to partner company. Effort resulted in.
• Decreased by 90% data surgery requests related to limited applications functionalities by creating custom intranet web ASP pages. Provided user community the tools to get their job done accurately and in a timely.
• Served as mentor and SQL / PL/SQL resource for team members and associates.

Tyler, Texas Area

• Developed and programmed several accounting modules, including general journal, general ledger, encumbrance journal, work order, payroll, account payable and receivable, billing and others using 4GL language, Informix.
• Wrote the majority of the reports for above modules using SQR software. Deployed these modules, setup database, loaded converted data, and provided stabilization onsite support in the country of Cyprus.
• Sought out consistently by peers for technical and troubleshooting support as well as general problem-solving. Mentored developers on best practices for using SQR and Informix New Era language.

Graduate Certificate In Health Information Management (Him)

Bachelor’S Degree, Computer Science

Associate’S Degree, Computer Science

Activities and Societies: Phi Theta Kappa