Ranjan Mamidala acxlt2@r.postjobfree.com

856-***-**** Status: U.S. Citizen

Profile Summery

Total over 11 years of experience in IT which includes over 8 years of SAP BI BW and BOBJ.

Strong functional and technical knowledge of SAP R/3 application areas like SD, MM, P2P, FI, CO, AR & AP.

Design, develops, tests and implements (BEX, WEBI and Crystal) reports that utilize the underlying data stores of the enterprise.

Expert in Business Objects, created many complex BEX, WEBI and Crystal reports by using BEX and Universes (UDT and IDT).

Involved in several full life cycle implementations (SAP ASAP methodologies) involving data modeling, design and development of BW objects, transformations, installation of standard Business Content, and configuration..

Strong Backend and Front end design with In-depth understanding of OLAP, OLTP and ETL Process in doing extraction from Source Systems to BW system.

Strong on End-to-End SAP BW Configurations and Customizations of SAP BW Extractions.

Developed various Data targets, Data sources, Info objects, and Key figures, Infoproviders, DSOs, Process Chains and Multiproviders. Created Generic Extracts, Transfer Rules, Update Rules, Start routines and End Routines.

Excellent communication and leadership skills and strong analytical skills with functional and technical abilities.

Expertise in Data Modeling using Entity Relationship (ER), Multi Dimensional/Star Schema and Extended Star Schema models. Strong knowledge of SAP BW architecture and SAP BW data modeling. Experienced with gathering business requirements, data modeling, ETL design, implementation, report creation, data analysis and customization of data Extractors and BI objects.

Works on a project team in support of production support and other team members to understand business requirements. Collaborates with cross-functional teams in order to gather and document reporting requirements.

Develops and integrates application software, including unit testing and implementation efforts; maintains and support software implementation.

Works under minimum supervision to exercise independent decision making.

Translates business requirements into specifications that will be used to implement the required reports.

Creates deployment plans which promote developed reports and from development environments to higher environments.

Provide technical assistance and cross training to other team members; Provide training and assistance to users for generation of ad-hoc reports

Design and implement technology best practices, guidelines and repeatable processes

Prepares and presents status updates on various projects

EDUCATION

B.S Computer Science, Andhra University

Master of Computer Applications, Andhra University

TECHNICAL SKILLS

SAP BI / BW: Interacted with users/functional team for requirement gathering and analysis.

Worked with Infoproviders, Multiproviders Info Sources, Info Objects, DSO, Open

Hubs, Master data, Transactional data with delta and full uploads, Logistics

Cockpit set up Update Rules, Transfer rules, Start Routine, End Routine, Uses exits in

BW and ECC Using ABAP, Create and maintain, Process Chains, Info Package Info

Spokes, BEX Analyzer, Query Designer, Info Set Queries, Calculated and Restricted

Key figures, Structures, Process Chains, Open Hubs, Flat file uploads, Generic

Extractors, Customizing the BW extractions Variables, conditions, exceptions,

Query Performance Monitoring, Aggregates, and Reporting Optimizations,

Reporting Authorizations, Transport Management (CTS), Trouble shooting

Problems in Production Environment.

SAP BOBJ: Universe Design Tool (UDT), Information Design Tool (IDT), WEBI, Crystal Reports

2011, Xcelsius, Design studio, Dashboards, Business Objects 4.0, Business Objects 4.0,

4.1, customizing/configuring Business Objects, solving client information needs through

The analysis, design, and building reports.

ERP: SAP ECC 7.0. SAP BI BW up to 7.4, Business Objects (BOBJ) up to 4.1 Crystal 2011.

Modules: FI/CO (GL, AP and AR) SD, MM, PP and SCM.

Databases: DB2, Oracle, MS SQL and MS Access.

Languages: ABAP, HTML, JavaScript, SQL, PL/ SQL

MS Products: Microsoft Excel, Word, Access, PowerPoint, and Visio.

PROFESSIONAL EXPERIENCE

