RELEVANT EXPERIENCE:

• 8 plus years of IT experience in Analysis, Design, Development, Administration and Support solutions for SAP Business Objects XI 3.1(R3)/XIR2/R1/6.x/5.x.
• Experienced in Development, Administration and Support solutions for SAP Business Objects XI 3.1(R3) / XIR2/R1/6.x/5.x,Server Intelligent Agent (SIA), Central Configuration Manager, Central Management Console, Business Objects Enterprise, BO Performance Management, Crystal Reports, Crystal Xcelsuis
• Developed Universes for Canned/Ad - hoc Reports using various Sources like Oracle, SQL Server, MS Access and DB2.
• Expertise in solving Production Environment issues with the Reports and Universe.
• Administration using Central Management Console to configure user and group security, categories, folders, universes, universe connections.
• Worked extensively in Data warehouse concepts
• Created various restricted Datasets for various User groups in Universe level.
• Commandable knowledge of Data Warehouse Schemas like Star Schema, Multi-Star Schema and Snowflake Schema.
• Implemented the underlying logic for Slowly Changing Dimensions.
• Extensively used Report Conversion tool to Convert Deski Reports to Web Intelligence
• Experience in installation of BOXI Enterprise and configuration of CMS, Migration of objects to BOXI from previous versions.
• Extensive Knowledge in software Testing Methodology and developing Test Plans, Testing Procedures and Modification Requests.
• Experience in using various Data Providers like Universe, Free Hand and Personal Data Files for retrieving Data and created Simple, Complex and Adhoc Reports.
• Interaction with Business Users for Requirements Gathering Created Technical Specifications. Developing End Users Notes. Involved in Production Support/ Maintenance.

TECHNICAL SKILLS:

Business Intelligence / ETL Tools/Data Modeler: Business Objects 5.1/6.5.1/XI R2/R3 (Designer, Reporter, Supervisor, Web Intelligence, Info View, Webi Rich client, Deski, CMC, CCM, Broadcast Agent Server), Crystal Xcelsius 2008,Crystal Reports 6/XI and Data Stage 7.5, Informatica 7.x,Erwin, Tomcat 4.0.6, Apache 1.3.x.

O/S: Windows95/98/NT/2000/XP, Linux/Unix and DOS

Database: Oracle 7/8/9/10g/11i, Oracle EBS 11.5.10, SQL Server 2000/2005, Teradata, Sybase and MS Access97/2000, DB2 UDB

Programming: SQL, HTML 4, DHTML, Transact SQL and Java.

GUI: Visual Basic 5.0/6.0, Forms 4.5 and Reports 2.5

Others: Microsoft Excel, Word, Winsql and Toad

Web Servers: IIS, Apache, Tomcat

PROFESSIONAL EXPERIENCE:

Confidential, VA

BOBJ DEVELOPER

Responsibilities:

• IR Scorecard Detail and Summary Report which runs for a given Lender Marketing ID and Activity Month
• Beginning Hard Rejects report which runs based on Mgr ID, Analyst ID, Servicer
• Actual Actual Cashflow Report which runs based on Mgr name, Analyst, Lender Marketing ID and Servicer for a given month.
• STAR Adjustments Audit Report which runs based on Mgr name and Lender Marketing ID for a given month.
• Monitoring Compliance Reports used for visibility into the overall level of compliance with the monitoring standard for software assets (Applications, Utilities, and Components).
• Business Hours availability Report which allows the Business and Technology Owners to ensure that the availability of their IT services are being met and in a cost-effective manner and Measuring Production Support activity associated with a given asset.
• Interacted with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
• Converted business requirements (FRD) to technical requirement documents.
• Created and Formatted the Reports as per the Users Requirements using the features in BOBJ like Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, @functions and Formulae to analyze the data.
• Created and distributed Report Templates to Users and Main Data Providers for created these reports are - Universes.
• Created Derived Tables in the Universe using views and sqls to meet the Reporting Requirements.
• Migrated universes and reports from SIT/UAT to production using Import wizard.
• Involved in Creating Universes and Reports. Designed new Universes using features like Check Integrity, Cardinalities, Aliases, Loops, Contexts and Hierarchies. Created Classes, Sub-Classes and Objects (which include Dimensions and Measures).
• Resolved the issues while converting Deski report to Webi, by direct workout
• Created Cascading Web Services for different Dashboards.
• Created Universes and complex reports against huge Oracle database.
• Created user defined @prompts, Smart Measures and complex conditions at Universe level for better performance.
• Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results
• Created alerters, filters and inserted Breaks in designing reports.
• Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department.
• Created the reports using BOBJ functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc
• Provided the security access management by creating users/groups and folders.
• Created reports using Info View and for distribution to users
• Scheduled jobs in CMC by Daily, weekly, bi-weekly and monthly basis and export the results in Excel and send the report to the user thru Email.
• Created hundreds of reports in Webi, Deski and Rich client using all the functionalities
• Designed Universes using different data sources.
• Worked with team closely with Functional Architect, DBA and Analysts.
• Experience with Report testing and to validate the results against the database.
• Maintaining Universes and Reports to multiple Environments (Dev, Test, Pre-prod & Prod etc.).

