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.

Gathering & understanding business requirements and converting them into functional specifications and technical requirements. Leading the team of 3 developers. Designed the architecture of the project. Integrated different source systems (RDBMS, flat files, SAAS based application to bigdata platform). Involved in dashboard design calls and providing the inputs to the team. Creating the shell scripts to automate the jobs using Rundeck and Oozie.

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.

Gathering & understanding business requirements and converting them into functional specifications and technical requirements. Designed and Developed Database in Teradata. Designed Database detail document for the project. Involved in preparation of ETL mapping specification document. Developed mappings in Informatica to validate the quality checks. Wrote efficient and complex SQL queries to validate the results. Created stored procedures in Teradata. Involved in UNIT testing of ETL mappings. Involved in setting up process automation through Autosys.

Gathering & understanding business requirements and converting them into functional specifications and technical requirements. Designed and Developed Database in Teradata. Involved in preparation of ETL mapping specification document. Involved in QlikView Development - Creating QVD extracts and Dashboard/report reloads. Created stored procedures in Teradata to lock or unlock or delay Autosys Jobs. Involved in UNIT testing of ETL mappings and Java application. Developed mappings in Informatica to load fact tables. Designed and created Qlikview Dashboard for ISVN and IAE modules.

Understanding the business requirements and converting them into functional specifications and technical requirements. Developed Database models in SQL Server 2008 and uploaded to Teradata using the Informatica. Implemented the ETLs using Informatica to export/import data from/to Teradata. Worked closely with Business Analysts and Marketing Officers of Home Depot to resolve the issues. Led the 5 member team and deliver the requirements on time.

Understanding the user requirements, functional specifications and technical requirements. Designed ETL packages using SSIS 2008. Involved in Database model in SQL Server 2008. Prepared test cases for the application. Involved in Unit testing.