SUMMARY

• 9+ years of experience in SAP Business Objects (BOBJ) 4.1 Sp5/4.0/XIR3.1/XIR2 using different tools like IDT, UDT, BI launch Pad, Business Object universe Designer, Desktop Intelligence, Web Intelligence, InfoView, Dashboard, Scorecards, Central Management Console, Xcelsius/Dashboard 2008, 4.1, Crystal Reports,Tableau7.0/8.1 Data Services 4.0,3.1/Data Integrator XI, Oracle 11g/10g/9i, Oracle 10g, SQL Server 2008/2005/2000 , Microsoft Access 2000.
• Over 2+year of experience in SAP HANA1.0 and developing data warehouse model by using Analytic Views, attribute views and calculated views using HANA Studio.
• Over 2 to 3 Years of experience in BOE administration like creating user, group, and different security management using CMC.
• Over 4years of experience in Xcelsius/ dashboards using QAAWS & Web services, Live Office.
• Creation of Dashboards Converting Business Data requirements into Conceptual and logical data models. Commonly used excel functions ("VLookup, Hlookup, Index, Match and Conditional statements") Microsoft excel as a data source.
• Good understanding on Data Integrator concepts which involves creation of complex Jobs, Work Flows, Data Flows, Writing Scripts and using different Transformations to successfully load data from multiple sources into a desired target.
• Proficiency in data warehousing techniques for Slowly Changing Dimension phenomenon, surrogate key assignment and change data capture.
• Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
• Experience in Data Warehouse development working with Data Migration, Data Conversion, and Extraction/Transformation/Loading using SAP Data Integrator/SAP Data Services with Oracle, SQL Server.
• Experience in gathering business requirements and building Universes, Reports and Dashboards.
• Experience in creating Universes with measures and dimensions objects, Join conditions, Filters, LOV, cardinality, Aliases, Contexts, Aggregate Awareness, applied row level and object level securities on different groups and users using Business Objects Designer.
• Experience in designing and developing the Universe and updating the existing Universes, developing canned/adhoc reports, scheduling the processes and administering the BO activities using Business Objects 4.0/XIR3/XIR2/6.5.
• Worked with Crystal Reports 2008/XI/10/9 for creating complicated reports including sub - reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports and data reports.
• Using Universe & Crystal Reports and Webi Reports as a Data source of Xcelsius to build the dashboards thru Use live office & QAAWS to getting the live data.
• Using SAP Netwear BW Connection to connect the SAP BEx queries into getting the data from Xcelsius Dashboards.
• Experience in BOE administration like user, group, and different security management using CMC.
• 1+ year of experience in SAP BW/BI components like Info Cubes, Info Package, Data Source, BEx Query Designer, BEx Analyzer.
• Excellent understanding of Data Warehouse architecture, Star Schema, Snowflake Schemas, Fact and Dimensions Tables.
• Complete Software Development Life Cycle experience including requirements gathering, analysis/design, development and testing.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Involved in all the stages of Software Development Life Cycle.
• Extensive experience in Developing and Testing the PL/SQL (Procedures, Cursors and functions, Triggers) scripts while developing the reports.
• Expertise in SQL, PL/SQL, My SQL, Stored Procedures, Functions, Cursors, Packages, Views, Indexes
• Proficient in working on development environment in different RDBMS (Oracle 10g, Oracle 9i, TOAD9.0 etc.
• Strong writing and documentation skills for the management, development and control of documentation.
• Worked on a flexible schedule, weekends as per client’s requirement and with different clients and on various domains
• Ability to meet deadline and handle multiple tasks, decisive with strong leadership qualities
• Excellent communication, documentation and presentation skills
• Highly organized, detail-oriented professional with strong technical skills.

TECHNICAL SKILLS

BI Report Tool: SAP Business Objects 4.1/4.0/XIR3/R2, Desktop Intelligence, Dashboard, Web-Intelligence, Info View, Universe Designer, IDT, UDT, Crystal report, Tableau7.0/8.1

ETL Tool: SAP Business Object Data services(BODS),IBM Web sphere Data Stage 8.0 (Designer, Director, Manager ),Kalido Data warehouse

Databases: SAP HANA 1.0,Tera data, Oracle 9i/10g/11g, MS Access

Programming Languages: C, C++, Java, SQL, PL/SQL

Web Technologies: JSP, JavaScript, PHP, HTML, XML, CSS

Operating Systems: Windows 98/XP/Vista, UNIX

Data Modeling Tools: TOAD 9.0/8.5

Software Packages: TOAD 9.0/8.5, Oracle SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

Senior SAP BO/BI Technical Consultant

Responsibilities:

• Worked with users to know their business need while gathering the reporting requirements and provided several mock-up reports to finalize the requirements.
• Designed mock-up universes and WebI Reports from scratch for a demo to the users.
• Have used Agile processed for software life cycle.
• Based on functional requirement I have designed end to end BO traceability document.
• Provided time estimates based on analysis of report specs and BRD.
• Created Universes and complex reports against Teradata Database and also Denodo Virtual Layer.
• Set up Universe level conditions to restrict data based on report requirements.
• Created Webi reports with multiple data providers and synchronized the data using Merge Dimensions option in BO.
• Created Joins, Contexts, and Aliases for resolving Loops and checked the Integrity, Cardinalities of the Universe.
• Created reports using all the BO functions like hyperlinking, Prompts, input controls, dimensional and Measure variables to show the accurate results.
• Writing Complex SQL queries and matching the data with database and reports.
• Experienced in writing complex SQL Queries, Views, Joins, Constraints and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Advised optimization of queries by looking Confidential Execution Plan for better tuning of the database.
• Tuned and enhanced universes with SQL queries for the report performance.
• Specialize in migration to SAP BO XI R4.0 Universe Information Design Tool (IDT), Web Intelligence Reporting, SAP Dashboard 4.0 (Xcelsius) and Crystal Report 2011.
• Expertise in working with new tools in BO4.1 Design Studio 1.2 and Lumira.
• Expertise in building mobile Apps using Design Studio 1.2 and Dashboard 4.0 for IPAD and IPhone.
• Created customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Created and modified Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Generated the Business Objects reports involving complex queries, sub queries, unions and intersections.
• Worked on the color coding of the Reports based on the user requirement.
• Worked with Platform Team to Schedule the Reports in the Production Environment on the Monthly and Weekly basis.
• Created Web Intelligence Ad-hoc and canned reports.
• Worked on the improving the performance of the reports by tuning Teradata views.
• Deployed the reports to CMC for the users to able to see the reports in Info View and run, schedule and view the reports in different formats (PDF, Excel)
• Wrote formulas, parameters and conditions depending upon selection criteria.
• Implemented dynamic cascading prompts and defined business views
• Involved in Modifying and Performance tuning of the Existing Reports.
• Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Developed reports specific with these Delegated Search, Database Delegated, Open Document and Data tracking new functionalities.
• Published Reports to CMC (Central Management Console) and involved in Scheduling and exporting the reports in different Formats.
• Did unit testing and Integration testing after the development of universe and report.
• Involved in User acceptance testing and giving BO training to User.

Environment: SAP Business Objects4.1SP5 (IDT, UDT,BI Launch), Dashboard4.0,SAP Crystal report, SAP Lumira, SAP Design Studio, Tableau 8.1,Teradata,Denodo V5.5,Informatica SAP HANA (SP09).

Confidential, Detroit, Michigan

Sr.SAP BO/BI Consultant

Responsibilities:

• Involved in gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects Web Intelligence and Tableau Reports.
• Designed mock universes and WebI Reports from scratch for a demo to the users.
• Designed, developed and implemented solutions with data warehouse, ETL, data analysis, and BI reporting technologies.
• Pulled Sales Order data using SLT replication from ECC system for warehousing purpose Confidential HANA.
• Developed various Data warehouse Models like, Analytical view, Attribute view and calculated view using HANA Studio.
• Designed Various HANA views after data load from transactional system to the HANA.
• Created universe using IDT from the calculated views created on HANA DB.
• Analyzed the Universe data using explorer, Webi and other reporting tools.
• Advised optimization of queries by looking Confidential Execution Plan for better tuning of the database.
• Tuned and enhanced universes with SQL queries for the report performance.
• Defined security models with row level data security, role based security etc in Business Objects Universes and Central Management Console (CMC)
• Created users, groups, server groups and setup security architecture.
• Implemented Row Level, Object Level security for data restriction Confidential Universe level.
• Developed Webi, Deski, Crystal, Webi Rich Client and Xcelsius Dashboards
• Developed BO 4.1 using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking, Input Controls and Merge Dimensions
• Experienced in developing complex reports using Business Objects Webi Rich Client & Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
• Created WebI reports with multiple data providers and synchronized the data using Merge Dimensions option in BO.
• Created Joins, Contexts, and Aliases for resolving Loops and checked the Integrity, Cardinalities of the Universe.
• Created reports using all the BO functions like hyperlinking, Prompts, input controls, dimensional and Measure variables to show the accurate results.
• Designed and developed a business intelligence dashboard using Tableau Desktop, allowing
• Generated the Business Objects reports involving complex queries, sub queries, unions and intersections.
• Created Xcelsius Dashboards for Sales and Product level data based on Product Age & Usage using various components of Xcelsius.
• Created WSDLs using QAAWS (Query as Web Services) and implemented into Xcelsius dashboards.
• Created Pseudo dashboards one report having multiple hyperlinks to various reports using Open Document functionality from Dashboard to Webi Report.
• Used OpenDoc functionality to drill down from Xcelsius dashboard to Webi Reports.
• Using Flash variables passed the parameters from Parent Dashboard to Child Dashboard.
• Written SQL queries have been used on the Universe and created as Derived Tables.
• Wrote Complex SQL Queries for Data validation purpose.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• Worked with Platform Team to Schedule the Reports in the Production Environment on the Monthly and Weekly basis.
• Unit Testing & Regression Testing of reports.

Environment: SAP Business Objects4.1SP5 (IDT, UDT,BI Launch), Dashboard4.0,SAP Crystal report, SAP Lumira, Tableau 8.1,Oracle,Teradata,SAP HANA (SP09),DataStage V8.0,URWin.

Confidential,Teaneck, NJ

Sr.SAP BO/BI Consultant

Responsibilities:

• Worked with business users, subject matter experts and technical staff to identify and articulate requirements, evaluate data architecture and technical environment and align the software tools with business-user needs for effective information delivery.
• Designed the overall architecture for reporting layer from various data warehouses and source systems, Supported strategic, tactical and operational reporting strategy in real-time, near real-time, and batch environments.
• Responsible for Design/development/testing of Universes, Webi, and Crystal Reports based on the requirement given by business users.
• Also part of regular maintenance activities with enhancement of the existing reports and fixing day to day tickets.
• Installed patches or releases on the server as well as client PCs. Also involved in software installation, configuration, and security integration.
• Involved in BO Upgrade from 3.1 to 4.0
• Responsible for giving access to the user for the Tableau.
• Involved QA environment setup testing.
• Part of migration involving webi reports from XIR3.1 to 4.0.
• Worked on Maintenance project on universe, bug fix and day to day issue.
• Involved in disaster recovery setup for BO and Tableau.
• Involved in Tableau7.1 and 8.0upgrade and also did Regression Testing of Dashboards.
• Performance management on Webi report and crystal report.
• Involved in requirement gathering and Data modeling for the new for Universes and reports.
• Security setup for the User in Webi and Tableau and scheduling jobs for them.
• Managed the transition from development to testing to production deployment of reports.
• Developed Business Objects Universe using IDT & UDT (Universe Design Tool).
• Provided 3rd tier (advanced) support and deployment and management of tools and applications on distributed server environments.
• Experience in Analysis, Design, Development, Implementation, Deployment and maintenance of Business Intelligence applications.
• Experience in handling SAP Business Objects BI 4.0, XIRX3.1, Web Intelligence, Crystal and BO Xcelsius.
• Hands on Experience in Designing Universes and Reports Using SAP Business Objects, Web Intelligence, Xcelsius suite.
• Hands on experience in Resolving loops Creating Contexts and Aliases in the Universe Designer.
• Created Universes and complex reports against Teradata Database.
• Worked in Developing Universe by Multiple as well as single Data source using Information Design Tool of SAP Business Objects 4.0.
• Worked in analyzing the data by using Master-Detail, Cross Tab and Drill Down techniques.
• Worked in developing Analytical Dashboards Using Xcelsius with QAAWs and Live office connectivity.
• Hands on Experience in Writing and Optimizing SQL and PL/SQL queries.
• Designed, developed complex reports (drilldown reports, crosstabs) using Business Objects Webi, Crystal Reports with Oracle Stored Procedure or Universe for Auditors, Accounting, Finance, Sales departments, and Executives.
• Did unit testing and Integration testing after the development of universe and report.
• Being part of offshore and onsite model, manage offshore team on day to day basis.
• Interacting with team members to ensure smooth progress of project work, maintaining quality throughout the system development life cycle, Process and providing support to the users on the application.
• Day to day job includes Managing, administering and supporting infrastructure, which includes On-Call duties as specified in the on-call checklist such as monitoring and resolving support tickets.
• Involved in Developing, Maintaining, Unit Testing and enhancing existing Business Objects Universes.
• We modify, test and promote the universes to the Repository on Quarterly basis.
• Monitoring user access request activity for unresolved requests and intervening when necessary to ensure the request is addressed by the proper approver.
• Monitoring servers on regular basis.
• Extensive use of Info View, Desktop Intelligence, Web Intelligence, Import Wizard and other CMC controlled functions.
• Co-ordinated with testing team in preparing BOBJ test plans on different projects.
• Interacted with customer support regularly, supporting BOBJ queries/report functionality, resolving issues ranging from report publishing/scheduling to database connections and giving support to the users.

Environment: SAP Business Objects XIR3.1/4.0/4.1 SP5 (IDT, UDT, BI Launch PAD, CMC), Dashboard4.0,SAP Crystal report, Tableau 7.0/8.1,Oracle EBS,Teradata,DataStageV8.0, Erwin.

Confidential

Responsibilities:

• Participating in End user meeting along with Univision Team to understand the enhancement requirement and propose cost effective solutions.
• Being part of offshore and onsite model, manage offshore team on day to day basis.
• Provide analysis and solutions for issues on SAP Business Objects, Tableau, Crystal Reports and database objects.
• Familiarize the team with the customer needs, specifications, design targets, the development process, design standards, techniques and tools to support task performance.
• Work closely with multiple cross functional teams to effectively co-ordinate and manage business user expectations.
• Manage solutions delivery of concurrent projects using on-site/off-shore resources.
• Provide subject matter expertise to support reporting needs for multiple functional area.
• Capture user-feedback/comments on the delivered system and document it for the client and project manager's review. Also provide training for business users.
• Resolving critical tickets to make sure the business continuity and to avoid revenue loss.
• Participating in daily status meetings to update the status and task prioritization.
• Responsible for updating the appropriate status in Univision tracking system.
• Interacting with team members to ensure smooth progress of project work, maintaining quality throughout the system development life cycle, Process and providing support to the users on the application.
• Day to day job includes Managing, administering and supporting infrastructure, which includes On-Call duties as specified in the on-call checklist such as monitoring and resolving support tickets.
• Involved in Developing, Maintaining, Unit Testing and enhancing existing Business Objects Universes.
• We modify, test and promote the universes to the Repository on Quarterly basis.
• Monitoring user access request activity for unresolved requests and intervening when necessary to ensure the request is addressed by the proper approver.
• Monitoring servers on regular basis.
• Extensive use of Info View, Desktop Intelligence, Web Intelligence, Import Wizard and other CMC controlled functions.
• Co-ordinated with testing team in preparing BOBJ test plans on different projects.
• Interacted with customer support regularly, supporting BOBJ queries/report functionality, resolving issues ranging from report publishing/scheduling to database connections and giving support to the users.

Environment: SAP Business Objects XIR3.1/4.0 (IDT, UDT, BI Launch PAD, CMC), Dashboard4.0,SAP Crystal report, Tableau 7.0/8.1,Oracle EBS,Teradata,DataStageV8.0, Erwin.

Confidential, Milwaukee, WI

Sr.SAP BO/BI Consultant

Responsibilities:

• Involved in business meetings to gather requirements
• Provided the estimation for the reports based on report complexity and query design.
• Gathered User requirement for new reports and designed the functional specs as per the user requirements.
• Designed the Technical spec as per the functional spec by converting the requirement to the report prototypes.
• Did Installation, support and maintaining of servers.
• Supported CMC for supervising and security domain which includes creating users, groups, providing access Confidential various levels.
• Maintained the Business Objects, authorized the connectivity of tools to the Objects and authenticate the password.
• Maintained and developed the backup script for Business Objects.
• Managing Security and administration activities for the team.
• Working with the administrator team who was involved in installation of BO, tomcat on linux and windows server.
• Migrated the Users, Groups, Universes, and Personal Folders, Connections, Reports (DeskI & WebI), Excel, pdf and Instances to Production, Development and Test Environments using Import Wizard.
• Worked on CMC for creating, organizing, scheduling, and publishing of BO objects.
• Implement the policies for the use of the computer system and network.
• Setup security policies for users.
• Created a backup and recovery policy.
• Designed, developed and implemented solutions with data warehouse, ETL, data analysis, and BI reporting technologies.
• Pulled Sales Order data using SLT replication from ECC system for warehousing purpose Confidential HANA.
• In Sales and Distribution module, I got chance to work in Sales order processing, Return orders, Delivery process, Invoicing process.
• All these data got used in Recap reporting related to Sales & distribution area.
• Also we had to bring Sales Order, memo, Invoices, Customer Detail, Exchange Rate for other reporting purpose.
• Developed various Data warehouse Models like, Analytical view, Attribute view and Calculated view using HANA Studio.
• Creating reports in SAP BOBJ.
• Designed Various HANA views after data load from transactional system to the HANA.
• Created universe using IDT from the calculated views created on HANA DB.
• Analyzed the Universe data using explorer, Webi and other reporting tools.
• Strong experience with OLAP reporting in BW and implementation of BEx Analyzer. Worked extensively with BEx Query Designer, BEx Analyzer & Workbooks for developing reports, analysis, and Web reporting.
• Basically The Data Service is used to load the non SAP data to the HANA Database.
• Created some Batch jobs from the non SAP data like from the Oracle database,DB2 databse and loaded to the HANA database.
• Form the HANA database created universes and from the universe created some WEBI reports,Crustal Report and Dashboards.
• Using Universe & Crystal Reports and Webi Reports as a Data source of Xcelsius to build the dashboards thru Use live office & QAAWS to getting the live data. By Using Single Sign on (SSO).
• Using SAP Netwear BW Connection to connect the SAP BEx queries into getting the data from Xcelsius Dashboards.
• Extensively used QAAWS and Live Office to get the live data. Created Dynamic Visibility dashboard reports in Xcelsius.
• Used Xcelsius Visualization of dashboards to pull the data from the required reports to Excel sheet by using Universe as data source. QAAWS & Web services, Live Office as a middle ware using Data feeding to Excel sheet. And analyzing, Designing and developing dashboards
• Creation of Dashboards Converting Business Data requirements into Conceptual and logical data models. Commonly used excel functions ("VLookup, Hlookup, Index, Match and Conditional statements") Microsoft excel as a data source.
• Exported Dashboards to BOE Server Exported visualization contents to various file formats (pdf, ppt, and html, flash).
• Worked on Load monitoring and good exposure on solving load failures.

Environment: SAP Business Objects 4.0(IDT,UDT,BI Launch PAD,CMC), Dashboard4.0, SAP Crystal report, SAP Business Object Data Services (BOD4.0)/Data Integrator, SAP HANA 1.0, SAP BW 7.0,UNIX Shell Scripting

Confidential

Responsibilities:

• Provided the estimation for the reports based on report complexity and query design.
• Gathered User requirement for new reports and designed the functional specs as per the user requirements.
• Designed the Technical spec as per the functional spec by converting the requirement to the report prototypes.
• Involved to Support CMC for supervising and security domain which includes creating users, groups, providing access Confidential various levels.
• Maintained the Business Objects, authorized the connectivity of tools to the Objects and authenticate the password.
• Designed and Build Universes, Classes and objects for Category Management System.
• Designed Universe by creating the Business Objects Data Model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the Objects like Dimensions, Details and Measures, which are grouped into Classes and Checked the Integrity of the Universes.
• Also created some universe level filters.
• Exported the universes to the repository to make resources available to the users. Created reports for various Portfolios using the Universes as the main Data Providers.
• Use of Reporter, Designer, Query Panel and Data Provider; handling of ODBC issues
• Worked on Universes, Query Panel, Prompts and Report Layout and re-formatting.
• Developed three types of reports like Graphical Reports, Data Dump Reports and formatted Reports in Web Intelligence as per the requirement from clients.
• Developed reports using various functions, operators, Calculation Contexts, report filters and variables.
• Created Data security also in the universe level.
• Exported the Business Objects reports to WEBI XI to be viewed by all users.
• Used Drill Down, Cross tab, Sub reports extensively.
• Experience to developed Navigate the interface Creating Dynamic Dashboards. Data can be exposed different levels By Drill down functionality. Using these Reports the end user can analyze data Confidential different levels like 'By age Group', 'By Gender' 'By Brand' 'By Product'.
• Maintenance, Migration, Testing, Change the color scheme for components in a dashboard. Dashboard gives the information of the Best 10 stores by Shrink (%), Worst 10 stores by shrink (%) by region.
• Applying Time standard Monthly Reports, Quarterly Reports - Annual Reports published by Revenue. Designed Dashboard Using SAP Xcelsius Tool from flat files. Using Add-on components to create the Dashboards. Creating user authentication for the dashboards.
• Using Universe & Crystal Reports and Webi Reports as a Data source of Xcelsius to build the dashboards thru Use live office & QAAWS to getting the live data. By Using Single Sign on (SSO).
• Using SAP Netwear BW Connection to connect the SAP BEx queries into getting the data from Xcelsius Dashboards.
• Used Xcelsius Visualization of dashboards to pull the data from the required reports to Excel sheet by using Universe as data source. QAAWS & Web services, Live Office as a middle ware using Data feeding to Excel sheet. And analyzing, Designing and developing dashboards.
• Creation of Dashboards Converting Business Data requirements into Conceptual and logical data models.
• Commonly used excel functions ("VLookup, Hlookup, Index, Match and Conditional statements") Microsoft excel as a data source.
• Exported Dashboards to BOE Server Exported visualization contents to various file formats (pdf, ppt, and html, flash).
• Confidential the reporting end I modified the Universes for accommodating the new table structure change in the database.
• There are twenty to thirty reports which are modified as per the modified universe structures.
• Also few reports are created which were based on the new SAP data structures.
• Involved in creating reports on the web using Business Objects Web Intelligence XI.
• Wrote UNIX Shell Scripts to automate the process.
• Basically used the BODS for extracting the data from the Legacy system load into the Oracle database.
• Used various Transforms like Map Operation, Table Comparisons, Row-Generation, Query History Generation, Key Generation, Pivot, Reverse Pivot and functions like lookup, index search for transforming data.
• Involved in creating the data warehouse model.
• Configured the mappings to handle the updates to preserve the existing records using History Preserve Transformation (Slowly Changing Dimensions Type-2)
• Created mappings using Designer and designed workflows using Workflows to build DW as per business rules.
• Also involved in the testing of some data service jobs.
• Prepared the UT document during development phase and also designed TPCN, PPCN for the migration of reports and universes from DEV to QA and QA to production.
• Did the SQL performance tuning.
• Developed System testing documents for integration testing before migration to QA.

Environment: SAP Business Objects XIR3.1 (Universe Designer, Webi),Xcelsius/Dashboard 2008, SAP Crystal report, CMC,SAP BODS3.1,SAP BW, IBM AIX, Oracle 10g,SQL, PL/SQL, TOAD 9.0, UNIX Shell Scripting and Kimball Data warehouse modeling

Confidential

Responsibilities:

• Designed Technical spec as per the functional spec with Universe and reporting solutions.
• Designed Business Objects Universes. Used Contexts and Alias to resolve the Loops.
• Involved to convert the crystal report to the Webi reports.
• Developed reports using various functions, operators, report filters and variables.
• Worked on Universes, Query Panel, Prompts and Report Layout and re-formatting.
• Created reports containing formatting options such as Grouping, Sorting, Alerting, Ranking, Field highlighting, Drill-down, Parameter prompt.
• Designed a complex report with 15 tabs with multiple queries underlying.
• Also created some Dashboards for the visualization purposes.
• Experience to developed Navigate the interface Creating Dynamic Dashboards. Data can be exposed different levels By Drill down functionality.
• Using these Reports the end user can analyze data Confidential different levels like 'By age Group', 'By Gender' 'By Brand' 'By Product'.
• Maintenance, Migration, Testing, Change the color scheme for components in a dashboard. Dashboard gives the information of the Best 10 stores by Shrink (%), Worst 10 stores by shrink (%) by region.
• Using Universe & Crystal Reports and Webi Reports as a Data source of Xcelsius to build the dashboards thru Use live office & QAAWS to getting the live data. By Using Single Sign on (SSO).
• Used Xcelsius Visualization of dashboards to pull the data from the required reports to Excel sheet by using Universe as data source.
• QAAWS & Web services, Live Office as a middle ware using Data feeding to Excel sheet. And analyzing, Designing and developing dashboards.
• Exported Dashboards to BOE Server Exported visualization contents to various file formats (pdf, ppt, and html, flash).
• Used the BODS to extract data from the legacy system to load Oracle database.
• Used various Transforms like Map Operation, Table Comparisons, Row-Generation, Query History Generation, Key Generation, Pivot, Reverse Pivot and functions like lookup, index search for transforming data.
• Worked with the Business analysts and Subject Matter Experts to thoroughly understand the different business processes and data Confidential various sources.
• Developed ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Kimball data warehouse methodology is used to modeling the data warehouse.

Environment: SAP Business Objects XIR3.1,CMC,Xcelsius 2008, SAP Crystal report, SASP BODS3.1CSV files, flat files, IBM AIX, Oracle 10g, PL/SQL, TOAD 9.0, UNIX Shell Scripting and Kimball Data warehouse modeling

Confidential, Moline, IL

BO Consultant

Responsibilities:

• Designed and Build Universes, Classes and objects for Global Long-Term Forecasting system.
• Designed Universe by creating the Data Model, selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the Objects like Dimensions, Details and Measures, which are grouped into Classes and Checked the Integrity of the Universes.
• Also created some universe level filters.
• Exported the universes to the Repository to make resources available to the users. Created reports for various Portfolios using the Universes as the main Data Providers.
• Involved in issue of Report, Universe, Query, and ODBC.
• Worked on Universes, Query Panel, Prompts and Report Layout and re-formatting.
• Developed three types of reports like Graphical Reports, Data Dump Reports and formatted Reports in Web Intelligence as per the requirement from clients.
• Created reports containing formatting options such as Grouping, Sorting, Alerting, Ranking, Field highlighting, Drill-down, Parameter prompt.
• Developed reports using various functions, operators, Calculation Contexts, report filters and variables.
• Restricted the data using the Prompts and filters. Developed reports using Cross tab, PIE and BAR Charts with Drill down option using Drill down Report Expert and also used in combining the cross tab and vertical bar charts.
• Various Graphical Reports have been created in 2D/3D dimensional format.
• In data dump reports I had used the combined query, unions, merged dimensions and also Templates.
• Also used purging for deleting the old data and data tracking for checking the new changes.
• Exported Reports into PDF & Excel from Enterprise and resolved formatting related to issues.
• And also modified few existing Data Stage jobs and also created some job to do fact load like Forecast Fact in the Data Stage.
• Designed warehouse in Kimball methodology.

Environment: Business Objects XIR2 (Designer, web intelligence, desktop intelligence), BODS, CSV files, flat files, IBM AIX, Oracle 10g, PL/SQL, TOAD 9.0, UNIX Shell Scripting

Confidential, Kansas City, MO

BO Developer

Responsibilities:

• Interacted with the Business analyst and the Manager in gathering the business requirements to design and develop.
• Analyzed the existing database tables and designed Universes using Designer module for generating reports.
• Conducted Study to Build Universe’s Classes and Objects involving everyday terms that supports Users. Object properties defining Measure, Dimension and Details were created.
• Involved in development and deployment of Complex Reports.
• Created canned and Ad-hoc reports using WebI/Deski Reports.
• Created Reports showing attempted calls, type of call (long distance, local), and length of call, originated number, destination number, rates, and time of call for creating report for billing of a customer.
• Used Designer as a part of Universe Development for Defining the Parameters of Universe, Inserting the table, making Joins, Resolving Loop's, Creating Classes, and Objects.
• Involved in creation of Filters, @prompts and setup Hierarchies for Multidimensional Analysis.
• Creating the Reports using the Universes as the main Data providers and writing the complex queries including Sub Queries using Deski reports XI.
• Created reports using Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Alerter and Formulae etc using Web intelligence.
• Created & Modified Universes for various functional areas of high level reports group using Designer.
• Customized LOVs in Universes for quicker performance of reports.
• Used SQL against the database to check data retrieved.
• Changed the universe parameter settings to optimize the performance of universe.
• According to the customer information created complex report using Universe as main data provider.
• Exported the universes to the Repository making resources available to the users.
• Involved in creation of Reports, formatting reports, generation of charts, bars etc as per user requirements using Webi.
• Modified many existing WEBI reports.
• Worked with the team who has involved in migrating Business Objects (Universe, Reports, and BCA) from ver. 6x to ver. XI R2.

Environment: BO XI R2, BODS,Oracle Developer 10g, Oracle 10g, PL/SQL, SunOS 5.10, TOAD 9, HP-UX 11.11

Confidential, Overland Park, KS

BO Developer

Responsibilities:

• Work closely with the project lead to write the design documents for reports and universes.
• Modified the existing Business Object Universe and Business Objects Report.
• Also the new universe were designed and developed to support the user requirements.
• Created many Master Detail and Cross tab reports.
• Trouble shooting and tuning of the existing reports (Web Intelligence and Desktop Intelligence).
• Used prompts in the report as well as in the universe to create more interactive reports.

Environment: Business Objects 6.5, Business Objects XI, Oracle 9i, PL/SQL, HP UNIX 5.10, and TOAD 8.0

Confidential

Software Engineer

Responsibilities:

• Worked with Lead to understand the requirement of the project.
• Understood the universe design by going through the various existing universe.
• Involved in modification and deployment of Webi Reports.
• Written the SQL queries to validate the report data.
• Involved in various reports testing.

Environment: Business Objects 6.5, Oracle 9i, HP UNIX 5.10, TOAD 8.0