Sr. Data Engineer/Sr. SAP Data Services (BODS) and Information Steward

JAMES L. PITSCH

*******@***-********.***

Cell: 307-***-****

TECHNICAL

SAP BODS Data Services, SAP BOIS Information Steward, Data Quality Management (DQM) for SAP, FirstLogic, SQL Server, TSQL, SSIS, Oracle, PL/SQL, Netezza, PostgreSQL, HANA, C#, .NET, Azure, ESRI ArcGIS, ArcObjects

EXPERIENCE

April 1997 to Present

Staffordshire Associates, Inc.

Sr. Data Engineer/Sr. SAP Data Services (BODS) and Information Steward Consultant

Past project assignments:

Lamb Weston: Performed as a SAP Data Services developer as part of an S/4HANA implementation. Developed data quality processes for cleansing and deduping vendor and customer addresses. Built processes for loading data from ODP sources and Amazon S3 buckets to a Snowflake data warehouse.

Continental Resources: Performed an analysis and conversion of an existing SAP Data Services job stream and developed a replacement using SQL Server, TSQL and SSIS.

Lockheed Martin: Provided SAP Data Services support to the Chief Data Analytics Office during a data center migration. Responded to incident reports, diagnosed and resolved problems.

Mayo Clinic: Migrated complex SAP Data Services jobs for the Advanced Analytics Unit over to a Java based web services platform using Java, IntelliJ IDEA, Git and Maven. Developed Data Services jobs, SQL Server functions and stored procedures to download data from the Oracle Cloud via encrypted web services, decode the packed data, parse and load into a staging environment all in a seamless parameter driven package.

NextLabs: Worked with software development company during their research into integrating their security product with SAP Information Steward. Configured Information Steward instance and created scenarios designed to test and exercise product functionality and capabilities.

National Vision: Performed a complete ground up install of SAP Data Services and Information Steward during an upgrade to the latest versions. Installed Information Platform Services, Information Steward, multiple BODS job servers and setup Active Directory Authentication. Tested SQL Server and Netezza data warehouse ETL and Data Quality jobs including address cleanse, NCOA, geocoding and match/dedupe. Tested Information Steward Data Insight data profiling jobs, Metapedia and Metadata Management setup and configurations.

Banfield: Updated data warehouse ETL processes during a human resources ERP migration. Collaborated in the development of Software as a Service web calls using SAP Data Services, created jobs and dataflows to load source data into an Oracle data warehouse utilizing table compare, history preserving, and map operation transforms. Modified Oracle PL/SQL queries and packages.

CSL Behring: Developed SAP Data Services jobs for loading a FDA certified data warehouse in SAP HANA from laboratory trial data. Developed and executed test plans and extensively documented the entire process.

Blue Buffalo: Developed SAP Data Services jobs for importing point of sale data from Canadian distributors and retailers. Cleansed and standardized incoming data, resolved currency conversion issues, matched input SKUs to SAP material master data and integrated results into SAP HANA analytical views. Setup Information Steward Data Insight data profiling rules, scorecards and jobs for measuring sales data metrics.

Hubbell Inc.: Implemented SAP Data Services and Data Quality Management (DQM) for SAP on S/4HANA. Diagnosed setup and configuration issues. Resolved critical issues with address cleanse mappings between S/4’s business partner data and DQM. Developed custom address cleanse jobs to clean up legacy unstructured address data. Assisted in the customization of DQM processes based on Hubbell’s specific business requirements.

Legends, a subsidiary of the Dallas Cowboys: Developed and supported data warehouse transformation processes. Used C#, TSQL, Microsoft SSIS and Microsoft Azure Data Factory to transform assorted data feeds. Data sources varied from real-time web services to point of sale vendor data and were transformed and loaded into SQL Server data warehouses for reporting and analysis.

Uptake Technologies: Responsible for the build out of a SAP Data Services environment for the Symphony project, a global data warehouse built for Caterpillar Inc. Installed and configured Data Services in DEV, QA, and PROD. Developed transformation dataflows and code promotion strategy. Developed BODS custom bulk loader routines to address performance and Unicode issues when writing to Postgres via Data Services. Automated scheduling of nightly backups and production job streams.

