SYNOPSIS

• Around 9 years of strong IT experience with focus on Business Intelligence for all kinds of reporting solutions using BusinessObjects Enterprise, SAP BO Explorer, Crystal Reports and Xcelsius in various business domains like Banking/Finance, Logistics, Consumer goods/products.
• Hands on experience in advanced SAP tools like Analysis for OLAP, Analysis for OLAP, Design Studio,
• Involved in heavy interaction with clients/end users, BI teams to analyze Business requirements, gathering reporting needs in order to process Business solutions effectively.
• Solid experience in various versions- BO 4.0, BOXI 3.x/R2/6.x and all BO components- Web Intelligence WEBI , Universe Designer, BI Launch Pad InfoView earlier , Live Office, Xcelsius, Desktop Intelligence, Promotion Manager Import Wizard earlier , Publishing Wizard.
• Experience in working at various levels As Team Lead, Technical Lead coordinating and managing teams at Onsite/Offshore.
• Extensively worked on Designing, Developing BusinessObjects Universes with various functionalities like Aggregate navigation, row level and table level Securities, cascading LOV's.
• Worked heavily on designing Universes comprising of over 45 tables with huge no. of classes objects, resolving loops using Contexts and Alias
• Huge experience in creating Web Intelligence WebI reports for adhoc reporting and publishing them to BusinessObjects Enterprise, migrating/upgrading the reports from BO XI 3.1 to BO 4.1/4.0
• Excellent in Building and Maintaining interactive Dashboards using Crystal Xcelsius with an emphasis on live data services such as XML, Live Office, Query as a Web Service QaaWS and integrated Xcelsius dashboards with other tools like Crystal Reports, Microsoft SharePoint.
• Strong Experience in creating complex reports using Crystal Reports 2008/XI/10.0/8.5 and integrating them with various Web Applications.
• Very good at building custom SQL queries and excellent in performance tuning.
• Strong Exposure to Enterprise Data Warehousing EDW , Strong understanding Data Modeling and very good at Complex Data Analysis, Facts Dimensions and ETL processes.
• Working experience in performing basic DBA activities using BO Administrative tools - Central Management Console CMC , Central Configuration Manager CCM
• Good at Data analysis of huge data sources, studying relationships among data tables to understand the data flow of various Businesses Key for Report Writing.
• Good knowledge and experience in working with various databases like Teradata, SAP BW/BI 7.x, Oracle 10g/9i/8i, MS SQL Server 2005/2000, DB2
• Expertise in designing Complex Crystal Reports including Cross-tab, Conditional, Drill-down/summary, Top/Bottom N, multiple Subreports, Conditional formatting, Summaries and Complex formulae.
• Good at creating Dynamic Cascading prompts, Business Views, List of Values LOV's .
• Expertise in Migrating BO/Crystal Reports from version 6.x or earlier to BOXI R2.
• Played many key roles in various stages- Reports developing, Testing, resolving Production/data issues, Data modeling and complex Data analysis.
• Extensively worked in end-user requirements, business data requirements- studied, analyzed them.
• Extensively involved in migrating reports from Dev Environment to Test, Test to Production and experienced in publishing and scheduling.
• Extensively involved in conducting knowledge transfer sessions to end users.
• Performed extensive Unit Testing for new and existing applications. Involved in Integration Testing, User Acceptance Testing and other test efforts like data validation, data integration before deployment of reports to Production.
• Active team player and as an individual with Excellent Communication, Interpersonal skills, self motivated, fast learner and good listener.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

SAP BO/BI Onsite Lead

Responsibilities

• Performed a role of Onsite Lead for a team of 8 comprising of both SAP BO and BW teams.
• Responsible for overall coordination with Business users and SAP BI team with focus on reports delivery.
• One of the main modules of the project is to convert/migrate many legacy and BEx reports into BO 4.1 tools which included Analysis for Office, WebI Adhoc and Design Studio
• Interacted closely with Functional team and Loves Business users to discuss the optimum strategies for reports delivery using various advanced SAP tools.
• Worked a lot on IDT to create BICS connections on top of BEx queries, which would act as the sources for most of the WebI and Analysis reports.
• Developed BEx queries for WebI reports.
• Analyzed Oracle SQL and PL/SQL procedures and converted them to crystal reports.
• Demonstrated SQL and PL/SQL knowledge including writing complex stored procedures, dynamic SQL, packages functions. Worked with complex SQL including analytic functions, sub queries, correlated sub queries etc.
• Implemented best practices for few complex reports involving multiple BEx queries and various hierarchies.
• Worked closely with BW team to setup critical backend objects, data sources suitable for reporting needs.
• Involved in developing Pilots for SAP BO Explorer, HANA views, Design Studio and Analysis tools and given presentations to explain the abilities and capabilities of these powerful tools on BW and HANA backend.
• Responsible for Onsite-Offshore coordination and status tracking of the deliverables.

