SUMMARY

• Accomplished professional with over 8 years of hands on experience in SAP Business Objects 6.5, XI R2, 3.x, 4.x, Crystal Reports XI, Crystal Repots 2008, Data Warehousing, Schema Modeling implemented in the areas of Financial, Banking, Telecom and IT Infrastructure domains and have in - depth business process knowledge.
• Extensive experience as Developer, Sr. Developer, Lead.
• Experience in 4 full life cycle implementation for different modules in SAP Business Objects all modules and methodologies which involves Documentation, Requirement analysis, Gap Analysis, Realization, Data modeling, Unit testing, production Support, End user documentation, Reporting and Go-Live check.
• Experience in Design and Development of Universes using Business Objects Enterprise products namely - Business Objects XI R3/R2, 4.x,Crystal Reports and Xcelsius.
• Worked extensively on Designer, Web Intelligence (Webi), Desktop Intelligence (Deski), Crystal reports, Central Management Console (CMC), Information Design Tool (IDT), Universe Design Tool (UDT), Life Cycle Manager (LCM), Crystal Reports Enterprise.
• Worked extensively on Information Design tool to develop a universe with multiple data sources and developed various Web Intelligence reports on top of this data source.
• Developed various reports using Desktop Intelligence and Web Intelligence using the Universes built.
• Experience in implementing Business Objects report management with Finance, Sales and Marketing, Pharmaceuticals and Retail.
• Extensively used calculations, variables, prompts and sorted inputs, drill down, slice and dice, alerts for creating business objects reports.
• Created different types of reports like Master/Detail, Cross Tab and Chart.
• Designed and Developed extensive Business Objects reports using multiple Queries, combination of chart and tables.
• Imposed several Joins, Filters, and Alerter to restrict the unwanted data and highlight the required data.
• Provided Technical Assistance/Support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
• Created the Universe and report check list templates, which are used as check points before moving the migrated objects into QA and Production environments.
• Good knowledge of SAP HANA
• Worked closely with the Architects to address the performance issues from the server side.
• Created the reports using Crystal Reports functionalities like Add Queries (Command), Sub Reports, Drill down, Cross-Tab, Formulas, Parameters along with Dropdown lists etc.
• Generated reports with complex, business views, ad-hoc reports, dashboards, list of values (LOV) along with user acceptance test (UAT).
• Published Crystal Reports on to Business Objects Infoview and provided access to the end users.
• Expertise in using Import Wizard to migrate reports and universes between different environments like development, testing and production.
• Experience in creating users and user groups, restricted access of the users as needed using Central Management Console (CMC). Involved in managing users, groups, folders and published reports.
• Experience in Star-Schema Modeling, Snowflake Modeling, Fact, Dimension tables and Dimensional modeling.
• Migrated Business Objects environment from Business Objects Enterprise XIR2 to XIR3 and 3.x to 4.x.
• Experienced on creating dashboards using Crystal Xcelsius 2008 by importing data files to create the visualization utilizing QAAWS and Live Office.
• Experienced to support the issues with reports on the crystal enterprise environments.
• Experienced to Sign-Off on the crystal enterprise and Ad-Hoc application after the release.
• Created Executive dashboards for the upper management showing summary metrics for the Key performance Indicators (KPI’s).
• Strong planner and organizer with demonstrated ability to develop business solutions that increase efficiency, productivity, and profitability.
• Created WEBI reports and Crystal reports and deployed them through info view with BW universe as source.
• Resolved performance issues by writing stored procedures and command objects in crystal reports and performed unit testing, system integration testing, and user acceptance testing at various levels.
• Worked on pre-calculated web templates and used control queries to increase the performance of the query and also worked on OLAP.
• Published and scheduled Business Objects Reports to users using Scheduler.
• Built, designed, and tested various levels OLAP and OLTP reporting systems using Business Objects product suite. Strong skills in interfacing Business Objects with Databases like Oracle, Sql Server.

TECHNICAL SKILLS

BO Tools: Business Objects 4.0/3.1/XIR2/6.5/5.1 Reporter, Designer, Supervisor, and Web Intelligence, CMC, IDT, UDT, LCM, Crystal XI R2, 2008, Xcelsius, Crystal Reports Enterprise.

Databases: Oracle 11g/10, MS SQL Server 2005/2008.

Data Warehousing: Star Schema, Snow Flake, Data Modeling

PROFESSIONAL EXPERIENCE

Confidential, CA

IT - Engineer

