Business Objects / Report Development / Data Warehousing / SQL / BI / ETL / Data Modeling:

Results-oriented IT professional with proven abilities in Business Intelligence solutions, database development, data modeling, software development, report development, GIS Mapping, web development and systems support. Excellent analytical skills enable development of database applications that improve throughput and efficiency. Proven abilities and successes as a database developer are due to a quick grasp of complex concepts along with excellence in interpreting ideas into logical strategies.

Comprehensive Experience in the Following

DB & Software Dev.
MS SQL Server 2000/2005
Oracle 10, 9.2
MySQL
MS Access (All Versions)
VB / VBA / VB Script

ETL & Report Dev.
PL/SQL & T-SQL
Toad for Oracle/Sql Svr.
Oracle Enterprise Mgr.
Business Obj 6.5x, XIR1, R2, R3
MicroStrategy 9.2

GIS & Misc Dev.
MapInfo 7.5
MapBasic 6.5
Adobe Photoshop
MS Visual InterDev
MS Operating Systems

Professional Experience:

Confidential, Fort Lauderdale, FL 11/07 12/08
Division of CBS that develops all CBS Sports’ web sites and fantasy games, and captures all data associates with those entities. CBSi is the 8th highest traffic site on the internet with the longest retention time at 42 minutes per user.
Data Warehouse Developer/Report Developer
Member of six person team responsible for capturing all web activity from CBS Sports and migrate data from Application to Warehouse to Datamart through several ETL processes. Datamart built as Star Schema for reporting purpose and for ad-hoc querying.

• Duties included; Business Objects (R1, R2, R3) report development, universe design, security, data validation, troubleshooting server issues, ETL, stored procedures, custom queries, training, and technical documentation.

Confidential,Fort Lauderdale, FL 12/99 11/07
Leading South Florida newspaper, with circulation over 250,000. This newspaper is owned and operated by Tribune Corp., a leading national media operation.
Senior ETL & Report Developer Circulation 10/04 11/07
Lead group that supports the Circulation user’s data environment. My time was distributed between 75% development, 10% training and 15% data analysis.

• Development: Data Modeling and development using Oracle, SQL Server and MS Access. Stored Procedures, functions, ETL development written in PL/SQL, Web page design and interface with SQL server using ASP. Business Objects (6.x, R1, R2) development included; universe design, report development and building a security model for a 12 site, multi departmental environment.
• Training: Three junior Business Objects report designers worked with me and I spent about 4 hours a week training them on advanced report design techniques.
• Data Analysis: Managed the ETL and data warehouse on the Oracle servers. Troubleshot issues that arose from the ETL during the 44 step daily process. Wrote stored procedures for data validation to insure data integrity. Note: See page 3 for detailed Business Objects tasks list

Systems Analyst Technology 12/99 9/04

• Instrumental in the Discus Project which replaced the SS Circulation System. My role for 2 years on this team included; data conversion and migration, Business Objects (BO) server setup, BO Security, BO Universe design, and Development of 60 go-live reports.
• Willowbend Project: GIS mapping project. Administered multiple SQL 2000 databases. Databases manage all addresses, subscribers, rate codes, and geocoding information. Manage back end, writing custom stored procedures for generating maps and reports.
• Administered and developed 15-20 active MS Access databases. Database development included enhancement of existing databases with design changes, data modeling, stored procedures, triggers, and DTS packages. SQL database development included project management application for intranet.
• Developed Marketing and Circulation Intranet site, consisting of 13 subwebs. Development included graphics, images, java hierarchical menu design, template design, security, Flash banners, and database interfaces.

Confidential,Coral Springs, FL 1/99 - 12/99
Medical software developer and manufacturer, marketing to medical office environments. Software capable of practice management, reports, and claims submission, and archiving software for X-rays, Ekg’s and medical claims.
Systems Support / Analyst

• Provided all levels of support to end-users. Troubleshot software, hardware, and operating system issues.
• Sought out solutions for bug fixes, wrote custom queries and reports.

Confidential,Sunrise, FL 6/97 1/99
Manufacturer and developer of relational database software written in PICK, targeted to automotive paint industry and inventory intensive distribution businesses. Offers complete business management solutions, including POS, Shipping/Receiving, AP, AR, Payroll and General Ledger.
Support Analyst / Programmer / Installer

• Provided level II and III support. Troubleshot software and hardware, custom programming, designed custom queries and found specific solutions to complex tasks.
• Traveled nationwide (10-20%) installing networks, using PICK (dumb terminals), Win 95, and/or Win NT. Trained employees in all areas of software usage.

