As the Oracle Technical Application Lead I serve as a subject matter expert and take responsibility for the research, design and implementation of Oracle data warehouse technology for the Coles Group. I have lead the following projects: o PPB LCM (Sales Data) HP-DB (11g) – AIXo CIW Migration 10g – Oracle Exadatao COL (Coles On-line Operation Reporting)/Project Orange with DataStageo CIW Migration 9i – 10g (Database)o COL (Coles On-line Operation Reporting)/Project Orange legacy in 2008o Customer Information Warehouse support o Sales Data Warehouse Support Determine all system and business functions to be monitored and create processes for identification, correction and escalation.Ensure High Availability: Grid, Cluster, monitor system and data changes, proactive monitoring of table spaces, backup, restore, refresh, bottlenecks, load balancing and design disaster recovery plans.Drive and deliver technical specifications (High Level Design / Low Level Design)Work with function leads/stakeholders to define and update master data maintenance and quality processesContribute to the development of end-to-end solutions that deliver capabilities to the enterprise.Coach and mentor team membersAnalyse enterprise business drivers to determine corresponding change requirementsEvaluate market trends and identify prospective impact on businessMaintain database scripts from creation, build, migration and maintenance

Environment: C#, ASP.NET, HTML, JavaScript, VB Script, IIS, Sql Server 2000Platform: Windows 2000Perform requirement study, design and analysisCreate and execute designs for small sets of new functionality as part of software projectConvey knowledge on concepts to Replenishment Planning to offshore team.Extensively engaged in writing PL/SQL batch.Coding and Preparing schedules & test plansConduct TestingConfiguration Controller for VSS Nullify defects, troubleshoot and provide technical and business support to downstream systemsServe as a mentor to less experienced software engineers

Environment: VB.Net, ASP.NET, HTML, JavaScript, VB Script, IIS, SQL Server 2000Platform: Windows 2000Determine operational feasibility by evaluating analysis, problem definition, requirements, solution development and proposed solutions.Document and demonstrate solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code.Prepare and install solutions by determining and designing system specifications, standards and programming.Improve operations by conducting systems analysis; recommending changes in policies and procedures

Environment: VB.Net, ASP.NET, HTML, JavaScript, VB Script, IIS, SQL Server2000Platform: Windows 2000Perform rapid-prototyping to support functional requirement developmentDeep dive analysis improving hardware and software interfacesDevelop automated test software for software testingParticipate in program review meetings, interface studies, design reviewsWrite low level designs and conduct system testingReview current systemsPresent ideas for system improvements, including cost proposalsWorking closely with analysts, designers and staffTest product in controlled, real situations before going live