SUMMARY

• Over 8 years of Business Intelligence solutions with experience in all stages of software application development life cycle.
• Strong experience in Developing BI reporting applications using Business Objects, Crystal Reports.
• Good Knowledge in Data Warehouse and Transactional database design and development, Data modeling, Business Intelligence Concepts.
• Expertise in OLAP/OLTP system study, analysis of database schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling
• Expertise in gathering business requirements and preparation documents such as of Business Requirements Documents (BRD), Functional Specification Documents (FSD), Meta Data document, Report Requirement Document, Project Specification Document, Technical Specification Document, and Requirements Traceability Matrix.
• Expertise in all modules of Business Objects suite (XI R3, XIR2, 6.x and 5.x) with experience in Central Configuration Manager (CCM), Central Management Server (CMS), Central Management Console (CMC), Desktop Intelligence, Import Wizard, Publishing Wizard, Designer, Reporter, Broadcast Agent, Web Intelligence and Info View and Crystal Reports.
• Involved in Migration of Business Objects 6.5 content in to Business Objects XIR2/R3 and HANA BI 4.0 environment.
• Well versed with BI Mobile concepts and implementation.
• Knowledge of SAP MM Module and a very good handle on the SAP BW architecture
• Expert in troubleshooting issues and Installation & Configuration of Business Objects Enterprise product Suite.
• Sound knowledge of Datawarehousing concepts like dimensional data modeling, star and snowflake schemas
• Involved in DataStage MVS will compile Cobol data integration programs for transfer and execution on a mainframe.
• Expertise in resolving Join path problems like Loops and Traps in the Universes using Aliases and Contexts.
• Experience in Creating Repositories, Folders, Groups, Users, Assigning privileges to users and maintaining the Repository.
• Extensively used Business Objects Reporting functionalities such as Aliases, Context, Slice and dice, Drilling Methodology, Filters, Sorts, Ranking Sections, Graphs, Query Prompts and Breaks.
• Experienced in developing Dashboards using Xcelsius& Dashboard manager.
• Extensively worked on Query As A Web Service (WSDL’s) while getting the query data from Business Objects Enterprise to Xcelsius 2008 / 4.5 .
• Involved in Scheduling and publishing reports in Crystal Enterprise Environment/ Business Objects Enterprise XI R2 Environment.
• Good working knowledge of implementing object and row level security in Business Objects XIR2/XIR3.
• Specialized in creating complex query reports using Oracle, SQL Server, Teradata, DB2, MS Access, MS Excel, XML and various RDB.
• Extensive experience in working on both UNIX and Windows environments.
• Experience in Unit testing which included data validation using SQL scripts, data integrity, functional testing, integration testing, regression testing and system testing, post production support.
• Exposure to Data Modeling, Normalization, and Business process Analysis, Reengineering and Logical & Physical database designs.
• Experienced in working with Business Managers, Analysts, End users and all the stake holders in documenting requirements, providing estimates, creating High and Detail Level design specifications.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals/teams at all levels.

TECHNICAL SKILLS

OLAP Tools: Business Objects 6.5/XIR1/ R2/ R3/ R3.1, HANA,BOBJ BI 4.0( Business Objects Designer, Desktop Intelligence, Web Intelligence, WebI Rich Client, Universe Builder, Voyager, Central Management Console, InfoView), Xcelsius 4.5/2008 (Live Office, QAAWS), Crystal Reports 9/10/XI/2008, SQL Server Reporting Services 2005/2008.

ETL Tools: BusinessObjects Data Integrator, SAP BW 3.5/BI7, InformaticaPowercenter.

Programming Languages: PL/SQL, Transact - SQL, Unix Shell Scripting, Java, J2EE, Advanced C, C++, C# .NET, VB .NET, and ASP.NET.

Databases: Oracle 8/8i/9i/10g/11g, SQL Server 2000/2005/2008 , Teradata V2R5/V2R6/12, MS Access, MS Excel(vlookup, hlookup, pivot tables), Apache Tomcat Server.

Database Tools: PL/SQL Developer, Toad, Datastage 8 server,SQL*Plus, SQL*Loader, PL Edit, SQL Server Management Studio.

Web Technologies: XML, XSLT, VBScript, Java Script,.NET Framework, HTML, DHTML.

Operating Systems: Windows NT, Windows 95/98/2000/XP,Linux, IBM AIX, Unix.

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

Business Objects/Android mobile application developer

Responsibilities:

