TECHNICAL SKILLS:

SAP BODS Business Objects Data Services, Data Quality Management (DQM) for SAP, FirstLogic, SQL Server, TSQL, SSIS, Oracle, PL/SQL, Toad, Netezza, Erwin, Power Designer, Windows Server, UNIX, PERL, C, C#, .NET, ArcView / ArcGIS, ArcObjects

PROFESSIONAL EXPERIENCE:

Confidential

Data Engineer/Systems Integrator

Responsibilities:

• Supported Puget Sound Energy during a SAP BODS Data Services and Satori Presort implementation. Diagnosed and resolved critical performance and stability problems. Streamlined operational processes and verified cleansed address data against USPS postal standards.
• Resolved Data Quality Management (DQM) for SAP stability problems.
• Installed and configured SAP BODS Data Services and Information Steward 4.2 for Confidential .
• Migrated existing 3.2 installations to 4.2. Provided Data Services development and support services for legacy system to ECC migration. Developed and implemented strategy for using Information Steward Data Insight and custom Data Services jobs to validate and score the migrated data prior to import into ECC. Developed and implemented a custom automation system for scheduling BODS batch jobs and passing in dynamic variable and parameter overrides.
• Implemented SAP BODS Data Services 4.1 for Demeter Analytics, a database marketing firm located in Alexandria, VA. Developed data quality jobs, base match, address, and data cleanse transforms. Designed and implemented a data quality process for importing, cleansing, Confidential processing, geocoding, matching and householding data from multiple different sources across multiple servers. Developed a SQL Server SSIS custom task transform to execute Data Services jobs via web services from within the SSIS environment. Developed batch utility for migrating data between MongoDB and SQL Server using the 10gen C# driver. Developed server based .NET spatial applications using ESRI’s ArcGIS Server platform and the Network Analyst extension.
• Migrated Data Integrator 11.7 ETL jobs for Netezza Data Warehouse to Data Services 4.0 for Major League Baseball. Provided ongoing Data Services development and production support for evolving business requirements and enhancements to the Injury Analytics Data Warehouse by transforming data from SQL Server and Oracle data sources.
• Migrated SAP/Business Objects DQXI 11.7 instances to Data Services 4.0 for the RNC.
• Developed Data Services jobs for the cleansing, geocoding, matching, and Confidential processing of name and address data in both batch and real - time. Developed process to remotely execute batch Data Services jobs via web services and to provide for the dynamic substitution of global variables and substitution parameters. Developed C# applications to implement CoreLogic’s PxPoint spatial geocoder and used SQL Server 2008 to develop processes for analyzing spatial data used in the decennial redistricting process.
• Implemented FirstLogic IQ8 and FirstLogic Postalsoft ACE for Confidential processing at Confidential, a Chattanooga, TN based ISP and hosting provider.
• Diagnosed and resolved implementation issues with SAP/Business Objects Data Services 3.2 and Data Quality Management (DQM) for SAP for Confidential in Libertyville, IL.
• Customized Data Services DQM jobs to add custom break keys and facilitate customer specific address mapping requirements.
• Implemented SAP/Business Objects Data Service 3.2 and Data Quality Management (DQM) for SAP for Confidential in Vancouver, BC. Developed Data Services batch jobs for migrating EMIGALL business partner data from a legacy application to ECC. Developed real-time web service jobs for Canada Post address cleansing and duplicate checking.
• Assisted Bridgestone/Firestone with their migration from FirstLogic IQ8 to Data Services 3.2.
• Worked with Fulcrum Analytics to develop a process for the name and address cleansing, matching, and householding of retail sales data using Oracle, PL/SQL, FirstLogic Postalsoft (ACE, DataRight, MPG), and Business Objects/SAP DQXI 11.7.
• Assisted Edelman Public Relations in the migration of a Media Monitoring database by developing ETL procedures using SQL Server, SSIS, and C#. Developed user acceptance test plans for validating the correct transformation of migrated information.
• Provided Oracle Database Development and Project Management skills to Bridgestone/Firestone during the transition of a database marketing system from an outsourced vendor to an in-house managed project. Was responsible for modeling schema changes using Erwin and converting the terabyte-sized system’s ETL processes to meet in-house standards. Rewrote core data transformation routines using PL/SQL, .NET, FirstLogic Postalsoft (ACE, TrueName, DataRight, MPG), and FirstLogic IQ8. Also developed XML web services to integrate data warehouse information running on Teradata with enterprise CRM systems. Developed process for cross-referencing retail sales data with demographic data using ArcView/ArcGIS to display the results geospatially.
• Performed analysis of geospatial data as Chairman of the Village of Bull Valley Plan Commission. Used ArcView/ArcGIS and SQL Server to interactively analyze wetland, soil, tax, and demographic data during development of the village’s comprehensive plan.
• Functioned as a Sr. Systems Architect and technical resource for Confidential Administrators during the migration of their medical claims management systems. Responsibilities included SQL Server database administration and development. Additional responsibilities included the development of data models, operational controls, and data access requirements for a local data warehouse. Was also responsible for developing a series of HIPAA compliant application services used to securely transmit and receive application data between systems, vendors, and business partners using MSMQ and PGP public key encryption.
• Performed as a Sr. Systems Architect and SQL Server Database Administrator during the development of a web-based practice management portal for Confidential Consulting. Played a key role in the solutions delivery and integration of Microsoft technologies in a distributed environment. Responsibilities included technical design and implementation of system interfaces, performance tuning and monitoring, logical and physical data modeling, data mart and ad-hoc reporting security design, and the training of client personnel.
• Worked as Database Administrator of an Oracle-based order management system for the Confidential Title and Trust. Responsibilities included logical and physical data modeling, migration of the database schema and the conversion of its data from SQL Server to Oracle. Additional responsibilities included the development of stored procedures using PL/SQL and the performance tuning of SQL queries.
• Was fully responsibility for the software implementation, database administration, and integration of an enterprise banking reconciliation system for Confidential0 Responsibilities included hardware selection, installation and configuration of Windows servers, SQL Server, and IIS. Project highlights included the use of an Intranet to distribute reports and the creation of custom routines to receive and distribute incoming data feeds.
• Additional accomplishments included the complete automation and monitoring of daily processes using stored procedures, Perl scripts, and ADO.

Confidential

SENIOR SYSTEMS ENGINEER

Responsibilities:

• Supported a large human resources development project for a big five professional services and consulting firm.
• Responsibilities included the planning and implementation of packaged software, the development of stored procedures for batch processing, the development of an ad-hoc data mart, the training of junior personnel, and the performance monitoring and tuning of multiple SQL Server databases.
• Developed technical training materials and taught courses in relational database concepts, SQL Server, and networking basics.

Confidential

PRODUCT DEVELOPER

Responsibilities:

• Accomplishments included the co-development of Platinum Fast Unload, a DB2/MVS Data Warehouse utility.
• Responsibilities included the timely handling of customer assistance requests, functioning as a liaison to other product development groups, and participation in the architecture and design of inter-product interfaces.