I am a senior Data warehouse Architect with over 12 years experience in Data warehouse
Design,ETL Development, Report Authoring using MSBI and Cognos also a Certified Cognos
Developer.
As a Data Analyst responsible for Analysis using SPSS, Design, Develop, Test and Implement ETL
(Extract, Transform, Load) solutions for our Clients.
Job involves skills on SQL, PL\SQL, Statistics, and ETL tools like Datastage,
Informatica, DTS.
Tech well aware of - MYSQL, MSSQL, PHP, Oracle,BD2,Cognos 8,10,10.2 and MSBI.
An experienced Cognos Professional with database programming and administration skills
across both MS SQL and Business Intelligence Development and Maintenance. Having the
ability to take the technical lead in projects and supporting technical implementation
whilst working on multiple products.
Databases: SQL server, Oracle, My SQL, Postgres, SQL, PL-SQL
Reporting: IBM Cognos, Microstrategy
Others: Macros, Scripts and Stored Procedures,SSAS(Cube),SSIS
I am expert in data analysis using R,SAS,SPSS, STATA,, Eviews, Minitab and excel. Please, give me an opportunity to work for you and deliver the best.
I am responsible for the Design and the Development of the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2.
The database is being updated daily from the core system via SSIS and a numerous of KPIS are being daily updated during the ETL.
For performance reasons the KPIS are replicated to another DB which exploits the report