We provide IT Staff Augmentation Services!

Sap Hana Data Services Consultant Resume

Bellevue, WA

PROFESSIONAL SUMMARY:

Creative problem solver with significant experience in leading organizational change through implementation of information technology. Customer service oriented with strong communication and analytical skills. Exceptional abilities in project design and management with the organizational and supervisory skills to assure success. Delegates and monitors work to meet and beat deadlines. Tendency to thrive in dynamic and fluid environments while remaining pragmatic and focused.

CORE COMPETENCIES & EXPERTISE

  • SAP Implementation
  • SAP 4.7 / ECC 6.0
  • SAP FI/CO, PM, BW
  • 6 years Project Management Experience
  • 9+ yrs analysis and ERP configuration (SAP FI/CO, GL, AR, AP, TR, CCA, PCA, COPA)
  • Go - live Cutover Plan
  • SAP HANA
  • SLT
  • Business Objects Data Services
  • Information Design Tool (Universe)
  • 4 Full SAP Implementation (Business Definition & Planning to Go-Live)
  • Disaster Recovery Planning
  • Technology Development
  • Cost Benefit Analysis
  • Strategic Business Planning
  • Change Management
  • Research & Development
  • Data Integrity & Recovery
  • Contingency Planning
  • Risk Assessment
  • Mentoring and Coaching
  • Business Impact Analysis

TECHNICAL SKILLS:

  • SAP FICO/BW/PM
  • BO Crystal Reports
  • SLT
  • Web Intelligence
  • SAP HANA
  • BO Analysis
  • SAP Dashboard
  • SQL Server 2005/2008
  • BO Data Services
  • BO Explorer
  • Info Design Tool
  • MS Project 2007/2010

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

SAP HANA Data Services Consultant

Responsibilities:

  • Provides guidance and advice to SAP Customers, Sales Executives, Pre-sales and Solution Architect resources on the data approach to HANA opportunities.
  • Gathers business requirements from key stakeholders and translate them to a comprehensive data solution design using multiple products.
  • Determines the size and scope for a suitable data solution in HANA projects based on the identified business requirements.
  • In-depth knowledge and hands-on experience of HANA security/user setup configuration
  • Leverages knowledge of data warehouse and software development methodologies to contribute to the overall planning of projects by recommending approaches, identifying resources, and developing timelines.
  • Builds ETL architecture and provides guidance to ETL developers on the best practices to handle high volumes of data.
  • Expert at Data Provisioning and Data Modeling
  • Experienced in reporting techniques such as creating calculation views, managing attribute mappings, creating analytic privileges, adding variables, using system generating joins.
  • Provides knowledge transfer to IT users.
  • Develops a collaborative working relationship with clients.
  • Works with project managers, SAP’s offshore and partner consultants to develop consulting and project methodology, techniques, tools, and solutions.
  • Responsible for SAP Data Services development.
  • Analyses data contained in source/ Confidential databases.
  • Resolves technical issues and implement code modification needed to support changing user requirements for multiple data services jobs.
  • Besides BOBJ Data Services (BODS), I also use SAP Landscape Transformation (SLT) for real time replication.
  • Developing and delivering, executive level, sales-oriented and technical presentations
  • Works with different types of reporting tools: Excel, BO Explorer, BO Crystal Reports, Dashboard.
  • Created many Analytic and Calculation views with hierarchies, measures, variables.

Confidential, Saginaw, MI

Senior SAP Data Migration Consultant

