project, framework, analysis, oltp, datastage, server, data stage, logging, data structure, analytics, microstrategy, strategy, sql server, sql, olap, estimation, reports, data warehouse, etl, design, ods, database, pos, dashboards, data structures, db2, planning, bi
Rogue Community College
Responsible for the data warehouse and analytics and reporting solutions. Designed and developed the data model and the ETL process for the application.
Responsible for the development of a new data model for the Oracle application to support the business Intelligence and data warehouse.
Design and develop data warehouse solutions using SQL, Query, and query Analyzer. The Kimball methodology was used to perform analysis and report generation.
Worked with offshore team to develop and implement data warehouse solutions. Developed and implemented the framework for the data mart.
Responsible for the development of the data warehouse and Informatica Server monitoring. Developed and implemented the process for the new business intelligence.
Involved in the development of the data warehouse and business objects. This includes the creation of the new tables, views, materialized views, indexes, and functions.
Senior DataStage Developer
Designed and developed the OLAP cubes for the OLTP system and used IBM DB2 for data warehouse design and reporting.
Designed and developed the OLAP cubes for the project using IBM DB2 and Teradata. Involved in troubleshooting of ETL process and reports.
Design and development of data warehouse framework for reporting and analysis of data from various sources like OLTP, OLAP, and RDBMS using Erwin.
Involved in the planning and development of the OLAP cubes and data marts using Informatica Power Center. Designed and developed the ETL process to extract the data from various sources like flat files, relational databases.
Created the dimensional model for the OLAP system using Erwin tool for the ETL process. Used Star schema to load data into the relational databases.
Developed the data mart for the OLAP cubes using Informatica Power Center. Created and maintained the ETL jobs to extract the data from the source systems.