SUMMARY

• Over 10+ years of IT experience as Developer/Technical Lead in Data Warehousing and Business Intelligence projects with excellent hands on experience with SAP BO/BI/BW/DS Technologies.
• Installed & configured Data Services XI 3.2 and Upgraded from Data Services XI 3.2 to 4.0.
• Extensively worked on integration of Business Objects Data Services with SAP MODULES (Finance, HR & CRM) and Non - SAP Data Sources like Oracle 11i/10g/9i, SQL Server 2008/2005/2000 , DB2, JD Edwards Mainframes, Flat Files and Legacy System files.
• BODS/Data Quality in design of work flows, data flows, scripts and complex transforms using different data integrator, platform and data quality transforms.
• Integrated Data Quality objects to BO Information Steward for building rules, metrics and results.
• Expertise in BODS code migration using Check-In/Out of Central/Local Repository.
• Experience in debugging execution errors using Data Integrator logs (trace, monitor, and error) and by examining the target data.
• Extensively used Data Services Management Console to schedule and execute jobs, Manage repositories and perform metadata reporting.
• Expertise in data warehousing techniques for data cleansing, Slowly Changing Dimensions (SCD) phenomenon, surrogate key assignment and Change Data Capture (CDC).
• Involved in design, development, optimization and maintenance of BODS jobs to extract data from various sources to data marts/data warehouse various SAP modules through IDOCS.
• Experience in working with ABAP dataflows to extract the data from SAP Applications.
• Hands on knowledge on Data Quality concepts and familiarity with setting up Data Cleanse, Address Cleanse, Match and Associate transform.
• Expertise in analyzing, designing, creating and maintaining InfoCubes, DSO objects, Remote Cubes, Multi Providers, infosets, Infoobjects, InfoSources, and Extract Structures
• Expertise in Flat file, Generic DataSource, LO Cockpit, and COPA extraction.
• Experience in BW components like Data Sources, Full/Delta upload, Scheduling, Process Chains, Data Mart, Legacy Systems, XML and DB Connect
• Created Info spokes for exporting data to external systems.
• Proficient with Business Objects (BOBJ) WebI, BO-Web I rich, Universe Designer, Live Office, Query as a Web Service, and Xcelsius 2008
• Experience in development of SAP Universes in Designer against SAP BI Cubes and BEx Queries.
• Experience in BOBJ 4.0 integration with BW for reporting WEBI etc.
• Expert in managing System Management Tools like CCM, CMC, Import Wizard and Publishing Wizard.
• Familiarity with Business View Manager and Crystal Reports 2008 and Crystal Report Enterprise.
• Experience in SAP HANA data modeling using attribute view, analytical view and calculation view. Knowledgeable in SEM BPS/BPC.
• Experience in SAP HANA Data provisioning using SAP LT replication server (SLT) and data server.

TECHNICAL SKILLS

ERP: ECC 6.0/5.0,CRM 5.0, ISU, SAP R/3 - 4.6 B, 4.6C, 4.7

Business Warehouse: Nw2004s (BI 7.0/7.3), IP, BPC, SAP BW 7.3/3.5/3.1C/3.0B, SAP BO Data Services.

Languages: ABAP/4, C, SQL

Databases: HANA1.0, DB2, IMS-DB, ORACLE 9i/8i, PLSQL.

Reporting Tools: BEx, Webi, Crystal Reports10, BO/ Xcelsius, BI 4.0

PROFESSIONAL EXPERIENCE

Confidential, Lakeforest, IL

Sr. SAP BODS Developer/Admin/ BI Consultant

Responsibilities:

