Summary

Overview

Work History

Education

Skills

Timeline

Anil Baviskar

Carnegie

Summary

Seasoned Solution Architect with over 24 years of experience in designing and implementing robust, scalable, and secure data platforms and analytical applications across on-premises and cloud environments (Azure, AWS, GCP). Proven expertise in architecting elastic data warehousing solutions using Snowflake, Azure Synapse, and other modern platforms. Adept in end-to-end data lifecycle management including ingestion, storage, governance, engineering, modelling, virtualization, and advanced analytics and handing multi scrod teams of more than 30 technical onshore offshore resources. Extensive experience in building cloud-native solutions leveraging Lambda architecture, event-driven ingestion, and real-time reporting. I am skilled in machine learning, AI, and large language models (LLMs), with hands-on experience in prompt engineering and chatbot development. Strong background in infrastructure and networking solutions for hybrid environments, including VPN, subnets, and cloud gateways. Proficient in DevOps practices, implementing CI/CD pipelines and automation for application development and deployment. A strategic thinker and technical leader, driving data strategy and best practices across organizations to enable data-driven decision-making and innovation.

Experienced with creating comprehensive data architecture strategies that align with business objectives. Utilizes advanced data modeling techniques and architectural frameworks to enhance system efficiency and reliability. Track record of optimizing data management practices, ensuring seamless data integration, and supporting data-driven decision-making.

Overview

years of professional experience

Work History

Data Architect

HCLTech

09.2024 - Current

Company Overview: ANZ (Australia and New Zealand Banking Group). ANZ is one of Australia's 'Big Four' banks and the largest in New Zealand.
Envolve at initial level during pre-sales for this project.
Create solution design presentation for client and get project approval.
Design and articulate this migration solution.
Developed this migration solution in spark.
Collaborate with different stakeholders within ANZ back to deliver this project.
Attain daily calls and update JIRA portal.
Collaborate with team on sprint planning and help other team members on development.
Collaborate with the team on migration coding and testing.
Delivered this project from end to end and take a responsibility of design, coding, testing and even for deployment.
Work with IT for infrastructure readiness.
Work with ten technical team members.
Get security approvals, architects’ approvals, business approvals and many more approvals from client’s stakeholders.
Work with manager on sprint planning and guide team to delivered in agile manner.
Did documentation and testing and deployments.
Help application team for testing and creating run sheet.
ANZ (Australia and New Zealand Banking Group). ANZ is one of Australia's 'Big Four' banks and the largest in New Zealand.
Design migration solution and data model.
Create Prod and Non-Prod environment for these solutions.
Build migration code and pass testing and UAT.
Deploy solution in production environment.

Data Architect

HCLTech

09.2024 - Current

Company Overview: ANZ (Australia and New Zealand Banking Group). ANZ is one of Australia's 'Big Four' banks and the largest in New Zealand.
Envolve at initial level during pre-sales for this project.
Create solution design presentation for client and get project approval.
Design and articulate this migration solution.
Developed this migration solution in spark.
Collaborate with different stakeholders within ANZ back to deliver this project.
Attain daily calls and update JIRA portal.
Collaborate with team on sprint planning and help other team members on development.
Collaborate with the team on migration coding and testing.
Delivered this project from end to end and take a responsibility of design, coding, testing and even for deployment.
Work with IT for infrastructure readiness.
Work with ten technical team members.
Get security approvals, architects’ approvals, business approvals and many more approvals from client’s stakeholders.
Work with manager on sprint planning and guide team to delivered in agile manner.
Did documentation and testing and deployments.
Help application team for testing and creating run sheet.
ANZ (Australia and New Zealand Banking Group). ANZ is one of Australia's 'Big Four' banks and the largest in New Zealand.
Design migration solution and data model.
Create Prod and Non-Prod environment for these solutions.
Build migration code and pass testing and UAT.
Deploy solution in production environment.

Data Architect

HCLTech

02.2024 - 09.2024

Company Overview: Bapcor Limited is a leading provider of vehicle parts, accessories, equipment, service, and solutions in the Asia Pacific region.
Implement data governance solution on Azure Purview.
Work with 15 ETL and Power BI technical team members.
Work with manager on sprint planning and plan to delivered this in time.
Collaborate with architects and many stakeholders.
Design RBAC for multitenant Power BI Solution.
Implement DevOps for Azure Data Lake platform.
Implement Release management and change management processes.
Implement ERP and Non-ERP data governance processes.
Design and Implement dynamic ETL pipelines to integrate multiple source systems using Azure Data Factory.
Implement security management processes.
Implement Power BI development process.
Design new could data warehousing solutions on Synapse and Azure.
Architecting Azure cloud security with Vents, Subnets, Express route etc.
Solution to remove informatica and implement snowflake.
Talk to stakeholders and business leaders about the weekly milestones.
Work on data ingestion for databases, ETL tools, cloud data bases etc.
Working on snowflake SP, Task, and design ETL and SDC solutions.
Create a migration strategy from Sybase to snowflake.
Work on Data profiling, Data cleansing, metadata management and data security solutions.
Use Azure Purview for data governance.
Design RBAC for Dev, test, UAT environments.
Manage Power BI multi talent environment in Active Directory.
Management virtual machines.
Repointing SSRS reports to snowflake.
Working on power BI models.
Bapcor Limited is a leading provider of vehicle parts, accessories, equipment, service, and solutions in the Asia Pacific region.
Delivered digital data platform on Azure.
Delivered analytical solutions for Business.
Delivered data governance platform.

Data Architect

HCLTech

02.2024 - 09.2024

Company Overview: Bapcor Limited is a leading provider of vehicle parts, accessories, equipment, service, and solutions in the Asia Pacific region.
Implement data governance solution on Azure Purview.
Work with 15 ETL and Power BI technical team members.
Work with manager on sprint planning and plan to delivered this in time.
Collaborate with architects and many stakeholders.
Design RBAC for multitenant Power BI Solution.
Implement DevOps for Azure Data Lake platform.
Implement Release management and change management processes.
Implement ERP and Non-ERP data governance processes.
Design and Implement dynamic ETL pipelines to integrate multiple source systems using Azure Data Factory.
Implement security management processes.
Implement Power BI development process.
Design new could data warehousing solutions on Synapse and Azure.
Architecting Azure cloud security with Vents, Subnets, Express route etc.
Solution to remove informatica and implement snowflake.
Talk to stakeholders and business leaders about the weekly milestones.
Work on data ingestion for databases, ETL tools, cloud data bases etc.
Working on snowflake SP, Task, and design ETL and SDC solutions.
Create a migration strategy from Sybase to snowflake.
Work on Data profiling, Data cleansing, metadata management and data security solutions.
Use Azure Purview for data governance.
Design RBAC for Dev, test, UAT environments.
Manage Power BI multi talent environment in Active Directory.
Management virtual machines.
Repointing SSRS reports to snowflake.
Working on power BI models.
Bapcor Limited is a leading provider of vehicle parts, accessories, equipment, service, and solutions in the Asia Pacific region.
Delivered digital data platform on Azure.
Delivered analytical solutions for Business.
Delivered data governance platform.

Solution Lead

HCLTech

08.2023 - 01.2024

Company Overview: Elders are for Australian Agriculture. For farming families. Elders have been supporting farmers and primary producers for more than 185 years.
Work as a solution lead and managing 8 ETL and reporting team members.
Design new could data warehousing solutions on snowflake and Azure.
Solution to remove informatica and produce snowflake.
Design dynamic queries that will increase the reusability.
Talk to multiple stakeholders and business leaders about the weekly milestones.
Design and build data cleansing solution to new data platform.
Work on data ingestion for databases, ETL tools, cloud data bases etc.
Working on snowflake SP, Task, and design ETL and SDC solutions.
Create a migration strategy from Sybase to snowflake.
Daily work with 7 teams’ members to handle ETL and reporting work and update the status in standup calls.
Repointing SSRS reports to snowflake.
Working on power BI models.
Elders are for Australian Agriculture. For farming families. Elders have been supporting farmers and primary producers for more than 185 years.
Build digital data platform on cloud.
Migrate old SSRS reports into Power BI.

Solution Lead

HCLTech

08.2023 - 01.2024

Company Overview: Elders are for Australian Agriculture. For farming families. Elders have been supporting farmers and primary producers for more than 185 years.
Work as a solution lead and managing 8 ETL and reporting team members.
Design new could data warehousing solutions on snowflake and Azure.
Solution to remove informatica and produce snowflake.
Design dynamic queries that will increase the reusability.
Talk to multiple stakeholders and business leaders about the weekly milestones.
Design and build data cleansing solution to new data platform.
Work on data ingestion for databases, ETL tools, cloud data bases etc.
Working on snowflake SP, Task, and design ETL and SDC solutions.
Create a migration strategy from Sybase to snowflake.
Daily work with 7 teams’ members to handle ETL and reporting work and update the status in standup calls.
Repointing SSRS reports to snowflake.
Working on power BI models.
Elders are for Australian Agriculture. For farming families. Elders have been supporting farmers and primary producers for more than 185 years.
Build digital data platform on cloud.
Migrate old SSRS reports into Power BI.

