JAMAL KHAN

TECHNO-FUNCTIONAL MIGRATION CONSULTANT

acodxp@r.postjobfree.com

Katy, Texas 77449

832-***-****

Available Immediate

SUMMARY

Total IT experience of 14 years. Certified Consultant in the Data Migration and Data Governance Methodology and Tools with over 10 years of SAP experience in the Materials Management (MM), Plant Maintenance (PM), and Financial and Controlling (FICO) with Extensive knowledge of QM and EDI processes.

I exhibit a great deal of leadership due to my extensive experience interacting with client-side resources and team members. I am a results-oriented and customer-focused with a proven track record of quality assurance. My analytical and problem solving skills coupled with core technical skills make me an asset to any data migration team and Quality Assurance Team.

CORE Competencies & Expertise

• SAP Implementation

• SAP 4.7 / ECC 6.0

• SAP MM, PM, QM, FICO, BW

• 7+ yrs analysis and ERP configuration

• Go-live Cutover Plan

• Data Governance

• Microsoft Access

• BI (SSIS, SSAS & SSRS) • Business Objects Data Services

• Information Steward

• Information Design Tool (Universe)

• 5 Full SAP Implementation (Business Definition & Planning to Go-Live)

• Technology Development • Cost Benefit Analysis

• Strategic Business Planning

• Change Management

• Data Integrity & Recovery

• Contingency Planning

• Mentoring and Coaching

• Business Impact Analysis

• Data Quality Assurance

PROFESSIONAL EXPERIENCE AND CERTIFICATIONS

• Certified Consultant in BackOffice Associates Data Migration Toolset™ and Methodology

• Certified Professional in Oracle 9i Administration

• CSP – Certified SCRUM Professional

• CSM – Certified SCRUM Master

• CSTE – Certified Software Tester

EDUCATION

Bachelor of Science, Management Information Systems

WORK EXPERIENCE

Abbott Laboratories

Senior SAP BODS Lead

Chicago, Illinios January 2015 – Till Date

Responsibilities

• Lead a team of 4 individuals for Quality Management Objects and all tier two objects which are corresponding with the tier1 object.

• Established guidelines for Developers to develop the entire job in BODS for Recipe Update.

• Conducted meeting on Data Cleansing, data enrichment and mapping tasks.

• Gathered business requirements from key stakeholders and translated them into a comprehensive data solution design.

• Crafted and collected data from Legacy systems and DCS files in BODS.

• Built the entire ETL architecture and help Junior developers in best practices for data migration.

• Lead a team of 3 offshore Data migration BODS and IS consultants.

• Performed weekly review of Central Repository to validate if the coding standards are being followed.

• Oversaw data load error recovery efforts.

• Drafted Data construction server pages for business to validation and provide Legacy cleansed data.

• Provided training to manager and SME on various technical issues as needed.

• Formulated data reports in Information Steward Environment.

• Provided guidance in creating Error, Info, Profiling, Business Readiness, Business Relevancy, SAP Readiness, Preload and Post-load reports.

• Maintained existing data migration program with occasional upgrades and enhancements.

• Performed data migration enforcement tasks.

• Extensively completed data quality management using Information Steward and did extensive data profiling.

• Provided detailed metric reports to business on how SAP ready the data is in information Steward.

• Developed and implemented the entire naming convention methodology in BODS and Information Steward to eliminate confusion between multiple objects of different modules.

• Maintained proper documentation for each object in Google docs for Knowledge transfer if needed.

• Conducted peer review of every object between offshore and onsite resources.

• Provided weekly update reports and measured the data KPI.

• Maintained a proper version controlled documentation on different environment data loads.

COSTCO Wholesale

Senior BODS Data Migration and Validation Lead

Seattle, Washington March 2014 – December 2014

Responsibilities

• Responsible for Master Data (Material, Customer, Vendor) and all tier two objects which are corresponding with the tier1 object.

• Developed a performance optimized Data Services objects.

• Created repositories, projects, work flows, data flows, scripts and Data Stores.

• Brought Costco’s Extracting methodology to industry standards and implemented hard required rules.

• Created RFC connections to SAP systems.

• Setup ODBC connections between multiple systems.

• Performed tests on data quality and load optimizations.

• All jobs include extensive work on extract the data from different sources. Built extract jobs in order to extract the data into staging.

• Built in scope jobs in order to extract data only to get the data as per business requirements.

• Remediation.

• Data Quality management and data profiling using Information Steward.

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

• Worked extensively On ORACLE SQL DEVELOPER in order to do the backend testing.

• Conducted extensive meetings involvement as a part of defect resolution and also live trouble shooting with the Junior level Developers, SME and also rest of the team.

