PROFESSIONAL SUMMARY:

• 8 plus years of experience in Data Warehouse with the skill set of specialize in BI Developer / SAP Business Objects 4.2/4.1/4.x/3.x/R2. Looking forward for a challenging position where I can work with the best of my abilities.
• Excellent experience with Information design tool, Universe design and development, Developing complex reports using Deski, WebI, WebI Rich Client, Report Conversion Tool, Crystal Report, Design Studio, Creating complex Dashboards.
• Great experience using SQL, Great working experience with RDBMS, Complex Queries, joins, Grouping, from condition to projection, expertise in all clauses, Stored Procedures, Functions, customizing exceptions, selecting a perfect loop for optimization of Stored Procedures, working with the cursors, variable, sub blocks.
• Expertise in gathering the Business Requirement and building Universes, Free hand SQL methods and creating complex ad - doc.
• Experience in all phases of Software Development Life Cycle (SDLC) such as developing, testing, migrating, administration, security management and production supporting. Migrating universes, reports, users, categories from old version to Business Objects XI environment.
• Expertise using SAP Business Objects 4.2 (IDT, Universe Designer, LCM/P. Manager, BI Launch Pad, Advance Analysis, WebI, Dashboard Design, BI Workspaces).
• Experience in creating Universes with measures and dimensions objects, Join conditions, Filters, LOV, cardinality, Aliases, Contexts, Aggregate Awareness using Business Objects Designer.
• Creating universes from two different data source (DB) using Data Federator (DF).
• Created Drilldown Reports, Sub Reports, On-Demand Sub Reports, Label Reports, Chart and Reports.
• Created Ad Hoc/Canned Reports, Use Hyper link, Document linking by passing same parameters to Drill through and jump from one to another report.
• Extensively worked on Report Conversion Tool to convert Deski reports to WebI reports.
• Expertise in Creating OpenDoc and passing parameters, printing in PDF/HTML or WID format.
• Strong experience in designing and developing interactive live data Dashboard using BI and Crystal Xcelsius.
• Created dashboards and Scorecards using dashboard design 4.1.
• Expertise using Excel formula like, Vlookup, Hlookup, IF logic in Xcelsius.
• Experience in CMC, Creating user group, Manage security, Manager Services, Update keys, Maintaining repository, Migration from Dev to QA/Pre Prod and QA/Pre Prod to Prod using Import Wizards.
• Converted Cognos Impromptu Catalog into Universe
• Extensive Experience working with Prod issue with timeline and priorities for Sustaining Team, PPM Tickets.
• Excellent Experience in Data warehouse methodologies
• Expertise in retrieving data using SAP Business Objects Universes, Personal data files, stored procedures and free hand SQL methods.
• Experience using Microsoft Excel, PowerPoint, PDFs interaction with Business Objects.
• Extensive experience in complete SAP Business Objects and Crystal suites.

TECHNICAL SKILLS

• Business Requirement Gathering
• Functional Requirement Document
• Technical Documentation
• Proper Deployment plan
• Training Documents
• SQL Server 2003
• Oracle 9i/10g
• Netezza
• Teradata
• PL/SQL
• Information Design Tool
• Universe Design Tool
• Central Management Console
• Xcelsius 2008
• Dashboard
• Crystal Reports 2008
• Web Intelligence
• SAP Lumira
• Desktop Intelligence
• BOE 3.0
• BI Launch Pad/Infoview
• Central Configuration Manager Tableau 10.0 RDBMS
• Live Office
• Report Conversion Tool
• Production Release
• Data Comparison with Compare Beyond.

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Sr. SAP Business Objects Developer / BI Lead

Responsibilities:

• Gathered requirement from users and product owners, Convert those into Technical requirements, Created POC based on requirements and start developing, testing, UAT, Documentation, Peer review, Prod.
• Created design document for work flow, reporting environment, training session, technical proposal.
• Resolved tickets and ad hoc requests.
• Created/Modified 15 Universes from scratch and enhancement using IDT in Current environment (Costco HQ), Set up connection, Tables, Views, Derive Tables, Joins, Cardinality, Context, Aliases, Hierarchies, Classes, Objects, Filters, @functions, Aggregate Navigation, LOVs, Cascading LOVs, Raw/Column Level Security.
• Created Universes using Data model Schema like Star schema Relational.
• Create views in Oracle from scratch as well as modifications of views.
• Providing fast and active service to business users for complex Ad-hoc reporting and environment issues, errors, complex dynamic date formula’s in reports and in universe and different logics @prompt and CASE statement logic, Increasing report performance by doing analysis each and every elements in the queries and report, Creates document for training session for new users about BOE, EDW and new functionality of BOE, scheduling reports into different format.
• Created Hyperlink and document linking for drill through and jump one report to another report by passing same parameters.
• Created Business level security and Migrated Universe and Migrate objects from DEV to QA and QA to Prod using LCM, increasing performance of web and App server, increasing session timeout limit by changing script from the server, creating connection for database, providing BOE access to the users, scheduling reports for external source,
• Migrated content from DEV to QA and QA to Prod every second week.
• Created proper documentation with peer review for sustaining team before migrating project to prod.
• Create Proper BRD, FRD and TRD.
• Create Test cases for deployment plan.

