Professional Summary

• Over 8 years of SAP experience focused on SAP BW and Business Objects development and over one year of SAP HANA .
• Participated in two full life cycle development and implementation and end user training.
• Knowledge of core business processes in SAP R3/ECC/BW/BI/BOBJ.
• Good understanding of SAP methodology, all the way from Business Blueprinting, Realization, Go-live Cut over, post implementation support Training.
• Team player with great communication and leadership abilities.
• Full cycle implementation and creation of Infocubes, DSO, Multiproviders, Infoareas, Delta loads and BEX reporting.
• Developed complex and sophisticated BO reports including Multiple Data providers, Reporting prompts, Dash board reporting, Hyper links and Multi-tab reporting.
• Designed and maintained complex Business Objects Universes Linked Universes .
• Developed specs for multiple Business Objects reports, enhancements to transactions, user exits, and enhanced standard SAP Reports.
• Created spec documents for enhancements per client needs.
• Created documentation for end users for training purposes.
• Conducted training classes for business users, mid and higher level management.
• Configured materials master including material types, definition of views and fields, required number ranges for material types.
• Configuration of vendor master including creation of account groups defining fields and usage of partner functions.
• Interfacing legacy application of vendor, suppliers and subcontractor with SAP.
• Experience with multiple full life-cycle implementations in SAP BI/BW, Business Objects adopting ASAP Methodologies which involves Requirement Workshops, Gap analysis, Business Blue-Printing, Realization, Data extraction, Data modeling, Data loading, Production Support, Testing, Documentation, Requirement analysis, End user documentation, Reporting and Go-Live Check.
• Expertise in Data-Modeling Multiproviders, Infocubes, DSO, Remote Cubes, Master Data, Process Chains , Extraction
• Extensively worked on Reporting tools like BEx Analyzer, BEx Query Designer, BEx workbooks, Web Application Designer.
• Expertise in using Start Routine, End Routines and Expert Routines for Complex data transformation Requirements. Experience in creating DTP Filter Routines and Infopackage Routines User Exits.
• Expertise in Creating Xcelsius Dynamic Dashboards using SAP BI data/ BEx Queries. Valuable Knowledge on Xcelsius Dashboard Components Like Charts, Selectors Filters, label Based menus , Tabsets, Canvas Containers.
• Expertise in using Universe Designer over BEx queries and Info Cubes to migrate model data from BI to BO for reporting. Excellent skills to develop reports using Webi. Valuable knowledge of Crystal Reports.
• Built Custom extractors/ Info cubes in Logistics/Finance Enhanced the Business Content by performing GAP Analysis to identify KPI's for the business needs.
• Worked on various kinds of Performance Tuning techniques such as Aggregates, Rollups, Indexes, Partitions and Info-Cube Compression techniques.

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
• Business Objects 3.X, 4.0: Web Intelligence, Universe Designer, Query as a Web Service, Data Services, Xcelsius 20011.
• SAP Function Modules: BI/BOBJ, HANA 1.0 SP5, SD,MM
• Operating System: Win 98, 2000, NT, XP,
• Languages: Java and SQL
• Back End: MS-ACCESS 2000

Certifications

• SAP Certified-Associate Business Foundations integration with SAP ERP 6.0 EHP5
• SAP HANA Application Associate 1.0 in-View
• Project Management Professional PMP in view

Professional Experience

DTE Energy

Detroit Michigan March 2014 Nov 2014

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.
• Created reusable components like Workflow, Data flows, batch and real time JobsResponsible for creating datasets using T-SQL and stored procedures.
• Extensively used Calculations, Variables, Prompts, and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business objects reports.
• Expertise in generating the Complex Crystal Reports like On Demand reports, Sub Reports, Drill-Down, Dynamic Grouping, Cross-Tab, Graphical, Ad Hoc Reports, Summary Reports, Linked Reports, Mailing Labels and Aging Reports.
• Good Experience in creating Corporate Dashboards, Scorecards, Performance Metrics, Rules, Alerts, Bar charts, 3D charts, Pie charts, Column chart, Line chart, Bubble chart and Goals using Xcelsius 2008.
• Experienced in Business objects universe designing OLAP Universes , Business Objects Web Intelligence WebI , InfoView, and BOE.
• Hands on experience in creating BOXcelsius dashboards and KPI's to large-scale multi-layer reports.
• Configured OLAP Cubes, Data Sources and Data Source Views for Portfolio Analysis using SQL Server Analysis Services
• Experience working with Web Intelligence, Web Intelligence Rich Client WEBI , Desktop Intelligence, Crystal Reports 2008 2011, Xcelsius 2008 Dashboards 4.0 , Central Management Console CMC , Query as a Web Service QaaWS , Live Office, Publishing Wizard, Import Wizard and Report Conversion Tool.
• Excellent knowledge in implementation of Relational Database OLTP and Data Warehousing systems OLAP and Data Marts.
• Extensively worked on Performance Tuning of the jobs.
• Extensively used Try/Catch to handle exceptions and writing Scripting to automate the Job Process.
• Involved in Migration of Jobs and workflows from Development to Test and to Production. Analyzing the context, content and end user requirements of reports and data with a view to optimizing Information Architecture.