• Coordinated with the Business Owners to outline Business Requirements.
• Worked with Business Systems Analyst to understand flow of data.
• Liasoned with the regional heads of Singapore, London and Taiwan to seamlessly connect all requirements and completed Technical Specifications Documents.
• We use to build a mobile solution that provides critical campaign operational data and campaign KPI's to the Channel Management, Retail and Care leaders. They will be able to view this data on their tablets and laptops
• Most of the campaign KPI data is already developed and presented in soft copy once a month to the business leaders. The Mobile solution will augment that reporting by providing the data more frequently with enhanced graphics & navigation capabilities - on the Android tablet.
• Implemented LDAP configuration of Business Objects to get Single-Sign On for the Business Users.
• Creating the Mobile reports Most of the campaign KPI data is already developed and presented in soft copy once a month to the business leaders. The Mobile solution will augment that reporting by providing the data more frequently with enhanced graphics & navigation capabilities - on the Android tablet
• The Mobile solution will augment that reporting by providing the data more frequently with enhanced graphics & navigation capabilities - on the Android tablet (IPAD’S) using Afaira and by Business Explorer (SUP) inter
• Involved in Analysis, Development, Testing, and Maintenance and problem resolution during implementation.
• Assigned security rights to groups and users Central Management Console using and then imported rights to other environments.
• Experienced in BICS layer building to access BEx queries.
• Designed, developed, deployed and maintained Universes Used Business Objects Designer Tool to Build Universes.
• Ensure Xcelsius dashboards worked on mobile I-Pads using Exxova (3rd Party Tool)
• Created different Categories in the repository and published full client reports corporate documents to their respective categories from data mart.
• Worked on migration from Xcelsius 3.0 to 3.5
• Expertise inanalysis, design, development and unit testing of software applications from user requirements and design documents.
• Successfully designed and developed Xcelsius/Crystal dash boards
• Worked on Business Objects integration with SAP BW
• Implemented Interactive Metric Trends Analytics according to end user requirements.
• As part of Universe development, created Classes, different kinds of objects, cardinalities, Strategies, resolving loops using Aliases and Contexts.
• Responsible for creating & managing Business Objects repository and coordinating/performing universe development. Exported the universes to the Repository to make resources available to the users.
• Extensively used Informatica transformations like router, aggregator, lookup, source qualifier, joiner, expression, aggregator and sequence generator transformations in extracting data in compliance with the business logic developed.
• Resolved high-priority tickets generated on production databases on a timely basis.

Environment: Business Objects XIR3/XIR2 HANA, Android, Afaria,SUP,Samsung Galaxy (CCM, CMC, Designer, Desktop intelligence, Web Intelligence, Rich Client, Info View, Import Wizard, Report conversion tool, Live office, Qaaws), Xcelsius 2008, Oracle 10g, Teradata 12, Quality Center, UNIX, and Windows 2003.

Confidential, Mclean, VA

Business Objects Consultant

Responsibilities:

• Gathered requirements from Business Managers and prepared Business Requirements Documents & Technical specification document out of it.
• Created new classes and objects in Universe Designer and made structural changes to the existing universe to include new objects by updating tables and joins. Also handled testing and debugging of Universes after enhancements and modifications were made.
• Resolved join problems such as Loops, Chasm and Fan traps by creating Aliases, Contexts and used the features available in the Designer to separate queries on measures.
• Responsible for BO reports upgrade from Version 6.5/XIR2 to XIR3.1 and HANA 4.0
• Generating Migration of Business Objects and reports content in to Business ObjectsR3.1 to HANA BI 4.0 environment
• Created and deployed WEBI Reports through Info View.
• Generated Custom LOV’s (List of Values) and Custom Hierarchies for drilling down Reports which allows the users to analyze the data.
• Created Master detail, Charts and Cross-tabs reports to view data in an analyzed way by using WebI and DeskI.
• Worked extensively with the major functionality of BO like Breaks, Ranks, Alerter, complex Calculations, and Filters, Sorts, query prompts, opendoc calls and cascading prompts.
• Created Users and moved those to Groups and set privileges on BO Enterprise Central Management Console.
• Published Reports on to BO Enterprise CMC and scheduled those as per the Business Requirements and set the distribution method.
• Developed a Windows application in order call the reports onto Windows form using Crystal Viewer.
• Extensively used Calculations, Break points, Drill down, Slice and Dice, Functions and Formulas, Filters &Alerters for creating Complex reports.
• Develop customer facing Dashboards/Reports using Xcelsius.
• Created and Customized Application Dashboards using Xcelsius to meet the requirements of higher level analysis and Maintained the consistency among the Xcelsius dashboards.
• Created Various Analytical, operational, what-if model dashboards using Qaaws and Live office.
• Created various Views and Stored procedures using PL/SQL for Crystal Reports.
• Used Performance optimization techniques while writing PL/SQL code.

