SUMMARY:

• Around 8 years of experience in Business Intelligence with a focus on Reporting side for all kinds of enterprise reporting solutions using SAP BusinessObjects Enterprise suite on top of all flavors of relational databases like Teradata, Oracle, SQL server and with SAP BI/BW backend (on top of OLAP universes, BEx queries, BICS connections, Infocubes).
• Involved in heavy interaction with business/end users, various BI teams to analyze business requirements, gathering reporting needs in order to process Business solutions effectively in various domains like Healthcare (Claims, Providers info and Billing data), Banking/Finance, Logistics, and Consumer goods/products.
• Experience in working with huge chunks of data related to Encounter Lifecycle of Insurance claims, (837 Institutional and Professional claims)
• Solid experience in various versions - BO 4.x, BOXI 3.x/R2/6.x and all BO components- Information Design Tool (IDT), Web Intelligence (WEBI), Universe Designer, BI Launch Pad (InfoView earlier), Xcelsius (QaaWS, BICS, Live Office), Desktop Intelligence, Promotion Manager (Import Wizard earlier), Publishing Wizard.
• Extensively worked on Designing, Developing BusinessObjects Universes with various functionalities like Aggregate navigation, row level and table level Securities, cascading LOV's.
• 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.x
• Hands on experience in advanced SAP 4.x tools like Analysis for OLAP, Analysis for Office, Design Studio, SAP BO explorer, SAP Mobile, Dashboard Designer, Crystal Reports for Enterprise 4.0 on top of SAP BI 7.0/7.3 using BEx queries, BICS connections.
• Experience in working at various levels - As Team Lead, Technical Lead coordinating and managing teams at Onsite/Offshore.
• Very good in writing 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.
• 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).
• Played many key roles in various stages- Reports developing, Testing, resolving Production/data issues, Data modeling and complex Data analysis.
• Experience in working on analyzing end-user requirements, business data requirements for effective reporting.
• Extensively involved in migrating reports from Dev Environment to Test, Test to Production and experienced in publishing and scheduling.
• 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.
• Extensively involved in conducting knowledge transfer sessions to end users.
• Active team player and an individual with Excellent Communication, Interpersonal skills, self motivated, fast learner and good listener.

TECHNICAL SKILLS:

SAP BO/BW tool set: BusinessObjects 4.x, 3.x/XI R2/6.x, CMC, CCM, Query Designer, BEx, IDT, Crystal Reports for Enterprise 4.0, 2008/XI R2, Universe Designer, Web Intelligence/Rich client, Desktop Intelligence, BI LaunchPad (InfoView), Crystal Xcelsius, Information Design Tool (IDT), Universe Designer, Business Analytics, Dashboard Manager, Promotion Manager 4.0 (Import Wizard), Publishing Wizard, Business View Manager, Live Office, SAP BO Explorer, Design Studio, Analysis for Office/OLAP

ETL BI skills: Informatica Power Center, Data Stage ETL, Data Modeling using Star and Snowflake schemas

Databases & tools: SAP BI 7.x, Teradata, Oracle 10g/8i, SQL Server 2008/2005/2000, Netezza, DB2, MS Access, SQL*Plus, SQL* Loader, Oracle Developer, SQL Developer, Erwin, HP Quality Center.

Programming & Scripting: SQL, PL/SQL, C, C++, MS Office Suite.

Operating Systems: Unix (Linux), Windows XP/2003/2000/NT/2003 Server

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

SAP BO/BI 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 with focus on reports delivery and cutover plans.
• Gather reporting requirements for healthcare providers’ with claims information and billing data.
• Interacted closely with Functional team and Business users to discuss the optimum strategies for reports delivery.
• Most of the data is related to Insurance claims (837I and 837P), providers info, Individual, non-individual with various Taxonomy codes.
• Worked a lot on Universe Designing (semantic layer) using Designer and IDT.
• Developed BEx queries to support the design and development of 25 WebI reports and few crystal reports.
• Develop WebI which involved calculation contexts, sectioning, filters (global and block level), hyperlinks involving multiple tabs.
• 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, Design Studio and Analysis tools and given presentations to explain the abilities and capabilities of these powerful tools.
• Responsible for Onsite-Offshore coordination and status tracking of the deliverables.

Environment: BusinessObjects 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, Oklahoma City, OK

SAP BO/Tableau Developer

Responsibilities:

• Involved in heavy interaction with business users in the process of discussing the overall Reporting requirements.
• Assisted in defining functional specs and writing technical specs. Strategize reporting deliverables with various reporting tools (SAP BO and Tableau)
• SAP BI and Oracle 10g as major backend databases for different set of reports to various business teams.
• Designed and developed Universes 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 WebI reports on top of universes and Bex queries. Bex is the main source for majority of the BO reports.
• As a Tableau developer, worked on Tableau Demo sessions, presentations, Pilot releases of Dashboards and workbooks.
• Involved in migration of few legacy reports to Tableau workbooks with improved functionalities in terms of input parameters, Dynamic data synchronization at run time.
• Responsible for Tableau Server Administration, Maintenance, Deployment and Performance Tuning for Optimization.
• Involved in building 2 P&L dashboards using Tableau visualizations.

Environment: BusinessObjects 4.1, SAP BI 7.1, Tableau Software 8.1, Oracle,, BI LaunchPad, IDT, Query Designer, Web Intelligence, Design Studio, Analysis for OLAP/Office

Confidential, Plano, TX

SAP BO/BI Developer

Responsibilities:

• 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.
• 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, BI LaunchPad (InfoView), IDT, Crystal Reports for Enterprise 4.0, Promotion Manager, Web Intelligence, Windows

Confidential, La Palma, CA

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)
• 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
• Extensively involved in fine tuning of SQL queries to validate the backend data with reports data
• Worked on Data Modeling and built Source to Target (STT) transformations, data mappings for the Data Warehouse
• 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 and 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.
• Fine-tuned the existing universes to enhance their performance by extensively using SQL wherever required.
• Involved in End User, Coordinated the migration strategy to move the developed objects across the landscape.

Environment: BusinessObjects 4.0, BOXI R3.1, Teradata 12, BI LaunchPad (InfoView), Universe Designer, IDT, Web Intelligence, Xcelsius 2008 SP3, Live Office, Crystal Reports for Enterprise 4.0, Crystal Reports 2008, Unix and Windows

Confidential, Denver, CO

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 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.
• Modified existing reports and designed new parameterized reports based on the mockups.
• 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.
• 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 the end users on accessing/handling web portal InfoView to execute the reports based on selection parameters
• Maintain regular interaction with BW developers for better understanding of Business

Environment: SAP BODI/BODS 4.0, BO 4.0, BO XI R3.1, SAP BI 7.1, Launch Pad (InfoView), Universe Designer, Web Intelligence, Xcelsius 2008 SP3, Live Office, Crystal Reports 2008, Oracle 10g, SQL Server

Confidential, Neenah, WI

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
• Installed and configured SAP BusinessObjects 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
• 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 the end users on accessing/handling web portal InfoView to execute the reports based on selection parameters
• Maintain regular interaction with ETL developers for better understanding of Business Flow

Environment: BusinessObjects XI R3.1, Oracle 10g, SAP BI, Explorer 3.1, Universe Designer, Web Intelligence, InfoView, Xcelsius 2008, Live Office, Windows

Confidential, Hershey, PA

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
• 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.
• Converted few existing WebI reports to Crystal reports to overcome the limitations of output data rows in WebI.
• 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
• 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 InfoView.

Environment: SAP BODI 3.1, BusinessObjects XI R3.1, Oracle, 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, New Berlin, WI

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.
• 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
• 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 InfoView

Environment: BusinessObjects XI R3.0, Teradata 12, SQL Assistant, Designer, Web Intelligence, Crystal Reports 2008, Windows 2003.

Confidential, Chicago, IL

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.
• Created Classes & Objects using different Joins- developed mappings, checked the integrity of the universe and resolved loops using aliases and contexts.
• 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.
• 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 WebI reports.
• Published and scheduled the reports in BusinessObjects Enterprise using InfoView.
• 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.
• 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: BusinessObjects XI 3.0, Designer, Web Intelligence, Crystal Reports 2008, Oracle 10g, Oracle SQL Developer 1.2, Toad, Windows.

Confidential, Chicago, IL

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.
• Designed Universes from multiple data providers by creating prompts, queries and applied Contexts and Aliases to remove loops.
• Created new classes & User Objects in designing the Universes, Importing/Exporting the Universe from/to repository to make it accessible to end users.
• Extensively used Calculations, Variables, Break points, and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Worked on the migration of Business Objects reports from version 6.5 to version XIR2.
• 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 .
• 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: BusinessObjects XI R2, Web Intelligence, Crystal Reports XI R2, Oracle 10g, Crystal Xcelsius 2008, Oracle Developer, TOAD, Windows.

Confidential, Dayton, OH

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.
• Designed, Developed and Maintained Business Objects universes by defining joins & cardinalities between tables.
• 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.
• 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: BusinessObjects XI, Designer, Web Intelligence, Crystal Reports XI, SQL Server 2000, Windows.