Professional Summary

• Full cycle implementation and creation of Infocubes, DSO, Multiproviders, Infoareas, Delta loads and BEX reporting.
• Good understanding of SAP methodology, all the way from Business Blueprinting, Realization, Go-live Cut over, post implementation support Training..
• Extensive experience in Modeling, Data Extraction/Loading ETL , Reporting, SAP Business Explorer Suite, SAP Business Object Analysis Suite, Analysis Process Designer APD , Information Broadcasting
• Expertise in working with Solution Manager and Transport Management System
• Highly experienced in upgrade of SAP BW Application from BI 3.5 to BI 7.x
• Extensive experience in Modeling, Data Extraction/Loading ETL , Reporting, SAP Business Explorer Suite, SAP Business Object Analysis Suite, Analysis Process Designer APD , Information Broadcasting
• Worked on 3 full life cycle implementation projects starting from Requirement
• 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
• 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 Summary

• 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, XP,
• Languages: Java, SQL, VB.net, ABAP 4, PL SQL
• Back End:MS-ACCESS 2000

Professional Experience

SAP Business Object BODS Developer

• 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

SAP BW BO Consultant

Environment: SAP BW Business Objects 4.0

• Also used various Aggregate functions, string functions, date functions, Environment Functions, Math Functions.
• Created functional requirement specifications through end-user meetings and analysis of Business Requirement Documents for Enhancements.
• Expertise in SAP HANA Data provisioning technology including SAP LT Replication Server SLT , Flat Files and BO Data Services.
• Expertise in SAP HANA data modeling using Attribute Views, Analytic Views and Calculation Views.
• Created new reports in Bex using report designer tool.
• Created advanced SQLfor Analytic Views and Calculation Views
• Extensively worked on BEx Query Designer in designing many queries using pre queries, filters, variables, calculated Key figures/Restricted Keyfigures, Exceptions, and Conditions.
• Involved in gathering requirements from user, creating Functional specs, Technical specs, Test plans, and end user training.
• Worked on the performance tuning the queries by maintaining aggregates, indexes and compression on Info cubes.
• 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.
• Analyzed the errors that occurred during the data loading and solved the issues for that occurred during the activation process of the objects.
• Involved in solving high-prioritized tickets regarding extractions and load failures.
• Extensively created reports in WebI, implemented drill down features and created reports including horizontal table, vertical tables, forms and charts
• Resolved Universe problems such as loops and traps using alias and context.
• Created dashboard designs with the Dynamic visibility for interactive functionality
• Created Xcelsius dashboards using different chart types and tables
• Involved in the migration of BEx Queries to BO Reports and Developed BEx customer exit variables for FICO Reports.
• Created universes and test environments for Business Objects and tested user permissions
• Worked with the business, share point team to make changes to the queries to resolve timeout issues.
• Involved in Data Modeling, Data Extraction, Data Loading Full/Delta Upload ,Scheduling and Monitoring
• Worked on scheduling reports using Information Broadcasting to export reports in form of excel and pdf files.
• 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.
• Provided pilot training to finance functional team and performed unit testing.
• Designed and built BEx Analyzer finance reports using variables, structures, conditions, exceptions, filters and aggregates for performance tuning of queries.
• Interacted with functional team, development team and end users of Finance, Order to Cash, and Procure to pay departments, to study their business process.
• 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.

POCO Project

• 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

SAP HANA 1.0 forPoco Project

• 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

Harris Logic Project

The ATCG Team Helped built Harris Logic SAP Business Object Edge Solution from the installation to Configuration of the Business Object Edge solution along with other fulfillments according to the SOW

• 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

SQL Server BW Developer

• 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

ETL OLAP SQL Developer

Main 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,architectand 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

Business Object Developer JR SQL Developer

• 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

Business Object Developer

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

Main 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

Business Object Developer

Main 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.