Arshad Merchant

Arshad Merchant

Project Manager/ Scrum Master
Canada

نبذة عني

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…

الخبرة

Data Engineer

Suntechpros
Oct 2023 - حتى الآن · 3 سنوات

- 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 سنوات 8 أشهر

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

Onsite Project Manager

Pharmaceutical Product development, Morrisville
Mar 2019 - Dec 2019 · 9 أشهر

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

Offshore delivery lead/Project manager

DaVita, Mumbai
Jan 2016 - Feb 2019 · 3 سنوات 1 شهر

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

ETL developer

GE - Mumbai
Aug 2011 - Dec 2015 · 4 سنوات 4 أشهر

<p>Worked as a Data Modeler and was responsible for creating the model for different subject areas of FLEET<br>
Presided over the Data Architecture review calls to ensure the design was given a sign off for further development<br>
Created DDL scripts for implementing Data Modeling changes<br>
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<br>
Created the database design structure and ETL mapping specifications<br>
Responsible for determining the load strategy based on the source data analysis<br>
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<br>
Was the direct point of contact for the QA team (external vendor) for all subject area related queries and observations<br>
Worked with the reporting team to create the reporting wireframes<br>
To assist the business in making better decisions, develop and analyze essential reports<br>
Created bteqs to load the data from the EDW to AWS layer for reporting</p>

Application and Database developer

John Hancock, Boston
Mar 2008 - May 2009 · 1 سنة 2 أشهر

<p>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<br>
Participate in meetings to come up with new performance test scenarios<br>
Involved in creating test strategies, writing test plans, estimating test efforts, managing test efforts<br>
Fixing issues related to SQL, PI/SQL, SAP BW and escalating the code and data issues to functional teams<br>
Create Requirements using Quality center and generate traceability Matrices to ensure that all the requirements are covered by test cases</p>

Application developer

OPAL, Mumbai
Mar 2006 - Feb 2008 · 1 سنة 11 أشهر

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

Business Objects report writer

Client: Citibank, Mumbai
Mar 2004 - Feb 2006 · 1 سنة 11 أشهر

<p>Analyzed and translated Functional Specifications and Change Requests into Technical Specifications for report creation<br>
Ran SQL queries for data validation and performed quality analysis on data extracts to ensure data quality and integrity across various database systems<br>
Responsible for defining the naming standards for data warehouse<br>
Involved in Data mapping specifications to create and execute detailed system test plans<br>
Responsible for creating new FlexCube reports and making changes to the existing one<br>
Responsible for making changes to the Business Objects universe design<br>
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</p>

المهارات

البيانات الضخمة مستودع البيانات هادوب (Hadoop) سكالا سبارك أباتشي هايف أباتشي بيغ خدمات أمازون ويب (AWS) كافكا نوسكيو إل ردشفت (خدمة قاعدة بيانات) إس 3 (خدمة تخزين البيانات على الإنترنت) 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
الإبلاغ عن هذا الملف الشخصي؟