Summary:

• About 5 years of SAP BI/BO Consultant with wide experience in development/implementation and support of SAP BI-BO reporting solutions.
• Strong experience in SAP methodologies and reporting skills.
• Experience in all the phases of Software Development Life Cycle (SDLC) such as requirements gathering, analysis, designing, development, testing and documentation of SAP reporting applications.
• Expertise in various business objects tools like Business Objects Enterprise XI 3.1 Web Intelligence, Universe Designer, Crystal Report 2008, and Xcelsius 2008.
• Strong understanding of the upcoming SAP Business objects 4.0 landscapes.
• Worked extensively on creation/maintenance of universe (on SAP Multi dimensional structure), Creating WebI Reports, variables, detail and dimension object, merging of queries from different SAP as well as non SAP data providers.
• Extensively used Business Objects reporting functionalities such as Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks
• Exposure to Microsoft Business Intelligence (MS BI) and BO Xcelsius technology for dashboard reporting.
• Experienced with transformations, Start routine, End routine and data flow processes to transfer data to BI 7.0 System.
• Coordinated with the Functional Consultants and Technical Consultant for clients Requirements.
• Experience includes understanding customer requirements, system landscape, and existing business processes.
• Strong inter-personal skills and Team building skills, ability to carry out work around and motivate team to achieve the deliverables in the given time.

Education: Bachelor of Science in Electrical Engineering

Certification: SAPCertified Application Associate- Business Intelligence with SAP NetWeaver 7.0

Technical Skills:

Reporting Tools: Crystal Reports XI/2008, Business Objects XI R2/3.1(Designer, CMC, Web Intelligence, WebI, Rich Client and Desktop Intelligence), Crystal Enterprise 10.0/9.0, MS Reporting Services 2005/2008 and Xcelsius 2008, GUI Visual Basic 6.0, VB.NET Databases: MS SQL Server 2000/2005/2008, DB2, Oracle10g/11g, MS-Access 2003/2007/2010 Operating Systems: Windows 7 Professional/XP/2000/98, UNIX Languages: VBScript, JavaScript, C, C++, T-SQL, PL/SQL.

Experience Summary:

Confidential- Cincinnati, OH 01/2011 -06/2012 Role: Dashboard and Report developer Tools: WebI, Crystal Reports, Xcelsius, BO Explorer, LiveOffice, MS SQL server & SAP BI queries. Description: Full Development Lifecycle starting with gathering of requirements, designing of the Xcelsius dashboard, building the Dashboard and reports using tools like Xcelsius, WEBI, Crystal Reports and BO explorer. Testing of the dashboard with custom test cases & deploying it onto the P&G landscape.

Responsibilities:

• Created BEx queries on InfoCubes with Report to Report Interface facility.
• 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.
• Developed Universe Using Business objects XI 3.1 and solved the performance issues in existing Universes.
• Requirement gathering for the Xcelsius Layout screens.
• Design and development for the Crystal Reports which work as a feed for the dashboard.
• Creating mapping for the data through the Live Office Connectivity option.
• Designing Xcelsius Screens using the build in components like Pie charts, Tabs, Panels, Filters and so on.
• Displaying the components using the Dynamic Visibility logic.
• Developed WebI reports
• Provided links on the dashboard to go directly to the WebI reports for a particular metric.
• Also created reports in BO Explorer, using pre-existing BI queries.

Confidential- Windsor Locks, CT 04/2009 - 10/2010 Role: Lead Developer Tools: Query Designer, QaaWS, LiveOffice, Business Objects - WebI & Crystal Xcelsius. Description: BI Modeling involving development of DSO's Info Cubes and their maintenance. Monitoring of Process Chains & Reporting using Business Objects

Responsibilities:

• Prepared BI Data model designs, configuring custom and delivered BI content, analyzing BI reporting requirements and developing detailed reporting specifications.
• Involved in overall development, testing and maintenance of custom Info Cubes, DSO, InfoSources/DataSources based on reporting requirements.
• Used multiple layers of DSO's to stage the data before transferring the DSO contents to the InfoCube. Data Store object level reporting to give details of deliveries, sales budget, sales forecast, order situation and inventories.
• Worked on Process Chains, User Exits, Function module enhancements, update and transfer rules, and transfer routines as per project requirements.
• Uploaded master and transactional data from flat files and R/3 Source system.
• Worked extensively on administration workbench and Managed and Monitored data loads with full update and Delta mechanism.
• Created Various types of reports like Simple, Drill down Reports, and Grouped Cross Tab using BO for better analysis
• Created Web intelligence reports by using the various business objects functions
• Developed Xcelsius dashboards, based on WebI reports.
• Used Live Office & QaaWS to connect to the WebI Universe and to bring the data into Xcelsius.
• Implemented aggregated data into Crystal Xcelsius and created highly interactive and user friendly dashboards with visual effects.

Confidential - Santa Ana, CA07/2008 - 03/2009 Role: Report Developer Tools: Query Designer, QaaWS, LiveOffice, Business Objects - WebI & Crystal Xcelsius. Description: Integration of historical data from the existing system, upgrade to ECC 6.0 and SAP 7.0 Configuring & Developing reports using BEx and Crystal Xcelsius across 5 departments. Also creating web reports using Web Application Designer

Responsibilities:

• Developed health matrix operational dashboard for Ingram Micro
• Involved in the functional design for the Dashboard KPI's and provided multiple layouts for the design approval.
• Created WebI reports for P2P/OTC and FI reports for base of the dashboard development
• Created reports based on the Date dimension and integrated with each of the WebI reports for daily refresh of the dashboard without manual intervention.
• New universe created on the SAP multi dimensional data provider using designer and worked on the resolution of the connectivity issues and created dimension object in universe used in the merging of queries.
• Tabular WebI reports are created with 16 KPI's in each of the individual tabs for the dashboards
• Created large number of KPI's required for Dashboard in WebI for using formulas, variables, standard business object functions and merging between multiple universes fetching information from different underlying data targets.
• Created recurring scheduling instances in Business object CMC for the daily scheduling of the underlying WebI reports for Dashboard
• Used Live Office to connect to the Scheduled WebI reports to bring the data into Xcelsius.

Confidential - Edison, NJ08/2007 - 05/2008 Role: Dashboard Developer Tools: CMC, Designer, LiveOffice, BusinessObjects - WebI & Crystal Xcelsius. Description: Developing reports& interactive dashboards using BEx and Business Objects reporting tools such as Xcelsius, WebI, Crystal Reports 2008.

Responsibilities:

• Created large number of WebI reports for OTC/P2P area
• Worked extensively on creation/maintenance of universe (on SAP Multi dimensional structure), variables, detail and dimension object, merging of queries from different SAP as well as non SAP data providers.
• Created Various types of reports like Simple, Drill down Reports, and Grouped Cross Tab using BO for better analysis
• Created Web intelligence reports by using the various business objects functions
• Developed Xcelsius dashboards by taking WebI reports as base for designing.
• Used Live Office & QaaWS to connect to the WebI Universe and to bring the data into Xcelsius.
• Implemented aggregated data into Crystal Xcelsius and created highly interactive and user friendly dashboards with visual effects.