SUMMARY

• IT professional with over 7 years of working experience in different technologies including Business Intelligence Technology and toolset.
• Strong working experience in all of Business Objects Analytical tools using different versions of Business Objects Enterprise (6.5/XIR2/R3/R3.1),Crystal Reports.
• Worked with different Databases including SQL Server 2005/2000, Oracle and DB2.
• Experience in working with BI project development methodology including Analyze, Specify, Design, Plan, Develop, Test and Deploy projects.
• Good knowledge of Data modeling and dimensional modeling.
• Created parameterized, cross - tab, Drill down and summary reports in Crystal Reports.
• Streamlined client reporting requirements and successfully developed and delivered Business Objects Universes and Webi reports based on those requirements.
• Business Objects Migration experience migrating contents from older versions to newer versions of Business Objects Enterprise.
• Expertise in gathering the business requirement by interacting with client directly and creating Business Requirement Specification Document, Design and functional documents.
• Involved in Full development life cycle while developing contents (building Universes and creating Reports) for different projects and different clients.
• Expertise in creating Universes using Personal data files, stored procedures, free hand SQL methods and creating complex ad-hoc Reports using Web Intelligence/Crystal Reports.
• Expertise in building/enhancing/migrating Business Objects universes and moving contents from one environment to another (i.e. Dev, QA, UAT, Prod) using import wizard.
• Business Objects Administration experience working with Supervisor and CMC to support existing BOE Environment.
• Created complex Dashboards by using different data sources like Live Office, QaaWS.
• Involved in POC of Xcelsius/Live Office to the client also trained users on Business Objects functionality and tool set.
• Mentored and helped developers to enhance their skills in using BI tools and utilize them in best manner possible.
• Experience working with Onsite and Off-shore models of Project Development.
• A self-motivated and self-directed person with Excellent Communication, interpersonal skills and ability to work under Tight Schedules.

TECHNICAL SKILLS

BI Tools: Business Objects XI 3.1/R2/R1/6.X/5.X (CMC, CMS, DesignerDesktop Intelligence, Web Intelligence, Live Office), Business Objects 6.x/5.x (Supervisor, Designer, Reporter, Web Intelligence), BCA, Crystal Reports XI/2008.

RDBMS: Oracle, MS SQL Server, DB2, MS Access.

ETL Tool: Data Stage

Languages: PL/SQL, VBA, Java, C, and C++.

Operating Systems: Windows XP/NT/98/2000/Server2003, UNIX, LINUX, MS-DOS.

Other Tools: SQL Word, Toad, MS Office 2007/2005/2003 , AQT

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

Business Objects Developer/Technical Lead

Responsibilities:

• Involved in gathering reporting requirements and analyzing existing legacy system.
• Modify the existing marts by adding dimensions or measures as needed.
• Created classes, subclasses and objects including complex measure objects according to the business requirements from the Universe schemas and database tables
• Created Custom Hierarchies for several groups in Universe and also provided row level security for the end users.
• Worked extensively with (@select, @aggregate aware, @where, and @prompt) to overcome the problems with database when integrating with Business Objects.
• Coordinated with the ETL team to discuss the business rule/logic used to develop mapping and processes to populate the marts/tables.
• Interacted with DBA to tune the report queries to enhance the performance of the reports.
• Create standard reports in Business Objects as per the specs finalized. Most of these reports are complex reports having multiple data providers and use advance formatting like Sections, Master Detail and Cross-tab.
• Used AQT (Advanced Query Tool) to verify data pulled by the report is correct compared to the database data and also to verify the joins used in designing the universe are correct
• Interact with the users to get approval of the developed reports, Promote reports in the production environment through Change Management.
• Modified the existing Universes by merging different Classes, resolved the Loops and Chasm Traps by context.
• Modified existing Business Objects/ Crystal / SQL Word reports as needed.
• Create and test BO/Crystal reports. These reports use multiple data providers and involve complex features of Business Objects
• Provided production support during and/or after office hours on technical Business Objects related issues and/or data analysis on data related issues to end users.
• Created interactive reports in Xcelsius with the summary level data.
• Designed and developed dashboards using Query as a Web Service (QAWS) in Xcelsius
• Created score cards in the Xcelsius.
• Created Report level variables by using Used Variable Editor.
• Scheduled and monitored reports using Broad Cast Agent (BCA).

Environment: Windows 2000 x, Business Objects 3.1 tools (Designer and Business Object-Reporter), Xcelsius, Oracle 9i, DB2 Database, Hyperion Essbase, Excel Add-Ins.

Confidential, Trenton, NJ

Business Objects Developer

