Professional Summary:

Certified Application Associate in SAP BI with 7+ years of SAP experience in BODS, BW, BOBJ, and ABAP.

BODS/BOBJ Experience:

Hands on experience in Data Services Designer, which includes creation and execution of Jobs, Work flows, Data flows, Data stores.

Having experience using SAP ECC and Legacy systems as Source, Staging the data and loading into target system using SAP Business Objects Data Services.

Experience in platform transformations which consists of case, merge, row generation, validation, SQL and various query transforms using different functions. Also experienced on integrator transforms like table comparison, key generation and history preservation.

Handled various Look-up functions, custom functions and scripts.

Experience in SAP interface like FIM tool which can be used to maintain master data look ups.

Knowledge in creating Local Repository as well as Central Repository.

Experience in migrating the objects across Landscapes.

Experience in moving the objects from Development, Quality and Production systems.

Experience in SAP Business objects (4.0/3.x) and BOBJ products like Web Intelligence, Xcelsius, and Universes.

Good knowledge in Data Services Management Console which includes Scheduling the Jobs based on the Business requirements, Auto Documentation also Data Validation.

Experience in creating Universes with Measures and Dimensions, Filters, List of Values (LOV’s) using, Universe Design Tool and Information Design Tool. Defined Cardinalities, Contexts, Joins and Aliases.

Created Users and Groups and setting the rights on them using Central Management Console (CMC). Scheduled Crystal reports in CMC on Daily, Weekly, Monthly basis.

Hands on experience in BI Launch pad and extensively worked with major functionality of BO like Breaks, Sections, Group values, Sorts Pre-defined conditions, Calculations and Ranking, Standard reports and Cross tab reports.

Developed WebI reports, Ad-hoc reports and Graphical representation of reports such as Bar charts, Pie Charts, 3D Charts providing the End user training for the same.

Created reports from multiple sources and functionalities like slice & dice, drill down in Crystal Reports.

Dashboard design – Knowledge in Dashboards reports.

BW Experience:

Expertise in gathering requirements, understanding, analysis, and implementation on Business Intelligence platform using SAP ASAP methodology.

Excellent working knowledge of Data warehouse concepts and extensive experience in BW Architecture, Extended Star schema, Multi-dimensional modeling, Data flow strategy, Info cube, DSO, Multi provider, Info sets, Info source, Data source, Info objects, PSA.

Experience in BI 7.0, which includes ETL Process, including Transformations and Data Transfer Process (DTP), Real Time Data Acquisition.

Experience in SAP functional modules which includes SD(Order To Cash, Reverse Logistics, Credit/Debit memo), MM(Procure to Pay), PP(Make to Order, Make to Stock), IM(Goods Issue/ Goods Receipt), and FI-AP,FI- AR, CO-COPA(Controlling and Profitability Analysis)

Experience in Back end components, which involved OLTP Extraction from SAP R/3 into BW using different extraction structures such as Logistics Cockpit, FI and Generic Extractors along with Flat file extraction of data from third party systems using methodologies like DB Connect, XML uploads and carried out transports to staging and production environments.

Configuration and administration of Info spokes for external DW systems.

Experience in writing routines which includes Start routine and End routine.

Expertise in Bex Query designer, Analyzer, Web Application designer.

Proficient in creating complex queries which includes Free characteristics, RKF, CKF, Variables, Exceptions, Conditions, Formulas, Selections and RRI, Cell editor.

Experience in Publishing the Bex reports in Net weaver Portal through Information Broadcasting.

Experience in creating user Roles and Authorizations for report users.

Expertise in BW performance tuning activities like maintaining Aggregates, Roll up, Compression, Partition, Process chains, Indexing of Info cubes and use the statistics for the same.

Experience in BWA and creation of BWA Indexes for BW Queries and Reports.

Involved in Production support, Scheduling Start process and Process chains of Events, Data mart and Open hub services, fixing errors and daily ETL Data load (Full/Delta upload). Monitoring of the BW jobs and designed process chains for Daily, Weekly, and Monthly data loads.

