SUMMARY:

• Highly experienced in data architecture, migration strategy, data transformation, metadata repository design and business analysis. Have a deep understanding of data structures and business requirements. Able to move between and communicate with SMEs, developers, business leads, and functional leads with ease.
• Involved and led many data migrations, including large teams combining client and consulting staff. Very familiar with SAP, Oracle eBusiness and Siebel data architecture.
• Engineering background includes production, engineering and maintenance. Have written and installed MES and CMMS systems. Strong experience with Asset Management and Maintenance
• SAP data architecture and migration using SAP Business Objects Data Services (BODS)
• Logical and physical modeling for both 3NF and dimensional design
• ETL development using SAP Data Services, SSIS, T - Sql and PL/SQL
• Data Migration SAP Data Services, Siemens IPS, Siebel migration tool and custom SQL Server and Oracle scripts
• Familiar with MDM and Data Governance theory and processes
• General DBA and database development Oracle 8i - 11g and SQL Server thru 2012
• Data warehouse architecture and design
• Application integration, migration and consolidation SAP, Siebel, BaaN, Oracle eBusiness, Siemens PLM, Agile PLM
• Application database development OLTP and OLAP using SAP Data Services, PL/SQL, T-SQL, VB
• CRM: Siebel 98 thru 7.8 Call Center, Sales, Public Sector, Marketing / Oracle 11i Sales, iStore, Call Center
• Database performance enhancement: SQL Tuning, Statspack.
• Software development: VB, Oracle 3GL, 4GL, VB.net
• SDLC CMM Level 3 experience
• Security IRS MBI (Minimal Background Investigation IRS and Position of trust DOJ)

TECHNICAL SKILLS:

Technology and Tools: ERP CRM Data Base Migration Coding Oracle 11g Oracle10i - 11g Oracle 7-11g (Expert) SAP DS VB (Expert) BaaN Siebel 98-8 SQL Server 7-2008 (Expert) Siebel EIM PL/SQL (Expert) Agile PLM Microsoft Access (Expert) Oracle T-SQL (Expert) SAP Toad (Expert) Custom SQL 3gl-4gl (expert) BaaN Data Model /ETL Reporting Tuning Projects Done BO Data Services (Expert) Crystal Report Statspack (5 yr) Siebel 6 Custom PL/SQL(Expert) Actuate SQL Tuning (6yr) Oracle CRM 2 Visio (Good) MS-Excel BaaN 5 MetaData (Expert) BaaN Oracle ERP 1 Erwin (Good) Old experience Access Agile PLM 2 VB6 Data Migration 14 CMMS 3 MES 1 SAP 9 Data warehouse 4 Data Services 9 Architecture/Control Role (Yrs.) Yrs. CMM Level 3 (trained) Data Architecture 10+ SDLC (Formal) Data/Business Analysis 8 Agile Process Data Modeling 8 Dimensional modeling Data Mapping 8 Data Governance DBA 5 Metadata Management PL/SQL 10 ETL MS Projects 3 EIM Custom & Siebel ETL 8 Data Migration 10 Integration 8

PROFESSIONAL EXPERIENCE:

Confidential

Data Migration Consultant

Responsibilities:

• ETL of legacy data using SSIS and custom T-SQL
• Use of Power shell and VBA to extract file data.
• Reverse Engineering of a collection of applications maintaining the customer’s current PLM system.
• Siemens Team Center migration using the IPS, UGPC and UG Clone utilities.
• Creation of documentation storage hierarchy and migration to Siemens PLM.
• ETL of JD Edwards data and migration to Siemens PLM
• Creation of technical documentation.

Confidential

Managing solutions architect

Responsibilities:

• BPDM (SAP “Best Practices for Data Migration”) migration
• BODS ETL development
• Data validation
• SQL Server

Confidential

Principal Data Services consultant (Technical)

Responsibilities:

• BPDM migration HCM and Data Services ETL to legacy systems
• BODS 4.2
• Pre and Post data validation scripts in SQL and Data Services
• SQL Server
• Oracle
• HPQC

Confidential

BPDM Data Services Data Migration (Technical Lead Migration)

Responsibilities:

• Leading group of developers in BPDM migration
• BODS 4.0
• Oracle 11g
• Master data Material, Vendor, Customer

Confidential

ETL SAP Data warehouse Developer

