We provide IT Staff Augmentation Services!

Sap Data Services Specialist Resume

Chicago, IL

SUMMARY:

Accomplished Senior IT professional with a background in business intelligence, software design and full life - cycle development. Capable of managing numerous projects while leading cross-functional teams to meet and exceed overall IT initiatives. Demonstrated consultative process skills with emphasis on written and relationship development skills.

HIGHLIGHTS OF SKILLS:

  • Business Intelligence
  • Data Warehousing
  • Process Improvement
  • Team Leadership & Effectiveness
  • Strategic Planning and & Analysis
  • Reporting Systems Architecture
  • Process Implementation
  • Software Design & Development

TECHNICAL EXPERTISE:

Tools: Business Objects 4, XI r3, r2, r1, 6.5, …; WebIntelligence 4, XI, 6.5, …; UDT/IDT; Data Integrator 6; Data Services 4.2 (to 4.0), XI 3.2, …; DQM; SAP HANA; Talend; SSIS; Ab Initio; BEx Query Designer; PowerDesigner; Sagent; BrioQuery; Cognos; DOMO; Targit; Amazon Redshift; Genio; Erwin; Oracle SQL Developer Data Modeler; Crystal Reports 2011, XI, 8.5; Xcelsius; IIS; Visio.

Languages: Visual Basic 6; PL/SQL; SQL; Transact-SQL ( Confidential -SQL); Java; ASP; JavaScript; VBScript; .NET; C#; HTML; Ajax; JQuery; CSS; JSON; XML; XSLT; eBay, Indeed, YQL, & Google APIs; SAS; Cobol.

Databases: SQL Server Azure, 2014, 2012, 2010, 2008, 2005, 2000, 7.0, 6.5; Oracle 11g, 10g, 9i, 8, 7; Teradata; Neteeza; Hyperion Essbase; SAP HANA; MySQL; MS Access; UDB; DB2; Sybase; Filemaker.

Business Applications: SAP ECC 4.7, 6.0; Salesforce; Oracle ERP; Navision ERP / MS Dynamics.

SAP: MM, MDM, FICO, PI, PUR, CAPEX, COPA, MFG, SD, PP, QM, PM, MRP, WM, HCM, SCM, VM.

OS: Windows Server 2012/2008/2003/7/ Vista/XP/2000/NT/98/95/NT; Unix/Linux; Mac OS; Mainframe.

Other: OLTP, OLAP, ODBC, ADO, RDO, OLE DB, SOAP, SSL, Git, Subversion, SAP Bank Analyzer, Forecasting, Trend Analysis, Star and Snowflake Schemas, Executive Dashboards, CDC (change data capture), 3-Tier Programming, TCP / IP, FTP, HTTP, LibGDX, LDAP, SSO, RPC.

Methodologies: Agile, Scrum, Waterfall, Inmon, Kimball, object-oriented programming (OOD), rapid application development (RAD), Accelerated SAP (ASAP).

Industries: Consumer Products, Banking, Lumber, Legal, Logistics, Health Care, Hospitals, Chemicals, Pharmaceuticals, Dept. of Defense, Energy, Electric, Automotive, Government, Politics, Insurance, Data Quality, Telecommunications, Building Materials, Financial Services, Commodities, Fleet Management, Furniture, Food & Beverages, Mining, Coal, Debit & Credit Cards, Animal Feed, Incentives, Marketing

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

SAP Data Services Specialist

Responsibilities:

  • Performed detailed analysis related to tracing lineage between Navision ERP, SSIS, SSAS, and Targit reports.
  • Creation and tuning of over sixty actual ETL jobs pulling data from Navision / SQL Server (+ Azure) into SAP DSO tables, with date-based CDC. Successfully created and tested jobs integrating Confidential and SAP BW.
  • Merged, applied business rules to, and created twenty-two reports for data sourced from over twenty countries.
  • Authored key pieces of ETL blueprinting document (goal to produce sales report with global data): database details (incl. sizing); Confidential architecture; Confidential templates; and SSAS cube, WebI, and Targit report information.
  • Worked closely with SAP BW resources and business to gather and implement rules and resolve issues.
  • Engaged in data modeling and architecture related to target and auditing tables used in ETL loads.

