SUMMARY

• 9 Plus years of Extensive experience in working with QRA/DSS tools and Business Intelligence (BI) Applications using Business Objects Product Suite.
• Experience in Designing Universes and development of reports both in Fat client as well as in Web Intelligence.
• Working experience with Business Objects modules such as Desktop Intelligence, Designer, Supervisor, Web Intelligence, Crystal Reports, and Broadcast Agent on UNIX and Windows platforms.
• Experience in working with universe created for Ad - hoc reporting as well as for canned reports. Also experience in creating reports using different sources such as universes, Free hand SQL personal data files and stored procedures.
• Manage SAP BW and R/3 systems for data extraction.
• Involved in Xcelsius Dashboards POCs at various clients, also created Xcelsius visualizations,
• Business Objects Mobile BI Dashboard Deployment to make informed decisions with instant access to personalized information. Receive alerts, investigate problems and take immediate action. Annotate and share insights. Ensure secure access to information on a wide range of devices. Create interactive, mobile reports and dashboards to design fast to deploy. Such as create standard Webi reports with bar chart, Line chart then save report to repository and assign to the 'Mobile' category, Also Creating Scorecards.
• Designed executive level dashboards using QlikView 9.x, 10.x.
• Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Good presentation, summarization, structuring and refinement skills. Proven track record of execution capabilities for strategic as well as tactical plans, both within and through functional boundaries.
• Worked as a QlikView Technical Consultant for a wide variety of business applications.
• Experience in complete project life cycle including documentation, analysis, and development and testing.
• Always worked in close association with customers and a single point of contact for many major implementation projects.
• Enthusiast and Experienced QlikView developer- the pioneered in-memory Dash boarding tool.
• Dashboards and complex analytics reports, used QaaWS and Live Office.
• Designed executive level dashboards using QlikView 9.x, 10.x.
• Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Good Knowledge of Data Modeling extensively worked with relational data models OLTP/OLAP data models, Dimensional Data Modeling i.e. Star schema (ROLAP) and snow flake schema.
• Worked with various databases (Oracle, SQL Server, MS Access databases, DB2 and flat files).
• Involved in release management and Complete Development life cycle of document from developing contents to moving them across multiple environments using Import wizard.
• Experience in using Data Integrator for ETL purpose using Business rules provided by clients.
• Involved in installation and deployment, upgrades, maintenance, clustering, and administrating the complete suite of SAP Business Objects tools in shared environment.
• Involved in Maintenance of repository, connections, Report Publishing, Scheduling, Monitoring, Users and Groups.
• Involved in migration from older versions to newer once using import wizard, also involved in report conversion using RCT from deski to webi.
• Excellent Analytic skills with the ability to recognize and translate business problems into technical solutions.
• Involved in Requirement gathering by directly interacting with the client and understanding business applications, business data flow and data relations.
• Involved in creating Business Requirement specification BRS documents as well as functional and technical specification documents for universe design and report development.
• Involved in User training, mentoring colleagues and coordinating with development teams.
• Strong verbal and written communication skills, also ability to work towards success of the project in fast paced tough environments.

TECHNICAL SKILLS

Tools: Business Objects 4.0, XI R3/R2/6.5 (Supervisor, Designer and Reporter), WEBI /DESKI /Rich client, Crystal Reports, Crystal Xcelsius, QlikView 9.x, 10.x, Live Office, Broadcast Agent Server (scheduler & publisher), Dashboard Manager, Business Objects 6.5 (Supervisor, Designer, Reports), WEBI 2.6/2.7/6.x/6.5, Auditor 6.5/XI R2.

PROFESSIONAL EXPERIENCE

Confidential, Albany-NY

Sr. SAP BI Analysts / Qlikview Consultant

Responsibilities:

• Designed and developed reports using Crystal Reports 2008 version.
• Created Crystal Reports using formulas, Grouping, Parameters, OLAP Expert, Cross Tab Expert, Selection criteria to handle the customer's requests from Tables, Stored Procedures, Views and Command Objects.
• Wrote several PL/SQL queries to query the database and use them as a command object for designing the reports.
• Designed and developed database calls using ODBC connectivity.
• Developed various charts and graphs like Bar chart (side-by-side, stacked), line graphs, Gantt Chart etc by using Chart Expert using Crystal Reports 2008.
• Design and implement of Xcelsius 2008 Dashboard with SAP BW/Bex Query and dimensional data connection by using ‘Query as a Web Service (QAAWS), and Live Office
• Designed executive level dashboards using QlikView 9.x, 10.x.
• Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Good presentation, summarization, structuring and refinement skills. Proven track record of execution capabilities for strategic as well as tactical plans, both within and through functional boundaries.
• Worked as a QlikView Technical Consultant for a wide variety of business applications.
• Experience in complete project life cycle including documentation, analysis, and development and testing.
• Always worked in close association with customers and a single point of contact for many major implementation projects.
• Enthusiast and Experienced QlikView developer- the pioneered in-memory Dash boarding tool.
• Understanding the requirements from the users. Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
• Providing executives and operational users with powerful analytic capabilities and detailed information on their operational and marketing performance.
• The Process was Agile and strict time line oriented. Worked closely with Project manager.
• Monthly distributed to specific user group via email, through publisher.
• Extracted data from multiple complex hierarchies from cross table flat files and websites.
• Created Heat map with alert mechanism. Various KPI graphs were drawn. Kept eye on Qlikview best practices.
• Worked with 32 core processor with 200GB RAM server, having daily refresh. 2-tier QVD architecture is implemented and the final application is taking 27 second to reload.
• The application is used by 20 CAL licensed user, with additional session licensed users.
• Document event trigger and field event triggers is created. Incremental reloading is implemented
• Created Document for the project planning and production Interface Documentation.
• Four dashboards were created, along with helping other team to create Qlikview reports.
• Successfully passed through the QA Environment and implemented on Production and currently working as post production support.
• Worked with QlikView 9.x, upgrade to 10.x,SQL Server, Oracle, Excel,
• Generated report for web-based query using Business Objects Enterprise 2008.
• Used Central Management Console for deploying and managing the reports.
• Responsible for giving user access and setting restrictions to view the reports.
• Worked with other users and the project manager to gather requirements.
• Worked on reports that contained up to 10 sub-reports (including drill-down sub reports). Handled both dependent and stand-alone sub reports.
• Extensively worked on reports that contained several parameters (static and dynamic cascade prompts).
• Set filters, suppression formulae and used highlighting expert to show the data the users would like to see in a more concise and presentable format.
• Communicated reporting changes, enhancements, and modifications, verbally or through written documentation, to management and other employees so that issues and solutions were understood.
• Worked with the testing team to implement and debug the application.
• Worked along with Senior Systems Engineer to ensure that the application program code meets the design specification.
• Wrote several SQL and PL/SQL queries on both Oracle 11g and SQL Server 2010 extensively.
• Created SQL commands, Views, Stored procedures and OLAP cubes as needed.
• Used BICS to connect to BW Queries with Crystal Report 2008 installing SAP integration kit.
• Using MDX Driver to connect directly to BW Cubes and Queries with Allow External use with BEx query utilizing drill down and charts for Analysing report for the client.
• SQL optimization to improve run time performance of reports using Materlize Views.
• Used Accela to understand the flow of data in the current application.
• Created Adhoc Reports using Accela Tool
• Created Specification Document to deliver it along with the reports.
• Used JIRA to log the status of each activity and design the Dashboard Inside in JIRA.

Environment: SAP Business Objects BI 4.0, XI3, Xir2, CMC, Information Design Tool, BI Launch Pad, Web Intelligence, SAP BOBI 4.0 Dashboard, QlikView 9.x, 10.x SAP Data Service4.0, SSIS, Data Stage7.0. Crystal Reports 2008, LCM, UMT, RCT, SAP BW/BexQuery, Windows 2000,2003,XP, Oracle 10G, SQL Server 2008, Accela,Tomat 6.Oracle 11g, DB2 UDB, Java,BW 7.3, Windows NT/2000, Microsoft.Net, IIS & JSP.

Confidential, Mt Laurel, NJ

SAP Crystal Report Admin/Developer

Responsibilities:

• Interacted with business analysts, data architects and application developer to develop a data model.
• Responsible for developing, support and maintenance BOE servers.
• Configured Crystal Report Server 2011 with SSO and used Upgrade Management tool to migrate reports from XiR2 to Crystal Report Server 2011.
• Migrated AD users in user/groups of Crystal Reports Server 2011.
• Used Crystal Report 2011 to develop reports for budget section by using Highlights experts, Select Expert, Record Select, subreports, static and dynamic parameters.
• Created and manage users in BOE XIR2, 4.0 servers and use import wizard and Upgrade Management Tool for migration.
• Use Visual Studio 2008 for integration of Crystal reports in web Application using Crystal Report viewer control with AJAX controls.
• Designed executive level dashboards using QlikView 10.x.
• Multiple tier of QVD architecture is implemented depending upon the complexity of the application and the final application reload duration was 4 Hours.
• Created stored procedures and views using Sql server 2005,2008.
• Used Informatica 9.1 to transform data from different sources to Sql server 2008 using Aggregator, connected and unconnected lookup,joiner,filter Transforms.
• Designed workflows with session and command tasks with sql override and parallel partitioning.
• Created data mart from Logical design to Physical design and defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.

Environment: SAP Business Objects 4.0,XI R2 (CMC, Designer) Web Intelligence XI R2 (Info view),MS SqlServer 2008,Informatica 9.1, MS Excel 2007,Visual Studio.Net 2010, Windows XP, Windows 2003 Server.

Confidential, San Antonio, TX

Business Object Developer

Responsibilities:

• Involvedin requirement gathering for Auto financial Claims project using JAD.
• Involved in requirement gathering and client managerial meetings.
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users.
• Involved in creating the RSM document for mapping the new system with old legacy system.
• Involved in implementing rules for different Level of Coverage’s on the base of LOB’s in database.
• Used SAP BW with Crystal Reports Connectivity using BICS and BEx Query to generate Financial Reports.
• Involved in Architecture design for Auto Financial Claims universe.
• Involved in creating row level security for various users and groups in universe designer.
• Developed the universes using the information design tool of BO 4.0 and published them.
• Created conformed dimensions in order to share the objects for the slice and dice controls in Loss level reports for each state.
• Involved in specify requirement for aggregate tables and write queries to generate table structure using Squirrel.
• Use Aggregate Awareness functionality to improve the performance and adjust the incompatible objects.
• Created information spaces by defining facets, measures and filters using BO Explorer 3.1.
• Created and manage alerts by subscribe to My Alerts and Emails in BI LaunchPad.
• Involved in requirement gathering for Auto financial Claims project.
• Designed Universes using IDT with Multi source data sources defined Connection
• Layer, Data Foundation Layer and Business Layer and Publish it.
• Used Upgrade Management tool to fully migrate objects from BIAR file to new system with Full Up gradation option from XI 3.1 to BO 4.0.
• Use prompts, blocks level filters and removed char level fields in reports for the better performance of the old property universe base long sheet reports.
• Created Ad-hoc reports using webi functionalities like Cross Tab, Master Detail, Slice & Dice and Drill Down for Loss, loss item, loss party, coverage, exposure, allocation and disbursement level
• Created and modified the WEBi reports for various P&C Auto Financial clients.
• Involved in redesign of P&C Underwriting reports and changes in universe using case statements to in designer to adjust all the LOB’s Coverage’s.
• Developed Dashboard for Auto Finance Claims in Xcelsius.
• Developed Corporate Dashboard in Infoview for ADS DATA MART.
• Created Mockup dashboard to give visual demo to executives in Auto Financial Claims Project for showing the comparison with legacy system.
• Use of Squirrel for creating queries for crosscheck against the infoviewSql.
• Defined Alias and context to solve the loop problem in ADS Data Mart Universe.
• Extensively used Inforamtica 8.6 by using transformations(Joiner,SourceQaulifer,Aggregate,Expression, connected and unconnected lookup) with sessions and workflows.
• Use Oracle, DB2 and Sql Server 2005, Sql Server 2008 as databases for connecting universes and creating ODBC connections.

Environment: Business Objects 4.0,XI 3.1 (CMC, Designer) Web Intelligence XI 3.1 (Info view), Business Objects XI 3.1, Live Office, QAAWS, Xcelsius 2008,Informatica 8.6, Oracle 10g, DB2,Squirrel,MS SqlServer 2008, MS Excel 2007, Windows XP, Windows 2003 Server.

Confidential, Birmingham, AL

