SUMMARY:

• 9 years of experience in design, develop, deploy, and maintenance of reports/solutions with Business Objects Suite of Products.
• Extensively worked on Business Objects 6.x/XI/XI R2/Xi 3.1, Crystal Reports using dynamic SQL, cascading prompts, command SQL, Cross - tab, Conditional, Drill-Down, Summary and Sub reports.
• A good team player, quality conscious with good communication skills, capable of quickly adapting to new challenges and environment.
• Has been playing a role of a team leader responsible for work allocation, tracking progress and providing technical leadership and guidance.
• Excellent communication and presentation skills.
• Extensive experience in coordinating with ETL, Finance and infrastructure teams
• Good understanding of Data modeling concepts.
• Extensive knowledge of Crystal Reports, Xcelcius, Structured Query Language (DDL, DML).
• Good Knowledge of SAP Business Warehousing, Live Office, Query As a web service.
• Worked with versioning and Migration tools like Subversion, CVS, and Lifecycle Manager.
• Good Knowledge in developing Data Models in SAP HANA.
• Understanding and usage of SLT and BODS as HANA replicators.
• Basic knowledge and usage of Cognos Reporting.
• Good Understanding on data extraction, Transformation and loading data using Informatica.

TECHNICAL SKILLS:

• Strong expertise Web Intelligence, Desktop Intelligence, Import Wizard, Universe Designer and Central Management Console.
• Experience in developing Crystal Reports, the Cross Tab Reports, Top N Reports for highlighting significant data, summary reports with drill-down capabilities.
• Experience working with Business Objects XI 3.1,R2/5.1.x/6.x/6.5.1Creating and Managing QlikView Reports & Dashboards.
• Extensive experience in Business Objects Full Client, Supervisor, Designer, Broadcast Agent, Info View and Web Intelligence.
• Understanding of SAP Business Warehouse.
• Created Classes, Objects, Cardinalities, Strategies, and linked the Universes to share the common objects between them.
• Created complex and sophisticated Business Objects Reports that had drilldown, slice and dice features using Business Objects.
• Experience in retrieving data from Business Objects Universes and Personal Data Files.
• Thorough knowledge of scheduling documents using Broadcast Agent.
• Experience with creating hierarchies, predefined conditions, customized Lists of Values, Derived Tables and in using @ functions.
• Designed, implemented and deployed some highly complex Business Objects Universes. Created classes, objects, Cardinalities, Contexts, Joins, External Strategies and Aliases for resolving Loops and checked the Integrity of the Universes.
• Extensively used Central Management Console.
• Experience in creating Repositories, designing Universes, Full Client/WebI reports, publishing and scheduling using Broadcast Agent for publisher and scheduler
• Experience in working with reports where data has been shared across Sub reports.
• Experienced in design, development and maintenance of Reports, Stored Procedures, Views and scheduling the generated reports to be printed/saved at regular intervals.
• Developed various Charts and Graphs like Bar chart (Side By Side, Stacked), Line graphs, Pie charts, and Numeric Axis etc by using Chart expert of Crystal Reports.
• Major responsibilities include getting requirements from the user and developing Crystal Reports and Maintaining proper documentation of the reports for future reference.
• Experience in installation of Business Objects XI Enterprise and configuration of CMS with Oracle 9i, Migration of objects to Business Objects XI from previous versions and conversions of Reports.
• Extensively used Calculation Contexts, Variables, Drill down in making the reports easy for user analysis.
• Excellent understanding of relational database concepts and reporting tools.
• Experience in Oracle 10g/9i/8i, SQL Server, MS Access, SQL, PL/SQL, SQL Plus, Toad, and MS SQL Server, Query Analyzer. Able to write SQL and PL/SQL queries utilizing grouping sets & rollups in order to optimize reporting development.
• Experience working with tools like Peregrene and Remedy and Test Directory.
• Hands on experience in Requirement analysis, Documentation and good understanding of SDLC.
• Strong interpersonal skills, with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.
• Capable of working as an individual as well as a part of team.

PROFESSIONAL EXPERIENCE:

Confidential, Waltham, MA

Business Objects Developer/Crystal Reports Developer

• Redesign and enhance Universes according to new DB tables.
• Design, Develop Crystal reports and Web Intelligence Analysis reports for UptoDate Licence Managemnet system and several other utility reports coming from Licence management datamarts/datasources.
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically

Environment: SAP Business Objects BI 4.1, Oracle 12c,Crystal Reports 2008, SQL Developer 4.0.

Confidential, Wellesley, MA

Business Objects Developer

• Analyze and collect requirements based on existing Cognos reports.
• Design, Develop Universes related to different Packages. Developed over 50 Web Intelligence reports involving some complex reports
• Help set up User and report security. Check of data quality and accuracy before deploying.

Environment: SAP Business Objects BI 4.1, SQL Server 2008, SQL Server Management Studio.

Confidential, Bloomington IL

Business Objects Developer