Environment: Data Services ( Confidential ) 4.2; Business Objects 4 (WebI); SQL Server 2014 (including Azure); SSIS; SSAS; CDC; Navision / MS Dynamics; Targit; SAP BW (target); SAP BEx Queries; Win 7.

Confidential, Atlanta, GA, and Indianapolis, IN

Senior BI Architect / Technical Lead

Responsibilities:

  • Successful technical leadership leading to on-time end-to-end implementation of a data warehouse, including all design, development, testing, and support phases.
  • Replaced existing technologies where data came manually from multiple plants and a variety of separate systems with a single reliable and consistent highly available centralized data warehouse.
  • Created logical and physical models storing inventory (including costing), customer, vendor, machine / production data, revenue (AP and AR), and auditing information. Tool: Oracle Data Modeler.
  • Developed almost three hundred reusable Java routines for use with Talend ETL procedures.
  • Converted from manual Access inventory process to ETL driven approach using Talend.
  • Designed, coordinated creation of, and created ETL code extracting and cleansing information from several dozen sources, including files, SAP, and databases. Included support for clear and load, incremental (CDC) processing, status updates, and automated testing. Tool: Talend.
  • Guided and highly involved with universe, report, and dashboard creation.
  • Architected medical database and related ETL and reports, including CDC support (modeling tables, creating SSIS packages + SSRS reports, deployment, documentation, testing, and setting up templates for easy additions).
  • Integrated GL and financial data from school of medicine and hospital to provide visibility into cross organization funding efforts.

Environment: Talend 6.2; Java; Oracle 11; SQL Server 2012-14; Access; SAP; Git; Subversion; CDC; Xcelsius; Webi; IDT; SSIS; SSRS; .NET; C#; Oracle SQL Developer Data Modeler; Win 7 & 10.

Confidential, Greensboro, NC

SAP Data Services and HANA Specialist

Responsibilities:

  • Development of Confidential objects supporting multiple change data capture styles that include thousands of mappings and over seventy SAP DSO destinations. All information sourced from and writing to SAP HANA.
  • Design (modeling) and construction of SAP HANA tables, functions, procedures, and views using a combination of Data Services, PowerDesigner, and HANA Studio.
  • Optimization of ETL processes, including using push-down SQL, caching, simplifying joins, creation of HANA information views, CDC, and implementing parallel execution.
  • Migration of information from multiple source systems, from and to SAP HANA, copying into SAP BW transfer structures, and ending in SAP Bank Analyzer.
  • Advised team on HANA best practices, including creating column-based tables, using information views instead of SQL script, minimizing primary key usage, and reducing column quantity in tables.
  • Implemented various data profiling and quality checks and used a composite table to ease maintenance.

Environment: Data Services ( Confidential ) 4; SAP HANA; SAP Bank Analyzer; DB2; PowerDesigner; Win 7.

Chesapeake Utilities, Dover, DE, 04/2015 to 09/2015

Dashboard Expert

  • Creation of executive dashboard and reports illustrating volumes, imbalances, accounting details, and customer information related to acquisition. Improvement of existing dashboards and reports - organization and bug fixes.
  • Ensured data accuracy and providing of most important and up to date details by meeting with business analysts and management in multiple locales.
  • Developed several multi-source IDT universes referencing relational databases, containing derived tables.
  • Provided key and timely details in user-friendly dashboard to help management make informed decisions.
  • Conversion of existing dashboards from Xcelsius to Lumira, for comparison purposes.

Environment: Xcelsius 4.1; Crystal Reports; IDT 4.1; MS Access 2012; SQL Server 2012; Win 7.

Confidential, Atlanta, GA

SAP Data Services Expert