Responsibilities:

• Working as IT - Specialist Engineer to migrate BOXI 3.1 Web Intelligence Reports to BOXI 4.0 Web Intelligence Reports.
• Gathered Migration Requirement’s to analyze the Web Intelligence Reports, Universe’s and its Connections to Migrate.
• Migrating Canned Reports as well as Adhoc reports to the new BOXI Environment.
• Creation/Deletion and managing, groups, users, folders, objects, servers.
• Security implementation at group and user level.
• Granting appropriate access rights as per requirements.
• Improving Performance of Web Intelligence Reports.
• Transposed the Row Oriented Structure Query to Column Oriented Structure Query to improvise the performance.
• Performed Web Intelligence Report Unit Testing, to validate the Report Data with Database.
• Promoting Migrated Web Intelligence reports to Stage environment to test the functionality and validation of data in Webi reports and move to Production environment.
• Handover of Migrated Reports to Business Users.

Environment: Business Objects3.1/4.0, IDT, WEBI, Designer, Info view, Teradata.

Confidential, NY

Business Objects Lead

Responsibilities:

• Worked as a Lead (Database Analysis, Reports Development, and Meeting Stake Holders to understand their requirements).
• Lead a Team of size 5, handling multiple projects on priority basis.
• Product Integration with BOXI reports.
• Worked on analyzing Data for doing better data modeling.
• PUPM reports are Critical reports in Access Control, as these reports provide the details of all the Privileged Users who can access all the management decision reports.
• Single BIAR approach is the crucial part in the deliverables as we need to maintain the tables and their data types synchronize all the times for both databases.
• Extensively used Information Design Tool (IDT) for developing universe with multiple data sources as PUPM reports data sources are multiple.
• Reports developed using Crystal reports and used subreport functionality of Crystal reports to fulfill the requirements.
• Internationalizing (I18N) locales to Japanese and Korean.
• Identifying all the static strings in each report which need to be internationalized.
• Created tables in database which holds the entire original and target language strings for Internationalization.
• Created a subreport to determine the target language strings as per the original language and created formulas in subreport using shared variables.
• Created formulas in the main report to use the shared variables created in the subreport.
• Synchronizing all the tables for both Oracle and Sql Server Databases
• Provided Single Biar file for both the databases.
• Designing and developing Universes for development of Reports using BO Designer.
• Created Joins in designer and Resolved Loops.
• Created Classes, Objects and Conditional Objects.
• Checked the Integrity of the Universes.
• Created Universes for different departments
• Exported the universes to the Repository making resources available to the users using the BO Designer.
• Created reports using WebI-Infoview.
• Created Alerters, Breaks, Sections, Filters and Drill Analysis.
• Formatted the Reports to the Users requirements using various features of Business Objects.
• Created views to improve the performance of the reports.
• Involved in installation of Business Objects 4.0.
• Involved in performance tuning of the Data Warehouse and identifying the bottlenecks.
• Involved in Training the users in Business Objects and in using the newly developed universe and in Report.
• Involved in data modeling.
• Extensively used the Business Objects functionality such as Master-Detail, Slice and Dice, Drill Down and Hierarchies for creating reports.

Environment: Business Objects3.1/4.0, Crystal Reports 2008, IDT, WEBI, Designer, Info view, SQL, PL/SQL, Oracle11, Windows 2008 and Microsoft SQL Management Studio.

Confidential - Framingham, MA

Business Objects Lead

Responsibilities:

• Lead a Team of size 4 for handling Internationalization and Externalization.
• Internationalizing (I18N) locales to Japan and French and Externalizing UI X12N.
• Identifying all the static strings in each report which need to be Internationalized and all the object types in each report which need to be externalized.
• Created tables in database which holds the entire original and target language strings for Internationalization and all the object types and the properties for externalization.
• Created a subreport to determine the target language strings as per the original language and created Formulas in subreport using shared variables.
• Created formulas in the main report to use the shared variables created in the subreport.
• Synchronizing all the tables for both Oracle and Sql Server Databases
• Provided Single Biar file for both the databases.
• Unit Testing for both I18N - Internationalization and UI X12N - Externalization.
• Interacted with Business Users and Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and dataspecifications for Business Objects Universes and Reports.
• Design and Development of Business Objects Universes, which suits the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Responsible for activities such as conceptual design, detail technical specifications and technical documentation. Partner with Enterprise Architecture and application teams to design Business Objects solutions.
• Played significant role in the design, development, testing, implementation and documentation of solutions.
• Involved in migration strategies from development to test & Production.
• Lead, coordinate, and organize the activities required to properly tune the Business Objects (BO) server environment
• Played significant role in the design, development, testing, implementation and documentation of solutions.
• Installed and deployed the business object 3.1 software in Dev,test and production environments.
• Applied the different levels of group and folder level security.
• Applied the security for sub groups by breaking inheritance and disabling the inheritance.
• Involved in maintenance of Business objects servers and on call support 24/7
• Created the groups/sub groups, users and folders for each module.
• Involved in the gathering requirements of universe and report design.
• Created the class and objects of the universe and according to the user requirement.
• Created the user objects and predefined conditions.
• Created Aliases and Contexts for resolving Loops and checked the Integrity of the Universe.
• Created hyperlinks in summary reports to navigate to detail report
• Created the custom hierarchies for drill down and drill up. created the derived tables in the universe to avoid the creation of views at database level
• Created different error messages and block the popup by using dummy objects.
• Created the WEBI reports on universe.
• Created the desktop reports using desktop intelligence for Users.
• Exported the reports in to PDF & Excel formats.
• Designed and document the test cases for testing team.

Environment: Business Objects3.1/4.0, Crystal Reports 2008, WEBI, Designer, Infoview, SQL, PL/SQL, Oracle11, DB2 and Windows 2008, Microsoft SQL Management Studio.

Confidential, Rochester, MN

Senior Programmer Analyst

Responsibilities:

• Group Lead in entire Migration process of Confidential (MEd’S) and Revenue Cycle (RC) Projects.
• Leading a Team of size 4 on entire migration process from Web Focus to BO XI R3.1
• In-depth analyses of code for migrating Web focus code and Focus code to BO Universe.
• Build up universe based on web focus and focus code.
• Developed crystal reports using the universe.
• Worked Closely with Onsite Team to understand the requirements and resolve issues.
• Responsible for tracking, analyzing and reporting of project performance against plans.
• Created Sub Reports in Crystal 2008.
• Handle daily operations and support and define standards, guidelines, and best practices.
• Conduct on-going tuning and monitoring to maintain and improve the performance and stability of the environment as well as to plan and implement upgrades and migrations.
• Reviewing all deliverable and responsible for all report deliverable On-Time.
• Understanding Client requirement and Standards to provide the Best fit solutions to the Client needs.
• Created Users and roles, granted privileges to role and roles to users according to user level to access data to enforce object level security.
• Implemented Row & Object level security for different user group requirements.
• Defined Aliases and Contexts to resolve the join issues in the Universe.
• Solved the issues during designing such as loops, Cartesian product due to fan trap and chasm traps.
• Exported the universes to the Repository for making resources available to the users.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Built full client and WebI reports, according to end user requirements.
• Created user Prompts, conditions, and filters for various reports to specify the reporting parameters as per business requirements.
• Coding and testing of new reports and mocking up data as necessary.
• Experience in design of data models (3NF, Star Schema, Snow flake schema) and implementation of enterprise data warehouse, data mart and OLAP solution.
• Experience in design of BI process documents, technical specification, templates, standards and best practices.
• Created the new Views and Aggregate tables for report performance.
• Extensive testing and migrating the reports or objects from development to Production system.
• Automated the reports for refreshing the data every month and quarter details.
• Responsible for giving Business Objects classes for the entire staff that was using reports.
• Hide objects for different users to maintain data availability based on Business requirements.
• Analyzed all tables and created various indexes to enhance query performance and written hints in query for tuning the query

Environment: Business Objects3.1, Data Modeling (3NF/OLTP, Star Schema, DWH/BI, etc.), Crystal Reports 2008, WEBI, DESKI, Designer, Infoview, Toad 8.6.1, Web Focus and Windows 2008.

Confidential

Application Developer

Responsibilities:

