SUMMARY:

• Visionary and goal oriented Oracle Technical and Functional Professional with demonstrated experience in planning, analyzing, developing, implementing, administering and supporting cutting edge information solutions to address business opportunities. Motivated Project Manager with strong analytical, organizational and planning skills. Creative problem solver with positive attitude, experienced in managing and completing projects with the ability to plan and work within project budgets and timelines. Specializing in object oriented design and analysis with extensive experience in the full life cycle of the software design process including; requirements definition, proof of concept, interface implementation, testing, support and maintenance, security and administration. Excellent communicator with demonstrated ability to promote a positive work environment for strong team cohesiveness. Fluent in English, Russian and some Spanish and Portuguese.
• Consistently exceed as successful projects are completed in the area of RDBMS database software and ODBC Link reporting applications. Professional expertise is based on over fifteen years of multi - level support and project management of multiple production and development databases under UNIX and NT platform environments. Effectively able to manage and build credibility, establish rapport and maintain communication with stakeholders at multiple levels, including those external to the organization. Successful vendor manager and experienced in managing technology projects from concept to completion.

TECHNICAL SKILLS:

CRM: Oracle Customer Relations Management 11i

Databases: Oracle: 7, 8i, 9i, 10g, MS Access, RDBMS, DB2 V8

DB Query: PL/SQL, SQL Navigator 3.1, TOAD: 7.5, 7.6, 8.5.1, 8.5.3, 10.1.1.8, 11.6, SQL Plus 11.2, BrioQuery 6.2, Crystal Reports 8.5, Business Objects 4.5, 5.1.x, Broadcast Agent, Designer and Supervisor, Forms and Reports Builder, ShowCase Strategy, Discoverer 3i, 4i

ERP: Oracle Application: 10.7, 11.03, 11.5.3, 11.5.5, 11.5.9, 11.5.10, 12.0.6, 12.1.3 (AP, AR, BOM, CE, E-Business Tax, E-Procurement, FA, GL, HRMS, Install Base, INV, MAN, OAB, OE, OM, PA, PO, Sales Compensation, Self Service Expense and Time)

GUI/Web: HTML

Languages: MS Access BASIC, MS Visual Basic 6.x, SQL

Methodology: Oracle Application Implementation Methodology (AIM)

Operating Systems: Windows XP/2000/98/95/NT, UNIX, MacOS, DOS, Novell Environment, WinVNC Server 4.1.x

Other Software: APRO Banking Gateway 5.0, ClarifyCRM 12iSR2, Data Loader 4.3.9, ICA Citrix WinFrame Manager 1.7, Internet Explorer: 5.0, 6.0.x, Kronos, LiveLink, Lotus1-2-3, Lotus Notes Domino Designer 6.5.4, MiniTab, MS Office 97, 2003, 2010, MS Outlook 14.0.5, MS Project 14.0.5, MS SharePoint Workspace 14.0.5, Netscape Navigator: 4.0, 6.0, 7.1, Nortel VPN Client 10.04, Oracle Configurator, Oracle Wallet Manager 11.2, ReflectionX for Windows NT 8.0.2

PROFESSIONAL EXPERIENCE:

Confidential, Bedford, Massachusetts

Oracle EBS Technical Functional Consultant

Responsibilities:

• Provided Oracle EBS system technical and functional support and solutions in AP, CM, GL, INV, iProcurement, iExpense, PUR and EB Tax modules. Analyzing user issues in the EBS financial applications and databases for full life cycle testing of resolutions. Reported on overall support tickets and statuses, fixes, bugs, testing and user acceptance testing phases prior to roll out to Production environment.

Confidential, Farmingdale, New York

Oracle R12 Application System Administrator Consultant

Responsibilities:

• Designed responsibilities, menus, sub-menus, functions and exclusions for future go-live of the Oracle EBS Financial Application system. Analyzing extracts from financial applications and databases for full life cycle testing of resolutions. Lead and attended meetings and report on overall project plan, status, initiatives, gap analysis, timing and resources of the current projects.

Confidential, Boston, Massachusetts

Project Manager / Business Systems Analyst Consultant

Responsibilities:

