Ash Ahmed
Data Engineer - SAP BW/4 HANA , SAP FICO S/4HANA
Hire this person
Send a job offer directly to this candidate
About
Over 20 years of IT experience in design, development and implementation of business applications that includes more than 12 plus years of functional/technical expertise in SAP BI/BW. Involved in 8 full life cycle implementations (including upgrade from BW 3.5 to BI 7.0) from blue-print to Go-Live stages. Well versed with ASAP Methodology and all the phases involved in Project implementation.
Experienced in Data Analytics/ Data Mining utilizing different ERP tools and techniques. Experienced in working in upgrade Projects from BW 3.5 to BI 7.0. Extensively worked on different domains like SD, HR and FI/CO (GL/AR/AP).
Strong expertise in SAP BI 7.0 features: Transformations, DTP, Error DTP, DSO, Start and End Routines using Data Warehouse Workbench. Experienced with new BI 7.0 features Real time data Acquisition, write optimized DSO, Open Hub destination, Admin Cockpit, BI Accelerator, Analysis Process Designer and Information Broadcasting. Expert in building SAP-BW Components like Info-cubes, Data Marts, Multi-Providers, Info Sources, Info-object, ODS Objects, Info Spokes, Update Rules, Transfer Rules and Routines.
Expertise in data extraction from ECC (FI/CO, HR, CRM, SD, CO-PA) and Generic Data Sources.
Customized Standard Business Content
Extractors and Enhanced Data Sources in various applications using customer user exits to suit the user requirements. Extensive experience in Production Support. Created and Scheduled process chains to load master/transaction data for daily, weekly and monthly intervals.
Experienced in Report Generation – Worked extensively in BEx Analyzer and Web Application Designer. Created custom queries using Conditions, Exceptions, Variables, Structures, Restricted and Calculated Key Figures. Experienced in ABAP programming which helps in developing custom solutions using code in User exits, Start Routines and End Routines.
Hands-on in SAP HANA modeling using attribute view, Analytic view, and Calculation view. Good knowledge in Direct extractor connection. Hands-on experience with SAP S/HANA implementation and support in finance and supply chain operations.
Partnered with cross-functional teams to optimize workflows and reporting using S/4HANA capabilities. Able to adapt quickly to new technologies and work environments. Excellent communication, interpersonal, managerial skills and positive work attitude and self-motivated to work independently and as well as in a team.
Experience
Data Engineer - SAP BW/4 HANA , SAP FICO S/4HANA - International Paper - Memphis, TN
(2022-10)
Working as a senior level BI Architect on a large scale SAP finance implementation. Involved in implementation and support of SAP S/4 HANA modules (FI/CO, MM, SD) to streamline core business processes. Currently Involved in end-to-end testing and user training during S/4HANA migration from ECC.
Manager - Business Intelligence - Power and Controls - FP&A - Collins Aerospace (Now Raytheon Technologies)
(2017-11 - 2022-10)
In the air, on the ground, or at sea, in both manned and unmanned platforms, our military and defense products help Allied defense forces around the world complete missions safely, efficiently and effectively. Brought in to build reporting solutions for Finance Cost Accounting including Labor Reconciliation, Costing Run and Government Finance. – Ongoing. This project is to provide business super-users with complete automation of ECC reporting in BW/BI platform by identifying database tables used by each T-code that the business user runs in ECC to reconcile FI and CO data in the Cost Accounting area and building BW components using related database tables.
Building customized data sources, Transformation mappings to the target components including DSO’s Infocubes and MultiProviders for BEX queries. Scheduling in Production systems for daily executions using Process Chains etc. Working with the business community for Ad-hoc requirements in different areas.
Involved in implementation and support of SAP S/4 HANA modules (FI/CO, MM, SD) to streamline core business processes. Involved in end-to-end testing and user training during S/4HANA migration using LTMC and LTMOM capabilities.
SAP Business Intelligence Analyst III - Dawn Food Products - Jackson, MI
(2013-09 - 2017-11)
What began as a small but thriving bakery in Jackson, Michigan, more than eight decades ago has evolved into the international bakery supplier known as Dawn Food Products, Inc. Senior member of a large team on project SAP implementation of core module such as FI, P2P, SD and MM. Involved in all phases of the project. Responsible for production environment support. Worked on Data extraction frpm SAP ECC or Legacy systems to SAP BW system using SAP BODS.
Sr. SAP BI Lead Consultant - Cameron International (Oil & Gas) - Houston, TX
(2012-11 - 2013-09)
Cameron is a leading provider of flow equipment products, systems and services to worldwide oil, gas and process industries. Leveraging its global manufacturing, Working as a senior level SAP BI consultant on a large scale project involving a joint venture between Cameron International and Schlumberger oil companies. As part of an onsite/offshore BI team, my role includes conducting SAP BI impact analysis covering all the functional areas impacted by this merger including FI, SD, MM, and other modules.
Development (Extraction, data cleansing, reporting), writing test scripts and deployment.
SAP BI Lead Consultant - California State Teachers Retirement Systems (PS) - Sacramento, CA
(2012-02 - 2012-11)
Working as a senior level BI consultant on a large scale SAP finance implementation. As a principal consultant, responsible for working with the functional team to build BI data warehouse, SAP delivered standard contents and a large number of external interfaces and legacy systems. Also, a full implementation of SRM using standard extractors and internal SRM tables.
- Largest U.S. teachers' retirement fund
- Membership: 856,360
- Assets: $152.1 billion as of July 31, 2012.
Sr. SAP BI Consultant - Fossil Inc. (AFS) - Richardson, TX
(2012-12 - 2012-02)
Fossil is a global retailer specializing in the design, innovation, and marketing of fashion lifestyle and accessory products. At the heart of the Company’s vision is a commitment to fostering creativity and delivering the best in design through its two core businesses: Fossil brand; and a multi-brand watch business. Worked as a Sr. BI consultant for the configuration and implementation of COPA. Developed and implemented VISTEX for BI reporting for Sales, Advertising and Inventory.
SAP BI Programmer Level III - Lockheed Martin - Denver, CO
(2011-09 - 2011-12)
Aeronautics - Lockheed Martin Aeronautics Company is known for building the finest military aircraft in the world. This recognition was earned through relentless research and development of high-performance aircraft and by continuously seeking innovative and low-cost design and manufacturing strategies. Working as O&M lead, supporting the production environment.
Day to day operational incident monitoring and resolution. Working on several development projects in parallel. Mentoring the internal team members on developing BI skills.
SAP BI Architect/Configurer - JBS Swift - Greeley, CO
(2010-04 - 2011-09)
JBS Swift Company is the world’s second-largest processor of fresh beef and pork products, and the leading beef processor in Australia. Founded in 1855, Swift has more than $10 billion in annual sales and more than 20,000 employees worldwide. Joined the company during the acquisition and transition of Pilgrims Pride Company in Rockwall, TX.
Responsibilities include transition of existing business areas such as LOR, BPS, PCA, CCA, APO Lite, EDI etc. Responsible for all historical data development involving 2 years of data archiving. Also responsible for development of technical design/specs of new requirements for JBS. Development of new data marts. Involved in Business Objects implementation.
Building
Universes according to the reporting requirements. Developing queries in Bex to be used as source for the universes. Involved in heavy custom development for historical date extracted from PeopleSoft system that includes building of objects to map with the interface files. Also responsible for all the production support issues as on-call. Recently implemented Business Objects (Webi/Crystal) as our primary front-end tool for corporate reporting solutions. Was actively involved in BOBJ
Sr. SAP BI Architect/Manager DW - AngioDynamics - Queensbury, NY
(2009-11 - 2010-04)
Founded in 1988 in Queensbury, N.Y., U.S., AngioDynamics is today a NASDAQ-listed public company with more than 650 employees. They are a leading provider of innovative medical devices used by interventional radiologists, nephrologists and surgeons for the minimally invasive treatment of cancer and peripheral vascular disease. Their diverse product line includes market-leading radiofrequency ablation and irreversible electroporation resection systems, vascular access products, angiographic products and accessories, dialysis products, angioplasty products, drainage products, thrombolytic products, embolization products and venous products.
Lead a team of 7 internal resources and 8 offshore developers. Responsible for all the data warehousing and reporting requirements of the business which includes development of custom BW components (IC’s, DSO’s, Objects, Datasources) and conversion of current crystal reports into Bex reports utilizing BW 3.5 reporting tools. Also, working on the layout of the roadmap from BW 3.x to BI 7.0 in the near future.
Currently involved in working with local and global teams for the upcoming CRM (Services) implementation with target Go-Live as of Apr'1 2010
SAP BI Consultant on HR, SCM and FICO configuration and implementation. - United Launch Alliance (Lockheed Martin) - Denver, CO
(2009-01 - 2009-10)
Project scope was to extract financial and Controlling data from R/3 and load into the data mart and on to Cognos planning server for financial planning and forecasting.
- Developed FI-CO (AP, AR, GL) functional and technical specs. Submitted the data model design after successful completion of gap analysis of the GL DSO and Cube.
- Activated/installed all required business contents including cubes, dso’s into BI.
- Activated all AR, AP, GL, CO and CATS master data (phase one)
- Created Transformations, DTPs and InfoPackages for all above master data
- Migrated all the v3.5 data sources to Netweaver 2004.
- Loaded all the transactional data for FI and CO.
- Deleted and reloaded all HCM master data per requirements.
- Created ad-hoc queries for SCM, HCM, FI, and CO requirements
- Activated content Data Sources such as 2LIS_12_VCHDR (Delivery), 2LIS_02_ITM (PUR) etc.
- Mainly responsible for transporting the entire project contents (Infoproviders, Reports, Process chains, Portal content, Security Roles) from development to Q/A.
- Closely worked with Basis team and Oracle DBA and FICO functional leads to create ODBC connection between BI and data mart for the FICO data feed for the Cognos planning/reporting.
- Worked extensively on Historical Data Archiving into BI from several Legacy systems (ARS, BAAN etc) creating several DSO’s for reporting requirements. Also developed functional and technical specs (Custom and SAP objects, Datasources, DTP’s, Transformations, Infopackages etc) for all archiving requirements.
Sr. SAP BI Consultant - Freeman Company - Dallas, TX
(2008-08 - 2008-11)
Environment : SAP BI 7.0/BW3.5, SAP ECC 6.0, Enterprise Portal 6.0 FREEMAN is the world's leading provider of integrated services for face-to-face marketing events, including exhibitions, conventions, corporate events, and exhibits. The project deals with implementing FI modules for financial reporting. The project involved creating the entire data flow and reports for both management and operational reporting.
- FICO and IP project implementation.
- Worked as a Co-Lead, training other developers on design, back-end development and reporting.
- Managed entire projects from requirement gathering to production implementation. Delegated work load among junior developers. Interacted with different user groups for project specifications. Performed user training.
- Submitted the data model design after successful completion of gap analysis of the GL DSO and Cube.
- Involved in writing the required start routine, end routine and update routines for data transformation and Cleansing.
- Activated BI contents for Integrated Planning such as Planning Functions and Planning Process management (PPM).
- Enhanced the 0FI_AR_4 datasource according to the user requirements.
- Was mainly responsible for transporting the entire project contents (Infoproviders, Reports, Process chains, Portal content, Security Roles) from development to Q/A.
- Designed the entire data loading process for all the master/transaction data loads.
- Created the cut over plan and implemented it for successful Go-Live process.
- Scheduled the process chains and successfully monitored and fixed the load failures.
- Experienced with new features and data load process in BI 7.0
- Experienced in new error handling techniques using Error Stack DTP.
- Installed the required OSS Notes to fix issues in SAP BI 7.0.
- Document detailed business process procedures (BPPs) according to the requirements.
- Performed routine basis tasks including monitoring locks, object transportation to production using t-code STMS, setting up user roles/ authorizations, monitoring system performance, applying OSS notes (Direct/Manual) from SAP, cube partitioning etc.
- Performed BI Security tasks on a daily basis. (See ‘Basis Experience’)
BI 7.0 Migration - Freeman Company - Dallas, TX
- Created the project plan for the entire migration of the BW data flow and the components.
- Involved in the migration of BW 3.5 data sources/queries to BI 7.0 data sources.
- Created Transformation by migrating update/transfer rules from 3.x to 7.0
- Migrated the queries from 3.x to 7.0 and resolved the issues during migration.
- Created test plans to perform regression testing.
- Referred OSS notes to resolve issues while migrating to 7.0.
SAP BI Consultant - ACS Computer Services - Dallas, TX
(2007-01 - 2007-10)
Environment : SAP BI 7.0, SAP ECC 6.0, Enterprise Portal 6.0 ACS is a global leader in business process and information technology services. The project deals with implementing CO modules for Cost reporting. The project involved designing the entire data flow for data loads and creating reports for both management and end user reporting.
- Worked extensively on standard and custom defined LIS, LO extractors. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery information. Logistics Cockpit configuration and customization
- Managed and monitored data loads with Full update and Delta update
- Involved in upgrade process from BW 3.5 to BI 7.0.
- Experienced in migrating BW 3.5 data sources to BI 7.0 data sources
- Created test plans to perform regression testing and implemented them successfully before and after migration to validate the migration process.
- Implemented the required OSS Notes after upgrade to resolve the issues.
- Created Data Transfer Process(DTP) to schedule the update in BI 7.0
- Developed flexible queries using filters and navigational attributes to facilitate data analysis in a drill down or summarized way to give detailed levels of information, required in areas of SD and FI.
- Extensively worked on query development and formatting techniques in both BEx and Web Application Designer(WAD) of key BW reports and created Web Templates
- Worked on BEx Analyzer and WAD. Created queries using BW- Reporting variables, navigational attributes and Filters. Developed workbooks, info set Queries. Defined reports as per reporting requirements.
SAP BW Consultant - SBC Inc. (AT&T) - St. Louis, MO
(2006-05 - 2006-11)
- As a part of the BW implementation team, involved in gathering user requirements and data modeling using ERM, star schema concepts.
- Analyzed Business and Query Requirements, designed data model.
- Worked extensively on administration workbench and business content.
- Worked on flat file extraction of master data and transaction data of Non-SAP R/3 systems into BW. Used extended star schema for data modeling.
- Worked on configuration of BW by identifying the needs of customers, modeling the data, defining data sources at OLTP and reporting data by using Administrator Workbench’s Business explorer.
- Installed and extended standard Business Content based on client requirements for enhancing DataSources for transaction data and master data.
- Worked on standard cubes (sales orders, billing and delivery orders).
- Modified data sources for certain Info cubes (0SD_C01, 0SD_C03).
- Used purchasing cube 0PUR_C01 for purchasing information. Designed and created a Custom ODS object for purchasing line item level details.
- Involved in developing extract structure in R3 and communication structures in BW to incorporate the changes for the end user acceptance.
- Developed reports on InfoCubes/ODS objects using BEx Analyzer to facilitate summarization of data. Created local workbooks, global workbooks, Infoset queries and template workbooks using Calculated Key figures, Restricted Key Figure, Filters, Exceptions, Variables, Conditions and Structures. Created and maintained roles.
- Involved in end-user training and documentation.
SAP BW Consultant - Dr Pepper/Seven-Up Companies Inc. - Atlanta, GA
(2004-06 - 2006-04)
- Involved in gathering Business Requirements and preparation of Information templates used for identifying data elements for future reporting needs.
- Involved in analysis of data requirements & translation of these requirements into dimensional data models using star schema and extended star schema, with an emphasis on actual implementation in BW.
- Worked with the Data management group during the process of Data Analysis & Data Mapping exercise.
- Installed and extended standard Business Content based on client requirements for enhancing DataSources for transaction data and master data.
- Created Info Objects, DataSources, InfoSources, Data targets, InfoPackages and InfoProviders to load Master and Transactional data from SAP R/3 system into BW.
- Involved in customizing LO-Cockpit extract structures (2LIS_11_VAHDR, 2LIS_11_V_SSL) and data sources in sales and distribution, and material management to facilitate the data extraction to BW and to reporting using classification of various data elements.
- Created Info package groups to automate the data transfer when and what intervals the data to be extracted from R/3 to BW.
- By using Open Hub Service the data, which is in Info, cube and ODS is passed to Flat files and db tables.
- Enhanced the Communication Structures to add new fields for Purchase Orders.
- Developed Transfer Rules to extract data from various DataSources to transfer structures.
- Created Custom InfoCube for Key Performance Indicators (KPIs) defined by business.
- Created a generic structure to extract data from the custom tables.
- Designed and created an ODS object which gets data from the generic structure.
- Loading of third party tools data through flat files periodically as required.
- Worked on performance tuning of Queries by creating aggregates, indexing and cube Compression.
- Created variables restricted, calculated Key Figures for the Queries. Created Conditions, Exceptions, Structures and Variables that are used in BEx Reporting.
- Provided help in end-user training and documentation.
Data warehouse ETL Developer (5yrs) - Neiman Marcus Group Inc. - Irving, TX
(1997-04 - 2004-05)
Worked as a Data Warehouse ETL developer for Neiman Marcus Retail Sales/Inventory system. The system replaced the legacy reporting system (built on Mainframe) and was able to deliver 4 years of historical data sets and assisted end users(Planners and Buyers and Executives) in critical business decisions.
- Participated in the requirement gathering phase of the project. Interviewed system users and business analysts to define/analyze and cleanse source data sources.
- Worked with DBAs and Business Object developers in defining the data mart star schema model and building staging areas to load the multiple data sources. In total 4 source systems are used and that many extract programs were built on the source systems.
- The fact tables and dimension table were defined and created. Wrote ETL programs to extract data sets for fact and hierarchy tables from Enterprise Data warehouse and Mainframe. ETL routines are written in Unix shell script and SQL language to load data into staging areas.
- Four years of historical data was loaded into the data mart with a total size of around half a terabyte. Performed overall system tuning to reduce the batch cycle time and improve report performance.
- Load routines were written to update dimension table and load current fact data into the Fact table. Weekly OPC batch jobs were written and scheduled to load the data-mart every week.
- Supported the production environment for more than 3 years and the entire user base of around 200.
Universe Developer (3 Yrs)
- Worked as a PICK/Universe programmer, developing and maintaining applications.
- Developed several complex applications that included merchant reporting, warehouse system, order entry/maintenance,
- Worked on baseline support on-call rotation supporting the business in compliance with the SDM.
Sr. Operations Analyst (1 Yr)
Worked as a Sr. Ops analyst supporting production in a mainframe environment OS390. Job scheduling, monitoring and reporting were the main responsibilities in this role.
Education
Bachelor's Degree - Business Administration/Commerce - University of Karachi (1991)