Profile:

• Over 9 years of IT experience including 7 years of experience in Business Intelligence tools including: Business Objects XI3.1/XIR2/6.5/6.0/5.1/5.0, Business Objects Designer, Reporter, Supervisor, Info view, Web Intelligence and BCA, Hyperion Interactive Reporting, ETL Data Integrator, Budgeting and Planning and Microsoft tools SSIS, SSRS and Crystal Xcelcius.
• Performed several full Lifecycle implementations of Business Intelligence products.
• Interactions with the executive team for the latest trends in BI and evaluations and recommending and implementing the best practices.
• Utilized the team resources, developed the plans, designed the architecture and completed various implementations.
• Designed extensive dashboards using Xcelcius and Roambi for both executive and mobile users.
• Designed the architecture of the Application,data models and structures and made them efficient to the business model.
• Experience building dashboards, universes, retrieving data using universes, personal data files, stored procedures, free hand SQL methods and creating complex ad hoc reports using the Business Objects and Web Intelligence modules.
• Sound knowledge in designing and implementing Star and Snowflake Schema.
• Set up the dimensions, roll ups and hierarchies in the planning applications.
• Thorough knowledge of web publishing and scheduling documents using broadcast agent. Managed resources such as universes, repositories and distribution of documents.
• Created complex reports by linking data from multiple sources using functionalities such as: combined queries, slice and dice, drill down, master detail, etc
• Knowledge of designing reports using the Crystal Reports using data access and report design.
• Involved with the identification of facts, measures, dimensions and hierarchies.
• Excellent leadership, technical, logical, and problem solving capabilities.
• Ability to adapt to changing professional work environment to implement software solutions in an efficient manner
• Through knowledge of architecture of the Data Integrator and resolved various issues relating it.
• Excellent writing and oral communication skills, Sales, management, billing, reporting and executive writing skills.

Technical Skills:

Business Intelligence Business Objects and OLAP:

XI3.1/XIR2/6.X,5.X,Designer,Supervisor,Web Intelligence2.X/6.X, Publisher, Application

Crystal Reports XIR2/8.0/7.0, Dashboard Manager, Data Integrator XI, Budgeting and Planning, Crystal Xcelcius4.5/2008 ,Hyperion Reporting and Web Analysis, SSIS, SSRS,Oracle Modeler.

RDBMS:

Oracle 11g/10i/9i/8i, SQL Server 2008/2005/2000, Teradata 3.1.

Methodologies:

Star Schema, Snowflake schema, Kimball, Immoh

Programming Languages:

C, C++, BASIC, Assembly language

Web Server/Application Server:

Microsoft IIS Server, Tomcat 4.0/5.5, Apache 1.3, Java Web Server1.2

Application sys software:

Adobe Works, MS–Office/access, Photoshop

Operating Systems:

Linux, Windows XP/2003/2000/NT

Professional Experience:

Confidential,Indianapolis, IN (March 2010 – Present)
Business Objects/Data Architect

Manage the enterprise data warehouse(EDW) environment for the reporting and dashboarding in the Health care industry. Developed the application architecture and implemented the Reporting hub for the whole company by utilizing the several different BI tools like Business Objects, Roambi, Microsoft Reporting and Integration services, Sharepoint server 2007.Managing a group of BI and ETL people.

Responsibilities:

• Developed the scorecarding model using Xcelcius, Live office through Business Objects
• Designed extensive dashboards using Xcelcius,Roambi,QAWS,Live office and xml data providers.
• Design the architecture of the BI environment ,optimize the processes and data quality with the latest trends in BI to give customers high level of satisfaction
• Managed the upgrade of current BI tools to the latest versions
• Manage the data warehouse team and ETL and BI groups
• Manage and evaluate the latest tools and trends in Business Intelligence
• Evaluate the latest tools in dashboarding and recommend and implement the best practices
• Interaction with the project stakeholders for the latest trends in BI and recommending the best practices
• Work on the Data Warehouse model of the clinical, inpatient/outpatient data.
• Build the Scorecards and high level dashboards for the physicians so that they are able to compare their performance based on specific set of measures against their peers/facility/nation
• Use Analytics, trend graphs, speedometers and gauges in the dashboards
• Upgraded the Enterprise reporting from version XIR2 to version 3.1. Designed the plan and assigned different tasks to different people
• Created the new Architecture of the 3.1 SAP Business Objects and upgraded from previous version
• Migrated over 10,000 reports from XIR2 to 3.1 environment.
• Integrated SharePoint 2007 with Business Objects 3.1.
• Accessed the current Cognos Environment and prepared a future scope of the project
• Work on the Scorecards for the Clinical data
• Build the live dashboards on Crystal Xcelcius 2008 using the Live Office capability
• Set up the whole architecture of BI tools including Business Objects Enterprise and Microsoft
• Involved with the creation of various complex reports by reviewing the Universes
• Managed several projects, assigned work as needed and gathered updates on regular basis
• Build dashboards and scorecards using the Performance Manager using different Analytics
• Involved in various team meetings to make updates on projects and determine their future goals

Environment: Business Objects 3.0/3/1/XIR2,SSIS,SSRS, Cognos 8, SQL Server 2008, Visual Studio 2008, Info View, Web Intelligence Rich client, Apache and Crystal Xcelcius 2008, Live Office

Confidential,Indianapolis, IN (November 2006 – February 2010)
Business Intelligence Architect/ Project Lead

Involved in the analysis of the PDF and Excel reports in the existing system and implemented the new Business Intelligence environment for sales, marketing and executive reporting.Designed the architecture and implemented the entire enterprise datawarehouse system for sales and marketing reporting initially and expanded to other groups including: budgeting and planning and data integrator.

Responsibilities:

• Worked closely with the business owners and end users to take the requirement and gave them the best possible solution to satisfy them
• Ability to handle multiple projects at a time and provided them the best possible solution
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports
• Involved in understanding the current Business flow and designed the datamodels according to the business needs
• Implemented BI as software as a service to serve various needs of the business
• Designed the Data Warehouse based on the business needs of the different groups
• Designed high level dashboards displaying sales activity on daily/monthly/yearly basis
• Designed the reports for the finance team showing the activity by site level
• Interfaced the 3.1 with SAP BW environment and created the reports on the top of using the cubes from the BW
• Designed few universes from the Bex queries.
• Designed dashboards using Crystal Xcelsius and embedded in the Infoview
• Extensive development using Xcelcius Engage using Live office and QAWS.
• Created the connections to the SAP through Business Objects 3.1.
• Involved in the data validation and provided accurate results
• Implemented the whole reporting system for sales, marketing and executive groups
• Involved in the designing and building of Universe, user friendly classes and objects
• Created a security plan for all the users. Different groups had different privileges and permissions as set up in the CMC
• Built high level dashboards from the reports
• Implemented Budgeting and Planning test and prod environments and managing the security of those
• Set up the Dimensions, Roll ups, Hierarchies and users for the planning application
• Worked on the Data Integrator on scheduling of jobs and security through Web Admin console
• Worked on Secure Central Repository, local Repository for the change management in Data Integrator
• Resolved issues regarding multiple Job servers of Data Integrator on one machine
• Designed and developed a future state DI environment for change management and cleaning the existing repository\'s and centralizing data in one single secure central repository
• Migrated and modified jobs from one repository to another and placed all jobs in the secure central to enable changes and can be tracked easily
• Set up and configured the environments related to production and test environments
• Applied security at four different levels namely at the Enterprise Application Level, Universe Level, Universe Connection Level and at the Folder Level
• Used Event Viewer along with log files generated by applying traces at various services in the CCM to pinpoint the exact source of error
• Created BIAR files at regular intervals to backup the system
• Developed VBAmacros and applied to the reports
• Set Up Groups and Users and assigned security levels to those users and groups and reviewed a number of training manuals and made improvements on those
• Completed scheduling to all the reports in different formats and given training to the end users about the same
• Resolved the issues relating to the current year (CY) and prior year (PY) and made them dynamic
• Involved in the creation of Prompts for Fiscal Year, Fiscal Month and Date range
• Created and combined user friendly objects and applied restrictions to the same
• Handled the Business Objects servers and client software
• Designer, Web Intelligence, central management console and CCM
• Communicated the vision and strategy of the Business Objects architecture with the business groups

Environment: Business Objects XI3.1/XI R2, SAP BW, Data Integrator XI, Oracle 9i/10g/11g, Data Integrator XI, Web Intelligence, Crystal Xcelcius4.5/2008,Crystal Reports, IIS, Info View, Apache

Confidential,Danville, IN (June 2006 – November 2006)
Business Objects Architect/Developer

Involved in the complete analysis of the earlier billing system and to implement a Business Objects XI R2 environment for the Cellular One and reproduce reporting capability similar to that available in the Business Objects environment provided by VeriSign Inc. Installed and configured Business Objects XI software and worked on the complete conversion analysis from the existing system to the new billing system. Designed universe for the reporting requirements and developed the reports based on the requirement of the end users.

Responsibilities:

• Performed an evaluation of the architecture of the current state Business Objects environment
• Established the Business Intelligence environment using Business Objects software that can meet the current reporting needs of the business users and provide a foundation for the future reporting
• Initial design documentation summarizing current environment settling and parameters
• Created the whole plan and gave guidelines to other team members and monitored the outputs
• Installed and configured Business Objects XI software (development and production servers) on the Linux Server
• Customized the dashboards for the executives using the speedometers and 3–D graphs
• Built different analytics and personal dashboards for the analysis of data
• Supported the Hyperion Reporting Web Analysis (WA) and Interactive Reporting (IR).
• Prepared reports from the Repository using different data elements (POV), formatted the grids, formatted cells, defined members and defined rows and columns properties
• Worked with the ETL team to govern the issues relating process flows
• Configured batch jobs as well scheduled jobs properly in Data Integrator
• Mapped the existing user in the Windows Active Directory to the Business Objects Enterprise
• Developed 10 new universes for the new billing system
• Worked on the various issues in the universe design
• Made changes in the Objects of the universes according to the needs of the Business users like changes in the formats of the objects, user friendly objects and on the object restrictions to the end users
• Worked on the chasm and fan trap problems in the universe design
• Worked on the Master, Kernel and Component approach during the linking of universes
• Resolved the issues relating to the end user requirements
• Worked in the CMC (Central Configuration Console) to add certain permissions to the Business managers and end users
• Worked on the conversion of core reports that exists in the previous billing system to the new billing system
• Made reports through SQL Server Reporting Services, stored procedures
• Resolved issues relating to the database and also made the user friendly universes from the new database
• Gave Universe Design Training to the end users

Environment: Business Objects XI R2/3.1,Data Integrator Xilinx, Hyperion 9.1, Business Objects 5.1.6 SQL Server 2005,SSIS, IIS, Info View, Web Logic, Apache

Confidential,Indianapolis, IN (May 2006 – June 2006)
Business Objects Developer

Worked in Revenue Systems to resolve the issues relating to the Teradata and the Business Objects XI R2 architecture. Resolved the end user issues relating to the Universe design and few reports. Also supported DBA for the new Business Objects XI R2 architecture and worked on the issues relating to the Servers like Web intelligence Server, Report Application Server and FRS (Input as well as Output File Repository Servers).Also played an active role in configuring some of the servers in the Central Configuration Manager (CCM).

Responsibilities:

• Resolved the issues relating the interfacing of Teradata with Business Objects XI R2
• Worked on the changes in the Servers for the proper functioning of the Web Intelligence
• Worked on the some issues, issues like Fan Traps and loops, relating to the universe designers and provided the best possible solutions
• Made some changes in the universes in order to improve performance features for the end users
• Troubleshot the BO servers in the Linux environment
• Created a number of users through CMC in order to perform a stress level test for the Business Objects in the server machine
• Worked on reports in the existing system and recreated them in the new system
• Completed analysis of one complete web application for reporting (Web String) and reproduced similar capability in the Business Objects environment

Environment: Business Objects XI R2, Teradata 3.1, IIS, Info View, Web Intelligence, Web String, Teradata SQL assistant

Confidential,Sterling, VA (September 2005 – May 2006)
Business Objects Developer

Involved in the development of Universe for the Phase II of the ICIS (Integrated Compliance Information System) project that was designed for the Environmental Protection Agency (EPA). The main objective of the project was to make sure the rules and regulations of the EPA are properly monitored and enforced. The system is designed to keep track of the permits issued to various industries and farms, and how they are complying with the emission and discharge levels set by the EPA. Failure to comply with the requirements would lead to the generation of a violation and repeated attempts of violation could even lead to the canceling of Permit.

Responsibilities:

• Involved in understanding the end user requirements and business processes in creating and designing universes, queries and reports
• Worked on the chasm and fan trap problems in the universe design
• Worked on the Master, Kernel and Component approach during the linking of universes
• Created contexts, aliases, joins and cardinalities to resolve the loops and checked the Integrity of the universes
• Involved in the creation of Prompts for Fiscal Year, Fiscal Quarter and Date range
• Worked in modifying objects by using different conditions
• Prompts were designed in such a way that it should give the end user an option to choose one value, multiple value or all values
• Exported the LOV’s with the universe and the end users are given an option to edit the list of values
• Scheduled and monitored reports at the server level using Broadcast Agent (BCA)
• Provided standard, number and date formatting for the corresponding object types
• Used prompts in the reporter as well as in the universe to create more interactive reports for running different kind of comparison reports
• Worked extensively on distribution, maintenance, and optimization of universes for Business Objects and Web Intelligence deployments
• Exported the universes to the Repository for making resources available to the end users
• Responsible for retrieving and publishing documents from and to Corporate Repository
• Worked with the add, create, delete users in the in the supervisor module
• Working knowledge of Business Objects XI enhancements

Environment: Business Objects 6.5, Oracle 9i, Web Intelligence 6.5, Info View, WebLogic, Apache

Confidential,Chandigarh, India (July 2002 – August 2005)
Business Objects Reporting

One of the leading companies dedicated to providing cutting–edge Embedded, Networking and Information Technology Solutions to its clients. The project involved testing or verification and validation of clientele software. The team was responsible for testing the products or application in different ways to ensure the software was bug free. Each team member was assigned modules to test for defects and the defects found were listed to be given to the corresponding developers to fix the bugs.

Responsibilities:

• Involved in preparation of Detailed Design Documents
• Generated the Business Object Reports using the universes as the main Data provider
• Developed complex queries including Sub queries, Unions, Intersect and Aliases
• Created User Objects including Dimensions, Details and Measures
• Reports were formatted to the users according to the user requirements using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, @Functions and Formulas etc
• Created Master Detail and Cross Tab reports to view the data in an analyzed way
• Involved in the creation of Prompts for Fiscal Year, Quarter and Date range
• Organized data in the reports inserting Filters, Sorting, Ranking and highlighting data using Alerts
• Worked with Hierarchical grouping and drill down reports
• Used Reports and generated pictorial views in the form of 2D, 3D & Pie Charts from existing Reports & Chart Wizard
• Worked with ranks, alerters, prompts, variables and calculation contexts in designing reports
• Scheduled and monitored reports using Broadcast Agent server
• Created complex prompt filters, and objects to calculate the period related information for Project to Date and Fiscal Period to date budget and expenditure queries
• Gathered software requirement specification from the users
• Identified and reviewed the design outputs against the design input requirements
• Provided reports requirements gathering and designing technical and functional specifications
• Interaction with different clients
• Involved in creation of Database Tables, Global Temporary Tables, Cluster Tables, Partition Tables, and Index–by Tables using storage parameters
• Involved in interaction with the End Users and implemented reviews of the application

Environment: Business Objects 5.1, Web Intelligence server, Business Objects designer, BCA 5.1, Oracle 8i

Education:

• Bachelor of Engineering in Electronics and Instrumentation