SUMMARY

• More than 4 years of experience in Business Intelligence tools using Business Objects 4.0, XI 3.1, XIR2,Universe Design, BOBJ Administration, Web Intelligence (WEBI), Crystal Reports for Enterprise edition, Analysis for OLAP, Xcelsius. Excellent understanding on RDBMS.Strong experience in interfacing Business Objects with databases like Oracle, SQL Server, Teradata and SAP.
• Strong experience in requirement gathering, design, technical analysis, development and Testing for BFSI (banking, Financial Services and insurance), Media and Entertainment, MIS, Healthcare.
• Expertise in performing end to end requirement gathering from business users and owners.
• Performed role of providing technical solutions based on requirements gathered.
• Good understanding in Data Warehouse design using Star and Snowflake schemas.
• Develop business critical reports in WEBI and Crystal reports for Enterprise edition.
• Develop reports and Universe on SAP BW systems.
• Central Management Console (CMC) Administration - maintain access levels and security.
• Report migration using Promotion Management and LCM.
• Expertise in executing data accuracy tests for the reports.
• Demonstrated worthy skills to write test cases, test plans and execution of test cases using HP Quality Center
• Well versed with SDLC process which includes Analysis, Designing, Developing, Testing and Implementation. ITIL V3 certified.

TECHNICAL SKILLS

Enterprise Business Intelligence Tools: SAP Business objects 4.0, XI R2,XIR3.1(CMC, Designer),SAP BI 7.0

Reporting Tools: Web Intelligence, Crystal Reports for Enterprise 4,Analysis for OLAP, SAP Business objects Dashboards 4

Languages, Web Technologies: PL SQL, ASP.Net, C#, HTML, JavaScript Jelly

RDBMS: SQL Server 2000/2005, Oracle, Teradata, DB2

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Responsible to maintain Universe and create Business critical Reports.
• Developed Webi reports and dashboards for different operations and finance KPI'S like Project planning and estimation.
• Apply fixes in the Reports and create Ad-hoc Reports to the users as per the Requirement.
• Performed back-end testing on the Oracle database by writing SQL queries
• Performed Data validation to verify the data extracts and record counts in the database tables.
• Migration of Report from one environment to another using LCM and creating Promotion jobs and LCM Biar backups.
• Involved in the access for BO Environment involving LDAP creation ID and giving Group level access to users for Info view through CMC.
• Involved in the Creation of Competitive Landscape Report which had the use of Alters, previous month and Current Month’s Amount Financials in the same Report
• Creation of reports like Reports by Period, Forecast, Demographic reports and Comparative Reports.
• Involved in Creation of custom reports like Gross Margin, Account Query, Aging, Balance Sheet, Income Statement, and Payment Reports in response to user needs.
• Prepared month-end reports for General Ledger, Net Investment, Interest, Fees and Incomes
• Extensively used Calculations, Variables, Breaks, Sorting, Drill down, Slice and Dice, Alerts, Ranking, Filtering for creating Business Objects reports.

Confidential

Responsibilities:

• Working as a SAP BI Consultant provide BI solutions to AmerisourceBergen
• Involved in creating reports built on SAP BW 7.0 system by accessing BEX Queries through BI Launch Pad
• Created Reports showing the sales of various Drug products in a particular Year, Quarter and Month and All Plants Distribution Report.
• Providing 24*7 support to users for their queries and maintaining SLA’s for the same
• Setting up access level security in CMC to give access to users as per their business departments
• Developing new reports on Web-I and helping users to cater to their ad hoc query requirement

Confidential

Responsibilities:

