Built a custom interface to support integration of CERM orders and technology within existing Oracle EBSManaged technical processes for development of new and existing product lines involving order to cashEnhanced custom pricing engine to allow for the application of a sophisticated and robust costing modelOften worked on complex requirements that spanned multiple areas of expertise and inter-company disciplinesContinually evaluated both Oracle EBS and various interfaces and subsystems to recommend areas for improvementPrioritized development efforts and identified organizational dependencies that needed to be resolved

Supported DataTrak, the leading club management software for the health and fitness industryDeveloped customized solutions to meet individual client needs in the areas of process control and reportingInnovated key processes by introducing a repeatable framework used to execute typical support tasks as background operations that could be passively monitoredMentored staff by explaining and documenting concepts related to security, availability and reliability of the dataCollaborated with other teams to improve upon the existing database design, provide much needed security controls and deliver client requested functionalityTrained and directed offshore teams regarding business process and technical enhancementsRecovered client member data using historical data from Oracle Golden Gate replication process

Provided support for various Oracle EBS R12 modules including Human Resources, Payroll, iRecruitment, Time & Labor, Learning Management and Advanced BenefitsDeveloped, enhanced and improved reports and customizations previously implemented in Oracle EBS to meet updated business requirements and function properly within an upcoming unified R12 environmentConverted an existing mainframe based pension system to work exclusively within the Oracle EBS environmentFulfilled requests for custom reporting solutions and alerts to support FEMA related activities and validation of time card submission and approval processCollaborated with vendors, network, database and security teams to develop a framework to replace manual efforts for transmitting operational data with a secure automated solution utilizing SFTP and key authentication

Provided Oracle technical guidance and advice to Grant Thornton clients who were often facing accelerated project deadlines. The clients were leaders in industries such as online retail, manufacturing and aerospaceRetrofitted processes and RICE customizations and data previously implemented in both Oracle EBS and Lawson ERP to function properly within the upgraded R12 environmentDeveloped new interfaces and procedures for transmission of critical expense, payroll data and banking activities from client to payroll vendors, banks and other outside entitiesEnhanced and customized reports to aggregate data from different modules and systems to allow the business to have a comprehensive view of assets, capital and expenditures

Mapped, matched and loaded vendor program source data to internal custom databases for use in the distribution process using a variety of software, tools and techniquesIdentified components and completely automated a previously manual archiving processEnhanced the end of period purge procedure to allow for a complex set of conditions to be specified and executed upon for each vendorMentored staff on proper debugging and troubleshooting methods for isolating and reporting hard to duplicate errors between a heterogeneous set of applications and platforms

Retrofitted processes and customizations previously implemented in the Oracle 11i EBS to function seamlessly within the upgraded R12 environmentOne such retrofitted process included a billing interface that allowed data from customers to be directly uploaded and automatically generate the corresponding receivables and ordersAnother key customization was a consolidated invoicing module that created invoices for customers based on a flexible configuration model such that invoicing was aligned with the customer's needsConverted and enhanced custom concurrent programs related to Oracle Advanced Pricing (QP). These programs allowed for mass adjustments to price lists, denormalization of data related to qualifiers and modifiers along with building and processing all of the attribute mapping rules setup in QPSeveral converted items represented core functionality that CSG offered to its customersSome of the high profile customers receiving invoices based on this work include Comcast, DISH and MediacomUpgrading from 11i to R12 offered a great opportunity to reevaluate standards, efficiency and usability. As a result of my effort in this area, many processes were greatly simplified to work in a uniform manner across all companies within CSG. This effort resulted in a significant reduction in maintenance of the code and knowledge necessary to perform tasks related to these processes in R12

Enhanced donor management application and database to align with the strategic direction of the organizationRapid familiarization of the donor giving model and custom call center software was required to perform effectively at all levels within the organizationUtilized a combination of several languages and tools including Oracle PL/SQL, Forms, Reports, Linux shell scripts, Perl, XML and FTPThe scope of development and customization ranged from operational needs to project and milestone initiatives Partnered with Enterprise Architects and the Business Intelligence team to convert processes, structures and reports from an Oracle-based architecture to an operational data store (ODS) utilizing SQL ServerAdvised business and technical teams on recommended current and future state for technical processesExtensive knowledge of the SQL Server platform and related tools were essential including SQL Server Management Studio, Visual Studio and SQL Server Integration Services (SSIS)Strong analytical and interpersonal skills were imperative to perform technical analysis quickly and convey meaningful results to a variety of audiences

Coordinated efforts and provided guidance regarding the best practices for globally implementing financial products within the R12 release of the Oracle E-Business Suite for 92 operating units and legal entitiesAnalyzed and documented business requirements to identify gaps and clarify justification for customizations Recommended alternative solutions for successfully achieving the needed efficiency, performance and scalability needs of the enterpriseEvaluated, researched and diagnosed product defect issues using My Oracle Support and other technical and functional resources to present risk and benefit summaries to managementPerformed system administration duties including the initial setup and configuration of Oracle EBS for use in a multi-org environmentEnsured that FedEx related issues received the proper level of attention within Oracle and managed resolution expectations within FedExDeveloped roadmaps, executive summaries and other presentation materials used to clearly show the status of current issues and a projected timeline for future enhancements to be completed by Oracle or internal IT effortsDesigned non-invasive solution to allow bad debt to be processed correctly within Oracle EBS as required by the international accounting teamThe solution involved unlocking an undocumented area of the accounting processing engine and rewriting the desired accounting rules to meet the requirements of the businessIn addition, modifications were required to the underlying support structures such as views and proceduresThe solution allowed the international accounting team to continue using well established accounting protocol without the risk of a major policy change or excessive manual effortsWorked closely with functional and technical leads, Oracle Consulting and key technical development resources at Oracle was essential

Analyzed, documented and presented insightful information regarding how to improve functional processesGathered business requirements used to implement AR lockbox functionality with customizationsResearched and planned integration of iPayments with existing products and merchant account providerAdvised functional groups on solutions to Oracle technical issues encountered using various modules

Established technical strategy and approach on project to convert financial accounting and reporting from an IBM mainframe system to Oracle EBS General LedgerFacilitated effective communication between IT application groups impacted by the transition of the GL functionPromoted a conducive forum for extraction and prioritization of business requirements in order to ensure a detailed technical design was completed within agreed upon project timelinesCommunicated and coordinated with a variety of personnel from developers to the Assistant Controller of Finance in managing expectations and charting progress at each stage of the process