Summary
Overview
Work History
Education
Accomplishments
Skills
Work Preference
Timeline
Generic
Satyendra Maurya

Satyendra Maurya

Azure Data Architect
Greater Noida,UP

Summary

Senior/Lead Analyst/developer with almost 15+ years of experience in Information Technology specializing in Information/Data Management including Architecture, Data Warehousing, Business Intelligence (BI), Data Quality and Governance. Successfully implemented many large-scale Data Warehouses, Business Intelligence and Meta Data solutions. Very sound in handling financial data, across multiple business verticals including healthcare, banking, finance, retail, and real estate. Microsoft certified developer – Certification in Implementing data warehouse using SQL Server 2019 with Extensive knowledge in Data Warehouse Design, Development and Testing using Azure Data Factory, Synapse and SSIS. Experienced in developing different types of reports like Ad hoc reports, matrix reports, tabular reports and drill down reports using Power BI, Tableau, SSRS and Qlik. Worked on Azure Databricks, Hadoop platform. Implemented Error Handling Concepts, Testing, Debugging and Performance tuning of targets, sources, transformation logics, extensively used clear case and version control to promote the jobs. Coordinated small pieces of cloud adoption work with end-to-end development lifecycle to implement quality solution and moving the data to Snowflake Database.

Overview

18
18
years of professional experience

Work History

Lead Developer & Integrator

Dataminerz Innovative Solutions
11.2021 - Current
  • Worked with high-ranking executives to understand the metrics, gather business requirements
  • Demonstrating familiarity with standard business reporting processes and refining data needs in a changing environment to meet specific business objectives
  • Identified opportunity areas for growth and differentiation, by understanding the client's current capabilities
  • Performed Data mining/Data Analysis on data sources and assigned the quality level of data
  • Collaborated with assigned teammates to conduct research, analyze and deliver presentations on all Bank products and modeling topics to members
  • Worked with different BA’s/SMEs to analyze and create metrics
  • Experience with Snowflake Multi – Cluster warehouses, Virtual warehouse and building Snow pipe
  • Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL, and U-SQL Azure Data Lake Analytics
  • Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks
  • Created Pipelines in ADF using Linked Services/Datasets/Pipeline to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards
  • Developed Spark applications using PySpark and Spark-SQL for data extraction, transformation, and aggregation from multiple file formats for analyzing & transforming the data to uncover insights into the customer usage patterns
  • Designed and help determine the correct data model for each Project
  • Helped in developing/automation of metrics in Power BI.

Lead Data Warehouse Developer

Provana India
01.2020 - 12.2021
  • Worked with Business Users and Managers to understand the business needs and Design the Data Model to fulfill the needs
  • Provided the Optimal ETL Solution to extract and load the data from different source system to EDW
  • Established and enforce technical standards for deliverables of projects
  • Designed the High level ETL Dataflow
  • Designed the ETL Reference Pattern
  • Created the Technical Design Specification Document
  • Created Source to Target Mapping Document
  • Designed POC Mappings and helped the ETL team on data acquisition techniques and loading strategies during the development phase
  • Loaded data into Azure Data lake - connecting SSIS
  • Query optimization and SSIS Code optimization to improve the Load time
  • Testing and setting up the peer reviews for each of the modules to minimize the development errors
  • Creating the SQL server Agent jobs to run the ETL on daily basis
  • Creating Change Tickets to deploy the code into Production
  • Responsible for handling and fixing the issues in Stabilization period
  • Prepared the Support document and transitioned the project to the Support team.

Lead/Consultant