Responsibilities:

  • Designed and developed ETL solutions using SAP Data Services as well as Cransoft.
  • Developed ETL jobs, Work Flows, Data Flows and other Data Services components.
  • Worked extensively with EZMap™, CranSoft® DataConstructionServer™ (WebApp development), BackOffice Data StagingWarehouse™ (DSW), and BDCdirect®.
  • Expert in BDC and LSMW.
  • Worked in creating Profit Center, Cost Centers, Cost Elements, Activity Types, Statistical Key Figures, and Internal Orders.
  • Expert in SQL Server 2005/2008.
  • Used several BackOffice functions to modify data.
  • Created Hierarchies for Profit Center, Cost Center, Statistical Key Figures, Cost Elements, Activity Types, and Account Groups (SETHEADER, SETHEADERT, SETNODE & SETLEAF).
  • Created Confidential and source rules and validation reports for multiple sources for all assigned objects.
  • Created Remediation rules at Confidential level.
  • Worked with DataGarage® to manage the Legacy sources.
  • Created Confidential Export to be used by BDC and LSMW in SAP ECC 6.0.
  • Worked extensively with several SAP Transactions in FICO.
  • Expert in creating DTS and SSIS packages in SQL Server.
  • Created several WebApps to accommodate data construction for many objects.
  • Created rules for several fields including zRelevant, zSource, and zLoaded (zInSAP).
  • Configured several applications in CranSoft® for optimal performance.

Confidential

Senior SAP Data Migration Consultant

Responsibilities:

  • Migrated all customer master objects from R3 into ECC including, Customer Contacts, Sales Information, Loading Points, Tax Grouping, Tax Indicator, Bank Details, Partner Functions, Shipping Data and Sales Data.
  • Utilized SAP Data Services as an ETL tool for various objects.
  • Conducted several meetings with clients to help them formulate conversion rules for each field.
  • Used LSMW as the standard data loading method.
  • Created complete set of rules for the objects where EZMap was not used.
  • Utilized EZMap 5.3.1 extensively to generate automated rules and modified the complex ones as well as created several Confidential level rules.
  • Researched to find out the errors in customer master configuration.
  • Created reports for customer address cleansing, including de-duplication, finding inconsistencies between addresses.
  • Created several Web-apps to support client in their data cleansing activities.
  • Created many Cranport packages for movement of data.
  • Optimized DataGarage for automation and ease of use.
  • Expert in SQL Server 2008, New CranSoft® Tool 4.5, CranPort™, SSIS Packages (to replace DTS packages), Stored Procedures, and editing DTS Packages in SQL Server 2008.
  • Provided expertise in testing the server, Software, and documentation.
  • Created all validation reports for General Ledger, Accounts Payable, and Accounts Receivable.
  • Imported tables from the legacy to the source in DataGarage®.
  • Created detailed documentation with extensive data analysis for every procedure to help client better manage their data.
  • Scheduled batch process to run on weekly basis.
  • Worked extensively with BackOffice Data StagingWarehouse™ (DSW), DataGarage®, BDCdirect®, and LSMW.
  • Created views and Stored Procedures, as well as other BackOffice Functions in SQL Server 2005 for many different Rules and Validation reports.

Confidential, Houston, TX

SAP Data Migration Consultant

Responsibilities:

  • Involved in every aspect of Data Conversion from start to Go-Live.
  • Worked extensively with CranSoft® and SAP.
  • Expert in AdeptSQL for CranSoft® instance replication.
  • Managed Vendor / Quality / APO / CRM objects for data conversion.
  • P2P - Extensively worked with P2P objects (PIR, Vendor Contracts, Quality Info Records, Master Inspection Characteristics, etc.).
  • Worked with SAP Data Services in conjunction with DSW.
  • BW/BI Sales History and Obligation data conversion lead
  • SCM - APO - Extensive knowledge of Supply Chain (SCM) and Advanced Planner and Optimizer (APO) including Location Master, Product Master, Transportation Lanes, and Product Interchangeability.
  • Monitored Core Interface (CIF) process that replicates Materials and PIRs into APO.
  • Inherited other objects (including Contact information) for complete overhaul and revamp of all sources, targets, rules, and reports.
  • Worked with SD Objects, loading Sysco Contacts into CRM and replicating over to ECC.
  • Worked with Functional team to update and finalize Functional Specs.
  • Led high level meetings to accomplish tasks and derive resolutions.
  • Performed CranSoft® Toolset for BackOffice employees and clients.
  • Worked with DataFactory™ associates to bring them up to speed with team objectives.
  • Communicated / created messages with SAP to resolve issues related to APO Transportation Lanes.
  • Created many Super Sources to accommodate for multiple companies with similar data structure.
  • Worked extensively with EZMap™, CranSoft® DataConstructionServer™ (WebApp development), BackOffice Data StagingWarehouse™ (DSW), and BDCdirect®.
  • Created SSIS packages in SQL Server 2005 to bring in construction data from disparate sources.
  • Developed MS Access application to collect data from business and transport it directly in to DCS tables, minimizing time and effort to populate web applications.
  • Extensively utilized BAPI to create and modify LSMW to load object.
  • Recorded transactions using SHDB to create a load program for BDC.
  • Created many remediation rules at Confidential level.
  • Developed Excel documents to collect data from disparate sources to centralize in CranSoft® DataConstructionServer™.
  • Created complex web application in CranSoft® DataConstructionServer™ to collect data for quality objects.
  • Expert in CranSoft® tools and security.
  • Worked extensively with SAP Application Development team to debug SAP programs, including Transportation Lanes BAPI.
  • Worked with Security and Basis teams with related issues.
  • Created many validation and reconciliation reports for vendors.
  • Expert in SQL Server 2000/2005. Used several BackOffice functions to modify data.
  • Skilled in HPQC defect management.
  • Performed Knowledge Transfer to other BackOffice employees and Sysco counterparts.

