SUMMARY

• Over 8+ years of experience in the Business Requirements Analysis, Application Design, Dimensional Data Modeling, Development, Testing, Implementation, maintenance, documentation.
• Worked on SAP Business Objects XI 3.1,4.0, XIR2, 6.x, and 5.x Suite (Desktop and Enterprise Server products suite), Web Intelligence, Voyager, Performance Management and Dashboard Manager, Xcelsius, Data Integrator/Data Services.
• Expert in SAP Business Objects Designer, Bex Query Designer, Voyager, Desktop Intelligence, Supervisor/CMC, Info view, Full-Client, and Web Intelligence tools.
• Good Experience and analytical skills in reporting requirements into drill-down/drill-across universe support, and review designs with business users.
• Excellent skills in analysis and business requirements gathering from end users to the client and experience in documentation of developed applications.
• Sound knowledge in Star & Snowflake Schemas.
• Developing all Data Integrator mappings to load data from multiple SQL Server data sources for load into a custom reporting data mart.
• Effectively tested and documented all Jobs/Workflows/Dataflows.
• Expertise in translating business reporting requirements into universe strategies and design.
• Good Experience in architecture.
• In-depth knowledge in creation of WEBI reports and Dashboards using Xcelsius.
• Knowledge of migration from Crystal reporting to SAP Business Objects and end-users.
• Worked on Bex Query Designer by performing advanced data analysis and hierarchical member selection within the SAP BusinessObjects query and analysis tools such as SAP Business Objects Web Intelligence, SAP Crystal Reports Enterprise and SAP BusinessObjects Dashboards.
• Experience in Full Software development life cycle (SDLC) knowledge from Requirements Gathering, Technical Design, analysis, development and support.
• Proficient in setting up Repository, creating and managing users and user groups and security.
• Proficient in creating reports using Business Objects XI R2 functionalities such as Queries, Master/Detail and Formula, Slice and Dice, Drilling, Cross Tab and Charts.
• Proficient in SQL, PL/SQL developed Stored Procedures, Triggers, Functions and Packages besides writing DDL, DML and Transaction queries with development tools like TOAD.
• Configuration of basic operating system software RDBMS (Oracle), providing UNIX level support to DBA/Application administrator.
• Flexible and resourceful, applying strong organizational, time-management and planning skills to deliver projects on time and budget, despite intense pressure and aggressive timelines.
• Ability to communicate effectively with all levels of management and the client community.

Technical Skills:
Business Intelligence Tools: SAP Business Objects XI R2/R3.1/Xi4.0, 6.X, 5.X
Reporting Tools: Xcelsius 4.5, 2008
DWH Methodologies: Star Schema, Snowflake Schema
Database Servers: Oracle 11g/10g/9i/8i, SQL Server, DB2 (UDB),Terradata
Data Modeling: ERwin
Languages: PL/SQL, T-SQL, C, JAVA
Platforms: Windows 98/2000/XP/2003, UNIX, Solaris10/9, Linux (Ubuntu), Mac
Data Loading Utilities: SQL * Loader, BCP, DTS
Source Controls: Microsoft Visual Source Safe, Clear Case, Source Offsite, Perforce
Project Management: Microsoft Project , Microsoft Vision
Web Tools: HTML, XHTML, CSS, CGI-perl, JavaScript, VBScript

Education
B. Tech, Computer Science

Confidential, New York City. Feb '11 - Present
Business Objects Consultant
Guardian Life Insurance Company is one of the Fortune 500 companies and top insurance company in US. It has a huge Guardian dataware house at its headquarters in NYC which supports its business decision making process. The main objective of the project was to build universes and generate reports which are used by different managers to analyze the sales, performance of various agencies & sales representatives and also to calculate and analyze bonus for sales representatives.
Responsibilities:

• Participate in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Creating, modifying, maintaining and managing Universes and implementing row level security.
• Maintenance, support, administration of SAP Business Objects XI R4.0/R3.1/R2 and SAP Business Objects 6.5 environments.
• Interacted with business managers and end users to know their Business views in developing and modifying Universes and Reports accordingly.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for SAP Business Objects Universes and Reports.
• Created different Universe and Document domains.
• Involved in the designing and Building of Universes, Classes and Objects.
• Resolved loop and traps using Contexts and Aliases.
• Exported the universes to the Repository to making resources available to the users.
• Created reports for various Portfolios using the Universes as the main Data Providers.
• Created the reports using various SAP Business Objects functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc.
• Developed both Full client and WebI reports.
• Experience in Crystal Xcelsius to create interactive dashboards by using QAAWS and Live Office.
• Used Live Office and QaaWs (Query as a Web Service) to feed live data into Xcelsius 2008 to show product portfolio.
• Created complex Xcelsius dash boards to reflect User Adoption Metrics.
• Created complex Xcelsius dash boards by connecting directly with existing Crystal Reports and XML files.
• Set up groups and users for SAP Business Objects deployment.
• Managed user profiles using Supervisor.
• Published and scheduled SAP Business Objects Reports to users using BCA Scheduler and SDK.
• Gathering requirements and creating dashboards using Crystal Xcelsius.
• Hands-on experience in the application of the more advanced capabilities of Xcelsius such as trend analysis, predictive analysis, drilling, graphic design, dynamic adjustment of X & Y axis as selections changes.
• Created interactive dashboards from Microsoft Excel or a live data source, and export your dashboard to a familiar format like M.S.Office, Flash (SWF) files, Adobe PDF, and Adobe AIR.
• Extend, manage, and secure access to real-time company data with one-click export of your Dashboards to SAP Crystal Reports Server and corporate portals.
• Develop and deploy performance dashboards and business applications connected to your corporate database.
• Designed Job/Workflow/Dataflow structure for optimized batch load performance.
• Effectively tested and documented all Jobs/Workflows/Dataflows.
• Involved in loading of data into Terradata from legacy systems and flat files using complex scripts.
• Extensively used Teradata and Oracle utilities such as FastLoad, Multiload, Tpump and Toad.
• Involved in using Excel, Excel VBA, and Teradata SQL to analyze the data and calculate results.
• Experience in developing dimensional modeling solution based on SAP Data Integrator backend.
• Developing all Data Integrator mappings to load data from multiple SQL Server data sources for load into a custom reporting data mart.

