Summary

Master Information Technologist with focus on Oracle Manufacturing and Financial Analyst seeks' to bring functional expertise in Oracle Applications to the table in pursuit of lead position in a growing company. Strong expertise in consulting, business analysis, project management and systems management with deep understanding of the manufacturing and financial business processes and reporting needs. Adept at interacting professionally with all levels of management and stakeholders and will undoubtedly present the vision for solution to everyone in a clear and concise manner.

Areas Of Expertise

Executive Summary

• 20 years of cutting-edge experience in the field of designing and implementing Large-scale Enterprise Application Systems in Oracle eBusiness suite, Business Intelligence, Fusion Middleware SOA, OSB and Microsoft technologies.
• Professional with Masters of Science MS in Computer Information Systems, Masters in Business Administration MBA in Finance and Strategy and Bachelors BS in Management Information Systems and emphasis on accounting.
• Subject matter expert and solution architect for ERP and CRM based systems including finance, quality, manufacturing, warehousing, inventory, advanced supply chain ASCM , order to cash and procure to pay, hire to fire applications.
• Completed 6 EBS Full life cycle projects 3 Implementations and 3 Upgrades , involving all phases of Requirements Definition, GAP Analysis, Process Modeling, Data Modeling, Report Mapping, Application Configuration, System Testing and User Training.
• With strong functional knowledge led the assessment, requirement gathering and process design and delivery efforts of Oracle modules, including Account Receivables, Accounts Payables, Quality Control, Spares, Depot Repair, Quoting, Inventory, Bill of Materials, WIP, Pricing and ASCM Advanced Supply Chain Management .
• Liaised between business teams in finance, manufacturing and information technology. Assisted business teams in Quarter/Month-end activities and reporting.
• Gained vast experience in Global Finance working for a multi-national corporation in a complex multi-org, intercompany, multi-currency and international tax environment.
• Rich technical experience in developing CEMLI's Customizations, Extensions and Integrations etc. .
• Experienced in application integration, designed and developed Industry standard EDIFAC interfaces for integrating internal and external applications, including ecommerce transactions to foreign governments and SalesForce.com.
• Championed implementing Spares Management, Depot Repair, BI Publisher and financial reporting.
• Managed external consultants in all stages of vendor selection, RFP and SOW reviews, knowledge transfer and post implementation support transitioning.
• Instrumental for interviewing and horning recommendation for new recruits.
• Championed Oracle SOA Suite 10g and 11g implementations, governance and design, as well as trained staff on web logic and bpel program design.
• Project managed multiple ERP implementations and enhancement projects including project scoping, planning, resource estimation, communication management, prioritizing and status tracking activities.
• Member and actively engaged with Oracle professional groups OAUG, NEOAUG, SOA BPM PARTNER COMMUNITY and blogs.oracle.com
• Excellent analytical/problem solving abilities and excellent communication skills.

Professional Experience

Confidential

• Lead Consultant, EPS, Oracle Fusion Middleware, SOA, OSB, WebLogic
• Company Overview: Perficient PRFT is a publically traded IT consulting services company. Perficient partnerships includes Microsoft Gold Partner, Oracle Platinum Partner, IBM Partner, EMC Select Partner, Tibco and Salesforce.
• Lead technical consultant working in the area of Service-oriented architecture, Oracle Fusion Middleware, Oracle Service Bus and WebLogic.
• Accolades: Implement Oracle Service Bus OSB and Oracle SOA SOA in a clustered SUSE Linux environment with Oracle Coherence Caching.

Confidential

Principle Business Systems Analyst Lead IV

Company Overview: Elbit Systems, 11 billion Dollar business units include defense electronics contractor and integrator, medical devices, land, aerospace and commercial aviation.

Role: Lead Cross Functional Business Analyst in a lean manufacturing environment.

• Acclimated with data security SSA , export control ITAR and FDA requirements on medical devices.
• Accolades: Responsible for the specification, technical design and testing of applications components to support the users of the Oracle ERP Application including customizations, modifications, reports and interface development. Functional areas include Order Management, Financials, Pricing, Projects, AP/AR. Customers, Suppliers, Manufacturing, Quality, WIP, Boms, Routings, and Configuration. Support and enhancement of Quality Control Plans, PLM, Customer Concern Process, Contact, RMA, Shipping Receive, Depot Repair, Knowledge Management, Repair Tech, Warranty, Failure Analysis, MRB, CAPA and Supplier Corrective Actions.

Projects:

• Participated in Oracle R12 upgrade testing and setup and configuration of new modules.
• Champion for driving new business functionality into the ERP system including Depot Repair, Debit Memo, Serial Number Control, Quality Control functionality.
• Spun up SOA 11g environment and trained DBA and Manager on Web logic, Enterprise Manager and BPEL.
• Redesigned Supplier Scorecard Analysis using new Business Rules defined by Quality Team
• Redesigned key Quality Control processes which improved overall functionality and data capture.

Responsibilities:

