David Cohn Email & Phone Number

Atlanta, GA, US

Dallas, TX, US

* Led the design, architecture, and primary development of an employee performance incentive system for over 800 top-performing AT&T resources, leveraging Synapse, ADF pipelines, Azure Blob Storage, Power BI, Power Query, and SharePoint.* Collaborated extensively with the director of consulting services to validate data, review requirements, plan strategy.

New York, NY, US

* Architected and created multiple real estate dashboards, all approved by senior management, averaging completing one to two every two sprints.* Architecture involved modeling of data, cleansing, transformation, building of views, tables, stored procedures, and functions, and development of related dashboards.* Managed, coordinated, and mentored other BI.

Mclean, VA, US

* Created ETL solution for migrating user, group, accounts, and three custom objects from MS Dynamics to Pentaho.* Built multiple proofs of concept (user membership, encryption, and case management) involving Pentaho for final transformations and Talend for sample data generation.* Created, worked with (inserts, updates, …), and administered regular (user.

Melbourne, Victoria, AU

* Built end-to-end ETL solution for migrating from (PWA) Microsoft Project to Clarity leveraging SAP BODS, with support for encryption and archiving.* Designed and developed full load and CDC based jobs, including auditing mechanism, for populating information from Clarity files into SAP HANA. First project involved tab-delimited and second included xml.

Alpharetta, Georgia, US

* Built SAP BODS processes to validate data quality in migration from SAP ECC to S/4 HANA.* Ran extracts and researched data using interfaces for SAP ECC and S/4 HANA (SE16,...).* Engineered ETL processes (including with RFC functions), validating information tied primarily to finance, BOMs and routings, and materials.* Successfully helped the client.

Miami, Florida, US

* Creation, debugging, and tuning of standard and big data (Spark, MongoDB, ADLS / Parquet file) jobs in a fully agile scrum setting, with successes including reducing several job run times from hours (or never finishing) to minutes.* Tracing, debugging, and configuration of HDInsight and Spark environment, with relation to Talend big data jobs.*.

Tupelo, MS, US

* Guided staff and heavily involved in conversion from custom solution to Accenture LFC mortgage system.* Instrumental in successfully converting a dozen reports existing in custom solution using new Webi-based engine.* Implemented and instructed staff in best practices and resolved most complicated reporting issues faced by users.

Birmingham, Alabama, US

* Constructed Talend ETL jobs pulling RESTful API data from online sources into Oracle databases: CDC, BLS, OpenWeather, USDA, and Medicare. Achieved significant cost savings by replacing bought with free APIs. * Improved data value through incorporation of related information from other hospitals / providers via APIs.* Modeled over one hundred tables.

* Performed detailed analysis related to tracing lineage between Navision ERP, SSIS, SSAS, and Targit reports.* Creation and tuning of sixty-eight ETL jobs with SAP BODS, pulling data from Navision / SQL Server (+ Azure) into SAP DSO tables, with date-based CDC.* Merged, applied business rules to, and created twenty-two reports for data sourced from over.

Irvine, CA, US

* Successful technical leadership leading to on-time end-to-end implementation of a data warehouse, including all design, development, testing, and support phases.* Replaced existing technologies where data came manually from multiple plants and a variety of separate systems with a single reliable and consistent highly available centralized data.

Charlotte, NC, US

* Development of dataflows supporting multiple change data capture styles that include thousands of mappings and over seventy SAP DSO destinations. All information sourced from and writing to SAP HANA, with staging in DB2.* Created BODS specific portions of technical (ETL) documents, including mapping, lineage, and CDC information.* Design (modeling) and.

Dover, DE, US

* Creation of executive dashboard and reports illustrating volumes, imbalances, accounting details, and customer information related to acquisition. Improvement of existing dashboards and reports – organization and bug fixes.* Ensured data accuracy and providing of most important and up to date details by meeting with business analysts and management in.

Atlanta, GA, US

* Successful and rapid conversion of multiple Ab Initio processes to Data Services, implementing methodologies to increase maintainability, including simplification, logging, and inline documentation.* Data analysis, modeling, and profiling using SQL Server and Data Services, to provide new and improved data structures related to conversion efforts..

Irving, TX, US

* Constructed reusable templates to speed ETL development in BODS and provide auditing functionality. Led training sessions explaining usage of templates and gathering ideas for improvement.* Created executive summary and framework (Xcelsius) dashboards, including hierarchical selectors, flash variables (linking to dashboards), and dynamic sales and.

* Improved and created Crystal Reports documents, querying JobBOSS (a manufacturing ERP system.* Created reports with income statements from five current locations, mergers and acquisitions, and overall. * Developed two reports displaying (a) well organized list of customer details, allowing for prompts to meet needs of particular users and (b) shipped.

Atlanta, Georgia, US

* Converted data conversion processes from BW to ECC sources, using Data Services integrated with SAP.* Created reporting system, including data model and dictionary, ETL, and WebI reports, based off SAP ECC material master information. Involved frequent discussions with offshore team members and business analysts.* Troubleshot reporting, universe, and ETL.

Bloomington, Indiana, US

* Acting as systems/software engineer for system architecture planning, technical design, software development and test, and software, hardware, and interface integration.* Installing and providing best practices and guidance for multiple Business Objects Enterprise and Data Services (with Data Quality) instances.* Creating ten complex reports based on HR.

Alpharetta, Georgia, US

Using Data Services 3.2 to perform an SAP migration (4.7 to 6.0) against pharmaceutical data. Performing staging and testing in Oracle and SQL Server. Focusing to this point on manufacturing and material master information.

Cranberry Township, PA, US

* Conversion and enhancement of Cognos into WebI, Crystal, and Xcelsius reports based on SAP data (HCM,...).* Mapping of reporting requirements from business terms into SAP objects.* Creation and maintenance of olap universes sourced from BEx queries.* Writing and editing of SAP BEx queries using Query Designer.* Writing of test scripts for accuracy.

* 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.

* Creation of projects, jobs, workflows, and dataflows to manage and quality test data using Business Objects Data Services.* Loading and manipulation of SAP information using Business Objects Data Services.* Creation of Xcelsius dashboards to report on information extracted from SAP.* Full lifecycle development of data validation and contact duplicates.

Dallas, TX, US

* Gathered requirements, produced technical and functional specifications, and created and consolidated reports, universes, and (Xcelsius) dashboards containing telecommunications information.* Created, consolidated, and documented reports and universes containing telecommunications information.* Provided guidelines, assistance, and best practices for.

Canonsburg, Pennsylvania, US

* Managed team of developers in migration of Business Objects from 6.5 to XIr3, in hybrid Windows/Unix environment, with SAP Integration Kit.* Provided recommendations on improvements and fixes.* Implemented security, report, and scheduling fixes.

Dublin, IE

* Developed ETL program to extract and transform information from Excel spreadsheets into a SQL Server database.* Designed application in 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.

Atlanta, GA, US

* Reporting analyst migrating Sybase Business Objects (6.x) and Oracle Sagent data warehouses to provide (energy related) financial information to clients and internal business users.* Administration using Central Management Console to schedule reports, configure user and group security, categories, folders, universes, and licensing.

Dawsonville, Georgia, US

Reporting analyst creating a Business Objects data warehouse to provide leasing information to hundreds of clients.

Amsterdam, North Holland, NL

Reporting analyst creating a Business Objects data warehouse to provide leasing information to hundreds of clients.

Bethesda, MD, US

* Reporting analyst performing primary development work for multiple Navy reporting systems.* Primary Business Objects developer involved in successfully signed off government contract.

Assisted with 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.

Holland, MI, 49423, US

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.

Houston, Texas, US

Reporting analyst in a data warehousing project balancing data related to a conversion of a loan system.

Dallas, TX, US

Reporting analyst and administrator in a data warehousing project analyzing call center performance.

New York, NY, US

Financial reporting analyst in a mainframe (Focus), SAS to client-server (Business Objects, Crystal Reports) conversion of the Annuity Reporting System.

New York, NY, US

* 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.

Bloomfield, CT, US

Responsible for enhancing, supporting, and maintaining a customized data warehouse (Brio) reporting application for investment data, including transformation of source data (Genio).

St. Louis, MO, US

* 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.

Purchase, NY, US

Generated financial reports and graphical user interface using Crystal Reports, Visual Basic, and Oracle.

* 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.

St. Louis, Missouri, US

Implemented a data warehousing application that provided information on various aspects of coal production.

Vevey, CH

Converted order administration software from Easel to Visual Basic, using printer api and user controls.

St. Louis, MO, US

* Assembly of Visual Basic based software for reusable client incentive system (CIMS for Windows).* Assisted with SQL Server database administration.

Bachelor'S, Accounting

High School, High School/Secondary Diplomas And Certificates