Environment: SAP Business Objects Enterprise XI R3.1, Web Intelligence, Infoview, Windows, Oracle 10g/11i and CMC

Confidential

BOBJ DEVELOPER/ADMIN

Responsibilities:

• Interacted with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
• Installed and configured BOBJ on Windows.
• Technical expertise in Analyzing, Design, Implementation and administration of security models with row level data security, role based security etc in BOBJ Universes and Central Management Console (CMC)
• Created and Formatted the Reports as per the Users Requirements using the features in BOBJ like Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, @functions and Formulae to analyze the data. Created and distributed Report Templates to Users and Main Data Providers for created these reports are - Universes.
• Designed Universe by creating the BOBJ Data Model selecting/joining tables, indicating cardinalities, creating aliases and contexts to resolve the loops, creating the objects like Dimensions, Details and Measures which are grouped into Classes and checked the integrity of the universe
• Created Derived Tables in the Universe using views to meet the Reporting Requirements.
• Migrated universes and reports from SIT/UAT to production using Import wizard.
• Technical expertise in Analyzing, Design, Implementation and administration of security models with row level data restrictions, object level based restrictions and object based security etc in BOBJ
• Created Standard reports, Cross tabs reports, Ad-hoc reports using the features like Ranking, Sorting, and @functions to analyze the data. Used Web Intelligence to create Reports. Involved in customizing the look and feel of Web Intelligence Interface.
• Migrated Reports from Deski to Webi
• Involved in Creating Universes and Reports. Designed new Universes using features like Check Integrity, Cardinalities, Aliases, Loops, Contexts and Hierarchies. Created Classes, Sub-Classes and Objects (which include Dimensions and Measures).
• Resolved the issues while converting Deski report to Webi, by direct workout
• Created Cascading Web Services for different Dashboards.
• Created Universes and complex reports against huge Oracle database.
• Created user defined @prompts, Smart Measures and complex conditions at Universe level for better performance.
• Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results
• Created alerters, filters and inserted Breaks in designing reports.
• Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department.
• Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.
• Schedule jobs in CMC by Daily, weekly, bi-weekly and monthly basis and export the results in Excel and send the report to the user thru Email.

Environment: SAP Business Objects Enterprise XI 3.1, Web Intelligence, Deski, Webi Rich Client, Info View, Windows, Oracle EBS, Crystal Xcelsius, Crystal Reports XI and CMC

Confidential, Washington, DC

BOBJ DEVELOPER/ADMIN

Responsibilities:

• Interacted with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
• Installed and configured BOBJ on Windows.
• Created users, groups, server groups and setup security architecture
• Implemented BIAR file for Backups/Deployments.
• Technical expertise in Analyzing, Design, Implementation and administration of security models with row level data security, role based security etc in BOBJ Universes and Central Management Console (CMC)
• Deployed BO universes and reports from DEV to TEST/SIT/UAT and Production environments using Import wizard..
• Developed BOBJ Universes by Using Teradata Database as Data Source
• Designed Universe by creating the BOBJ Data Model selecting/joining tables, indicating cardinalities, creating aliases and contexts to resolve the loops, creating the objects like Dimensions, Details and Measures which are grouped into Classes and checked the integrity of the universe.
• Implemented Cardinality settings, Joins, Conditions and Global Filters in Universe
• Worked in Aliases and Contexts to resolve looping problems and used Derived tables methods.
• Migrated Reports from BOXI 6.1v to BOXI R3
• Created Cascading Web Services for different Dashboards.
• Creating and Formatting the Reports as per the Users Requirements using the features in BOBJ like Master/Detail, Charts, Cross tabs, Slice and Dice, @functions and Formulae to analyze the data. Creating and distributing Report Templates to Users and Main Data Providers for creating these reports are - Universes.
• Created Web Intelligence Ad-hoc and canned reports.
• Created Reports with multiple hyperlinks to various reports using Open Document Syntax.
• Created Web Intelligence Rich Client reports using Universe.
• Creating Standard reports, Cross tabs reports, Ad-hoc reports using the features like Ranking, Sorting, and @functions to analyze the data.
• Used Web Intelligence to create Reports. Involved in customizing the look and feel of Web Intelligence Interface.
• Created user defined @prompts and complex conditions at Universe level for better performance.
• Provided the security access management by creating users/groups and folders.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• Schedule jobs in CMC by Daily, weekly, bi-weekly and monthly basis and export the results in Excel and send the report to the user thru Email.
• Supported and solved the tickets for Crystal Reports in production environment.
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users.
• Generated the BOXI reports involving complex queries, sub queries, Unions and Intersection.
• Developed universe user documentation guide for the end users reference