• Design and develop policy writer Universe representing EDW tables in Information Design Tool.
• Created several Web Intelligence reports containing Policy, Coverage’s and Auto policy Information, active policies and combined coverage reports.
• Enhance and support Common Product Universe which has information related to property policy and Universes from SAP Business Objects 3.1

Environment: SAP Business Objects BI 4.0, DB2, Oracle 11g,Verson 1, SAP Business Objects 3.1, Tableau 8.1.7

Confidential, King Of Prussia, PA

Sr.Business Objects Developer

• Develop and enhance universe and create new web intelligence reports with several functionality and also create highly form Confidential ed web intelligence and crystal reports.
• Worked with customers to create functional and technical documents for the requirements and also help users identify reports requirements.
• Provide Business Objects subject m Confidential er expertise. Plan and manage deployment from Development to Staging to Production
• Validate design with business requirements to ensure completeness of the solution.
• Created end user training documents and provide user support.

Environment: Business Objects XI 3.1, Teradata, Webi rich client, Crystal reports, Oracle 11g, DBVisualizer.

Confidential, Dublin, OH

Sr.Business Objects Consultant

• Develop new universes and support, Enhance/Bug fix issues on existing medical Universes and performance tuning on Business Objects web intelligence reports.
• Worked with users to fix Ad-hoc reports and create new reports based on the requirements.
• Worked on any Business Objects and Teradata incidents logged as Tickets and resolved them within the SLA’s.
• Worked on analysis, identifying problems in reports and fix in SAP Business Objects reports and Universes.
• Worked extensively on Teradata queries to do root cause analysis.
• Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning..
• Developed Web intelligence reports and dashboards, Business Objects Explorer reports for different operations and finance KPI'S like warehouse management, Material management.

Environment: Business Objects 4.0, Business Objects XI 3.1, Teradata, Web Intelligence rich client, OLAP Analysis tool, BO Dashboard Design, Oracle, Clarify, SQL Assistant, SAP HANA 1.0, Business Objects Explorer

Confidential

Lead Business Objects Consultant

• Worked on Enhancement/ new requirement /Bugfix issues on existing Universes and Business Objects web intelligence reports.
• Worked with users to fix Ad-hoc reports and create new reports based on the requirements.
• Write custom SQL queries to support Client applications ‘Credit’ and ‘Emptoris’ Contract management systems.
• Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView.
• Designed and developed extensive QlikView reports using combination of charts and tables.
• Converted SSRS reports to Business Objects Web Intelligence reports.
• Testing Applications, reports using review checklists, Data quality for quality assurance before delivering to the end users.

Environment: Business Objects 3.1, Oracle, TOAD, QlikView 10, Informatica, Service-Now.

Confidential,Confidential, Morgantown, WV

Business Objects Consultant

• Worked with extensively with users on requirement gathering including Analysis, Cutover/Go-Live Planning, User Training, Knowledge Transfer, Deployment, Production Support, Change Control, and Change Management.
• Worked on Design, development of Relational Universes against Oracle data marts.
• Developed 2 Relational Universes from scratch and enhanced and maintained 4 existing relational Universes and Developed SAP OLAP Universes to suit the reporting requirements.
• Detailed Level Documentation for reports and Universe design. Map SAP data to reports and universe specifications and developed SAP BW Queries.
• Train interns to BO developers by attending workshops with users and converting Business requirements to technical specifications, develop Universes, reports and review and approve design documents
• Created the reports using Business Objects functionality’s like Queries, Cross Tab, Master Detail and Formulae’s, Grand totals, Charts etc. Applied slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Created calculated measures in Universe Using MDX functions.
• Documented End to End scenarios for SAP BW integration with Business Objects Web Intelligence, Crystal Reports and Xcelcius.

Environment: Business Objects XI 3.1, Crystal Reports, Live Office, QAAWS,Xcelcius, SAP BW 7.1, Oracle 9.2, SQL Developer, SAP Business Objects BIConfidential, Latrobe, PA

SAP Business Objects Developer

• Detailed Level Documentation for reports and Universe design. Map SAP data to reports and universe specifications and developed SAP BW Queries.
• Involved in the installation of SAP integration Kit with BO XI R2 environment.
• Developed dashboards and scorecards using Xcelcius by direct connectivity to SAP BEX Query.
• Created Web Intelligence, Crystal and Voyager documents on SAP Bex Queries build on Infocubes and Multiproviders.
• Used SAP BW Authorization variable in Web Intelligence document to restrict data as per User security.
• Create URL iView using CUID (Cluster Unique Identifier) to view reports in SAP Enterprise Portal.
• Worked with Business Objects Explorer Simplified Version and also BI Accelerator Version.
• Promoted reports, Universes and Security to different environments using Business Objects Life Cycle Manager(LCM).
• Used The Sub versioning feature of LCM for Version Control integration.
• Created the reports using Business Objects functionality’s like Queries, Cross Tab, Master Detail and Formulae’s, Grand totals, Charts etc. Applied slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Created calculated measures in Universe Using MDX functions.
• Documented End to End scenarios for SAP BW integration with Business Objects Web Intelligence, Crystal Reports and Xcelcius.

