Ray Mccormack Email & Phone Number

Dublin, Ireland

Dublin, Leinster, Ireland

Setup and populated Big Data on both Oracle Cloud and Microsoft Azure Cloud Platforms.Assisted with hiring and onboarding the Development and Sales teams in Ireland, United Kingdom, Italy and Singapore.Built and optimized data pipelines to process complex diverse big datasets from across Hutchison industries such as Telecoms (Three Ireland, Three UK, Three Austria, Three Sweden, Three Denmark, Wind Tre Italy, Three Indonesia, and Three Hong Kong), Retail (AS Watson, Superdrug and The Perfume Shop) and Utilities (Northumbrian Water, UK Power Network).Innovated with data to create sustainable data products by processing complex datasets as part of Data Monetization projects to provide real-world value, arriving at transformative insights.Designed Data Privacy and Anonymization protocols to guarantee GDPR compliant and best practice data privacy procedures in alignment with global roadmap.

Dublin, Ireland

Creation of ETL & Database project-level technical designs & documentation based on team/Fidelity best practices & standards. Assisted Project Managers with estimation and project plan creation.Lead performance evaluations and tuning activities. Performed code reviews of project ETL deliverables. Acted as a point of technical escalation and resolution for database & ETL topics during the project lifecycle using Informatica 9 on Oracle Exadata platform. Assisted Quality Assurance group with the creation and execution of test cases.

Dublin

Key member of highly skilled Business Intelligence team using OBIEE 11g for reporting, Oracle Data Integrator 11g for ELT and Embarcadero for data modeling in an Agile Scrum environment.Promoted to 'Solutions Architect'. Lead initiative to review CVs, interview and hire developers for offshore team based in Chennai, India. Spent weeks in Chennai inducting and training new team on best practices.Conducted weekly design meetings with developers both in Dublin and Chennai to review work and assist with development issues.Taught ‘Oracle Data Integrator (ODI) 11g’ 1 week training course to new developers. Sourced data from disparate systems including SQL Server, Oracle, PeopleSoft and Excel to implement an Enterprise Data Warehouse using Inmon methodology feeding into a Star Schema designed Data Mart using Dimensional modeling’s best practices.Implemented complex ETL solutions using Hierarchy bridge table, numerous transaction, aggregate and accumulating Facts, slowly changing (Type 2), mini and conformed Dimensions, KPIs and analytic functions.Helped estimate Scrum stories, tasks and define quarterly release plan scope. Regularly produced high quality OBIEE reports, containing Scorecards, KPIs, maps, and bridge table functionality.Monitoring of nightly scheduled ETL load to optimize ETL process whilst ensuring data accuracy and integrity.Architected best practice documents such as development guidelines and standards, code review checklist, technical specification and deployment procedure. Large involvement with integration projects to provide sponsor data in XML format using defined XSDs. Customised ‘Data Lineage’ solution with metadata from Embarcadero, ODI, OBIEE's RPD and Catalog. Extended OBIEE ‘Usage Tracking’ solution to provide more data points on user interaction with the reporting solution.

Greater San Diego Area

Team Lead of the reporting team where tasks included defining the University's reporting strategy, hiring staff, developing reports in Cognos Report Studio, enhancing the Operational Data Store by deploying new ETL packages to the Framework Manager, training business users in Cognos Query Studio and successfully upgrading to Cognos 8. Actively provided support for Oracle Discoverer and Noetix reporting. Created ‘High Availability’ strategy to improve monitoring of critical systems. Setup Oracle Grid Control with alerts created to notify key people when issues occurred.Primary programmer responsible for Admissions, Financial Aid and Registration modules during the implementing of SunGard’s Banner Student System.Wrote interfaces using PL/SQL Web Toolkit and Banner API’s to interface vendor applications such as campus card system and library systems. Greatly improved data quality by implementing Clean Address to cleanse data to improve productivity and lower cost of maintenance.Managed teams to implement products such as ‘Xtender Imaging’, ‘Mobile Applications’ and ’Enrollment Management’ on schedule and within budget.Programmed mobile websites for iPhone, Blackberry, Android using HTML, CSS, JavaScript, JQuery, JQTouch and PhoneGap. Lead the implementation, marketing and launch of USD's native mobile application suite (mySDmobile) catering for iPhone, Blackberry and smart phones.

Dublin

Provided end-user support for Oracle 11i E-Business Suite Order Management, Manufacturing, Sales and Marketing modules.Active member in huge year long project to consolidate two Production instances spread across continents into one Multi-Org Unicode structured environment.Analyzed end-user requirements and converted their business needs into solutions by working extensively on new Oracle Reports, Workflows, Alerts, PL/SQL, Form customizations and modifications to the Custom.pll library.Performed DBA duties such as fine tuning poor performing SQL queries and installing and testing Patches on a regular basis.Wrote UNIX shell scripts to support automated transfers of data between heterogeneous systems.

Greater San Diego Area

Helped implement Oracle E-Business Suite (Human Resources, Payroll and Admissions) and become first US College to go live with Oracle 11i Admissions system. Designed and constructed a Data Warehouse (Star Schema) using Oracle Warehouse Builder to bolster the capacity to integrate and present summary student data from disparate systems.Worked with Discoverer Administrator to create reports and maintain End User Layers to define departmental security.Created high quality Oracle Reports and Forms as per user requirements.Customized Oracle CRM JSP’s using PL/SQL TCA API’s to create upload information.Designed and implemented an online Financial Aid application using Application Express residing on Oracle Portal.

Certificate, Data Science Pipeline And Critical Thinking

B.S., Computer Applications

Activities and Societies: Computer Network Society.