Hi,
My recent work includes ERP and DWH.. In this project I integrate more than 300+ systems from multiple OLTPs like Oracle,SQL, MySql, DB2 into one common platform and write my own SQL custom base CDC inform of procedure, SSIS packages and procedure to complete this task...and this custom SSIS and procedure will continusily fetch data incrementally on daily basis..
I have total 11 plus years of experience especially in Development, DWH, ETL, SSIS, SQA, Database development & maintenance.
• Very strong in Open Interfaces, SQL, PL/SQL, Stored procedures/packages, writing Test Scripts, Windows/Linux environment and both back-end database development and front-end development.
Business Intelligence & ETL consultant with sound experience in end to end BI implementation. Sound experience in logical & physical modeling of semantic layer, reports and dashboard development in various BI tools like MicroStrategy, Microsoft Excel, Tableau, Power BI. Developed Powerful ETL Using PDI (Pentaho Data Integration). Good knowledge of Big Data Analytic s having worked and successfully delivered on Sentiment prediction of Social Data set. • Business Analysis and Requirement Gathering • Effort Estimation and Planning • Solution Design and Architecture • Logical and Physical Data Modeling (Semantic & Core) • Reports and Dashboard Design and Development • Advance Analytics and Big Data…