Environment: SAP BI 7.1, BO 3.1 SP2, Crystal Reports 2008 SP2, Xcelcius 2008, Live Office

Confidential, Richfield, MN

SAP BI Developer

• Gathered Reporting requirements in the area of Procurement.
• Created the data model in BW to accommodate Purchasing data from Purchase orders Line item, Header and Schedule lines.
• Created Functional and Technical Specifications for Data requirements (Metrics) for Purchasing Analytics.
• Identified Purchasing Datasources, InfoCubes and ODS Objects in Business Content based on Business requirements.
• Present and Understand the Business benefits to Users and prioritize new requirements from Procurement.

Environment: SAP BI 7.1, ECC 6.0

Confidential, New York City, NY

Business Objects Consultant

• Interacted with Business Users and Business Analyst to gather the Requirements and Business logics.
• Created SAP BW OLAP based Universe and WebI documents, extract data from SAP using the SAP Integration Kit.
• Used SAP BW query elements like SAP variables, characteristics, key figures, Query filter, Display and navigational Confidential ributes in Universe.
• Gave demonstration of all WEBI features and Business Objects components to Business Users and Client Technical team.
• Build Universe against SAP Datasources like Infocubes, Multicube and SAP BI Query.
• Use MDX (Multi dimensional expressions) a query language of OLAP system for calculated measures created in Universe.
• Validate new features of BO XI 3.1 like Report Bursting, Optional Prompts.
• Good Familiarity with SAP connectivity with Crystal Reports.
• Provide support to QA testing team to clarify changes and resolve testing issues or bugs.
• Worked on Business Objects web intelligence report Security and Governance approach using Central Management Console.
• Follow-up with Client on various proposed initiatives.
• Created Master Detail, charts and Cross Tab reports.
• Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with Alerter.
• Generated reports for web users using Web Intelligence.
• Scheduled Reports for the use of end users and customers.

Environment: Business Objects 3.1 & SAP BI 7.0

Confidential, Santa Clara, CA

Business Objects Developer

• Developed universes extensively using functions @Aggregate aware, @prompt, @script, @select, @where and @variable for performance.
• Developed complex reports with Business Objects using Drilldown, Slicing and Dicing, Multiple Sections, Section Conditions, Hidings, Ranking, Alerts Reports.
• Developed several Complex Reports, various features include multiple groupings, drilldowns, parameter fields, functions, Type Conversions, formulas, Running Totals and conditional suppressing, form Confidential ing using Crystal Reports.
• Experience with Crystal XCELSIUS for implementing Enterprise Dashboards
• Created Interactive dashboards/graphs using Crystal Xcelsius with Microsoft Excel files as the data provider
• Tracked KPI’s (key performance indicators) by department to create interactive dashboards for higher management using Crystal Xcelsius.
• Managed existing Universes and created Classes and Objects for Supplier Compliance.
• Created Contexts and Aliases for resolving loops and checked the Integrity of the Universes

Environment: Business Objects XI R2, Crystal Reports XI, Xcelcius 4.5

Confidential

Business Objects Developer

• Developed various database objects like Tables, Views and Stored Procedures by using SQL*Plus in SQL Server2000.
• Developing Auto prompts to give end users a choice of different filtering criteria each time they run the report.
• Extensively used Calculations, Variables, Sorting, Drill down, slice and dice, Alerts for creating reports.
• Developed Reports using Business Object XI R2 - Desktop Intelligence, Web-Intelligence.
• Expertise in creating complex universes meant for both complex and adhoc reporting.
• Reports and Universes were migrated from E 6.5.1 to Business Objects XI R2 Environment - Desktop Intelligence Reports, Web Intelligence using the Manual Methods and the Import Wizard.
• Migrated the 6.5.1 Full Client Reports to BO XI-R2 Webi Reports using the Report Conversion Tool.

Environment: Business Objects XI, Crystal Reports XI, Xcelcius 4.5

Confidential

Crystal Reports/SQL

• Developed reports from SQL server 2000 and Crystal reports in some capacity.
• Application Maintenance, like policy changes, fund transfer, incident management, problem handling: identify, document, create reports, classify and analyze the problem, evaluate and fix the error and supports the handling of more involved incidents

Environment: Crystal Reports 9, SQL Server 2000

Project III

Confidential

Business Objects Developer

• Several simple, complex and Ad-hoc reports were created having Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae.
• Established security/accessibility criteria through BO SUPERVISOR.
• Resolved the loops using Aliases and Contexts.

Environment: Oracle 9.2, Business Objects Enterprise 6x Suite (Web Intelligence, BCA, Auditor, Application Foundation), Erwin, Visio.

Confidential

Crystal Reports /BO Developer

• Interacted with the users for understanding and gathering business requirements.
• Created Standard reports, Cross-tab, Sub reports, drill down reports, on demand sub reports.
• Designing and developing Universes for report generation.
• Created the reports using the Universes as the main Data providers..
• Linked universes to work with common objects.

Environment: Business Objects 6.5, Crystal Reports 8.5, Oracle 9.0