SUMMARY:

• Confidential is a Business Objects developer with a rare combination of excellent communication skills, deep technical knowledge and broad BI functional experience.
• His passion is designing and implementing technical solutions that enable companies to significantly increase the value derived from their investment.
• Over 9 years of IT industry Experience.
• With strong knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production support on various platforms like UNIX, Windows NT/2000/XP/98.
• Worked with End - to-End implementation with Data warehousing team and Strong understanding of Data warehouse concepts OLTP, OLAP, Star Schema, Snowflake Schema and Multi-Dimensional Models for query and analysis requirements.
• Experience in designing Universe using Universe Design Tool & Information Design Tool.
• Experience in developing reports using Web Intelligence, Crystal Reports and Dashboard design tools.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Experience in Optimization and Performance tuning of new and existing Business Objects universes, reports.
• Data Modeling using Star Schema and Extended Star Schema for Data reporting.
• Strong Knowledge of RDBMS and SQL.
• Expert in tuning the performance of SQL queries and ETL process.
• Ability to work under pressure with cross-functional, cross geographic and cross-cultural teams
• Excellent communication skills both verbally and written.
• Proactive and self-starter with the great ability of leadership.

TECHNICAL SKILLS:

Tools: Business Objects (4.1/4.0/XIR3.1/XIR/6.5), BODS 4.0, Crystal Reports 2008/XI/Enterprise, Xcelsius Data Visualization, Dashboard Designer, Central Management Console, Central Configuration Manager, Desktop Intelligence, Web intelligence, Webi Rich client, Live Office, SAP Lumira, SAP Design Studio, Import Wizard, SSIS, SSRS, QaaWS, Report Conversion Tool and Services.

Databases: Oracle 10g/9i/8i, MS SQL Server 2000/2005/2008/2012 , Sybase 11, PL/SQL, IBM DB2, MS Access, SAP BW, SAP ECC 6.0, SAP ERP

Languages: C, C++, SQL, PL/SQL, XML, HTML, Perl, C-Shell, TCL

Operating Systems: Windows 2000/XP/NT, MS DOS and UNIX

Utilities: MS Word, MS Excel, MS PowerPoint

WORK EXPERIENCE:

Sr. BO Developer

Confidential, Arlington, TX

Responsibilities:

• Development, Support and administration for Universe and Reports creation using SAP BOBI 4.1
• Interacted with Business Users and Mangers in gathering business requirement.
• Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
• Involved in complete architectural design of BO4.1 as global reporting portal.
• Implemented data warehousing schemas like star-schema snow-flake schema.
• Perform Universe migration from XI R3.1 to 4.1. If required design Universe from scratch.
• Involved in designing and building of Universes, Classes and Objects using IDT.
• Fix any loops and traps in the newly developed universe and also add access level restrictions (Row/Object level) as per guidelines.
• Check the integrity of the Universes and export the universes to repository for making them available to the users.
• Provide technical support in creating new Web Intelligence reports as per blue print provided.
• Created the reports using Business Objects functionalities like merged queries, sub-queries, drill-down.
• Created Breaks, Filters at Different Levels of the reports and applied ranking in the Webi reports.
• Extensively worked on formatting the reports according to the user requirements.
• Need to do performance tuning for faster update of reports.
• Guide and Train new engineers in developing reports.
• Drive client level meetings. Need to address all client quires related to reports generated.
• Modify or update reports as per client request.
• Developed Dashboards according to user specifications using Dashboard Designer.
• Coordination and work along with the ETL team to ensure the timely execution of the feeds to the reporting tables as well as testing the quality of data and providing inputs to them.
• Perform address and data cleansing using BODS before report generation as per the client guidelines.
• Create required aggregate tables using BODS as per reporting requirement.
• Recommended standards of good practices of report development and maintenance of universes.
• Developed universe user guide for end user reference.

Environment: SQL Server 2008/2012, SAP BOBI 4.1, Web intelligence, BODS 4.0, CMC, BI Launchpad, Information Design Tool, Dashboard Designer, QaaWS, Upgrade Manger.

Sr. BO Developer

Confidential, Sunnyvale, CA

Responsibilities:

• Work with Project Manager to gather Business user requirement before generating reports.
• Manage enterprise business intelligence solution based on BI 4.0 platform.
• Interact with Senior Business Objects Consultants as well as Business users to identify the reports for developing and modifying as per Business user requirements.
• Involved in building universe, inserting tables, detecting joins and checking integrity.
• Created universes, classes, objects, prompts, predefined conditions by retrieving the data from data sources and defining the necessary connections.
• Optimize and perform tuning of new and existing business objects universes and reports.
• Export the universes to the repository to make resources available to users for ad-hoc reporting needs.
• Migrate universes from development to production environment.
• Designed and developed reports using WebI.
• Developed reports like simple, complex, cross tab using multiple queries, prompts, combination of charts and tables.
• Created, maintained and modified the business critical reports using Web Intelligence.
• Work with Date Modellers and ETL team to resolve data issues.
• Test the reports developed to ensure that the date is accurate and valid.
• Perform data verification comparing the existing reports against the new reports.
• Work with BO administrator to resolve security issues.
• Create ad hoc dash board reports as per Business User requirement using Lumira.
• Train Business Users to interpret and modify reports as and when needed.
• Develop universe user document guide for end users reference.

