Anurag Pandey

- Design and implement highly scalable and available Big Data solutions using AWS services including S3, Redshift, Athena, Glue, Lake formation and Lambda.

- Develop and deploy ETL pipelines using Spark, and other Big Data tools to extract, transform and load data into data lake.

- Create and maintain data models and schemas using tools like Glue and Athena to enable self-service data access for business users.

- Collaborate with cross-functional teams including Data Scientists, Data Analysts, and Business stakeholders to understand their requirements and provide solutions.

- Designed and implemented an end-to-end Data solution using Azure services including ADF, SSIS, Azure Data Lake Storage, and Azure Databricks.

- Built and deployed ETL pipelines using Spark and Hive to ingest, process, and transform data from various sources into the data lake.

- Developed data models and schemas using Azure Data Lake Analytics and Power BI to enable self-service data access for business users.

- Collaborated with cross-functional teams including Data Scientists, Data Analysts, and Business stakeholders to understand their requirements and provide solutions.

- Developed complex ETL processes using SSIS to extract, transform and load data from various sources like flat files, API, SAP, Excel spreadsheets, and databases.

- Designed and implemented efficient data models using SQL Server Analysis Services (SSAS) to provide business intelligence solutions for financial reporting and analysis.

- Developed custom reports using SQL Server Reporting Services (SSRS) and Power BI for management to track key performance indicators and monitor business trends.

- Creating reports and dashboards for the client

- Participating in the data migrations team and assisting in the transition from SQL Server to SAP B4 HANA.

• Assessed platform statistics to create customized, data-intensive BI analytics.
• Wrote and optimized SQL statements to assist business intelligence practices.
• Compiled, maintained and developed database systems for tracking tailored content reports.
• Monitored assessment software for performance, security and database availability throughout lifecycle.

• Conducted tests to identify issues and make necessary modifications.
• Implemented security measures to protect vital business data.
• Cultivated and maintained effective working relationships with other developers and members of finance department.
• Created and updated database designs and data models.