Arshad Merchant

Arshad Merchant

Project Manager/ Scrum Master
Canada

About Me

Around 20 years of experience as a ETL and BI architect and manager having worked on various Etl and BI reporting tools
Responsible for successful implementation of the SDLC and delivery of the final product
Managed a t…

Experience

Data Engineer

Suntechpros
Oct 2023 - Present · 2 years 9 months

- Develop pipelines to move data from on premise to cloud
- Develop pipelines to move data from on premise to cloud
-Create the database structure in cloud and then unit test the data post load
-Create the database structure in cloud and then unit test the data post load

Project Manager/ Scrum Master

Mayo Clinic, Rochester
Jan 2020 - Sep 2024 · 4 years 8 months

Work with the business analyst and end user for requirement gathering
Create datasets from EPIC clarity database based on the requirement provided
Perform unit testing of the prepared SQLs and VQLs and ensure they meet the business requirement
Create Tableau visuals using the virtualization layer of Denodo
Develop, design, and maintain Tableau dashboards and analytics
Collect, refine, and prepare data for analytics and visualization
Manage and utilize the Tableau platform to extract meaningful insights from it
Define new KPIs and consistently measure in the datasets
Drill-down data and prepare reports with utmost accuracy
Creating wireframes and beta dashboards with a focus on user experience, correctness, and visibility
Monitoring reports and dashboards and make necessary changes
Solving any data or performance issues related to workbooks and data sources
Actively manage the performance and usability of Tableau to get the desired result
Developed user stories on subject areas like Workforce management and Health equity
Create adequate backlog which can be consumed by the developers over the next two sprints
Present to the management team the team utilization report

Onsite Project Manager

Pharmaceutical Product development, Morrisville
Mar 2019 - Dec 2019 · 9 months

Handled a team of 80 people from onsite
Was the sole point of contact for the client for all technical queries, resourcing and deliverables
Helped the account grow from 25 resources to 60 resources
Played a dual role of project manager and Scrum Master on the project
Involved with Data Profiling activities for new sources before creating new subject areas in warehouse
Implemented the agile methodologies for all the projects in the account
Conducted a daily standup with the team leads for 19 projects that were underway
Conducted scrum ceremonies like sprint planning, daily scrum, sprint review, backlog refinement and show n tell
Create the product backlog
Performed unit testing for the features developed

Offshore delivery lead/Project manager

DaVita, Mumbai
Jan 2016 - Feb 2019 · 3 years 1 month

Handled multiple DaVita projects handling a team of 60 people
Presided over the weekly and monthly dashboards calling out the risks and development in the project
Responsible for the optimum resource utilization and ensuring a good gross profit margin on the project
Responsible for the delivery of the project
Played the role of a Data Analyst & Business Analyst throughout the product implementation lifecycle
Analyzed the source data and accordingly created the source to target mapping specifications
Worked closely with business to understand the reporting requirements and create the wireframe design
Create the Frame Work Manager to enable the reporting needs
Performed extensive data cleansing, data manipulations and date transforms and data auditing
Created Cognos reports in the Reporting Manager based on the wireframe
Responsible for debugging the ETL job cycle errors
Made Informatica enhancements
Performed Unit testing for the ETL changes and Reporting changes
Worked closely with the QA team to overcome the issues reported by them

ETL developer

GE - Mumbai
Aug 2011 - Dec 2015 · 4 years 4 months

Worked as a Data Modeler and was responsible for creating the model for different subject areas of FLEET
Presided over the Data Architecture review calls to ensure the design was given a sign off for further development
Created DDL scripts for implementing Data Modeling changes
Worked with ETL processes to transfer/migrate data from relational database and flat files common staging tables in various formats to meaningful data in Oracle
Created the database design structure and ETL mapping specifications
Responsible for determining the load strategy based on the source data analysis
Worked closely with a team of ETL developers to ensure that the design and loading strategies were developed as per the requirement and design specifications
Was the direct point of contact for the QA team (external vendor) for all subject area related queries and observations
Worked with the reporting team to create the reporting wireframes
To assist the business in making better decisions, develop and analyze essential reports
Created bteqs to load the data from the EDW to AWS layer for reporting

Application and Database developer

John Hancock, Boston
Mar 2008 - May 2009 · 1 year 2 months

Analyzed the Business and Technical requirements by interacting with business users and developed test plan and test strategy for functional and performance testing of each phase of code modifications
Participate in meetings to come up with new performance test scenarios
Involved in creating test strategies, writing test plans, estimating test efforts, managing test efforts
Fixing issues related to SQL, PI/SQL, SAP BW and escalating the code and data issues to functional teams
Create Requirements using Quality center and generate traceability Matrices to ensure that all the requirements are covered by test cases

Application developer

OPAL, Mumbai
Mar 2006 - Feb 2008 · 1 year 11 months

Created the Technical requirement document for OPAL application
Responsible for making Informatica, database, Unix and Mainframe changes for existing OPAL correspondence jobs or adding new correspondence to the existing OPAL application
Tested the ETL process for both before data validation and after data validation process
Tested the messages published by ETL tool and data loaded into various database
Added new messages to the application by creating SQL scripts
Primary point of contact for any job failures for the application

Business Objects report writer

Client: Citibank, Mumbai
Mar 2004 - Feb 2006 · 1 year 11 months

Analyzed and translated Functional Specifications and Change Requests into Technical Specifications for report creation
Ran SQL queries for data validation and performed quality analysis on data extracts to ensure data quality and integrity across various database systems
Responsible for defining the naming standards for data warehouse
Involved in Data mapping specifications to create and execute detailed system test plans
Responsible for creating new FlexCube reports and making changes to the existing one
Responsible for making changes to the Business Objects universe design
Involved in SQL Development, Unit Testing and Performance Tuning and to ensure testing issues are resolved based on using defect reports for any existing/new report

Skills

Big Data Data Repository Hadoop Scala Spark Apache Hive Apache Pig Amazon Web Services (AWS) Kafka NoSQL Redshift S3 ETL BI SDLC Agile methodology Scrum Project management Team management Mentoring Coaching Cloud migration GCP Azure SQL Server Denodo Tableau Data Fusion BigQuery Informatica PowerCenter Azure Cloud ADF ADLS Synapse JIRA Confluence Netezza Cognos GIT Flask Oracle Teradata OBIEE Java Sybase Mainframe Unix JCL Business Objects PL/SQL Collibra Data modeling Data architecture Data profiling Data cleansing Data auditing Data warehousing Unit testing Performance tuning Wireframing Dashboard development Reporting
Report this Profile?