Created Prototype for Sales Planning model in Business Planning and Simulation (BPS).

Knowledge in Data mining models like Decision Tree, ABC Analysis, Scoring and Clustering.

Technical Skills:

ERP : SAP R/3 4.6C, 4.7, ECC 5.0 and ECC 6.0

Data Warehousing : SAP BW 3.1C, SAP BW 3.5, SAP BI 7.x

Business Objects : Business objects 4.x, 3.x, Business Objects Data Services (BODS), Crystal

Report 9/10, Dash board reports

4.5/2008, CMC, CMS, BI Launch Pad, Web Intelligence

Languages : ABAP/4, Java, C, C++, PL/SQL

SAP Net weaver : Enterprise Portal 6, Visual Composer 7.0, ALE/IDOC, User exits

Operating systems : Win NT, Windows 2000, XP, Linux

Database systems : Oracle 8i/9i, DB2, SQL Server 2005/2008, MySQL, and MS Access

Others : MS Office, HTML

Certification:

Certified SAP “Application Associate–Business Intelligence with SAP Netweaver 7.0”

Educational Qualification:

Master’s Degree in Mobile Telecommunications and High speed Networks, Oxford Brookes

University, UK

Bachelor’s Degree in Computer Science and Engineering from Madras University, Chennai, India.

Client : Coca cola Refreshments, Atlanta Feb 2015- Current

Roles : SAP BW/BODS Consultant

Environment: ECC 6.0, Data Services XI 4.0, SQL Server Management studio

2008, TD, SAP BI

Experience in Financial Data Warehousing/BPC system which extracts data from various Sources which includes SAP ECC, Teradata, Oracle, SAP BI, PLUS, Flat file and loading into SAP BI and SQL server as Target systems.

Responsible for enhancing Master data as well as Transaction data for all interfaces plus new developments.

Experience in maintaining offshore team – interacting with the team by passing the Functional requirements, validate the code, present it to Architecture team and update the weekly status.

Working as a Lead for yearly loads also troubleshooting in case of Job failures and reprocess the error records.

Involved in Data reconciliation process in order to match record count between Source Vs Staging Vs Target and communicate the same to BI team as well as Business team.

Responsible for Unit testing, Integration testing, assisted UAT and resolved the issues to ensure the solutions to meet business requirements.

Client : KO, Atlanta Nov 2014 – Jan 2015

Roles : Lead SAP BW/BODS Consultant

Environment: ECC 6.0, Data Services XI 4.0, SQL Server Management studio

2008, TD, SAP BI, Oracle

Prepared Technical Documentation for various Interface jobs which includes BOFC, BPC, FIM

These jobs were developed by other team – Worked as a Lead for this effort, interacting with Offshore team by allocation jobs to them, validate TSD’s created by them before submitting to Business user and provided the status update for the same.

Client : Coca cola Refreshments, Atlanta May 2014 – Current

Roles : SAP BW/BODS Consultant

Environment: ECC 6.0, Data Services XI 4.0, SQL Server Management studio

2008, Teradata, ASCORE/BASIS

Customer Master Harmonization- which is part of Master Data Management which extracts data from SAP ECC, Teradata and ASCORE worked as a core developer for all these extracts.

Responsible for extracting data from SAP ECC source, which includes KNA1, KNB1 (Complex Transformations M-N), KNVV, ADRC and Ztables, also applied complex Transformations for KNB1 table.

Responsible extracting Full/Delta load data from ASCORE/BASIS boxes and loading into SQL server for Harmonization.

Responsible for extracting Full load data from Teradata and loading into SQL server for synchronizing all master data.

Client : Coca cola Refreshments, Atlanta May 2014 – Oct 2014

Roles : SAP BW/BODS Consultant

Environment : SQL server 2008, Data Services XI 4.0, Teradata

CMASigned Interface is developed to collect all the Agreements signed by Customers from SQL server source and loading into Teradata Target tables.

