Summary :

• Over 6.5 years of experience in Information technolgy with strong work experience as Business Objects Developer.
• Extensive experience in Analysis, Design, Development, Implementation, Deployment and maintenance of Business Intelligence applications.
• Knowledge of Datawarehouse Concepts and metholodies.
• Expertise in Business Objects enterprise Products Universe Designer, Desktop Intelligence, Web Intelligence, Info View, CMS, CMC CCM and its deployment
• Expertise in identification of Business and Data requirements and converting them into conceptual and logical data models.
• Experience in building and retrieving data using Universes, Personal data files, and creating complex ad-hoc Reports using the Business Objects suite applications.
• Extensively used advanced reporting functionalities such as Master Detailed,Drill, Filters, Ranking, Sections, Graphs and Breaks.
• Hands-on experience in developing Analytical Dashboards using Xcelsius withQaaWS and Live Office connectivity.
• Strong database experience in using Oracle 10g/9i/8i, MS SQL Server 2008/2005, MS Access
• Exposure to Dimensional Data modeling- Star Schema modeling andSnowflake modeling.
• Participated in all phases of Software Development Life Cycle SDLC Requirement Analysis, Design, Development, Testing and Documentation .
• Possess excellent communication, decision-making, Problem Solving, Analytical, and Interpersonal skills with result oriented dedication towards goals. Capable of working as a Team Member or Individually with minimum supervision.

Technical Summary:

Experience :

Confidential

Role: Sr.Business Objects Developer

Responsibilities:

• Inventory, Accounts Payable and Purchase Orders were the different subject areas within the data warehouse.
• Used advanced universe functionalities like Derived tables, Index Awareness, custom LOVs.
• Created custom hierarchies to aid in Drill-Through analysis of WebI documents and built cascading prompts.
• Participated in the complete development lifecycle: analysis, design, build and test reports
• Created several complex Web Intelligence and Desktop Intelligence reports to help management to track and monitor contract, commodity and price compliance.
• Created reports linking several universes for different subject areas like Purchase Orders, Accounts Payable, Pharmacy and Inventory for seamless reporting.
• Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report. Extensively used Calculations, Variables, User Objects in the creation of reports.
• Created User Prompts, Conditions and Filters to improve the quality of report generation.
• Scheduled Reports using scheduler Infoview as well as CMC.
• Key metrics 'procure to pay cycle times', 'diversity spend', 'cash discounts captured and missed' spanning across different subject areas has been re-created using Xcelsius.
• Consolidation of reports by groups/regions and designing templates catering to the needs of sourcing/financial analysts material and cost specialists.

Providing support for the users on application usage and conducting training walk through of salient features of the application.

Environment: Oracle 10G, Business Objects XI 4.0/3.1, Web Intelligence and Infoview XI R2, Desktop Intelligence, CMC, Import Wizard, Universe Designer, PL/SQL Developer, Windows 2003 advanced server.

Confidential

Role: Business Objects Developer

Responsibilities:

• Gathered requirements from users and documented it as mockup reports and technical specification documents.
• Actively interacted with various functional groups, project teams and other stakeholders to effectively understand the business requirements and create documentation.
• Refined data findings and interpret again to drive data-based insight.
• Provided guidance on what data to capture how to map data needs to business questions.
• Held meetings with internal and external teams business, QA, dev, vendor to drive consensus across business and system needs.
• Created process flow diagrams and use cases.
• Created business requirement document and Functional specification document and got sign-off from various stakeholders.
• Engaged in JAD sessions with development team and involved in User Acceptance Testing.
• Involved in deployment of various releases and bug fixes.
• Designed Libraries and Report Templates which is used by other reports
• Created new reports, Master Detail Reports and Parameterized Reports using Sequential, Conditional, Group and Parallel Reports sections
• Extensively worked on Page Level Security, Data filter, Combined Data Stream, Data Sorter and other objects
• Published Crystal Reports on to Business Objects Infoview and provided access to the end users.
• Created User test cases and ran SQL to test report values and to reconcile values of our reports with existing operations report.
• Created test scripts for testing reports.
• Created presentations to discuss the process flow and mockup reports.
• Created training guide for end users.
• Used Remedy tool Remedy Incident Management and Service Management.
• Worked in a matrix environment wherein teams where present in an onsite-offshore model.

Environment: Business Objects XIR3.1,BO 4.0, MS-Excel, Oracle 10g.

Confidential

Role: Business Objects Consultant

Responsibilities:

• Interacted with Business Users, Business owners to know their Business requirements in developing and modifying Universes and Reports accordingly.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Working on the SQL tuning and optimization of the Business Objects reports.
• Applied security features of Business Objects like row level, report level object level security in the universe so as to make the sensitive data secure.
• Designed and maintained complex Universes, resolved loops by creating aliases and contexts.
• Exported the ad-hoc ready universes to the for making semantic layeravailable to the users.
• Extensively used the functions and Aggregate Aware feature. Worked on back end views, tables required by the business objects universes.
• Created and defined the Hierarchies for various reports based on the Business rule of the Organization.
• Created Xcelsius dashboard for executive view covering selected KPI for the business function
• Created WSDLs using Query As a Web Service QaaWS from different Data sources.
• Migrated Xcelsius dashboards and deployed QaaWS to the new servers and fixed the hyperlinks and excel spreadsheet to be compatible in new environment.
• Troubleshoot errors for reports, dashboards, and universes. Fixed them to work as per the business needs.
• Created complex reports by linking data from multiple data providers, stored procedures and functionalities like Union Queries, Drill Down, Master Detail, Custom Sorts etc.
• Extensively worked with Ranks, Alerter, filters, prompts, variables and calculation contexts in designing reports.
• Built WebI reports Provided OLAP functionality and worked extensively with data warehousing.
• Set up groups and users for Business Objects deployment.
• Created the Web Intelligence Report and used Events for Daily/Weekly /Monthly Scheduling of the reports.
• Extensive testing and migrating the reports or objects from development to Production system.
• Developed testing scripts and test cases. Extensively tested Business Objects reports, dashboards and other Business Objects Applications in new environment.
• Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.

Environment: Business Objects XIR3.1, WebI, Xcelsius, Universe Designer, Oracle 8i/9i, PL/SQL, Windows XP/7.

Confidential

Role: Business Objects Reporting Developer

Responsibilities:

• Actively involved in requirement gathering sessions and created necessary documentation for the technical audiences' in-order to develop the reports.
• Created source to target mappings and provided pseudo-SQL and transformation logic for various report elements.
• Worked with internal business partners and cross functional teams ETL Informatica to prepare and maintain a seamless execution of BAT/UAT activities.
• Created documentation for use cases and technical specifications.
• Created the BRD and FSD and got it validated from the Business.
• Created User test cases and ran SQL to test report values and to reconcile values of our reports with existing operations report
• Worked in Onsite-offshore model.

Environment: Business Objects 3.0, SQL, MS-Excel, Erwin

Confidential

Role: BO Analyst/Requirements Analyst

Responsibilities:

• Responsible for requirements gathering for creation of reports and Universes and conducted gap analysis between requirements and existing Universes.
• Tuned SQL to improve the performance of report execution.
• Created both static and dynamic dashboards using Xcelsius.
• Planned and designed web services using QAAWS to feed Xcelsius as a data provider.
• Extensively used Live Office to import web Intelligence documents to Excel and created Dashboards using Xcelsius.
• Created periodical reports: daily, weekly, monthly, quarterly, annual reports

Environment: Business Objects XIR2, Xcelsius 2008, CMS, Ms-Excel, Oracle10g, SQL, PL/SQL, Apache Tomcat Server