DOC

Resume of David Cohn

By Scott Harper,2014-03-06 06:58
11 views 0
IT Consultant 1995 to 2006. Key Clients LeasePlan, Lockheed Martin, WPAFB Air Force, Haworth, HPFS, ATT, Travelers, CIT, Cigna, Anheuser-Busch,

David Cohn

    Atlanta, GA 30346 | Mobile: 314.322.5968 | davidcn2@aol.com

Professional Profile

    Accomplished Senior IT professional with a background in business intelligence, software design and full life-cycle development. Capable of managing numerous projects while leading cross-functional teams to meet and exceed overall IT initiatives. Demonstrated consultative process skills with emphasis on written and relationship development skills. Highlights of skills:

; Business Intelligence ; Strategic Planning and & Analysis

    ; Data Warehousing ; Reporting Systems Architecture

    ; Process Improvement ; Process Implementation

    ; Team Leadership & Effectiveness ; Software Design & Development

Technical Expertise

    ; Tools: Business Objects XI r3, r2, r1, 6.5, 6.1, 5.1.6, 5.1.6; WebIntelligence XI, 6.5, 6.1, 2.7 (WEBI); Data

    Integrator 6; Data Services XI 3.2; SSIS; SSAS; Sagent; BrioQuery; Hummingbird Genio; Erwin; Crystal

    Reports XI, 8.5; Xcelsius 2008; Internet Information Server (IIS); SQL Loader; SQLNet; Visio; PVCS.

    ; Languages: Visual Basic 6; PL/SQL; SQL; SQL Plus; Transact-SQL; Active Server Pages (ASP); C++;

    JavaScript; VBScript; HTML; DHTML; Focus; SAS; Cobol; Macromedia Director.

    ; Databases: SQL Server 2008, 2005, 2000, 7.0, 6.5; Oracle 9I, 8I, 7; Teradata v2r5; Hyperion Essbase;

    Netezza; MySQL; MS Access; UDB; DB2; Sybase; FoxPro; Filemaker.

    ; Business Applications: Business Objects (up to XI r3); Oracle Financials 10.7; SAP (extracts).

    ; OS: Windows Server 2008/7/Vista/XP/2000/NT/98/95NT; Windows 95; Mac OS; Mainframe.

    ; Other: OLTP; OLAP; ODBC/API, ADO; DAO; OLE DB; XML; CSS; Ajax; Forecasting; Trend Analysis;

    Full Life-Cycle Development; Star and Snowflake Schemas; Executive Dashboards; 3-Tier Programming.

    ; Industries: Commodities, Defense, Investments, Pharmaceuticals, Clinical Trials, Finance, Leasing, Mining,

    Beverage, Health Care, Insurance, Telecommunications, Government, and Manufacturing.

    ; Certifications: Teradata Certified Professional, Teradata Certified SQL Specialist.

Professional Experience

    American Safety Insurance, Atlanta, GA 06/2010 to Present

    Business Objects Architect

    ; Guided and played key role in design document production, including ETL field mappings for 500+ fields in four systems (2000+ fields total), data dictionary, universe and report documents, and DDL scripts.

    ; Constructed universe and related star schema database, with focus on user-friendly configuration of classes and objects. Universe automatically updated with self-created automation tool.

    ; Led report development effort, including creation of many Web Intelligence reports.

    ; Designed and implemented Business Objects architecture, including hardware and software requirements, CMS information, security, and migration from XIr2 to XIr3.

    ; Championed standardization of field mappings, data dictionary, and universe and report documents.

    ; Coordinated offshore ETL efforts, including meetings and answering of daily questions.

    Environment: Business Objects XI r3.2; SQL Server 2008; Designer SDK; Crystal Enterprise SDK, Win XP.

Convergence Consulting Group, Tampa, FL 07/2010 to Present

    ETL Architect

David Cohn Resume, Page 2

    ; Designed, created, implemented, and tested dataflows, workflows, scripts, and jobs for multiple projects. ; Troubleshooting and performance tuning which reduced several jobs from several hours to less than one. ; Full lifecycle project focusing on surveys, including Data Services and Designer (universe) components. ; Migrated dataflows, workflows, scripts, and jobs between repositories.

    Environment: Data Services XI r3.2, Business Objects XI r3.2; SQL Server 2008; Windows Server 2008, XP.

Black Watch Data, Atlanta, GA 01/2010 to 07/2010

    Data Quality Expert with Focus on ETL and Dashboards

; Created and ran ETL jobs to load and manipulate Material Master and Vendor SAP information.

    ; Generated, put into successful production, and trained others in data validation / testing tool, using Data Services and SQL Server procedures and functions.

    ; Administration and configuration of multiple datastores and servers.

    ; Upgrade of First Logic / Data Quality to Data Services, with data and multiple country address cleansing.

    ; Developed, published, and scheduled batch and real-time jobs.

    ; Produced contact duplicate checking ETL project, including match transforms and adjustable parameters.

    ; Constructed dashboards to review data validation results.

    Environment: Data Services XI r3.1, 3.2; SQL Server 2005; SAP (extracts); Xcelsius 2008; Windows XP.

