Kim Dilts Email & Phone Number

Orange County, California, United States

Business Analyst and IT Support

Oracle Database DBA, Oracle Applications (EBS) DBA, Oracle Agile PLM Administration, Oracle Software Installation, Linux Administration Support.

Oracle Applications DBA

• Designed, implemented and managed multiple telephony usage Oracle analytic repositories – one implementation exceeded 16 terabytes• Responsible for performance tuning and operational support of production real-time rater Oracle databases• Designed and implemented a telephony call detail reconciliation system • Designed and implemented the Oracle database for Primal’s Revenue Assurance Dashboard• Responsible for operational support and administration of multiple customer Oracle databases• Automated critical operational processes for Primal’s Operations team• Worked closely with customers – gathering requirements and providing operational support

• Developed processes for collecting, manipulating and outputting detailed usage information for customer billing. Extensive experience in converting various telephony switch/industry standard billing formats into billable events• Improved the accuracy and decreased the elapsed time to install Primal’s AccessIM mediation, Rating engine and Web Presentment Module products• Primary project manager for the Outfront Usage Analysis data mart module – led a team of 5 that designed and implemented a telephony usage analysis reporting and monitoring solution to add to the Outfront suite of modules• Designed and built the first prototype of the Outfront Customer Analysis Portal – a first of its kind targeted customer monitoring data mart and reporting solution

• Directly supervised 5 developers in the ongoing development of an International Banking Software package (IBS) – responsible for coordination, development, maintenance and system administration of IBS which consisted of over 7000 functions and 1800 files. Worked closely with the customer to gather requirements

• Implemented S.W.I.F.T. messaging both outbound and inbound for Trade Finance, Money Transfer and Treasury products• Assisted in the development and maintenance of Letters of Credit, Collections, Reimbursements, Money Transfer (including the Core) and Bills of Exchange.

• Designed and developed custom order processing and purchasing software for one of the largest ceramic tile importers in Los Angeles• Designed a program to interface between the Qantel Report Generator and a PC based database application• Designed a Progress based Mail/Courier Billing system fully integrated with Varnet A/R and G/L• Designed and implemented a custom RMA system and automated bar-code order picking/shipping module for a major medical manufacturer and distributor• Provided customer training and on going support for application software as well as system administration

• Primary programmer on a custom distribution software package for a clothing warehouse company and a multi-marketing firm.• Gained extensive knowledge of accounting, distribution, manufacturing and job cost by customizing, maintaining and supporting several clients’ systems