Mohammad Rehan Email and Phone Number

Having 5+ years of experience in ETL/Data-warehouse. I have experience in BigData, HDFS, Hive and Scoop. Expertise in writing queries in Oracle, MySQL. I am able to work on different source systems like Oracle, MongoDB, TBA,PEGA,MySQL Database and Flat Files as well. Proficient in Test Documentation and Test Management Tools like HP ALM, HP QC, JIRA. I have extensive experience in data-warehouse concepts like Schemas, Fact and Dimension table. I have good experience in STLC viz. Sanity, Smoke, System, Integration and Regression Testing. Closely worked with Development and BA teams while delivering projects in Insurance & Health domain. Working in BOLD from last 1+ years writing data validation scripts using Unix Shell Scripting. Also,validating the shell scripts that processed the data from different sources and load into the reporting tables and data warehouse.TECHNICAL PROFFICIENCY :• RDBMS: Oracle 11g, MS-SQL Server 12.0, IBM DB2, TOAD• Scripting : Unix Shell Scripting• Hadoop: HDFS, Hive, Impala, Scoop, Spark, Kudu• Testing Profficiency: Database testing, ETL testing and Big data testing,OBIEE reports testing, Cognos Report Testing• Test Management Tool : HP ALM, JIRA• ETL Tool: Infromatica, Lite Tool (Pentaho) • Data Automation Tool: QuerySurge• Data Optimization Tool: CTD• Processes: IBM-MetLife QIP (Quality Improvement Process)• Methodologies: Agile, SDLCCAPABILITIES : Ability to work in a team. Flexible, compatible, dependable and approachable. I enjoy working with people, as people are the greatest source of my learnings.Looking for job change. Help me if any opportunities within your knowledge.