Environment: MS access, SQL Server 2012, SAP BOBI 4.0, WebI, Dashboard Designer, Lumira, Information Design Tool, SAP Design Studio, BODS 4.0, CMC, BI Lauchpad. Team Foundation Server 2010(TFS)

Sr. BO Developer

Confidential, Austin, TX

Responsibilities:

• Participate in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in universe.
• Exported the universes to the repository to make resources available to users for ad-hoc report needs.
• Create reports containing all information using web intelligence.
• Created custom dashboard reports as per the requirement.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according to user requirements.
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
• Developed universe user documentation guide for end users reference.
• Involved in full life cycle of Business Objects Reporting application.
• Created Multiple Universes in Designer in secure connection as well shared connection.
• Trained users to use interpret and modify reports as and when needed.

Environment: Information Design Tool, CMC, SAP ECC, SAP CRM, SQL Server 2008, Crystal Reports for Enterprise, WebI.

Report Developer

Confidential, Orlando, FL

Responsibilities:

• Provide technical support in designing and development for Universe.
• Creating universes by defining connections and retrieving data from database
• Generated reports for web users using Web Intelligence.
• Extensively used designer to design various universes for different business groups.
• Generated various reports on daily, weekly, monthly and yearly basis.
• Imported/Exported the universes from/to repository to make them accessible to end users.
• Created charts to display summary data using universe as main data provider.
• Monitored and solved the issues encountered in universes and reports while migration and tested before moving to production.
• Developed universe user documentation guide for the end users reference.
• Provided training for end users for generating their own report including complicated report.

Environment: Universe Design Tool, Information Design Tool, SAP BW, SAP ECC, BI Launchpad, WebI, Live Office.

BO Developer

Confidential, Atlanta, GA

Responsibilities:

• Worked with Safety Directors and PM’s to gather user requirements.
• Documented the user requirements into Functional and Technical Specifications.
• Analyzed database tables for report requirements and developed Hierarchy Table for Organization Hierarchy.
• Created Derived Tabled for Multiple Incidents Employees (MIE) who were involved in more than 1 incidents for a given time period.
• Created Prompts in the MIE derived table, so that users can enter certain criteria for MIE.
• Created Cascading LOVs for the Organization Hierarchy in Hierarchy Prompt.
• Used Contexts and Aliases to resolve Chasm Traps and Fan Traps.
• Built complex formulas in the Desktop Intelligence documents to accommodate business rules and the report formatting.
• Created several standard reports Desktop Intelligence Documents for the Safety Department, which uses Refresh On Open so that each time prompts are presented to the users to select the report Criteria.
• Created various condition objects as prompts so that users can use these objects in their Ad-Hoc reporting.

Environment: Oracle 10g, Universe Design Tool, Desktop Intelligence.

Sr. Report Developer

Confidential, Atlanta, GA

Responsibilities:

• Involved in Analyzing and Documenting End user requirements, Business requirements and data specifications for Business Objects reports.
• Involved in the creation of Universes, Classes, Objects and Hierarchies for Multidimensional Analysis for Loans, Checking Accounts, Saving Accounts, Accounts Balances and Revenues Generated.
• Created and setup Universes for each reporting group and established a BO Environment.
• Created Derived Tables in the Universe to create frequently used reports.
• Work with staff to upload Crystal Reports to server.
• Created graphical representation of reports such as Bar Charts, Line Charts as per end user requirements.
• Involved in full life cycle of Business Objects reporting application.
• Trained users to use interpret and modify reports as and when needed.
• Created Executive Level Dashboards using Xcelsius.
• Created custom dashboards using Xcelsius as per the requirement.

Environment: Universe Design Tool, Xcelsius 2008, Crystal Reports, SQL Server 2008

Report Developer

Confidential, Atlanta, GA

Responsibilities:

• Interacted with teams to gather their Business requirements in developing and modifying Universes and Reports accordingly.
• Involved in designing and building of Universes, Classes and Objects.
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables, applying context and alias tables to remove cyclic dependencies.
• Importing/Exporting the Universes from/to repository to make them accessible to end users.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab etc.
• Used @functions like @select, @where and @prompt function to create prompts which helps the user to select the values dynamically.
• Customized the list of values (LOVs) which helps the end users to select the values.
• Created many Crystal reports after gathering the requirements from business user.
• Exported the reports in to PDF and Excel format.
• Worked with Data Modelers and ETL team to resolve data issues.
• Migration of Universes and reports from development to Production environment.

Environment: Universe Design Tool, Crystal Reports, Desk Top Intelligence

Jr. Developer

Confidential

Responsibilities:

• Development of the existing reports in Excel and Oracle8i, now in Crystal Reports.
• Data verification comparing the existing reports against the new Crystal Reports.
• Be part of the team for the implementation of Business Objects Crystal Enterprise.
• Attend to the training of the Business Objects Crystal Enterprise.
• Creation of database objects like tables, views, procedures using PL/SQL, SQL.
• Prepared program specifications for PL/SQL Procedures and Functions to do the data migration and conversion.
• Optimize SQL queries for better performance.
• Run batch jobs for loading database tables from flat files using SQL loader.
• Provided occasional IT support by configuring servers and desktop systems.

Environment: Oracle 8i, MS Excel, Crystal Reports, SQL