Confidential, Minneapolis, MN

SAP Data Migration Analyst

Responsibilities:

  • Experienced in creating DTS Packages, Validation Reports, and Source Rules and Confidential Rules (including Stored Procedures) for different Targets and Sources.
  • Created DTS packages to migrate data from source files to the source tables.
  • Worked heavily with views and Stored Procedures, as well as numerous BackOffice Functions, in SQL Server for many different Rules and Validations.
  • Ensured all procedures were well-documented.
  • Created a Source Rule to update Order Type (zAUART) field in stVBAK table for Confidential ttVBAK in SD Team.
  • Created Insert and Delete Rules for many different sources.
  • Created all Rules for zOKToLoad and zLoaded for stVBAK table before the data was inserted into the Confidential Table.
  • Created all the Validations for zOKToLoad and zLoaded for stVBAK to verify if the data that had been inserted into Confidential Table was accurate before the final load.
  • Helped to migrate all XREF Source Tables, as well as their source files and DTS packages, from their disparate databases into a new DB called sdbManual to keep up with the new methodology.

Confidential, Houston, TX

Finance Team Lead

Responsibilities:

  • Implement and integrate SAP FICO module with other SAP modules (i.e. SD & MM).
  • Converted a large and complex Legacy system to SAP FICO ECC6.0.
  • Role includes information gathering, interface design, data mapping and conversion, and configuring New GL, AR, AP, CCA, PCA, COPA.
  • SAP Treasury Implementation and Administration Experience: Cash Management, Money Market, Accounting and Master Data Creation and Maintenance.
  • Coordinated special projects and programs for Global Treasury Operations Dept. Cross-trained in several key areas of Treasury, providing first level back-up for the following functions: North American cash management, daily issuance of commercial paper and foreign exchange trading. Creation of ad-hoc reports to analyze metrics of cash flows, transaction processing and working capital management.
  • Supported SAP Treasury Management platform as Power User, Process Trainer and Regression Testing Lead. Facilitated month-end accounting reconciliation between Treasury and other areas of Finance.
  • Perform all tasks in the development cycle, starting from business process definition to configuration and unit testing, assists and follow-up with users who perform UAT.
  • Configuration included: GL accounts, Account Determination, Field Status Groups, Enterprise Structure - Credit Control Area and Business Area, Account Groups, Document types, Customer and Document number ranges, Terms of payment, Clearing functions - Posting Keys, Reason Codes, Automatic clearing, Account assignment, and Tolerance groups, Bank master data, Closing & reporting, Interest calculation, Statements, Dunning, Credit Management functionality and Lockbox processing.
  • Teamed with Treasury Department to Configure TR-CM Cash Management. Cash Management configuration included account management, electronic bank statement, account groupings, Lockbox processing, liquidity forecast, cash management position, manual check deposit, cash concentration, and the payment program.
  • Applied ASAP Methodology for planning, designing and implementing SAP FICO.
  • Provide application functional support and implementation in SAP Applications R/3, within the module areas of FI-Finance (GL, SPL, FM, AP, AR), CO Controlling.
  • Created & maintain project plans, schedules, and updates for assigned projects or system enhancements.
  • Developed and maintain the configuration and functional design documents and support role based profile changes.
  • Identify, evaluate, and develop solutions.
  • Fixed assets FI-AA required configuration of asset classes, account determination, screen layout, asset under construction, capitalization, acquisition, depreciation, disposition, and reporting.
  • Troubleshoot productions and work with development team.
  • Profitability Analysis (account based and costing based)
  • SAP modular experience includes: General Ledger, Accounts Payable, Accounts Receivable, Treasury, Asset Management, Cost Center Accounting, Profit Center Accounting, Product Costing and Special Purpose Ledger.
  • Worked with business leaders to translate business and functional needs into technical requirements.
  • Defined, configured, and reengineered CMRS financial data to SAP FI/CO modules according to business requirements.
  • Performed business requirements analysis and developed solutions.
  • Implemented and modified SAP FI/CO modules and resolves implementation issues.
  • Educated others in the workflow, business processes, and reporting metrics of SAP FI/CO. Coordinated, implemented, and communicated system change requirements
  • Defined and assigned company codes as well as the chart of accounts
  • Documented new business processes and create new process flows to aid and change documentation.
  • Translated system requirements into functional spec documents and process flow charts.
  • Interfaced with clients, users, developers, and management and DBA teams to aid system development, testing, troubleshooting, and deployment.
  • Interfaced with Users and platform experts to develop functional test and use cases.
  • Served as technical contact for clients undergoing User Acceptance Testing (UAT) processes.
  • Facilitated conference calls with clients and support teams to establish troubleshoot and resolve database, application and/or system process issues.
  • Worked closely with Project managers to determine technical solutions to specific client need by acting as liaison between developers, DBA’s and business end-users
  • Created Business and Technical flow charts to illustrate proposed solutions in MS Visio and Power Point presentation formats.
  • Hands on approach to configuring SAP FI/CO including General Ledger, Accounts Payable and Accounts Receivable.
  • Configured and customized profit center hierarchy, sales order substitution, material master assignment and reports.
  • Responsible for configuration, testing and documentation of the solution in the Treasury area.
  • Configured Lockbox process/automated AR cash posting and on AP side Positive Pay file.
  • Stop payment report using ALV: This report gives the Line items stopped for payment, item details such as House Bank, A/c Id, ABA, DDA, Check range, Check issue date, Total dollar amount and Business partner for Non-Electronic Banks.
  • TR-CM configuration and implementation of Electronic Bank Statement Upload and Processing.
  • I have supported SAP Vertex/Sales & Use tax, Lacerte Computax and other tax software packages.
  • Configuration included, tax by country, verify tax indicator, assign tax classifications, define default for non-taxable transactions, tax jurisdiction structure for USA, tax codes, processing key set up, condition records, configured non-USA countries, created reports, worked on customer master data conversion, supported post implementation, integrated with order entry and Material Management module.
  • Responsible for FI/CO configuration test based upon existing business processes and business scenarios, create FI-General Ledger test plan.
  • Mapped and specified with programmers all conversions and interfaces from Legacy system to SAP.
  • Trained and advised team members on SAP functionality.
  • BSCS produces one page activity summary of each hospital’s overall performance in financial, service/satisfaction and core measure indicators to senior level team members.
  • I implemented SAP FI/CO 4.6 upgrade project, did fit gap analysis, business re-engineering, testing and new configuration to fit gap between SAP 3.1h to SAP 4.6C version.
  • Includes SAP AR, AP, AA, GL and CO modules.
  • Gathered system requirements for End User to Super Users and designed and implemented .
  • Followed ASAP Implementation methodology and designed the business processes, wrote blueprint phase documentation and completed configuration during realization phase.
  • Change Configuration for executing a Cycle count and frequency

Hire Now