Confidential,Boca Raton, FL 12/96 - 4/97
IT contractor and recruiter. Spearheaded group for ARC, into Blockbuster Entertainment Group, determining requirements to efficiently relocate computer hardware from FL to TX.
Consultant

• Surveyed all users about applications required to do their job in order to minimize the 237 different types of software. Standardized software usage, resulting in reduced licensing cost and improved efficiency.
• Conducted time studies on amount of labor required to reconfigure each PC, package all hardware, and upgrade memory, NICs, hard drives and CD ROMs to specified minimum standards.
• Organized 1500 PCs into 8 basic configurations prior to the move to TX.

Confidential,Fort Lauderdale, FL 8/96 - 12/96
Temporary job placement company assigned to Vencor Hospital Corp for 5 months.
Technical Writer / Application Designer / Programmer

• Designed and wrote initial database program in Lotus 123 that tracked all hospital employees. Program comprised of custom menus, macro buttons, 5,000+ formulas, and 2,000 lines of code. Wrote a 75-page users manual that was distributed to 200+ hospitals.

Education:

Confidential, University
Confidential,Community

Computer Courses:

LAN Management
Turbo Pascal
Programming in Basic
Advanced Visual Basic 5.0
MS SQL Admin & Developer

Awards:

• 2004 Recipient of the Sun-Sentinel Presidents Award given for outstanding contribution to the DISCUS project development and implementation.
• 2004 Recipient of the Sun-Sentinel Technology Directors Award for outstanding leadership with the Sarbanes Team.

Detailed Business Objects Task List

This is a list of many of the tasks I was responsible for at the Sun-Sentinel as they related to Business Objects. I also had a list of other duties but I spent 60-70% of my time directly related to Business Objects or Data Warehouse development and managing the ETL.

• Took part in the evaluation of all the leading Reporting Development tools. The group ended up to choosing Business Objects as the software solution.
• I was part of the project team that wrote specifications for Oracle and Business Objects licensing requirements. I also was an integral part of Business Objects hardware specifications team.
• Chose the Business Objects Solution provider who came in and did the initial installation of the software and configuration of the servers. Went through training at the same time. At that time we installed version 6.0 in 1st quarter of 2002.
• I was a member of the conversion team that who were responsible for the extraction and conversion of old data from our IBM mainframe to the new Oracle database. I wrote many conversion programs that handled the data conversion automatically.
• Was a member of the Business Audit team that met with a different Business Objects Solution provider who was contracted to build a Datamart, ETL process, 5 universes and about 25 Go-Live reports.
• Shadowed that provider’s team for many months while they build their solution and provided answers to their specific questions when they arose. I also went through many months of training in Business Objects and took their courses in Administration, Universe Design, Report Development from beginners through advanced report writing as well as other courses.
• Took over primary support of the Business Objects, ETL process and the Data Warehouse after we went live with the new system.
• After between 1-2 years I had to rewrite the entire ETL process (approximately 25-30 of the 42 functions) because the process went from 2-3 hours at Go-Live to 10-12 hours within a year or two. This was not an option because of many production reports that were critical to getting the newspaper out the door were dependant on the ETL process completing within a certain time period.
• Added at least another 12-14 universes and 250+ reports.
• Maintained the Business Objects servers and applied patches and updates as needed.
• Trained other users on how to write and develop reports as well as 3 other report developers within my team.
• Maintained the user environment and security in 6.x and XI.
• Built a development server in version XI and after extensive testing, migrated the Business Objects 6.x servers to version XI R1.
• I assisted other Tribune Corp. properties in building Business Objects environments as they went onto this new “Discus” software to manage their circulation system. I used to travel to their locations for 2-3 weeks.
• Continued as the sole support for this environment for 5 years until 2007 when Tribune Corp. the Sun-Sentinel’s parent company decided to migrate the entire environment (software application, live data, Datamart and Business Objects) into a single environment based out of Chicago.
• They hired an off shore company based in India to head up the Datamart and Business Objects migration and I was chosen to be the Tribune’s technical lead for the project. That entailed speaking on the phone with the offshore project manager for an average of 2-3 hours per day for as many as 6 months. I provided them all the universes and PL/SQL code I had written over the years and then they used that information to convert my process to an Informatica ETL process.
• Designed and build a security model in BO XI that involved 16 separate properties and approximately 1600 users. This included a general corporate area where the base 100 +/- reports were located. Any one of the 11 properties could open and use these reports. I also designed a separate environment for each property where they could use the environment for their site specific reports. No other property had access to these areas.