• Analyzed the Database to create the universe as per the Client requirements.
• Analyzed the data and provided the information for creating the materialized views and provided the information for creating Indexes on the Parent ID's for Better Performance.
• Created the Universes as per the Client requirements.
• Developed and created classes with Dimension, Detail & Measure Objects and Specified the Custom hierarchies
• Resolved the Loops using Aliases and Contexts.
• Created the custom Hierarchies based on business requirements.
• Developed Universe Design Documentation and Report Specification Documentation of IMart BI Standard Reports
• Worked Extensively in Creating Profile’s and Publishing the Web Intelligence Report’s in CMC
• Cross-tab report functions are used for viewing data in different perspectives.
• Prompts are used in the reports as well as in the Universe to create more Interactive reports.
• Created pie, Line graph, and 3D Graphs in reports for graphical representation.
• Written 1BC Telemedia and Mobility Aggregate Scripts in DB2, based on the Business requirements and Business Logic provided by the Business User.
• Loaded data into Fact Tables which are used for developing 1 BC Telemedia and Mobility Reports.
• Done Testing on all the Fact Tables for Data Accuracy.
• Catch up Plan is done for Six Months.
• UAT for 1 BC Telemedia and Mobility Reports Completed Successfully and 1 BC Telemedia and Mobility reports are product ionized.
• Worked on deploying the developed reports from Development to Test and from Test to Production.
• Formatted the reports based on the Client requirements.
• Provided KT (Knowledge Transfer) of DB2 1BC Aggregate Scripts and Handed Over the Aggregate Scripts and 1BC Telemedia and Mobility Reports to the Operations Team.
• Provided Training of Business Objects 6.5 to the Internal Team.
• Visited APO (Airtel President Office) of BHARTI and Trained Business Objects 6.5 to BHARTI User’s.
• Providing Support for productionized reports of 1 BC Telemedia and Mobility Reports.

Environment: Business Objects 6.5, 3.1, WEBI, Designer, Infoview, Teradata, DB2 and Windows 2003.

Confidential

Software Developer

Responsibilities:

• Worked at client place to develop the “Profile” reports.
• Studied the existing business rules and understood the client’s new reporting requirements by interacting with the Business managers and users.
• Involved in designing universes and objects by retrieving the data from various data sources and defining the necessary connections.
• Created new reports from the scratch for new requirements and modified some of the existing reports in three different Universes.
• Created new Attributes, Filters and Complex measure objects in the Universe.
• Provided support to the Web Users and Full client users for any specific or performance issues related to the reports.
• Developed the Daily Reports and Financial Reports using Business Objects XI and Crystal Report XI
• Cross-tab report functions are used for viewing data in different perspectives.
• Prompts are used in the reports as well as in the Universe to create more interactive reports.
• Created Sub Reports in Crystal XI for Drill down analysis.
• Created Cross tab reports in Business Objects XI and Crystal XI for data analysis.
• Created pie, Line graph, histogram, horizontal/vertical and 3D Graphs in reports for graphical representation.
• Worked in CMC for creating the Groups/Users, and providing the Logins and Access to the users.
• Worked in CMC for scheduling the reports and sending the final output to the Client through Email.
• Resolved Loops, Fan traps and Chasm traps with Aliases and Contexts.
• Creating Measure objects and hierarchies to enable drill down functionality in the reports.
• Created custom LOV’s and Hierarchies for easy user selection drill down purposes.
• Exported the Universe/Reports to the Repository/Broadcast Agent for automation.
• Worked on the SQL tuning and optimization of the Business Objects reports
• Worked with multiple Data providers in a report and added slice and dice capabilities.
• Extensively used various techniques Sectioning, Ranking, and Filtering to develop the reports.
• Developed Cross-Tab and Drill Down reports.
• Used Broadcast Agent to schedule the reports.
• Formatted the Reports as per the Users requirements using all the facilities in Business Objects, which allows the users to analyze the data.
• Exported the reports in to PDF, Excel and Word formats.
• Extensive testing and migrating the reports or objects from Test to Production system.
• Worked along with the testing team to derive test cases for efficient Data reporting.
• Conducted the Unit testing and prepared the testing document and creating the error log document.
• Performed the knowledge transfer to other team members. Provided application and user on-call support

Environment: Business Objects 6.5, XIr2, Oracle 9i, PL/SQL, and Windows 2003

Confidential

Software Developer

Responsibilities:

• Gathered reporting requirements from the requestor and shared report options with the requestor.
• Created mock-up reports for review.
• Prepared time estimates for all Crystal reports developed.
• Supported, modified and maintained Crystal reports that are currently in production.
• Responded expediently for requests to create, modify and fix reports.
• Developed complex, production-level reports.
• Designed and created reports based on technical specifications provided.
• Mapped data between Crystal Reports and the Enterprise Data Warehouse.
• Use prompts, alerts, drill down analysis as per the end user requirements.
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV
• Translated end user reporting requirements into technical design documents.

Environment: Crystal Reports XIr2, MS Access, MS SQL and Excel.