Daniel Drahorád Email & Phone Number

Česko

Project participationData analyst at project data anonymization of non-production databases.Data Assassement at powerdesigner. Creating of physical data models.

Prague, Czechia

Participation in the projectTraining of junior analysts / developers. Development of new code or modification of existing code (in Javascript and JSON) for following processes: Changes in operations of the accounts. Modification of debt restructuring accounts. Cancelling of accounts of deceased clients. Modification of process of changing clients personal information. Preparaion of Smartcase tutorials, teaching junior Smartcase developers, providing them with consultations during their very first real requirements and tasks from business, quality assurance and code review.

Prague, Czechia

Project descriptionEnrichment of the existing DWH in ČEZ sale with the area "Recovery of receivables". Create an overview of receivables in due/overdue and enrichment with payment schedules, enforcement process and judicial enforcement. Sap BW source system analysis. Business analysis and design of the deposit of the area "Recovery of receivables" in the existing DWH. Delivery of founding scripts in this area. Testing reports over an already finished solution.Participation in the projectAnalysis and propose of data structures for business processes : Payments, Write-offs, Depreciations, Collections and Receivables.

Prague, The Capital, Czech Republic

Project descriptionBusiness methodology, requirements business analysis, management of business and data dictionary, proposal of data model, preparation of tasks for supplier, proposal of consolidation rules, methodology and architecture of enumeration management and expert consultation in chosen business areas (risk management, master data unification).Participation in the projectBusiness Insurance Analysis, Operational Leasing, Financial Leasing, Services, New Reporting. Solution Design: Concept of planning, forecasting and budgeting solutions across the company; Client Consolidation and Unification Concept in DWH; Analysis and revision of manual inputs in terms of automation; BA: Collecting business requirements and transforming them into IT solutions. Systems - DWH, Target, MIS, NIA, HEF, Accipiens. Analysis of reports and data bases.

Prague, The Capital, Czech Republic

Project descriptionThe goal of the project was to ensure Moneta harmony with EU regulations about personal data protection (GDPR), to replace the existing solution in the Credit Check for the approval of the new DWH registration module, to ensure the migration of the consent, to create a new logic for the client's consent, to modify / create new processes.

Prague, The Capital, Czech Republic

- Business Analyst for Datawarehouse (Oracle) and BI Reporting (IBM Cognos) areas- Gathering business requirements- Creation of Business Requirements Document = Intent and direction (business pains, b. drivers, b. measurement, Function&Non-functional requirements, Scope of intent, Description of current state, Business process description of future state.)- Creation of System Functional Specification = High level solution design (Impacts on the application environment, Solution proposal)- UML models (Enterprise Architect, Visio) - Financial estimate of proposal- Connection between business departments and IT department

Oracle Hyperion Planning - PoC for T-MobileOracle Hyperion Financial ReportingOracle Hyperion Web AnalysisOracle Hyperion SmartView

PROJECT ALLOCATIONS:Time Period - Company - Technology Area - Role---------------------------------------------------------------------------------------------------------Dec 2010 - Jul 2011 CME - Data Warehouse - (DW Analyst/Consultant)Jul 2011 - Nov 2012 AVG - Success Factors - (Analyst/Consultant)Jan 2012 - Nov 2012 Komerční Banka - Data Warehouse(Teradata)/Reporting(IBM Cognos) - (BI Analyst/Consultant)

Prague, The Capital, Czech Republic

Conslutant of Helios Orange System (ERP)http://www.helios.eu/en.html