Professional Summary:

7 years of IT experience in all aspects of Systems Development and complete Project Life Cycle in Data warehousing, and OLAP applications including Requirement gathering, Analysis, Design, Development, and Documentation.

• Extensive experience in Business Intelligence and Data Warehousing.
• Expertise in working with Business Objects Universe Designer, Web Intelligence, Desktop Intelligence, Crystal Reports, Import Wizard and CMC.
• Extensively created and maintained complex Business Objects Universes and Reports using the Designer and Reporting modules on SQL Server, Oracle databases and SAP BEx queries.
• Experience in SAP BW - BO Integration.
• Extensive experience in creating repository, scheduling and publishing reports through BCA. Created Cardinalities, Contexts, Joins, Prompts, Cascading prompts, Aliases for resolving Loops and checked the Integrity of the Universes.
• Strong expertise in creating reports using the Business objects functionalities like Prompts, Slice and Dice, Drill Mode, Filtering.
• Expert in migrating Business Objects 6.5 to Business Objects XI R2.
• Expertise in implementation of Crystal Enterprise & Reports, Crystal XCelsius.
• Used LDAP (Lightweight Directory Access Protocol) set up for creating & managing user accounts.
• Managed the resources, granted permissions to Business Object product users, WEBI users, managed the connections, universes and repository domains.
• Worked with Business users to analyze the business process and made necessary changes to the schema objects and trained users.
• Familiar with UML Methodologies using MSVisio, Rational Rose.
• Knowledge on Installation of BO XI server products.
• Excellent technical, logical, code debugging and problem solving capabilities.
• Excellent team player having strong interpersonal skills and ability to interact with business users, managers, technical personnel.

Technical Skills:

• ETL Tools: SQL Data Transformation Services, SSIS, SSAS, Informatica Power Center 8.6.1 and Business Objects Data Integrator.
• OLAP: Business Objects Designer 5.1/6.0/6.5/XI R2/XI 3.0/3.1
• Reporting/DSS: Business Objects 5.1/6.0/6.5,/XI R2/XI 3.0/3.1, Web Intelligence, Info view 1.0 and Crystal Reports 10/2008, SSRS 2000, SAP BW 3.5/7.1
• Analytics: Business Objects Dashboard Manager, Xcelsius 2008.
• Operating Systems: Windows 98/XP/2000/2003, UNIX
• Databases: Oracle 8i/9.0/10G, SQL Server 2000/2005, MS Access, UDB DB2
• Languages: PL/SQL, C
• Internet Technologies: JSP, XML, XSL, HTML, JavaScript, HTML, DHTML, ASP, VB Script, IIS and Adobe Flex.
• Configuration Management Tools: PVCS, Version Manager, VSS

Professional Experience:

Confidential, TN Nov'08 - Present BI Consultant

Confidential is one of the leading health care companies providing advanced medical devices for health care professionals around the world.
Business Intelligence Rapid Deployment project involves analyzing and delivering BW - BI content using Business Objects Enterprise.

Responsibilities:

• Interacted with the Business Analysts, Business Users and Management Group for gathering report and analytical requirement
• Installed & Configured of Business Objects XIr2/XI3.O/3.1 Enterprise Suite of Products.
• Managed and configured the XI 3.1 Environment using the CMC and CCM utilities.
• Set up best practices for all Business Objects development and administration
• Involved in defining Security roles for Users and User Groups, and assigned different privileges to users depending on their profile.
• Converting high-level design specifications to detailed functional and technical specifications
• Created various Universes and Reports using Designer and Full client Business Objects
• Developed reports on SAP BW Infoproviders using SAP BEx Reporting tool.
• Created multiple Universes against SAP BW Infocubes and SAP BEx Queries.
• Created Joins, checked the integrity of the universe and resolved loops and traps using aliases and contexts
• Created Alerts and Implemented Ranking in the reports
• Participated in merging different Universes into one Universe.
• Re-pointing reports from old Universes to New Universe. Fixing synchronization issues.
• Import and export universes and reports to and from the repository
• Created users, users groups and maintained user access rights.
• Developed Dashboards and Scorecards using Xcelsius.
• Developed queries to extract data from database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality
• Updated Universes by adding new objects to support new enhancements.
• Analyzed Business Objects implementation and gave performance recommendations
• Extensively used Data Integrator, SSIS to extract, transform, and load data from various sources into a data warehouse used for analytic and on demand queries.
• Created delta loads that incremented based on update and entry dates.

Environment: Business Objects XIR2/XI3.1, Web Intelligence, SAP BW3.5/7.0 (Business Explorer), Xcelsius 2008, Data Integrator11.7, SSIS, SSAS, SQL Server 2005, Windows 2003, UNIX.

Confidential, TX Nov'07 - Oct'08 Business Objects Consultant

Confidential wireless is the largest wireless company in the United States, with more than 65 million subscribers who use the nation's largest digital voice and data network. This project is about IVRS (Interactive voice response system) which involves the Design, Development and Maintenance of Business Objects universes and create Reports.

Responsibilities:

• Requirements Gathering and Business Analysis
• Designed and Developed universe in the designer, connected to the database, Created classes and objects, joins and predefined conditions
• Used multiple data providers such as Universe and personal data files in generating report.
• Created Aliases and Contexts for resolving Loops in the Universes to improve performance.
• Worked with various types of joins such as inner-joins, outer-joins, equi-joins, theta-joins, defined cardinalities and resolved issues like loops and traps by creating aliases and contexts
• Extensively used filters, conditions, list of values (LOV), calculations, etc.
• Used @functions like @prompt (for user defined queries), @where (for creating conditional filters), and @select to create duplicate objects in the process of building the universes.
• Resolved issues like Loops, Fan Traps & Chasm Traps by creating Aliases and Contexts as required in removing the cyclic dependencies.
• Documented and Created different canned and Ad hoc reports for Delinquency Reports, Reports by Period, Demographic reports and other Comparative reports in Full Client and Web Intelligence.
• Created Dash Boards Using Crystal Xcelsius Designer.
• Designed Visual Display models Like Graph, Gauges Using Crystal Xcelsius Designer.
• Used Business Objects EPM for accurate estimation of the call waiting and network traffic thereby removing the bottlenecks in the network, also used for controlling cost for new phone promotion.
• Developed most of the reports with Crystal Reports tool using complex formulae with Running Totals based on Grouping, Parameters (Dynamic and Cascading prompts) and Sub-reports.
• Created custom hierarchies while designing universe and making it available to end users through Web Intelligence.
• Leverage the Business Objects Universe (Semantic Layer) to make measures aggregate aware. These changes substantially improved query performance.
• Used the drill down/up, slice and dice features to analyze data, set variables, alerts and group values in the reports.
• Created Deski Reports using user variables, aggregates and other functionalities.
• Created and configured multiple Job servers and Webi Report servers.
• Configured multiple cluster servers in Development and QA environment.
• Involved in support, for fixing the bugs reported from System and UAT test and keeping track of the bugs.
• Drawn activity diagrams using Rational Rose.

Environment: Business Objects 6.x/XIR2, Crystal Reports, Web Intelligence, Dashboard Manager, BO Designer, Oracle 9i/10g, PL/SQL, Windows 2003 server, UNIX.

Confidential, CA Aug'06 - Nov'07
Business Objects Developer

Triad Financial is an independent, wholly owned subsidiary of Confidential. Triad focuses on non-prime lending for new and late model used automobile purchases. It primarily provides loans to borrowers through new and used car dealerships throughout the US. The project was concerned with building financial universe and producing various reports for finance, marketing and sales department.

Responsibilities:

• Collaborated with the business analyst in gathering business, functional requirements and documented the requirements as well as the data specifications for the business objects reports and universe enhancements for approval
• Checked the integrity of the enhanced universe by analyzing additional joins, defining cardinalities, and resolving cyclic dependencies and traps
• Implemented Aggregate Awareness to enhance query performance
• Creating, maintaining and modifying the universes using Business Objects designer
• Created custom LOVs, cascaded and nested prompts
• Organized classes and objects as specified in the Design Specification document
• Set up hierarchies/custom hierarchies for multidimensional analysis
• Exported the enhanced universe to the repository
• Linked different data sources to display in a block for data comparisons
• Documented and created different Canned and Ad hoc reports for Delinquency Reports, Reports by Period, Demographic reports and other Comparative reports in Full Client and Web Intelligence
• Generated Complex reports and calculations with formulae, variables and different in-built functions and universe modifications for some reports
• Involved in performance tuning of Business Objects Report which are running significantly slower
• Formatted data through various presentation styles such as charts, cross tabs, master-detail, breaks, sorts, ranking and alerter
• Improved report response time by tuning BO queries
• Created reports with Drill functions for multi-dimensional analysis of billings, costs, income and profitability to analyze them geographically, periodically and product wise
• Exported reports to the corporate documents, and scheduled/monitored the reports via Broadcast Agent server
• Checked Universe for integrity and exported to repository to make it available for user groups.
• Created Template for the reports as Landscape and portrait types
• Attended user meetings to collect the data to develop reports
• Did Unit testing for developed reports

Environment: Business Objects 6.5, Designer, Reporter, Web Intelligence 6.5, Crystal Reports, Data Integrator, Broadcast Agent Server and Publisher, Toad, Teradata V2R5, Oracle 10g, Win XP

Confidential, NY, NY Apr'05 - Aug'06
Crystal Report Developer
Confidential is a leading supplier of highly specialized software and expertise for financial institutions and corporation's activities, which have established our reputation as "the house of financial know-how". SimCorp Dimension 4.1 is an integrated standard software solution to financial institutions and corporate treasuries. It provides solutions that support the customers\' central business processes. The project encompassed development of reports for various modules (front office, middle office, back office, Risk Measurement, Training, etc).
Responsibilities:

• Interacted with the users for understanding and gathering business requirements. Involved in preparation of various reports of different modules and coordinating with the clients, participating in the weekly calls and meetings regularly.
• Worked as part of the Client Services Reporting team and participated in the full life cycle development of advanced reporting solutions from requirements gathering, data analysis, report design and testing, scheduling and maintained reports as per client or user needs.
• Participated in business requirements and functional specification reviews to evaluate business requirements and write technical specifications.
• Helped define the report requirements documentation for the Client Service Reporting Group.
• Development of various Crystal reports for different modules involving cross tabs, sub reports, chart and graphs.
• Coordinated with the distribution centers to process map, identify and recommend opportunities to improve processes and reduce cycle time.
• Performed Unit Testing for all the reports.
• Up-gradation of existing reports to enhance their performance.

Environment: Crystal Reports XI, Oracle 9i, PL/SQL, TOAD and Sim Corp Dimension 4.1.

Confidential, MI Jun'04- Apr'05
Crystal Report Developer
ITMS is a web application for accepting all the IT Project related information at Ford. The reporting on the project health and financials is done using Business Objects. Business Objects is used both for Ad hoc reporting and canned reports.
Responsibilities:

• Involved in Installing the Business Objects, creating, recovering Repository, creating Users, User Groups and Categories.
• Involved in taking requirements, writing specifications for generation of reports.
• Responsible for including Business Objects deliverables in the SDM process for current release.
• Responsible for driving the team meetings.
• Responsible for micro-charter sign-offs and customer acceptance.
• Designed, developed, maintained and tested universes for supporting ad hoc queries and canned reports.
• Created reports using Universe, Free-Hand SQL, Stored Procedures as Data providers.
• Designed, developed and maintained Projects, Programs, Applications, Operations Review and Other IT universes.
• Developed both full client and webi reports.
• Utilized Business Intelligence capabilities of Business Objects using Business Objects SDK to support event handling in reports. Built the feature of Nested Prompts in reports using BO SDK.
• Customized the web intelligence interface using JSP.
• Trained Business End users on webI and Full-Client reporting.
• Provided end-user training on aspects of Business Intelligence, including concepts and best practices.
• Worked on Multiple data providers in creating Canned Reports.
• Utilized the concept of Database views for improving the efficiency of report generation to slice and dice data.
• Involved in Deployment Strategy for both thin and full client.

Environment: BusinessObjects6.1.4, WebIntelligence, SSRS, MS SQL Server 2000, JSP, and Windows NT/XP, UNIX.

Confidential, India Mar'03 - May'04
Oracle PL/SQL Developer

Confidential, India had implemented Inventory Management System in its various plants. The aim of this project was to enhance certain modules of the inventory management system for Confidential

Responsibilities:

• Clarified the requirements by talking to the user groups and accordingly modified the functional and technical specifications.
• Developed / modified Oracle PL/SQL codes like stored procedures, functions, triggers etc based on technical and functional specification documents.
• Developed / modified scripts to create tables, views and executed them using SQL Plus.
• Developed / modified scripts to rectify data errors and executed them using SQL Plus.
• Responsible for generating various levels of reports using Oracle Reports 2.5.
• Involved in unit test, integration test and test plan.
• Ran batch jobs for loading database tables from flat files using SQL Loader
• Prepared unit test cases and executed the same.

Environment: Oracle 8i, PL / SQL, TOAD, Developer 2000 (Forms 4.5 & Reports 3.0), Windows 2000, Visual SourceSafe, SQL Loader.