• Overall 9+ years of experience in Pentaho,Tableau, Oracle, PostgreSQL, MySQL, SQL Server, Dot Net, Java, SSRS, Groovy.
• Performed various roles such as Software Developer, Module Lead, Technical Analyst and Business Analyst.
• Extensive experience in working on OLTP systems.
• Extensive experience in writing complex SQL queries and PL/SQL objects (stored procedures, functions, views, triggers).
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Data Modeling, and Creating ER Diagrams.
• Proficient in using Pentaho Data Integration (PDI) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing.
• Hands on experience with Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables.
• Expertise in preparing report specifications and database designs to support reporting requirements.