BI Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the financial system for Business Objects Universes and Reports.
• Led a migration from Business Objects XI R2 to Business Objects XI R3 .
• Involved in design of architecture to support full-lifecycle development of universes and reports.
• Analyzed existing database and Designed Universe by using BO 4.0 Designer Module.
• Setup and initial configuration of XI R3 on Windows 2003 using Oracle as the repository database.
• Maintaining reconciliations to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
• Created the BW BEx queries and OLAP Universes on top of the BEx Queries and then generated reports in Web Intelligence.
• Understanding flow of clinical events in Cerner system(Firstnet,Surgnet and Lab data)
• Migration of content from the XI R2 system to XI R3 using the Import Wizard.
• Designed metrics Total Delay in ED, Total Surgery time, Total patient time admit to discharge etc.
• Conversion of Desktop Intelligence documents to Web Intelligence documents using the Report Conversion Tool.
• Integration of XI R3 with Windows Active Directory for authentication.
• Mapping of the XI R2 security requirements to the XI R3 security model.
• The migration team included me, a contractor specializing in Business Objects installation and configuration, and a consultant who performed the security mapping and Windows AD integration. We worked with the client's Windows administrators, database administrators, and a line-of-business manager for business requirements.
• Designed, developed and managed Universes in Business Objects Designer for generating the pay roll reports for sales, marketing reports for marketing group users.
• Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.
• Responsible for creation of various reports which includes weekly reports, bi-weekly reports, reports by Group, reports by Product and Sub-product.
• Created Ad-hoc reports using Business Objects functionalities like Cross Tab, Master Detail, Slice & Dice and Drill Down, etc.
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users.
• Defined Aliases and Contexts to resolve loops in the universes.
• Addressed Chasm trap and Fan Trap using Multi Parse SQL
• Created and worked on Row level security, Object level security using Designer and various predefined security settings depending upon users and group needs using CMC.
• Created several users and groups inside the CMC and implemented the access levels as per the best practices.
• Responsible for documentation of various stages in development including Design, debug, maintenance etc.
• Linked the Universes to share common objects. Updated and maintained Universes based on changing user requirements and data source changes.
• Developed Xcelsius presentations/visualizations for Lab Analysis of different Samples.
• Interactive visualizations were made for executives to visually evaluate different scenarios by adjusting key variables.
• Built multi variable what-if analysis bar charts for all information at one glance about all product lines of the company.
• Key player in improving the performance of the Business Objects reports.
• Involved in trouble shooting of various reporting errors.
• Created Business Objects reports, Queries with constant interaction with the end users. Trained end users in understanding the reports. Functionalities such as Slice and Dice, Drill mode and Ranking were used for Multidimensional Formatting.

Environment: Business Objects XI 3.1 (CMC, Designer) Web Intelligence XI 3.1 (Info view),Crystal Report, Cerner, Surgnet, Business Objects XI 3.1, Live Office, QAAWS, Xcelsius 2008, Oracle 10g, SQR, MS Excel 2007, Windows XP, Windows 2003 Server, Unix.

Confidential, NYC

Business Object & Crystal Report Developer

Responsibilities:

• Identified and road mapped the Business Requirements (functional & technical) with the Business users, which acted as a base for the project initiation and implementation.
• Gathered Customer requirements; analyzed and documented them.
• Created Data Flow Diagrams (DFD) to define the data element flow to the most granular level to translate data requirements to ETL processing.
• Created Transforms using SSIS to transfer data from Ms Access to Sqlserver 2008.
• Integrated with Business Intelligence ETL team to give out better performance.
• Extensively used Business Objects Designer to design and maintain Data warehouse Universe.
• Involved in migrating, testing and troubleshooting the Business Object XIR2 to XI3.1 content and environment
• Setup, execute, and test the assigned programs utilizing BO XI3.1 Webi and Deski tools.
• Worked on creating Universes using the Business Object Designer and connected to the database using ODBC. Resolved join problems, fan and chasm traps using aliases and contexts.
• Created Reports by Product, Reports by Customer, Reports by time Period (Quarterly, yearly, monthly, weekly comparisons).
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Developed ad-hoc and recurrent reports from a number of internal and external data sources like Oracle, MS ACCESS which has ODBC links from Data ware house.
• Developed various Charts and Graphs like Bar chart (Side By Side, Stacked), Line graphs, Pie Charts etc by using Chart expert of Reports.
• Have sound knowledge in Excel -- Created graphs using Pivot tables and written VB scripts for macros.
• Used Complex EXCEL formulae v lookup and H LOOKUP to generate complex Dashboards.
• Created Dashboards in Crystal Xcelsius 2008 using Charts, Selectors, Gauges, Maps, Arts and
• Background and Web Connectivity, used QaaWS, live office, and XML as a source to bring information.
• Created, refined and delivered functional test materials collaborated with test cases, set up test plans, schedules and scenarios.
• Used Business Objects Central Management Console in creating and managing the users, giving access permission for Business Objects Reports.
• Created parameterized and summary Crystal reports and tested them thoroughly.
• Customized existing reports for presentations using Cross-Tab reports. Developed sub-reports,
• Running Totals, Sorting, Alerting, used Crystal syntax to create formulas for the reports.
• Involved in the creation of Cross Tab Reports and Sub Reports using Crystal Reports with different data sources like Oracle and MS ACCESS.
• Developed reports implementing Dynamic & Cascading Parameter field feature in Crystal Reports 2008
• Recommended changes and updates on Views used by Crystal Reports, also trained users to use Crystal Reports 2008.
• Trained end users in Infoview. Explained different functionalities such as Slice and Dice, Prompt,
• Drill mode and Ranking were used for Multidimensional Formatting.
• Created user manuals for the end users on Webi Rich Client and Report Conversion Tool.
• Developed Release Notes and did POC’s for Xcelsius and live office.
• Responsible for Validating and testing the Design Considerations document with instructions.

Environment: Business Objects XI 3.1 (CMC, Designer) Web Intelligence XI 3.1 (Info view),Crystal Report, Business Objects XI 3.1, Live Office, QAAWS, Xcelsius 2008, Oracle 10g, SQR, MS Excel 2007, Windows XP, Windows 2003 Server.

Confidential, Syracuse, NY

BI Developer

Responsibilities:

• Involved in productions support of existing environment, resolved daily issues and tickets assigned.
• Transformed MS Excel spreadsheets into interactive data presentations and shared them via PowerPoint, Adobe Pdf and Infoview.
• Developed visualizations/Dashboards for upper management using Xcelsius 2008 using multiple data sources like QaaWS, Live Office and MS Excel displaying information for their finance department.
• Converted Priority 1 reports from desktop intelligence to web intelligence using Report conversion tool.
• Developed a universe using relational data model as per business requirement specification.
• Created Derived Tables, Classes, Objects, Dimensions, Measures, Details, Conditions, Joins.
• Resolved Loops using Aliases and Contexts, verified integrity of the universes.
• Used aggregate tables in universe to bring most frequently queried data for optimum query response. Applied aggregate navigation to aggregate tables.
• Worked extensively with @functions (@aggregate aware, @select, @prompt, @where) in the creation of dimensions, measures and conditions.
• Applied row level and column level Security at designer level to secure data based on the user profiles.
• Used Slice and Dice, Drill Down, Filters, Master Details, Cross-Tabs and developed Hierarchies to support drill down reports.
• Used Web Intelligence Rich Client to create webi reports locally using universes and excel files as a source.
• Used Profiles and Publication feature in XI 3.1 for Report Bursting.
• Involved in the user management activities, maintained users and groups, created and assigned proper access levels using Central Management Console.
• Creating and Modifying Info Cubes, Data store Objects, Info Objects, Data Transfer process using BEx queries.
• Established direct access connectivity using BICS SAP NetWeaver 7 BW.
• Used Data Services to perform ETL tasks by using flat files as a source, applying Query transforms and populating the destination tables based on business rules.
• Scheduled the reports to be emailed to end users as per schedule in PDF and XLS formats from Info view.
• Trained the users in viewing/scheduling the reports and creating Ad - hoc reports using the Info view.
• Trained users on Xcelsius 2008 and mentored them in creating basic dashboard.
• Created training manuals for users for Infoview, CMC and Xcelsius.

Environment: Business Objects XI 3.1 (CMC, Designer) Web Intelligence XI 3.1 (Info view), Business Objects XI 3.1, Live Office, QAAWS, Xcelsius 2008,BW, Oracle 10g, SQR, MS Excel 2007, Windows XP, Windows 2003 Server.

Confidential, Miami, FL

Senior Business Objects Consultant

Responsibilities:

• Gathered Business requirements from Business Users and prepared BRS, functional specification and technical specification documents.
• Configured and managed Business Objects Enterprise XIR2 servers and security setup.
• Installed Business Objects XI R2 on Windows 2003 Server, configured IIS settings.
• Used Import Wizard to move contents i.e. Universes and reports, from Dev to QA and then to
• Production, managed the release management of the documents.
• Supported the existing environment by maintaining universes and reports using ROLAP data model (star schema) as per the requirements.
• Created nested Derived Tables to bring complex result set for specific queries based on client’s requirements.
• Created Classes, Objects, Conditions and multiple hierarchies to give the reports drill across functionality.
• Created reports in Deski by using free hand SQL as a source.
• Resolved Loops using Aliases and Contexts, resolved errors after the integrity check in the universe.
• Used @functions (@aggregate aware, @select, @prompt, @where) in the creation of dimensions, measures and conditions.
• Used aggregate navigation to select data from multiple tables dynamically.
• Implemented row level, column level security to restrict the data for different users and user groups, also used connection overload functionality to dynamically switch universe connection based on the user’s logins.
• Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create the reports.
• Used Web Intelligence for web based query and reporting.
• Developed Dashboards for top management using Crystal Xcelsius and published them to Infoview.
• Created Profiles and Publication, used profile for report bursting in Business Objects XI R2.
• Scheduled the reports to be emailed to end users daily in PDF and XLS formats from Info view.
• Created users, user groups, folders and sub-folders and assigned proper access levels to them using Central Management Console.
• Worked with dimensional modelers to redesign dimensional model of an existing data mart by creating snowflake.
• Trained the users on Infoview and Live Office, mentored them to create ad - hoc reports in Infoview, and also trained users to schedule the reports using the Info view.
• Created user training documents to use for Central Management Console and Import Wizard.

Environment: Business Objects XI R2 (CMC, Designer, DeskI), Web Intelligence (Info view), Hibernate, Oracle 10g, SQL Server 2008, MS Excel 2007, Windows XP, Windows 2003 Server.

Confidential, Cooperstown, NY

BI Developer

Responsibilities:

• Interacted with Business Users to understand requirement details based on project scope to develop Universes and Reports accordingly.
• Created complex business reports using custom formulas, context operators (Foreach, Forall)
• Merge dimension, combined queries and sub - queries.
• Created universe on top of data marts using star schema data model.
• Designed and Built the Universes, Classes and Objects in Business Objects XI R2.
• Involved in enhancing and converting few of excel macro reports to Crystal reports.
• Created dashboards for analyzing statistical finance data using Xcelsius.
• Exported the universes to the Repository to share the resources among the users
• Created different types of reports such as Master/Detail, Cross Tab and Charts in Desktop
• Intelligence and Webi.
• Used conditional formatting for various reports in Crystal Reports and used Parameters, Graphics, Charts and other features in Crystal Reports.
• Written Free Hand SQL to write reports using FHSQL as a source and optimized queries written in derived tables.
• Designed and developed different type of Crystal Reports, Created Cross Tab, and Top N Reports for highlighting significant data, sub reports with drill-down capabilities.
• Documented test cases and test scripts along with technical specifications.

Environment: SQL Server 2005, SSRS, Business Objects XI R2, Xcelsius 2008, Crystal Reports XI, Web Intelligence, Info view, XML, HTML, Oracle 9i/10g, PL/SQL, HP Service Center, UNIX and Windows 2003.

Confidential, Colorado Springs, CO

Business Objects Consultant

Responsibilities:

• Installed, deployed and configured Business Objects Enterprise on Windows NT server.
• Tested and deployed universes and documents across testing/production repositories
• Setup and administer the Broadcast Agent. Worked with BCA to schedule reports on monthly and weekly basis.
• Row level security is implemented in the supervisor to restrict the data to the respective divisions.
• Resolved Chasm Traps and Fan Traps using multiple SQL statement option and Alias and Context.
• Created different types of reports like Cross Tab, Charts and Master Detail using multi data sources.
• Created complex reports using Business Objects functionality like Slice and Dice, Drill Down, Drill
• Up and Ranking were used in reports.
• Used Aggregate awareness functions of Business Objects to smartly select the columns coming from multiple aggregate tables.
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, slice and dice, Master/Detail, Cross Tab, Charts and alerts for creating Business Objects Reports.
• Used Slice and Dice, Drill Down, Filters, Master Details, Cross-Tabs and developed Hierarchies to support drill down reports.

