Over 7 years of experience in IT Industry with expertise in Business Intelligence, BOBJ and Data Warehouse applications.

Professional Skills

• Experience in analysis, design, development, implementation and testing Business Object Applications.
• Extensive experience in Data Analysis using BI tools SAP Business Objects [BOBJ], Crystal Reports.
• Expert in Business Objects Designer, Desktop Intelligence, CMC, CMS, Info view, QAAWS and Web Intelligence tools.
• Experience in Unit, Performance, Integration, Regression and User Acceptance Testing of Reports and Universe.
• Expert in translating business reporting requirements into universe Strategies and design.
• Worked on BO Designer Functionalities like Derived Tables, Contexts, Linked Universes, Aggregate Aware, Index aware, Aliases, complex joins, Customized LOV’s and Cascading LOV’s.
• Experience in retrieving data using Universes, Personal Data Files, Stored Procedures and Free Hand SQL methods and creating Ad-Hoc and canned reports using Full Client & Web Intelligence Tools.
• Expertise in creation of Web Intelligence Documents to create Breaks, Filters, Master/Detail, Drill, Calculations, 2D and 3D Pie Charts.
• Expertise in implementation of reports in different formats using Crystal Report 12/XI/9.0.
• Installation and configuration of Business Objects Enterprise 4.0/XI R2.
• Experience in using oracle 10g/9i/8i in writing SQL Queries and PL/SQL Stored Procedures, Functions and SQL tuning.
• Worked with CMC creating Groups, Users and Folders and assigning proper Security.
• Extensive working knowledge in migration of Business objects Universe from one domain to another.
• Experience in using Import wizard for migrating Business Objects Universe, reports and Database components from one environment to another and experience in working with Report conversion Tool to convert DeskI report to WebI report.
• Experience in transforming Microsoft Excel files to interactive flash media Files (dashboards) using Xcelsius to monitor KPI.
• Extensive knowledge of Data Warehousing and Normalization concepts.
• Experience in creating Database using Data Modeling tool ERWIN. And Strong understanding ofdimensional modeling in star and snowflake schema.
• Experience in extraction, transformation and loading (ETL).
• Experience in Training & Supporting end user reporting needs using Business Objects.
• Expertise in troubleshooting issues.
• Committed in providing total Quality work. And ability to quickly learn new Technologies and solve problems in a team environment as well as individually.

Technical SkillsOLAP Tools:Business objects 4.0,XI R2, 6.5, Crystal Report 12, XI, 9.0, Crystal Xcelsius, Xcelsius 2008Database:Oracle 11g, 10g, 9i, 8i,SQL server 2008,TeraDataWeb Tools: HTML, XML, VBSCRIPT,ASP, JSP.Data modeling Tool:ERWIN 4.X, 3.X.SQL Utilities:TOAD, SQL* PLUS Programming Languages:Java, SQL, PL SQL, VB 6.0, C/C++. Operating Systems: Windows Server 2008,2003, 2000, Red Hat Enterprise,Linux, UNIX

Professional Experience

Confidential, Denver, CO Aug’09 –Till DateRole: Sr. SAP BOBJ Consultant

Responsibilities:

• Attend requirement gathering meeting with business users and technical staff refine requirements for Universe, canned reports, dashboards, and ad-hoc query.
• Designed Universes from Data warehouse, Datamart by defining joins, cardinality between tables, linked the existing Universes Added/created complex objects.
• Created Cascading List of Values with custom hierarchy to improve the performance of the universe and used shortcut joins, aggregate table and created necessary Indexes for fast retrieval of datafrom the universe and used universe defined prompts for interactive reports and used other Functions like @select and @where.
• Involved in WEBI and Crystal reports development.
• Created and maintained reports using universe, stored procedure, freehand SQL as the Data providers and wrote complex queries including Sub Queries, Unions and Aliases using Web Intelligence, Full Client and Crystal Reports.
• Created custom queries for complex reports as per business needs.
• Exported the reports to Infoview to publish it to the end user and schedule report according to the end user requirements.
• Organized data in the Report by Inserting Filters, Sorting, Ranking, Break, Section and highlighting data.
• Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Worked on Crystal reports XI for advanced functionalities (Stored Procedure, Alerts within a graph and superimposing one graph over the other, multiple y-Axis) for custom reports.
• Created Sub Reports, prompt, groups in a report and created parameters, custom functions and expressions in Crystal Reports.
• Created hyperlinks to connect multiple reports. And exported reports to info view.
• Used LIVE OFFICE to interact with reports for Presentation and design.
• Created Business objects Reports using stored procedures
• Expertise in transforming Microsoft Excel files to interactive dashboard files using Xcelsius. Used QAAWS to interact with Xcelsius.
• Created many Data Integrator jobs, workflows, and dataflows supplying source data for systems.
• Involved in Installation and configuration of BOE 4.0.
• Involved in migrating and testing documents from BO XI R2 to BO 4.0 and moved objects between different domains using Import Wizard.
• Converted existing reports in Desktop Intelligence to Web Intelligence reports using Report conversion tool.
• Wrote the necessary SQL DDL/ PLSQL procedures to build the physical data bases table spaces tables views and indexes for the project
• Worked with CMC in Creating Groups, users, folders and categories and customized access levels to apply security accordingly for proper usage of the reporting system.
• Used Data Integrator in setting up Extraction, Transformation and Load process.
• Experience in testing applications developed using Waterfall model,andAgile methodologies.
• Involved in QA phase to test the Classes, Objects, Connections and reports in Business Objects. Conducted the Integration, performance and regression and UAT, prepared the test cases and documents.

