SUMMARY:

• Multifaceted professional, powered with extensive information technology and business process experience in diverse industries. Demonstrate in - depth understanding and big-picture vision of key projects, with proven adeptness in managing all facets of project life cycle development.
• Decisive and direct in managing cross-functional teams toward achievement of company objectives.
• Exhibit strong ability to identify primary success factors and carry out strategic decisions to ensure both short-term and long-term positive impacts.
• Effective problem solver, motivator, and leader; able to design innovative solutions, facilitate strategic software projects and initiatives, and centralize customer interaction to deliver optimal results.
• Proven track record of efficiently determining and meeting client needs, crucial in amplifying competence, reducing needs for re-engineering, achieving operational efficiency, and surpassing company goals.

TECHNICAL SKILLS:

Databases: Oracle 7X, 8, 9i,10g,11g

Database Tools: SQL*Plus, SQL*Net, Microsoft Query

Development Skills: Oracle Developer 2000, Form Builder v5.0, Forms v4.5, v6.0, Report Builder v6 (Reports 3.0 & 6i,9i)

Applications Rel 11i: Oracle (11i, R12) Applications in Manufacturing (PO, INV, OM), Financials (AP, AR, GL, CRM, Workflow), Functional and Technical Specifications (Process Flow Diagrams, Oracle BOM/Engineering, Flow Manufacturing, Purchasing, Quality, Order Management and Shipping Modules)

Languages: C, COBOL, PL/SQL, HTML

Hardware: HP 9000, EMC, Pentium and IBM PC-AT, Dec Alpha

Operating Systems: Windows NT, Windows 98,UNIX

Network Products: TCP/IP

Other: Exceed, Access, Microsoft Project, Tidal

PROFESSIONAL EXPERIENCE:

Confidential, bloomfield, CT

Oracle Application Developer

Responsibilities:

• Designed and construct contract process using Oracle Package to reduce manually inputting information into Clarity PPM System
• Develop NSQL statements to give customers more flexibility in Clarity PPM System
• Created Utility Oracle Package with regularly used Oracle Used functions to promote modularity, encapsulation and generally a more effective and organized process
• Created Oracle Package to convert GL data from BPCS Legacy system to Oracle General Ledger
• Created Oracle Procedure to convert open invoices to Oracle Account Receivable
• Used Business Objects to create custom reports for the general business community which uses Clarity PPM.
• Constructing Best Practices coding document for the entire department
• Constructed Oracle Package to capture errors, using autonomous transaction mechanism
• Involved with service pack application integration testing using Quality Center
• Utilized Sqlloader to load data into custom tables

Confidential, Alexandria, VA

Oracle Application Developer

• Fabricated claim workflow main software to obtain and coordinate new claims data from existing claim payment systems; validated and navigated claims through the entire workflow process until the claims were paid by the company
• Initiated roles and security packages to allow individual with a given right/privilege to access the claims at different stages
• Facilitated regular meetings with other developers to ensure that the path of intent progress was clear; advised by project sponsors to confirm that intended business goals remain in focus
• Instituted Workflow Email Oracle Package to streamline processes in dispensing emails to the necessary individuals, verifying accuracy on claims in the RED STATUS were prioritized and attended ASAP
• Utilized Sqlloader to load data into custom tables.
• Instrumental in writing the functional documents for the Batch, Escalation rules, and Security aspects of the Claims Workflow Process

Confidential, ORLANDO, FL

Oracle Software Engineer

Environment: Oracle 10g, TOAD 9.7.3, Cognos 7.3, Windows XP, PL/SQL, Informatica 7.1, UNIX, Oracle Application R12

