Milind Chavda

My name is Milind and I am an enthusiastic professional with a passion for data and business analysis. I am experienced in conducting research, monitoring records for accuracy, and organizing multiple data sources.

I am also technically proficient in multiple tools and technologies such as SQL, Excel, and Tableau. I have hands-on experience with Microsoft SQL Server.

During my career, I have consistently exhibited analytical expertise in assembling, analyzing, and auditing complex data. I am also adept at delivering comprehensive presentations of data findings and distributing qualitative and quantitative reports. I am an articulate communicator, with expertise in building client relationships and providing consultative services.

Connect with me today to acquire a better understanding of my skill set and to find out how I can help to bring your objectives into focus!

Company: Omicron Pharmaceutical

Gujarat, India

May 2015 – August 2022

Role: Technical Business Analyst

Responsibilities:

• Prepared BRD (Business Requirement Document) to translate business needs to build and design reporting solutions (metric management, dashboards, enterprise performance management).
• Act as liaison with Product Managers to understand the impacts of tech enabler backlog items and interlay these with the overall Product Backlog. 
• Collaborate with Product Managers to understand requirements and author Epics, Minimum Business Increments and Features and gather approval on the requirement as authored.
• Performed data modelling exercise to migrate data between oracle to hive DB. Creates data flow diagrams using visio as part of data modelling.
• Maintain JIRA with appropriately detailed specifications and Acceptance Criteria for business enablement, technology enablement and tech features so that they are clearly understood by the development teams.
• Provided decision-support to client in pharmaceutical industry, by exploring data, building reports, and presenting findings using SQL and Tableau.
• Interpreted results of analyses, identified trends and issues (forecasting), and developed alternatives to support business objectives to reduce operational cost.
• Ensure the core processes are followed and hold teams accountable to the deliverables required of each phase to promote consistent, transparent, and quality results.
• Develop and manage business relationships with senior leaders and executive-level management across the organization.
• Oversee the development deliverables, particularly data and source to target mapping.
• Work with development managers and their lead SMEs to ensure we understand what backlog items needs to be addressed to ensure team maintains data quality.
• Worked on to improve data literacy across the organization and focus on improving the ability to access data & to understand potential insights from data.
• Used PMI project management methodologies, tools, and techniques to enhance the productivity of Project.
• Supported, followed, and contributed to information governance, architect data integration, master data solutions and data standards established by the organization. 
• Built and maintained workflows for data governance and management processes using Collibra.
• Troubleshooted and resolved issues as they arose in the development and deployment of Collibra workflows. Created and maintained documentation for all Collibra workflows.
• Supported the implementation and adoption of target state Metadata solution using Collibra across the enterprise.
• Identify and document opportunities for improvement of data quality. Work in collaboration with decision support and clinical teams to determine root causes and business impacts.
• Planned process improvements and translated these into system change Requirements.
• Maintained prototype reports during initial business review and support finalization of Requirements for permanent reports.
• Provided weekly metrics related to KPIs (Key Performance Indicators), meeting and maintain production schedule adherence report.
• Extrapolated from individual projects and interactions to define ongoing business needs for data gathering and process governance.
• Created Data Pipeline using Pyspark framework and deployed to UAT/PROD.
• Handled in-house CRM tool to manage existing relationship with client and provided trend analysis.

Created excel metrics report using Microsoft EXCEL VBA and macros which helped the marketing team to monitor the trend in pharmaceutical industry on a daily basis.

• Company: Omicron Pharmaceutical

Gujarat, India

May 2015 – August 2022

Role: Technical Business Analyst

Responsibilities:

• Prepared BRD (Business Requirement Document) to translate business needs to build and design reporting solutions (metric management, dashboards, enterprise performance management).
• Act as liaison with Product Managers to understand the impacts of tech enabler backlog items and interlay these with the overall Product Backlog. 
• Collaborate with Product Managers to understand requirements and author Epics, Minimum Business Increments and Features and gather approval on the requirement as authored.
• Performed data modelling exercise to migrate data between oracle to hive DB. Creates data flow diagrams using visio as part of data modelling.
• Maintain JIRA with appropriately detailed specifications and Acceptance Criteria for business enablement, technology enablement and tech features so that they are clearly understood by the development teams.
• Provided decision-support to client in pharmaceutical industry, by exploring data, building reports, and presenting findings using SQL and Tableau.
• Interpreted results of analyses, identified trends and issues (forecasting), and developed alternatives to support business objectives to reduce operational cost.
• Ensure the core processes are followed and hold teams accountable to the deliverables required of each phase to promote consistent, transparent, and quality results.
• Develop and manage business relationships with senior leaders and executive-level management across the organization.
• Oversee the development deliverables, particularly data and source to target mapping.
• Work with development managers and their lead SMEs to ensure we understand what backlog items needs to be addressed to ensure team maintains data quality.
• Worked on to improve data literacy across the organization and focus on improving the ability to access data & to understand potential insights from data.
• Used PMI project management methodologies, tools, and techniques to enhance the productivity of Project.
• Supported, followed, and contributed to information governance, architect data integration, master data solutions and data standards established by the organization. 
• Built and maintained workflows for data governance and management processes using Collibra.
• Troubleshooted and resolved issues as they arose in the development and deployment of Collibra workflows. Created and maintained documentation for all Collibra workflows.
• Supported the implementation and adoption of target state Metadata solution using Collibra across the enterprise.
• Identify and document opportunities for improvement of data quality. Work in collaboration with decision support and clinical teams to determine root causes and business impacts.
• Planned process improvements and translated these into system change Requirements.
• Maintained prototype reports during initial business review and support finalization of Requirements for permanent reports.
• Provided weekly metrics related to KPIs (Key Performance Indicators), meeting and maintain production schedule adherence report.
• Extrapolated from individual projects and interactions to define ongoing business needs for data gathering and process governance.
• Created Data Pipeline using Pyspark framework and deployed to UAT/PROD.
• Handled in-house CRM tool to manage existing relationship with client and provided trend analysis.

Created excel metrics report using Microsoft EXCEL VBA and macros which helped the marketing team to monitor the trend in pharmaceutical industry on a daily basis.