Data Engineer

HCLTech

11.2022 - 08.2023

Company Overview: ANZ (Australia and New Zealand Banking Group). ANZ is one of Australia's 'Big Four' banks and the largest in New Zealand.
Play a data engineering role for Data Governance for ANZ bank.
In Data Governance ANZ has metadata management, reference data management and master data management.
I need to handle all 3 teams and solutions including metadata management.
ANZ has Alex as a metadata management tool which storing data from different applications and technologies like databases, ETL tolls, reporting tools, cloud-based reporting platforms etc.
ANZ (Australia and New Zealand Banking Group). ANZ is one of Australia's 'Big Four' banks and the largest in New Zealand.
Implement Alex solution within ANZ.
Successfully build data governance solution within ANZ.

Data Engineer

HCLTech

11.2022 - 08.2023

Company Overview: ANZ (Australia and New Zealand Banking Group). ANZ is one of Australia's 'Big Four' banks and the largest in New Zealand.
Play a data engineering role for Data Governance for ANZ bank.
In Data Governance ANZ has metadata management, reference data management and master data management.
I need to handle all 3 teams and solutions including metadata management.
ANZ has Alex as a metadata management tool which storing data from different applications and technologies like databases, ETL tolls, reporting tools, cloud-based reporting platforms etc.
ANZ (Australia and New Zealand Banking Group). ANZ is one of Australia's 'Big Four' banks and the largest in New Zealand.
Implement Alex solution within ANZ.
Successfully build data governance solution within ANZ.

Data Migration Lead

HCLTech

01.2022 - 10.2022

Company Overview: Uniting Care is migrating data from different source systems like Care Link and Preceda to Alaya care system.
Design solution for migration and data extraction, transformation, and validation.
Preparing source to target Mapping document.
Work on Requirement Analysis for mapping.
Working with the team for development.
Deployment in to Stating and UAT environment.
Creating a database and schema with handing database security.
Managing database backup and recovery.
Maintaining source databases.
Database performance improvement.
Design database capacity planning for dev, test and Production environments.
Design infrastructure solutions and capacity planning for the enterprise architecture.
Looking at the network related issues for the applications.
Connecting with different stake holders to understand to business level problem and provide technical solutions.
Implement best practices for the Security processes and data management solutions etc.
Manage cloud bases infrastructure and applications solutions.
Looking at the product architecture and ensuring that it’s meets the business requirement.
Managing 5 team members for this migration and work together on this project.
Uniting Care is migrating data from different source systems like Care Link and Preceda to Alaya care system.
Done Migration Successfully.
Successfully migrated application on cloud.

Data Migration Lead

HCLTech

01.2022 - 10.2022

Company Overview: Uniting Care is migrating data from different source systems like Care Link and Preceda to Alaya care system.
Design solution for migration and data extraction, transformation, and validation.
Preparing source to target Mapping document.
Work on Requirement Analysis for mapping.
Working with the team for development.
Deployment in to Stating and UAT environment.
Creating a database and schema with handing database security.
Managing database backup and recovery.
Maintaining source databases.
Database performance improvement.
Design database capacity planning for dev, test and Production environments.
Design infrastructure solutions and capacity planning for the enterprise architecture.
Looking at the network related issues for the applications.
Connecting with different stake holders to understand to business level problem and provide technical solutions.
Implement best practices for the Security processes and data management solutions etc.
Manage cloud bases infrastructure and applications solutions.
Looking at the product architecture and ensuring that it’s meets the business requirement.
Managing 5 team members for this migration and work together on this project.
Uniting Care is migrating data from different source systems like Care Link and Preceda to Alaya care system.
Done Migration Successfully.
Successfully migrated application on cloud.

Solution Architect

EMTEC SOLUTIONS PVT LTD

12.2020 - 12.2021

