ABN 25 061 443 605 Dimitar Berberu
4/105 The Grand Pde, Brighton Le Sands 2216
mob 0430 208 331
e-mail: , au.linkedin.com/in/DimitarBerberu
29 Jun 2017
I am talented team oriented professional with broad data/business domain skills and passion for getting holistic value from digital transformation, data governance/ analytics/ reportingwith a diverse skill set. Advanced creative problem solving skills with background in Mathematics, Big Data Warehouse architecture. Achievements in delivering with complex Data Quality/Accuracy, Integration Competency/Excellence Centre methodology; ensuring leadership, relationships, and customer/stakeholder satisfaction.
• Over 20 years DataWarehousing, BI, Digital Transformation, inc. Teradata, Oracle, DB2, SQL Server/Access (advanced SQL, Excel with VBa) as technical Business/QA/Holistic Data specialist.
• Deliver quality/timely research/analysis, requirements elicitation/gathering, QA strategies, plans/cases, management & defect resolution across various platforms, including security, performance, regression testing. Use various tools, , ALM, JIRA, Agile Data Driven Design.
• Liaise/cooperate with business/managers/SMEs/developers/vendors on multi-service business value-driven delivery, end-to-end view of enterprise, resolve/escalate issues with task ownership, status reporting, follow up and data driven decision responsibility.
• Ability to ask questions probe to uncover issues, explain complex concepts in non-technical language, handle multiple tasks, prioritise agile continual improvement.
• At MLC/NAB, AMP, Westpac, Optus, etc. I've been working on complex projects, coordinating Business, Data & Developers efforts to migrate/produce Data Marts sourced from legacy systems/EDWarehouse & rules to classify customer portfolios. Analysis of data, reports used for presentation/visualisation to stakeholders, ETL, cleansing, validation/ reconciliation, auditing & creative solutions. Sense for hard to find errors.
As Lead tech QA analyst, managing team of six & coordinating with developers/UAT business workload of over 250 SAP Business Objects reports/dashboards/graphs (consolidated from 600 Cognos) & coordinating requirements/QA, with stakeholders, managing migration risks, issues & root cause analysis.
• Business engagement with end to end data transformations/consolidation, quality, reporting. Stakeholder coordination, requirements traceability mapping, data governance, business metadata/ profiling/ ID match, master data, & solving various data problems.
Yours sincerely,
Dimitar Berberu
P.S. This is more than a job to me—it's my philosophy in life how to bring technology, analytics, social collaboration & business people together in a positive way that maximizes their potential. I'm a keen/fast learner/thinker & diving into new trends as AIntelligence, Cloud, Data Economy, IoT / Smart Cities…
Resume - DIMITAR BERBERU
Dimitar BERBERU
M 0430 208331
for CV download: http://iinet.net.au/~berberu
Citizenship: Australian, Loc: Sydney
Objective
To obtain a challenging position '82 that will leverage on my significant professional skills & support company's growth, profitability & success. Effective, collaborative in a team & under minimum supervision. Able to work well under pressure, achieving excellent results. Can also accept flexible/remote working to boost productivity (& reduce travel time).
Education & Training
B.Sc., Mathematics Information Science, Cyril Methodius Uni, Macedonia/Yugoslavia '82
Post graduate studies, Faculty of Electronics, IT, Cyril Methodius Uni (not completed)
Data Science Machine Learning with Matlab/R 14 week course completed with max points (distinction)
Mining Massive datasets/MapReduce, Getting Cleaning Data ongoing12'14; D4M, Python
Agile Development (Scrum, Kanban, RAD)
SAS BI ETL Studio/Data Integration & Marketing Automation certificate; Data Quality; Visual Analytics 6.3+,
BI course MicroStrategy 8/9.4; sap Business Objects XI r2, QlikView, Hyperion Essbase, ms powerPivot/view/BI, Tableau~QlikView~Birt, Crystal
, DataFluxSQL Server 2012+ BI SSIS/RS/AS/DTools/DQS new horizons, intro DAX, tSQL; Kimball model; DataStage
Informatica powerCenter, ICC Integration Competency Centre/ Master Data8.6/Quality, salesforce integration
Oracle 10g SQL certificate, PL/Sql, Oracle/OBIee 11gR2 OBIEE practical
Teradata warehouse architecture (incl R15), TCManager 3(Relationship Optimizer CRM 6), ms Dynamics
Toad for Oracle/SqlServer/DB2, 4Data Analysis/Modeller QiD analytical query tool
, Squirrel, Spufi, ProEdit for DB2, Datacom /DataQuerySAP ERP, PeopleSoft/Siebel HRms
Financial Competence, Superannuation(924), Essentials of Corp. Finance
Project Management, Presentations; Volere req.spec, IIBA BABOK v3 review; Agile/Systems thinking;, PMBok
Problem/Configuration/Change Info Management (InfoMan) Analysis
Ringtail (Litigation Support) back-end, Migration & reporting including Tracker (ASIC), Analytics
MS Office 2010-16 VBa, Access, Excel, Word, Power Point, VBasic, VStudio 2010 .NET, Visio, Erwin
Java script jQuery, PERL regular expressions Introduction to COM & MTS, Test tools ~ TQP, Java script, Java,SmallTalk, Visual Age, OO AD, ObjectRexx, C/C++, KaseSet
Dreamweaver MX Level 2(HTML/web design);; GoldMine CRM; Hadoop
IKM QA Test certificate with 96% percentile (~ISTQB)
HP ALM 11/ Quality Center, IBM Rational suite(rtc), JIRA prj/issue tracking, Xpeditor/Xchange, PLITEST, CA Intertest, WITT Testing (OS/2), TSO Test
XML, HTML5, Css, Adobe Acrobat, ABBYY FineReader OCR
File Aid/Data Ager, Librarian, Endevor, OPC, Net/Master, Net View; SMP/E, ACF2, RACF security
ETi Extract/ETL; PL/1 & IBM systems devl. lang, COBOL, AssemblerDB2 9.1, QMF; PL/1 Advanced; PASCAL; CICS programming; workshop; installation and maintenance; Cobol; VSAM; JCL
Constantly keeping involved with Education, industry trends and business needs. Data Driven Decision making focus., DOS/VSE
Top Skills Roles / yrs / last used / rating/10Technical Business Data Analyst / QA Lead/ Design development,
Data Quality/ mgmt. coordination/Governance / 10+ / Current / 10
Data Warehousing, SQL Server, Teradata, Oracle, DB2, Hive; TOAD data/model
big SQL, Excel/Access/VBa / 10+ / current / 10
Analysis /QA, HP/mercury ALM/QCenter, IBM rational / 10+ / current / 9
ETL Informatica, DataStage, ms SSIS/AS/RS, SAS/BI, stored procedures, Unix / 5+ / current / 8
Microsoft BI, SAP Business Objects/BW, Cognos, QlikView, CRM / 5+ / current / 8
Analytics R/Python/Perl / 2+ / current / 7
Problem/Configuration/Change Management / 5+ / '2010 / 7
VSAM and specialised databases CICS, ISPF / 9+ / '02 / 8
PL/1, COBOL, C, mainframe, JCL, REXX os2/vm/mvs *z/OS / 10+ / '09 / 7
Matlab, C#, C++, PASCAL, SmallTalk, Fortran , PL/I / 2+ / '2014 / 6
EXPERTISE SUMMARY
Applications & Industry domains
Finance, Wealth Management, Superannuation, Insurance, Investment/Trading/Retail/Commercial/Treasury institutional banking
Data Integration, governance, Migration various formats/ distributed business systems, Data Mapping/Profiling/Modelling, Metadata, Quality Validation/ Collation/ deDuplication/ Cleansing/ Integrity/ Accuracy/ Completeness/ Lineage, EDI/B2B,
pattern/identity/address Matching, Root cause/gap/impact analysis, Single View of Customer (SCV)
Digital Transformation, Customer insights/Business Intelligence/Data Analytics/Visualisation, Customer Rel Mgmt (CRM), Marketing & Sales Campaigns, Behavioural Scoring, Credit Risk Analytics/reporting, Basel/FinStudio,
Credit Collections, eCommerce
Statistics Analysis Reports/Charts metrics, forecast, Quantitative, Total Quality Control (TQC~6σ sigma, CI)
Enterprise Data Warehousing(real time)/Mining/ MasterDataManagement(MDM)/ stewardship, DataMarts architecture, Business Data Dictionary, Metadata solutions in large scale global markets/corporate environments, OLAP
Problem solving & Automated Test through Sql, Excel/Access VBa, Requirements Traceability, Managing environments/reviews, SDLC scope, tools assessment, defect management, story boards, QA, UT/ST/SIT/UAT
Evidence Management Sys migration for Government Litigation Support Sys (SQL server/FTI Ringtail Legal) Functional spec design, ETL, QA risk/change/stakeholder management, recommending solutions
Telecoms Billing, Traffic Accounting System, Customer Profile System, Web Reporting
Utilities/Energy metering, reportingcall centre,; Airline financials/ticketing/billing
Problem, Change, Configuration, Project Management, Business Process, Elicit requirements, foster RelationshipsReengineering
Operating System, National Language Support/Double Byte Character Set, Payroll/HRMS,
Expert Systems, Medical/Health
Methodologies: Agile/Lean/Continuous Integration & Delivery CI/XP/CD, Test/Data Driven Development, ITIL, ISTQB CMM(i), Babok; Data/Quality Management, RAD, QPLAN, SOA; ETL dimensional modelling, Kimball/Inmon, Data Vault
PROFESSIONAL ACHIEVEMENTS Functional
Oct '14-'15; -Sep'16 Sen Business Data Analyst Westpac; Lead Data QA Analyst Governance/Customer insights Optus
Westpac/St.George Capability Delivery BI/insights MyBank Digital Transformation/Migration for branch OTC customer behaviour, with Teradata/SAS Enterprise Guide solution & BI front end visualisation. *see Westpac engagements next page
NSW Data Analytics Centre linking, extraction, consolidation, analysis. Using SQL/Toad, Data Pivot, Excel utilities.
Consolidate/migrate legacy system into Integrated DW, ETL process, SQL Teradata/Netezza/Big Data Insights(TNF Big Sql/Hive/Hadoop), SAS marketing, data mapping & reporting/dashboard consolidation, data management framework, BI/Qlick.
▪ Stakeholder coordination/requirements traceability, acceptance testing. ▪ Data governance, business metadata/dictionary, master data. ▪ Data & business analysis with profiling, business rules/transformations/flows in post/prepaid & digital domains.
Nov 2013 –May 2014; Technical Business Data Analyst MLC/NABank Wealth Mgmt Super;
Sep'07-Jan'08 QA Lead business Test/Data integration Analyst Agile/ Kanban env, multiple assignments
Wealth Superannuation Intra Fund Consolidation, Analysis, Mapping, Algorithms Design, customer segmentation
▪ Development of rules to identify & categorise multiple customer accounts(identity/address matching), maintain confidentiality
▪ Gap analysis, architecture, docs & solutions to access data from DW/multiple complex product sources, data mining
▪ Analysis/reports to determine impacts of consolidations over time & generation of project Business Case with agile approach
▪ Coordinate with SMEs/BAs/Developers/ETL(Infosys) on customer Data Model/Mart/ algorithms to support mail out (opt in/out). Quality deliverables, Liaise with remote resources. Advanced SQL & Excel VBA, Access, Oracle/Toad data analysis, transformation & loading, data modelling, mining, continuous delivery.
MLC, Lead/coordinate/mentor/inspire (team of 6) migration from Cognos8 to SAP Business Objects XI Reporting of Wealth Mgmt BI/analytics: OracleFin/General Ledger(GL), Expense/Profitability(Profit&Loss), Unit Pricing, Resource Utilisation, Sales
▪ Migration of visual reports, completeness/accuracy of financial metadata/ definitions/ Universes/cubes & quality standards
▪ Life-Cycle Management Workflow (>250 of 600 reports consolidated). Business req. analysis, validation & publishing.
May-Sep'16, Jan-Jun'13, Apr-Aug'09, Nov'05-Apr'06, Tech business Data/DW/CRM Analyst Westpac Bank multiple assignments
Apr'01-Sep'02, Feb-Aug'98, Dec'87-Sep'88 DWarehouse Analyst/Dev/QA St George Bank(part of WBC)
Westpac/St.George Capability Delivery BI/insights MyBank Digital Transformation/Migration for branch(OTC) customer behaviour, with Teradata/SAS EG solution integrated with MyBank insights & BI tool from Intilecta as Sen. Analyst.
Treasury Transfer Pricing Replacement, legacy systems OracleFSA→SqlServer Common Data Model (CDM) architecture. ▪ Data collection from Asset & Liability Mgmt Transfer Pricing(TP) fed to key Mgmt systems (Interest Rate Risk) & compliance reports sent to regulators (APRA).
▪ Accurate mapping TP & Cost of Funds for decisions on BUnit strategies (which products to market at what price)
▪ CDM (MDM) of Treasury Balance Sheet enriched with more granularity for other systems (Liquidity Risk Reporting)
▪ Data Profiling, review/recommend sources, gap/impact analysis, cleansing, document schema from legacy systems
▪ Enrichment to ALMPROD from Rapid Maps & Data Junction business rules logic (Oracle Financials), Loans, Derivatives(Murex)
▪ Data Quality business rules ▪ Master Data Management, Consolidation, Reconciliation of 'As Is' vs 'To Be' models/GL
BI/DW: Enterprise/Finance Data Warehouse ETL quality migrations in areas of: Debtor, Sas Credit Risk(crms)/ Scoring, Collections, Loans, Gen.Insurance, Provisioning, Superannuation(from Composer), Bonds, Data Integrity/Lineage/Security.
▪ Master Data Management/Governance, deDup, Informatica, Visio/Erwin, Unix, Excel/VB , Teradata, solving complex issues
CRM, Reach: Customer Intelligence/Analytics, Marketing campaigns/ insights
▪ Collaborate with business Campaign Managers to build & execute marketing campaigns (out/inbound) & measure positive outcomes. eg. Next Best offer, Wealth Service Offer, Home Loans, Term Deposits, BPay, Equipment Finance
▪ Data extracts of cross channel customer/business/agribusiness/institutional segment product
▪ Interpreting marketing customer selection criteria & translate into data specifications. Single view of customer
▪ Analyse & present results to cross-functional marketing teams. Statistical analysis & campaign evaluation
▪ Cleanse/Transform/format/build data (structures) to feed into subsequent CRM direct marketing processes
▪ Advanced SQL (complex exclusions), direct mail, e-mail, inserts ad hoc analysis
▪ Data consolidation of multiple/external sources. QA post implementation review of campaigns
▪ Support team in sharing best practice. Recommendations for business campaign improvements. SAS DataFlux DQ/integration/MDM eval.
St.George: TeraData warehouse Customer special projects, GIS, Cobol JCL Rexx
▪ Data & business analysis, modelling, architecture, implementation of a successful solution that supports customer management process by providing customer behavioural scores strategies to core systems. Business liaison/workshops, meta data dictionary.
▪ CRM, auto Credit Risk (Experian) scoring, customer performance recognition, insights & operational efficiencies.
▪ Data mining/validation/Datamarts produced for scorecard modelling, customer segmentation daily/monthly sourcing/mapping for scorecard engine strategy manager. Detailed Functional Specs, context diagrams.
▪ Logical Data Model, ETL extract procedures. Performed complex restores from degraded archives for analytics
▪ Portfolio management reporting for Group Credit Risk, monitor Balance Sheet portfolio of Loan & automation
▪ Exposures (inc. commercial accounts obligor group exposures). Mapping from gold bronze (non ETL) data
▪ Advanced DW SQL/BTEQ OLAP functions. SDLC Quality deliverables, Metadata docs, Visio, MVS/Unix, XLS/VBa.
Collections Commercial Bills, Sen Analyst Developer, Info management
▪ Major conversion/test/support of a generic customised complex Collection System over several releases Cobol, CICS
▪ Customised interfaces to Trading Bank & Mortgage Systems. Bank of Melbourne integration interfaces, PL/1.
Retail Banking Analyst Dev. reports. File transmissions via Net/Master& ACF2 security
▪ Performance tuning, analysis, statistical reporting from Info/Configuration/Change Management. Disaster recovery procs.
Jul 2010 – Aug 2012 Business Data Migration specialist BA, Litigation Support Sys, FTI Ringtail Legal, ASIC Evidence Mgmt
Migrated numerous DBs to Ringtail e-Discovery case management & document review Web/Cloud based system via SQL Server customisable DBMS collaboration with business stakeholders. Eliciting business requirements/workshops with agile approach.
▪ Custom extended with Tracker/Hyperlinker & numerous databases with varying size/complexity were curated & migrated
▪ Design, Extract, Cleanse, Enhance, Load, Data Quality/governance from Powerbuilder/Sybase Litigation Support System.
▪ Various Reports, prototypes & comprehensive Testing for quality results.
▪ Created & documented procedures/algorithms, data flow diagram, collate/split databases. Handover doc.
▪ Used SSIS/tSQL stored procedures/Access/Excel/VBa, Objective Enterprise content/collaboration management.
2007 –2010 ETL QA Sen QA/Business/Data integration Analyst: Lloyds International;
CBA-CommBank Finance/Group Risk; RGA- ReInsurance Group America
Lloyds Data Migrated CFAL, BOSI & Treasury. Credit Risk Grading SAS interface, FX Rates, Basel, Hyperion ,XML feeds.
▪ Robust agile enterprise ETL ssIS/rs framework, utilised across various integrations/components of large Catalyst Program. Uri Alassov, Nigel Bates, Chris Suter, Vitaliy Shurapey, Dimitar Popov, Dimitar Berberu, Data specialist, Jenny Waugh, Hugh Madden, Michael Ewald, Jai Dhandapani, Brent Ombler, William Wenkart
CBA System/Data testing in Credit Risk Analytics & Reporting of FinStudio package. Beryl Seckington
▪ Data quality/transformations of Risk weighted assets/capital adequacy in Global Market Transactions for Basel II reporting
▪ QA of CommSee ETL infoSphere DataStage Loads into Teradata GDataWarehouse for a dozen subject areas provided leadership guidance to the QA/Data solution team
▪ Used SQL Server, Oracle, Teradata, Toad, Quality Center, Visio, DataStage
RGA Administration Common Data Format B2B data structure integration. Analyse/convert/migrate disparate client data consolidated with MS Access/VBa for financial analysis & reconciliation against contractual agreements/actuarial.
▪ Development of in-house ETL/ EDI(Electronic data interchange) system, replacing Informatica using Oracle, pl/SQL, ms Excel/Access/VBa, MS SQL server for parallel deployments into their Asian Pacific offices for analytical re-insurance portfolios.
2007 –2008, oct'93/sep94 Technical business Analyst; Consultant Energy Australia; Sydney Electricity
Energy Australia: Data QA/System test migration to midrange DB2 v9 Metering Business System
▪ complex DB2, C system with over 570 normalised tables/ Control-M mainframe jobs
▪ Data extraction/Quality, analysis reporting/reconciliation to SAP Utilities Billing, Customer Care System, Project Accounting. Evaluation use of query tools (Toad data analysis, Parallon QiD, Excel, Access, Unix)