Environment: Business Objects 4.1, SAP BI 7.3/7.1, SQL Server, BI LaunchPad, IDT, Query Designer, Crystal Reports for Enterprise 4.0, Promotion Manager, Web Intelligence, Design Studio, Analysis for OLAP/Office

Confidential

SAP BO/BI Lead

Responsibilities

• Involved in heavy interaction with business users in the process of discussing the overall Reporting requirements.
• Designed and developed a Universe with huge chunks of Sales data of various brands to support 25 Web Intelligence reports including hyperlinks, multiple tabs and aggregation at various levels
• Created mockup reports with sample data as per the users reporting needs.
• Report development work involved the creation of reports from SAP BI 7.3 and non-SAP Teradata data sources.
• Developed universes .unx to support almost 20 WebI reports with multiple data providers
• Created BICS connections in IDT and publish them to repository to support most of the WebI reports with BI 7.3 as the backend
• Developed complex Crystal and WebI reports using BICS connections on top of Bex queries.
• Involved in creating new Bex queries and modifying the existing if necessary.
• Migrated/Upgraded a set of 120 WebI reports from BO XI 3.1 to BO 4.0. Tested the reports functionality prior to release
• Developed many Crystal reports with filters, parameters, drill-downs, sub-reports and complex formulae.
• Developed various stored procedures and functions in Oracle 11g Database to improve the performance thus concealing complexity from the front-end application.
• Involved in tuning of Crystal Reports for better performance and worked with PL/SQL and TOAD designed by Quest software for query analysis.
• Analyzed Oracle SQL and PL/SQL procedures and converted them to crystal reports.
• Demonstrated SQL and PL/SQL knowledge including writing complex stored procedures, dynamic SQL, packages andfunctions. Worked with complex SQL including analytic functions, sub queries, correlated sub queries etc.
• Worked heavily on Web Intelligence reports involving multiple tabs, hyperlinks using open doc, event based scheduling etc.
• Coordinate with the report users on periodic basis about the scheduled reports for data validation
• Used Promotion Manager Import Wizard earlier to migrate the reports from Dev box to Quality.
• Involved in production support of many existing WebI scheduled reports
• Trained users in accessing and executing the reports

Environment: BusinessObjects 4.0, SAP BI 7.3/7.1, Teradata, Oracle 11g Database ,BI LaunchPad InfoView , IDT, Crystal Reports for Enterprise 4.0, Promotion Manager, Web Intelligence, Windows Visual Studio Team Foundation Developer's Suite

Confidential

Sr. BO/BI Consultant

Responsibilities