• Module Lead for BO managing a team of three resources to develop Universe and create Business critical Reports.
• Designed the Universe for Billing, Costing Module which pulls the data for billing-Revenue of various projects and their functioning within TCS.
• Created a Revenue and Cost Dashboard in Web Intelligence using drills and hyperlinks to navigate to child Reports by passing parameters.
• Created IOU Profitability dashboard which showed the gross profit/margin, cost and revenue by Operating Unit/Account level in TCS.
• Created Reports using functionalities like drills, cascaded prompts, and formulas, alerter, Prompts, Filters, Ranking, Sections, Graphs and Breaks using Web Intelligence.
• Created reports using Crystal Reports XI with Standard, Cross Tabs, grouping, sub reports, Top N Reports for highlighting significant data, summary reports with drill-down capabilities etc.
• Created canned reports in Crystal reports for enterprise edition using functionalities like grouping of records, sub reports, summary reports etc.
• Demonstrated and created reports-Analysis Workspaces on Analysis edition of OLAP by consuming Analytical view using OLAP Connections (cubes of data).Functionalities explored were creating jumplinks to connect it to Crystal/Webi reports and presented it to users for data Analytics.
• Added/created complex objects, Derived table to the universe to enhance the report functionality.
• Administering the BO activities through CMC and creating Groups and folders.
• Export the Universes to the Repository to make resources available to the users for ad-hoc report needs.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Written test cases for checking the populated data correctly into fact and dimension tables.
• Did the unit testing of the Reports developed and data accuracy test against the database values and records.
• Developed universe user documentation guide for the end users reference.
• Create Universe and Report Checklist to be followed as a baseline for development.

Confidential

SAP BI Consultant

Responsibilities:

• Created Web Intelligence ad-hoc and canned reports as per requirements.
• Creating detailed technical design documentation for all the use cases involved.
• Impact analysis on existing functionality because of any new enhancements.
• Managed security restrictions and access rights using CMC.
• Created Webi Reports which involved data from multi data providers.
• Exported the universes to the Repository to make the Universes available to the users.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, formulas.
• Optimized the usage and performance of reports through objects, conditions and universe level filters
• Organised data in the reports using Filters, Sorting, Ranking, and highlighting data.
• Writing SQL Queries in Teradata SQL developer for backend testing of data in reports.
• Did the Unit Testing of Webi Reports against Database.
• Applied custom Hierarchies and generated cascading prompts in the reports.
• Created Report level variables by using Variable Editor for different calculations involved in P&L Report.
• Provided Production support for published reports.
• Was involved in creating recurring schedules to view the reports in different formats (PDF, Excel) and monitored the Reports adhered to SLA.
• Prepared Report design documents to understand how the reports will work and how to use the functionality step by step.
• Wrote detailed level documentation for reports and universe designs.

Confidential

Responsibilities:

• Design and developed WEBI reports as per Business requirements to analyse the response time of team on several applications.
• Involved in the Designing of Universes.
• Reporting to onsite team and client regarding progress of project by sending out regular Project Scorecards.
• Gained expertise in writing SQL queries.
• Made the changes in the Universe as per requirements.

Confidential

SAP BI Consultant

Responsibilities:

• Involved in the Development of design and functional specifications, producing deliverables related to changes and enhancements with the tool
• Aiding in translating business requirements into technical requirements
• Helping to implement new functionality including configuration and testing
• Experience with IT Service Management, Service Desk, Asset Management and Change Management
• Extensively involved in the development of various enhancements pertaining to different modules and customisation of the same using Business Rules, Client Scripts, UI Policies, UI Actions and Data Policies.
• Ability to perform configurations and customizations of Service-Now applications, e.g. Service Catalog, Incident, Problem and Change Request which are adhere to ITIL Process.
• Managing UAT, Test, Training and Production instances for Service-now
• Service-now performance monitoring and Development of Service Requests
• Ability to create and modify workflows in Incident Management, Problem Management, Change Management and Configuration Item (CMDB)with Service Level Management and/or Service Catalog Management
• Setting up user roles and permissions
• Maintaining List of Values and Lookup Fields
• Scripting adding custom attributes using JavaScript, Glide Record and Query
• Creating UI Pages using Jelly Scripting and XML/HTML
• Perform complex data analysis in support of ad-hoc and standard report requests extracting existing data to manipulate/calculate/format into presentable reports, charts, and graphs