OBJECTIVE:

• To obtain a position that will allow me to grow as a person and a professional to achieve my goal of working in Data Management for a company that values its data and manages it accordingly.

SUMMARY:

• Lead data conversions for SAP Go Live
• Developed a data conversion methodology for converting data from 10 different ERP systems to SAP
• Developed and Implemented Global Data Conversion Process for converting hundreds of applications to SAP
• Worked to implement in house software development where there was none
• Implemented development strategies of CMMI, use MS Project to track projects and created documentation procedures

PROFESSIONAL EXPERIENCE:

Confidential, Mechanicsburg, PA

Senior Oracle DBA and Developer

Responsibilities:

• Technical Expert on database redesign for a system upgrade
• Participated in collaborative meeting to design the new system based on customers prior experiences and process changes to produce the most efficient system for the customer
• Database modeling and relational design of new database in Erwin
• Designed and produced a versioning system to allow the system to be audited and rolled back to any state in time easily using PL/SQL packages and triggers
• Developed data migration procedures and code to migrate from old version of the database to the new version in PL/SQL
• Developed and deployed database encryption mechanisms for PII in production system
• Experience implementing Oracle Database Security Technical Implementation Guide
• Developed Unix scripts in KORN to complete database tasks such as loads and processing jobs
• Monitor Database jobs, parse errors and resolve logic errors in the database
• Write complex queries for data calls and reports for clients

Confidential, Shady Grove, PA

Data Architect

Responsibilities:

• Participated in a Pilot project for an SAP ECC 6.0 implementation in Portugal at two manufacturing facilities
• Lead technical data conversion of legacy systems into SAP for a new SAP implementation
• Provide subject matter expertise on data management topics such as metadata management, data interoperability standards, data quality, data governance, data development, and master data management, data integration, data warehousing and data security management
• Experienced in providing technical data & information architecture leadership on large, complex, enterprise class SDLC projects
• Facilitate meetings with technical and business stakeholders to determine data and interoperability requirements
• Experienced in identifying, analyzing and translating business requirements into conceptual, logical and physical data models in complex ERP environments
• Experienced in identifying and documenting data integration issues and challenges such as duplicate data, non - conformed data, and unclean data
• Experienced in developing global data conversion processes, develop conversion rules with business, produce documentation and instructions defining the process, develop technical process (Oracle database coding), manage developers and data team members, communicate process and information throughout the company
• Experience working with global teams, remotely and on location, that consist of many cultures to meet project milestones
• Designed Oracle Data Warehouse that is used to store company data for conversion; data is loaded from legacy systems, converted by using custom Oracle scripts and formatted to load into SAP
• DBA for Oracle database - Tuned database, wrote PL/SQL packages, procedures, functions and triggers, oversaw backups and monitored database for performance
• Develop and maintain Legacy System Migration Workbench (LSMW) applications used to load flat file data into SAP
• Hands-on Dimensional modeling and ER data modeling experience
• Knowledgeable in OLAP, BI and Data Mining
• Data analysis skills using SQL, TOAD or SQL Developer tool
• Experienced in delivering quality work on time with multiple, competing priorities

Confidential, Chambersburg, PA

Team Design Lead

Responsibilities:

• Project Manager - Work with business process experts to develop business requirements for new software projects. Develop project plans and scopes of work. Schedule projects balancing resources which are primarily time and personnel. Coordinate all requirements with Application Developers, Testers, Report builders and DBAs. Work with developers to make sure requirements are met and with customer to ensure all needs are met. Manage upwards of six projects simultaneously. Track projects in MS Project and use Project Workspaces to store all documentation, keep it version controlled, track issues, risks and involve customers in the project throughout the process.
• Oracle DBA - Design, development and maintain Oracle 10.2.0.3 Databases: Production, Test and Development. Production databases are used by 12 applications and a user size of 800. Maintain backups using RMAN and monitor and tune for performance using Oracle Advisors. Develop scripts using PL/SQL for database operations. Develop complex reports to allow Lean Six Sigma Team to track and improve operations. Operate in a Windows Server 2003 environment.
• Oracle AS Administrator - Administer Oracle Application Server 10.1.2.2 & 10.1.3.1: Production and Test environment. Configure OHS, Web Cache, Forms and OC4J. Maintain configuration of all servers, manage user accounts using Oracle Identity Management and apply OPatches to keep installations up to date.
• Application Developer - Create Applications using Oracle Application Express (Formerly HTML-DB). Have developed 7 applications in two years.
• Developed a database and application that will be used by all Directorates to track all Contract and IMPAC Depot Purchases. Users record all items purchased, supervisors approve purchases, all receipts are recorded and the Directorate of Contracting records payments of all depot contracts. Application replaced six others and increased visibility of purchases.
• Developed a database and application to handle the fabrication requests for items needing to be manufactured on the Depot. Application triggers users in the process to let them know when their input is needed on requests. This web based system replaced a paper and internal mail system. This old paper method took 4-8 weeks to complete while this application has reduced the time to less then a week.
• Developed a database and application that keeps track of all Depot estimates. Application replaces paper system, increases visibility, allows for better re-use of estimates and allows management to keep informed of estimate requests coming into the Depot.
• Migrated a Quality and Foreign Military Sales database from INFORMIX to Oracle 10gR2. Then developed an application for each using Application Express.