Company Overview: Working in a Transport Insight, USA, as a Solution architect and Design solutions for taking business and infrastructure on cloud digital data platform using lambda architecture for TI.
Design and implement strategy for cloud movement.
Understand the business problems and provide technical solutions.
Implement cloud base infrastructure for applications and data.
Design and implement Network security, access management to applications and data.
Managing 10 technical team members from different technology.
Attain daily calls to get status and assign the work to the team members and help them to get work done.
Design new analytical and data solutions to meet the business requirements.
Implement new best architecting solutions.
Implement agile methodology for development and new CICD and deployment processes.
Did structure data injection use Talend ETL tools.
Design a product roadmap and implement it.
Streaming data using Confluent Kafka.
Work on Change data capture and Change Tracking using SQL server.
Design architecture and low-level design document.
Work on the RFP and win this account.
From a team to deliver.
Discussion with the client and design azure infrastructure architecture.
Analysed source data to identify source data elements, tables, and relationships.
Identified source validation rules, process calculations, equations, and validations.
Design common data model, design data lake system.
Design DevOps and data Ops strategy and procedure.
Design terraform code.
Design security, Networking, for solution.
Design ELT loads pipelines using ADF tools.
Expertise in Snowflake data modelling.
Working in a Transport Insight, USA, as a Solution architect and Design solutions for taking business and infrastructure on cloud digital data platform using lambda architecture for TI.
Implement digital data platform on azure.
Enhance data platform and improve reporting performance.

Solution Architect

EMTEC SOLUTIONS PVT LTD

12.2020 - 12.2021

Company Overview: Working in a Transport Insight, USA, as a Solution architect and Design solutions for taking business and infrastructure on cloud digital data platform using lambda architecture for TI.
Design and implement strategy for cloud movement.
Understand the business problems and provide technical solutions.
Implement cloud base infrastructure for applications and data.
Design and implement Network security, access management to applications and data.
Managing 10 technical team members from different technology.
Attain daily calls to get status and assign the work to the team members and help them to get work done.
Design new analytical and data solutions to meet the business requirements.
Implement new best architecting solutions.
Implement agile methodology for development and new CICD and deployment processes.
Did structure data injection use Talend ETL tools.
Design a product roadmap and implement it.
Streaming data using Confluent Kafka.
Work on Change data capture and Change Tracking using SQL server.
Design architecture and low-level design document.
Work on the RFP and win this account.
From a team to deliver.
Discussion with the client and design azure infrastructure architecture.
Analysed source data to identify source data elements, tables, and relationships.
Identified source validation rules, process calculations, equations, and validations.
Design common data model, design data lake system.
Design DevOps and data Ops strategy and procedure.
Design terraform code.
Design security, Networking, for solution.
Design ELT loads pipelines using ADF tools.
Expertise in Snowflake data modelling.
Working in a Transport Insight, USA, as a Solution architect and Design solutions for taking business and infrastructure on cloud digital data platform using lambda architecture for TI.
Implement digital data platform on azure.
Enhance data platform and improve reporting performance.

Sr. Cloud Architect

SAAMA TECHNOLOGY PVT LTD

01.2020 - 12.2020

Design and architecting on premise EDW and BI solutions.
Work at client side for designing.
Handling Presales, delivery and CoE activities within the organization.
Managing delivery with technical teams and discuss requirements with clients.
Leading client facing role in delivery and deal with multiple stakeholders.
Managing technical and architect teams.
People management.
Working on big data platforms.

Sr. Cloud Architect

SAAMA TECHNOLOGY PVT LTD

01.2020 - 12.2020

Design and architecting on premise EDW and BI solutions.
Work at client side for designing.
Handling Presales, delivery and CoE activities within the organization.
Managing delivery with technical teams and discuss requirements with clients.
Leading client facing role in delivery and deal with multiple stakeholders.
Managing technical and architect teams.
People management.
Working on big data platforms.

Assoc Director

COGNIZANT TECHNOLOGY

10.2016 - 06.2020

