Chetan Pandey

• Developed, implemented and maintained data analytics protocols, standards and documentation.
• Build multiple Data Lakes. Build how the data will be received, validated, transformed and then published .
• Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, Azure DataBricks ,SQL Database and SQL datawarehouse environment .
• Design & implement migration strategies for traditional systems on Azure (Lift and shift/Azure Migrate, other third- party tools) worked on Azure suite: Azure SQL Database, Azure Data Lake(ADLS), Azure Data Factory(ADF) V2, Azure SQL Data Warehouse, Azure Service Bus, Azure key Vault, Azure Analysis Service(AAS), Azure Blob Storage, Azure Search, Azure App Service, Azure data Platform Services .
• Design and implement end-to-end data solutions (storage, integration, processing, visualization) in Azure .
• Led onsite and offshore development team for huge data integration and migration projects.
• Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.
• Performed large-scale data conversions for integration into [Product or Service].
• Used Azure DataBricks, Azure Data Factories, Azure Delta Lake, SQL DWH, Synapse to design and update databases.
• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Designed and implemented effective database solutions and models to store and retrieve data.
• Monitored incoming data analytics requests and distributed results to support [Type] strategies.
• Designed and developed analytical data structures.
• Prepared written summaries to accompany results and maintain documentation.
• Employed data cleansing methods, significantly Enhanced data quality.
• Compiled, cleaned and manipulated data for proper handling.
• Tested and validated models for accuracy of predictions in outcomes of interest.

• Follow the Agile methodology for all project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.
• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Extract Transform Load(ETL) development Using SQL server 2008R2,SQL 2008
  Integration Services(SSIS)
• Extensively worked on Stored Procedures, Functions in T-SQL.
• Generated several drill down and drill through reports using SSRS.
• Designed and maintain Payment files, Credit worklists, Credit productivity, Cash vs Released and P-Value Ageing ,Billing report on daily, weekly and monthly billing cycle.
• Using Joins and sub-queries for complex queries involving multiple tables from different databases.
• Working on the ETL documentation for the packages.
• Assist Business analysts in developing, maintaining and supporting operational reports,dashboards, and scorecards using Microsoft Power BI.
• Optimize all Reports, Package.
• Create dashboards, volume reports, operating summaries, and presentations and graphs.
• Automate Daily, Weekly and Monthly Scheduled Job.
• Collecting Information from On-Shore Clients and understanding the requirements and updating the Team regarding that and delivering the task on time to our Clients.

• Provide database coding to support business applications using T-SQL.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and

• Plan, design, and implement application database code objects, such as stored procedures and views.
• Supported development of T-SQL database for new product launch.
• Monitored and provided front-line support of daily processes.
• SQL Server jobs monitoring, Job failures and root cause analysis.
• Backup and restoration of the Databases.
• Creation of stored procedures in MS SQL Server 2000/2005/2008.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (MSSQL), Excel Spreadsheet to SQL Server 2005/2008/2012.