• Pioneered Invoice Retro Billing System used in updating existing invoices in Deltek tables with changed invoice data
• Created Oracle Package to convert GL data from BPCS Legacy system to Oracle General Ledger
• Led the process for establishing code manual for the entire ITS department
• Took an integral part in requirements gathering, data analysis, and database modeling; coordinated with IT partners in the design and execution of database solutions and tools
• Codified functional specification documents for Retro Bill, Customer Alias, Sales Tax and other high visibility processes
• Created Oracle Procedure to convert open invoices to Oracle Account Receivable
• Maintained essential ETL programs which transfers data from various sources to the dataMart
• Cultivated positive relationship with key stakeholders involving internal clients and other IT application teams
• Successfully wrote a technical documentation for the Retro Bill invoice process by extensively interfacing with all customers
• Reengineered the Customer Alias package to add zeroes or not to add zeroes base on specified conditions
• Revised Timesheet Sign package to account for customers’ requests to change timesheets

Confidential, Basking RIDGE, New Jersey

Technical Project Lead

Environment: Oracle 9i, Cognos 7.3, Windows XP, PL/SQL, Informatica 7.1, UNIX

• Led the development and implementation of CR048 payroll worldwide business solution to compensate internal and external sales representative based on sales-oriented activities that transpired for a particular month
• Written functional specification documents for numerous aspects of the CR048 payroll process
• Created ETL process using PL/SQL packages to insert data into the data DataMart
• Maintained existing ETL package processes for the data warehousing environment
• Facilitated project-related activities relating to requirement evaluation and analysis through the AIM methodology
• Generated an order system that loaded XML in Oracle custom tables and implemented all facets of business functions
• Oversaw the entire Oracle Database Department from modification of the change management process to proper coding standards

Confidential, Greensboro, North Carolina

Oracle Application Developer

Environment: Oracle 10g, Oracle Applications R12 (Modules (PO, INV, OM, AP.AR, GL)) Forms 6i, Reports 6i, PL/SQL, Windows XP, UNIX.

• Initiated and executed a PL/SQL conversion boat invoice process that imported header and detail data for orders transported from China
• Developed order process that validated different data after which multiple Oracle reports will be initialized from within the procedure to enable the distribution of PDF and Excel format to the factories
• Created label files for different inventory organizations through the development of PL/SQL procedure
• Employed the CLOB in loading huge shipping instructions into custom table that direct shipment process utilized to associate with corresponding orders
• Built PL/SQL procedure to flag new items and related UPC code and other data

Confidential, Bronx, New York

Oracle Application Programmer

Environment: Oracle 8i, Oracle Applications 10 (Manufacturing (PO, INV, OE, Bills of Materials (BOM), WIP), Financials (AP, AR, GL, Cash Management), Forms 6i, Reports 6i, PL/SQL, TOAD, Windows 2000, UNIX.

• Conveyed ideas and knowledge with various business analysts and other pertinent individuals during regular meetings to ensure smooth flow of business processes, in coordination with functionalities that Oracle Application possesses
• Significantly contributed in formulating functional requirements documents for AR, GL and OM conversions processes
• Designed package and a view that served as the basis for all Collection Aging reports
• Redeveloped the Oracle Standard Adjustment Cycle Count Report to suit the custom need at Kronos Incorporated
• Wrote UNIX Shell script to load data into the custom temporary table and run the current program for loading data from different legacy systems
• Utilized Oracle report to develop a Cross Charge Expense report to reposition funds to proper cost centers

Confidential, Bronx, NY

Oracle Consultant

Environment: Oracle 8i, Oracle Applications 10 (Manufacturing (PO, INV, OE, Bills of Materials (BOM), WIP), Financials (AP, AR, GL, Cash Management), Forms 6i, Reports 6i, PL/SQL, TOAD, Windows 2000, UNIX.

• Significantly contributed in formulating functional requirements for importing BOM and technical design documentation
• Took part in the execution of Oracle Distribution Suite modules, including order entry, inventory, purchasing, and shared bills of material
• Aided in conducting customer conversions by loading the data from the flat file, directly to the Oracle standard interface tables (Inventory Tables)