Trupti V. Kulkarni. .

**** ********* *****, #***,

Loveland, OH 45140.

Ph #: 513-***-****

abg3ie@r.postjobfree.com

Professional Summary: .

● Over three years of IT experience. Worked on multiple technologies like SAP BI-BO and IBM

Mainframe.

● Two & half years of experience in SAP-BI and worked extensively on Extraction, Reporting and

Modeling. Worked in Various Areas like SAP-BI, SAP-R/3. Worked in BW3.5 as well as BI7.0 for up

gradation of data.

● Strong knowledge of SAP BO.

● Extensive experience in Multi Dimensional Data Modeling ie.Extended Star-Schema

● Strong knowledge of best business practices and BI project methodology.

● Hands-on experience with requirements gathering,identifying,analyzing various report

requirements for end users and prepared Functional Specification and Report Help documents,

supporting existing reports in production.

● Strong experience with the SAP BI/BW front end tools such as BEx Query Designer, WAD, BEx

Analyzer, SAP Business Objects XI 3.1, Xcelsius, Web-Intelligence, Crystal Reports and Live

Office.

● Experience with development of Sr. Executive dashboard for Executives using BOXI 3.2 –

Xcelsius 2008.

● Experience in designing, creating and maintaining OLAP Universes in Business Objects using

SAP BI info providers as back ends.

● Excellent client facing, Interpersonal and communication skills.

● Six months of experience in Application Programming on IBM Mainframe using COBOL, CICS,

DB2, JCL & VSAM. Extensive knowledge RDBMS concepts using database DB2.

Expertise in BI7.0: .

Modeling Expertise:

● Extensively worked on the Administrative Workbench like designing various data Targets like Info

Cubes, ODS, Master Info Objects, Multi Provider and Info Set.

● Created Process chains and monitored them.

● Created Master Data Info Sources for Attributes, Texts and Hierarchies.

● Worked on performance at Data Target level like Index creations, Aggregates, Compression of cubes.

● Worked on Transfer Rules, Update Rules and Transformations.

Extraction Expertise:

● Configured Data Target Objects to upload the data from SAP-R/3 and flat files.

● Good knowledge of creating Generic, LO & CO- PA extractors.

● Worked in the Direct Delta and Queue Delta methods in LO Extraction and have an extensive

knowledge on LIS and LO Cockpit functionalities.

● Worked On Data Source Enhancements.

● Have knowledge on DB connect and UD connect.

Reporting Expertise:

● BW Reporting, Bex Analyzer, Web Application designer and Report to Report Interface.

● Good work experience with BEx Query Designer. Extensively built queries on info cubes,

Multiproviders, using BEx analyzer.

● Created reports with Calculated Key Figures, Restricted Key Figures and Filters.

● Worked with Exceptions and Conditions as part of the BEx Query Reporting and have created

variables.

● Created Views and Published the Queries and the Views as Web templates.

Expertise in BO: .

● Knowledge in designing universe by using multi dimension data base (SAP BI) as the back end.

● Knowledge in classifying the classes and dimension /(Detail measure).

● Experience in designing and developing the Universe and updating the existing Universes,

developing canned/adhoc reports

● Knowledge in designing reports by using different report components like desktop intelligence, Web

intelligence rich client.

● Knowledge in creating xcelsius, Dashboards and integrating same in crystal reports.

● Knowledge of using live office.

Expertise in IBM Mainframe: .

● Six months of experience in application programming on IBM mainframe Z/OS, OS390 server using

Linux environment.

● Excellent programming skills in COBOL using VSAM / DB2 database & executing the programs in

MVS batch OS using JCL.

● Excellent programming skills in COBOL using DB2 database & executing the programs in CICS

online OS.

● Knowledge of Object-Oriented Analysis, design and full product of development life cycle including

Requirements Analysis, Product Design, Implementation, Testing and Maintenance.

● Knowledge of RDBMS Concepts using DB2.

Additional Technical skills: .

● Knowledge on C, C++

● Excellent Knowledge in MS Office.

Professional Details: .

● Worked with Access software systems Pvt. Ltd, Chennai, India as an Associate SAP BI-BO

Consultant, from August 2007 to Feb 2010.

● Worked for Six months on a Mainframe Application programming project for Maples ESM Pvt. Ltd.,

Chennai, India from Jan 2007 to June 2007.

SAP BI-BO Experience Details: .