Environment: SAP Business Objects XI R2/R3.1/4.0,6.1,6.5, Data Integrator/Data Services, WebIntelligence, Xcelsius 2008/4.5, Designer, Supervisor, CMC, Oracle 11g/10g/9i, Teradata, MS SQL server, PL/SQL, Windows NT, UNIX, IIS.

Confidential, Dallas, TX May'09 - Dec '10
Business Object Developer
Providian financial is one of the leading financial companies in USA. Providian has various data marts like OIS, ODSP, CAPONE and ICARD. Their marketing information system (MIS) team runs reporting on pre-screen, non-prescreen and booked data for their various decision supports. The MIS team runs report by setting many options manually, since the data is stored at various servers. In order to eliminate the cumbersome and time consuming process, the ADM project arises to serve MIS development team have better reports, time savings and better utilization of data. The ADM process will store all static information about the Acquired/Booked customer required by MIS team.
Responsibilities:

• Designed, developed and maintained Universes for supporting Adhoc and Canned reports.
• Maintained security for the end users by giving privileges with supervisor module.
• Used BO universe as an input to Xcelsius using Query as a Web Service.
• Utilized Xml, Sql services, Webservices, oracle sources for generating dashboards.
• Made graphical analysis and dashboards.
• Coordinated with ETL, Data warehouse team to implement the Star Schema modeling.
• Created Context, Alias to resolve the Loops in the universe.
• Created user objects to enhance the reporting needs.
• Object properties (Dimension, Measure & Detail) are defined properly at the design level so that it does affect the reports and charts.
• Created Filters (Condition Objects) to improve the report generation.
• Created Hierarchies from providing drill down options for the end-user.
• Maintained security for the end users by giving privileges with Supervisor.
• Created the Derived and Aggregate Tables.
• Detected cardinalities and checked the Integrity of Universes.
• Created variables, @prompt (Interactive objects), formulas and etc.
• Created Standard reports, Summary, Cross Tabs, sub reports using Crystal Reports.
• Using various visual analytics, themes, colors, and fonts, customize the look and feel of dashboards to fit the corporate standards.
• Increase productivity by consolidating multiple reports into a single live dashboard.
• With point-and-click ease, created live business dashboardsfrom any Microsoft SQL Server Reporting
• Maintained whether the SAP Crystal Dashboard Design visualization is deployed to Infoview, Dashboard Builder, orembeded inside Microsoft Office and Adobe PDF.
• Summarize rows of data in easy-to-understand charts and maps and provide report-level details.
• Creating interactive Xcelsius dashboards by using QAAWS and Live Office.
• Created complex Xcelsius dash boards by connecting directly with existing Crystal Reports and XML files.
• Fast-Load, MultiLoad, BTEQ & Fast-Export were the Teradata utilities used.
• Designed and created macros using Excel and VBA, including a macro to get customized reports.

Environment: SAP Business Objects Xir2/3.1/6.5,Terradata, Xcelsius 2008/4.5, Designer, Supervisor, Web Intelligence, SQL Server, Crystal Reports 8.0, Windows NT

Confidential, Seattle, WA Feb '07 - April '09
Business Objects Developer and Reporter
Washington Mutual is a banking company which has its roots based in, as early as in the end of 18th century, and today it has become one of the biggest Banking Services after it went public in 1983. It offers many types of loans for personal loans, refinance loans, mortgage loans and company loans. The project scope was to design universes and build reports for decision support for personal and institutional loan data. The reports are built from data received from various branches and these reports give summarized view for optimized decision making.
Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for SAP Business Objects Universes and Reports.
• Involved in the designing and Building of Universes, Classes and Objects.
• Resolve loop using Contexts and Aliases.
• Exported the universes to the Repository to making resources available to the users.
• Created reports for various Portfolios using the Universes as the main Data Providers.
• Created the reports using SAP Business Objects functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc.
• Created Schedulers to monitor Broadcast Agent.
• Built full client and WebI reports.
• Designed, developed and tested the reports based upon data generated by enterprise transaction, financial, and customer information systems.
• Created SAP Business Objects Repository while building SAP Business Objects solution.
• Created and tested classes and objects to organize the universe.
• Published and scheduled SAP Business Objects Reports to users using Scheduler.
• Created and Maintained load jobs using BTEQ, FASTLOAD and MLOAD in Terradata.

Environment: Business Objects 6.5, WEBI, Designer, Supervisor, Broadcast Agent, ZABO, Terradata, PL/SQL, Windows NT, Crystal reports 9.0.

Confidential, IN Oct' 06 - Feb' 07
Reports developer
Description: Confidential, is one of the largest players in Pharmaceutical Industry. A data warehouse was built by extracting data from different sources and various analytical reports were generated. Informatica, ETL tool was used to extract data and Business objects used for reporting for CLIMATE4.0 Release.
Responsibilities:

Created the Complex reports using the multiple Data Providers and functionalities such as Cross Tab, Slice and Dice, Drill down and Master Detail for Banking Tracking Project. Created Business Objects Reports for CLIMATE4.0 Project to test new derived Objects.

• Did Formal and Informal testing of all the Objects.

Written Test Scripts for all the Objects tested. Provided Testing Support to the Team and find the bugs in Universe.

• Also worked parallel with other project CSB6.0 and Banking Tracking Projects for creating reports and writing validation documents.
• Involved in solving loops in CSB Universe and removed bugs.
• Extensively used Teradata utilities such as BTEQ, FastLoad, Multiload.

Environment: SAP Business Objects 6.5/XI Release2, Central Management Console, Universe Designer, BCA, Infoview, Oracle 8i,Terradata, Sql Server 2000, SQL, PL/SQL, SQL * Loader, UNIX, TOAD, Windows 2003 Server.

Confidential, Chennai, India March' 04 - Sep' 06

Confidential, is a global provider of IT and Process outsourcing services. We focus exclusively on maximizing client returns from outsourcing and off-shoring. Hexaware has a client base comprising several Global 1000 organizations Client 2: Best Buy, MN Business Objects Developer Worked as a SAP Business Objects developer to create reports and universes to supports Users in Best Buy. Also involved in migrating the reports and universes from previous Versions to new version.

• Responsibilities:
• Interacting with Business Users and Business Analysts to understand and document the requirements and Built Universes for end user reports generation using SAP Business Object 6.5
• Good experience with Supervisor in creating users/groups and assigning privileges.
• Designed and developed complex Universes.
• Defined various Contexts and aliases in Universe.
• Implemented various Schema modeling techniques like star and snowflake schemas.
• Optimized different types of queries in enhancing the performance of the universe.
• Created various Object hierarchies to allow users to perform multidimensional analysis.
• Used derived tables.
• Resolved fan traps and chasm traps and loops.
• Used various functions like @Aggregate aware, @prompt, @select in designing the universe.
• Implemented Multiple Linking of data providers using merge dimensions combining data from two Universes.
• Performed Indexing in coordination with the Business objects administrator improving the performance of reports.
• Done enhancements to the existing reports like linking the reports in the repository at the universe level.
• Defined analytical functions for the function groups like ranking, accumulativeaggregation.
• Managed universes like deploying, setting security controls and optimizing the universe.
• Developed several Complex Reports, various features include multiple groupings, drilldowns, parameter fields, functions, Type Conversions, formulas, Running Totals and conditional suppressing, formatting using Crystal Reports.
• Developed Summarized Cross-Tab, Master/Detail Reports by implementing various functionalities like Custom Filtering, Creating Alerts, Date and String functions.
• Created linked and Unlinked Sub reports and used different Custom Functions and worked with various Financial Functions.
• Visualized Data and enhanced reports using different types of charts like Histogram charts, Bar charts and Funnel charts.
• Carried out the performance monitoring and tuning of reports.
• Done troubleshooting in database connectivity problems in the various designer components of Crystal Reports.
• Generated SQL scripts for validating and testing reports.
• Trained users in scheduling reports in BOXI server.
• Environment: SAP Business Objects 6.5, Designer, Web Intelligence 6.5, SQL Server 2005, Windows XP

Client 1: Confidential, India
Database Analyst
We developed software for keeping track of checking accounts, saving account, Investment Information, generate reports, loan information, and for archiving the older transaction. Involved in the design phase and responsible for creating GUI interface for the Personnel information system Module. The system includes the software application tools development to convert data from Database to Oracle and generation of reports by using Oracle tools.

Responsibilities

• Involved in design, development and implementation.
• Responsible for development of forms and interfacing the data selection from the database.
• Created various GUI for the personnel Information System Module.
• Assisted in developing reports on Branch turnover and profits.
• Assisted in the Development of several reports including tabular, master detail, daily reports.

Environment: Oracle 6.x/7.x, Forms 4.5, Report 2.5, UNIX, and Windows 3.x/95