• Involved in high level discussions with business users, BI technical team to understand the requirements needed to setup BO platform at client location
• Involved in successful implementation of BO Enterprise 3.1 with SAP BI 7.1 as backend database supported by Teradata 12.
• Lead an offshore team of 4, assign tasks on bi-weekly basis and review their work regularly.
• Involved in migration of Universes and Reports to BI 4.0 from BO XI 3.1 R3
• Involved in tuning of Crystal Reports for better performance and worked with PL/SQL and TOAD designed by Quest software for query analysis.
• Develop and embed Crystal Reports into MS .Net and ASP.Net applications, schedule the reports based on the user requirements.
• Developed new Universes using Information design tool IDT and created new reports in BI 4.0
• Designed and Developed 2 major universes with over 40 tables by defining necessary Joins, Cardinalities and apply Contexts/Alias to maintain the overall integrity of the Universes
• Created derived tables wherever necessary and used Aggregate navigation for aggregate level calculations like Yearly, Quarterly, Monthly figures
• Analyzed Oracle SQL and PL/SQL procedures and converted them to crystal reports.
• Demonstrated SQL and PL/SQL knowledge including writing complex stored procedures, dynamic SQL, packages andfunctions. Worked with complex SQL including analytic functions, sub queries, correlated sub queries etc.
• Extensively involved in fine tuning of SQL queries to validate the backend data with reports data
• Developed various stored procedures and functions in Oracle 11g Database to improve the performance thus concealing complexity from the front-end application.
• Worked on Data Modeling and built Source to Target STT transformations, data mappings for the Data Warehouse
• Created and maintained BO Universes from BW queries and InfoCubes.
• Implemented Business Intelligence BI program to improve scorecard, Xcelsius dashboard KPIs and analysis capabilities.
• Responsible for supporting reports using BOXI 3.1 interpreting user requests, documenting requirements.
• Followed SAP best practices for BO and generated Custom hierarchies and Cascading list of values and user response filter, smart measures at universe level to improve the query performance.
• Generated Xcelsius dashboard based interactive reports by using Tabset, Trend Analyzer and multiple graph reports like pie, bar, column charts an d published them to the Infoview.
• Involved in applying Securities by object wise in universe and applying object and column wise securities in Universes.
• Generated Hyperlinks in WebI reports and sub reports in crystal reports.
• Experienced with CMC and CMS while configuring authenticating users and groups, and keeping track of the availability of the other Business Objects Enterprise services like system database connections, session tracking etc.
• Fine-tuned the existing universes to enhance their performance by extensively using SQL wherever required.
• Involved in End User Training, Coordinated the migration strategy to move the developed objects across the landscape.

Environment: Business Objects 4.0, BOXI R3.1, Teradata 12, Visual Studio Team Foundation Developer's Suite, BI LaunchPad InfoView , Universe Designer, Oracle 11g Database ,IDT, Web Intelligence, Xcelsius 2008 SP3, Live Office, TFS, Crystal Reports for Enterprise 4.0, Crystal Reports 2008, Unix and Windows

Confidential

BO/BW and Crystal Reports Consultant

Responsibilities

• Gathered the User Requirements and prepared detailed Functional Design Documents and Report design details documents for the Adhoc reporting using WebI.
• Involved in End users and business users meeting in the process of discussing the overall Reporting requirements.
• Helped in preparing the functional specs for all the reports to be build and finalize the reporting requirements, mockups using sample data.
• Involved in very recent migration from BOXI 3.1 to BO 4.0 - Supported in issues related to Universes and reports during migration.
• Created WebI on top of universes with Bex queries. Bex is the main source for majority of the BO universes.
• Created complex WebI which involved multiple data providers, multiple levels of hierarchy of various dimension objects.
• Designed around 30 Crystal Reports with complex formulae, parameters, sub-reports involved.
• Analyzed Oracle SQL and PL/SQL procedures and converted them to crystal reports.
• Demonstrated SQL and PL/SQL knowledge including writing complex stored procedures, dynamic SQL, packages andfunctions. Worked with complex SQL including analytic functions, sub queries, correlated sub queries etc.
• Modified existing reports and designed new parameterized reports based on the mockups.
• Involved in tuning of Crystal Reports for better performance and worked with PL/SQL and TOAD designed by Quest software for query analysis.
• Involved in performance tuning of Reports and Universes by making necessary changes to Bex queries whenever needed.
• Created predefined conditions, prompts at Universe level to improve the efficiency of reports.
• Extensively used merged dimensions in lot of WebI reports to extract data from more than one universe.
• Developed various stored procedures and functions in Oracle 11g Database to improve the performance thus concealing complexity from the front-end application.
• Validate the report data with respect to SAP data and perform unit testing on all the reports built.
• Assisted in developing Xcelsius dashboards to display the high level data of various departments of CDOT. Modified few already existing Crystal reports as per requirement changes.
• Involved in training the end users on accessing/handling web portal Info View to execute the reports based on selection parameters
• Maintain regular interaction with BW developers for better understanding of Business.
• Develop and embed Crystal Reports into MS .Net and ASP.Net applications, schedule the reports based on the user requirements.

