SUMMARY

• IT experience: 9+ years of experience in Analysis, Design, Development and Implementation of Data Warehousing with Star schema, Extended Star Schema, Snowflake Schema and other applications using Object Oriented Analysis, Design and Methodologies.
• Business Intelligence: 7+ years of Business Intelligence experience in building Business Objects universes, developing reports, and analyzing OLAP data. Worked in various BO environments like linking data from multiple sources, applying several functionalities, and using various Data Providers, etc., trained users in producing documents and running queries. Worked with different types of team members for different tasks. Tested reports for validating and verifying data.
• Business Objects: 6+ years of Business Objects 4.0/3.1/3.0/XIR2/6.x/5.x experience - Central Management Console, Central Configuration Manager, BI Launch Pad/Infoview, WEBI/Desktop/OLAP Intelligence, Data Integrator, Information Design Tool (IDT)/ Designer, Administrator/Supervisor, Application Foundation, Enterprise Performance / Information Manager, Dashboard Manager, ScoreCards, Crystal Reports 2008/XIR2/6, SAP Business Objects Dashboards/Crystal Xcelsius 2008/4.5/3.5/3.0, Business Objects Data Federator, Explorer (Polestar), Live Office, LifeCycle Management (LCM), Import Wizard, and Report Conversion Tool and Services, and Publications, Broadcast Agent Scheduler Publisher, and Auditor.
• Dash Board Manager: 1 year of Dash Board experience using Dashboard Manager, Report Writer and Application Foundation 6.0/2.5, Performance Management, Dashboard Manager.
• Data Integrator: 2 years’ experience of using BO Data Integrator XIR2, Loaded data (FACT Tables, Dimension Tables) into data marts. Extensively used Data Integrator Designer.
• Informatica: 1+ year of strong experience in Data Warehousing and ETL using Informatica Power Center 8.1/7.1.2/7.0 Informatica Power Mart 6.2/5.1, Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, and Informatica server .
• Database experience: 8+ years of experience in Oracle Exadata/11g/10g/9i/8i/8.0/7.x, IBM DB2 8.1/7.0, MS SQL Server 2005/2000/7.0, MS Access 2007/2003, Teradata V2R5/V2R4, (database triggers, materialized views, In-line views, Packages, stored procedures, functions, and database constraints), Microsoft Enterprise Manager Query Analyzer, SQL Loader, SQL*Plus, PL/SQL and oracle DBMS Packages, oracle supplied utilities, Developer 2000 (Forms 6i/5.0, Reports 3.0/2.5), TOAD, Rapid SQL.
• Expertise in all the modules of Business Objects suite like Supervisor/CMC, BO/DESKI, Designer, WEBI, Performance Management, Date Federator, Explorer, Voyager.
• Knowledge of new features of Business Objects XIR2 including index awareness, Derived tables, Dashboards, Macros and Central management console.
• Experience in building documents using Universes, Personal data files and creating complex adhoc/Canned reports using the Business Objects Desktop Intelligence and Web Intelligence.
• Technically proficient in preparing Reports, custom formatting techniques, creating Cross-Tabs for Summarized Reporting.
• Worked with business users to analyze the business process to create the new Universes and change the existing universes as per the reporting requirement.
• Strong expertise in creating reports using the Business objects functionalities like Prompts, Slice and Dice, Open document (linking Reports), Drill Filters and Alerter.
• Efficient in Optimizing, Debugging and Testing SQL queries and stored procedures in Oracle, IBM DB2 and SQL Server.
• Used Crystal Reports 2008/XIR2 to develop custom and dynamic reports.
• Created Reports using BIRT and Endeca Latitude using various data sources (Data sets).
• Involved in Complete project life cycle processes, project documentation including requirements, design, functional and technical specifications and test plans based on strategies. Conducted War Room and JAD sessions.
• Good communication and interpersonal skills, capability to learn fast the latest trends and technologies and assume any responsibilities.

TECHNICAL SKILLS

Business Intelligence: BI/Business Objects 4.0/3.1/3.0/XIR2/6.x/5.x - Central Management Console, Central Configuration Manager, BI Launch Pad/ InfoView, WEBI / Desktop / OLAP Intelligence, Data Integrator, Information Design Tool (IDT)/ Designer, Supervisor, Administrator, Application Foundation, Performance Management, Dashboard Manager, ScoreCards, Crystal Reports Server XI, SAP Business Objects Dashboards /Crystal Xcelsius 2008/4.5/3.5/3.0, Crystal Decisions, Reports, and Excelsius Data Visualization, Live Office, LifeCycle Management (LCM), Import Wizard, and Report Conversion Tool and Services, and Broadcast Agent Scheduler, Publisher, and Auditor, SSIS, SSRS, SSAS, BIRT (Business Intelligence and Reporting Tool) 2.2.2/2.3.2, Query as a Web service, BEx Analyser 7.0, BEx Query Designer, SAP BO Data Federator 3.0, Explorer, Voyager.

Data Warehousing: Informatica Power Center 8.1/7.1.2/7.0, Informatica Power Mart 6.2/5.1, SSIS, Repository Manager, Designer, Star schema, Extended Star Schema, Snowflake Schema, ERwin 7/4, MS Visio Standard 2003.

Databases: Oracle Exadata/11i /10g/9i/8i/8.0/7.x, IBM DB 2 8.1/8.0/7.0, MS SQL Server 2005/2000/7.0, MS Access 2007/2003, Teradata V2R5/V2R4 (database triggers, materialized views, In-line views, Packages, stored procedures, functions, and database constraints), SQL Loader, SQL*Plus, PL/SQL and oracle DBMS Packages, oracle supplied utilities, Developer 2000 (Forms 6i/5.0, Reports 3.0/2.5), Microsoft Enterprise Manager, Query Analyzer, TOAD, Rapid SQL.

Programming/Web Technologies: Visual Basic 6, PL/SQL, HTML, UML Diagrams, Unix Shell Scripting, JavaScript, Crystal Reports, TOAD, DbVisulaiser, Apache Web Server, Tomcat, IIS 5.0/4.0.

Environment: MS Windows 95 - 2000/XP, MS office suite (Word, Excel, Access, Outlook and PowerPoint), MS- Windows NT, LDAP, Solaris, Linux, HP Unix, Lotus Notes.

PROFESSIONAL EXPERIENCE

Confidential

Business Objects Developer/Designer/Administrator

Responsibilities:

• Interacted with Business Users, Business Analyst to gather the Requirements and Business logics for Reporting projects which took place at End client.
• Installed BIP 4.0/ XI 3.1, SAP GUI 710, SAP Integration Kit 3.1, Crystal Reports 2008, Live Office XI3.1 on Windows Enterprise Servers and Client Machines. Upgrading to Service Packs at Server level and Developers PC’s.
• Created Functional Design document, Technical Design document and got approved from Business users.
• Involved in creating various BEx Query’s using BEx Query Designer. Created Mandatory and Optional variables in the Query Designer.
• Created 14 OLAP Universe’s in BO Designer on the top of BEx Query’s.
• Created Universe pre-defined filters, Dimension Objects and Calculated measures in OLAP universe’s with the help of MDX Functions.
• Generated around 120 Complex Canned Reports on top of OLAP Universe’s as per the requirements using WEBI, WEBI Rich Client Crystal Reports and scheduled the reports as per the requirements. Also created Dashboards using Crystal Xcelsius 2008.These 120 Reports and Dashboards are used by MP and SM group of Business users around the world.
• Created 12 Universe’s in BO Designer against EDW Oracle Exadata/HP Neoview.
• Created 3 Universe’s in BO Designer against Oracle 11g/10g.
• Applied Aggregate awareness in the universe to improve the Performance of reports.
• Created Index Awarness for the objects that are used for Prompts.
• Generated around 150 Complex Canned Reports using above mentioned 12 Relational Universe’s as per the requirements using WEBI, WEBI Rich Client and scheduled the reports as per the requirements.
• Used Open Document functionality to link WEBI reports and Dashboards.
• Validated the data against source system. Validated the data from SAP cube using BEx Analyser 7.0 to verify the data quality in the reports.
• Created BO universe and WEBI best Practices documents and Template reports which are being used by entire BOBJ Environment at End client.
• Designed, developed and maintained a wide dashboard Reporting using Live Office, Query As a Web Service (QAaWS) and Crystal Xcelsius.
• Combined data from SAP BW and Oracle using Data Federator and created universe using itual tables from Data federator.
• Created around 12 Information Spaces using Explorer (Polestar).
• Created and Maintained Servers/Users, Groups, Folders, and Connections and allocated rights to them using Central management console (CMC). Migrated Objects (Universes, Reports,etc..) from one environment to another environment using Import Wizard and Life Cycle Manager.
• Provided solutions at team meetings for critical defects rise.
• Trained the end users in using Business Objects Infoview and also trained a BO developer whoever new to BO 3.1 version.
• Documented entire work done by me.

Environment: Business Objects 3.1/BIP 4.0, BI Launch Pad/Infoview, Web Intelligence (WEBI), Web Intelligence Rich Client, QAAWS (Query as a Web Service), Live Office, SAP Business Objects Dashboards /Crystal Xcelsius 2008, Information Design Tool (IDT)/ BO Designer XI3.1, CMC, BEx Analyser 7.0, BEx Query Designer 7.0/3.x, SAP BO Data Federator 3.0, Explorer (Polestar), Oracle Exadata/ 11i, HP Quality Center and DbVisualizer 6.5.5.

Confidential, Oklahoma City, OK

Sr.Business Objects Developer/Designer

Responsibilities:

• Interacted with Business Users,Business Analyst to gather the Requirements and Business logics for FAST (Accounting & Finance, Operations Support) project whick took place at OGE.
• Involved in creating various Query’s using BEx Query Designer. Created Mandatory and Optional variables in the Query Designer which become the Prompts on BO side.
• Created Universe’s in BO Designer on the top of Query’s created in BEx Query Designer.
• Generated Complex Reports as per the requiremnts for various projects using WEBI through Infoview and scheduled the reports as per the requirements.
• Created Template reports which are standards for the entire OG&E.
• Used the Drill Concept in the WEBI a report, Hirerachy with 13 levels on Cost Center was built in SAP BW.
• Used OpenDocument and Drill Filters functionality to link reports during drill down/up.
• During linking reports answered (passed parameters to the child reports) the Prompts from SAP BW Query.
• Validated the data from SAP cube using BEx Analyser 7.0 to verify the data quality in the reports.
• Designed, developed and maintained a wide dashboard using Query as a Web Service and Crystal Xcelsius.
• Worked on Crystal Xcelsius dynamic data presentation software.
• Created Standard reports, Cross-tab Reports using Crystal Reports XIR2 against SAP BW cubes and BO Universe.
• Created Static, Dynamic and Dynamic Cascading Prompt parameters.
• Published reports on the web using Crystal Enterprise/BO XI Publishing Wizard.
• Created linked, unlinked and on-demand sub reports.
• Extensively involved in using of formula fields, parameter fields, Group selection, Custom Functions and record selection in Crystal reports.
• Migrated Documents (Reports) and Universes from Business Objects XIR2 to Business Objects XIR3 using Import Wizard.
• Worked very closely with BO Admin and on his absence to Migrate Universe/Reports from Development/QA to production.
• Created and Maintained users, Folders, Connections and allocated rights to them using Central management console (CMC).
• Enabled the report credentials like VOD-View on Demand, Scheduling, Arranging them in the associated folders, Validating the events of BO and crystal reports.
• Provided solutions at team meetings for critical defects raised.
• Trained the end users in using Business Objects Infoview and also trained a BO developer whoever new to BO XIR3 (3.0/3.1) version.
• Documented entire work done by me.

Environment: BEx Analyser 7.0, BEx Query Designer 7.0/3.x, Business Objects 3.1/3.0/XIR2, Infoview, Web Intelligence (WEBI), Crystal Reports XIR2, Query as a Web Service (QAAWS), Crystal Xcelsius 2008, Designer XI3.1/XIR2, CMC, Microsoft Office.

Confidential, Los Angels, CA

Sr.Business Objects Developer/Designer

Responsibilities:

• Interacted with Business Users,Business Analyst to gather the Requirements and Business logics for multiple projects whick took place at Confidential .
• Installed required softwares like IBM DB2 Connect Personal Ed 8.1, Informatica PC 8.1, MS Visio Standard 2003, Mercury Interactive TestDirector 8.0, Business Objects Enterprise XI R2 suite’s on client machine.
• Created catalogs to provide interface between BO designer and DB2 database.
• Loaded the data into 3 datamarts (MLCDM,APDM,HPDM) depending upon projects requirment using Informatica PC 8.1 where the source was FARMERS centralized datawarehouse(FDR).
• Worked on several transformations such as Filter Transformations, Joiner Transformations, Rank Transformations, Stored Procedure Transformations, and Expression Transformations in Informatica.
• Using the detailed Tech Specs, developed Informatica mappings and tuned them for better performance.
• Extensively worked on Informatica Transformations. Written maps for daily data loads.
• Created BI Design documents for every project in which I am was involved.
• Created views on database and used that view as a source for Universe designing as a part of farmers preferred program Project.
• Created 6 universes and modified the existing universes and also tested each universe by creating various reports.
• Resolved loops using contexts and aliases, created Dimensions, Detail and Measure Objects and exported Universe to repository.
• Used derived tables in designer for resolving issues during universe creation.
• Created Dynamic Date (Week/Month/Year) range Predefined Conditions.
• Generated Reports as per the requiremnts from various projects using WEBI through Infoview and scheduled the reports as per the requirements.
• Executed SQL queries against database to verify the data quality in the reports.
• Extensively involved in using of formula fields, parameter fields, Group selection, record selection, and Crystal syntax in Crystal reports.
• Designed, developed and maintained a wide dashboard using Excel and Xcelsius.
• Worked on Crystal Xcelsius dynamic data presentation software.
• Worked very closely with BO Admin and on his absence to Migrate Universe/Reports from Development/QA to production.
• Certifed every object in universes as a part of Certification Project.
• Created users, Groups, Folders, Maintained Services, Connections and allocated rights to them using Central management console (CMC).
• Provided solutions at team meetings for critical defects raised.
• Customized the user interface to meet the needs of end users with Business Objects SDK as a part of AOI project.
• Documented entire 3 projects.

Environment: IBM DB2 Connect Personal Ed 8.1, Informatica PC 8.1, MS Visio Standard 2003, ERwin 7, Mercury Interactive TestDirector 8.0, IBM Lotus Notes, Business Objects Enterprise XI R2, Infoview, Web Intelligence, Designer, Crystal Reports XIR2, Crystal Xcelsius 4.5.

Confidential, Toledo, OH

Sr.Business Objects Developer/Designer

Responsibilities:

• Interacted with Business Users,Business Analyst and Project Manager to gather the Requirements and Business logics.
• Installed BO XIR2 suite on client machine.
• Installation & configuration of Business Objects Enterprise.
• Loaded the data into datamart using BO data integrator where the source database was Oracle financial GL/AP Fixed assets.
• Created 2 BO universes and modified the existing universes.
• Resolved loops using contexts and aliases, created Dimensions, Detail and Measure Objects and exported Universe to repository.
• Created critical Financial, Manufacturing, Distribution and Supply chain department reports and modified existing reports.
• Worked with Oracle Process Manufacturing team to understand the business process.
• Migrated Universe/Reports from Development/QA to production.
• Executed SQL queries against database to verify the data quality in the reports.
• Developed reports as per the requirement through WEBI using InfoView and scheduled the report as per the requirement.
• Created reports using crystal Xcelsius where source was excel sheet.
• Involved in Migrating users, Universes, report objects (Webintelligence, Full Client) personal categories, inbox documents, universes, documents and universe connections.
• Enabled the report security through VOD-view on demand, Scheduling, Arranging them in the associated folders, Validating the events of BO and crystal reports.
• Trained the end users in using Business Objects Infoview and also trained a BO developer who was new to BO XIR2 version.
• Documented the entire 2 projects.

Environment: Business Objects 6.5.1/XIR2, Web Intelligence, Info View, Live Office, Business Objects Data Integrator XIR2, Oracle 8.1.6, Windows 2000, Microsoft Office 2003, UNIX, Tomcat 4.0.

Confidential, Woodland Hills, CA

Business Objects Developer/Designer

Responsibilities:

• Performed an initial study of the current reporting application, to finalize the data elements required for reporting.
• Analyzed user requirements and sorted the best possible ways of representing the data.
• Created Universes, Classes, Dimension and Measure Objects by retrieving the data from various data sources and defining the necessary connections.
• Detected/Resolved data Cardinalities and loops, checked integrity of Universes, created list of values. Resolved Chasm, Fan traps and Loop problems using aliases and contexts in the universe and exported to repository.
• Created Hierarchies, complex objects using various @functions, Aggregate objects in the universe.
• Implemented row and object level restrictions. Worked on linking of universes.
• Created reports using Business Objects functionalities like queries, cross tab, master detail reports, formulas, Customized filters to display relevant data, etc.
• Created complex reports using cascading prompts.
• Created variables, formulas and used contexts (in, for all, for each).
• Created Web Intelligence reports using Multiple Data Providers, Prompts, break, filter, rank, alerters, Slice & Dice and Drill up/down functionality.
• Created Hyperlinked Reports using Open Document Functionality.
• Created PL/SQL scripts including stored procedures, functions and packages to implement business logic.
• Tested reports before posting them to the repository (query optimization & performance).
• Migrated Universe/Reports from Development/QA to production.
• Used Crystal Reports to develop custom and dynamic reports.
• Designed and analyzed the reports using Crystal Reports.
• Used parameters, Formulas, running totals and Crystal Functions to Convert Data according to the specification of the report.
• Designed, developed and maintained a wide dashboard using Excel and Xcelsius.
• Migrated Objects, Documents and universes from Business Objects 6.x to Business Objects XI Enterprise using import wizard.
• Customized the user interface to meet the needs of end users with Business Objects SDK with VBA.
• Creation of prototype dashboards to demonstrate use of Interactive Metric Trends (IMT) for executive-level users.
• Involved in Migrating users, Universes, report objects (Webintelligence, Full Client), personal categories, inbox documents.
• Supported Business Objects Administrator in creating users and allocating rights to them.
• Worked in production support team for Supporting Business Objects Environment.

Environment: Business objects 6i/XI R2, WEBI, DESKI, Dashboard manager, Crystal Reports XIR2, Oracle10g, SQL Server 2005, Microsoft Enterprise Manager, Query Analyzer, Teradata V2R4, MS Office, Window 2000 and SQL Loader.

Confidential, Danbury, CT

Business Objects Developer/Designer

Responsibilities:

• Involved in full life cycle implementation (requirement gathering to production phase).
• Interacted with Business Analysts and end users to develop standard and ad-hoc reports according to functional requirements.
• Business Analysis and Requirements Gathering. Interviewing and coordination with end user communities.
• Converting high-level design specifications to detailed functional and technical specifications
• Worked with Business Objects Supervisor for creating repository, creating and managing the universes, creating categories, creating and managing the users, giving access permissions for Business Objects Reports.
• Used Business Objects Designer to create universes containing complex dimensions, measures, conditions and prompt objects to be used in Business Objects and Application Foundation.
• Defined and created dimension objects, conditions, user and measure objects to capture complex formulae.
• Extensively used Designer to design various Universes for different business groups, Created classes, aliases, help text, reports.
• Resolved Chasm, Fan traps and Loop problems.
• Developed Manufacturing, Distribution and Supply chain department reports.
• Extensively created Business Objects reports like tables and Pie charts.
• Extensively used breaks for white spaces and sections for better navigation. Created template documents with header, footer and company logo.
• Written complex queries using sub queries, Intersect and Union to generate reports using Free hand SQL and personal data files.
• Scheduled pre-canned reports through Broad Cast Agent Publisher for distribution and printing.
• Created Analytics like Interactive Metrics Trends, Goals & Speedometers using various metrics developed in Application Foundations.
• Validated all the reports rigorously and resolved any issue by working closely with Business Objects Technical Support.

Environment: Business Objects 6.5 (Designer, Supervisor, Web Intelligence 2.7,Broadcast agent), IBM DB2 UDB 7.0, ERWIN 4.0, Windows 2000, Oracle, SQL Server 2000, Microsoft Enterprise Manager, Query Analyzer, Unix Shell Scripting.

Confidential, MD

Business Objects Developer

Responsibilities:

• Interacted with Business Users and Business Analyst to gather the Requirements and Business logics
• Involved in creating reports and its publication to corporate documents.
• Designed and developed a Universe in Designer module of Business Objects 6.1 based on physical data model.
• Interacted with Project Manager and other resources in understanding the requirements and user specifications.
• Used the Broadcast Agent console for auto refreshing the business Objects Documents.
• Resolved loops using contexts created Dimensions, Detail and Measure Objects and exported Universe to repository.
• Migrated Universe/Reports from Development/QA to production.
• Executed SQL queries against database to verify the data quality in the reports.
• Developed reports as per the requirement through WEBI using InfoView and scheduled the report as per the requirement.
• Created a wide variety of charts like pie chart, 2d and 3d charts.
• Created Standard reports, Cross-tab Reports using Crystal reports.
• Extensively involved in using of formula fields, parameter fields, Group selection, and record selection in Crystal reports.
• Created standard reports, cross-tab, sub reports, using Crystal reports8.5.

Environment: Business Objects 5.1.2, Web Intelligence 2.7, Info View, Broadcast Agent 2.7, WebI, Crystal Enterprise 8.0/8.5, Windows NT, Oracle 9i, Excel 2000, Oracle 9i, Windows NT.