Nayaab Bhatia Email & Phone Number

Glasgow, Scotland, United Kingdom

MDM SME for establishing Data Governance for CTMS processeso Ongoing task of defining Data Governance Elements (Council, Stewardship, Processes, Standards, etc.)o Analysed as-is processes & data quality of Healthcare Organization (HCO) datao Formulating approach in alignment with business objectives to clean existing HCO data Data Architect for the Clinical System Landscapeo Defined as-is Data Lineage for critical objects and identified areas for optimizationo Lead… Show more MDM SME for establishing Data Governance for CTMS processeso Ongoing task of defining Data Governance Elements (Council, Stewardship, Processes, Standards, etc.)o Analysed as-is processes & data quality of Healthcare Organization (HCO) datao Formulating approach in alignment with business objectives to clean existing HCO data Data Architect for the Clinical System Landscapeo Defined as-is Data Lineage for critical objects and identified areas for optimizationo Lead the engagement across teams to plan & implement the improvement initiativeso Established end-to-end Identity & Access Management process for the Infrastructure team Show less

# Acted as Product Owner and delivered the below 2 products within a tight timeline of 3 months - PostgreSQL integration solution for CTMS data consumer systems - Power BI Dashboard to fulfill reporting needs of individual CTMS data users# Led various stakeholder engagement initiatives - To improve data quality of historical CTMS system prior to data migration - Execute end-user trainings on the use of Veeva Vault CTMS# Defined Data Mapping rules… Show more # Acted as Product Owner and delivered the below 2 products within a tight timeline of 3 months - PostgreSQL integration solution for CTMS data consumer systems - Power BI Dashboard to fulfill reporting needs of individual CTMS data users# Led various stakeholder engagement initiatives - To improve data quality of historical CTMS system prior to data migration - Execute end-user trainings on the use of Veeva Vault CTMS# Defined Data Mapping rules in collaboration with the client for a huge CTMS Migration project# Worked within Veeva Vault CTMS to build reports, perform data analysis, and support end users with change management Show less

Copenhagen, Capital Region Of Denmark, Denmark

Lead the Master Data Building Blocks projecto Developed SIPOC and process flow for each of the MDM serviceso Reviewed and verified the SOPs to ensure coherence with the current processo Working on improving the quality of inputs received to increase efficiency of process by 50%Mentored the team in data analysiso Guided on lifecycle management; from data mining to data visualizationo Provided hands-on training on the use of T-SQL and PL/SQL

Kongens Lyngby, Capital Region, Denmark

- Understanding the Drilling industry and how the different business units like Rigs, Operations, Supply Chain and Finance operate, with Master Data playing an important role.- Responsible to align with business stakeholders to implement MD Governance and prepare process improvement plans. - Hands on experience in using IFS 8 and SAP HR for data mining and data analysis, combined with SQL, SSIS and Power BI to generate Data Quality Indicator (DQI) dashboards.- The DQI dashboards… Show more - Understanding the Drilling industry and how the different business units like Rigs, Operations, Supply Chain and Finance operate, with Master Data playing an important role.- Responsible to align with business stakeholders to implement MD Governance and prepare process improvement plans. - Hands on experience in using IFS 8 and SAP HR for data mining and data analysis, combined with SQL, SSIS and Power BI to generate Data Quality Indicator (DQI) dashboards.- The DQI dashboards have been instrumental in the data clean-up drives as well as various master data improvement initiatives.- Lead a Process Improvement project for Master Data team to define and document all the services that the team offers to the organisation. The main elements that defined a service where the Objective, SIPOC, Process Map, SLAs and SOPs- Exploring possibilities of moving to Azure Platform. Make use of Linked Server connections, BLOB storage and data pipelines to perform ELT operations, and then use Power BI as the presentation layer. Show less

Copenhagen, Capital Region, Denmark

- BlueBenu’s mission to clean up the oceans by recycling the plastic waste into bio fuel, resonates with my ideals and hence a great motivation to work with them.- The role requires me to: * Build the database * Prepare data models using Python * Validate the experimental data

Copenhagen, Capital Region, Denmark

- Great move to explore Europe and stay here for good with husband taking up an amazing job at Copenhagen Metro. - Initial months spent in building a new home, help settle my 5- year old daughter in a Danish Kindergarten and explore the beauty of Copenhagen.- Took this time off as an opportunity to invest in my hobby of recycling cardboard, plastic and metal scrap in creating objects of craft and purpose.- With beautiful parks and lakes nearby, I have kept myself active and healthy… Show more - Great move to explore Europe and stay here for good with husband taking up an amazing job at Copenhagen Metro. - Initial months spent in building a new home, help settle my 5- year old daughter in a Danish Kindergarten and explore the beauty of Copenhagen.- Took this time off as an opportunity to invest in my hobby of recycling cardboard, plastic and metal scrap in creating objects of craft and purpose.- With beautiful parks and lakes nearby, I have kept myself active and healthy with regular walks, jogging and just being playful.- Built new friendships through various networking events Show less

Kuala Lumpur, Malaysia

- Developed SQL database and ETL workflows using SSIS to capture the client’s adoption of Monster.com tools to determine their success rate. - Made use of MS Excel and Power BI dashboards to analyze the data trends and present solutions to relevant functional units to manage the irregularities.- Created batch files to ensure auto data refresh in the dashboards and email the updated reports to the predefined recipients.- Built the Resume Extraction tool as part of the in-house… Show more - Developed SQL database and ETL workflows using SSIS to capture the client’s adoption of Monster.com tools to determine their success rate. - Made use of MS Excel and Power BI dashboards to analyze the data trends and present solutions to relevant functional units to manage the irregularities.- Created batch files to ensure auto data refresh in the dashboards and email the updated reports to the predefined recipients.- Built the Resume Extraction tool as part of the in-house productivity enhancement initiative, which reduced the process time from 2 days of manual work to merely 4 hours of an automated procedure. This tool was built with a combination of SQL queries, SSIS packages and WScript.- Set up the Data Warehousing System (tables, views, stored procedures and ETL packages) to support the in-house reporting website. - Responsible to setup the data management strategy to ensure the data quality, accuracy and completeness.- Took care of database management tasks like archive the old data and clear the transaction LOG files.- Explored new domains like AWS and Qlikview to enhance the team’s capabilities.- Develop and maintain the automation manuals and technical documents. Show less

Cyberjaya, Selangor, Malaysia

- Build a Master Data Management system for the Pricing Finance team in order to streamline their pricing and reporting process for the whole Asia Pacific region- Integrate the manual product pricing tools to generate a standard pricing platform.- Develop various SQL queries, stored procedures and SSIS packages for ETL processing of pricing data.- Process historical pricing database to churn out meaningful pricing insights, analysis and trends.- Develop framework to integrate… Show more - Build a Master Data Management system for the Pricing Finance team in order to streamline their pricing and reporting process for the whole Asia Pacific region- Integrate the manual product pricing tools to generate a standard pricing platform.- Develop various SQL queries, stored procedures and SSIS packages for ETL processing of pricing data.- Process historical pricing database to churn out meaningful pricing insights, analysis and trends.- Develop framework to integrate each month’s FX rates, labor costs and other factors impacting a product’s price.- Create PowerPivot dashboards to showcase the pricing trends in each of the countries and associate the currency fluctuations to it- Develop and maintain SQL training manuals and technical documents. Show less

Kuala Lumpur, Malaysia

With my husband taking up a job with Kuala Lumpur Metro project, I decided to move along.

Gurgaon, India

Project Highlights:- The Central Independent Validation Group (CIVG) mainly caters to the Credit Risk domain and works on models generated for Credit Card industry.- Our team designs and generates the monitoring and tracking reports for model validation.- To achieve this, a Model Governance Reporting System designed using .NET and SQL Server is present which generates reports such as Population Stability Index (PSI), KS for Strategy objective and model objective report, Dynamic… Show more Project Highlights:- The Central Independent Validation Group (CIVG) mainly caters to the Credit Risk domain and works on models generated for Credit Card industry.- Our team designs and generates the monitoring and tracking reports for model validation.- To achieve this, a Model Governance Reporting System designed using .NET and SQL Server is present which generates reports such as Population Stability Index (PSI), KS for Strategy objective and model objective report, Dynamic Delinquency Report, Vintage, Override, Joint odd early indicator report etc.- In this system we have translated SAS reports into SQL Report. System fetches data from multiple sources and generates the report.Responsibilities: - Data mining for model development.- Created multiple DB objects for calculating different statistical values used for Model Development and validation.- Created the SSIS packages (ETL tool) to transfer data between multiple sources and SQL Server destination.- Designing complex performance statistical reports using MS Excel and SSRS- Tracking the performance of risk models as well as performing in depth analysis as required. - Annual Validation of Models Show less

Mumbai Area, India

- Develop, Enhance and support the various data-marts for Amerisourcebergen Bergen Speciality Group, US.- Successfully upgraded the existing DTS packages to new SSIS version, along with development of new ones.- Worked on Server Upgrade from 2005 to 2008 version.- Development of Server objects which includes SPs, Views, SSIS packages etc.