SAP BI BW BOBJ Sr. Analyst Keurig, Burlington, VT Jun 2013 – Present

SAP BI 7.4, ECC 7.0, BOBJ 4.1, FI/CO, MM, PP, SD, and SCM (BW on HANA)

Responsible for collecting the requirements, performing of gap analysis, creating, functional & technical specifications and high level design documents.

Worked on Global and regional reports in SAP modules FI/CO, CO, SD, and MM

Worked on customization of extract structure to support business needs.

Designed and developed various Data targets and Infoproviders like DSO, Info cubes, Info objects, Multiproviders and Info sets using Admn workbench. Developed various transformations to cleanse the data and enhance the master and transaction data using start and transfer routines with ABAP4 to suit the business requirements.

Populated various data targets like Info objects, Infoproviders, with Master data and Transactional data from ECC and legacy systems using flat file interface via Data Staging area (PSA).

Created Webi reports with multiple data providers and synchronized the data using Merge Dimensions.

Developed WebI Reports as per the business requirements.

Developed WebI Reports (on demand, Ad Hoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-Down, and Cross-Tab).

Interacted with the End Users, Business Analysts and responsible for Involved in training sessions to impart knowledge on designed universes and published reports.

Created reports using Crystal Reports and also using Business Objects functionalities like Queries, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.

Worked on various Business Object Reporting functionalities such as Slice and Dice, Master/detail, User Response function and different Formulas.

Installed, Troubleshoot, upgraded and maintained the various Business Objects.

Created Dashboard using SAP Business Objects Dashboard.

Created graphs/charts for the reports, Created Master Detail and Cross Tab Reports.

Exported reports into various formats like PDF, HTML, EXCEL and WORD for end users.

Debugged Start routines and End routines to resolve the issues.

Evaluated statistical Performance and provided recommendations or applied the solutions as needed. Improved data load and query performance by doing compression, aggregates, and partitioning. Collecting and Releasing transports (BW and BI).

Worked with basis team for space related issues, establishing RFC connections to various source systems, applying required notes, moving objects from development box to QA and Production.

Reconciliation of BI reports with the ECC & legacy data as wells as the reports.

Designed and developed complex Business Objects (BOBJ) reports using BEx analyzer, BO universes, WEBI, Crystal Report 2011, Worked with BEX queries free characteristics, formulas, selections, reusable objects like calculated/restricted keys, structures, conditions, exceptions and variables, query views, query elements, Web templates, Report, RRI, (BEx) Query Designer, BEx Analyzer and Workbook design, formatted reports, Information Broadcasting, publishing and Dash Boarding.

Interfaced to transfer data from BI to Flat Files to load to an external system using Open Hub.

Performed huge data loads into DSO and Info cubes from ECC as well as the legacy systems

Developed complex BOBJ reports using BEX, Universes and WEBI (4.1).

Created Jump queries (using RRI), Restricted Key Figures, Calculated key Figures, Filters, Conditions, Variables and Structures. Reports related to SD, MM, FI and COPA.

Reports: Number of Cups report, Filled/Empty cups report, GL Line Items, Inventory Flash Reports, Cost center and Profit center COPA related reports, Sales Reports, Billing reports and Delivery reports.

SAP BI BW BOBJ Sr. Consultant, Blue Harmony, and Raleigh, NC Jan 2011–Jun 2013

SAP BI 7.3, ECC 7.0, BOBJ 4.0, FI/CO, MM, PP, SD, and PP

Gathered and assessed business information needs by working closely with the business to collect reporting requirements, to create functional and technical design documents and to deliver reporting solutions for approved projects.

Worked with End-To-End implementation with Data warehousing team and Implemented Star- Schema, Snow-Flake Schema

Extract data from SAP ECC, as well other applications using DB Connect, and flat files.

Worked on activation of Standard Business Contents, customized and created BW cubes

Built Generic extracts and enhanced existing BW objects; Info cubes, Info Objects, Info Sources, Start/End routines, and Data Sources, DTP, Master Data, and Transactional data sources.