Work as a Team Lead managing large teams of different skill sets.
Work with business users and different stakeholders.
Get daily status from the team as lead and guide them for daily work.
Understand current data infrastructure and challenges IT (Transport Insight) is facing and design the futuristic data solution on azure cloud platform and help in creating proposal for IT.
Design and develop digital data platform on azure and design Operational data store and EDW in snowflake using lambda architecture for Transport Insight.
Understand the underline ETL logic from informatica and design pipelines into azure data bricks and ADF and design ADLS folder structure.
Start at very initial level and engage the client making them understand the next generation platform and initialize the Azure platform creation work (ADLS, ADF, Azure Data Bricks, Snowflake, confluent Kafka, Bitbucket etc., Site to Site VPN, ADF Firewall).
Build entire delivery team and work with the client to design the phases and sprint planning.
Start working on small different POCs with the team that will help in delivery.
Design the snowflake architecture or ODS and EDW for reporting and create data modelling and RBAC solutions on snowflake and azure.
Work on snowflake streams and task creation to handle insert, update and delete.
Work on the confluent Kafka connecters to stream the data from SQL server and Json file on ftp server.
Work with the different stakeholders like infrastructure team, security team, data engineering team, data modelling team, reporting teams and management teams to deliver the project successfully.
Work on ADF and Azure data bricks to design the data pipelines and handle automation with config tables and audit tables and build power BI reports to show daily status on data pipeline.
Help the internal team to make them understand the proposed solution and work with them to delivered and work with the CoE teams on different PoCs and ideas.
Provide the trainings to the client support team so that they can handle operations on new platform.
Design and architecting scalable, fault tolerance digital platforms for Analytics on Azure cloud for multiple clients.
Work on the multiple POCs for azure cloud, data, and reporting solutions and work with them team to in creating proposal and work as a people manager.
Design on premise and cloud data warehousing solutions, Analytical solutions with ML and AI with different clients and participate in delivery.
Build relationships with clients and identifying opportunities for data design improvement.
Work with internal and external teams and follow organizational goals and client goals.
Work with the client to understand the current solutions, challenges and proposed them the scalable futuristic platform which will enrich analytical solutions and challenges.
Understand the organizational data, source systems, ETL routines, security, and design new solutions with data modelling concepts.

Assoc Director

COGNIZANT TECHNOLOGY

10.2016 - 06.2020

Work as a Team Lead managing large teams of different skill sets.
Work with business users and different stakeholders.
Get daily status from the team as lead and guide them for daily work.
Understand current data infrastructure and challenges IT (Transport Insight) is facing and design the futuristic data solution on azure cloud platform and help in creating proposal for IT.
Design and develop digital data platform on azure and design Operational data store and EDW in snowflake using lambda architecture for Transport Insight.
Understand the underline ETL logic from informatica and design pipelines into azure data bricks and ADF and design ADLS folder structure.
Start at very initial level and engage the client making them understand the next generation platform and initialize the Azure platform creation work (ADLS, ADF, Azure Data Bricks, Snowflake, confluent Kafka, Bitbucket etc., Site to Site VPN, ADF Firewall).
Build entire delivery team and work with the client to design the phases and sprint planning.
Start working on small different POCs with the team that will help in delivery.
Design the snowflake architecture or ODS and EDW for reporting and create data modelling and RBAC solutions on snowflake and azure.
Work on snowflake streams and task creation to handle insert, update and delete.
Work on the confluent Kafka connecters to stream the data from SQL server and Json file on ftp server.
Work with the different stakeholders like infrastructure team, security team, data engineering team, data modelling team, reporting teams and management teams to deliver the project successfully.
Work on ADF and Azure data bricks to design the data pipelines and handle automation with config tables and audit tables and build power BI reports to show daily status on data pipeline.
Help the internal team to make them understand the proposed solution and work with them to delivered and work with the CoE teams on different PoCs and ideas.
Provide the trainings to the client support team so that they can handle operations on new platform.
Design and architecting scalable, fault tolerance digital platforms for Analytics on Azure cloud for multiple clients.
Work on the multiple POCs for azure cloud, data, and reporting solutions and work with them team to in creating proposal and work as a people manager.
Design on premise and cloud data warehousing solutions, Analytical solutions with ML and AI with different clients and participate in delivery.
Build relationships with clients and identifying opportunities for data design improvement.
Work with internal and external teams and follow organizational goals and client goals.
Work with the client to understand the current solutions, challenges and proposed them the scalable futuristic platform which will enrich analytical solutions and challenges.
Understand the organizational data, source systems, ETL routines, security, and design new solutions with data modelling concepts.

Application Architect

IBM TECHNOLOGY

05.2013 - 10.2016

As Lead managing more than 15 team members and guiding them to delivered in time.
Lead the daily calls and assign task to team members and delivered in time.
Understand the current state of DW architecture.
Design a modern data warehouse solution.
Prepare the strategy to migrate the current DW from on premise to cloud.
Prepared SSIS integration runtime on azure data factory.
Create an Azure architecture for modern data warehouse.
Gathered business requirements and designed functional and technical requirements documentation.
Worked closely with Business Analyst and business users to identify source data, source validation rules, and process calculations; finalize the Granularity and Documented the Business Rules.
Finalize the naming Standards for Data Elements and ETL Jobs and create a Data Dictionary for Meta Data Management.
Analysed source data to identify source data elements, tables, and relationships.
Identified source validation rules, process calculations, equations, and validations.
Implement CICD process on azure.
Help in team building and Sprint design.