Environment: SAP Business Objects Enterprise XI 3.1, Web Intelligence, Webi Rich Client, Info View, Linux/Windows, Teradata, DB2, Crystal Xcelsius, Crystal Reports XI and CMC

Confidential, McLean VA

SYSTEMS ENGINEER/ADMIN

Responsibilities:

• Interacted with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
• Converted business requirements (FRD) to technical requirement documents.
• Created and Formatted the Reports as per the Users Requirements using the features in BOBJ like Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, @functions and Formulae to analyze the data. Created and distributed Report Templates to Users and Main Data Providers for created these reports are - Universes.
• Created Derived Tables in the Universe using views and sequels to meet the Reporting Requirements.
• Migrated universes and reports from SIT/UAT to production using Import wizard.
• Technical expertise in Analyzing, Design, Implementation and administration of security models with row level data restrictions, object level based restrictions and object based security etc in BOBJ
• Created Standard reports, Cross tabs reports, Ad-hoc reports using the features like Ranking, Sorting, and @functions to analyze the data. Used Web Intelligence to create Reports. Involved in customizing the look and feel of Web Intelligence Interface.
• Migrated Reports from Deski to Webi
• Involved in Creating Universes and Reports. Designed new Universes using features like Check Integrity, Cardinalities, Aliases, Loops, Contexts and Hierarchies. Created Classes, Sub-Classes and Objects (which include Dimensions and Measures).
• Resolved the issues while converting Deski report to Webi, by direct workout
• Created Cascading Web Services for different Dashboards.
• Created Universes and complex reports against huge Oracle database.
• Created user defined @prompts, Smart Measures and complex conditions at Universe level for better performance.
• Created the reports using BOBJ functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc
• Provided the security access management by creating users/groups and folders.
• Created reports using Info View and for distribution to users
• Scheduled jobs in CMC by Daily, weekly, bi-weekly and monthly basis and export the results in Excel and send the report to the user thru Email.
• Created hundreds of reports in Webi, Deski and Rich client using all the functionalities
• Designed Universes using different data sources.
• Worked with team closely with Functional Architect, DBA and Analysts.
• I have an experience with Report testing and to validate the results against the database.
• Maintaining Universes and Reports to multiple Environments (Dev, Test etc.).
• Implemented Row Level, Object Level security for data restriction at Universe level.

Environment: SAP Business Objects Enterprise XI 3.1, Web Intelligence, Webi Rich Client, Info View, Sybase, Oracle 10g, Toad, Crystal Xcelsius 2008, Windows and CMC

Confidential, Research Triangle Park, NC

BO DEVELOPER

Responsibilities:

• Interacting with Report Users and Business Analysts to understand and document the Requirements and translate these to Technical Specifications for Designing Universes and Business Object Reports.
• Creating and Formatted the Reports as per the Users Requirements using the features in BOBJ like Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, @functions and Formulae to analyze the data.
• Managing security by Adding, Enabling, Disabling and Deleting of Users/Groups and the granting of privileges using CMC (Central Management Console) to Administer BOXI r2.
• Interacting with Report Users and Business Analysts to understand the Requirements for Designing the BOBJ Reports.
• Opened tickets in the Tracker for Reporting purpose to track all the Report statuses purpose.
• Created Derived Tables in the Universe using to meet the Reporting Requirements.
• Migrated Crystal Reports XI to Business Objects XI R2 Reports.
• Created Cascading Prompts on the Reports.
• Implemented Filters, conditions in the Universe to the run the Reports quickly.
• Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End User Notes, Testing the Reports and Data validation.
• Migrated Reports from BOXI 6.1v to BOXI R3
• Experience in grouping, sorting, totaling, running totals, charts etc., I have exported my reports into various formats like PDF, Excel etc.

