test, test plans, oracle 11g, oracle, informatica, ibm, cognos, ibm cognos, electronics, qa, financial services, etl, retail, etl testing, clients, integration testing, erwin, tableau, testing, data integration, systems engineer, customer service, test plan, credit, design, data warehouse, credit ca
Involved in the analysis of the data warehouse and data mart. Worked with the business Intelligence team to design and develop the ETL process for the organization.
Responsible for the research and analysis of the data analytics and reporting tools in the EDW and in the production environment using SAS/SQL, SAS, and Tableau.
Worked with the data management team to design and develop a new data mart for the organization. The primary objective of the development of the analytics, analytical reports, and predictive analytics.
Experience in writing data analysis, design, development, testing, and implementation of SAS/SQL and Hadoop Hive tables, and BTEQ scripts to improve the performance of the organization.
Writing and maintaining the data model and the design of the BI Publisher reports and dashboards for the organization. Responsible for the research and analysis of the SAS/SQL.
Worked with the business Intelligence team to design and develop data models, reports, and dashboards for the organization.
Worked on ETL and data warehousing projects for the business Intelligence and BI reports. Performed the analysis of the data from the SAP system.
Created ETL test scripts for the data warehouse and performed unit testing and system testing of the Informatica reports. This includes the implementation of the Cognos BI tool.
Involved in the analysis, design, development, testing, and implementation of the ETL process using IBM Cognos.
Oracle Application: Designed and developed a data warehouse for the financial system for the bank. Worked with the business users to develop the reports for the credit card transactions.
The data Warehouse: This includes the creation of the new tables, and the implementation of the testing of the reports.
Provided technical support for the ETL development team for the data warehousing, including the creation of test plans, test scripts, testing, and troubleshooting of the reports.