Application Architect

IBM TECHNOLOGY

05.2013 - 10.2016

As Lead managing more than 15 team members and guiding them to delivered in time.
Lead the daily calls and assign task to team members and delivered in time.
Understand the current state of DW architecture.
Design a modern data warehouse solution.
Prepare the strategy to migrate the current DW from on premise to cloud.
Prepared SSIS integration runtime on azure data factory.
Create an Azure architecture for modern data warehouse.
Gathered business requirements and designed functional and technical requirements documentation.
Worked closely with Business Analyst and business users to identify source data, source validation rules, and process calculations; finalize the Granularity and Documented the Business Rules.
Finalize the naming Standards for Data Elements and ETL Jobs and create a Data Dictionary for Meta Data Management.
Analysed source data to identify source data elements, tables, and relationships.
Identified source validation rules, process calculations, equations, and validations.
Implement CICD process on azure.
Help in team building and Sprint design.

Solution Architect

TECHNOSOFT

07.2012 - 04.2013

Work with 20 onshore and offshore team members and manage them from onshore.
Get daily status in the calls and help in delivering in time and with good quality.
Understand business requirement and provide task to the team and help them to delivered.
Dealing with the client explaining solutions and risk involved into it.
Key role during initiation of the project and provide various approach to the various BI solutions.
Implementation and maintenance of Cognos Dev. environment.
Looking after POC related work and provide solutions to the POC.
Key role in UAT, provide Cognos training to the UBS Client and make them understand the system.

Solution Architect

TECHNOSOFT

07.2012 - 04.2013

Work with 20 onshore and offshore team members and manage them from onshore.
Get daily status in the calls and help in delivering in time and with good quality.
Understand business requirement and provide task to the team and help them to delivered.
Dealing with the client explaining solutions and risk involved into it.
Key role during initiation of the project and provide various approach to the various BI solutions.
Implementation and maintenance of Cognos Dev. environment.
Looking after POC related work and provide solutions to the POC.
Key role in UAT, provide Cognos training to the UBS Client and make them understand the system.

Technical Manager

CAPITA

06.2010 - 07.2012

Work with 30+ team members as a manager and daily assign task to them and involved in getting work done.
Lead standing calls get status from team lead and task assignments and task delivery progress on daily basis.
Provide the support on daily challenges to the team members.
Design Data Modelling and data marts, Data Integration Approach.
Technical tool was SQL server, SSIS and Cognos.
Knowledge of Handling slowing changing dimensions and change captured data.
Manage projects like Capita Its, UK Census, BBC, HNS, YPLA, develop in Cognos 8.4, and SSIS, Informatica.
Know ETL process, Incremental Load, Load Banning, Transformations, Monitoring, and log files and tables.
Engage in gathering High level requirements and provide various approaches for Data Integration and data presentation.
Knowledge in multi dimension modelling and design and develop cubes with drill up and drill down capability.

Technical Manager

CAPITA

06.2010 - 07.2012

Work with 30+ team members as a manager and daily assign task to them and involved in getting work done.
Lead standing calls get status from team lead and task assignments and task delivery progress on daily basis.
Provide the support on daily challenges to the team members.
Design Data Modelling and data marts, Data Integration Approach.
Technical tool was SQL server, SSIS and Cognos.
Knowledge of Handling slowing changing dimensions and change captured data.
Manage projects like Capita Its, UK Census, BBC, HNS, YPLA, develop in Cognos 8.4, and SSIS, Informatica.
Know ETL process, Incremental Load, Load Banning, Transformations, Monitoring, and log files and tables.
Engage in gathering High level requirements and provide various approaches for Data Integration and data presentation.
Knowledge in multi dimension modelling and design and develop cubes with drill up and drill down capability.

Sr. Consultant

CAPGEMINI

02.2008 - 06.2010

