Arshad Merchant

About Arshad Merchant

Around 20 years of experience in the field of Data Warehousing, last 8 years have been working in the healthcare domain • Worked extensively on Infromatica PowerCenter and visualization tools like Tableau, Cognos and Business Objects • Define and steward the Enterprise Data Lifecycle Management including data quality, data conversion, and data security technologies • Experience in Analysis, Design, Development, Management, and Implementation of various standalone and client-server architecture-based enterprise application software. • Coordinate with BI analysts to understand business and reporting requirements to translate these needs into efficient data models (logical and physical), and lead the development of Integration, extraction, and transformation processes between operational systems and the DW • Good experience in developing ETL mappings, BI reports and database changes. • Perform database performance tuning, application performance tuning, workload management, application architecture • Hands on experience in SQL and PL/SQL and writing stored procedures • Database Development ­ Loading/Unloading ­ External tables, table distribution, skew detection/remediation, optimizing query plans • Develop, implement, and maintain data models and database designs to build data warehouses related to subject areas to share and disseminate data throughout the enterprise • Analyze business/functional requirements, review the solution architecture, and develop the technical architecture and detailed design • Analyze data issues, identify and articulate the business impact of data problems • Perform code reviews and ensure that all solutions are aligned to pre-defined architectural standards, guidelines, best practices, and meet quality standards • Understand and comply with the established software development life cycle methodology • Utilize subject matter expertise in area of enterprise applications, solutions to evaluate complex, sensitive business problems and architect technical solutions • Keep current with industry technologies and tools in the integration domain

Experience

1. Senior Consultant

   CitiusTech

   Jan 2016 — Present

   Define & design ETL framework for Data Warehouse & Business Intelligence Application.• Working with Business analysts to understand the requirements & translate to technical design.• Provide estimations of the deliverables.• Ensuring quality & implementing best practices in ETL and Reporting.• Working on Performance optimization on ETL & database related components.• Lead the team of developers, worked as liaison between client & senior management.• Work on the virtualization layer of Denodo• Responsible for end to end Tableau development• Being accountable for the deliveries being done.

Education

• Bangalore University

  MCA

  2000 — 2003