Datagrazp
Bangalore
06.2018 - 12.2019
  • Gathered requirements and did analysis to design a new ODS layer
  • Meticulously handled financial/investment data to move across multiple platforms
  • Directly managed a team of nine, including Business Analysts, was responsible for day-to-day task and resource management
  • Communicated project accomplishments and issues on a regular basis via written and verbal means to Senior Management, including the project sponsors
  • Worked closely with the development team, scrum master and business to deploy new releases each month and supported them
  • Hands - on experience in Azure Cloud Services (PaaS & IaaS), Azure Synapse Analytics, SQL Azure, Data Factory, Azure Analysis services, Application Insights, Azure Monitoring, Key Vault, Azure Data Lake
  • Very Good Experience in BI Development (SSRS, SSIS, SSAS)
  • Knowledge of Excel Macro
  • Fluent in SQL Coding using different software tools such as SQL Developer, TOAD and MS SQL Server Management Studio 2008/2008 R2/2012
  • Well versed in using Data Services Designer to ETL from multiple sources including Flat Files, Excel workbooks, XML; SAP ECC and third-party tools through Data Store setup and custom transfer program
  • Well versed in using Performance Tuning techniques to improve Throughput of data
  • Fluent in utilizing Data Integrator and Platform transforms, Variables and functions
  • Created SSIS jobs to export and import data from Text files, CSV files and Excel Spreadsheets
  • Worked SCDs to populate Type I and Type II slowly changing dimension tables from several operational source files
  • Successfully implemented pipeline and partitioning parallelism techniques and ensured load balancing of data
  • Create a business-driven approach to feeding data downstream.

Principal Lead Business Analyst

