SUMMARY

• Dedicated IT professional with in - depth experience and a track record of managing critical IT functions to meet complex organizational requirements.
• Adept at working across departments, with internal and external teams, to consistently deliver high quality projects.
• Capable of managing resources and timelines to ensure projects meet or exceed expectations and are delivered on time and within budget.
• Solution driven, adaptable to new technology and the latest process and IT advancements to automate and modernize systems.
• Six Sigma Green Belt. Pursuing PMP certification.

AREAS OF EXPERTISE

• Master Data Management
• Technical IT Project Leadership
• Production Support Management
• IT Project Management
• Application Design
• Data Warehousing
• Interfaces & Integration
• Modeling & Mapping
• Analysis & Problem Solving

TECHNICAL SKILLS

• Oracle ERP
• Business Objects
• Cognos
• MS Office Suite, Access, Project, Visio
• DataStage
• Informatica - IDQ,IDD,HUB,PowerCenter
• Oracle
• Sybase
• Netezza
• SQL*Plus, PL/SQL
• SQL Developer
• SQL Server Mgmt. Studio
• Jira
• ServiceNow
• Oracle Agile PLM
• UNIX and DOS Scripting dbase/FoxBASE

PROFESSIONAL EXPERIENCE

Confidential

System Design Architect

Responsibilities:

• Implemented Logility Voyager (demand planning software) for global supply chain. Developed and deployed ETL solutions between regional ERPs and four distribution warehouse centers.
• Functioned as Master Data Management technical lead to implement Informatica MDM solution. Standardized product portfolio from 17 different ERPs globally consisting of over 12 million SKUs. Managed activities for team of six developers (contractors and internal).
• Integrated Eye Care Providers (ECP) data into Confidential website allowing our ECP customers to easily track their rebates, promotions and incentives.
• Managed commercial, manufacturing, and financial System Change Requests (SCR) using Oracle Agile PLM for development enhancements and production support issues.
• Improved order entry process for Japan and their outside vendor by managing the data exchange between CVJ Baan and Birds Order Entry system, reducing order entry inaccuracies into Japans Baan ERP.
• Increased inventory visibility and improved efficiency between internal sites by implementing a new PO/SO process flow, enhancing the ability to track overage and short-shipped orders, lead times, planned and actual delivery times, and receipt of inventory between manufacturing facilities and distribution warehouse centers.
• Technical Project manager for several high profile initiatives overseeing the activities of Cognos and ETL developers. Projects included: EDW reporting solution for sales and inventory data across Europe & APAC countries. DataMart’s for Logility analytics, Oracle Advanced Pricing contract management and New Product Launch performance metrics.

Confidential

Systems Analyst/Project Manager

Responsibilities:

• Managed deliverables associated with replacing existing JDE ERP solution with Oracle E-Business suite. Modules included Financial, Distribution, Manufacturing, and Planning functions for New York headquarters, and locations in Belfast and Skarpnäck.
• Facilitated meetings between consulting partner and internal business personnel as needed. Led weekly staff meetings to distribute consolidated status report. Collaborated with consulting project lead to map project plan and work with internal resources to keep project tasks on track.
• Worked with vendors to ensure proper version and functionality of add-ons were incorporated in the implementation.

Confidential

Senior Systems Analyst

Responsibilities:

• Led initiative of the ETL process for converting legacy Oracle database systems to Teradata structures.
• Managed data repositories for customer billing and subscriptions.
• Engaged as IT project lead for SAS implementation for Marketing Automation.
• Worked with technical teams to implement IBM MQ solution for interfacing with data warehouse.
• Analyzed current business processes and procedures to recommend areas for enhancement and automation.
• Assessed user requirements in order to develop detailed design documents, technical specifications and project plans.
• Created logical data modeling, ETL and ERD documentation supporting design specifications.

Confidential

Lead Technical Analyst

Responsibilities:

• Managed a team of 6 supporting Oracle/Sybase databases on UNIX operating system across IBM and SUN platforms. Maintained 100+ business applications as well as 250 production and test databases across 40 servers.
• Achieved an average availability time of 98% across all databases while team addressed and successfully resolved an average of 90 production support issues on a monthly basis.
• Assisted in the hardware migration of 24 SAP instances from Winter Hawk servers to the Regatta platform.
• Performed installations, maintenance, and upgrades to bolt-on software (BMC Control-M, Connect Direct, Taxware).
• Implemented strategies and controls for securing sensitive data (i.e. SS#) within database repositories.
• Improved runtime efficiency by 50% by identifying and tuning critical areas in the Oracle order cycle and interfaces.
• Realized a $54K annual cost savings in labor charges by implementing process changes resulting from Six Sigma Certification training.
• Directed a 10-person Oracle application development team providing production support, new development and enhancements to reports, forms and interfaces for initiative ranging from 1-5 months in duration.
• Managed a 24/7 production support staff responsible for resolving all functional and technical issues within specified SLA.
• Implemented UNIX scripts to efficiently monitor systems with focus on performance optimization and space utilization.
• Consolidated software agreements resulting in high compliance coupled with $150K in savings on licenses and maintenance fees.
• Y2K Data Warehouse Project Lead. Effectively reviewed interfaces, data structures and reports for potential 2K issues. Worked Command center. No issues were recorded.
• Executed responsibilities as Sybase DBA and Unix admin
• Sales Force Automation project, achieving a $50K annual cost savings through automated vendor contract administration and a $250K savings through automation of in-house price books and a CD-ROM reference disk.