Work with different stakeholders for getting requirements and assign them among the team.
Work with more than 12 team members and help them in design, build and testing.
Responsible for Requirement Gathering, Coding.
Identify the requirement gaps and challenges and see how we can meet those.
Work with different stakeholders, different team members and business users.
Technical tool was Business Objects.
Good Understanding of OLAB modelling and provide solutions for various cubes.
Develop Sales Analysis and Demand forecast dashboards in Cognos 8.4.
Understand Cognos Tool and provide reporting and analysis solutions.
Responsible for planning, coordinating and managing development, testing and release of several simultaneous high-profile Canadian Retail processing application projects.

Sr. Consultant

CAPGEMINI

02.2008 - 06.2010

Work with different stakeholders for getting requirements and assign them among the team.
Work with more than 12 team members and help them in design, build and testing.
Responsible for Requirement Gathering, Coding.
Identify the requirement gaps and challenges and see how we can meet those.
Work with different stakeholders, different team members and business users.
Technical tool was Business Objects.
Good Understanding of OLAB modelling and provide solutions for various cubes.
Develop Sales Analysis and Demand forecast dashboards in Cognos 8.4.
Understand Cognos Tool and provide reporting and analysis solutions.
Responsible for planning, coordinating and managing development, testing and release of several simultaneous high-profile Canadian Retail processing application projects.

Consultant

GALAXY SOLUTIONS

02.2007 - 02.2008

Lead a team of 20+ developers to develop and support the DW and BI solutions.
Technical tool was Oracle and Cognos.
Authored Technical Implementation Documents for each Department and Application recommending technology, architecture, function, development needs, costs, and timelines.
Created architectural framework foundation for which the entire company Intranet would be based (focusing on ease of development, stability, extensibility, and security).
Worked with Training Department to produce comprehensive user training manuals, tutorials, and administration manuals for each web application to meet corporate auditing requirements and ease the future hand-off, administration and use of the web applications and tools created.

Consultant

GALAXY SOLUTIONS

02.2007 - 02.2008

Lead a team of 20+ developers to develop and support the DW and BI solutions.
Technical tool was Oracle and Cognos.
Authored Technical Implementation Documents for each Department and Application recommending technology, architecture, function, development needs, costs, and timelines.
Created architectural framework foundation for which the entire company Intranet would be based (focusing on ease of development, stability, extensibility, and security).
Worked with Training Department to produce comprehensive user training manuals, tutorials, and administration manuals for each web application to meet corporate auditing requirements and ease the future hand-off, administration and use of the web applications and tools created.

Consultant

SEEINFOBIZ

05.2006 - 02.2007

Design Data Modelling and data marts, Data Integration Approach.
Technical tool was SQL server and Cognos.
Build reports on Cognos.
Understand the business requirement from business team.
Did reporting mapping and business approval for it.
Get unit testing and testing done from testing team.
Deploy reports into production environment.

Consultant

SEEINFOBIZ

05.2006 - 02.2007

Design Data Modelling and data marts, Data Integration Approach.
Technical tool was SQL server and Cognos.
Build reports on Cognos.
Understand the business requirement from business team.
Did reporting mapping and business approval for it.
Get unit testing and testing done from testing team.
Deploy reports into production environment.

Administrator

PLAIN RECRUITMENT

02.2004 - 11.2005

Responsible to database creation, schema and table creation in Oracle.
Take regular backups of databases.
Give access to end users.
Deploy update schema scripts given by developers.
Manage multiple databases in oracle.
Responsible for other administrative work in oracle database.

Administrator

PLAIN RECRUITMENT

02.2004 - 11.2005

Responsible to database creation, schema and table creation in Oracle.
Take regular backups of databases.
Give access to end users.
Deploy update schema scripts given by developers.
Manage multiple databases in oracle.
Responsible for other administrative work in oracle database.

Software Engineer

SYDEL CORPORATION

07.2002 - 12.2003

Working with databases creation and schema management.
Handing data backup, recovery, security, integrity and SQL.
Maintain documentation for different databases and management.
Managing database backup and recovery.
Maintaining source databases.
Did SQL server software installation.

Software Engineer

SYDEL CORPORATION

07.2002 - 12.2003

Working with databases creation and schema management.
Handing data backup, recovery, security, integrity and SQL.
Maintain documentation for different databases and management.
Managing database backup and recovery.
Maintaining source databases.
Did SQL server software installation.

Software Engineer

CIT Computers

10.2000 - 05.2002

Work on .Net application and SQL server database.
Create tables and schemas in SQL servers.
Generate insert and update and delete records scripts for applications.
Generate reports in .Net applications.
Work with the .Net team to understand the database requirements.
Test the dataset result in .Net application.

