Sree Dhar Email & Phone Number

Environment: Business objects XI 3.X, (Designer, Web Intelligence, XCelsius 2008), SAP BI 7.0, Windows 2003 Server/XP.; Involved in different phases of Software Development Life Cycle (SDLC) like requirements gathering, preparation of technical specification documents, designing and developing reports, Unit Testing and UAT.Created Business Objects Universe using Designer on top of Info Cubes and BW Queries.Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.Worked on Hierarchy Levels and Developed hierarchies to support drill down reports.Designing, developing and deploying using Universe Designer, Web Intelligence Info View, Desktop Intelligence, Info View and CMC.Created reports using Web Intelligence tools with Business Objects Universe as the Data provider. Extensively used Web Intelligence reporting functionalities such as Filters, Ranking, Breaks, Formulas, Variables, Alerts and Tracking etc.Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups and Created Adhoc Reports by accessing the universe. Scheduled daily, weekly and monthly company turnover reports of Web Intelligence as per the business requirements.Extensively created reports with Charts (bar chart, Pie chart. etc), Cross-tabs and sub reports. Created an interactive graph and speedometer for donors at different regions by XCelsius 2008.Developed Xcelsius interactive Dashboards using Column chart and Ticker to show interactiveness between weekly sales by branch to that of target sales.Created Xcelsius dashboards using Query as a web service (QAAWS).Exported Xcelsius visualizations using options like PDF, Word and Power Point.

Limited is one of the leading oil exploration and production company with an exciting growth portfolio of assets in India. The company operates the largest producing oil field in the Indian private sector and has pioneered the use of cutting-edge technology to extend production life. Today Cairn has a world-class resource base with an interest in 14 blocks in India.

Technologies: Business objects XI 3.X (Designer, Webi, Deski, Crystal Reports), SAP BW 3.5, Windows 2003 Server/XP.; Responsibilities Gathering requirements from users and designing reports as per the business requirements.Designed a universe using alias and contexts as per the report requirement.Involved in creating and publishing reports on the web using the Info View in Web Intelligence.Created various simple and complex reports using drill down/up, slice and dice, breaks, filters and alerts.Created Classes and Objects taking the information from the database. Also created measured objects. Conducted Performance tuning of Universes for time management purpose by creating alternate views and indexes.Scheduling the documents and distributing them using CMC and monitoring them.Exported the universes to the Repository to make the resources available to the users.Developed Webi reports for various business needs and formatted reports, generated charts as per user requirements.Modify the format and structures according to the end-user requirements.Validated the data of reports by writing SQL queries.Conducted meetings with management and user community to understand their requirements and convert Business requirements into technical specificationsProject#3Dmart stores opened in the year 2000 out of a 'mom and pop' shop in Washington, DC. Their local success allowed them to expand to serve customers through out the U.S and Canada. Its turnover for the business is $ 7.6 billion.Client: Dmart, USA.Technologies: SAP R/3 4.7, BW 3.5Description: Support project

Lafarge Roofing is the world leader in building materials, with top ranking positions in all of its businesses. It is the leading roofing material supplier in the Nordic market.

ResponsibilitiesMonitoring data loads which were scheduled for hourly, daily and weekly basis, while solving any errors encountered while loading data into BW from different source and informing the same to the users.Data is loaded from SAP systems through existing process chains and info packages into BW.Removing the process chains from schedule during the weekends whenever the server is down and rescheduling it.Extracted data into Info cube, ODS, LO-Cockpit data sources from SAP source systems using process chains.Updated data through PSA for Info cube using Delta, Full update.Updated data from ODS to Info cube using with Delta update. Created Transfer rules, Communication structures, update rules.Created Data sources, Info sources, Info packages for scheduling and monitoring the data extraction.Created Aggregates on Info cubes, Line item dimensions while doing extractions for improving the performance.Set up periodic jobs for delta-data uploads, generated reports using Bex Analyzer.

established in 1949 surges ahead to establish itself as a reputed Industrial conglomerate with a wide range portfolio from Spinning; Technologies: SAP R/3, BW 3.5Description: Support project; ResponsibilitiesIn case of data load failures, involved in analyzing the errors, and took corrective actions.Involved in handling CR (Customer Request).Monitoring the data made available in the Web Interface, after the data was loaded, either from flat files or using scheduled extraction programs, on a daily basis. Used PSA for checking data quality before loading and BW monitor for troubleshooting during ETL. Created ODS objects, loaded them with data and then into Info Cubes. Always solved the tickets within the SLA (Service Level Agreement).Scheduled extract jobs with BW Scheduler and monitored transfer/update of data loads into Info Cubes with BW Monitor.As a VB/SQL ProgrammerProject Name : Municipal e-Governance System. (MeGS)Client : Govt. of Maharashtra.Platform : Windows 2000, Visual Basic-6.0, SQL Server, Crystal Reports

PROJECT # 1