• Designed project scope and developed conversion plans for financial application users. Analyzed extracts from financial applications and databases for full life cycle testing of resolutions. Lead and attended meetings and reported on overall project plan, status, initiatives, gap analysis, timing and resources of the current projects. Maintained project work packages for global Finance projects, business continuity and development. Created, administered and utilized SharePoint sites and contents. Designed IT and Finance documentation database as well as utilized MS Projects in a collaborative environment. Responsible for analyzing and presenting financial GL reports for user acceptance testing.
• Architected and implemented the process of merging business branches, legal entities and the chart of accounts in Oracle EBS Financial Applications. Analyzed interfaces and data extracts to identify issues with synched systems and processes. Created business system design functional and technical documentations such as MD50, MD70 and MD120 documentations for the technical Oracle and Technology teams.

Confidential, Boston, Massachusetts

Lead Oracle R12 EBS Technical Functional Consultant

Responsibilities:

• Provided lead functional and technical support for the Oracle EBS System. Developed, debugged, testing, maintaining and supporting the full Oracle Application Suite, which includes: AP, AR, FA, GL, Security and Administration. Analyzed system performance and concurrent manager for risk assessment. Maintained users and performed Oracle administrative application support and security functions. Maintained the concurrent manager and processing alerts and notifications. Debugged workflow and transactional error related issues and problems. Supported Financial Period closing and opening process and resolved interface issues. Designed and developed Financial Statement Generator reports and Discoverer reports.
• Acted as the functional lead for all projects involving the Oracle E-Business suite and the point person for Oracle On-Demand hosted environment. Acted as a Lead Security and Control System Administrator for the SOX audit and control process and procedures. Analyzed the existing process and designed and implemented the monthly Oracle reconciliation process in order to maintain and comply with the audit regulations and guidelines. Lead a project in the consolidation and clean-up of the chart of account in GL module. Provided to functional end users as needed. Configurated designed and created a new Bank check XML templates. Created, maintained and controlled forms cross validation rules, flex-field segments, security profiles and user responsibilities.

Confidential

Oracle R12 Trainer Consultant

Responsibilities:

• Responsible for creating and delivering end user business application on iProcurement and iExpense applications. Provided user interface form recommendations and clean-up of data values and data gap analysis prior to go-live. Customized materials and made recommendations on converting the power point presentations to the native language of each region and added own insight and knowledge to the end user material. Provided materials to users and conducted and oversaw the expected production database project go-live date in December of 2011.

Confidential, Framingham, Massachusetts

Senior Business Systems Analyst

Responsibilities:

• Developed, debugged, unit tested, maintained and supported the full Oracle Application Suite, which includes: AP, AR, E-Business Tax, FA, GL and HRMS. Completed project involving the addition of six new inventory organizations and implementing Oracle E Business Suite. Managed, architected and implemented enhancements for the existing modules on an Oracle On demand hosted environment. Designed, implemented and supported the User to role Matrix of the User Organizational Hierarchy that supports the current structure of the corporation. Collaborated in architecting, designing and enhancing the ITIM system. Lead as a Functional Analyst and Applications Administrator in supporting the Oracle EBS Application. Supported in the implementation initiatives such as break fixes, enhancements as well as performing financial data cleanup, restructuring and reporting. Acted as a Security and control System Administrator for an On Site Support Remote Model environment as well as the APRO Banking Gateway System Administrator. Effectively managed changes to databases in order to maintain business functionality, including configuring forms, defining elements and loading values for the financial tables to achieve business need and functionality. Maintained and administered the Oracle Enterprise System using SQL Server technology and implemented processes for conversion to retire the inherited legacy systems.
• Instrumental in designing SOX procedures and documentation requirements related to entity, system security, computer operations, system development and change management to meet the legislative requirement for SOX 2011. Gathered requirements and supported the SOX audit obligations and requirements, Internal Controls, ISO Audits, Inventory Audits and Financial Audits. Project managed utilizing the Oracle implementation methodology the application roles design project from the security and controls perspective. Attended PMO meetings and reported on plans, status, initiatives, gap analysis and the timing and resources of the project. Managed and supported the fiscal month end close, fiscal quarter end close and fiscal year end close financial database activities and processes. Administered DB2 subsystems in Production, Quality, Test and Development regions. Responsible for establishing and the off-shore support team on the EBS support processes. Performed Disaster recovery testing and piloting in an Oracle EBS environment. Architected, lead and implemented of merger client into the existing Oracle Applications ERP in an FDA controlled manufacturing environment.

