We are building centralized datalake by integrating multiple source systems like SAP, SAP HANA, JDE, SQL Server, Oracle and SAAS based applications into data lake.

Building centralized data warehouse for enterprise or organization level.

Building different certified data sets or integration views for different business units based on the requirement.

Involved in entire life cycle of the project from gathering the requirements to production support.

Designed the architecture of the project including data integration, data modelling and data visualization.

We are building centralized datalake by integrating multiple source systems like SQL Server, Oracle, flatfiles and SAAS based applications into data lake.

Building centralized data warehouse for enterprise or organization level.

Involved in entire life cycle of the project from gathering the requirements to production support.

Recovered and saved the cost of more than 100Mn in enterprise.

▪ Gathering & understanding business requirements and converting them into functional specifications and technical requirements.

▪ Involved in preparation of ETL mapping specification document.

▪ Involved in migrating tasks from SAP HANA to Hadoop (Cloudera).

▪ Involved in productivity through automation (Rundeck) and process improvement.

▪ Involved in Extracting, Transforming and Loading data from different source systems.

▪ Involved in providing SAP Audit results to corporate audit team.

▪ Involved and provided results for various Data desk activities.

▪ Gathering & understanding business requirements and converting them into functional specifications and technical requirements.

▪ Involved in preparation of ETL mapping specification document.

▪ Creating data model in Greenplum & QlikView.

▪ Working experience with mapplets and mappings using different transformations like Expression, Lookup, Filter, Router, Union, Aggregator, Joiner, Update Strategy, Sequence generator

▪ Created Dashboard using different components of QlikView like List boxes, Multi boxes, slider, and buttons, Input Box and charts (Bar, Line, Combo, Scatter, Pie and Straight/Pivot table) etc.

▪ Experience in working with QlikView Functions.

▪ Involved in Extracting, Transforming and Loading data from different data source.

▪ Different ETL script statements like Resident, Concatenate, Join, Keep, Mapping Load, etc.

▪ I was leading the Data Analytics and Reporting Team of Five members.

▪ Gathering & understanding business requirements and converting them into functional specifications and technical requirements.

▪ Expertise in Informatica & Data warehousing, Database design, Performance Tuning.

▪ Involved in preparation of ETL mapping specification document.

▪ Integration of Apache Sqoop, HDFS with Hive and Greenplum.

▪ Identification and designing systems & reports for Decision Analytics derived out of structured and unstructured data.

▪ Involved in leveraging Open-source technologies to reduce the cost of operation and improving efficiency.