Environment: BOBJ, Business Objects Enterprise XI R4.0/R2,WEBI, Toad, Crystal Reports 12, Xcelsius 2008, ERWIN, Teradata, Oracle 11g/10g, and Windows 2003.

Confidential, Richmond, VA Sep’07 – July’09 
Role: BOBJ ConsultantDescription:
CapitalOne utilized Business Objects to build a secure data management system. The project involves developing universes, building reports and co-ordinate with three different teams in different sites.

Responsibilities:

• Lead BO Developers in business Object projects including project design, development, implementation and documentation using Agile Process. And interacted with users and business analyst to find the requirements.
• Created and maintained Universe and developed complex universes by using features like aggregate aware, Index aware, Conditions and hierarchies to Perform linking of universes by to optimize the universe development and performance improvement.
• Used filters at universe level to enhance the report creation. And used Functions like @select and @where to reuse code.
• Extensively worked in optimizing universe performance by creating necessary Indexes and shortcut joins. Added row level and object level security to make sensitive data secure.
• Create custom prompts at the universe level to create interactive reports. And extensively used Aggregate tables for fast retrieval of data from universe.
• Created custom hierarchy and added cascading List of Values.
• Created and maintained reports using universe, stored procedure, freehand SQL as the Data providers and wrote complex queries including Sub Queries, Unions and Aliases using Web Intelligence, Full Client and Crystal Reports.
• Created Reports using grouping, sorting, Running totals, charts etc., and exported reports into Excel, pdf, csv etc. Organized data in the report by using Slice and dice and used drilling options.
• Created reports in crystal reports using sub reports, custom functions, expressions, prompt and hyperlinks.
• Created KPI visualization for the client dashboard using live data techniques (Query as a Web Service, Crystal Xcelsius, and Live Office).
• Worked with CMC in Creating and maintaining Groups, users, folders and customized access levels to apply security accordingly for proper usage of the reporting system.
• Migration of universes, Web Intelligence documents between repositories and across multiple servers in test and production environments.
• Created stored procedures, and freehand sql as Data providers and writing the complex queries including Sub Queries, Unions, and Intersect for Business Objects Reporting Purpose
• Involved in re-designing or customizing the existing Views and Stored Procedures to suit the Business Objects Reporting Needs.
• Used SQL and Toad for query optimization and validation. Andinvolved in trouble shooting.
• Involved in QA phase to test the Classes, Objects andConnections in Business Objects. Involved in Unit testing, integration testing, Performance testing and UAT of Universes.

Environment: Business Objects XI R2, Crystal Report 10, Oracle 9i, Teradata, Windows 2000.

Confidential, Phoenix, AZ March’06 – Aug’07Role: BOBJ Consultant Description:The project aims at consolidating customer data received from different source systems. And creating a central database to analyze the business performance, trends over time and build forecasts in addition to generating various standard, ad-hoc/canned reports.

Responsibilities:

• Leading business intelligence projects including project execution, scope management, defining deliverables, development and documentation.
• Designed Universe, Created Contexts and Aliases for resolving Loops in the Universes.
• Created Crystal Reports using Crystal Reports formulae, Grouping, Parameters, Selection criteria.
• Extensively used Aggregate tables and shortcut joins to optimize the Universe.
• Created Business Intelligence reports using Business Objects XI software provided through Crystal Reports.
• Worked with the ETL team by using Informatica to load data relating to production information into the organization\'s data warehouse.
• Created Source and target definition in informatica designer. And developed Informatica Mappings, Mapplets, Sessions and transformation.
• Involved in Informatica administration. Migrated development mappings to production environment.
• Designed and developed reports using Crystal Reports XI version.
• Involved in creating metadata in framework manager. Created and published packages based on the security.

Environment: Business Objects 6.5, Informatica 7, Oracle 9i, Teradata, Toad, Windows 2003 server.

Confidential, New York, NY May’05 – Feb’06Role: Crystal Report DeveloperDescription: 
This project deals creating database and analysis of issues of customer, host Performance and Server Statistics. These reports give description about the issues with the region and server information, which will allow the end user to manage the servers.

Responsibilities:

• Involved in creating and redesigning existing reports in crystal reports.
• Developed various reports including sub-reports, cross-tabs, standard reports. Worked with groups and drill down reports.
• Wrote SQL queries to pull the data for ad-hoc reports.
• Developed reports with formulas, expressions and hyperlinks to link different reports.
• Involved in Report Validation for the generated reports to test and sent it to the production.
• Developed procedures, functions and database triggers using PL/SQL.
• Created Entity and relationships in logical data model and converted them to physical data model. And created Database tables using ERWIN.
• Involved in creating Source and target definition in informatica designer.
• Involved in developing Informatica Mappings, Mapplets, Sessions and transformation andinvolved in creating metadata in framework manager.

Environment: Crystal reports 10/9, Toad, Oracle 8i, SQL*plus, Informatica 7, Windows 2003/2000 server.

Confidential March’04 – April ’05Role: Oracle SQL DeveloperDescription:
This project involves developing and analyzing reports for its clients in banking industry, which will facilitate the customers with the ability to keep track of their account and Investment Information.

Responsibilities:

• Involved in analysis and development of Database.
• Created Stored Procedures, triggers, functions, temp tables for data manipulation & reporting.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Programming with SQL for data manipulation, used for Crystal Reports based on SQL Queries, Procedures, Tables and Triggers.
• Worked with Toad to validate and manipulate data. Involved in Query Optimization.
• Implemented Full Text Search on MS SQL Server tables.

Environment: Oracle 8i, Toad, SQL*Plus, Windows 2000 server.