SUMMARY

• Over 8 years of experience in Design, Development, Implementation, Production Support for Business Applications in SAP Business Intelligence/Warehouse (BI 7.X/3.X) with SAP R/3 (4.X/ECC 6.0) and SAP BO 4.0, 4.1 and over One year of SAP HANA
• Worked on 3 full life cycle implementation projects starting from Requirement
• Extensive experience in Modeling, Data Extraction/Loading (ETL), Reporting, SAP Business Explorer Suite, SAP Business Object Analysis Suite, Analysis Process Designer (APD), Information Broadcasting
• Highly experienced in upgrade of SAP BW Application from BI 3.5 to BI 7.x
• Expertise in working with Solution Manager and Transport Management System
• Extensive experience in Modeling, Data Extraction/Loading (ETL), Reporting, SAP Business Explorer Suite, SAP Business Object Analysis Suite, Analysis Process Designer (APD), Information Broadcasting
• Good understanding of SAP methodology, all the way from Business Blueprinting, Realization, Go - live & Cut over, post implementation support & Training..
• Full cycle implementation and creation of Infocubes, DSO, Multiproviders, Infoareas, Delta loads and BEX reporting.
• Lead the definition, design and development of the Account Planning architecture and associated business warehouse information model.
• Development of BPS planning applications - Planning Areas, Levels, Layouts, Functions, Variables, Planning Sequences.
• Created Planning Folder with planning functions in UPSPM, worked with EXIT function in Planning Application.
• Extensively worked on designing/creating InfoObjects, InfoCubes, ODS/DSO Objects, InfoSets, Multiproviders, DTP, Transformations, Data Sources, InfoPacakage, InfoSources, Transfer Structures, Communication Structures, Process Chains, Transfer Rules, Update Rules, BEx Analyzer, Views, Work Books
• Designed and maintained complex Business Objects Universes
• Hands on Experience withSAP Business Objects Explorer (BEx), Business Objects Design Studio
• Developed specs for multiple Business Objects reports, enhancements to transactions, user exits, and enhanced standard SAP Reports.
• Experience in SAP HANA data modeling using Attribute View, Analytical View and Calculation View.
• Experience in SAP HANA Data provisioning using SAP LT Replication Server and Data Services.
• Worked on various kinds of Performance Tuning techniques such as Aggregates, Rollups, Indexes, Partitions and Info-Cube Compression techniques.
• Created interactive dashboards using Xcelsius.
• Built Transactional cubes in BW for Planning and Basic cubes for actual data. Enhancements for extraction of data, creating some custom info Objects, calculated key figures, custom transfer and update rules. Built Query / Structure with Bex Analyzer with Calculated key figures using various filters & restrictions for SEM use.
• Development of Planning Hierarchy in SEM-BPS, Hierarchy Attributes in BW, Characteristic Relationships in BI-IP Worked on realignment of Characteristics across Hierarchies.
• Development of Planning functions, Parameter Groups: (formula, Copy, Repost, Revaluate, Currency Translation, Distribution, Allocation etc). Used the Fox converter to build formulae.
• Development of Planning Sequences and Macros for Excel Layouts, variables in planning functions
• Development of Planning areas, Multi-planning areas for Actual and various planning versions, Planning Levels, Planning Packages, Planning Folders.

TECHNICAL SKILLS

ERP: SAP R/3, SAP ECC 5.0/6.0,SAP BOBJ XI 3.1, 4.0, Xcelsius 2008, 2011 Web Intelligence

BW: BW 3.5, 7.0 BEx Explorer, SAP BI 7.0, BW/BOBJ, HANA 1.0 SP5

Reporting: WEBI, Crystal Reports, WAD, BEx Query Designer, Analyzer, Dashboard, Lumira

SAP Function Modules: SD, PP, MM, CRM, SCM, CO-PA, HR, FICO

Operating System: Win 98, 2000, NT, XPLanguages Java, SQL, VB.net, ABAP|4, PL|SQL

Back End: MS-ACCESS 2000

PROFESSIONAL EXPERIENCE

Confidential, Detroit Michigan

SAP Business Object| BODS Developer

Responsibilities:

• Responsible for design & develop solutions using SAP BODS for Data Migration jobs.
• Responsible in administrative activities like Repository Configuration, Job Server configuration, Central Repository configuration, Job Scheduling, Monitoring.
• Actively worked on Data services Management Console, CMC.
• Designed and developed simple and complex transformations in Data Flows.
• Experience in implementation of Recovery Mechanism for unsuccessful batch jobs execution.
• Created Custom functions to make the code reusable.
• Proficiently applied Change data capture methods depends on the business requirements.
• Worked on the onsite/offshore model and managed a team of three offshore consultants.
• Worked on the Tax Project to replicate a SAP report in BW combining data from Finance and Sales, getting COST value from the SD flow
• Wrote end routines, field routines to remove invalid characters, start routines to lookup data from different DSOs to get COST values, document types, serial numbers and other fields.
• Created BODS jobs, workflows to link the SAP OpenHub Table output, editing certain fields, before putting the extract file on a shared folder.
• Worked on enhancements on purchasing extractors 2lis 02 itm, SD extractors, 2lis 11 vaitm
• Created a generic extractor on VEKP/VEPO for handling, information, extracted data over to the BW side
• Enhanced Shipping extractor 2lis 12 vcitm for delivery information
• Worked on hierarchies for entity target label. Created jobs in BODS to bring data over from DRM module to BW to load the entity hierarchy
• Worked on automation of data loads via Process Chains, setup a schedule for running daily/ weekly/ monthly.
• Built reports in BEx query designer on purchasing data based on EKKO/EKPO join, BSIK (accounting secondary vendor information), Handling VEKP/VEPO join, LIKP/LIPS join (delivery information)
• Extensively worked on Performance Tuning of the jobs.
• Extensively used Try/Catch to handle exceptions and writing Scripting to automate the Job Process.
• Did a POC on Spotfire integration with BW, another POC to establish baselines for query performance comparing, Oracle on IBM/AIX and Oracle on Exxadata.
• Involved in requirement gathering and complete design of DS jobs
• Designed and developed Data Services jobs to bring over tables in to Oracle.
• Optimized Data Services jobs for better performance in terms of processing times
• Developed and Loaded Fact Tables and Dimension Tables for PFR reporting based on business and reporting requirements
• Created Scripts like starting script and ending script for each job and declaring the variables local and Global Variables.
• Involved in High Level design(ICD), Low level Design(FD), Unit Test Case and Integration Test case Preparation, Performance, and improvement of BODS
• Involved in Migration of Jobs and workflows from Development to Test and to Production Servers
• Extensively worked on development of mappings and worked with BODSTransformations like Reverse Pivot, Map Operation, Table Comparison, Effective Date, History Preserving, Row Generation, Key Generation, Query, Case, Merge, Validation, and Pivot Etc.
• Involved in Data Profiling/ validation and address cleansing transformations by using Data Quality.
• Involved in administrative tasks like local/central Repository configuration, Job Scheduling, Monitoring.
• Created Data stores for Source, staging area and target systems.
• Worked on debugging execution errors using Data Services logs (trace, statistics and error) and by examining the target data.
• Involved in scheduling and running Batch jobs on time at Data services Management Console.
• Participated in JAD sessions with Application team to fix the data issues.
• Worked on CR's (Change Request) Issues and resolved them in an estimated time period.
• Create views in the staging area using source system which will be used as source in the Data Services.

Confidential, Houston Texas

SAP BW|BO Consultant

Environment: SAP BW| Business Objects 4.0

Responsibilities:

• Interacted with functional team, development team and end users of Finance, Order to Cash, and Procure to pay departments, to study their business process.
• Designed and built BEx Analyzer finance reports using variables, structures, conditions, exceptions, filters and aggregates for performance tuning of queries.
• Provided pilot training to finance functional team and performed unit testing.
• Created training materials with topics including using BEx web and analyzer reports and their data analysis tools such as OLAP functions, filters, variables, how to create reports using structures etc.
• Worked on scheduling reports using Information Broadcasting to export reports in form of excel and pdf files.
• Involved in Data Modeling, Data Extraction, Data Loading (Full/Delta Upload),Scheduling and Monitoring
• Worked with the business, share point team to make changes to the queries to resolve timeout issues.
• Created universes and test environments for Business Objects and tested user permissions
• Involved in the migration of BEx Queries to BO Reports and Developed BEx customer exit variables for FICO Reports.
• Created Xcelsius dashboards using different chart types and tables
• Created dashboard designs with the Dynamic visibility for interactive functionality
• Resolved Universe problems such as loops and traps using alias and context.
• Extensively created reports in WebI, implemented drill down features and created reports including horizontal table, vertical tables, forms and charts
• Involved in solving high-prioritized tickets regarding extractions and load failures.
• Analyzed the errors that occurred during the data loading and solved the issues for that occurred during the activation process of the objects.
• Designed and developed Process chains (RSPC) for master data loads and transaction data loads with the help of Info Packages. And these Process chains were scheduled for periodic loads.
• Worked on the performance tuning the queries by maintaining aggregates, indexes and compression on Info cubes.
• Involved in gathering requirements from user, creating Functional specs, Technical specs, Test plans, and end user training.
• Extensively worked on BEx Query Designer in designing many queries using pre queries, filters, variables, calculated Key figures/Restricted Keyfigures, Exceptions, and Conditions.
• Created advanced SQLfor Analytic Views and Calculation Views
• Created new reports in Bex using report designer tool.
• Expertise in SAP HANA data modeling using Attribute Views, Analytic Views and Calculation Views.
• Expertise in SAP HANA Data provisioning technology including SAP LT Replication Server (SLT), Flat Files and BO Data Services.
• Created functional requirement specifications through end-user meetings and analysis of Business Requirement Documents for Enhancements.
• Also used various Aggregate functions, string functions, date functions, Environment Functions, Math Functions.
• Created various Local and Global Variables to populate default values in the target system.
• Used Business Objects Data Integrator XI R2 interactive debugger to test the jobs and fixed the bugs.
• Involved in High Level design(ICD), Low level Design(FD), Unit Test Case and Integration Test case Preparation, Performance, and improvement of BODS
• Involved in Migration of Jobs and workflows from Development to Test and to Production Servers
• Extensively worked on development of mappings and worked with BODI Transformations like Reverse Pivot, Map Operation, Table Comparison, Effective Date, History Preserving, Row Generation, Key Generation, Query, Case, Merge, Validation, and Pivot etc.
• Involved in Data Profiling/ validation and address cleansing transformations by using Data Quality.
• Involved in administrative tasks like local/central Repository configuration, Job Scheduling, Monitoring.
• Participated in full life cycle implementation: Scope, Blue printing, Functional Specification, Technical Specification,Configuration,Unit Test,Integration,User acceptance,Go live Preparation and After Go-Live Support
• Cleansed historical data within Excel for sales person’s revenue and budget/actual cost for three products, also created direct connections in BW and loaded data for reporting into infocubes and Multiproviders
• Provided effort estimation on FIAR content installation, data load and testing
• Created Global bike Revenue Vs. Cost Analysis using XCelsius with revenue vs. cost by month and monthly margin alert KPIs over BW BEx Reports
• Created Financial reports in WEBi to analyze revenue made and the cost incurred, canned reports in crystal to dig full potential of team and executive dashboard in Xcelsius using BW FIGL data sources for POCO Ltd
• Expert in understanding of the complete Architecture (Data loading, Data modeling & Reporting).
• Created connectivity to a new systems and Loaded a Flat file into the system to create views
• Used the IDT to build a UNX Universes and store in the BO repository
• Excellent understanding of the SCALE UP and SCALE OUT concept in SAP HANA
• Expert in creation of Analytical and Attribute Views and complex models by using SQL script in Calculation Views.
• Created Analytical Privileges and Procedures for modeling
• Good understanding of various components of SAP HANA.
• Overview working knowledge with SAP BO Data services & SLT replication methods.
• Configured for LT Replication
• Develop complex Analytical Views, Calculation Views SQL procedures and functions Using SAP HANA
• Installation and Configuration of SAP Business Objects Edge Solution
• Designing and Building of Universes for up to 15 reports and 5 Dashboards
• System documentation from start to finish
• Support during UAT rework
• Report Writing and training for business users
• Administrative training for IT staffs
• Post Implementation review

Confidential, Dallas Texas

SQL Server |BW Developer

Responsibilities:

• Design and Development of Custom Infocubes, ODS objects, Multi Providers, Infosets and master data objects.
• Developed Custom ODS objects that captures the erroneous data.
• Development and Enhancement of Info sources, Transfer rules and update rules.
• Created update rules with necessary update routines and start routines.
• Created and activated Communication Structure, Transfer Structure, Transfer Routines, Update Rules (both ODS and Info Cube level). Built and loaded cubes and validated results.
• Created Scheduling plans for data load to use Process chains in order to load Master Data and Transactional Data from SD into BW.
• Worked on system tools for tuning like RSRV, ST05.
• Extensively used BEx Analyzer to build queries and worksheets to access data from BW data targets.
• Supported the client by providing long-term solutions to the tickets by doing Root cause Analysis.
• Maintain list of all the activities for all the tickets until it is closed down.
• Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Monitoring of info packages and analyzing the reasons for frequent failures of infopackage.

Confidential, Dallas Texas

ETL|OLAP|SQL Developer

Responsibilities:

• Completed phase one of an ongoing project, which is called the GRS (Global Repair Services)-Demand Planning project.
• Completed eRMA WAS reporting, CVRT project in which got good experience in creating generic extractors, function module and SAP program, which was a copy of standard SAP program.
• Worked on APO, WAS, ECC source systems for these projects.
• Worked in AHS (After Hours Support) team to monitor Process Chains and provide production support (hyper care).
• Created data transfer processes using process chains and gained experience in extraction, transformation, data distribution techniques in the ETL process.
• Wrote start routines, end routines, expert routines as well as logic for DTP, infopacks to dynamically change the selection criterion based on sy-datum, etc.
• Extensively worked on write optimized DSO's
• Resolved the RFC issue successfully when we were not getting records into BW from the source system (WAS) as the transaction ids were getting stacked up in the TRFC monitor. (applied a SAP note
• Built a lot of Process Chains (some to trigger the IF work flow using ABAP program) and corrected some PCs already in Production in order to improve the system performance.
• Designed Universes and classes by Business Objects XI 4.0 enterprise tool and build all the objects required for WebI reporting which performed selecting, joining tables, cross tab, ranking, and alerter functions.
• Did query development in BEx Query Designer with filters, free characteristics, formulas, selections, reusable objects like calculated/restricted keys, structures, conditions, exceptions, variables and display in BEx Analyzer/Report Designer.
• Worked on the eRMA project to write logic in order to do look-ups on different DSOs (cartdtl, serial no, etc) and built MultiProvider to do reporting off it.
• Monitored the discrepancy between the ZRM3 report generated on ECC side with the IF record count and the record count from the function module result screen on BW side which was causing significant hyper care issues.
• Wrote routines to convert calendar weeks, calendar days coming from the APO side to fiscal month, fiscal weeks on BW side using different function modules.
• Created generic extractors on ECC, WAS and SCM side following the SOLMAN (Solution Manager) process
• Got approval for every change in the Source System from the CAB (Change Advisory Board), which is a meeting, attended by technical experts,architect and technical leads.
• Created Z tables in ECC which got data fed from a function module based extractor incorporating a standard SAP program.
• Created export generated Data Sources to test data in Q bringing it from BW Production as well as exporting InfoCubes over to different source systems to bring data over.
• Wrote expert routines for looking up data based on the requirement to do calculations for the CVRT project and created OpenHubs to give data over to Informatica.
• Performed Data load management, CTS, experience also in Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load), Monitoring, Remote Cubes, Multicubes, Data Mart and Open Hub Service.
• Generated business elements using Business View Manager and data used in different sources and generated Crystal Reports.
• Created Management Reports, Audit Summaries & Financial Statement reports using Xcelsius.

Confidential, Atlanta Georgia

Business Object Developer|JR SQL Developer

Responsibilities:

• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Design of the database and tables and loading of data into them.
• Installed and Configured SQL Server 2000 successfully.
• Involved in writing procedures to check some of the rules at the backend at the time of entering data.
• Responsible in SQL Server disaster recovery procedures and involved in Stored Procedures Optimization, Performance tuning & Index tuning
• Responsible for development of SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Built table relationships and wrote stored procedures to clean the existing data.
• Coordinated with the front-end developer to put in the business rules.
• Involved in developing SSRS reports.
• Created universes based on the data needed to be reported and created standard reports mainly focusing on ad hoc reports.
• Created tables, sequences, indexes, views and constraints.
• Implemented Join conditions, group by functions, correlated sub queries.
• Used various join methods like Equi-join, shortcut join. Created classes and objects in the universe.
• Used Aggregate tables in the universes for the query optimization process along with designer functions like @prompt, @select and @where to create and define condition objects required to generate reports.
• Created Row Level Security in the universes to make the data available only to permitted users.
• Resolved the issues while creating joins like loops, chasm traps, fan traps by creating aliases, contexts and performing integrity checks.
• Created WebI reports using multiple data providers and exported them to Central Management Server.
• Extensively worked on the features like sorting, grouping, ranks and alerts in WebI reports for a better readability of the reports.
• Designed and developed existing reports in Crystal Reports.
• Initiated the crystal reports API to run on demand reports automatically according to the reporting schedules.
• Generated reports based on time line like year, quarter, month, week based on relative and comparative reports.
• The data consisted of various dimensions like customer, vendor, billing information, operation planning, sales and production.
• Planned coordinated and executed Business Objects deployment end users and also documented the entire project.