Environment: SAP BODI/BODS 4.0, BO 4.0, BO XI R3.1, SAP BI 7.1, Oracle 11g Database ,Launch Pad InfoView , Universe Designer, Web Intelligence, Visual Studio Team Foundation Developer's Suite, Xcelsius 2008 SP3, Live Office, Crystal Reports 2008, Oracle 10g, SQL Server,ASP.NET,VB.NET.

Confidential

Sr. BO Consultant

Responsibilities

• Interacted with KCC users and Analysts to discuss the Universes' and Reporting issues and fixes to be performed which were already in Production.
• Lead BO and SAP BW reporting teams in the process of setting up the quick fixes to the high level hierarchies in BW system.
• Involved in fixing hierarchy issues related to major universes which were already in production and their corresponding hierarchies in SAP BW system
• Involved in performance tuning of already existing Universes and optimize the reports based on those universes.
• Involved in tuning of Crystal Reports for better performance and worked with PL/SQL and TOAD designed by Quest software for query analysis.
• Analyzed Oracle SQL and PL/SQL procedures and converted them to crystal reports.
• Demonstrated SQL and PL/SQL knowledge including writing complex stored procedures, dynamic SQL, packages andfunctions. Worked with complex SQL including analytic functions, sub queries, correlated sub queries etc.
• Develop and embed Crystal Reports into MS .Net and ASP.Net applications, schedule the reports based on the user requirements.
• Installed and configured SAP Business Objects Explorer on a Blade architecture BW system. Configure CMS with necessary add-ons to implement the Explorer on third party mobile apps.
• Typical WebI reports included multiple tabs with various prompts, drill filters and multiple data providers to show the different sets of data in a single report
• Developed various stored procedures and functions in Oracle 11g Database to improve the performance thus concealing complexity from the front-end application.
• Used Input Controls in WebI reports new feature in BOXI R3.1 - the functionality which allows users to change their selection criteria even after the report is executed
• Performance tuning of Universe joins to retrieve the accurate data with respect to different hierarchy levels based on Business background.
• Scheduled and published WebI and Crystal Reports using Info view, and trained users on creating reports.
• Extensively worked on Importing/Exporting the Universe from/to repository to make it accessible to end users.
• Assisted in developing Xcelsius dashboards to display the high level data of various global locations
• Involved in training the end users on accessing/handling web portal Info View to execute the reports based on selection parameters
• Maintain regular interaction with ETL developers for better understanding of Business Flow

Environment: Business Objects XI R3.1, Oracle 10g, Visual Studio Team Foundation Developer's Suite, SAP BI, Explorer 3.1, Universe Designer, Web Intelligence, Oracle 11g Database ,InfoView, Xcelsius 2008, Live Office, Windows

Confidential

BO/Crystal Reports Developer

Responsibilities

• Met various Business users' teams and involved in heavy interaction with them in the process of discussing the overall Reporting requirements.
• Gathered all kinds of end users' Business requirements and analyzed the Business data flow which is the key for Report writing and decision making.
• Involved in preparing High level/ Detail design specification documents with the help of Business Analysts
• Created many Mock-up/Model reports for initial user presentation in the process of preparing Functional specifications
• Analyzed Oracle SQL and PL/SQL procedures and converted them to crystal reports.
• Demonstrated SQL and PL/SQL knowledge including writing complex stored procedures, dynamic SQL, packages and functions. Worked with complex SQL including analytic functions, sub queries, correlated sub queries etc.
• Designed and Developed 2 universes by defining necessary Joins, Cardinalities and apply Contexts/Alias to maintain the overall integrity of the Universes
• Created Classes and universe Objects as per the Business standards defined additional measure objects wherever require.
• Designed a universe from BEX query source data in the process of creating few WebI reports
• Developed 2 interactive Xcelsius Dashboards with multiple selector components and Bar/Pie charts for MTD, QTD and YTD data comparison
• Used Live Office to import necessary WebI and Crystal reports which were the source of data for Xcelsius Dashboards
• Created many WebI reports of high complexity which involved multiple data providers, Report level and Block level drill filters, Alerts for conditional output
• Created few WebI reports which uses Input Controls, the functionality which allow users to change their selection criteria of the report output
• Converted few selected DeskI reports to WebI reports as per business users' needs.
• Develop and embed Crystal Reports into MS .Net and ASP.Net applications, schedule the reports based on the user requirements.
• Converted few existing WebI reports to Crystal reports to overcome the limitations of output data rows in WebI.
• Involved in tuning of Crystal Reports for better performance and worked with PL/SQL and TOAD designed by Quest software for query analysis.
• Developed various stored procedures and functions in Oracle 11g Database to improve the performance thus concealing complexity from the front-end application.
• Used Aliases and Contexts in resolving various loops and traps in course of Universe development.
• Created derived tables and aggregate tables for maximum optimization and efficient performance of the universes.
• Developed few complex reports which included WebI and Crystal with multiple parameters and custom SQL wherever required.
• Created various filters at both Universe and report levels.
• Created few WebI reports using Bar charts, graphs to depict Monthly, Quarterly and Yearly data
• Worked with a Teradata ETL team in gathering required data tables and resolving data issues.
• Worked with Informatica ETL for Data Loading and executed Informatica batch jobs for loading the data into target systems
• Participated in daily status meetings with co-developers and Manager to discuss the progress of the reporting tasks assigned.
• Migrated all the developed reports from BO dev to BO test and BO test to BO Prod.
• Performed unit testing of the reports and involved in UAT at all stages.
• Trained end users in running parameterized reports and accessing Info View.