Environment: Business Objects XI R2, Web Intelligence, Infoview, Crystal Report Xi, Oracle 10g, SQL Developer and SQL Server 2005

Confidential, Los Angeles, CA

Responsibilities:

• Created Classes, Sub-Classes and Objects (which include Dimensions and Measures).
• Creating and distributing Report Templates to Users and Main Data Providers for creating these reports are - Universes and Freehand SQL.
• Performing Data Analysis, writing SQL Queries for Testing and Troubleshooting againstData Warehouse
• Maintaining Universes and Reports to multiple Environments (Model office and Production).
• Exported my reports into various formats like PDF, txt, xls.
• The main Data Providers for the Report generation in Full Client are Universes / Freehand SQL.
• Created Ad hoc Reports using End User module in BOBJ.
• Designing EIS Dashboards and Score boards Using features like IMT, New Analytics, and pie charts. Creating Metric Universe for Performance Management Dashboards.
• Experience in creating Metrics and Deploying Dashboards.
• Good knowledge on Managing security by Adding, Enabling, Disabling and Deleting of Users/Groups and the granting of privileges using CMC.
• Involved in the development of reports by using Crystal Reports XI. Developed reports like blank report, cross tab reports, sub reports in Crystal 11.
• Knowledge on ER Data Modeling skills using Erwin.
• Involved in the design of Star schema Data Model using Erwin.
• Used generalized formulas using both Crystal and Basic Syntax.

Environment: Business Objects XI, Crystal Reports XI, Webi, Informatica 7, Performance Management, Infoview, Teradata, Erwin, SQL, Toad, Manual Testing, Power Builder and Windows 2000/XP

BUSINESS OBJECTS DEVELOPER

Confidential, Seattle, WA

Responsibilities:

• Involved in full project life cycle (requirement gathering to implementation phase), which includes preparation of Business/Technical Requirements, Design Templates, Development Standards document and Detailed Design documents.
• Responsible for the Designing the universes by creating the BOBJ data model selecting/joining tables, indicating cardinalities, created aliases to resolve the loops, subdividing into contexts and created the objects which are grouped into classes.
• Designed and Developed extensive BOBJ reports using multiple Queries, combination of chart and tables.
• Worked closely with Datawarehouse architects to understand the process and design and implement the ETL.
• Created Ad hoc Reports using End User module in BOBJ.
• Created different types of reports like Master/Detail, Cross Tab and Chart.
• Wide usage of Drill mode and Slice and Dice techniques to modify the reports in accordance with the user’s analysis needs.
• Used Business Query to load data directly to Excel and also involved in formatting.
• Coded and maintained BOBJ Reports using Web Intelligence.
• Used Broad Cast Agent to schedule reports.
• Imposed several Joins, Filters, and Alerters to restrict the unwanted data and highlight the required data.
• Resolved loops with Aliases and Contexts.
• Provided training to end users to use various functionalities of BOBJ
• Creation of Re-usable repository using the Ascential Data Stage Manager.
• Extensively used Ascential Data Stage Director for scheduling the job to run at nighttime, emailing production support for troubleshooting from LOG files.
• Interacting with Report Users and Business Analysts to understand and document the Requirements and translate these to Technical Specifications for Designing Universes and Business Object Reports.
• Designing new Universes using features like Check Integrity, Aliases, Loops, Contexts, and Joins and finally creating the Objects (Dimensions, Measures and Details), whichare grouped into Classes.
• Maintaining Universes and Reports using BOBJ Best Practices in multiple Environments (Development, Test and Production).
• Created and Formatting the Reports as per the Users Requirements using the features in BOBJ like Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, @functions to analyze the data. Created and distributing Report Templates to Users. Web-Enabling the Reports using Web Intelligence.
• Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End User Notes.
• Developed Various Types of reports like blank reports, cross tab reports, sub-reports in Crystal reports.
• Managing security by Adding, Enabling, Disabling and Deleting of Users/Groups and the granting of privileges using Supervisor.
• Generated Test data for identifying valid data, Invalid data, Partial data, Bad data and Reported / Tracked defects using Star Team.

Environment: Business Objects 5.1, Data stage 7.5, SQL Server, DB2, Crystal Reports 9, Toad, Star Team, Manual Testing and Windows 2000/XP