AMIR M. KHAN

SAP BODS LEAD CONSULTANT

acc6ul@r.postjobfree.com – 832-***-****

PROFESSIONAL SUMMARY

• Over all 10 years of SAP Data Migration experience and have been a DM Lead for several projects for past 7 years.

• Over Seven years of development experience SAP BODS - Data Services

• Worked extensively with Data Extraction, Data Profiling, Data Cleansing, Data Enrichment, LSMW, BDC, BAPI & IDocs.

• Configured and installed SAP BODS, Job Server, Central and Local repositories.

• Experienced in different SAP BODS BPDMs, Transforms & Functions.

• Proficient in creating Jobs, Workflows, Dataflows, Query and other Transforms in SAP Data Services

• Excellent in implementing and testing of Stored Procedures, Views, Packages, Database triggers, cursors and functions at database level.

CORE COMPETENCIES & EXPERTISE

• SAP Implementation

• SAP 4.7 / ECC 6.0

• SAP FI/CO, PM, PRA

• 6 years Project Management Experience

• 5+ yrs. ABAP, analysis and ERP configuration (SAP FI/CO, GL, AR, AP, PRA)

• Go-live Cutover Plan • SAP HANA

• RDS - BPDM

• BODS - Business Objects Data Services

• SAP – EIM (MDM, MDG, Information Steward)

• Data Governance

• 4 Full SAP Implementation (Business Definition & Planning to Go-Live) • Technology Development

• Strategic Business Planning

• Change Management

• Research & Development

• Data Integrity & Recovery

• Contingency Planning

• Risk Assessment

• Mentoring and Coaching

• Business Impact Analysis

PROFESSIONAL EXPERIENCE

Swagelok

SAP Data Migration Lead

2012 (Dec) to current Solon, OH.

• Responsible for data migration and conversion activities such as extraction, transforming, migrating, validating and reconciliation of data.

• Developed data migration approach and strategies.

• Provides guidance to internal IT key users to design and develop data loaders / templates to fit the business requirements.

• Developed validation programs to cross check all the data before and after the data loading.

• Identifies problematic areas and conducts research to determine the best course of action to correct data.

• Proactively identifies project risks and created feasible solutions.

• Escalates cross functional issues and identified SMEs required for resolution.

• Drive data migration strategy and process to enable quality data delivery without delays.

• Advises and assists in data extraction, data cleansing, data mapping, data harmonization, data enrichment, data consolidation, data loading and data reconciliation.

• Provides weekly update reports and measured the data KPI.

• Provides guidance and advice on SAP Data Migration methodology.

• Builds ETL architecture and helps junior developers with best practices for data conversion.

• Responsible for full Migration cycle of objects across modules including SAP technical and Functional assistance on the project.

• Responsible for coordinating with various teams and resolving any incidents/requests/issues related to SAP MDG.

• SAP MDG Implementation and support including Data modeling, Process modeling, UI Configuration & Data Replication techniques.

• Responsible for performing Industry and process-oriented MDM/MDG consulting for key customers.

• Gathers business requirements from key stakeholders and translate them to a comprehensive data solution design.

• Works with Information Steward to profile legacy data.

• Utilizes Rapid Deployment Solution, BPDMs and customized Jobs to migrate data with SAP Data Services for following items: Purchase Orders, DMS, Inventory, PIRs, Misc. PRTs, Batch Master, Work Centers, EWM Stock Transfer, Product Master, Storage Bins, and Inspection Rules.

• Resolves technical issues and implement code modification needed to support changing user requirements for multiple data services jobs.

• Responsible for developing complex SAP Data Services Data flows / Workflows using different types of transforms like Query transform, Table compare transform, Case transform, Map_operation, Merge, History_preserve and key_generation transform based on the business requirements.

• Migrated code from Local/Central repository to different environment repository.

• Works with project managers, SAP’s offshore and partner consultants to develop consulting and project methodology, techniques, tools, and solutions.

• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, and hierarchies.

• Gathered and analyzed the requirements to replicate the ECC content in HANA using Data Provisioning.

• Performed data modeling and developed Analytical views for the transactional data, Attribute views for master data, and the calculation views as the final model in SAP HANA studio.

BHP Billiton

Sr. SAP PRA Techno-Functional Consultant

2010 (Oct) to 2012 (Dec) Houston, TX.

• Gathered business requirements from key stakeholders and translate them to a comprehensive data solution design.

• Over two plus years of experience in working on SAP’s Oil and Gas industry solution in the upstream area which consists of PRA and JVA modules.

• Experience in configuring PRA module business processes of Production Allocation, Regulatory Reporting, Ownership, Tax and Royalty Reporting.

• Worked on design and configuration of revenue recognition and development of revenue recognition custom program integrated with SD.

• Knowledge of Finance, Contractual Allocation and Sales and Balancing modules of SAP PRA.

• Implemented SAP PRA MMS 2014 software. Instrumental in ensuring that the software worked properly and was compliant with the MMS regulations.

• Experience in Setup and maintenance of Production Allocation networks pertaining to operated facilities in North American upstream Oil & Gas PRA customers.

• Designed and developed ETL solutions for SAP PRA – IS OIL using SAP Data Services as well as Cransoft.

• Migrated data for IS OIL (PRA), Joint Ventures, Base DOI, Business Associates, Valuation, Delivery Networks and Well Data.

• Creating jobs using SAP Data Services to extract and transform data from the source systems to the target SAP.

• Provide the business and IT users with the pre-load and post validation reports after validation on source data and transformation.

• Initial data loads and data migrations from Legacy to SAP MDG systems

• Expert at Information Steward for Data Profiling.

• Used various De-duplication techniques Data Quality Transforms and other logics.

• Implementing the business rules, validations and restructuring the data into target SAP.

• Conducted meetings with Business, Functional consultants and Legacy experts for data mapping sessions.

• Provided business and junior consultants with knowledge of Data Profiling (Information Steward), Sourcing, Cleansing, Construction, Migration, Transformation and Reporting (Cransoft and SAP Data Services).

• Worked extensively with SQL Server 2008, SSIS Packages, Stored Procedures, and Views.

DOW Chemicals.

SAP Data Migration Lead

2010 (Jan) to 2010 (Oct) Saginaw, MI.

• Developed cutover plan

• Capable of managing unstructured data team to a professional high performance data team.

• Capable of overcoming any project delays, apply proper strategies to ensure the project schedules are on track.

• Migrated legacy system to SAP ECC 6.0 and SAP MDG platform for master and transactional data.

• In depth and hands-on development experience of using SAP BODS 4.1, LSMW, BDC & IDocs across all areas of SAP (FI, SD, MM, PP, QM and PM)

• Designed and developed data conversion programs using conventional LSMW, BDC and IDocs.

• Able to design any LSMW loaders with full consistencies checked.

• Provided immediate support / guidance for bug fixes or data issues.

• Provided guidance to PM in grasping data migration concept and processes.

• Proficient in LSMW, IDOC, ALE, BAPI, batch input, direct input, SQL Views, MS Access & Excel.

• Expert in CranSoft® tools and security.

• 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 target and source rules and validation reports for multiple sources for all assigned objects.

• Created Remediation rules at target level.

• Worked with DataGarage® to manage the Legacy sources.

• Created Target 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 and trained junior consultants in several applications in CranSoft® for optimal performance as well as SAP Tools such as BODS and Information Steward.

Carlsberg Group

SAP Data Migration Lead

2009 (Apr) to 2010 (Jan) Copenhagen, Denmark

• 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 target 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 training server, Software, and Training 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.

Sysco Food, Inc.

SAP Data Migration Lead

2007 (Feb) to 2009 (Apr) Houston, TX.

• Involved in every aspect of Data Conversion from start to Go-Live.

• Implemented/supported Data Cleansing activities to reduce data redundancy.

• Data Construction activities to make sure data is SAP ready and consistent with the requirements.

• 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 training 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 target 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.

• Technical expertise includes ABAP, dialog programming, ALV reports and classical report, BDC & LSMW.

Target, Inc.

Sr. SAP Data Migration Consultant

2006 (Jul) to 2007 (Feb) Minneapolis, MN.

• Worked extensively with BackOffice Data StagingWarehouse™ (DSW), DataGarage®, BDCdirect®, and LSMW.

• Experienced in creating DTS Packages, Validation Reports, and Source Rules and Target 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 Target 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 Target Table.

• Created all the Validations for zOKToLoad and zLoaded for stVBAK to verify if the data that had been inserted into Target 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.

• Experienced in ABAP, Interfaces development, Data Conversion, Enhancements and User Exits.

CHRISTUS Health 1999 (Mar) to 2006 (Jul) Houston, TX.