Responsibilities:

  • Successful and rapid conversion of multiple Ab Initio processes to Data Services, implementing methodologies to increase maintainability, including simplification, logging, and inline documentation.
  • Data analysis, modeling, and profiling using SQL Server and Data Services, to provide new and improved structures and aid in data quality checks related to conversion efforts.
  • Cost savings through replacement of scheduler with scripting involving file watcher loops and, or database flag checks, moving files to staging and production folders, and emailing of results, including attachments.
  • Executed technical leadership on the use of the technology platform and tools, mentoring in optimal use of Confidential in a SQL Server, SAP, and Unix environment.

Environment: Data Services ( Confidential ) 4; SQL Server 2008; Oracle; SAP; Ab Initio; Acorn; Win 7; Unix.

Confidential, Atlanta, GA

SAP Data Services and Xcelsius Lead Developer

Responsibilities:

  • Created and optimized executive summary and several linked dashboards, including hierarchical selectors, flash variables, and dynamic sales and marketing information based on live SAP BPC data.
  • Built Crystal Reports detail reports connected to BI services pointed Confidential Web Intelligence blocks containing BEx query details. Reports launched by and received prompts from Xcelsius dashboard.
  • Acted as go-to for the team for technical concerns and idea development.
  • Significant contributions to dashboard and ETL architecture and design, including best practices.
  • Constructed reusable templates to speed batch and real-time ETL development in Confidential .
  • Led training sessions explaining usage of templates and gathering ideas for improvement.

Environment: Data Services ( Confidential ) 4; Xcelsius; Business Objects 4 (WebI, UDT, IDT); Crystal Reports 4; SQL Server 2008; Neteeza; XML; Win 7.

Confidential, Atlanta, GA

Sr. Crystal Reports Developer