Confidential

SAP BOBJ Consultant

Environment: SAP BW BI, Business Objects 4.0

• 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..
• Created Users and Roles under User Administration in Enterprise Portal. Created worksets, pages, iViews under content administration in Portal.
• 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.
• Created help documents, work instructions for web templates, web items, iViews etc.
• Helped implement SAP BEX transitions in to Business Objects reporting tool utilizing Webi and Deski
• 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 WEBI reports and Crystal reports and deployed them through info view with BI universe as source and created Inventory accuracy dash boards using Xcelsius.
• 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.
• Resolved Post-Production issues like rescheduling process chains to meet user requirement etc.
• Experienced in development of project documentation, testing materials and execution, training materials, requirements gathering including downstream and upstream interface requirements and adhering to a project management.
• Extracted into COPA
• experience as a SAP configuration or functional analyst in the SAP COPA
• created data source for CO PA
• created Characteristics and key figures for COPA
• Worked with client during specification gathering,
• configuration and implementation of SAP systems
• Configured FI/TR AP, GL, CM, MM workflow creation,
• configuration, testing and implementation of Business Processes according to specified requirements with particular emphasis on projects systems, results analysis and settlements of all SAP module objects profitability analysis.
• Integrated testing, documentation and user development training of new processes.
• Set up for multi currencies
• Coordinated report specification design and program testing
• Configured basic organization settings Company Code, Charts of Accounts, Business areas , setup year independent fiscal year variant, G/L accounts group, field status variant and document number ranges.

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 monsth and monthly margin alert KPIs over BW BEx Reports
• Created Financial reports in WEBi to analyse 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
• Confidential
• 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

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 reowork
• Report Writing and training for business users
• Administrative training for IT staffs
• Post Implementation review

Confidential

SAP BW/BOBJ Support

Environment: SAP BOBJ -WEBI, Crystal.,Dashboard

• Created functional requirement specifications through end-user meetings and analysis of Business Requirement Documents for Enhancements.
• Created Complex and Sophisticated reports with multiple data providers Universe/Free Hand SQL/Personal Data Files and formatting the Reports as per the Users requirements by using DeskI and WebI.
• Involved in Performance testing and Stress testing of all the reports, which helped in analyzing its performance before moving into production.
• Created Reports using hierarchies, scope of analysis, alerters, filters, conditions
• Created Crystal reports using SAP
• Release Management: Responsible for all release that are implemented in UAT and Production.
• Coordination with Development team on site and offshore in China.
• Universe Design
• Testing user privileges
• Created Multi tab reports using multiple universes
• Expertise in design of DSOs, Info Cubes and Aggregates. Strong Working knowledge of Roles, Transports, Process Chains, Performance Monitoring and Tuning
• Configured of general ledger accounting,
• creation of chart of accounts and assignment of company code to chart of accounts,
• configured financial statement version,
• configured planning in the general ledger accounting
• Integrated with MM PP: configuration of automatic account assignment
• Integrated with SD: configured account assignment with respect to SD module.

Confidential

BW Developer ECC Functional Support

Environment: SAP BW 3.5, ECC 5.0, SAP BO XI3.1/XI3.0/XIR2/6.x/5.x

Main Responsibilities