Infomerica, IMS Quintiles
Bangalore
09.2017 - 05.2018
  • Responsible for interaction with business stakeholders, gathering requirements and managing the delivery
  • Connected Tableau server to publish dashboard to a central location for portal integration
  • Experience in debugging execution errors using Data Services logs (trace, statistics, and error)
  • Turning jobs for high volume and complex transformation scenarios
  • Configuring DS components including job servers and repositories
  • Responsible for PL - SQL, SQL, T-SQL queries, procedures, triggers, cursors and functions
  • Performing design of SSIS packages and SSRS reports for IVR applications
  • Helping with ongoing projects development & execution
  • Managing huge database pertaining to IVR system for CDR & call events
  • SSIS: - Installation, Package Configuration, Development & Deployment
  • SSRS: - Installation, Reporting Services Configuration, RDL Development & Deployment
  • Provide support to the design as well as development team in ongoing projects
  • Developing T-SQL queries, trigger, functions, cursors and stored procedures
  • Create views to restrict access to data in a table for security
  • Created ETL packages using Heterogeneous data sources (SQL Server, Flat Files, Excel source files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS
  • Designed and optimized all the SSIS packages
  • Identified and defined the Datasets for report generation and included report parameters
  • Used Active Batch job scheduler to automate jobs in both Dev and Prod environments.

Lead Business Analyst

Optum, United HealthGroup
Gurgaon
07.2011 - 09.2017
  • Worked with various data sources, including SQL Server, Oracle, Azure Blob Storage, Azure SQL Database, Data Lakes, and flat files (CSV, JSON, Parquet)
  • Developed ETL solutions to extract data from heterogeneous data sources, transform it to meet business needs, and load it into data warehouses or other destination systems
  • Optimized SSIS packages for high-performance data extraction, transformation, and loading, reducing execution time for large-scale data loads
  • Conducted performance tuning for Azure Data Factory pipelines, ensuring cost-effective and efficient data processing
  • Performed debugging and error handling in both SSIS and ADF environments, addressing issues like data integrity, performance bottlenecks, and pipeline failures
  • Used SQL Server Profiler and ADF Monitoring for identifying and resolving performance issues in data flows
  • Utilized Azure Data Lake Storage (ADLS) and Blob Storage for handling large datasets, ensuring efficient data loading and retrieval
  • Implemented Azure Blob Storage as both source and destination in ADF pipelines, optimizing data transfer and storage solutions
  • Applied data validation and data quality checks to ensure that data transformations were accurate and met business requirements
  • Designed, developed, and deployed ETL pipelines using Azure Data Factory (ADF) to orchestrate data movement and transformation across cloud and on-premises data sources
  • Configured ADF Data Flows for transforming large datasets using scalable data processing and transformation logic
  • Integrated Azure Blob Storage and Azure SQL Data Warehouse as source and destination systems in ADF pipelines
  • Used ADF Activities to perform tasks such as data movement, data transformation, and file handling
  • Automated ETL jobs through ADF Triggers and scheduled pipeline execution based on business requirements
  • Leveraged ADF Monitoring to track pipeline execution and handle failure notifications, logging, and debugging
  • Implemented business logic for data cleaning and data enrichment during the ETL process to ensure high-quality data.

Business Analyst

American Express
Gurgaon
02.2010 - 06.2011
  • Analysed customer spending patterns to identify trends and opportunities
  • Segmented transaction data to track high-value customers and spending behaviors
  • Created dashboards to monitor category-wise and region-wise spending trends
  • Developed automated MIS reports for business stakeholders
  • Ensured data accuracy and integrity while generating financial reports
  • Worked with large datasets from multiple sources to derive key insights
  • Provided actionable insights to optimize marketing and customer retention strategies
  • Collaborated with finance, risk, and marketing teams for data-driven decisions
  • Supported strategic planning by delivering key spending analytics reports.

Reporting Analyst

IBM Daksh
Gurgaon
07.2007 - 02.2010
  • Analyzed customer spending patterns to identify trends and opportunities
  • Analysed call centre operations data to track and report on key performance metrics (KPIs) like Average Handling Time (AHT), First Call Resolution (FCR), Service Level, Abandonment Rate, and Customer Satisfaction (CSAT)
  • Generated daily, weekly, and monthly reports to assess call centre performance and support decision-making by management
  • Utilized data visualization tools like Power BI and Excel to create interactive dashboards and reports for real-time monitoring of call centre metrics
  • Extracted call centre data from various sources such as CRM systems, IVR logs, and telephony platforms (e.g., Genesys, Avaya) to generate insightful reports
  • Integrated data from multiple sources (internal databases, cloud-based platforms, and external APIs) to provide a holistic view of call centre performance
  • Conducted trend analysis on call volumes, agent performance, and customer interaction patterns to identify areas for improvement and optimize staffing requirements
  • Created predictive models to forecast call volumes and staffing needs using historical data, helping in better resource allocation.

Education

Bachelor of Science - undefined

Certification in Advance Analytics and Business Optimization - undefined

IIT

Accomplishments

  • ETL Tools: Azure Data Factory, Synapse Pipelines, Azure Databricks SSIS, Alteryx etc
  • Business Intelligence: SSRS, Power BI, Tableau, Qlik etc
  • Business Analysis: Functional Requirements Gathering, User Interviews, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, Data Analysis, Requirements Analysis, Design, Data Modeling, analyzing data using HiveQL

Skills

SQL

Project management

Python

Technical analysis

Technical leadership

SQL integration

Project oversight

Technical consulting

Cloud-based storage

Data structures

Data analysis

Data cleaning

Data interpretation

Storytelling techniques

Interactive visualization

Dashboard design

User experience

Big data handling

Statistical modeling

Data warehousing

Agile methodology

Tableau software

Time series analysis

Data integration

Data visualization and presentations

Data formatting

Report preparation

Business management

Data exports

Data quality assurance processes

Analytical problem solving

Data mining

Microsoft Visio

Data modeling

ETL processes

Analytical thinking

MS Excel

Data collection

Tableau

Data validation

Reporting tools

Business intelligence tools

Database management

Relational databases

Statistical analysis

Google analytics

Trend analysis

Data integrity validation

Requirements definition

Data utilization

Work Preference

Work Type

Contract WorkGig WorkPart TimeFull Time

Location Preference

RemoteHybrid

Important To Me

Work-life balanceCompany CultureFlexible work hoursCareer advancementPersonal development programsHealthcare benefitsWork from home optionPaid time offTeam Building / Company RetreatsStock Options / Equity / Profit Sharing4-day work weekPaid sick leave401k match

Timeline

Lead Developer & Integrator

Dataminerz Innovative Solutions
11.2021 - Current

Lead Data Warehouse Developer

Provana India
01.2020 - 12.2021

Lead/Consultant

Datagrazp
06.2018 - 12.2019

Principal Lead Business Analyst

Infomerica, IMS Quintiles
09.2017 - 05.2018

Lead Business Analyst

Optum, United HealthGroup
07.2011 - 09.2017

Business Analyst

American Express
02.2010 - 06.2011

Reporting Analyst

IBM Daksh
07.2007 - 02.2010

Bachelor of Science - undefined

Certification in Advance Analytics and Business Optimization - undefined

IIT

Similar Profiles

CREATE PROFILE
Satyendra MauryaAzure Data Architect