Confidential, Irving Texas

Business Object Developer

Environment: SAP R|3 4.7, BW 3.5, BW 7.0, BEx Analyzer, Browser & WebAD

Responsibilities:

• Performed functional migration of SAP BW 3.5 to SAP BI7.0.
• Worked in the Design, development and extraction of the data from R/3 system and flat files in to BW system from SD and MM modules using LO Cockpit extraction methods.
• Created or enhanced BW DataSources in CRM and ECC environments.
• Created Functional and Technical specs as per business requirements and built SAP BW HRreporting system
• Worked on Work Management module, which included accepting, planning, calculating and carrying out work orders.
• Created Data Transfer Process (DTP) to transfer data within BI from one persistent object to another object.
• Generated Transformations from Transfer rules and update rules in the process of Migration of data flow from 3.5 to 7.0
• Implemented Start and End routines within Transformations.
• Worked on Open hubs to give data to third party systems like Teradata and Datastage.
• Worked on ABAP/4 Workbench building of Data Dictionary Objects and wrote Function Modules.
• Enhanced Infocube with remodeling concept to make changes, without having to reload data.
• Used Direct Update DSO in the process of APD (Analysis Process Designer).
• Generated Queries using new BEx Query Designer.
• Designed new applications using new Templates in BEx WAD.
• Worked extensively with new BEx Analyzer.
• Worked with BEx Report Designer to create formatted reports.
• Executed Ado query analysis using Web Analyzer.
• Launched BEx Report to the Web and generated PDF file.
• Developed Web Reports in BI 7. Used the New BI 7 Web Items such as Tab pages, Containers, Menu bar items to give the reports a dashboard look & feel.
• Created BW Universes on top of BW queries to access the BW data in Business Objects.
• Created WebI reports and deployed them through Info View with BW Universe as Source.

Confidential, Bartlesville, OK

Business Object Developer

Responsibilities:

• Launched BEx Report to the Web and generated PDF file.
• Developed Web Reports in BI 7. Used the New BI 7 Web Items such as Tab pages, Containers, Menu bar items to give the reports a dashboard look & feel.
• Created BW Universes on top of BW queries to access the BW data in Business Objects.
• Created WebI reports and deployed them through Info View with BW Universe as Source.
• Analyzed the data issue on the BW side, which was mismatching the data on the COGNOS side.
• Created BW queries for Outpatient for Rehab Careusing BEx query designer using restricted and calculated Key Figures.
• Created Crystal Reports on top of these BW queries to align with the COGNOS reports.
• Completed a list of various Inpatient Reports in query designer and Business Objects Crystal Reports filtering on Profit centers, different facility ids.
• Exported the views to the portal.
• Interacted with Subject Matter Experts for studying their business requirements.
• Actively involved in the complete life cycle implementation of SAP BW
• Analyzed business reporting requirements that could be satisfied with SAP business content and installed the documented objects.
• Analyzed, designed and developed Extraction, Transformation, data acquisition, and real time data acquisition processes for a data warehousing and Data Migrations projects
• Responsible for job schedules for loading Master data (Texts, Attributes and Hierarchies), Attached newly developed objects to Requests and Tasks and Transport them to QA and Production system.
• Configured, enhanced and extracted data from SAP (using COPA, LO and Generic extractor) and non-SAP systems.
• Defined specifications for frequency and mode of data transfers and setup of batch jobs for Info package by coordinating with basis and system admin teams t
• Uploaded the data to BW from source systems in specific intervals using delta update mechanisms.
• Developed flexible queries using filters in BEx analyzer to facilitate data analysis
• Created and maintained Report-to-Report interface (RRI).
• Created Web templates using Web Application Designer WAD.
• Involved in creating I-views for web templates.