Enhanced data sources with user exits on BW and ECC using ABAP.

Created many complex (single tab and multi tab) reports in above mentioned SAP modules using BEx Analyzer (Report Variables, Navigational Attributes, filters, structures, alerts and conditions) and query designer, WEBI and Crystal reports.

Worked with security team on creating reporting roles for BOBJ reports.

Developed workbooks and used RRI Jump Queries to drill down to other queries and R/3 transactions.

Provided all around support in the use of BI reporting and to the end user community; took ownership of resolution.

Involved in performance tuning by creating indexes, aggregates.

Performed Data Extraction and using LO Cockpit and extended the structures using user exits to support the business needs.

Involves formal testing data integration and data quality and confirms that BW reports meet documented requirements. Provided issue resolutions during testing process.

Created reports on development data to test the functionality of universes with a group of power users.

Created graphs/charts for the reports, created Master Detail and Cross Tab Reports to provide a transformational approach.

Created complex reports using user-defined functions like @variables, @prompt, and conditions

Scheduled and broadcasted reports to business users using Broadcast Agent.

Created Dashboards using Crystal X-Celsius for senior management for business decision making.

Worked on Crystal Reports reporting system including Crystal Server reports distribution infrastructure.

Created Xcelsius Dashboard for executive and sales team in summery and drill down levels.

Trained business users in how to navigate through BO Info Views and creating slice and dice reports as business needs.

Conducting training sessions for power-users, end-users and Knowledge Transfer to consultant and employees.

Reports: Daily detail and summary reports, COPA reports, GL balance reports, Sales Documents Blocked for Delivery, Sales Documents Blocked for Billing and Budget reports

SAP BW Consultant, Stanley Black & Decker, Towson, MD Feb 2008– Nov 2010

SAP BI BW 7.0, ECC 6.0, BOBJ 3.1, FI/CO, MM, PP, SD, and PP

Collected requirements from users and Modeled data targets according to the reporting and Interface requirements. Worked with teams to discuss/review technical specifications (TD) and functional requirements (FD) and get the right approval before passing the task to for development.

OLTP extraction from SAP R/3 and BI system using standard and generic extractions. Developed Custom Data Extractors (ETL Using ABAP) and Trouble shoot when there is any problem.

Involved in full life cycle Implementation of SAP BI.

Worked with Scheduling, Monitoring, Info-cubes, Info-Source, Remote Cubes, ODS objects, BEx-Analyzer, BEx-Query, Workbooks, Data Extraction, Generic Extraction, Data Loading (Full /Delta Up-Load).

Involved in integrating BI reports in to the portal.

Created Aggregates, Segmentation and Multi-providers to improve load and query performance.

Developed user exits on ECC and BI side to achieve the enhanced functionality.

Created universes, classes object by retrieving the data from various data sources and defining the necessary connections.

Used Business Objects Developer Suite (Publisher View, CMC, Designer, and Info View) to perform various tasks specific to every component.

Developed Queries to access data from various BW Infoproviders like ODS, Infocubes, Infoobjects, Multiproviders and Infosets using BEx query designer.

Created BEX queries using Query Designer and Jump queries (using RRI), Restricted Key Figures, Calculated key Figures, Filters, Conditions, Variables and Structures, and Exceptions,

Extensively worked in Crystal Reports for creating complicated 18 reports including sub-reports, parameter based reports, graphical reports, formula based, drilling reports, and analysis reports.

Reports: Daily sales report, Purchase Orders by Vendor, Purchase Orders by Material, Purchase Orders by PO Number, Invoice Overview, Stock Overview and special stock report.

Java Consultant, TSoft PVT Ltd, Melbourne, Australia Feb 2004–Dec 2007

Environment: Java/J2EE D

Worked as Research Assistant and a Development Team Member. Coordinated with Business Analysts to gather the requirement and prepare data flow diagrams and technical documents. Identified Use Cases and generated Class, Sequence and State diagrams.

Contact this candidate