Offered CMA also a new interface developed to extract Offers which is coming from SAP CRM as Source (Custom IDOC) and loading into Teradata target tables.

Translate FSD’s into TSD’s and follow the SDLC process.

Responsible for Unit testing and QA testing, and part of UAT testing.

Client : Coca cola Refreshments, Atlanta Apr 2013 –May 2013

Roles : SAP BW/BODS Consultant

Environment: SQL server 2008, Data Services XI 4.0, Teradata

•UFP (Uniform Forecast Process) data will be uploaded daily in the Segmentation data base on a daily basis. This data is used for Segmentation efforts around AOL store to define AOL store Universe by allowing the identification of UFP outlets for inclusion in the population of AOL store outlets.

•Developed DS Interface for the above requirement, which extracts data from SQL server and loading into Teradata segmentation tables.

•Applied the mapping rules and Transformations in order to run the Full load schedule.

Client : Coca cola Refreshments, Atlanta Mar 2014-Apr 2014

Roles : SAP BW/BODS Consultant

Environment : SAP CRM, Data Services XI 4.0,Teradata

•Extracted Header, Item, Text data from SAP CRM source using ABAP dataflow, applied the business rules for Transformations and loaded into Teradata Target system.

•Responsible for development, created Test cases for Unit testing, responsible for Archiving,

•Created scripts for deletion of source data once its extracted and loaded into Teradata. Supported the Production support until warranty period.

Client : Coca cola Refreshments, Atlanta Jan 2013- Mar 2013

Roles : SAP BW/BODS Consultant

Environment : XML, Data Services XI 4.0,Teradata

•Involved in extracting data using XML as a source system, using Transformations to load the data into Teradata for Surveys and Responses entered in the third party system for different Segmentation channels.

•Responsible for developing the file transfer through FTP connection, also archiving the files once it is loaded into Teradata system.

•Involved in creating Unit testing documents in Development and Quality systems, also part of UAT. Also provided support for the above system.

Client : Coca cola Refreshments, Atlanta Jan 2013- Mar 2013

Roles : SAP BW/BODS Consultant

Environment : SAP CRM, Data Services XI 4.0,Tera data

•Involved in extracting data from SAP CRM using ABAP data flow, using Data services to load the data into Teradata.

•Responsible for development, and deploy the same in QA and Production.

•Involved in moving the DS generated ABAP code across system landscape, because of Execute and Preload setting of a Data store.

Client : CONA, Atlanta Oct 2013- Dec2013

Roles : SAP BW/BODS Consultant

Environment: ECC 6.0, Data Services XI 4.0, SQL Server Management studio 2008

•Responsible for Extracting Material master data from SAP ECC as Source, and apply Transformation rules as per FSD and loading into Target as Flat file.

•Responsible for Translating FSD into Technical spec and get the approval from Architecture review team, design the code.

•Responsible for Unit testing in Dev also translate these test cases into HPQC and responsible for QA testing.

•Migrated the objects across Landscapes.

• Used FIM as a User Interface tool for Master data lookup.

Client : Storage Solutions, Southborough Dec 2010 – Dec 2011

Role : SAP BW BOBJ/BODS Consultant

Environment: ECC 6.0, SAP BI 7.x, SD/MM, BO 4.0, Data Services XI 4.0, SQL Server

2008

Responsibilities:

SAP BOBJ/BODS:

Experience in defining the Source system as Flat file layouts, data types and naming conventions in order to transfer the data into MS SQL Server, as well as SAP BW as a target systems.

Experience in extracting the data from MS SQL Server as a Source system, loading the data into SAP ECC is the Target system based on IDOC mapping to transfer the data.

Worked on Vendor Master, Customer master IDOCS: CREMAS, DEBMAS

Experience in extracting data from Legacy systems into SAP BW using Data Services.

Created mappings using the Data Services Designer, designed Workflows, Data flows, Data stores.

Created Local and Central repositories based on the business requirements using Data Services Management Console.

Utilized the Transformations like Query Transform, Case, Merge, Validation, Look up, Key Generation, Map operations, Table comparison to map the data from Source system into Target system.

