Dania Greer Email & Phone Number

Analyse and build target lists for mandatory communications to customers from initial specifications to final deliverables using SQL and SAS from the IBM mainframe platform Build on-demand data extracts from the corporate data warehouse from fixed, mobile and Internet data using the Teradata query toolkit and SQLContribute to requirements definition and design reviews of the new Enterprise Data Warehouse (EDW) feeding Siebel-based data into a Teradata platformConvert legacy DW… Show more Analyse and build target lists for mandatory communications to customers from initial specifications to final deliverables using SQL and SAS from the IBM mainframe platform Build on-demand data extracts from the corporate data warehouse from fixed, mobile and Internet data using the Teradata query toolkit and SQLContribute to requirements definition and design reviews of the new Enterprise Data Warehouse (EDW) feeding Siebel-based data into a Teradata platformConvert legacy DW extract programmes to use the EDW holdings for migrated customer accounts, including validation of data against the legacy data warehouse contentsServe as a source of knowledge and mentor for other data warehouse users Ensure that regulatory and "customer care" considerations are met in data extract construction (e.g., identifying Privacy Opt-out and Braille-using customers for special handling)Consistently meet deadlines for highly complex data extracts while ensuring minimal flaws in selecting and allocating target sets of customers Achievements:Received "Reward and Recognition" award for a project to move approximately 500,000 customers into a single-bill structure prior to migrating them onto the new customer accounting platformPart of project team nominated for an achievement award for customer pre-migration initiatives Part of project team for migrating from a sales and marketing query system which (1) generated savings through reduced hardware and software licensing costs and (2) smoothed the users' transition to using the corporate data warehouse. Show less

Contracted to Telstra to perform the same job functions as described above prior to the position being made permanentAchievements:Adapted the original existing marketing list generation process to provide support for new business structures Converted extract and data construction processes from VSAM and flat files to use the new data warehouse dataLiaised with external vendors to document and resolve data quality problems encountered with the new data warehouse holdings

Contracted to work for a variety of clients including; ANZ Bank - technical support of a package to generate home loan offer letters for non-standard loans, including modifications to comply with the credit code requirements and to capture an audit trail of interim calculations.IBM-GSA - mainframe capacity projects for Telstra including modeling tape drive utilization by hour and implementation of higher capacity tape devicesTelstra (mainframe performance management team) -… Show more Contracted to work for a variety of clients including; ANZ Bank - technical support of a package to generate home loan offer letters for non-standard loans, including modifications to comply with the credit code requirements and to capture an audit trail of interim calculations.IBM-GSA - mainframe capacity projects for Telstra including modeling tape drive utilization by hour and implementation of higher capacity tape devicesTelstra (mainframe performance management team) - investigation and resolution of incidents of perceived poor computer system performanceUnited Energy Ltd - maintained model of annual Master Vesting Contract forecasts; built managerial KPI achievement measurement system Show less