CELESTE GIANFRANCESCO BLENDEN

*** ******* ******, ***** *****, NJ 07009

acd7yj@r.postjobfree.com

973-***-****

SUMMARY OF QUALIFICATIONS

Information Technology Professional with over 20 years of experience. Core competencies include

business analysis, data warehousing and reporting. Experience in the design, development,

implementation and support of business intelligence. Effectively gathers business requirements and

translates functional specifications into technical. Expertise in Business Objects universe design,

complex reporting and security administration. Proficient at SQL programming. Successfully manages

multiple projects and is committed to meeting deliverables. Resourceful problem solver with solid

analytical, troubleshooting and performance tuning experience. Possesses strong leadership and

interpersonal skills. Excellent written and oral communication skills.

SOFTWARE

Client: BO XI 3.1 (Deski, Designer, Administrator), SQL Management Studio, Xcelsius Designer, TOAD,

PL/SQL, SQL Query Analyzer, MS Office, Lotus Notes, Windows 2000/XP/Vista, Telnet, VBA, SQL*Plus

Server: BO XI 3.1 (Webi, Infoview, CMC) Oracle 10g/11g, OBIEE, Discoverer, Qlikview, RAP, Citrix,

SVN, VSS, Service Now, Remedy, Harvest, SQL Server, Unix, VI Editor, FTP, DB2 UDB, TCP/IP

PROFESSIONAL EXPERIENCE

09/2013–Present

Business Objects Consultant, Axis Reinsurance Company, New York, NY

Provided BO Development/Administration and Data Analysis for Reinsurance Reporting

- Designed, developed, and maintained BO/Webi reports using SQL Server databases

- Supported existing production reports by addressing bugs and enhancement requests

- Migrated DEV/QA/UAT/PROD environments for regression testing using Import Wizard

- Performed impact analysis and implemented solutions for BOXI 3.1 Fix Pack 6.2 software upgrade

- Prepared Operational Handbook for BO Reports and documented CMC Procedures

- Automated the scheduling and delivery of monthly Financial/Accounting Reports

- Utilized SQL Management Studio to validate data warehouse and test the accuracy of BO Reports

08/2008–07/2013

Reporting Analyst/Developer, Ricoh, Montville, NJ

Provided Business Analysis and BI Design/Development for Financial/Manufacturing Reporting

- Designed, developed, and maintained BO/Deski/Webi reports/universes using Oracle databases

- Led Super User meetings and transformed requirements into effective/efficient BO reports

- Facilitated BO training and educated BO Administrator on security/migration procedures

- Prepared gap analysis to integrate IKON and Ricoh data and business rules for customer reporting

- Supported BO Xcelsius Designer/Live Office 4.5 dashboard with snapshot and drill down functionality

- Maintained Oracle Discoverer and Report Access Portal reports for multiple Business Areas

- Built universes mapping source data warehouses to target data mart for ad-hoc reporting

- Experience with Oracle Business Intelligence Enterprise Edition and Qlikview reporting tools

04/2008–06/2008

Business Objects Consultant, Pfizer, New York, NY

Provided Business Analysis and BO Development for Shared Application Management Systems

- Designed and developed BO/WebI reports accessing SQL Server databases

- Consolidated similar BO/WebI reports reducing overall number by over 75 percent

- Prepared Business Objects technical specifications for off-shore resources

- Utilized SQL Query Analyzer for analysis of tables, views, stored procedures and functions

- Analyzed legacy BO Universes/Reports/Metrics and provided recommendations for redesign

CELESTE GIANFRANCESCO BLENDEN

Page 2

07/2000–05/2003

Business Objects Consultant, JP Morgan Chase, New York, NY

Managed end-to-end information technology services for Global Credit Risk/Equities Reporting

- Designed, developed, and maintained BO/WebI reports/universes accessing Oracle databases

- Administered the security, utilization and reorganization of the BO repository

- Reduced the number of BO universes by 60 percent eliminating redundant and obsolete code

- Assisted users in creating BO/WebI reports and synchronizing multiple data providers

- Utilized TOAD and SQL Worksheet for database analysis, QA testing and performance tuning

- Prepared technical specifications and documented BO procedures

09/1999–07/2000

Business Objects Developer/Designer, The Prudential Insurance Company, Roseland, NJ

Provided technical leadership and delivered Insurance/Financial Business Intelligence

- Gathered business requirements and empowered users through adhoc reporting

- Designed and developed BO reports/universes accessing DB2 UDB databases

- Created linked universes to promote reusability and reduce maintenance time

- Built aliases, self-joins and contexts to resolve loops and create reporting objects

- Set up multiple domains and repositories for development, QA and production environments

- Migrated reports and universes from one domain to another and cross-repositories

- Utilized CAE Command Center to write SQL for testing objects, joins, and views

- Conducted BO training sessions and demonstrated how to create/format reports

11/1998–09/1999

Business Objects Developer/Designer, Schering-Plough, Liberty Corner, NJ

Assisted in the design, development and delivery of Pharmaceutical Business Intelligence

- Collected reporting requirements by meeting with user community and analyzing existing code

- Collaborated with DBA to design data warehouse for Business Objects reporting

- Designed and developed BO reports/universes mapping Oracle data warehouses and data marts

- Created customized lists of values for dimension codes and descriptions

- Implemented aggregate awareness to enhance the performance of SQL transactions

- Managed users/resources and customized environment with General Supervisor authority

- Coded PL/SQL functions, packages and triggers to create reporting objects

- Utilized TOAD and SQL*Plus for creating/testing queries and Y2K data reconciliation

01/1997–10/1998

Sr. Programmer Analyst/Developer, GE Capital, Stamford, CT

Assisted in the development, delivery and support of Marketing/Lending Business Intelligence

- Developed and maintained BO reports/universes accessing Oracle data warehouses

- Installed, configured, and administered BO servers and client software

- Utilized SQL*Plus for comparison testing during BO software upgrade

- Transferred files from mainframe to server for ad-hoc BO reporting and analysis

- Designed, coded, tested, and documented Cobol marketing systems for mail campaign

EDUCATION

Stevens Institute of Technology, Hoboken, NJ

Master of Science in Management Information Systems, 2002

Rutgers University, Newark, NJ

Bachelor of Science in Business Management, Alpha Sigma Lambda, 1993

Chubb Institute of Technology, Parsippany, NJ

Certificate in Computer Programming, 1988

Contact this candidate