Environment: Windows 2010, Business Objects 4.2, Design Studio, SQL, Oracle, MS Office 2013.

Confidential, St. Pete, FL

Sr. SAP Business Objects Developer

Responsibilities:

• Gathered requirement from users and product owners, Convert those into Technical requirements, Created POC based on requirements and start developing, testing, UAT, Documentation, Peer review, Prod.
• Created complex type of dashboard and story board by using SAP QlikView from scratch, resolved tickets and ad hoc requests.
• Created/Modified 10 Universes using IDT in Current environment ( Confidential ), Set up connection, Tables, Views, Derive Tables, Joins, Cardinality, Context, Aliases, Hierarchies, Classes, Objects, Filters, @functions, Aggregate Navigation, LOVs, Cascading LOVs, Raw/Column Level Security.
• Created Universes using Data model Schema like Star schema Relational.
• Create views in Tara Data from scratch as well as modifications of views.
• Providing fast and active service to business users for complex Ad-hoc reporting and environment issues, errors, complex dynamic date formula’s in reports and in universe and different logics @prompt and CASE statement logic, Increasing report performance by doing analysis each and every elements in the queries and report, Creates document for training session for new users about BOE, EDW and new functionality of BOE, scheduling reports into different format.
• Created Hyperlink and document linking for drill through and jump one report to another report by passing same parameters.
• Created Users and Groups, Applied Data level or Business level security and Migrated Universe and Migrate objects from DEV to QA and QA to Prod using LCM, increasing performance of web and App server, increasing session timeout limit by changing script from the server, creating connection for database, providing BOE access to the users, scheduling reports for external source,
• Migrated content from Dev to QA and QA to Prod every second week.
• Created proper documentation with peer review for sustaining team before migrating project to prod.
• Create Proper BRD, FRD and TRD.
• Create Test cases for deployment plan.

Environment: Windows 2010, Business Objects 4.2, Design Studio, SQL, Teradata, MS Office 2013.

Confidential, Folsom, CA

SAP Business Objects Developer/ Admin

Responsibilities:

• Gathered requirement from users, Convert those into Technical requirements, Created POC on the bases of requirements and start developing, testing, UAT, Documentation, Peer review, Prod.
• Created/Modified several Universes using IDT/UDT, Set up connection, Tables, Views, Derive Tables, Joins, Cardinality, Context, Aliases, Hierarchies, Classes, Objects, Filters, @functions, Aggregate Navigation, LOVs, Cascading LOVs, Raw/Column Level Security.
• Created Universes using Data model Schema like Star/Snow Flake/Relational.
• Created Universes for Ad-Hoc Reporting for users by using SQL server and Excel sheet as an data source with complex relation between the different data sources.
• Providing fast and active service to business users for complex Ad-hoc reporting and environment issues, errors, complex dynamic date formula’s in reports and in universe and different logics @prompt and CASE statement logic, Increasing report performance by doing analysis each and every elements in the queries and report, Creates document for training session for new users about BOE, EDW and new functionality of BOE, scheduling reports into different format.
• Created Info spaces using Explorer.
• Developed Complex Reports using WebI Rich Client, such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections,
• Created OpenDoc and passing parameters, printing in pdf or wid format.
• Created Dashboards, Scorecard using dynamic data, using connections, Live Office, Master/Detail Dashboards, Used Dynamic visibility to hide and show component, Provide complex functionality using IF logic in excel.
• Created Hyperlink and document linking for drill through and jump one report to another report by passing same parameters.
• Configured Dashboard and WebI Reports.
• Created Users and Groups, Applied security, Migrated Universe and Reports from DEV to QA and QA to Prod using Import Wizard and LCM, increasing performance of web and App server, increasing session timeout limit by changing script from the server, creating connection for database, providing BOE access to the users, scheduling reports for external source,
• Migrated contents from 3.1 to 4.1 using UMT and migrated content from Dev to QA and QA to Prod.
• Created proper documentation with peer review for sustaining team before migrating project to prod.

Environment: Windows 2010, Business Objects 4.2, SQL server 2012, Teradata, Crystal Reports, MS Office 2013, tableau 10.0.

