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.

TECHNICAL SKILLS

Reporting Tools: Crystal Reports XI/2008, Business Objects XI R2/3.1(Designer, CMCWeb Intelligence, WebI, Rich Client and Desktop Intelligence), Crystal Enterprise 10.0/9.0, MS Reporting Services 2005/2008 and Xcelsius 2008GUI 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.

PROFESSIONAL EXPERIENCE

Confidential - Cincinnati, OH

Dashboard and Report developer

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

Lead Developer

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, CA

Report Developer

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, NJ

Dashboard Developer

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.