• Sr. BO Data Services Developer/ Admin for Development on BO/BODS Admin,Data Migration and EDW projects.
• Created Repositories, Users & assigned the security in the Multi-Team Environment.
• Worked in the BODS4.0 Environment, the entire project implementation was on 4.0
• Worked on the IDOC’S, Batch/ real time jobs to extract the data from the SAP/ECC system, and load into the staging data-base for the multiple projects.
• Worked on the BW open Hub tables to extract the data from the BW.
• Customer Master Data Cleansing project using BODS Data Quality Solution by SAP.
• Extracted US and Canada Data for data cleansing using Address directories DQ transforms.
• Integrated Data Quality objects to BO Information Steward for building rules, metrics and results.
• Work with Data Governance, Compliance team, Data Stewards to build governance processes MDM.
• Extracted Data from all the Relational Databases including oracle, Microsoft Sql server and loaded in different environments which include BW, ORACLE, SQL SERVER, and .txt & .CSV files.
• Worked on the DI scripting & prepared a standard Incremental load template which enables the job failure/success notifications.
• Created Global variables to read the files from the shared location from the BODS Designer Also worked on the FTP process to put & get the files on the data-exchange servers.
• Worked on all the standards & guidelines Best practices Documentation, and also the functional & Technical design specification documentation.
• Migrated all the Projects of the team from DEV TO TEST TO PS TO PROD, & scheduled the jobs as part of the Administrator.
• Worked on the Data Quality, Address cleanse transformations for cleansing the data
• Provided the technical guidance & knowledge transfer of effectively using BODS4.0
• Requirements gathering from business users to support the Solution Architecture ETL for EDW.
• Supported the Solution Architect for BODS Technical features to integrate with SAP systems and provide solution to establish the ETL Framework around SAP BODS.
• Defined Data Stores to allow BO Data Services to connect to the source or target database.
• Developed ETL jobs to move data from multiple sources to Enterprise Data Warehouse
• Installed & configured BO Data Services 4.0 in Development & Production Server.
• Implemented use of SAP ABAP dataflows to extract data from SAP Applications ECC, BW etc.
• Developed integration between different systems ( SAP BW, SAP ECC, SQL Server )
• Implemented Delta recovery solution for failed objects like auto-recovery etc.
• Tuned performance for large data files by increasing block size, cache size and implemented performance tuning logic on sources, workflows, data flow’s and target tables using bulk loads etc.
• Responsible for configuration and implementation of Enterprise structures, Organizational Management, Personnel Administration, and Payroll. It's a full cycle SAP BI implementation as a Techno functional team member.
• Designed and implemented numerous accounting systems including applications such as G/L, A/P, A/R, F/A, and Financial Reporting.
• Worked on Cut-over activities and data validations and post. Go-live support.

Environment: SAP BO Data Services 4.0, BW 7.0/7.3,SRM,BI 4.0, BEx, ECC 6.0

Confidential, Dallas, TX

SAP BODS / BI Consultant

Responsibilities:

• Sr. BO Data Services Consultant for SAP Data Migration project.
• Mentoring and co-coordinating with offshore team on business queries, reviewing and guiding on the technical implementation of team at off-shore.
• Troubleshooting BODS connectivity issues with source systems and SAP BAPI integration.
• Extensively worked on AIO (All In One) methodology, SAP preferred Data Migration methodology
• Developed a code migration methodology for SAP BODS across Dev, Test, Prod landscape
• Guide the client team in establishing the dependencies on the data load objects, and preparing project plan with dependencies and cut-over strategy
• Creating a load structure which can feed to SAP- LSMW loads.
• Closely interacted with SAP load team to fix the load errors at ETL end.
• Creating dynamic error report on error data and analysis to provide inputs to business.
• Created reusable BODS code components to load data from legacy source to SAP ECC.
• Created temples for loading data to SAP-LSMW and held tight integration for AIO BAPI objects
• Managing development team to adhere to project schedule and optimize the resources for quick turnaround on bugs and testing.
• Analyzed the session, event and error logs for trouble shooting mapping sessions.
• Created test cases for carrying out unit testing and part of functional testing.
• Worked with Variables and Parameters in the mappings to pass the values between sessions
• Responsible for documentation, version controlling of schema and version releasing.
• Prepared Data Migration cut-over plans, mock data loads, performance improvement initiatives
• Actively participated in the blueprint phase of project regarding the architecture phase.
• Implemented BO Data Quality Solution Customer address cleansing on SAP CRM and SAP ECC
• Developed, published, and scheduled batch and real-time jobs.
• Responsible for the development of strategic documents including the technical specs.
• Installation and configuration of Business Objects Enterprise and Data Services 3.2, including Data Quality.
• Creation, improvement, and documentation of HCM reports and related universe, including standardization and applying best practices.
• Designed the mapping templates for data extraction and loading and supported ETL developers
• Designed and implemented Plant maintenance Cubes (0PM C03 Maintenance Orders), DSO, Data Sources (2LIS 17 ORDER) in SAP BI data flow.