Environment: SAP BODI 3.1, Business Objects XI R3.1, Oracle 11g Database, SAP BI 7.0, Universe Designer, Web Intelligence, Xcelsius, Live Office, Crystal Reports 2008, SQL Assistant, Informatica ETL 8.6.1, Unix and Windows.

Confidential

BO Offshore Lead

Responsibilities

• Involved in direct interaction with end users and Business Analysts to analyze the Business processes very thoroughly and gather Business requirements
• Developed System Requirement Specifications SRS and Detail Design Specifications DDS for the universes and reports to be developed based on the Business rules.
• Designed, developed and maintained 2 major universes with over 25 tables in each with various Objects Classes and categorized accordingly.
• Created Joins, cardinalities, checked the overall integrity of the universes
• Created predefined conditions, prompts and customized LOV's in universes.
• Responsible for migaration of BO Objects Universes, Reports to various cycles of the Enviroment Dev to Test and from Test to Production.
• Designed Universes from multiple data providers by creating prompts, queries and applied Contexts and Aliases to remove loops.
• Created various WebI reports for adhoc reporting needs.
• Converted few selected DeskI reports to WebI reports as per business users' needs.
• Converted few WebI reports to Crystal to overcome the limitations of output data rows in WebI.
• Scheduled and published BO/WebI reports using Info view, and trained users
• Extensively worked on Importing/Exporting the Universe from/to repository to make it accessible to end users. Analyzed Oracle SQL and PL/SQL procedures and converted them to crystal reports.
• Demonstrated SQL and PL/SQL knowledge including writing complex stored procedures, dynamic SQL, packages and functions. Worked with complex SQL including analytic functions, sub queries, correlated sub queries etc.
• Develop and embed Crystal Reports into MS .Net and ASP.Net applications, schedule the reports based on the user requirements.
• Involved in tuning of Crystal Reports for better performance and worked with PL/SQL and TOAD designed by Quest software for query analysis.
• Developed various stored procedures and functions in Oracle 11g Database to improve the performance thus concealing complexity from the front-end application.
• Used Aliases and Contexts in resolving various loops and traps in course of Universe development.
• Created derived tables and aggregate tables for maximum optimization and efficient performance of the universes.
• Created various filters at both Universe and report levels.
• Created few WebI reports using Bar charts, graphs to depict Monthly, Quarterly and Yearly data
• Worked with a Informatica ETL team in gathering required data tables and resolving data issues.
• Participated in regular status meetings with co-developers and Manager to discuss the progress of the assignment.
• Migrated all the developed reports from BO dev to BO test and BO test to BO Prod.
• Performed unit testing of the reports and involved in UAT at all stages.
• Trained end users in running parameterized reports and accessing Info View

Environment: Business Objects XI R3.0, Teradata 12, SQL Assistant, Designer, Web Intelligence, Oracle 11g Database, Crystal Reports 2008, TFS, Microsoft.NET,VB.NET,ASP.NET,Windows 2003.

