Summary

Technically sound, innovative and flexible IT professional offers 11 years of expertise in Oracle development tools including Oracle Forms, Reports, and Workflow, SQL Plus PL/SQL, UNIX shell scripting, software development, support, system/business analysis, implementation and upgrade using AIM methodology. Goal-oriented over-achiever rises to any challenge, consistently delivering complex projects and high quality programs that improve functionality of existing applications ahead of schedule in order to maintain long-lasting and trusting relationships with customers. Team-player exhibits a share your wealth of knowledge attitude, collaborating and mentoring team to align to the business requirements.

AREAS OF EXPERTISE

CAREER HIGHLIGHTS

• Served as technical lead on Oracle upgrade project, ensuring timely execution of the project with oversight of a group of consultants and developers.
• Acted as senior team member during implementation of AR module, applying checks and balances in the programs to reduce exceptions and improve efficiency. Implemented Cash Management module un-assisted with a quick turnaround time.
• Initiated and developed a self-invoicing module PEAS as an extension of Oracle E-business suite, to reduce the time of the manual process to save RCN Corp roughly 600,000 in annual recurring expenses.
• Received RCN Top Performer Award 2004, 2005, 2006, 2007, 2008 for consistently exceeding customer expectations, delivering high-quality services, performing with uniquely high standards and demonstrated leadership.

QUALIFICATIONS IN ACTION

LEAD APPLICATION DEVELOPER

SR. APPLICATION DEVELOPER

Confidential

• First engaged by Telecom company as Senior Application Developer addressing the needs of 8000 employees. Promoted to Lead Application Developer, developing, modifying and enhancing programs and implementing changes while troubleshooting system problems within Oracle E-business suite and empowering users with automation.
• Completes enhancements on pre-existing programs, gathering business and user requirements and translating them to the technical solution best suited to business needs.
• Provides full technical functional support to AP, PO, CE, INV, FA, PA, AR, i-Expense and i-Procurement GL modules and expertly makes the most of Oracle Application Object Library.
• Compiles user requirements and enters findings into functional specifications documents and after approval, develops and tests program before writing out technical documentation.
• Improves analysis and insight into data by creating reports in all of the modules utilizing Oracle Reports and Oracle Discoverer resulting in the ease of exporting into Excel spreadsheets.
• Plays an active role in the development, maintenance, support and improvement of critical interfaces and processes to be user friendly, implementing pgp/gpg encryption and decryption for data protection and working continuously with internal and external IT auditors for SOX compliance.

Confidential

Regionalized account creation through the modification of FA Account Generator Workflow.

PROJECT HIGHLIGHTS INCLUDE:

• Accounts Receivable: Implemented AR module and integrated VERTEX for the commercial division, working with and supervising 4 external consultants to ensure that user requirements and 40-50 customization goals were met.
• Developed the Service Contract module which houses telecommunication contracts with the customers, contributing to the development of a process to interface data from Service Contract module with the AR module for accurate monthly billing.
• Showcased adept ability to collect data and perform set ups including, but not limited to, Line Transaction Flexfield, Autoinvoice, Transaction Types, Transaction Sources and Grouping Rules.
• Utilized root-cause analysis skills to eliminate inefficiencies and perform post-production troubleshooting in underlying business process issues within Service Contracts, Oracle AR, Vertex and TCA/Customer Master.
• Conceived and extended custom processes to include Late Fee and billing adjustment requirements.
• Improved processes to ensure that the integration, maintenance and support of the vertex communication tax Q series was properly executed and kept in place.
• 11i Upgrade from 11.0.3 to 11.5.10.2: Served as technical lead on upgrade of Oracle EBS, managing a group of consultants and developers while creating solutions to improve processes and meet company objectives on-time and on-budget.
• Leveraged technical and business knowledge in order to comprehend the existing customizations and to come up with viable options to tune queries in custom modules so that they are faster and more efficient.
• Upgraded all interfaces, Oracle forms, reports and custom applications to 11i, and used Forms Personalization and Custom.pll to address market specific needs.
• Received accolade of Top Performer for diligently handling Oracle upgrade project spanning accomplishments such as tuning of queries and augmenting performance related to Cost Base Optimized database.
• Cash Management: Took full charge of the implementation process, completing the set up of the Cash Management system using AIMS methodology so that the information on cashed cheques is processed and automatically reconciled in Accounts Payable.
• Conducted close analysis and mapping of bank transaction codes in order to configure BAI2 feed from the bank back into Oracle Cash Management module.
• Made the process of loading and processing of daily inbound feed an automated process while integrating new bank accounts in CE module.
• Programmers Expense Analysis System PEAS : As technical lead, single-handedly designed and developed this automated self-invoicing module as an extension to Oracle application in 10 months, to better enable networks to ascertain viewership and to process payment of programmers Cable Networks using billing data from billing application. Fully complied with SOX auditing rules and received applaud from auditors.
• Contributed to savings of 600K in annual recurring costs by conceiving developing the project and extending the module with VOD and premium channels add-ons, fashioning tool kits and best practices to circumvent potential discrepancies in set-ups, boosting user friendly exception handling routines and enabling audit trails.
• Created 25 forms for entry screens and developed file load automations, the Business Rule Engine and 20 different reports using Oracle Tools when fashioning user-friendly invoice and accrual interfaces and facilitating easy upload of journal entries.
• Capital Authorization Request CAR : Spearheaded and served as sole executor of project funding request application in EBS, a tool embedded with Oracle Workflow enabling users to submit and gain approval from a series of predefined approvers while enabling attachment functionality, budget distribution forecasting, also allowing CAR reversions to be maintained for any change in the request, interfacing finally with Oracle Projects.
• IPM Imaging and Process Management: Aided in the integration and implementation of paperless process for filing PO and Non-PO related invoices and expense reports within E-business suite, creating a system whereby barcodes are attached to the transactions for easier tracking and approval in IPM. A process was developed to import invoices into AP after Non-PO related invoices completes approval process.
• Revenue Database: Designed and developed a data mart using AWK and PL/SQL to ETL, validating and summarizing complex multi-file revenue data from mainframe billing application by market and integrating it to General Ledger module with distinctive checks and balances to handle exceptions and completeness of the process.
• Major Interfaces and Processes: Developed, maintained, supported and improved a range of critical interfaces, including creation and transmissions of positive pay file to the bank through Positive Pay interface, performing ACH set ups for NACHA payments and processes to create and transmit ACH, P-Card, and Check payment files to the bank through Payment Advantage interface, integrating HR and payroll data from an external source into Oracle EBS establishing employee hierarchy, position hierarchy, web signing limit and maintaining employee status in Oracle through HR interface.
• Mergers and Acquisitions Neon, ConEd, CCS, LIFE : Imported legacy data, developing an innovative process to import vendors, vendor sites and open invoices following acquisition of Neon and ConEd. As part of Neon, CCS and LIFE acquisitions, imported active customer AR , open balances and aging, AR invoices and active service contracts into AR module. Also provided essential support and manage data integration during mergers and acquisitions. Scrubbed and prepared Fixed Asset mapping files to be loaded through Oracle ADI.
• XML Publisher: Using this Oracle tool, migrated check printing solution from Paybase Bottomline to Oracle EBS, saving 50,000 annually in licensing and support fees. Created templates for printing of cheques and purchase orders, dynamically assigning signatures for various bank accounts on printed cheques and buyers in purchase orders.

COMPUTER APPLICATION PROGRAMMER/SR. APPLICATION DEVELOPER

Confidential

• Selected for this contract position to design develop various forms and reports in a plethora of Modules of Oracle Financials Project Accounting, General Ledger, Purchasing, Inventory, Accounts Payable, Fixed Asset Modules while customizing Oracle Workflow to setup approvals and custom notifications in Oracle.
• Provided consistent support to end-users on issues pertaining to Markview, iExpense, day to day problems and Ad-hoc reporting needs, quickly responding to all queries with professionalism and tact.
• Utilized expertise with AP interfaces to effectively extract data from Real Estate Application housing rent/building access contracts and interfacing to Oracle Accounts Payable to load invoices.
• Implemented audit controls in workflows including email alert notifications and embedded region specific Business Managers in approval hierarchies.
• Leveraged Oracle Forms and PL/SQL expertise to create market specific Internal Requisition in Purchasing module.

TECHNICAL SKILLS