Confidential, Massachusetts

Oracle Application Manager

Responsibilities:

• Analyzed, developed, debugged, unit tested, maintained and supported the full Oracle Application Suite, which includes: AP, AR, BOM, GL, HRMS, INV, OE, OM, PO, PUR and Sales Compensation. Collected requirements and implemented the Bartender Labeling Software with the Oracle ERP system. Defined elements and loading values for the financial tables to achieve business need. Performed financial table’s set-ups, maintenance, patch application and developed, tested, and maintained the test plans and key technical and functional customizations. Managed database changes in order to maintain business functionality and performed data cleanup, restructuring and reporting. Performed POS load processes for distributors and sales representatives worldwide. Developed, collaborated and test-piloted the Oracle server upgrade and created, distributed, collected and analyzed module test results, providing specific initiatives for the IT department. Redeveloped user responsibilities and organizational hierarchy that supports the structure of the company in compliance with current SOX Information technology and financial regulations. Maintained, supported and developed Lotus Notes databases and corporations Sales Force Automation web-site.

Confidential, Wilmington, Massachusetts

Senior Programmer Analyst

Responsibilities:

• Responsibilities within this position included; the management of the supplier web portal, the implementation, development and management of the assigned Oracle business system modules. Assisted in the development of the future process model and conversion strategy for the implementation. Gathered user requirements and performed gap analysis, tested, redeveloped, redesigned and debugged reports for user testing and acceptance. Project managed the migration, testing, back up and the restore of PRO 3 ERP Application on a new RS-6000 server for the Air Technology division of the company.

Confidential, Needham, Massachusetts

Oracle 11i HRMS Consultant

Responsibilities:

• Loaded data, verified, updated and sorted quick codes, values list, descriptive and key flex-fields, organizations and added flex-field information for master organization, and assigned them to their respective organization managers. Analyzed information from system extracts, debugged, trouble-shooted, and resolved database security issues and errors. Tested the automated content loading and synchronization processes.

Confidential, Newton, Massachusetts

Real Estate Development Assistant / Property Manager

Responsibilities:

• Utilized Oracle platform applications such as MLS, ThePoint, and PC Access. Assisted in setup and maintenance of computer labs as well as supported in the development decisions and technology strategy. Attained the Coldwell Banker Residential Brokerage real estate Buyer Agency License Law .

Confidential, Cambridge, Massachusetts

Oracle Business Analyst Applications Support Specialist / Business Objects Administrator

Responsibilities:

• Developed, analyzed, debugged, unit tested, maintained, and supported the HRMS and Advanced Benefits modules. Created a worldwide Organizational Hierarchy that supports the current structure of the company. Provided technical and functional support and for users and defined elements and input values for the payroll tables. Supported, maintained and administered the Business Objects Reporting application. Performed payroll table’s set-ups and maintenance and developed, tested, and maintained the descriptive and key flex-field set-ups. Developed, collaborated, and test piloted the User Satisfaction Survey for users worldwide. Oversaw the implementation of ADP Connection Software with Oracle HRMS and administered the CRM 11i implementation, set-up and customization.

Confidential, Burlington, Massachusetts

Oracle 11i Financial Application Consultant

Responsibilities:

• Loaded data into tables, verified, updated, and sorted inventory items as well as added GL account information for master organization and assigned them to their respective pricing organizations. Created new reports utilizing the Business Objects Reporting application. Performed setups such as lookup codes and sales periods for integrating GL with Inventory and Sales modules. Maintained inventory and pricing changes, created suppliers and their sites to maintain the business model.

Confidential, Avon, Massachusetts

Oracle Applications Implementation Specialist Consultant

Responsibilities:

• Achieved full life cycle Oracle Implementation of GL, AP, AR, INV, Purchase Order and OE modules. Project managed and contributed to all of the phases of the implementation plan. Developed the architecture, definition and designed documentation by modules. Assisted in the designing and building processes, data conversion, documentation, business system and performance testing. Created account code combinations for use in Inventory and Purchasing. Performed accounting periods and lookup code maintenance for integration of the GL, AP, AR and Purchasing modules. Tested and debugged the financial modules using test scripts. Performed sub-inventory transfers to insure the proper business data structure. Integrated approved supplier lists and sourcing rules for assigned items.