Confidential

BO/Cryatal Reports developer.

Responsibilities

• Interacted with Business Team in gathering their business requirements to prepare high- level User/System manual.
• Involved in conversion of high-level specifications to detailed documentation for building Universe with all necessary data elements, mockup templates and design specifications.
• Assisted project lead in managing a BO reporting team in course of Report designing.
• Designed universes for standard canned, ad hoc reports based on reporting requirements.
• Developed WebI reports by using advanced functionalities like Optional prompts, Data tracking, Merge function, Custom SQL at Report level.
• Develop and embed Crystal Reports into MS .Net and ASP.Net applications, schedule the reports based on the user requirements.
• Involved in tuning of Crystal Reports for better performance and worked with PL/SQL and TOAD designed by Quest software for query analysis.
• Used Aggregate tables in the universes for the query optimization process and Designer Functions like Prompt, Select, Where to create and define condition objects and prompts required to generate reports.
• Created Classes Objects using different Joins- developed mappings, checked the integrity of the universe and resolved loops using aliases and contexts.
• Assisted in developing 4 Xcelsius dashboards with various visualizations and components.
• Built dashboards with drilldown capabilities, Dynamic Visibility and various visualizations using menu components, Gauges, Sliders.
• Generated and published the SWF files of the Dashboards to BO Enterprise.
• Involved in performance tuning of Business Objects Full Client and Web reports.
• Published and scheduled the reports in Business Objects Enterprise using Info View.
• Installed and configured Crystal reports on Windows 2003 server in development box.
• Designed Business Views, LOV in Business View Manager and developed reports accordingly.
• Created Repository Custom Functions and used them in reports wherever needed.
• Scheduled Crystal reports in Crystal Enterprise for automatic refresh and to different destinations.
• Developed various stored procedures and functions in Oracle 11g Database to improve the performance thus concealing complexity from the front-end application.
• Engaged in daily team meetings to review the status of the reports being developed.
• Migrated all the developed reports from Dev environment to Test environment.
• Performed extensive Unit Testing before submitting the reports for testing.
• Published Crystal Reports in web based environment using Crystal Enterprise.
• Involved in troubleshooting, optimizing, and fine-tuning the SQL queries and debugging for efficiency.

Environment: Business Objects XI 3.0, Visual Studio Team Foundation Developer's Suite Designer, Web Intelligence, Crystal Reports 2008, Oracle 11g, Oracle SQL Developer 1.2, Toad, Windows.

Confidential

BO/Crystal Reports Developer.

Responsibilities

• Interacted with the Business Users to analyze the business process and gathered the requirements- Made necessary changes to schema objects to fulfill the business needs.
• Worked with Business Analyst in developing high level documentation according to specifications.
• Responsible for migaration of BO Objects Universes, Reports to various cycles of the Enviroment Dev to Test and from Test to Production.
• Involved in tuning of Crystal Reports for better performance and worked with PL/SQL and TOAD designed by Quest software for query analysis.
• Developed various stored procedures and functions in Oracle 11g Database to improve the performance thus concealing complexity from the front-end application.
• Worked on the migration of Business Objects reports from version 6.5 to version XIR2.
• Customized the Info View using WebI SDK, published reports using Info view, and trained users for ad hoc reporting.
• Extensively used Calculations, Variables, Break points, and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Created new classes User Objects in designing the Universes, Importing/Exporting the Universe from/to repository to make it accessible to end users.
• Designed Universes from multiple data providers by creating prompts, queries and applied Contexts and Aliases to remove loops.
• Analyzed Oracle SQL and PL/SQL procedures and converted them to crystal reports.
• Demonstrated SQL and PL/SQL knowledge including writing complex stored procedures, dynamic SQL, packages and functions. Worked with complex SQL including analytic functions, sub queries, correlated sub queries etc.
• Involved in data quality and data control methodologies for developing data models.
• Responsible for the design of a set of Crystal Reports which included sub-reports, dynamic parameters and complex formulae.
• Worked with Crystal team in developing mockups and design templates with user specifications.
• Published Crystal Reports in web based environment using Crystal Enterprise.
• Designed and developed Interactive Dashboards using Crystal Xcelsius and developed various visualizations using Menu Components, Gauges and Sliders.
• Double checked all the developed reports even before sending them for testing team.
• Developed various reports based on Multiple Parameters and Prepared Test Plans and Test Cases for all the Reports and documented the results for future reference.
• Involved in tuning of Crystal Reports for better performance and worked with PL/SQL and TOAD designed by Quest software for query analysis.
• Involved in troubleshooting, Optimizing, and fine-tuning the SQL Queries used TOAD and Crystal Report debugging for efficiency.
• Participated in reports analysis, quality control testing, deployment and integration testing.