Responsibilities:

  • Improved and created Crystal Reports documents, querying JobBOSS (a manufacturing ERP system.
  • Created reports with income statements from five current locations, mergers and acquisitions, and overall.
  • Developed two reports displaying (a) well organized list of customer details, allowing for prompts to meet needs of particular users and (b) shipped revenue by customer and state.
  • Designed and implemented best practices and standards for Crystal Reports.
  • Worked with analysts to resolve all accounting related data issues.

Environment: Crystal Reports; JobBOSS; Excel; VBA; Win 7.

Confidential, Atlanta, GA

SAP Data Services and Business Objects Enterprise Developer

Responsibilities:

  • Migrated data conversion processes from BW to ECC sources, using Data Services integrated with SAP.
  • Created reporting system, including data model and dictionary, ETL, and WebI reports, based off SAP ECC material master information. Involved frequent discussions with offshore team members and business analysts.
  • Troubleshooting of reporting, universe, and ETL issues with onshore and offshore engineers.
  • Performed data profiling and analysis to ensure successful conversion of all information.

Environment: Data Services ( Confidential ) 4; Business Objects 4 (WebI, UDT); Oracle 11g; SAP BW, ECC; Win 7.

Confidential

Business Objects Admin / Architect

Responsibilities:

  • Acted as systems/software engineer for Business Objects architecture planning, technical design, development and testing, and software, hardware, and interface integration.
  • Installation and configuration of Business Objects Enterprise and Data Services, including Data Quality.
  • Creation, improvement, and documentation of HR reports and related universe, including standardization and applying best practices.

Environment: Data Services XI r3.2; Business Objects XI r3.2; SQL Server 2008; Win Server 2008.

Confidential, Atlanta, GA

SAP Data Services Architect

Responsibilities:

  • Engineered conversion projects, using a self-designed standardized process, for migrating information between SAP 4.7 and 6.0. Trained other resources in process usage.
  • Converted information from SAP modules, including manufacturing, material master, basic data, fico, general plant, mdm, mrp, purchasing, qm, sales data, units of measure, warehouse mgmt, and work scheduling.
  • Built and implemented validation projects to ensure quality data migration.
  • Frequent interaction with analysts and business to review requirements and results and update estimates.

Environment: Data Services XI r3.2; Oracle 9i; SQL Server 2008; SAP ECC 4.7, 6.0; Win XP.

Confidential, Pittsburgh, PA

SAP Business Objects Specialist

Responsibilities:

  • Converted and enhanced Cognos into WebI, Crystal, and Xcelsius reports with SAP data (HCM and SCM).
  • Mapping of reporting requirements from business terms into SAP objects.
  • Writing and editing of SAP BEx queries using Query Designer and created related universes.
  • Writing of test scripts for accuracy, formatting, and performance.

Environment: Business Objects XI r3.2; SAP ECC 4.7 - HCM, SCM, SD; Cognos; SQL Server 2008; Win XP.

Confidential, Atlanta, GA

Business Objects Architect

Responsibilities:

  • Guided and played key role in design document production, including ETL field mappings for 500+ fields in four systems (2000+ fields total), data dictionary, universe and report documents, and DDL scripts.
  • Designed centralized data warehouse and subject specific data marts, following Inmon methodology.
  • Led report development effort, including creation of many Web Intelligence reports and universes.
  • Designed and implemented Business Objects architecture, including hardware and software requirements, CMS information, security, and migration from XIr2 to XIr3.
  • Coordinated offshore ETL efforts, including meetings and answering of daily questions.

Environment: Business Objects XI r3.2; SQL Server 2008; SSIS; Inmon; Crystal Enterprise SDK; Erwin; XP.

Confidential, Tampa, FL

ETL Architect

Responsibilities:

  • Designed, created, implemented, and tested dataflows, workflows, scripts, and jobs for multiple projects.
  • Troubleshooting and performance tuning which reduced several jobs from several hours to less than one.
  • Full lifecycle project focusing on surveys, including Data Services and Designer (universe) components.
  • Migrated dataflows, workflows, scripts, and jobs between repositories.

Environment: Data Services XI r3.2, Business Objects XI r3.2; SQL Server 2008; Windows Server 2008, XP.

Confidential, Atlanta, GA

Data Quality Expert

Responsibilities:

  • Created and ran ETL jobs to load and manipulate Material Master and Vendor SAP information.
  • Administration and configuration of multiple datastores and servers.
  • Upgraded Data Quality (DQM) to Confidential, with data and multiple country address cleansing and matching.
  • Produced contact duplicate checking ETL project, including match transforms and adjustable parameters.
  • Performed data cleansing including: company and person names and addresses, email addresses, dates, and casing of data and diacritics.
  • Developed, published, and scheduled batch and real-time jobs involving XML.

Environment: Data Services XI r3.2; SQL Server 2005; SAP ECC; XML; XSLT; Xcelsius 2008; Win XP.

Confidential, Atlanta, GA

Business Objects Technical Lead/Architect

Responsibilities:

  • Directed and coordinated organizational strategies of four employees responsible for conceptualizing, constructing, testing and implementing business and technical solutions for telecommunications data.
  • Partnered with software and architectural teams to plan and build out new systems, understand scalability and constraints of software, and manage disaster recovery and business continuity planning.
  • Modeled and integrated several data marts using Kimball methodology.
  • Held weekly training sessions with business users, analysts, management, and other developers explaining how to use and edit reports and explaining related business concepts.
  • Full lifecycle development in multiple concurrent projects, all reaching sign off on schedule.
  • Reverse engineering of SAS reports using ETL (SSIS) and Business Objects universes and reports.
  • Created tables, synonyms, views (particularly with analytic functions), and sequences in Netezza.
  • Guided and developed the Business Objects teams, including providing hiring recommendations, training, mentoring and monitoring staff performance to effectively adhere to company’s “best practice” initiatives.

Environment: Business Objects XI r2 (Webi, Designer, CMS, Admin); Crystal Reports XI; Crystal Xcelsius 2008; SQL Server 2005; Teradata; SAS; SSIS; Netezza; Kimball and Agile methodology; Windows XP.

Hire Now