• Involved in complete life cycle of a data migration from DEV TO PROD.

• Helped business generate requirements for complex reports to automate the business manual validation process.

• Reduced a tremendous amount of time by automating the validation process.

• Developed and implemented a proper Data Migration, Data Validation and naming convention methodology.

• Developed and delivered the following objects. Article Master, Vendor Master, Customer Master, Inventory balances, Accounts Payable, Accounts Receivable, Historical GL Balances and Year End Balances.

• Provided guidance to junior team members on the Data Migration and Validation approach.

• Introduced and Implemented a industry standard of A, B and C Validation methodology for Reports.

• Trained and guided Business SME (Subject Master Experts) on Extract Validation (A), Transform Validation (B) and Load (C) Validation requirements parameters are.

• Held daily standup meetings with the entire team of 11 individuals on site and 3 off shore.

• Taught and trained developers on how to maintain standards of flipping defects around within 4 hours of time.

• Did a weekly code peer review to bring all the code to an optimized level.

• Created a standard Technical Design document to be filled out via the team members.

BHP Billiton

Senior Data Migration Lead Consultant

Singapore, Singapore & Houston, Texas February 2010 – March 2014

Responsibilities

• Built quality and repeatable Data Cleansing & Preparation processes for Work Management Stream (Plant Maintenance, HSEC) for 1SAP Project (Release 3 & 4) for South Africa, South America, Australia, Canada and North America.

• Knowledge of Mining and Oil & Gas Industry.

• Knowledge of PM functional area and key interfaces / touch points between SAP PM/MM.

• Prepared/Cleansed master and transactional data (Functional Location, Equipment, Materials, BOM, Task list, Work Center, Work Orders, Documents, Permits, Maintenance Plan & Item and Measuring Point).

• Coordinated with onshore and offshore business and functional team.

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

• Worked with Overseas (Singaporean) Subject Matter Experts and coordinated frequent developments and change requests.

• Generate complex conversion rules in Data StagingWarehouse™ (DSW) from multiple data sources to fulfill business requirements.

• Created views and Stored Procedures, as well as other BackOffice Functions in SQL Server 2008 for many different Rules and Validation reports.

• Provided constant support to business during Mock Validation.

• Coordinated design decision meeting with Team Leads.

• Provided training for business users on EZMap™ and DataConstructionServer™.

• Produced reusable build and quality delivery of 530+ compliancy & error reports in SSRS to assist smooth data migration and integration with SAP Information Steward and Data Services.

• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

• Built active and passive data governance processes to validate and report weekly metrics across multiple database source instances and 2K+ manual files for 30 Assets/Operations across 9 commodity groups.

• Business Asset Groups include: Aluminum (Aluminum South Africa, Mozambique Aluminum, Worsley Australia), Base Metals (Cannington, Cerro Colorado, Escondida, Spence, Pinto Valley), Diamonds & Specialty Products (Ekati, Potash), Energy Coal (South Africa, Mt Arthur NSW Coal, Cerrejon Coal, New Mexico), Iron Ore, Manganese (Groote Eylandt Mining Company, Tasmanian Electro Metallurgical Company, Metalloys, Hotazel), Metallurgical Coal (Billiton Mitsubishi Alliance, BHP Mitsui Coal, Illawarra Coal), Nickel & Stainless Steel (Nickel West Australia, Cerro Matoso Colombia), Uranium (Olympic Dam), Minerals Exploration, Marketing & Group Functions.

• Created users and granted privileges to business users accordingly for different toolsets within CranSoft®.

• Designed and developed advanced data deduplication solution with custom stored procedures for large volume for 100% data integrity.

• Expert with various .Net / C# based CranSoft® Toolsets.

• Worked extensively to create tables and refresh all legacy tables in DataGarage®

• Ensure the design of tools, processes and validations are based on and adhere to a Global Template including Retrofit (ECC6, PM, DMS, GRC, SAP DS & SLO integration)

• Works with Data Stewards / Data Custodians to achieve better data quality.

• Builds ETL architecture and provides guidance to ETL developers on the best practices to handle high volumes of data.

• Responsible for SAP Data Services 4.1 development.

• Analyses data contained in source/target databases.

• Besides BOBJ Data Services 4.1 (BODS), I also use SAP Landscape Transformation (SLT) for real time replication.

• Extensively completed data quality management using information steward and did extensive data profiling.

• Guided QA team in creating SQL Test scripts for Data validation based off of Logical path and QA Test Plan.

• Assisted testing team in SQL back-end validation.

• Fixed various Data related QA defects.

• Designed and Developed ETL processed from Extract to Load.

• Developed Advanced Data Construction Pages in .Net / C# based CranSoft®.

SABMiller, plc.