Software Engineer

CIT Computers

10.2000 - 05.2002

Work on .Net application and SQL server database.
Create tables and schemas in SQL servers.
Generate insert and update and delete records scripts for applications.
Generate reports in .Net applications.
Work with the .Net team to understand the database requirements.
Test the dataset result in .Net application.

Software Engineer

PARAM INFORMATION TECHNOLOGY

01.1999 - 09.2000

Responsible for Requirement Gathering, Coding.
Technical tool was Oracle.
Use oracle SQL and PL SQL Script.
Create Excel reports using the script.
Provide reports to end users.

Software Engineer

PARAM INFORMATION TECHNOLOGY

01.1999 - 09.2000

Responsible for Requirement Gathering, Coding.
Technical tool was Oracle.
Use oracle SQL and PL SQL Script.
Create Excel reports using the script.
Provide reports to end users.

Education

Bachelor of Commerce -

Mumbai University

01.1997

Professional Diploma - Software Engineering

DataPro

01.1999

Skills

Azure Synapse analytics
Snowflake
Azure SQL Server
Big Query
Azure ADLS Gen2
SQL Server
Oracle
DB2
Teradata
Azure Data Factory
Azure Data Bricks
Spark
SSIS
Informatica
Talend
DBT
Confluence

Kafka
Power BI
Tableau
SSRS
QlikView
Machine Learning
LMM model
Chat Bots
NLP
Deep Learning
Neural Network models
Azure Git Repository
Gira
Azure VM
Azure infrastructure
Logic APP
Azure functions

<Enter your own>

Title: Data Engineer

Timeline

Data Architect

HCLTech

09.2024 - Current

Data Architect

HCLTech

09.2024 - Current

Data Architect

HCLTech

02.2024 - 09.2024

Data Architect

HCLTech

02.2024 - 09.2024

Solution Lead

HCLTech

08.2023 - 01.2024

Solution Lead

HCLTech

08.2023 - 01.2024

Data Engineer

HCLTech

11.2022 - 08.2023

Data Engineer

HCLTech

11.2022 - 08.2023

Data Migration Lead

HCLTech

01.2022 - 10.2022

Data Migration Lead

HCLTech

01.2022 - 10.2022

Solution Architect

EMTEC SOLUTIONS PVT LTD

12.2020 - 12.2021

Solution Architect

EMTEC SOLUTIONS PVT LTD

12.2020 - 12.2021

Sr. Cloud Architect

SAAMA TECHNOLOGY PVT LTD

01.2020 - 12.2020

Sr. Cloud Architect

SAAMA TECHNOLOGY PVT LTD

01.2020 - 12.2020

Assoc Director

COGNIZANT TECHNOLOGY

10.2016 - 06.2020

Assoc Director

COGNIZANT TECHNOLOGY

10.2016 - 06.2020

Application Architect

IBM TECHNOLOGY

05.2013 - 10.2016

Application Architect

IBM TECHNOLOGY

05.2013 - 10.2016

Solution Architect

TECHNOSOFT

07.2012 - 04.2013

Solution Architect

TECHNOSOFT

07.2012 - 04.2013

Technical Manager

CAPITA

06.2010 - 07.2012

Technical Manager

CAPITA

06.2010 - 07.2012

Sr. Consultant

CAPGEMINI

02.2008 - 06.2010

Sr. Consultant

CAPGEMINI

02.2008 - 06.2010

Consultant

GALAXY SOLUTIONS

02.2007 - 02.2008

Consultant

GALAXY SOLUTIONS

02.2007 - 02.2008

Consultant

SEEINFOBIZ

05.2006 - 02.2007

Consultant

SEEINFOBIZ

05.2006 - 02.2007

Administrator

PLAIN RECRUITMENT

02.2004 - 11.2005

Administrator

PLAIN RECRUITMENT

02.2004 - 11.2005

Software Engineer

SYDEL CORPORATION

07.2002 - 12.2003

Software Engineer

SYDEL CORPORATION

07.2002 - 12.2003

Software Engineer

CIT Computers

10.2000 - 05.2002

Software Engineer

CIT Computers

10.2000 - 05.2002

Software Engineer

PARAM INFORMATION TECHNOLOGY

01.1999 - 09.2000

Software Engineer

PARAM INFORMATION TECHNOLOGY

01.1999 - 09.2000

Professional Diploma - Software Engineering

DataPro

Bachelor of Commerce -

Mumbai University