Improved business processes and supported critical business strategies in SAP FI/CO by managing the development, implementation, and maintenance of business applications systems. Led multiple projects and oversaw developers to ensure that specifications are met. Worked closely with senior executives to form viable business development strategies and plans. Integrated system-wide programs and software development processes for clinical redesign, medical informatics, data analysis and research/development. Provided technical leadership in study and project design.

Revenue Cycle Management (Corporate office) Mar 04-Jul 06

• Finance Team Lead. Led and mentored staff with designing and configuring FI modules including GL, AP, AR and FA. Other duties included creating project plan, assigning resources, creating timelines; performance reviews write-ups, and mentoring consultants and client personnel.

• 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.

• Implemented Data Quality / Data Governance to make sure data is in compliance with HIPAA directives.

• 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.

Department of Finance Mainframe (Corporate office) Jul 03 – Mar 04

• 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 training 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, training 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.

• 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.

Balanced Scorecard (Corporate office) Oct 02 – Jul 03

• 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.

Physician Re-credentialing (Corporate office) Dec 99 – Oct 02

• 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 training.

• 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

Computer Task Group (CTG) Jan 98 - Dec 99 Topeka, KS

Software Engineer (Contract)

Served on various projects for the State of Kansas. Duties include analyzing, designing, developing / tracking of project schedules, conducting client meetings, developing program specification, writing test programs. I implemented and maintained various projects within the company.

Kansas Department of Health and Environment (Database Analyst & Administrator)

• Supervised the generation of reports for Clinical/Outcomes research, automated and oversaw processes for quality management activity by healthcare center and system.

• Supported clinical quality outcomes studies with applications and development of applications.

• Organized and conducted client meetings, developed program specification and writing / testing programs.

• Successful projects include: Funds Management System, Medication Error Safety project, Denials Management System, and Project Management database.

Kansas Department of Health and Environment (Disease tracking System)

Performed analysis and design. Developed the system with the use of Visual Interdev 6.0 (Java scripting and VBscripting) and SQL Server 7.0 (Created Stored Procedures, Triggers and Views performed Tuning and Configuration, Processed Transactions, Monitored Processes and Locks, Created Backup and Restoration Strategies, Added Linked Servers, Used DTS, BCP, and Transact-SQL to Import Data, and also worked with Replication) for the backend.

Kansas Department of Administration

Analyzed existing system. Developed a relational database in SQL Server 7.0 (Created Stored Procedures, Triggers and Views performed Tuning and Configuration, Processed Transactions, Monitored Processes and Locks, Created Backup and Restoration Strategies, Added Linked Servers, Used DTS, BCP, and Transact-SQL to Import Data, and also worked with Replication) for the backend. Developed front-end with Visual Interdev 6.0 (ASP, java scripting, Vbscripting). Documented new system and created a user’s manual.

Lawrence Medical Health Center Dec 96 - Dec 97 Lawrence, KS

Software Developer

My Duties included analyzing, designing and developing program specification and writing test programs. I analyzed an existing system, to include an additional product to three existing site.

• Wrote an intricate Visual Basic data parser to transfer data from flat files into multiple relational tables.

• Utilized Erwin for PDMs and CDMs for data modeling.

• Conducted meeting with all subject areas experts for reporting needs.

• Along with Building DTS packages to perform data load task, I also wrote stored procedures and produced proper documentation for future enhancements.

• Created Scripts for Data warehouse and backup development and restored in staging and then moved it into Production environment.

• Created a MDM (Master Data Management) environment for data consolidation purposes.

• Train new developer on existing and upcoming technology.

TECHNICAL QUALIFICATIONS

• SAP FICO/PM/STP/MM

• BO Crystal Reports

• SLT

• Web Intelligence • SAP HANA

• BO Analysis

• SAP Dashboard

• SQL Server 2005/2008 • BO Data Services

• BO Explorer

• Information Steward

• MS Project 2007/2010

EDUCATION / TRAINING

Bachelors in Computer Science (BSCS) – Karachi University – Karachi, Pakistan

SAP HANA Certified

Implementing a Database on MS SQL Server 2005

System Administration for MS SQL Server 2005

ASP.NET

Visual Studio.NET

Visual Basic.NET

PERSONAL QUALITIES

• Ability to Prioritize • Self-Motivated • Organized

• Responsible • Energetic • Team Player

• Self-Directed • Ability to Multitask

PROFESSIONAL & CIVIC AFFILIATIONS

American Medical Information Association, AMIA (1999 to 2006)

Healthcare Information Management Systems Society, HIMSS (1999 to 2006)

Contact this candidate