Senior Data Governance Lead

Johannesburg, South Africa August 2009 – January 2010

Responsibilities

• Gathered requirements from different business users for different modules and scenarios.

• Developed cMass™ templates for Create, Change, Extend, Delete, Block and Unblock Scenarios.

• Configured different roles for each template

• Configured Privileges for each role based on requirements given from business user.

• Developed cMass™ templates for Materials, Vendors and Customers modules

• Developed cMass™ templates to Create New Materials with Material Master data for different Material Types.

• Developed cMass™ template to Create BOMs.

• Developed cMass™ template to Flag existing Material for deletion at Storage Location, Plant and Client level.

• Developed cMass™ template to Change Material Master Data for an existing Material.

• Developed cMass™ separate templates to Change Vendor Payment Methods, Payment Terms, Classification ABC Indicator and Withholding Tax Indicator

• Developed cMass™ template to create and change Purchase Order Long Text.

• Created and registered Validation rules at page and template level.

• Created Dynamic validations to be utilized in multiple templates and to reduce maintenance efforts.

• Developed Decision tree and Process document for training purpose.

Corning Cable Systems

Senior Data Migration Consultant

Hickory, North Carolina October 2008 – July 2009

Responsibilities

• Created conversion rules for Material Master, Inventory, BOM, Routing, Purchase Orders, Sales Orders, Open AP, Open AR, and Classification.

• Worked on Master Data (Materials, Customers, Vendors), BOMs (Material BOM, Equipment BOM, Sales order BOM, Variant BOM, Multiple BOM), Routings, PPM, POs, Purchase Info Records, Sales Orders, Scheduling Agreements, GR, GI, MRP, Kanban, IM, Catalog parts, Articles, Components, UOM, WIP, KITUPS, ECM (Engineering Change Management), PLM (Product Lifecycle Management).

• Loading the Standard Material Repository, customizing data from SAP into the Repository through Import Manager.

• Defining User, Roles in the console, importing the data from the files, defining the table joins and look-up tables, creating validation rules in data manager, creating matching rules, transformations and strategy to do the material matching and identify duplicates.

• Material Master MM - Reviewed and tested purchasing groups, purchase requisition, purchase orders, contracts, price determination process, material types, and valuation classes. Reconciled goods movement processing, goods issues, and goods receipts.

• Created views and Stored Procedures and used BackOffice Functions in SQL Server 2005 for many different Rules and Validation reports.

• Created Users and granted privileges to business users in CranSoft® that required access to EZMap™.

• Converted existing Mapping document into EZMap™.

• Granted privileges to user for different areas of CranSoft®.

• Created several WebApps to accommodate data construction for many objects.

• Helped to create a Dashboard to provide visibility in current standing of project mapping and development.

• Switched SAP table views in every database from one environment to another.

• Created Remediation rules at target level.

• Created rules for several fields including zError, zExclude, zSource, and zInSAP.

• Created Target Export to be used by BDC and LSMW in SAP ECC 6.0.

• Created and modified existing LSMW and BDC scripts.

Maxum Petroleum, Inc.

Data Migration Consultant

Oklahoma City, Oklahoma January 2007 – August 2008

Responsibilities

• Generated complex conversion rules in Data StagingWarehouse™ (DSW) from multiple Data Sources to fulfill the client’s business requirement for Project Systems.

• Created Pre-Load and Post-Load reports for Project Systems.

• Generated Error Reports for business to rectify legacy data errors.

• Created Users and granted privileges to business users in CranSoft® that required access to DataConstructionServer™ pages.

• Worked extensively in DataGarage® to manage data extraction.

• Used DataGarage® to apply rules to the data during extraction.

• Added new source connections and source systems to CranSoft® data source.

• Used SHDB to create vital recording in Inventory and Production Bill of Materials.

• Helped team members to generate conversion rules and reports for Material Master and Purchasing.

• Used BDCdirect® to generate scripts with conditions and modified screens to improve efficiency for the load process.

• Used CranPort™ to retrieve data from one server to another.

• Extracted and converted data from multiple source systems.

• Utilizing BackOffice Data StagingWarehouse™ (DSW), migrated legacy data from multiple legacy source databases into target tables creating SAP Business-Ready Data™ for Materials Management, Batches, and Storage Bin.

• Managed Data Conversion Specification updates and data modifications to target tables on an ongoing basis.

• Worked within SAP for purpose of verifying loaded data, reviewing transactions, and for a point of reference for data elements and tables.

• Resolved TIR (Testing Incident Reports) found during post-load data quality testing used at Mercury Quality Center.

Clear

SAP MM Functional Analyst/SME

Santa Monica, California January 2005 – December 2006

Responsibilities