1. BSNL, India. Jan2009 - Feb2010.

Role: Team Member.

Responsibilities:

● Designing ETL Documents for setting up the procedures for extractors.

● Designed the Data Models by using the Performance Indicator’s & Business Objects, starting with

Bubble diagrams and convert them into MDM Data Model (Extended Star Schema), Data Flow diagrams

by doing the GAP analysis on the extractors available from the Source System.

● Involved in LIS, Generic, LO and CO PA Extractors.

● Upgraded the data from SAP BW 3.5 to SAP BI 7.0 to maintain the data consistency.

● Data Loading and Load Monitoring.

● Involved in Debugging the Update rules and transfer rules.

● Uploaded master and transactional data from flat files, SAP BI and SAP R/3.

● Validated data consistency in reporting with Data Target against PSA after loading them to data

targets.

● Involved in mapping of info source with the Data targets using update rules.

● Loaded Data into the ODS Object before transporting the data into the Info Cube.

● Info Package Group Management and Triggering of Event Chains.

● Extracting Master & Transaction Data using Generic Data Sources from OLTP.

● Involved in Info Cube maintenance i.e., Compression, Roll-up.

● Setup the Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management.

● Created custom queries and defined Calculated Key Figures, Restricted Key Figures, Text Variables,

etc. For customized reporting using BEx Analyzer, Designed and developed several workbooks and

global views.

● Created reporting data (Key figure) columns in Hierarchy format to provide drilldown feature.

2. Client: Syndicate Bank Mar2008 – Jan2009.

Role: Team Member

Project description:

The goal of this project is to provide performance reports based on transitional data and historical data to

address client performance questions and to identify areas and opportunities for system improvements.

This system is developed to data mining on based of data gather from there various system. Main goal of

the project to increase the output of bank.

Responsibilities:

● Interacting with customer and collecting the requirements.

● Involved in gathering Functional Requirements.

● Develop Universe Using Business objects XI R3 using SAP BI as back end.

● Creating Reports based on the requirements of the customer using Web Intelligence, also

created the Dashboards..

● Created the users and given the access to the users.

● Created data marts for Reporting.

3. Client: Access Software Leadership team Aug2007 – Mar2008.

Role: Team member

Project description:

This project mainly tracks the metrics and health of each business in Access Software. These businesses

are managed by corporate leaders and are designed to meet the organization objectives/Benchmarks.

Based on the metrics score achieved, each business is given a health status on a periodic basis. In

addition to this, each leader’s performance is assessed by the Top management and necessary

improvement steps are taken after mutual discussions.

Responsibilities:

● Interacting with customer and collecting the requirements for various reports needed.

● Extracting the data from sources like flat files, SAP R3. Maintained the data consistency by

upgrading it from BW 3.5 to BI 7.0 data targets.

● Involved in gathering Functional Requirements.

● Technical Support to the customers for viewing and creating Adhoc reports.

● Analyzed the reporting needs & Using Business Objects, generated reports aligned in

accordance with user specifications, by understanding the system improved the retrieving

performance of the reports.

● Develop Universe Using Business objects XI R3.

● Creating Reports based on the requirements of the customer using Web Intelligence and

Crystal Reports.

● Made changes in the procedure, packages, updation

● Update all the project related documents.

IBM Mainframe Experience Details: .

1. General Motors Corporation. Jan 2007 to June 2007.

Role: Team Member.

Responsibilities:

● Development

● Preparing Test Plan and Test cases

● Executing of Test cases and Recording the Test results

● Cycle Monitoring for Supply Chain Modules

● Remedy report Generation and Remedy Change management

● Working with the project team and the client for establishing achievable requirements

Project Overview:

GM (General Motors Corporation) is the world's biggest automaker company and has been the global

situations across the World. The industry has been sales leader for 75 years. Founded in 1908, GM

manufactures cars and trucks in 33 countries. GM vehicles sold globally under brands like Buick, Cadillac,

Chevrolet, GMC, GM Daewoo, Holden, Hummer,

Opel, Saab, Saturn etc.

The current project is basically a maintenance and support project involving activities like Production

Support for batch jobs, batch monitoring and regular maintenance activities for Jobs and applications

under Supply chain module. Involved as a Team Member for Service Requests, Cycle Monitoring,

Remedy Report Generation and Base Support for the Supply Chain Service Modules.

Education: .

Bachelor of Architecture (B.Arch.). Shivaji University, India.

Contact this candidate