Worked with tables involving Hierarchies, resolved them using Hierarchy flattening based on the business requirements

Developing and modifying the changes in data flows, scheduling and execution of Jobs, debugging the errors using Trace function.

Responsible for Unit testing and Integration testing.

Experience in creating, organizing, publishing and scheduling reports using Central Management Console.

Created WebI reports for Sales overview and Material Movements Analyses using the functionalities Sections, Breaks, Prompts, Formulas and Functions, displayed the same using the Graphical view.

Created Dashboard reports(What if Analysis) for Forecasting the future Sales Revenues based on the Data warehousing data

Experience in Data validation, Data cleansing, Data mappings, Data Transformations includes for both SAP Master data and Transaction data.

Worked with legacy application SMEs to extract transform and load data into SAP also Legacy applications.

Responsibilities:

SAP BW:

Involved in gathering business requirements and deliverables for reporting requirements along with functional end users in the business area. Based on the analysis finalized the Extractors for Sales order, Delivery, Shipment and Purchasing.

Configured and extracted data using LO cockpit Extractors for Sales Order, Delivery, Shipment and Purchasing.

Created Generic Extractor based on Function module to capture the Tracking number which is coming from MES system.

Enhanced the data sources for Master data as well as Transaction data for Delivery Extractors and Shipment extractors.

Created Data Store Objects (DSO) and Info cubes also Transformations to integrate different data streams from Sales order, Delivery and Purchasing Data sources.

Created Multi providers based on Sales Overview cube and Delivery cube.

Created Start routines in Transformations to calculate the sales revenue, and delete the data records for the sales revenue value is equal to zero as per the business needs.

Created End routines to distribute the incoming sales figures by the employees belong to the sales organization.

Involved in review of various objects and created test cases and test plans in different environments.

Involved in Query Performance tuning activities, thus includes creating Aggregates, Indexing, Line item dimension, OLAP Cache to improve the response time.

Created Custom reports on Sales Info cubes, and Purchasing Info cubes, Inventory Info cubes using the Query Designer features including Formulas, Conditions and Exceptions, format those reports using Crystal reports.

Used Customer exits for complex reporting scenarios, worked on Report to Report Interface to get the detailed level of reporting.

Client: Morrison Homes, Atlanta Feb 2009 – Nov 2010

Role : SAP BW BOBJ Consultant

Environment: SAP ECC 5.0, SAP BW 3.5, SD, FI-AR, FI-AP, COPA

Responsibilities:

Analyzed Business requirements and translated these requirements into dimensional data models using Extended star schema data modeling technique also involved in preparing the GAP analysis report.

Worked on Sales Order extractors, Delivery Extractors, Billing Extractors, Procurement extractors based on LO cockpit, also worked on FI-AR extractors and FI-AP extractors.

Enhanced the FI-GL extractor Line items to include Document header text, populated the Extract structure with Master data Text enhancement

Worked on Billing extractor data source enhancement, to add the Custom field called Posting status based on the Business requirements.

Extensively worked on Administrator workbench for modeling the Info objects, Info providers like Info cubes, ODS, Multi providers.

Designed and developed ODS objects to load Sales order Header and Item level data, defined Update rules.

Loaded Transactional data into PSA and updated the data from PSA to ODS, Activated the ODS contents to make data available in Info cube for reporting.

Activated and loaded Master data Info objects, Transactional data, for both Full update and Delta update for Sales orders, Billing and Procurement data sources.

Created Transfer Routine to eliminate duplicate records and Update routine to handle the Unit of Measure conversion.

Created Info sources for Master data and Transactional data, assigned these to Data sources, Schedule the Info packages for data extraction.

Experience in creating Info sets and Multi providers.

Involved in the Production support activities which include Data Monitoring, Data validation, for periodic loads from SAP R/3 to BW as per the checklist, Updating the client about the Success/Failure of the data loads, Enhancing/ modifying a report based on business requirement, and Fine tuning.

Created Process Chains for Daily / Weekly Loads for Sales and Distribution (SD), Finance areas involve General Ledger, Accounts Payable, and Accounts Receivable.

Extracted the data from BW using Open Hub service(Info Spokes) for both Master data and Transactional data, Validating the data against BW, submitted the results back to the client. Successfully completed and implemented the same for the above.

Involved in Query validation, Testing and Reporting back to the corresponding areas.

Modified the existing data loads and redesigned the corresponding BEx reports. Involved in performance tuning activities to improve the Query response time which includes creating Aggregates, Line Item Dimension, and OLAP Cache.

Created Custom reports from Sales Overview Cube, Accounts Receivable cube.

Created Variables using Customer Exit, wrote ABAP code to calculate YTD and MTD, populated the values for the same.

Created User training documents, conducted sessions for the same.

Worked on Authorizations, creating Roles, assigning the Roles to End Users.

Distributed the Reports on weekly basis using Information broadcaster.

Interacting with Business analysts for creating Complex Queries, using Advanced Query features.

Client : Home Depot Jun 2007– Dec 2008

Role : SAP BW Consultant

Environment: SAP BW 3.5, FI, SD

Responsibilities:

Understanding the Business of the Home Depot for Enterprise Finance Module.

Extensively involved in Production support by monitoring Daily/Weekly/Monthly data loads into BW system, Data validation for Periodic loads from SAP R/3 to BW as per the checklist, updating the client about the Success/Failure of the data loads.

Worked as an Offshore Coordinator role which involves, interacting with Business and offshore team, fixing the errors, updating the Status of the Loads on weekly basis.

Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.

Created Info packages for populating Info providers by executing Info packages using both update methods (Full update method and Initialization of Delta method).

Performed Data load monitoring and failed data packets were analyzed and if possible manually maintaining work history for all the tickets until it is closed.

Worked on Reconciliation to verify the data in SAP R/3 and SAP BW system.

Implemented various performance tuning activities, including Creation of Secondary Indexes, Aggregates, Partitioning and Compression.

Interacting with Business analysts for Queries, created reports based on the Business requirements.

Solving the tickets raised by Business users pertaining to the Reports, based on the priority.

Involved in Query validation & testing and reporting back to the corresponding areas.

Done Value Addition for Process chains with reference to OSS notes.

Involved in Master Data restructuring, so that Text, Attribute and hierarchy loads can be done in parallel with all the loads, so it improves the loading performance.

Extensively worked on Administrator Workbench for Modeling the Info objects, Info cubes, ODS and Multi provider.

Activated and loaded Master data Info objects for both Initial and Delta load.

Worked on BEx analyzer/browser, portal reporting. Developed flexible queries using filters, navigational attributes in BEX analyzer to facilitate data analysis in a summarized way to give detailed level of information.

Created Custom reports for Accounts Payable and Accounts Receivable based on User requirements.

Created custom reports on Sales Analysis, Vendor Analysis, Open Invoice and Material purchased Daily Sales Activity reports which runs as a background job and designed a report for Rejected materials.

Developed Crystal reports for Sales data based on Customer, Material and Product.

Client : JKTechnosoft, Bangalore Jan 2007 to May 2007

Role : Trainee, Developer

Environment: SAP R/3 4.6C

Responsibilities:

Developed Batch input program for uploading material master mater data into SAP.

Designed and created a mapping document and defined rules for each field, before moving data from legacy to SAP.

Using LSMW (batch input session) method, uploaded Customer Master records.

Developed BDC program for the Resell Contract.

Developed Upload program for supplier email addresses from the excel files.

Developed Rework request form and Vin/Scrap form using SAP script.

Developed Complaint Report Form and Label Printing (QM tag for Rejected Parts)

Included Barcode printing in the forms.

Converted ‘Complaint Report’ into PDF file so that it can be sent as an attachment in email to vendors.

Migrated standard purchase order, invoice into SMARTFORMS and written print programs for the same.

Involved in performance analysis of various ABAP/4 programs.

Contact this candidate