Nirmal Ram Email and Phone Number

Responsible for Leading the team in Architecting and Designing Cloud Migration solutions for Database and BI tools. Architecting, Designing and Maintaining Data warehouse and Business intelligence solutions using Netezza , Informatica, Cognos Analytics, Db2 Warehouse on Cloud.Architecting and Designing Data flow solutions using snaplogic ETL and Apache NifiInterviewing and building new team members and mentoring them.

• Leading the team handling New Developments, Change Requests, Incidents in both DW & BI Area and supporting the existing data warehouse system.• Responsible for bringing in collaboration tools like Slack, Mural and Trello for the entire account.• Leading the team in Automation activities using shell scripts and Automation tools.• Responsible for Building end to end reporting solution for multiple subject areas.• Leading the team in QA activities.• Responsible for building Cognos Data Model and for performance tuning of report queries.• Responsible for leading the team in Reporting data migration to cloud.• Executed POC projects Cloud Datawarehouse like Db2Whoc & Snowflake. • Responsible for daily, weekly and monthly batch job and failure support • Responsible for data analysis, unit testing, integration testing.• Responsible for configuration management of all the application specific deliverables.• SPOC for all network related issues in the project.• Responsible for training new team members on business aspects of the application as well as technical aspects.

Leading the team handling New Developments, Change Requests, Incidents in both DW & BI Area and support / Maintenance of the Marriott data warehouse application.

Member of the data warehousing and business intelligence team for the system built for SEBI that will be useful in querying large amount of data to get the desired results and reports in most efficient way.

My roles and responsibilities include creation of etl environment for loading of the data from heterogeneous data sources and writing of SQL, PL/SQL queries and Unix shell scripts in order to assist in the same.