AT&T, Atlanta, GA 2007 to 2009

    Business Objects Technical Lead/Architect

    ; Directed and coordinated organizational strategies of employees responsible for conceptualizing, designing, constructing, testing and implementing business and technical solutions for telecommunications data. ; Partnered with software and architectural teams to plan and build out new systems, understand scalability and constraints of software, and manage disaster recovery and business continuity planning. ; Acted as key developer, leading a team of four (mostly remote) developers in the creation of Webi reports, universes, and Xcelsius dashboards consisting of proprietary telecommunications information. ; Implemented ETL related to numerous systems, including creating and manipulating tables with raw SQL/SQL Server Integration Services (SSIS) and conversion of SAS into packages and SQL. ; Created tables, synonyms, views (particularly with analytic functions), and sequences in Netezza. ; Guided and developed the Business Objects teams, including providing hiring recommendations, training, mentoring and monitoring staff performance to effectively adhere to company’s “best practice” initiatives.

    ; Recipient of the “Employee of the Quarter” Award (Q4 2007).

    Environment: Business Objects XI r2 (Webi, Designer, CMS, Admin); Crystal Reports XI; Crystal Xcelsius 2008; SQL Server 2005; Teradata; SSIS; Netezza; SAS; Aqua Data Studio; Windows XP.

Rho, Chapel Hill, NC 2008

    Senior Business Objects Developer

    ; Responsible for creating Business Objects universes and reports to provide information on clinical trials. ; Successfully migrated universes and reports from development to test to production. ; Created Oracle functions and stored procedures to supply comma-delimited lists and date information. ; Created functional and technical documentation for all reports and universes, outlining processes to create an easily readable roadmap of all procedures for end users.

Environment: BusinessObjects XI r2; Oracle 9i; ARISg; Windows XP.

Oldcastle, Atlanta, GA 2007

    Lead ETL Developer

    ; Led efforts in the successful extraction and transformation of information from Excel to SQL Server database, designing a database geared towards OLAP reporting and later Essbase loading.

    ; Created >2,000 transformations to alter information extracted from Excel.

David Cohn Resume, Page 3

    ; Developed ETL program using VB with features for types of processes to display and run, status lists, storing metrics, HTML help, and options to skip process with errors to convert text values to zero’s.

Environment: SQL Server 2005; Visual Basic 6; Hyperion Essbase; OLAP; Windows XP.

Intercontinental Exchange, Atlanta, GA 2006 to 2007

    Lead Developer/Administrator Business Objects/Crystal Reports

    ; Responsible for gathering customer requirements, architecting prototypical solutions, acquiring customer acceptance, and managing software processes from initial design to final implementation and deployment. ; Primarily responsible for migrating Sybase, Business Objects (6.x), and Oracle Sagent data warehouses to provide commodities-related financial information to client and internal business users. ; Key Projects:

    o Migrated three reporting systems to Business Objects XI and Crystal Reports XI, with Oracle 9i.

    o Administration using Central Management Console to schedule reports, configure user and group

    security, and manage categories, folders, universes, and licensing.

    o Created and tested reports and universes with information about commodities, futures, and options.

    o Installed, tested, and maintained Business Objects XI (including Crystal) client and server software.

    Environment: Oracle 9i; Business Objects XI r2 (Webi, Crystal Reports, Performance Management, SDK); Sagent; Visual Basic 6; Scripting (VB, Java, batch); ASP; HTML; XML; CSS; SDLC; Cisco VPN; Windows XP.

