PROFESSIONAL SUMMARY

• Over 8 years of IT experience in Business Intelligence and Data warehousing Technologies.
• Diversified Experience in implementation of Business Objects in Finance, Insurance, Telecom, Manufacturing and Pharmaceutical sectors.
• Extensive exposure in DimensionalData Modelling,Physical & logical Data Modellingusing Erwin.
• Complete Life Cycle Knowledge including Architecture, CapacityPlanning,Installation, Administration, Change Management and UpgradingBusiness Objects Enterprise XI 4.0/3.1/ 3.0/XI R2/6.5 in a Distributed and Clustered Environments
• Design, Implement and Maintain Business Objects Security Models and configuring Business Objects Enterprise, LDAP, Windows Active Directory, and Windows NT authentication
• Strong Experience in migration of Business Objects 5.X/6.X to XI/XI Release 2, XI 3.0, XI 3.1
• Extensive experience in Migrating Universes, Folders, Report Objects, User Objects using Import Wizard and LCM(Life Cycle Manager).
• Hands on experience in using Publishing Wizard, Broadcast Agent, Report Conversion Tool.
• Extensively Worked on Oracle 7.x/8.x/9i/10g/11g,MS-SQL Server 7.0/2000/2005/2008,Teradata V2R6.2/12.0.1 and IBM DB2.
• Extensive experience writing complex SQL' s and stored procedures using PL/SQL programming.
• Expertise in Tuning of SQL Queriesleading to significant improvement in system response time and efficiency using Explain Plan, TKPROF and Auto Trace.
• Excellent Knowledge in Extraction, Transformation and Loading process using Informatica, Data Stage and Microsoft SQL Server Integration Services (SSIS).
• Hands on experience working with SAP BW.
• Good Knowledge in SAP BI/BW components like Data source, User Exits, ETL activities like OLTP data extraction, loading (Full/Delta Up-Load), Scheduling, Monitoring, Process Chains, Remote Cubes, Open Hub Service.
• Worked on integration of SAP BW in planning, reporting and simulation based on the user requirements.
• Good Knowledge of SAP BW Security Performed positive and negative security testing.
• Good Knowledge on BEx Analyzer, Query Designer, Web Application Designer, BEx browser.
• Good Knowledge to work with SAP BW BEx Queries and creating connections from SAP to BO Systems.
• Extensive Experience Designing, Maintaining and Modifying Universes using BO Designer.
• Extensively used Multiple Data Providers such as Universe, Free-hand SQL, Stored Procedures and Personal Data Files for generating reports.
• Strong experience in creating complex reports using Business Objects and Crystal Reports functionalities Such as Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail, @Functions, Custom sorts, Formulae, Summary, Form and Sub-Reports.
• Analyzed and Created the data in charts(pie charts, bar graphs, line graphs) using various metrics & formats using slice/dice, drill up/drill down, Hierarchies, Scope of Analysis etc.
• Extensively used Xcelsius and Live Office in Creating simple to complex Scorecards and Dashboards.
• Good Working knowledge of BO Dashboard Manager and data visualization using Crystal Xcelsius.
• Expertise Developing Canned/Ad-hoc Reports, scheduling Reports and administering the BO activities.
• Extensively worked in converting Crystal and Tableau Reports to Business Objects Reports.
• Experience in creating macros in Business Objects and Excel.
• Strong experience in writing Test plans, Test cases, Unit testing, System testing & Integration testing.
• Involved inDocumenting Processes, Business Objects Environment Architecture, Server Configurations, Sizing Specifications, Training End Users and Preparing Training Material
• Strong time management and project coordination skills with simultaneous projects.
• Excellent Technical, Analytical and Problem Solving Skills. Ability to rapidly learn new Technologies.
• Experience in conducting small and large group presentations and proven to be highly effective in interfacing across business and technical groups.
• Experienced in Training & Supporting End-Users.
• Flexible & versatile to adapt to new environment with strong desire to keep pace with latest technologies.

TECHNICAL SKILLS

BI Tools : Business Objects 4.x/5.x/6.1/6.5.1/XIR1/R2/R3.0/R3.1,Crystal Enterprise
XI /9.0/8.0/6.0, SAP BW 3.5, Tableau 5.1/6.0
ETL Tools : Informatica PowerCenter 6.x/7.x/8.x/9.1.0 (Repository Manager,
Designer, Work flow Manager), SSIS (SQL Server Integration
Services), Data Integrator (BODI), Data Stage
Data Modelling Tools : Erwin 4.0/3.5, MS Visio
Databases : Oracle7.x/8.x/9i/10g/11g,MS-SQL Server 7.0/2000/2005/2008, Teradata
V2R6. 2/12.0.1,DB2 UDB, MS-Access.
Web Technologies : HTML, DHTML, Dream weaver, Photoshop, MS FrontPage.
Web/Application Servers : Apache, Tomcat, JBoss, Web logic.
Tools / Packages : TOAD, Oracle Enterprise Manager, SQL Navigator, SQL Loader,
SQL*Plus, SQL Developer, MS Office suite (Word, Excel, Power Point)
Languages : SQL, PL/SQL, T-SQL, XML, Java, ASP, JSP, .NET, Visual Basic
Operating Systems : MS-DOS, Windows 95/98/2000/NT/XP/Vista/7, Linux, UNIX, SUN
Solaris

EDUCATION

• Bachelors in Computer Science Engineering
• Masters in Computer Science

PROFESSIONAL EXPEREINCE

Confidential
OCFO - Office of Chief Financial Officer
Washington, DC 09/11 - To Date
Sr.Business Objects & Informatica Lead Consultant

The replacement of EPA' s Integrated Financial Management System (IFMS) possessed significant challenges for many EPA feeder systems, consumer systems, and most importantly for the Superfund User Community.

EPA-OCFO proposed to create a Superfund Consolidated Data Source (SFCDS) to meet the Superfund Community Requirement. The Superfund Consolidated Data Source provides Repository of Comprehensive Superfund Cost Recovery Data including legacy data. It has Detail-level, post Momentum go-live Superfund Data, converted and non-converted data within Functional Data Warehouse.

Responsibilities:

• Involved in Gathering, Interviewing and Analysing the Superfund Community Requirements from Business Users.
• Extensively worked with SFCDS team to analyse the Legacy and New Applications to design the Superfund Consolidated Data Source (SFCDS).
• Created the Scope Documentation for the implementation of Superfund Consolidated Data Source.
• Assisted in creating Data Mart to support SF Data Source and various other Projects.
• Extensively involved in Dimensional Data Modelling, ETL Design and Universe Design for SFCDS.
• Interacted with the various Data Source Teams involved and gathered the Data.
• Developed strategies for data extraction from various source systems, transformation and loading into SFCDS target system.
• Worked with functional analyst to Document the Source-Target mappings with the business logic.
• Lead a team of 4 on the project.
• Extensively used Informatica to Create Mappings, Workflows and Jobs for data extraction and Loading.
• Build the XML' s for deployment of the code from development to staging to production.
• Verify the logs to confirm all the relevant jobs are completed successfully and timely and involvedin production support to resolve the production issues.
• Provided Solution to Automate Superfund Consolidated Data Source (SFCDS) process using Business Objects Reporting Tool.
• Created Universes based on Reporting Requirements and modified existing universes to cater the Reporting Needs.
• Extensively worked on BOWeb Intelligence and Full Client Canned and Ad-Hoc Reports.
• Converted the existing Full Client and WEBI Reports as part of the Migration.
• Created simple and complex Dashboards using Xcelsius and Live Office
• Performed Report Scheduling, Publication, Report Bursting Setup.
• Created Package Build Forms for deployment from one environment to the other.
• Developed Test cases/scenarios with concerned users and obtaining necessary sign offs.
• Interacted with Business users to understand the issues and action the support tickets.
• Scheduled the Reports as per requirement and distributed it to different Functional Groups.
• Created Documentation for the whole scenario of the project.

Environment: Business Objects XI R3.1, Informatica 9.1.0, Oracle 10g/11g, Erwin/Visio, Toad 10.6, SQL Developer Windows 7 Professional, UNIX, Linux, Microsoft Share point Portal, XML, Tomcat, Apache.

Confidential
Livermore, CA 07/10 - 09/11
Sr.Business Objects & Informatica Consultant

Responsibilities:

• Involved in Gathering and Analyzing the Requirements from Business Users and Engineers.
• Understanding the Manual Process used for tracking the Lead Times on the Probe Cards Manufacturing.
• Documented the Manual Process Involved in Tracking the Lead Times to Build a LTM Reporting Tool.
• Created the Scope Documentation for the implementation of Lead Time Management Reporting Tool.
• Provided Solution to Automate Lead Time Manual Process using Business Objects Reporting Tool.
• Interacted with the various Data Source Teams involved and gathered the Data.
• Documented the Data Source Mapping for the different Source Systems involved.
• Data Modelling, ETL Design Semantic layer/Universe Design and Dashboard Design.
• Created a Data Mart to support the Lead Time Management Tool and various other Projects.
• Extensively used Informatica to Create Mappings, Workflows and Jobs for data Extraction and Loading.
• Installed and Configured Business Objects XI R3.1 on clustered environments of Windows and UNIX.
• Configured BOE with Windows Active Directory (AD) with SSO (Single Sign On).
• Created the BIAR files to backup the Content in Business Objects XI R2.
• Migrated Business Objects XI R2 to Business Objects XI R3 using Import Wizard and LCM.
• Provided Complete Support to entire Business Intelligence environment right from software installation, configuration, upgrades and enhancements.
• Extensively Worked with CMS and CMC components to configure and maintain BO environment.
• Installed Service/Fix packs, critical hot fix and monthly hot fix.
• Configured Audit Database on all the servers and created the AuditReports.
• Created Universes for Reporting Requirements and modified existing ones to cater the Reporting Needs.
• Extensively worked on BOWeb Intelligence and Full Client Canned and Ad-Hoc Reports.
• Created Hyperlinked Web Intelligence (WEBI) Reports using Open Document Functionality.
• Installed and Configured the TABLEAU Desktop client.
• Converted Existing TABLEAU Reports to Business Objects as part of the Workflow Migration.
• Created simple and complex Scorecards and Dashboards using Xcelsius and Live Office
• Performed Report Scheduling, Publication, Report Bursting Setup.
• Created Tasks, CCB (Change Management) and PMF (Production Migration Forms).
• Developed Test cases/scenarios with concerned users and obtaining necessary sign offs.
• Interacted with Business users to understand the issues and action the support tickets.
• Scheduled the Reports as per requirement and distributed it to different Functional Groups.
• Created Documentation for the whole scenario of the project.

Environment: Business Objects XI R3/XI R2, Tableau 5/6, Informatica 8.5, Oracle 10g, Windows XP/2003 Server, Unix, Sun Solaris, Salesforce CRM, Oracle Applications, Agile, Erwin/Visio, Microsoft Share point Portal, Toad 9.7.2

Confidential, 03/10 - 07/10
Erlanger, KY
Business Objects & Informatica Consultant

Toyota Motor Engineering & Manufacturing North America (TEMA) is an automobile manufacturing and research and development company owned by Toyota Motor Company. It is the result of a merger of Toyota Motor Manufacturing North America (TMMNA) and Toyota Technical Center (TTC) U.S.A., and has its headquarters at the former TMMNA headquarters in Erlanger, KY.

Responsibilities:

• Involved in Functional and Technical Requirements gathering from Business Users & Divisions.
• Coordinated with the Design Team to create Datawarehouse and Data Marts.
• Extensively worked on Informatica to Create Informatica Mappings, Sessions and Jobs for data Extraction and Loading.
• Created complex Universes for Reporting Requirements and modified the existing ones as part of enhancing the universes to satisfy the new and existing reporting requirements.
• Linked the Universes to shared common objects. Updated and maintained Universes based on changing user requirements and data source changes.
• Created Complex Desk I and Web I (Web intelligence) Reports and modified existing Reports.
• Created Reports from Multiple Data Providers each of the Data Provider being on a different Database Platforms as part of integrating the Data from the Plan View and People Soft Application.
• Created On Demand, Ad-Hoc, Summary, Cross-tab, Conditional, Drill-down, Charts, Sub and Graphical Reports using Business Objects and Crystal Reports.
• Extensively used Business Objects SDK to customize look and feel of Business Objects Reports.
• Provided recommendations on performance enhancements in Pre/Post Production environments.
• Involved in Production support for fixing the issues pertaining to Business Objects Environment.
• Scheduled the Reports and Distributed Reports in multiple formats such as Excel, word, HTML & PDF.
• Provided Technical support to Power/End Users
• Created Documentation for knowledge transfer (KT).

Environment: Business Objects XI R3.0, Crystal Enterprise XI, Informatica 8.0, Oracle 9i, MS SQL Server 2005/2008, TOAD 8.5.1,Plainview Portfolio Management, People Soft HR System, Windows XP/2003 Server.

Confidential, 10/09 - 03/10
Indianapolis, IN
Lead Business Objects Consultant

Precision Rx Specialty Solutions (PRxSS) is a full-service specialty pharmacy based in Indianapolis, IN that is backed by the nation' s leading health benefits company. Designed to more effectively manage and monitor the distribution of specialty drugs, PRxSS offers a robust support program including a team of personal care coordinators, pharmacists and nurses to help people taking specialty medications achieve the best possible outcomes from their treatments. It offers condition-specific member care coordination - through a dedicated team of health professionals - to help promote quality, safety and clinical effectiveness in the treatment of complex, chronic diseases. Express Scripts Inc, one of the Nation\'s largest Pharmacy, recently acquired WellPoint NextRx.

Responsibilities:

• Interacted with Business Analysts, Business Users and Managers in gathering Business Requirements.
• Understand the business requirements and come up with High-level Reporting Requirements, Semantic Design, Dashboard Design and Report Mapping Design Documents.
• Estimated High-level project effort and resource requirements.
• Extensively Worked with CMC to manage the BOE environment.
• Used Import Wizard for migrating Folders, Groups, Objects, and Universes from Development to Test to Production Environments and create BIAR files for back up.
• Extensively used SQL Server Integration Services (SSIS) to extract and load data.
• Used Report Conversion Tool to convert Desktop Intelligence reports to Web-I reports.
• Created Simple and complex universes to meet the Reporting Requirements.
• Performed linking of the universes, and applied hierarchies based on business procedures.
• Created Web-I Reports on multiple universes with Ranking, Filters, Prompts and Formulas.
• Extensively Worked on Crystal Reports making use of formulas, parameters, field expressions, special fields, mapping to data sources, performing linking etc.
• Query Performance Optimization.
• Performed troubleshooting users having problems with B.O. Security, Access to Applications, Web-I reports, Universe connections, Session timeouts, and Report schedules etc.
• Experience in Crystal Xcelsius creating Templates, Visualizations, Charts, Sliders, and Gauges.
• Interact and Delegate work to offshore Team.
• Demonstrate leadership in problem solving and mentorship, in depth knowledge of business intelligence, Business Objects and data warehouse technology.
• Provided complete Documentation for the whole scenario of the project.

Environment: Business Objects XI R2, Crystal Reports XI, Oracle 10g/ 9i, SQL Server 2005, Teradata, Remedy Ticketing System ,TOAD 9.0.1.8

Confidential, Coralville, IA 04/09 - 10/09
Lead Business Objects & Informatica Consultant

Confidential, the nation' s leading provider of saving, planning and paying for education programs. The company provides federal and private student loans for undergraduate and graduate students and their parents.

Vangent Inc. provides IT support for Sallie Mae Inc. which funds private education and federally guaranteed consolidation loans to students and families nationwide. Vangent Inc. is currently dealing with the project Falcon -- Department of Education Servicing Contract by Sallie Mae Inc. It involves developing the Data Mart based on FSA Database called CLASS which is on DB2 and Mainframes and also provide Daily, Monthly and Quarterly Reports based on the Data Martto be delivered to Sallie Mae Inc and FSA.

Responsibilities:

• Involved in Client Interaction and Understanding the Requirements
• Created the Business Requirement Document (BRD) and Technical Requirement Document (TSD).
• Coordinated with the Design Team in defining the data model and its attributes.
• Performed Analysis of migration content to the New Environment.
• Installed and Configured Business Objects XI 3.O server/client tools, QaaWS, and Crystal Celsius.
• Configured and Managed Auditor on Business Objects Servers to track User and System Activity.
• Performed through testing on the content in the new environment migrated from the previous system
• Configured and Deployed Performance management applications.
• Extensively used CCM to manage various BO servers.
• Used the CMC to secure dashboards and restrict access to performance management.
• Extensively worked on Central Management Console (CMC) and Info-view to perform Business Objects Server side Administrator role to manage users, objects, security both user level and object level.
• Responsible for developing BW data models and designs, configuring custom and delivered content BW objects, analyzing BW reporting requirements, developing detailed reporting specifications
• Designed, developed ETL and extracted SAP BW Data for Reporting needs.
• Extensively worked on SAP BW/BI content.
• Identified possible Reports that Department of Education need from Sallie Mae to service the FSA loans.
• Lead a team of 9 developers and testers on the project.
• Identified the scope of the Reports and distributed them into Business Objects or Crystal Reports.
• Designed Universe on data model for three segments Loan Transactions, Loan Daily, Loan Monthly.
• Designed universes for Reporting and Metric Universes for Performance Management.
• Created Universes using SAP BI/BW Queries as Source Data.
• Created WEBI and Crystal Reports and deployed them through Info View with BW Universe as Source.
• Created Contexts/Aliases for resolving Loops and Hierarchies to support Drill up/down.
• Performed Testing of universes, reports functionalities, reports performance, Dashboards functionalities in the new environments before migrating.
• Created Complex Desk I, Web I and Crystal Reports (Loan Servicing, Financial Transaction and Claim Reports) using universes, free hand SQL, Stored Procedures and Personal Data Files.
• Created Several Drill Up/Down, Drill through Capable, Hyper-linked Reports and used Calculations, Variables, Breaks, Sorting, and Alerts for creating Business Objects reports.
• Added, Modified and positioned analytics and Web I reports in personal, corporate Dashboards and in compound analytics.
• Performed Ad-hoc query testing on universes, Developed Test scripts and tested reports data.
• Tested the system before going live by increment users and different activities.
• Scheduled and Distributed Reports in multiple formats (Excel, HTML, PDF, Fixed Width Text & CSV).
• Trained Users to build Reports and use the different functionalities Available in the Reporter Component.
• Created Documentation for the whole scenario of the project.

Environment: Business Objects XI R2/3.0, Crystal Reports XI, SAP BW3.5, Informatica, Windows XP/2003 Server SP1, Oracle 10g, .NET (ASP), Erwin4.1, TOAD 8.0, SQL Developer.

Confidential
Columbus, GA 09/08 - 03/09
Business Objects Consultant

Confidential, is one of the largest Financial Institutions in the Southeast Region, providing Banking, Investments, Asset Management Services, Commercial and Retail Banking to customers. It emerged as one of the strongest and most capable regional banking networks in US. Synovus Financial Corp has implemented Business Objects as an OLAP tool for reporting across all the data marts for SFC Loans.

Responsibilities:

• Involved in functional requirement gathering from Business Users & Teams.
• Prepared Requirements specification documents, Business Objects environment specifications, Business Objects sizing and capacity planning documents.
• Prepared Technical specifications for Lender workbench and LLR Data mart, Universes and Reports.
• Involved in designing\\modelling using ERWIN the Data Marts adhering to the Enterprise Standards.
• Developed ETL Jobs using SQL Server 2005 - Integration Services (SSIS) from various sources and constructed daily and weekly batch process to load the LLR\\Lender workbench Data Marts.
• Worked with business team in finalizing the Report Design by creating excel and HTML mock-ups and upon approval involved in designing \\ construction of reports.
• Analyzed Existing System and gathered andprepared a list of items that needs to be migrated.
• Discussed the Pros and Cons with the limitations and Future consequences of BOXI R2 with the Team.
• Migrated the Existing Version of Business Objects to Newer Version and customized the system.
• Installed and Configured Business Objects XI R2 on Production, Development and Test servers.
• Involved in the sizing in BOXI R2 to meet the old system requirements.
• Installed and configured server settings and created server groups.
• Extensively used CCM(Central Configuration Manager) to manage the BO servers.
• Created New Universes and Applied Row Level and Object Level Securities.
• Analyzed macros from old system and created an easy work around process in the new system.
• Tested the system before going live by increment users and different activities.
• Configured the Web and Application servers for the new Business Objects server.
• Configured and Deployed Performance management applications.
• Used the CMC to secure dashboards and restrict access to performance management and used designer to restrict access to metrics.
• Created Universes based on the reporting requirements and modified the existing ones as part of enhancing the universes to satisfy the new reporting requirements.
• Designed universes for Reporting and Metric Universes for Performance Management.
• Added, Modified and positioned analytics and WEB I reports in personal, corporate Dashboards and in compound analytics.
• Created Complex Full client and WebI Reports and Modified existing Reports based on Requirements.
• Extensively worked with formatting the reports according to user requirements
• Performed Ad-hoc query testing on universes, Developed Test scripts and tested reports data.
• Created several Interactive Web pages in .NET (ASP) and integrated with Database.
• Migrated Universes, Reports, Folders from Dev to QA to Production environments using Import Wizard.
• Trained the End Users and Power Users to Create Reports.
• Created Documentation for the whole scenario of the project.

Environment: Business Objects XI R2/6.1, Windows XP/2003 Server SP1, Teradata V2R6.2, MS SQL Server 2000/2005, Erwin4.1,Teradata SQL Assistant, Toad.

Confidential, 01/07 - 09/08
Treasury & Security Services, Tampa, FL
Business Objects & Informatica Consultant

Confidential, has implemented Business Objects as an OLAP tool for reporting across all the data marts for Treasury & Security Services (TSS). The current deployment of Business Objects allows users of the different data marts to create and analyze canned as well as ad hoc reports across various universes and data sources.

Responsibilities:

• Involved in gathering requirement from End Users and translated requirements to Technical Specifications for the DDA (Demand Draft Account) and Liquidity Data Mart Universes & Reports.
• Acted as a supervisor and led the execution of reporting projects across all 7 data marts.
• Administered and Maintained the Business Objects Servers in Production and Development environments.
• Installed and Configured Business Objects XI R2 on Production, Development and Test servers.
• Configured the Web and Application servers for the new Business Objects server.
• Setup single sign on functionality with LDAP.
• Created different CMS clusters and also different server groups to gain performance.
• Configured the auditing database to track the users and system activity.
• Configuring File Repository Servers, Crystal Report Job, Cache and Page Servers, LOV Job server, Web Intelligence Job and Report Servers, Desktop Intelligence Job, Report and Cache Servers, Destination Job Server, Program Job Server, and Event Server.
• Created User Groups, Users, Categories and Profiles and assigned privileges based on there roles.
• Created new universes for upcoming reporting requirements and modified the existing ones as part of enhancing the universes to satisfy the new reporting requirements.
• Provided support to an existing data mart against the MS SQL Server 2005
• Provided support to the End Users in installing and configuring Business Objects desktops products.
• Rebuilt and modified the existing universes based on DB2 Database (DDA and Liquidity) to Oracle Database (Namely DDA ORA and Liquidity ORA) universes.
• As a measure to improve the performance of the reports we planned to have constraints on the universe.
• Created and modified Full client and Web I Reports based on the business requirements.
• Created Complex reports using universes, Personal Data files, free hand SQL, Stored Procedures and migrated the already existing excel reports to Business Objects.
• Created Cross-tab, Conditional, Drill-down, Charts and Sub reports.
• Designed and Developed complex reports using Crystal Reports involving Standard Reports, Mailing Label Reports, Sub reports, Graphs and Cross Tabs.
• Created Daily and Monthly reports for Bear Stearns Inc a recent acquisition by JPMorgan Chase.
• Applied Row and Object Level Restrictions to the different user.
• Developed stored procedures, packages and views for use in crystal reports
• Created Macros using BO SDK (VBA) to generate Excel and PDF files from business objects reports.
• Scheduled and Published the reports using CMC and Infoview.
• Distributed reports in multiple formats such as Excel, word, HTML & PDF and monitored the reports daily in Business Objects environment this was done using the existing Batch Script Files..
• Involved in technical, production support for fixing issues pertaining to Business Objects environment.

Environment: Business Objects Enterprise suite XI R2/6.5.1, Crystal Reports XI/9.0, Windows XP/2003 Server SP1, Oracle 9i, MS SQL Server 2005, IBM DB2 V 7 / 8, Teradata, TOAD.

Confidential, is one of the leading global, broad-based health care companies providing reliable service and delivering to the customers. The aim of the eBReporter project was to develop a Reporting System comprising of different Universes, Canned & Ad-hoc Reports and corporate Repositories to support decision making for Target executives, managers, and HR Generalists as the audiences of the tool to effectively communicate and monitor business results based on different Analysis Techniques.

Responsibilities:

• Involved in functional requirement gathering from Business Users & Teams.
• Installed & Configured Business Objects XI R2 Enterprise Suite.
• Created Users/Usergroups and assigned privileges using Central Management Console (CMC).
• Assigned row level and object level security using Designer in BO XI R2.
• Converting Desktop Intelligence Documents to Web-Intelligence Reports using RCT
• Created schemas for the warehouse and BI Analysis Requirements using ERWIN by designing Logical Datamart Schema and Creating Physical Data-models.
• Involved in designing and Building Universes from different data sources (Oracle and SQL Server).
• Linked Universes to share Universes which had common dimension tables and classes and objects.
• Created Contexts, Joins and Aliases for resolving Loops and check Integrity of Universes.
• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters) and @Select.
• Created Desk I and Web I Reports based on Business Requirements from Multiple Data Sources.
• Designed, Developed and tested Reports based on data generated by enterprise transaction, financial and customer information systems.
• Assisted in migration of crystal reports from R1 to R2-Resolved Issues related to report distribution.
• Created Crystal Reports based on requirements which included designing cross tab, summary Reports, Sub-Reports withparameter passing from tables, views and stored procedures.
• Scheduled and Published the Reports through Schedule manager on a regular basis.
• Involved in Production Support and trained the end users.

Environment:Business Objects XI R2, Crystal Reports XI, Oracle 10g, MS SQL Server 2005, TOAD, TOAD,
Windows 2003 Server, Red Hat Linux 8.0/9/1.

Confidential, India 06/04 - 12/04
Report Developer

Confidential, one of biggest Banking & Financial Company with wide range of Business Areas. The project involved creation of Reports for a Central Data warehouse for the Debit division of ICICI Bank. This warehouse is projected to assist Sales and Marketing Department to categorize their customers based on significant portfolio of services including checking accounts, savings accounts, personal loans and geographical area.

Responsibilities:

• Gathered the Reporting Requirements from the Business.
• Created Reports using Crystal Reports & Business Objects.
• Created Business Objects Reports for day-to-day Analysis & Calculations.
• Worked with BO reporting features like Breaks, Alerter, Filters, Sorts, and Query prompt and Drill filters.
• Analyzed the reports using the Drill Through, Slice and Dice.
• Setup Print Setup & Configurations for all the Reports.

Environment:Crystal Reports 6.0,Business Objects 4.X, Oracle 8.1, MS Excel, SQL, Windows NT/2000, Sun Solaris.