Environment: Business Objects 6.5/XI R2 (Designer, supervisor, Full Client), Crystal Reports 9.0, SQL Server 2005, Windows NT, UNIX

Confidential, Houston, TX

Business Objects Developer

Responsibilities:

• Analyzed the existing data warehouse and implemented changes to design, develop reports in the new format as per escalating user requirement.
• Involved in understanding the end-user requirements and business processes in creating new reports.
• Wrote technical and functional documentation for new universe and reports.
• Build universes, reports to keep track of the metrics on the Business Objects usage scheduled job statistics for the management.
• Involved in designing and developing universes for report generation from different databases (SQL Server, MySQL, and Oracle).
• Worked with Data Analyst in developing Universes based on data model, and reporting requirements.
• Weekly, and Monthly, reports were created based on Forecasting and actuals data in
• Business Objects Client. Modified the existing reports with additional functionalities.
• Generated reports involving numerous prompts and linking several data providers and automated them.
• Validated the data and the joins in the Universe by running BO reports and exporting the output to the Excel Spreadsheets and again testing it against the data that was fetched from backend tables.
• Documented test cases for reports and universes.

Environment: SQL Server 2005, MySQL 5.1, Oracle 9i/10g, HP Service Center, Business Objects XI R2/ 6.5, Crystal Reports X, XCelsius, Data Federator, DB2 8.0, Java Script 1.5, PL/SQL, Business Objects XIR2, WEBI, Designer, HTML, XML, Windows 2003, UNIX.

Confidential, Seattle, WA

Business Objects Developer

Responsibilities:

• Involved in the creation of report templates to be used as the standard throughout the department.
• Created multiple hierarchies to drill across different dimensions, used drill through and drill across options in the reports.
• Developed embedded SQL Queries for the Reports and developed SQL Queries using the PS Query tool.
• Created Universe on finance data mart and created financial reports involving multiple data-providers.
• Created drill down reports up to 3 levels of drilling data using BO.
• Integrated and upgraded existing reports with added functionalities for comparison and cost-time trend analysis.
• Created complex reports involving Master/detail and cross-tab; combined queries and sub-queries and linked multiple data-providers.
• Designed complex schemas using various @functions like @prompt and @Aggregate Aware.

Environment: Business Objects 6.5, Oracle 9i/10g, MS SQL Server 2005/2000, PL/SQL, SQL Navigator, XML, HTML, Microsoft suite 2003, UNIX.

Confidential, Boyertown, NY

Business Objects Reports Developer

Responsibilities:

• Involved in Full development life cycle of the project from understanding the scope to deploying the universes for standard reporting and ad-hoc reporting requirements.
• Resolved loops using alias and contexts in the universes.
• Modifying the existing universes, adding new objects, editing joins and mapping the existing objects with renamed tables.
• Worked with different universes and used linking of different universes using Designer.
• Worked with Distributing, Importing, Exporting and deploying of universes using WEB Intelligence.
• Implemented different level of hierarchies for drill down reports.
• Involved in Writing Detailed Level Documentation for reports and Universe design.
• Involved in developing both static and dynamic reports.
• Controlling Reports data by working with Universe and queries. Using Filters, Sorts and Rankings.
• Used various @Functions, Created customized functions/hierarchies for reports.
• Created several complexes-cross tab reports using Business Objects FatClient.
• Involved in resolving issues relating to pre implementation of Reports.

Environment: SQL Server 2000, Oracle 9i/8i, Business Objects 6.5 (Designer, Reporter, Web Intelligence), Crystal Reports 10, XML, Windows 2000, Java Script, PL/SQL.

Confidential, Charlotte, NC

Developer/SQL Server

Responsibilities:

• Installation of SQL 2000 and its upgrades.
• Design the logical and physical database structures based on business requirements.
• Creation of database and their table spaces. Defining the backup strategies for the oracle databases based on business requirements. Database upgrades/migrations.
• Recovery of database whenever required. Hot & cold backups of SQL. Monitoring and tuning the databases
• Troubleshooting of Database related problems. Export/Import SQL Net configurations.
• Providing connectivity to client’s databases. Data Transfer from legacy system to SQL Database using SQL*Loader.

Environment: SQL Server 2000, MS Excel, Word Perfect, Windows, and UNIX.