SAP BODS, ETL developer
Resume:
Mohammed A Khan
BI Consultant
*********@*****.***
SUMMARY
●12+ years of experience in BI with ability to design and develop complex ETL solutions by translating design requirements into feasible, reusable and scalable technical implementation and also creating reports and dashboards for data visualization.
●Experience Architecting and positioning any combination of products in a best-practice Enterprise Solution.
●Experience working with business users to effectively capture and define BI requirements and turn these into a BI solution design.
●Managed version control of Webi Reports, Data Services Objects and transport objects to different systems in landscape.
● Ensure development and packaging of ETL routines, Error Handling, Restart/Recovery Procedures, and performance tuning based on best practices. Monitored Daily BODI ETL schedules.
●10+ years of experience as SAP BODS, SAP Data migration, HANA,SDI, SQL Server, SAP BI and WEBI, Universe Design IDT, Crystal Reports, Tableau, Power BI
●Worked and have good understanding of various SAP Business Object technologies like Data Services Designer, SAP BI, WEBI, universe design which are used for creating the enterprise DWH and reports.
●Created connection to SAP HANA from SAP BODS repository for data loading.
●Experience creating the reports and dashboard of Tableau using the enterprise DW.
●Experience including analysis, modeling, design, and development of Tableau reports and dashboards for analytics.
●Have good understanding of Guidewire architecture, design, development and end user experience.
●Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader.
●Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
●Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
●Schedule the Web intelligence and Crystal reports through the Business Object CMC.
●Functional Expertise
●Data Extraction, Integration, Modelling
●BI Reporting – Design and Development
●Data Cleansing and transformation
●Domain Expertise
●Retail, Manufacturing
●Pharma and Utility
CERTIFICATION
SAP Certified Application Associate - Data Integration with SAP Data Services 4.x
SAP, License 001*******
Starting November 2015
EXPERIENCE
AMIG (P&C Insurance)
SAP BODS Consultant Jun ’19 – till date
●Extraction of PC/BC/CC data from source system and loading into Oracle.
●Working on the enhancement of the ETL job to reduce the run time.
●Have a good knowledge on the Guidewire architecture (DH and IC).
●Working on the open items created product owner for data issues.
SPXFLOW
SAP BI Consultant Apr ‘16 – May ‘19
Charlotte, NC
Environment:
SAP BODS Version 4.2 SP4, BW 7.3,SQL Server 2014, Power BI Pro.
●Responsibilities:
●Design the flow of data from different sources and consolidate and load in Oracle Hyperion Planning application.
●Created excel template for the flat file entities/customers to submit the sales and bookings data.
●Weekly orders data and Aftermarket sales.
●Worked on Version 4.2 and Support pack4.
●Created Data Warehouse in SQL server before loading into Hyperion Planning application.
●Used stored procedures to call them in the Data Services script to get the list of entities.
●Created the financial reports using tableau for decision making.
●Monitor the data loads at the end of period close and trouble shoot the errors in the jobs and data in Hyperion.
●Load the Bookings and Sales data in Revenue, Finstmt and Reporting cubes in Hyperion planning application.
●Calculate the PLUG (difference between HFM and Planning application) process for all the entities and load the difference.
●Enhancement and change request to existing DI process is done through Service Desk ticketing system.
●Mapping files are posted by the entities in the shared drive and DI process updates the mapping/lookup tables.
Sysco Foods.
SAP BODS, Tableau Consultant Oct ‘14 – Mar ’16
Houston, TX
Environment:
SAP BODS Version 4.1, BW 7.3, DB2 10, Informatica 9, Tableau 8
●Responsibilities:
●Develop the job for HR data to be extracted from BW source and perform table comparison and load into PSA for attribute and text.
●Created the job server to load and balance the BODS server activities.
●Loaded weekly and monthly sales data from different OPCO’s to our SAP BW system.
●Troubleshoot the bugs in the weekly sales job as per the client requirements.
●Perform the data cleansing and validation and loaded into BPC system for budgeting and forecasting.
●Updated the Lookup tables by using the flat file submitted by Business User.
●Monitoring the 10 minute auto load of GL financial data and flat file interface.
●Update the changes in the BODS code as per the client requirements and perform testing and move the code to different environments.
●Created the technical documents for the BODS interface and uploaded to Share point.
Tableau Reporting:
●Involved in creating dashboards by extracting data from different sources in Tableau.
●Created dashboard using parameters, sets, groups and calculations.
●Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
●Involved in creating calculated fields, mapping and hierarchies.
●Involved in creating data blending in case of merging different sources.
●Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
●Created action filters, parameters and calculated sets for preparing dashboards and worksheets using Tableau.
Glenmark Pharmaceutical Jan ‘14 – Aug ‘14
SAP BODS Consultant
New Jersey
●Responsibilities:
●Perform Data analyst in the two current systems namely Glenmark Generics Limited Glenmark Pharmaceutical limited using Data services 4.0
●Created reports from the data base as per the client requirement and used that data to migrate to the new landscape.
●Created different database in SQL server to store and analyze the data using different DI transformations.
●Created functional specs and technical specs as per the business requirement and present it to the client for approval.
●Used SAP Information Steward to parse and standardize the quality of the enterprise data.
●Created the mapping documents so as to transform the data and load in to new SAP landscape.
●Used the different loading techniques like LSMW, direct input and IDOC to load different object depending on the requirement from the client in to the new system.
Saudi Electricity Co. Dec ‘12 – May ‘13
Data Migration Consultant (SAP IS-U)
Dammam, Saudi Arabia
Responsibilities:
●Created the conversion report specification document with the help of functional consultant.
●Discuss different SAP IS-U scenarios with the client and translate it into technical conversion.
●Collected the legacy data files from their IT team.
●Design the SAP BODS jobs to translate the mapping document into source file to load into SAP.
●Created the BODS repository to design the jobs.
●Solved issues when data loading was done in SAP IS-U by EMIGALL
●Data Loading was performed by using EMIGALL tool provided by SAP using the tab delimited file.
●Objects Migrated are: Connection Object, Business Partner, Contract Account, Material Master, MRU, Device Category, Register Group, Payments, Dunning Status etc.
●Analyze the IS-U scenarios and created different lookup’s.
●Maintain the legacy data coming through the flat file in the SQL database.
●Standardize and cleanse the legacy data based on the functional requirement.
●Created data flows and process flow diagrams of the different IS-U scenarios.
Cooper Tires & Rubber Co. Jun ‘11 – Sep ‘12
Data Migration Consultant
Findlay, Ohio
Responsibilities:
Objects Migrated are: Functional Location, Work Center, Task List, Maintenance Plans, Equipment, Equipment Bill of Material, Routing, Material Master, Production version of Material etc.
●Design of architecture to support full-lifecycle development of Data Integrator XI R2.
●Designed, developed and tested SAP BO Data Integrator jobs to extract data from SAP R/3 and BW systems using Batch interface.
●Tested and Validated BODI ETL Jobs.
●Evaluated server sizing requirements for Data Integrator XI R2.
●Wrote custom function and published to the team members to import into the BO Data Services.
●Utilized DI Designer for designing the ETL jobs and scheduled through the job server.
●Designed Information Integration strategy from 15 data sources to load into Oracle Staging Tables.
●data sources included RDBMS, Flat Files and Web Applications.
●Created data flows and process flow diagrams.
●Created Meta Data Repository for the management of business and technical Meta Data.
●Involved in Data Quality analysis, auditing, metrics gathering, ROI analysis, data cleansing and standardizing data.
●Held responsible to finalize any enhancements/new requirements needed for reporting by discussing with business users.
●Created ODBC for the connectivity with different sources such as SQL server, Oracle and Progress Data sources.
●Upgrade the repositories to XI 3.1 from BODI XI R2 and import the ATL file from the repository.
Southern California Edison Los Angeles, CA Sep ‘10 – May '11
SAP Data Quality Analyst
Los Angeles, California
Responsibilities:
●Install the SAP Business Object Data Services Client tools on the local machines.
●Gathered requirements for Data Profiling from the business users.
●Establish connection between SAP Data services and SAP ECC system.
●Design and develop jobs through ABAP data flow that extract data from SAP ECC and load into staging area in Oracle.
●Wrote custom functions to standardize and cleanse the data in Data services.
●Created reports for the profiled data to present it to the data owners.
●Document the differences between the SAP BODS and other third party tool.
●Downloaded and Install the address cleansing package both on the server side and on the client machine for address cleansing.
●Actively involved in the team to resolve the issues related to executing the job.
●Involved in Data Quality analysis, auditing, metrics gathering, ROI analysis, data cleansing and standardizing data.
●Held responsible for presentation to the client and the deliverables.
●Created ODBC for the connectivity with different sources such as SQL server, Oracle and DB2 Data sources.
●Upgrade the repositories to XI 3.1 from BODI XI R2 and import the ATL file from the repository.
●Schedule the jobs through Data Services Management Console, added repository to the console, created profiler user and administer and monitor the job execution.
●Ability to follow program specifications to Write, Test, Debug, Document and Implement jobs including Batch Jobs and Real-Time Jobs using complex transformations. Experience in Performance Optimization & Tuning techniques, Data Quality, Data Profiling and Data Management.
A . O. Smith, Dayton OH Jul ‘09 – Aug'10
SAP BO Developer
Dayton, Ohio
Responsibilities:
●Design of architecture to support full-lifecycle development of Data Integrator XI R2.
●Designed, developed and tested SAP BO Data Integrator jobs to extract data from SAP R/3 and BW systems using Batch interface.
●Tested and Validated BODI ETL Jobs.
●Evaluated server sizing requirements for Data Integrator XI R2.
●Wrote custom function and published to the team members to import into the BO Data Services.
●Utilized DI Designer for designing the ETL jobs and scheduled through the job server.
●Designed Information Integration strategy from 15 data sources to load into Oracle Staging Tables.
●data sources included RDBMS, Flat Files and Web Applications.
●Created data flows and process flow diagrams.
●Created Meta Data Repository for the management of business and technical Meta Data.
●Involved in Data Quality analysis, auditing, metrics gathering, ROI analysis, data cleansing and standardizing data.
●Held responsible to finalize any enhancements/new requirements needed for reporting by discussing with business users.
●Created ODBC for the connectivity with different sources such as SQL server, Oracle and Progress Data sources.
●Upgrade the repositories to XI 3.1 from BODI XI R2 and import the ATL file from the repository.
Scotts Miracle Gro, Sep’08 – May‘09
Business Objects Developer
Marysville, Ohio
Responsibilities:
●Developed Batch jobs to extract data from a variety of data sources, transform the data, and load the data to specified destinations using Data Integrator XI.
●Ability to define database Data Stores and File Formats to allow Data Integrator XI to connect to the source or target database and files.
●Created master and detail report to present the sales distribution
●Ability to design and develop simple and complex transformations in Data Flows
●Experience in cleansing data in DI using proper data types and mappings
●Ability to create Workflows using object library and tool palette to execute data flows.
●Experience in creating and administering the metadata Integrator repository in a multi user environment.
●Experience in publishing batch jobs using Data Integrator Administrator
●Experience in implementation of Recovery Mechanism for unsuccessful batch jobs execution.
●Strong skills with SQL to perform Complex Selects, Updates, Inserts, and Deletes on database tables
●Good understanding of Data Warehousing and SAP Data Migration/Extraction using SAP Business Objects Data Services.
●Wrote custom function and published to the team members to import into the BO Data Services. Scheduled the Data Integrator jobs to accommodate the data changes on timely basis.
●Involved in performance tuning of the DI jobs, which were considerably slow due to schema changes
●Transformed the existing Data Integration Jobs, corresponding to the changing business requirements which include addition, mapping and data type changes to the fields
●Worked on complex reports that require sub-reports, multiple groups and conditional display of sections, fields, and messages
●Developed complex Webi reports with report level context to control numbers according to user’s requirements.
EDUCATION
Master in Computer Sciences and Information Management, NEIU, Chicago, IL.
Bachelors in Computer Sciences, Osmania University, Hyderabad, India.
Contact this candidate