David Cohn
3221 Asbury Square
Atlanta, GA 30346
Email: [email protected]
|
Cell: (314) 322-5968 |
PROFESSIONAL PROFILE
Senior Technologist with twelve years experience in business intelligence systems and software design and development. Background includes a variety of technologies such as data warehousing (reporting and etl), application development (including Internet), database design, and graphical user interfaces. Entrusted with a variety of key roles in projects such as technical lead, lead developer, and subject matter expert. Industry experience includes commodities, defense, investments, pharmaceuticals, clinical trials, financial-credit and loan systems, leasing, accounting (mostly general ledger, accounts payable, and accounts receivable), mining, beverage, health care, insurance, telecommunications, education, government, and manufacturing.
Business intelligence work includes reporting (Business Objects, Crystal Reports, Xcelsius, Brio), ETL (Oracle, Data Integrator, Genio, SQL Server DTS and SSIS) and many full lifecycle projects involving requirements gathering, writing of functional and technical specifications, report prototypes, development, testing, production implementation, and support. Business Objects expertise includes full-client and web-based report and universe development, installation, and administration, troubleshooting, scheduling and publishing, security, migrations, and the Visual Basic SDK. Customer-focused with the ability to respond to and update customers in a timely fashion and deliver projects within budget.
***
TECHNICAL EXPERTISE
Tools
Business Objects XI r2, 6.5, 6.1, 5.1.6, 5.1.6; WebIntelligence XI, 6.5, 6.1, 2.7 (WEBI); Data Integrator 6; SSIS; Sagent; BrioQuery; Hummingbird Genio; Erwin; Crystal Reports XI, 8.5; Crystal Xcelsius 2008; Visual Test Suite; Internet Information Server (IIS); InstallShield; Oracle Financials 10.7; Rational Clearquest; Microsoft Excel; Visio; HTML Help; Lotus Notes; Microsoft Word; Microsoft PowerPoint; Visual SourceSafe; Adobe Photoshop; Paintshop Pro; PVCS
Languages
Visual Basic 6; SQL; PL/SQL; Active Server Pages (ASP); C++; Ajax; Javascript; Cascading Style Sheets (CSS); VBScript; HTML; DHTML; XML; Focus; SAS; Cobol; Macromedia Director
Databases
SQL Server 2005, 2000, 7.0, 6.5; Oracle 9I, 8I, 7; Teradata v2r5; Neteeza; Queryman; SQLNet; SQL Loader; MySQL; PL/SQL; SQL; SQL Plus; Transact-SQL; Microsoft Access; UDB; DB2; Sybase; Foxpro; Filemaker
Operating Systems
Windows Vista, Windows XP, 2000, NT, 98, 95NT; Windows95; Mainframe; OS2; Macintosh OS; DOS
Other
OOD/OOP; COM/DCOM; OLE; OLAP; ROLAP; ODBC; ODBC API; ADO; RDO; DAO; SDLC; CRM; Direct-X; Web Browers; Sheridan Data Widgets; Win32 API; ActiveX Component Programming; DLL creation; Business Objects VB SDK; Star and Snowflake Schemas; 3-Tier Programming
PROFESSIONAL EXPERIENCE
| Cingular, Atlanta, GA |
05/2007-06/2009 |
| Business Objects Technical Lead and Architect |
Managed four developers while heavily participating in the Business Objects development effort for a large telecommunications company.
- Gathered requirements, produced technical and functional specifications, installed and configured Business Objects servers, and created and consolidated reports, universes, and (Xcelsius) dashboards containing telecommunications information.
- Provided guidelines and best practices for report and universe creation and architecture. Used to reengineer and standardize report set.
- Implemented ETL related to multiple systems, including creating and manipulation of tables with raw SQL and SQL Server Integration Services (SSIS). Analyzed related SAS code
- Successful sign-off, on time, for (all) five consecutive projects.
- Interviewed, selected, and mentored new Business Objects staff and directed their tasks.
Environment:
Business Objects XI r2; Crystal Xcelsius 2008; SQL Server 2005; Teradata; SSIS; Neteeza; Aqua Data Studio; Windows XP.
| Oldcastle, Atlanta, GA |
01/2007-05/2007 |
| Lead ETL Developer |
Extracted and transformed information from Excel spreadsheets into a SQL Server database.
- Designed database geared towards OLAP reporting and later Essbase loading to hold information from Excel.
- Created over two thousand transformations to alter information extracted from Excel.
- Developed ETL program using Visual Basic which included features for: selecting types of processes to display and which ETL processes to run; a status list; storing the metric values and a status for each process in the database; and options to skip processes with errors and convert text values to zero�s.
Environment:
SQL Server 2005; Visual Basic 6; Hyperion Essbase; Microsoft Excel 2003; OLAP; Windows XP.
| Intercontinental Exchange, Atlanta, GA |
03/2006-01/2007 |
| Business Objects and Crystal Reports Lead Developer and Administrator |
Migrating Sybase Business Objects (6.x) and Oracle Sagent data warehouses to provide (energy related) financial information to clients and internal business users.
- Migrated three reporting systems to Business Objects XI, with Oracle 9i: Sybase, Sagent, and VB.NET/ASP.
- Created, tested, and tuned reports and universes providing information about commodities, futures, and options.
- Created Oracle packages, functions, stored procedures, tables, and views.
- Gathered requirements from and fixed issues for business and technical users located locally and abroad.
- Business Objects installation, configuration, and administration, including scheduling reports, configuring user and group security, categories, folders, universes, and licensing.
Environment:
Oracle 9i; Business Objects XI r2 (Desktop Intelligence, Webi, Crystal Reports, Designer, Performance Management, SDK, and Central Management Console); Sagent; TOAD; Visual Basic 6; Scripting (VB, Java, batch); ASP; VB.NET; MS Office 2003 (All Products); HTML; XML; CSS; SDLC; Cisco VPN; Windows XP.
| LeasePlan, Atlanta, GA |
09/2005-03/2006 |
| Business Objects Expert |
Reporting analyst creating a Business Objects data warehouse to provide leasing information to hundreds of clients.
- Created linked reporting system using Webi with nine basic and eight linked Business Objects reports. Included documentation and performance tuning.
- Created a conversion utility supporting more and better formats than natively possible (Excel, Word, and HTML).
- Frequent interaction and meetings with users and management, including demonstrations.
Environment:
SQL Server 2005, 2000 (T-SQL, DTS, Query Analyzer, and Enterprise Manager); Business Objects XI (Webi, Designer, Java Administration); VBA; MS Office 2003 (All Products); HTML; CSS; Cisco VPN; Windows XP.
| Lockheed Martin (US Navy), New Orleans, LA |
08/2004-08/2005 |
| Business Objects Expert |
Reporting analyst performing primary development work for multiple Navy reporting systems.
- Successfully completed (accepted by customer) a conversion of an Access reporting system into Business Objects.
- Developed, documented, and performance tuned thirteen reports and associated universe.
- Assisted in defining the project scope using qualitative, quantitative, and technical criteria.
- Created a conversion utility for perfecting Excel and Word documents from Excel exports, using VBA.
- Frequent interaction and meetings with users and all levels of management, including demonstrations.
Environment:
Oracle 9i; Business Objects 6.5, 6.1; Designer; Supervisor; WEBI; Data Integrator; BO Reporter and Designer SDK; Access and Excel VBA; PVCS; MS Office 2000 (All Products); Windows 2000.
| WPAFB (US Air Force), Dayton, OH |
12/2003-07/2004 |
| Technical Support Analyst (Level II) |
Analyst providing assistance for the AFKS (Air Force Knowledge System) application.
- Provided solutions to over four hundred fifty tickets arising from over three hundred users, report creation and editing, troubleshooting of WIS and INF errors, training, and network, database, and universe problems.
- Reviewed, fixed, and increased performance of user reports and queries.
- Troubleshooting of invalid data resulting from universe and database problems, including fixing of joins, contexts, and data modeling issues.
- Assisted users in configuring client PC�s software to use USAF enterprise data warehouse.
Environment:
Teradata v2r5; Oracle 9i; Business Objects 6.1; Designer; Supervisor; ZABO; WEBI; Queryman; ISMT; Rational Clearquest; Access; MS Virtual Machine, Sun Java Runtime Environment, Outlook VB SDK; Windows 2000.
| Haworth, Holland, MI |
10/2003-11/2003 |
| ETL Developer |
Gathered requirements for, designed, developed, tested, and put in production transformations and universes for AP, PO, and FA segments of Oracle Financials using Data Integrator.
Environment:
Oracle 8i and 9i; Business Objects 5.1.4; Designer; Oracle Financials 10.7; Decision Point; Data Integrator 6; PL/SQL; PL/SQL Developer; Excel; Windows XP.
| HPFS, Murray Hill, NJ |
07/2003-09/2003 |
| Business Objects Expert |
Reporting analyst in a data warehousing project balancing data related to a conversion of a loan system.
- Gathered requirements for, designed, developed, tested, and maintained 30+ reports.
- Daily interaction with users for report requests and maintenance.
- Developed complex reports involving linked data providers, subqueries, and a universe with many contexts.
- Wrote reports including VB SDK additions, such as extra toolbars, menu options, and a form with prompts.
- Analyzed, documented, and provided recommendations for SQL Server DTS scripts.
- Developed multiple web sites using HTML, DHTML, Cascading Style Sheets (CSS), ASP, and Javascript.
Environment:
SQL Server 2000; Oracle 9i; Business Objects 5.1.6 and 6; Reporter; Designer; Supervisor; WEBI (2.7); Broadcast Agent; Access; Visual Basic 6; SQL; HTML; DHTML; CSS; ASP; Javascript; DTS; Excel; Windows 2000.
| AT&T, Bedminster, NJ |
03/2003-04/2003 |
| Business Objects Expert |
Reporting analyst and administrator in a data warehousing project analyzing call center performance.
- Resolved daily maintenance requests, provided performance recommendations, and developed prototype reports for an Application Foundation online reporting system.
- Installed, administered, and configured Business objects, including publisher.
- Produced Visual Basic tool for binary file compression of numeric sets of information.
Environment:
Oracle 8i; Oracle 9i; Business Objects 5.1.6; Reporter; Designer; Supervisor; WEBI (2.5); Publisher; Set Analyzer; Visual Basic 6; Microsoft Access; PL/SQL; SQL; Microsoft Excel; Windows XP.
| TRAVELERS, Hartford, CT |
12/2002-02/2003 |
| Lead Financial Reporting Analyst |
Lead financial reporting analyst in a mainframe (Focus), SAS to client-server (Business Objects, Crystal Reports) conversion of the Annuity Reporting System.
- Assisted with development of forty-two reports, including prototype development, testing, documentation, performance recommendations, and all requirements gathering and design.
- Detailed analysis of data, including data dictionary, physical data model, entity relationship diagrams, writing of test strategies and associated PL/SQL queries for balancing and reviewing integrity of data.
- Assisted with tool selection -- compared Business Objects and Crystal Reports reporting applications.
Environment:
Oracle 8i; Business Objects 5.0; Reporter; Designer; WEBI (2.6); Broadcast Agent; Crystal Reports 8.5; Cobol; PL/SQL;SQL; Erwin; Focus; SAS; Visual Basic; Microsoft Access; Microsoft Excel; Mainframe; Windows NT.
| CIT, Livingston, NJ |
03/2002-09/2002 |
| Business Objects Expert |
Financial reporting analyst in a mainframe (Citation) to client-server (ALS) Business Objects implementation of a data warehouse (Oracle, Sybase) for leasing. Extensively involved with end-users, vice-presidents, and accounting staff in requirement gathering, design, and testing stages.
- Full lifecycle development including requirements gathering, designing, data modeling and mapping, scheduling, universe and report building, testing, and assistance with training.
- Installation, administration, configuration, troubleshooting, and performance tuning of Business Objects Reporter, Designer, Supervisor, and Broadcast Agent.
- Fifty-three of fifty-five reports functioned flawlessly after commencement of production.
- Developed Visual Basic software and PL/SQL queries to balance and analyze data integrity.
- Used Business Objects Visual Basic SDK to recursively search for and describe report and universe objects.
- Mentoring of other Business Objects developers.
Environment:
Business Objects 5; Reporter; Designer; Supervisor; WEBI (2.5); Broadcast Agent; Oracle 8i; Sybase; Visual Basic 6; Microsoft Access; Microsoft Excel; DAO; TOAD; Excel VBA; Business Objects VB SDK; BusinessQuery for Excel; IIS; Windows 2000.
| CIGNA, Hartford, CT |
05/2001-01/2002 |
| Data Warehousing Consultant |
Responsible for enhancing, supporting, and maintaining a customized data warehouse (Brio) reporting application for investment data, including transformation of source data (Genio).
- Requirements gathering, design, documenting, scheduling, testing, and daily support of Brio and Genio.
- Mentoring of other developers in use of Brio.
- Creation of web-based reporting system, using Dreamweaver and ASP.
- Participated in tool selection comparison of various ETL products.
Environment:
BrioQuery (Portal, Enterprise, and On-Demand Server); Hummingbird Genio; Macromedia Dreamweaver; ASP; HTML; IIS; Erwin; UDB; Javascript; Microsoft Access; DAO; VBA; Microsoft Excel; Windows NT.
| ANHEUSER-BUSCH, INC., St. Louis, MO |
09/1999-01/2001 |
| Business Objects Expert |
Supported full lifecycle design of a data warehouse pricing and promotion system in a very structured environment that aided retailer sales tracking and marketing applications. Assisted in creating and validating the design of the application, exhibiting leadership through role as a mentor to other developers and assignment and review of tasks.
- Data modeling for the reporting system database and the Business Objects universe.
- Gathered requirements, designed, built and tested sixty+ reports and related PL/SQL functions and views.
- Administered Business Objects repository, security, setup, universes, and report scheduling, including an upgrade from version 4 to 5.
- Drew workflow diagrams related to requirements and repository documentation.
- Constructed automated universe and report documentation with Business Objects Visual Basic SDK.
- Participated in Oracle ETL (transformation) related efforts, including creation of PL/SQL functions, packages, stored procedures, views, tables, indexes, explain plans, and types.
Environment:
Business Objects 4 & 5; Reporter; Designer; Supervisor; Document Agent; Broadcast Agent; Oracle; PL/SQL; SQL; Microsoft Access; TOAD; Designer 2000; VBA; Developer 2000; Microsoft Excel; Visio; Windows95.
| PEABODY GROUP, St. Louis, MO |
01/1999-09/1999 |
| Business Objects Consultant |
Implemented a data warehousing application that provided information on various aspects of coal production.
- Data warehouse production including report creation, design, and prototyping, security, universe maintenance and origination, data definition and manipulation, testing, and layout.
- Conversion and enhancement of Crystal Reports into Business Objects documents.
- Developed materials for and led training in the use of a reporting system for technical support.
- Web page design for Business Objects related informational site.
Environment:
Business Objects 4; Reporter; Designer; Supervisor; Document Agent; Oracle; PL/SQL; SQL; Crystal Reports; TOAD; Macromedia Dreamweaver; PowerPoint; Visio; VBScript; VBA; HTML; Windows95.
| MASTERCARD, St. Louis, MO |
11/1998-12/1999 |
| Consultant |
Responsible for conception of financial reporting system and associated graphical user interface.
- Generated financial reports and graphical user interface using Crystal Reports, Visual Basic, and Oracle.
- Called back by manager for further development work after original completion date.
Environment:
Crystal Reports; Oracle; PL/SQL; SQL; Visual Basic; DAO; Active-X; Windows NT.
| RALSTON PURINA, St. Louis, MO |
09/1998-11/1998 |
| Consultant |
Converted order administration software from Easel to Visual Basic, using printer api and user controls.
Environment:
Visual Basic; DB2; Easel; DAO; ADO; Active-X; Lotus Notes; InstallShield (Scripts); Windows NT; OS2.
| MARITZ, INC., St. Louis, MO |
04/1997-08/1998 |
| Programmer Analyst I |
Assembly of software for reusable client incentive system (CIMS for Windows). Assisted with database administration.
- Database administration including backups, scheduling tasks daily, and setting up users and groups.
- Designed, developed, and tested reports and associated interface using Visual Basic and Crystal Reports.
- Led conversion of Filemaker database to Access, including development of interface and maintenance.
- Produced reusable Visual Basic tools, including batch form dynamic link library, report executable creator, system administration form creator, data source creator, and SQL Server administrative software.
Environment:
3-tiered architecture; COM/DCOM; ADO; RDO; DAO; Active-X; Visual Basic; SQL Server 6.5; Transact-SQL; Access; Crystal Reports; Visual Test Suite; Visual SourceSafe; Sheridan Data Widgets; FileMaker; Windows NT.
| DAVIS INTERACTIVE (Interchange Technologies), St. Louis, MO |
12/1995-12/1999 |
| Consultant |
Responsible for design and maintenance of multimedia projects with Macromedia Director and Visual Basic. Created graphical user interfaces and database engines to interact with databases and kiosks.
Environment:
Macromedia Director; Visual Basic; FTP; FileFlex; FileMaker; Windows95; Macintosh OS; Photoshop.
EDUCATION
MARYVILLE UNIVERSITY, St. Louis, MO
B.S. Accounting; Minor: Business Management, 1996
Recipient of Academic Scholarship
Tutor: General Statistics, 1995-97
NUMEROUS PROFESSIONAL WORKSHOPS & SEMINARS
CERTIFICATIONS
Teradata Certified Professional; Teradata Certified SQL Specialist
AWARDS
Employee of the Quarter (Quarter 4, 2007)
Lockheed Martin Outstanding Performer - 2004
DOWNLOADS