Environment: Business Objects XIR3/XIR2 HANA (CCM, CMC, Designer, Desktop intelligence, Web Intelligence, Rich Client, Info View, Import Wizard, Report conversion tool, Live office, Qaaws), Xcelsius 2008, Oracle 10g, Teradata 12, Quality Center, UNIX, and Windows 2003.

Confidential, Tampa, FL

BO/Crystal Report Developer

Responsibilities:

• Gathered business requirements and performed detailed analysis.
• Gathered User requirements from end users.
• Created the reports using universes as the main data provider.
• Created Aliases and Contexts for Solving the Join problems in Business Objects.
• Use of BO Designer Module to implement Universes, linkages between tables, creating
• Prompts and queries, parsing the Universes, applying contexts and alias tables to Removecyclic Dependencies
• Worked with Business Objects Supervisor for creating repository, creating and managingthe universes, creating categories, creating and managing the users, giving accesspermissions for Business Objects Reports.
• Created charts to display summary of the data. Created User conditions and Filters to improvereport generation. Also used Alerts to improve the readability of the report.
• Used various join methods like Equi-join, Theta-join, Outer-join, when creating Universes.
• Created Classes, different kind of objects and cardinalities.
• Resolved the loops using Contexts and checked the Integrity of the Universes.
• Exported the Universes to Repository for making it available to users.
• Created hierarchies and predefined conditions using Business Objects.
• Extensively used Data Integrator to cleanse and populate target database
• Extensively used various techniques like Sectioning, Ranking, Filtering, Slice and Dice to developthe reports.
• Exported the reports in to PDF & Excel formats.
• Unit testing of the reports.
• Used Crystal Xcelsius to visualize and bridge the gap between data analysis to enhance the data Presentation.
• Extensively used Crystal Xcelsius to improve Dashboards and Scorecard presentation
• Reconstruction of Pre-Created Crystal Reports on Combined Profitability to Business ObjectsReports
• Designing and building of Universes, Classes and Objects based upon revenue, costsperformance and customer management systems.
• Resolution of loops, fan traps, chasm traps using contexts and aliases and its combinations,Checking of cardinalities, maintaining integrity of the Universes.
• Built Universes using Business Objects Designer.
• Created reports using Business Objects for business requirements.
• Created Reports showing the sales of various drugs in a particular Year, Quarter and Monthusing Business Objects.
• Designed the Universe by creating the Business Objects data model, selecting/joining tables, indicating cardinalities, created aliases to resolve the loops, used Aggregate function andCreated the objects which are grouped into classes based on Business Functionality.
• Created Reports using the Universe, Stored Procedures and Free Hand SQL as the Data providers.
• Created the reports using Business Objects functionalities like Drill Down, Cross tab, Master-Detail and Formulas etc.
• Formatted Reports as per the user requirements using extensively the functionalities in Business Objects, Used Slice and Dice, Drill Down, Filters, Conditions, Cross Tab, Master Detail and Formulas etc
• Developed Hierarchies to support drill down reports which allows the users to analyze the data.
• Involved in Importing/Exporting the Universes to repository to make available to the end user.
• Used Web Intelligence for web based query and reporting.
• Publishing reports using Info view and training users for ad hoc reporting.
• Implemented reporting using n-vision, Crystal Reports, Business Objects.
• Implementing security among the Business Object tools using CMC.

Environment: Business objects XIR2, Crystal Xcelsius 4.5, WebI, Info view, Designer, Data integrator, Report writer, Oracle10g/9i, SQL, and UNIX.

Confidential

Database Developer/ Report Developer

Responsibilities:

• Used Crystal Reports for designing of reports and multi grouping of data at report level as per client requirement.
• Displayed pie charts, bar graphs more understandable for top-level management using Analyzer in the reports.
• Deployed reports in Crystal Enterprise and setup of Scheduling, Publishing is done. Set up of Users, Groups, User Ids, Single sign-on, Report viewing privileges for Users are done in Crystal Enterprise.
• Extensively involved in using of formulas fields, parameter fields, Group selection, record selection, and Crystal syntax in Crystal reports.
• Displayed reports for users on web browser by e-launch pad, e-portfolio using Crystal Enterprise.
• Extensively involved in SQL coding creating complex queries, Views, Stored procedures, Functions to give better results at Crystal Reports.
• Creation of packages, procedures, functions and triggers to boost the application performance.
• Created stored functions to manipulate table values before fetching it to the reports using queries.

Environment: Crystal reports 9, Crystal Enterprise 9, Oracle 8i/9i, SQL Server 2000, SQL*Plus, Toad, MS Excel, ASP, HTML/DHTML, VBScript, IIS Server, Web component server, Windows 2000, UNIX.