Environment: Business Objects XI R2, Web Intelligence, Crystal Reports XI R2, Oracle 10g, Crystal Xcelsius 2008, Oracle 11g Database ,Oracle Developer, TOAD, Windows.

Confidential

BO/Report Developer

Responsibilities

• Involved in gathering Business Requirements such as Applicants Information in Underwriting to the information about Accounting from the Business Documents.
• Developed detail level documentation for creating universe to be used for reporting with Crystal Reports XI as well as BO XI.
• Develop and embed Crystal Reports into MS .Net and ASP.Net applications, schedule the reports based on the user requirements.
• Designed, Developed and Maintained Business Objects universes by defining joins cardinalities between tables.
• Involved in the development of mappings, sessions and workflows to load data in slow changing dimension
• Involved in Deployment of Universes and Reports from Development Environment into Production Environment.
• Analyzed Oracle SQL and PL/SQL procedures and converted them to crystal reports.
• Demonstrated SQL and PL/SQL knowledge including writing complex stored procedures, dynamic SQL, packages and functions. Worked with complex SQL including analytic functions, sub queries, correlated sub queries etc.
• Developed many complex Adhoc/canned reports using Web Intelligence with drilldown capabilities and Alerts wherever necessary.
• Designed and developed Crystal Reports, Cross Tab Reports, Top N Reports for indicating significant data, summary reports with drill-down capabilities.
• Worked in Crystal Reports Server XI for flexible scheduling and delivery of the report which gives the easy access to the Business Data.
• Developed various stored procedures and functions in Oracle 11g Database to improve the performance thus concealing complexity from the front-end application.
• Resolved the Performance issues/Data issues with Reports and data source tables.
• Created complex stored procedures, Views to extract data.
• Exported Reports into PDF Excel from Enterprise and resolved formatting issues
• Used Business Objects Web Intelligence client as the primary reporting tool obtaining Business Data into its interactive query and analysis capabilities.
• Worked Extensively on Web Intelligence for any new requests and performance issues.

Environment: Business Objects XI, Designer, Web Intelligence, Crystal Reports XI, SQL Server 2000, Windows.

Confidential

BO/Report Developer

Responsibilities

• Actively involved in gathering user Requirements and developed high level Documentation.
• Developed crystal reports to figure out YTD and MTD statements.
• Developed set of Crystal reports with different and multiple parameter fields and multiple grouping for different hierarchy levels and published them to Crystal Enterprise.
• Involved in developing the financial reports for the Financial services Dept and successfully published the highly formatted reports and met with the end user requirements.
• Exported reports into various formats like Editable RTF, XML, PDF, HTML, MS Word, and Excel.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports.
• Created complex stored procedures, Views to extract data from source data tables.
• Responsible for developing provisioning reports for various groups and upper management.
• Various Report Formats developed include Sub Reports, Cross Tab Reports, Standard Reports and Master/Detail Reports.
• Performed User training and Unit Testing of developed reports before testing.
• Involved in tuning of Crystal Reports for better performance and worked with PL/SQL and TOAD designed by Quest software for query analysis.
• Analyzed Oracle SQL and PL/SQL procedures and converted them to crystal reports.
• Demonstrated SQL and PL/SQL knowledge including writing complex stored procedures, dynamic SQL, packages and functions. Worked with complex SQL including analytic functions, sub queries, correlated sub queries etc.
• Developed various stored procedures and functions in Oracle 11g Database to improve the performance thus concealing complexity from the front-end application.
• Participated in reports analysis, quality control testing, deployment and integration.

Environment: Crystal Reports 10.0, Crystal Enterprise, Designer, Oracle 11g Database, BO 6.5, SQL Server 2000, Windows NT, UNIX Linux .