• Managed and mentored Business Users and other Application Staff
• Analyze and evaluate existing or proposed systems.
• Revises computer programs, systems and related procedures to process data.
• Prepares charts and diagrams to assist in problem analysis.
• Submits recommendations for solution.
• Prepares program specifications and diagrams.
• Works with minimum supervision, conferring with supervisor on unusual matters.
• Decision making is performed independently.
• Performance tuning, Data analysis and validation.
• Heavily Customized Forms environment.
• Follows AIA framework for enterprise architecture and AIM Methodology for Document Control.
• Oracle Reports, Forms, XML / BI Publisher, BI Enterprise, API's, Workflows, Triggers, Hooks, PL/SQL, Sun Solaris 10.5.10, Windows 2008, Windows 7, VMWare

Confidential

Role: Lead Analyst

• Description: Long after the quantity is forgotten, the quality is remembered . One of the responsibilities of producing and selling products to medical, aerospace and military applications is to have accountability for quality control for both products manufactured in house and purchased through 3rd party vendors. In some cases, it is required to be accountable for detail down to the producer of a certain types of lubrication, lot and production date. This allows detailed investigation into product failure and analysis.
• Responsibilities: Over the past decade, Elbit has designed a customized module to manage Quality Control and Repair. None of the original architects of the module are still employed at Elbit, and there was no documentation on its design. There was a lot of functionality that was not working or business requirements had changed since it was last modified. I was tasked with documenting and flowcharting functionality provide a gap analysis and redesigning and providing enhancements.
• The module was designed use Oracle Forms and BI Publisher.
• I used a 2 tier approach to develop improvements
• Deploy Depot Repair where we were able to move some of the custom functionality into seeded functionality.
• Reverse engineer the Custom Functionality and design and process improvements as required by business, Redesign Scorecards for improved Quality Reporting.

Confidential

Role: Lead Analyst, Project Manager

• The Depot Repair module replaced several 3rd party modules that handle RMA functionality. This included sun setting other applications, several Oracle customizations and several interfaces which move data in and out of the Oracle E-business system. Improvements realized better accountability of inventory and on demand needs MRP , financial accountability Sales Orders and Invoicing which are automated as part of the improvement.
• Depot Repair is a complex module to implement, because it touches Order Management, Inventory, WIP, BOMS, Service, Customers, HR, Contracts, Install Base, GL, and several others, and integration into these modules is detailed. Finance, Supply Chain, Logistics, Quality and Warehousing teams were involved as part of the integration, testing and signoff.
• My part in this project was to
• Learn and document the existing RMA processes
• Learn and document the Oracle Depot Repair process
• Develop a GAP analysis
• Provide a cross functional analysis of Depot Repair in the Elbit environment
• Perform Setup of the Depot Repair Module in the following environment's
• I. Demo
• II. Pilot
• III. UAT1
• IV. UAT2
• V. Production
• Work with a Project Manager to Plan out the lifecycle of the project
• Work with all teams to develop Report Requirements
• Develop BR100
• Develop Test Scripts TE40
• Develop Technical Specs MD50
• Develop Deployment Documents MD120
• Develop Training Documents
• Code and Deploy Required Reports
• Modify APIs
• Personalization's
• Work Flows

Confidential

Principal Business Systems Analyst

• Company Overview: Aspect is a mid-size company operating in High-tech manufacturing industry with 20 hardware manufacturing and 80 software. Aspect is a multi-national with operations in 17 countries world-wide.
• Notable Initiatives and Accomplishments:
• Selected as Elite high performer at Aspect, and 4x Company award Recipient including Employee Recognition Award and Excellence Award.
• Performed lead Project Management role on dozens of projects interfacing Business, Analysts and Developers, helping to define requirements, design, and delivery planning.
• Project1: EDIFAC Data Exchange for Foreign Governments

Role: Project Manager and Architect

Description: Expanding the business footprint to LATAM Latin America , certain foreign governments require invoice data to be exchanged with the government to ensure proper taxation. Requirements included sending invoice data using EDIFAC format, transacting, receiving back a digital signature and reloading the completed data into the ERP system. Then completing the invoicing process using the digital signature within the ERP System.

Responsibilities:

• Involved in project initiation, scoping and resource estimation
• Managed project schedules and resources, communication management, prioritizing and status tracking activities.
• Designed and architected new processes.
• Lead and manage 2 developers.

• Trained business on the updated business processes, provide production support and transition.

Confidential

Project2: COCO

Role: Techno-Functional Lead

Description: Business wanted to reengineer the Oracle Quoting module. This included modifications to seeded quoting processes, configurator modifications, JSP customizations, and integrating BI Publisher to the Quoting module where it was unsupported by Oracle.

Responsibilities:

• Lead technical and functional designs.
• Involve in requirement gathering, analysis, creation of test scenarios, creation of BR100 and MD50 documents.
• Perform various system setups and create customizations, work with business users in testing.
• Lead and manage other developer, including activities like time and status reporting.

• Train business on the updated business processes, provide production support and transition.