Major League Baseball: Migrated legacy ETL processes for a Netezza data warehouse to Data Services 4.x. Provided ongoing SAP 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.

National Vision: Developed and implemented a Data Quality solution for cleansing, geocoding, deduping, and householding customer data using SAP Data Services and Netezza. This was a prerequisite to the implementation of SAP Hybris Commerce and SAP Hybris Marketing. Developed processes for enriching customer details with US Census data using ESRI’s ArcGIS tools.

National Hockey League: Developed back-end transformation processes for a SAP Hybris Marketing implementation using SAP Data Services and SAP HANA. Developed processes for the cleansing, matching and loading of incoming data streams to a HANA based marketing database. Redesigned existing processes to implement process automation, restartability and fault tolerance.

ARI: Developed ETL processes for ARI’s Business Information Garage fleet management data warehouse using Oracle, SAP HANA and SAP Data Services.

Sargento: Provided maintenance and support for a production operations data mart using Oracle, SAP HANA and SAP Data Services.

Kimberly-Clark: Provided SAP Information Steward technical assistance and direction to the Enterprise Data Management group. Used Data Insight for data profiling, rule development and scorecard setup. Created procedures for setup and use of Data Cleansing Advisor and Match Review. Configured and scheduled Metadata Management Integrators. Developed custom code for displaying Data Insight profile results. Developed C# web service interface for displaying Metapedia search results. Built custom Cleansing Package for Material Procurement. Developed group strategy for using Team Foundation Server for source code control and configuration management.

Puget Sound Energy: Supported a SAP 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.

Dawn Foods: Installed and configured SAP Data Services and Information Steward 4.2. Migrated existing 3.2 installations to 4.2. Provided Data Services development and support services for legacy system to SAP 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 SAP ECC. Developed and implemented a custom automation system for scheduling Data Services batch jobs using passed in dynamic variable and parameter overrides.

Demeter Analytics: Implemented SAP Data Services 4.x for this database marketing firm. Developed data quality jobs, base match, address, and data cleanse transforms. Designed and implemented data quality processes for importing, cleansing, NCOA processing, geocoding, matching and householding data from multiple different sources across multiple servers. Developed server-based .NET spatial applications using ESRI’s ArcGIS Server platform.

CNR: Installed and configured SAP Data Services 4.x. Developed Data Services jobs for the cleansing, geocoding, matching, and NCOA 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 to develop processes for analyzing spatial data.

Hollister International: Diagnosed and resolved implementation issues with SAP Data Services and Data Quality Management (DQM) for SAP. Customized Data Services DQM jobs to add custom break keys and facilitate customer specific address mapping requirements.

Terasen Gas: Implemented SAP Data Service and Data Quality Management (DQM) for SAP. Developed Data Services batch jobs for migrating EMIGALL business partner data from a legacy application to SAP ECC and CRM. Developed real-time web service jobs for Canada Post address cleansing and duplicate checking.

Fulcrum Analytics: Worked 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 Object’s Data Quality (DQXI) suite.

Edelman Public Relations: Assisted 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.

Bridgestone/Firestone: Provided Oracle database development and project management services during the transition of a database marketing system from an outsourced vendor to an in-house managed project. 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 and data quality routines using PL/SQL, .NET. Implemented FirstLogic Postalsoft (ACE, TrueName, DataRight, MPG), and FirstLogic IQ8/BOBJ DQXI (predecessor to SAP Data Services). 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.

Accenture/Andersen Consulting: Performed as a Sr. Systems Architect and SQL Server database administrator during the development of a web-based practice management portal.

Chicago Title and Trust: Worked as database administrator of an Oracle-based order management system for the e-commerce group. 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.

February 1996 to March 1997

DC Systems

SENIOR SYSTEMS ENGINEER

Responsibilities included functioning as project leader, instructor and database/network technical specialist on application development projects.

Andersen Consulting: Supported a large human resources development project. 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.

EDUCATION

Masters of Business Administration with a concentration in Management Information Systems, 1996

Rosary College - River Forest, Illinois.

Bachelor of Arts, Liberal Arts, 1992

DePaul University - Chicago, Illinois

Contact this candidate