Edward Deutsch Email & Phone Number

Columbia, SC, US

• Primary individual responsible for forming policy and procedures aimed at a growing MS SQL Server data warehouse and reporting/BI environment. Responsible for the overall quality of data in management reporting..
• Develop test scenarios utilizing best practices
• Review and validate test cases
• Auditing and evaluation of data processes
• Test Automation, ETL testing, Functional Testing, Integration Testing and System Testing
• Aid in the automation strategy, technique and processes.

US

• Created interactive dashboards for self-service reporting, mostly coding in Hyperion Javascript, JOOLE, and SQL:
• Developed a method of trending data for short periods of time against a non-trending data source without creating a stored data source.
• Using JOOLE to send VBA commands to Excel and PowerPoint, generated intensely formatted output seamlessly, without the need for user interaction to export the data.
• Automated all existing Regulatory, Account, Compliance, New Business, and Appeals/Complaints/Grievance reporting against new data sources.
• Found and resolved issues with application client upgrades. Identified changes to data warehouse marts then implemented changes to queries accordingly.
• Researched applications to determine suitability for business processes. Instrumental in deployment, particularly with SAP Business Objects Web Intelligence Xcelsius Dashboards, Tableau, and MS SQL Server (SSMS and SSRS)

US

• Responsible for upholding data integrity and quality in reporting:
• Performed high-focus regulatory reporting and query writing, containing company-wide utilization information, coordinating key stakeholders, data professionals, and database administrators.
• Interpreted requests for audits (Customer, Corporate, and QI), to organize information gathering and fulfill ad-hoc requests.
• Poured through existing reporting methods, looking for data variances, bringing discrepancies to stakeholders for verification, going over changes and how possible past over/under would impact ongoing business. Worked.
• Assessed impact, and restructured data in Access at ten source sites for warehouse data mart population. Wrote Windows batch files to kick off compaction and data unification of multiple Access databases. Rebuilt a.
• Continued to use Excel to manipulate or filter data extracts making frequent use of complex formulas, and conditional formatting, to highlight potential mismatches in data.

US

• Sole individual responsible for compliance and detail reporting for all Appeals and Complaints sites nationwide for regulatory agencies, internal and external customers, and auditors:
• Administered national Access databases; developed and administered local Access databases.
• Access development and administration included VBA coding and maintenance of front and back ends at ten sites around the country, as well as VBA scripting to aggregate data from those sites locally for reporting.
• Trained staff to query databases and produce reports. Organized a new team to handle the reporting on an ongoing basis.
• Automated tasks in Excel reporting with VBA macros. Enabled us to expedite training staff to assist with reporting.
• Queried national Sybase database using Brio Query Explorer. Designed and coded dashboards.

Web Development and Design. Document and media formatting. Technical support. As a freelance tech, responsible for projects from start to finish, finances, contract writing and negotiation, working with other independent contractors, freelancers and subcontractors. First project was the official Peaches and Herb web site.

Washington, D.C., US

While working for TONYA, Inc. created intranet/internet site for the Department of Housing and Urban Development (HUD), to assist grantees with obtaining resources, tools and training information related to the Integrated Disbursement and Information System (IDIS).https://idis.hud.gov/idis/Dreamweaver, Coldfusion, ADA Section 508 Compliance

Ba, International Affairs, Middle Eastern Studies

Education record

Education record