Environment: SAP R/3 4.6c, SAP ECC 6.0, SAP BI 7.0/7.3, SAP CRM SAP BODS 3.2

Confidential, Houston, TX

SAP BI Consultant

Responsibilities:

• Prepared the Road map of SAP BI and IP.
• Created Aggregation levels, Data slices, Planning Functions, Planning Sequences, Filters and variables.
• Created POSDM DSOs and Inventory Stock and Movements Cubes for Retail Implementation.
• Created reusable structures, Restricted Key Figures, Formulas and BEx Reports and published in Web for Good Year Daily Sales, Preventive Maintenance, Service Sales, Daily Feed, Consumer Tire Retail report for different brands Good Year/Dunlop/Kelly Tires
• Created Extractors for Site Master and Article Master Data Loads.
• Created cubes for Operating Statement, AOP and FI-GL and Gross Margin.
• Created Write-Optimized DSOs for PODM Data, Inventory data and Gross Margin.
• Created Stock and Movements cubes and Valuations DSO and data loaded using no marker update.
• Activated datasources 2LIS 02 BX, 2LIS 02 BF and 2LIS 02 UM and worked on Stock Initialization, Movements, and Revaluations extractions and worked on Marker Update.
• Created Billing Documents, Billing Conditions DSOs and Infocubes.
• Created reports for Daily Sales Analyzer, Car Count, and Gross Margin Daily Tracker.
• Daily data loads support for Sales and Gross Margin with flat file source data.
• Created Process chains and worked on automation with File trigger event and used Autosys for Load process.
• Created Outbound feeds for Bonus Calculations, Sales Tax, and Car count for SMG( third party vendor). Created Multiproviders and all reports are based out of MPs and are published in portals.
• Worked on Cut-over activities and data validations and business to sign off.
• Created APD (Analysis Process Designer) for outbound feeds.

Environment: BI 7.0/ Flat Files, BEx, WAD, ECC 6.0, Portals

Confidential, IL

Senior SAP BI Consultant

Responsibilities:

• Monitoring Chains on Daily Weekly, Monthly.
• Loading Master data, Transaction data into the SAP BW on daily basis.
• Handling the tickets raised by the market.
• Worked in BW 3.5 to 7.0 upgrade project
• Involved in report migration from BW 3.5 reports to BI 7.0
• Analyze the errors in the data loads.
• Using Lo cockpit configured and maintained MM data sources.
• Uploading Master and Transactional data from Flat files and SAP as the OLTP sources, worked extensively on Administration workbench.
• Installed Business content as and when required.
• Involved in Creation of reports using BEx Analyzer such that the execution time is evenly distributed through the report by using Free Characteristics, Restricted Key figures, calculated key figures, Variables and Exceptions.

Environment: BW 7.0, CRM 5.0, ECC 6.0, WAD

Confidential

Senior SAP BW/BI Consultant

Responsibilities:

• Involved in the upgrade from BW 3.5 to BI 7.0 and tested the configuration of all objects in BI system.
• Created Transformations and Data Transfer Process(DTP) in BI 7.0 for PCA and HR cubes
• Created Info Cubes, Info Sources, Transfer structures, Transfer rules, and Communication structures, Update Rules and Process Chains and Aggregates.
• Data Load Monitoring and fixing the load problems in Master Data and Transaction Data for PCA, HR, Shipments, Inventory Management, Asset Accounting, Material Ledger, AR, AP, COPA, BPS, and APO Demand Planning(DP) and Supply Planning Network(SNP) and Product Costing and Service Orders and Notifications cubes.
• Extensively Used Process chains and all jobs are controlled by a UC4 scheduler.
• Data load problem resolution using Remedy trouble ticketing system.
• Performance tuning using Aggregates, Compression, Query tuning using RSRT, RSDDSTAT.
• Created Data Transfer Processes (DTP) and used in process chains.
• Enhancements to the existing Product Costing Cube.
• Crystal Enterprise folder maintenance using Management Console

Environment: SAP BW 3.5, /7.0 R/3 ECC5.0 (MM, SD, FI-CO), SEM 4.0, BEx Analyzer, WAD

Confidential

SAP BW Consultant

Responsibilities:

• Managed the Project team, assigned work and metrics reported to Client.
• Communicated Weekly status updates to client with the tasks analysis, scope and risks if any.
• Discussions with VP on SOW and scope of the project.
• Completed the feasibility study of the current business process functional specifications and identified the relevant areas for customizations.
• Involved in upgradation of BI from BW 3.1C to BW 3.5.
• Tested the System Configuration Settings for all Objects in BW 3.5 System
• Implementation of BW PCA for UPI (Universal Pictures International, UK) with 0EC PCA 1 DataSource.
• Regression Testing of Project Juice (PeopleSoft to SAP Migration) BW.
• Created InfoCubes, InfoSources, Multi-Providers, Transfer structures, Transfer rules, Communication structures, Update Rules.
• Implemented Deltas for PCA and FI-SL by applying OSS Notes to R/3 4.6c which does not support Deltas.
• Scheduled and monitoring of data loads from R/3 during Quarter close activities for CCA, FI-GL and PCA and SPL cubes.
• Extensively worked on Process Chains, created Daily Monitoring chains using RSPCM of Financial Data Loads for PCA, CCA, FI-SL and FI-GL.
• Worked on Master Data Attributes and Hierarchies for Profit Center, Account, and Company Code data.
• Transported BW objects from Development to QA for testing using Lotus Notes MDM process and created Kintana CCP ticketing to move transports to BW Production (Change Management Process).
• Performed various tuning techniques (aggregates, statistics and Query Cache) to optimize the query performance.
• Developed flexible queries on MultiProviders using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Created Views and Web Templates for PCA Work Books by using WAD.

Environment: SAP BW 3.5/3.1C, BI 7.0, R/3 4.6C (FI-CO, SD, MM), SEM 4.0

Confidential

SAP BW Consultant

Responsibilities:

• Involved in the upgrade from BW 3.5 to BI 7.0 and tested the configuration of all objects in BI system.
• Created Transformations and Data Transfer Process(DTP) in BI 7.0 for PCA and HR cubes
• Created Info Cubes, Info Sources, Transfer structures, Transfer rules, and Communication structures, Update Rules and Process Chains and Aggregates.
• Data Load Monitoring and fixing the load problems in Master Data and Transaction Data for PCA, HR, Shipments, Inventory Management, Asset Accounting, Material Ledger, AR, AP, COPA, BPS, and APO Demand Planning(DP) and Supply Planning Network(SNP) and Product Costing and Service Orders and Notifications cubes.
• Extensively Used Process chains and all jobs are controlled by a UC4 scheduler.
• Data load problem resolution using Remedy trouble ticketing system.
• Performance tuning using Aggregates, Compression, Query tuning using RSRT, RSDDSTAT.
• Created Data Transfer Processes (DTP) and used in process chains.
• Enhancements to the existing Product Costing Cube.
• Crystal Enterprise folder maintenance using Management Console