Amit Pagariya, Developer in Pune, Maharashtra, India
Amit is available for hire
Hire Amit

Amit Pagariya

Verified Expert  in Engineering

Bio

Amit is a talented senior BI developer and architect with 14+ years of expertise in delivering BI and analytics projects. He is a certified Microsoft Data Engineer with in-depth knowledge of the data-driven Azure stack. Amit built a high-performing sales analytics solution that created reporting dashboards, which improved revenue. Amit has delivered robust data projects following Agile methodologies in the telecommunications, eCommerce, and healthcare industries.

Portfolio

Commonwealth Financial Network - Main
Microsoft Power BI, Snowflake, Azure DevOps, Data Modeling, Dashboards...
Cognizant
Microsoft Power Apps, Python, Databricks, Agile Software Development...
Cognizant
SQL Server Integration Services (SSIS), Microsoft Power BI, Azure SQL Databases...

Experience

  • MCSE | Business Intelligence - 12 years
  • Data Warehouse Design - 12 years
  • Data Architecture - 10 years
  • BI Reporting - 9 years
  • Azure SQL - 6 years
  • Analytics - 5 years
  • Azure Data Factory (ADF) - 4 years
  • Azure SQL Databases - 3 years

Availability

Part-time

Preferred Environment

Data Architecture, Data Analytics, MCSE | Business Intelligence, Data Engineering, Microsoft Azure, BI Reporting

The most amazing...

...sales analytics solution I delivered created reporting dashboards to help sales and commercial excellence teams drive customer discussions and improve revenue.

Work Experience

PowerBI Consultant

2023 - PRESENT
Commonwealth Financial Network - Main
  • Developed a PowerBI model and Reports/App based on advisors and their valuations data to serve all operational and analytical needs of business users. It helped business users to switch from old SSRS reports to PowerBI.
  • Architected a PowerBI model and reports based on clients, products, and their assets data to serve all operational and analytical needs of business users. It helped users to self-serve their needs than submitting data requests to the support team.
  • Helped the client set up the PowerBI platform and processes from scratch and grow the adoption of PowerBI reporting in the business community. Served as a reporting lead and worked data architects to design the data warehouse and reporting layer.
  • Managed reporting for multiple domains to ensure the common processes were followed across teams. Worked on Snowflake to create views and custom logic to serve the reporting needs.
  • Implemented various PowerBI key features like object-level security, row-level security, PowerBI dataflows, PowerBI Apps, deployment pipelines, various business KPIs, etc.
Technologies: Microsoft Power BI, Snowflake, Azure DevOps, Data Modeling, Dashboards, Data Analysis

Senior Data Engineer

2018 - 2020
Cognizant
  • Developed a sales analytics data warehouse and a reporting solution for a consumer healthcare client using MS Azure stack. Created complex daily sales, net revenue management and other reports, dashboards to support sales.
  • Developed data pipelines in Azure data factory V2 for data ingestion. Prepared and validated using data bricks. stored data in an Azure data lake and then model it in Azure Synape analytics (ADW) and used PowerBI to develop reports and dashboards.
  • Led the deployment using Azure DevOps pipelines to promote Azure components to a higher environment. Led a team of data engineers and business analysts while ensuring data governance policies are followed for data access.
  • Followed Agile Kanban methodology for project delivery. Worked with multiple countries in Europe to understand the business processes and customized the solution to serve the local business needs.
  • Developed power apps to provide feature to users to input the master data and mappings.
Technologies: Microsoft Power Apps, Python, Databricks, Agile Software Development, Data Visualization, Data Analytics, Azure SQL Databases, Microsoft Power BI, Azure Data Lake, Azure Data Factory (ADF), Azure SQL, Data Modeling, ETL, SQL, Dashboards, Data Analysis, Microsoft SQL Server, SQL Server 2017

Data and Reporting Architect

2017 - 2018
Cognizant
  • Designed a reporting solution in Azure for an online fashion clothing brand in UK to support the finance department, which extracts data from Dynamics365 into an Azure SQL database.
  • Built reports and dashboards for sales, P&L, Tax, VAT and other operational reporting to support finance operations. Developed a proof-of-concept to prove the solution and design flow.
  • Defined a data migration strategy to migrate data from the old system to Dynamics 365. Developed data extraction batches and refresh daily data loads to the Azure SQL database. Designed power apps to track the master data input and configurations.
  • Collaborated with SMEs to identify KPIs and reporting requirements. Supported developers to meet business requirements. Acted as a bridge between different finance teams to build a common understanding of the data.
Technologies: SQL Server Integration Services (SSIS), Microsoft Power BI, Azure SQL Databases, Microsoft Dynamics, Data Modeling, ETL, Dashboards, Data Analysis, Microsoft SQL Server, SQL Server 2017