Responsibilities:

• Involved in user training, trained users on InfoView and Xcelsius Applications, and provided technical guidance to users.
• Created universes with Classes and Objects for investment management system.
• Created universe on top of views build in composite coming from multiple data sources.
• Worked extensively with (@functions (@select, @prompt, @where) in designer, created optional prompts, also created objects using complex case functions.
• Addressed chasm trap and Fan Trap using Multi Parse SQL. Resolved Loops using Aliases and Context.
• Created Multiple Custom Hierarchies for several groups to provide drill across functionality.
• Wrote functional specification documents for the project scope to be created in security to be implemented in Business Objects XI R 3.1
• Responsible for maintenance existing universes, Webi reports and Crystal reports.
• Extensively involved in developing Web Intelligence reports, publications, scheduling and monitor publications.
• Created Xcelsius Dashboard using Query as a Web services and XML as a source.
• Implemented security matrix in CMC, created access levels for users and applied restrictions on contents.
• Implemented Row level restriction for managers profiles using designer.
• Resolved tickets to support production environment, Modified and tweaked report content and distributed reports in multiple formats such as Excel and PDF.
• Used @aggregate aware () function and Aggregate tables for optimized query performance.
• Used @functions to create predefined conditions and prompts to filter the data and dynamic user selection.
• Created reports using Crystal Reports with Standard, Summary, and Cross Tabs and Grouping.
• Used conditional formatting as per user requirements in Crystal reports.
• Created WEBI Reports with multiple variables at report level to meet complex business requirements.
• Written user training documents for basic implementation Design and create User guide and Training Guides.

Environment: Business Objects XI R 3.1, ITM Software, Hyperion ESS Base, SQL Server 2000, Oracle 9i,Unix.

Confidential, San Francisco, CA

Business Objects Developer

Responsibilities:

• Involved in requirement gathering from end users to create universes and reports.
• Developed dashboard using Xcelsius for Risk management department, involved in POC and user training on Xcelsius and live office
• Created universe and trained users for ad-hoc reporting using Infoview and Rich - Client.
• Provided technical guidance, mentoring and knowledge transfer to client.
• Deployed and Tested the crystal Reports on Crystal Report Environment 8.0
• Involved in migration from business objects 6.5 to Business Objects XIR3.1 using Import Wizard.
• Involved in report conversion extensively using Report conversion tool as well as manual conversion.
• Installed and configured Business Objects Enterprise XI 3.1 using Apache/Tomcat.
• Worked as Dashboard/Performance Manager to analyze the investment return.
• Creating complex full client and Web intelligence reports using graphs, pie-charts and multiple data providers on daily, weekly, monthly and quarterly basis
• Used combined queries and sub queries to create reports using Webi and Deski.
• Developed Custom hierarchies to support drill down reports, used scope of analysis to define drilling scope.
• Created data flows and work flows, used query transforms to do the ETL jobs created in Data Services.

Environment: Business Objects XI R3.1, SQL Server 2000, Oracle 9i,10g, Windows XP.

Confidential, Santa Ana, CA

Business Objects Developer

Responsibilities:

• Provided on-site Business Objects XI Release 2 (XIR2) universe and Web Intelligence (Webi) report development services. Responsibilities with lead role in support of the Business Intelligence deployment.
• Development of Test Cases matching requirements with help from business analysts.
• Created various Cross-tab, Master-detail, tabular and Summary reports.
• Acquired an excellent understanding and work experience of EXCEL functions in Xcelsius.
• Involved in analyzing, developing and testing various Business Objects Reports based on grouping, drill downs, charts and custom formulas etc.
• Converted P1 reports from desktop Intelligence to web intelligence using Report conversion tool and manual conversion method.
• Applied calculations and used formatting using different colors and functionalities i.e. alerter, sorting, ranking and formulae in the report.
• Wrote a full functional specification document for the security to be implemented in Business Objects XI R2.
• Involved in dimensional modeling Star Schema customization.
• Developed reports in 6.5 Worked extensively with (@functions (@select, @prompt, @where) in designer, created optional prompts, also created objects using complex case functions.
• Developed reports in XI R2 web intelligence.
• Installed and configured Business Objects Enterprise XIR2 using Apache/Tomcat.
• Wrote SQL queries to extract the data from Sales Force database.
• Wrote Formulas to calculate the Percentages and Summaries based on the group levels.
• Use of Analyzer and Explorer to view reports from different prospects (Slice and Dice, Drill down).

Environment: Business Objects XI R2, ITM Software, SQL Server 2000, Oracle 9i, Unix.

Confidential, Lake Forest, CA

Business Objects Developer/Crystal Reports Developer

Responsibilities:

• Involve in user requirement gathering for the project, interacted with the Business users to better understand the requirement and to purpose solutions.
• Involved in development of universes and reports, also involved in production support, solving user tickets and issues on daily basis.
• Involved in 4 Full Development life cycles of universes from understanding the scope of the projects to deploy and support the universes.
• Developed universes for sales and marketing department, using star schemas and snowflakes as source for these universes.
• Provided post production Business Objects universes and reports support and maintenance.
• Enhanced and modified the Sales Commissions full-client and web intelligence report issues.
• Analyzed specs and database model to generate the reports for the sign-off specs.
• Created Business Objects Web Intelligence reports and published on the INFOVIEW.
• Optimized report performance by modifying the SQL generated by Business Objects, used combined queries and sub query options to bring complex result set in the report.
• Connected to Business Objects Repository as a Business View and created reports.
• Used Crystal Report XI Enterprise to design the front end reports.
• Used Team Track to track the status of the report by developer, state and comments.
• Scheduled various reports in Broadcast Agent on a weekly or monthly and send the output to users.
• Responsible for improving the query performance by 80% by tuning the Queries and creating business views.
• Created User Ids and implemented security features.
• Managed categories that were created and assigned to documents by users.
• Presented the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily.
• Provided complete documentation and presentation at the end of the contract to help users in developing various reports using different functionalities and methods used in creation of reports.

Environment: Business Objects 6.5, SQL Server 2005, SQL integrated services, Windows NT.

Confidential, Columbus, OH

Business Objects Developer

Responsibilities:

• Primary task was to provide technical assistance, guidance; mentoring and supervision to client’s developers in converting their Consumer Credit Management system Java based portal reporting system to Business Objects Web Intelligence 6 base report platform.
• Successfully assisted and mentor the client’s development and conversion project to completion and implementation. Build the Universes for Business Analyst report generation using Designer module.
• Detect Joins and checked the Cardinalities. Used Slice and Dice, Drill Down, Filters, Conditions, Cross Tab, Master Detail and Formulas etc and developed Hierarchies to support drill down reports.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions, Cross tab, Master-Detail and Formulas etc.
• Used WEBI info view to open and display documents, traverse a category hierarchy, create, rename and delete categories, get the details of a category, add and remove documents to and from a category.
• Converted Crystal reports 8.0 to Business Objects reports 6.5.
• Experienced in writing SQL. Plus Queries to test the Reports.
• Scheduled various reports in Broadcast Agent on a weekly or monthly and send the output to users.
• Responsible for improving the query performance by 80% by tuning the Queries and creating business views.
• Resolve Universe problems like Loops, chasm trap fan trap using Alias and context.
• Develop and create classes with Dimension, Detail & Measure objects.
• Develop Custom hierarchies to support drill down reports.
• Developed Graphic Reports, Pie charts for the statistical representation of the data
• Create Derived tables in the Designer to enhance the capabilities and performance of the universe.
• Generated reports involving complex queries, sub queries, and combined queries such as Unions and Intersection
• Implement cascading prompts in universe.
• Check the integrity of the Universes, and export the universes to Repository for making available to users.

Environment: Windows XP, Business Objects 6.5(Designer and Business Object-Reporter), Oracle 9i

Confidential, Eden Prairie, MN

Business Objects Developer

Responsibilities:

• Built additional new universes for Inventory Management, Purchasing and Receipt tracking system for ad-hoc reporting.
• Using context selection and Business Objects aggregate-aware features to in corporate summary information in the universes.
• Provided production support during and/or after office hours on technical Business Objects related issues and/or data analysis on data related issues to team lead and end users.
• Provided technical solutions and fine tuned long running query to improve query performance.
• Modified and enhanced all clients’ standard Business Objects reports for scheduling in Broadcast agent.
• Assisted/guided end users to efficiently use the universes in building simple and complex reports.
• Developed and Deployed complex reports. Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts.
• Worked extensively with (@select, @aggregate aware, @where, and @prompt) to overcome the problems with database when integrating with Business Objects
• Created templates for standardizing the Structure of our Corporate Documents.
• Worked extensively with the major functionality of Business Objects like Breaks, Alerter, Filters, Sorts, Query Prompt and Drill filters.
• Created Report level variables by using Used Variable Editor
• Analyzed the reports using the Drill Through, Slice and Dice.
• Scheduled and monitored reports using Broad Cast Agent (BCA).

Environment: Windows 2000 x, Business Objects 6.1 tools (Designer and Business Object-Reporter), Oracle 9i.