OBJECTIVE

A strategic, focused, and business oriented senior technology manager with 25 years of experience in information technologies. To make a significant technical contribution to a growing/progressive organization in the areas of Oracle applications, EDI and software development.

SUMMARY

• Over 25 years' experience as an IT professional with extensive experience in EDI Project Management, Oracle Development and ERP Integration.
• Visionary IT leader with a track record for defining, building and optimizing best-in-class IT infrastructures and operations.
• Recognized for defining enterprise technology strategies/solutions that reduce costs, improve efficiencies, support organizational goals and maximize the technology investment.
• Highly valued strategic partner at the top management levels
• Proven track record of identifying and understanding business needs for Information Technology.
• Extensive experience in managing all aspects of EDI life cycle from the establishment of trading partner relationships to the design and integration of EDI business models.
• Ability to establish and maintain effective working relationships with senior level executives as well as to work closely with associates on the project team so that the nature of the work is always collaborative with everyone participating in the process.
• Excellent oral and written communication skills.
• Resident go-to person and resident expert for analysis and solutions.

TECHNICAL SKILLS

• Gentran EDI Applications, Cyclone AS2 Protocol, Salesforce.com CRM
• Oracle 10g/9i/8i/7.0, SQL, PL/SQL, Procedure and Functions, Pro-Cobol SQL Embedded , MF Cobol, Cobol 74, DMSII, UNIFY, DMS1100
• Oracle Discoverer Reporting, Oracle Forms, Oracle Report Writer, SQL Plus, SQL Loader, DDL, SDDL, ADMLP, MAP, ERGO, CANDE and JCL Commands
• Windows, HP-UX, UNIX, MCP, OS-1100, EXEC 1100
• HP 9000, Unisys A Series, Unisys 1100/60 C1, Horizon III.

EXPERIENCE

Confidential

• Provided technical leadership and direction to cross functional teams operations, sales, marketing, and technology.
• Responsible for Project Management activities including project scheduling and phasing.
• Spearheaded new technology research, product and vendor evaluation.
• Led the upgrade process of Oracle database from 8i to 10g including the setup of the 10g Oracle development environment.
• Oracle Discoverer Administrator for multiple EUL's production issues.
• Coordinating presentations and workshop sessions and managing tasks
• Liaising between users and consultants to resolve specific business needs and coordinating technical enhancements of systems and reports.
• Interfacing with users, identifying functional and technical gaps, estimating work, architecting system interactions, designing custom solutions, leading developers and preparing documentation.
• Documented business rules, functional and technical designs, test cases and user guides.
• Configuration, installation and administration of the company's electronic EDI order systems install and configure trading partner data and mappings for new EDI documents.
• Write and debug scripts and programs that run the EDI software on WIN/NT servers.
• Create and run test scenarios against mappings to ensure correct operation.
• Maintain daily EDI data communications, quickly resolving exceptions that may arise.
• Working with trading partners to determine requirements for implementing new EDI documents or updates.
• Lead, coordinate and administer key process improvements in both legacy and new Internet based EDI implementations.
• Designed and created an interface between custom application and order processing system.
• Designed and generated database objects and Oracle Forms, Reports, and Libraries through Oracle Designer.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.
• Responsible for data cleanup and conversion/migration task using Oracle Warehouse Builder 10G R2, to migrate mainframe legacy to Oracle eBusiness Suite.
• Analyzed Discover EUL and submitted enhancements for improved end user productivity.
• Analysis, Design and Implementation of Oracle Discoverer queries.
• Generated Oracle Discoverer and Report Builder reports based on report requirements.
• Assisted in a complete business process redesign for all sales function within the company.
• Supported Salesforce.com CRM users - maintaining profiles, access and security requirements.
• Developed complex matrix reports to summarize information for Senior Management.
• Developed complex analysis procedures to integrate data between Saleforce.com CRM and internal systems.
• Performed all administrative functions as needed and required for the Salesforce.com CRM.
• Troubleshot, fixed and implemented bug fixes and enhancements within tight deadlines.
• Major clients Wal-Mart, Sears, Kmart, C S stores, Shop Vac, Tacony, Home Depot

Confidential

• Involved in requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, preparing training guides, training end users and production support.
• Developed an in-house Oracle 8i data warehousing system by converting data from DMSII database to Oracle database data was populated by using SQL Loader Developed all DDL and DML statements.
• Performing the day to day maintenance of data warehouse.
• Installed and configured Oracle Developer suite environment on Development machine.
• Worked as an EDI specialist and created more than 100 GENTRAN EDI 810, 850, 856, 820, 816, 864 maps and partner profile setup.
• Created more than 250 matrix reports using Oracle Discoverer.
• Mentored junior programmers in Oracle database design and development.

Confidential

• Led teams of system designers, software developers and testers to project completion.
• Managed various large scale oracle application projects.
• Spearheaded new technology research, product and vendor evaluation.
• Provided technical leadership and direction to cross functional teams, responsible for transformation of legacy systems into oracle.
• Involved in all phases of software development lifecycle - analysis, design, technical specification, database architecture, programming, testing, implementation system maintenance and support.
• Drive the analysis and requirements activities associated with a given project or initiative and design the specifications.
• Designed, developed prototype forms, reports in Oracle and developed all the major modules in the ERP system.
• Responsible for creating and validating data and loading it to Oracle tables.
• Coded various Pro-Cobol programs and procedures.
• Coded database triggers to audit various databases.
• Created and debugged various kinds of Database objects including PL/SQL procedures and functions, tables, triggers, constraints etc. to support various areas of development as well as maintenance and support of the Application.
• Conducted training sessions for users.
• Projects:
• Part Disposal Order System
• Aim: Auto generation of part disposal orders, dispatch advice, inspection tags, and material requisitions for other divisions and generates shop-floor documents like Assembly material requisitions, job cards, job tickets for in-house for a given aircraft. It caters information for work-in progress module.
• Work Order System WOS
• Aim: To generate work orders based on release sale orders for a given range of sale order dates or a given sale order number and cater information for work-in progress module.
• Sale Order System SOS
• Aim: To release sales orders based on target.
• Purchase Order Progression System POPS
• Aim: Estimation of labor cost and material cost after considering rejection to arrive at the product cost for an assembly/detail.
• Bill of Material and Planning 'BOMPLING' MRP-II applications.

Confidential

• Responsible for preparation of process specifications, perform user department requirements, process modeling, planning/scheduling/monitoring of the project and fine-tuning of the application and maintenance.
• Involved in the development of various systems.
• Prepared functional specifications and coordinated software development for major modules.
• Debugged and unit tested software prior to implementation.
• Provided technical support and maintained the software.
• Projects:
• Master Data Processor for Overhaul MDP
• Aim: Creation and maintenance of Engineering Data Master EDM which comprises of components specifications, routing data and bill of materials.
• Production Documents for Line Aircrafts
• Aim: To develop a menu driven system to take care of the total overhauling activities relating to different parts of the aircraft.
• Production Planning and Control PPC
• Aim: Create and maintain a huge centralized database of 23 record types, 21 sets and 19 areas with a total population of 5 million records using DMS-1100 database software in line with CODASYL approach.
• Human Resource Development Database HRD
• Aim: System to generate information relating to personnel and training that is required to be furnished to external/internal agencies.
• Shop Floor Documents for Overhaul Shops
• Aim: To process data and prepare documents at various stages of overhaul of an aircraft. Also, giving detailed information of operations carried out along with the time required for each operation.
• Goods in Transit System GIT
• Aim: Identify and evaluate the goods in transit at a particular point of time and to keep track of the invoices and to value the goods in transit.