RPC Group | Resume

Ryan P. Casey

Phone: (817) 832-1794
Fax: (972) 956-0595
rpcasey@r-p-c-group.com.com
RPC Group
2704 Ponderosa Pine Drive
Flower Mound, TX 75028
United States

Data Warehouse Manager / Business Intelligence Architect

Objective

Obtain a permanent position that challenges my twelve years of experience in information technology (IT) including, management, project management, lead, and senior roles. A future role would offer management growth to complement my MBA program work combined with the functional application of my areas of focus as a subject matter expert. These areas of focus include data warehouses and data marts using the Kimball methodology as well as implementing database management (DBA) best practices. Data warehouse /data mart architecture includes designing extract, transform, and load (ETL) processes, scripts and packages, enterprise reporting, ad-hoc analysis, OLAP analytics, business intelligence, and functional and technical specification through a development life cycle such as plan, architect, design, prototype, develop, test, implement, and maintain.

5 years Visual Studio (BI Studio, ASP.Net, C#, VB.Net)
5 years SQL Server / Oracle
4 years SSRS, SSIS, SSAS
3 years SharePoint Server
1 year Performance Point Server

Experience

8/2009 – Current
BravoTECH (T-System), Dallas, TX
Chief Business Intelligence Architect / Developer / Administrator

Chief architect responsible for planning, architecting, designing, and implementing a reporting architecture (T-Reporting) using T-SQL, SSRS and SSIS for a global emergency department information system software package called T-SystemEV.
Architected and implemented a custom deployment for T-Reporting using Powershell, Reporting Services Script (RSS), XML configuration files, SQL Management Objects (SMO), and Windows Management Instrumentation (WMI).
Planned and implemented a Continuous Integration (CI) Server using Cruise Control .Net, Subversion, Powershell, MS Build, DTEXEC, CMD, and SQLCMD.
Prototyped a custom SSRS Portal using ASP.Net, C#, and Internet Information Services (IIS). The portal included technologies such as the Microsoft AJAX Framework (AJAX), the Reporting Services Control, as well as numerous custom controls to handle parameter input, user accessibility, and wizard like functionality.
Developed a Visual Studio 2008 C# custom SSIS data flow transformation called Report Exporter. This custom data flow transformation synchronously took a data flow input and exported reports based on fields in the data flow such as webServiceURL, reportName, reportPath, destinationReportName, destinationReportPath, and parameters.
Designed a SSIS transformation script component that synchronously took the destinationReportPath data flow input and determined if the path existed. If the path did not exist, the path was created for the Report Exporter.
Created a SSIS source transformation script component that dynamically generated the source data flow for the Report Exporter custom data flow transformation from multiple SQL Server tables and XML files.
Designed a Visual Studio 2008 C# class Excel Format that dynamically formatted excel reports that were exported by Report Exporter. Formatting including turning on gridlines, setting page layout view, and renaming sheet label names.
Implemented custom T-Reporting SSRS Report Manager branding using Reporting Services CSS and HTML Viewer CSS.
Included custom watermarks in both SSRS Report Manager and RDL report files created in Visual Studio.
Developed and Implemented a SSRS centralized, dynamic style library (style sheets) that functioned similar to CSS by creating a custom Visual Studio 2008 C# assembly called report styles.
Mentored report writers on the benefits of style sheets and how to incorporate the report styles custom assembly. Also how to decide when to use a temp (#) table, inline view, view, table variable, and a common table expression (CTE).

4/2009 – 7/2009
Elan Partners (Beal Bank), Addison, TX
Senior Microsoft Business Intelligence Silver Partner Architect / Developer / Administrator

Senior architect responsible for planning, architecting, designing, and implementing a loan and a bond data mart using SQL Server 2008 Enterprise on a 64-bit server environment combined with a SSRS 2008 Scale-Out Deployment.
Planned, architected, designed, and implemented Enterprise Reporting using SQL Server Reporting Services 2008 (SSRS 2008). Implemented system, folder, report, and row level security. Row level security was provided by including an authorization table/dimension to filter by region and department based on the user’s identification number.
Developed a Visual Studio 2008 C# class called Report Helper that accessed the SSRS 2008 web services to programmatically complete tasks such as update a report snap shot for event driven subscriptions. Report helper included partial stored procedure classes that, through the common library runtime (CLR) could be used to in a T-SQL stored procedure or, SSIS Package. An example of this use is to start reconcile reports when an ETL process completes and notify the appropriate stake holders that the ETL process has finished allowing them the opportunity to review the reconcile reports.
Planned, architected, designed, and implemented ETL process using SQL Server Integration Services 2008 (SSIS 2008) packages and T-SQL stored procedures, tables, views, synonyms, and functions. ETL Process designed to take advantage of parallelism, use surrogate keys, account for slowly changing dimensions (T-SQL 2008 Merge and Lookup Transformation), adhere to conformed dimensions, utilize custom error data flows, and incorporate delta loads.
Modeled and developed MOLAP loan and bond cubes using SQL Server Analysis Services 2008 (SSAS 2008). The star schema created from the ETL process was used to build and deploy five dimensions including time and 3 fact tables of unique grain. Created a data source view, hierarchies, attributes, measures, calculations, KPIs, and actions.
Clients accessed cube data using excel pivot tables, reporting services, and ProClarity.
Developed and designed three versions of Board Reports for Executive and Compliance reporting. The version of the board report displayed was determined by the authorization table based on the user and their appropriate region and department.
Developed and designed twenty (20) reconcile reports that compared the loaded data to the source data by month end date, portfolio, reporting type, balances, delinquencies, servicer, and investor.
Implemented and distributed Report Builder 2.0 for Ad Hoc reporting to numerous power users.

1/2008 – 2/2009
Robert Half International (NYSE: RHI), Dallas, TX
Microsoft Business Intelligence Gold Partner Consultant

Torchmark (NYSE: TMKPRA) - Client

Senior DBA tasked to help design and implement version 2.0 of a recruit and leads management system for a large insurance company. Project included user interface back-end, T-SQL and SSIS data feeds, error and exception handling, email notification, and job scheduling.
Designed data marts for reporting that included SSIS data feeds and transformation, as well as reporting services reports to support scheduled and ad-hoc requirements.
Developed VB scripts to rename and zip files for EDI using FTP.
Created VB.Net executables that monitored exchange server inboxes and produced reply emails and updated comments in the recruit and leads database.

Source Corp - Client

Architect tasked to evaluate the current business intelligence implementation processing the state of Kentucky corporate tax returns, suggest design changes based on industry standards such as the Kimball Method, and lead the project management and development of the accepted design changes.
Created ETL process using SQL Server Integration Services (SSIS) packages and T-SQL stored procedures, tables, views, synonyms, and functions. ETL Process designed to take advantage of parallelism, use surrogate keys, account for slowly changing dimensions, adhere to conformed dimensions, utilize custom error data flows, and incorporate delta loads.
Modeled and developed MOLAP cube using SQL Server Analysis Services (SSAS). The star schema created from the ETL process was used to build and deploy five dimensions including time and five fact tables of unique grain. Created a data source view, hierarchies, attributes, measures, calculations, KPIs, actions, partitions, perspectives and translations.
Clients accessed cube data using excel pivot tables, reporting services, and ProClarity.
Evaluated server sizing requirements, possible use of SharePoint Services, and Performance Point dashboards.
Professional Microsoft Training for Performance Point Server (Monitoring / Analytics / Planning / Dashboards / ProClarity).

5/2007 – 1/2008
Neiman Marcus Group, Irving, TX
Senior Business Objects Developer / Administrator

Senior developer responsible for implementing auditing for merchant reporting. Assignment included designing 6 additional tables to provide increased functionality to the “out of the box” Business Objects Auditor XIr2 schema. These tables provided report grouping and user grouping functionality as well as table maintenance for these groups.
Developed 9 custom XIr2 Usage Reports based on the auditing infrastructure including “Most Active Users,” “Users Not Logging In,” “Most Accessed Documents,” “All Reports Accessed by Reporting Group,” and “Merchant Reports by Day of the Week.” All reports used a month/Year, or day/Month/Year parameter. Parameters refreshed and updated automatically. Many reports used rankings to select the top or least records in a row set.
Modified and created numerous XIr2 Universes that supported Merchant Reporting and Usage Reports. Universes included list of values, parameters, contexts, aliases, hierarchies, filters, classes, objects, dimensions, measures, and details. Used Business Objects Designer XIr2.
Planned and implemented a XIr2 security model that included folder and object based security as well as delegated administrator rights. The security model included custom groups including merchants, UAT, developers, and auditors. Different administrator policies were created for development, test, and production.
Planned and implemented a backup and recovery policy that used Business Objects XIr2 BIAR files to backup and restore the Business Objects environment for both production disaster recovery and development synchronization.
Maintained custom navigation tables and XML output used for populating custom navigation in Apache Tomcat environment. Setup virtual directories in Apache Tomcat.
Maintained Oracle procedures, packages, tables, views, and materialized views. Worked with SQL Loader, UNIX Scripts, and OPC Scripts. Used SQL Developer and Toad.
Professional Oracle Training including PL/SQL Fundamentals and Programming PL/SQL.

2/2007 – 4/2007
M1 Support Services, Denton, TX
Business Intelligence / SharePoint Services Developer

Project Manager for a SharePoint Services 3.0 collaboration portal using the .Net Framework 2.0, ASP.Net with C# code behind, and SQL Server 2005 for a contractor with the United States Air Force.
Provided dashboard business intelligence by using Crystal Xcelsius for Workgroups web part for three fleets of aircraft at Holloman, Whiteman, and Beale Air Force bases.
Created page integrated forms authentication delivered using a Secure Sockets Layer (SSL).
Implemented an extended site to provide Windows authentication on a different port.
Configured groups, users, and permissions to provide individualized access to site content.
ASP.Net web pages used master pages, CSS, site map, web configuration, and web server controls as well as included libraries, lists, workflows, surveys, announcements, calendars, tasks, project tasks, links, issue tracking, discussion board, custom lists, custom lists in a data sheet view, and contacts.
Delivered the project early including scheduled presentations, training, and documentation.

11/2006 – 01/2007
Resulte’ Universal (FedEx Kinkos, NYSE: FDX), Dallas, TX
Business Intelligence / Business Objects Developer

Senior Business Objects developer on a team responsible for creating, maintaining, and migrating over 250 reports, 45 universes, and three different Business Objects versions in multiple environments.
Reports and Universes were built using Business Objects XI-R2, Business Objects 6.5, and Business Objects 6.1b in order to support numerous business needs for activities such as Shipping Activity, Workforce Management, Compass Reporting, Transfer Pricing (SAS Activity-Based Management), Auditing, and Monthly Volume.
Complex Universes techniques used included loop detection, prompts, conditions, classes, objects, dimensions, measures, details, joins, cardinality, keys, data integrity, list of values, aliases, derived tables, multiple contexts, and hierarchies.
Senior Business Objects developer assigned to support the reporting needs of SAS Activity-Based Management by designing the data model, working with the ETL team, building a universe, and creating numerous cost based analysis reports.
Business Objects tools used included Designer, Full Client, InfoView, ZABO, Broadcast Agent/Administrator, Supervisor, Administration Console, Configuration Tool, Business View Manager, Desktop Intelligence/Web Intelligence (WEBI), OLAP Reporting, Oracle 9.2i, SQL Analyzer, Trace Data Viewer, Tuning Expert, SQL Plus, ERWin, and Toad.
Included in the support of the installation, configuration, upgrade, performance tuning, load balancing, capacity planning, and troubleshooting of the migration of Business Objects 6.1b, to Business Objects 6.5, and to Business Objects XI-R2.
Ran and archived monthly audit reports that contained 5 million rows of company critical audit data.
Attended weekly status meetings covering on going projects, mile stones, deadlines, and issues. Project mile stones and progress was monitored using Microsoft Project while issues were tracked in an issues log maintained by the entire team.
Responsible for documenting reporting requirements, functional and technical specifications, test plans, and user guides.

08/2006 – 11/2006
Comsys (Mosaic) , Addison, TX
Business Intelligence / Sr. Report Writer / Manager

Hands-on manager accountable for the successful delivery of business intelligence projects for clients such as Microsoft, Kodak, Best Buy, Wal-Mart, and Buena Vista Home Entertainment. Managed all aspects of report delivery including requirements gathering, report development and report delivery.
Built reports utilizing Business Objects XI-R2, Crystal Reports, List of Values (LOV), Dynamic Cascading Parameters (DCP), Business Views, Desktop Intelligence/Web Intelligence (WEBI) reports, Universes, OLAP reports, Live Office, and Share Point portals to assist team in meeting deadlines and go-lives.
Responsible for the creation and maintenance of all Universes to support WEBI reporting and responsible for 30% of creation and maintenance of Business Views.
Responsible for testing and delivering Live Office to the Business Team. Interfaced with end users and management extensively to gather business requirements and take reporting process through the system development life cycle.
Write and utilize SQL generated by the tools daily to test reports and improve report quality and performance.
Determined to what level human resources of a six person report writing team were assigned to daily activities of each project depending upon risk, complexity, or significance to the business. Assisted the director in managing project scopes, timelines and budgets. Assisted the director in staffing the report writing team.
Planned, tracked, controlled and communicated activities at a higher level across all assigned projects to customers and upper management. Provided regular status reports and presented project summaries to customers and upper management.
Maintained an in-depth understanding of business intelligence principles and current industry best practices. Assisted in research and development on new business intelligence tools and techniques such as Crystal Reports, List of Values (LOV), Dynamic Cascading Parameters (DCP), Business Views, Web Intelligence (WEBI) reports, Universes, OLAP reports, Live Office, and Share Point portals.
Mentored team members, and the customers on BI Methodology and practices. Responsible for associate performance management as well as understands associates career development goals and provided the work opportunities required for them to accomplish those goals. Ensured the roles and expectations of direct reports were clearly defined.

01/2006 - 07/2006
Primus Global Services, Inc. (CitiGroup, NYSE: C)
Irving, TX
Business Intelligence Consultant

Lead consultant hired to implement a Crystal Enterprise 9 High Availability Production and Disaster Recovery (Continuity of Business - COB) Environment.

Acquired two new servers that were built identical to accommodate the necessary requirements to ensure a high availability production/COB environment.
Servers used identical service credentials, either local or domain accounts. Since these servers used email (SMTP), accessed unmanaged disk space, and used a data source to connect to Microsoft Access or Excel, a domain account was used. All data sources on both servers were named the same and used the same user accounts with read only access. The file repository server (FRS) was located in the same file structure location on both servers. These locations are literal locations; so changing from C:\ to D:\ would result in the loss of links to historical instances stored in the web application (eProtfilio). Both servers had SQL Server 2000 installed and client tools were available to developers. Also, Crystal Reports 9 was installed on both servers for trouble shooting purposes. Finally, all custom COM objects and CSP code were maintained identically on both servers.
After these new servers were built, configured to the specifications described above, and toughly tested, these new servers replaced the current server in production. The data in the current production database was backed up and restored to the new servers. Also, the historical reports stored in the FRS were achieved for future reference.
This plan assured that current reports were not lost, current production and auditing reporting continued uninterrupted, and that there was a minimal business user impact.
Replication of the database data and files stored in the FRS, was accomplished using SQL Server 2000. DTS packages and jobs were created in order to maintain and manage replication effectively.

6/2005 - 10/2005
Sense Corp (Cooper Industries, NYSE: CBE)
St. Louis, MO
Technical Analyst

Project manager responsible for an incentive reporting cube for a fortune 50 company with an information technology budget of greater than a billion dollars.

Design SAP BW info providers and info objects such as cubes, multi-providers, info sets, operational data stores, characteristics (master data, texts, and hierarchies), and key figures.
Create info sources in order to load data into info objects and info providers by creating update rules, info sources, and transfer rules. Data can be loaded from pre-defined source systems such as business content, Oracle, SQL Server, or flat files.
Utilize persistent storage areas in order to verify and test all data loaded into info providers and info objects.
Designed an ASP.Net web interface that accessed and maintained SAP BW master data for incentive reporting. SQL stored procedures were used to process data requests and changes made through the web interface. Due to licensing, Microsoft Web Matrix was used to code and debug the web interface.
Develop queries that can be used to analyze sales dollars over many years. Reporting includes budget to actual, current month to previous month, current year to previous year, variance, and exception reporting. Many reports require customer exit variables that are written in ABAP in order to provide specialized features. Complex reporting combines the power of SAP BW with Business Objects (Crystal Reports, OLAP Reporting).
Integrate reporting to the web portal by using web templates that display queries in an HTML format that includes objects such as tables, charts, navigation bars, tickers, radio buttons, and text elements.
Integrate browser based printing with custom print sheets that utilize style sheets (.CSS) and Microsoft Excel printing features such as pushbutton printing, company logo, page orientation, fit to page, and repeating rows and columns.
Increase reporting performance by using query traces and pre-calculations.
Create transports and transport requests in order to migrate to and from sandbox, development, quality assurance, and production.
Add reports that are in production to the web portal.
Develop web interfaces that allow business users to select, update, insert, and delete master data needed for reporting.

5/2004 - 5/2005
DR Horton Homes (NYSE: DHI)
Fort Worth, Texas
Crystal Enterprise Administrator, Lead Crystal Report Developer

Lead developer responsible for implementing DR Horton’s (DHI) first enterprise class business intelligence environment using Crystal Enterprise 10 and Crystal Reports 10. With over 1,000 named user licenses, business views, processing extensions, and custom functions were heavily implemented in order to provide row level security while empowering regional and divisional report creation that could easily be distributed to all regions and divisions without modifying reports or creating multiple report versions.
The environment included two Crystal Enterprise quad-servers; a production and development server that used active directory authentication in a single sign-on mode. In order to increase user accessibility, the Microsoft Share Pointe server plug-in was installed allowing report viewing and scheduling through the corporate intranet portal.
Custom applications that were intended to be used corporate wide were developed with integrated reporting using C# .Net and Visual Basic .Net according to the push model of report design. This included creating XML files to define the data connection as well as creating custom web services in order to support reporting needs.
Company standards, styles, and templates were created in order to help users create reports that had a consistent look and feel throughout the enterprise. Documentation, tutorials, and webX sessions were created in order to help train users and increase end user knowledge of the environment.
APOS dynamic parameters were used to improve parameter functionality by including query driven pick lists, cascading parameters, and hidden parameters such as the current crystal enterprise user.
Current development includes a third prototype server running Business Objects Enterprise XI and Crystal Reports XI.
Professional training included business view training from Business Objects and attending the Microsoft Security Summit held in Dallas, TX.
Internal training included AS/400 training using JD Edwards and Lloyds applications.

4/2003 - 4/2004
Assisted Living Concepts (Extendicare, NYSE: EXE)
Dallas, TX
SQL Server / Crystal Reports Developer

Project lead for all migrations between Crystal Reports 8.5, 9, and 10 Enterprise. Enterprise web based reporting and Seagate Info 7.5 where used for report scheduling and distribution. Reporting environment supported point in time reporting by using actual and historical tables with triggers that automatically updated and inserted rows of data in order to track changes at any given date and time. All reports were developed using stored procedures that included scope (leaf level, regional, divisional, and total company) parameters, level (granularity) parameters, and custom parameters.
Implemented Comshare's corporate performance management system (CPM). $300,000.00 dollar budget and a potential corporate wide savings of over $2,000,000.00 dollars. Projects included installing, partitioning, and creating namespaces, databases, and security for SQL Server 2000. Customized ASP code in order to integrate Comshare with Crystal Reports by using Comshare's SDK, javascript, and vb script. Modified ASP code in order to personalize Comshare to match the current company web applications styles, form, and functionality. Used Project 2000 to create Gantt charts, determine critical paths, identify milestones, clarify requirements, and allocate resources.
Project lead in the implementation of a collaborative system with direct supply systems (DSSi). Provided a centralized, consolidated web interfacing vendor ordering system that seamlessly integrated with all accounting databases and business processes. Included ftp file transfers, direct general ledger feeds, invoice remittance information provided to DSSi and the vendor, invoice controls, and management approval. Project planning and management utilized Project 2000 and Project Central as an integral solution to a collaborative, project management environment.

11/2002 - 4/2003
Payroll America, Inc.
Boise, Idaho
Payroll Reports Analyst

Created reports with Crystal Reports 9 and 8.5 Enterprise. Custom reports were generated for accounting (actual to budget revenue), benefits (401k eligibility), information technology (help desk open ticket count), payroll (401k by period/year to date), human resources (disciplinary lists), quality assurance (complaint summary), workers compensation (workers compensation costs year to date), sales (referral source) and all other organizational divisions.
Web development included designing a new look and feel for the internet web site using ASP along with Macromedia Flash, Home Site, and Fireworks. Migrated ASP applications to ASP.Net and the .Net platform. Used Project 2000 to plan and manage all web development.
Application development included documenting and testing ESS (employee self service) an ASP and ASP.Net application using ADO.Net and Active Directory that allowed payroll clients to access personal payroll and human resource information through a web browser. Used Project 2000 to plan and manage the application.
Professional training included FPC (fundamental payroll certificate), Crystal Reports - Level 2 from New Horizons Learning Centers, and DevApps .Net training.

4/1999 - 5/2002
Micron Technology, Inc. (NYSE: MU) and Micron Custom Manufacturing Services (MCMS)
Boise, Idaho
Programmer / PC Technician

At Micron Technology, Inc. (4/2001 - 5/2002)

Responsible for daily development and maintenance of the corporate information technology intranet.
Created Crystal Reports in order to implement various reporting capabilities into application and web based development.
Developed a web-based project tracking and reporting application using ASP and SYBASE that included project status, team-member updates, and productivity reporting. Required Crystal Reports in order to implement various reporting capabilities into the project.
Designed an ASP application that created emails from a web form and distributed form information to a Clear Quest email reader for tracking application errors and new feature requests.
Updated Micron's API DLL library from ASCII to Unicode compatibility using C++.
Professional training included Rational Suite, ASP, Cold Fusion, UNIX, C/C++, Documentum, and the Rational Unified Process.

At MCMS (Manpower Technical 1/2001 - 4/1999)

Accountable for network functionality and upgrade for a large integrated circuit manufacturer using Windows NT 4.0 server and client, SQL Server, Crystal Reports, Transaction Server, Exchange Server, and UNIX.
Created Crystal Reports in order to report on Help Desk and PC Tech tickets, queue times, and business user ticket status.
Technical services were conducted on production floors, in server and communication rooms, in clean rooms, and in office buildings.
A special job responsibility required organization between the corporate safety department and a software vendor. The software provided hazardous materials management tools, which adhere to the environmental protection agency’s regulations, and claim management tools for tracking corporate workers compensation and safety.
Network resources were provided for multimedia training in multiple training rooms. Training room computers required network connectivity and authentication, web access from the proxy server, and the installation of proprietary software. The training rooms required audio and visual aids including digital overhead projection, presentation/instructor audio, and wireless input devices.
Professional training included A+ training, hazardous materials, and workers compensation.

9/1998 - 11/1998
Volt Technical, NYSE: VOL (Albertsons, Inc., NYSE: ABS)
Boise, Idaho
UNIX Systems Operator

Provided remote systems support for a wide area network that supported grocery store point of sale registers, local area networks, and wireless inventory handheld devices.
Tasks included fixing MAC address tables, manipulating printer queues, and resetting primary and backup domain controllers.
System operators were required to work a rotating shift that required being on-call and working all shifts including weekends and holidays.
Professional training included UNIX, POS, OSI model, network typologies, and Telzon infrared handheld barcode/inventory devices.

9/1997 - 10/1998
Manpower Technical, NYSE: MAN (GenRev, ST Labs)
Boise, Idaho
Test Operator

Conducted regression, feature, and system level testing for various companies including Hewlett Packard and Microsoft.
Testing included localization, twain compliance, blind tests, benchmarking, and Microsoft product compliance (WHQL).
Required to write detailed technical summaries describing the processes and results of the testing. Technical summaries required clear screen captures as well as step-by-step instructions that used the minimalist style.
Professional training included ghosting test machines and cloning computers.

Education

Current

University of Texas at Dallas - Professional MBA Program – Information Systems Focus

8/2002

Boise State University - Bachelor's Degree

I received a BA in English with a technical communication (writing) emphasis. In order to obtain a career in information technology I also received a minor in CIS focusing on database management and software development. I made the Dean's List with High Honors twice: once in the Spring of 2000 and again in the Spring of 2002. (3.4 GPA)

Affiliations

2/2001 – Present       Donate Life
3/2002 – Present       Trout Unlimited
6/2005 – Present       National Duck Stamp Collectors Society

Volunteer Information

Volunteer web and SQL Server 2000 development for the Idaho Donor Network using ASP, ASP.Net, and SQL Server. Presentation layer development uses Macromedia flash, fireworks, and dream weaver (HTML).

Tools

I have professional consultant level experience using many business intelligence tools. Examples of tools I have used are:

SAP BW: The administrative workbench (transaction rsa1), BEx Analyzer, BEx Query Designer, and BEx Web Application Designer.
Business Objects: Business Objects Enterprise, Crystal Reports, Crystal Management Console, Crystal Configuration Manager, Business View Manager, ePortfolio, OLAP Intelligence, Web Intelligence, Desktop Intelligence, Crystal Repository, Data Integrator, Live Office, SharePoint Portal, and the Integration Kit for SAP.
Microsoft: Visual Studio .Net, SQL Server: DTS (Data Transformation Services), SSIS (SQL Server Integrated Services, Microsoft’s new ETL tool provided with SQL Server 2005), and SSRS (SQL Server Reporting Services).
Cognos: Framework Manager, Report Net, and Power Play.