Data Engineer Resume
3.00/5 (Submit Your Rating)
Tx
SUMMARY
- Over twenty - eight years of experience in information services in analyzing and developing custom applications on SAP, Mainframe, and Unix platforms with a strong emphasis in Master Data and Data Governance in SAP and SAP Retail.
- Over twenty-two years of experience in SAP R/3 environment developing functional specs, technical specs, enhancements, interfaces, and custom reports in SAP R/3 environment and providing post production support. Proficient in SAP R/3, ABAP/4, MySQL, Access DB, Cobol II, SQL, JCL, and Micro Focus Cobol.
- Familiar with UNIX and IBM 3090 MVS operating systems.
- Solid background in computer science, software engineering, and database management.
- Interested in management, software design, application development, computer system analysis, support and consulting in the SAP R/3 environment.
TECHNICAL SKILLS
- ABAP/4, MySQL, Access, COBOL, COBOLII, SQL, JCL, CQS, Clipper, S-Cobol, Micro Focus CobolMicrosoft Office suite, Access, SQL Server Management Studio, ER/Studio
- Client Server Based SAP R3HP, UNIX platform using Oracle database
- IBM-RS6000
- MS SQL Server
- MVS 3090
- PC and Macintosh
PROFESSIONAL EXPERIENCE
Confidential, Tx.
Data Engineer
Responsibilities:
- Managing and defining data solutions for internal ExxonMobil projects.
- Designing and modeling databases using ER/Studio for internal projects utilizing a multitude of tools like Access, SQL Server Management Studio, Tableau, SAP Business Objects Data Services (BODS), etc.
- Received EBX by Orchestra Networks Data Management Software Training
- Received Python Training
- Data Lead on Project to de-merge Company Code for all Retail Locations in Germany. Physical Business locations moved to a Branded Wholesaler model and the country was split into 8 regions and 11 company codes from just 1.
- Data design lead to move SCADA Pipeline readings from an ACCESS DB to a new SQL Server DB. I created the data model in E/R Studio and built the new DB in SQL Server Management Studio. I created 3 new forms in the ACCESS application and linked to SQL Server with ODBC.
- Data lead on new Sales Opportunity application in Salesforce which is taking over from existing Seibel CRM system. Data from the Seibel system and from SAP is staged in a Data Hub and views created in SAP S4 HANA to feed the data through the Mulesoft ESB to the Salesforce tables for Products and Accounts.
- Created BODS Jobs with over 700 Workflows to pull SAP ERP tables’ data and write to SQL Server Database for Auditing Group.
Confidential, Pa
SAP Data lead
Responsibilities:
- Managing the creation of Function Specification documents for 87 Migration Objects by the Functional Team.
- Managing the creation of Technical Field Mapping documents for 87 Migration Objects by off-shore Development Team in India.
- Deciding migration methodology for 87 Migration Objects. Tools being used are SAP LSMW, BODS/IDOC (SAP Data Services), and the S/4 HANA 1610 Migration Cockpit.
- Making changes to S/4 HANA delivered Migration Cockpit Objects using the Data Modeler inside the tool for adding fields and/or creating new objects for Confidential ’s Migration Objects that are not included in the delivered S/4 HANA Migration Cockpit product.
- Assisting Confidential with the mapping of the SAP ECC 6.0 data to the new S/4 HANA 1610 system. This include both the MDG (Master Data Governance) tables inside S/4 HANA as well as the S/4 HANA tables.
Confidential, Tx.
SAP Data lead
Responsibilities:
- Project Manager for roll-out of SAP UEM by KNOA software
- Project Manager for rollout of SAP Single Sign-On (SSO)
- Data Lead on all Dealership/Branch Go-Lives (every 2 months for last 4 years) for all Master Data loads in all modules, including, assets, customers, vendors, vehicles, parts/materials, pricing types, condition records and procedures, info records, contracts, employees, user id’s, and user security roles, along with all Data Governance guidelines.
- Led effort for development of methodology for removing duplicate customers and the way conversions from the legacy system will be done moving forward.
- Responsible for converting all Zip Codes to +4 to accommodate roll-out of SABRIX tax solution. Done with MELISSA address standardization program.
- Responsible for maintaining Users and User Security Roles through SU01, SUIM, and PFCG.
- Occasionally debugging and fixing Enhancement Z-programs in User Exits by coding ABAP changes and modifying Z-tables
Confidential - Arlington, Va
SAP Data leadResponsibilities:
- Corporate Project Data Lead at Fortune 200 Energy company, Confidential, in Arlington, Va. I was responsible for developing overall methodology for data migration as well as coordinating the delivery of functional and technical specifications to the offshore teams in Beunos Aires, Argentina and India for all conversion objects as well as time and budget estimates for each. Responsibilities also include writing of all Data Cleansing Procedure documents, and all Data Migration Procedure documents for the methodology approved by the steering committee. I also helped in the data cleansing with the Business Owners of the legacy systems’ data and converting legacy data into SAP Configuration values to prepare the data for the LSMW load programs for the following objects
- GL balances to ECC 6.0
- GL historical balances to BW
- Material Master
- Vendor master
- Cost Center upload
- Profit Center upload
- Intercompany customers
- Assets master data and balances
- HR Organizational data upload
- HR Employee master data upload
- SAP Retail Master Data Lead at Electronics company, Tweeter, in Boston, Ma. Providing functional and technical specifications to the development team and developing the mapping requirements from the Legacy systems of record to SAP R/3.
- SAP Retail Master Data Lead at large Retail company, Luxottica, in Cincinnati, Ohio. Providing functional and technical specifications to the development team and developing the mapping requirements from the Legacy systems of record to SAP R/3. Responsibilities included:
- Article Master configuration, conversion, and interface design/mapping/documentation from multiple Legacy systems to R/3 utilizing IDOC ARTMAS05, design/mapping/documentation of Article Pricing conversion utilizing IDOC CONDA01.
- Merchandise Category Hierarchy and Merchandise Category design, including Merchandise Category reference article setup.
- Site Master configuration including Site Customer records, DC Vendor and Customer records, listing strategy for Articles to Assortments and reference site setup. This includes Reference Site methodology and design for Assortments, Distribution Chains, Logistics & Replenishment, and Purchasing.