IT Consultant 1995 to 2006

    Key Clients: LeasePlan, Lockheed Martin, WPAFB (Air Force), Haworth, HPFS, AT&T, Travelers, CIT, Cigna, Anheuser-Busch, Peabody Group, MasterCard, Ralston Purina, Maritz, Davis Interactive

    ; Client: LeasePlan, Atlanta, GA Business Objects Expert (2005 to 2006)

    o Created a Business Objects data warehouse to provide leasing information to >100 key clients.

    o Designed and rolled out an innovative reporting system using Webi, including linked reports.

    o Created conversion utility supporting improved (Excel) and unavailable formats (Word and HTML).

    ; Client: Lockheed Martin (US Navy), New Orleans, LA Business Objects Expert (2004 to 2005)

    o Gained acceptance of a conversion of an Access reporting system into Business Objects.

    o Developed, documented, and performance tuned thirteen reports and associated universes.

    o Conducted qualitative and quantitative analysis to define project scopes and technical criteria.

    o Created many Data Integrator jobs, workflows, and dataflows supplying source data for systems.

    o Collaborated with key internal and external decision makers to recommend process enhancements,

    including creation of conversion utility for perfecting Word and Excel files from Excel exports.

    o Recipient of the “Lockheed Martin Outstanding Performer” Award (2004).

    ; Client: WPAFB (US Air Force), Dayton, OH Bus. Objects Technical Support Analyst (2003 to 2004)

    o Provided expert analysis and assistance for the Air Force Knowledge System application, supporting

    over 450 tickets arising from over 300 users.

    o Tested and troubleshot WIS and INF errors, training, and network, database and universe issues.

    o Troubleshot invalid data resulting from universe and database problems.

    ; Client: Halworth, Holland, MI ETL Developer (2003)

    o Gathered specifications and developed, tested, and rolled out transformations and universes for AP,

    PO, and FA segments of Oracle Financials using Business Objects Data Integrator and Designer.

    ; Client: HFPS, Murray Hill, NJ Business Objects Expert (2003)

    o Served as financial reporting analyst, balancing data related to a conversion of a loan system.

    o Provided support to users for report requests and maintenance, creating and testing >30 reports.

    o Analyzed, documented, and implemented recommendations for SQL Server DTS scripts.

    ; Client: AT&T, Bedminster, NJ Business Objects Expert (2003)

    David Cohn Resume, Page 4

    o Reporting analyst/administrator for data warehouse targeted to analyze and improve call center

    performance and processes.

    o Responded to daily maintenance requests, streamlining processes through the installation,

    administration and configuration of Business Objects, including Publisher.

; Client: Travelers, Hartford, CT Business Analyst (2002 to 2003)

    o Main point of contact in a Focus mainframe, SAS to client-server (Business Objects, Crystal Reports)

    migration and conversion of the Annuity Reporting System.

    o Collaborated with cross-functional teams to develop 42 reports including prototype creation, testing,

    documentation, performance tuning, and requirements gathering and design.

    o Conducted in-depth data analysis including data dictionary, physical data model, entity relationship

    diagrams, and PL/SQL queries for balancing and reviewing integrity of data.

; Client: CIT, Livingston, NJ Business Objects Expert (2002)

    o Served as lead financial reporting analyst in a Citation mainframe to client-server (ALS) Business

    Objects implementation of a data warehouse (Oracle, Sybase) for leasing.

    o Partnered with end-users and key internal decision makers on requirements gathering.

    o Full life-cycle development and performance tuning of 54 flawless reports using Business Objects

    Reporter, Designer, Supervisor, and Broadcast Agent.

    o Trained, mentored and monitored new and existing developers, instilling “best practices” to adhere to

    internal protocols and procedures.

; Client: Cigna, Hartford, CT Data Warehousing Consultant (2001 to 2002)

    o Responsible for the enhancement and maintenance of a customized Brio data warehouse reporting

    application for investment data, including transforming source data (Genio).

    o Gathered scopes and specifications to test and provide daily support of Brio and Genio.

    o Taught end users on the capabilities, enhancements, and limitations of Brio.

; Client: Anheuser-Busch, Inc., St. Louis, MO Senior Business Objects Developer (1999 to 2001)

    o Implemented full lifecycle design of a 60 report data warehouse for pricing and promotions, that

    aided retailer sales tracking and marketing applications.

    o Administered Business Objects repository, security, setup, universes, and report scheduling, including

    an upgrade from version 4 to 5.

    o Constructed automated universe and report documentation with Business Objects SDK.

    o Participated in Oracle ETL (transformation) related efforts, including creation of PL/SQL functions,

    packages, stored procedures, views, tables, indexes, explain plans, and types.

; Client: Peabody Group, St. Louis, MO Business Objects Developer (1999)

    o Production included report creation, design, and prototyping security, universe maintenance and

    origination, data definition and manipulation, testing and layout.

; Client: MasterCard, St. Louis, MO Consultant (1998 to 1999)

    o Accountable for the conception of financial reporting system and associated graphical user interface,

    generating financial reports using Crystal Reports, VB, and Oracle.

; Client: Davis Interactive (Interchange Technologies) St. Louis, MO Consultant (1995 to 1999)

    o Responsible for design and support of multimedia projects with Macromedia Director and VB.

    o Created graphical user interfaces and database engines to interact with databases and kiosks.

    Maritz, St. Louis, MO 1997 to 1998

    Programmer/Analyst

    ; Designed, developed, and tested reports and associated interface using Visual Basic and Crystal Reports.

    Education

    ; Bachelors of Science Degree in Accounting, Minor in Business Management Maryville University;

    Recipient of Academic Scholarship. Graduated December 1996.

Report this document

For any questions or suggestions please email
cust-service@docsford.com