Confidential

Project3: Oracle SOA Implementation

Role: Architect

Description: Emerging trends in technology introduced the need for Aspect to embrace newer technologies like Fusion middleware. This project involved evaluating the newer fusion middleware technologies like Oracle SOA, OSB and strategically taking advantage by leveraging the service oriented capability for better application integration of internal applications. This project involved integrating sharable entities like customers, vendors, employee etc. across various internal and external applications using BPEL, OSB, Database adapters, JMS Queues etc.

Responsibilities:

• Architect and design various interfaces for application integration between Oracle and other custom applications.
• Mentored other team members in Oracle SOA.
• Train business on the updated business processes.
• Monitor the activity and provide production support.
• Create UDDI registry's and create functional documentation
• Setup BAM for Activity Monitoring

Modules: TCA, HR, Oracle SOA, Service Bus, BAM, JMS / AQ queues, Database adapters, BPEL, Human workflow.

Confidential

Role: Techno-Functional Lead

Description: The business wanted to modify the intercompany invoice process. One of the requirements was to customize the transaction between specific business units, to uplift the COGS when transactions occurred between these entities.

Responsibilities:

• Lead technical effort in defining and documenting how the intercompany invoice process works.
• Work with business to define requirements for the uplift process.
• Create customized hooks within Oracle to process the uplift during the intercompany invoicing process within the AR Interface Tables.
• Lead user testing, training and change management activities, also production support.

Confidential

Role: Technical Lead

Description: Aspect acquired Quilogy Inc, Services Company with 70 M in revenue. Quilogy had a custom built ERP system running on .NET and this project involved decommissioning of Quilogy's ERP system and migrating business process to Oracle. This prompted creation of a new legal entity for Quilogy and it involved a full-cycle ERP implementation project involving all modules of Oracle, additionally prompting for creation of several external applications and data conversions.

Responsibilities:

• Lead the various data migrations including migration of Projects, expenditures, Items, customers, vendors, banks, fixed assets, OTL, sales orders and invoices.
• Design and create customizations and enhancements in oracle to facilitate new business processes.

• Create/modify several reports and interfaces to include Quilogy's information.

Modules: HR, PA, OTL, iExpense, AR, AP, GL.

Confidential

Role: Technical Lead

Description: Aspect Software entity was created as a merger of Concerto Software, Davox and Aspect Communications, each with about 350 M in revenues. These companies were running on separate instances of Oracle and there emerged a need to consolidate them in order to save costs. This project was mainly to integrate and consolidate Oracle eBusiness suite to versions 11.5.9 and then upgrade it to 11.5.10. This involved re-engineering the various RICE reports, interfaces, customizations and extensions and also several data migrations.

Responsibilities:

• Code in PL/SQL using API's/open interfaces and migrate HR, Customers, vendors, FA's, AP and AR.
• Develop RICE components, Reports, Interfaces, Customizations and Extensions.
• Develop new and update existing workflows, OAF extensions and personalization's.

• Create technical design MD70, and Installation MD120 documents.

Modules: AR, AP, HR, BOM, Engineering BOMS, TCA, INV and AOL.

Role: Responsibilities include, but not limited to, Design, Development, Implementation of Oracle Reports 6i, XML Publisher Reports, Interfaces, Extracts and other custom PL/SQL Development. Forms, Personalization's, Workflows

• Oracle setups of Concurrent Executable, Concurrent Programs, Request Groups, Value Sets, Data Definitions, Templates, Parameters.
• Developed all custom customer facing documents in Oracle Reports and XML Publisher Developed Custom Interfaces and Extracts using API in PL/SQL.
• Acclimated with AR, AP, BOM, WIP, Pricing, Inventory, Administrator, OM and other ERP Modules.
• Develop installation and end user documentation.
• Develop 6i and XML Reports and API based Interfaces
• CRM Responsibilities include Design, Development, Implementation and Support of Saleslogix CRM System.
• Saleslogix Developer and Business Analyst, Saleslogix 5.2, 6.2, 7.0
• Accounts, Contact, Opportunities, Forecasting
• Crystal Reports

Company Overview: TJX Companies is the largest international apparel and home fashions off-price department store chain in the United States. The company originally evolved from Zayre, and in 1995 purchased its main rival Marshalls Inc. of Andover Ma from Melville Corporation. As part of the assets, TJX acquired me

Role: Responsible for maintenance and Hygenitity of over 600 Million dollars of transactional data annually for over 2000 Stores, millions of transactions. Working with the executive staffs' requirements, I designed custom distributed information systems to handle specific tasks, and then interfaced them together with an interactive reporting system and data warehouse.

• Accolades: Over a 15 year period, I had a key role in designing and automating the Logistics Information Systems at Marshalls and the TJX Companies, which took them from manual or main framed based paper dumps, into the world of relational databases, data mining, corporate reporting and Enterprise Resource Planning.
• Custom Logistics Information Systems Modules Designed and Developed by Ira Kleiner