Results-driven technical leader with expertise contributing to the success of systems development, implementation, and support in mission-critical environments. Offers focused expertise in business intelligence solutions, including the development of dashboards and reporting. Demonstrated track record of success producing consistent results over a series of positions executing contract engagements for companies in multiple industries, including Biopharmaceuticals, Medical Devices, Financial Services, and other sectors. Effective at leveraging an unwavering commitment to excellence to launch, build, and lead highly effective software development strategies, consistently meeting and exceeding expectations.Key Skills & Competencies Data Warehouse Design | Driving Performance and Process Improvement | Technology Solutions | Building Relationships| Project Implementation | Project Management | Quality Assurance | Continuous Delivery | Reporting Solutions| Data Models | KPIs | Dashboard and Reporting Tools | Team Management | Mentoring & Coaching | Problem SolvingOpen NetworkerPhone: 314-322-5968Email Address: dcohn.data@gmail.comCalendly: https://calendly.com/dcohn-data/60min ... Please feel free to schedule a time for networking.Top technologies:* ETL (e.g., Talend, ADF, Synapse, SAP BODS, Pentaho, SSIS)* Dashboards (e.g., Power BI, Xcelsius)* Reporting (e.g., SAP BOBJ, Crystal Reports, SSRS)* Languages: SQL, Java, JavaScript, VBScript, VBA, HTML, CSS< JSON, XML.* Other Tools: Power Platform (e.g., Power Query / M, Power Pivot, Power Automate)* Databases: SQL Server| Oracle| Azure| Teradata| Neteeza| Amazon Redshift| Postgres | Hyperion Essbase| SAP HANA| MySQL| MS Access| UDB| DB2| Sybase* ERP: SAP ECC 4.7| 6.0| S/4 HANA| Oracle ERP| Vendavo| LFC| MRI| Yardi* CRM: Salesforce| Navision ERP / MS Dynamics* APIs: eBay, Indeed, CDC, Medicare, OpenWeatherMap, USDA, BLS, Cofense, eBay, Yahoo, and Google* Methodologies: Agile| Scrum| Waterfall| Inmon| Kimball| object-oriented programming (OOD)| Accelerated SAP (ASAP)LinkedIn Badges: Power BI| Agile Methodologies| Transact-SQL| MySQL| XML| Java| JavaScript| VBA| HTML| Access| Excel| Unity
-
Senior Bi Engineer (Power Bi And Azure)At&TAtlanta, Ga, Us -
Senior Bi Engineer (Power Bi And Azure)At&T Sep 2021 - PresentDallas, 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, and discuss system enhancements.* Transitioned legacy data entry processes from Excel to a combination of Power Apps, SharePoint, and Excel files, working alongside a dedicated Power Apps resource to ensure seamless integration.* Replaced a complex Excel/VBA-based month-end financial analysis tool with a streamlined Synapse/Azure/Power BI solution, reducing errors and improving maintainability.* Enhanced system efficiency, saving the client dozens of hours monthly and resolving recurring issues inherent in the previous solutions.Environment: Power BI, Power Query, Power Pivot, ADF / Synapse, Azure Blob Storage, Azure Database, SQL, SharePoint, VBA. -
Senior Business Intelligence Developer (Power Bi, Azure, Talend)Silverstein Properties, Inc. Mar 2020 - Jul 2022New 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 developers.* Major involvement in tool selection process, learning Power BI and Tableau within a few days each and producing related prototypes.* Built, implemented, and maintained BI solutions to meet business needs utilizing Agile methodology best practices with JIRA.Environment: Power BI, Azure, Talend, MRI, Agile, JIRA, Power Query, DAX, Win 10. -
Senior Business Intelligence Developer (Pentaho, Salesforce, Ms Dynamics)Acumen Solutions Dec 2019 - Mar 2020Mclean, 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, group, group member, opportunity, lead, account, contact, …) and over a dozen custom Salesforce objects.* Utilized Salesforce Data Loader extensively in application and command-line and from Pentaho in ETL processes.* Collected, profiled, collated, and mapped data for usage in new and existing solutions.* Queried data extensively with SOQL to ensure quality and identify and resolve inconsistencies and missing data.Environment: Pentaho, Salesforce CRM, Salesforce Data Loader, MS Dynamics, Talend, SOQL, SQL Server, Win 10. -
Sap Bods + Hana ArchitectCsl Behring Feb 2019 - Feb 2020Melbourne, 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 and xsd files.* Created SAP HANA tables, views, and calculated views for Qlik consumption containing Clarity data.* Wrote extensive documentation, including design specifications for SAP BODS (ETL) and HANA (tables and calculated views, data lineage spreadsheets illustrating the mappings between sources and targets, and data dictionaries).Environment: SAP BODS 4.2, SAP HANA, Clarity, Excel, XML, XSD, CDC, Win 10. -
Sap Bods Data Integration EngineerAvanos Medical Jun 2019 - Aug 2019Alpharetta, 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 migrate from SAP ECC to S/4 HANA. Finished the project when the client signed off on the migration.Environment: SAP BODS, SAP ECC, S/4 HANA, Excel. -
Talend Big Data ArchitectRoyal Caribbean Cruises Ltd. Feb 2019 - Apr 2019Miami, 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.* Construction of jobs and joblets dealing with error handling, logging, auditing, including incorporation of Neo4j.* Environment involves pulling from MongoDB, Parquet files (Azure data storage / ADLS), and SQL Server and writing to MongoDB and SQL Server, for later consumption with Dremio in a data lake.Environment: Talend Studio for Big Data 7.1.1| SQL Server 2017| Azure| ADLS| Dremio| MongoDB| HDInsight| Spark| Java. -
Bi / Bobj ArchitectCadence Bank, N.A. Nov 2018 - Jan 2019Tupelo, 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. -
Talend Developer / Architect / AdminUab Medicine Jun 2018 - Oct 2018Birmingham, 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 containing API-related data and auditing information.* Implemented and lead staff in cleansing of Excel & relational database tables via Talend Data Preparation tool.Environment: Talend Big Data 6.4, Talend Data Preparation, Oracle 11g, Java, JSON, XML, XPath, NetBeans, Excel. -
Sap Data Services ArchitectWeber-Stephen Products Llc May 2017 - May 2018* 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 twenty countries.* Authored key pieces of ETL blueprinting document (goal to produce sales report with global data): database details (incl. sizing); BODS architecture; BODS templates; and SSAS cube, WebI, and Targit report information.* Worked closely with SAP BW resources and business to gather and implement rules and resolve issues.* Engaged in data modeling and architecture related to target and auditing tables used in ETL loads. Environment: Data Services (BODS) 4.2; Business Objects 4 (WebI); SQL Server 2014 (including Azure); SSIS; SSAS; CDC; Navision / MS Dynamics; Targit; SAP BW (target); SAP BEx Queries; Win 7.
-
Senior Bi ArchitectRgp Jan 2016 - Oct 2017Irvine, 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 warehouse.* Created logical and physical models storing inventory (including costing), customer, vendor, machine / production data, revenue (AP and AR), and auditing information.* Developed almost three hundred reusable Java routines for use with Talend ETL procedures.* Converted from manual Access inventory process to ETL driven approach using Talend.* Designed, coordinated creation of, and created ETL code extracting and cleansing information from several dozen sources, including files, SAP, and databases. Included support for clear and load, incremental (CDC) processing, status updates, and automated testing. Tool: Talend.* Guided and highly involved with universe, report, and dashboard creation.Environment: Talend 6.1; Java; Oracle 11; SQL Server 2012; Access; SAP; Git; Subversion; Xcelsius; Webi; IDT; Win 7 & 10. -
Sap Business Objects Data Services (With Hana) SpecialistBb&T May 2015 - Oct 2015Charlotte, 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 construction of SAP HANA tables, views, stored procedures, and functions using a combination of Data Services, PowerDesigner, and HANA Studio.* Migration of information from multiple source systems (out of SAP HANA) into SAP Bank Analyzer, with various data profiling and quality checks and use of a composite table to ease maintenance.* Implemented creative approaches to maintain strong performance and accurate results, to get around limitations in highly locked down environment where HANA did not allow for creating objects within BODS.Environment: Data Services (BODS) 4, SAP HANA, SAP Bank Analyzer, DB2, PowerDesigner, Win 7. -
Senior Dashboard ConsultantChesapeake Utilities Corporation Apr 2015 - Sep 2015Dover, 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 multiple locales.* Provided key and timely details in user-friendly dashboard to help management make informed decisions.* Conversion of Microsoft Access based system to SQL Server.Environment: Dashboard Designer 4.1, Crystal Reports, Information Design Tool 4, MS Access, SQL Server 2012, Windows 7. -
Data Services SpecialistGeorgia-Pacific Llc Jul 2014 - Feb 2015Atlanta, 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. Included both inline and offline documentation of table structures.* Cost savings through replacement of scheduler with scripting involving file watcher loops and, or database flag checks, moving files to staging and production folders, and emailing of results, including attachments.* Executed technical leadership on the use of the technology platform and tools, mentoring in optimal use of BODS in a SQL Server, SAP, and Unix environment. -
Business Objects Specialist (Data Services And Enterprise)Kimberly-Clark Mar 2012 - May 2014Irving, 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 marketing information based on live SAP BPC data.* Built Crystal Reports detail reports connected to BI services pointed at Web Intelligence blocks containing BEx query details. Reports launched by and received prompts from Xcelsius dashboard.* Introduced best practices for Data Services, Xcelsius and Crystal Reports development.* Acted as go-to for the team for technical concerns and idea development.* Introduced best practices for Data Services and Xcelsius development.Note: Worked at another client from Feb to June, 2013. Concurrent with K-C in Feb and Mar.Environment: Data Services (BODS) 4; Xcelsius; Business Objects 4 (WebI, UDT, IDT); Crystal Reports 4; SQL Server 2008; Neteeza; XML; Win 7. -
Sr. Crystal Reports DeveloperImpreglon Feb 2011 - Oct 2013* 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 revenue by customer and state.* Designed and implemented best practices and standards for Crystal Reports.* Worked with analysts to resolve all accounting related data issues.Note: Provided part-time assistance with creating and modifying Crystal Reports documents with accounting information. Additional tool: JobBOSS.Environment: Crystal Reports; JobBOSS; Excel; VBA; Win 7.
-
Data Services And Business Objects Enterprise DeveloperCp Kelco Feb 2013 - Jun 2013Atlanta, 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 issues with onshore and offshore engineers. -
Business Objects Architect / AdministratorTri-Star Engineering (Us Navy) Oct 2011 - May 2012Bloomington, 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 information and allowing for linking with geographic based front end application. -
Sr. Data Services DeveloperUcb Feb 2011 - Nov 2011Alpharetta, Georgia, UsUsing 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. -
Senior Sap Business Objects DeveloperWestinghouse Electric Company Nov 2010 - Feb 2011Cranberry 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, formatting, and performance. -
Business Objects ArchitectAmerican Safety Insurance Jun 2010 - Jan 2011* 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.* Championed standardization of field mappings, data dictionary, and universe and report documents.
-
Senior Etl Developer - Data ServicesBlackwatch Data Jan 2010 - Aug 2010* 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 checking projects in Data Services.* Involved in pre-sales with multiple clients, including prototype development and demonstrations.
-
Business Objects Technical LeadAt&T May 2007 - Aug 2009Dallas, 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 report and universe creation and architecture.* 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.* Led and mentored team of four developers in project to reengineer, improve, and standardize report set.* Successful sign-off, on time, for (all) five consecutive projects.* Interviewed, helped select, and mentored new Business Objects staff and directed their tasks. -
Business Objects Project ManagerMylan Pharmaceuticals 2009 - 2009Canonsburg, 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. -
Etl DeveloperOldcastle (Crh) Jan 2007 - May 2007Dublin, 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 skip processes with errors and convert text values to zero’s. -
Business Objects And Crystal Reports Developer And AdministratorIntercontinental Exchange Mar 2006 - Jan 2007Atlanta, 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. -
Business Objects ExpertBlackstone And Cullen Sep 2005 - Mar 2006Dawsonville, Georgia, UsReporting analyst creating a Business Objects data warehouse to provide leasing information to hundreds of clients. -
Business Objects ExpertLeaseplan Sep 2005 - Mar 2006Amsterdam, North Holland, NlReporting analyst creating a Business Objects data warehouse to provide leasing information to hundreds of clients. -
Business Objects ExpertLockheed Martin Aug 2004 - Aug 2005Bethesda, Md, Us* Reporting analyst performing primary development work for multiple Navy reporting systems.* Primary Business Objects developer involved in successfully signed off government contract. -
Technical Support Analyst IiInformation Gateways Dec 2003 - Jul 2004Assisted 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.
-
Data Integrator DeveloperHaworth Oct 2003 - Nov 2003Holland, Mi, 49423, UsGathered requirements for, designed, developed, tested, and put in production transformations and universes for AP, PO, and FA segments of Oracle Financials using Data Integrator. -
Business Objects ExpertHewlett Packard Financial Services Jul 2003 - Sep 2003Houston, Texas, UsReporting analyst in a data warehousing project balancing data related to a conversion of a loan system. -
Business Objects ExpertAt&T Mar 2003 - Apr 2003Dallas, Tx, UsReporting analyst and administrator in a data warehousing project analyzing call center performance. -
Financial Reporting AnalystTravelers Dec 2002 - Feb 2003New York, Ny, UsFinancial reporting analyst in a mainframe (Focus), SAS to client-server (Business Objects, Crystal Reports) conversion of the Annuity Reporting System. -
Business Objects ExpertCit Group Mar 2002 - Sep 2002New 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. -
Data Warehousing ConsultantCigna May 2001 - Jan 2002Bloomfield, Ct, UsResponsible for enhancing, supporting, and maintaining a customized data warehouse (Brio) reporting application for investment data, including transformation of source data (Genio). -
Business Objects ExpertAnheuser-Busch Sep 1999 - Jan 2001St. 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. -
Vb / Crystal Reports DeveloperMastercard Nov 1998 - Dec 1999Purchase, Ny, UsGenerated financial reports and graphical user interface using Crystal Reports, Visual Basic, and Oracle. -
ConsultantDavis Interactive Dec 1995 - Dec 1999* 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.
-
Business Objects ConsultantPeabody Jan 1999 - Sep 1999St. Louis, Missouri, UsImplemented a data warehousing application that provided information on various aspects of coal production. -
Visual Basic DeveloperNestle Sep 1998 - Nov 1998Vevey, ChConverted order administration software from Easel to Visual Basic, using printer api and user controls. -
Programmer Analyst IMaritz Apr 1997 - Aug 1998St. Louis, Mo, Us* Assembly of Visual Basic based software for reusable client incentive system (CIMS for Windows).* Assisted with SQL Server database administration.
David Cohn Education Details
-
Maryville University Of Saint LouisAccounting -
Parkway Central High SchoolHigh School/Secondary Diplomas And Certificates
Frequently Asked Questions about David Cohn
What company does David Cohn work for?
David Cohn works for At&t
What is David Cohn's role at the current company?
David Cohn's current role is Senior BI Engineer (Power BI and Azure).
What schools did David Cohn attend?
David Cohn attended Maryville University Of Saint Louis, Parkway Central High School.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial