Experience

Housemark

• Australia
• Real Estate
• 1 - 100 Employee

• Data Developer

  • May 2021 - Mar 2022

  I was on a fixed term contract. The database technology used was SQL server and SSIS. I was responsible for adding new information to the current data-warehouse, refreshing database environments with recent data from live environments. I produced database extracts for the business as required. I ran reports for customers as and when required. I investigated data issues in the warehouse. Various documents were produced to document the processes of the data-warehouse for future team members. Show less



MRI Software

• United States
• Software Development
• 700 & Above Employee

• Software Engineer

  • Apr 2013 - Mar 2021

  I am developing and maintaining Stored procedures, SQL Routines. I am responsible database design and development aswell as performance tuning of our database queries. I am responsible for BI Development. I am developing and maintaining Stored procedures, SQL Routines. I am responsible database design and development aswell as performance tuning of our database queries. I am responsible for BI Development.



SG GAMING LIMITED

• United Kingdom
• IT Services and IT Consulting
• 1 - 100 Employee

• Oracle DBA Developer / Crystal Reporting / Cognos Reporting & Datawarehousing

  • Sep 2008 - Apr 2013

  I am part of the Systems Development team where I am developing using Oracle 11g r1. I am developing ETL routines in PL/SQL. My role involves developing reports in Cognos 10 BI and also using Crystal reports enterprise edition. I am developing new cognos packages using Framework Manager based on star schemas which I have designed and implemented using PL/SQL. I am responsible for all Cognos administration work. I have been maintaining stored procedures written in Microsoft SQL Server. An ETL routine has been implemented as database stored procedures and database packages. I have also used Cognos transformer to build data cubes for reporting purposes. We are currently using Toad V9. I designed and implemented reporting solutions using Cognos v10. I developed and implemented packages using Framework manager, so reporting could be created by the end users. I implemented a datawarehouse which was refreshed on a daily basis. The ETL routine used in this was written using PL/SQL on an Oracle database. I have deployed a STAR schema and designed the Fact and dimension tables so that packages could be mapped onto this schema. I also provided training to junior members of staff. I was in total charge of Cognos administration, creating and deleting users, maintaining privileges and scheduling of reports. Documentation was produced at all stages and I have covered the full system life cycle from requirements to testing / implementation. In addition to this I maintained a Cognos cube using Transformer. I have been maintaining stored procedures written in Microsoft SQL Server. I have attended the below training courses :- Cognos 8 BI (Query Studio, Report Studio, Analysis Studio) : Reading – February 2009. Cognos 8 Framework Manager : Wolverhampton - March 2010. Cognos 8 Administration : Wolverhampton - March 2010. Cognos 8 BI Transformer : Wolverhampton - March 2010. Cognos 10 Business Insight - Wolverhampton - April 2011. Show less



Capgemini

• India
• Information Services
• 1 - 100 Employee

• Datawarehouse Developer

  • Aug 2005 - Sep 2008

  I am currently working on the Inland Revenue account (ASPIRE) based in Telford as a Datawarehouse developer. I have been involved in several datawarehouse projects the main one being TPSS. My duties include developing and maintaining Business Objects universes and reports on various systems. The main ETL tools used are Informatica and PL/SQL scripts. I also have experience of Infoview. The database being used is Oracle 10g (Release 1) We are using Oracle on a Unix platform. I am developing PL/SQL & SQL routines for data loading and therefore have very strong Oracle and PL/SQL skills. Some exposure to Java and XML has also been gained. The Erwin data modeler is used as the main entity relationship modeler for schema design. Main types of Datawarehouse schemas being used are Star schema. A full understanding of Datawarehousing architecture, concepts and implementation has been gained, i.e. Datawarehouse, Data Marts and Data cleansing. As an overview, my current role involves developing and supporting Datawarehouse Extracts, Datawarehouse Loads, Data Marts and reports. Considerable experience of unix shell scripting has also been gained during this post. I have also worked in the Live Support team supporting various systems. Training courses attended :- Oracle 9i r1 : Harrogate – September 2005. Oracle Forms 10g / Reports 10g : Richmond –September 2005. Oracle 10g r2 : Reading – February 2006. Informatica Powercentre 7.2 : Reading – March 2006. Show less



Griffiths Waite

• United Kingdom
• IT System Custom Software Development
• 1 - 100 Employee

• Oracle Consultant

  • Sep 1998 - Aug 2005

  I worked for a Bespoke Oracle Consultancy. I gained several years of experience doing consultancy work in Oracle Forms / Reports and database procedure development whilst my stay at this company. I have used Oracle versions up to 9i (Release 1), Forms 9i, Reports 9i, SQL* Plus, SQL Loader and PL/SQL. This role involved creating complete applications using a variety of Oracle Developer suite products. Duties included, producing front end in Oracle Forms 9i, producing back end Oracle packages and procedures, and reports using Oracle Reports and Business Objects 6.5. I also developed and maintained reports in Cognos (PowerPlay and Impromptu) as well as designing and creating new universes using Business Objects – Designer. There was the opportunity to work on various Data Warehousing projects, which lasted about 2 years in duration. The full system life cycle on various projects was covered. Prototypes and demos for clients were often produced using a tool called Demoshield. I was also creating DTS Packages using Microsoft SQL Server 2000 and macros in Visual Basic which were used with Business Objects to create reports on the local company intranet. There was some development work, which involved using HTML and Javascripts. Occasionally I was responsible for training junior staff in Oracle Reports 6i/9i. Substantial consultancy experience was gained by working for this valuable organization. Show less



Fame Computers

• Computer and Network Security
• 1 - 100 Employee

• Analyst Programmer

  • Mar 1996 - Sep 1998

  I was responsible for the design, development and support of Financial Software written in Quick Basic. The support involved solving queries arising from the Help desk and end users. I also cross-trained to a front-end tool called USOFT which was based on an Oracle 6 back end database. There was substantial experience gained in PL/SQL, writing database stored procedures and database triggers. I worked closely with Business Analysts / Testers, which helped me, develop and implement the systems successfully. Some tasks involved producing specifications and technical documentation. In this role, I gained considerable Life and Pensions experience as well as Oracle PL/SQL experience. Show less