Current Location: / Pune
Preferred Location/Relocation: / Bangalore
Current Salary per month: / 8.24 LPA
Expected Salary per month: / 9.5 LPA
Email Confirmation on Salary: / N
Notice Period: / 1 Month (Negotiable for 20 Days)
Total Exp: / 5
Relevant Exp: / 4
Current Employment (Cont/FT): / FT
Resume Formatted (Y/N): / Y
F2F Interview (If Required): / Y
Attitude (Good/ Excellent/ Bad): / Good
Team Mgmt (Y/N): / N
References Provided (Y/N): / N
Recruiter / Vinay
BHASKAR
Mobile: +91-9922994988
Pune, India
SUMMARY:
● Around 5 years of Experience in Business Intelligence with SAP-BOBJ/BOXI.
● Extensively used BOBJ XI R2 & 3.1 Products (CMC, Designer, Web-I, Deski, Xcelsius ,Crystal Reports and Import wizard)
● Experience in Design, development, Testing, Support, and Implementation phases of DW-BI projects.
● Diversified experience in BO-Testing and implementation of Universe and Reports.
● Good Exp. in creating Reports & Dashboards design by using Xcelsius and CR.
● SQL proficiency in database programming using Oracle, SQL Server
● Good exposure in ETL process by using Informatica.
● Having Onsite experience in Abu Dhabi and Singapore
● Experience in SAP Integration and develop the reports by using SAP Data source.
● Team player with the ability to communicate effectively at all levels of the development process.
EXPERIENCE:
● Working as Sr. IT Consultant for FUJITSU Consulting, PUNE,from Dec-2010.
● Worked as Software Engineer for MELSTAR InfoTech Ltd, Bangalore.
● Worked as BO Consultant for INFOSTEP Pvt. Ltd, Hyderabad.
● Worked as DWH Consultant for TRIGYN Technologies Ltd, Mumbai.
EDUCATION:
● B.COM (Computer Applications) from KAKATIYA University, AP, India.
TECHNICAL SKILLS:
DW-BI Tools / : / SAP BO, BOXI-R2,3.1 and 4.0, Xcelsius, Crystal Reports.DW-ETL / : / Informatica and DataStage.
Databases
/ : / Oracle 9i/10g, MS-SQL ServerProgramming / : / SQL/PLSQL, Visual Basic, Html
Operating systems / : / Windows 2k/XP/NT
Other tools / : / Ms-Excel, Toad, Adobe Photoshop and Flash
Project: 1
Title : BOBJ-CRM offshore support.
Client : Thomson Reuters, London, UK.
Environment : BO XI 3.1, Oracle 10g, Informatica, Siebel CRM, Windows
Role : BOBJ Consultant.
Duration : Mar-2011 to Nov-2011.
Description:
Thomson Reuters is the leader in market research and financial services. They are using Seibel CRM for the customer service provider and the transactional data is loading in to oracle data mart by using Informatica-ETL tool, the reporting functionality is enabling the business users by using BOBJ Reporting Tool for Analysis of Business data. Fujitsu India is providing the offshore support to the development and maintenance to the BOXI servers and Users for EDW Reporting process.
Responsibilities:
● Involved as a BOBJ support team member by using ticketing system (ISQ, SM7).
● Resolving issues like… Servers, database connections, Universe issues, Report issues as per the requirement and priority.
● Creating users and giving privileges to the user and groups
● Interacting with end users and development team for resolving the issues.
● Involved Migration activities to moving the BOXI data from one environment to another environment.
● Involving monthly BIAR file backup activities by using Import wizard.
● Communicate issues and be actively involved in resolving issues during development.
● Involved in monitoring the servers and improve quality of end users reporting.
Project: 2
Title : SAP-BO Reports Implementation.
Client : Arkan, Abudhabi.
Environment : BO XI 3.1, SAP BI 7.1, Xcelsius-2008, Windows
Role : BOBJ Consultant.
Duration : Dec-2010 to Feb-2011.
Description:
BI-BOBJ is providing data warehousing functionality enabling Arkan for Reporting, Analysis of Business data relevant to business information from productive SAP applications and all operational external data sources can be integrated with BI and BO for EDW Reporting.
Responsibilities:
● Designing of Universe by Using SAP data source (Infocube and Bex Queries)
● Design and Develop the WEBI reports and Xcelsius Dashboards.
● Generating various types of repots like tabular reports and crosstab reports
● Communicate issues and be actively involved in resolving issues during development
● Involved in Support operation and improve quality of the reports
Project: 3
Title : Opportunity and Revenue Analysis System.
Client : Adobe Global.
Environment : BO XI 3.1, Oracle10g, Windows
Role : SAP-BO Engineer.
Duration : Jul 2010 to Dec-2010.
Description:
Adobe is a huge software product Development Company. We have different software products including a wide range like Creative graphic suites and adobe flash player, entertainment, media products etc. The company has a massive distribution network of warehouse, distributors and retail stores.
The challenge was to develop a system fully automate the Integrated data warehouse building process. Data is extracted from various sources from all branches. This transformed data is loaded into a single database Oracle-EDW, which is maintained as a Data warehouse for the whole company. The main objective of this project is to help the senior and middle level management of the organization to improve the product sales and get knowledge of the new business opportunities.
Responsibilities:
● Designing and enhancement of Universe and develop the WEBI reports.
● Generating various types of repots like tabular reports and crosstab reports.
● Created row level security in the Universe as per business requirements.
● Communicate issues and be actively involved in resolving issues during development.
● Involved in functional testing of the Universe and Reports.
● Prepared test cases for testing of the Universe and WEBI Reports
● Involved in Support operation and improve quality of the reports
Project: 4
Title : Enterprise Banking.
Client : HDFC Bank.
Environment : BOXI-R2, Xcelsius, Oracle 9i, Windows 2003 Server
Duration : Jan 2009 to Feb 2010
Role : BO Consultant
Description:
The project is for a Banking company which is involved in disbursal loan amount for various purposes like Personal loan, Vehicle loan, Housing loan, Consumer durable loans etc. The company requires different levels of analysis regarding loan amount, type of customers, type of payment schedules, interest rates (variable or fixed), defaulter list and penal interest calculation, etc. The Data warehouse captures data from their transactional database maintained under client/server architecture.
Responsibilities:
● Designing of Universe and development of webi reports.
● Involved in migrating universes and Reports from Dev environment to test and then production after UAT (user acceptance testing)
● Involved in Creating Dashboards by using Crystal Xcelsius
● Design and develop the dynamic and static dashboards by using Xcelsius.
● Used query as web service and live office for creating dynamic dashboards.
● Involved in testing of the BO Universes and Reports.
Project: 5
Title : HRMS Reporting
Client : GASCO-Abudhabi-UAE.
Environment : BOXI-R2, SQL Server 2005, Windows
Duration : June 2008 to Dec 2008
Role : BO Consultant
Description:
The Human Resources Management System is a generalized package that will suit any type of Organization. HRMS is a combination of Human Resource Development package and payroll package. The personal information Systems maintains the Employee data like personal data, family details, number of language known, present of permanent address, educational qualifications, expertise areas, previous experience etc.
Created and generated web-I reports based on the above points the performance of each and every employee in the organization, the Promotions, transfers and punishments will be given.
Responsibilities:
● Enhance and developing Universe & Web-I Reports
● Developed Hierarchies to support drill down reports
● Used drill mode and slice and dice mode in reports.
● Created Master details and tabular reports.
● Used different filters, formulas, ranking and alerts in the Reports.
● Giving training and supporting to the business users.
● Involved in the Unit testing of the reports
Project: 6
Title : Integrated DWH
Client : DPKO-United Nations, New York
Environment : BOXI-R2, Informatica, SQL Server-2000, Windows
Duration : July 2007 to April 2008
Role : DWH Consultant
Description:
UN-DPKO uses different Information Systems (IS) of operational and analytical nature for managing its business process. Some of these systems are centralized and hosted from central locations at New York, Brindisi-Italy and some of them are distributed in nature and are operated from various field missions and UN offices throughout of the world. Brindisi, Italy is a Logistics Base (UNLB) for UN, which is responsible for collection of data from all UN field missions spread throughout the world.
The Integrated Data Warehouse will be designed and built by using industry standard data warehouse methodologies and design patterns. The data is extracted from different sources using ETL tool Informatica and loaded to final warehousing schema. Using Business Objects we pullout data from final Data warehousing and Design Universes and create various kind of Reports
Responsibilities:
● Design and Developing Webi and desktop Reports
● Created Webi reports by using multiple data providers
● Involved in ETL development analyzed the sources, targets, transformed the data and loading the data into target database by using Informatica.
● Used transformations like Source Qualifier, Expression, Aggregator, Filter, Router, Sorter, Joiner, and Update Strategy.
● Involved in the Unit Testing
Project: 7
Title : Telecom CRM.
Client : T- Mobile, USA.
Environment : BOXI-R2, Oracle 9i, Crystal Reports, Windows NT.
Role : DWH Consultant
Duration : Nov-2006 to June-2007
Description:
T- Mobile provide Telecommunication services it offers Mobile telephone services, domestic long distance services, international voice services, and data transmission services, as well as other value-added services.
Customer Relationship Management projects consists of three modules Customer, Billing and Service Order. Customer Universe holds the information about the customers having different classes. Classes contain information about services like Basic, Internet, Voicemail, Call forwarding etc. Designed Universes for Customer and Billing modules, as well as generating various reports according to end user requirements.
Responsibilities:
● Enhancement of the Universe by using designer
● Design and develop the Web-I Reports
● Created crystal Reports using different charts and graphs
● Used different parameters, formulas in the crystal reports.
● Involved in the Unit Testing.
+91-9922994988