Confidential, Honolulu, HI

SAP Business Objects & BI Developer

Responsibilities:

• Gathered requirement from users, convert those into Technical requirements, created POC on the bases of requirements and start developing, testing, UAT, Documentation, Peer review, Prod.
• Created/Modified several Universes using IDT/UDT, Set up connection, Tables, Views, Stored Procedure, Derive Tables, Joins, Cardinality, Chasm /Fan Trap Context, Aliases, Hierarchies, Classes, Objects, Filters, @functions, Aggregate Navigation, LOVs, Cascading LOVs, Raw/Column Level Security.
• Created Universes using Data model Schema like Star/Snow Flake/Relational.
• Created Universes for Ad-Hoc Reporting for users by using SQL server and Excel sheet as a data source with complex relation between the different data sources.
• Providing fast and active service to business users for complex Ad-hoc reporting and environment issues, errors, complex dynamic date formula’s in reports and in universe and different logics @prompt and CASE statement logic, increasing report performance by doing analysis each and every elements in the queries and report, training session for new users about BOE, EDW and new functionality of BOE, scheduling reports into different format.
• Created Info spaces using Explorer.
• Developed Complex Reports using WebI Rich Client, such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections,
• Created OpenDoc and passing parameters, printing in pdf or wid format.
• Created Dashboards, Scorecard using dynamic data, using connections, Master/Detail Dashboards, Used Dynamic visibility to hide and show component, Provide complex functionality using IF logic in excel.
• Created Hyperlink and document linking for drill through and jump one report to another report by passing same parameters.
• Created Users and Groups, Applied security, Migrated Universe and Reports from DEV to QA and QA to Prod using Import Wizard and LCM, increasing performance of web and App server, increasing session timeout limit by changing script from the server, creating connection for database, providing BOE access to the users, scheduling reports for external source,
• Migrated contents from 3.1 to 4.1 using UMT and migrated content from dev to qa and qa to prod.
• Created proper documentation with peer review for sustaining team before migrating project to Prod.
• Tested 4.1 in sandbox for possible issues.
• Created Attribute views, Analytic View, Calculation view into Hana and created universes and reports on top of Hana DB.
• Support Sustaining Team for Prod issues.
• Support Supply Chain Metrics (SCM) and Learning Management System (LMS).
• Worked on PPM tickets (CR, SR, ER).

Environment: Windows 7/server 2008, Business Objects 4.x/4.1/4.2, SQL server 2012, Crystal Dashboard Design (Xcelsius) 2008/4.1, Design studio, MS Office 2013, tableau 10.0

Confidential, San Antonio, TX

SAP Business Objects & Dashboard Developer/Admin

Responsibilities:

• Gathered requirement from users, convert those into Technical requirements, created POC on the bases of requirements and start developing, testing, UAT, Documentation, Peer review, Prod.
• Created/Modified several Universes using IDT/UDT, Set up connection, Tables, Views, Stored Procedure, Derive Tables, Joins, Cardinality, Chasm /Fan Trap Context, Aliases, Hierarchies, Classes, Objects, Filters, @functions, Aggregate Navigation, LOVs, Cascading LOVs, Raw/Column Level Security.
• Created Universes using Data model Schema like Star/Snow Flake/Relational.
• Created Universes for Ad-Hoc Reporting for users.
• Created Info spaces using Explorer.
• Developed Complex Reports using WebI Rich Client, such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Created OpenDoc and passing parameters, printing in pdf or wid format.
• Created Dashboards, Scorecard using dynamic data, using connections, Live Office, QaaWS, Flash Variables, EIC, XML, Master/Detail Dashboards, Used Dynamic visibility to hide and show component, Provide complex functionality using IF logic in excel.
• Created Hyperlink for drill through and jump one report to another report.
• Configured Dashboard and WebI Reports into portal using Liferay portal.
• Wrote JavaScript code for IPC in portal and decomposed dashboard for portal requirements.
• Created Users and Groups, Applied security, Migrated Universe, Reports from DEV to QA and QA to Prod using Import Wizard, LCM.
• Migrated contents from 3.1 to 4.1 using UMT and migrated content from DEV to QA and QA to Prod.
• Created proper documentation with peer review for sustaining team before migrating project to Prod.
• Tested 4.1 in sandbox for possible issues.
• Created Attribute views, Analytic View, Calculation view into Hana and created universes and reports on top of Hana DB.
• Support Sustaining Team for Prod issues.
• Support Supply Chain Metrics (SCM) and Learning Management System (LMS).
• Worked on PPM tickets (CR, SR, ER).