• Created Xcelsius components like charts, menus and container
• Created different kinds of analytics, interactive Metric trend and Metrics list
• Use section Expert with conditional formatting to create Hide/suppress summary Reports
• Use LCM Life cycle Manager for exporting BO objects from one environment to another
• Worked extensively with the major functionality of BO like breaks, ranks, variables, Alerters, Formulas, calculated data items, Filters, sorts and Query prompts
• Prepared Business Requirement Document and used Rational RequisitePro to manage, analyze, and convert business requirements into functional specifications
• Managed schedules and collaborated with different teams working on the project
• Used Designer to create Dimensional, Detail and Measure objects
• Created and deployed Web Intelligence Reports through Info View
• Involved in creating Tables and relationships.
• Developed complex queries and reports using different data providers in the same report.
• Good command on designing reports using Xcelsius dashboard and using Xcelsius Designer.
• Resolved loops in universe using contexts and aliases and also Implemented aggregate awareness functions.
• Maintained consolidations and reconciliations for Finance and Inventory data to verify the data in SAP R/3 and SAP BI are same or not after the month end data loads as a part of month end activities.
• Worked extensively on standard and custom defined LIS, LO extractors. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery information. Logistics Cockpit configuration and customization.
• Worked extensively onData Modeling, Data Extraction, Transformation, Loading, Scheduling jobs, Monitoring data loads and Reporting.
• Worked with info cube 0CCA C11, which contains all costs and quantities on cost centers.
• Developed custom ABAP code in start and end routines and performance improvement on data loads and run time optimization.
• Developed the cubes ZFIAA C11, ZFIAA C12, and ZFIAA C13 from scratch by adding several new fields based on the Info cubes 0FIAA C11 Cumulative Movements , 0FIAA C12 Annual-Delta and 0FIAA C13 Period values-delta .
• Extracted data from standard line item data sources like 0FI GL 04 GL line item , 0FI AR 04 AR line item , 0FI GL 10 GL Leading Ledger-Balances 0FI GL 14 New GL Reporting .
• Extracted data from CO-PA data source 0C0 PC PCP 01 to provide value cost components and deliver data for product costing header data and product costing Cost of components .
• Worked on the enhancement of business content data sources by appending structures and writing user exits. Modified the standard extractors 0FI AP 3, 0FI AR 4 and populated the enhanced fields.
• Enhanced standard data source 0FI AA 11 to provide Asset Transaction records at Posting Date, Document Level from the tables ANEK and ANEP filling through User-exit.
• Worked on dashboard design and development, capable of analyzing requirements documentation.
• Migrated reports to Xcelsius for better analysis.
• Responsible for reports sign off from business users and making sure the reports suffice the business requirements.

Confidential

Business Object Developer

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

Main Responsibilities

• Worked on support, maintenance and migration of the clients existing SAP BW reports. Devised the strategies and methods for the migration of BW 3.5 to BW.7.0.
• Worked with the business users and Functional consultants in defining the FSD for SD and MM modules.
• Worked with the business and development team to define the strategy for integrating SAP and non-SAP data
• Created Hierarchies both time dependent and time independent based on business requirements.
• Preparation of Data Model design document, Query design document, Test script, User training Administrator's guide for this project.
• Creation of Process Chains and monitoring the data loads from different source systems using Process Chains
• Built Queries and present results in Workbooks by defining rows, columns and free characteristics providing drill-downs using RRI functionality and other features - maintaining Conditions Exceptions
• Providing end user training and technical support for existing processes
• Involved in full life cycle implementation, which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• Created Financial and Regulatory accounting reports like Trail balance summary, Flash YTD Variance to budget Prior year and Cash Flow GAAP reports.
• Developed Financial Asset accounting Reports like Fixed Assets continuity and Monthly retirements.
• Created Custom DataSource and required Custom user exits for data extraction and enhanced update tables used to load data into BI System.
• Created Datastores for threedifferent G/L reporting standards IFRS, GAAP USOA and created overview Multi Provider G/L Summary for consolidated Reporting. Built Aggregates to improve query performance.
• Installed extractors from BI Content in G/L, AP AR enhanced them meeting the data warehouse requirements.
• Developed custom Multi provider for Asset Accounting reporting in SAP BI. Obtained data from Cumulated Movements, Annual Values Period Values for Asset Accounting.
• Implemented standard content for Personal administration 0PA C01, 0PA C02 cube to analyze personal data such as head count based on nationality, gender, language, personnel area, employee group and organizational unit.
• Created Financial Reports Overhead Variance, Operational Expenditure Variance, Revenue Variance Depreciation Variance Reports using SAP BEx comprising of Planned-Actual analysis, fiscal year comparison.