• Experienced in 2 full life cycle implementations of the SAP MM module. Also configured several Procure to Pay (P2P) scenarios.

• Gained valuable knowledge on Material Master Data and Inventory Management and Accounting.

• Gained a good knowledge of Inventory Management concepts including Goods Receipts, Goods Issues, Reservations, Physical Inventory. Also involved in PP integration points including MRP and Production Orders.

• Gained a cross-application knowledge for integration of IM/MM with FI/CO for pricing procedures and also with SD module.

• Gained knowledge in Material Masters and Vendor Masters evaluation in SAP

• Worked with the MM enterprise structure.

• Worked with vendor master data: Account groups, number range and partner determination and field definitions.

• Worked with different material type, different number ranges for different material type, and field setting.

• Involved in inventory management/physical inventory.

• Involved in material planning, procurement, and development of new vendors.

• Supply chain and complete procure to pay process experience.

• Experience with QM, EDI, and other supply chain processes.

• Provided efficient post-Go-Live support to key users.

• End to end implementation and support experience in MM module.

• Extensively worked on tables related to MM.

• Extensive experience in interacting with business users to identify user requirements, preparing functional specifications for ABAP programmers, MM related interfaces including iDocs, and integrating testing and training of end users.

• Developed data conversion procedures.

• Mapped value from legacy source system.

• Integrated legacy system into SAP.

• Prepared functional specifications for generation of reports.

• Worked closely with senior executives to form viable business development strategies and plans.

• Translated system requirements into functional spec documents and process flow charts.

• Served as technical contact for clients undergoing User Acceptance Testing (UAT) processes.

e-MDs, Charting the Future of Healthcare

QA Manager (Conversion Project)

Austin, Texas July 2003 – December 2004

Responsibilities

• Reviewed business requirement and software specification requirements to achieve better understanding of business process.

• Developed reports in Quality Center.

• Gained experience in client-server computing and relational database environments.

• Gained experience with data management and data processing flow charting techniques.

• Utilized technical documentation skills.

• Responsible for troubleshooting and problem solving of SQL and Oracle development.

• Gained experience with managing multiple MS SQL 2000 & 2005 RDBMS on large systems.

• Gained experience with Transactional SQL, DTS/SSIS, and stored procedures.

• Gained practical experience in managing the internal and external MS SQL databases security.

• Certified SCRUM Master.

• Able to prioritize and execute tasks in a high-pressure environment.

• Implemented change process introduced during an iteration.

• Conducted sprint retrospective meetings at the end of every iteration.

• Gave demo to product team and stakeholders.

• Gained experience working in a team-oriented, collaborative environment.

• Self-motivated and directed with keen attention to detail.

• Managed 8 delivery teams, 4 offshore (India) and 4 onsite for a total of 22 individuals.

• Validated the offshore team’s test plan, test strategy, and test cases.

• Ensured the data migration project complied with Surescript policies and standards.

• Verified the private patient data was secured at all stages of migration.

• Worked very closely with QA team on DB and client-side performance testing using Silk Performer.

• Gathered requirements from stakeholders and defined the benchmark for database performance testing.

• Designed and implemented the build workflow from Development to QA and then to Demo environment.

• Performed duties of QA Build Master.

Verizon Wireless

Business AnalystDecember 2002 – June 2003

Responsibilities

• Created multiple reports in SQL Server.

• Used SQL queries to retrieve data from tables and to perform back-end testing.

• Validated Stored Procedure with different parameters.

• Validated and parsed XML calls through service layers.

• Helped System Analyst and DBA on defining the Data Model.

• Utilized SharePoint and Tortoise SVN for documentation versioning.

• Reviewed Business Requirement and Software Specification Requirements to achieve better understanding.

• Developed Functional Requirement Documents.

• Worked closely with PMO to define project roadmap.

• Gathered the required information for the project and set up the dates for milestones.

• Collected and analyzed the traceability matrix and then submitted the reports to management.

• Conducted daily meetings to discuss the status of the project and to accelerate resolution for the blocking issues to meet milestones.

• Provided support training after the application was deployed in production.

• Facilitated production testing and resolved issues related to environment and back-end applications.

• Interacted with QA analysts, designers, and developers in resolving the problems.

• Designed workflow for each module.

• Served as Product team’s proxy when signing off on each item as they were completed by delivery teams.

• Supported client’s UAT testing, providing assistance in resolving the issues related to several back-end systems.

• Produced user manual for Content Management System.

• Coordinated work of employees and outside contractors to meet deadlines, budgets, and client demand. Provided situational leadership to motivate individuals.

• Timed successful launches of websites to allow for system administrator support, developer resources, and training of content producers on Content Management Systems, as well as content delivery strategies.

Contact this candidate