Environment: Windows 7/server 2008, Business Objects 3.1/4.1, Oracle 11g, Design studio, SAP Lumira, Crystal Dashboard Design (Xcelsius) 2008/4.1, BW 7.3, Hana 1.0

Confidential, Middletown NJ

SAP Business Objects Developer/Admin

Responsibilities:

• Gathered requirement from users, convert those into Technical requirements, created POC on the Mbases of requirements and start developing, testing, UAT, Documentation, Peer review, Prod.
• Created universes using IDT, UDT.
• Created several reports using WebI, Explorer for end users.
• Created Dashboard, Scorecard using dynamic data, using connections, Live Office, QaaWS, BEx, Flash Variables, EIC, XML, Master/Detail Dashboards, Used Dynamic visibility to hide and show component, Provide complex functionality using IF logic in excel.
• Created Hyperlink for drill through and jump one report to another report.
• Created Users and Groups, Applied security, Migrated Universe, Reports from DEV to QA and QA to Prod using Import Wizard.
• Support Sustaining Team for Prod issues.
• Support offshore team in India.
• Created WebI reports and Universes using BW as a data source using BICS connection.
• Worked on Hana modeling creating Attribute/Analytic/Calculation Views for end users to get best performance out, all cached data.
• Deployed 4.0 into send box for testing and migrate contents of 3.1 into 4.0 using UMT.
• Worked on PPM tickets (CR, SR, ER).
• Created proper documentation with peer review for sustaining team before migrating project to Prod.

Environment: Windows 7, Business Objects 3.1/4.0, Oracle 10g/11g, Crystal Xcelsius 2008/4.0, Crystal Reports 2008/4.0/2011, BW 7.3

Confidential, CT

SAP Business Objects & Dashboard Developer/Admin

Responsibilities:

• Gathered requirement from users, convert them into Technical requirements, created POC on bases of requirements and start developing, testing, UAT, Documentation, Peer review, Prod.
• Created/Modified several Universes, Set up connection, Tables, Views, Stored Procedure, Derive Tables, Joins, Cardinality, Chasm /Fan Trap Context, Aliases, Hierarchies, Classes, Objects, Filters, @functions, Aggregate Navigation, LOVs, Cascading LOVs, Raw/Column Level Security.
• Created Universes using Data model Schema like Star/Snow Flake/Relational.
• Converted Cognos Catalog into Universe.
• Created Universes from two different DB using DF.
• Created Universes for Ad-Hoc Reporting for users.
• Developed Complex Reports using WebI Rich Client, such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Created OpenDoc and passing parameters, printing in pdf/html or wid format.
• Created Dashboards, Scorecard using dynamic data, using connections, Live Office, Master/Detail Dashboards, Used Dynamic visibility to hide and show component, Provide complex functionality using IF logic in excel.
• Created Hyperlink for drill through and jump one report to another report.
• Created Logical Multiple value selector for Xcelsius according to user’s requirements.
• Configured Dashboard and WebI Reports into portal using Liferay portal.
• Created Users and Groups, Applied security, Migrated Universe, Reports from DEV to QA and QA to Prod using Import Wizard.
• Created proper documentation with peer review for sustaining team before migrating project to Prod.
• Support Sustaining Team for Prod issues.
• Support Supply Chain Metrics (SCM) and Learning Management System (LMS).
• Worked on PPM tickets (CR, SR, ER).

Environment: Windows XP/7/Server 2008, Business Objects XIR 3.1, Oracle 10g/11g, Crystal Reports 2008, Crystal Xcelsius 2008, Cognos 8.

Confidential, New York

SAP Business Objects Developer

Responsibilities:

• Gathered requirement from users, convert those into Technical requirements, created POC on the bases of requirements and start developing, testing, UAT, Documentation, Peer review, Prod.
• Design the Conversion project for the existing Legacy Reports in to the Business Objects WebI Reports and work closely with Architects to upgrade the existing BO XI R2 version to BO XI R3.1
• Created Dynamic Reports using a Main report.
• Designed universes using over relational database schemas and stored procedures
• Created Hyperlinks for top-level reports for linking to the bottom level reports.
• Created Business Objects Web Intelligence reports and published on the INFOVIEW.
• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill down, Cross tab, Master detail and Formulae.
• Developed complex Reports using Web Intelligence Rich Client, Web intelligence Info View, graphs, pie-charts and multiple data providers on daily, weekly, monthly and quarterly basis.
• Created annual and quarterly finance reports of the Client in Crystal Reports 2008.
• Created proper documentation with peer review for sustaining team before migrating project to Prod.

Environment: Windows XP/7, Business Objects 3.1, Oracle 10g, Crystal Report 2008.