Responsibilities:

• Develop custom PL/SQL procedures for data warehouse
• BODS 4.0
• Oracle 11g Geospatial development
• BO Web intelligence reporting

Confidential, Houston TX

SAP Consultant Data Migration

Responsibilities:

• Extensive use of BODS and AIO Best Practices for data migration tools.
• Data Architecture of SAP instance, Customer, Material, Vendor
• Creation of DS jobs to do configuration verification between SAP instances
• Creation of DS jobs to validate lookup table data
• Master data Material, vendor, customer

Confidential, Washington, DC

SAP Architect

Responsibilities:

• SAP Data Services to architect data dictionary and data model of SAP system.
• Data modeling of SAP instance for data migration.

Confidential, Columbus, Oh

SAP Data Services Consultant

Responsibilities:

• SAP Data Services Best Practices for data migration of company acquisitions
• SAP Best Practice product to accomplish data migration, mapping and validation.
• SAP Data Services to architect data dictionary and data model of SAP system.
• Trained new developers in the use of DS and PBDM.
• SAP development lead for data services and data migration.
• Master data Material

Confidential, Atlanta GA

SAP Data Services Consultant

Responsibilities:

• SAP Data Services Best Practices for data migration of company acquisitions.
• Used BODS to build custom data dictionary and data model of SAP system.
• Assisted customer in source data identification, data transformation, normalization, rule administration, error detection and correction.
• IDoc template use. Did some re-development of template processes to better support migration effort.
• Technical support and guidance provided to business analyst to better understand data mapping, architecture and data migration of source SAP system to target SAP system, including SAP data validation process.
• Technical support of inventory, Sales and Purchasing Rapid Marts.

Confidential, Cheyenne, WY

Business Analyst for SAP PM

Responsibilities:

• SAP Data Services in support data quality and migration of current and future SAP preventive maintenance and parts requirements at six North America plants, defining overall workflow needs for master data.
• Responsible for identification and operation of various facility software including DCS system.
• Development of data migration strategy from legacy DataStream MP5 system to SAP, including PM and MM modules.

Confidential, Boulder CO private co Boulder Co.

Data Architect

Responsibilities:

• Managed data architecture work being performed by IBM consulting. This work was Master data Management, data migration, data warehousing, integration and data validation of Oracle 11i and Siebel 7.8 application moving from Siebel on Demand to Siebel.
• Data Quality of migrated master data wrote custom PL/SQL.
• System being loaded from over 200 Source applications running on DB2, including SAP.
• Responsible for data governance and metadata management, data model, data dictionary and ERD of Oracle system, ETL Informatica, PL/SQL to do validation.
• Wrote validation test scripts and queries to check migrated data.
• Led client presentations and discussions in dimensional modeling principles and data warehouse design.

Confidential, Falls Church MA

Senior Data Architect

Responsibilities:

• Responsible for Master Data Management, Data modeling, Architecture, ETL, EIM and data validation of Siebel 7.8 install for Department of Justice.
• Used PL/SQL and Siebel programming.
• Collaboration with Oracle consultants in data warehousing proof of concept created stare schema and did normalization.
• Backwards Engineering of current litigation program.
• Did Logical and physical data models of legacy application.
• Developed data models (dimensional and transactional) and solution designs.
• Wrote test validation SQL for automated validation of data to be migrated.

Confidential, Philadelphia PA

Data Architect

Responsibilities:

• Consolidation of Navy Servers, applications and Networks.
• Responsible for Data architecture, Master Data Management, application migration, installation and consolidation of Oracle 9i thru 7, SQL server 2003 and various applications at US Naval bases.
• Responsible for ETL and troubleshooting of application data and database performance after installation.
• SQL load, export/import backup and clone of data.
• Created and maintain database to track servers, applications, network information and devices used by the US Navy.
• Data modeling of Navy application.
• Remote DBA support of 6 Oracle databases, database tuning using statspack.
• Systems were combination of 8i, 9i and 10g.
• Remote, support for data architecture and modeling of database consolidation of various regions in Canada United Way effort, SQL Server 2000 and Fox Pro databases used.
• Used T-sql in creation of procedures and data moving scripts.
• Did logical and Physical data models.

Confidential, Joplin MO

Senior Technical Architect

Responsibilities:

• Installation and configuration of StatsPack database and SQL performance tuning.
• f internal customer DBA for support of application.
• Conversion of customer legacy data to application.
• Tuning of application tablespace to spread I/O evenly across disks.
• Data modeling of CC&B application.
• ETL of legacy data to customer application.
• Responsible for development of data migration and transformation process and methodology.
• Heavy use of PL/SQL and T-SQL to do migration.

Confidential, Lawrence KS

Developer/DBA

Responsibilities:

• Project management of 30 plus Siebel, Oracle and Tibco staff to develop data migration methodology between Oracle 11i and Siebel 7 systems.
• Led development teams in effort to determine connectivity points between systems. A 2600 Seat CRM Call center.
• Responsible for data mapping, modeling integration and code development of system. Used Tibco, Siebel, Oracle, XMLspy databases Oracle 9i.
• Data Modeling, analysis and testing of Siebel to Oracle integrations. Software: Oracle 9i, Siebel, Tibco.
• Created star schema and data model for use in analytics data warehouse.
• DBA support for Oracle and SQL Server, Siebel and IRS program, data utility program development in VB6, VB.Net, Access, Crystal Reports, and VBA.
• Creation of Shell scripts and backup processes.
• Use of Oracle diagnostics, SQL tuning and Erwin.
• Creation of Data Warehouse for application data. Data modeling. Data bases 8i, 9i and SQL server7. Software: Oracle 9i, Toad, OWB, SQL server, Power Designer

Confidential, Blue Springs MO

Automation Engineer

Responsibilities:

• PLC machine automation using Monicron DBA SQL Server 7 and VB6

Confidential, Redwood CA

Responsibilities:

• DBA work installing patches to UNIX system. Setting tablespace and data files.
• Telesales and Interaction center project scope analysis.
• Legacy data migration analysis.
• Shell scripting and data modeling.
• Internal project setting up 90 day CRM, i-Store, i-Marketing, Scripting, Telesales, PL/SQL script to load lead tables and SQL Loader, data modeling and mapping of Oracle 10i.

Confidential, Chicago IL

Senior Consultant

Responsibilities:

• Technical Lead on DBA support for two plants one in Mexico one in Raleigh N.C. NT & Unix systems.
• Mapped Agile data model, migrated legacy data to Oracle 8i Dbase.
• Installed and configured Agile running on Oracle and SQL Server.
• EAI of legacy system to Agile and back

Confidential, Columbus OH

Consultant

Responsibilities:

• Technical lead for Siebel Sales Force Automation implementation.
• Used VB to do data validation.
• Develop workflow, Assignment Manager and Security.
• Data mapping, modeling and integration of Siebel to legacy system, use of VB, EAI and PL/SQL.
• Technical lead, EIM preparation, data model of legacy system to do migration, DBA support
• Confidential Internal projects to migrate from 98 to 99.5, custom configuration of sales and forecasting. Actuate Reports. VB, Actuate reports.

Confidential, Atlanta GA

Technical Consultant

Responsibilities:

• Technical lead and source code changes to BaaN, VB application doing data exchange between BaaN and ADI.
• Creation of down load of data to Excel and Access applications.
• DBA support. EAI of BaaN IV to legacy systems.
• ETL of data for load, data modeling and migration.
• Source Code modifications, manufacturing routings. PL/SQL on 8i.
• Source Code modification, used in work order module. PL/SQL on 8i.

Confidential, Chicago IL

Senior Consultant

Responsibilities:

• Data collection for an EAI integration program for Zebra bar code printing to BaaN.
• BaaN administration and tools, EAI of legacy warehouse system to BaaN IV. PL/SQL on 8i.

Confidential, Tulsa OK

Manufacturing Engineer

Responsibilities:

• Project management of the manufacturing portion of a BaaN IV implementation.
• Creation of a routing system, formula construction, and inventory update.
• Designed and developed a data model for MES application, integrated MES system to BaaN.
• Full development and creation of database using 3NF and Dimensional data architecture.
• Engineered, designed, developed and implemented the SCADA/MES system, using six sigma ideology, system developed around SLC 500’s, ladder logic, visual basic and panel view programs.
• An activity based costing system, giving real time manufacturing cost, efficiencies, and scrap. System responsible for 25% reduction in production labor and neutralizing 3rd shift requirement.