Technical Architect

2015 - 2016
Cognizant
  • Served as a technical architect and lead for an online fashion clothing brand in the UK to design new applications and manage the technical delivery. Collaborated with the client DBE and architects to design new applications or enhance old ones.
  • Created ETL flow in SSIS to read data from a retail ERP and ingest into the operational database. Developed SQL Sprocs to transform and load the data in the target operational database. Reviewed code and technical deliveries to ensure quality.
  • Managed the production releases of the Middleware platform. Organized and facilitated agile and scrum meetings, which included sprint planning, daily scrums and stand-ups.
  • Collaborated with the business analyst to convert business requirements into stories and prepared technical specifications.
Technologies: SQL Server Reporting Services (SSRS), SQL Server 2014, SQL Server Integration Services (SSIS), SQL, Data Modeling, ETL, Microsoft SQL Server, SQL Server 2017

Database Engineer

2013 - 2015
Cognizant
  • Served as the database engineer for a data migration of all customer-related information from a SQL Server database to Gigya data store (MongoDB) and changes in legacy SQL server database to implement the new features on the customer site.
  • Designed and developed ETL flow for data migration from sql server to MongoDB. Created and modified database objects such as procedures, functions, and views. Created and modified the replication between two databases.
  • Collaborated with the client for requirements gathering. Onsite coordinator for data migration project and other database tasks. Performed ETL unit, integration, and performance testing.
Technologies: MongoDB, SQL Server 2012, SQL Server Integration Services (SSIS), ETL, SQL, Microsoft SQL Server, SQL Server 2017

ETL Developer

2012 - 2013
Cognizant
  • Served as an ETL developer to create a data warehouse product that included datamarts for various modules of different products like ITSM (remedy), ITBM, and BPPM on which reports are generated.
  • Empowered the product users to see the trends and figures of IT infrastructure performance and make better decisions. Completed ETL deployments from development to test and test to the production environment.
  • Developed ETL flow in SQL Server and BODS. Owned one module and acted as the point-of-contact for all ETL related tasks. Performed ETL unit and integration testing.
Technologies: SQL Server 2008 R2, SAP BusinessObjects Data Service (BODS), ETL, SQL, Microsoft SQL Server

ETL Developer

2009 - 2012
Tieto
  • Developed an enterprise-level data warehouse for a retailer company that contains financial and HR data, which was further used for analysis and reporting.
  • Extracted data from SAP extractors using the business content integration method. Developed an ETL flow in Informatica using pushdown, optimization, and teradata parallel transport operators. Acted as the point-of-contact for all ETL-related tasks.
  • Supported the Informatica environment by overseeing administration tasks.
Technologies: Scrum, Agile, Unix, Teradata Databases, Informatica ETL, ETL, SQL

Experience

Sales Analytics

Address the sales analysts' pains and reduce repetitive, manual tasks such as extracting and manipulating data in Excel. This sales analytics solution is a centralized data warehouse for all markets, which enables sales professionals to focus on achieving their monthly targets without worrying about data preparation. It also provides insights on sales trends to identify the focus areas and a reliable set of data enabling better decisions and strategic goal setting.

Education

2004 - 2008

Bachelor's Degree in Computer Science

University of Rajasthan - Jaipur, India

Certifications

MAY 2020 - MAY 2021

Certified SAFe 4 Agilist

Scaled Agile

JANUARY 2020 - PRESENT

Microsoft Data Engineer Associate

Microsoft

Skills

Tools

Synapse, Microsoft Power BI, Slack, Azure IoT Hub, Informatica ETL, Microsoft Dynamics, Microsoft Power Apps

Languages

SQL, Python 3, Python, Snowflake

Paradigms

Agile Software Development, ETL, Agile, Scrum, Azure DevOps

Platforms

Microsoft BI Stack, Windows, Databricks, Azure Event Hubs, Unix

Storage

Azure SQL, SQL Server Integration Services (SSIS), Azure SQL Databases, SQL Server Reporting Services (SSRS), Microsoft SQL Server, SQL Server 2017, Teradata, SQL Server 2012, SQL Server 2014, MongoDB, SQL Server 2008 R2, Teradata Databases

Frameworks

Scaled Agile Framework (SAFe)

Other

Data Warehouse Design, Analytics, MCSE | Business Intelligence, Azure Data Factory (ADF), Data Visualization, Azure Data Lake, Data Analytics, Data Engineering, Data Modeling, BI Reporting, Data Migration, Computer Engineering, Dashboards, Data Analysis, Data Architecture, SAP, Microsoft Azure, SAP BusinessObjects Data Service (BODS)

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring